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
16080000203740L16/scrutins1616080000203506160800002037391PA719874PM796674PSE
16080000203951L16/scrutins1616080000203839160800002039501PA609590PM797742PSE
16080000204057L16/scrutins1616080000203970160800002040561PA609590PM797742PSE
16080000204182L16/scrutins1616080000204071160800002041811PA609590PM797742PSE
16080000204312L16/scrutins1616080000204202160800002043111PA609590PM797742PSE
16080000204445L16/scrutins1616080000204333160800002044441PA609590PM797742PSE
16080000204589L16/scrutins1616080000204464160800002045881PA609590PM797742PSE
16080000204733L16/scrutins1616080000204609160800002047321PA609590PM797742PSE
16080000204843L16/scrutins1616080000204754160800002048421PA609590PM797742PSE
16080000204971L16/scrutins1616080000204857160800002049701PA609590PM797742PSE
16080000205086L16/scrutins1616080000204988160800002050851PA609590PM797742PSE
16080000205334L16/scrutins1616080000205101160800002053331PA719874PM796674PSE
16080000205545L16/scrutins1616080000205433160800002055441PA609590PM797742PSE
16080000205670L16/scrutins1616080000205561160800002056691PA609590PM797742PSE
16080000205784L16/scrutins1616080000205687160800002057831PA609590PM797742PSE
16080000205905L16/scrutins1616080000205800160800002059041PA609590PM797742PSE
16080000206013L16/scrutins1616080000205921160800002060121PA609590PM797742PSE
16080000206108L16/scrutins1616080000206027160800002061071PA609590PM797742PSE
16080000206502L16/scrutins1616080000206125160800002065011PA719874PM796674PSE
16080000206790L16/scrutins1616080000206674160800002067891PA719874PM796674PSE
16080000206934L16/scrutins1616080000206818160800002069331PA719874PM796674PSE
16080000207079L16/scrutins1616080000206964160800002070781PA719874PM796674PSE
16080000207337L16/scrutins1616080000207117160800002073361PA719874PM796674PSE
16080000207552L16/scrutins1616080000207446160800002075511PA719874PM796674PSE
16080000207691L16/scrutins1616080000207588160800002076901PA719874PM796674PSE
16080000207837L16/scrutins1616080000207727160800002078361PA719874PM796674PSE
16080000207986L16/scrutins1616080000207876160800002079851PA719874PM796674PSE
16080000208114L16/scrutins1616080000208018160800002081131PA719874PM796674PSE
16080000208230L16/scrutins1616080000208145160800002082291PA719874PM796674PSE
16080000208333L16/scrutins1616080000208261160800002083321PA609590PM797742PSE
16080000208417L16/scrutins1616080000208343160800002084161PA609590PM797742PSE
16080000208548L16/scrutins1616080000208427160800002085471PA609590PM797742PSE
16080000208690L16/scrutins1616080000208569160800002086891PA609590PM797742PSE
16080000208978L16/scrutins1616080000208711160800002089771PA719874PM796674PSE
16080000209213L16/scrutins1616080000209090160800002092121PA609590PM797742PSE
16080000209340L16/scrutins1616080000209234160800002093391PA609590PM797742PSE
16080000209481L16/scrutins1616080000209353160800002094801PA609590PM797742PSE
16080000209610L16/scrutins1616080000209505160800002096091PA609590PM797742PSE
16080000209747L16/scrutins1616080000209624160800002097461PA609590PM797742PSE
16080000209908L16/scrutins1616080000209773160800002099071PA609590PM797742PSE
16080000210099L16/scrutins1616080000209940160800002100981PA609590PM797742PSE
16080000210263L16/scrutins1616080000210131160800002102621PA609590PM797742PSE
16080000210425L16/scrutins1616080000210286160800002104241PA609590PM797742PSE
16080000210598L16/scrutins1616080000210453160800002105971PA609590PM797742PSE
16080000210851L16/scrutins1616080000210623160800002108501PA719874PM796674PSE
16080000211081L16/scrutins1616080000210938160800002110801PA609590PM797742PSE
16080000211232L16/scrutins1616080000211109160800002112311PA609590PM797742PSE
16080000211388L16/scrutins1616080000211248160800002113871PA609590PM797742PSE
16080000211529L16/scrutins1616080000211410160800002115281PA609590PM797742PSE
16080000211663L16/scrutins1616080000211547160800002116621PA609590PM797742PSE