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
16080000258913L16/scrutins1616080000258857160800002589121PA794354PM796869PSE
16080000259052L16/scrutins1616080000258987160800002590511PA794354PM796869PSE
16080000259273L16/scrutins1616080000259138160800002592721PA719874PM796674PSE
16080000259450L16/scrutins1616080000259316160800002594491PA719874PM796674PSE
16080000259609L16/scrutins1616080000259493160800002596081PA719874PM796674PSE
16080000259741L16/scrutins1616080000259644160800002597401PA719874PM796674PSE
16080000259839L16/scrutins1616080000259775160800002598381PA720286PM796878PSE
16080000260201L16/scrutins1616080000259891160800002602001PA720908PM797556PSE
16080000260534L16/scrutins1616080000260256160800002605331PA719874PM796674PSE
16080000260753L16/scrutins1616080000260652160800002607521PA720286PM796878PSE
16080000260931L16/scrutins1616080000260829160800002609301PA720286PM796878PSE
16080000261108L16/scrutins1616080000261005160800002611071PA720286PM796878PSE
16080000261294L16/scrutins1616080000261183160800002612931PA720286PM796878PSE
16080000261509L16/scrutins1616080000261391160800002615081PA720286PM796878PSE
16080000261715L16/scrutins1616080000261600160800002617141PA720286PM796878PSE
16080000261915L16/scrutins1616080000261800160800002619141PA720286PM796878PSE
16080000262115L16/scrutins1616080000262004160800002621141PA720286PM796878PSE
16080000262323L16/scrutins1616080000262214160800002623221PA720286PM796878PSE
16080000262536L16/scrutins1616080000262422160800002625351PA720286PM796878PSE
16080000262898L16/scrutins1616080000262641160800002628971PA719874PM796674PSE
16080000263129L16/scrutins1616080000263015160800002631281PA720286PM796878PSE
16080000263310L16/scrutins1616080000263197160800002633091PA720286PM796878PSE
16080000263511L16/scrutins1616080000263403160800002635101PA720286PM796878PSE
16080000263694L16/scrutins1616080000263603160800002636931PA720286PM796878PSE
16080000263820L16/scrutins1616080000263771160800002638191PA720468PM796983PSE
16080000263972L16/scrutins1616080000263911160800002639711PA720468PM796983PSE
16080000264130L16/scrutins1616080000264071160800002641291PA720468PM796983PSE
16080000264284L16/scrutins1616080000264232160800002642831PA720468PM796983PSE
16080000264434L16/scrutins1616080000264387160800002644331PA720468PM796983PSE
16080000264589L16/scrutins1616080000264536160800002645881PA720468PM796983PSE
16080000264968L16/scrutins1616080000264697160800002649671PA719874PM796674PSE
16080000265150L16/scrutins1616080000265087160800002651491PA720468PM796983PSE
16080000265339L16/scrutins1616080000265274160800002653381PA720468PM796983PSE
16080000265518L16/scrutins1616080000265450160800002655171PA720468PM796983PSE
16080000265683L16/scrutins1616080000265619160800002656821PA720468PM796983PSE
16080000265865L16/scrutins1616080000265806160800002658641PA720468PM796983PSE
16080000266042L16/scrutins1616080000265976160800002660411PA720468PM796983PSE
16080000266209L16/scrutins1616080000266143160800002662081PA720468PM796983PSE
16080000266401L16/scrutins1616080000266333160800002664001PA720468PM796983PSE
16080000266581L16/scrutins1616080000266512160800002665801PA720468PM796983PSE
16080000266768L16/scrutins1616080000266699160800002667671PA720468PM796983PSE
16080000267165L16/scrutins1616080000266893160800002671641PA719874PM796674PSE
16080000267384L16/scrutins1616080000267299160800002673831PA720286PM796878PSE
16080000267545L16/scrutins1616080000267449160800002675441PA720286PM796878PSE
16080000267724L16/scrutins1616080000267624160800002677231PA720286PM796878PSE
16080000267918L16/scrutins1616080000267802160800002679171PA720286PM796878PSE
16080000268118L16/scrutins1616080000268004160800002681171PA720286PM796878PSE
16080000268321L16/scrutins1616080000268203160800002683201PA720286PM796878PSE
16080000268523L16/scrutins1616080000268404160800002685221PA720286PM796878PSE
16080000268719L16/scrutins1616080000268608160800002687181PA720286PM796878PSE