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 |
|---|---|---|---|---|---|---|---|---|
| 17060000000002 | L17/dossiers | 17 | 17060000000001 | 17060000000001 | 1 | PA722190 | auteur | |
| 17060000000004 | L17/dossiers | 17 | 17060000000003 | 17060000000003 | 1 | PO791932 | ||
| 17060000000006 | L17/dossiers | 17 | 17060000000005 | 17060000000005 | 1 | PO791932 | ||
| 17060000000008 | L17/dossiers | 17 | 17060000000007 | 17060000000007 | 1 | PA722190 | auteur | |
| 17060000000010 | L17/dossiers | 17 | 17060000000009 | 17060000000009 | 1 | PO791932 | ||
| 17060000000012 | L17/dossiers | 17 | 17060000000011 | 17060000000011 | 1 | PO838901 | ||
| 17060000000014 | L17/dossiers | 17 | 17060000000013 | 17060000000013 | 1 | PO838901 | ||
| 17060000000016 | L17/dossiers | 17 | 17060000000015 | 17060000000015 | 1 | PO838901 | ||
| 17060000000018 | L17/dossiers | 17 | 17060000000017 | 17060000000017 | 1 | PO838901 | ||
| 17060000000020 | L17/dossiers | 17 | 17060000000019 | 17060000000019 | 1 | PA368 | auteur | |
| 17060000000022 | L17/dossiers | 17 | 17060000000021 | 17060000000021 | 1 | PA410 | auteur | |
| 17060000000024 | L17/dossiers | 17 | 17060000000023 | 17060000000023 | 1 | PO838901 | ||
| 17060000000026 | L17/dossiers | 17 | 17060000000025 | 17060000000025 | 1 | PO838901 | ||
| 17060000000028 | L17/dossiers | 17 | 17060000000027 | 17060000000027 | 1 | PO838901 | ||
| 17060000000030 | L17/dossiers | 17 | 17060000000029 | 17060000000029 | 1 | PA410 | auteur | |
| 17060000000032 | L17/dossiers | 17 | 17060000000031 | 17060000000031 | 1 | PO838901 | ||
| 17060000000034 | L17/dossiers | 17 | 17060000000033 | 17060000000033 | 1 | PO838901 | ||
| 17060000000036 | L17/dossiers | 17 | 17060000000035 | 17060000000035 | 1 | PA410 | auteur | |
| 17060000000038 | L17/dossiers | 17 | 17060000000037 | 17060000000037 | 1 | PO838901 | ||
| 17060000000040 | L17/dossiers | 17 | 17060000000039 | 17060000000039 | 1 | PA410 | auteur | |
| 17060000000042 | L17/dossiers | 17 | 17060000000041 | 17060000000041 | 1 | PO838901 | ||
| 17060000000044 | L17/dossiers | 17 | 17060000000043 | 17060000000043 | 1 | PA410 | auteur | |
| 17060000000046 | L17/dossiers | 17 | 17060000000045 | 17060000000045 | 1 | PO838901 | ||
| 17060000000048 | L17/dossiers | 17 | 17060000000047 | 17060000000047 | 1 | PO838901 | ||
| 17060000000050 | L17/dossiers | 17 | 17060000000049 | 17060000000049 | 1 | PO838901 | ||
| 17060000000052 | L17/dossiers | 17 | 17060000000051 | 17060000000051 | 1 | PA410 | auteur | |
| 17060000000054 | L17/dossiers | 17 | 17060000000053 | 17060000000053 | 1 | PA643210 | auteur | |
| 17060000000056 | L17/dossiers | 17 | 17060000000055 | 17060000000055 | 1 | PO838901 | ||
| 17060000000058 | L17/dossiers | 17 | 17060000000057 | 17060000000057 | 1 | PO838901 | ||
| 17060000000060 | L17/dossiers | 17 | 17060000000059 | 17060000000059 | 1 | PA643210 | auteur | |
| 17060000000062 | L17/dossiers | 17 | 17060000000061 | 17060000000061 | 1 | PO838901 | ||
| 17060000000064 | L17/dossiers | 17 | 17060000000063 | 17060000000063 | 1 | PO838901 | ||
| 17060000000066 | L17/dossiers | 17 | 17060000000065 | 17060000000065 | 1 | PO838901 | ||
| 17060000000068 | L17/dossiers | 17 | 17060000000067 | 17060000000067 | 1 | PA643210 | auteur | |
| 17060000000070 | L17/dossiers | 17 | 17060000000069 | 17060000000069 | 1 | PO838901 | ||
| 17060000000072 | L17/dossiers | 17 | 17060000000071 | 17060000000071 | 1 | PO838901 | ||
| 17060000000074 | L17/dossiers | 17 | 17060000000073 | 17060000000073 | 1 | PO838901 | ||
| 17060000000076 | L17/dossiers | 17 | 17060000000075 | 17060000000075 | 1 | PO838901 | ||
| 17060000000078 | L17/dossiers | 17 | 17060000000077 | 17060000000077 | 1 | PO838901 | ||
| 17060000000080 | L17/dossiers | 17 | 17060000000079 | 17060000000079 | 1 | PO838901 | ||
| 17060000000082 | L17/dossiers | 17 | 17060000000081 | 17060000000081 | 1 | PO838901 | ||
| 17060000000084 | L17/dossiers | 17 | 17060000000083 | 17060000000083 | 1 | PA793362 | auteur | |
| 17060000000086 | L17/dossiers | 17 | 17060000000085 | 17060000000085 | 1 | PA721908 | auteur | |
| 17060000000088 | L17/dossiers | 17 | 17060000000087 | 17060000000087 | 1 | PA720704 | auteur | |
| 17060000000089 | L17/dossiers | 17 | 17060000000087 | 17060000000087 | 2 | PA266797 | auteur | |
| 17060000000091 | L17/dossiers | 17 | 17060000000090 | 17060000000090 | 1 | PA717161 | auteur | |
| 17060000000093 | L17/dossiers | 17 | 17060000000092 | 17060000000092 | 1 | PA722190 | auteur | |
| 17060000000095 | L17/dossiers | 17 | 17060000000094 | 17060000000094 | 1 | PA795046 | auteur | |
| 17060000000097 | L17/dossiers | 17 | 17060000000096 | 17060000000096 | 1 | PA368 | auteur | |
| 17060000000099 | L17/dossiers | 17 | 17060000000098 | 17060000000098 | 1 | PA410 | auteur |