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
16080000337643L16/scrutins1616080000337624160800003376421PA720468PM796983PSE
16080000337710L16/scrutins1616080000337690160800003377091PA720468PM796983PSE
16080000337761L16/scrutins1616080000337759160800003377601PA721908PM797568PSE
16080000337868L16/scrutins1616080000337866160800003378671PA721908PM797568PSE
16080000337950L16/scrutins1616080000337948160800003379491PA721908PM797568PSE
16080000338041L16/scrutins1616080000338039160800003380401PA721908PM797568PSE
16080000338158L16/scrutins1616080000338156160800003381571PA721908PM797568PSE
16080000338265L16/scrutins1616080000338263160800003382641PA721908PM797568PSE
16080000338389L16/scrutins1616080000338387160800003383881PA721908PM797568PSE
16080000338511L16/scrutins1616080000338509160800003385101PA721908PM797568PSE
16080000338792L16/scrutins1616080000338561160800003387911PA719874PM796674PSE
16080000339006L16/scrutins1616080000338882160800003390051PA720286PM796878PSE
16080000339115L16/scrutins1616080000339113160800003391141PA721908PM797568PSE
16080000339245L16/scrutins1616080000339243160800003392441PA721908PM797568PSE
16080000339347L16/scrutins1616080000339345160800003393461PA721908PM797568PSE
16080000339444L16/scrutins1616080000339442160800003394431PA721908PM797568PSE
16080000339543L16/scrutins1616080000339541160800003395421PA721908PM797568PSE
16080000339648L16/scrutins1616080000339646160800003396471PA721908PM797568PSE
16080000339739L16/scrutins1616080000339737160800003397381PA721908PM797568PSE
16080000339920L16/scrutins1616080000339831160800003399191PA720286PM796878PSE
16080000340097L16/scrutins1616080000340007160800003400961PA720286PM796878PSE
16080000340233L16/scrutins1616080000340184160800003402321PA794354PM796869PSE
16080000340564L16/scrutins1616080000340511160800003405631PA794354PM796869PSE
16080000340740L16/scrutins1616080000340685160800003407391PA794354PM796869PSE
16080000340884L16/scrutins1616080000340829160800003408831PA794354PM796869PSE
16080000341030L16/scrutins1616080000340974160800003410291PA794354PM796869PSE
16080000341181L16/scrutins1616080000341119160800003411801PA794354PM796869PSE
16080000341349L16/scrutins1616080000341288160800003413481PA794354PM796869PSE
16080000341520L16/scrutins1616080000341460160800003415191PA794354PM796869PSE
16080000341685L16/scrutins1616080000341624160800003416841PA794354PM796869PSE
16080000341847L16/scrutins1616080000341784160800003418461PA794354PM796869PSE
16080000342016L16/scrutins1616080000341956160800003420151PA794354PM796869PSE
16080000342458L16/scrutins1616080000342398160800003424571PA794354PM796869PSE
16080000342622L16/scrutins1616080000342561160800003426211PA794354PM796869PSE
16080000342819L16/scrutins1616080000342765160800003428181PA794354PM796869PSE
16080000342969L16/scrutins1616080000342914160800003429681PA794354PM796869PSE
16080000343148L16/scrutins1616080000343067160800003431471PA720286PM796878PSE
16080000343309L16/scrutins1616080000343223160800003433081PA720286PM796878PSE
16080000343456L16/scrutins1616080000343386160800003434551PA720286PM796878PSE
16080000343576L16/scrutins1616080000343502160800003435751PA720286PM796878PSE
16080000343671L16/scrutins1616080000343618160800003436701PA720286PM796878PSE
16080000343810L16/scrutins1616080000343746160800003438091PA720286PM796878PSE
16080000344178L16/scrutins1616080000344139160800003441771PA720286PM796878PSE
16080000344285L16/scrutins1616080000344231160800003442841PA720286PM796878PSE
16080000344399L16/scrutins1616080000344343160800003443981PA720286PM796878PSE
16080000344533L16/scrutins1616080000344469160800003445321PA720286PM796878PSE
16080000344638L16/scrutins1616080000344575160800003446371PA720286PM796878PSE
16080000344778L16/scrutins1616080000344709160800003447771PA720286PM796878PSE
16080000344917L16/scrutins1616080000344849160800003449161PA720286PM796878PSE
16080000345051L16/scrutins1616080000344988160800003450501PA720286PM796878PSE