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 |
|---|---|---|---|---|---|---|---|---|
| 16060000056120 | L16/dossiers | 16 | 16060000056118 | 16060000056118 | 2 | PO59048 | ||
| 16060000056123 | L16/dossiers | 16 | 16060000056122 | 16060000056122 | 1 | PA721584 | rapporteur | |
| 16060000056124 | L16/dossiers | 16 | 16060000056122 | 16060000056122 | 2 | PO59051 | ||
| 16060000056127 | L16/dossiers | 16 | 16060000056126 | 16060000056126 | 1 | PA2952 | rapporteur | |
| 16060000056128 | L16/dossiers | 16 | 16060000056126 | 16060000056126 | 2 | PO836589 | ||
| 16060000056130 | L16/dossiers | 16 | 16060000056129 | 16060000056129 | 1 | PA720560 | rapporteur | |
| 16060000056131 | L16/dossiers | 16 | 16060000056129 | 16060000056129 | 2 | PO836267 | ||
| 16060000056133 | L16/dossiers | 16 | 16060000056132 | 16060000056132 | 1 | PA719814 | rapporteur | |
| 16060000056134 | L16/dossiers | 16 | 16060000056132 | 16060000056132 | 2 | PA267324 | rapporteur | |
| 16060000056135 | L16/dossiers | 16 | 16060000056132 | 16060000056132 | 3 | PO419604 | ||
| 16060000056138 | L16/dossiers | 16 | 16060000056137 | 16060000056137 | 1 | PA795508 | rapporteur | |
| 16060000056139 | L16/dossiers | 16 | 16060000056137 | 16060000056137 | 2 | PO837899 | ||
| 16060000056141 | L16/dossiers | 16 | 16060000056140 | 16060000056140 | 1 | PA795192 | rapporteur | |
| 16060000056142 | L16/dossiers | 16 | 16060000056140 | 16060000056140 | 2 | PO419604 | ||
| 16060000056145 | L16/dossiers | 16 | 16060000056144 | 16060000056144 | 1 | PA720692 | rapporteur | |
| 16060000056146 | L16/dossiers | 16 | 16060000056144 | 16060000056144 | 2 | PO420120 | ||
| 16060000056149 | L16/dossiers | 16 | 16060000056148 | 16060000056148 | 1 | PA796106 | rapporteur | |
| 16060000056150 | L16/dossiers | 16 | 16060000056148 | 16060000056148 | 2 | PO420120 | ||
| 16060000056153 | L16/dossiers | 16 | 16060000056152 | 16060000056152 | 1 | PA415448 | rapporteur | |
| 16060000056154 | L16/dossiers | 16 | 16060000056152 | 16060000056152 | 2 | PA721150 | rapporteur | |
| 16060000056155 | L16/dossiers | 16 | 16060000056152 | 16060000056152 | 3 | PO837930 | ||
| 16060000056157 | L16/dossiers | 16 | 16060000056156 | 16060000056156 | 1 | PA720370 | rapporteur | |
| 16060000056158 | L16/dossiers | 16 | 16060000056156 | 16060000056156 | 2 | PO59051 | ||
| 16060000056161 | L16/dossiers | 16 | 16060000056160 | 16060000056160 | 1 | PA722150 | rapporteur | |
| 16060000056162 | L16/dossiers | 16 | 16060000056160 | 16060000056160 | 2 | PO838264 | ||
| 16060000056164 | L16/dossiers | 16 | 16060000056163 | 16060000056163 | 1 | PA793210 | rapporteur | |
| 16060000056165 | L16/dossiers | 16 | 16060000056163 | 16060000056163 | 2 | PO59048 | ||
| 16060000056168 | L16/dossiers | 16 | 16060000056167 | 16060000056167 | 1 | PA721046 | rapporteur | |
| 16060000056169 | L16/dossiers | 16 | 16060000056167 | 16060000056167 | 2 | PO59051 | ||
| 16060000056172 | L16/dossiers | 16 | 16060000056171 | 16060000056171 | 1 | PA822617 | rapporteur | |
| 16060000056173 | L16/dossiers | 16 | 16060000056171 | 16060000056171 | 2 | PO420120 | ||
| 16060000056176 | L16/dossiers | 16 | 16060000056175 | 16060000056175 | 1 | PA720696 | rapporteur | |
| 16060000056177 | L16/dossiers | 16 | 16060000056175 | 16060000056175 | 2 | PO420120 | ||
| 16060000056180 | L16/dossiers | 16 | 16060000056179 | 16060000056179 | 1 | PA719286 | rapporteur | |
| 16060000056181 | L16/dossiers | 16 | 16060000056179 | 16060000056179 | 2 | PO420120 | ||
| 16060000056184 | L16/dossiers | 16 | 16060000056183 | 16060000056183 | 1 | PO791932 | ||
| 16060000056186 | L16/dossiers | 16 | 16060000056185 | 16060000056185 | 1 | PO791932 | ||
| 16060000056189 | L16/dossiers | 16 | 16060000056188 | 16060000056188 | 1 | PO791932 | ||
| 16060000056192 | L16/dossiers | 16 | 16060000056191 | 16060000056191 | 1 | PO791932 | ||
| 16060000056195 | L16/dossiers | 16 | 16060000056194 | 16060000056194 | 1 | PO791932 | ||
| 16060000056198 | L16/dossiers | 16 | 16060000056197 | 16060000056197 | 1 | PO791932 | ||
| 16060000056201 | L16/dossiers | 16 | 16060000056200 | 16060000056200 | 1 | PO791932 | ||
| 16060000056204 | L16/dossiers | 16 | 16060000056203 | 16060000056203 | 1 | PO791932 | ||
| 16060000056207 | L16/dossiers | 16 | 16060000056206 | 16060000056206 | 1 | PO791932 | ||
| 16060000056210 | L16/dossiers | 16 | 16060000056209 | 16060000056209 | 1 | PO791932 | ||
| 16060000056213 | L16/dossiers | 16 | 16060000056212 | 16060000056212 | 1 | PO791932 | ||
| 16060000056216 | L16/dossiers | 16 | 16060000056215 | 16060000056215 | 1 | PO791932 | ||
| 16060000056219 | L16/dossiers | 16 | 16060000056218 | 16060000056218 | 1 | PO791932 | ||
| 16060000056222 | L16/dossiers | 16 | 16060000056221 | 16060000056221 | 1 | PO791932 | ||
| 16060000056225 | L16/dossiers | 16 | 16060000056224 | 16060000056224 | 1 | PO791932 |