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
16080000505600L16/scrutins1616080000505598160800005055991PA721908PM797568PSE
16080000505672L16/scrutins1616080000505670160800005056711PA721908PM797568PSE
16080000505746L16/scrutins1616080000505744160800005057451PA721908PM797568PSE
16080000505818L16/scrutins1616080000505816160800005058171PA721908PM797568PSE
16080000505894L16/scrutins1616080000505892160800005058931PA721908PM797568PSE
16080000505968L16/scrutins1616080000505966160800005059671PA721908PM797568PSE
16080000506043L16/scrutins1616080000506041160800005060421PA721908PM797568PSE
16080000506116L16/scrutins1616080000506114160800005061151PA721908PM797568PSE
16080000506188L16/scrutins1616080000506186160800005061871PA721908PM797568PSE
16080000506265L16/scrutins1616080000506263160800005062641PA721908PM797568PSE
16080000506387L16/scrutins1616080000506340160800005063861PA794354PM796869PSE
16080000506480L16/scrutins1616080000506478160800005064791PA721908PM797568PSE
16080000506558L16/scrutins1616080000506556160800005065571PA721908PM797568PSE
16080000506633L16/scrutins1616080000506631160800005066321PA721908PM797568PSE
16080000506708L16/scrutins1616080000506706160800005067071PA721908PM797568PSE
16080000506846L16/scrutins1616080000506844160800005068451PA721908PM797568PSE
16080000506983L16/scrutins1616080000506981160800005069821PA721908PM797568PSE
16080000507694L16/scrutins1616080000507692160800005076931PA721908PM797568PSE
16080000507795L16/scrutins1616080000507793160800005077941PA721908PM797568PSE
16080000507987L16/scrutins1616080000507985160800005079861PA721908PM797568PSE
16080000508220L16/scrutins1616080000508159160800005082191PA720286PM796878PSE
16080000508241L16/scrutins1616080000508239160800005082401PA721908PM797568PSE
16080000508446L16/scrutins1616080000508387160800005084451PA794354PM796869PSE
16080000508645L16/scrutins1616080000508619160800005086441PA794354PM796869PSE
16080000508764L16/scrutins1616080000508733160800005087631PA794354PM796869PSE
16080000508893L16/scrutins1616080000508848160800005088921PA794354PM796869PSE
16080000509253L16/scrutins1616080000509214160800005092521PA794354PM796869PSE
16080000509387L16/scrutins1616080000509342160800005093861PA794354PM796869PSE
16080000509569L16/scrutins1616080000509521160800005095681PA794354PM796869PSE
16080000509734L16/scrutins1616080000509687160800005097331PA794354PM796869PSE
16080000509945L16/scrutins1616080000509854160800005099441PA720286PM796878PSE
16080000510044L16/scrutins1616080000509996160800005100431PA794354PM796869PSE
16080000510213L16/scrutins1616080000510165160800005102121PA794354PM796869PSE
16080000510383L16/scrutins1616080000510335160800005103821PA794354PM796869PSE
16080000510509L16/scrutins1616080000510507160800005105081PA721908PM797568PSE
16080000510710L16/scrutins1616080000510708160800005107091PA721908PM797568PSE
16080000510913L16/scrutins1616080000510911160800005109121PA721908PM797568PSE
16080000511085L16/scrutins1616080000511083160800005110841PA721908PM797568PSE
16080000511237L16/scrutins1616080000511235160800005112361PA721908PM797568PSE
16080000511391L16/scrutins1616080000511389160800005113901PA721908PM797568PSE
16080000511549L16/scrutins1616080000511547160800005115481PA721908PM797568PSE
16080000511788L16/scrutins1616080000511689160800005117871PA720286PM796878PSE
16080000512445L16/scrutins1616080000512370160800005124441PA719874PM796674PSE
16080000512565L16/scrutins1616080000512484160800005125641PA719874PM796674PSE
16080000512653L16/scrutins1616080000512622160800005126521PA719874PM796674PSE
16080000512735L16/scrutins1616080000512688160800005127341PA719874PM796674PSE
16080000512841L16/scrutins1616080000512783160800005128401PA719874PM796674PSE
16080000512943L16/scrutins1616080000512886160800005129421PA719874PM796674PSE
16080000513046L16/scrutins1616080000512990160800005130451PA719874PM796674PSE
16080000513398L16/scrutins1616080000513089160800005133971PA720908PM797556PSE