dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000076585 | L17/dossiers | 17 | 17060000076584 | 17060000076584 | 1 | PO78718 | ||
| 17060000076587 | L17/dossiers | 17 | 17060000076586 | 17060000076586 | 1 | PO78718 | ||
| 17060000076589 | L17/dossiers | 17 | 17060000076588 | 17060000076588 | 1 | PO78718 | ||
| 17060000076591 | L17/dossiers | 17 | 17060000076590 | 17060000076590 | 1 | PO78718 | ||
| 17060000076593 | L17/dossiers | 17 | 17060000076592 | 17060000076592 | 1 | PO78718 | ||
| 17060000076595 | L17/dossiers | 17 | 17060000076594 | 17060000076594 | 1 | PO78718 | ||
| 17060000076597 | L17/dossiers | 17 | 17060000076596 | 17060000076596 | 1 | PO78718 | ||
| 17060000076599 | L17/dossiers | 17 | 17060000076598 | 17060000076598 | 1 | PO78718 | ||
| 17060000076601 | L17/dossiers | 17 | 17060000076600 | 17060000076600 | 1 | PO78718 | ||
| 17060000076603 | L17/dossiers | 17 | 17060000076602 | 17060000076602 | 1 | PO78718 | ||
| 17060000076605 | L17/dossiers | 17 | 17060000076604 | 17060000076604 | 1 | PO78718 | ||
| 17060000076607 | L17/dossiers | 17 | 17060000076606 | 17060000076606 | 1 | PO78718 | ||
| 17060000076609 | L17/dossiers | 17 | 17060000076608 | 17060000076608 | 1 | PO78718 | ||
| 17060000076611 | L17/dossiers | 17 | 17060000076610 | 17060000076610 | 1 | PO78718 | ||
| 17060000076613 | L17/dossiers | 17 | 17060000076612 | 17060000076612 | 1 | PO78718 | ||
| 17060000076615 | L17/dossiers | 17 | 17060000076614 | 17060000076614 | 1 | PO78718 | ||
| 17060000076617 | L17/dossiers | 17 | 17060000076616 | 17060000076616 | 1 | PO78718 | ||
| 17060000076619 | L17/dossiers | 17 | 17060000076618 | 17060000076618 | 1 | PO78718 | ||
| 17060000076621 | L17/dossiers | 17 | 17060000076620 | 17060000076620 | 1 | PO78718 | ||
| 17060000076623 | L17/dossiers | 17 | 17060000076622 | 17060000076622 | 1 | PO78718 | ||
| 17060000076625 | L17/dossiers | 17 | 17060000076624 | 17060000076624 | 1 | PO78718 | ||
| 17060000076627 | L17/dossiers | 17 | 17060000076626 | 17060000076626 | 1 | PO78718 | ||
| 17060000076629 | L17/dossiers | 17 | 17060000076628 | 17060000076628 | 1 | PO78718 | ||
| 17060000076631 | L17/dossiers | 17 | 17060000076630 | 17060000076630 | 1 | PO78718 | ||
| 17060000076633 | L17/dossiers | 17 | 17060000076632 | 17060000076632 | 1 | PO78718 | ||
| 17060000076635 | L17/dossiers | 17 | 17060000076634 | 17060000076634 | 1 | PO78718 | ||
| 17060000076637 | L17/dossiers | 17 | 17060000076636 | 17060000076636 | 1 | PO78718 | ||
| 17060000076639 | L17/dossiers | 17 | 17060000076638 | 17060000076638 | 1 | PO78718 | ||
| 17060000076641 | L17/dossiers | 17 | 17060000076640 | 17060000076640 | 1 | PO78718 | ||
| 17060000076643 | L17/dossiers | 17 | 17060000076642 | 17060000076642 | 1 | PO78718 | ||
| 17060000076645 | L17/dossiers | 17 | 17060000076644 | 17060000076644 | 1 | PO78718 | ||
| 17060000076647 | L17/dossiers | 17 | 17060000076646 | 17060000076646 | 1 | PA703520 | rapporteur | |
| 17060000076648 | L17/dossiers | 17 | 17060000076646 | 17060000076646 | 2 | PO516753 | ||
| 17060000076650 | L17/dossiers | 17 | 17060000076649 | 17060000076649 | 1 | PA775242 | rapporteur | |
| 17060000076651 | L17/dossiers | 17 | 17060000076649 | 17060000076649 | 2 | PO211494 | ||
| 17060000076653 | L17/dossiers | 17 | 17060000076652 | 17060000076652 | 1 | PA775302 | rapporteur | |
| 17060000076654 | L17/dossiers | 17 | 17060000076652 | 17060000076652 | 2 | PO211490 | ||
| 17060000076656 | L17/dossiers | 17 | 17060000076655 | 17060000076655 | 1 | PA775218 | rapporteur | |
| 17060000076657 | L17/dossiers | 17 | 17060000076655 | 17060000076655 | 2 | PO516754 | ||
| 17060000076659 | L17/dossiers | 17 | 17060000076658 | 17060000076658 | 1 | PA775226 | rapporteur | |
| 17060000076660 | L17/dossiers | 17 | 17060000076658 | 17060000076658 | 2 | PO211490 | ||
| 17060000076662 | L17/dossiers | 17 | 17060000076661 | 17060000076661 | 1 | PA828008 | rapporteur | |
| 17060000076663 | L17/dossiers | 17 | 17060000076661 | 17060000076661 | 2 | PO211495 | ||
| 17060000076665 | L17/dossiers | 17 | 17060000076664 | 17060000076664 | 1 | PA429884 | rapporteur | |
| 17060000076666 | L17/dossiers | 17 | 17060000076664 | 17060000076664 | 2 | PO211494 | ||
| 17060000076668 | L17/dossiers | 17 | 17060000076667 | 17060000076667 | 1 | PA708632 | rapporteur | |
| 17060000076669 | L17/dossiers | 17 | 17060000076667 | 17060000076667 | 2 | PO211495 | ||
| 17060000076671 | L17/dossiers | 17 | 17060000076670 | 17060000076670 | 1 | PA429889 | rapporteur | |
| 17060000076672 | L17/dossiers | 17 | 17060000076670 | 17060000076670 | 2 | PO211493 | ||
| 17060000076674 | L17/dossiers | 17 | 17060000076673 | 17060000076673 | 1 | PA827996 | rapporteur |