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
16080000327005L16/scrutins1616080000326859160800003270041PA720286PM796878PSE
16080000327455L16/scrutins1616080000327101160800003274541PA720908PM797556PSE
16080000328239L16/scrutins1616080000328175160800003282381PA720468PM796983PSE
16080000328427L16/scrutins1616080000328363160800003284261PA720468PM796983PSE
16080000328608L16/scrutins1616080000328547160800003286071PA720468PM796983PSE
16080000328766L16/scrutins1616080000328706160800003287651PA720468PM796983PSE
16080000328915L16/scrutins1616080000328859160800003289141PA720468PM796983PSE
16080000329018L16/scrutins1616080000329016160800003290171PA721908PM797568PAN
16080000329212L16/scrutins1616080000329016160800003292111PA720908PM797556PSE
16080000329421L16/scrutins1616080000329256160800003294201PA720286PM796878PSE
16080000329564L16/scrutins1616080000329562160800003295631PA721908PM797568PAN
16080000329657L16/scrutins1616080000329562160800003296561PA720908PM797556PSE
16080000329736L16/scrutins1616080000329664160800003297351PA720908PM797556PSE
16080000329818L16/scrutins1616080000329747160800003298171PA720908PM797556PSE
16080000329904L16/scrutins1616080000329829160800003299031PA720908PM797556PSE
16080000329988L16/scrutins1616080000329917160800003299871PA720908PM797556PSE
16080000330071L16/scrutins1616080000330001160800003300701PA720908PM797556PSE
16080000330151L16/scrutins1616080000330083160800003301501PA720908PM797556PSE
16080000330227L16/scrutins1616080000330160160800003302261PA720908PM797556PSE
16080000330294L16/scrutins1616080000330238160800003302931PA720908PM797556PSE
16080000330361L16/scrutins1616080000330302160800003303601PA720908PM797556PSE
16080000330531L16/scrutins1616080000330369160800003305301PA720286PM796878PSE
16080000330719L16/scrutins1616080000330670160800003307181PA719874PM796674PSE
16080000330803L16/scrutins1616080000330738160800003308021PA719874PM796674PSE
16080000330898L16/scrutins1616080000330831160800003308971PA719874PM796674PSE
16080000330989L16/scrutins1616080000330924160800003309881PA719874PM796674PSE
16080000331076L16/scrutins1616080000331014160800003310751PA719874PM796674PSE
16080000331148L16/scrutins1616080000331101160800003311471PA609590PM797742PSE
16080000331226L16/scrutins1616080000331161160800003312251PA609590PM797742PSE
16080000331301L16/scrutins1616080000331238160800003313001PA609590PM797742PSE
16080000331334L16/scrutins1616080000331312160800003313331PA720468PM796983PSE
16080000331413L16/scrutins1616080000331386160800003314121PA720468PM796983PSE
16080000331616L16/scrutins1616080000331453160800003316151PA720286PM796878PSE
16080000331786L16/scrutins1616080000331759160800003317851PA720468PM796983PSE
16080000331860L16/scrutins1616080000331836160800003318591PA720468PM796983PSE
16080000331941L16/scrutins1616080000331916160800003319401PA720468PM796983PSE
16080000332015L16/scrutins1616080000331994160800003320141PA720468PM796983PSE
16080000332081L16/scrutins1616080000332050160800003320801PA609590PM797742PSE
16080000332144L16/scrutins1616080000332092160800003321431PA609590PM797742PSE
16080000332203L16/scrutins1616080000332157160800003322021PA609590PM797742PSE
16080000332273L16/scrutins1616080000332216160800003322721PA609590PM797742PSE
16080000332364L16/scrutins1616080000332284160800003323631PA609590PM797742PSE
16080000332459L16/scrutins1616080000332377160800003324581PA609590PM797742PSE
16080000332637L16/scrutins1616080000332472160800003326361PA720286PM796878PSE
16080000332826L16/scrutins1616080000332768160800003328251PA609590PM797742PSE
16080000332898L16/scrutins1616080000332847160800003328971PA609590PM797742PSE
16080000332979L16/scrutins1616080000332913160800003329781PA609590PM797742PSE
16080000333068L16/scrutins1616080000332999160800003330671PA609590PM797742PSE
16080000333150L16/scrutins1616080000333089160800003331491PA609590PM797742PSE
16080000333233L16/scrutins1616080000333165160800003332321PA609590PM797742PSE