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 |
|---|---|---|---|---|---|---|---|---|
| 17060000111599 | L17/dossiers | 17 | 17060000111598 | 17060000111598 | 1 | PA794478 | rapporteur | |
| 17060000111600 | L17/dossiers | 17 | 17060000111598 | 17060000111598 | 2 | PO59048 | ||
| 17060000111602 | L17/dossiers | 17 | 17060000111601 | 17060000111601 | 1 | PA841107 | rapporteur | |
| 17060000111603 | L17/dossiers | 17 | 17060000111601 | 17060000111601 | 2 | PO59048 | ||
| 17060000111605 | L17/dossiers | 17 | 17060000111604 | 17060000111604 | 1 | PA841487 | rapporteur | |
| 17060000111606 | L17/dossiers | 17 | 17060000111604 | 17060000111604 | 2 | PO59048 | ||
| 17060000111608 | L17/dossiers | 17 | 17060000111607 | 17060000111607 | 1 | PA841251 | rapporteur | |
| 17060000111609 | L17/dossiers | 17 | 17060000111607 | 17060000111607 | 2 | PA605745 | rapporteur | |
| 17060000111610 | L17/dossiers | 17 | 17060000111607 | 17060000111607 | 3 | PO59048 | ||
| 17060000111612 | L17/dossiers | 17 | 17060000111611 | 17060000111611 | 1 | PA791824 | rapporteur | |
| 17060000111613 | L17/dossiers | 17 | 17060000111611 | 17060000111611 | 2 | PA794702 | rapporteur | |
| 17060000111614 | L17/dossiers | 17 | 17060000111611 | 17060000111611 | 3 | PO201269 | ||
| 17060000111616 | L17/dossiers | 17 | 17060000111615 | 17060000111615 | 1 | PA721004 | rapporteur | |
| 17060000111617 | L17/dossiers | 17 | 17060000111615 | 17060000111615 | 2 | PA720952 | rapporteur | |
| 17060000111618 | L17/dossiers | 17 | 17060000111615 | 17060000111615 | 3 | PO59047 | ||
| 17060000111620 | L17/dossiers | 17 | 17060000111619 | 17060000111619 | 1 | PA606793 | rapporteur | |
| 17060000111621 | L17/dossiers | 17 | 17060000111619 | 17060000111619 | 2 | PA719640 | rapporteur | |
| 17060000111622 | L17/dossiers | 17 | 17060000111619 | 17060000111619 | 3 | PO59048 | ||
| 17060000111624 | L17/dossiers | 17 | 17060000111623 | 17060000111623 | 1 | PA795778 | rapporteur | |
| 17060000111625 | L17/dossiers | 17 | 17060000111623 | 17060000111623 | 2 | PO59048 | ||
| 17060000111627 | L17/dossiers | 17 | 17060000111626 | 17060000111626 | 1 | PA794954 | rapporteur | |
| 17060000111628 | L17/dossiers | 17 | 17060000111626 | 17060000111626 | 2 | PO59048 | ||
| 17060000111630 | L17/dossiers | 17 | 17060000111629 | 17060000111629 | 1 | PA841539 | rapporteur | |
| 17060000111631 | L17/dossiers | 17 | 17060000111629 | 17060000111629 | 2 | PA719080 | rapporteur | |
| 17060000111632 | L17/dossiers | 17 | 17060000111629 | 17060000111629 | 3 | PO420375 | ||
| 17060000111634 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 1 | PA795588 | rapporteur | |
| 17060000111635 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 2 | PA793736 | rapporteur | |
| 17060000111636 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 3 | PA794678 | rapporteur | |
| 17060000111637 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 4 | PA722374 | rapporteur | |
| 17060000111638 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 5 | PA793174 | rapporteur | |
| 17060000111639 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 6 | PA793270 | rapporteur | |
| 17060000111640 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 7 | PA722102 | rapporteur | |
| 17060000111641 | L17/dossiers | 17 | 17060000111633 | 17060000111633 | 8 | PO420120 | ||
| 17060000111643 | L17/dossiers | 17 | 17060000111642 | 17060000111642 | 1 | PA266797 | rapporteur | |
| 17060000111644 | L17/dossiers | 17 | 17060000111642 | 17060000111642 | 2 | PA795176 | rapporteur | |
| 17060000111645 | L17/dossiers | 17 | 17060000111642 | 17060000111642 | 3 | PA795876 | rapporteur | |
| 17060000111646 | L17/dossiers | 17 | 17060000111642 | 17060000111642 | 4 | PA842299 | rapporteur | |
| 17060000111647 | L17/dossiers | 17 | 17060000111642 | 17060000111642 | 5 | PO675659 | ||
| 17060000111649 | L17/dossiers | 17 | 17060000111648 | 17060000111648 | 1 | PA841955 | rapporteur | |
| 17060000111650 | L17/dossiers | 17 | 17060000111648 | 17060000111648 | 2 | PO59048 | ||
| 17060000111652 | L17/dossiers | 17 | 17060000111651 | 17060000111651 | 1 | PA719798 | rapporteur | |
| 17060000111653 | L17/dossiers | 17 | 17060000111651 | 17060000111651 | 2 | PO59048 | ||
| 17060000111655 | L17/dossiers | 17 | 17060000111654 | 17060000111654 | 1 | PA793780 | rapporteur | |
| 17060000111656 | L17/dossiers | 17 | 17060000111654 | 17060000111654 | 2 | PO59048 | ||
| 17060000111658 | L17/dossiers | 17 | 17060000111657 | 17060000111657 | 1 | PA795422 | rapporteur | |
| 17060000111659 | L17/dossiers | 17 | 17060000111657 | 17060000111657 | 2 | PA841381 | rapporteur | |
| 17060000111660 | L17/dossiers | 17 | 17060000111657 | 17060000111657 | 3 | PO59048 | ||
| 17060000111662 | L17/dossiers | 17 | 17060000111661 | 17060000111661 | 1 | PA721916 | rapporteur | |
| 17060000111663 | L17/dossiers | 17 | 17060000111661 | 17060000111661 | 2 | PA341981 | rapporteur | |
| 17060000111664 | L17/dossiers | 17 | 17060000111661 | 17060000111661 | 3 | PO59046 |