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
16080000377719L16/scrutins1616080000377688160800003777181PA719874PM796674PSE
16080000377875L16/scrutins1616080000377744160800003778741PA609590PM797742PSE
16080000377942L16/scrutins1616080000377911160800003779411PA719874PM796674PSE
16080000378068L16/scrutins1616080000377967160800003780671PA720908PM797556PSE
16080000378202L16/scrutins1616080000378080160800003782011PA720908PM797556PSE
16080000378341L16/scrutins1616080000378220160800003783401PA720908PM797556PSE
16080000378520L16/scrutins1616080000378359160800003785191PA720908PM797556PSE
16080000378729L16/scrutins1616080000378556160800003787281PA720908PM797556PSE
16080000378873L16/scrutins1616080000378769160800003788721PA720908PM797556PSE
16080000379000L16/scrutins1616080000378885160800003789991PA719874PM796674PSE
16080000379177L16/scrutins1616080000379044160800003791761PA719874PM796674PSE
16080000379340L16/scrutins1616080000379218160800003793391PA719874PM796674PSE
16080000379501L16/scrutins1616080000379374160800003795001PA609590PM797742PSE
16080000379645L16/scrutins1616080000379528160800003796441PA719874PM796674PSE
16080000379796L16/scrutins1616080000379679160800003797951PA719874PM796674PSE
16080000379961L16/scrutins1616080000379831160800003799601PA719874PM796674PSE
16080000380132L16/scrutins1616080000379998160800003801311PA719874PM796674PSE
16080000380312L16/scrutins1616080000380162160800003803111PA719874PM796674PSE
16080000380425L16/scrutins1616080000380358160800003804241PA719874PM796674PSE
16080000380534L16/scrutins1616080000380458160800003805331PA719874PM796674PSE
16080000380644L16/scrutins1616080000380566160800003806431PA719874PM796674PSE
16080000380757L16/scrutins1616080000380676160800003807561PA719874PM796674PSE
16080000380862L16/scrutins1616080000380789160800003808611PA719874PM796674PSE
16080000380898L16/scrutins1616080000380896160800003808971PA721908PM797568PSE
16080000381188L16/scrutins1616080000381092160800003811871PA719874PM796674PSE
16080000381330L16/scrutins1616080000381226160800003813291PA719874PM796674PSE
16080000381493L16/scrutins1616080000381374160800003814921PA719874PM796674PSE
16080000381659L16/scrutins1616080000381540160800003816581PA719874PM796674PSE
16080000381830L16/scrutins1616080000381705160800003818291PA719874PM796674PSE
16080000382005L16/scrutins1616080000381883160800003820041PA719874PM796674PSE
16080000382178L16/scrutins1616080000382052160800003821771PA719874PM796674PSE
16080000382351L16/scrutins1616080000382228160800003823501PA719874PM796674PSE
16080000382525L16/scrutins1616080000382405160800003825241PA719874PM796674PSE
16080000382702L16/scrutins1616080000382575160800003827011PA719874PM796674PSE
16080000382759L16/scrutins1616080000382757160800003827581PA721908PM797568PSE
16080000383072L16/scrutins1616080000382947160800003830711PA719874PM796674PSE
16080000383248L16/scrutins1616080000383127160800003832471PA719874PM796674PSE
16080000383419L16/scrutins1616080000383300160800003834181PA719874PM796674PSE
16080000383591L16/scrutins1616080000383471160800003835901PA719874PM796674PSE
16080000383761L16/scrutins1616080000383642160800003837601PA719874PM796674PSE
16080000383932L16/scrutins1616080000383812160800003839311PA719874PM796674PSE
16080000384103L16/scrutins1616080000383985160800003841021PA719874PM796674PSE
16080000384236L16/scrutins1616080000384158160800003842351PA719874PM796674PSE
16080000384351L16/scrutins1616080000384277160800003843501PA719874PM796674PSE
16080000384498L16/scrutins1616080000384396160800003844971PA719874PM796674PSE
16080000384544L16/scrutins1616080000384542160800003845431PA721908PM797568PSE
16080000384822L16/scrutins1616080000384715160800003848211PA719874PM796674PSE
16080000384979L16/scrutins1616080000384870160800003849781PA719874PM796674PSE
16080000385133L16/scrutins1616080000385029160800003851321PA719874PM796674PSE
16080000385286L16/scrutins1616080000385178160800003852851PA719874PM796674PSE