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
17080000982287L17/scrutins1717080000982227170800009822861PA795310PM840453False634PSE
17080000982391L17/scrutins1717080000982356170800009823901PA721908PM843467False380PAN
17080000982500L17/scrutins1717080000982458170800009824991PA721908PM843467False380PAN
17080000982633L17/scrutins1717080000982588170800009826321PA721908PM843467False380PAN
17080000982767L17/scrutins1717080000982721170800009827661PA721908PM843467False380PAN
17080000982906L17/scrutins1717080000982858170800009829051PA721908PM843467False380PAN
17080000983054L17/scrutins1717080000983005170800009830531PA721908PM843467False380PAN
17080000983202L17/scrutins1717080000983153170800009832011PA721908PM843467False380PAN
17080000983221L17/scrutins1717080000983153170800009832201PA795310PM840453False634PSE
17080000983341L17/scrutins1717080000983292170800009833401PA721908PM843467False380PAN
17080000983486L17/scrutins1717080000983438170800009834851PA721908PM843467False380PAN
17080000983607L17/scrutins1717080000983585170800009836061PA607846PM843113False266MG
17080000983608L17/scrutins1717080000983585170800009836062PA722046PM843482False270MG
17080000983609L17/scrutins1717080000983585170800009836063PA717161PM842396False400MG
17080000983610L17/scrutins1717080000983585170800009836064PA721908PM843467False402PAN
17080000983643L17/scrutins1717080000983585170800009836421PA330008PM842366False171PSE
17080000983644L17/scrutins1717080000983585170800009836422PA608016PM843155False173MG
17080000983645L17/scrutins1717080000983585170800009836423PA794038PM842783False186MG
17080000983658L17/scrutins1717080000983585170800009836571PA605782PM842666False222MG
17080000983716L17/scrutins1717080000983668170800009837151PA721908PM843467False380PAN
17080000983878L17/scrutins1717080000983830170800009838771PA721908PM843467False380PAN
17080000984040L17/scrutins1717080000983992170800009840391PA721908PM843467False380PAN
17080000984200L17/scrutins1717080000984152170800009841991PA721908PM843467False380PAN
17080000984363L17/scrutins1717080000984315170800009843621PA721908PM843467False380PAN
17080000984524L17/scrutins1717080000984476170800009845231PA721908PM843467False380PAN
17080000984674L17/scrutins1717080000984638170800009846731PA721908PM843467False380PAN
17080000984811L17/scrutins1717080000984772170800009848101PA721908PM843467False380PAN
17080000984952L17/scrutins1717080000984908170800009849511PA721908PM843467False380PAN
17080000985096L17/scrutins1717080000985055170800009850951PA721908PM843467False380PAN
17080000985223L17/scrutins1717080000985201170800009852221PA607846PM843113False266MG
17080000985224L17/scrutins1717080000985201170800009852222PA722046PM843482False270MG
17080000985225L17/scrutins1717080000985201170800009852223PA717161PM842396False400MG
17080000985226L17/scrutins1717080000985201170800009852224PA721908PM843467False402PAN
17080000985259L17/scrutins1717080000985201170800009852581PA330008PM842366False171PSE
17080000985260L17/scrutins1717080000985201170800009852582PA608016PM843155False173MG
17080000985261L17/scrutins1717080000985201170800009852583PA794038PM842783False186MG
17080000985275L17/scrutins1717080000985201170800009852741PA605782PM842666False222MG
17080000985329L17/scrutins1717080000985285170800009853281PA721908PM843467False380PAN
17080000985471L17/scrutins1717080000985432170800009854701PA721908PM843467False380PAN
17080000985602L17/scrutins1717080000985567170800009856011PA721908PM843467False380PAN
17080000985722L17/scrutins1717080000985693170800009857211PA721908PM843467False380PAN
17080000985806L17/scrutins1717080000985771170800009858051PA721908PM843467False380PAN
17080000985888L17/scrutins1717080000985886170800009858871PA794354PM842960False028PSE
17080000985923L17/scrutins1717080000985886170800009859221PA721908PM843467False380PAN
17080000986055L17/scrutins1717080000986021170800009860541PA721908PM843467False380PAN
17080000986170L17/scrutins1717080000986168170800009861691PA794354PM842960False028PSE
17080000986202L17/scrutins1717080000986168170800009862011PA721908PM843467False380PAN
17080000986359L17/scrutins1717080000986320170800009863581PA721908PM843467False380PAN
17080000986515L17/scrutins1717080000986474170800009865141PA721908PM843467False380PAN
17080000986665L17/scrutins1717080000986640170800009866641PA607846PM843113False266MG