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 |
|---|---|---|---|---|---|---|---|---|
| 17060000004505 | L17/dossiers | 17 | 17060000004504 | 17060000004504 | 1 | PO791932 | ||
| 17060000004508 | L17/dossiers | 17 | 17060000004507 | 17060000004507 | 1 | PO791932 | ||
| 17060000004511 | L17/dossiers | 17 | 17060000004510 | 17060000004510 | 1 | PO791932 | ||
| 17060000004514 | L17/dossiers | 17 | 17060000004513 | 17060000004513 | 1 | PO791932 | ||
| 17060000004517 | L17/dossiers | 17 | 17060000004516 | 17060000004516 | 1 | PO791932 | ||
| 17060000004520 | L17/dossiers | 17 | 17060000004519 | 17060000004519 | 1 | PO791932 | ||
| 17060000004523 | L17/dossiers | 17 | 17060000004522 | 17060000004522 | 1 | PO791932 | ||
| 17060000004526 | L17/dossiers | 17 | 17060000004525 | 17060000004525 | 1 | PO791932 | ||
| 17060000004529 | L17/dossiers | 17 | 17060000004528 | 17060000004528 | 1 | PO791932 | ||
| 17060000004532 | L17/dossiers | 17 | 17060000004531 | 17060000004531 | 1 | PO791932 | ||
| 17060000004535 | L17/dossiers | 17 | 17060000004534 | 17060000004534 | 1 | PO791932 | ||
| 17060000004538 | L17/dossiers | 17 | 17060000004537 | 17060000004537 | 1 | PO791932 | ||
| 17060000004541 | L17/dossiers | 17 | 17060000004540 | 17060000004540 | 1 | PO791932 | ||
| 17060000004544 | L17/dossiers | 17 | 17060000004543 | 17060000004543 | 1 | PO791932 | ||
| 17060000004547 | L17/dossiers | 17 | 17060000004546 | 17060000004546 | 1 | PO791932 | ||
| 17060000004550 | L17/dossiers | 17 | 17060000004549 | 17060000004549 | 1 | PO791932 | ||
| 17060000004553 | L17/dossiers | 17 | 17060000004552 | 17060000004552 | 1 | PO791932 | ||
| 17060000004556 | L17/dossiers | 17 | 17060000004555 | 17060000004555 | 1 | PO791932 | ||
| 17060000004559 | L17/dossiers | 17 | 17060000004558 | 17060000004558 | 1 | PO791932 | ||
| 17060000004562 | L17/dossiers | 17 | 17060000004561 | 17060000004561 | 1 | PO791932 | ||
| 17060000004565 | L17/dossiers | 17 | 17060000004564 | 17060000004564 | 1 | PO791932 | ||
| 17060000004568 | L17/dossiers | 17 | 17060000004567 | 17060000004567 | 1 | PO791932 | ||
| 17060000004571 | L17/dossiers | 17 | 17060000004570 | 17060000004570 | 1 | PO791932 | ||
| 17060000004574 | L17/dossiers | 17 | 17060000004573 | 17060000004573 | 1 | PO791932 | ||
| 17060000004577 | L17/dossiers | 17 | 17060000004576 | 17060000004576 | 1 | PO791932 | ||
| 17060000004580 | L17/dossiers | 17 | 17060000004579 | 17060000004579 | 1 | PO791932 | ||
| 17060000004583 | L17/dossiers | 17 | 17060000004582 | 17060000004582 | 1 | PO791932 | ||
| 17060000004586 | L17/dossiers | 17 | 17060000004585 | 17060000004585 | 1 | PO791932 | ||
| 17060000004589 | L17/dossiers | 17 | 17060000004588 | 17060000004588 | 1 | PO791932 | ||
| 17060000004592 | L17/dossiers | 17 | 17060000004591 | 17060000004591 | 1 | PO791932 | ||
| 17060000004595 | L17/dossiers | 17 | 17060000004594 | 17060000004594 | 1 | PO791932 | ||
| 17060000004598 | L17/dossiers | 17 | 17060000004597 | 17060000004597 | 1 | PO791932 | ||
| 17060000004601 | L17/dossiers | 17 | 17060000004600 | 17060000004600 | 1 | PO791932 | ||
| 17060000004604 | L17/dossiers | 17 | 17060000004603 | 17060000004603 | 1 | PO791932 | ||
| 17060000004607 | L17/dossiers | 17 | 17060000004606 | 17060000004606 | 1 | PO791932 | ||
| 17060000004610 | L17/dossiers | 17 | 17060000004609 | 17060000004609 | 1 | PO791932 | ||
| 17060000004613 | L17/dossiers | 17 | 17060000004612 | 17060000004612 | 1 | PO791932 | ||
| 17060000004616 | L17/dossiers | 17 | 17060000004615 | 17060000004615 | 1 | PO791932 | ||
| 17060000004619 | L17/dossiers | 17 | 17060000004618 | 17060000004618 | 1 | PO791932 | ||
| 17060000004622 | L17/dossiers | 17 | 17060000004621 | 17060000004621 | 1 | PO791932 | ||
| 17060000004625 | L17/dossiers | 17 | 17060000004624 | 17060000004624 | 1 | PO791932 | ||
| 17060000004628 | L17/dossiers | 17 | 17060000004627 | 17060000004627 | 1 | PO791932 | ||
| 17060000004631 | L17/dossiers | 17 | 17060000004630 | 17060000004630 | 1 | PO791932 | ||
| 17060000004634 | L17/dossiers | 17 | 17060000004633 | 17060000004633 | 1 | PO791932 | ||
| 17060000004637 | L17/dossiers | 17 | 17060000004636 | 17060000004636 | 1 | PO791932 | ||
| 17060000004640 | L17/dossiers | 17 | 17060000004639 | 17060000004639 | 1 | PO791932 | ||
| 17060000004643 | L17/dossiers | 17 | 17060000004642 | 17060000004642 | 1 | PO791932 | ||
| 17060000004646 | L17/dossiers | 17 | 17060000004645 | 17060000004645 | 1 | PO791932 | ||
| 17060000004649 | L17/dossiers | 17 | 17060000004648 | 17060000004648 | 1 | PO791932 | ||
| 17060000004652 | L17/dossiers | 17 | 17060000004651 | 17060000004651 | 1 | PO791932 |