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 |
|---|---|---|---|---|---|---|---|---|
| 16060000083161 | L16/dossiers | 16 | 16060000083160 | 16060000083160 | 1 | PA721262 | rapporteur | |
| 16060000083162 | L16/dossiers | 16 | 16060000083160 | 16060000083160 | 2 | PO822403 | ||
| 16060000083164 | L16/dossiers | 16 | 16060000083163 | 16060000083163 | 1 | PA795990 | rapporteur | |
| 16060000083165 | L16/dossiers | 16 | 16060000083163 | 16060000083163 | 2 | PA703530 | rapporteur | |
| 16060000083166 | L16/dossiers | 16 | 16060000083163 | 16060000083163 | 3 | PO822178 | ||
| 16060000083168 | L16/dossiers | 16 | 16060000083167 | 16060000083167 | 1 | PA720354 | rapporteur | |
| 16060000083169 | L16/dossiers | 16 | 16060000083167 | 16060000083167 | 2 | PO59046 | ||
| 16060000083175 | L16/dossiers | 16 | 16060000083174 | 16060000083174 | 1 | PA794802 | rapporteur | |
| 16060000083176 | L16/dossiers | 16 | 16060000083174 | 16060000083174 | 2 | PO59048 | ||
| 16060000083179 | L16/dossiers | 16 | 16060000083178 | 16060000083178 | 1 | PA722054 | rapporteur | |
| 16060000083180 | L16/dossiers | 16 | 16060000083178 | 16060000083178 | 2 | PO59048 | ||
| 16060000083184 | L16/dossiers | 16 | 16060000083183 | 16060000083183 | 1 | PA794974 | rapporteur | |
| 16060000083185 | L16/dossiers | 16 | 16060000083183 | 16060000083183 | 2 | PO420120 | ||
| 16060000083189 | L16/dossiers | 16 | 16060000083188 | 16060000083188 | 1 | PA719814 | rapporteur | |
| 16060000083190 | L16/dossiers | 16 | 16060000083188 | 16060000083188 | 2 | PO419604 | ||
| 16060000083193 | L16/dossiers | 16 | 16060000083192 | 16060000083192 | 1 | PA721584 | rapporteur | |
| 16060000083194 | L16/dossiers | 16 | 16060000083192 | 16060000083192 | 2 | PA719558 | rapporteur | |
| 16060000083195 | L16/dossiers | 16 | 16060000083192 | 16060000083192 | 3 | PA793306 | rapporteur | |
| 16060000083196 | L16/dossiers | 16 | 16060000083192 | 16060000083192 | 4 | PO59051 | ||
| 16060000083200 | L16/dossiers | 16 | 16060000083199 | 16060000083199 | 1 | PA719202 | rapporteur | |
| 16060000083201 | L16/dossiers | 16 | 16060000083199 | 16060000083199 | 2 | PO59051 | ||
| 16060000083204 | L16/dossiers | 16 | 16060000083203 | 16060000083203 | 1 | PA722054 | rapporteur | |
| 16060000083205 | L16/dossiers | 16 | 16060000083203 | 16060000083203 | 2 | PO825399 | ||
| 16060000083207 | L16/dossiers | 16 | 16060000083206 | 16060000083206 | 1 | PA794802 | rapporteur | |
| 16060000083208 | L16/dossiers | 16 | 16060000083206 | 16060000083206 | 2 | PO825406 | ||
| 16060000083210 | L16/dossiers | 16 | 16060000083209 | 16060000083209 | 1 | PA719814 | rapporteur | |
| 16060000083211 | L16/dossiers | 16 | 16060000083209 | 16060000083209 | 2 | PO825929 | ||
| 16060000083213 | L16/dossiers | 16 | 16060000083212 | 16060000083212 | 1 | PA719372 | rapporteur | |
| 16060000083214 | L16/dossiers | 16 | 16060000083212 | 16060000083212 | 2 | PA794510 | rapporteur | |
| 16060000083215 | L16/dossiers | 16 | 16060000083212 | 16060000083212 | 3 | PA795270 | rapporteur | |
| 16060000083216 | L16/dossiers | 16 | 16060000083212 | 16060000083212 | 4 | PA793560 | rapporteur | |
| 16060000083217 | L16/dossiers | 16 | 16060000083212 | 16060000083212 | 5 | PA722038 | rapporteur | |
| 16060000083218 | L16/dossiers | 16 | 16060000083212 | 16060000083212 | 6 | PO825530 | ||
| 16060000083221 | L16/dossiers | 16 | 16060000083220 | 16060000083220 | 1 | PA720354 | rapporteur | |
| 16060000083222 | L16/dossiers | 16 | 16060000083220 | 16060000083220 | 2 | PA719822 | rapporteur | |
| 16060000083223 | L16/dossiers | 16 | 16060000083220 | 16060000083220 | 3 | PO826014 | ||
| 16060000083225 | L16/dossiers | 16 | 16060000083224 | 16060000083224 | 1 | PA720728 | rapporteur | |
| 16060000083226 | L16/dossiers | 16 | 16060000083224 | 16060000083224 | 2 | PO419610 | ||
| 16060000083229 | L16/dossiers | 16 | 16060000083228 | 16060000083228 | 1 | PA642868 | rapporteur | |
| 16060000083230 | L16/dossiers | 16 | 16060000083228 | 16060000083228 | 2 | PA719756 | rapporteur | |
| 16060000083231 | L16/dossiers | 16 | 16060000083228 | 16060000083228 | 3 | PO420120 | ||
| 16060000083234 | L16/dossiers | 16 | 16060000083233 | 16060000083233 | 1 | PA795664 | rapporteur | |
| 16060000083235 | L16/dossiers | 16 | 16060000083233 | 16060000083233 | 2 | PA794810 | rapporteur | |
| 16060000083236 | L16/dossiers | 16 | 16060000083233 | 16060000083233 | 3 | PA794426 | rapporteur | |
| 16060000083237 | L16/dossiers | 16 | 16060000083233 | 16060000083233 | 4 | PA719294 | rapporteur | |
| 16060000083238 | L16/dossiers | 16 | 16060000083233 | 16060000083233 | 5 | PA720146 | rapporteur | |
| 16060000083239 | L16/dossiers | 16 | 16060000083233 | 16060000083233 | 6 | PO826232 | ||
| 16060000083242 | L16/dossiers | 16 | 16060000083241 | 16060000083241 | 1 | PA719472 | rapporteur | |
| 16060000083243 | L16/dossiers | 16 | 16060000083241 | 16060000083241 | 2 | PO59048 | ||
| 16060000083246 | L16/dossiers | 16 | 16060000083245 | 16060000083245 | 1 | PA795652 | rapporteur |