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
16080000298449L16/scrutins1616080000298429160800002984481PA794354PM796869PSE
16080000298766L16/scrutins1616080000298492160800002987651PA720908PM797556PSE
16080000298857L16/scrutins1616080000298816160800002988561PA794354PM796869PSE
16080000298963L16/scrutins1616080000298917160800002989621PA794354PM796869PSE
16080000299078L16/scrutins1616080000299032160800002990771PA794354PM796869PSE
16080000299205L16/scrutins1616080000299153160800002992041PA794354PM796869PSE
16080000299374L16/scrutins1616080000299284160800002993731PA794354PM796869PSE
16080000299637L16/scrutins1616080000299562160800002996361PA794354PM796869PSE
16080000299871L16/scrutins1616080000299798160800002998701PA794354PM796869PSE
16080000300081L16/scrutins1616080000300009160800003000801PA794354PM796869PSE
16080000300293L16/scrutins1616080000300225160800003002921PA794354PM796869PSE
16080000300489L16/scrutins1616080000300420160800003004881PA794354PM796869PSE
16080000300856L16/scrutins1616080000300624160800003008551PA720908PM797556PSE
16080000300949L16/scrutins1616080000300885160800003009481PA794354PM796869PSE
16080000301094L16/scrutins1616080000301058160800003010931PA720286PM796878PSE
16080000301175L16/scrutins1616080000301134160800003011741PA720286PM796878PSE
16080000301277L16/scrutins1616080000301215160800003012761PA720286PM796878PSE
16080000301420L16/scrutins1616080000301344160800003014191PA720286PM796878PSE
16080000301576L16/scrutins1616080000301497160800003015751PA720286PM796878PSE
16080000301739L16/scrutins1616080000301657160800003017381PA720286PM796878PSE
16080000301905L16/scrutins1616080000301823160800003019041PA720286PM796878PSE
16080000302078L16/scrutins1616080000301992160800003020771PA720286PM796878PSE
16080000302259L16/scrutins1616080000302169160800003022581PA720286PM796878PSE
16080000302592L16/scrutins1616080000302360160800003025911PA720908PM797556PSE
16080000302713L16/scrutins1616080000302621160800003027121PA720286PM796878PSE
16080000302912L16/scrutins1616080000302819160800003029111PA720286PM796878PSE
16080000303124L16/scrutins1616080000303016160800003031231PA720286PM796878PSE
16080000303335L16/scrutins1616080000303226160800003033341PA720286PM796878PSE
16080000303558L16/scrutins1616080000303439160800003035571PA720286PM796878PSE
16080000303786L16/scrutins1616080000303658160800003037851PA720908PM797556PSE
16080000303948L16/scrutins1616080000303808160800003039471PA720908PM797556PSE
16080000304112L16/scrutins1616080000303969160800003041111PA720908PM797556PSE
16080000304258L16/scrutins1616080000304136160800003042571PA720908PM797556PSE
16080000304401L16/scrutins1616080000304278160800003044001PA720908PM797556PSE
16080000304617L16/scrutins1616080000304422160800003046161PA609590PM797742PSE
16080000304767L16/scrutins1616080000304660160800003047661PA720908PM797556PSE
16080000304894L16/scrutins1616080000304785160800003048931PA720908PM797556PSE
16080000305000L16/scrutins1616080000304914160800003049991PA720908PM797556PSE
16080000305053L16/scrutins1616080000305013160800003050521PA720286PM796878PSE
16080000305115L16/scrutins1616080000305075160800003051141PA720286PM796878PSE
16080000305177L16/scrutins1616080000305137160800003051761PA720286PM796878PSE
16080000305241L16/scrutins1616080000305199160800003052401PA720286PM796878PSE
16080000305311L16/scrutins1616080000305269160800003053101PA720286PM796878PSE
16080000305366L16/scrutins1616080000305339160800003053651PA720286PM796878PSE
16080000305435L16/scrutins1616080000305396160800003054341PA720286PM796878PSE
16080000305691L16/scrutins1616080000305471160800003056901PA609590PM797742PSE
16080000305784L16/scrutins1616080000305741160800003057831PA720286PM796878PSE
16080000305888L16/scrutins1616080000305823160800003058871PA720286PM796878PSE
16080000306002L16/scrutins1616080000305938160800003060011PA720286PM796878PSE
16080000306112L16/scrutins1616080000306049160800003061111PA720286PM796878PSE