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
16080000559309L16/scrutins1616080000559131160800005593081PA609590PM797742PSE
16080000559495L16/scrutins1616080000559341160800005594941PA609590PM797742PSE
16080000559799L16/scrutins1616080000559530160800005597981PA609590PM797742PSE
16080000560040L16/scrutins1616080000559863160800005600391PA609590PM797742PSE
16080000560272L16/scrutins1616080000560073160800005602711PA609590PM797742PSE
16080000560512L16/scrutins1616080000560306160800005605111PA609590PM797742PSE
16080000560782L16/scrutins1616080000560550160800005607811PA609590PM797742PSE
16080000561020L16/scrutins1616080000560828160800005610191PA609590PM797742PSE
16080000561222L16/scrutins1616080000561053160800005612211PA609590PM797742PSE
16080000561311L16/scrutins1616080000561253160800005613101PA719874PM796674PSE
16080000561435L16/scrutins1616080000561341160800005614341PA719874PM796674PSE
16080000561580L16/scrutins1616080000561470160800005615791PA719874PM796674PSE
16080000561743L16/scrutins1616080000561624160800005617421PA719874PM796674PSE
16080000562060L16/scrutins1616080000561790160800005620591PA609590PM797742PSE
16080000562265L16/scrutins1616080000562130160800005622641PA719874PM796674PSE
16080000562405L16/scrutins1616080000562321160800005624041PA719874PM796674PSE
16080000562576L16/scrutins1616080000562457160800005625751PA719874PM796674PSE
16080000562780L16/scrutins1616080000562646160800005627791PA609590PM797742PSE
16080000562990L16/scrutins1616080000562810160800005629891PA609590PM797742PSE
16080000563204L16/scrutins1616080000563030160800005632031PA609590PM797742PSE
16080000563417L16/scrutins1616080000563247160800005634161PA609590PM797742PSE
16080000563519L16/scrutins1616080000563457160800005635181PA719874PM796674PSE
16080000563612L16/scrutins1616080000563549160800005636111PA719874PM796674PSE
16080000563711L16/scrutins1616080000563643160800005637101PA719874PM796674PSE
16080000564025L16/scrutins1616080000563749160800005640241PA609590PM797742PSE
16080000564154L16/scrutins1616080000564092160800005641531PA719874PM796674PSE
16080000564265L16/scrutins1616080000564191160800005642641PA719874PM796674PSE
16080000564366L16/scrutins1616080000564301160800005643651PA719874PM796674PSE
16080000564462L16/scrutins1616080000564403160800005644611PA719874PM796674PSE
16080000564543L16/scrutins1616080000564497160800005645421PA719874PM796674PSE
16080000564669L16/scrutins1616080000564567160800005646681PA719874PM796674PSE
16080000564812L16/scrutins1616080000564722160800005648111PA719874PM796674PSE
16080000564949L16/scrutins1616080000564864160800005649481PA719874PM796674PSE
16080000565076L16/scrutins1616080000564998160800005650751PA719874PM796674PSE
16080000565188L16/scrutins1616080000565121160800005651871PA719874PM796674PSE
16080000565428L16/scrutins1616080000565219160800005654271PA720286PM796878PSE
16080000565724L16/scrutins1616080000565615160800005657231PA794354PM796869PSE
16080000565988L16/scrutins1616080000565931160800005659871PA719874PM796674PSE
16080000566081L16/scrutins1616080000566016160800005660801PA719874PM796674PSE
16080000566183L16/scrutins1616080000566117160800005661821PA719874PM796674PSE
16080000566280L16/scrutins1616080000566217160800005662791PA719874PM796674PSE
16080000566379L16/scrutins1616080000566326160800005663781PA719874PM796674PSE
16080000566481L16/scrutins1616080000566418160800005664801PA720286PM796878PSE
16080000566590L16/scrutins1616080000566537160800005665891PA720286PM796878PSE
16080000566661L16/scrutins1616080000566626160800005666601PA609590PM797742PSE
16080000566707L16/scrutins1616080000566676160800005667061PA719874PM796674PSE
16080000566788L16/scrutins1616080000566725160800005667871PA719874PM796674PSE
16080000566918L16/scrutins1616080000566821160800005669171PA794354PM796869PSE
16080000567146L16/scrutins1616080000567093160800005671451PA719874PM796674PSE
16080000567785L16/scrutins1616080000567712160800005677841PA794354PM796869PSE