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 |
|---|---|---|---|---|---|---|---|---|
| 16060000056028 | L16/dossiers | 16 | 16060000056027 | 16060000056027 | 1 | PA340343 | rapporteur | |
| 16060000056029 | L16/dossiers | 16 | 16060000056027 | 16060000056027 | 2 | PO59051 | ||
| 16060000056032 | L16/dossiers | 16 | 16060000056031 | 16060000056031 | 1 | PA793306 | rapporteur | |
| 16060000056033 | L16/dossiers | 16 | 16060000056031 | 16060000056031 | 2 | PO59051 | ||
| 16060000056036 | L16/dossiers | 16 | 16060000056035 | 16060000056035 | 1 | PA722336 | rapporteur | |
| 16060000056037 | L16/dossiers | 16 | 16060000056035 | 16060000056035 | 2 | PO420120 | ||
| 16060000056040 | L16/dossiers | 16 | 16060000056039 | 16060000056039 | 1 | PA794838 | rapporteur | |
| 16060000056041 | L16/dossiers | 16 | 16060000056039 | 16060000056039 | 2 | PO59051 | ||
| 16060000056044 | L16/dossiers | 16 | 16060000056043 | 16060000056043 | 1 | PA795026 | rapporteur | |
| 16060000056045 | L16/dossiers | 16 | 16060000056043 | 16060000056043 | 2 | PO419865 | ||
| 16060000056048 | L16/dossiers | 16 | 16060000056047 | 16060000056047 | 1 | PA722102 | rapporteur | |
| 16060000056049 | L16/dossiers | 16 | 16060000056047 | 16060000056047 | 2 | PA793876 | rapporteur | |
| 16060000056050 | L16/dossiers | 16 | 16060000056047 | 16060000056047 | 3 | PO834560 | ||
| 16060000056052 | L16/dossiers | 16 | 16060000056051 | 16060000056051 | 1 | PA719798 | rapporteur | |
| 16060000056053 | L16/dossiers | 16 | 16060000056051 | 16060000056051 | 2 | PO59048 | ||
| 16060000056056 | L16/dossiers | 16 | 16060000056055 | 16060000056055 | 1 | PA722150 | rapporteur | |
| 16060000056057 | L16/dossiers | 16 | 16060000056055 | 16060000056055 | 2 | PO59051 | ||
| 16060000056060 | L16/dossiers | 16 | 16060000056059 | 16060000056059 | 1 | PA342415 | rapporteur | |
| 16060000056061 | L16/dossiers | 16 | 16060000056059 | 16060000056059 | 2 | PO420120 | ||
| 16060000056064 | L16/dossiers | 16 | 16060000056063 | 16060000056063 | 1 | PA793664 | rapporteur | |
| 16060000056065 | L16/dossiers | 16 | 16060000056063 | 16060000056063 | 2 | PO419865 | ||
| 16060000056068 | L16/dossiers | 16 | 16060000056067 | 16060000056067 | 1 | PA795908 | rapporteur | |
| 16060000056069 | L16/dossiers | 16 | 16060000056067 | 16060000056067 | 2 | PO59051 | ||
| 16060000056072 | L16/dossiers | 16 | 16060000056071 | 16060000056071 | 1 | PA720960 | rapporteur | |
| 16060000056073 | L16/dossiers | 16 | 16060000056071 | 16060000056071 | 2 | PO59051 | ||
| 16060000056076 | L16/dossiers | 16 | 16060000056075 | 16060000056075 | 1 | PA720022 | rapporteur | |
| 16060000056077 | L16/dossiers | 16 | 16060000056075 | 16060000056075 | 2 | PA795794 | rapporteur | |
| 16060000056078 | L16/dossiers | 16 | 16060000056075 | 16060000056075 | 3 | PO835801 | ||
| 16060000056080 | L16/dossiers | 16 | 16060000056079 | 16060000056079 | 1 | PA720342 | rapporteur | |
| 16060000056081 | L16/dossiers | 16 | 16060000056079 | 16060000056079 | 2 | PA266795 | rapporteur | |
| 16060000056082 | L16/dossiers | 16 | 16060000056079 | 16060000056079 | 3 | PO835822 | ||
| 16060000056084 | L16/dossiers | 16 | 16060000056083 | 16060000056083 | 1 | PA793664 | rapporteur | |
| 16060000056085 | L16/dossiers | 16 | 16060000056083 | 16060000056083 | 2 | PO419610 | ||
| 16060000056088 | L16/dossiers | 16 | 16060000056087 | 16060000056087 | 1 | PA793708 | rapporteur | |
| 16060000056089 | L16/dossiers | 16 | 16060000056087 | 16060000056087 | 2 | PO420120 | ||
| 16060000056092 | L16/dossiers | 16 | 16060000056091 | 16060000056091 | 1 | PA793948 | rapporteur | |
| 16060000056093 | L16/dossiers | 16 | 16060000056091 | 16060000056091 | 2 | PO419865 | ||
| 16060000056096 | L16/dossiers | 16 | 16060000056095 | 16060000056095 | 1 | PA794146 | rapporteur | |
| 16060000056097 | L16/dossiers | 16 | 16060000056095 | 16060000056095 | 2 | PO419610 | ||
| 16060000056100 | L16/dossiers | 16 | 16060000056099 | 16060000056099 | 1 | PA794214 | rapporteur | |
| 16060000056101 | L16/dossiers | 16 | 16060000056099 | 16060000056099 | 2 | PO835915 | ||
| 16060000056103 | L16/dossiers | 16 | 16060000056102 | 16060000056102 | 1 | PA721150 | rapporteur | |
| 16060000056104 | L16/dossiers | 16 | 16060000056102 | 16060000056102 | 2 | PO59048 | ||
| 16060000056107 | L16/dossiers | 16 | 16060000056106 | 16060000056106 | 1 | PA643048 | rapporteur | |
| 16060000056108 | L16/dossiers | 16 | 16060000056106 | 16060000056106 | 2 | PO419604 | ||
| 16060000056111 | L16/dossiers | 16 | 16060000056110 | 16060000056110 | 1 | PA722038 | rapporteur | |
| 16060000056112 | L16/dossiers | 16 | 16060000056110 | 16060000056110 | 2 | PO419865 | ||
| 16060000056115 | L16/dossiers | 16 | 16060000056114 | 16060000056114 | 1 | PA642868 | rapporteur | |
| 16060000056116 | L16/dossiers | 16 | 16060000056114 | 16060000056114 | 2 | PO420120 | ||
| 16060000056119 | L16/dossiers | 16 | 16060000056118 | 16060000056118 | 1 | PA719922 | rapporteur |