dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000003538 | L17/dossiers | 17 | 17060000003537 | 17060000003537 | 1 | PO717460 | ||
| 17060000003541 | L17/dossiers | 17 | 17060000003540 | 17060000003540 | 1 | PO717460 | ||
| 17060000003544 | L17/dossiers | 17 | 17060000003543 | 17060000003543 | 1 | PO717460 | ||
| 17060000003547 | L17/dossiers | 17 | 17060000003546 | 17060000003546 | 1 | PO717460 | ||
| 17060000003550 | L17/dossiers | 17 | 17060000003549 | 17060000003549 | 1 | PO717460 | ||
| 17060000003553 | L17/dossiers | 17 | 17060000003552 | 17060000003552 | 1 | PO717460 | ||
| 17060000003556 | L17/dossiers | 17 | 17060000003555 | 17060000003555 | 1 | PO717460 | ||
| 17060000003559 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 1 | PA720480 | auteur | |
| 17060000003898 | L17/dossiers | 17 | 17060000003897 | 17060000003897 | 1 | PO717460 | ||
| 17060000003901 | L17/dossiers | 17 | 17060000003900 | 17060000003900 | 1 | PA721750 | auteur | |
| 17060000004171 | L17/dossiers | 17 | 17060000004170 | 17060000004170 | 1 | PO717460 | ||
| 17060000004174 | L17/dossiers | 17 | 17060000004173 | 17060000004173 | 1 | PO717460 | ||
| 17060000004177 | L17/dossiers | 17 | 17060000004176 | 17060000004176 | 1 | PO717460 | ||
| 17060000004180 | L17/dossiers | 17 | 17060000004179 | 17060000004179 | 1 | PO717460 | ||
| 17060000004183 | L17/dossiers | 17 | 17060000004182 | 17060000004182 | 1 | PO717460 | ||
| 17060000004186 | L17/dossiers | 17 | 17060000004185 | 17060000004185 | 1 | PO717460 | ||
| 17060000004189 | L17/dossiers | 17 | 17060000004188 | 17060000004188 | 1 | PO717460 | ||
| 17060000004192 | L17/dossiers | 17 | 17060000004191 | 17060000004191 | 1 | PO717460 | ||
| 17060000004195 | L17/dossiers | 17 | 17060000004194 | 17060000004194 | 1 | PO717460 | ||
| 17060000004198 | L17/dossiers | 17 | 17060000004197 | 17060000004197 | 1 | PO717460 | ||
| 17060000004201 | L17/dossiers | 17 | 17060000004200 | 17060000004200 | 1 | PA719874 | auteur | |
| 17060000004252 | L17/dossiers | 17 | 17060000004251 | 17060000004251 | 1 | PA720846 | auteur | |
| 17060000004298 | L17/dossiers | 17 | 17060000004297 | 17060000004297 | 1 | PO717460 | ||
| 17060000004301 | L17/dossiers | 17 | 17060000004300 | 17060000004300 | 1 | PO717460 | ||
| 17060000004304 | L17/dossiers | 17 | 17060000004303 | 17060000004303 | 1 | PO717460 | ||
| 17060000004307 | L17/dossiers | 17 | 17060000004306 | 17060000004306 | 1 | PO717460 | ||
| 17060000004310 | L17/dossiers | 17 | 17060000004309 | 17060000004309 | 1 | PO717460 | ||
| 17060000004313 | L17/dossiers | 17 | 17060000004312 | 17060000004312 | 1 | PO717460 | ||
| 17060000004316 | L17/dossiers | 17 | 17060000004315 | 17060000004315 | 1 | PO717460 | ||
| 17060000004319 | L17/dossiers | 17 | 17060000004318 | 17060000004318 | 1 | PO717460 | ||
| 17060000004322 | L17/dossiers | 17 | 17060000004321 | 17060000004321 | 1 | PO717460 | ||
| 17060000004325 | L17/dossiers | 17 | 17060000004324 | 17060000004324 | 1 | PO717460 | ||
| 17060000004327 | L17/dossiers | 17 | 17060000004326 | 17060000004326 | 1 | PO717460 | ||
| 17060000004330 | L17/dossiers | 17 | 17060000004329 | 17060000004329 | 1 | PO717460 | ||
| 17060000004333 | L17/dossiers | 17 | 17060000004332 | 17060000004332 | 1 | PO717460 | ||
| 17060000004336 | L17/dossiers | 17 | 17060000004335 | 17060000004335 | 1 | PO717460 | ||
| 17060000004339 | L17/dossiers | 17 | 17060000004338 | 17060000004338 | 1 | PA607553 | rapporteur | |
| 17060000004340 | L17/dossiers | 17 | 17060000004338 | 17060000004338 | 2 | PO420120 | ||
| 17060000004343 | L17/dossiers | 17 | 17060000004342 | 17060000004342 | 1 | PA720170 | rapporteur | |
| 17060000004344 | L17/dossiers | 17 | 17060000004342 | 17060000004342 | 2 | PA720480 | rapporteur | |
| 17060000004345 | L17/dossiers | 17 | 17060000004342 | 17060000004342 | 3 | PO420120 | ||
| 17060000004348 | L17/dossiers | 17 | 17060000004347 | 17060000004347 | 1 | PA721750 | rapporteur | |
| 17060000004349 | L17/dossiers | 17 | 17060000004347 | 17060000004347 | 2 | PA721888 | rapporteur | |
| 17060000004350 | L17/dossiers | 17 | 17060000004347 | 17060000004347 | 3 | PA718902 | rapporteur | |
| 17060000004351 | L17/dossiers | 17 | 17060000004347 | 17060000004347 | 4 | PO419604 | ||
| 17060000004354 | L17/dossiers | 17 | 17060000004353 | 17060000004353 | 1 | PA720170 | rapporteur | |
| 17060000004355 | L17/dossiers | 17 | 17060000004353 | 17060000004353 | 2 | PA720480 | rapporteur | |
| 17060000004356 | L17/dossiers | 17 | 17060000004353 | 17060000004353 | 3 | PO784418 | ||
| 17060000004358 | L17/dossiers | 17 | 17060000004357 | 17060000004357 | 1 | PA719874 | rapporteur | |
| 17060000004359 | L17/dossiers | 17 | 17060000004357 | 17060000004357 | 2 | PO59051 |