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
16080000024842L16/scrutins1616080000024840160800000248411PA721908PM797568PSE
16080000025312L16/scrutins1616080000025310160800000253111PA721908PM797568PSE
16080000025778L16/scrutins1616080000025776160800000257771PA721908PM797568PSE
16080000026246L16/scrutins1616080000026244160800000262451PA721908PM797568PSE
16080000026939L16/scrutins1616080000026937160800000269381PA721908PM797568PSE
16080000027408L16/scrutins1616080000027406160800000274071PA721908PM797568PSE
16080000027881L16/scrutins1616080000027879160800000278801PA721908PM797568PSE
16080000028353L16/scrutins1616080000028351160800000283521PA721908PM797568PSE
16080000028822L16/scrutins1616080000028820160800000288211PA721908PM797568PSE
16080000029292L16/scrutins1616080000029290160800000292911PA721908PM797568PSE
16080000029762L16/scrutins1616080000029760160800000297611PA721908PM797568PSE
16080000030234L16/scrutins1616080000030232160800000302331PA721908PM797568PSE
16080000030705L16/scrutins1616080000030703160800000307041PA721908PM797568PSE
16080000031174L16/scrutins1616080000031172160800000311731PA721908PM797568PSE
16080000031819L16/scrutins1616080000031817160800000318181PA721908PM797568PSE
16080000032285L16/scrutins1616080000032283160800000322841PA721908PM797568PSE
16080000032754L16/scrutins1616080000032752160800000327531PA721908PM797568PSE
16080000033223L16/scrutins1616080000033221160800000332221PA721908PM797568PSE
16080000033693L16/scrutins1616080000033691160800000336921PA721908PM797568PSE
16080000034161L16/scrutins1616080000034159160800000341601PA721908PM797568PSE
16080000034630L16/scrutins1616080000034628160800000346291PA721908PM797568PSE
16080000035096L16/scrutins1616080000035094160800000350951PA721908PM797568PSE
16080000035560L16/scrutins1616080000035558160800000355591PA721908PM797568PSE
16080000036028L16/scrutins1616080000036026160800000360271PA721908PM797568PSE
16080000036731L16/scrutins1616080000036729160800000367301PA721908PM797568PSE
16080000037196L16/scrutins1616080000037194160800000371951PA721908PM797568PSE
16080000037661L16/scrutins1616080000037659160800000376601PA721908PM797568PSE
16080000038124L16/scrutins1616080000038122160800000381231PA721908PM797568PSE
16080000038594L16/scrutins1616080000038592160800000385931PA721908PM797568PSE
16080000039059L16/scrutins1616080000039057160800000390581PA721908PM797568PSE
16080000039528L16/scrutins1616080000039526160800000395271PA721908PM797568PSE
16080000039995L16/scrutins1616080000039993160800000399941PA721908PM797568PSE
16080000040462L16/scrutins1616080000040460160800000404611PA721908PM797568PSE
16080000040922L16/scrutins1616080000040920160800000409211PA721908PM797568PSE
16080000041557L16/scrutins1616080000041555160800000415561PA721908PM797568PSE
16080000042026L16/scrutins1616080000042024160800000420251PA721908PM797568PSE
16080000042493L16/scrutins1616080000042491160800000424921PA721908PM797568PSE
16080000042823L16/scrutins1616080000042821160800000428221PA721908PM797568PSE
16080000043241L16/scrutins1616080000043239160800000432401PA721908PM797568PSE
16080000043653L16/scrutins1616080000043651160800000436521PA721908PM797568PSE
16080000044076L16/scrutins1616080000044074160800000440751PA721908PM797568PSE
16080000044550L16/scrutins1616080000044548160800000445491PA721908PM797568PSE
16080000044805L16/scrutins1616080000044650160800000448041PA719874PM796674PSE
16080000044964L16/scrutins1616080000044859160800000449631PA719874PM796674PSE
16080000045237L16/scrutins1616080000045034160800000452361PA720286PM796878PSE
16080000045747L16/scrutins1616080000045674160800000457461PA719874PM796674PSE
16080000045876L16/scrutins1616080000045798160800000458751PA719874PM796674PSE
16080000046005L16/scrutins1616080000045928160800000460041PA719874PM796674PSE
16080000046146L16/scrutins1616080000046055160800000461451PA719874PM796674PSE
16080000046330L16/scrutins1616080000046196160800000463291PA719874PM796674PSE