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
17080000477040L17/scrutins1717080000476831170800004770382PA720908PM843701False318MG
17080000477051L17/scrutins1717080000476831170800004770501PA793210PM842417False454MG
17080000477138L17/scrutins1717080000477068170800004771371PA721908PM843467False402PAN
17080000477149L17/scrutins1717080000477068170800004771481PA795228PM840447False627PSE
17080000477276L17/scrutins1717080000477215170800004772751PA795950PM843419False389MG
17080000477277L17/scrutins1717080000477215170800004772752PA721908PM843467False402PAN
17080000477278L17/scrutins1717080000477215170800004772753PA795990PM856036False322MG
17080000477279L17/scrutins1717080000477215170800004772754PA795330PM843800False259MG
17080000477280L17/scrutins1717080000477215170800004772755PA795386PM843695False284MG
17080000477281L17/scrutins1717080000477215170800004772756PA721134PM843797False368MG
17080000477282L17/scrutins1717080000477215170800004772757PA720066PM842933False298MG
17080000477377L17/scrutins1717080000477215170800004773761PA1327PM842747False304MG
17080000477378L17/scrutins1717080000477215170800004773762PA842117PM843635False184MG
17080000477379L17/scrutins1717080000477215170800004773763PA870010PM870011False084MG
17080000477401L17/scrutins1717080000477215170800004774001PA719024PM842390False344PSE
17080000477402L17/scrutins1717080000477215170800004774002PA795120PM858429False360MG
17080000477419L17/scrutins1717080000477215170800004774181PA794426PM842993False239MG
17080000477420L17/scrutins1717080000477215170800004774182PA720908PM843701False318MG
17080000477432L17/scrutins1717080000477215170800004774311PA793210PM842417False454MG
17080000477516L17/scrutins1717080000477452170800004775151PA795950PM843419False389MG
17080000477517L17/scrutins1717080000477452170800004775152PA721908PM843467False402PAN
17080000477518L17/scrutins1717080000477452170800004775153PA795990PM856036False322MG
17080000477519L17/scrutins1717080000477452170800004775154PA795330PM843800False259MG
17080000477520L17/scrutins1717080000477452170800004775155PA795386PM843695False284MG
17080000477521L17/scrutins1717080000477452170800004775156PA721134PM843797False368MG
17080000477522L17/scrutins1717080000477452170800004775157PA720066PM842933False298MG
17080000477627L17/scrutins1717080000477452170800004776261PA1327PM842747False304MG
17080000477628L17/scrutins1717080000477452170800004776262PA842117PM843635False184MG
17080000477629L17/scrutins1717080000477452170800004776263PA870010PM870011False084MG
17080000477651L17/scrutins1717080000477452170800004776501PA719024PM842390False344PSE
17080000477652L17/scrutins1717080000477452170800004776502PA795120PM858429False360MG
17080000477668L17/scrutins1717080000477452170800004776671PA794426PM842993False239MG
17080000477669L17/scrutins1717080000477452170800004776672PA720908PM843701False318MG
17080000477682L17/scrutins1717080000477452170800004776811PA793210PM842417False454MG
17080000477767L17/scrutins1717080000477701170800004777661PA795950PM843419False389MG
17080000477768L17/scrutins1717080000477701170800004777662PA721908PM843467False402PAN
17080000477769L17/scrutins1717080000477701170800004777663PA795990PM856036False322MG
17080000477770L17/scrutins1717080000477701170800004777664PA795330PM843800False259MG
17080000477771L17/scrutins1717080000477701170800004777665PA795386PM843695False284MG
17080000477772L17/scrutins1717080000477701170800004777666PA721134PM843797False368MG
17080000477773L17/scrutins1717080000477701170800004777667PA720066PM842933False298MG
17080000477881L17/scrutins1717080000477701170800004778801PA1327PM842747False304MG
17080000477882L17/scrutins1717080000477701170800004778802PA842117PM843635False184MG
17080000477883L17/scrutins1717080000477701170800004778803PA870010PM870011False084MG
17080000477907L17/scrutins1717080000477701170800004779061PA719024PM842390False344PSE
17080000477908L17/scrutins1717080000477701170800004779062PA795120PM858429False360MG
17080000477920L17/scrutins1717080000477701170800004779191PA794426PM842993False239MG
17080000477921L17/scrutins1717080000477701170800004779192PA720908PM843701False318MG
17080000477936L17/scrutins1717080000477701170800004779351PA793210PM842417False454MG
17080000478032L17/scrutins1717080000477963170800004780311PA795950PM843419False389MG