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 |
|---|---|---|---|---|---|---|---|---|
| 15060000113666 | L15/dossiers | 15 | 15060000113665 | 15060000113665 | 1 | PO717460 | ||
| 15060000113669 | L15/dossiers | 15 | 15060000113668 | 15060000113668 | 1 | PO717460 | ||
| 15060000113672 | L15/dossiers | 15 | 15060000113671 | 15060000113671 | 1 | PO717460 | ||
| 15060000113674 | L15/dossiers | 15 | 15060000113673 | 15060000113673 | 1 | PO717460 | ||
| 15060000113677 | L15/dossiers | 15 | 15060000113676 | 15060000113676 | 1 | PO717460 | ||
| 15060000113680 | L15/dossiers | 15 | 15060000113679 | 15060000113679 | 1 | PO717460 | ||
| 15060000113683 | L15/dossiers | 15 | 15060000113682 | 15060000113682 | 1 | PO717460 | ||
| 15060000113686 | L15/dossiers | 15 | 15060000113685 | 15060000113685 | 1 | PO717460 | ||
| 15060000113688 | L15/dossiers | 15 | 15060000113687 | 15060000113687 | 1 | PO717460 | ||
| 15060000113691 | L15/dossiers | 15 | 15060000113690 | 15060000113690 | 1 | PO717460 | ||
| 15060000113694 | L15/dossiers | 15 | 15060000113693 | 15060000113693 | 1 | PO717460 | ||
| 15060000113697 | L15/dossiers | 15 | 15060000113696 | 15060000113696 | 1 | PO717460 | ||
| 15060000113700 | L15/dossiers | 15 | 15060000113699 | 15060000113699 | 1 | PO717460 | ||
| 15060000113703 | L15/dossiers | 15 | 15060000113702 | 15060000113702 | 1 | PO717460 | ||
| 15060000113706 | L15/dossiers | 15 | 15060000113705 | 15060000113705 | 1 | PO717460 | ||
| 15060000113709 | L15/dossiers | 15 | 15060000113708 | 15060000113708 | 1 | PO717460 | ||
| 15060000113712 | L15/dossiers | 15 | 15060000113711 | 15060000113711 | 1 | PO717460 | ||
| 15060000113716 | L15/dossiers | 15 | 15060000113715 | 15060000113715 | 1 | PO717460 | ||
| 15060000113719 | L15/dossiers | 15 | 15060000113718 | 15060000113718 | 1 | PO717460 | ||
| 15060000113722 | L15/dossiers | 15 | 15060000113721 | 15060000113721 | 1 | PO717460 | ||
| 15060000113725 | L15/dossiers | 15 | 15060000113724 | 15060000113724 | 1 | PO717460 | ||
| 15060000113727 | L15/dossiers | 15 | 15060000113726 | 15060000113726 | 1 | PO717460 | ||
| 15060000113730 | L15/dossiers | 15 | 15060000113729 | 15060000113729 | 1 | PO717460 | ||
| 15060000113733 | L15/dossiers | 15 | 15060000113732 | 15060000113732 | 1 | PO717460 | ||
| 15060000113736 | L15/dossiers | 15 | 15060000113735 | 15060000113735 | 1 | PO717460 | ||
| 15060000113741 | L15/dossiers | 15 | 15060000113740 | 15060000113740 | 1 | PO717460 | ||
| 15060000113744 | L15/dossiers | 15 | 15060000113743 | 15060000113743 | 1 | PO717460 | ||
| 15060000113747 | L15/dossiers | 15 | 15060000113746 | 15060000113746 | 1 | PO717460 | ||
| 15060000113750 | L15/dossiers | 15 | 15060000113749 | 15060000113749 | 1 | PO717460 | ||
| 15060000113753 | L15/dossiers | 15 | 15060000113752 | 15060000113752 | 1 | PO717460 | ||
| 15060000113757 | L15/dossiers | 15 | 15060000113756 | 15060000113756 | 1 | PO717460 | ||
| 15060000113760 | L15/dossiers | 15 | 15060000113759 | 15060000113759 | 1 | PO717460 | ||
| 15060000113764 | L15/dossiers | 15 | 15060000113763 | 15060000113763 | 1 | PO717460 | ||
| 15060000113769 | L15/dossiers | 15 | 15060000113768 | 15060000113768 | 1 | PO717460 | ||
| 15060000113772 | L15/dossiers | 15 | 15060000113771 | 15060000113771 | 1 | PO717460 | ||
| 15060000113776 | L15/dossiers | 15 | 15060000113775 | 15060000113775 | 1 | PO717460 | ||
| 15060000113778 | L15/dossiers | 15 | 15060000113777 | 15060000113777 | 1 | PO717460 | ||
| 15060000113780 | L15/dossiers | 15 | 15060000113779 | 15060000113779 | 1 | PO717460 | ||
| 15060000113783 | L15/dossiers | 15 | 15060000113782 | 15060000113782 | 1 | PO717460 | ||
| 15060000113788 | L15/dossiers | 15 | 15060000113787 | 15060000113787 | 1 | PO717460 | ||
| 15060000113791 | L15/dossiers | 15 | 15060000113790 | 15060000113790 | 1 | PO717460 | ||
| 15060000113794 | L15/dossiers | 15 | 15060000113793 | 15060000113793 | 1 | PO717460 | ||
| 15060000113797 | L15/dossiers | 15 | 15060000113796 | 15060000113796 | 1 | PO717460 | ||
| 15060000113800 | L15/dossiers | 15 | 15060000113799 | 15060000113799 | 1 | PO717460 | ||
| 15060000113810 | L15/dossiers | 15 | 15060000113809 | 15060000113809 | 1 | PO717460 | ||
| 15060000113812 | L15/dossiers | 15 | 15060000113811 | 15060000113811 | 1 | PO717460 | ||
| 15060000113815 | L15/dossiers | 15 | 15060000113814 | 15060000113814 | 1 | PO717460 | ||
| 15060000113817 | L15/dossiers | 15 | 15060000113816 | 15060000113816 | 1 | PO717460 | ||
| 15060000113820 | L15/dossiers | 15 | 15060000113819 | 15060000113819 | 1 | PO717460 | ||
| 15060000113823 | L15/dossiers | 15 | 15060000113822 | 15060000113822 | 1 | PO717460 |