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 |
|---|---|---|---|---|---|---|---|---|
| 17060000070875 | L17/dossiers | 17 | 17060000070874 | 17060000070874 | 1 | PO838901 | ||
| 17060000070878 | L17/dossiers | 17 | 17060000070877 | 17060000070877 | 1 | PO838901 | ||
| 17060000070880 | L17/dossiers | 17 | 17060000070879 | 17060000070879 | 1 | PO838901 | ||
| 17060000070883 | L17/dossiers | 17 | 17060000070882 | 17060000070882 | 1 | PO838901 | ||
| 17060000070886 | L17/dossiers | 17 | 17060000070885 | 17060000070885 | 1 | PO838901 | ||
| 17060000070889 | L17/dossiers | 17 | 17060000070888 | 17060000070888 | 1 | PO838901 | ||
| 17060000070892 | L17/dossiers | 17 | 17060000070891 | 17060000070891 | 1 | PO838901 | ||
| 17060000070895 | L17/dossiers | 17 | 17060000070894 | 17060000070894 | 1 | PO838901 | ||
| 17060000070898 | L17/dossiers | 17 | 17060000070897 | 17060000070897 | 1 | PO838901 | ||
| 17060000070901 | L17/dossiers | 17 | 17060000070900 | 17060000070900 | 1 | PO838901 | ||
| 17060000070904 | L17/dossiers | 17 | 17060000070903 | 17060000070903 | 1 | PO838901 | ||
| 17060000070907 | L17/dossiers | 17 | 17060000070906 | 17060000070906 | 1 | PO838901 | ||
| 17060000070910 | L17/dossiers | 17 | 17060000070909 | 17060000070909 | 1 | PO838901 | ||
| 17060000070913 | L17/dossiers | 17 | 17060000070912 | 17060000070912 | 1 | PO838901 | ||
| 17060000070916 | L17/dossiers | 17 | 17060000070915 | 17060000070915 | 1 | PO838901 | ||
| 17060000070919 | L17/dossiers | 17 | 17060000070918 | 17060000070918 | 1 | PO838901 | ||
| 17060000070922 | L17/dossiers | 17 | 17060000070921 | 17060000070921 | 1 | PO838901 | ||
| 17060000070925 | L17/dossiers | 17 | 17060000070924 | 17060000070924 | 1 | PO838901 | ||
| 17060000070928 | L17/dossiers | 17 | 17060000070927 | 17060000070927 | 1 | PO838901 | ||
| 17060000070930 | L17/dossiers | 17 | 17060000070929 | 17060000070929 | 1 | PO838901 | ||
| 17060000070933 | L17/dossiers | 17 | 17060000070932 | 17060000070932 | 1 | PO838901 | ||
| 17060000070936 | L17/dossiers | 17 | 17060000070935 | 17060000070935 | 1 | PO838901 | ||
| 17060000070939 | L17/dossiers | 17 | 17060000070938 | 17060000070938 | 1 | PO838901 | ||
| 17060000070942 | L17/dossiers | 17 | 17060000070941 | 17060000070941 | 1 | PO838901 | ||
| 17060000070945 | L17/dossiers | 17 | 17060000070944 | 17060000070944 | 1 | PO838901 | ||
| 17060000070948 | L17/dossiers | 17 | 17060000070947 | 17060000070947 | 1 | PO838901 | ||
| 17060000070951 | L17/dossiers | 17 | 17060000070950 | 17060000070950 | 1 | PO838901 | ||
| 17060000070954 | L17/dossiers | 17 | 17060000070953 | 17060000070953 | 1 | PO838901 | ||
| 17060000070957 | L17/dossiers | 17 | 17060000070956 | 17060000070956 | 1 | PO838901 | ||
| 17060000070960 | L17/dossiers | 17 | 17060000070959 | 17060000070959 | 1 | PO838901 | ||
| 17060000070963 | L17/dossiers | 17 | 17060000070962 | 17060000070962 | 1 | PO838901 | ||
| 17060000070965 | L17/dossiers | 17 | 17060000070964 | 17060000070964 | 1 | PO838901 | ||
| 17060000070967 | L17/dossiers | 17 | 17060000070966 | 17060000070966 | 1 | PO838901 | ||
| 17060000070970 | L17/dossiers | 17 | 17060000070969 | 17060000070969 | 1 | PO838901 | ||
| 17060000070972 | L17/dossiers | 17 | 17060000070971 | 17060000070971 | 1 | PO838901 | ||
| 17060000070974 | L17/dossiers | 17 | 17060000070973 | 17060000070973 | 1 | PO838901 | ||
| 17060000070977 | L17/dossiers | 17 | 17060000070976 | 17060000070976 | 1 | PO838901 | ||
| 17060000070980 | L17/dossiers | 17 | 17060000070979 | 17060000070979 | 1 | PO838901 | ||
| 17060000070983 | L17/dossiers | 17 | 17060000070982 | 17060000070982 | 1 | PO838901 | ||
| 17060000070986 | L17/dossiers | 17 | 17060000070985 | 17060000070985 | 1 | PO838901 | ||
| 17060000070989 | L17/dossiers | 17 | 17060000070988 | 17060000070988 | 1 | PO838901 | ||
| 17060000070991 | L17/dossiers | 17 | 17060000070990 | 17060000070990 | 1 | PO838901 | ||
| 17060000070993 | L17/dossiers | 17 | 17060000070992 | 17060000070992 | 1 | PO838901 | ||
| 17060000070996 | L17/dossiers | 17 | 17060000070995 | 17060000070995 | 1 | PO838901 | ||
| 17060000070999 | L17/dossiers | 17 | 17060000070998 | 17060000070998 | 1 | PO838901 | ||
| 17060000071002 | L17/dossiers | 17 | 17060000071001 | 17060000071001 | 1 | PO838901 | ||
| 17060000071005 | L17/dossiers | 17 | 17060000071004 | 17060000071004 | 1 | PO838901 | ||
| 17060000071009 | L17/dossiers | 17 | 17060000071008 | 17060000071008 | 1 | PO838901 | ||
| 17060000071012 | L17/dossiers | 17 | 17060000071011 | 17060000071011 | 1 | PO838901 | ||
| 17060000071015 | L17/dossiers | 17 | 17060000071014 | 17060000071014 | 1 | PO838901 |