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
16080000360607L16/scrutins1616080000360538160800003606061PA719874PM796674PSE
16080000360686L16/scrutins1616080000360632160800003606851PA719874PM796674PSE
16080000360764L16/scrutins1616080000360707160800003607631PA719874PM796674PSE
16080000360961L16/scrutins1616080000360787160800003609601PA609590PM797742PSE
16080000361048L16/scrutins1616080000360991160800003610471PA719874PM796674PSE
16080000361123L16/scrutins1616080000361069160800003611221PA719874PM796674PSE
16080000361199L16/scrutins1616080000361143160800003611981PA719874PM796674PSE
16080000361287L16/scrutins1616080000361222160800003612861PA719874PM796674PSE
16080000361388L16/scrutins1616080000361315160800003613871PA719874PM796674PSE
16080000361535L16/scrutins1616080000361417160800003615341PA719874PM796674PSE
16080000361579L16/scrutins1616080000361577160800003615781PA721908PM797568PSE
16080000362186L16/scrutins1616080000362036160800003621851PA720286PM796878PSE
16080000362774L16/scrutins1616080000362611160800003627731PA609590PM797742PSE
16080000362963L16/scrutins1616080000362801160800003629621PA609590PM797742PSE
16080000363054L16/scrutins1616080000362985160800003630531PA719874PM796674PSE
16080000363182L16/scrutins1616080000363083160800003631811PA719874PM796674PSE
16080000363295L16/scrutins1616080000363210160800003632941PA719874PM796674PSE
16080000363430L16/scrutins1616080000363324160800003634291PA719874PM796674PSE
16080000363559L16/scrutins1616080000363464160800003635581PA719874PM796674PSE
16080000363697L16/scrutins1616080000363592160800003636961PA719874PM796674PSE
16080000363822L16/scrutins1616080000363731160800003638211PA719874PM796674PSE
16080000363973L16/scrutins1616080000363857160800003639721PA719874PM796674PSE
16080000364130L16/scrutins1616080000364001160800003641291PA719874PM796674PSE
16080000364338L16/scrutins1616080000364168160800003643371PA609590PM797742PSE
16080000364483L16/scrutins1616080000364372160800003644821PA719874PM796674PSE
16080000364661L16/scrutins1616080000364520160800003646601PA719874PM796674PSE
16080000364840L16/scrutins1616080000364704160800003648391PA719874PM796674PSE
16080000364983L16/scrutins1616080000364876160800003649821PA719874PM796674PSE
16080000365152L16/scrutins1616080000365021160800003651511PA719874PM796674PSE
16080000365307L16/scrutins1616080000365193160800003653061PA719874PM796674PSE
16080000365461L16/scrutins1616080000365346160800003654601PA719874PM796674PSE
16080000365504L16/scrutins1616080000365502160800003655031PA721908PM797568PAN
16080000365584L16/scrutins1616080000365502160800003655831PA719874PM796674PSE
16080000365701L16/scrutins1616080000365661160800003657001PA720286PM796878PSE
16080000365782L16/scrutins1616080000365728160800003657811PA720286PM796878PSE
16080000365981L16/scrutins1616080000365814160800003659801PA609590PM797742PSE
16080000366081L16/scrutins1616080000366014160800003660801PA720286PM796878PSE
16080000366185L16/scrutins1616080000366120160800003661841PA720286PM796878PSE
16080000366300L16/scrutins1616080000366225160800003662991PA720286PM796878PSE
16080000366419L16/scrutins1616080000366341160800003664181PA720286PM796878PSE
16080000366526L16/scrutins1616080000366459160800003665251PA720286PM796878PSE
16080000366635L16/scrutins1616080000366567160800003666341PA720286PM796878PSE
16080000366745L16/scrutins1616080000366676160800003667441PA720286PM796878PSE
16080000366852L16/scrutins1616080000366788160800003668511PA720286PM796878PSE
16080000366950L16/scrutins1616080000366886160800003669491PA720286PM796878PSE
16080000367065L16/scrutins1616080000366989160800003670641PA720286PM796878PSE
16080000367300L16/scrutins1616080000367125160800003672991PA609590PM797742PSE
16080000367679L16/scrutins1616080000367586160800003676781PA720286PM796878PSE
16080000367949L16/scrutins1616080000367820160800003679481PA720286PM796878PSE
16080000368234L16/scrutins1616080000368104160800003682331PA720286PM796878PSE