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
16080000063235L16/scrutins1616080000063138160800000632341PA720908PM797556PSE
16080000063415L16/scrutins1616080000063252160800000634141PA720908PM797556PSE
16080000063599L16/scrutins1616080000063437160800000635981PA720908PM797556PSE
16080000063781L16/scrutins1616080000063616160800000637801PA720908PM797556PSE
16080000063996L16/scrutins1616080000063806160800000639951PA720908PM797556PSE
16080000064193L16/scrutins1616080000064029160800000641921PA720908PM797556PSE
16080000064620L16/scrutins1616080000064477160800000646191PA720908PM797556PSE
16080000064692L16/scrutins1616080000064643160800000646911PA720286PM796878PSE
16080000064797L16/scrutins1616080000064740160800000647961PA720286PM796878PSE
16080000064927L16/scrutins1616080000064857160800000649261PA720286PM796878PSE
16080000065077L16/scrutins1616080000064986160800000650761PA720286PM796878PSE
16080000065234L16/scrutins1616080000065140160800000652331PA720286PM796878PSE
16080000065388L16/scrutins1616080000065290160800000653871PA720286PM796878PSE
16080000065541L16/scrutins1616080000065443160800000655401PA720286PM796878PSE
16080000065690L16/scrutins1616080000065598160800000656891PA720286PM796878PSE
16080000065818L16/scrutins1616080000065741160800000658171PA720286PM796878PSE
16080000065977L16/scrutins1616080000065869160800000659761PA720468PM796983PSE
16080000066352L16/scrutins1616080000066242160800000663511PA720286PM796878PSE
16080000066624L16/scrutins1616080000066511160800000666231PA720286PM796878PSE
16080000066845L16/scrutins1616080000066780160800000668441PA720286PM796878PSE
16080000067020L16/scrutins1616080000066916160800000670191PA720286PM796878PSE
16080000067217L16/scrutins1616080000067115160800000672161PA720286PM796878PSE
16080000067412L16/scrutins1616080000067311160800000674111PA720286PM796878PSE
16080000067561L16/scrutins1616080000067476160800000675601PA720286PM796878PSE
16080000067692L16/scrutins1616080000067608160800000676911PA720286PM796878PSE
16080000067786L16/scrutins1616080000067728160800000677851PA720286PM796878PSE
16080000067883L16/scrutins1616080000067828160800000678821PA720286PM796878PSE
16080000068031L16/scrutins1616080000067935160800000680301PA720468PM796983PSE
16080000068308L16/scrutins1616080000068239160800000683071PA720286PM796878PSE
16080000068421L16/scrutins1616080000068356160800000684201PA720286PM796878PSE
16080000068545L16/scrutins1616080000068478160800000685441PA720286PM796878PSE
16080000068656L16/scrutins1616080000068591160800000686551PA720286PM796878PSE
16080000068756L16/scrutins1616080000068692160800000687551PA720286PM796878PSE
16080000068859L16/scrutins1616080000068803160800000688581PA720286PM796878PSE
16080000068957L16/scrutins1616080000068899160800000689561PA720286PM796878PSE
16080000069055L16/scrutins1616080000068997160800000690541PA720286PM796878PSE
16080000069147L16/scrutins1616080000069092160800000691461PA720286PM796878PSE
16080000069236L16/scrutins1616080000069182160800000692351PA720286PM796878PSE
16080000069387L16/scrutins1616080000069276160800000693861PA720468PM796983PSE
16080000069597L16/scrutins1616080000069595160800000695961PA721908PM797568PSE
16080000069888L16/scrutins1616080000069886160800000698871PA721908PM797568PSE
16080000070088L16/scrutins1616080000069993160800000700871PA720468PM796983PSE
16080000070200L16/scrutins1616080000070198160800000701991PA721908PM797568PSE
16080000070864L16/scrutins1616080000070758160800000708631PA719874PM796674PSE
16080000070930L16/scrutins1616080000070898160800000709291PA720468PM796983PSE
16080000071001L16/scrutins1616080000070976160800000710001PA720468PM796983PSE
16080000071109L16/scrutins1616080000071046160800000711081PA720468PM796983PSE
16080000071266L16/scrutins1616080000071200160800000712651PA720468PM796983PSE
16080000071423L16/scrutins1616080000071352160800000714221PA720468PM796983PSE
16080000071604L16/scrutins1616080000071493160800000716031PA720468PM796983PSE