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
15080000300799L15/scrutins1515080000300797150800003007981PA606171PM722632PAN
15080000300844L15/scrutins1515080000300797150800003008431PA1874PM722598PSE
15080000300889L15/scrutins1515080000300887150800003008881PA606171PM722632PAN
15080000300941L15/scrutins1515080000300887150800003009401PA1874PM722598PSE
15080000300983L15/scrutins1515080000300981150800003009821PA606171PM722632PAN
15080000301036L15/scrutins1515080000300981150800003010351PA1874PM722598PSE
15080000301080L15/scrutins1515080000301078150800003010791PA606171PM722632PAN
15080000301130L15/scrutins1515080000301078150800003011291PA1874PM722598PSE
15080000301171L15/scrutins1515080000301169150800003011701PA606171PM722632PAN
15080000301215L15/scrutins1515080000301169150800003012141PA1874PM722598PSE
15080000301262L15/scrutins1515080000301260150800003012611PA332747PM722798PAN
15080000301263L15/scrutins1515080000301260150800003012612PA720622PM723018PSE
15080000301340L15/scrutins1515080000301338150800003013391PA606171PM722632PAN
15080000301383L15/scrutins1515080000301338150800003013821PA1874PM722598PSE
15080000301426L15/scrutins1515080000301424150800003014251PA606171PM722632PAN
15080000301524L15/scrutins1515080000301522150800003015231PA606171PM722632PAN
15080000301566L15/scrutins1515080000301522150800003015651PA1874PM722598PSE
15080000301604L15/scrutins1515080000301602150800003016031PA606171PM722632PAN
15080000301657L15/scrutins1515080000301602150800003016561PA1874PM722598PSE
15080000301698L15/scrutins1515080000301696150800003016971PA606171PM722632PSE
15080000301880L15/scrutins1515080000301878150800003018791PA606171PM722632PAN
15080000301987L15/scrutins1515080000301878150800003019861PA1592PM723060PSE
15080000302027L15/scrutins1515080000302025150800003020261PA606171PM722632PAN
15080000302179L15/scrutins1515080000302025150800003021781PA1592PM723060PSE
15080000302245L15/scrutins1515080000302243150800003022441PA606171PM722632PAN
15080000302396L15/scrutins1515080000302243150800003023951PA1592PM723060PSE
15080000302439L15/scrutins1515080000302437150800003024381PA606171PM722632PAN
15080000302588L15/scrutins1515080000302437150800003025871PA1592PM723060PSE
15080000302652L15/scrutins1515080000302650150800003026511PA606171PM722632PAN
15080000302849L15/scrutins1515080000302650150800003028481PA1592PM723060PSE
15080000302934L15/scrutins1515080000302932150800003029331PA332747PM722798PAN
15080000302935L15/scrutins1515080000302932150800003029332PA720622PM723018PSE
15080000303028L15/scrutins1515080000303026150800003030271PA606171PM722632PAN
15080000303029L15/scrutins1515080000303026150800003030272PA721824PM723394PSE
15080000303235L15/scrutins1515080000303233150800003032341PA606171PM722632PAN
15080000303236L15/scrutins1515080000303233150800003032342PA721824PM723394PSE
15080000303450L15/scrutins1515080000303448150800003034491PA606171PM722632PAN
15080000303451L15/scrutins1515080000303448150800003034492PA721824PM723394PSE
15080000303666L15/scrutins1515080000303664150800003036651PA606171PM722632PAN
15080000303772L15/scrutins1515080000303664150800003037711PA1874PM722598PSE
15080000303833L15/scrutins1515080000303831150800003038321PA606171PM722632PAN
15080000303937L15/scrutins1515080000303831150800003039361PA1874PM722598PSE
15080000303998L15/scrutins1515080000303996150800003039971PA606171PM722632PAN
15080000304103L15/scrutins1515080000303996150800003041021PA1874PM722598PSE
15080000304164L15/scrutins1515080000304162150800003041631PA606171PM722632PAN
15080000304241L15/scrutins1515080000304162150800003042401PA1874PM722598PSE
15080000304293L15/scrutins1515080000304291150800003042921PA606171PM722632PAN
15080000304390L15/scrutins1515080000304291150800003043891PA1874PM722598PSE
15080000304443L15/scrutins1515080000304441150800003044421PA606171PM722632PAN
15080000304570L15/scrutins1515080000304568150800003045691PA606171PM722632PAN