dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 600 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | acteur_acteur_ref | VARCHAR | document.auteurs.auteur.acteur.acteurRef · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % · XSD 2016 : Rapporteur, rapporteur pour avis, général, spécial, intervenant. Ne pas mettre auteur et cosignataire. Utilisé également pour la spécialité du rapporteur sur le PLF |
| 9 | organe_organe_ref | VARCHAR | document.auteurs.auteur.organe.organeRef · présence : L17 59 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 16060000062990 | L16/dossiers | 16 | 16060000062988 | 16060000062988 | 2 | PO516753 | ||
| 16060000062992 | L16/dossiers | 16 | 16060000062991 | 16060000062991 | 1 | PA703514 | rapporteur | |
| 16060000062993 | L16/dossiers | 16 | 16060000062991 | 16060000062991 | 2 | PO211494 | ||
| 16060000062995 | L16/dossiers | 16 | 16060000062994 | 16060000062994 | 1 | PA703494 | rapporteur | |
| 16060000062996 | L16/dossiers | 16 | 16060000062994 | 16060000062994 | 2 | PO211495 | ||
| 16060000062998 | L16/dossiers | 16 | 16060000062997 | 16060000062997 | 1 | PA426327 | rapporteur | |
| 16060000062999 | L16/dossiers | 16 | 16060000062997 | 16060000062997 | 2 | PO211495 | ||
| 16060000063001 | L16/dossiers | 16 | 16060000063000 | 16060000063000 | 1 | PA736238 | rapporteur | |
| 16060000063002 | L16/dossiers | 16 | 16060000063000 | 16060000063000 | 2 | PO211490 | ||
| 16060000063004 | L16/dossiers | 16 | 16060000063003 | 16060000063003 | 1 | PA747422 | rapporteur | |
| 16060000063005 | L16/dossiers | 16 | 16060000063003 | 16060000063003 | 2 | PO516754 | ||
| 16060000063007 | L16/dossiers | 16 | 16060000063006 | 16060000063006 | 1 | PA415449 | rapporteur | |
| 16060000063008 | L16/dossiers | 16 | 16060000063006 | 16060000063006 | 2 | PO211490 | ||
| 16060000063010 | L16/dossiers | 16 | 16060000063009 | 16060000063009 | 1 | PA703511 | rapporteur | |
| 16060000063011 | L16/dossiers | 16 | 16060000063009 | 16060000063009 | 2 | PO211490 | ||
| 16060000063013 | L16/dossiers | 16 | 16060000063012 | 16060000063012 | 1 | PA736237 | rapporteur | |
| 16060000063014 | L16/dossiers | 16 | 16060000063012 | 16060000063012 | 2 | PO211493 | ||
| 16060000063016 | L16/dossiers | 16 | 16060000063015 | 16060000063015 | 1 | PA304017 | rapporteur | |
| 16060000063017 | L16/dossiers | 16 | 16060000063015 | 16060000063015 | 2 | PO211490 | ||
| 16060000063019 | L16/dossiers | 16 | 16060000063018 | 16060000063018 | 1 | PA703520 | rapporteur | |
| 16060000063020 | L16/dossiers | 16 | 16060000063018 | 16060000063018 | 2 | PO824878 | ||
| 16060000063022 | L16/dossiers | 16 | 16060000063021 | 16060000063021 | 1 | PA304086 | rapporteur | |
| 16060000063023 | L16/dossiers | 16 | 16060000063021 | 16060000063021 | 2 | PO211493 | ||
| 16060000063025 | L16/dossiers | 16 | 16060000063024 | 16060000063024 | 1 | PA703523 | rapporteur | |
| 16060000063026 | L16/dossiers | 16 | 16060000063024 | 16060000063024 | 2 | PA767418 | rapporteur | |
| 16060000063027 | L16/dossiers | 16 | 16060000063024 | 16060000063024 | 3 | PA775276 | rapporteur | |
| 16060000063028 | L16/dossiers | 16 | 16060000063024 | 16060000063024 | 4 | PO824144 | ||
| 16060000063030 | L16/dossiers | 16 | 16060000063029 | 16060000063029 | 1 | PA775192 | rapporteur | |
| 16060000063031 | L16/dossiers | 16 | 16060000063029 | 16060000063029 | 2 | PO824749 | ||
| 16060000063033 | L16/dossiers | 16 | 16060000063032 | 16060000063032 | 1 | PA703520 | rapporteur | |
| 16060000063034 | L16/dossiers | 16 | 16060000063032 | 16060000063032 | 2 | PO516753 | ||
| 16060000063036 | L16/dossiers | 16 | 16060000063035 | 16060000063035 | 1 | PA775220 | rapporteur | |
| 16060000063037 | L16/dossiers | 16 | 16060000063035 | 16060000063035 | 2 | PO825231 | ||
| 16060000063039 | L16/dossiers | 16 | 16060000063038 | 16060000063038 | 1 | PA763158 | rapporteur | |
| 16060000063040 | L16/dossiers | 16 | 16060000063038 | 16060000063038 | 2 | PO211493 | ||
| 16060000063042 | L16/dossiers | 16 | 16060000063041 | 16060000063041 | 1 | PA763158 | rapporteur | |
| 16060000063043 | L16/dossiers | 16 | 16060000063041 | 16060000063041 | 2 | PO826002 | ||
| 16060000063045 | L16/dossiers | 16 | 16060000063044 | 16060000063044 | 1 | PA775184 | rapporteur | |
| 16060000063046 | L16/dossiers | 16 | 16060000063044 | 16060000063044 | 2 | PO825849 | ||
| 16060000063048 | L16/dossiers | 16 | 16060000063047 | 16060000063047 | 1 | PA736196 | auteur | |
| 16060000063050 | L16/dossiers | 16 | 16060000063049 | 16060000063049 | 1 | PA703485 | auteur | |
| 16060000063052 | L16/dossiers | 16 | 16060000063051 | 16060000063051 | 1 | PA775236 | auteur | |
| 16060000063054 | L16/dossiers | 16 | 16060000063053 | 16060000063053 | 1 | PA775252 | auteur | |
| 16060000063056 | L16/dossiers | 16 | 16060000063055 | 16060000063055 | 1 | PA415446 | auteur | |
| 16060000063058 | L16/dossiers | 16 | 16060000063057 | 16060000063057 | 1 | PA415446 | auteur | |
| 16060000063060 | L16/dossiers | 16 | 16060000063059 | 16060000063059 | 1 | PA775248 | auteur | |
| 16060000063062 | L16/dossiers | 16 | 16060000063061 | 16060000063061 | 1 | PA703521 | auteur | |
| 16060000063064 | L16/dossiers | 16 | 16060000063063 | 16060000063063 | 1 | PO78718 | ||
| 16060000063066 | L16/dossiers | 16 | 16060000063065 | 16060000063065 | 1 | PA758716 | auteur | |
| 16060000063067 | L16/dossiers | 16 | 16060000063065 | 16060000063065 | 2 | PA758716 | auteur |