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 323 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
17080000032927L17/scrutins1717080000032785170800000329261PA330008PM842366False171PSE
17080000033044L17/scrutins1717080000033008170800000330431PA721908PM843467False402PAN
17080000033141L17/scrutins1717080000033008170800000331401PA330008PM842366False171PSE
17080000033261L17/scrutins1717080000033221170800000332601PA721908PM843467False402PAN
17080000033321L17/scrutins1717080000033221170800000333201PA643089PM843431False206MG
17080000033347L17/scrutins1717080000033221170800000333461PA720908PM843701False221PSE
17080000033348L17/scrutins1717080000033221170800000333462PA720480PM843101False245MG
17080000033448L17/scrutins1717080000033369170800000334471PA721908PM843467False402PAN
17080000033556L17/scrutins1717080000033369170800000335551PA330008PM842366False171PSE
17080000033557L17/scrutins1717080000033369170800000335552PA643089PM843431False206MG
17080000033594L17/scrutins1717080000033369170800000335931PA720480PM843101False245MG
17080000033661L17/scrutins1717080000033624170800000336601PA721908PM843467False402PAN
17080000033764L17/scrutins1717080000033624170800000337631PA330008PM842366False171PSE
17080000033881L17/scrutins1717080000033842170800000338801PA721908PM843467False402PAN
17080000033991L17/scrutins1717080000033842170800000339901PA330008PM842366False171PSE
17080000034116L17/scrutins1717080000034071170800000341151PA721908PM843467False402PAN
17080000034231L17/scrutins1717080000034071170800000342301PA330008PM842366False171PSE
17080000034359L17/scrutins1717080000034319170800000343581PA721134PM843797False268PSE
17080000034360L17/scrutins1717080000034319170800000343582PA721908PM843467False402PAN
17080000034528L17/scrutins1717080000034493170800000345271PA721134PM843797False268PSE
17080000034529L17/scrutins1717080000034493170800000345272PA721908PM843467False402PAN
17080000034697L17/scrutins1717080000034647170800000346961PA721908PM843467False402PAN
17080000034753L17/scrutins1717080000034647170800000347521PA330008PM842366False171PSE
17080000034855L17/scrutins1717080000034806170800000348541PA721908PM843467False402PAN
17080000034912L17/scrutins1717080000034806170800000349111PA330008PM842366False171PSE
17080000035016L17/scrutins1717080000034968170800000350151PA721908PM843467False402PAN
17080000035069L17/scrutins1717080000034968170800000350681PA330008PM842366False171PSE
17080000035178L17/scrutins1717080000035126170800000351771PA721908PM843467False402PAN
17080000035230L17/scrutins1717080000035126170800000352291PA330008PM842366False171PSE
17080000035344L17/scrutins1717080000035290170800000353431PA721908PM843467False402PAN
17080000035395L17/scrutins1717080000035290170800000353941PA330008PM842366False171PSE
17080000035531L17/scrutins1717080000035452170800000355301PA721908PM843467False402PAN
17080000035634L17/scrutins1717080000035452170800000356331PA330008PM842366False171PSE
17080000035635L17/scrutins1717080000035452170800000356332PA643089PM843431False206MG
17080000035675L17/scrutins1717080000035452170800000356741PA720480PM843101False245MG
17080000035758L17/scrutins1717080000035706170800000357571PA721908PM843467False402PAN
17080000035817L17/scrutins1717080000035706170800000358161PA330008PM842366False171PSE
17080000035936L17/scrutins1717080000035886170800000359351PA721908PM843467False402PAN
17080000035995L17/scrutins1717080000035886170800000359941PA330008PM842366False171PSE
17080000036113L17/scrutins1717080000036063170800000361121PA721908PM843467False402PAN
17080000036175L17/scrutins1717080000036063170800000361741PA330008PM842366False171PSE
17080000036299L17/scrutins1717080000036246170800000362981PA721908PM843467False402PAN
17080000036559L17/scrutins1717080000036506170800000365581PA721908PM843467False402PAN
17080000036799L17/scrutins1717080000036766170800000367981PA721134PM843797False268PSE
17080000036800L17/scrutins1717080000036766170800000367982PA721908PM843467False402PAN
17080000036908L17/scrutins1717080000036875170800000369071PA721134PM843797False268PSE
17080000036909L17/scrutins1717080000036875170800000369072PA721908PM843467False402PAN
17080000037034L17/scrutins1717080000036995170800000370331PA721134PM843797False268PSE
17080000037035L17/scrutins1717080000036995170800000370332PA721908PM843467False402PAN
17080000037162L17/scrutins1717080000037123170800000371611PA721134PM843797False268PSE