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
17080000481235L17/scrutins1717080000481161170800004812332PA721908PM843467False402PAN
17080000481236L17/scrutins1717080000481161170800004812333PA795990PM856036False322MG
17080000481237L17/scrutins1717080000481161170800004812334PA795330PM843800False259MG
17080000481238L17/scrutins1717080000481161170800004812335PA795386PM843695False284MG
17080000481239L17/scrutins1717080000481161170800004812336PA721134PM843797False368MG
17080000481240L17/scrutins1717080000481161170800004812337PA720066PM842933False298MG
17080000481346L17/scrutins1717080000481161170800004813451PA1327PM842747False304MG
17080000481347L17/scrutins1717080000481161170800004813452PA842117PM843635False184MG
17080000481348L17/scrutins1717080000481161170800004813453PA870010PM870011False084MG
17080000481378L17/scrutins1717080000481161170800004813771PA795120PM858429False360MG
17080000481390L17/scrutins1717080000481161170800004813891PA794426PM842993False239MG
17080000481391L17/scrutins1717080000481161170800004813892PA720908PM843701False318MG
17080000481407L17/scrutins1717080000481161170800004814061PA793210PM842417False454MG
17080000481424L17/scrutins1717080000481422170800004814231PA794354PM842960False100PSE
17080000481494L17/scrutins1717080000481422170800004814931PA795950PM843419False389MG
17080000481495L17/scrutins1717080000481422170800004814932PA721908PM843467False402PAN
17080000481496L17/scrutins1717080000481422170800004814933PA795990PM856036False322MG
17080000481497L17/scrutins1717080000481422170800004814934PA795330PM843800False259MG
17080000481498L17/scrutins1717080000481422170800004814935PA795386PM843695False284MG
17080000481499L17/scrutins1717080000481422170800004814936PA721134PM843797False368MG
17080000481500L17/scrutins1717080000481422170800004814937PA720066PM842933False298MG
17080000481605L17/scrutins1717080000481422170800004816041PA1327PM842747False304MG
17080000481606L17/scrutins1717080000481422170800004816042PA842117PM843635False184MG
17080000481607L17/scrutins1717080000481422170800004816043PA870010PM870011False084MG
17080000481632L17/scrutins1717080000481422170800004816311PA795120PM858429False360MG
17080000481644L17/scrutins1717080000481422170800004816431PA794426PM842993False239MG
17080000481645L17/scrutins1717080000481422170800004816432PA720908PM843701False318MG
17080000481654L17/scrutins1717080000481422170800004816531PA793210PM842417False454MG
17080000481672L17/scrutins1717080000481670170800004816711PA794354PM842960False100PSE
17080000481745L17/scrutins1717080000481670170800004817441PA795950PM843419False389MG
17080000481746L17/scrutins1717080000481670170800004817442PA721908PM843467False402PAN
17080000481747L17/scrutins1717080000481670170800004817443PA795990PM856036False322MG
17080000481748L17/scrutins1717080000481670170800004817444PA795330PM843800False259MG
17080000481749L17/scrutins1717080000481670170800004817445PA795386PM843695False284MG
17080000481750L17/scrutins1717080000481670170800004817446PA721134PM843797False368MG
17080000481751L17/scrutins1717080000481670170800004817447PA720066PM842933False298MG
17080000481857L17/scrutins1717080000481670170800004818561PA1327PM842747False304MG
17080000481858L17/scrutins1717080000481670170800004818562PA842117PM843635False184MG
17080000481859L17/scrutins1717080000481670170800004818563PA870010PM870011False084MG
17080000481886L17/scrutins1717080000481670170800004818851PA795120PM858429False360MG
17080000481906L17/scrutins1717080000481670170800004819051PA794426PM842993False239MG
17080000481907L17/scrutins1717080000481670170800004819052PA720908PM843701False318MG
17080000481924L17/scrutins1717080000481670170800004819231PA793210PM842417False454MG
17080000481949L17/scrutins1717080000481947170800004819481PA794354PM842960False100PSE
17080000482020L17/scrutins1717080000481947170800004820191PA795950PM843419False389MG
17080000482021L17/scrutins1717080000481947170800004820192PA721908PM843467False402PAN
17080000482022L17/scrutins1717080000481947170800004820193PA795990PM856036False322MG
17080000482023L17/scrutins1717080000481947170800004820194PA795330PM843800False259MG
17080000482024L17/scrutins1717080000481947170800004820195PA795386PM843695False284MG
17080000482025L17/scrutins1717080000481947170800004820196PA721134PM843797False368MG