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
16080000211744L16/scrutins1616080000211680160800002117431PA794354PM796869PSE
16080000211958L16/scrutins1616080000211884160800002119571PA794354PM796869PSE
16080000212162L16/scrutins1616080000212087160800002121611PA794354PM796869PSE
16080000212312L16/scrutins1616080000212272160800002123111PA794354PM796869PSE
16080000212404L16/scrutins1616080000212367160800002124031PA794354PM796869PSE
16080000212737L16/scrutins1616080000212461160800002127361PA719874PM796674PSE
16080000212890L16/scrutins1616080000212853160800002128891PA794354PM796869PSE
16080000212986L16/scrutins1616080000212945160800002129851PA794354PM796869PSE
16080000213087L16/scrutins1616080000213047160800002130861PA794354PM796869PSE
16080000213191L16/scrutins1616080000213148160800002131901PA794354PM796869PSE
16080000213296L16/scrutins1616080000213255160800002132951PA794354PM796869PSE
16080000213406L16/scrutins1616080000213355160800002134051PA720286PM796878PSE
16080000213481L16/scrutins1616080000213428160800002134801PA720286PM796878PSE
16080000213553L16/scrutins1616080000213495160800002135521PA720286PM796878PSE
16080000213636L16/scrutins1616080000213578160800002136351PA720286PM796878PSE
16080000213728L16/scrutins1616080000213669160800002137271PA720286PM796878PSE
16080000213928L16/scrutins1616080000213763160800002139271PA720286PM796878PSE
16080000214142L16/scrutins1616080000214067160800002141411PA720286PM796878PSE
16080000214278L16/scrutins1616080000214195160800002142771PA720286PM796878PSE
16080000214422L16/scrutins1616080000214338160800002144211PA720286PM796878PSE
16080000214564L16/scrutins1616080000214479160800002145631PA720286PM796878PSE
16080000214709L16/scrutins1616080000214624160800002147081PA720286PM796878PSE
16080000214854L16/scrutins1616080000214768160800002148531PA720286PM796878PSE
16080000214995L16/scrutins1616080000214908160800002149941PA720286PM796878PSE
16080000215141L16/scrutins1616080000215052160800002151401PA720286PM796878PSE
16080000215279L16/scrutins1616080000215196160800002152781PA720286PM796878PSE
16080000215410L16/scrutins1616080000215326160800002154091PA720286PM796878PSE
16080000215756L16/scrutins1616080000215454160800002157551PA720908PM797556PSE
16080000216004L16/scrutins1616080000215815160800002160031PA720286PM796878PSE
16080000216229L16/scrutins1616080000216144160800002162281PA720286PM796878PSE
16080000216353L16/scrutins1616080000216277160800002163521PA720286PM796878PSE
16080000216477L16/scrutins1616080000216399160800002164761PA720286PM796878PSE
16080000216597L16/scrutins1616080000216525160800002165961PA720286PM796878PSE
16080000216706L16/scrutins1616080000216640160800002167051PA720286PM796878PSE
16080000216789L16/scrutins1616080000216738160800002167881PA719874PM796674PSE
16080000216864L16/scrutins1616080000216815160800002168631PA719874PM796674PSE
16080000216934L16/scrutins1616080000216890160800002169331PA719874PM796674PSE
16080000216999L16/scrutins1616080000216954160800002169981PA719874PM796674PSE
16080000217064L16/scrutins1616080000217017160800002170631PA719874PM796674PSE
16080000217211L16/scrutins1616080000217085160800002172101PA720286PM796878PSE
16080000217374L16/scrutins1616080000217321160800002173731PA719874PM796674PSE
16080000217448L16/scrutins1616080000217396160800002174471PA719874PM796674PSE
16080000217576L16/scrutins1616080000217469160800002175751PA719874PM796674PSE
16080000217682L16/scrutins1616080000217629160800002176811PA719874PM796674PSE
16080000217750L16/scrutins1616080000217707160800002177491PA720286PM796878PSE
16080000217832L16/scrutins1616080000217785160800002178311PA720286PM796878PSE
16080000217907L16/scrutins1616080000217865160800002179061PA720286PM796878PSE
16080000217981L16/scrutins1616080000217938160800002179801PA720286PM796878PSE
16080000218065L16/scrutins1616080000218017160800002180641PA720286PM796878PSE
16080000218230L16/scrutins1616080000218107160800002182291PA720908PM797556PSE