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 |
|---|---|---|---|---|---|---|---|---|
| 17060000107016 | L17/dossiers | 17 | 17060000107012 | 17060000107012 | 1 | PA795636 | rapporteur | |
| 17060000107017 | L17/dossiers | 17 | 17060000107012 | 17060000107012 | 2 | PO420120 | ||
| 17060000107022 | L17/dossiers | 17 | 17060000107018 | 17060000107018 | 1 | PA793980 | rapporteur | |
| 17060000107023 | L17/dossiers | 17 | 17060000107018 | 17060000107018 | 2 | PO419610 | ||
| 17060000107025 | L17/dossiers | 17 | 17060000107024 | 17060000107024 | 1 | PA721486 | rapporteur | |
| 17060000107026 | L17/dossiers | 17 | 17060000107024 | 17060000107024 | 2 | PO420120 | ||
| 17060000107031 | L17/dossiers | 17 | 17060000107027 | 17060000107027 | 1 | PA841701 | rapporteur | |
| 17060000107032 | L17/dossiers | 17 | 17060000107027 | 17060000107027 | 2 | PO59051 | ||
| 17060000107037 | L17/dossiers | 17 | 17060000107033 | 17060000107033 | 1 | PA736201 | rapporteur | |
| 17060000107038 | L17/dossiers | 17 | 17060000107033 | 17060000107033 | 2 | PO420120 | ||
| 17060000107040 | L17/dossiers | 17 | 17060000107039 | 17060000107039 | 1 | PA841931 | rapporteur | |
| 17060000107041 | L17/dossiers | 17 | 17060000107039 | 17060000107039 | 2 | PO415287 | ||
| 17060000107043 | L17/dossiers | 17 | 17060000107042 | 17060000107042 | 1 | PA795176 | rapporteur | |
| 17060000107044 | L17/dossiers | 17 | 17060000107042 | 17060000107042 | 2 | PO415287 | ||
| 17060000107049 | L17/dossiers | 17 | 17060000107045 | 17060000107045 | 1 | PA719558 | rapporteur | |
| 17060000107050 | L17/dossiers | 17 | 17060000107045 | 17060000107045 | 2 | PO419604 | ||
| 17060000107052 | L17/dossiers | 17 | 17060000107051 | 17060000107051 | 1 | PA795374 | rapporteur | |
| 17060000107053 | L17/dossiers | 17 | 17060000107051 | 17060000107051 | 2 | PA720342 | rapporteur | |
| 17060000107054 | L17/dossiers | 17 | 17060000107051 | 17060000107051 | 3 | PO864789 | ||
| 17060000107059 | L17/dossiers | 17 | 17060000107055 | 17060000107055 | 1 | PA267318 | rapporteur | |
| 17060000107060 | L17/dossiers | 17 | 17060000107055 | 17060000107055 | 2 | PO420120 | ||
| 17060000107062 | L17/dossiers | 17 | 17060000107061 | 17060000107061 | 1 | PA793520 | rapporteur | |
| 17060000107063 | L17/dossiers | 17 | 17060000107061 | 17060000107061 | 2 | PO419865 | ||
| 17060000107068 | L17/dossiers | 17 | 17060000107064 | 17060000107064 | 1 | PA795374 | rapporteur | |
| 17060000107069 | L17/dossiers | 17 | 17060000107064 | 17060000107064 | 2 | PO419610 | ||
| 17060000107074 | L17/dossiers | 17 | 17060000107070 | 17060000107070 | 1 | PA805166 | rapporteur | |
| 17060000107075 | L17/dossiers | 17 | 17060000107070 | 17060000107070 | 2 | PO420120 | ||
| 17060000107080 | L17/dossiers | 17 | 17060000107076 | 17060000107076 | 1 | PA721984 | rapporteur | |
| 17060000107081 | L17/dossiers | 17 | 17060000107076 | 17060000107076 | 2 | PO59051 | ||
| 17060000107086 | L17/dossiers | 17 | 17060000107082 | 17060000107082 | 1 | PA841931 | rapporteur | |
| 17060000107087 | L17/dossiers | 17 | 17060000107082 | 17060000107082 | 2 | PO59047 | ||
| 17060000107089 | L17/dossiers | 17 | 17060000107088 | 17060000107088 | 1 | PA720162 | rapporteur | |
| 17060000107090 | L17/dossiers | 17 | 17060000107088 | 17060000107088 | 2 | PO415287 | ||
| 17060000107095 | L17/dossiers | 17 | 17060000107091 | 17060000107091 | 1 | PA794830 | rapporteur | |
| 17060000107096 | L17/dossiers | 17 | 17060000107091 | 17060000107091 | 2 | PO419610 | ||
| 17060000107101 | L17/dossiers | 17 | 17060000107097 | 17060000107097 | 1 | PA794810 | rapporteur | |
| 17060000107102 | L17/dossiers | 17 | 17060000107097 | 17060000107097 | 2 | PO59051 | ||
| 17060000107104 | L17/dossiers | 17 | 17060000107103 | 17060000107103 | 1 | PA795528 | rapporteur | |
| 17060000107105 | L17/dossiers | 17 | 17060000107103 | 17060000107103 | 2 | PO419610 | ||
| 17060000107107 | L17/dossiers | 17 | 17060000107106 | 17060000107106 | 1 | PA793708 | rapporteur | |
| 17060000107108 | L17/dossiers | 17 | 17060000107106 | 17060000107106 | 2 | PO59051 | ||
| 17060000107110 | L17/dossiers | 17 | 17060000107109 | 17060000107109 | 1 | PA794466 | rapporteur | |
| 17060000107111 | L17/dossiers | 17 | 17060000107109 | 17060000107109 | 2 | PO59051 | ||
| 17060000107116 | L17/dossiers | 17 | 17060000107112 | 17060000107112 | 1 | PA2952 | rapporteur | |
| 17060000107117 | L17/dossiers | 17 | 17060000107112 | 17060000107112 | 2 | PO59051 | ||
| 17060000107122 | L17/dossiers | 17 | 17060000107118 | 17060000107118 | 1 | PA345722 | rapporteur | |
| 17060000107123 | L17/dossiers | 17 | 17060000107118 | 17060000107118 | 2 | PO59047 | ||
| 17060000107125 | L17/dossiers | 17 | 17060000107124 | 17060000107124 | 1 | PA720162 | rapporteur | |
| 17060000107126 | L17/dossiers | 17 | 17060000107124 | 17060000107124 | 2 | PO419865 | ||
| 17060000107131 | L17/dossiers | 17 | 17060000107127 | 17060000107127 | 1 | PA720728 | rapporteur |