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 |
|---|---|---|---|---|---|---|---|---|
| 15060000076358 | L15/dossiers | 15 | 15060000076357 | 15060000076357 | 1 | PO717460 | ||
| 15060000076361 | L15/dossiers | 15 | 15060000076360 | 15060000076360 | 1 | PO717460 | ||
| 15060000076364 | L15/dossiers | 15 | 15060000076363 | 15060000076363 | 1 | PO717460 | ||
| 15060000076367 | L15/dossiers | 15 | 15060000076366 | 15060000076366 | 1 | PO717460 | ||
| 15060000076370 | L15/dossiers | 15 | 15060000076369 | 15060000076369 | 1 | PO717460 | ||
| 15060000076373 | L15/dossiers | 15 | 15060000076372 | 15060000076372 | 1 | PO717460 | ||
| 15060000076376 | L15/dossiers | 15 | 15060000076375 | 15060000076375 | 1 | PO717460 | ||
| 15060000076379 | L15/dossiers | 15 | 15060000076378 | 15060000076378 | 1 | PO717460 | ||
| 15060000076382 | L15/dossiers | 15 | 15060000076381 | 15060000076381 | 1 | PO717460 | ||
| 15060000076387 | L15/dossiers | 15 | 15060000076386 | 15060000076386 | 1 | PO717460 | ||
| 15060000076391 | L15/dossiers | 15 | 15060000076390 | 15060000076390 | 1 | PO717460 | ||
| 15060000076394 | L15/dossiers | 15 | 15060000076393 | 15060000076393 | 1 | PO717460 | ||
| 15060000076397 | L15/dossiers | 15 | 15060000076396 | 15060000076396 | 1 | PO717460 | ||
| 15060000076400 | L15/dossiers | 15 | 15060000076399 | 15060000076399 | 1 | PO717460 | ||
| 15060000076403 | L15/dossiers | 15 | 15060000076402 | 15060000076402 | 1 | PO717460 | ||
| 15060000076406 | L15/dossiers | 15 | 15060000076405 | 15060000076405 | 1 | PO717460 | ||
| 15060000076410 | L15/dossiers | 15 | 15060000076409 | 15060000076409 | 1 | PO717460 | ||
| 15060000076413 | L15/dossiers | 15 | 15060000076412 | 15060000076412 | 1 | PO717460 | ||
| 15060000076416 | L15/dossiers | 15 | 15060000076415 | 15060000076415 | 1 | PO717460 | ||
| 15060000076419 | L15/dossiers | 15 | 15060000076418 | 15060000076418 | 1 | PO717460 | ||
| 15060000076422 | L15/dossiers | 15 | 15060000076421 | 15060000076421 | 1 | PO717460 | ||
| 15060000076425 | L15/dossiers | 15 | 15060000076424 | 15060000076424 | 1 | PO717460 | ||
| 15060000076428 | L15/dossiers | 15 | 15060000076427 | 15060000076427 | 1 | PO717460 | ||
| 15060000076431 | L15/dossiers | 15 | 15060000076430 | 15060000076430 | 1 | PO717460 | ||
| 15060000076434 | L15/dossiers | 15 | 15060000076433 | 15060000076433 | 1 | PO717460 | ||
| 15060000076437 | L15/dossiers | 15 | 15060000076436 | 15060000076436 | 1 | PO717460 | ||
| 15060000076440 | L15/dossiers | 15 | 15060000076439 | 15060000076439 | 1 | PO717460 | ||
| 15060000076443 | L15/dossiers | 15 | 15060000076442 | 15060000076442 | 1 | PO717460 | ||
| 15060000076446 | L15/dossiers | 15 | 15060000076445 | 15060000076445 | 1 | PO717460 | ||
| 15060000076449 | L15/dossiers | 15 | 15060000076448 | 15060000076448 | 1 | PO717460 | ||
| 15060000076451 | L15/dossiers | 15 | 15060000076450 | 15060000076450 | 1 | PO717460 | ||
| 15060000076455 | L15/dossiers | 15 | 15060000076454 | 15060000076454 | 1 | PO717460 | ||
| 15060000076458 | L15/dossiers | 15 | 15060000076457 | 15060000076457 | 1 | PO717460 | ||
| 15060000076460 | L15/dossiers | 15 | 15060000076459 | 15060000076459 | 1 | PO717460 | ||
| 15060000076463 | L15/dossiers | 15 | 15060000076462 | 15060000076462 | 1 | PO717460 | ||
| 15060000076466 | L15/dossiers | 15 | 15060000076465 | 15060000076465 | 1 | PO717460 | ||
| 15060000076469 | L15/dossiers | 15 | 15060000076468 | 15060000076468 | 1 | PO717460 | ||
| 15060000076471 | L15/dossiers | 15 | 15060000076470 | 15060000076470 | 1 | PO717460 | ||
| 15060000076474 | L15/dossiers | 15 | 15060000076473 | 15060000076473 | 1 | PO717460 | ||
| 15060000076476 | L15/dossiers | 15 | 15060000076475 | 15060000076475 | 1 | PO717460 | ||
| 15060000076479 | L15/dossiers | 15 | 15060000076478 | 15060000076478 | 1 | PO717460 | ||
| 15060000076482 | L15/dossiers | 15 | 15060000076481 | 15060000076481 | 1 | PO717460 | ||
| 15060000076485 | L15/dossiers | 15 | 15060000076484 | 15060000076484 | 1 | PO717460 | ||
| 15060000076488 | L15/dossiers | 15 | 15060000076487 | 15060000076487 | 1 | PO717460 | ||
| 15060000076491 | L15/dossiers | 15 | 15060000076490 | 15060000076490 | 1 | PO717460 | ||
| 15060000076494 | L15/dossiers | 15 | 15060000076493 | 15060000076493 | 1 | PO717460 | ||
| 15060000076497 | L15/dossiers | 15 | 15060000076496 | 15060000076496 | 1 | PO717460 | ||
| 15060000076500 | L15/dossiers | 15 | 15060000076499 | 15060000076499 | 1 | PO717460 | ||
| 15060000076503 | L15/dossiers | 15 | 15060000076502 | 15060000076502 | 1 | PO717460 | ||
| 15060000076505 | L15/dossiers | 15 | 15060000076504 | 15060000076504 | 1 | PO717460 |