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 |
|---|---|---|---|---|---|---|---|---|
| 16060000057112 | L16/dossiers | 16 | 16060000057111 | 16060000057111 | 1 | PA906 | auteur | |
| 16060000057148 | L16/dossiers | 16 | 16060000057147 | 16060000057147 | 1 | PO78718 | ||
| 16060000057150 | L16/dossiers | 16 | 16060000057149 | 16060000057149 | 1 | PO78718 | ||
| 16060000057152 | L16/dossiers | 16 | 16060000057151 | 16060000057151 | 1 | PO78718 | ||
| 16060000057154 | L16/dossiers | 16 | 16060000057153 | 16060000057153 | 1 | PO78718 | ||
| 16060000057156 | L16/dossiers | 16 | 16060000057155 | 16060000057155 | 1 | PO78718 | ||
| 16060000057158 | L16/dossiers | 16 | 16060000057157 | 16060000057157 | 1 | PO78718 | ||
| 16060000057160 | L16/dossiers | 16 | 16060000057159 | 16060000057159 | 1 | PO78718 | ||
| 16060000057162 | L16/dossiers | 16 | 16060000057161 | 16060000057161 | 1 | PO78718 | ||
| 16060000057164 | L16/dossiers | 16 | 16060000057163 | 16060000057163 | 1 | PO78718 | ||
| 16060000057166 | L16/dossiers | 16 | 16060000057165 | 16060000057165 | 1 | PA2552 | rapporteur | |
| 16060000057167 | L16/dossiers | 16 | 16060000057165 | 16060000057165 | 2 | PO211495 | ||
| 16060000057169 | L16/dossiers | 16 | 16060000057168 | 16060000057168 | 1 | PA429891 | rapporteur | |
| 16060000057170 | L16/dossiers | 16 | 16060000057168 | 16060000057168 | 2 | PO211495 | ||
| 16060000057172 | L16/dossiers | 16 | 16060000057171 | 16060000057171 | 1 | PA304071 | rapporteur | |
| 16060000057173 | L16/dossiers | 16 | 16060000057171 | 16060000057171 | 2 | PO211495 | ||
| 16060000057175 | L16/dossiers | 16 | 16060000057174 | 16060000057174 | 1 | PA415474 | rapporteur | |
| 16060000057176 | L16/dossiers | 16 | 16060000057174 | 16060000057174 | 2 | PO516754 | ||
| 16060000057178 | L16/dossiers | 16 | 16060000057177 | 16060000057177 | 1 | PA227087 | rapporteur | |
| 16060000057179 | L16/dossiers | 16 | 16060000057177 | 16060000057177 | 2 | PO211495 | ||
| 16060000057181 | L16/dossiers | 16 | 16060000057180 | 16060000057180 | 1 | PA1447 | rapporteur | |
| 16060000057182 | L16/dossiers | 16 | 16060000057180 | 16060000057180 | 2 | PO211495 | ||
| 16060000057184 | L16/dossiers | 16 | 16060000057183 | 16060000057183 | 1 | PA415465 | rapporteur | |
| 16060000057185 | L16/dossiers | 16 | 16060000057183 | 16060000057183 | 2 | PO211495 | ||
| 16060000057187 | L16/dossiers | 16 | 16060000057186 | 16060000057186 | 1 | PA945 | rapporteur | |
| 16060000057188 | L16/dossiers | 16 | 16060000057186 | 16060000057186 | 2 | PO211495 | ||
| 16060000057190 | L16/dossiers | 16 | 16060000057189 | 16060000057189 | 1 | PA2183 | rapporteur | |
| 16060000057191 | L16/dossiers | 16 | 16060000057189 | 16060000057189 | 2 | PO211495 | ||
| 16060000057193 | L16/dossiers | 16 | 16060000057192 | 16060000057192 | 1 | PA1828 | auteur | |
| 16060000057194 | L16/dossiers | 16 | 16060000057192 | 16060000057192 | 2 | PA429858 | auteur | |
| 16060000057196 | L16/dossiers | 16 | 16060000057195 | 16060000057195 | 1 | PA415483 | auteur | |
| 16060000057245 | L16/dossiers | 16 | 16060000057244 | 16060000057244 | 1 | PA304015 | auteur | |
| 16060000057249 | L16/dossiers | 16 | 16060000057248 | 16060000057248 | 1 | PA429870 | auteur | |
| 16060000057293 | L16/dossiers | 16 | 16060000057292 | 16060000057292 | 1 | PO78718 | ||
| 16060000057295 | L16/dossiers | 16 | 16060000057294 | 16060000057294 | 1 | PO78718 | ||
| 16060000057297 | L16/dossiers | 16 | 16060000057296 | 16060000057296 | 1 | PO78718 | ||
| 16060000057299 | L16/dossiers | 16 | 16060000057298 | 16060000057298 | 1 | PO78718 | ||
| 16060000057301 | L16/dossiers | 16 | 16060000057300 | 16060000057300 | 1 | PO78718 | ||
| 16060000057303 | L16/dossiers | 16 | 16060000057302 | 16060000057302 | 1 | PA1122 | rapporteur | |
| 16060000057304 | L16/dossiers | 16 | 16060000057302 | 16060000057302 | 2 | PO211495 | ||
| 16060000057306 | L16/dossiers | 16 | 16060000057305 | 16060000057305 | 1 | PA267891 | rapporteur | |
| 16060000057307 | L16/dossiers | 16 | 16060000057305 | 16060000057305 | 2 | PO211495 | ||
| 16060000057309 | L16/dossiers | 16 | 16060000057308 | 16060000057308 | 1 | PA415460 | rapporteur | |
| 16060000057310 | L16/dossiers | 16 | 16060000057308 | 16060000057308 | 2 | PO211495 | ||
| 16060000057312 | L16/dossiers | 16 | 16060000057311 | 16060000057311 | 1 | PA1122 | rapporteur | |
| 16060000057313 | L16/dossiers | 16 | 16060000057311 | 16060000057311 | 2 | PO211495 | ||
| 16060000057315 | L16/dossiers | 16 | 16060000057314 | 16060000057314 | 1 | PA267512 | rapporteur | |
| 16060000057316 | L16/dossiers | 16 | 16060000057314 | 16060000057314 | 2 | PO211495 | ||
| 16060000057318 | L16/dossiers | 16 | 16060000057317 | 16060000057317 | 1 | PA1122 | rapporteur | |
| 16060000057319 | L16/dossiers | 16 | 16060000057317 | 16060000057317 | 2 | PO211495 |