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
17080000486883L17/scrutins1717080000486803170800004868785PA795386PM843695False284MG
17080000486884L17/scrutins1717080000486803170800004868786PA721134PM843797False368MG
17080000486885L17/scrutins1717080000486803170800004868787PA720066PM842933False298MG
17080000486979L17/scrutins1717080000486803170800004869781PA1327PM842747False304MG
17080000486980L17/scrutins1717080000486803170800004869782PA842117PM843635False184MG
17080000486981L17/scrutins1717080000486803170800004869783PA870010PM870011False084MG
17080000487007L17/scrutins1717080000486803170800004870061PA795120PM858429False360MG
17080000487025L17/scrutins1717080000486803170800004870241PA795270PM858399False217PSE
17080000487026L17/scrutins1717080000486803170800004870242PA794426PM842993False239MG
17080000487027L17/scrutins1717080000486803170800004870243PA720908PM843701False318MG
17080000487041L17/scrutins1717080000486803170800004870401PA793210PM842417False454MG
17080000487121L17/scrutins1717080000487056170800004871201PA721908PM843467False402PAN
17080000487286L17/scrutins1717080000487210170800004872851PA795950PM843419False389MG
17080000487287L17/scrutins1717080000487210170800004872852PA721908PM843467False402PAN
17080000487288L17/scrutins1717080000487210170800004872853PA795990PM856036False322MG
17080000487289L17/scrutins1717080000487210170800004872854PA795330PM843800False259MG
17080000487290L17/scrutins1717080000487210170800004872855PA795386PM843695False284MG
17080000487291L17/scrutins1717080000487210170800004872856PA721134PM843797False368MG
17080000487292L17/scrutins1717080000487210170800004872857PA720066PM842933False298MG
17080000487390L17/scrutins1717080000487210170800004873891PA1327PM842747False304MG
17080000487391L17/scrutins1717080000487210170800004873892PA842117PM843635False184MG
17080000487392L17/scrutins1717080000487210170800004873893PA870010PM870011False084MG
17080000487418L17/scrutins1717080000487210170800004874171PA795120PM858429False360MG
17080000487431L17/scrutins1717080000487210170800004874301PA795270PM858399False217PSE
17080000487432L17/scrutins1717080000487210170800004874302PA794426PM842993False239MG
17080000487433L17/scrutins1717080000487210170800004874303PA720908PM843701False318MG
17080000487446L17/scrutins1717080000487210170800004874451PA793210PM842417False454MG
17080000487534L17/scrutins1717080000487458170800004875331PA795950PM843419False389MG
17080000487535L17/scrutins1717080000487458170800004875332PA721908PM843467False402PAN
17080000487536L17/scrutins1717080000487458170800004875333PA795990PM856036False322MG
17080000487537L17/scrutins1717080000487458170800004875334PA795330PM843800False259MG
17080000487538L17/scrutins1717080000487458170800004875335PA795386PM843695False284MG
17080000487539L17/scrutins1717080000487458170800004875336PA721134PM843797False368MG
17080000487540L17/scrutins1717080000487458170800004875337PA720066PM842933False298MG
17080000487638L17/scrutins1717080000487458170800004876371PA1327PM842747False304MG
17080000487639L17/scrutins1717080000487458170800004876372PA842117PM843635False184MG
17080000487640L17/scrutins1717080000487458170800004876373PA870010PM870011False084MG
17080000487667L17/scrutins1717080000487458170800004876661PA795120PM858429False360MG
17080000487681L17/scrutins1717080000487458170800004876801PA795270PM858399False217PSE
17080000487682L17/scrutins1717080000487458170800004876802PA794426PM842993False239MG
17080000487683L17/scrutins1717080000487458170800004876803PA720908PM843701False318MG
17080000487695L17/scrutins1717080000487458170800004876941PA793210PM842417False454MG
17080000487781L17/scrutins1717080000487710170800004877801PA795950PM843419False389MG
17080000487782L17/scrutins1717080000487710170800004877802PA721908PM843467False402PAN
17080000487783L17/scrutins1717080000487710170800004877803PA795990PM856036False322MG
17080000487784L17/scrutins1717080000487710170800004877804PA795330PM843800False259MG
17080000487785L17/scrutins1717080000487710170800004877805PA795386PM843695False284MG
17080000487786L17/scrutins1717080000487710170800004877806PA721134PM843797False368MG
17080000487787L17/scrutins1717080000487710170800004877807PA720066PM842933False298MG
17080000487879L17/scrutins1717080000487710170800004878781PA1327PM842747False304MG