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
17080000094499L17/scrutins1717080000094472170800000944981PA721908PM843467False402PAN
17080000094631L17/scrutins1717080000094604170800000946301PA721908PM843467False402PAN
17080000094765L17/scrutins1717080000094739170800000947641PA721908PM843467False402PAN
17080000094895L17/scrutins1717080000094872170800000948941PA721908PM843467False402PAN
17080000095045L17/scrutins1717080000094998170800000950441PA721908PM843467False402PSE
17080000095134L17/scrutins1717080000094998170800000951331PA643089PM843431False206MG
17080000095168L17/scrutins1717080000094998170800000951671PA720480PM843101False245MG
17080000095214L17/scrutins1717080000095186170800000952131PA721908PM843467False402PAN
17080000095255L17/scrutins1717080000095186170800000952541PA795310PM840453False634PSE
17080000095364L17/scrutins1717080000095340170800000953631PA721908PM843467False402PAN
17080000095499L17/scrutins1717080000095475170800000954981PA721908PM843467False402PAN
17080000095635L17/scrutins1717080000095610170800000956341PA721908PM843467False402PAN
17080000095790L17/scrutins1717080000095752170800000957891PA721908PM843467False402PAN
17080000095859L17/scrutins1717080000095752170800000958581PA794022PM842777False509PSE
17080000095957L17/scrutins1717080000095894170800000959561PA721908PM843467False402PAN
17080000096058L17/scrutins1717080000095894170800000960571PA794022PM842777False509PSE
17080000096187L17/scrutins1717080000096121170800000961861PA721908PM843467False402PAN
17080000096257L17/scrutins1717080000096121170800000962561PA794022PM842777False509PSE
17080000096383L17/scrutins1717080000096315170800000963821PA721908PM843467False402PAN
17080000096467L17/scrutins1717080000096315170800000964661PA794022PM842777False509PSE
17080000096594L17/scrutins1717080000096523170800000965931PA721908PM843467False402PAN
17080000096680L17/scrutins1717080000096523170800000966791PA794022PM842777False509PSE
17080000096802L17/scrutins1717080000096735170800000968011PA721908PM843467False402PAN
17080000096889L17/scrutins1717080000096735170800000968881PA794022PM842777False509PSE
17080000096988L17/scrutins1717080000096945170800000969871PA721908PM843467False402PSE
17080000097075L17/scrutins1717080000096945170800000970741PA643089PM843431False206MG
17080000097106L17/scrutins1717080000096945170800000971051PA720480PM843101False245MG
17080000097193L17/scrutins1717080000097125170800000971921PA721908PM843467False402PAN
17080000097282L17/scrutins1717080000097125170800000972811PA794022PM842777False509PSE
17080000097410L17/scrutins1717080000097340170800000974091PA721908PM843467False402PAN
17080000097498L17/scrutins1717080000097340170800000974971PA794022PM842777False509PSE
17080000097616L17/scrutins1717080000097555170800000976151PA721908PM843467False402PAN
17080000097703L17/scrutins1717080000097555170800000977021PA794022PM842777False509PSE
17080000097827L17/scrutins1717080000097754170800000978261PA721908PM843467False402PAN
17080000097924L17/scrutins1717080000097754170800000979231PA794022PM842777False509PSE
17080000098055L17/scrutins1717080000097982170800000980541PA721908PM843467False402PAN
17080000098151L17/scrutins1717080000097982170800000981501PA794022PM842777False509PSE
17080000098280L17/scrutins1717080000098207170800000982791PA721908PM843467False402PAN
17080000098388L17/scrutins1717080000098207170800000983871PA794022PM842777False509PSE
17080000098528L17/scrutins1717080000098449170800000985271PA721908PM843467False402PAN
17080000098634L17/scrutins1717080000098449170800000986331PA794022PM842777False509PSE
17080000098781L17/scrutins1717080000098698170800000987801PA721908PM843467False402PAN
17080000098885L17/scrutins1717080000098698170800000988841PA794022PM842777False509PSE
17080000099035L17/scrutins1717080000098952170800000990341PA721908PM843467False402PAN
17080000099137L17/scrutins1717080000098952170800000991361PA794022PM842777False509PSE
17080000099288L17/scrutins1717080000099204170800000992871PA721908PM843467False402PAN
17080000099397L17/scrutins1717080000099204170800000993961PA794022PM842777False509PSE
17080000099511L17/scrutins1717080000099464170800000995101PA721908PM843467False402PSE
17080000099600L17/scrutins1717080000099464170800000995991PA643089PM843431False206MG
17080000099634L17/scrutins1717080000099464170800000996331PA720480PM843101False245MG