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 |
|---|---|---|---|---|---|---|---|---|
| 16060000055450 | L16/dossiers | 16 | 16060000055449 | 16060000055449 | 1 | PO791932 | ||
| 16060000055453 | L16/dossiers | 16 | 16060000055452 | 16060000055452 | 1 | PO791932 | ||
| 16060000055455 | L16/dossiers | 16 | 16060000055454 | 16060000055454 | 1 | PO791932 | ||
| 16060000055458 | L16/dossiers | 16 | 16060000055457 | 16060000055457 | 1 | PO791932 | ||
| 16060000055461 | L16/dossiers | 16 | 16060000055460 | 16060000055460 | 1 | PO791932 | ||
| 16060000055464 | L16/dossiers | 16 | 16060000055463 | 16060000055463 | 1 | PO791932 | ||
| 16060000055467 | L16/dossiers | 16 | 16060000055466 | 16060000055466 | 1 | PO791932 | ||
| 16060000055470 | L16/dossiers | 16 | 16060000055469 | 16060000055469 | 1 | PO791932 | ||
| 16060000055473 | L16/dossiers | 16 | 16060000055472 | 16060000055472 | 1 | PO791932 | ||
| 16060000055476 | L16/dossiers | 16 | 16060000055475 | 16060000055475 | 1 | PO791932 | ||
| 16060000055479 | L16/dossiers | 16 | 16060000055478 | 16060000055478 | 1 | PO791932 | ||
| 16060000055481 | L16/dossiers | 16 | 16060000055480 | 16060000055480 | 1 | PO791932 | ||
| 16060000055483 | L16/dossiers | 16 | 16060000055482 | 16060000055482 | 1 | PO791932 | ||
| 16060000055486 | L16/dossiers | 16 | 16060000055485 | 16060000055485 | 1 | PO791932 | ||
| 16060000055489 | L16/dossiers | 16 | 16060000055488 | 16060000055488 | 1 | PO791932 | ||
| 16060000055492 | L16/dossiers | 16 | 16060000055491 | 16060000055491 | 1 | PO791932 | ||
| 16060000055495 | L16/dossiers | 16 | 16060000055494 | 16060000055494 | 1 | PO791932 | ||
| 16060000055497 | L16/dossiers | 16 | 16060000055496 | 16060000055496 | 1 | PO791932 | ||
| 16060000055499 | L16/dossiers | 16 | 16060000055498 | 16060000055498 | 1 | PO791932 | ||
| 16060000055502 | L16/dossiers | 16 | 16060000055501 | 16060000055501 | 1 | PO791932 | ||
| 16060000055505 | L16/dossiers | 16 | 16060000055504 | 16060000055504 | 1 | PO791932 | ||
| 16060000055507 | L16/dossiers | 16 | 16060000055506 | 16060000055506 | 1 | PO791932 | ||
| 16060000055509 | L16/dossiers | 16 | 16060000055508 | 16060000055508 | 1 | PO791932 | ||
| 16060000055511 | L16/dossiers | 16 | 16060000055510 | 16060000055510 | 1 | PO791932 | ||
| 16060000055514 | L16/dossiers | 16 | 16060000055513 | 16060000055513 | 1 | PA795958 | rapporteur | |
| 16060000055515 | L16/dossiers | 16 | 16060000055513 | 16060000055513 | 2 | PO802288 | ||
| 16060000055517 | L16/dossiers | 16 | 16060000055516 | 16060000055516 | 1 | PA721530 | rapporteur | |
| 16060000055518 | L16/dossiers | 16 | 16060000055516 | 16060000055516 | 2 | PO59048 | ||
| 16060000055521 | L16/dossiers | 16 | 16060000055520 | 16060000055520 | 1 | PA722284 | rapporteur | |
| 16060000055522 | L16/dossiers | 16 | 16060000055520 | 16060000055520 | 2 | PO420120 | ||
| 16060000055525 | L16/dossiers | 16 | 16060000055524 | 16060000055524 | 1 | PA720092 | rapporteur | |
| 16060000055526 | L16/dossiers | 16 | 16060000055524 | 16060000055524 | 2 | PO419865 | ||
| 16060000055529 | L16/dossiers | 16 | 16060000055528 | 16060000055528 | 1 | PA720334 | rapporteur | |
| 16060000055530 | L16/dossiers | 16 | 16060000055528 | 16060000055528 | 2 | PO419865 | ||
| 16060000055533 | L16/dossiers | 16 | 16060000055532 | 16060000055532 | 1 | PA795068 | rapporteur | |
| 16060000055534 | L16/dossiers | 16 | 16060000055532 | 16060000055532 | 2 | PO59051 | ||
| 16060000055537 | L16/dossiers | 16 | 16060000055536 | 16060000055536 | 1 | PA722046 | rapporteur | |
| 16060000055538 | L16/dossiers | 16 | 16060000055536 | 16060000055536 | 2 | PO59051 | ||
| 16060000055541 | L16/dossiers | 16 | 16060000055540 | 16060000055540 | 1 | PA607395 | rapporteur | |
| 16060000055542 | L16/dossiers | 16 | 16060000055540 | 16060000055540 | 2 | PO420120 | ||
| 16060000055545 | L16/dossiers | 16 | 16060000055544 | 16060000055544 | 1 | PA795228 | rapporteur | |
| 16060000055546 | L16/dossiers | 16 | 16060000055544 | 16060000055544 | 2 | PO419604 | ||
| 16060000055549 | L16/dossiers | 16 | 16060000055548 | 16060000055548 | 1 | PA720892 | rapporteur | |
| 16060000055550 | L16/dossiers | 16 | 16060000055548 | 16060000055548 | 2 | PO59051 | ||
| 16060000055553 | L16/dossiers | 16 | 16060000055552 | 16060000055552 | 1 | PA719372 | rapporteur | |
| 16060000055554 | L16/dossiers | 16 | 16060000055552 | 16060000055552 | 2 | PO419610 | ||
| 16060000055557 | L16/dossiers | 16 | 16060000055556 | 16060000055556 | 1 | PA719186 | rapporteur | |
| 16060000055558 | L16/dossiers | 16 | 16060000055556 | 16060000055556 | 2 | PO420120 | ||
| 16060000055561 | L16/dossiers | 16 | 16060000055560 | 16060000055560 | 1 | PA720696 | rapporteur | |
| 16060000055562 | L16/dossiers | 16 | 16060000055560 | 16060000055560 | 2 | PA793382 | rapporteur |