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
16080000121616L16/scrutins1616080000121518160800001216151PA720908PM797556PSE
16080000121850L16/scrutins1616080000121630160800001218491PA720286PM796878PSE
16080000122110L16/scrutins1616080000122015160800001221091PA720908PM797556PSE
16080000122213L16/scrutins1616080000122124160800001222121PA720908PM797556PSE
16080000122507L16/scrutins1616080000122227160800001225061PA719874PM796674PSE
16080000122975L16/scrutins1616080000122595160800001229741PA719874PM796674PSE
16080000123250L16/scrutins1616080000123147160800001232491PA719874PM796674PSE
16080000123345L16/scrutins1616080000123276160800001233441PA719874PM796674PSE
16080000123463L16/scrutins1616080000123365160800001234621PA719874PM796674PSE
16080000123603L16/scrutins1616080000123485160800001236021PA719874PM796674PSE
16080000123752L16/scrutins1616080000123634160800001237511PA719874PM796674PSE
16080000123906L16/scrutins1616080000123784160800001239051PA719874PM796674PSE
16080000124158L16/scrutins1616080000123936160800001241571PA720286PM796878PSE
16080000124470L16/scrutins1616080000124326160800001244691PA719874PM796674PSE
16080000124661L16/scrutins1616080000124507160800001246601PA719874PM796674PSE
16080000124850L16/scrutins1616080000124697160800001248491PA719874PM796674PSE
16080000125045L16/scrutins1616080000124890160800001250441PA719874PM796674PSE
16080000125249L16/scrutins1616080000125079160800001252481PA719874PM796674PSE
16080000125463L16/scrutins1616080000125297160800001254621PA719874PM796674PSE
16080000125668L16/scrutins1616080000125506160800001256671PA719874PM796674PSE
16080000125853L16/scrutins1616080000125711160800001258521PA719874PM796674PSE
16080000126027L16/scrutins1616080000125885160800001260261PA719874PM796674PSE
16080000126200L16/scrutins1616080000126059160800001261991PA719874PM796674PSE
16080000126452L16/scrutins1616080000126229160800001264511PA720286PM796878PSE
16080000126782L16/scrutins1616080000126628160800001267811PA720908PM797556PSE
16080000126951L16/scrutins1616080000126798160800001269501PA720908PM797556PSE
16080000127123L16/scrutins1616080000126967160800001271221PA720908PM797556PSE
16080000127296L16/scrutins1616080000127139160800001272951PA720908PM797556PSE
16080000127468L16/scrutins1616080000127313160800001274671PA720908PM797556PSE
16080000127642L16/scrutins1616080000127486160800001276411PA720908PM797556PSE
16080000127814L16/scrutins1616080000127660160800001278131PA720908PM797556PSE
16080000127957L16/scrutins1616080000127830160800001279561PA720908PM797556PSE
16080000128103L16/scrutins1616080000127973160800001281021PA720908PM797556PSE
16080000128239L16/scrutins1616080000128122160800001282381PA720908PM797556PSE
16080000128464L16/scrutins1616080000128256160800001284631PA720286PM796878PSE
16080000128739L16/scrutins1616080000128633160800001287381PA720908PM797556PSE
16080000128867L16/scrutins1616080000128757160800001288661PA720908PM797556PSE
16080000128985L16/scrutins1616080000128884160800001289841PA720908PM797556PSE
16080000129142L16/scrutins1616080000129004160800001291411PA720908PM797556PSE
16080000129296L16/scrutins1616080000129157160800001292951PA720908PM797556PSE
16080000129434L16/scrutins1616080000129310160800001294331PA720908PM797556PSE
16080000129572L16/scrutins1616080000129449160800001295711PA720908PM797556PSE
16080000129709L16/scrutins1616080000129586160800001297081PA720908PM797556PSE
16080000129845L16/scrutins1616080000129720160800001298441PA720908PM797556PSE
16080000129982L16/scrutins1616080000129859160800001299811PA720908PM797556PSE
16080000130204L16/scrutins1616080000129996160800001302031PA720286PM796878PSE
16080000130486L16/scrutins1616080000130362160800001304851PA720908PM797556PSE
16080000130611L16/scrutins1616080000130500160800001306101PA720908PM797556PSE
16080000130707L16/scrutins1616080000130625160800001307061PA720908PM797556PSE
16080000130804L16/scrutins1616080000130719160800001308031PA720908PM797556PSE