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
15080000003407L15/scrutins1515080000003405150800000034061PA332747PM722798PAN
15080000003408L15/scrutins1515080000003405150800000034062PA721824PM723394PSE
15080000003545L15/scrutins1515080000003543150800000035441PA332747PM722798PAN
15080000003546L15/scrutins1515080000003543150800000035442PA721824PM723394PSE
15080000003689L15/scrutins1515080000003687150800000036881PA332747PM722798PAN
15080000003690L15/scrutins1515080000003687150800000036882PA721824PM723394PSE
15080000003821L15/scrutins1515080000003819150800000038201PA332747PM722798PSE
15080000004022L15/scrutins1515080000004020150800000040211PA332747PM722798PAN
15080000004023L15/scrutins1515080000004020150800000040212PA721824PM723394PSE
15080000004138L15/scrutins1515080000004136150800000041371PA332747PM722798PSE
15080000004251L15/scrutins1515080000004249150800000042501PA332747PM722798PSE
15080000004375L15/scrutins1515080000004373150800000043741PA332747PM722798PSE
15080000004519L15/scrutins1515080000004517150800000045181PA332747PM722798PSE
15080000004675L15/scrutins1515080000004673150800000046741PA332747PM722798PSE
15080000004829L15/scrutins1515080000004827150800000048281PA332747PM722798PAN
15080000004830L15/scrutins1515080000004827150800000048282PA720622PM723018PSE
15080000004945L15/scrutins1515080000004943150800000049441PA332747PM722798PSE
15080000005023L15/scrutins1515080000005021150800000050221PA332747PM722798PSE
15080000005115L15/scrutins1515080000005113150800000051141PA332747PM722798PSE
15080000005205L15/scrutins1515080000005203150800000052041PA332747PM722798PSE
15080000005587L15/scrutins1515080000005585150800000055861PA332747PM722798PSE
15080000005686L15/scrutins1515080000005684150800000056851PA332747PM722798PSE
15080000005806L15/scrutins1515080000005804150800000058051PA332747PM722798PSE
15080000005935L15/scrutins1515080000005933150800000059341PA332747PM722798PSE
15080000006023L15/scrutins1515080000006021150800000060221PA332747PM722798PSE
15080000006098L15/scrutins1515080000006096150800000060971PA332747PM722798PSE
15080000006199L15/scrutins1515080000006197150800000061981PA332747PM722798PAN
15080000006200L15/scrutins1515080000006197150800000061982PA720622PM723018PSE
15080000006282L15/scrutins1515080000006280150800000062811PA332747PM722798PAN
15080000006283L15/scrutins1515080000006280150800000062812PA720622PM723018PSE
15080000006365L15/scrutins1515080000006363150800000063641PA332747PM722798PAN
15080000006366L15/scrutins1515080000006363150800000063642PA720622PM723018PSE
15080000006417L15/scrutins1515080000006415150800000064161PA332747PM722798PAN
15080000006418L15/scrutins1515080000006415150800000064162PA720622PM723018PSE
15080000006474L15/scrutins1515080000006472150800000064731PA332747PM722798PSE
15080000006856L15/scrutins1515080000006854150800000068551PA332747PM722798PSE
15080000006921L15/scrutins1515080000006919150800000069201PA332747PM722798PSE
15080000007001L15/scrutins1515080000006999150800000070001PA332747PM722798PAN
15080000007002L15/scrutins1515080000006999150800000070002PA720622PM723018PSE
15080000007071L15/scrutins1515080000007069150800000070701PA332747PM722798PSE
15080000007182L15/scrutins1515080000007180150800000071811PA332747PM722798PSE
15080000007293L15/scrutins1515080000007291150800000072921PA332747PM722798PSE
15080000007408L15/scrutins1515080000007406150800000074071PA332747PM722798PSE
15080000007522L15/scrutins1515080000007520150800000075211PA332747PM722798PSE
15080000007621L15/scrutins1515080000007619150800000076201PA332747PM722798PSE
15080000007707L15/scrutins1515080000007705150800000077061PA332747PM722798PSE
15080000007777L15/scrutins1515080000007775150800000077761PA332747PM722798PSE
15080000008090L15/scrutins1515080000008088150800000080891PA332747PM722798PSE
15080000008221L15/scrutins1515080000008219150800000082201PA332747PM722798PSE
15080000008410L15/scrutins1515080000008408150800000084091PA332747PM722798PSE