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 323 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
17080000104460L17/scrutins1717080000104413170800001044591PA795310PM840453False634PSE
17080000104618L17/scrutins1717080000104544170800001046171PA721908PM843467False402PAN
17080000104647L17/scrutins1717080000104544170800001046461PA795228PM840447False627PSE
17080000104726L17/scrutins1717080000104544170800001047251PA643089PM843431False206MG
17080000104761L17/scrutins1717080000104544170800001047601PA720480PM843101False245MG
17080000104847L17/scrutins1717080000104794170800001048461PA721908PM843467False402PSE
17080000104891L17/scrutins1717080000104794170800001048901PA643089PM843431FalseMG
17080000104909L17/scrutins1717080000104794170800001049081PA720480PM843101FalseMG
17080000104949L17/scrutins1717080000104925170800001049481PA721908PM843467False402PAN
17080000104972L17/scrutins1717080000104925170800001049711PA795310PM840453False634PSE
17080000105084L17/scrutins1717080000105054170800001050831PA721908PM843467False402PAN
17080000105233L17/scrutins1717080000105228170800001052321PA721908PM843467False402PAN
17080000105288L17/scrutins1717080000105282170800001052871PA721908PM843467False402PAN
17080000105350L17/scrutins1717080000105342170800001053491PA721908PM843467False402PAN
17080000105428L17/scrutins1717080000105420170800001054271PA721908PM843467False402PAN
17080000105484L17/scrutins1717080000105420170800001054831PA794022PM842777False509PSE
17080000105533L17/scrutins1717080000105523170800001055321PA721908PM843467False402PAN
17080000105597L17/scrutins1717080000105523170800001055961PA794022PM842777False509PSE
17080000105665L17/scrutins1717080000105654170800001056641PA721908PM843467False402PAN
17080000105734L17/scrutins1717080000105654170800001057331PA794022PM842777False509PSE
17080000105818L17/scrutins1717080000105788170800001058171PA721908PM843467False402PSE
17080000105940L17/scrutins1717080000105904170800001059391PA721908PM843467False402PSE
17080000106074L17/scrutins1717080000106029170800001060731PA721908PM843467False402PSE
17080000106156L17/scrutins1717080000106029170800001061551PA643089PM843431False206MG
17080000106186L17/scrutins1717080000106029170800001061851PA720480PM843101False245MG
17080000106244L17/scrutins1717080000106207170800001062431PA721908PM843467False402PSE
17080000106390L17/scrutins1717080000106329170800001063891PA795228PM840447False627PSE
17080000106506L17/scrutins1717080000106460170800001065051PA721908PM843467False402PAN
17080000106525L17/scrutins1717080000106460170800001065241PA795228PM840447False627PSE
17080000106679L17/scrutins1717080000106604170800001066781PA795228PM840447False627PSE
17080000106852L17/scrutins1717080000106764170800001068511PA795228PM840447False627PSE
17080000107045L17/scrutins1717080000106957170800001070441PA795228PM840447False627PSE
17080000107236L17/scrutins1717080000107148170800001072351PA795228PM840447False627PSE
17080000107432L17/scrutins1717080000107342170800001074311PA795228PM840447False627PSE
17080000107594L17/scrutins1717080000107541170800001075931PA721908PM843467False402PAN
17080000107615L17/scrutins1717080000107541170800001076141PA795228PM840447False627PSE
17080000107790L17/scrutins1717080000107713170800001077891PA795228PM840447False627PSE
17080000107931L17/scrutins1717080000107886170800001079301PA721908PM843467False402PSE
17080000108016L17/scrutins1717080000107886170800001080151PA643089PM843431False206MG
17080000108050L17/scrutins1717080000107886170800001080491PA720480PM843101False245MG
17080000108154L17/scrutins1717080000108072170800001081531PA795228PM840447False627PSE
17080000108334L17/scrutins1717080000108258170800001083331PA795228PM840447False627PSE
17080000108495L17/scrutins1717080000108438170800001084941PA795228PM840447False627PSE
17080000108639L17/scrutins1717080000108579170800001086381PA721908PM843467False402PAN
17080000108775L17/scrutins1717080000108579170800001087741PA330008PM842366False171PSE
17080000108995L17/scrutins1717080000108873170800001089941PA721908PM843467False402PAN
17080000109477L17/scrutins1717080000109428170800001094761PA721908PM843467False402PAN
17080000109545L17/scrutins1717080000109428170800001095441PA330008PM842366False171PSE
17080000109663L17/scrutins1717080000109603170800001096621PA721908PM843467False402PAN
17080000109729L17/scrutins1717080000109603170800001097281PA330008PM842366False171PSE