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
16080000385438L16/scrutins1616080000385335160800003854371PA719874PM796674PSE
16080000385587L16/scrutins1616080000385486160800003855861PA719874PM796674PSE
16080000385731L16/scrutins1616080000385633160800003857301PA719874PM796674PSE
16080000385880L16/scrutins1616080000385776160800003858791PA719874PM796674PSE
16080000386025L16/scrutins1616080000385927160800003860241PA719874PM796674PSE
16080000386157L16/scrutins1616080000386061160800003861561PA719874PM796674PSE
16080000386193L16/scrutins1616080000386191160800003861921PA721908PM797568PSE
16080000386461L16/scrutins1616080000386367160800003864601PA719874PM796674PSE
16080000386590L16/scrutins1616080000386495160800003865891PA719874PM796674PSE
16080000386710L16/scrutins1616080000386624160800003867091PA719874PM796674PSE
16080000386979L16/scrutins1616080000386744160800003869781PA609590PM797742PSE
16080000387115L16/scrutins1616080000387024160800003871141PA720286PM796878PSE
16080000387306L16/scrutins1616080000387215160800003873051PA720286PM796878PSE
16080000387495L16/scrutins1616080000387401160800003874941PA720286PM796878PSE
16080000387690L16/scrutins1616080000387595160800003876891PA720286PM796878PSE
16080000387859L16/scrutins1616080000387782160800003878581PA720286PM796878PSE
16080000387989L16/scrutins1616080000387914160800003879881PA720286PM796878PSE
16080000388081L16/scrutins1616080000388079160800003880801PA721908PM797568PSE
16080000388323L16/scrutins1616080000388253160800003883221PA720286PM796878PSE
16080000388469L16/scrutins1616080000388398160800003884681PA720286PM796878PSE
16080000388616L16/scrutins1616080000388544160800003886151PA720286PM796878PSE
16080000388755L16/scrutins1616080000388685160800003887541PA720286PM796878PSE
16080000388895L16/scrutins1616080000388826160800003888941PA720286PM796878PSE
16080000389020L16/scrutins1616080000388970160800003890191PA720286PM796878PSE
16080000389139L16/scrutins1616080000389090160800003891381PA720286PM796878PSE
16080000389265L16/scrutins1616080000389212160800003892641PA720286PM796878PSE
16080000389389L16/scrutins1616080000389339160800003893881PA720286PM796878PSE
16080000389501L16/scrutins1616080000389453160800003895001PA720286PM796878PSE
16080000389903L16/scrutins1616080000389578160800003899021PA719874PM796674PSE
16080000390041L16/scrutins1616080000390039160800003900401PA721908PM797568PSE
16080000390269L16/scrutins1616080000390217160800003902681PA720286PM796878PSE
16080000390384L16/scrutins1616080000390336160800003903831PA720286PM796878PSE
16080000390498L16/scrutins1616080000390466160800003904971PA720286PM796878PSE
16080000391320L16/scrutins1616080000391129160800003913191PA719874PM796674PSE
16080000391517L16/scrutins1616080000391380160800003915161PA719874PM796674PSE
16080000391736L16/scrutins1616080000391586160800003917351PA719874PM796674PSE
16080000391892L16/scrutins1616080000391816160800003918911PA719874PM796674PSE
16080000391992L16/scrutins1616080000391928160800003919911PA720908PM797556PSE
16080000392092L16/scrutins1616080000392009160800003920911PA720908PM797556PSE
16080000392111L16/scrutins1616080000392109160800003921101PA721908PM797568PSE
16080000392287L16/scrutins1616080000392285160800003922861PA721908PM797568PSE
16080000392375L16/scrutins1616080000392373160800003923741PA721908PM797568PSE
16080000392498L16/scrutins1616080000392496160800003924971PA721908PM797568PSE
16080000393702L16/scrutins1616080000393636160800003937011PA720468PM796983PSE
16080000393847L16/scrutins1616080000393845160800003938461PA721908PM797568PAN
16080000393946L16/scrutins1616080000393845160800003939451PA720908PM797556PSE
16080000394073L16/scrutins1616080000393975160800003940721PA720908PM797556PSE
16080000394202L16/scrutins1616080000394092160800003942011PA720908PM797556PSE
16080000394342L16/scrutins1616080000394221160800003943411PA720908PM797556PSE
16080000394403L16/scrutins1616080000394364160800003944021PA720286PM796878PSE