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 |
|---|---|---|---|---|---|---|---|---|
| 17060000111871 | L17/dossiers | 17 | 17060000111869 | 17060000111869 | 2 | PA721296 | rapporteur | |
| 17060000111872 | L17/dossiers | 17 | 17060000111869 | 17060000111869 | 3 | PO201269 | ||
| 17060000111874 | L17/dossiers | 17 | 17060000111873 | 17060000111873 | 1 | PA840817 | rapporteur | |
| 17060000111875 | L17/dossiers | 17 | 17060000111873 | 17060000111873 | 2 | PA840159 | rapporteur | |
| 17060000111876 | L17/dossiers | 17 | 17060000111873 | 17060000111873 | 3 | PA721426 | rapporteur | |
| 17060000111877 | L17/dossiers | 17 | 17060000111873 | 17060000111873 | 4 | PO419604 | ||
| 17060000111879 | L17/dossiers | 17 | 17060000111878 | 17060000111878 | 1 | PA840955 | rapporteur | |
| 17060000111880 | L17/dossiers | 17 | 17060000111878 | 17060000111878 | 2 | PA719550 | rapporteur | |
| 17060000111881 | L17/dossiers | 17 | 17060000111878 | 17060000111878 | 3 | PO59047 | ||
| 17060000111883 | L17/dossiers | 17 | 17060000111882 | 17060000111882 | 1 | PA774954 | rapporteur | |
| 17060000111884 | L17/dossiers | 17 | 17060000111882 | 17060000111882 | 2 | PA840947 | rapporteur | |
| 17060000111885 | L17/dossiers | 17 | 17060000111882 | 17060000111882 | 3 | PO59046 | ||
| 17060000111887 | L17/dossiers | 17 | 17060000111886 | 17060000111886 | 1 | PA345722 | rapporteur | |
| 17060000111888 | L17/dossiers | 17 | 17060000111886 | 17060000111886 | 2 | PA841931 | rapporteur | |
| 17060000111889 | L17/dossiers | 17 | 17060000111886 | 17060000111886 | 3 | PO415287 | ||
| 17060000111897 | L17/dossiers | 17 | 17060000111890 | 17060000111890 | 1 | PA793398 | rapporteur | |
| 17060000111898 | L17/dossiers | 17 | 17060000111890 | 17060000111890 | 2 | PO869802 | ||
| 17060000111900 | L17/dossiers | 17 | 17060000111899 | 17060000111899 | 1 | PA794530 | rapporteur | |
| 17060000111901 | L17/dossiers | 17 | 17060000111899 | 17060000111899 | 2 | PA719550 | rapporteur | |
| 17060000111902 | L17/dossiers | 17 | 17060000111899 | 17060000111899 | 3 | PO415287 | ||
| 17060000111904 | L17/dossiers | 17 | 17060000111903 | 17060000111903 | 1 | PA841359 | rapporteur | |
| 17060000111905 | L17/dossiers | 17 | 17060000111903 | 17060000111903 | 2 | PA722336 | rapporteur | |
| 17060000111906 | L17/dossiers | 17 | 17060000111903 | 17060000111903 | 3 | PO419865 | ||
| 17060000111908 | L17/dossiers | 17 | 17060000111907 | 17060000111907 | 1 | PA794838 | rapporteur | |
| 17060000111909 | L17/dossiers | 17 | 17060000111907 | 17060000111907 | 2 | PA841553 | rapporteur | |
| 17060000111910 | L17/dossiers | 17 | 17060000111907 | 17060000111907 | 3 | PO59046 | ||
| 17060000111912 | L17/dossiers | 17 | 17060000111911 | 17060000111911 | 1 | PA841419 | rapporteur | |
| 17060000111913 | L17/dossiers | 17 | 17060000111911 | 17060000111911 | 2 | PA719550 | rapporteur | |
| 17060000111914 | L17/dossiers | 17 | 17060000111911 | 17060000111911 | 3 | PO415287 | ||
| 17060000111916 | L17/dossiers | 17 | 17060000111915 | 17060000111915 | 1 | PA720354 | rapporteur | |
| 17060000111917 | L17/dossiers | 17 | 17060000111915 | 17060000111915 | 2 | PO59046 | ||
| 17060000111919 | L17/dossiers | 17 | 17060000111918 | 17060000111918 | 1 | PA719118 | rapporteur | |
| 17060000111920 | L17/dossiers | 17 | 17060000111918 | 17060000111918 | 2 | PA795982 | rapporteur | |
| 17060000111921 | L17/dossiers | 17 | 17060000111918 | 17060000111918 | 3 | PO59046 | ||
| 17060000111923 | L17/dossiers | 17 | 17060000111922 | 17060000111922 | 1 | PA795430 | rapporteur | |
| 17060000111924 | L17/dossiers | 17 | 17060000111922 | 17060000111922 | 2 | PO744127 | ||
| 17060000111926 | L17/dossiers | 17 | 17060000111925 | 17060000111925 | 1 | PA721004 | rapporteur | |
| 17060000111927 | L17/dossiers | 17 | 17060000111925 | 17060000111925 | 2 | PA795808 | rapporteur | |
| 17060000111928 | L17/dossiers | 17 | 17060000111925 | 17060000111925 | 3 | PO59047 | ||
| 17060000111930 | L17/dossiers | 17 | 17060000111929 | 17060000111929 | 1 | PA841885 | rapporteur | |
| 17060000111931 | L17/dossiers | 17 | 17060000111929 | 17060000111929 | 2 | PA720560 | rapporteur | |
| 17060000111932 | L17/dossiers | 17 | 17060000111929 | 17060000111929 | 3 | PA793342 | rapporteur | |
| 17060000111933 | L17/dossiers | 17 | 17060000111929 | 17060000111929 | 4 | PO804431 | ||
| 17060000111935 | L17/dossiers | 17 | 17060000111934 | 17060000111934 | 1 | PA795430 | rapporteur | |
| 17060000111936 | L17/dossiers | 17 | 17060000111934 | 17060000111934 | 2 | PO744127 | ||
| 17060000111938 | L17/dossiers | 17 | 17060000111937 | 17060000111937 | 1 | PA794906 | rapporteur | |
| 17060000111939 | L17/dossiers | 17 | 17060000111937 | 17060000111937 | 2 | PA841339 | rapporteur | |
| 17060000111940 | L17/dossiers | 17 | 17060000111937 | 17060000111937 | 3 | PO744127 | ||
| 17060000111942 | L17/dossiers | 17 | 17060000111941 | 17060000111941 | 1 | PA840947 | rapporteur | |
| 17060000111943 | L17/dossiers | 17 | 17060000111941 | 17060000111941 | 2 | PO420375 |