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
17080000942106L17/scrutins1717080000942083170800009421051PA721908PM843467False380PSE
17080000942107L17/scrutins1717080000942083170800009421052PA720066PM878039False304MG
17080000942208L17/scrutins1717080000942186170800009422071PA721908PM843467False380PSE
17080000942209L17/scrutins1717080000942186170800009422072PA720066PM878039False304MG
17080000942298L17/scrutins1717080000942278170800009422971PA721908PM843467False380PSE
17080000942299L17/scrutins1717080000942278170800009422972PA720066PM878039False304MG
17080000942397L17/scrutins1717080000942377170800009423961PA721908PM843467False380PSE
17080000942398L17/scrutins1717080000942377170800009423962PA720066PM878039False304MG
17080000942495L17/scrutins1717080000942475170800009424941PA721908PM843467False380PSE
17080000942496L17/scrutins1717080000942475170800009424942PA720066PM878039False304MG
17080000942623L17/scrutins1717080000942576170800009426221PA607846PM843113False266MG
17080000942624L17/scrutins1717080000942576170800009426222PA722046PM843482False270MG
17080000942625L17/scrutins1717080000942576170800009426223PA717161PM842396False400MG
17080000942626L17/scrutins1717080000942576170800009426224PA721908PM843467False402PAN
17080000942637L17/scrutins1717080000942576170800009426361PA795310PM840453False634PSE
17080000942655L17/scrutins1717080000942576170800009426541PA608016PM843155False173MG
17080000942656L17/scrutins1717080000942576170800009426542PA794038PM842783False186MG
17080000942667L17/scrutins1717080000942576170800009426661PA605782PM842666False222MG
17080000942699L17/scrutins1717080000942679170800009426981PA721908PM843467False380PSE
17080000942700L17/scrutins1717080000942679170800009426982PA720066PM878039False304MG
17080000942795L17/scrutins1717080000942775170800009427941PA721908PM843467False380PSE
17080000942796L17/scrutins1717080000942775170800009427942PA720066PM878039False304MG
17080000942894L17/scrutins1717080000942873170800009428931PA721908PM843467False380PAN
17080000942895L17/scrutins1717080000942873170800009428932PA720066PM878039False304MG
17080000942995L17/scrutins1717080000942972170800009429941PA721908PM843467False380PAN
17080000942996L17/scrutins1717080000942972170800009429942PA720066PM878039False304MG
17080000943094L17/scrutins1717080000943071170800009430931PA721908PM843467False380PAN
17080000943095L17/scrutins1717080000943071170800009430932PA720066PM878039False304MG
17080000943204L17/scrutins1717080000943176170800009432031PA721908PM843467False380PAN
17080000943205L17/scrutins1717080000943176170800009432032PA720066PM878039False304MG
17080000943331L17/scrutins1717080000943303170800009433301PA721908PM843467False380PAN
17080000943332L17/scrutins1717080000943303170800009433302PA720066PM878039False304MG
17080000943454L17/scrutins1717080000943427170800009434531PA721908PM843467False380PAN
17080000943455L17/scrutins1717080000943427170800009434532PA720066PM878039False304MG
17080000943572L17/scrutins1717080000943546170800009435711PA721908PM843467False380PAN
17080000943573L17/scrutins1717080000943546170800009435712PA720066PM878039False304MG
17080000943673L17/scrutins1717080000943646170800009436721PA721908PM843467False380PAN
17080000943674L17/scrutins1717080000943646170800009436722PA720066PM878039False304MG
17080000943811L17/scrutins1717080000943751170800009438101PA607846PM843113False266MG
17080000943812L17/scrutins1717080000943751170800009438102PA722046PM843482False270MG
17080000943813L17/scrutins1717080000943751170800009438103PA717161PM842396False400MG
17080000943814L17/scrutins1717080000943751170800009438104PA721908PM843467False402PAN
17080000943832L17/scrutins1717080000943751170800009438311PA795310PM840453False634PSE
17080000943868L17/scrutins1717080000943751170800009438671PA608016PM843155False173MG
17080000943869L17/scrutins1717080000943751170800009438672PA794038PM842783False186MG
17080000943891L17/scrutins1717080000943751170800009438901PA605782PM842666False222MG
17080000943942L17/scrutins1717080000943914170800009439411PA721908PM843467False380PAN
17080000943943L17/scrutins1717080000943914170800009439412PA720066PM878039False304MG
17080000944057L17/scrutins1717080000944029170800009440561PA721908PM843467False380PAN
17080000944058L17/scrutins1717080000944029170800009440562PA720066PM878039False304MG