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 |
|---|---|---|---|---|---|---|---|---|
| 14060000015367 | L14/dossiers | 14 | 14060000015366 | 14060000015366 | 1 | PO78718 | ||
| 14060000015369 | L14/dossiers | 14 | 14060000015368 | 14060000015368 | 1 | PA605606 | rapporteur | |
| 14060000015370 | L14/dossiers | 14 | 14060000015368 | 14060000015368 | 2 | PO419610 | ||
| 14060000015374 | L14/dossiers | 14 | 14060000015373 | 14060000015373 | 1 | PA1886 | auteur | |
| 14060000015410 | L14/dossiers | 14 | 14060000015409 | 14060000015409 | 1 | PO644420 | ||
| 14060000015413 | L14/dossiers | 14 | 14060000015412 | 14060000015412 | 1 | PO78718 | ||
| 14060000015415 | L14/dossiers | 14 | 14060000015414 | 14060000015414 | 1 | PA605606 | rapporteur | |
| 14060000015416 | L14/dossiers | 14 | 14060000015414 | 14060000015414 | 2 | PO419610 | ||
| 14060000015419 | L14/dossiers | 14 | 14060000015418 | 14060000015418 | 1 | PA267622 | auteur | |
| 14060000015423 | L14/dossiers | 14 | 14060000015422 | 14060000015422 | 1 | PA267622 | auteur | |
| 14060000015425 | L14/dossiers | 14 | 14060000015424 | 14060000015424 | 1 | PA267785 | rapporteur | |
| 14060000015426 | L14/dossiers | 14 | 14060000015424 | 14060000015424 | 2 | PO59051 | ||
| 14060000015428 | L14/dossiers | 14 | 14060000015427 | 14060000015427 | 1 | PA267785 | auteur | |
| 14060000015434 | L14/dossiers | 14 | 14060000015433 | 14060000015433 | 1 | PA336971 | rapporteur | |
| 14060000015435 | L14/dossiers | 14 | 14060000015433 | 14060000015433 | 2 | PO677887 | ||
| 14060000015437 | L14/dossiers | 14 | 14060000015436 | 14060000015436 | 1 | PO644420 | ||
| 14060000015440 | L14/dossiers | 14 | 14060000015439 | 14060000015439 | 1 | PO78718 | ||
| 14060000015442 | L14/dossiers | 14 | 14060000015441 | 14060000015441 | 1 | PO78718 | ||
| 14060000015444 | L14/dossiers | 14 | 14060000015443 | 14060000015443 | 1 | PA335017 | rapporteur | |
| 14060000015445 | L14/dossiers | 14 | 14060000015443 | 14060000015443 | 2 | PO420120 | ||
| 14060000015450 | L14/dossiers | 14 | 14060000015449 | 14060000015449 | 1 | PA335017 | rapporteur | |
| 14060000015451 | L14/dossiers | 14 | 14060000015449 | 14060000015449 | 2 | PO420120 | ||
| 14060000015454 | L14/dossiers | 14 | 14060000015453 | 14060000015453 | 1 | PO644420 | ||
| 14060000015457 | L14/dossiers | 14 | 14060000015456 | 14060000015456 | 1 | PA415448 | rapporteur pour avis | |
| 14060000015458 | L14/dossiers | 14 | 14060000015456 | 14060000015456 | 2 | PO211494 | ||
| 14060000015460 | L14/dossiers | 14 | 14060000015459 | 14060000015459 | 1 | PA267622 | auteur | |
| 14060000015466 | L14/dossiers | 14 | 14060000015465 | 14060000015465 | 1 | PA332305 | rapporteur pour avis | |
| 14060000015467 | L14/dossiers | 14 | 14060000015465 | 14060000015465 | 2 | PO419604 | ||
| 14060000015469 | L14/dossiers | 14 | 14060000015468 | 14060000015468 | 1 | PA610594 | rapporteur pour avis | |
| 14060000015470 | L14/dossiers | 14 | 14060000015468 | 14060000015468 | 2 | PO59048 | ||
| 14060000015472 | L14/dossiers | 14 | 14060000015471 | 14060000015471 | 1 | PA1183 | rapporteur pour avis | |
| 14060000015473 | L14/dossiers | 14 | 14060000015471 | 14060000015471 | 2 | PO211490 | ||
| 14060000015475 | L14/dossiers | 14 | 14060000015474 | 14060000015474 | 1 | PA267622 | auteur | |
| 14060000015477 | L14/dossiers | 14 | 14060000015476 | 14060000015476 | 1 | PA304086 | rapporteur | |
| 14060000015478 | L14/dossiers | 14 | 14060000015476 | 14060000015476 | 2 | PO211493 | ||
| 14060000015480 | L14/dossiers | 14 | 14060000015479 | 14060000015479 | 1 | PA304086 | rapporteur | |
| 14060000015481 | L14/dossiers | 14 | 14060000015479 | 14060000015479 | 2 | PO708730 | ||
| 14060000015486 | L14/dossiers | 14 | 14060000015482 | 14060000015482 | 1 | PA335017 | rapporteur | |
| 14060000015487 | L14/dossiers | 14 | 14060000015482 | 14060000015482 | 2 | PO420120 | ||
| 14060000015489 | L14/dossiers | 14 | 14060000015488 | 14060000015488 | 1 | PA335017 | rapporteur | |
| 14060000015490 | L14/dossiers | 14 | 14060000015488 | 14060000015488 | 2 | PO708730 | ||
| 14060000015492 | L14/dossiers | 14 | 14060000015491 | 14060000015491 | 1 | PA335017 | rapporteur | |
| 14060000015493 | L14/dossiers | 14 | 14060000015491 | 14060000015491 | 2 | PO420120 | ||
| 14060000015498 | L14/dossiers | 14 | 14060000015494 | 14060000015494 | 1 | PA335017 | rapporteur | |
| 14060000015499 | L14/dossiers | 14 | 14060000015494 | 14060000015494 | 2 | PO420120 | ||
| 14060000015501 | L14/dossiers | 14 | 14060000015500 | 14060000015500 | 1 | PA304086 | rapporteur | |
| 14060000015502 | L14/dossiers | 14 | 14060000015500 | 14060000015500 | 2 | PO211493 | ||
| 14060000015504 | L14/dossiers | 14 | 14060000015503 | 14060000015503 | 1 | PA267622 | auteur | |
| 14060000015506 | L14/dossiers | 14 | 14060000015505 | 14060000015505 | 1 | PA1379 | rapporteur | |
| 14060000015507 | L14/dossiers | 14 | 14060000015505 | 14060000015505 | 2 | PA343493 | rapporteur |