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
15080000304664L15/scrutins1515080000304568150800003046631PA720746PM723064PSE
15080000304703L15/scrutins1515080000304701150800003047021PA332747PM722798PAN
15080000304704L15/scrutins1515080000304701150800003047022PA720622PM723018PSE
15080000304771L15/scrutins1515080000304769150800003047701PA606171PM722632PAN
15080000304921L15/scrutins1515080000304919150800003049201PA606171PM722632PAN
15080000305069L15/scrutins1515080000305067150800003050681PA606171PM722632PAN
15080000305202L15/scrutins1515080000305200150800003052011PA606171PM722632PAN
15080000305321L15/scrutins1515080000305319150800003053201PA606171PM722632PAN
15080000305322L15/scrutins1515080000305319150800003053202PA721824PM723394PSE
15080000305441L15/scrutins1515080000305439150800003054401PA606171PM722632PAN
15080000305562L15/scrutins1515080000305560150800003055611PA606171PM722632PAN
15080000305631L15/scrutins1515080000305560150800003056301PA1874PM722598PSE
15080000305678L15/scrutins1515080000305676150800003056771PA606171PM722632PAN
15080000305747L15/scrutins1515080000305676150800003057461PA1874PM722598PSE
15080000305792L15/scrutins1515080000305790150800003057911PA606171PM722632PAN
15080000305848L15/scrutins1515080000305790150800003058471PA605991PM722660PSE
15080000305889L15/scrutins1515080000305887150800003058881PA606171PM722632PAN
15080000305940L15/scrutins1515080000305887150800003059391PA605991PM722660PSE
15080000305978L15/scrutins1515080000305976150800003059771PA332747PM722798PAN
15080000305979L15/scrutins1515080000305976150800003059772PA720622PM723018PSE
15080000306051L15/scrutins1515080000306049150800003060501PA606171PM722632PAN
15080000306114L15/scrutins1515080000306049150800003061131PA605991PM722660PSE
15080000306156L15/scrutins1515080000306154150800003061551PA606171PM722632PAN
15080000306213L15/scrutins1515080000306154150800003062121PA605991PM722660PSE
15080000306257L15/scrutins1515080000306255150800003062561PA606171PM722632PAN
15080000306318L15/scrutins1515080000306255150800003063171PA605991PM722660PSE
15080000306362L15/scrutins1515080000306360150800003063611PA606171PM722632PAN
15080000306431L15/scrutins1515080000306360150800003064301PA1874PM722598PSE
15080000306498L15/scrutins1515080000306496150800003064971PA606171PM722632PAN
15080000306583L15/scrutins1515080000306496150800003065821PA1874PM722598PSE
15080000306649L15/scrutins1515080000306647150800003066481PA606171PM722632PAN
15080000306740L15/scrutins1515080000306647150800003067391PA1874PM722598PSE
15080000306808L15/scrutins1515080000306806150800003068071PA606171PM722632PAN
15080000306891L15/scrutins1515080000306806150800003068901PA1874PM722598PSE
15080000306956L15/scrutins1515080000306954150800003069551PA606171PM722632PAN
15080000307034L15/scrutins1515080000306954150800003070331PA1874PM722598PSE
15080000307085L15/scrutins1515080000307083150800003070841PA606171PM722632PSE
15080000307603L15/scrutins1515080000307601150800003076021PA606171PM722632PAN
15080000307761L15/scrutins1515080000307759150800003077601PA332747PM722798PAN
15080000307762L15/scrutins1515080000307759150800003077602PA721824PM723394PSE
15080000307862L15/scrutins1515080000307860150800003078611PA606171PM722632PAN
15080000308004L15/scrutins1515080000308002150800003080031PA606171PM722632PAN
15080000308162L15/scrutins1515080000308160150800003081611PA606171PM722632PAN
15080000308323L15/scrutins1515080000308321150800003083221PA606171PM722632PAN
15080000308483L15/scrutins1515080000308481150800003084821PA606171PM722632PAN
15080000308635L15/scrutins1515080000308633150800003086341PA606171PM722632PAN
15080000308704L15/scrutins1515080000308633150800003087031PA1874PM722598PSE
15080000308764L15/scrutins1515080000308762150800003087631PA606171PM722632PAN
15080000308874L15/scrutins1515080000308762150800003088731PA1874PM722598PSE
15080000308955L15/scrutins1515080000308953150800003089541PA606171PM722632PAN