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
15080000167509L15/scrutins1515080000167507150800001675081PA606171PM722632PAN
15080000167510L15/scrutins1515080000167507150800001675082PA721824PM723394PSE
15080000167563L15/scrutins1515080000167561150800001675621PA606171PM722632PAN
15080000167564L15/scrutins1515080000167561150800001675622PA721824PM723394PSE
15080000167618L15/scrutins1515080000167616150800001676171PA606171PM722632PAN
15080000167699L15/scrutins1515080000167697150800001676981PA606171PM722632PAN
15080000167779L15/scrutins1515080000167777150800001677781PA606171PM722632PAN
15080000167836L15/scrutins1515080000167777150800001678351PA720746PM723064PSE
15080000167880L15/scrutins1515080000167878150800001678791PA606171PM722632PAN
15080000167932L15/scrutins1515080000167878150800001679311PA720746PM723064PSE
15080000167972L15/scrutins1515080000167970150800001679711PA332747PM722798PAN
15080000168043L15/scrutins1515080000167970150800001680421PA1874PM722598PSE
15080000168082L15/scrutins1515080000168080150800001680811PA606171PM722632PAN
15080000168127L15/scrutins1515080000168080150800001681261PA720746PM723064PSE
15080000168163L15/scrutins1515080000168161150800001681621PA606171PM722632PAN
15080000168208L15/scrutins1515080000168161150800001682071PA720746PM723064PSE
15080000168244L15/scrutins1515080000168242150800001682431PA606171PM722632PAN
15080000168285L15/scrutins1515080000168242150800001682841PA720746PM723064PSE
15080000168322L15/scrutins1515080000168320150800001683211PA606171PM722632PAN
15080000168360L15/scrutins1515080000168320150800001683591PA720746PM723064PSE
15080000168399L15/scrutins1515080000168397150800001683981PA606171PM722632PAN
15080000168445L15/scrutins1515080000168397150800001684441PA720746PM723064PSE
15080000168490L15/scrutins1515080000168488150800001684891PA606171PM722632PAN
15080000168508L15/scrutins1515080000168488150800001685071PA720746PM723064PSE
15080000168538L15/scrutins1515080000168536150800001685371PA606171PM722632PAN
15080000168565L15/scrutins1515080000168536150800001685641PA720746PM723064PSE
15080000168592L15/scrutins1515080000168590150800001685911PA606171PM722632PAN
15080000168626L15/scrutins1515080000168590150800001686251PA720746PM723064PSE
15080000168655L15/scrutins1515080000168653150800001686541PA606171PM722632PAN
15080000168689L15/scrutins1515080000168653150800001686881PA720746PM723064PSE
15080000168717L15/scrutins1515080000168715150800001687161PA606171PM722632PAN
15080000168748L15/scrutins1515080000168715150800001687471PA720746PM723064PSE
15080000168778L15/scrutins1515080000168776150800001687771PA332747PM722798PAN
15080000168882L15/scrutins1515080000168776150800001688811PA1874PM722598PSE
15080000168962L15/scrutins1515080000168960150800001689611PA606171PM722632PSE
15080000169188L15/scrutins1515080000169186150800001691871PA606171PM722632PSE
15080000169440L15/scrutins1515080000169438150800001694391PA606171PM722632PSE
15080000169681L15/scrutins1515080000169679150800001696801PA606171PM722632PSE
15080000169895L15/scrutins1515080000169893150800001698941PA606171PM722632PSE
15080000170112L15/scrutins1515080000170110150800001701111PA606171PM722632PSE
15080000170349L15/scrutins1515080000170347150800001703481PA606171PM722632PSE
15080000170577L15/scrutins1515080000170575150800001705761PA606171PM722632PSE
15080000170816L15/scrutins1515080000170814150800001708151PA606171PM722632PSE
15080000171010L15/scrutins1515080000171008150800001710091PA606171PM722632PSE
15080000171238L15/scrutins1515080000171236150800001712371PA332747PM722798PAN
15080000171311L15/scrutins1515080000171236150800001713101PA1874PM722598PSE
15080000171361L15/scrutins1515080000171359150800001713601PA606171PM722632PSE
15080000171591L15/scrutins1515080000171589150800001715901PA606171PM722632PSE
15080000171836L15/scrutins1515080000171834150800001718351PA606171PM722632PSE
15080000172066L15/scrutins1515080000172064150800001720651PA606171PM722632PSE