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 |
|---|---|---|---|---|---|---|---|---|
| 16060000004466 | L16/dossiers | 16 | 16060000004465 | 16060000004465 | 1 | PO791932 | ||
| 16060000004469 | L16/dossiers | 16 | 16060000004468 | 16060000004468 | 1 | PO791932 | ||
| 16060000004472 | L16/dossiers | 16 | 16060000004471 | 16060000004471 | 1 | PO791932 | ||
| 16060000004475 | L16/dossiers | 16 | 16060000004474 | 16060000004474 | 1 | PO791932 | ||
| 16060000004478 | L16/dossiers | 16 | 16060000004477 | 16060000004477 | 1 | PO791932 | ||
| 16060000004481 | L16/dossiers | 16 | 16060000004480 | 16060000004480 | 1 | PO791932 | ||
| 16060000004484 | L16/dossiers | 16 | 16060000004483 | 16060000004483 | 1 | PO791932 | ||
| 16060000004487 | L16/dossiers | 16 | 16060000004486 | 16060000004486 | 1 | PO791932 | ||
| 16060000004490 | L16/dossiers | 16 | 16060000004489 | 16060000004489 | 1 | PO791932 | ||
| 16060000004493 | L16/dossiers | 16 | 16060000004492 | 16060000004492 | 1 | PO791932 | ||
| 16060000004496 | L16/dossiers | 16 | 16060000004495 | 16060000004495 | 1 | PO791932 | ||
| 16060000004499 | L16/dossiers | 16 | 16060000004498 | 16060000004498 | 1 | PO791932 | ||
| 16060000004502 | L16/dossiers | 16 | 16060000004501 | 16060000004501 | 1 | PO791932 | ||
| 16060000004505 | L16/dossiers | 16 | 16060000004504 | 16060000004504 | 1 | PO791932 | ||
| 16060000004508 | L16/dossiers | 16 | 16060000004507 | 16060000004507 | 1 | PO791932 | ||
| 16060000004511 | L16/dossiers | 16 | 16060000004510 | 16060000004510 | 1 | PO791932 | ||
| 16060000004514 | L16/dossiers | 16 | 16060000004513 | 16060000004513 | 1 | PO791932 | ||
| 16060000004517 | L16/dossiers | 16 | 16060000004516 | 16060000004516 | 1 | PO791932 | ||
| 16060000004520 | L16/dossiers | 16 | 16060000004519 | 16060000004519 | 1 | PO791932 | ||
| 16060000004523 | L16/dossiers | 16 | 16060000004522 | 16060000004522 | 1 | PO791932 | ||
| 16060000004526 | L16/dossiers | 16 | 16060000004525 | 16060000004525 | 1 | PO791932 | ||
| 16060000004529 | L16/dossiers | 16 | 16060000004528 | 16060000004528 | 1 | PO791932 | ||
| 16060000004532 | L16/dossiers | 16 | 16060000004531 | 16060000004531 | 1 | PO791932 | ||
| 16060000004535 | L16/dossiers | 16 | 16060000004534 | 16060000004534 | 1 | PO791932 | ||
| 16060000004538 | L16/dossiers | 16 | 16060000004537 | 16060000004537 | 1 | PO791932 | ||
| 16060000004541 | L16/dossiers | 16 | 16060000004540 | 16060000004540 | 1 | PO791932 | ||
| 16060000004544 | L16/dossiers | 16 | 16060000004543 | 16060000004543 | 1 | PO791932 | ||
| 16060000004547 | L16/dossiers | 16 | 16060000004546 | 16060000004546 | 1 | PO791932 | ||
| 16060000004550 | L16/dossiers | 16 | 16060000004549 | 16060000004549 | 1 | PO791932 | ||
| 16060000004553 | L16/dossiers | 16 | 16060000004552 | 16060000004552 | 1 | PO791932 | ||
| 16060000004556 | L16/dossiers | 16 | 16060000004555 | 16060000004555 | 1 | PO791932 | ||
| 16060000004559 | L16/dossiers | 16 | 16060000004558 | 16060000004558 | 1 | PO791932 | ||
| 16060000004562 | L16/dossiers | 16 | 16060000004561 | 16060000004561 | 1 | PO791932 | ||
| 16060000004565 | L16/dossiers | 16 | 16060000004564 | 16060000004564 | 1 | PO791932 | ||
| 16060000004568 | L16/dossiers | 16 | 16060000004567 | 16060000004567 | 1 | PO791932 | ||
| 16060000004571 | L16/dossiers | 16 | 16060000004570 | 16060000004570 | 1 | PO791932 | ||
| 16060000004574 | L16/dossiers | 16 | 16060000004573 | 16060000004573 | 1 | PO791932 | ||
| 16060000004577 | L16/dossiers | 16 | 16060000004576 | 16060000004576 | 1 | PO791932 | ||
| 16060000004580 | L16/dossiers | 16 | 16060000004579 | 16060000004579 | 1 | PO791932 | ||
| 16060000004583 | L16/dossiers | 16 | 16060000004582 | 16060000004582 | 1 | PO791932 | ||
| 16060000004586 | L16/dossiers | 16 | 16060000004585 | 16060000004585 | 1 | PO791932 | ||
| 16060000004589 | L16/dossiers | 16 | 16060000004588 | 16060000004588 | 1 | PO791932 | ||
| 16060000004592 | L16/dossiers | 16 | 16060000004591 | 16060000004591 | 1 | PO791932 | ||
| 16060000004595 | L16/dossiers | 16 | 16060000004594 | 16060000004594 | 1 | PO791932 | ||
| 16060000004598 | L16/dossiers | 16 | 16060000004597 | 16060000004597 | 1 | PO791932 | ||
| 16060000004601 | L16/dossiers | 16 | 16060000004600 | 16060000004600 | 1 | PO791932 | ||
| 16060000004604 | L16/dossiers | 16 | 16060000004603 | 16060000004603 | 1 | PO791932 | ||
| 16060000004607 | L16/dossiers | 16 | 16060000004606 | 16060000004606 | 1 | PO791932 | ||
| 16060000004610 | L16/dossiers | 16 | 16060000004609 | 16060000004609 | 1 | PO791932 | ||
| 16060000004613 | L16/dossiers | 16 | 16060000004612 | 16060000004612 | 1 | PO791932 |