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 411 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
17080000976873L17/scrutins1717080000976871170800009768721PA794354PM842960False028PSE
17080000976892L17/scrutins1717080000976871170800009768911PA721908PM843467False380PAN
17080000976967L17/scrutins1717080000976946170800009769661PA721908PM843467False380PAN
17080000977039L17/scrutins1717080000977019170800009770381PA721908PM843467False380PAN
17080000977108L17/scrutins1717080000977088170800009771071PA721908PM843467False380PAN
17080000977177L17/scrutins1717080000977158170800009771761PA721908PM843467False380PAN
17080000977249L17/scrutins1717080000977225170800009772481PA721908PM843467False380PAN
17080000977333L17/scrutins1717080000977307170800009773321PA721908PM843467False380PAN
17080000977421L17/scrutins1717080000977394170800009774201PA721908PM843467False380PAN
17080000977510L17/scrutins1717080000977483170800009775091PA721908PM843467False380PAN
17080000977597L17/scrutins1717080000977570170800009775961PA721908PM843467False380PAN
17080000977709L17/scrutins1717080000977660170800009777081PA721134PM843797False268PSE
17080000977710L17/scrutins1717080000977660170800009777082PA607846PM843113False266MG
17080000977711L17/scrutins1717080000977660170800009777083PA722046PM843482False270MG
17080000977712L17/scrutins1717080000977660170800009777084PA717161PM842396False400MG
17080000977713L17/scrutins1717080000977660170800009777085PA721908PM843467False402PAN
17080000977772L17/scrutins1717080000977660170800009777711PA608016PM843155False173MG
17080000977773L17/scrutins1717080000977660170800009777712PA794038PM842783False186MG
17080000977797L17/scrutins1717080000977660170800009777961PA605782PM842666False222MG
17080000977846L17/scrutins1717080000977820170800009778451PA721908PM843467False380PAN
17080000977935L17/scrutins1717080000977909170800009779341PA721908PM843467False380PAN
17080000978023L17/scrutins1717080000977997170800009780221PA721908PM843467False380PAN
17080000978108L17/scrutins1717080000978082170800009781071PA721908PM843467False380PAN
17080000978198L17/scrutins1717080000978173170800009781971PA721908PM843467False380PAN
17080000978276L17/scrutins1717080000978250170800009782751PA721908PM843467False380PAN
17080000978368L17/scrutins1717080000978341170800009783671PA721908PM843467False380PAN
17080000978457L17/scrutins1717080000978429170800009784561PA721908PM843467False380PAN
17080000978535L17/scrutins1717080000978509170800009785341PA721908PM843467False380PAN
17080000978628L17/scrutins1717080000978602170800009786271PA721908PM843467False380PAN
17080000978748L17/scrutins1717080000978693170800009787471PA721134PM843797False268PSE
17080000978749L17/scrutins1717080000978693170800009787472PA607846PM843113False266MG
17080000978750L17/scrutins1717080000978693170800009787473PA722046PM843482False270MG
17080000978751L17/scrutins1717080000978693170800009787474PA717161PM842396False400MG
17080000978752L17/scrutins1717080000978693170800009787475PA721908PM843467False402PAN
17080000978819L17/scrutins1717080000978693170800009788181PA608016PM843155False173MG
17080000978820L17/scrutins1717080000978693170800009788182PA794038PM842783False186MG
17080000978847L17/scrutins1717080000978693170800009788461PA605782PM842666False222MG
17080000978898L17/scrutins1717080000978873170800009788971PA721908PM843467False380PAN
17080000978989L17/scrutins1717080000978963170800009789881PA721908PM843467False380PAN
17080000979081L17/scrutins1717080000979054170800009790801PA721908PM843467False380PAN
17080000979170L17/scrutins1717080000979143170800009791691PA721908PM843467False380PAN
17080000979260L17/scrutins1717080000979235170800009792591PA721908PM843467False380PAN
17080000979333L17/scrutins1717080000979321170800009793321PA721908PM843467False380PAN
17080000979366L17/scrutins1717080000979364170800009793651PA794354PM842960False028PSE
17080000979389L17/scrutins1717080000979364170800009793881PA721908PM843467False380PAN
17080000979466L17/scrutins1717080000979442170800009794651PA721908PM843467False380PAN
17080000979551L17/scrutins1717080000979524170800009795501PA721908PM843467False380PAN
17080000979643L17/scrutins1717080000979615170800009796421PA721908PM843467False380PAN
17080000979762L17/scrutins1717080000979711170800009797611PA721908PM843467False402PAN
17080000979823L17/scrutins1717080000979711170800009798221PA643089PM843431False206MG