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
14080000009780L14/scrutins1414080000009778140800000097791PA381PM645125PAN
14080000009781L14/scrutins1414080000009778140800000097792PA1198PM645393PSE
14080000009794L14/scrutins1414080000009792140800000097931PA381PM645125PAN
14080000009795L14/scrutins1414080000009792140800000097932PA1198PM645393PSE
14080000009804L14/scrutins1414080000009802140800000098031PA381PM645125PAN
14080000009805L14/scrutins1414080000009802140800000098032PA1198PM645393PSE
14080000009814L14/scrutins1414080000009812140800000098131PA381PM645125PAN
14080000009815L14/scrutins1414080000009812140800000098132PA1198PM645393PSE
14080000009824L14/scrutins1414080000009822140800000098231PA381PM645125PAN
14080000009825L14/scrutins1414080000009822140800000098232PA1198PM645393PSE
14080000009834L14/scrutins1414080000009832140800000098331PA381PM645125PAN
14080000009835L14/scrutins1414080000009832140800000098332PA1198PM645393PSE
14080000009844L14/scrutins1414080000009842140800000098431PA381PM645125PAN
14080000009845L14/scrutins1414080000009842140800000098432PA1198PM645393PSE
14080000009856L14/scrutins1414080000009854140800000098551PA381PM645125PAN
14080000009857L14/scrutins1414080000009854140800000098552PA1198PM645393PSE
14080000009866L14/scrutins1414080000009864140800000098651PA381PM645125PAN
14080000009867L14/scrutins1414080000009864140800000098652PA1198PM645393PSE
14080000009876L14/scrutins1414080000009874140800000098751PA381PM645125PAN
14080000009877L14/scrutins1414080000009874140800000098752PA1198PM645393PSE
14080000009886L14/scrutins1414080000009884140800000098851PA381PM645125PAN
14080000009887L14/scrutins1414080000009884140800000098852PA1198PM645393PSE
14080000009896L14/scrutins1414080000009894140800000098951PA381PM645125PAN
14080000009897L14/scrutins1414080000009894140800000098952PA1198PM645393PSE
14080000009906L14/scrutins1414080000009904140800000099051PA381PM645125PSE
14080000009916L14/scrutins1414080000009914140800000099151PA381PM645125PSE
14080000009925L14/scrutins1414080000009923140800000099241PA381PM645125PSE
14080000009936L14/scrutins1414080000009934140800000099351PA381PM645125PSE
14080000009946L14/scrutins1414080000009944140800000099451PA381PM645125PSE
14080000009956L14/scrutins1414080000009954140800000099551PA381PM645125PSE
14080000009991L14/scrutins1414080000009989140800000099901PA381PM645125PSE
14080000010000L14/scrutins1414080000009998140800000099991PA381PM645125PSE
14080000010009L14/scrutins1414080000010007140800000100081PA381PM645125PSE
14080000010020L14/scrutins1414080000010018140800000100191PA381PM645125PAN
14080000010022L14/scrutins1414080000010018140800000100211PA267797PM645350PSE
14080000010030L14/scrutins1414080000010028140800000100291PA381PM645125PAN
14080000010032L14/scrutins1414080000010028140800000100311PA267797PM645350PSE
14080000010040L14/scrutins1414080000010038140800000100391PA381PM645125PAN
14080000010042L14/scrutins1414080000010038140800000100411PA267797PM645350PSE
14080000010050L14/scrutins1414080000010048140800000100491PA381PM645125PAN
14080000010052L14/scrutins1414080000010048140800000100511PA267797PM645350PSE
14080000010060L14/scrutins1414080000010058140800000100591PA381PM645125PAN
14080000010062L14/scrutins1414080000010058140800000100611PA267797PM645350PSE
14080000010070L14/scrutins1414080000010068140800000100691PA381PM645125PAN
14080000010072L14/scrutins1414080000010068140800000100711PA267797PM645350PSE
14080000010080L14/scrutins1414080000010078140800000100791PA381PM645125PAN
14080000010082L14/scrutins1414080000010078140800000100811PA267797PM645350PSE
14080000010090L14/scrutins1414080000010088140800000100891PA381PM645125PAN
14080000010092L14/scrutins1414080000010088140800000100911PA267797PM645350PSE
14080000010100L14/scrutins1414080000010098140800000100991PA381PM645125PAN