dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000071414 | L17/dossiers | 17 | 17060000071412 | 17060000071412 | 2 | PO59051 | ||
| 17060000071417 | L17/dossiers | 17 | 17060000071416 | 17060000071416 | 1 | PA722366 | rapporteur | |
| 17060000071418 | L17/dossiers | 17 | 17060000071416 | 17060000071416 | 2 | PO419610 | ||
| 17060000071421 | L17/dossiers | 17 | 17060000071420 | 17060000071420 | 1 | PA333285 | rapporteur | |
| 17060000071422 | L17/dossiers | 17 | 17060000071420 | 17060000071420 | 2 | PO420120 | ||
| 17060000071425 | L17/dossiers | 17 | 17060000071424 | 17060000071424 | 1 | PA842211 | rapporteur | |
| 17060000071426 | L17/dossiers | 17 | 17060000071424 | 17060000071424 | 2 | PO419610 | ||
| 17060000071429 | L17/dossiers | 17 | 17060000071428 | 17060000071428 | 1 | PA841681 | rapporteur | |
| 17060000071430 | L17/dossiers | 17 | 17060000071428 | 17060000071428 | 2 | PO419604 | ||
| 17060000071433 | L17/dossiers | 17 | 17060000071432 | 17060000071432 | 1 | PA795430 | rapporteur | |
| 17060000071434 | L17/dossiers | 17 | 17060000071432 | 17060000071432 | 2 | PO419610 | ||
| 17060000071437 | L17/dossiers | 17 | 17060000071436 | 17060000071436 | 1 | PA795156 | rapporteur | |
| 17060000071438 | L17/dossiers | 17 | 17060000071436 | 17060000071436 | 2 | PO419604 | ||
| 17060000071441 | L17/dossiers | 17 | 17060000071440 | 17060000071440 | 1 | PA841853 | rapporteur | |
| 17060000071442 | L17/dossiers | 17 | 17060000071440 | 17060000071440 | 2 | PO420120 | ||
| 17060000071445 | L17/dossiers | 17 | 17060000071444 | 17060000071444 | 1 | PA643192 | rapporteur | |
| 17060000071446 | L17/dossiers | 17 | 17060000071444 | 17060000071444 | 2 | PO420120 | ||
| 17060000071449 | L17/dossiers | 17 | 17060000071448 | 17060000071448 | 1 | PA793624 | rapporteur | |
| 17060000071450 | L17/dossiers | 17 | 17060000071448 | 17060000071448 | 2 | PO419610 | ||
| 17060000071453 | L17/dossiers | 17 | 17060000071452 | 17060000071452 | 1 | PA720342 | rapporteur | |
| 17060000071454 | L17/dossiers | 17 | 17060000071452 | 17060000071452 | 2 | PO419610 | ||
| 17060000071457 | L17/dossiers | 17 | 17060000071456 | 17060000071456 | 1 | PA794278 | rapporteur | |
| 17060000071458 | L17/dossiers | 17 | 17060000071456 | 17060000071456 | 2 | PO59051 | ||
| 17060000071461 | L17/dossiers | 17 | 17060000071460 | 17060000071460 | 1 | PA793174 | rapporteur | |
| 17060000071462 | L17/dossiers | 17 | 17060000071460 | 17060000071460 | 2 | PO420120 | ||
| 17060000071465 | L17/dossiers | 17 | 17060000071464 | 17060000071464 | 1 | PA795990 | rapporteur | |
| 17060000071466 | L17/dossiers | 17 | 17060000071464 | 17060000071464 | 2 | PO59051 | ||
| 17060000071469 | L17/dossiers | 17 | 17060000071468 | 17060000071468 | 1 | PA794938 | rapporteur | |
| 17060000071470 | L17/dossiers | 17 | 17060000071468 | 17060000071468 | 2 | PO420120 | ||
| 17060000071473 | L17/dossiers | 17 | 17060000071472 | 17060000071472 | 1 | PA720022 | rapporteur | |
| 17060000071474 | L17/dossiers | 17 | 17060000071472 | 17060000071472 | 2 | PO852305 | ||
| 17060000071476 | L17/dossiers | 17 | 17060000071475 | 17060000071475 | 1 | PA794118 | rapporteur | |
| 17060000071477 | L17/dossiers | 17 | 17060000071475 | 17060000071475 | 2 | PO419610 | ||
| 17060000071480 | L17/dossiers | 17 | 17060000071479 | 17060000071479 | 1 | PA642847 | rapporteur | |
| 17060000071481 | L17/dossiers | 17 | 17060000071479 | 17060000071479 | 2 | PO420120 | ||
| 17060000071484 | L17/dossiers | 17 | 17060000071483 | 17060000071483 | 1 | PA840979 | rapporteur | |
| 17060000071485 | L17/dossiers | 17 | 17060000071483 | 17060000071483 | 2 | PO59048 | ||
| 17060000071488 | L17/dossiers | 17 | 17060000071487 | 17060000071487 | 1 | PA266797 | rapporteur | |
| 17060000071489 | L17/dossiers | 17 | 17060000071487 | 17060000071487 | 2 | PO59051 | ||
| 17060000071492 | L17/dossiers | 17 | 17060000071491 | 17060000071491 | 1 | PA842117 | rapporteur | |
| 17060000071493 | L17/dossiers | 17 | 17060000071491 | 17060000071491 | 2 | PO419610 | ||
| 17060000071496 | L17/dossiers | 17 | 17060000071495 | 17060000071495 | 1 | PA330008 | rapporteur | |
| 17060000071497 | L17/dossiers | 17 | 17060000071495 | 17060000071495 | 2 | PO59051 | ||
| 17060000071500 | L17/dossiers | 17 | 17060000071499 | 17060000071499 | 1 | PA721984 | rapporteur | |
| 17060000071501 | L17/dossiers | 17 | 17060000071499 | 17060000071499 | 2 | PO59051 | ||
| 17060000071504 | L17/dossiers | 17 | 17060000071503 | 17060000071503 | 1 | PA722390 | rapporteur | |
| 17060000071505 | L17/dossiers | 17 | 17060000071503 | 17060000071503 | 2 | PO420120 | ||
| 17060000071508 | L17/dossiers | 17 | 17060000071507 | 17060000071507 | 1 | PA841813 | rapporteur | |
| 17060000071509 | L17/dossiers | 17 | 17060000071507 | 17060000071507 | 2 | PO59051 | ||
| 17060000071512 | L17/dossiers | 17 | 17060000071511 | 17060000071511 | 1 | PA720342 | rapporteur |