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 |
|---|---|---|---|---|---|---|---|---|
| 16060000084036 | L16/dossiers | 16 | 16060000084035 | 16060000084035 | 1 | PO78718 | ||
| 16060000084038 | L16/dossiers | 16 | 16060000084037 | 16060000084037 | 1 | PO78718 | ||
| 16060000084040 | L16/dossiers | 16 | 16060000084039 | 16060000084039 | 1 | PO78718 | ||
| 16060000084042 | L16/dossiers | 16 | 16060000084041 | 16060000084041 | 1 | PO78718 | ||
| 16060000084044 | L16/dossiers | 16 | 16060000084043 | 16060000084043 | 1 | PO78718 | ||
| 16060000084046 | L16/dossiers | 16 | 16060000084045 | 16060000084045 | 1 | PO78718 | ||
| 16060000084048 | L16/dossiers | 16 | 16060000084047 | 16060000084047 | 1 | PO78718 | ||
| 16060000084050 | L16/dossiers | 16 | 16060000084049 | 16060000084049 | 1 | PO78718 | ||
| 16060000084052 | L16/dossiers | 16 | 16060000084051 | 16060000084051 | 1 | PO78718 | ||
| 16060000084054 | L16/dossiers | 16 | 16060000084053 | 16060000084053 | 1 | PO78718 | ||
| 16060000084056 | L16/dossiers | 16 | 16060000084055 | 16060000084055 | 1 | PO78718 | ||
| 16060000084058 | L16/dossiers | 16 | 16060000084057 | 16060000084057 | 1 | PO78718 | ||
| 16060000084060 | L16/dossiers | 16 | 16060000084059 | 16060000084059 | 1 | PO78718 | ||
| 16060000084062 | L16/dossiers | 16 | 16060000084061 | 16060000084061 | 1 | PO78718 | ||
| 16060000084064 | L16/dossiers | 16 | 16060000084063 | 16060000084063 | 1 | PO78718 | ||
| 16060000084066 | L16/dossiers | 16 | 16060000084065 | 16060000084065 | 1 | PO78718 | ||
| 16060000084068 | L16/dossiers | 16 | 16060000084067 | 16060000084067 | 1 | PO78718 | ||
| 16060000084070 | L16/dossiers | 16 | 16060000084069 | 16060000084069 | 1 | PO78718 | ||
| 16060000084072 | L16/dossiers | 16 | 16060000084071 | 16060000084071 | 1 | PO78718 | ||
| 16060000084074 | L16/dossiers | 16 | 16060000084073 | 16060000084073 | 1 | PO78718 | ||
| 16060000084076 | L16/dossiers | 16 | 16060000084075 | 16060000084075 | 1 | PO78718 | ||
| 16060000084078 | L16/dossiers | 16 | 16060000084077 | 16060000084077 | 1 | PO78718 | ||
| 16060000084080 | L16/dossiers | 16 | 16060000084079 | 16060000084079 | 1 | PO78718 | ||
| 16060000084082 | L16/dossiers | 16 | 16060000084081 | 16060000084081 | 1 | PO78718 | ||
| 16060000084084 | L16/dossiers | 16 | 16060000084083 | 16060000084083 | 1 | PO78718 | ||
| 16060000084086 | L16/dossiers | 16 | 16060000084085 | 16060000084085 | 1 | PO78718 | ||
| 16060000084088 | L16/dossiers | 16 | 16060000084087 | 16060000084087 | 1 | PO78718 | ||
| 16060000084090 | L16/dossiers | 16 | 16060000084089 | 16060000084089 | 1 | PO78718 | ||
| 16060000084092 | L16/dossiers | 16 | 16060000084091 | 16060000084091 | 1 | PO78718 | ||
| 16060000084094 | L16/dossiers | 16 | 16060000084093 | 16060000084093 | 1 | PO78718 | ||
| 16060000084096 | L16/dossiers | 16 | 16060000084095 | 16060000084095 | 1 | PO78718 | ||
| 16060000084098 | L16/dossiers | 16 | 16060000084097 | 16060000084097 | 1 | PO78718 | ||
| 16060000084100 | L16/dossiers | 16 | 16060000084099 | 16060000084099 | 1 | PO78718 | ||
| 16060000084102 | L16/dossiers | 16 | 16060000084101 | 16060000084101 | 1 | PO78718 | ||
| 16060000084104 | L16/dossiers | 16 | 16060000084103 | 16060000084103 | 1 | PO78718 | ||
| 16060000084106 | L16/dossiers | 16 | 16060000084105 | 16060000084105 | 1 | PO78718 | ||
| 16060000084108 | L16/dossiers | 16 | 16060000084107 | 16060000084107 | 1 | PO78718 | ||
| 16060000084110 | L16/dossiers | 16 | 16060000084109 | 16060000084109 | 1 | PO78718 | ||
| 16060000084112 | L16/dossiers | 16 | 16060000084111 | 16060000084111 | 1 | PO78718 | ||
| 16060000084114 | L16/dossiers | 16 | 16060000084113 | 16060000084113 | 1 | PO78718 | ||
| 16060000084116 | L16/dossiers | 16 | 16060000084115 | 16060000084115 | 1 | PO78718 | ||
| 16060000084118 | L16/dossiers | 16 | 16060000084117 | 16060000084117 | 1 | PO78718 | ||
| 16060000084120 | L16/dossiers | 16 | 16060000084119 | 16060000084119 | 1 | PO78718 | ||
| 16060000084122 | L16/dossiers | 16 | 16060000084121 | 16060000084121 | 1 | PO78718 | ||
| 16060000084124 | L16/dossiers | 16 | 16060000084123 | 16060000084123 | 1 | PO78718 | ||
| 16060000084126 | L16/dossiers | 16 | 16060000084125 | 16060000084125 | 1 | PO78718 | ||
| 16060000084128 | L16/dossiers | 16 | 16060000084127 | 16060000084127 | 1 | PO78718 | ||
| 16060000084130 | L16/dossiers | 16 | 16060000084129 | 16060000084129 | 1 | PO78718 | ||
| 16060000084132 | L16/dossiers | 16 | 16060000084131 | 16060000084131 | 1 | PO78718 | ||
| 16060000084134 | L16/dossiers | 16 | 16060000084133 | 16060000084133 | 1 | PO78718 |