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
16080000353827L16/scrutins1616080000353749160800003538261PA609590PM797742PSE
16080000353922L16/scrutins1616080000353843160800003539211PA609590PM797742PSE
16080000354019L16/scrutins1616080000353939160800003540181PA609590PM797742PSE
16080000354161L16/scrutins1616080000354117160800003541601PA719874PM796674PSE
16080000354236L16/scrutins1616080000354185160800003542351PA719874PM796674PSE
16080000354325L16/scrutins1616080000354261160800003543241PA719874PM796674PSE
16080000354426L16/scrutins1616080000354350160800003544251PA719874PM796674PSE
16080000354521L16/scrutins1616080000354451160800003545201PA719874PM796674PSE
16080000354893L16/scrutins1616080000354556160800003548921PA720908PM797556PSE
16080000355189L16/scrutins1616080000354950160800003551881PA719874PM796674PSE
16080000355436L16/scrutins1616080000355283160800003554351PA609590PM797742PSE
16080000355530L16/scrutins1616080000355469160800003555291PA719874PM796674PSE
16080000355607L16/scrutins1616080000355552160800003556061PA609590PM797742PSE
16080000355744L16/scrutins1616080000355622160800003557431PA609590PM797742PSE
16080000355884L16/scrutins1616080000355777160800003558831PA609590PM797742PSE
16080000356028L16/scrutins1616080000355912160800003560271PA609590PM797742PSE
16080000356175L16/scrutins1616080000356052160800003561741PA609590PM797742PSE
16080000356308L16/scrutins1616080000356203160800003563071PA609590PM797742PSE
16080000356452L16/scrutins1616080000356335160800003564511PA609590PM797742PSE
16080000356599L16/scrutins1616080000356482160800003565981PA719874PM796674PSE
16080000356791L16/scrutins1616080000356643160800003567901PA719874PM796674PSE
16080000357017L16/scrutins1616080000356862160800003570161PA609590PM797742PSE
16080000357186L16/scrutins1616080000357047160800003571851PA719874PM796674PSE
16080000357391L16/scrutins1616080000357252160800003573901PA719874PM796674PSE
16080000357526L16/scrutins1616080000357442160800003575251PA719874PM796674PSE
16080000357637L16/scrutins1616080000357555160800003576361PA719874PM796674PSE
16080000357690L16/scrutins1616080000357667160800003576891PA720468PM796983PSE
16080000357763L16/scrutins1616080000357732160800003577621PA720468PM796983PSE
16080000357847L16/scrutins1616080000357814160800003578461PA720468PM796983PSE
16080000357938L16/scrutins1616080000357905160800003579371PA720468PM796983PSE
16080000358031L16/scrutins1616080000357996160800003580301PA720468PM796983PSE
16080000358127L16/scrutins1616080000358091160800003581261PA720468PM796983PSE
16080000358346L16/scrutins1616080000358188160800003583451PA609590PM797742PSE
16080000358418L16/scrutins1616080000358381160800003584171PA720468PM796983PSE
16080000358513L16/scrutins1616080000358478160800003585121PA720468PM796983PSE
16080000358605L16/scrutins1616080000358571160800003586041PA720468PM796983PSE
16080000358704L16/scrutins1616080000358666160800003587031PA720468PM796983PSE
16080000358808L16/scrutins1616080000358770160800003588071PA720468PM796983PSE
16080000358915L16/scrutins1616080000358874160800003589141PA720468PM796983PSE
16080000359019L16/scrutins1616080000358979160800003590181PA720468PM796983PSE
16080000359124L16/scrutins1616080000359085160800003591231PA720468PM796983PSE
16080000359231L16/scrutins1616080000359190160800003592301PA720468PM796983PSE
16080000359339L16/scrutins1616080000359296160800003593381PA720468PM796983PSE
16080000359570L16/scrutins1616080000359416160800003595691PA609590PM797742PSE
16080000359643L16/scrutins1616080000359604160800003596421PA720468PM796983PSE
16080000359811L16/scrutins1616080000359722160800003598101PA609590PM797742PSE
16080000359927L16/scrutins1616080000359838160800003599261PA609590PM797742PSE
16080000360047L16/scrutins1616080000359945160800003600461PA609590PM797742PSE
16080000360176L16/scrutins1616080000360073160800003601751PA609590PM797742PSE
16080000360472L16/scrutins1616080000360344160800003604711PA719874PM796674PSE