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
17080000478747L17/scrutins1717080000478684170800004787407PA720066PM842933False298MG
17080000478828L17/scrutins1717080000478684170800004788271PA1327PM842747False304MG
17080000478829L17/scrutins1717080000478684170800004788272PA842117PM843635False184MG
17080000478830L17/scrutins1717080000478684170800004788273PA870010PM870011False084MG
17080000478849L17/scrutins1717080000478684170800004788481PA719024PM842390False344PSE
17080000478850L17/scrutins1717080000478684170800004788482PA795120PM858429False360MG
17080000478864L17/scrutins1717080000478684170800004788631PA794426PM842993False239MG
17080000478865L17/scrutins1717080000478684170800004788632PA720908PM843701False318MG
17080000478874L17/scrutins1717080000478684170800004788731PA793210PM842417False454MG
17080000478945L17/scrutins1717080000478888170800004789441PA795950PM843419False389MG
17080000478946L17/scrutins1717080000478888170800004789442PA721908PM843467False402PAN
17080000478947L17/scrutins1717080000478888170800004789443PA795990PM856036False322MG
17080000478948L17/scrutins1717080000478888170800004789444PA795330PM843800False259MG
17080000478949L17/scrutins1717080000478888170800004789445PA795386PM843695False284MG
17080000478950L17/scrutins1717080000478888170800004789446PA721134PM843797False368MG
17080000478951L17/scrutins1717080000478888170800004789447PA720066PM842933False298MG
17080000479034L17/scrutins1717080000478888170800004790331PA1327PM842747False304MG
17080000479035L17/scrutins1717080000478888170800004790332PA842117PM843635False184MG
17080000479036L17/scrutins1717080000478888170800004790333PA870010PM870011False084MG
17080000479055L17/scrutins1717080000478888170800004790541PA719024PM842390False344PSE
17080000479056L17/scrutins1717080000478888170800004790542PA795120PM858429False360MG
17080000479070L17/scrutins1717080000478888170800004790691PA794426PM842993False239MG
17080000479071L17/scrutins1717080000478888170800004790692PA720908PM843701False318MG
17080000479081L17/scrutins1717080000478888170800004790801PA793210PM842417False454MG
17080000479097L17/scrutins1717080000479095170800004790961PA794354PM842960False100PSE
17080000479143L17/scrutins1717080000479095170800004791421PA795950PM843419False389MG
17080000479144L17/scrutins1717080000479095170800004791422PA721908PM843467False402PAN
17080000479145L17/scrutins1717080000479095170800004791423PA795990PM856036False322MG
17080000479146L17/scrutins1717080000479095170800004791424PA795330PM843800False259MG
17080000479147L17/scrutins1717080000479095170800004791425PA795386PM843695False284MG
17080000479148L17/scrutins1717080000479095170800004791426PA721134PM843797False368MG
17080000479149L17/scrutins1717080000479095170800004791427PA720066PM842933False298MG
17080000479197L17/scrutins1717080000479095170800004791961PA1327PM842747False304MG
17080000479198L17/scrutins1717080000479095170800004791962PA842117PM843635False184MG
17080000479199L17/scrutins1717080000479095170800004791963PA870010PM870011False084MG
17080000479215L17/scrutins1717080000479095170800004792141PA795120PM858429False360MG
17080000479227L17/scrutins1717080000479095170800004792261PA794426PM842993False239MG
17080000479228L17/scrutins1717080000479095170800004792262PA720908PM843701False318MG
17080000479238L17/scrutins1717080000479095170800004792371PA793210PM842417False454MG
17080000479253L17/scrutins1717080000479251170800004792521PA794354PM842960False100PSE
17080000479302L17/scrutins1717080000479251170800004793011PA795950PM843419False389MG
17080000479303L17/scrutins1717080000479251170800004793012PA721908PM843467False402PAN
17080000479304L17/scrutins1717080000479251170800004793013PA795990PM856036False322MG
17080000479305L17/scrutins1717080000479251170800004793014PA795330PM843800False259MG
17080000479306L17/scrutins1717080000479251170800004793015PA795386PM843695False284MG
17080000479307L17/scrutins1717080000479251170800004793016PA721134PM843797False368MG
17080000479308L17/scrutins1717080000479251170800004793017PA720066PM842933False298MG
17080000479358L17/scrutins1717080000479251170800004793571PA1327PM842747False304MG
17080000479359L17/scrutins1717080000479251170800004793572PA842117PM843635False184MG
17080000479360L17/scrutins1717080000479251170800004793573PA870010PM870011False084MG