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
15080000040133L15/scrutins1515080000040077150800000401321PA1874PM722598PSE
15080000040165L15/scrutins1515080000040163150800000401641PA606171PM722632PAN
15080000040210L15/scrutins1515080000040163150800000402091PA1874PM722598PSE
15080000040240L15/scrutins1515080000040238150800000402391PA606171PM722632PAN
15080000040280L15/scrutins1515080000040238150800000402791PA1874PM722598PSE
15080000040310L15/scrutins1515080000040308150800000403091PA606171PM722632PAN
15080000040352L15/scrutins1515080000040308150800000403511PA1874PM722598PSE
15080000040381L15/scrutins1515080000040379150800000403801PA606171PM722632PAN
15080000040382L15/scrutins1515080000040379150800000403802PA720622PM723018PSE
15080000040438L15/scrutins1515080000040436150800000404371PA606171PM722632PAN
15080000040439L15/scrutins1515080000040436150800000404372PA720622PM723018PSE
15080000040498L15/scrutins1515080000040496150800000404971PA606171PM722632PAN
15080000040499L15/scrutins1515080000040496150800000404972PA720622PM723018PSE
15080000040557L15/scrutins1515080000040555150800000405561PA606171PM722632PAN
15080000040558L15/scrutins1515080000040555150800000405562PA720622PM723018PSE
15080000040615L15/scrutins1515080000040613150800000406141PA606171PM722632PAN
15080000040616L15/scrutins1515080000040613150800000406142PA720622PM723018PSE
15080000040671L15/scrutins1515080000040669150800000406701PA332747PM722798PSE
15080000040889L15/scrutins1515080000040887150800000408881PA332747PM722798PAN
15080000040890L15/scrutins1515080000040887150800000408882PA720622PM723018PSE
15080000040995L15/scrutins1515080000040993150800000409941PA606171PM722632PAN
15080000040996L15/scrutins1515080000040993150800000409942PA720622PM723018PSE
15080000041060L15/scrutins1515080000041058150800000410591PA606171PM722632PAN
15080000041061L15/scrutins1515080000041058150800000410592PA720622PM723018PSE
15080000041116L15/scrutins1515080000041114150800000411151PA606171PM722632PAN
15080000041117L15/scrutins1515080000041114150800000411152PA720622PM723018PSE
15080000041174L15/scrutins1515080000041172150800000411731PA606171PM722632PAN
15080000041175L15/scrutins1515080000041172150800000411732PA720622PM723018PSE
15080000041243L15/scrutins1515080000041241150800000412421PA606171PM722632PSE
15080000041306L15/scrutins1515080000041304150800000413051PA606171PM722632PSE
15080000041368L15/scrutins1515080000041366150800000413671PA606171PM722632PSE
15080000041431L15/scrutins1515080000041429150800000414301PA606171PM722632PSE
15080000041497L15/scrutins1515080000041495150800000414961PA606171PM722632PSE
15080000041562L15/scrutins1515080000041560150800000415611PA606171PM722632PSE
15080000041627L15/scrutins1515080000041625150800000416261PA332747PM722798PAN
15080000041628L15/scrutins1515080000041625150800000416262PA720622PM723018PSE
15080000041755L15/scrutins1515080000041753150800000417541PA606171PM722632PSE
15080000041817L15/scrutins1515080000041815150800000418161PA606171PM722632PSE
15080000041883L15/scrutins1515080000041881150800000418821PA606171PM722632PAN
15080000041884L15/scrutins1515080000041881150800000418822PA721824PM723394PSE
15080000041957L15/scrutins1515080000041955150800000419561PA606171PM722632PAN
15080000041958L15/scrutins1515080000041955150800000419562PA721824PM723394PSE
15080000042023L15/scrutins1515080000042021150800000420221PA606171PM722632PAN
15080000042024L15/scrutins1515080000042021150800000420222PA721824PM723394PSE
15080000042097L15/scrutins1515080000042095150800000420961PA606171PM722632PAN
15080000042098L15/scrutins1515080000042095150800000420962PA721824PM723394PSE
15080000042164L15/scrutins1515080000042162150800000421631PA606171PM722632PAN
15080000042165L15/scrutins1515080000042162150800000421632PA721824PM723394PSE
15080000042225L15/scrutins1515080000042223150800000422241PA606171PM722632PAN
15080000042226L15/scrutins1515080000042223150800000422242PA721824PM723394PSE