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 |
|---|---|---|---|---|---|---|---|---|
| 17060000106136 | L17/dossiers | 17 | 17060000106134 | 17060000106134 | 2 | PO59051 | ||
| 17060000106138 | L17/dossiers | 17 | 17060000106137 | 17060000106137 | 1 | PA718838 | rapporteur | |
| 17060000106139 | L17/dossiers | 17 | 17060000106137 | 17060000106137 | 2 | PO59051 | ||
| 17060000106150 | L17/dossiers | 17 | 17060000106140 | 17060000106140 | 1 | PA607553 | rapporteur | |
| 17060000106151 | L17/dossiers | 17 | 17060000106140 | 17060000106140 | 2 | PO420120 | ||
| 17060000106157 | L17/dossiers | 17 | 17060000106152 | 17060000106152 | 1 | PA720170 | rapporteur | |
| 17060000106158 | L17/dossiers | 17 | 17060000106152 | 17060000106152 | 2 | PA720480 | rapporteur | |
| 17060000106159 | L17/dossiers | 17 | 17060000106152 | 17060000106152 | 3 | PO420120 | ||
| 17060000106176 | L17/dossiers | 17 | 17060000106160 | 17060000106160 | 1 | PA721750 | rapporteur | |
| 17060000106177 | L17/dossiers | 17 | 17060000106160 | 17060000106160 | 2 | PA721888 | rapporteur | |
| 17060000106178 | L17/dossiers | 17 | 17060000106160 | 17060000106160 | 3 | PA718902 | rapporteur | |
| 17060000106179 | L17/dossiers | 17 | 17060000106160 | 17060000106160 | 4 | PO419604 | ||
| 17060000106181 | L17/dossiers | 17 | 17060000106180 | 17060000106180 | 1 | PA720170 | rapporteur | |
| 17060000106182 | L17/dossiers | 17 | 17060000106180 | 17060000106180 | 2 | PA720480 | rapporteur | |
| 17060000106183 | L17/dossiers | 17 | 17060000106180 | 17060000106180 | 3 | PO784418 | ||
| 17060000106185 | L17/dossiers | 17 | 17060000106184 | 17060000106184 | 1 | PA720846 | rapporteur | |
| 17060000106186 | L17/dossiers | 17 | 17060000106184 | 17060000106184 | 2 | PO59046 | ||
| 17060000106191 | L17/dossiers | 17 | 17060000106187 | 17060000106187 | 1 | PA719874 | rapporteur | |
| 17060000106192 | L17/dossiers | 17 | 17060000106187 | 17060000106187 | 2 | PO59051 | ||
| 17060000106194 | L17/dossiers | 17 | 17060000106193 | 17060000106193 | 1 | PA721750 | rapporteur | |
| 17060000106195 | L17/dossiers | 17 | 17060000106193 | 17060000106193 | 2 | PO789115 | ||
| 17060000106202 | L17/dossiers | 17 | 17060000106196 | 17060000106196 | 1 | PA721750 | rapporteur | |
| 17060000106203 | L17/dossiers | 17 | 17060000106196 | 17060000106196 | 2 | PA721888 | rapporteur | |
| 17060000106204 | L17/dossiers | 17 | 17060000106196 | 17060000106196 | 3 | PA718902 | rapporteur | |
| 17060000106205 | L17/dossiers | 17 | 17060000106196 | 17060000106196 | 4 | PO419604 | ||
| 17060000106211 | L17/dossiers | 17 | 17060000106206 | 17060000106206 | 1 | PA720704 | rapporteur | |
| 17060000106212 | L17/dossiers | 17 | 17060000106206 | 17060000106206 | 2 | PA266797 | rapporteur | |
| 17060000106213 | L17/dossiers | 17 | 17060000106206 | 17060000106206 | 3 | PO59051 | ||
| 17060000106218 | L17/dossiers | 17 | 17060000106214 | 17060000106214 | 1 | PA795076 | rapporteur | |
| 17060000106219 | L17/dossiers | 17 | 17060000106214 | 17060000106214 | 2 | PO59048 | ||
| 17060000106230 | L17/dossiers | 17 | 17060000106220 | 17060000106220 | 1 | PA720354 | rapporteur | |
| 17060000106231 | L17/dossiers | 17 | 17060000106220 | 17060000106220 | 2 | PO59046 | ||
| 17060000106236 | L17/dossiers | 17 | 17060000106232 | 17060000106232 | 1 | PA794626 | rapporteur | |
| 17060000106237 | L17/dossiers | 17 | 17060000106232 | 17060000106232 | 2 | PO59051 | ||
| 17060000106239 | L17/dossiers | 17 | 17060000106238 | 17060000106238 | 1 | PA720354 | rapporteur | |
| 17060000106240 | L17/dossiers | 17 | 17060000106238 | 17060000106238 | 2 | PA719822 | rapporteur | |
| 17060000106241 | L17/dossiers | 17 | 17060000106238 | 17060000106238 | 3 | PO826014 | ||
| 17060000106246 | L17/dossiers | 17 | 17060000106242 | 17060000106242 | 1 | PA795884 | rapporteur | |
| 17060000106247 | L17/dossiers | 17 | 17060000106242 | 17060000106242 | 2 | PO59051 | ||
| 17060000106253 | L17/dossiers | 17 | 17060000106248 | 17060000106248 | 1 | PA720022 | rapporteur | |
| 17060000106254 | L17/dossiers | 17 | 17060000106248 | 17060000106248 | 2 | PA795794 | rapporteur | |
| 17060000106255 | L17/dossiers | 17 | 17060000106248 | 17060000106248 | 3 | PO420120 | ||
| 17060000106261 | L17/dossiers | 17 | 17060000106256 | 17060000106256 | 1 | PA794854 | rapporteur | |
| 17060000106262 | L17/dossiers | 17 | 17060000106256 | 17060000106256 | 2 | PA719388 | rapporteur | |
| 17060000106263 | L17/dossiers | 17 | 17060000106256 | 17060000106256 | 3 | PO419610 | ||
| 17060000106268 | L17/dossiers | 17 | 17060000106264 | 17060000106264 | 1 | PA794038 | rapporteur | |
| 17060000106269 | L17/dossiers | 17 | 17060000106264 | 17060000106264 | 2 | PO420120 | ||
| 17060000106274 | L17/dossiers | 17 | 17060000106270 | 17060000106270 | 1 | PA643089 | rapporteur | |
| 17060000106275 | L17/dossiers | 17 | 17060000106270 | 17060000106270 | 2 | PO419604 | ||
| 17060000106280 | L17/dossiers | 17 | 17060000106276 | 17060000106276 | 1 | PA722162 | rapporteur |