AN · données ouvertes
Explorateur / scrutins

scrutins.scrutin_groupe_non_votants_votant

Chemin scrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 %

38 411 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7acteur_refVARCHARscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.acteurRef · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 %
8mandat_refVARCHARscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.mandatRef · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 %
9par_delegationBOOLEANscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.parDelegation · présence : L17 99 %
10num_placeVARCHARscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.numPlace · présence : L17 99 %
11cause_position_voteVARCHARscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.causePositionVote · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 % · XSD 2016 : Principalement utilisé dans le cas "nonVotant" pour pouvoir expliquer la raison 'réglementaire' de la position i.e. : Président de l'A.N., Président de la Séance, Nomination à un ministère, ou position personnelle 4 valeurs sont possibles PSE = Président de Séance PAN = Président de l'Assemblée nationale MG = Membre du Gouvernement PP = Position personnelle

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_refmandat_refpar_delegationnum_placecause_position_vote
16080000312275L16/scrutins1616080000312195160800003122741PA609590PM797742PSE
16080000312535L16/scrutins1616080000312291160800003125341PA609590PM797742PSE
16080000312719L16/scrutins1616080000312587160800003127181PA609590PM797742PSE
16080000312852L16/scrutins1616080000312754160800003128511PA609590PM797742PSE
16080000312978L16/scrutins1616080000312872160800003129771PA609590PM797742PSE
16080000313092L16/scrutins1616080000312993160800003130911PA609590PM797742PSE
16080000313209L16/scrutins1616080000313109160800003132081PA609590PM797742PSE
16080000313307L16/scrutins1616080000313224160800003133061PA609590PM797742PSE
16080000313402L16/scrutins1616080000313325160800003134011PA609590PM797742PSE
16080000313420L16/scrutins1616080000313418160800003134191PA721908PM797568PSE
16080000314188L16/scrutins1616080000313999160800003141871PA719874PM796674PSE
16080000314510L16/scrutins1616080000314253160800003145091PA719874PM796674PSE
16080000314742L16/scrutins1616080000314609160800003147411PA720908PM797556PSE
16080000315023L16/scrutins1616080000314760160800003150221PA719874PM796674PSE
16080000315401L16/scrutins1616080000315123160800003154001PA720908PM797556PSE
16080000315646L16/scrutins1616080000315450160800003156451PA720908PM797556PSE
16080000315765L16/scrutins1616080000315671160800003157641PA720908PM797556PSE
16080000315847L16/scrutins1616080000315781160800003158461PA720908PM797556PSE
16080000315931L16/scrutins1616080000315864160800003159301PA720908PM797556PSE
16080000315974L16/scrutins1616080000315948160800003159731PA720468PM796983PSE
16080000316088L16/scrutins1616080000316031160800003160871PA720468PM796983PSE
16080000316257L16/scrutins1616080000316199160800003162561PA720468PM796983PSE
16080000316417L16/scrutins1616080000316368160800003164161PA720468PM796983PSE
16080000316677L16/scrutins1616080000316500160800003166761PA720908PM797556PSE
16080000316973L16/scrutins1616080000316930160800003169721PA720468PM796983PSE
16080000317061L16/scrutins1616080000317022160800003170601PA720468PM796983PSE
16080000317159L16/scrutins1616080000317120160800003171581PA720468PM796983PSE
16080000317254L16/scrutins1616080000317215160800003172531PA720468PM796983PSE
16080000317344L16/scrutins1616080000317305160800003173431PA720468PM796983PSE
16080000317480L16/scrutins1616080000317396160800003174791PA719874PM796674PSE
16080000317608L16/scrutins1616080000317512160800003176071PA719874PM796674PSE
16080000317735L16/scrutins1616080000317644160800003177341PA719874PM796674PSE
16080000317851L16/scrutins1616080000317766160800003178501PA719874PM796674PSE
16080000318145L16/scrutins1616080000317886160800003181441PA720908PM797556PSE
16080000318280L16/scrutins1616080000318195160800003182791PA719874PM796674PSE
16080000318404L16/scrutins1616080000318309160800003184031PA719874PM796674PSE
16080000318542L16/scrutins1616080000318437160800003185411PA719874PM796674PSE
16080000318693L16/scrutins1616080000318578160800003186921PA719874PM796674PSE
16080000318871L16/scrutins1616080000318727160800003188701PA719874PM796674PSE
16080000319056L16/scrutins1616080000318913160800003190551PA719874PM796674PSE
16080000319240L16/scrutins1616080000319098160800003192391PA719874PM796674PSE
16080000319425L16/scrutins1616080000319281160800003194241PA719874PM796674PSE
16080000319609L16/scrutins1616080000319465160800003196081PA719874PM796674PSE
16080000319787L16/scrutins1616080000319646160800003197861PA719874PM796674PSE
16080000320024L16/scrutins1616080000319828160800003200231PA720908PM797556PSE
16080000320156L16/scrutins1616080000320060160800003201551PA720468PM796983PSE
16080000320449L16/scrutins1616080000320354160800003204481PA720468PM796983PSE
16080000320753L16/scrutins1616080000320654160800003207521PA720468PM796983PSE
16080000320997L16/scrutins1616080000320899160800003209961PA720468PM796983PSE
16080000321270L16/scrutins1616080000321169160800003212691PA720468PM796983PSE