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
15080000507239L15/scrutins1515080000507203150800005072381PA720746PM723064PSE
15080000507254L15/scrutins1515080000507252150800005072531PA332747PM722798PAN
15080000507255L15/scrutins1515080000507252150800005072532PA719850PM722780PSE
15080000507394L15/scrutins1515080000507392150800005073931PA332747PM722798PAN
15080000507432L15/scrutins1515080000507392150800005074311PA720746PM723064PSE
15080000507449L15/scrutins1515080000507447150800005074481PA332747PM722798PAN
15080000507481L15/scrutins1515080000507447150800005074801PA720746PM723064PSE
15080000507497L15/scrutins1515080000507495150800005074961PA332747PM722798PAN
15080000507535L15/scrutins1515080000507495150800005075341PA720746PM723064PSE
15080000507551L15/scrutins1515080000507549150800005075501PA332747PM722798PAN
15080000507587L15/scrutins1515080000507549150800005075861PA720746PM723064PSE
15080000507605L15/scrutins1515080000507603150800005076041PA332747PM722798PAN
15080000507638L15/scrutins1515080000507603150800005076371PA720746PM723064PSE
15080000507653L15/scrutins1515080000507651150800005076521PA332747PM722798PAN
15080000507687L15/scrutins1515080000507651150800005076861PA720746PM723064PSE
15080000507700L15/scrutins1515080000507698150800005076991PA332747PM722798PAN
15080000507733L15/scrutins1515080000507698150800005077321PA720746PM723064PSE
15080000507749L15/scrutins1515080000507747150800005077481PA332747PM722798PAN
15080000507782L15/scrutins1515080000507747150800005077811PA720746PM723064PSE
15080000507799L15/scrutins1515080000507797150800005077981PA332747PM722798PAN
15080000507834L15/scrutins1515080000507797150800005078331PA720746PM723064PSE
15080000507847L15/scrutins1515080000507845150800005078461PA332747PM722798PAN
15080000507883L15/scrutins1515080000507845150800005078821PA720746PM723064PSE
15080000507899L15/scrutins1515080000507897150800005078981PA332747PM722798PAN
15080000507900L15/scrutins1515080000507897150800005078982PA719850PM722780PSE
15080000508056L15/scrutins1515080000508054150800005080551PA332747PM722798PAN
15080000508092L15/scrutins1515080000508054150800005080911PA720746PM723064PSE
15080000508108L15/scrutins1515080000508106150800005081071PA332747PM722798PAN
15080000508144L15/scrutins1515080000508106150800005081431PA720746PM723064PSE
15080000508160L15/scrutins1515080000508158150800005081591PA332747PM722798PAN
15080000508197L15/scrutins1515080000508158150800005081961PA720746PM723064PSE
15080000508214L15/scrutins1515080000508212150800005082131PA332747PM722798PAN
15080000508251L15/scrutins1515080000508212150800005082501PA720746PM723064PSE
15080000508268L15/scrutins1515080000508266150800005082671PA332747PM722798PAN
15080000508303L15/scrutins1515080000508266150800005083021PA720746PM723064PSE
15080000508322L15/scrutins1515080000508320150800005083211PA332747PM722798PAN
15080000508357L15/scrutins1515080000508320150800005083561PA720746PM723064PSE
15080000508375L15/scrutins1515080000508373150800005083741PA332747PM722798PAN
15080000508405L15/scrutins1515080000508373150800005084041PA720746PM723064PSE
15080000508421L15/scrutins1515080000508419150800005084201PA332747PM722798PAN
15080000508451L15/scrutins1515080000508419150800005084501PA720746PM723064PSE
15080000508468L15/scrutins1515080000508466150800005084671PA332747PM722798PAN
15080000508499L15/scrutins1515080000508466150800005084981PA720746PM723064PSE
15080000508515L15/scrutins1515080000508513150800005085141PA332747PM722798PAN
15080000508547L15/scrutins1515080000508513150800005085461PA720746PM723064PSE
15080000508563L15/scrutins1515080000508561150800005085621PA332747PM722798PAN
15080000508564L15/scrutins1515080000508561150800005085622PA719850PM722780PSE
15080000508727L15/scrutins1515080000508725150800005087261PA332747PM722798PAN
15080000508759L15/scrutins1515080000508725150800005087581PA720746PM723064PSE
15080000508775L15/scrutins1515080000508773150800005087741PA332747PM722798PAN