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
16080000400728L16/scrutins1616080000400696160800004007271PA794354PM796869PSE
16080000400816L16/scrutins1616080000400781160800004008151PA794354PM796869PSE
16080000400908L16/scrutins1616080000400873160800004009071PA794354PM796869PSE
16080000400983L16/scrutins1616080000400949160800004009821PA794354PM796869PSE
16080000401071L16/scrutins1616080000401041160800004010701PA794354PM796869PSE
16080000401227L16/scrutins1616080000401128160800004012261PA794354PM796869PSE
16080000401476L16/scrutins1616080000401443160800004014751PA794354PM796869PSE
16080000401578L16/scrutins1616080000401534160800004015771PA720286PM796878PSE
16080000401665L16/scrutins1616080000401621160800004016641PA720286PM796878PSE
16080000401751L16/scrutins1616080000401707160800004017501PA720286PM796878PSE
16080000401852L16/scrutins1616080000401804160800004018511PA720286PM796878PSE
16080000401959L16/scrutins1616080000401904160800004019581PA720286PM796878PSE
16080000402062L16/scrutins1616080000402006160800004020611PA720286PM796878PSE
16080000402172L16/scrutins1616080000402113160800004021711PA720286PM796878PSE
16080000402280L16/scrutins1616080000402225160800004022791PA720286PM796878PSE
16080000402377L16/scrutins1616080000402322160800004023761PA720286PM796878PSE
16080000402507L16/scrutins1616080000402419160800004025061PA794354PM796869PSE
16080000402748L16/scrutins1616080000402689160800004027471PA720286PM796878PSE
16080000402850L16/scrutins1616080000402791160800004028491PA720286PM796878PSE
16080000402959L16/scrutins1616080000402902160800004029581PA720286PM796878PSE
16080000403070L16/scrutins1616080000403015160800004030691PA720286PM796878PSE
16080000403182L16/scrutins1616080000403125160800004031811PA720286PM796878PSE
16080000403293L16/scrutins1616080000403236160800004032921PA720286PM796878PSE
16080000403404L16/scrutins1616080000403348160800004034031PA720286PM796878PSE
16080000403503L16/scrutins1616080000403451160800004035021PA720286PM796878PSE
16080000403613L16/scrutins1616080000403556160800004036121PA720286PM796878PSE
16080000404320L16/scrutins1616080000404234160800004043191PA794354PM796869PSE
16080000404629L16/scrutins1616080000404520160800004046281PA719874PM796674PSE
16080000404764L16/scrutins1616080000404680160800004047631PA719874PM796674PSE
16080000404871L16/scrutins1616080000404793160800004048701PA719874PM796674PSE
16080000404972L16/scrutins1616080000404897160800004049711PA719874PM796674PSE
16080000405072L16/scrutins1616080000404996160800004050711PA719874PM796674PSE
16080000405172L16/scrutins1616080000405095160800004051711PA719874PM796674PSE
16080000405365L16/scrutins1616080000405198160800004053641PA720908PM797556PSE
16080000405469L16/scrutins1616080000405395160800004054681PA720908PM797556PSE
16080000405568L16/scrutins1616080000405482160800004055671PA720908PM797556PSE
16080000405666L16/scrutins1616080000405581160800004056651PA720908PM797556PSE
16080000405908L16/scrutins1616080000405679160800004059071PA719874PM796674PSE
16080000406083L16/scrutins1616080000405998160800004060821PA794354PM796869PSE
16080000406372L16/scrutins1616080000406286160800004063711PA720908PM797556PSE
16080000406467L16/scrutins1616080000406385160800004064661PA720908PM797556PSE
16080000406556L16/scrutins1616080000406480160800004065551PA720908PM797556PSE
16080000406651L16/scrutins1616080000406570160800004066501PA720908PM797556PSE
16080000406751L16/scrutins1616080000406667160800004067501PA720908PM797556PSE
16080000406860L16/scrutins1616080000406767160800004068591PA720908PM797556PSE
16080000406924L16/scrutins1616080000406881160800004069231PA720286PM796878PSE
16080000407030L16/scrutins1616080000406982160800004070291PA720286PM796878PSE
16080000407135L16/scrutins1616080000407088160800004071341PA720286PM796878PSE
16080000407215L16/scrutins1616080000407191160800004072141PA720468PM796983PSE
16080000407312L16/scrutins1616080000407238160800004073111PA794354PM796869PSE