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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000087238 | L16/dossiers | 16 | 16060000087233 | 16060000087234 | 4 | 0 | PA719718 | rapporteur | ||
| 16060000087239 | L16/dossiers | 16 | 16060000087233 | 16060000087234 | 5 | 0 | PA720286 | rapporteur | ||
| 16060000087240 | L16/dossiers | 16 | 16060000087233 | 16060000087234 | 6 | 0 | PO836892 | |||
| 16060000087242 | L16/dossiers | 16 | 16060000087233 | 16060000087241 | 1 | 0 | PA605694 | rapporteur | ||
| 16060000087243 | L16/dossiers | 16 | 16060000087233 | 16060000087241 | 2 | 0 | PA719154 | rapporteur | ||
| 16060000087244 | L16/dossiers | 16 | 16060000087233 | 16060000087241 | 3 | 0 | PA793876 | rapporteur | ||
| 16060000087245 | L16/dossiers | 16 | 16060000087233 | 16060000087241 | 4 | 0 | PA719718 | rapporteur | ||
| 16060000087246 | L16/dossiers | 16 | 16060000087233 | 16060000087241 | 5 | 0 | PA720286 | rapporteur | ||
| 16060000087247 | L16/dossiers | 16 | 16060000087233 | 16060000087241 | 6 | 0 | PO836892 | |||
| 16060000087249 | L16/dossiers | 16 | 16060000087233 | 16060000087248 | 1 | 0 | PA605694 | rapporteur | ||
| 16060000087250 | L16/dossiers | 16 | 16060000087233 | 16060000087248 | 2 | 0 | PA719154 | rapporteur | ||
| 16060000087251 | L16/dossiers | 16 | 16060000087233 | 16060000087248 | 3 | 0 | PA793876 | rapporteur | ||
| 16060000087252 | L16/dossiers | 16 | 16060000087233 | 16060000087248 | 4 | 0 | PA719718 | rapporteur | ||
| 16060000087253 | L16/dossiers | 16 | 16060000087233 | 16060000087248 | 5 | 0 | PA720286 | rapporteur | ||
| 16060000087254 | L16/dossiers | 16 | 16060000087233 | 16060000087248 | 6 | 0 | PO836892 | |||
| 16060000087256 | L16/dossiers | 16 | 16060000087233 | 16060000087255 | 1 | 0 | PA605694 | rapporteur | ||
| 16060000087257 | L16/dossiers | 16 | 16060000087233 | 16060000087255 | 2 | 0 | PA719154 | rapporteur | ||
| 16060000087258 | L16/dossiers | 16 | 16060000087233 | 16060000087255 | 3 | 0 | PA793876 | rapporteur | ||
| 16060000087259 | L16/dossiers | 16 | 16060000087233 | 16060000087255 | 4 | 0 | PA719718 | rapporteur | ||
| 16060000087260 | L16/dossiers | 16 | 16060000087233 | 16060000087255 | 5 | 0 | PA720286 | rapporteur | ||
| 16060000087261 | L16/dossiers | 16 | 16060000087233 | 16060000087255 | 6 | 0 | PO836892 | |||
| 16060000087273 | L16/dossiers | 16 | 16060000087271 | 16060000087272 | 1 | 0 | PA774962 | rapporteur | ||
| 16060000087274 | L16/dossiers | 16 | 16060000087271 | 16060000087272 | 2 | 0 | PO419610 | |||
| 16060000087282 | L16/dossiers | 16 | 16060000087280 | 16060000087281 | 1 | 0 | PA795192 | rapporteur | ||
| 16060000087283 | L16/dossiers | 16 | 16060000087280 | 16060000087281 | 2 | 0 | PO419604 | |||
| 16060000087288 | L16/dossiers | 16 | 16060000087286 | 16060000087287 | 1 | 0 | PA720692 | rapporteur | ||
| 16060000087289 | L16/dossiers | 16 | 16060000087286 | 16060000087287 | 2 | 0 | PO420120 | |||
| 16060000087297 | L16/dossiers | 16 | 16060000087295 | 16060000087296 | 1 | 0 | PA796106 | rapporteur | ||
| 16060000087298 | L16/dossiers | 16 | 16060000087295 | 16060000087296 | 2 | 0 | PO420120 | |||
| 16060000087312 | L16/dossiers | 16 | 16060000087310 | 16060000087311 | 1 | 0 | PA721262 | rapporteur | ||
| 16060000087313 | L16/dossiers | 16 | 16060000087310 | 16060000087311 | 2 | 0 | PO832903 | |||
| 16060000087315 | L16/dossiers | 16 | 16060000087310 | 16060000087314 | 1 | 0 | PA721262 | rapporteur | ||
| 16060000087316 | L16/dossiers | 16 | 16060000087310 | 16060000087314 | 2 | 0 | PO832903 | |||
| 16060000087337 | L16/dossiers | 16 | 16060000087335 | 16060000087336 | 1 | 0 | PA719472 | rapporteur | ||
| 16060000087338 | L16/dossiers | 16 | 16060000087335 | 16060000087336 | 2 | 0 | PO59048 | |||
| 16060000087340 | L16/dossiers | 16 | 16060000087335 | 16060000087339 | 1 | 0 | PA719472 | rapporteur | ||
| 16060000087341 | L16/dossiers | 16 | 16060000087335 | 16060000087339 | 2 | 0 | PO59048 | |||
| 16060000087359 | L16/dossiers | 16 | 16060000087357 | 16060000087358 | 1 | 0 | PA793210 | rapporteur | ||
| 16060000087360 | L16/dossiers | 16 | 16060000087357 | 16060000087358 | 2 | 0 | PO59048 | |||
| 16060000087365 | L16/dossiers | 16 | 16060000087363 | 16060000087364 | 1 | 0 | PA721046 | rapporteur | ||
| 16060000087366 | L16/dossiers | 16 | 16060000087363 | 16060000087364 | 2 | 0 | PO59051 | |||
| 16060000087377 | L16/dossiers | 16 | 16060000087375 | 16060000087376 | 1 | 0 | PA267766 | rapporteur | ||
| 16060000087378 | L16/dossiers | 16 | 16060000087375 | 16060000087376 | 2 | 0 | PO59051 | |||
| 16060000087386 | L16/dossiers | 16 | 16060000087384 | 16060000087385 | 1 | 0 | PA822617 | rapporteur | ||
| 16060000087387 | L16/dossiers | 16 | 16060000087384 | 16060000087385 | 2 | 0 | PO420120 | |||
| 16060000087392 | L16/dossiers | 16 | 16060000087390 | 16060000087391 | 1 | 0 | PA720696 | rapporteur | ||
| 16060000087393 | L16/dossiers | 16 | 16060000087390 | 16060000087391 | 2 | 0 | PO420120 | |||
| 16060000087398 | L16/dossiers | 16 | 16060000087396 | 16060000087397 | 1 | 0 | PA719286 | rapporteur | ||
| 16060000087399 | L16/dossiers | 16 | 16060000087396 | 16060000087397 | 2 | 0 | PO420120 | |||
| 16060000089651 | L16/dossiers | 16 | 16060000089649 | 16060000089650 | 1 | 0 | PA794838 | rapporteur |