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
14080000000749L14/scrutins14140800000007321408000000073316PA267622PM645033MG
14080000000750L14/scrutins14140800000007321408000000073317PA268048PM645257MG
14080000000751L14/scrutins14140800000007321408000000073318PA590031PM645352MG
14080000000752L14/scrutins14140800000007321408000000073319PA333611PM645389MG
14080000000753L14/scrutins14140800000007321408000000073320PA332364PM645525MG
14080000000754L14/scrutins14140800000007321408000000073321PA335532PM645082MG
14080000000755L14/scrutins14140800000007321408000000073322PA335543PM645096MG
14080000000756L14/scrutins14140800000007321408000000073323PA331924PM645417MG
14080000000757L14/scrutins14140800000007321408000000073324PA335999PM645219MG
14080000000769L14/scrutins1414080000000732140800000007681PA588872PM645062MG
14080000000771L14/scrutins1414080000000732140800000007701PA336175PM645264MG
14080000000806L14/scrutins1414080000000804140800000008051PA328PM645184MG
14080000000807L14/scrutins1414080000000804140800000008052PA381PM645125PAN
14080000000808L14/scrutins1414080000000804140800000008053PA1268PM645112MG
14080000000809L14/scrutins1414080000000804140800000008054PA2912PM645085MG
14080000000810L14/scrutins1414080000000804140800000008055PA1816PM645051MG
14080000000811L14/scrutins1414080000000804140800000008056PA1893PM645245MG
14080000000812L14/scrutins1414080000000804140800000008057PA334160PM645133MG
14080000000813L14/scrutins1414080000000804140800000008058PA588886PM645620MG
14080000000814L14/scrutins1414080000000804140800000008059PA590032PM645180MG
14080000000815L14/scrutins14140800000008041408000000080510PA2825PM645568MG
14080000000816L14/scrutins14140800000008041408000000080511PA333285PM645365MG
14080000000817L14/scrutins14140800000008041408000000080512PA590034PM645519MG
14080000000818L14/scrutins14140800000008041408000000080513PA706PM645268MG
14080000000819L14/scrutins14140800000008041408000000080514PA785PM645345MG
14080000000820L14/scrutins14140800000008041408000000080515PA2240PM645077MG
14080000000821L14/scrutins14140800000008041408000000080516PA267622PM645033MG
14080000000822L14/scrutins14140800000008041408000000080517PA268048PM645257MG
14080000000823L14/scrutins14140800000008041408000000080518PA590031PM645352MG
14080000000824L14/scrutins14140800000008041408000000080519PA333611PM645389MG
14080000000825L14/scrutins14140800000008041408000000080520PA332364PM645525MG
14080000000826L14/scrutins14140800000008041408000000080521PA335532PM645082MG
14080000000827L14/scrutins14140800000008041408000000080522PA335543PM645096MG
14080000000828L14/scrutins14140800000008041408000000080523PA331924PM645417MG
14080000000829L14/scrutins14140800000008041408000000080524PA335319PM645070PSE
14080000000830L14/scrutins14140800000008041408000000080525PA335999PM645219MG
14080000000834L14/scrutins1414080000000804140800000008331PA588872PM645062MG
14080000000836L14/scrutins1414080000000804140800000008351PA336175PM645264MG
14080000000841L14/scrutins1414080000000839140800000008401PA328PM645184MG
14080000000842L14/scrutins1414080000000839140800000008402PA381PM645125PAN
14080000000843L14/scrutins1414080000000839140800000008403PA1268PM645112MG
14080000000844L14/scrutins1414080000000839140800000008404PA2912PM645085MG
14080000000845L14/scrutins1414080000000839140800000008405PA1816PM645051MG
14080000000846L14/scrutins1414080000000839140800000008406PA1893PM645245MG
14080000000847L14/scrutins1414080000000839140800000008407PA334160PM645133MG
14080000000848L14/scrutins1414080000000839140800000008408PA588886PM645620MG
14080000000849L14/scrutins1414080000000839140800000008409PA590032PM645180MG
14080000000850L14/scrutins14140800000008391408000000084010PA2825PM645568MG
14080000000851L14/scrutins14140800000008391408000000084011PA333285PM645365MG
14080000000852L14/scrutins14140800000008391408000000084012PA590034PM645519MG