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 |
|---|---|---|---|---|---|---|---|---|
| 16060000086819 | L16/dossiers | 16 | 16060000086818 | 16060000086818 | 1 | PA793780 | rapporteur | |
| 16060000086820 | L16/dossiers | 16 | 16060000086818 | 16060000086818 | 2 | PO419865 | ||
| 16060000086822 | L16/dossiers | 16 | 16060000086821 | 16060000086821 | 1 | PA720754 | rapporteur | |
| 16060000086823 | L16/dossiers | 16 | 16060000086821 | 16060000086821 | 2 | PO59051 | ||
| 16060000086825 | L16/dossiers | 16 | 16060000086824 | 16060000086824 | 1 | PA720014 | rapporteur | |
| 16060000086826 | L16/dossiers | 16 | 16060000086824 | 16060000086824 | 2 | PO419865 | ||
| 16060000086831 | L16/dossiers | 16 | 16060000086827 | 16060000086827 | 1 | PA720446 | rapporteur | |
| 16060000086832 | L16/dossiers | 16 | 16060000086827 | 16060000086827 | 2 | PO59051 | ||
| 16060000086834 | L16/dossiers | 16 | 16060000086833 | 16060000086833 | 1 | PA796018 | rapporteur | |
| 16060000086835 | L16/dossiers | 16 | 16060000086833 | 16060000086833 | 2 | PO415287 | ||
| 16060000086841 | L16/dossiers | 16 | 16060000086836 | 16060000086836 | 1 | PA793624 | rapporteur | |
| 16060000086842 | L16/dossiers | 16 | 16060000086836 | 16060000086836 | 2 | PA722202 | rapporteur | |
| 16060000086843 | L16/dossiers | 16 | 16060000086836 | 16060000086836 | 3 | PO59048 | ||
| 16060000086845 | L16/dossiers | 16 | 16060000086844 | 16060000086844 | 1 | PA795430 | rapporteur | |
| 16060000086846 | L16/dossiers | 16 | 16060000086844 | 16060000086844 | 2 | PO419610 | ||
| 16060000086848 | L16/dossiers | 16 | 16060000086847 | 16060000086847 | 1 | PA342196 | rapporteur | |
| 16060000086849 | L16/dossiers | 16 | 16060000086847 | 16060000086847 | 2 | PO419604 | ||
| 16060000086854 | L16/dossiers | 16 | 16060000086850 | 16060000086850 | 1 | PA608172 | rapporteur | |
| 16060000086855 | L16/dossiers | 16 | 16060000086850 | 16060000086850 | 2 | PO59048 | ||
| 16060000086857 | L16/dossiers | 16 | 16060000086856 | 16060000086856 | 1 | PA609332 | rapporteur | |
| 16060000086858 | L16/dossiers | 16 | 16060000086856 | 16060000086856 | 2 | PO419865 | ||
| 16060000086863 | L16/dossiers | 16 | 16060000086859 | 16060000086859 | 1 | PA795762 | rapporteur | |
| 16060000086864 | L16/dossiers | 16 | 16060000086859 | 16060000086859 | 2 | PO420120 | ||
| 16060000086869 | L16/dossiers | 16 | 16060000086865 | 16060000086865 | 1 | PA333285 | rapporteur | |
| 16060000086870 | L16/dossiers | 16 | 16060000086865 | 16060000086865 | 2 | PO419610 | ||
| 16060000086875 | L16/dossiers | 16 | 16060000086871 | 16060000086871 | 1 | PA718930 | rapporteur | |
| 16060000086876 | L16/dossiers | 16 | 16060000086871 | 16060000086871 | 2 | PO59047 | ||
| 16060000086881 | L16/dossiers | 16 | 16060000086877 | 16060000086877 | 1 | PA609590 | rapporteur | |
| 16060000086882 | L16/dossiers | 16 | 16060000086877 | 16060000086877 | 2 | PO420120 | ||
| 16060000086884 | L16/dossiers | 16 | 16060000086883 | 16060000086883 | 1 | PA793816 | rapporteur | |
| 16060000086885 | L16/dossiers | 16 | 16060000086883 | 16060000086883 | 2 | PO420120 | ||
| 16060000086887 | L16/dossiers | 16 | 16060000086886 | 16060000086886 | 1 | PA344201 | rapporteur | |
| 16060000086888 | L16/dossiers | 16 | 16060000086886 | 16060000086886 | 2 | PO420120 | ||
| 16060000086890 | L16/dossiers | 16 | 16060000086889 | 16060000086889 | 1 | PA793948 | rapporteur | |
| 16060000086891 | L16/dossiers | 16 | 16060000086889 | 16060000086889 | 2 | PO415287 | ||
| 16060000086893 | L16/dossiers | 16 | 16060000086892 | 16060000086892 | 1 | PA774960 | rapporteur | |
| 16060000086894 | L16/dossiers | 16 | 16060000086892 | 16060000086892 | 2 | PA708632 | rapporteur | |
| 16060000086895 | L16/dossiers | 16 | 16060000086892 | 16060000086892 | 3 | PO834687 | ||
| 16060000086897 | L16/dossiers | 16 | 16060000086896 | 16060000086896 | 1 | PA794486 | rapporteur | |
| 16060000086898 | L16/dossiers | 16 | 16060000086896 | 16060000086896 | 2 | PO834614 | ||
| 16060000086900 | L16/dossiers | 16 | 16060000086899 | 16060000086899 | 1 | PA794802 | rapporteur | |
| 16060000086901 | L16/dossiers | 16 | 16060000086899 | 16060000086899 | 2 | PO419610 | ||
| 16060000086903 | L16/dossiers | 16 | 16060000086902 | 16060000086902 | 1 | PA795362 | rapporteur | |
| 16060000086904 | L16/dossiers | 16 | 16060000086902 | 16060000086902 | 2 | PA795430 | rapporteur | |
| 16060000086905 | L16/dossiers | 16 | 16060000086902 | 16060000086902 | 3 | PO415287 | ||
| 16060000086907 | L16/dossiers | 16 | 16060000086906 | 16060000086906 | 1 | PA793572 | rapporteur | |
| 16060000086908 | L16/dossiers | 16 | 16060000086906 | 16060000086906 | 2 | PO59048 | ||
| 16060000086914 | L16/dossiers | 16 | 16060000086909 | 16060000086909 | 1 | PA719814 | rapporteur | |
| 16060000086915 | L16/dossiers | 16 | 16060000086909 | 16060000086909 | 2 | PA718884 | rapporteur | |
| 16060000086916 | L16/dossiers | 16 | 16060000086909 | 16060000086909 | 3 | PO419604 |