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
16080000513648L16/scrutins1616080000513459160800005136471PA720286PM796878PSE
16080000513947L16/scrutins1616080000513845160800005139461PA720286PM796878PSE
16080000514053L16/scrutins1616080000513997160800005140521PA719874PM796674PSE
16080000514129L16/scrutins1616080000514103160800005141281PA720468PM796983PSE
16080000514222L16/scrutins1616080000514193160800005142211PA720468PM796983PSE
16080000514315L16/scrutins1616080000514291160800005143141PA720468PM796983PSE
16080000514405L16/scrutins1616080000514381160800005144041PA720468PM796983PSE
16080000514496L16/scrutins1616080000514471160800005144951PA720468PM796983PSE
16080000514578L16/scrutins1616080000514557160800005145771PA720468PM796983PSE
16080000514663L16/scrutins1616080000514646160800005146621PA720468PM796983PSE
16080000514836L16/scrutins1616080000514815160800005148351PA720468PM796983PSE
16080000514977L16/scrutins1616080000514869160800005149761PA720286PM796878PSE
16080000515061L16/scrutins1616080000515036160800005150601PA720468PM796983PSE
16080000515138L16/scrutins1616080000515113160800005151371PA720468PM796983PSE
16080000515212L16/scrutins1616080000515189160800005152111PA720468PM796983PSE
16080000515278L16/scrutins1616080000515258160800005152771PA720468PM796983PSE
16080000515343L16/scrutins1616080000515322160800005153421PA720468PM796983PSE
16080000515388L16/scrutins1616080000515386160800005153871PA721908PM797568PSE
16080000515465L16/scrutins1616080000515463160800005154641PA721908PM797568PSE
16080000515538L16/scrutins1616080000515536160800005155371PA721908PM797568PSE
16080000515613L16/scrutins1616080000515611160800005156121PA721908PM797568PSE
16080000515684L16/scrutins1616080000515682160800005156831PA721908PM797568PSE
16080000515855L16/scrutins1616080000515753160800005158541PA720286PM796878PSE
16080000515916L16/scrutins1616080000515914160800005159151PA721908PM797568PSE
16080000516151L16/scrutins1616080000516149160800005161501PA721908PM797568PAN
16080000516276L16/scrutins1616080000516251160800005162751PA794354PM796869PSE
16080000516400L16/scrutins1616080000516369160800005163991PA794354PM796869PSE
16080000516541L16/scrutins1616080000516513160800005165401PA794354PM796869PSE
16080000516676L16/scrutins1616080000516642160800005166751PA794354PM796869PSE
16080000516817L16/scrutins1616080000516781160800005168161PA794354PM796869PSE
16080000516958L16/scrutins1616080000516956160800005169571PA721908PM797568PSE
16080000517125L16/scrutins1616080000517123160800005171241PA721908PM797568PSE
16080000517294L16/scrutins1616080000517292160800005172931PA721908PM797568PSE
16080000517550L16/scrutins1616080000517487160800005175491PA720286PM796878PSE
16080000517592L16/scrutins1616080000517590160800005175911PA721908PM797568PSE
16080000517783L16/scrutins1616080000517781160800005177821PA721908PM797568PSE
16080000517972L16/scrutins1616080000517970160800005179711PA721908PM797568PSE
16080000518158L16/scrutins1616080000518156160800005181571PA721908PM797568PSE
16080000518345L16/scrutins1616080000518343160800005183441PA721908PM797568PSE
16080000518593L16/scrutins1616080000518591160800005185921PA721908PM797568PSE
16080000518764L16/scrutins1616080000518762160800005187631PA721908PM797568PSE
16080000518929L16/scrutins1616080000518927160800005189281PA721908PM797568PSE
16080000519091L16/scrutins1616080000519089160800005190901PA721908PM797568PSE
16080000519253L16/scrutins1616080000519251160800005192521PA721908PM797568PSE
16080000519471L16/scrutins1616080000519386160800005194701PA720286PM796878PSE
16080000519522L16/scrutins1616080000519520160800005195211PA721908PM797568PSE
16080000519699L16/scrutins1616080000519697160800005196981PA721908PM797568PSE
16080000519881L16/scrutins1616080000519879160800005198801PA721908PM797568PSE
16080000520059L16/scrutins1616080000520057160800005200581PA721908PM797568PSE
16080000520239L16/scrutins1616080000520237160800005202381PA721908PM797568PSE