dossiers.document_division_auteur
Chemin document.divisions.division.auteurs.auteur · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 %
7 614 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 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | acteur_acteur_ref | VARCHAR | document.divisions.division.auteurs.auteur.acteur.acteurRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % |
| 10 | acteur_qualite | VARCHAR | document.divisions.division.auteurs.auteur.acteur.qualite · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % · 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 |
| 11 | organe_organe_ref | VARCHAR | document.divisions.division.auteurs.auteur.organe.organeRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000086808 | L16/dossiers | 16 | 16060000086804 | 16060000086805 | 3 | 0 | PO59051 | |||
| 16060000086814 | L16/dossiers | 16 | 16060000086812 | 16060000086813 | 1 | 0 | PA794486 | rapporteur | ||
| 16060000086815 | L16/dossiers | 16 | 16060000086812 | 16060000086813 | 2 | 0 | PO59051 | |||
| 16060000086829 | L16/dossiers | 16 | 16060000086827 | 16060000086828 | 1 | 0 | PA720446 | rapporteur | ||
| 16060000086830 | L16/dossiers | 16 | 16060000086827 | 16060000086828 | 2 | 0 | PO59051 | |||
| 16060000086838 | L16/dossiers | 16 | 16060000086836 | 16060000086837 | 1 | 0 | PA793624 | rapporteur | ||
| 16060000086839 | L16/dossiers | 16 | 16060000086836 | 16060000086837 | 2 | 0 | PA722202 | rapporteur | ||
| 16060000086840 | L16/dossiers | 16 | 16060000086836 | 16060000086837 | 3 | 0 | PO59048 | |||
| 16060000086852 | L16/dossiers | 16 | 16060000086850 | 16060000086851 | 1 | 0 | PA608172 | rapporteur | ||
| 16060000086853 | L16/dossiers | 16 | 16060000086850 | 16060000086851 | 2 | 0 | PO59048 | |||
| 16060000086861 | L16/dossiers | 16 | 16060000086859 | 16060000086860 | 1 | 0 | PA795762 | rapporteur | ||
| 16060000086862 | L16/dossiers | 16 | 16060000086859 | 16060000086860 | 2 | 0 | PO420120 | |||
| 16060000086867 | L16/dossiers | 16 | 16060000086865 | 16060000086866 | 1 | 0 | PA333285 | rapporteur | ||
| 16060000086868 | L16/dossiers | 16 | 16060000086865 | 16060000086866 | 2 | 0 | PO419610 | |||
| 16060000086873 | L16/dossiers | 16 | 16060000086871 | 16060000086872 | 1 | 0 | PA718930 | rapporteur | ||
| 16060000086874 | L16/dossiers | 16 | 16060000086871 | 16060000086872 | 2 | 0 | PO59047 | |||
| 16060000086879 | L16/dossiers | 16 | 16060000086877 | 16060000086878 | 1 | 0 | PA609590 | rapporteur | ||
| 16060000086880 | L16/dossiers | 16 | 16060000086877 | 16060000086878 | 2 | 0 | PO420120 | |||
| 16060000086911 | L16/dossiers | 16 | 16060000086909 | 16060000086910 | 1 | 0 | PA719814 | rapporteur | ||
| 16060000086912 | L16/dossiers | 16 | 16060000086909 | 16060000086910 | 2 | 0 | PA718884 | rapporteur | ||
| 16060000086913 | L16/dossiers | 16 | 16060000086909 | 16060000086910 | 3 | 0 | PO419604 | |||
| 16060000086919 | L16/dossiers | 16 | 16060000086917 | 16060000086918 | 1 | 0 | PA795386 | rapporteur | ||
| 16060000086920 | L16/dossiers | 16 | 16060000086917 | 16060000086918 | 2 | 0 | PO59051 | |||
| 16060000086925 | L16/dossiers | 16 | 16060000086923 | 16060000086924 | 1 | 0 | PA340343 | rapporteur | ||
| 16060000086926 | L16/dossiers | 16 | 16060000086923 | 16060000086924 | 2 | 0 | PO59051 | |||
| 16060000086934 | L16/dossiers | 16 | 16060000086932 | 16060000086933 | 1 | 0 | PA793306 | rapporteur | ||
| 16060000086935 | L16/dossiers | 16 | 16060000086932 | 16060000086933 | 2 | 0 | PO59051 | |||
| 16060000086940 | L16/dossiers | 16 | 16060000086938 | 16060000086939 | 1 | 0 | PA722336 | rapporteur | ||
| 16060000086941 | L16/dossiers | 16 | 16060000086938 | 16060000086939 | 2 | 0 | PO420120 | |||
| 16060000086949 | L16/dossiers | 16 | 16060000086947 | 16060000086948 | 1 | 0 | PA722150 | rapporteur | ||
| 16060000086950 | L16/dossiers | 16 | 16060000086947 | 16060000086948 | 2 | 0 | PO59051 | |||
| 16060000086955 | L16/dossiers | 16 | 16060000086953 | 16060000086954 | 1 | 0 | PA794838 | rapporteur | ||
| 16060000086956 | L16/dossiers | 16 | 16060000086953 | 16060000086954 | 2 | 0 | PO59051 | |||
| 16060000086964 | L16/dossiers | 16 | 16060000086962 | 16060000086963 | 1 | 0 | PA722366 | rapporteur | ||
| 16060000086965 | L16/dossiers | 16 | 16060000086962 | 16060000086963 | 2 | 0 | PO419865 | |||
| 16060000086974 | L16/dossiers | 16 | 16060000086972 | 16060000086973 | 1 | 0 | PA795026 | rapporteur | ||
| 16060000086975 | L16/dossiers | 16 | 16060000086972 | 16060000086973 | 2 | 0 | PO419865 | |||
| 16060000086984 | L16/dossiers | 16 | 16060000086982 | 16060000086983 | 1 | 0 | PA721094 | rapporteur | ||
| 16060000086985 | L16/dossiers | 16 | 16060000086982 | 16060000086983 | 2 | 0 | PO59051 | |||
| 16060000086990 | L16/dossiers | 16 | 16060000086988 | 16060000086989 | 1 | 0 | PA720446 | rapporteur | ||
| 16060000086991 | L16/dossiers | 16 | 16060000086988 | 16060000086989 | 2 | 0 | PO59051 | |||
| 16060000086996 | L16/dossiers | 16 | 16060000086994 | 16060000086995 | 1 | 0 | PA720370 | rapporteur | ||
| 16060000086997 | L16/dossiers | 16 | 16060000086994 | 16060000086995 | 2 | 0 | PO59051 | |||
| 16060000087002 | L16/dossiers | 16 | 16060000087000 | 16060000087001 | 1 | 0 | PA719798 | rapporteur | ||
| 16060000087003 | L16/dossiers | 16 | 16060000087000 | 16060000087001 | 2 | 0 | PO59048 | |||
| 16060000087011 | L16/dossiers | 16 | 16060000087009 | 16060000087010 | 1 | 0 | PA722150 | rapporteur | ||
| 16060000087012 | L16/dossiers | 16 | 16060000087009 | 16060000087010 | 2 | 0 | PO59051 | |||
| 16060000087022 | L16/dossiers | 16 | 16060000087020 | 16060000087021 | 1 | 0 | PA342415 | rapporteur | ||
| 16060000087023 | L16/dossiers | 16 | 16060000087020 | 16060000087021 | 2 | 0 | PO420120 | |||
| 16060000087031 | L16/dossiers | 16 | 16060000087029 | 16060000087030 | 1 | 0 | PA795908 | rapporteur |