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 |
|---|---|---|---|---|---|---|---|---|
| 16060000085395 | L16/dossiers | 16 | 16060000085394 | 16060000085394 | 1 | PA719472 | rapporteur | |
| 16060000085396 | L16/dossiers | 16 | 16060000085394 | 16060000085394 | 2 | PO806319 | ||
| 16060000085398 | L16/dossiers | 16 | 16060000085397 | 16060000085397 | 1 | PA719472 | rapporteur général | |
| 16060000085399 | L16/dossiers | 16 | 16060000085397 | 16060000085397 | 2 | PO59048 | ||
| 16060000085401 | L16/dossiers | 16 | 16060000085400 | 16060000085400 | 1 | PA793852 | rapporteur | |
| 16060000085402 | L16/dossiers | 16 | 16060000085400 | 16060000085400 | 2 | PO419865 | ||
| 16060000085407 | L16/dossiers | 16 | 16060000085403 | 16060000085403 | 1 | PA719512 | rapporteur | |
| 16060000085408 | L16/dossiers | 16 | 16060000085403 | 16060000085403 | 2 | PO419610 | ||
| 16060000085413 | L16/dossiers | 16 | 16060000085409 | 16060000085409 | 1 | PA720066 | rapporteur | |
| 16060000085414 | L16/dossiers | 16 | 16060000085409 | 16060000085409 | 2 | PO420120 | ||
| 16060000085419 | L16/dossiers | 16 | 16060000085415 | 16060000085415 | 1 | PA793940 | rapporteur | |
| 16060000085420 | L16/dossiers | 16 | 16060000085415 | 16060000085415 | 2 | PO59051 | ||
| 16060000085422 | L16/dossiers | 16 | 16060000085421 | 16060000085421 | 1 | PA795270 | rapporteur | |
| 16060000085423 | L16/dossiers | 16 | 16060000085421 | 16060000085421 | 2 | PO59051 | ||
| 16060000085428 | L16/dossiers | 16 | 16060000085424 | 16060000085424 | 1 | PA720862 | rapporteur | |
| 16060000085429 | L16/dossiers | 16 | 16060000085424 | 16060000085424 | 2 | PO419610 | ||
| 16060000085431 | L16/dossiers | 16 | 16060000085430 | 16060000085430 | 1 | PA794442 | rapporteur | |
| 16060000085432 | L16/dossiers | 16 | 16060000085430 | 16060000085430 | 2 | PO59047 | ||
| 16060000085434 | L16/dossiers | 16 | 16060000085433 | 16060000085433 | 1 | PA796078 | rapporteur | |
| 16060000085435 | L16/dossiers | 16 | 16060000085433 | 16060000085433 | 2 | PO59047 | ||
| 16060000085440 | L16/dossiers | 16 | 16060000085436 | 16060000085436 | 1 | PA793876 | rapporteur | |
| 16060000085441 | L16/dossiers | 16 | 16060000085436 | 16060000085436 | 2 | PO420120 | ||
| 16060000085443 | L16/dossiers | 16 | 16060000085442 | 16060000085442 | 1 | PA721262 | rapporteur | |
| 16060000085444 | L16/dossiers | 16 | 16060000085442 | 16060000085442 | 2 | PO59051 | ||
| 16060000085446 | L16/dossiers | 16 | 16060000085445 | 16060000085445 | 1 | PA720092 | rapporteur | |
| 16060000085447 | L16/dossiers | 16 | 16060000085445 | 16060000085445 | 2 | PO419865 | ||
| 16060000085449 | L16/dossiers | 16 | 16060000085448 | 16060000085448 | 1 | PA1008 | rapporteur | |
| 16060000085450 | L16/dossiers | 16 | 16060000085448 | 16060000085448 | 2 | PO59047 | ||
| 16060000085452 | L16/dossiers | 16 | 16060000085451 | 16060000085451 | 1 | PA795958 | rapporteur | |
| 16060000085453 | L16/dossiers | 16 | 16060000085451 | 16060000085451 | 2 | PO59051 | ||
| 16060000085455 | L16/dossiers | 16 | 16060000085454 | 16060000085454 | 1 | PA642695 | rapporteur | |
| 16060000085456 | L16/dossiers | 16 | 16060000085454 | 16060000085454 | 2 | PA795864 | rapporteur | |
| 16060000085457 | L16/dossiers | 16 | 16060000085454 | 16060000085454 | 3 | PO814996 | ||
| 16060000085459 | L16/dossiers | 16 | 16060000085458 | 16060000085458 | 1 | PA720146 | rapporteur | |
| 16060000085460 | L16/dossiers | 16 | 16060000085458 | 16060000085458 | 2 | PO419865 | ||
| 16060000085462 | L16/dossiers | 16 | 16060000085461 | 16060000085461 | 1 | PA717379 | rapporteur | |
| 16060000085463 | L16/dossiers | 16 | 16060000085461 | 16060000085461 | 2 | PO59047 | ||
| 16060000085465 | L16/dossiers | 16 | 16060000085464 | 16060000085464 | 1 | PA795808 | rapporteur | |
| 16060000085466 | L16/dossiers | 16 | 16060000085464 | 16060000085464 | 2 | PO59047 | ||
| 16060000085471 | L16/dossiers | 16 | 16060000085467 | 16060000085467 | 1 | PA774960 | rapporteur | |
| 16060000085472 | L16/dossiers | 16 | 16060000085467 | 16060000085467 | 2 | PO59051 | ||
| 16060000085477 | L16/dossiers | 16 | 16060000085473 | 16060000085473 | 1 | PA608695 | rapporteur | |
| 16060000085478 | L16/dossiers | 16 | 16060000085473 | 16060000085473 | 2 | PO59051 | ||
| 16060000085480 | L16/dossiers | 16 | 16060000085479 | 16060000085479 | 1 | PA774958 | rapporteur | |
| 16060000085481 | L16/dossiers | 16 | 16060000085479 | 16060000085479 | 2 | PO59051 | ||
| 16060000085486 | L16/dossiers | 16 | 16060000085482 | 16060000085482 | 1 | PA795828 | rapporteur | |
| 16060000085487 | L16/dossiers | 16 | 16060000085482 | 16060000085482 | 2 | PO419610 | ||
| 16060000085492 | L16/dossiers | 16 | 16060000085488 | 16060000085488 | 1 | PA793394 | rapporteur | |
| 16060000085493 | L16/dossiers | 16 | 16060000085488 | 16060000085488 | 2 | PO419610 | ||
| 16060000085498 | L16/dossiers | 16 | 16060000085494 | 16060000085494 | 1 | PA795156 | rapporteur |