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
17080000626921L17/scrutins1717080000626830170800006269201PA795228PM840447False627PSE
17080000627112L17/scrutins1717080000627028170800006271111PA721908PM843467False402PAN
17080000627238L17/scrutins1717080000627028170800006272371PA795270PM858399False217PSE
17080000627349L17/scrutins1717080000627266170800006273481PA721908PM843467False402PAN
17080000627474L17/scrutins1717080000627266170800006274731PA795270PM858399False217PSE
17080000627585L17/scrutins1717080000627502170800006275841PA721908PM843467False402PAN
17080000627712L17/scrutins1717080000627502170800006277111PA795270PM858399False217PSE
17080000627817L17/scrutins1717080000627741170800006278161PA721908PM843467False402PAN
17080000627949L17/scrutins1717080000627741170800006279481PA795270PM858399False217PSE
17080000628048L17/scrutins1717080000627974170800006280471PA721908PM843467False402PAN
17080000628168L17/scrutins1717080000627974170800006281671PA795270PM858399False217PSE
17080000628274L17/scrutins1717080000628193170800006282731PA721908PM843467False402PAN
17080000628383L17/scrutins1717080000628193170800006283821PA795270PM858399False217PSE
17080000628469L17/scrutins1717080000628411170800006284681PA721908PM843467False402PAN
17080000628550L17/scrutins1717080000628411170800006285491PA795270PM858399False217PSE
17080000628624L17/scrutins1717080000628570170800006286231PA721908PM843467False402PAN
17080000628718L17/scrutins1717080000628570170800006287171PA795270PM858399False217PSE
17080000628815L17/scrutins1717080000628743170800006288141PA721908PM843467False402PAN
17080000628915L17/scrutins1717080000628743170800006289141PA795270PM858399False217PSE
17080000629016L17/scrutins1717080000628938170800006290151PA721908PM843467False402PAN
17080000629122L17/scrutins1717080000628938170800006291211PA795270PM858399False217PSE
17080000629222L17/scrutins1717080000629150170800006292211PA721908PM843467False402PAN
17080000629240L17/scrutins1717080000629150170800006292391PA795228PM840447False627PSE
17080000629419L17/scrutins1717080000629346170800006294181PA721908PM843467False402PAN
17080000629522L17/scrutins1717080000629346170800006295211PA795270PM858399False217PSE
17080000629620L17/scrutins1717080000629547170800006296191PA721908PM843467False402PAN
17080000629722L17/scrutins1717080000629547170800006297211PA795270PM858399False217PSE
17080000629795L17/scrutins1717080000629747170800006297941PA721908PM843467False402PAN
17080000629881L17/scrutins1717080000629747170800006298801PA795270PM858399False217PSE
17080000629932L17/scrutins1717080000629894170800006299311PA721908PM843467False402PAN
17080000630023L17/scrutins1717080000629894170800006300221PA795270PM858399False217PSE
17080000630068L17/scrutins1717080000630037170800006300671PA721908PM843467False402PAN
17080000630079L17/scrutins1717080000630037170800006300781PA795228PM840447False627PSE
17080000630168L17/scrutins1717080000630128170800006301671PA721908PM843467False402PAN
17080000630181L17/scrutins1717080000630128170800006301801PA795228PM840447False627PSE
17080000630307L17/scrutins1717080000630261170800006303061PA721908PM843467False402PAN
17080000630451L17/scrutins1717080000630404170800006304501PA721908PM843467False402PAN
17080000630629L17/scrutins1717080000630573170800006306281PA721908PM843467False402PAN
17080000630815L17/scrutins1717080000630756170800006308141PA721908PM843467False402PAN
17080000631018L17/scrutins1717080000630943170800006310171PA721908PM843467False402PAN
17080000631036L17/scrutins1717080000630943170800006310351PA795228PM840447False627PSE
17080000631202L17/scrutins1717080000631142170800006312011PA721908PM843467False402PAN
17080000631227L17/scrutins1717080000631142170800006312261PA795228PM840447False627PSE
17080000631400L17/scrutins1717080000631336170800006313991PA721908PM843467False402PAN
17080000631596L17/scrutins1717080000631536170800006315951PA721908PM843467False402PAN
17080000631806L17/scrutins1717080000631738170800006318051PA721908PM843467False402PAN
17080000632025L17/scrutins1717080000631954170800006320241PA721908PM843467False402PAN
17080000632058L17/scrutins1717080000631954170800006320571PA795228PM840447False627PSE
17080000632243L17/scrutins1717080000632171170800006322421PA721908PM843467False402PAN
17080000632465L17/scrutins1717080000632393170800006324641PA721908PM843467False402PAN