dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
60 224 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 72 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 72 %, 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 58 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 14060000084109 | L14/dossiers | 14 | 14060000084108 | 14060000084108 | 1 | PA267735 | auteur | |
| 14060000084138 | L14/dossiers | 14 | 14060000084137 | 14060000084137 | 1 | PA267622 | auteur | |
| 14060000084141 | L14/dossiers | 14 | 14060000084140 | 14060000084140 | 1 | PA2801 | auteur | |
| 14060000084179 | L14/dossiers | 14 | 14060000084178 | 14060000084178 | 1 | PA610291 | rapporteur | |
| 14060000084180 | L14/dossiers | 14 | 14060000084178 | 14060000084178 | 2 | PA607256 | rapporteur | |
| 14060000084181 | L14/dossiers | 14 | 14060000084178 | 14060000084178 | 3 | PA608363 | rapporteur | |
| 14060000084182 | L14/dossiers | 14 | 14060000084178 | 14060000084178 | 4 | PA606665 | rapporteur | |
| 14060000084183 | L14/dossiers | 14 | 14060000084178 | 14060000084178 | 5 | PO712376 | ||
| 14060000084186 | L14/dossiers | 14 | 14060000084185 | 14060000084185 | 1 | PO644420 | ||
| 14060000084189 | L14/dossiers | 14 | 14060000084188 | 14060000084188 | 1 | PO78718 | ||
| 14060000084191 | L14/dossiers | 14 | 14060000084190 | 14060000084190 | 1 | PO644420 | ||
| 14060000084194 | L14/dossiers | 14 | 14060000084193 | 14060000084193 | 1 | PA610291 | rapporteur | |
| 14060000084195 | L14/dossiers | 14 | 14060000084193 | 14060000084193 | 2 | PA607256 | rapporteur | |
| 14060000084196 | L14/dossiers | 14 | 14060000084193 | 14060000084193 | 3 | PA608363 | rapporteur | |
| 14060000084197 | L14/dossiers | 14 | 14060000084193 | 14060000084193 | 4 | PA606665 | rapporteur | |
| 14060000084198 | L14/dossiers | 14 | 14060000084193 | 14060000084193 | 5 | PO712376 | ||
| 14060000084201 | L14/dossiers | 14 | 14060000084200 | 14060000084200 | 1 | PA267622 | auteur | |
| 14060000084207 | L14/dossiers | 14 | 14060000084206 | 14060000084206 | 1 | PO78718 | ||
| 14060000084209 | L14/dossiers | 14 | 14060000084208 | 14060000084208 | 1 | PA267622 | auteur | |
| 14060000084211 | L14/dossiers | 14 | 14060000084210 | 14060000084210 | 1 | PA703520 | rapporteur | |
| 14060000084212 | L14/dossiers | 14 | 14060000084210 | 14060000084210 | 2 | PA266795 | rapporteur | |
| 14060000084213 | L14/dossiers | 14 | 14060000084210 | 14060000084210 | 3 | PO714945 | ||
| 14060000084215 | L14/dossiers | 14 | 14060000084214 | 14060000084214 | 1 | PA703520 | rapporteur | |
| 14060000084216 | L14/dossiers | 14 | 14060000084214 | 14060000084214 | 2 | PA266795 | rapporteur | |
| 14060000084217 | L14/dossiers | 14 | 14060000084214 | 14060000084214 | 3 | PO714224 | ||
| 14060000084225 | L14/dossiers | 14 | 14060000084218 | 14060000084218 | 1 | PA610291 | rapporteur | |
| 14060000084226 | L14/dossiers | 14 | 14060000084218 | 14060000084218 | 2 | PA607256 | rapporteur | |
| 14060000084227 | L14/dossiers | 14 | 14060000084218 | 14060000084218 | 3 | PA608363 | rapporteur | |
| 14060000084228 | L14/dossiers | 14 | 14060000084218 | 14060000084218 | 4 | PA606665 | rapporteur | |
| 14060000084229 | L14/dossiers | 14 | 14060000084218 | 14060000084218 | 5 | PO712376 | ||
| 14060000084237 | L14/dossiers | 14 | 14060000084230 | 14060000084230 | 1 | PA610291 | rapporteur | |
| 14060000084238 | L14/dossiers | 14 | 14060000084230 | 14060000084230 | 2 | PA607256 | rapporteur | |
| 14060000084239 | L14/dossiers | 14 | 14060000084230 | 14060000084230 | 3 | PA608363 | rapporteur | |
| 14060000084240 | L14/dossiers | 14 | 14060000084230 | 14060000084230 | 4 | PA606665 | rapporteur | |
| 14060000084241 | L14/dossiers | 14 | 14060000084230 | 14060000084230 | 5 | PO712376 | ||
| 14060000084243 | L14/dossiers | 14 | 14060000084242 | 14060000084242 | 1 | PA703520 | rapporteur | |
| 14060000084244 | L14/dossiers | 14 | 14060000084242 | 14060000084242 | 2 | PA266795 | rapporteur | |
| 14060000084245 | L14/dossiers | 14 | 14060000084242 | 14060000084242 | 3 | PO714224 | ||
| 14060000084247 | L14/dossiers | 14 | 14060000084246 | 14060000084246 | 1 | PA610291 | rapporteur | |
| 14060000084248 | L14/dossiers | 14 | 14060000084246 | 14060000084246 | 2 | PA608363 | rapporteur | |
| 14060000084249 | L14/dossiers | 14 | 14060000084246 | 14060000084246 | 3 | PA607256 | rapporteur | |
| 14060000084250 | L14/dossiers | 14 | 14060000084246 | 14060000084246 | 4 | PO714945 | ||
| 14060000084252 | L14/dossiers | 14 | 14060000084251 | 14060000084251 | 1 | PA267622 | auteur | |
| 14060000084254 | L14/dossiers | 14 | 14060000084253 | 14060000084253 | 1 | PO644420 | ||
| 14060000084257 | L14/dossiers | 14 | 14060000084256 | 14060000084256 | 1 | PA267622 | auteur | |
| 14060000084269 | L14/dossiers | 14 | 14060000084268 | 14060000084268 | 1 | PO78718 | ||
| 14060000084271 | L14/dossiers | 14 | 14060000084270 | 14060000084270 | 1 | PO644420 | ||
| 14060000084274 | L14/dossiers | 14 | 14060000084273 | 14060000084273 | 1 | PO78718 | ||
| 14060000084306 | L14/dossiers | 14 | 14060000084275 | 14060000084275 | 1 | PO644420 | ||
| 14060000084338 | L14/dossiers | 14 | 14060000084307 | 14060000084307 | 1 | PO644420 |