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 |
|---|---|---|---|---|---|---|---|---|
| 16060000084398 | L16/dossiers | 16 | 16060000084397 | 16060000084397 | 1 | PO78718 | ||
| 16060000084400 | L16/dossiers | 16 | 16060000084399 | 16060000084399 | 1 | PA722190 | auteur | |
| 16060000084403 | L16/dossiers | 16 | 16060000084402 | 16060000084402 | 1 | PO78718 | ||
| 16060000084405 | L16/dossiers | 16 | 16060000084404 | 16060000084404 | 1 | PO78718 | ||
| 16060000084407 | L16/dossiers | 16 | 16060000084406 | 16060000084406 | 1 | PO78718 | ||
| 16060000084409 | L16/dossiers | 16 | 16060000084408 | 16060000084408 | 1 | PO78718 | ||
| 16060000084411 | L16/dossiers | 16 | 16060000084410 | 16060000084410 | 1 | PO78718 | ||
| 16060000084413 | L16/dossiers | 16 | 16060000084412 | 16060000084412 | 1 | PO78718 | ||
| 16060000084415 | L16/dossiers | 16 | 16060000084414 | 16060000084414 | 1 | PO78718 | ||
| 16060000084417 | L16/dossiers | 16 | 16060000084416 | 16060000084416 | 1 | PO78718 | ||
| 16060000084419 | L16/dossiers | 16 | 16060000084418 | 16060000084418 | 1 | PO78718 | ||
| 16060000084421 | L16/dossiers | 16 | 16060000084420 | 16060000084420 | 1 | PO78718 | ||
| 16060000084423 | L16/dossiers | 16 | 16060000084422 | 16060000084422 | 1 | PO78718 | ||
| 16060000084425 | L16/dossiers | 16 | 16060000084424 | 16060000084424 | 1 | PO78718 | ||
| 16060000084427 | L16/dossiers | 16 | 16060000084426 | 16060000084426 | 1 | PO78718 | ||
| 16060000084429 | L16/dossiers | 16 | 16060000084428 | 16060000084428 | 1 | PO78718 | ||
| 16060000084431 | L16/dossiers | 16 | 16060000084430 | 16060000084430 | 1 | PO78718 | ||
| 16060000084433 | L16/dossiers | 16 | 16060000084432 | 16060000084432 | 1 | PO78718 | ||
| 16060000084435 | L16/dossiers | 16 | 16060000084434 | 16060000084434 | 1 | PO78718 | ||
| 16060000084437 | L16/dossiers | 16 | 16060000084436 | 16060000084436 | 1 | PO78718 | ||
| 16060000084439 | L16/dossiers | 16 | 16060000084438 | 16060000084438 | 1 | PO78718 | ||
| 16060000084441 | L16/dossiers | 16 | 16060000084440 | 16060000084440 | 1 | PO78718 | ||
| 16060000084443 | L16/dossiers | 16 | 16060000084442 | 16060000084442 | 1 | PO78718 | ||
| 16060000084445 | L16/dossiers | 16 | 16060000084444 | 16060000084444 | 1 | PO78718 | ||
| 16060000084447 | L16/dossiers | 16 | 16060000084446 | 16060000084446 | 1 | PO78718 | ||
| 16060000084449 | L16/dossiers | 16 | 16060000084448 | 16060000084448 | 1 | PO78718 | ||
| 16060000084451 | L16/dossiers | 16 | 16060000084450 | 16060000084450 | 1 | PO78718 | ||
| 16060000084453 | L16/dossiers | 16 | 16060000084452 | 16060000084452 | 1 | PO78718 | ||
| 16060000084455 | L16/dossiers | 16 | 16060000084454 | 16060000084454 | 1 | PO78718 | ||
| 16060000084457 | L16/dossiers | 16 | 16060000084456 | 16060000084456 | 1 | PO78718 | ||
| 16060000084459 | L16/dossiers | 16 | 16060000084458 | 16060000084458 | 1 | PO78718 | ||
| 16060000084461 | L16/dossiers | 16 | 16060000084460 | 16060000084460 | 1 | PO78718 | ||
| 16060000084463 | L16/dossiers | 16 | 16060000084462 | 16060000084462 | 1 | PO78718 | ||
| 16060000084465 | L16/dossiers | 16 | 16060000084464 | 16060000084464 | 1 | PO78718 | ||
| 16060000084467 | L16/dossiers | 16 | 16060000084466 | 16060000084466 | 1 | PO78718 | ||
| 16060000084469 | L16/dossiers | 16 | 16060000084468 | 16060000084468 | 1 | PO78718 | ||
| 16060000084471 | L16/dossiers | 16 | 16060000084470 | 16060000084470 | 1 | PO78718 | ||
| 16060000084473 | L16/dossiers | 16 | 16060000084472 | 16060000084472 | 1 | PO78718 | ||
| 16060000084475 | L16/dossiers | 16 | 16060000084474 | 16060000084474 | 1 | PO78718 | ||
| 16060000084477 | L16/dossiers | 16 | 16060000084476 | 16060000084476 | 1 | PO78718 | ||
| 16060000084479 | L16/dossiers | 16 | 16060000084478 | 16060000084478 | 1 | PO78718 | ||
| 16060000084481 | L16/dossiers | 16 | 16060000084480 | 16060000084480 | 1 | PO78718 | ||
| 16060000084483 | L16/dossiers | 16 | 16060000084482 | 16060000084482 | 1 | PO78718 | ||
| 16060000084485 | L16/dossiers | 16 | 16060000084484 | 16060000084484 | 1 | PO78718 | ||
| 16060000084487 | L16/dossiers | 16 | 16060000084486 | 16060000084486 | 1 | PO78718 | ||
| 16060000084489 | L16/dossiers | 16 | 16060000084488 | 16060000084488 | 1 | PO78718 | ||
| 16060000084491 | L16/dossiers | 16 | 16060000084490 | 16060000084490 | 1 | PO78718 | ||
| 16060000084493 | L16/dossiers | 16 | 16060000084492 | 16060000084492 | 1 | PO78718 | ||
| 16060000084495 | L16/dossiers | 16 | 16060000084494 | 16060000084494 | 1 | PO78718 | ||
| 16060000084497 | L16/dossiers | 16 | 16060000084496 | 16060000084496 | 1 | PO78718 |