AN · données ouvertes
Explorateur / dossiers

dossiers.dossier_parlementaire_acteur

Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %

25 238 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_refVARCHARdossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
8mandat_refVARCHARdossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_refmandat_ref
17060000147963L17/dossiers1717060000147962170600001479621PA840979PM842588
17060000147970L17/dossiers1717060000147969170600001479691PA793322PM840246
17060000147977L17/dossiers1717060000147976170600001479761PA794686PM843080
17060000147984L17/dossiers1717060000147983170600001479831PA607090PM842903
17060000148041L17/dossiers1717060000148040170600001480401PA340343PM842351
17060000148048L17/dossiers1717060000148047170600001480471PA794094PM840291
17060000148055L17/dossiers1717060000148054170600001480541PA774954PM842843
17060000148062L17/dossiers1717060000148061170600001480611PA841717PM843278
17060000148069L17/dossiers1717060000148068170600001480681PA346782PM840426
17060000148076L17/dossiers1717060000148075170600001480751PA677483PM842435
17060000148083L17/dossiers1717060000148082170600001480821PA721474PM843608
17060000148090L17/dossiers1717060000148089170600001480891PA719138PM842672
17060000148102L17/dossiers1717060000148101170600001481011PA268048PM829731
17060000148109L17/dossiers1717060000148108170600001481081PA736235PM874830
17060000148110L17/dossiers1717060000148108170600001481082PA736235PM874830
17060000148111L17/dossiers1717060000148108170600001481083PA736190PM829825
17060000148118L17/dossiers1717060000148117170600001481171PA719968PM842891
17060000148125L17/dossiers1717060000148124170600001481241PA775206PM775506
17060000148132L17/dossiers1717060000148131170600001481311PA756685PM775777
17060000148133L17/dossiers1717060000148131170600001481312PA429886PM829757
17060000148134L17/dossiers1717060000148131170600001481313PA827912PM828488
17060000148135L17/dossiers1717060000148131170600001481314PA757676PM829801
17060000148136L17/dossiers1717060000148131170600001481315PA775172PM775474
17060000148137L17/dossiers1717060000148131170600001481316PA827898PM828454
17060000148138L17/dossiers1717060000148131170600001481317PA850008PM850016
17060000148139L17/dossiers1717060000148131170600001481318PA827930PM828544
17060000148140L17/dossiers1717060000148131170600001481319PA268007PM829695
17060000148141L17/dossiers17170600001481311706000014813110PA736195PM829855
17060000148142L17/dossiers17170600001481311706000014813111PA736173PM829799
17060000148143L17/dossiers17170600001481311706000014813112PA775246PM775532
17060000148144L17/dossiers17170600001481311706000014813113PA827962PM828676
17060000148145L17/dossiers17170600001481311706000014813114PA736243PM829929
17060000148146L17/dossiers17170600001481311706000014813115PA736175PM829795
17060000148147L17/dossiers17170600001481311706000014813116PA828002PM828856
17060000148148L17/dossiers17170600001481311706000014813117PA775296PM775596
17060000148149L17/dossiers17170600001481311706000014813118PA828020PM828864
17060000148156L17/dossiers1717060000148155170600001481551PA267743PM829699
17060000148175L17/dossiers1717060000148174170600001481741PA873607PM873611
17060000148200L17/dossiers1717060000148199170600001481991PA841931PM843485
17060000148207L17/dossiers1717060000148206170600001482061PA721110PM843782
17060000148217L17/dossiers1717060000148216170600001482161PA736241PM829931
17060000148218L17/dossiers1717060000148216170600001482162PA605888PM775604
17060000148219L17/dossiers1717060000148216170600001482163PA606375PM775602
17060000148220L17/dossiers1717060000148216170600001482164PA873607PM873611
17060000148221L17/dossiers1717060000148216170600001482165PA775290PM775576
17060000148228L17/dossiers1717060000148227170600001482271PA840979PM842588
17060000148232L17/dossiers1717060000148231170600001482311PA643210PM873637
17060000148233L17/dossiers1717060000148231170600001482312PA267797PM873658
17060000148337L17/dossiers1717060000148336170600001483361PA643210PM873637
17060000148338L17/dossiers1717060000148336170600001483362PA605991PM873649