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 |
|---|---|---|---|---|---|---|---|---|
| 17060000108713 | L17/dossiers | 17 | 17060000108712 | 17060000108712 | 1 | PA942 | rapporteur | |
| 17060000108714 | L17/dossiers | 17 | 17060000108712 | 17060000108712 | 2 | PO59048 | ||
| 17060000108719 | L17/dossiers | 17 | 17060000108715 | 17060000108715 | 1 | PA794830 | rapporteur | |
| 17060000108720 | L17/dossiers | 17 | 17060000108715 | 17060000108715 | 2 | PO419610 | ||
| 17060000108722 | L17/dossiers | 17 | 17060000108721 | 17060000108721 | 1 | PA719640 | rapporteur | |
| 17060000108723 | L17/dossiers | 17 | 17060000108721 | 17060000108721 | 2 | PO419865 | ||
| 17060000108728 | L17/dossiers | 17 | 17060000108724 | 17060000108724 | 1 | PA721984 | rapporteur | |
| 17060000108729 | L17/dossiers | 17 | 17060000108724 | 17060000108724 | 2 | PO59051 | ||
| 17060000108734 | L17/dossiers | 17 | 17060000108730 | 17060000108730 | 1 | PA719024 | rapporteur | |
| 17060000108735 | L17/dossiers | 17 | 17060000108730 | 17060000108730 | 2 | PO419604 | ||
| 17060000108737 | L17/dossiers | 17 | 17060000108736 | 17060000108736 | 1 | PA794810 | rapporteur | |
| 17060000108738 | L17/dossiers | 17 | 17060000108736 | 17060000108736 | 2 | PA722162 | rapporteur | |
| 17060000108739 | L17/dossiers | 17 | 17060000108736 | 17060000108736 | 3 | PO59051 | ||
| 17060000108744 | L17/dossiers | 17 | 17060000108740 | 17060000108740 | 1 | PA267318 | rapporteur | |
| 17060000108745 | L17/dossiers | 17 | 17060000108740 | 17060000108740 | 2 | PO420120 | ||
| 17060000108750 | L17/dossiers | 17 | 17060000108746 | 17060000108746 | 1 | PA805166 | rapporteur | |
| 17060000108751 | L17/dossiers | 17 | 17060000108746 | 17060000108746 | 2 | PO419865 | ||
| 17060000108756 | L17/dossiers | 17 | 17060000108752 | 17060000108752 | 1 | PA722374 | rapporteur | |
| 17060000108757 | L17/dossiers | 17 | 17060000108752 | 17060000108752 | 2 | PO420120 | ||
| 17060000108762 | L17/dossiers | 17 | 17060000108758 | 17060000108758 | 1 | PA721296 | rapporteur | |
| 17060000108763 | L17/dossiers | 17 | 17060000108758 | 17060000108758 | 2 | PO59051 | ||
| 17060000108768 | L17/dossiers | 17 | 17060000108764 | 17060000108764 | 1 | PA720728 | rapporteur | |
| 17060000108769 | L17/dossiers | 17 | 17060000108764 | 17060000108764 | 2 | PO59048 | ||
| 17060000108771 | L17/dossiers | 17 | 17060000108770 | 17060000108770 | 1 | PA793904 | rapporteur | |
| 17060000108772 | L17/dossiers | 17 | 17060000108770 | 17060000108770 | 2 | PO415287 | ||
| 17060000108774 | L17/dossiers | 17 | 17060000108773 | 17060000108773 | 1 | PA794270 | rapporteur | |
| 17060000108775 | L17/dossiers | 17 | 17060000108773 | 17060000108773 | 2 | PO415287 | ||
| 17060000108777 | L17/dossiers | 17 | 17060000108776 | 17060000108776 | 1 | PA267200 | rapporteur | |
| 17060000108778 | L17/dossiers | 17 | 17060000108776 | 17060000108776 | 2 | PO59051 | ||
| 17060000108780 | L17/dossiers | 17 | 17060000108779 | 17060000108779 | 1 | PA267200 | rapporteur | |
| 17060000108781 | L17/dossiers | 17 | 17060000108779 | 17060000108779 | 2 | PO59051 | ||
| 17060000108787 | L17/dossiers | 17 | 17060000108782 | 17060000108782 | 1 | PA610968 | rapporteur | |
| 17060000108788 | L17/dossiers | 17 | 17060000108782 | 17060000108782 | 2 | PA842311 | rapporteur | |
| 17060000108789 | L17/dossiers | 17 | 17060000108782 | 17060000108782 | 3 | PO59051 | ||
| 17060000108791 | L17/dossiers | 17 | 17060000108790 | 17060000108790 | 1 | PA794802 | rapporteur | |
| 17060000108792 | L17/dossiers | 17 | 17060000108790 | 17060000108790 | 2 | PO59051 | ||
| 17060000108794 | L17/dossiers | 17 | 17060000108793 | 17060000108793 | 1 | PA266797 | rapporteur | |
| 17060000108795 | L17/dossiers | 17 | 17060000108793 | 17060000108793 | 2 | PO59051 | ||
| 17060000108797 | L17/dossiers | 17 | 17060000108796 | 17060000108796 | 1 | PA793314 | rapporteur | |
| 17060000108798 | L17/dossiers | 17 | 17060000108796 | 17060000108796 | 2 | PO59047 | ||
| 17060000108800 | L17/dossiers | 17 | 17060000108799 | 17060000108799 | 1 | PA842211 | rapporteur | |
| 17060000108801 | L17/dossiers | 17 | 17060000108799 | 17060000108799 | 2 | PA721234 | rapporteur | |
| 17060000108802 | L17/dossiers | 17 | 17060000108799 | 17060000108799 | 3 | PO59047 | ||
| 17060000108807 | L17/dossiers | 17 | 17060000108803 | 17060000108803 | 1 | PA842125 | rapporteur | |
| 17060000108808 | L17/dossiers | 17 | 17060000108803 | 17060000108803 | 2 | PO59051 | ||
| 17060000108813 | L17/dossiers | 17 | 17060000108809 | 17060000108809 | 1 | PA719472 | rapporteur | |
| 17060000108814 | L17/dossiers | 17 | 17060000108809 | 17060000108809 | 2 | PO59051 | ||
| 17060000108819 | L17/dossiers | 17 | 17060000108815 | 17060000108815 | 1 | PA722070 | rapporteur | |
| 17060000108820 | L17/dossiers | 17 | 17060000108815 | 17060000108815 | 2 | PO419604 | ||
| 17060000108825 | L17/dossiers | 17 | 17060000108821 | 17060000108821 | 1 | PA793398 | rapporteur |