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
17080000407100L17/scrutins1717080000407037170800004070946PA721134PM843797False368MG
17080000407101L17/scrutins1717080000407037170800004070947PA720066PM842933False298MG
17080000407206L17/scrutins1717080000407037170800004072051PA1327PM842747False304MG
17080000407207L17/scrutins1717080000407037170800004072052PA842117PM843635False184MG
17080000407208L17/scrutins1717080000407037170800004072053PA870010PM870011False084MG
17080000407242L17/scrutins1717080000407037170800004072411PA795120PM858429False360MG
17080000407256L17/scrutins1717080000407037170800004072551PA794426PM842993False215MG
17080000407257L17/scrutins1717080000407037170800004072552PA720908PM843701False221MG
17080000407267L17/scrutins1717080000407037170800004072661PA793210PM842417False454MG
17080000407342L17/scrutins1717080000407284170800004073411PA795950PM843419False259MG
17080000407343L17/scrutins1717080000407284170800004073412PA721908PM843467False402PAN
17080000407344L17/scrutins1717080000407284170800004073413PA795990PM856036False297MG
17080000407345L17/scrutins1717080000407284170800004073414PA795330PM843800False273MG
17080000407346L17/scrutins1717080000407284170800004073415PA795386PM843695False284MG
17080000407347L17/scrutins1717080000407284170800004073416PA721134PM843797False368MG
17080000407348L17/scrutins1717080000407284170800004073417PA720066PM842933False298MG
17080000407449L17/scrutins1717080000407284170800004074481PA1327PM842747False304MG
17080000407450L17/scrutins1717080000407284170800004074482PA842117PM843635False184MG
17080000407451L17/scrutins1717080000407284170800004074483PA870010PM870011False084MG
17080000407485L17/scrutins1717080000407284170800004074841PA795120PM858429False360MG
17080000407499L17/scrutins1717080000407284170800004074981PA794426PM842993False215MG
17080000407500L17/scrutins1717080000407284170800004074982PA720908PM843701False221MG
17080000407510L17/scrutins1717080000407284170800004075091PA793210PM842417False454MG
17080000407576L17/scrutins1717080000407527170800004075751PA795950PM843419False259MG
17080000407577L17/scrutins1717080000407527170800004075752PA721908PM843467False402PAN
17080000407578L17/scrutins1717080000407527170800004075753PA795990PM856036False297MG
17080000407579L17/scrutins1717080000407527170800004075754PA795330PM843800False273MG
17080000407580L17/scrutins1717080000407527170800004075755PA795386PM843695False284MG
17080000407581L17/scrutins1717080000407527170800004075756PA721134PM843797False368MG
17080000407582L17/scrutins1717080000407527170800004075757PA720066PM842933False298MG
17080000407680L17/scrutins1717080000407527170800004076791PA1327PM842747False304MG
17080000407681L17/scrutins1717080000407527170800004076792PA842117PM843635False184MG
17080000407682L17/scrutins1717080000407527170800004076793PA870010PM870011False084MG
17080000407715L17/scrutins1717080000407527170800004077141PA795120PM858429False360MG
17080000407726L17/scrutins1717080000407527170800004077251PA794426PM842993False215MG
17080000407727L17/scrutins1717080000407527170800004077252PA720908PM843701False221MG
17080000407736L17/scrutins1717080000407527170800004077351PA793210PM842417False454MG
17080000407826L17/scrutins1717080000407751170800004078251PA721908PM843467False402PAN
17080000407889L17/scrutins1717080000407751170800004078881PA330008PM842366False171PSE
17080000408069L17/scrutins1717080000407944170800004080681PA795950PM843419False259MG
17080000408070L17/scrutins1717080000407944170800004080682PA721908PM843467False402PAN
17080000408071L17/scrutins1717080000407944170800004080683PA795990PM856036False297MG
17080000408072L17/scrutins1717080000407944170800004080684PA795330PM843800False273MG
17080000408073L17/scrutins1717080000407944170800004080685PA795386PM843695False284MG
17080000408074L17/scrutins1717080000407944170800004080686PA721134PM843797False368MG
17080000408075L17/scrutins1717080000407944170800004080687PA720066PM842933False298MG
17080000408217L17/scrutins1717080000407944170800004082161PA1327PM842747False304MG
17080000408218L17/scrutins1717080000407944170800004082162PA842117PM843635False184MG
17080000408219L17/scrutins1717080000407944170800004082163PA870010PM870011False084MG
17080000408280L17/scrutins1717080000407944170800004082791PA795120PM858429False360MG