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
17080000406135L17/scrutins1717080000405865170800004061332PA720908PM843701False221MG
17080000406150L17/scrutins1717080000405865170800004061491PA793210PM842417False454MG
17080000406252L17/scrutins1717080000406174170800004062511PA795950PM843419False259MG
17080000406253L17/scrutins1717080000406174170800004062512PA721908PM843467False402PAN
17080000406254L17/scrutins1717080000406174170800004062513PA795990PM856036False297MG
17080000406255L17/scrutins1717080000406174170800004062514PA795330PM843800False273MG
17080000406256L17/scrutins1717080000406174170800004062515PA795386PM843695False284MG
17080000406257L17/scrutins1717080000406174170800004062516PA721134PM843797False368MG
17080000406258L17/scrutins1717080000406174170800004062517PA720066PM842933False298MG
17080000406383L17/scrutins1717080000406174170800004063821PA1327PM842747False304MG
17080000406384L17/scrutins1717080000406174170800004063822PA842117PM843635False184MG
17080000406385L17/scrutins1717080000406174170800004063823PA870010PM870011False084MG
17080000406426L17/scrutins1717080000406174170800004064251PA795120PM858429False360MG
17080000406445L17/scrutins1717080000406174170800004064441PA794426PM842993False215MG
17080000406446L17/scrutins1717080000406174170800004064442PA720908PM843701False221MG
17080000406461L17/scrutins1717080000406174170800004064601PA793210PM842417False454MG
17080000406563L17/scrutins1717080000406485170800004065621PA795950PM843419False259MG
17080000406564L17/scrutins1717080000406485170800004065622PA721908PM843467False402PAN
17080000406565L17/scrutins1717080000406485170800004065623PA795990PM856036False297MG
17080000406566L17/scrutins1717080000406485170800004065624PA795330PM843800False273MG
17080000406567L17/scrutins1717080000406485170800004065625PA795386PM843695False284MG
17080000406568L17/scrutins1717080000406485170800004065626PA721134PM843797False368MG
17080000406569L17/scrutins1717080000406485170800004065627PA720066PM842933False298MG
17080000406688L17/scrutins1717080000406485170800004066871PA1327PM842747False304MG
17080000406689L17/scrutins1717080000406485170800004066872PA842117PM843635False184MG
17080000406690L17/scrutins1717080000406485170800004066873PA870010PM870011False084MG
17080000406732L17/scrutins1717080000406485170800004067311PA795120PM858429False360MG
17080000406751L17/scrutins1717080000406485170800004067501PA794426PM842993False215MG
17080000406752L17/scrutins1717080000406485170800004067502PA720908PM843701False221MG
17080000406767L17/scrutins1717080000406485170800004067661PA793210PM842417False454MG
17080000406847L17/scrutins1717080000406790170800004068461PA795950PM843419False259MG
17080000406848L17/scrutins1717080000406790170800004068462PA721908PM843467False402PAN
17080000406849L17/scrutins1717080000406790170800004068463PA795990PM856036False297MG
17080000406850L17/scrutins1717080000406790170800004068464PA795330PM843800False273MG
17080000406851L17/scrutins1717080000406790170800004068465PA795386PM843695False284MG
17080000406852L17/scrutins1717080000406790170800004068466PA721134PM843797False368MG
17080000406853L17/scrutins1717080000406790170800004068467PA720066PM842933False298MG
17080000406887L17/scrutins1717080000406790170800004068861PA795228PM840447False627PSE
17080000406959L17/scrutins1717080000406790170800004069581PA1327PM842747False304MG
17080000406960L17/scrutins1717080000406790170800004069582PA842117PM843635False184MG
17080000406961L17/scrutins1717080000406790170800004069583PA870010PM870011False084MG
17080000406995L17/scrutins1717080000406790170800004069941PA795120PM858429False360MG
17080000407010L17/scrutins1717080000406790170800004070091PA794426PM842993False215MG
17080000407011L17/scrutins1717080000406790170800004070092PA720908PM843701False221MG
17080000407021L17/scrutins1717080000406790170800004070201PA793210PM842417False454MG
17080000407095L17/scrutins1717080000407037170800004070941PA795950PM843419False259MG
17080000407096L17/scrutins1717080000407037170800004070942PA721908PM843467False402PAN
17080000407097L17/scrutins1717080000407037170800004070943PA795990PM856036False297MG
17080000407098L17/scrutins1717080000407037170800004070944PA795330PM843800False273MG
17080000407099L17/scrutins1717080000407037170800004070945PA795386PM843695False284MG