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 |
|---|---|---|---|---|---|---|---|---|
| 17060000071697 | L17/dossiers | 17 | 17060000071696 | 17060000071696 | 1 | PA720992 | rapporteur | |
| 17060000071698 | L17/dossiers | 17 | 17060000071696 | 17060000071696 | 2 | PO59051 | ||
| 17060000071701 | L17/dossiers | 17 | 17060000071700 | 17060000071700 | 1 | PA718784 | rapporteur | |
| 17060000071702 | L17/dossiers | 17 | 17060000071700 | 17060000071700 | 2 | PA718784 | rapporteur | |
| 17060000071703 | L17/dossiers | 17 | 17060000071700 | 17060000071700 | 3 | PO59051 | ||
| 17060000071706 | L17/dossiers | 17 | 17060000071705 | 17060000071705 | 1 | PA345722 | rapporteur | |
| 17060000071707 | L17/dossiers | 17 | 17060000071705 | 17060000071705 | 2 | PA722070 | rapporteur | |
| 17060000071708 | L17/dossiers | 17 | 17060000071705 | 17060000071705 | 3 | PO419604 | ||
| 17060000071711 | L17/dossiers | 17 | 17060000071710 | 17060000071710 | 1 | PA794982 | rapporteur | |
| 17060000071712 | L17/dossiers | 17 | 17060000071710 | 17060000071710 | 2 | PO419604 | ||
| 17060000071715 | L17/dossiers | 17 | 17060000071714 | 17060000071714 | 1 | PA605694 | rapporteur | |
| 17060000071716 | L17/dossiers | 17 | 17060000071714 | 17060000071714 | 2 | PA795430 | rapporteur | |
| 17060000071717 | L17/dossiers | 17 | 17060000071714 | 17060000071714 | 3 | PA795108 | rapporteur | |
| 17060000071718 | L17/dossiers | 17 | 17060000071714 | 17060000071714 | 4 | PA720446 | rapporteur | |
| 17060000071719 | L17/dossiers | 17 | 17060000071714 | 17060000071714 | 5 | PA793210 | rapporteur | |
| 17060000071720 | L17/dossiers | 17 | 17060000071714 | 17060000071714 | 6 | PO420120 | ||
| 17060000071723 | L17/dossiers | 17 | 17060000071722 | 17060000071722 | 1 | PA721584 | rapporteur | |
| 17060000071724 | L17/dossiers | 17 | 17060000071722 | 17060000071722 | 2 | PO868142 | ||
| 17060000071726 | L17/dossiers | 17 | 17060000071725 | 17060000071725 | 1 | PA793940 | rapporteur | |
| 17060000071727 | L17/dossiers | 17 | 17060000071725 | 17060000071725 | 2 | PO868165 | ||
| 17060000071729 | L17/dossiers | 17 | 17060000071728 | 17060000071728 | 1 | PA721474 | rapporteur | |
| 17060000071730 | L17/dossiers | 17 | 17060000071728 | 17060000071728 | 2 | PO59051 | ||
| 17060000071733 | L17/dossiers | 17 | 17060000071732 | 17060000071732 | 1 | PA721486 | rapporteur | |
| 17060000071734 | L17/dossiers | 17 | 17060000071732 | 17060000071732 | 2 | PO59051 | ||
| 17060000071737 | L17/dossiers | 17 | 17060000071736 | 17060000071736 | 1 | PA719286 | rapporteur | |
| 17060000071738 | L17/dossiers | 17 | 17060000071736 | 17060000071736 | 2 | PO420120 | ||
| 17060000071741 | L17/dossiers | 17 | 17060000071740 | 17060000071740 | 1 | PA794554 | rapporteur | |
| 17060000071742 | L17/dossiers | 17 | 17060000071740 | 17060000071740 | 2 | PO420120 | ||
| 17060000071745 | L17/dossiers | 17 | 17060000071744 | 17060000071744 | 1 | PA841017 | rapporteur | |
| 17060000071746 | L17/dossiers | 17 | 17060000071744 | 17060000071744 | 2 | PO419610 | ||
| 17060000071749 | L17/dossiers | 17 | 17060000071748 | 17060000071748 | 1 | PA712015 | rapporteur | |
| 17060000071750 | L17/dossiers | 17 | 17060000071748 | 17060000071748 | 2 | PO419610 | ||
| 17060000071754 | L17/dossiers | 17 | 17060000071753 | 17060000071753 | 1 | PA267780 | rapporteur | |
| 17060000071755 | L17/dossiers | 17 | 17060000071753 | 17060000071753 | 2 | PO869503 | ||
| 17060000071757 | L17/dossiers | 17 | 17060000071756 | 17060000071756 | 1 | PA793122 | rapporteur | |
| 17060000071758 | L17/dossiers | 17 | 17060000071756 | 17060000071756 | 2 | PO868336 | ||
| 17060000071760 | L17/dossiers | 17 | 17060000071759 | 17060000071759 | 1 | PA721584 | rapporteur | |
| 17060000071761 | L17/dossiers | 17 | 17060000071759 | 17060000071759 | 2 | PO419865 | ||
| 17060000071764 | L17/dossiers | 17 | 17060000071763 | 17060000071763 | 1 | PA795950 | rapporteur | |
| 17060000071765 | L17/dossiers | 17 | 17060000071763 | 17060000071763 | 2 | PO419610 | ||
| 17060000071768 | L17/dossiers | 17 | 17060000071767 | 17060000071767 | 1 | PA345722 | rapporteur | |
| 17060000071769 | L17/dossiers | 17 | 17060000071767 | 17060000071767 | 2 | PA722070 | rapporteur | |
| 17060000071770 | L17/dossiers | 17 | 17060000071767 | 17060000071767 | 3 | PO869346 | ||
| 17060000071772 | L17/dossiers | 17 | 17060000071771 | 17060000071771 | 1 | PA718850 | rapporteur | |
| 17060000071773 | L17/dossiers | 17 | 17060000071771 | 17060000071771 | 2 | PO420120 | ||
| 17060000071776 | L17/dossiers | 17 | 17060000071775 | 17060000071775 | 1 | PA794802 | rapporteur | |
| 17060000071777 | L17/dossiers | 17 | 17060000071775 | 17060000071775 | 2 | PO59046 | ||
| 17060000071780 | L17/dossiers | 17 | 17060000071779 | 17060000071779 | 1 | PA795664 | rapporteur | |
| 17060000071781 | L17/dossiers | 17 | 17060000071779 | 17060000071779 | 2 | PO59048 | ||
| 17060000071784 | L17/dossiers | 17 | 17060000071783 | 17060000071783 | 1 | PA796010 | rapporteur |