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
17080000022396L17/scrutins1717080000022351170800000223942PA721908PM843467False402PAN
17080000022503L17/scrutins1717080000022459170800000225021PA721134PM843797False268PSE
17080000022504L17/scrutins1717080000022459170800000225022PA721908PM843467False402PAN
17080000022610L17/scrutins1717080000022568170800000226091PA721134PM843797False268PSE
17080000022611L17/scrutins1717080000022568170800000226092PA721908PM843467False402PAN
17080000022724L17/scrutins1717080000022680170800000227231PA721134PM843797False268PSE
17080000022725L17/scrutins1717080000022680170800000227232PA721908PM843467False402PAN
17080000022834L17/scrutins1717080000022791170800000228331PA721134PM843797False268PSE
17080000022835L17/scrutins1717080000022791170800000228332PA721908PM843467False402PAN
17080000022947L17/scrutins1717080000022904170800000229461PA721134PM843797False268PSE
17080000022948L17/scrutins1717080000022904170800000229462PA721908PM843467False402PAN
17080000023058L17/scrutins1717080000023015170800000230571PA721134PM843797False268PSE
17080000023059L17/scrutins1717080000023015170800000230572PA721908PM843467False402PAN
17080000023168L17/scrutins1717080000023128170800000231671PA721134PM843797False268PSE
17080000023169L17/scrutins1717080000023128170800000231672PA721908PM843467False402PAN
17080000023273L17/scrutins1717080000023235170800000232721PA721134PM843797False268PSE
17080000023274L17/scrutins1717080000023235170800000232722PA721908PM843467False402PAN
17080000023365L17/scrutins1717080000023339170800000233641PA721908PM843467False402PAN
17080000023394L17/scrutins1717080000023339170800000233931PA330008PM842366False171PSE
17080000023502L17/scrutins1717080000023428170800000235011PA721908PM843467False402PAN
17080000023599L17/scrutins1717080000023428170800000235981PA643089PM843431False206MG
17080000023633L17/scrutins1717080000023428170800000236321PA720908PM843701False221PSE
17080000023634L17/scrutins1717080000023428170800000236322PA720480PM843101False245MG
17080000023685L17/scrutins1717080000023659170800000236841PA721908PM843467False402PAN
17080000023722L17/scrutins1717080000023659170800000237211PA330008PM842366False171PSE
17080000023788L17/scrutins1717080000023759170800000237871PA721908PM843467False402PAN
17080000023824L17/scrutins1717080000023759170800000238231PA330008PM842366False171PSE
17080000023898L17/scrutins1717080000023866170800000238971PA721908PM843467False402PAN
17080000023942L17/scrutins1717080000023866170800000239411PA330008PM842366False171PSE
17080000024006L17/scrutins1717080000023980170800000240051PA721908PM843467False402PAN
17080000024053L17/scrutins1717080000023980170800000240521PA330008PM842366False171PSE
17080000024116L17/scrutins1717080000024086170800000241151PA721908PM843467False402PAN
17080000024167L17/scrutins1717080000024086170800000241661PA330008PM842366False171PSE
17080000024233L17/scrutins1717080000024203170800000242321PA721908PM843467False402PAN
17080000024284L17/scrutins1717080000024203170800000242831PA330008PM842366False171PSE
17080000024351L17/scrutins1717080000024318170800000243501PA721908PM843467False402PAN
17080000024396L17/scrutins1717080000024318170800000243951PA330008PM842366False171PSE
17080000024462L17/scrutins1717080000024430170800000244611PA721908PM843467False402PAN
17080000024507L17/scrutins1717080000024430170800000245061PA330008PM842366False171PSE
17080000024576L17/scrutins1717080000024542170800000245751PA721908PM843467False402PAN
17080000024623L17/scrutins1717080000024542170800000246221PA330008PM842366False171PSE
17080000024694L17/scrutins1717080000024660170800000246931PA721908PM843467False402PAN
17080000024740L17/scrutins1717080000024660170800000247391PA330008PM842366False171PSE
17080000024852L17/scrutins1717080000024780170800000248511PA721908PM843467False402PAN
17080000024947L17/scrutins1717080000024780170800000249461PA643089PM843431False206MG
17080000024976L17/scrutins1717080000024780170800000249751PA720908PM843701False221PSE
17080000024977L17/scrutins1717080000024780170800000249752PA720480PM843101False245MG
17080000025037L17/scrutins1717080000025002170800000250361PA721908PM843467False402PAN
17080000025076L17/scrutins1717080000025002170800000250751PA330008PM842366False171PSE
17080000025152L17/scrutins1717080000025116170800000251511PA721908PM843467False402PAN