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
14080000015857L14/scrutins1414080000015855140800000158561PA381PM645125PAN
14080000015860L14/scrutins1414080000015855140800000158591PA267797PM645350PSE
14080000015869L14/scrutins1414080000015867140800000158681PA381PM645125PAN
14080000015872L14/scrutins1414080000015867140800000158711PA267797PM645350PSE
14080000015884L14/scrutins1414080000015882140800000158831PA381PM645125PAN
14080000015885L14/scrutins1414080000015882140800000158832PA335017PM645607PSE
14080000015894L14/scrutins1414080000015892140800000158931PA381PM645125PAN
14080000015895L14/scrutins1414080000015892140800000158932PA335017PM645607PSE
14080000015910L14/scrutins1414080000015908140800000159091PA381PM645125PAN
14080000015914L14/scrutins1414080000015908140800000159131PA609016PM645074PSE
14080000015920L14/scrutins1414080000015918140800000159191PA381PM645125PAN
14080000015924L14/scrutins1414080000015918140800000159231PA609016PM645074PSE
14080000015933L14/scrutins1414080000015931140800000159321PA381PM645125PAN
14080000015944L14/scrutins1414080000015942140800000159431PA381PM645125PAN
14080000015948L14/scrutins1414080000015942140800000159471PA609016PM645074PSE
14080000015955L14/scrutins1414080000015953140800000159541PA381PM645125PAN
14080000015959L14/scrutins1414080000015953140800000159581PA609016PM645074PSE
14080000015965L14/scrutins1414080000015963140800000159641PA381PM645125PAN
14080000015969L14/scrutins1414080000015963140800000159681PA609016PM645074PSE
14080000015976L14/scrutins1414080000015974140800000159751PA381PM645125PAN
14080000015980L14/scrutins1414080000015974140800000159791PA609016PM645074PSE
14080000015987L14/scrutins1414080000015985140800000159861PA381PM645125PAN
14080000015991L14/scrutins1414080000015985140800000159901PA609016PM645074PSE
14080000015998L14/scrutins1414080000015996140800000159971PA381PM645125PAN
14080000016002L14/scrutins1414080000015996140800000160011PA609016PM645074PSE
14080000016008L14/scrutins1414080000016006140800000160071PA381PM645125PAN
14080000016012L14/scrutins1414080000016006140800000160111PA609016PM645074PSE
14080000016019L14/scrutins1414080000016017140800000160181PA381PM645125PAN
14080000016021L14/scrutins1414080000016017140800000160201PA267797PM645350PSE
14080000016033L14/scrutins1414080000016031140800000160321PA381PM645125PAN
14080000016037L14/scrutins1414080000016031140800000160361PA267797PM645350PSE
14080000016045L14/scrutins1414080000016043140800000160441PA381PM645125PAN
14080000016047L14/scrutins1414080000016043140800000160461PA267797PM645350PSE
14080000016055L14/scrutins1414080000016053140800000160541PA381PM645125PAN
14080000016057L14/scrutins1414080000016053140800000160561PA267797PM645350PSE
14080000016067L14/scrutins1414080000016065140800000160661PA381PM645125PAN
14080000016069L14/scrutins1414080000016065140800000160681PA267797PM645350PSE
14080000016077L14/scrutins1414080000016075140800000160761PA381PM645125PAN
14080000016079L14/scrutins1414080000016075140800000160781PA267797PM645350PSE
14080000016090L14/scrutins1414080000016088140800000160891PA381PM645125PAN
14080000016092L14/scrutins1414080000016088140800000160911PA267797PM645350PSE
14080000016101L14/scrutins1414080000016099140800000161001PA381PM645125PAN
14080000016103L14/scrutins1414080000016099140800000161021PA267797PM645350PSE
14080000016111L14/scrutins1414080000016109140800000161101PA381PM645125PAN
14080000016112L14/scrutins1414080000016109140800000161102PA335319PM645070PSE
14080000016121L14/scrutins1414080000016119140800000161201PA381PM645125PAN
14080000016122L14/scrutins1414080000016119140800000161202PA335319PM645070PSE
14080000016131L14/scrutins1414080000016129140800000161301PA381PM645125PAN
14080000016132L14/scrutins1414080000016129140800000161302PA335319PM645070PSE
14080000016143L14/scrutins1414080000016141140800000161421PA381PM645125PAN