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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 14060000019808 | L14/dossiers | 14 | 14060000019785 | 14060000019804 | 4 | 0 | PA303998 | rapporteur | ||
| 14060000019809 | L14/dossiers | 14 | 14060000019785 | 14060000019804 | 5 | 0 | PA1502 | rapporteur | ||
| 14060000019810 | L14/dossiers | 14 | 14060000019785 | 14060000019804 | 6 | 0 | PO211493 | |||
| 14060000019812 | L14/dossiers | 14 | 14060000019785 | 14060000019811 | 1 | 0 | PA415483 | rapporteur | ||
| 14060000019813 | L14/dossiers | 14 | 14060000019785 | 14060000019811 | 2 | 0 | PA1779 | rapporteur | ||
| 14060000019814 | L14/dossiers | 14 | 14060000019785 | 14060000019811 | 3 | 0 | PA415461 | rapporteur | ||
| 14060000019815 | L14/dossiers | 14 | 14060000019785 | 14060000019811 | 4 | 0 | PA303998 | rapporteur | ||
| 14060000019816 | L14/dossiers | 14 | 14060000019785 | 14060000019811 | 5 | 0 | PA1502 | rapporteur | ||
| 14060000019817 | L14/dossiers | 14 | 14060000019785 | 14060000019811 | 6 | 0 | PO211493 | |||
| 14060000019878 | L14/dossiers | 14 | 14060000019876 | 14060000019877 | 1 | 0 | PA2161 | rapporteur | ||
| 14060000019879 | L14/dossiers | 14 | 14060000019876 | 14060000019877 | 2 | 0 | PO211495 | |||
| 14060000019881 | L14/dossiers | 14 | 14060000019876 | 14060000019880 | 1 | 0 | PA2161 | rapporteur | ||
| 14060000019882 | L14/dossiers | 14 | 14060000019876 | 14060000019880 | 2 | 0 | PO211495 | |||
| 14060000019960 | L14/dossiers | 14 | 14060000019958 | 14060000019959 | 1 | 0 | PA332305 | rapporteur | ||
| 14060000019961 | L14/dossiers | 14 | 14060000019958 | 14060000019959 | 2 | 0 | PO420120 | |||
| 14060000019963 | L14/dossiers | 14 | 14060000019958 | 14060000019962 | 1 | 0 | PA332305 | rapporteur | ||
| 14060000019964 | L14/dossiers | 14 | 14060000019958 | 14060000019962 | 2 | 0 | PO420120 | |||
| 14060000020506 | L14/dossiers | 14 | 14060000020504 | 14060000020505 | 1 | 0 | PA605804 | rapporteur | ||
| 14060000020507 | L14/dossiers | 14 | 14060000020504 | 14060000020505 | 2 | 0 | PO420120 | |||
| 14060000021678 | L14/dossiers | 14 | 14060000021676 | 14060000021677 | 1 | 0 | PA267735 | rapporteur | ||
| 14060000021679 | L14/dossiers | 14 | 14060000021676 | 14060000021677 | 2 | 0 | PA1476 | rapporteur | ||
| 14060000021680 | L14/dossiers | 14 | 14060000021676 | 14060000021677 | 3 | 0 | PO273589 | |||
| 14060000021682 | L14/dossiers | 14 | 14060000021676 | 14060000021681 | 1 | 0 | PA267735 | rapporteur | ||
| 14060000021683 | L14/dossiers | 14 | 14060000021676 | 14060000021681 | 2 | 0 | PA1476 | rapporteur | ||
| 14060000021684 | L14/dossiers | 14 | 14060000021676 | 14060000021681 | 3 | 0 | PO273589 | |||
| 14060000021770 | L14/dossiers | 14 | 14060000021768 | 14060000021769 | 1 | 0 | PA642699 | rapporteur | ||
| 14060000021771 | L14/dossiers | 14 | 14060000021768 | 14060000021769 | 2 | 0 | PO420120 | |||
| 14060000021832 | L14/dossiers | 14 | 14060000021830 | 14060000021831 | 1 | 0 | PA606555 | rapporteur | ||
| 14060000021833 | L14/dossiers | 14 | 14060000021830 | 14060000021831 | 2 | 0 | PA227094 | rapporteur | ||
| 14060000021834 | L14/dossiers | 14 | 14060000021830 | 14060000021831 | 3 | 0 | PO273589 | |||
| 14060000021836 | L14/dossiers | 14 | 14060000021830 | 14060000021835 | 1 | 0 | PA606555 | rapporteur | ||
| 14060000021837 | L14/dossiers | 14 | 14060000021830 | 14060000021835 | 2 | 0 | PA227094 | rapporteur | ||
| 14060000021838 | L14/dossiers | 14 | 14060000021830 | 14060000021835 | 3 | 0 | PO273589 | |||
| 14060000022626 | L14/dossiers | 14 | 14060000022624 | 14060000022625 | 1 | 0 | PA2183 | rapporteur | ||
| 14060000022627 | L14/dossiers | 14 | 14060000022624 | 14060000022625 | 2 | 0 | PO211495 | |||
| 14060000022629 | L14/dossiers | 14 | 14060000022624 | 14060000022628 | 1 | 0 | PA2183 | rapporteur | ||
| 14060000022630 | L14/dossiers | 14 | 14060000022624 | 14060000022628 | 2 | 0 | PO211495 | |||
| 14060000023767 | L14/dossiers | 14 | 14060000023765 | 14060000023766 | 1 | 0 | PA429838 | rapporteur | ||
| 14060000023768 | L14/dossiers | 14 | 14060000023765 | 14060000023766 | 2 | 0 | PA1684 | rapporteur | ||
| 14060000023769 | L14/dossiers | 14 | 14060000023765 | 14060000023766 | 3 | 0 | PO211495 | |||
| 14060000023771 | L14/dossiers | 14 | 14060000023765 | 14060000023770 | 1 | 0 | PA429838 | rapporteur | ||
| 14060000023772 | L14/dossiers | 14 | 14060000023765 | 14060000023770 | 2 | 0 | PA1684 | rapporteur | ||
| 14060000023773 | L14/dossiers | 14 | 14060000023765 | 14060000023770 | 3 | 0 | PO211495 | |||
| 14060000023786 | L14/dossiers | 14 | 14060000023784 | 14060000023785 | 1 | 0 | PA330357 | rapporteur | ||
| 14060000023787 | L14/dossiers | 14 | 14060000023784 | 14060000023785 | 2 | 0 | PO59051 | |||
| 14060000023789 | L14/dossiers | 14 | 14060000023784 | 14060000023788 | 1 | 0 | PA330357 | rapporteur | ||
| 14060000023790 | L14/dossiers | 14 | 14060000023784 | 14060000023788 | 2 | 0 | PO59051 | |||
| 14060000024055 | L14/dossiers | 14 | 14060000024053 | 14060000024054 | 1 | 0 | PA605888 | rapporteur | ||
| 14060000024056 | L14/dossiers | 14 | 14060000024053 | 14060000024054 | 2 | 0 | PO710237 | |||
| 14060000024064 | L14/dossiers | 14 | 14060000024062 | 14060000024063 | 1 | 0 | PA605888 | rapporteur |