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
16080000439280L16/scrutins1616080000439259160800004392791PA794354PM796869PSE
16080000439372L16/scrutins1616080000439353160800004393711PA794354PM796869PSE
16080000439586L16/scrutins1616080000439459160800004395851PA720468PM796983PSE
16080000440014L16/scrutins1616080000439857160800004400131PA720286PM796878PSE
16080000440223L16/scrutins1616080000440202160800004402221PA794354PM796869PSE
16080000440326L16/scrutins1616080000440304160800004403251PA794354PM796869PSE
16080000440427L16/scrutins1616080000440403160800004404261PA794354PM796869PSE
16080000440524L16/scrutins1616080000440500160800004405231PA794354PM796869PSE
16080000440620L16/scrutins1616080000440594160800004406191PA794354PM796869PSE
16080000440717L16/scrutins1616080000440693160800004407161PA794354PM796869PSE
16080000440823L16/scrutins1616080000440797160800004408221PA794354PM796869PSE
16080000440926L16/scrutins1616080000440901160800004409251PA794354PM796869PSE
16080000441025L16/scrutins1616080000440988160800004410241PA794354PM796869PSE
16080000441159L16/scrutins1616080000441147160800004411581PA794354PM796869PSE
16080000441296L16/scrutins1616080000441201160800004412951PA720286PM796878PSE
16080000441384L16/scrutins1616080000441371160800004413831PA794354PM796869PSE
16080000441452L16/scrutins1616080000441429160800004414511PA794354PM796869PSE
16080000441537L16/scrutins1616080000441509160800004415361PA794354PM796869PSE
16080000441634L16/scrutins1616080000441611160800004416331PA794354PM796869PSE
16080000441760L16/scrutins1616080000441727160800004417591PA794354PM796869PSE
16080000441874L16/scrutins1616080000441856160800004418731PA794354PM796869PSE
16080000441914L16/scrutins1616080000441895160800004419131PA794354PM796869PSE
16080000441953L16/scrutins1616080000441932160800004419521PA794354PM796869PSE
16080000441995L16/scrutins1616080000441974160800004419941PA794354PM796869PSE
16080000442036L16/scrutins1616080000442016160800004420351PA794354PM796869PSE
16080000442164L16/scrutins1616080000442054160800004421631PA720286PM796878PSE
16080000442232L16/scrutins1616080000442211160800004422311PA794354PM796869PSE
16080000442275L16/scrutins1616080000442254160800004422741PA794354PM796869PSE
16080000442316L16/scrutins1616080000442296160800004423151PA794354PM796869PSE
16080000442364L16/scrutins1616080000442343160800004423631PA794354PM796869PSE
16080000442432L16/scrutins1616080000442387160800004424311PA794354PM796869PSE
16080000442552L16/scrutins1616080000442505160800004425511PA794354PM796869PSE
16080000442662L16/scrutins1616080000442615160800004426611PA794354PM796869PSE
16080000442778L16/scrutins1616080000442731160800004427771PA794354PM796869PSE
16080000442870L16/scrutins1616080000442848160800004428691PA794354PM796869PSE
16080000442927L16/scrutins1616080000442907160800004429261PA794354PM796869PSE
16080000443080L16/scrutins1616080000442972160800004430791PA720286PM796878PSE
16080000443181L16/scrutins1616080000443161160800004431801PA794354PM796869PSE
16080000443244L16/scrutins1616080000443225160800004432431PA794354PM796869PSE
16080000443329L16/scrutins1616080000443289160800004433281PA720286PM796878PSE
16080000443400L16/scrutins1616080000443359160800004433991PA720286PM796878PSE
16080000443473L16/scrutins1616080000443429160800004434721PA720286PM796878PSE
16080000443553L16/scrutins1616080000443509160800004435521PA720286PM796878PSE
16080000443633L16/scrutins1616080000443589160800004436321PA720286PM796878PSE
16080000443710L16/scrutins1616080000443670160800004437091PA720286PM796878PSE
16080000443803L16/scrutins1616080000443747160800004438021PA720286PM796878PSE
16080000443902L16/scrutins1616080000443846160800004439011PA720286PM796878PSE
16080000444059L16/scrutins1616080000443944160800004440581PA720286PM796878PSE
16080000444225L16/scrutins1616080000444169160800004442241PA720286PM796878PSE
16080000444324L16/scrutins1616080000444269160800004443231PA720286PM796878PSE