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
16080000218376L16/scrutins1616080000218241160800002183751PA720286PM796878PSE
16080000218518L16/scrutins1616080000218477160800002185171PA720468PM796983PSE
16080000218627L16/scrutins1616080000218581160800002186261PA720468PM796983PSE
16080000218748L16/scrutins1616080000218703160800002187471PA720468PM796983PSE
16080000218887L16/scrutins1616080000218842160800002188861PA720468PM796983PSE
16080000219018L16/scrutins1616080000218979160800002190171PA720468PM796983PSE
16080000219157L16/scrutins1616080000219109160800002191561PA720468PM796983PSE
16080000219298L16/scrutins1616080000219250160800002192971PA720468PM796983PSE
16080000219414L16/scrutins1616080000219378160800002194131PA720468PM796983PSE
16080000219605L16/scrutins1616080000219480160800002196041PA609590PM797742PSE
16080000219767L16/scrutins1616080000219633160800002197661PA609590PM797742PSE
16080000219928L16/scrutins1616080000219792160800002199271PA720286PM796878PSE
16080000220061L16/scrutins1616080000220000160800002200601PA720468PM796983PSE
16080000220229L16/scrutins1616080000220166160800002202281PA720468PM796983PSE
16080000220399L16/scrutins1616080000220340160800002203981PA720468PM796983PSE
16080000220553L16/scrutins1616080000220504160800002205521PA720468PM796983PSE
16080000220694L16/scrutins1616080000220649160800002206931PA720468PM796983PSE
16080000220830L16/scrutins1616080000220787160800002208291PA794354PM796869PSE
16080000221008L16/scrutins1616080000220935160800002210071PA794354PM796869PSE
16080000221220L16/scrutins1616080000221171160800002212191PA794354PM796869PSE
16080000221376L16/scrutins1616080000221340160800002213751PA794354PM796869PSE
16080000221480L16/scrutins1616080000221438160800002214791PA794354PM796869PSE
16080000221689L16/scrutins1616080000221547160800002216881PA720286PM796878PSE
16080000221849L16/scrutins1616080000221809160800002218481PA794354PM796869PSE
16080000221957L16/scrutins1616080000221920160800002219561PA794354PM796869PSE
16080000222105L16/scrutins1616080000222038160800002221041PA719874PM796674PSE
16080000222199L16/scrutins1616080000222130160800002221981PA719874PM796674PSE
16080000222308L16/scrutins1616080000222225160800002223071PA719874PM796674PSE
16080000222424L16/scrutins1616080000222339160800002224231PA719874PM796674PSE
16080000222541L16/scrutins1616080000222456160800002225401PA719874PM796674PSE
16080000222665L16/scrutins1616080000222570160800002226641PA719874PM796674PSE
16080000222809L16/scrutins1616080000222700160800002228081PA719874PM796674PSE
16080000222959L16/scrutins1616080000222842160800002229581PA719874PM796674PSE
16080000223140L16/scrutins1616080000222991160800002231391PA720286PM796878PSE
16080000223365L16/scrutins1616080000223272160800002233641PA719874PM796674PSE
16080000223486L16/scrutins1616080000223395160800002234851PA719874PM796674PSE
16080000223542L16/scrutins1616080000223511160800002235411PA794354PM796869PSE
16080000223621L16/scrutins1616080000223587160800002236201PA794354PM796869PSE
16080000223717L16/scrutins1616080000223683160800002237161PA794354PM796869PSE
16080000223807L16/scrutins1616080000223778160800002238061PA794354PM796869PSE
16080000223901L16/scrutins1616080000223868160800002239001PA794354PM796869PSE
16080000223998L16/scrutins1616080000223966160800002239971PA794354PM796869PSE
16080000224099L16/scrutins1616080000224066160800002240981PA794354PM796869PSE
16080000224204L16/scrutins1616080000224173160800002242031PA794354PM796869PSE
16080000224412L16/scrutins1616080000224267160800002244111PA720286PM796878PSE
16080000224580L16/scrutins1616080000224538160800002245791PA794354PM796869PSE
16080000224727L16/scrutins1616080000224684160800002247261PA794354PM796869PSE
16080000224873L16/scrutins1616080000224830160800002248721PA794354PM796869PSE
16080000225021L16/scrutins1616080000224977160800002250201PA794354PM796869PSE
16080000225170L16/scrutins1616080000225125160800002251691PA794354PM796869PSE