dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
60 224 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 72 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 72 %, 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 58 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 14060000084368 | L14/dossiers | 14 | 14060000084339 | 14060000084339 | 1 | PO644420 | ||
| 14060000084409 | L14/dossiers | 14 | 14060000084369 | 14060000084369 | 1 | PO644420 | ||
| 14060000084432 | L14/dossiers | 14 | 14060000084410 | 14060000084410 | 1 | PO644420 | ||
| 14060000084458 | L14/dossiers | 14 | 14060000084433 | 14060000084433 | 1 | PO644420 | ||
| 14060000084460 | L14/dossiers | 14 | 14060000084459 | 14060000084459 | 1 | PA267622 | auteur | |
| 14060000084462 | L14/dossiers | 14 | 14060000084461 | 14060000084461 | 1 | PA415448 | rapporteur | |
| 14060000084463 | L14/dossiers | 14 | 14060000084461 | 14060000084461 | 2 | PO211494 | ||
| 14060000084627 | L14/dossiers | 14 | 14060000084464 | 14060000084464 | 1 | PA609590 | rapporteur général | |
| 14060000084628 | L14/dossiers | 14 | 14060000084464 | 14060000084464 | 2 | PO59048 | ||
| 14060000084633 | L14/dossiers | 14 | 14060000084629 | 14060000084629 | 1 | PA415448 | rapporteur | |
| 14060000084634 | L14/dossiers | 14 | 14060000084629 | 14060000084629 | 2 | PO211494 | ||
| 14060000084636 | L14/dossiers | 14 | 14060000084635 | 14060000084635 | 1 | PA609590 | rapporteur | |
| 14060000084637 | L14/dossiers | 14 | 14060000084635 | 14060000084635 | 2 | PO705223 | ||
| 14060000084639 | L14/dossiers | 14 | 14060000084638 | 14060000084638 | 1 | PA609590 | rapporteur général | |
| 14060000084640 | L14/dossiers | 14 | 14060000084638 | 14060000084638 | 2 | PO59048 | ||
| 14060000084642 | L14/dossiers | 14 | 14060000084641 | 14060000084641 | 1 | PA415448 | rapporteur | |
| 14060000084643 | L14/dossiers | 14 | 14060000084641 | 14060000084641 | 2 | PO705223 | ||
| 14060000084651 | L14/dossiers | 14 | 14060000084644 | 14060000084644 | 1 | PA609590 | rapporteur général | |
| 14060000084652 | L14/dossiers | 14 | 14060000084644 | 14060000084644 | 2 | PO59048 | ||
| 14060000084654 | L14/dossiers | 14 | 14060000084653 | 14060000084653 | 1 | PA607761 | auteur | |
| 14060000084656 | L14/dossiers | 14 | 14060000084655 | 14060000084655 | 1 | PA333134 | rapporteur | |
| 14060000084657 | L14/dossiers | 14 | 14060000084655 | 14060000084655 | 2 | PA332614 | rapporteur | |
| 14060000084658 | L14/dossiers | 14 | 14060000084655 | 14060000084655 | 3 | PO695919 | ||
| 14060000084660 | L14/dossiers | 14 | 14060000084659 | 14060000084659 | 1 | PA331594 | rapporteur | |
| 14060000084661 | L14/dossiers | 14 | 14060000084659 | 14060000084659 | 2 | PO59051 | ||
| 14060000084663 | L14/dossiers | 14 | 14060000084662 | 14060000084662 | 1 | PA346886 | auteur | |
| 14060000084666 | L14/dossiers | 14 | 14060000084665 | 14060000084665 | 1 | PA328 | auteur | |
| 14060000084670 | L14/dossiers | 14 | 14060000084669 | 14060000084669 | 1 | PA328 | auteur | |
| 14060000084672 | L14/dossiers | 14 | 14060000084671 | 14060000084671 | 1 | PO644420 | ||
| 14060000084675 | L14/dossiers | 14 | 14060000084674 | 14060000084674 | 1 | PA267622 | auteur | |
| 14060000084678 | L14/dossiers | 14 | 14060000084677 | 14060000084677 | 1 | PA334768 | rapporteur | |
| 14060000084679 | L14/dossiers | 14 | 14060000084677 | 14060000084677 | 2 | PO420120 | ||
| 14060000084682 | L14/dossiers | 14 | 14060000084681 | 14060000084681 | 1 | PO78718 | ||
| 14060000084684 | L14/dossiers | 14 | 14060000084683 | 14060000084683 | 1 | PA360 | rapporteur | |
| 14060000084685 | L14/dossiers | 14 | 14060000084683 | 14060000084683 | 2 | PO715554 | ||
| 14060000084687 | L14/dossiers | 14 | 14060000084686 | 14060000084686 | 1 | PA267622 | auteur | |
| 14060000084692 | L14/dossiers | 14 | 14060000084688 | 14060000084688 | 1 | PA334768 | rapporteur | |
| 14060000084693 | L14/dossiers | 14 | 14060000084688 | 14060000084688 | 2 | PO420120 | ||
| 14060000084695 | L14/dossiers | 14 | 14060000084694 | 14060000084694 | 1 | PA334768 | rapporteur | |
| 14060000084696 | L14/dossiers | 14 | 14060000084694 | 14060000084694 | 2 | PO715554 | ||
| 14060000084698 | L14/dossiers | 14 | 14060000084697 | 14060000084697 | 1 | PA785 | auteur | |
| 14060000084701 | L14/dossiers | 14 | 14060000084700 | 14060000084700 | 1 | PA267622 | auteur | |
| 14060000084704 | L14/dossiers | 14 | 14060000084703 | 14060000084703 | 1 | PA713448 | auteur | |
| 14060000084708 | L14/dossiers | 14 | 14060000084707 | 14060000084707 | 1 | PA346 | auteur | |
| 14060000084711 | L14/dossiers | 14 | 14060000084710 | 14060000084710 | 1 | PO644420 | ||
| 14060000084714 | L14/dossiers | 14 | 14060000084713 | 14060000084713 | 1 | PO78718 | ||
| 14060000084716 | L14/dossiers | 14 | 14060000084715 | 14060000084715 | 1 | PO78718 | ||
| 14060000084718 | L14/dossiers | 14 | 14060000084717 | 14060000084717 | 1 | PA328 | auteur | |
| 14060000084722 | L14/dossiers | 14 | 14060000084721 | 14060000084721 | 1 | PO644420 | ||
| 14060000084725 | L14/dossiers | 14 | 14060000084724 | 14060000084724 | 1 | PA1243 | rapporteur |