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 |
|---|---|---|---|---|---|---|---|---|
| 16060000084210 | L16/dossiers | 16 | 16060000084207 | 16060000084207 | 3 | PO814996 | ||
| 16060000084212 | L16/dossiers | 16 | 16060000084211 | 16060000084211 | 1 | PA720634 | rapporteur | |
| 16060000084213 | L16/dossiers | 16 | 16060000084211 | 16060000084211 | 2 | PO211491 | ||
| 16060000084215 | L16/dossiers | 16 | 16060000084214 | 16060000084214 | 1 | PA267081 | rapporteur | |
| 16060000084216 | L16/dossiers | 16 | 16060000084214 | 16060000084214 | 2 | PO816676 | ||
| 16060000084218 | L16/dossiers | 16 | 16060000084217 | 16060000084217 | 1 | PA429835 | rapporteur | |
| 16060000084219 | L16/dossiers | 16 | 16060000084217 | 16060000084217 | 2 | PO211491 | ||
| 16060000084221 | L16/dossiers | 16 | 16060000084220 | 16060000084220 | 1 | PA736173 | rapporteur | |
| 16060000084222 | L16/dossiers | 16 | 16060000084220 | 16060000084220 | 2 | PO211491 | ||
| 16060000084224 | L16/dossiers | 16 | 16060000084223 | 16060000084223 | 1 | PA736205 | rapporteur | |
| 16060000084225 | L16/dossiers | 16 | 16060000084223 | 16060000084223 | 2 | PA569 | rapporteur | |
| 16060000084226 | L16/dossiers | 16 | 16060000084223 | 16060000084223 | 3 | PO211495 | ||
| 16060000084228 | L16/dossiers | 16 | 16060000084227 | 16060000084227 | 1 | PA703498 | rapporteur | |
| 16060000084229 | L16/dossiers | 16 | 16060000084227 | 16060000084227 | 2 | PA429851 | rapporteur | |
| 16060000084230 | L16/dossiers | 16 | 16060000084227 | 16060000084227 | 3 | PO821760 | ||
| 16060000084232 | L16/dossiers | 16 | 16060000084231 | 16060000084231 | 1 | PA703510 | rapporteur | |
| 16060000084233 | L16/dossiers | 16 | 16060000084231 | 16060000084231 | 2 | PO822403 | ||
| 16060000084235 | L16/dossiers | 16 | 16060000084234 | 16060000084234 | 1 | PA415446 | rapporteur | |
| 16060000084236 | L16/dossiers | 16 | 16060000084234 | 16060000084234 | 2 | PO211494 | ||
| 16060000084238 | L16/dossiers | 16 | 16060000084237 | 16060000084237 | 1 | PA703530 | rapporteur | |
| 16060000084239 | L16/dossiers | 16 | 16060000084237 | 16060000084237 | 2 | PO822178 | ||
| 16060000084241 | L16/dossiers | 16 | 16060000084240 | 16060000084240 | 1 | PA703536 | rapporteur | |
| 16060000084242 | L16/dossiers | 16 | 16060000084240 | 16060000084240 | 2 | PO211491 | ||
| 16060000084244 | L16/dossiers | 16 | 16060000084243 | 16060000084243 | 1 | PA778908 | rapporteur | |
| 16060000084245 | L16/dossiers | 16 | 16060000084243 | 16060000084243 | 2 | PO211490 | ||
| 16060000084247 | L16/dossiers | 16 | 16060000084246 | 16060000084246 | 1 | PA415448 | rapporteur | |
| 16060000084248 | L16/dossiers | 16 | 16060000084246 | 16060000084246 | 2 | PO211494 | ||
| 16060000084250 | L16/dossiers | 16 | 16060000084249 | 16060000084249 | 1 | PA590034 | rapporteur | |
| 16060000084251 | L16/dossiers | 16 | 16060000084249 | 16060000084249 | 2 | PO211491 | ||
| 16060000084253 | L16/dossiers | 16 | 16060000084252 | 16060000084252 | 1 | PA267673 | rapporteur | |
| 16060000084254 | L16/dossiers | 16 | 16060000084252 | 16060000084252 | 2 | PO211491 | ||
| 16060000084256 | L16/dossiers | 16 | 16060000084255 | 16060000084255 | 1 | PA703525 | rapporteur | |
| 16060000084257 | L16/dossiers | 16 | 16060000084255 | 16060000084255 | 2 | PO211491 | ||
| 16060000084259 | L16/dossiers | 16 | 16060000084258 | 16060000084258 | 1 | PA703510 | rapporteur | |
| 16060000084260 | L16/dossiers | 16 | 16060000084258 | 16060000084258 | 2 | PA747420 | rapporteur | |
| 16060000084261 | L16/dossiers | 16 | 16060000084258 | 16060000084258 | 3 | PO211495 | ||
| 16060000084263 | L16/dossiers | 16 | 16060000084262 | 16060000084262 | 1 | PA775288 | rapporteur | |
| 16060000084264 | L16/dossiers | 16 | 16060000084262 | 16060000084262 | 2 | PO516753 | ||
| 16060000084266 | L16/dossiers | 16 | 16060000084265 | 16060000084265 | 1 | PA304085 | rapporteur | |
| 16060000084267 | L16/dossiers | 16 | 16060000084265 | 16060000084265 | 2 | PO211491 | ||
| 16060000084269 | L16/dossiers | 16 | 16060000084268 | 16060000084268 | 1 | PA703513 | rapporteur | |
| 16060000084270 | L16/dossiers | 16 | 16060000084268 | 16060000084268 | 2 | PA703492 | rapporteur | |
| 16060000084271 | L16/dossiers | 16 | 16060000084268 | 16060000084268 | 3 | PO765977 | ||
| 16060000084273 | L16/dossiers | 16 | 16060000084272 | 16060000084272 | 1 | PA267081 | rapporteur | |
| 16060000084274 | L16/dossiers | 16 | 16060000084272 | 16060000084272 | 2 | PO211493 | ||
| 16060000084276 | L16/dossiers | 16 | 16060000084275 | 16060000084275 | 1 | PA415448 | rapporteur | |
| 16060000084277 | L16/dossiers | 16 | 16060000084275 | 16060000084275 | 2 | PO825399 | ||
| 16060000084279 | L16/dossiers | 16 | 16060000084278 | 16060000084278 | 1 | PA415446 | rapporteur | |
| 16060000084280 | L16/dossiers | 16 | 16060000084278 | 16060000084278 | 2 | PO825406 | ||
| 16060000084282 | L16/dossiers | 16 | 16060000084281 | 16060000084281 | 1 | PA1344 | rapporteur |