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
16080000002750L16/scrutins1616080000002637160800000027491PA720286PM796878PSE
16080000003036L16/scrutins1616080000002870160800000030351PA720286PM796878PSE
16080000003336L16/scrutins1616080000003161160800000033351PA720286PM796878PSE
16080000003690L16/scrutins1616080000003501160800000036891PA720286PM796878PSE
16080000004289L16/scrutins1616080000004115160800000042881PA720286PM796878PSE
16080000004649L16/scrutins1616080000004469160800000046481PA720286PM796878PSE
16080000004960L16/scrutins1616080000004818160800000049591PA720286PM796878PSE
16080000005249L16/scrutins1616080000005099160800000052481PA720286PM796878PSE
16080000005401L16/scrutins1616080000005399160800000054001PA721908PM797568PSE
16080000005806L16/scrutins1616080000005804160800000058051PA721908PM797568PSE
16080000006206L16/scrutins1616080000006204160800000062051PA721908PM797568PSE
16080000006565L16/scrutins1616080000006563160800000065641PA721908PM797568PSE
16080000006890L16/scrutins1616080000006888160800000068891PA721908PM797568PSE
16080000007175L16/scrutins1616080000007173160800000071741PA721908PM797568PSE
16080000007752L16/scrutins1616080000007750160800000077511PA721908PM797568PSE
16080000008046L16/scrutins1616080000008044160800000080451PA721908PM797568PSE
16080000008301L16/scrutins1616080000008299160800000083001PA721908PM797568PSE
16080000008760L16/scrutins1616080000008758160800000087591PA721908PM797568PSE
16080000009224L16/scrutins1616080000009222160800000092231PA721908PM797568PSE
16080000009688L16/scrutins1616080000009686160800000096871PA721908PM797568PSE
16080000010153L16/scrutins1616080000010151160800000101521PA721908PM797568PSE
16080000010616L16/scrutins1616080000010614160800000106151PA721908PM797568PSE
16080000011083L16/scrutins1616080000011081160800000110821PA721908PM797568PSE
16080000011547L16/scrutins1616080000011545160800000115461PA721908PM797568PSE
16080000012244L16/scrutins1616080000012242160800000122431PA721908PM797568PSE
16080000012708L16/scrutins1616080000012706160800000127071PA721908PM797568PSE
16080000013178L16/scrutins1616080000013176160800000131771PA721908PM797568PSE
16080000013639L16/scrutins1616080000013637160800000136381PA721908PM797568PSE
16080000014104L16/scrutins1616080000014102160800000141031PA721908PM797568PSE
16080000014566L16/scrutins1616080000014564160800000145651PA721908PM797568PSE
16080000015029L16/scrutins1616080000015027160800000150281PA721908PM797568PSE
16080000015493L16/scrutins1616080000015491160800000154921PA721908PM797568PSE
16080000015959L16/scrutins1616080000015957160800000159581PA721908PM797568PSE
16080000016425L16/scrutins1616080000016423160800000164241PA721908PM797568PSE
16080000017124L16/scrutins1616080000017122160800000171231PA721908PM797568PSE
16080000017591L16/scrutins1616080000017589160800000175901PA721908PM797568PSE
16080000018059L16/scrutins1616080000018057160800000180581PA721908PM797568PSE
16080000018523L16/scrutins1616080000018521160800000185221PA721908PM797568PSE
16080000018987L16/scrutins1616080000018985160800000189861PA721908PM797568PSE
16080000019453L16/scrutins1616080000019451160800000194521PA721908PM797568PSE
16080000019922L16/scrutins1616080000019920160800000199211PA721908PM797568PSE
16080000020385L16/scrutins1616080000020383160800000203841PA721908PM797568PSE
16080000020855L16/scrutins1616080000020853160800000208541PA721908PM797568PSE
16080000021326L16/scrutins1616080000021324160800000213251PA721908PM797568PSE
16080000022029L16/scrutins1616080000022027160800000220281PA721908PM797568PSE
16080000022498L16/scrutins1616080000022496160800000224971PA721908PM797568PSE
16080000022962L16/scrutins1616080000022960160800000229611PA721908PM797568PSE
16080000023433L16/scrutins1616080000023431160800000234321PA721908PM797568PSE
16080000023902L16/scrutins1616080000023900160800000239011PA721908PM797568PSE
16080000024370L16/scrutins1616080000024368160800000243691PA721908PM797568PSE