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 |
|---|---|---|---|---|---|---|---|---|
| 15060000076508 | L15/dossiers | 15 | 15060000076507 | 15060000076507 | 1 | PO717460 | ||
| 15060000076511 | L15/dossiers | 15 | 15060000076510 | 15060000076510 | 1 | PO717460 | ||
| 15060000076514 | L15/dossiers | 15 | 15060000076513 | 15060000076513 | 1 | PO717460 | ||
| 15060000076517 | L15/dossiers | 15 | 15060000076516 | 15060000076516 | 1 | PO717460 | ||
| 15060000076520 | L15/dossiers | 15 | 15060000076519 | 15060000076519 | 1 | PO717460 | ||
| 15060000076523 | L15/dossiers | 15 | 15060000076522 | 15060000076522 | 1 | PO717460 | ||
| 15060000076526 | L15/dossiers | 15 | 15060000076525 | 15060000076525 | 1 | PO717460 | ||
| 15060000076529 | L15/dossiers | 15 | 15060000076528 | 15060000076528 | 1 | PO717460 | ||
| 15060000076532 | L15/dossiers | 15 | 15060000076531 | 15060000076531 | 1 | PO717460 | ||
| 15060000076535 | L15/dossiers | 15 | 15060000076534 | 15060000076534 | 1 | PO717460 | ||
| 15060000076538 | L15/dossiers | 15 | 15060000076537 | 15060000076537 | 1 | PO717460 | ||
| 15060000076541 | L15/dossiers | 15 | 15060000076540 | 15060000076540 | 1 | PO717460 | ||
| 15060000076544 | L15/dossiers | 15 | 15060000076543 | 15060000076543 | 1 | PO717460 | ||
| 15060000076547 | L15/dossiers | 15 | 15060000076546 | 15060000076546 | 1 | PO717460 | ||
| 15060000076550 | L15/dossiers | 15 | 15060000076549 | 15060000076549 | 1 | PO717460 | ||
| 15060000076553 | L15/dossiers | 15 | 15060000076552 | 15060000076552 | 1 | PO717460 | ||
| 15060000076556 | L15/dossiers | 15 | 15060000076555 | 15060000076555 | 1 | PO717460 | ||
| 15060000076559 | L15/dossiers | 15 | 15060000076558 | 15060000076558 | 1 | PO717460 | ||
| 15060000076562 | L15/dossiers | 15 | 15060000076561 | 15060000076561 | 1 | PO717460 | ||
| 15060000076565 | L15/dossiers | 15 | 15060000076564 | 15060000076564 | 1 | PO717460 | ||
| 15060000076568 | L15/dossiers | 15 | 15060000076567 | 15060000076567 | 1 | PO717460 | ||
| 15060000076571 | L15/dossiers | 15 | 15060000076570 | 15060000076570 | 1 | PO717460 | ||
| 15060000076574 | L15/dossiers | 15 | 15060000076573 | 15060000076573 | 1 | PO717460 | ||
| 15060000076577 | L15/dossiers | 15 | 15060000076576 | 15060000076576 | 1 | PO717460 | ||
| 15060000076580 | L15/dossiers | 15 | 15060000076579 | 15060000076579 | 1 | PO717460 | ||
| 15060000076583 | L15/dossiers | 15 | 15060000076582 | 15060000076582 | 1 | PO717460 | ||
| 15060000076586 | L15/dossiers | 15 | 15060000076585 | 15060000076585 | 1 | PO717460 | ||
| 15060000076589 | L15/dossiers | 15 | 15060000076588 | 15060000076588 | 1 | PO717460 | ||
| 15060000076592 | L15/dossiers | 15 | 15060000076591 | 15060000076591 | 1 | PO717460 | ||
| 15060000076595 | L15/dossiers | 15 | 15060000076594 | 15060000076594 | 1 | PO717460 | ||
| 15060000076598 | L15/dossiers | 15 | 15060000076597 | 15060000076597 | 1 | PO717460 | ||
| 15060000076601 | L15/dossiers | 15 | 15060000076600 | 15060000076600 | 1 | PO717460 | ||
| 15060000076604 | L15/dossiers | 15 | 15060000076603 | 15060000076603 | 1 | PO717460 | ||
| 15060000076607 | L15/dossiers | 15 | 15060000076606 | 15060000076606 | 1 | PO717460 | ||
| 15060000076610 | L15/dossiers | 15 | 15060000076609 | 15060000076609 | 1 | PO717460 | ||
| 15060000076613 | L15/dossiers | 15 | 15060000076612 | 15060000076612 | 1 | PO717460 | ||
| 15060000076616 | L15/dossiers | 15 | 15060000076615 | 15060000076615 | 1 | PO717460 | ||
| 15060000076619 | L15/dossiers | 15 | 15060000076618 | 15060000076618 | 1 | PO717460 | ||
| 15060000076622 | L15/dossiers | 15 | 15060000076621 | 15060000076621 | 1 | PO717460 | ||
| 15060000076625 | L15/dossiers | 15 | 15060000076624 | 15060000076624 | 1 | PO717460 | ||
| 15060000076628 | L15/dossiers | 15 | 15060000076627 | 15060000076627 | 1 | PO717460 | ||
| 15060000076631 | L15/dossiers | 15 | 15060000076630 | 15060000076630 | 1 | PO717460 | ||
| 15060000076634 | L15/dossiers | 15 | 15060000076633 | 15060000076633 | 1 | PO717460 | ||
| 15060000076637 | L15/dossiers | 15 | 15060000076636 | 15060000076636 | 1 | PO717460 | ||
| 15060000076640 | L15/dossiers | 15 | 15060000076639 | 15060000076639 | 1 | PO717460 | ||
| 15060000076643 | L15/dossiers | 15 | 15060000076642 | 15060000076642 | 1 | PO717460 | ||
| 15060000076645 | L15/dossiers | 15 | 15060000076644 | 15060000076644 | 1 | PO717460 | ||
| 15060000076647 | L15/dossiers | 15 | 15060000076646 | 15060000076646 | 1 | PO717460 | ||
| 15060000076649 | L15/dossiers | 15 | 15060000076648 | 15060000076648 | 1 | PO717460 | ||
| 15060000076651 | L15/dossiers | 15 | 15060000076650 | 15060000076650 | 1 | PO717460 |