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 |
|---|---|---|---|---|---|---|---|---|
| 16060000064507 | L16/dossiers | 16 | 16060000064506 | 16060000064506 | 1 | PO78718 | ||
| 16060000064509 | L16/dossiers | 16 | 16060000064508 | 16060000064508 | 1 | PO78718 | ||
| 16060000064511 | L16/dossiers | 16 | 16060000064510 | 16060000064510 | 1 | PO78718 | ||
| 16060000064513 | L16/dossiers | 16 | 16060000064512 | 16060000064512 | 1 | PO78718 | ||
| 16060000064515 | L16/dossiers | 16 | 16060000064514 | 16060000064514 | 1 | PO78718 | ||
| 16060000064517 | L16/dossiers | 16 | 16060000064516 | 16060000064516 | 1 | PO78718 | ||
| 16060000064519 | L16/dossiers | 16 | 16060000064518 | 16060000064518 | 1 | PO78718 | ||
| 16060000064521 | L16/dossiers | 16 | 16060000064520 | 16060000064520 | 1 | PO78718 | ||
| 16060000064523 | L16/dossiers | 16 | 16060000064522 | 16060000064522 | 1 | PO78718 | ||
| 16060000064525 | L16/dossiers | 16 | 16060000064524 | 16060000064524 | 1 | PO78718 | ||
| 16060000064527 | L16/dossiers | 16 | 16060000064526 | 16060000064526 | 1 | PO78718 | ||
| 16060000064529 | L16/dossiers | 16 | 16060000064528 | 16060000064528 | 1 | PO78718 | ||
| 16060000064531 | L16/dossiers | 16 | 16060000064530 | 16060000064530 | 1 | PO78718 | ||
| 16060000064533 | L16/dossiers | 16 | 16060000064532 | 16060000064532 | 1 | PO78718 | ||
| 16060000064535 | L16/dossiers | 16 | 16060000064534 | 16060000064534 | 1 | PO78718 | ||
| 16060000064537 | L16/dossiers | 16 | 16060000064536 | 16060000064536 | 1 | PO78718 | ||
| 16060000064539 | L16/dossiers | 16 | 16060000064538 | 16060000064538 | 1 | PO78718 | ||
| 16060000064541 | L16/dossiers | 16 | 16060000064540 | 16060000064540 | 1 | PO78718 | ||
| 16060000064543 | L16/dossiers | 16 | 16060000064542 | 16060000064542 | 1 | PO78718 | ||
| 16060000064545 | L16/dossiers | 16 | 16060000064544 | 16060000064544 | 1 | PO78718 | ||
| 16060000064547 | L16/dossiers | 16 | 16060000064546 | 16060000064546 | 1 | PO78718 | ||
| 16060000064549 | L16/dossiers | 16 | 16060000064548 | 16060000064548 | 1 | PO78718 | ||
| 16060000064551 | L16/dossiers | 16 | 16060000064550 | 16060000064550 | 1 | PO78718 | ||
| 16060000064553 | L16/dossiers | 16 | 16060000064552 | 16060000064552 | 1 | PO78718 | ||
| 16060000064555 | L16/dossiers | 16 | 16060000064554 | 16060000064554 | 1 | PO78718 | ||
| 16060000064557 | L16/dossiers | 16 | 16060000064556 | 16060000064556 | 1 | PO78718 | ||
| 16060000064559 | L16/dossiers | 16 | 16060000064558 | 16060000064558 | 1 | PO78718 | ||
| 16060000064561 | L16/dossiers | 16 | 16060000064560 | 16060000064560 | 1 | PO78718 | ||
| 16060000064563 | L16/dossiers | 16 | 16060000064562 | 16060000064562 | 1 | PO78718 | ||
| 16060000064565 | L16/dossiers | 16 | 16060000064564 | 16060000064564 | 1 | PO78718 | ||
| 16060000064567 | L16/dossiers | 16 | 16060000064566 | 16060000064566 | 1 | PO78718 | ||
| 16060000064569 | L16/dossiers | 16 | 16060000064568 | 16060000064568 | 1 | PO78718 | ||
| 16060000064571 | L16/dossiers | 16 | 16060000064570 | 16060000064570 | 1 | PO78718 | ||
| 16060000064573 | L16/dossiers | 16 | 16060000064572 | 16060000064572 | 1 | PO78718 | ||
| 16060000064575 | L16/dossiers | 16 | 16060000064574 | 16060000064574 | 1 | PO78718 | ||
| 16060000064577 | L16/dossiers | 16 | 16060000064576 | 16060000064576 | 1 | PO78718 | ||
| 16060000064579 | L16/dossiers | 16 | 16060000064578 | 16060000064578 | 1 | PO78718 | ||
| 16060000064581 | L16/dossiers | 16 | 16060000064580 | 16060000064580 | 1 | PO78718 | ||
| 16060000064583 | L16/dossiers | 16 | 16060000064582 | 16060000064582 | 1 | PO78718 | ||
| 16060000064585 | L16/dossiers | 16 | 16060000064584 | 16060000064584 | 1 | PO78718 | ||
| 16060000064587 | L16/dossiers | 16 | 16060000064586 | 16060000064586 | 1 | PO78718 | ||
| 16060000064589 | L16/dossiers | 16 | 16060000064588 | 16060000064588 | 1 | PA703494 | rapporteur | |
| 16060000064590 | L16/dossiers | 16 | 16060000064588 | 16060000064588 | 2 | PO211495 | ||
| 16060000064592 | L16/dossiers | 16 | 16060000064591 | 16060000064591 | 1 | PA703520 | rapporteur | |
| 16060000064593 | L16/dossiers | 16 | 16060000064591 | 16060000064591 | 2 | PO516753 | ||
| 16060000064595 | L16/dossiers | 16 | 16060000064594 | 16060000064594 | 1 | PA775292 | rapporteur | |
| 16060000064596 | L16/dossiers | 16 | 16060000064594 | 16060000064594 | 2 | PO516754 | ||
| 16060000064598 | L16/dossiers | 16 | 16060000064597 | 16060000064597 | 1 | PA1127 | rapporteur | |
| 16060000064599 | L16/dossiers | 16 | 16060000064597 | 16060000064597 | 2 | PO516754 | ||
| 16060000064601 | L16/dossiers | 16 | 16060000064600 | 16060000064600 | 1 | PA703515 | rapporteur |