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 |
|---|---|---|---|---|---|---|---|---|
| 16060000087463 | L16/dossiers | 16 | 16060000087461 | 16060000087461 | 2 | PO211495 | ||
| 16060000087465 | L16/dossiers | 16 | 16060000087464 | 16060000087464 | 1 | PA2552 | rapporteur | |
| 16060000087466 | L16/dossiers | 16 | 16060000087464 | 16060000087464 | 2 | PO211495 | ||
| 16060000087468 | L16/dossiers | 16 | 16060000087467 | 16060000087467 | 1 | PA429891 | rapporteur | |
| 16060000087469 | L16/dossiers | 16 | 16060000087467 | 16060000087467 | 2 | PO211495 | ||
| 16060000087471 | L16/dossiers | 16 | 16060000087470 | 16060000087470 | 1 | PA304071 | rapporteur | |
| 16060000087472 | L16/dossiers | 16 | 16060000087470 | 16060000087470 | 2 | PO211495 | ||
| 16060000087474 | L16/dossiers | 16 | 16060000087473 | 16060000087473 | 1 | PA415474 | rapporteur | |
| 16060000087475 | L16/dossiers | 16 | 16060000087473 | 16060000087473 | 2 | PO516754 | ||
| 16060000087477 | L16/dossiers | 16 | 16060000087476 | 16060000087476 | 1 | PA227087 | rapporteur | |
| 16060000087478 | L16/dossiers | 16 | 16060000087476 | 16060000087476 | 2 | PO211495 | ||
| 16060000087480 | L16/dossiers | 16 | 16060000087479 | 16060000087479 | 1 | PA1447 | rapporteur | |
| 16060000087481 | L16/dossiers | 16 | 16060000087479 | 16060000087479 | 2 | PO211495 | ||
| 16060000087483 | L16/dossiers | 16 | 16060000087482 | 16060000087482 | 1 | PA415465 | rapporteur | |
| 16060000087484 | L16/dossiers | 16 | 16060000087482 | 16060000087482 | 2 | PO211495 | ||
| 16060000087486 | L16/dossiers | 16 | 16060000087485 | 16060000087485 | 1 | PA945 | rapporteur | |
| 16060000087487 | L16/dossiers | 16 | 16060000087485 | 16060000087485 | 2 | PO211495 | ||
| 16060000087489 | L16/dossiers | 16 | 16060000087488 | 16060000087488 | 1 | PA2183 | rapporteur | |
| 16060000087490 | L16/dossiers | 16 | 16060000087488 | 16060000087488 | 2 | PO211495 | ||
| 16060000087492 | L16/dossiers | 16 | 16060000087491 | 16060000087491 | 1 | PA1122 | rapporteur | |
| 16060000087493 | L16/dossiers | 16 | 16060000087491 | 16060000087491 | 2 | PO211495 | ||
| 16060000087495 | L16/dossiers | 16 | 16060000087494 | 16060000087494 | 1 | PA267891 | rapporteur | |
| 16060000087496 | L16/dossiers | 16 | 16060000087494 | 16060000087494 | 2 | PO211495 | ||
| 16060000087498 | L16/dossiers | 16 | 16060000087497 | 16060000087497 | 1 | PA415460 | rapporteur | |
| 16060000087499 | L16/dossiers | 16 | 16060000087497 | 16060000087497 | 2 | PO211495 | ||
| 16060000087501 | L16/dossiers | 16 | 16060000087500 | 16060000087500 | 1 | PA1122 | rapporteur | |
| 16060000087502 | L16/dossiers | 16 | 16060000087500 | 16060000087500 | 2 | PO211495 | ||
| 16060000087504 | L16/dossiers | 16 | 16060000087503 | 16060000087503 | 1 | PA267512 | rapporteur | |
| 16060000087505 | L16/dossiers | 16 | 16060000087503 | 16060000087503 | 2 | PO211495 | ||
| 16060000087507 | L16/dossiers | 16 | 16060000087506 | 16060000087506 | 1 | PA1122 | rapporteur | |
| 16060000087508 | L16/dossiers | 16 | 16060000087506 | 16060000087506 | 2 | PO211495 | ||
| 16060000087510 | L16/dossiers | 16 | 16060000087509 | 16060000087509 | 1 | PA703530 | rapporteur | |
| 16060000087511 | L16/dossiers | 16 | 16060000087509 | 16060000087509 | 2 | PO516753 | ||
| 16060000087513 | L16/dossiers | 16 | 16060000087512 | 16060000087512 | 1 | PA2905 | rapporteur | |
| 16060000087514 | L16/dossiers | 16 | 16060000087512 | 16060000087512 | 2 | PO211495 | ||
| 16060000087516 | L16/dossiers | 16 | 16060000087515 | 16060000087515 | 1 | PA267891 | rapporteur | |
| 16060000087517 | L16/dossiers | 16 | 16060000087515 | 16060000087515 | 2 | PO211495 | ||
| 16060000087519 | L16/dossiers | 16 | 16060000087518 | 16060000087518 | 1 | PA2161 | rapporteur | |
| 16060000087520 | L16/dossiers | 16 | 16060000087518 | 16060000087518 | 2 | PO211495 | ||
| 16060000087522 | L16/dossiers | 16 | 16060000087521 | 16060000087521 | 1 | PA429866 | rapporteur | |
| 16060000087523 | L16/dossiers | 16 | 16060000087521 | 16060000087521 | 2 | PO516753 | ||
| 16060000087525 | L16/dossiers | 16 | 16060000087524 | 16060000087524 | 1 | PA1562 | rapporteur | |
| 16060000087526 | L16/dossiers | 16 | 16060000087524 | 16060000087524 | 2 | PO211495 | ||
| 16060000087528 | L16/dossiers | 16 | 16060000087527 | 16060000087527 | 1 | PA703530 | rapporteur | |
| 16060000087529 | L16/dossiers | 16 | 16060000087527 | 16060000087527 | 2 | PO516753 | ||
| 16060000087531 | L16/dossiers | 16 | 16060000087530 | 16060000087530 | 1 | PA703494 | rapporteur | |
| 16060000087532 | L16/dossiers | 16 | 16060000087530 | 16060000087530 | 2 | PO211495 | ||
| 16060000087534 | L16/dossiers | 16 | 16060000087533 | 16060000087533 | 1 | PA429838 | rapporteur | |
| 16060000087535 | L16/dossiers | 16 | 16060000087533 | 16060000087533 | 2 | PO211495 | ||
| 16060000087537 | L16/dossiers | 16 | 16060000087536 | 16060000087536 | 1 | PA406065 | rapporteur |