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 323 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
17080000389245L17/scrutins1717080000388898170800003892432PA720908PM843701False221MG
17080000389264L17/scrutins1717080000388898170800003892631PA793210PM842417False454MG
17080000389389L17/scrutins1717080000389293170800003893881PA795950PM843419False259MG
17080000389390L17/scrutins1717080000389293170800003893882PA721908PM843467False402PAN
17080000389391L17/scrutins1717080000389293170800003893883PA795990PM856036False297MG
17080000389392L17/scrutins1717080000389293170800003893884PA795330PM843800False273MG
17080000389393L17/scrutins1717080000389293170800003893885PA795386PM843695False284MG
17080000389394L17/scrutins1717080000389293170800003893886PA721134PM843797False368MG
17080000389395L17/scrutins1717080000389293170800003893887PA720066PM842933False298MG
17080000389560L17/scrutins1717080000389293170800003895591PA1327PM842747False304MG
17080000389561L17/scrutins1717080000389293170800003895592PA842117PM843635False184MG
17080000389562L17/scrutins1717080000389293170800003895593PA870010PM870011False084MG
17080000389622L17/scrutins1717080000389293170800003896211PA719024PM842390False344PSE
17080000389623L17/scrutins1717080000389293170800003896212PA795120PM858429False360MG
17080000389644L17/scrutins1717080000389293170800003896431PA794426PM842993False215MG
17080000389645L17/scrutins1717080000389293170800003896432PA720908PM843701False221MG
17080000389664L17/scrutins1717080000389293170800003896631PA793210PM842417False454MG
17080000389791L17/scrutins1717080000389695170800003897901PA795950PM843419False259MG
17080000389792L17/scrutins1717080000389695170800003897902PA721908PM843467False402PAN
17080000389793L17/scrutins1717080000389695170800003897903PA795990PM856036False297MG
17080000389794L17/scrutins1717080000389695170800003897904PA795330PM843800False273MG
17080000389795L17/scrutins1717080000389695170800003897905PA795386PM843695False284MG
17080000389796L17/scrutins1717080000389695170800003897906PA721134PM843797False368MG
17080000389797L17/scrutins1717080000389695170800003897907PA720066PM842933False298MG
17080000389961L17/scrutins1717080000389695170800003899601PA1327PM842747False304MG
17080000389962L17/scrutins1717080000389695170800003899602PA842117PM843635False184MG
17080000389963L17/scrutins1717080000389695170800003899603PA870010PM870011False084MG
17080000390024L17/scrutins1717080000389695170800003900231PA719024PM842390False344PSE
17080000390025L17/scrutins1717080000389695170800003900232PA795120PM858429False360MG
17080000390046L17/scrutins1717080000389695170800003900451PA794426PM842993False215MG
17080000390047L17/scrutins1717080000389695170800003900452PA720908PM843701False221MG
17080000390066L17/scrutins1717080000389695170800003900651PA793210PM842417False454MG
17080000390192L17/scrutins1717080000390097170800003901911PA795950PM843419False259MG
17080000390193L17/scrutins1717080000390097170800003901912PA721908PM843467False402PAN
17080000390194L17/scrutins1717080000390097170800003901913PA795990PM856036False297MG
17080000390195L17/scrutins1717080000390097170800003901914PA795330PM843800False273MG
17080000390196L17/scrutins1717080000390097170800003901915PA795386PM843695False284MG
17080000390197L17/scrutins1717080000390097170800003901916PA721134PM843797False368MG
17080000390198L17/scrutins1717080000390097170800003901917PA720066PM842933False298MG
17080000390358L17/scrutins1717080000390097170800003903571PA1327PM842747False304MG
17080000390359L17/scrutins1717080000390097170800003903572PA842117PM843635False184MG
17080000390360L17/scrutins1717080000390097170800003903573PA870010PM870011False084MG
17080000390419L17/scrutins1717080000390097170800003904181PA719024PM842390False344PSE
17080000390420L17/scrutins1717080000390097170800003904182PA795120PM858429False360MG
17080000390440L17/scrutins1717080000390097170800003904391PA794426PM842993False215MG
17080000390441L17/scrutins1717080000390097170800003904392PA720908PM843701False221MG
17080000390460L17/scrutins1717080000390097170800003904591PA793210PM842417False454MG
17080000390585L17/scrutins1717080000390489170800003905841PA795950PM843419False259MG
17080000390586L17/scrutins1717080000390489170800003905842PA721908PM843467False402PAN
17080000390587L17/scrutins1717080000390489170800003905843PA795990PM856036False297MG