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 |
|---|---|---|---|---|---|---|---|---|
| 16060000089472 | L16/dossiers | 16 | 16060000089471 | 16060000089471 | 1 | PA721608 | rapporteur | |
| 16060000089473 | L16/dossiers | 16 | 16060000089471 | 16060000089471 | 2 | PO59047 | ||
| 16060000089475 | L16/dossiers | 16 | 16060000089474 | 16060000089474 | 1 | PA795508 | rapporteur | |
| 16060000089476 | L16/dossiers | 16 | 16060000089474 | 16060000089474 | 2 | PO201269 | ||
| 16060000089478 | L16/dossiers | 16 | 16060000089477 | 16060000089477 | 1 | PA794322 | rapporteur | |
| 16060000089479 | L16/dossiers | 16 | 16060000089477 | 16060000089477 | 2 | PA794386 | rapporteur | |
| 16060000089480 | L16/dossiers | 16 | 16060000089477 | 16060000089477 | 3 | PO415287 | ||
| 16060000089482 | L16/dossiers | 16 | 16060000089481 | 16060000089481 | 1 | PA794982 | rapporteur | |
| 16060000089483 | L16/dossiers | 16 | 16060000089481 | 16060000089481 | 2 | PO201269 | ||
| 16060000089485 | L16/dossiers | 16 | 16060000089484 | 16060000089484 | 1 | PA340643 | rapporteur | |
| 16060000089486 | L16/dossiers | 16 | 16060000089484 | 16060000089484 | 2 | PA721486 | rapporteur | |
| 16060000089487 | L16/dossiers | 16 | 16060000089484 | 16060000089484 | 3 | PO59046 | ||
| 16060000089489 | L16/dossiers | 16 | 16060000089488 | 16060000089488 | 1 | PA722284 | rapporteur | |
| 16060000089490 | L16/dossiers | 16 | 16060000089488 | 16060000089488 | 2 | PA267794 | rapporteur | |
| 16060000089491 | L16/dossiers | 16 | 16060000089488 | 16060000089488 | 3 | PO59047 | ||
| 16060000089493 | L16/dossiers | 16 | 16060000089492 | 16060000089492 | 1 | PA721710 | rapporteur | |
| 16060000089494 | L16/dossiers | 16 | 16060000089492 | 16060000089492 | 2 | PA774960 | rapporteur | |
| 16060000089495 | L16/dossiers | 16 | 16060000089492 | 16060000089492 | 3 | PO804431 | ||
| 16060000089497 | L16/dossiers | 16 | 16060000089496 | 16060000089496 | 1 | PA719024 | rapporteur | |
| 16060000089498 | L16/dossiers | 16 | 16060000089496 | 16060000089496 | 2 | PA793616 | rapporteur | |
| 16060000089499 | L16/dossiers | 16 | 16060000089496 | 16060000089496 | 3 | PO420375 | ||
| 16060000089501 | L16/dossiers | 16 | 16060000089500 | 16060000089500 | 1 | PA793780 | rapporteur | |
| 16060000089502 | L16/dossiers | 16 | 16060000089500 | 16060000089500 | 2 | PO273589 | ||
| 16060000089504 | L16/dossiers | 16 | 16060000089503 | 16060000089503 | 1 | PA794004 | rapporteur | |
| 16060000089505 | L16/dossiers | 16 | 16060000089503 | 16060000089503 | 2 | PA794994 | rapporteur | |
| 16060000089506 | L16/dossiers | 16 | 16060000089503 | 16060000089503 | 3 | PO804431 | ||
| 16060000089508 | L16/dossiers | 16 | 16060000089507 | 16060000089507 | 1 | PA720684 | rapporteur | |
| 16060000089509 | L16/dossiers | 16 | 16060000089507 | 16060000089507 | 2 | PO415287 | ||
| 16060000089511 | L16/dossiers | 16 | 16060000089510 | 16060000089510 | 1 | PA794022 | rapporteur | |
| 16060000089512 | L16/dossiers | 16 | 16060000089510 | 16060000089510 | 2 | PA719600 | rapporteur | |
| 16060000089513 | L16/dossiers | 16 | 16060000089510 | 16060000089510 | 3 | PO59051 | ||
| 16060000089515 | L16/dossiers | 16 | 16060000089514 | 16060000089514 | 1 | PA335054 | rapporteur | |
| 16060000089516 | L16/dossiers | 16 | 16060000089514 | 16060000089514 | 2 | PA719822 | rapporteur | |
| 16060000089517 | L16/dossiers | 16 | 16060000089514 | 16060000089514 | 3 | PO415287 | ||
| 16060000089519 | L16/dossiers | 16 | 16060000089518 | 16060000089518 | 1 | PA718962 | rapporteur | |
| 16060000089520 | L16/dossiers | 16 | 16060000089518 | 16060000089518 | 2 | PA795868 | rapporteur | |
| 16060000089521 | L16/dossiers | 16 | 16060000089518 | 16060000089518 | 3 | PA795310 | rapporteur | |
| 16060000089522 | L16/dossiers | 16 | 16060000089518 | 16060000089518 | 4 | PA774958 | rapporteur | |
| 16060000089523 | L16/dossiers | 16 | 16060000089518 | 16060000089518 | 5 | PO419865 | ||
| 16060000089525 | L16/dossiers | 16 | 16060000089524 | 16060000089524 | 1 | PA794510 | rapporteur | |
| 16060000089526 | L16/dossiers | 16 | 16060000089524 | 16060000089524 | 2 | PA721270 | rapporteur | |
| 16060000089527 | L16/dossiers | 16 | 16060000089524 | 16060000089524 | 3 | PO420375 | ||
| 16060000089529 | L16/dossiers | 16 | 16060000089528 | 16060000089528 | 1 | PA719338 | rapporteur | |
| 16060000089530 | L16/dossiers | 16 | 16060000089528 | 16060000089528 | 2 | PA795794 | rapporteur | |
| 16060000089531 | L16/dossiers | 16 | 16060000089528 | 16060000089528 | 3 | PO419604 | ||
| 16060000089533 | L16/dossiers | 16 | 16060000089532 | 16060000089532 | 1 | PA793980 | rapporteur | |
| 16060000089534 | L16/dossiers | 16 | 16060000089532 | 16060000089532 | 2 | PA719080 | rapporteur | |
| 16060000089535 | L16/dossiers | 16 | 16060000089532 | 16060000089532 | 3 | PO419610 | ||
| 16060000089537 | L16/dossiers | 16 | 16060000089536 | 16060000089536 | 1 | PA719032 | rapporteur | |
| 16060000089538 | L16/dossiers | 16 | 16060000089536 | 16060000089536 | 2 | PO304272 |