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
15080000066667L15/scrutins1515080000066592150800000666661PA1874PM722598PSE
15080000066718L15/scrutins1515080000066716150800000667171PA606171PM722632PAN
15080000066774L15/scrutins1515080000066716150800000667731PA1874PM722598PSE
15080000066801L15/scrutins1515080000066799150800000668001PA606171PM722632PAN
15080000066869L15/scrutins1515080000066799150800000668681PA1874PM722598PSE
15080000066902L15/scrutins1515080000066900150800000669011PA332747PM722798PAN
15080000066903L15/scrutins1515080000066900150800000669012PA719850PM722780PSE
15080000067007L15/scrutins1515080000067005150800000670061PA606171PM722632PAN
15080000067073L15/scrutins1515080000067005150800000670721PA1874PM722598PSE
15080000067105L15/scrutins1515080000067103150800000671041PA606171PM722632PAN
15080000067169L15/scrutins1515080000067103150800000671681PA1874PM722598PSE
15080000067202L15/scrutins1515080000067200150800000672011PA606171PM722632PAN
15080000067256L15/scrutins1515080000067200150800000672551PA1874PM722598PSE
15080000067289L15/scrutins1515080000067287150800000672881PA606171PM722632PAN
15080000067346L15/scrutins1515080000067287150800000673451PA1874PM722598PSE
15080000067382L15/scrutins1515080000067380150800000673811PA606171PM722632PAN
15080000067431L15/scrutins1515080000067380150800000674301PA1874PM722598PSE
15080000067458L15/scrutins1515080000067456150800000674571PA606171PM722632PAN
15080000067459L15/scrutins1515080000067456150800000674572PA720622PM723018PSE
15080000067536L15/scrutins1515080000067534150800000675351PA606171PM722632PAN
15080000067537L15/scrutins1515080000067534150800000675352PA720622PM723018PSE
15080000067623L15/scrutins1515080000067621150800000676221PA606171PM722632PAN
15080000067624L15/scrutins1515080000067621150800000676222PA720622PM723018PSE
15080000067743L15/scrutins1515080000067741150800000677421PA606171PM722632PAN
15080000067744L15/scrutins1515080000067741150800000677422PA720622PM723018PSE
15080000067933L15/scrutins1515080000067931150800000679321PA606171PM722632PAN
15080000067934L15/scrutins1515080000067931150800000679322PA720622PM723018PSE
15080000068046L15/scrutins1515080000068044150800000680451PA332747PM722798PAN
15080000068047L15/scrutins1515080000068044150800000680452PA719850PM722780PSE
15080000068155L15/scrutins1515080000068153150800000681541PA606171PM722632PAN
15080000068156L15/scrutins1515080000068153150800000681542PA720622PM723018PSE
15080000068284L15/scrutins1515080000068282150800000682831PA606171PM722632PAN
15080000068285L15/scrutins1515080000068282150800000682832PA720622PM723018PSE
15080000068351L15/scrutins1515080000068349150800000683501PA606171PM722632PAN
15080000068397L15/scrutins1515080000068349150800000683961PA605991PM722660PSE
15080000068422L15/scrutins1515080000068420150800000684211PA606171PM722632PSE
15080000068504L15/scrutins1515080000068502150800000685031PA606171PM722632PAN
15080000068549L15/scrutins1515080000068502150800000685481PA1874PM722598PSE
15080000068588L15/scrutins1515080000068586150800000685871PA606171PM722632PAN
15080000068633L15/scrutins1515080000068586150800000686321PA1874PM722598PSE
15080000068671L15/scrutins1515080000068669150800000686701PA606171PM722632PAN
15080000068672L15/scrutins1515080000068669150800000686702PA721824PM723394PSE
15080000068779L15/scrutins1515080000068777150800000687781PA606171PM722632PAN
15080000068780L15/scrutins1515080000068777150800000687782PA721824PM723394PSE
15080000068883L15/scrutins1515080000068881150800000688821PA606171PM722632PAN
15080000068884L15/scrutins1515080000068881150800000688822PA721824PM723394PSE
15080000068983L15/scrutins1515080000068981150800000689821PA606171PM722632PAN
15080000068984L15/scrutins1515080000068981150800000689822PA721824PM723394PSE
15080000069067L15/scrutins1515080000069065150800000690661PA332747PM722798PAN
15080000069068L15/scrutins1515080000069065150800000690662PA719850PM722780PSE