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 323 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
17080000077985L17/scrutins1717080000077960170800000779832PA721908PM843467False402PAN
17080000078087L17/scrutins1717080000078063170800000780861PA721134PM843797False268PSE
17080000078088L17/scrutins1717080000078063170800000780862PA721908PM843467False402PAN
17080000078193L17/scrutins1717080000078166170800000781921PA721134PM843797False268PSE
17080000078194L17/scrutins1717080000078166170800000781922PA721908PM843467False402PAN
17080000078341L17/scrutins1717080000078273170800000783401PA721908PM843467False402PSE
17080000078437L17/scrutins1717080000078273170800000784361PA643089PM843431False206MG
17080000078469L17/scrutins1717080000078273170800000784681PA720480PM843101False245MG
17080000078513L17/scrutins1717080000078489170800000785121PA721134PM843797False268PSE
17080000078514L17/scrutins1717080000078489170800000785122PA721908PM843467False402PAN
17080000078609L17/scrutins1717080000078585170800000786081PA721134PM843797False268PSE
17080000078610L17/scrutins1717080000078585170800000786082PA721908PM843467False402PAN
17080000078701L17/scrutins1717080000078681170800000787001PA721134PM843797False268PSE
17080000078702L17/scrutins1717080000078681170800000787002PA721908PM843467False402PAN
17080000078797L17/scrutins1717080000078770170800000787961PA721134PM843797False268PSE
17080000078798L17/scrutins1717080000078770170800000787962PA721908PM843467False402PAN
17080000078897L17/scrutins1717080000078874170800000788961PA721134PM843797False268PSE
17080000078898L17/scrutins1717080000078874170800000788962PA721908PM843467False402PAN
17080000078983L17/scrutins1717080000078960170800000789821PA721134PM843797False268PSE
17080000078984L17/scrutins1717080000078960170800000789822PA721908PM843467False402PAN
17080000079072L17/scrutins1717080000079053170800000790711PA721134PM843797False268PSE
17080000079073L17/scrutins1717080000079053170800000790712PA721908PM843467False402PAN
17080000079156L17/scrutins1717080000079137170800000791551PA721134PM843797False268PSE
17080000079157L17/scrutins1717080000079137170800000791552PA721908PM843467False402PAN
17080000079239L17/scrutins1717080000079220170800000792381PA721134PM843797False268PSE
17080000079240L17/scrutins1717080000079220170800000792382PA721908PM843467False402PAN
17080000079322L17/scrutins1717080000079302170800000793211PA721134PM843797False268PSE
17080000079323L17/scrutins1717080000079302170800000793212PA721908PM843467False402PAN
17080000079455L17/scrutins1717080000079387170800000794541PA721908PM843467False402PSE
17080000079548L17/scrutins1717080000079387170800000795471PA643089PM843431False206MG
17080000079581L17/scrutins1717080000079387170800000795801PA720480PM843101False245MG
17080000079619L17/scrutins1717080000079599170800000796181PA721134PM843797False268PSE
17080000079620L17/scrutins1717080000079599170800000796182PA721908PM843467False402PAN
17080000079709L17/scrutins1717080000079687170800000797081PA721134PM843797False268PSE
17080000079710L17/scrutins1717080000079687170800000797082PA721908PM843467False402PAN
17080000079803L17/scrutins1717080000079779170800000798021PA721134PM843797False268PSE
17080000079804L17/scrutins1717080000079779170800000798022PA721908PM843467False402PAN
17080000079903L17/scrutins1717080000079879170800000799021PA721134PM843797False268PSE
17080000079904L17/scrutins1717080000079879170800000799022PA721908PM843467False402PAN
17080000080001L17/scrutins1717080000079979170800000800001PA721134PM843797False268PSE
17080000080002L17/scrutins1717080000079979170800000800002PA721908PM843467False402PAN
17080000080097L17/scrutins1717080000080075170800000800961PA721134PM843797False268PSE
17080000080098L17/scrutins1717080000080075170800000800962PA721908PM843467False402PAN
17080000080196L17/scrutins1717080000080174170800000801951PA721134PM843797False268PSE
17080000080197L17/scrutins1717080000080174170800000801952PA721908PM843467False402PAN
17080000080285L17/scrutins1717080000080268170800000802841PA721134PM843797False268PSE
17080000080286L17/scrutins1717080000080268170800000802842PA721908PM843467False402PAN
17080000080351L17/scrutins1717080000080330170800000803501PA721134PM843797False268PSE
17080000080352L17/scrutins1717080000080330170800000803502PA721908PM843467False402PAN
17080000080435L17/scrutins1717080000080414170800000804341PA721134PM843797False268PSE