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 |
|---|---|---|---|---|---|---|---|---|
| 16060000064415 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 17 | PA703536 | auteur | |
| 16060000064416 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 18 | PA775256 | auteur | |
| 16060000064417 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 19 | PA610850 | auteur | |
| 16060000064418 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 20 | PA775274 | auteur | |
| 16060000064419 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 21 | PA643028 | auteur | |
| 16060000064420 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 22 | PA736214 | auteur | |
| 16060000064421 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 23 | PA736217 | auteur | |
| 16060000064422 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 24 | PA828014 | auteur | |
| 16060000064423 | L16/dossiers | 16 | 16060000064398 | 16060000064398 | 25 | PA828018 | auteur | |
| 16060000064425 | L16/dossiers | 16 | 16060000064424 | 16060000064424 | 1 | PA827894 | auteur | |
| 16060000064427 | L16/dossiers | 16 | 16060000064426 | 16060000064426 | 1 | PA827904 | auteur | |
| 16060000064429 | L16/dossiers | 16 | 16060000064428 | 16060000064428 | 1 | PO78718 | ||
| 16060000064431 | L16/dossiers | 16 | 16060000064430 | 16060000064430 | 1 | PO78718 | ||
| 16060000064433 | L16/dossiers | 16 | 16060000064432 | 16060000064432 | 1 | PO78718 | ||
| 16060000064435 | L16/dossiers | 16 | 16060000064434 | 16060000064434 | 1 | PO78718 | ||
| 16060000064437 | L16/dossiers | 16 | 16060000064436 | 16060000064436 | 1 | PO78718 | ||
| 16060000064439 | L16/dossiers | 16 | 16060000064438 | 16060000064438 | 1 | PO78718 | ||
| 16060000064441 | L16/dossiers | 16 | 16060000064440 | 16060000064440 | 1 | PO78718 | ||
| 16060000064443 | L16/dossiers | 16 | 16060000064442 | 16060000064442 | 1 | PO78718 | ||
| 16060000064445 | L16/dossiers | 16 | 16060000064444 | 16060000064444 | 1 | PO78718 | ||
| 16060000064447 | L16/dossiers | 16 | 16060000064446 | 16060000064446 | 1 | PO78718 | ||
| 16060000064449 | L16/dossiers | 16 | 16060000064448 | 16060000064448 | 1 | PO78718 | ||
| 16060000064451 | L16/dossiers | 16 | 16060000064450 | 16060000064450 | 1 | PO78718 | ||
| 16060000064453 | L16/dossiers | 16 | 16060000064452 | 16060000064452 | 1 | PO78718 | ||
| 16060000064455 | L16/dossiers | 16 | 16060000064454 | 16060000064454 | 1 | PO78718 | ||
| 16060000064457 | L16/dossiers | 16 | 16060000064456 | 16060000064456 | 1 | PO78718 | ||
| 16060000064459 | L16/dossiers | 16 | 16060000064458 | 16060000064458 | 1 | PO78718 | ||
| 16060000064461 | L16/dossiers | 16 | 16060000064460 | 16060000064460 | 1 | PO78718 | ||
| 16060000064463 | L16/dossiers | 16 | 16060000064462 | 16060000064462 | 1 | PO78718 | ||
| 16060000064465 | L16/dossiers | 16 | 16060000064464 | 16060000064464 | 1 | PO78718 | ||
| 16060000064467 | L16/dossiers | 16 | 16060000064466 | 16060000064466 | 1 | PO78718 | ||
| 16060000064469 | L16/dossiers | 16 | 16060000064468 | 16060000064468 | 1 | PO78718 | ||
| 16060000064471 | L16/dossiers | 16 | 16060000064470 | 16060000064470 | 1 | PO78718 | ||
| 16060000064473 | L16/dossiers | 16 | 16060000064472 | 16060000064472 | 1 | PO78718 | ||
| 16060000064475 | L16/dossiers | 16 | 16060000064474 | 16060000064474 | 1 | PO78718 | ||
| 16060000064477 | L16/dossiers | 16 | 16060000064476 | 16060000064476 | 1 | PO78718 | ||
| 16060000064479 | L16/dossiers | 16 | 16060000064478 | 16060000064478 | 1 | PO78718 | ||
| 16060000064481 | L16/dossiers | 16 | 16060000064480 | 16060000064480 | 1 | PO78718 | ||
| 16060000064483 | L16/dossiers | 16 | 16060000064482 | 16060000064482 | 1 | PO78718 | ||
| 16060000064485 | L16/dossiers | 16 | 16060000064484 | 16060000064484 | 1 | PO78718 | ||
| 16060000064487 | L16/dossiers | 16 | 16060000064486 | 16060000064486 | 1 | PO78718 | ||
| 16060000064489 | L16/dossiers | 16 | 16060000064488 | 16060000064488 | 1 | PO78718 | ||
| 16060000064491 | L16/dossiers | 16 | 16060000064490 | 16060000064490 | 1 | PO78718 | ||
| 16060000064493 | L16/dossiers | 16 | 16060000064492 | 16060000064492 | 1 | PO78718 | ||
| 16060000064495 | L16/dossiers | 16 | 16060000064494 | 16060000064494 | 1 | PO78718 | ||
| 16060000064497 | L16/dossiers | 16 | 16060000064496 | 16060000064496 | 1 | PO78718 | ||
| 16060000064499 | L16/dossiers | 16 | 16060000064498 | 16060000064498 | 1 | PO78718 | ||
| 16060000064501 | L16/dossiers | 16 | 16060000064500 | 16060000064500 | 1 | PO78718 | ||
| 16060000064503 | L16/dossiers | 16 | 16060000064502 | 16060000064502 | 1 | PO78718 | ||
| 16060000064505 | L16/dossiers | 16 | 16060000064504 | 16060000064504 | 1 | PO78718 |