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
14080000000950L14/scrutins1414080000000940140800000009419PA590032PM645180MG
14080000000951L14/scrutins14140800000009401408000000094110PA2825PM645568MG
14080000000952L14/scrutins14140800000009401408000000094111PA333285PM645365MG
14080000000953L14/scrutins14140800000009401408000000094112PA590034PM645519MG
14080000000954L14/scrutins14140800000009401408000000094113PA706PM645268MG
14080000000955L14/scrutins14140800000009401408000000094114PA785PM645345MG
14080000000956L14/scrutins14140800000009401408000000094115PA2240PM645077MG
14080000000957L14/scrutins14140800000009401408000000094116PA267622PM645033MG
14080000000958L14/scrutins14140800000009401408000000094117PA268048PM645257MG
14080000000959L14/scrutins14140800000009401408000000094118PA590031PM645352MG
14080000000960L14/scrutins14140800000009401408000000094119PA333611PM645389MG
14080000000961L14/scrutins14140800000009401408000000094120PA332364PM645525MG
14080000000962L14/scrutins14140800000009401408000000094121PA335532PM645082MG
14080000000963L14/scrutins14140800000009401408000000094122PA335543PM645096MG
14080000000964L14/scrutins14140800000009401408000000094123PA331924PM645417MG
14080000000965L14/scrutins14140800000009401408000000094124PA335319PM645070PSE
14080000000966L14/scrutins14140800000009401408000000094125PA335999PM645219MG
14080000000989L14/scrutins1414080000000940140800000009881PA588872PM645062MG
14080000000991L14/scrutins1414080000000940140800000009901PA336175PM645264MG
14080000001004L14/scrutins1414080000001002140800000010031PA328PM645184MG
14080000001005L14/scrutins1414080000001002140800000010032PA381PM645125PAN
14080000001006L14/scrutins1414080000001002140800000010033PA1268PM645112MG
14080000001007L14/scrutins1414080000001002140800000010034PA2912PM645085MG
14080000001008L14/scrutins1414080000001002140800000010035PA1816PM645051MG
14080000001009L14/scrutins1414080000001002140800000010036PA1893PM645245MG
14080000001010L14/scrutins1414080000001002140800000010037PA334160PM645133MG
14080000001011L14/scrutins1414080000001002140800000010038PA588886PM645620MG
14080000001012L14/scrutins1414080000001002140800000010039PA590032PM645180MG
14080000001013L14/scrutins14140800000010021408000000100310PA2825PM645568MG
14080000001014L14/scrutins14140800000010021408000000100311PA333285PM645365MG
14080000001015L14/scrutins14140800000010021408000000100312PA590034PM645519MG
14080000001016L14/scrutins14140800000010021408000000100313PA706PM645268MG
14080000001017L14/scrutins14140800000010021408000000100314PA785PM645345MG
14080000001018L14/scrutins14140800000010021408000000100315PA2240PM645077MG
14080000001019L14/scrutins14140800000010021408000000100316PA267622PM645033MG
14080000001020L14/scrutins14140800000010021408000000100317PA268048PM645257MG
14080000001021L14/scrutins14140800000010021408000000100318PA590031PM645352MG
14080000001022L14/scrutins14140800000010021408000000100319PA333611PM645389MG
14080000001023L14/scrutins14140800000010021408000000100320PA332364PM645525MG
14080000001024L14/scrutins14140800000010021408000000100321PA335532PM645082MG
14080000001025L14/scrutins14140800000010021408000000100322PA335543PM645096MG
14080000001026L14/scrutins14140800000010021408000000100323PA331924PM645417MG
14080000001027L14/scrutins14140800000010021408000000100324PA335319PM645070PSE
14080000001028L14/scrutins14140800000010021408000000100325PA335999PM645219MG
14080000001036L14/scrutins1414080000001002140800000010351PA588872PM645062MG
14080000001038L14/scrutins1414080000001002140800000010371PA336175PM645264MG
14080000001047L14/scrutins1414080000001045140800000010461PA328PM645184MG
14080000001048L14/scrutins1414080000001045140800000010462PA381PM645125PAN
14080000001049L14/scrutins1414080000001045140800000010463PA1268PM645112MG
14080000001050L14/scrutins1414080000001045140800000010464PA2912PM645085MG