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
16080000423572L16/scrutins1616080000423441160800004235711PA720908PM797556PSE
16080000423727L16/scrutins1616080000423597160800004237261PA720908PM797556PSE
16080000423901L16/scrutins1616080000423749160800004239001PA720908PM797556PSE
16080000424088L16/scrutins1616080000423928160800004240871PA720908PM797556PSE
16080000424281L16/scrutins1616080000424112160800004242801PA720908PM797556PSE
16080000424483L16/scrutins1616080000424309160800004244821PA720908PM797556PSE
16080000424701L16/scrutins1616080000424510160800004247001PA720908PM797556PSE
16080000424770L16/scrutins1616080000424734160800004247691PA720468PM796983PSE
16080000424896L16/scrutins1616080000424858160800004248951PA720468PM796983PSE
16080000425234L16/scrutins1616080000424974160800004252331PA609590PM797742PSE
16080000425323L16/scrutins1616080000425286160800004253221PA720468PM796983PSE
16080000425452L16/scrutins1616080000425413160800004254511PA720468PM796983PSE
16080000425620L16/scrutins1616080000425539160800004256191PA720286PM796878PSE
16080000425751L16/scrutins1616080000425667160800004257501PA720286PM796878PSE
16080000425877L16/scrutins1616080000425799160800004258761PA720286PM796878PSE
16080000425993L16/scrutins1616080000425922160800004259921PA720286PM796878PSE
16080000426099L16/scrutins1616080000426031160800004260981PA720286PM796878PSE
16080000426213L16/scrutins1616080000426147160800004262121PA720286PM796878PSE
16080000426336L16/scrutins1616080000426262160800004263351PA720286PM796878PSE
16080000426468L16/scrutins1616080000426392160800004264671PA720286PM796878PSE
16080000426786L16/scrutins1616080000426528160800004267851PA609590PM797742PSE
16080000426915L16/scrutins1616080000426840160800004269141PA720286PM796878PSE
16080000427041L16/scrutins1616080000426972160800004270401PA720286PM796878PSE
16080000427171L16/scrutins1616080000427097160800004271701PA720286PM796878PSE
16080000427282L16/scrutins1616080000427226160800004272811PA720286PM796878PSE
16080000427401L16/scrutins1616080000427331160800004274001PA720286PM796878PSE
16080000427528L16/scrutins1616080000427454160800004275271PA720286PM796878PSE
16080000427666L16/scrutins1616080000427592160800004276651PA720286PM796878PSE
16080000427803L16/scrutins1616080000427732160800004278021PA720286PM796878PSE
16080000427944L16/scrutins1616080000427869160800004279431PA720286PM796878PSE
16080000428084L16/scrutins1616080000428005160800004280831PA720286PM796878PSE
16080000428388L16/scrutins1616080000428152160800004283871PA609590PM797742PSE
16080000428502L16/scrutins1616080000428424160800004285011PA720286PM796878PSE
16080000428652L16/scrutins1616080000428575160800004286511PA720286PM796878PSE
16080000428849L16/scrutins1616080000428736160800004288481PA719874PM796674PSE
16080000429032L16/scrutins1616080000428919160800004290311PA719874PM796674PSE
16080000429219L16/scrutins1616080000429103160800004292181PA719874PM796674PSE
16080000429410L16/scrutins1616080000429294160800004294091PA719874PM796674PSE
16080000429694L16/scrutins1616080000429485160800004296931PA719874PM796674PSE
16080000429847L16/scrutins1616080000429831160800004298461PA720468PM796983PSE
16080000429903L16/scrutins1616080000429879160800004299021PA720468PM796983PSE
16080000429979L16/scrutins1616080000429954160800004299781PA720468PM796983PSE
16080000430275L16/scrutins1616080000430029160800004302741PA609590PM797742PSE
16080000430333L16/scrutins1616080000430308160800004303321PA720468PM796983PSE
16080000430401L16/scrutins1616080000430374160800004304001PA720468PM796983PSE
16080000430478L16/scrutins1616080000430454160800004304771PA720468PM796983PSE
16080000430552L16/scrutins1616080000430534160800004305511PA720468PM796983PSE
16080000430614L16/scrutins1616080000430597160800004306131PA720468PM796983PSE
16080000430681L16/scrutins1616080000430659160800004306801PA720468PM796983PSE
16080000430786L16/scrutins1616080000430752160800004307851PA720286PM796878PSE