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
15080000199809L15/scrutins1515080000199752150800001998081PA720746PM723064PSE
15080000199839L15/scrutins1515080000199837150800001998381PA606171PM722632PAN
15080000199891L15/scrutins1515080000199837150800001998901PA720746PM723064PSE
15080000199918L15/scrutins1515080000199916150800001999171PA606171PM722632PAN
15080000199971L15/scrutins1515080000199916150800001999701PA720746PM723064PSE
15080000199998L15/scrutins1515080000199996150800001999971PA606171PM722632PAN
15080000200043L15/scrutins1515080000199996150800002000421PA720746PM723064PSE
15080000200072L15/scrutins1515080000200070150800002000711PA606171PM722632PAN
15080000200109L15/scrutins1515080000200070150800002001081PA720746PM723064PSE
15080000200136L15/scrutins1515080000200134150800002001351PA606171PM722632PAN
15080000200180L15/scrutins1515080000200134150800002001791PA720746PM723064PSE
15080000200210L15/scrutins1515080000200208150800002002091PA606171PM722632PAN
15080000200256L15/scrutins1515080000200208150800002002551PA720746PM723064PSE
15080000200287L15/scrutins1515080000200285150800002002861PA606171PM722632PAN
15080000200334L15/scrutins1515080000200285150800002003331PA720746PM723064PSE
15080000200365L15/scrutins1515080000200363150800002003641PA332747PM722798PSE
15080000200491L15/scrutins1515080000200489150800002004901PA606171PM722632PAN
15080000200515L15/scrutins1515080000200489150800002005141PA720746PM723064PSE
15080000200535L15/scrutins1515080000200533150800002005341PA606171PM722632PAN
15080000200584L15/scrutins1515080000200533150800002005831PA720746PM723064PSE
15080000200615L15/scrutins1515080000200613150800002006141PA606171PM722632PAN
15080000200665L15/scrutins1515080000200613150800002006641PA1592PM723060PSE
15080000200682L15/scrutins1515080000200680150800002006811PA606171PM722632PAN
15080000200750L15/scrutins1515080000200680150800002007491PA1592PM723060PSE
15080000200770L15/scrutins1515080000200768150800002007691PA606171PM722632PAN
15080000200835L15/scrutins1515080000200768150800002008341PA1592PM723060PSE
15080000200854L15/scrutins1515080000200852150800002008531PA606171PM722632PAN
15080000200919L15/scrutins1515080000200852150800002009181PA1592PM723060PSE
15080000200939L15/scrutins1515080000200937150800002009381PA606171PM722632PAN
15080000201004L15/scrutins1515080000200937150800002010031PA1592PM723060PSE
15080000201023L15/scrutins1515080000201021150800002010221PA606171PM722632PAN
15080000201090L15/scrutins1515080000201021150800002010891PA1592PM723060PSE
15080000201107L15/scrutins1515080000201105150800002011061PA606171PM722632PAN
15080000201161L15/scrutins1515080000201105150800002011601PA1592PM723060PSE
15080000201176L15/scrutins1515080000201174150800002011751PA606171PM722632PAN
15080000201219L15/scrutins1515080000201174150800002012181PA1592PM723060PSE
15080000201234L15/scrutins1515080000201232150800002012331PA332747PM722798PAN
15080000201329L15/scrutins1515080000201232150800002013281PA720746PM723064PSE
15080000201363L15/scrutins1515080000201361150800002013621PA332747PM722798PAN
15080000201364L15/scrutins1515080000201361150800002013622PA722150PM723486PSE
15080000201464L15/scrutins1515080000201462150800002014631PA606171PM722632PAN
15080000201534L15/scrutins1515080000201462150800002015331PA1592PM723060PSE
15080000201551L15/scrutins1515080000201549150800002015501PA606171PM722632PAN
15080000201623L15/scrutins1515080000201549150800002016221PA1592PM723060PSE
15080000201637L15/scrutins1515080000201635150800002016361PA606171PM722632PAN
15080000201706L15/scrutins1515080000201635150800002017051PA1592PM723060PSE
15080000201722L15/scrutins1515080000201720150800002017211PA606171PM722632PAN
15080000201788L15/scrutins1515080000201720150800002017871PA1592PM723060PSE
15080000201805L15/scrutins1515080000201803150800002018041PA606171PM722632PAN
15080000201876L15/scrutins1515080000201803150800002018751PA1592PM723060PSE