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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000087032 | L16/dossiers | 16 | 16060000087029 | 16060000087030 | 2 | 0 | PO59051 | |||
| 16060000087037 | L16/dossiers | 16 | 16060000087035 | 16060000087036 | 1 | 0 | PA720960 | rapporteur | ||
| 16060000087038 | L16/dossiers | 16 | 16060000087035 | 16060000087036 | 2 | 0 | PO59051 | |||
| 16060000087054 | L16/dossiers | 16 | 16060000087052 | 16060000087053 | 1 | 0 | PA793664 | rapporteur | ||
| 16060000087055 | L16/dossiers | 16 | 16060000087052 | 16060000087053 | 2 | 0 | PO419610 | |||
| 16060000087066 | L16/dossiers | 16 | 16060000087064 | 16060000087065 | 1 | 0 | PA793708 | rapporteur | ||
| 16060000087067 | L16/dossiers | 16 | 16060000087064 | 16060000087065 | 2 | 0 | PO420120 | |||
| 16060000087075 | L16/dossiers | 16 | 16060000087073 | 16060000087074 | 1 | 0 | PA793948 | rapporteur | ||
| 16060000087076 | L16/dossiers | 16 | 16060000087073 | 16060000087074 | 2 | 0 | PO419865 | |||
| 16060000087081 | L16/dossiers | 16 | 16060000087079 | 16060000087080 | 1 | 0 | PA794146 | rapporteur | ||
| 16060000087082 | L16/dossiers | 16 | 16060000087079 | 16060000087080 | 2 | 0 | PO419610 | |||
| 16060000087102 | L16/dossiers | 16 | 16060000087100 | 16060000087101 | 1 | 0 | PA721722 | rapporteur | ||
| 16060000087103 | L16/dossiers | 16 | 16060000087100 | 16060000087101 | 2 | 0 | PO59051 | |||
| 16060000087108 | L16/dossiers | 16 | 16060000087106 | 16060000087107 | 1 | 0 | PA720480 | rapporteur | ||
| 16060000087109 | L16/dossiers | 16 | 16060000087106 | 16060000087107 | 2 | 0 | PO420120 | |||
| 16060000087114 | L16/dossiers | 16 | 16060000087112 | 16060000087113 | 1 | 0 | PA721150 | rapporteur | ||
| 16060000087115 | L16/dossiers | 16 | 16060000087112 | 16060000087113 | 2 | 0 | PO59048 | |||
| 16060000087120 | L16/dossiers | 16 | 16060000087118 | 16060000087119 | 1 | 0 | PA643048 | rapporteur | ||
| 16060000087121 | L16/dossiers | 16 | 16060000087118 | 16060000087119 | 2 | 0 | PO419604 | |||
| 16060000087149 | L16/dossiers | 16 | 16060000087147 | 16060000087148 | 1 | 0 | PA795794 | rapporteur | ||
| 16060000087150 | L16/dossiers | 16 | 16060000087147 | 16060000087148 | 2 | 0 | PO419604 | |||
| 16060000087155 | L16/dossiers | 16 | 16060000087153 | 16060000087154 | 1 | 0 | PA722038 | rapporteur | ||
| 16060000087156 | L16/dossiers | 16 | 16060000087153 | 16060000087154 | 2 | 0 | PO419865 | |||
| 16060000087164 | L16/dossiers | 16 | 16060000087162 | 16060000087163 | 1 | 0 | PA642868 | rapporteur | ||
| 16060000087165 | L16/dossiers | 16 | 16060000087162 | 16060000087163 | 2 | 0 | PO420120 | |||
| 16060000087170 | L16/dossiers | 16 | 16060000087168 | 16060000087169 | 1 | 0 | PA719922 | rapporteur | ||
| 16060000087171 | L16/dossiers | 16 | 16060000087168 | 16060000087169 | 2 | 0 | PO59048 | |||
| 16060000087182 | L16/dossiers | 16 | 16060000087180 | 16060000087181 | 1 | 0 | PA721584 | rapporteur | ||
| 16060000087183 | L16/dossiers | 16 | 16060000087180 | 16060000087181 | 2 | 0 | PO59051 | |||
| 16060000087194 | L16/dossiers | 16 | 16060000087192 | 16060000087193 | 1 | 0 | PA720222 | rapporteur | ||
| 16060000087195 | L16/dossiers | 16 | 16060000087192 | 16060000087193 | 2 | 0 | PA720342 | rapporteur | ||
| 16060000087196 | L16/dossiers | 16 | 16060000087192 | 16060000087193 | 3 | 0 | PA719664 | rapporteur | ||
| 16060000087197 | L16/dossiers | 16 | 16060000087192 | 16060000087193 | 4 | 0 | PA795374 | rapporteur | ||
| 16060000087198 | L16/dossiers | 16 | 16060000087192 | 16060000087193 | 5 | 0 | PO419610 | |||
| 16060000087200 | L16/dossiers | 16 | 16060000087192 | 16060000087199 | 1 | 0 | PA720222 | rapporteur | ||
| 16060000087201 | L16/dossiers | 16 | 16060000087192 | 16060000087199 | 2 | 0 | PA720342 | rapporteur | ||
| 16060000087202 | L16/dossiers | 16 | 16060000087192 | 16060000087199 | 3 | 0 | PA719664 | rapporteur | ||
| 16060000087203 | L16/dossiers | 16 | 16060000087192 | 16060000087199 | 4 | 0 | PA795374 | rapporteur | ||
| 16060000087204 | L16/dossiers | 16 | 16060000087192 | 16060000087199 | 5 | 0 | PO419610 | |||
| 16060000087206 | L16/dossiers | 16 | 16060000087192 | 16060000087205 | 1 | 0 | PA720222 | rapporteur | ||
| 16060000087207 | L16/dossiers | 16 | 16060000087192 | 16060000087205 | 2 | 0 | PA720342 | rapporteur | ||
| 16060000087208 | L16/dossiers | 16 | 16060000087192 | 16060000087205 | 3 | 0 | PA719664 | rapporteur | ||
| 16060000087209 | L16/dossiers | 16 | 16060000087192 | 16060000087205 | 4 | 0 | PA795374 | rapporteur | ||
| 16060000087210 | L16/dossiers | 16 | 16060000087192 | 16060000087205 | 5 | 0 | PO419610 | |||
| 16060000087227 | L16/dossiers | 16 | 16060000087225 | 16060000087226 | 1 | 0 | PA719814 | rapporteur | ||
| 16060000087228 | L16/dossiers | 16 | 16060000087225 | 16060000087226 | 2 | 0 | PA267324 | rapporteur | ||
| 16060000087229 | L16/dossiers | 16 | 16060000087225 | 16060000087226 | 3 | 0 | PO419604 | |||
| 16060000087235 | L16/dossiers | 16 | 16060000087233 | 16060000087234 | 1 | 0 | PA605694 | rapporteur | ||
| 16060000087236 | L16/dossiers | 16 | 16060000087233 | 16060000087234 | 2 | 0 | PA719154 | rapporteur | ||
| 16060000087237 | L16/dossiers | 16 | 16060000087233 | 16060000087234 | 3 | 0 | PA793876 | rapporteur |