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
15080000518891L15/scrutins1515080000518889150800005188901PA332747PM722798PAN
15080000518892L15/scrutins1515080000518889150800005188902PA720622PM723018PSE
15080000518960L15/scrutins1515080000518958150800005189591PA332747PM722798PAN
15080000518961L15/scrutins1515080000518958150800005189592PA720622PM723018PSE
15080000519028L15/scrutins1515080000519026150800005190271PA332747PM722798PAN
15080000519029L15/scrutins1515080000519026150800005190272PA720622PM723018PSE
15080000519095L15/scrutins1515080000519093150800005190941PA332747PM722798PAN
15080000519096L15/scrutins1515080000519093150800005190942PA720622PM723018PSE
15080000519172L15/scrutins1515080000519170150800005191711PA332747PM722798PSE
15080000519321L15/scrutins1515080000519319150800005193201PA332747PM722798PAN
15080000519322L15/scrutins1515080000519319150800005193202PA721824PM723394PSE
15080000519367L15/scrutins1515080000519365150800005193661PA332747PM722798PAN
15080000519460L15/scrutins1515080000519365150800005194591PA605991PM722660PSE
15080000519507L15/scrutins1515080000519505150800005195061PA332747PM722798PAN
15080000519595L15/scrutins1515080000519505150800005195941PA605991PM722660PSE
15080000519649L15/scrutins1515080000519647150800005196481PA332747PM722798PAN
15080000519787L15/scrutins1515080000519647150800005197861PA605991PM722660PSE
15080000519840L15/scrutins1515080000519838150800005198391PA332747PM722798PAN
15080000519969L15/scrutins1515080000519838150800005199681PA605991PM722660PSE
15080000520025L15/scrutins1515080000520023150800005200241PA332747PM722798PAN
15080000520138L15/scrutins1515080000520023150800005201371PA605991PM722660PSE
15080000520188L15/scrutins1515080000520186150800005201871PA332747PM722798PAN
15080000520246L15/scrutins1515080000520186150800005202451PA1874PM722598PSE
15080000520285L15/scrutins1515080000520283150800005202841PA332747PM722798PAN
15080000520337L15/scrutins1515080000520283150800005203361PA1874PM722598PSE
15080000520370L15/scrutins1515080000520368150800005203691PA332747PM722798PAN
15080000520425L15/scrutins1515080000520368150800005204241PA1874PM722598PSE
15080000520458L15/scrutins1515080000520456150800005204571PA332747PM722798PAN
15080000520514L15/scrutins1515080000520456150800005205131PA1874PM722598PSE
14080000000003L14/scrutins1414080000000001140800000000021PA328PM645184MG
14080000000004L14/scrutins1414080000000001140800000000022PA381PM645125PSE
14080000000005L14/scrutins1414080000000001140800000000023PA1268PM645112MG
14080000000006L14/scrutins1414080000000001140800000000024PA2912PM645085MG
14080000000007L14/scrutins1414080000000001140800000000025PA1816PM645051MG
14080000000008L14/scrutins1414080000000001140800000000026PA1893PM645245MG
14080000000009L14/scrutins1414080000000001140800000000027PA334160PM645133MG
14080000000010L14/scrutins1414080000000001140800000000028PA588886PM645620MG
14080000000011L14/scrutins1414080000000001140800000000029PA590032PM645180MG
14080000000012L14/scrutins14140800000000011408000000000210PA2825PM645568MG
14080000000013L14/scrutins14140800000000011408000000000211PA333285PM645365MG
14080000000014L14/scrutins14140800000000011408000000000212PA590034PM645519MG
14080000000015L14/scrutins14140800000000011408000000000213PA706PM645268MG
14080000000016L14/scrutins14140800000000011408000000000214PA785PM645345MG
14080000000017L14/scrutins14140800000000011408000000000215PA2240PM645077MG
14080000000018L14/scrutins14140800000000011408000000000216PA267622PM645033MG
14080000000019L14/scrutins14140800000000011408000000000217PA268048PM645257MG
14080000000020L14/scrutins14140800000000011408000000000218PA590031PM645352MG
14080000000021L14/scrutins14140800000000011408000000000219PA333611PM645389MG
14080000000022L14/scrutins14140800000000011408000000000220PA332364PM645525MG
14080000000023L14/scrutins14140800000000011408000000000221PA335532PM645082MG