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 |
|---|---|---|---|---|---|---|---|---|
| 16060000062665 | L16/dossiers | 16 | 16060000062664 | 16060000062664 | 1 | PO78718 | ||
| 16060000062667 | L16/dossiers | 16 | 16060000062666 | 16060000062666 | 1 | PO78718 | ||
| 16060000062669 | L16/dossiers | 16 | 16060000062668 | 16060000062668 | 1 | PO78718 | ||
| 16060000062671 | L16/dossiers | 16 | 16060000062670 | 16060000062670 | 1 | PO78718 | ||
| 16060000062673 | L16/dossiers | 16 | 16060000062672 | 16060000062672 | 1 | PO78718 | ||
| 16060000062675 | L16/dossiers | 16 | 16060000062674 | 16060000062674 | 1 | PO78718 | ||
| 16060000062677 | L16/dossiers | 16 | 16060000062676 | 16060000062676 | 1 | PO78718 | ||
| 16060000062679 | L16/dossiers | 16 | 16060000062678 | 16060000062678 | 1 | PO78718 | ||
| 16060000062681 | L16/dossiers | 16 | 16060000062680 | 16060000062680 | 1 | PO78718 | ||
| 16060000062683 | L16/dossiers | 16 | 16060000062682 | 16060000062682 | 1 | PO78718 | ||
| 16060000062685 | L16/dossiers | 16 | 16060000062684 | 16060000062684 | 1 | PO78718 | ||
| 16060000062687 | L16/dossiers | 16 | 16060000062686 | 16060000062686 | 1 | PO78718 | ||
| 16060000062689 | L16/dossiers | 16 | 16060000062688 | 16060000062688 | 1 | PO78718 | ||
| 16060000062691 | L16/dossiers | 16 | 16060000062690 | 16060000062690 | 1 | PO78718 | ||
| 16060000062693 | L16/dossiers | 16 | 16060000062692 | 16060000062692 | 1 | PO78718 | ||
| 16060000062695 | L16/dossiers | 16 | 16060000062694 | 16060000062694 | 1 | PO78718 | ||
| 16060000062697 | L16/dossiers | 16 | 16060000062696 | 16060000062696 | 1 | PO78718 | ||
| 16060000062699 | L16/dossiers | 16 | 16060000062698 | 16060000062698 | 1 | PO78718 | ||
| 16060000062701 | L16/dossiers | 16 | 16060000062700 | 16060000062700 | 1 | PO78718 | ||
| 16060000062703 | L16/dossiers | 16 | 16060000062702 | 16060000062702 | 1 | PO78718 | ||
| 16060000062705 | L16/dossiers | 16 | 16060000062704 | 16060000062704 | 1 | PO78718 | ||
| 16060000062707 | L16/dossiers | 16 | 16060000062706 | 16060000062706 | 1 | PO78718 | ||
| 16060000062709 | L16/dossiers | 16 | 16060000062708 | 16060000062708 | 1 | PO78718 | ||
| 16060000062711 | L16/dossiers | 16 | 16060000062710 | 16060000062710 | 1 | PO78718 | ||
| 16060000062713 | L16/dossiers | 16 | 16060000062712 | 16060000062712 | 1 | PO78718 | ||
| 16060000062715 | L16/dossiers | 16 | 16060000062714 | 16060000062714 | 1 | PO78718 | ||
| 16060000062717 | L16/dossiers | 16 | 16060000062716 | 16060000062716 | 1 | PO78718 | ||
| 16060000062719 | L16/dossiers | 16 | 16060000062718 | 16060000062718 | 1 | PO78718 | ||
| 16060000062721 | L16/dossiers | 16 | 16060000062720 | 16060000062720 | 1 | PO78718 | ||
| 16060000062723 | L16/dossiers | 16 | 16060000062722 | 16060000062722 | 1 | PO78718 | ||
| 16060000062725 | L16/dossiers | 16 | 16060000062724 | 16060000062724 | 1 | PO78718 | ||
| 16060000062727 | L16/dossiers | 16 | 16060000062726 | 16060000062726 | 1 | PO78718 | ||
| 16060000062729 | L16/dossiers | 16 | 16060000062728 | 16060000062728 | 1 | PO78718 | ||
| 16060000062731 | L16/dossiers | 16 | 16060000062730 | 16060000062730 | 1 | PO78718 | ||
| 16060000062733 | L16/dossiers | 16 | 16060000062732 | 16060000062732 | 1 | PO78718 | ||
| 16060000062735 | L16/dossiers | 16 | 16060000062734 | 16060000062734 | 1 | PO78718 | ||
| 16060000062737 | L16/dossiers | 16 | 16060000062736 | 16060000062736 | 1 | PO78718 | ||
| 16060000062739 | L16/dossiers | 16 | 16060000062738 | 16060000062738 | 1 | PO78718 | ||
| 16060000062741 | L16/dossiers | 16 | 16060000062740 | 16060000062740 | 1 | PO78718 | ||
| 16060000062743 | L16/dossiers | 16 | 16060000062742 | 16060000062742 | 1 | PO78718 | ||
| 16060000062745 | L16/dossiers | 16 | 16060000062744 | 16060000062744 | 1 | PO78718 | ||
| 16060000062747 | L16/dossiers | 16 | 16060000062746 | 16060000062746 | 1 | PO78718 | ||
| 16060000062749 | L16/dossiers | 16 | 16060000062748 | 16060000062748 | 1 | PO78718 | ||
| 16060000062751 | L16/dossiers | 16 | 16060000062750 | 16060000062750 | 1 | PO78718 | ||
| 16060000062753 | L16/dossiers | 16 | 16060000062752 | 16060000062752 | 1 | PO78718 | ||
| 16060000062755 | L16/dossiers | 16 | 16060000062754 | 16060000062754 | 1 | PO78718 | ||
| 16060000062757 | L16/dossiers | 16 | 16060000062756 | 16060000062756 | 1 | PO78718 | ||
| 16060000062759 | L16/dossiers | 16 | 16060000062758 | 16060000062758 | 1 | PO78718 | ||
| 16060000062761 | L16/dossiers | 16 | 16060000062760 | 16060000062760 | 1 | PO78718 | ||
| 16060000062763 | L16/dossiers | 16 | 16060000062762 | 16060000062762 | 1 | PO78718 |