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 |
|---|---|---|---|---|---|---|---|---|
| 15060000083977 | L15/dossiers | 15 | 15060000083976 | 15060000083976 | 1 | PO78718 | ||
| 15060000083979 | L15/dossiers | 15 | 15060000083978 | 15060000083978 | 1 | PO78718 | ||
| 15060000083981 | L15/dossiers | 15 | 15060000083980 | 15060000083980 | 1 | PO78718 | ||
| 15060000083983 | L15/dossiers | 15 | 15060000083982 | 15060000083982 | 1 | PO78718 | ||
| 15060000083985 | L15/dossiers | 15 | 15060000083984 | 15060000083984 | 1 | PO78718 | ||
| 15060000083987 | L15/dossiers | 15 | 15060000083986 | 15060000083986 | 1 | PO78718 | ||
| 15060000083989 | L15/dossiers | 15 | 15060000083988 | 15060000083988 | 1 | PO78718 | ||
| 15060000083991 | L15/dossiers | 15 | 15060000083990 | 15060000083990 | 1 | PO78718 | ||
| 15060000083993 | L15/dossiers | 15 | 15060000083992 | 15060000083992 | 1 | PO78718 | ||
| 15060000083995 | L15/dossiers | 15 | 15060000083994 | 15060000083994 | 1 | PO78718 | ||
| 15060000083997 | L15/dossiers | 15 | 15060000083996 | 15060000083996 | 1 | PO78718 | ||
| 15060000083999 | L15/dossiers | 15 | 15060000083998 | 15060000083998 | 1 | PO78718 | ||
| 15060000084001 | L15/dossiers | 15 | 15060000084000 | 15060000084000 | 1 | PO78718 | ||
| 15060000084003 | L15/dossiers | 15 | 15060000084002 | 15060000084002 | 1 | PO78718 | ||
| 15060000084005 | L15/dossiers | 15 | 15060000084004 | 15060000084004 | 1 | PO78718 | ||
| 15060000084007 | L15/dossiers | 15 | 15060000084006 | 15060000084006 | 1 | PO78718 | ||
| 15060000084009 | L15/dossiers | 15 | 15060000084008 | 15060000084008 | 1 | PO78718 | ||
| 15060000084011 | L15/dossiers | 15 | 15060000084010 | 15060000084010 | 1 | PO78718 | ||
| 15060000084013 | L15/dossiers | 15 | 15060000084012 | 15060000084012 | 1 | PO78718 | ||
| 15060000084015 | L15/dossiers | 15 | 15060000084014 | 15060000084014 | 1 | PO78718 | ||
| 15060000084017 | L15/dossiers | 15 | 15060000084016 | 15060000084016 | 1 | PO78718 | ||
| 15060000084019 | L15/dossiers | 15 | 15060000084018 | 15060000084018 | 1 | PO78718 | ||
| 15060000084021 | L15/dossiers | 15 | 15060000084020 | 15060000084020 | 1 | PO78718 | ||
| 15060000084023 | L15/dossiers | 15 | 15060000084022 | 15060000084022 | 1 | PO78718 | ||
| 15060000084025 | L15/dossiers | 15 | 15060000084024 | 15060000084024 | 1 | PO78718 | ||
| 15060000084027 | L15/dossiers | 15 | 15060000084026 | 15060000084026 | 1 | PO78718 | ||
| 15060000084029 | L15/dossiers | 15 | 15060000084028 | 15060000084028 | 1 | PO78718 | ||
| 15060000084031 | L15/dossiers | 15 | 15060000084030 | 15060000084030 | 1 | PO78718 | ||
| 15060000084033 | L15/dossiers | 15 | 15060000084032 | 15060000084032 | 1 | PO78718 | ||
| 15060000084035 | L15/dossiers | 15 | 15060000084034 | 15060000084034 | 1 | PO78718 | ||
| 15060000084037 | L15/dossiers | 15 | 15060000084036 | 15060000084036 | 1 | PO78718 | ||
| 15060000084039 | L15/dossiers | 15 | 15060000084038 | 15060000084038 | 1 | PO78718 | ||
| 15060000084041 | L15/dossiers | 15 | 15060000084040 | 15060000084040 | 1 | PO78718 | ||
| 15060000084043 | L15/dossiers | 15 | 15060000084042 | 15060000084042 | 1 | PO78718 | ||
| 15060000084045 | L15/dossiers | 15 | 15060000084044 | 15060000084044 | 1 | PO78718 | ||
| 15060000084047 | L15/dossiers | 15 | 15060000084046 | 15060000084046 | 1 | PO78718 | ||
| 15060000084049 | L15/dossiers | 15 | 15060000084048 | 15060000084048 | 1 | PO78718 | ||
| 15060000084051 | L15/dossiers | 15 | 15060000084050 | 15060000084050 | 1 | PO78718 | ||
| 15060000084053 | L15/dossiers | 15 | 15060000084052 | 15060000084052 | 1 | PO78718 | ||
| 15060000084055 | L15/dossiers | 15 | 15060000084054 | 15060000084054 | 1 | PO78718 | ||
| 15060000084057 | L15/dossiers | 15 | 15060000084056 | 15060000084056 | 1 | PO78718 | ||
| 15060000084059 | L15/dossiers | 15 | 15060000084058 | 15060000084058 | 1 | PO78718 | ||
| 15060000084061 | L15/dossiers | 15 | 15060000084060 | 15060000084060 | 1 | PO78718 | ||
| 15060000084063 | L15/dossiers | 15 | 15060000084062 | 15060000084062 | 1 | PO78718 | ||
| 15060000084065 | L15/dossiers | 15 | 15060000084064 | 15060000084064 | 1 | PO78718 | ||
| 15060000084067 | L15/dossiers | 15 | 15060000084066 | 15060000084066 | 1 | PO78718 | ||
| 15060000084069 | L15/dossiers | 15 | 15060000084068 | 15060000084068 | 1 | PO78718 | ||
| 15060000084071 | L15/dossiers | 15 | 15060000084070 | 15060000084070 | 1 | PO78718 | ||
| 15060000084073 | L15/dossiers | 15 | 15060000084072 | 15060000084072 | 1 | PO78718 | ||
| 15060000084075 | L15/dossiers | 15 | 15060000084074 | 15060000084074 | 1 | PO78718 |