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 |
|---|---|---|---|---|---|---|---|---|
| 16060000083329 | L16/dossiers | 16 | 16060000083326 | 16060000083326 | 3 | PA720146 | rapporteur | |
| 16060000083330 | L16/dossiers | 16 | 16060000083326 | 16060000083326 | 4 | PA719294 | rapporteur | |
| 16060000083331 | L16/dossiers | 16 | 16060000083326 | 16060000083326 | 5 | PO830146 | ||
| 16060000083333 | L16/dossiers | 16 | 16060000083332 | 16060000083332 | 1 | PA721722 | rapporteur | |
| 16060000083334 | L16/dossiers | 16 | 16060000083332 | 16060000083332 | 2 | PO59051 | ||
| 16060000083337 | L16/dossiers | 16 | 16060000083336 | 16060000083336 | 1 | PA720480 | rapporteur | |
| 16060000083338 | L16/dossiers | 16 | 16060000083336 | 16060000083336 | 2 | PO420120 | ||
| 16060000083341 | L16/dossiers | 16 | 16060000083340 | 16060000083340 | 1 | PA722366 | rapporteur | |
| 16060000083342 | L16/dossiers | 16 | 16060000083340 | 16060000083340 | 2 | PA795144 | rapporteur | |
| 16060000083343 | L16/dossiers | 16 | 16060000083340 | 16060000083340 | 3 | PO836121 | ||
| 16060000083345 | L16/dossiers | 16 | 16060000083344 | 16060000083344 | 1 | PA722366 | rapporteur | |
| 16060000083346 | L16/dossiers | 16 | 16060000083344 | 16060000083344 | 2 | PO836135 | ||
| 16060000083348 | L16/dossiers | 16 | 16060000083347 | 16060000083347 | 1 | PA720370 | rapporteur | |
| 16060000083349 | L16/dossiers | 16 | 16060000083347 | 16060000083347 | 2 | PA719798 | rapporteur | |
| 16060000083350 | L16/dossiers | 16 | 16060000083347 | 16060000083347 | 3 | PO836128 | ||
| 16060000083352 | L16/dossiers | 16 | 16060000083351 | 16060000083351 | 1 | PA720222 | rapporteur | |
| 16060000083353 | L16/dossiers | 16 | 16060000083351 | 16060000083351 | 2 | PA720342 | rapporteur | |
| 16060000083354 | L16/dossiers | 16 | 16060000083351 | 16060000083351 | 3 | PA719664 | rapporteur | |
| 16060000083355 | L16/dossiers | 16 | 16060000083351 | 16060000083351 | 4 | PA795374 | rapporteur | |
| 16060000083356 | L16/dossiers | 16 | 16060000083351 | 16060000083351 | 5 | PO419610 | ||
| 16060000083361 | L16/dossiers | 16 | 16060000083360 | 16060000083360 | 1 | PA605694 | rapporteur | |
| 16060000083362 | L16/dossiers | 16 | 16060000083360 | 16060000083360 | 2 | PA719154 | rapporteur | |
| 16060000083363 | L16/dossiers | 16 | 16060000083360 | 16060000083360 | 3 | PA793876 | rapporteur | |
| 16060000083364 | L16/dossiers | 16 | 16060000083360 | 16060000083360 | 4 | PA719718 | rapporteur | |
| 16060000083365 | L16/dossiers | 16 | 16060000083360 | 16060000083360 | 5 | PA720286 | rapporteur | |
| 16060000083366 | L16/dossiers | 16 | 16060000083360 | 16060000083360 | 6 | PO836892 | ||
| 16060000083369 | L16/dossiers | 16 | 16060000083368 | 16060000083368 | 1 | PO791932 | ||
| 16060000083372 | L16/dossiers | 16 | 16060000083371 | 16060000083371 | 1 | PO791932 | ||
| 16060000083375 | L16/dossiers | 16 | 16060000083374 | 16060000083374 | 1 | PO791932 | ||
| 16060000083380 | L16/dossiers | 16 | 16060000083379 | 16060000083379 | 1 | PO791932 | ||
| 16060000083382 | L16/dossiers | 16 | 16060000083381 | 16060000083381 | 1 | PO791932 | ||
| 16060000083386 | L16/dossiers | 16 | 16060000083385 | 16060000083385 | 1 | PO791932 | ||
| 16060000083389 | L16/dossiers | 16 | 16060000083388 | 16060000083388 | 1 | PO791932 | ||
| 16060000083392 | L16/dossiers | 16 | 16060000083391 | 16060000083391 | 1 | PO791932 | ||
| 16060000083394 | L16/dossiers | 16 | 16060000083393 | 16060000083393 | 1 | PO791932 | ||
| 16060000083396 | L16/dossiers | 16 | 16060000083395 | 16060000083395 | 1 | PO791932 | ||
| 16060000083398 | L16/dossiers | 16 | 16060000083397 | 16060000083397 | 1 | PO791932 | ||
| 16060000083401 | L16/dossiers | 16 | 16060000083400 | 16060000083400 | 1 | PO791932 | ||
| 16060000083405 | L16/dossiers | 16 | 16060000083404 | 16060000083404 | 1 | PO791932 | ||
| 16060000083415 | L16/dossiers | 16 | 16060000083414 | 16060000083414 | 1 | PO791932 | ||
| 16060000083418 | L16/dossiers | 16 | 16060000083417 | 16060000083417 | 1 | PO791932 | ||
| 16060000083420 | L16/dossiers | 16 | 16060000083419 | 16060000083419 | 1 | PO791932 | ||
| 16060000083424 | L16/dossiers | 16 | 16060000083423 | 16060000083423 | 1 | PO791932 | ||
| 16060000083426 | L16/dossiers | 16 | 16060000083425 | 16060000083425 | 1 | PO791932 | ||
| 16060000083429 | L16/dossiers | 16 | 16060000083428 | 16060000083428 | 1 | PO791932 | ||
| 16060000083432 | L16/dossiers | 16 | 16060000083431 | 16060000083431 | 1 | PO791932 | ||
| 16060000083434 | L16/dossiers | 16 | 16060000083433 | 16060000083433 | 1 | PO791932 | ||
| 16060000083437 | L16/dossiers | 16 | 16060000083436 | 16060000083436 | 1 | PO791932 | ||
| 16060000083440 | L16/dossiers | 16 | 16060000083439 | 16060000083439 | 1 | PO791932 | ||
| 16060000083444 | L16/dossiers | 16 | 16060000083443 | 16060000083443 | 1 | PO791932 |