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
15080000015187L15/scrutins1515080000015184150800000151852PA722150PM723486PSE
15080000015380L15/scrutins1515080000015378150800000153791PA332747PM722798PAN
15080000015422L15/scrutins1515080000015378150800000154211PA1874PM722598PSE
15080000015448L15/scrutins1515080000015446150800000154471PA332747PM722798PAN
15080000015518L15/scrutins1515080000015446150800000155171PA1874PM722598PSE
15080000015556L15/scrutins1515080000015554150800000155551PA332747PM722798PAN
15080000015651L15/scrutins1515080000015554150800000156501PA1874PM722598PSE
15080000015723L15/scrutins1515080000015721150800000157221PA332747PM722798PSE
15080000015899L15/scrutins1515080000015897150800000158981PA332747PM722798PSE
15080000016057L15/scrutins1515080000016055150800000160561PA332747PM722798PSE
15080000016183L15/scrutins1515080000016181150800000161821PA332747PM722798PSE
15080000016262L15/scrutins1515080000016260150800000162611PA332747PM722798PSE
15080000016352L15/scrutins1515080000016350150800000163511PA332747PM722798PSE
15080000016429L15/scrutins1515080000016427150800000164281PA332747PM722798PSE
15080000016515L15/scrutins1515080000016513150800000165141PA332747PM722798PSE
15080000016762L15/scrutins1515080000016760150800000167611PA332747PM722798PAN
15080000016763L15/scrutins1515080000016760150800000167612PA722150PM723486PSE
15080000016945L15/scrutins1515080000016943150800000169441PA332747PM722798PSE
15080000017033L15/scrutins1515080000017031150800000170321PA332747PM722798PSE
15080000017116L15/scrutins1515080000017114150800000171151PA332747PM722798PSE
15080000017180L15/scrutins1515080000017178150800000171791PA332747PM722798PSE
15080000017257L15/scrutins1515080000017255150800000172561PA332747PM722798PSE
15080000017339L15/scrutins1515080000017337150800000173381PA332747PM722798PSE
15080000017419L15/scrutins1515080000017417150800000174181PA332747PM722798PSE
15080000017499L15/scrutins1515080000017497150800000174981PA332747PM722798PSE
15080000017582L15/scrutins1515080000017580150800000175811PA332747PM722798PSE
15080000017673L15/scrutins1515080000017671150800000176721PA332747PM722798PSE
15080000017760L15/scrutins1515080000017758150800000177591PA332747PM722798PAN
15080000017761L15/scrutins1515080000017758150800000177592PA722150PM723486PSE
15080000017949L15/scrutins1515080000017947150800000179481PA332747PM722798PSE
15080000018036L15/scrutins1515080000018034150800000180351PA332747PM722798PAN
15080000018090L15/scrutins1515080000018034150800000180891PA605991PM722660PSE
15080000018124L15/scrutins1515080000018122150800000181231PA332747PM722798PAN
15080000018171L15/scrutins1515080000018122150800000181701PA605991PM722660PSE
15080000018203L15/scrutins1515080000018201150800000182021PA332747PM722798PAN
15080000018240L15/scrutins1515080000018201150800000182391PA605991PM722660PSE
15080000018269L15/scrutins1515080000018267150800000182681PA332747PM722798PSE
15080000018422L15/scrutins1515080000018420150800000184211PA332747PM722798PSE
15080000018506L15/scrutins1515080000018504150800000185051PA332747PM722798PAN
15080000018507L15/scrutins1515080000018504150800000185052PA720622PM723018PSE
15080000018685L15/scrutins1515080000018683150800000186841PA332747PM722798PAN
15080000018686L15/scrutins1515080000018683150800000186842PA720622PM723018PSE
15080000018832L15/scrutins1515080000018830150800000188311PA332747PM722798PAN
15080000018833L15/scrutins1515080000018830150800000188312PA720622PM723018PSE
15080000018943L15/scrutins1515080000018941150800000189421PA606171PM722632PAN
15080000018944L15/scrutins1515080000018941150800000189422PA721824PM723394PSE
15080000019053L15/scrutins1515080000019051150800000190521PA332747PM722798PAN
15080000019054L15/scrutins1515080000019051150800000190522PA722150PM723486PSE
15080000019236L15/scrutins1515080000019234150800000192351PA606171PM722632PAN
15080000019313L15/scrutins1515080000019234150800000193121PA720746PM723064PSE