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
17080000478033L17/scrutins1717080000477963170800004780312PA721908PM843467False402PAN
17080000478034L17/scrutins1717080000477963170800004780313PA795990PM856036False322MG
17080000478035L17/scrutins1717080000477963170800004780314PA795330PM843800False259MG
17080000478036L17/scrutins1717080000477963170800004780315PA795386PM843695False284MG
17080000478037L17/scrutins1717080000477963170800004780316PA721134PM843797False368MG
17080000478038L17/scrutins1717080000477963170800004780317PA720066PM842933False298MG
17080000478138L17/scrutins1717080000477963170800004781371PA1327PM842747False304MG
17080000478139L17/scrutins1717080000477963170800004781372PA842117PM843635False184MG
17080000478140L17/scrutins1717080000477963170800004781373PA870010PM870011False084MG
17080000478161L17/scrutins1717080000477963170800004781601PA719024PM842390False344PSE
17080000478162L17/scrutins1717080000477963170800004781602PA795120PM858429False360MG
17080000478177L17/scrutins1717080000477963170800004781761PA794426PM842993False239MG
17080000478178L17/scrutins1717080000477963170800004781762PA720908PM843701False318MG
17080000478191L17/scrutins1717080000477963170800004781901PA793210PM842417False454MG
17080000478277L17/scrutins1717080000478208170800004782761PA795950PM843419False389MG
17080000478278L17/scrutins1717080000478208170800004782762PA721908PM843467False402PAN
17080000478279L17/scrutins1717080000478208170800004782763PA795990PM856036False322MG
17080000478280L17/scrutins1717080000478208170800004782764PA795330PM843800False259MG
17080000478281L17/scrutins1717080000478208170800004782765PA795386PM843695False284MG
17080000478282L17/scrutins1717080000478208170800004782766PA721134PM843797False368MG
17080000478283L17/scrutins1717080000478208170800004782767PA720066PM842933False298MG
17080000478379L17/scrutins1717080000478208170800004783781PA1327PM842747False304MG
17080000478380L17/scrutins1717080000478208170800004783782PA842117PM843635False184MG
17080000478381L17/scrutins1717080000478208170800004783783PA870010PM870011False084MG
17080000478402L17/scrutins1717080000478208170800004784011PA719024PM842390False344PSE
17080000478403L17/scrutins1717080000478208170800004784012PA795120PM858429False360MG
17080000478414L17/scrutins1717080000478208170800004784131PA794426PM842993False239MG
17080000478415L17/scrutins1717080000478208170800004784132PA720908PM843701False318MG
17080000478426L17/scrutins1717080000478208170800004784251PA793210PM842417False454MG
17080000478510L17/scrutins1717080000478443170800004785091PA795950PM843419False389MG
17080000478511L17/scrutins1717080000478443170800004785092PA721908PM843467False402PAN
17080000478512L17/scrutins1717080000478443170800004785093PA795990PM856036False322MG
17080000478513L17/scrutins1717080000478443170800004785094PA795330PM843800False259MG
17080000478514L17/scrutins1717080000478443170800004785095PA795386PM843695False284MG
17080000478515L17/scrutins1717080000478443170800004785096PA721134PM843797False368MG
17080000478516L17/scrutins1717080000478443170800004785097PA720066PM842933False298MG
17080000478616L17/scrutins1717080000478443170800004786151PA1327PM842747False304MG
17080000478617L17/scrutins1717080000478443170800004786152PA842117PM843635False184MG
17080000478618L17/scrutins1717080000478443170800004786153PA870010PM870011False084MG
17080000478637L17/scrutins1717080000478443170800004786361PA719024PM842390False344PSE
17080000478638L17/scrutins1717080000478443170800004786362PA795120PM858429False360MG
17080000478654L17/scrutins1717080000478443170800004786531PA794426PM842993False239MG
17080000478655L17/scrutins1717080000478443170800004786532PA720908PM843701False318MG
17080000478665L17/scrutins1717080000478443170800004786641PA793210PM842417False454MG
17080000478741L17/scrutins1717080000478684170800004787401PA795950PM843419False389MG
17080000478742L17/scrutins1717080000478684170800004787402PA721908PM843467False402PAN
17080000478743L17/scrutins1717080000478684170800004787403PA795990PM856036False322MG
17080000478744L17/scrutins1717080000478684170800004787404PA795330PM843800False259MG
17080000478745L17/scrutins1717080000478684170800004787405PA795386PM843695False284MG
17080000478746L17/scrutins1717080000478684170800004787406PA721134PM843797False368MG