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
17080000933514L17/scrutins1717080000933482170800009335122PA720066PM878039False304MG
17080000933604L17/scrutins1717080000933482170800009336031PA719024PM842390False344PSE
17080000933665L17/scrutins1717080000933632170800009336641PA721908PM843467False380PAN
17080000933666L17/scrutins1717080000933632170800009336642PA720066PM878039False304MG
17080000933759L17/scrutins1717080000933632170800009337581PA719024PM842390False344PSE
17080000933819L17/scrutins1717080000933784170800009338181PA721908PM843467False380PAN
17080000933820L17/scrutins1717080000933784170800009338182PA720066PM878039False304MG
17080000933908L17/scrutins1717080000933784170800009339071PA719024PM842390False344PSE
17080000933977L17/scrutins1717080000933942170800009339761PA721908PM843467False380PAN
17080000933978L17/scrutins1717080000933942170800009339762PA720066PM878039False304MG
17080000934071L17/scrutins1717080000933942170800009340701PA719024PM842390False344PSE
17080000934142L17/scrutins1717080000934107170800009341411PA721908PM843467False380PAN
17080000934143L17/scrutins1717080000934107170800009341412PA720066PM878039False304MG
17080000934236L17/scrutins1717080000934107170800009342351PA719024PM842390False344PSE
17080000934296L17/scrutins1717080000934263170800009342951PA721908PM843467False380PAN
17080000934297L17/scrutins1717080000934263170800009342952PA720066PM878039False304MG
17080000934379L17/scrutins1717080000934263170800009343781PA719024PM842390False344PSE
17080000934491L17/scrutins1717080000934406170800009344901PA607846PM843113False266MG
17080000934492L17/scrutins1717080000934406170800009344902PA722046PM843482False270MG
17080000934493L17/scrutins1717080000934406170800009344903PA717161PM842396False400MG
17080000934494L17/scrutins1717080000934406170800009344904PA721908PM843467False402PAN
17080000934571L17/scrutins1717080000934406170800009345701PA608016PM843155False173MG
17080000934572L17/scrutins1717080000934406170800009345702PA794038PM842783False186MG
17080000934596L17/scrutins1717080000934406170800009345951PA605782PM842666False222MG
17080000934651L17/scrutins1717080000934618170800009346501PA721908PM843467False380PAN
17080000934652L17/scrutins1717080000934618170800009346502PA720066PM878039False304MG
17080000934736L17/scrutins1717080000934618170800009347351PA719024PM842390False344PSE
17080000934793L17/scrutins1717080000934760170800009347921PA721908PM843467False380PAN
17080000934794L17/scrutins1717080000934760170800009347922PA720066PM878039False304MG
17080000934876L17/scrutins1717080000934760170800009348751PA719024PM842390False344PSE
17080000934935L17/scrutins1717080000934900170800009349341PA721908PM843467False380PAN
17080000934936L17/scrutins1717080000934900170800009349342PA720066PM878039False304MG
17080000935012L17/scrutins1717080000934900170800009350111PA719024PM842390False344PSE
17080000935066L17/scrutins1717080000935038170800009350651PA721908PM843467False380PAN
17080000935067L17/scrutins1717080000935038170800009350652PA720066PM878039False304MG
17080000935158L17/scrutins1717080000935038170800009351571PA795270PM858399False217PSE
17080000935207L17/scrutins1717080000935175170800009352061PA721908PM843467False380PAN
17080000935208L17/scrutins1717080000935175170800009352062PA720066PM878039False304MG
17080000935305L17/scrutins1717080000935175170800009353041PA795270PM858399False217PSE
17080000935351L17/scrutins1717080000935323170800009353501PA721908PM843467False380PAN
17080000935352L17/scrutins1717080000935323170800009353502PA720066PM878039False304MG
17080000935436L17/scrutins1717080000935323170800009354351PA795270PM858399False217PSE
17080000935483L17/scrutins1717080000935456170800009354821PA721908PM843467False380PAN
17080000935484L17/scrutins1717080000935456170800009354822PA720066PM878039False304MG
17080000935551L17/scrutins1717080000935456170800009355501PA795270PM858399False217PSE
17080000935598L17/scrutins1717080000935569170800009355971PA721908PM843467False380PAN
17080000935599L17/scrutins1717080000935569170800009355972PA720066PM878039False304MG
17080000935696L17/scrutins1717080000935569170800009356951PA795270PM858399False217PSE
17080000935742L17/scrutins1717080000935712170800009357411PA721908PM843467False380PAN
17080000935743L17/scrutins1717080000935712170800009357412PA720066PM878039False304MG