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
16080000414056L16/scrutins1616080000413959160800004140551PA720286PM796878PSE
16080000414213L16/scrutins1616080000414116160800004142121PA720286PM796878PSE
16080000414395L16/scrutins1616080000414281160800004143941PA720286PM796878PSE
16080000414562L16/scrutins1616080000414448160800004145611PA720286PM796878PSE
16080000414757L16/scrutins1616080000414642160800004147561PA720286PM796878PSE
16080000415123L16/scrutins1616080000414835160800004151221PA720908PM797556PSE
16080000415282L16/scrutins1616080000415171160800004152811PA720286PM796878PSE
16080000415456L16/scrutins1616080000415349160800004154551PA720286PM796878PSE
16080000415599L16/scrutins1616080000415531160800004155981PA794354PM796869PSE
16080000415767L16/scrutins1616080000415699160800004157661PA794354PM796869PSE
16080000415939L16/scrutins1616080000415868160800004159381PA794354PM796869PSE
16080000416129L16/scrutins1616080000416051160800004161281PA794354PM796869PSE
16080000416601L16/scrutins1616080000416292160800004166001PA720908PM797556PSE
16080000416951L16/scrutins1616080000416642160800004169501PA720908PM797556PSE
16080000417212L16/scrutins1616080000416995160800004172111PA720908PM797556PSE
16080000417337L16/scrutins1616080000417244160800004173361PA720908PM797556PSE
16080000417569L16/scrutins1616080000417346160800004175681PA720908PM797556PSE
16080000417738L16/scrutins1616080000417615160800004177371PA720908PM797556PSE
16080000417905L16/scrutins1616080000417748160800004179041PA609590PM797742PSE
16080000418172L16/scrutins1616080000417973160800004181711PA609590PM797742PSE
16080000418895L16/scrutins1616080000418774160800004188941PA720908PM797556PSE
16080000419055L16/scrutins1616080000418930160800004190541PA720908PM797556PSE
16080000419232L16/scrutins1616080000419093160800004192311PA720908PM797556PSE
16080000419412L16/scrutins1616080000419271160800004194111PA720908PM797556PSE
16080000419574L16/scrutins1616080000419445160800004195731PA720908PM797556PSE
16080000419763L16/scrutins1616080000419606160800004197621PA609590PM797742PSE
16080000419932L16/scrutins1616080000419812160800004199311PA720908PM797556PSE
16080000420089L16/scrutins1616080000419965160800004200881PA720908PM797556PSE
16080000420275L16/scrutins1616080000420121160800004202741PA720908PM797556PSE
16080000420352L16/scrutins1616080000420317160800004203511PA794354PM796869PSE
16080000420461L16/scrutins1616080000420427160800004204601PA794354PM796869PSE
16080000420572L16/scrutins1616080000420536160800004205711PA794354PM796869PSE
16080000420715L16/scrutins1616080000420661160800004207141PA719874PM796674PSE
16080000420819L16/scrutins1616080000420770160800004208181PA719874PM796674PSE
16080000420935L16/scrutins1616080000420872160800004209341PA719874PM796674PSE
16080000421051L16/scrutins1616080000420992160800004210501PA719874PM796674PSE
16080000421257L16/scrutins1616080000421109160800004212561PA609590PM797742PSE
16080000421349L16/scrutins1616080000421288160800004213481PA719874PM796674PSE
16080000421471L16/scrutins1616080000421408160800004214701PA719874PM796674PSE
16080000421640L16/scrutins1616080000421533160800004216391PA720908PM797556PSE
16080000421770L16/scrutins1616080000421658160800004217691PA720908PM797556PSE
16080000421901L16/scrutins1616080000421789160800004219001PA720908PM797556PSE
16080000422044L16/scrutins1616080000421920160800004220431PA720908PM797556PSE
16080000422188L16/scrutins1616080000422064160800004221871PA720908PM797556PSE
16080000422318L16/scrutins1616080000422207160800004223171PA720908PM797556PSE
16080000422470L16/scrutins1616080000422337160800004224691PA720908PM797556PSE
16080000422627L16/scrutins1616080000422491160800004226261PA720908PM797556PSE
16080000422779L16/scrutins1616080000422649160800004227781PA720468PM796983PSE
16080000423258L16/scrutins1616080000423053160800004232571PA609590PM797742PSE
16080000423420L16/scrutins1616080000423291160800004234191PA720908PM797556PSE