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
17080000364065L17/scrutins1717080000363984170800003640641PA795950PM843419False259MG
17080000364066L17/scrutins1717080000363984170800003640642PA721908PM843467False402PAN
17080000364067L17/scrutins1717080000363984170800003640643PA795990PM856036False297MG
17080000364068L17/scrutins1717080000363984170800003640644PA795330PM843800False273MG
17080000364069L17/scrutins1717080000363984170800003640645PA795386PM843695False284MG
17080000364070L17/scrutins1717080000363984170800003640646PA721134PM843797False268MG
17080000364071L17/scrutins1717080000363984170800003640647PA720066PM842933False260MG
17080000364199L17/scrutins1717080000363984170800003641981PA1327PM842747False304MG
17080000364200L17/scrutins1717080000363984170800003641982PA842117PM843635False184MG
17080000364201L17/scrutins1717080000363984170800003641983PA870010PM870011False084MG
17080000364246L17/scrutins1717080000363984170800003642451PA719024PM842390False344PSE
17080000364247L17/scrutins1717080000363984170800003642452PA795120PM858429False360MG
17080000364260L17/scrutins1717080000363984170800003642591PA794426PM842993False215MG
17080000364261L17/scrutins1717080000363984170800003642592PA720908PM843701False221MG
17080000364273L17/scrutins1717080000363984170800003642721PA793210PM842417False454MG
17080000364370L17/scrutins1717080000364291170800003643691PA795950PM843419False259MG
17080000364371L17/scrutins1717080000364291170800003643692PA721908PM843467False402PAN
17080000364372L17/scrutins1717080000364291170800003643693PA795990PM856036False297MG
17080000364373L17/scrutins1717080000364291170800003643694PA795330PM843800False273MG
17080000364374L17/scrutins1717080000364291170800003643695PA795386PM843695False284MG
17080000364375L17/scrutins1717080000364291170800003643696PA721134PM843797False268MG
17080000364376L17/scrutins1717080000364291170800003643697PA720066PM842933False260MG
17080000364502L17/scrutins1717080000364291170800003645011PA1327PM842747False304MG
17080000364503L17/scrutins1717080000364291170800003645012PA842117PM843635False184MG
17080000364504L17/scrutins1717080000364291170800003645013PA870010PM870011False084MG
17080000364545L17/scrutins1717080000364291170800003645441PA719024PM842390False344PSE
17080000364546L17/scrutins1717080000364291170800003645442PA795120PM858429False360MG
17080000364559L17/scrutins1717080000364291170800003645581PA794426PM842993False215MG
17080000364560L17/scrutins1717080000364291170800003645582PA720908PM843701False221MG
17080000364572L17/scrutins1717080000364291170800003645711PA793210PM842417False454MG
17080000364668L17/scrutins1717080000364589170800003646671PA795950PM843419False259MG
17080000364669L17/scrutins1717080000364589170800003646672PA721908PM843467False402PAN
17080000364670L17/scrutins1717080000364589170800003646673PA795990PM856036False297MG
17080000364671L17/scrutins1717080000364589170800003646674PA795330PM843800False273MG
17080000364672L17/scrutins1717080000364589170800003646675PA795386PM843695False284MG
17080000364673L17/scrutins1717080000364589170800003646676PA721134PM843797False268MG
17080000364674L17/scrutins1717080000364589170800003646677PA720066PM842933False260MG
17080000364794L17/scrutins1717080000364589170800003647931PA1327PM842747False304MG
17080000364795L17/scrutins1717080000364589170800003647932PA842117PM843635False184MG
17080000364796L17/scrutins1717080000364589170800003647933PA870010PM870011False084MG
17080000364838L17/scrutins1717080000364589170800003648371PA719024PM842390False344PSE
17080000364839L17/scrutins1717080000364589170800003648372PA795120PM858429False360MG
17080000364851L17/scrutins1717080000364589170800003648501PA794426PM842993False215MG
17080000364852L17/scrutins1717080000364589170800003648502PA720908PM843701False221MG
17080000364864L17/scrutins1717080000364589170800003648631PA793210PM842417False454MG
17080000364958L17/scrutins1717080000364881170800003649571PA795950PM843419False259MG
17080000364959L17/scrutins1717080000364881170800003649572PA721908PM843467False402PAN
17080000364960L17/scrutins1717080000364881170800003649573PA795990PM856036False297MG
17080000364961L17/scrutins1717080000364881170800003649574PA795330PM843800False273MG
17080000364962L17/scrutins1717080000364881170800003649575PA795386PM843695False284MG