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
17080000410638L17/scrutins1717080000410381170800004106371PA1327PM842747False304MG
17080000410639L17/scrutins1717080000410381170800004106372PA842117PM843635False184MG
17080000410640L17/scrutins1717080000410381170800004106373PA870010PM870011False084MG
17080000410685L17/scrutins1717080000410381170800004106841PA719024PM842390False344PSE
17080000410686L17/scrutins1717080000410381170800004106842PA795120PM858429False360MG
17080000410696L17/scrutins1717080000410381170800004106951PA794426PM842993False215MG
17080000410697L17/scrutins1717080000410381170800004106952PA720908PM843701False221MG
17080000410704L17/scrutins1717080000410381170800004107031PA793210PM842417False454MG
17080000410851L17/scrutins1717080000410728170800004108501PA795950PM843419False259MG
17080000410852L17/scrutins1717080000410728170800004108502PA721908PM843467False402PAN
17080000410853L17/scrutins1717080000410728170800004108503PA795990PM856036False297MG
17080000410854L17/scrutins1717080000410728170800004108504PA795330PM843800False273MG
17080000410855L17/scrutins1717080000410728170800004108505PA795386PM843695False284MG
17080000410856L17/scrutins1717080000410728170800004108506PA721134PM843797False368MG
17080000410857L17/scrutins1717080000410728170800004108507PA720066PM842933False298MG
17080000410979L17/scrutins1717080000410728170800004109781PA1327PM842747False304MG
17080000410980L17/scrutins1717080000410728170800004109782PA842117PM843635False184MG
17080000410981L17/scrutins1717080000410728170800004109783PA870010PM870011False084MG
17080000411025L17/scrutins1717080000410728170800004110241PA719024PM842390False344PSE
17080000411026L17/scrutins1717080000410728170800004110242PA795120PM858429False360MG
17080000411032L17/scrutins1717080000410728170800004110311PA794426PM842993False215MG
17080000411033L17/scrutins1717080000410728170800004110312PA720908PM843701False221MG
17080000411039L17/scrutins1717080000410728170800004110381PA793210PM842417False454MG
17080000411182L17/scrutins1717080000411061170800004111811PA795950PM843419False259MG
17080000411183L17/scrutins1717080000411061170800004111812PA721908PM843467False402PAN
17080000411184L17/scrutins1717080000411061170800004111813PA795990PM856036False297MG
17080000411185L17/scrutins1717080000411061170800004111814PA795330PM843800False273MG
17080000411186L17/scrutins1717080000411061170800004111815PA795386PM843695False284MG
17080000411187L17/scrutins1717080000411061170800004111816PA721134PM843797False368MG
17080000411188L17/scrutins1717080000411061170800004111817PA720066PM842933False298MG
17080000411306L17/scrutins1717080000411061170800004113051PA1327PM842747False304MG
17080000411307L17/scrutins1717080000411061170800004113052PA842117PM843635False184MG
17080000411308L17/scrutins1717080000411061170800004113053PA870010PM870011False084MG
17080000411348L17/scrutins1717080000411061170800004113471PA719024PM842390False344PSE
17080000411349L17/scrutins1717080000411061170800004113472PA795120PM858429False360MG
17080000411357L17/scrutins1717080000411061170800004113561PA794426PM842993False215MG
17080000411358L17/scrutins1717080000411061170800004113562PA720908PM843701False221MG
17080000411365L17/scrutins1717080000411061170800004113641PA793210PM842417False454MG
17080000411463L17/scrutins1717080000411388170800004114621PA721908PM843467False402PAN
17080000411529L17/scrutins1717080000411388170800004115281PA330008PM842366False171PSE
17080000411707L17/scrutins1717080000411585170800004117061PA795950PM843419False259MG
17080000411708L17/scrutins1717080000411585170800004117062PA721908PM843467False402PAN
17080000411709L17/scrutins1717080000411585170800004117063PA795990PM856036False297MG
17080000411710L17/scrutins1717080000411585170800004117064PA795330PM843800False273MG
17080000411711L17/scrutins1717080000411585170800004117065PA795386PM843695False284MG
17080000411712L17/scrutins1717080000411585170800004117066PA721134PM843797False368MG
17080000411713L17/scrutins1717080000411585170800004117067PA720066PM842933False298MG
17080000411833L17/scrutins1717080000411585170800004118321PA1327PM842747False304MG
17080000411834L17/scrutins1717080000411585170800004118322PA842117PM843635False184MG
17080000411835L17/scrutins1717080000411585170800004118323PA870010PM870011False084MG