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
14080000103427L14/scrutins1414080000103425140800001034261PA381PM645125PAN
14080000103450L14/scrutins1414080000103425140800001034491PA267797PM645350PSE
14080000103471L14/scrutins1414080000103469140800001034701PA381PM645125PAN
14080000103502L14/scrutins1414080000103469140800001035011PA267797PM645350PSE
14080000103537L14/scrutins1414080000103535140800001035361PA381PM645125PAN
14080000103572L14/scrutins1414080000103535140800001035711PA267797PM645350PSE
14080000103599L14/scrutins1414080000103597140800001035981PA381PM645125PAN
14080000103633L14/scrutins1414080000103597140800001036321PA267797PM645350PSE
14080000103660L14/scrutins1414080000103658140800001036591PA381PM645125PAN
14080000103715L14/scrutins1414080000103713140800001037141PA381PM645125PAN
14080000103751L14/scrutins1414080000103713140800001037501PA609016PM645074PSE
14080000103759L14/scrutins1414080000103757140800001037581PA381PM645125PAN
14080000103803L14/scrutins1414080000103801140800001038021PA381PM645125PAN
14080000103855L14/scrutins1414080000103801140800001038541PA609016PM645074PSE
14080000103868L14/scrutins1414080000103866140800001038671PA381PM645125PAN
14080000103937L14/scrutins1414080000103935140800001039361PA381PM645125PAN
14080000104001L14/scrutins1414080000103999140800001040001PA381PM645125PAN
14080000104048L14/scrutins1414080000104046140800001040471PA381PM645125PAN
14080000104073L14/scrutins1414080000104046140800001040721PA267797PM645350PSE
14080000104093L14/scrutins1414080000104091140800001040921PA381PM645125PAN
14080000104094L14/scrutins1414080000104091140800001040922PA335319PM645070PSE
14080000104126L14/scrutins1414080000104124140800001041251PA381PM645125PAN
14080000104127L14/scrutins1414080000104124140800001041252PA335319PM645070PSE
14080000104156L14/scrutins1414080000104154140800001041551PA381PM645125PAN
14080000104728L14/scrutins1414080000104726140800001047271PA381PM645125PAN
14080000104729L14/scrutins1414080000104726140800001047272PA1198PM645393PSE
14080000105010L14/scrutins1414080000105008140800001050091PA381PM645125PSE
14080000105107L14/scrutins1414080000105105140800001051061PA381PM645125PAN
14080000105378L14/scrutins1414080000105105140800001053771PA267797PM645350PSE
14080000105680L14/scrutins1414080000105678140800001056791PA381PM645125PAN
14080000105793L14/scrutins1414080000105791140800001057921PA381PM645125PAN
14080000106117L14/scrutins1414080000106115140800001061161PA381PM645125PAN
14080000106405L14/scrutins1414080000106403140800001064041PA381PM645125PSE
14080000106660L14/scrutins1414080000106658140800001066591PA381PM645125PAN
14080000106694L14/scrutins1414080000106658140800001066931PA1874PM645474PSE
14080000106734L14/scrutins1414080000106732140800001067331PA381PM645125PAN
14080000106770L14/scrutins1414080000106732140800001067691PA1874PM645474PSE
14080000106813L14/scrutins1414080000106811140800001068121PA381PM645125PAN
14080000106835L14/scrutins1414080000106833140800001068341PA381PM645125PSE
14080000107379L14/scrutins1414080000107377140800001073781PA381PM645125PSE
14080000107921L14/scrutins1414080000107919140800001079201PA381PM645125PAN
14080000107941L14/scrutins1414080000107919140800001079401PA1874PM645474PSE
14080000107965L14/scrutins1414080000107963140800001079641PA381PM645125PAN
14080000107986L14/scrutins1414080000107963140800001079851PA1874PM645474PSE
14080000108010L14/scrutins1414080000108008140800001080091PA381PM645125PAN
14080000108032L14/scrutins1414080000108008140800001080311PA1874PM645474PSE
14080000108056L14/scrutins1414080000108054140800001080551PA381PM645125PAN
14080000108070L14/scrutins1414080000108054140800001080691PA1874PM645474PSE
14080000108093L14/scrutins1414080000108091140800001080921PA381PM645125PAN
14080000108107L14/scrutins1414080000108091140800001081061PA1874PM645474PSE