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
15080000475560L15/scrutins1515080000475558150800004755591PA332747PM722798PAN
15080000475652L15/scrutins1515080000475558150800004756511PA1874PM722598PSE
15080000475733L15/scrutins1515080000475731150800004757321PA332747PM722798PAN
15080000475839L15/scrutins1515080000475731150800004758381PA1874PM722598PSE
15080000475932L15/scrutins1515080000475930150800004759311PA332747PM722798PAN
15080000476014L15/scrutins1515080000475930150800004760131PA1874PM722598PSE
15080000476092L15/scrutins1515080000476090150800004760911PA332747PM722798PAN
15080000476156L15/scrutins1515080000476090150800004761551PA267801PM723320PSE
15080000476176L15/scrutins1515080000476174150800004761751PA332747PM722798PSE
15080000476346L15/scrutins1515080000476344150800004763451PA332747PM722798PAN
15080000476347L15/scrutins1515080000476344150800004763452PA719850PM722780PSE
15080000476567L15/scrutins1515080000476565150800004765661PA332747PM722798PAN
15080000476638L15/scrutins1515080000476565150800004766371PA267801PM723320PSE
15080000476656L15/scrutins1515080000476654150800004766551PA332747PM722798PAN
15080000476719L15/scrutins1515080000476654150800004767181PA267801PM723320PSE
15080000476733L15/scrutins1515080000476731150800004767321PA332747PM722798PAN
15080000476795L15/scrutins1515080000476731150800004767941PA267801PM723320PSE
15080000476809L15/scrutins1515080000476807150800004768081PA332747PM722798PAN
15080000476862L15/scrutins1515080000476807150800004768611PA720746PM723064PSE
15080000476890L15/scrutins1515080000476888150800004768891PA332747PM722798PSE
15080000476968L15/scrutins1515080000476966150800004769671PA332747PM722798PSE
15080000477048L15/scrutins1515080000477046150800004770471PA332747PM722798PSE
15080000477130L15/scrutins1515080000477128150800004771291PA332747PM722798PSE
15080000477218L15/scrutins1515080000477216150800004772171PA332747PM722798PSE
15080000477308L15/scrutins1515080000477306150800004773071PA332747PM722798PSE
15080000477407L15/scrutins1515080000477405150800004774061PA332747PM722798PAN
15080000477408L15/scrutins1515080000477405150800004774062PA719850PM722780PSE
15080000477661L15/scrutins1515080000477659150800004776601PA332747PM722798PSE
15080000477742L15/scrutins1515080000477740150800004777411PA332747PM722798PSE
15080000477852L15/scrutins1515080000477850150800004778511PA332747PM722798PSE
15080000477971L15/scrutins1515080000477969150800004779701PA332747PM722798PSE
15080000478091L15/scrutins1515080000478089150800004780901PA332747PM722798PSE
15080000478212L15/scrutins1515080000478210150800004782111PA332747PM722798PSE
15080000478337L15/scrutins1515080000478335150800004783361PA332747PM722798PSE
15080000478470L15/scrutins1515080000478468150800004784691PA332747PM722798PSE
15080000478596L15/scrutins1515080000478594150800004785951PA332747PM722798PSE
15080000478730L15/scrutins1515080000478728150800004787291PA332747PM722798PSE
15080000478912L15/scrutins1515080000478910150800004789111PA332747PM722798PAN
15080000478913L15/scrutins1515080000478910150800004789112PA719850PM722780PSE
15080000479191L15/scrutins1515080000479189150800004791901PA332747PM722798PAN
15080000479212L15/scrutins1515080000479189150800004792111PA605991PM722660PSE
15080000479270L15/scrutins1515080000479268150800004792691PA332747PM722798PAN
15080000479296L15/scrutins1515080000479268150800004792951PA605991PM722660PSE
15080000479354L15/scrutins1515080000479352150800004793531PA332747PM722798PAN
15080000479380L15/scrutins1515080000479352150800004793791PA605991PM722660PSE
15080000479441L15/scrutins1515080000479439150800004794401PA332747PM722798PAN
15080000479500L15/scrutins1515080000479439150800004794991PA720746PM723064PSE
15080000479542L15/scrutins1515080000479540150800004795411PA332747PM722798PAN
15080000479566L15/scrutins1515080000479540150800004795651PA720746PM723064PSE
15080000479592L15/scrutins1515080000479590150800004795911PA332747PM722798PAN