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
16080000578638L16/scrutins1616080000578489160800005786371PA720908PM797556PSE
16080000578761L16/scrutins1616080000578673160800005787601PA720468PM796983PSE
16080000579043L16/scrutins1616080000578957160800005790421PA720468PM796983PSE
16080000579318L16/scrutins1616080000579231160800005793171PA720468PM796983PSE
16080000579584L16/scrutins1616080000579507160800005795831PA720468PM796983PSE
16080000579821L16/scrutins1616080000579729160800005798201PA794354PM796869PSE
16080000580261L16/scrutins1616080000580018160800005802601PA719874PM796674PSE
16080000580993L16/scrutins1616080000580865160800005809921PA719874PM796674PSE
16080000581201L16/scrutins1616080000581052160800005812001PA719874PM796674PSE
16080000581409L16/scrutins1616080000581245160800005814081PA719874PM796674PSE
16080000581630L16/scrutins1616080000581457160800005816291PA719874PM796674PSE
16080000581836L16/scrutins1616080000581688160800005818351PA719874PM796674PSE
16080000582038L16/scrutins1616080000581891160800005820371PA719874PM796674PSE
16080000582210L16/scrutins1616080000582094160800005822091PA719874PM796674PSE
16080000582372L16/scrutins1616080000582254160800005823711PA719874PM796674PSE
16080000582505L16/scrutins1616080000582419160800005825041PA794354PM796869PSE
16080000582814L16/scrutins1616080000582696160800005828131PA719874PM796674PSE
16080000582960L16/scrutins1616080000582853160800005829591PA719874PM796674PSE
16080000583106L16/scrutins1616080000583009160800005831051PA719874PM796674PSE
16080000583258L16/scrutins1616080000583156160800005832571PA719874PM796674PSE
16080000583391L16/scrutins1616080000583305160800005833901PA719874PM796674PSE
16080000583536L16/scrutins1616080000583435160800005835351PA719874PM796674PSE
16080000583765L16/scrutins1616080000583580160800005837641PA609590PM797742PSE
16080000583989L16/scrutins1616080000583805160800005839881PA609590PM797742PSE
16080000584197L16/scrutins1616080000584025160800005841961PA609590PM797742PSE
16080000584383L16/scrutins1616080000584231160800005843821PA609590PM797742PSE
16080000584510L16/scrutins1616080000584417160800005845091PA794354PM796869PSE
16080000584876L16/scrutins1616080000584723160800005848751PA609590PM797742PSE
16080000585055L16/scrutins1616080000584907160800005850541PA609590PM797742PSE
16080000585206L16/scrutins1616080000585083160800005852051PA609590PM797742PSE
16080000585357L16/scrutins1616080000585236160800005853561PA609590PM797742PSE
16080000585506L16/scrutins1616080000585385160800005855051PA609590PM797742PSE
16080000585607L16/scrutins1616080000585530160800005856061PA720286PM796878PSE
16080000585766L16/scrutins1616080000585688160800005857651PA720286PM796878PSE
16080000585906L16/scrutins1616080000585829160800005859051PA720286PM796878PSE
16080000586063L16/scrutins1616080000585987160800005860621PA720286PM796878PSE
16080000586217L16/scrutins1616080000586139160800005862161PA720286PM796878PSE
16080000586499L16/scrutins1616080000586292160800005864981PA720286PM796878PSE
16080000586962L16/scrutins1616080000586716160800005869611PA720908PM797556PSE
16080000587095L16/scrutins1616080000587018160800005870941PA720286PM796878PSE
16080000587252L16/scrutins1616080000587173160800005872511PA720286PM796878PSE
16080000587407L16/scrutins1616080000587327160800005874061PA720286PM796878PSE
16080000587537L16/scrutins1616080000587483160800005875361PA720286PM796878PSE
16080000587639L16/scrutins1616080000587587160800005876381PA720286PM796878PSE
16080000587734L16/scrutins1616080000587679160800005877331PA720286PM796878PSE
16080000587854L16/scrutins1616080000587801160800005878531PA720286PM796878PSE
16080000587977L16/scrutins1616080000587921160800005879761PA720286PM796878PSE
16080000588086L16/scrutins1616080000588045160800005880851PA720286PM796878PSE
16080000588176L16/scrutins1616080000588137160800005881751PA720286PM796878PSE
16080000588478L16/scrutins1616080000588221160800005884771PA720908PM797556PSE