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 |
|---|---|---|---|---|---|---|---|---|
| 17060000107647 | L17/dossiers | 17 | 17060000107643 | 17060000107643 | 1 | PA794466 | rapporteur | |
| 17060000107648 | L17/dossiers | 17 | 17060000107643 | 17060000107643 | 2 | PO59051 | ||
| 17060000107653 | L17/dossiers | 17 | 17060000107649 | 17060000107649 | 1 | PA793174 | rapporteur | |
| 17060000107654 | L17/dossiers | 17 | 17060000107649 | 17060000107649 | 2 | PO59048 | ||
| 17060000107659 | L17/dossiers | 17 | 17060000107655 | 17060000107655 | 1 | PA795998 | rapporteur | |
| 17060000107660 | L17/dossiers | 17 | 17060000107655 | 17060000107655 | 2 | PO420120 | ||
| 17060000107665 | L17/dossiers | 17 | 17060000107661 | 17060000107661 | 1 | PA795746 | rapporteur | |
| 17060000107666 | L17/dossiers | 17 | 17060000107661 | 17060000107661 | 2 | PO852507 | ||
| 17060000107668 | L17/dossiers | 17 | 17060000107667 | 17060000107667 | 1 | PA795864 | rapporteur | |
| 17060000107669 | L17/dossiers | 17 | 17060000107667 | 17060000107667 | 2 | PO415287 | ||
| 17060000107674 | L17/dossiers | 17 | 17060000107670 | 17060000107670 | 1 | PA795876 | rapporteur | |
| 17060000107675 | L17/dossiers | 17 | 17060000107670 | 17060000107670 | 2 | PO59051 | ||
| 17060000107680 | L17/dossiers | 17 | 17060000107676 | 17060000107676 | 1 | PA721474 | rapporteur | |
| 17060000107681 | L17/dossiers | 17 | 17060000107676 | 17060000107676 | 2 | PO420120 | ||
| 17060000107683 | L17/dossiers | 17 | 17060000107682 | 17060000107682 | 1 | PA841701 | rapporteur | |
| 17060000107684 | L17/dossiers | 17 | 17060000107682 | 17060000107682 | 2 | PO59051 | ||
| 17060000107686 | L17/dossiers | 17 | 17060000107685 | 17060000107685 | 1 | PA720154 | rapporteur | |
| 17060000107687 | L17/dossiers | 17 | 17060000107685 | 17060000107685 | 2 | PO869203 | ||
| 17060000107689 | L17/dossiers | 17 | 17060000107688 | 17060000107688 | 1 | PA842311 | rapporteur | |
| 17060000107690 | L17/dossiers | 17 | 17060000107688 | 17060000107688 | 2 | PA841419 | rapporteur | |
| 17060000107691 | L17/dossiers | 17 | 17060000107688 | 17060000107688 | 3 | PO59047 | ||
| 17060000107693 | L17/dossiers | 17 | 17060000107692 | 17060000107692 | 1 | PA642847 | rapporteur | |
| 17060000107694 | L17/dossiers | 17 | 17060000107692 | 17060000107692 | 2 | PO420120 | ||
| 17060000107702 | L17/dossiers | 17 | 17060000107695 | 17060000107695 | 1 | PA942 | rapporteur | |
| 17060000107703 | L17/dossiers | 17 | 17060000107695 | 17060000107695 | 2 | PO59048 | ||
| 17060000107708 | L17/dossiers | 17 | 17060000107704 | 17060000107704 | 1 | PA795144 | rapporteur | |
| 17060000107709 | L17/dossiers | 17 | 17060000107704 | 17060000107704 | 2 | PO419610 | ||
| 17060000107711 | L17/dossiers | 17 | 17060000107710 | 17060000107710 | 1 | PA720162 | rapporteur | |
| 17060000107712 | L17/dossiers | 17 | 17060000107710 | 17060000107710 | 2 | PO273589 | ||
| 17060000107720 | L17/dossiers | 17 | 17060000107713 | 17060000107713 | 1 | PA795240 | rapporteur | |
| 17060000107721 | L17/dossiers | 17 | 17060000107713 | 17060000107713 | 2 | PO854138 | ||
| 17060000107727 | L17/dossiers | 17 | 17060000107722 | 17060000107722 | 1 | PA335054 | rapporteur | |
| 17060000107728 | L17/dossiers | 17 | 17060000107722 | 17060000107722 | 2 | PA720552 | rapporteur | |
| 17060000107729 | L17/dossiers | 17 | 17060000107722 | 17060000107722 | 3 | PO419604 | ||
| 17060000107731 | L17/dossiers | 17 | 17060000107730 | 17060000107730 | 1 | PA841613 | rapporteur | |
| 17060000107732 | L17/dossiers | 17 | 17060000107730 | 17060000107730 | 2 | PO59047 | ||
| 17060000107734 | L17/dossiers | 17 | 17060000107733 | 17060000107733 | 1 | PA795046 | rapporteur | |
| 17060000107735 | L17/dossiers | 17 | 17060000107733 | 17060000107733 | 2 | PO415287 | ||
| 17060000107743 | L17/dossiers | 17 | 17060000107736 | 17060000107736 | 1 | PA331582 | rapporteur | |
| 17060000107744 | L17/dossiers | 17 | 17060000107736 | 17060000107736 | 2 | PA266797 | rapporteur | |
| 17060000107745 | L17/dossiers | 17 | 17060000107736 | 17060000107736 | 3 | PA267780 | rapporteur | |
| 17060000107746 | L17/dossiers | 17 | 17060000107736 | 17060000107736 | 4 | PA796078 | rapporteur | |
| 17060000107747 | L17/dossiers | 17 | 17060000107736 | 17060000107736 | 5 | PO59051 | ||
| 17060000107749 | L17/dossiers | 17 | 17060000107748 | 17060000107748 | 1 | PA796078 | rapporteur | |
| 17060000107750 | L17/dossiers | 17 | 17060000107748 | 17060000107748 | 2 | PO59051 | ||
| 17060000107752 | L17/dossiers | 17 | 17060000107751 | 17060000107751 | 1 | PA841769 | rapporteur | |
| 17060000107753 | L17/dossiers | 17 | 17060000107751 | 17060000107751 | 2 | PO59051 | ||
| 17060000107758 | L17/dossiers | 17 | 17060000107754 | 17060000107754 | 1 | PA841769 | rapporteur | |
| 17060000107759 | L17/dossiers | 17 | 17060000107754 | 17060000107754 | 2 | PO59051 | ||
| 17060000107764 | L17/dossiers | 17 | 17060000107760 | 17060000107760 | 1 | PA267561 | rapporteur |