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
16080000236561L16/scrutins1616080000236445160800002365601PA720286PM796878PSE
16080000236833L16/scrutins1616080000236675160800002368321PA720286PM796878PSE
16080000237088L16/scrutins1616080000236979160800002370871PA720286PM796878PSE
16080000237275L16/scrutins1616080000237198160800002372741PA720286PM796878PSE
16080000237398L16/scrutins1616080000237320160800002373971PA720286PM796878PSE
16080000237515L16/scrutins1616080000237448160800002375141PA719874PM796674PSE
16080000237636L16/scrutins1616080000237562160800002376351PA720286PM796878PSE
16080000237753L16/scrutins1616080000237677160800002377521PA720286PM796878PSE
16080000237867L16/scrutins1616080000237789160800002378661PA720286PM796878PSE
16080000237982L16/scrutins1616080000237908160800002379811PA720286PM796878PSE
16080000238095L16/scrutins1616080000238018160800002380941PA720286PM796878PSE
16080000238197L16/scrutins1616080000238120160800002381961PA720286PM796878PSE
16080000238304L16/scrutins1616080000238224160800002383031PA720286PM796878PSE
16080000238413L16/scrutins1616080000238334160800002384121PA720286PM796878PSE
16080000238519L16/scrutins1616080000238440160800002385181PA720286PM796878PSE
16080000238637L16/scrutins1616080000238559160800002386361PA720286PM796878PSE
16080000238733L16/scrutins1616080000238678160800002387321PA719874PM796674PSE
16080000238857L16/scrutins1616080000238779160800002388561PA720286PM796878PSE
16080000238974L16/scrutins1616080000238898160800002389731PA720286PM796878PSE
16080000239084L16/scrutins1616080000239017160800002390831PA720286PM796878PSE
16080000239170L16/scrutins1616080000239112160800002391691PA609590PM797742PSE
16080000239317L16/scrutins1616080000239183160800002393161PA609590PM797742PSE
16080000239470L16/scrutins1616080000239335160800002394691PA609590PM797742PSE
16080000239617L16/scrutins1616080000239486160800002396161PA609590PM797742PSE
16080000239756L16/scrutins1616080000239628160800002397551PA609590PM797742PSE
16080000239895L16/scrutins1616080000239774160800002398941PA609590PM797742PSE
16080000239994L16/scrutins1616080000239913160800002399931PA609590PM797742PSE
16080000240054L16/scrutins1616080000240001160800002400531PA719874PM796674PSE
16080000240206L16/scrutins1616080000240105160800002402051PA609590PM797742PSE
16080000240330L16/scrutins1616080000240223160800002403291PA609590PM797742PSE
16080000240517L16/scrutins1616080000240460160800002405161PA609590PM797742PSE
16080000240588L16/scrutins1616080000240531160800002405871PA609590PM797742PSE
16080000240662L16/scrutins1616080000240602160800002406611PA609590PM797742PSE
16080000240737L16/scrutins1616080000240676160800002407361PA609590PM797742PSE
16080000240816L16/scrutins1616080000240752160800002408151PA609590PM797742PSE
16080000240895L16/scrutins1616080000240833160800002408941PA609590PM797742PSE
16080000240972L16/scrutins1616080000240910160800002409711PA609590PM797742PSE
16080000241057L16/scrutins1616080000240987160800002410561PA720908PM797556PSE
16080000241144L16/scrutins1616080000241078160800002411431PA609590PM797742PSE
16080000241227L16/scrutins1616080000241158160800002412261PA609590PM797742PSE
16080000241313L16/scrutins1616080000241242160800002413121PA609590PM797742PSE
16080000241397L16/scrutins1616080000241327160800002413961PA609590PM797742PSE
16080000241480L16/scrutins1616080000241410160800002414791PA609590PM797742PSE
16080000241564L16/scrutins1616080000241495160800002415631PA609590PM797742PSE
16080000241642L16/scrutins1616080000241579160800002416411PA609590PM797742PSE
16080000241717L16/scrutins1616080000241656160800002417161PA609590PM797742PSE
16080000241798L16/scrutins1616080000241732160800002417971PA609590PM797742PSE
16080000241887L16/scrutins1616080000241814160800002418861PA609590PM797742PSE
16080000242154L16/scrutins1616080000241906160800002421531PA720908PM797556PSE
16080000242261L16/scrutins1616080000242198160800002422601PA720908PM797556PSE