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 |
|---|---|---|---|---|---|---|---|---|
| 17060000104531 | L17/dossiers | 17 | 17060000104530 | 17060000104530 | 1 | PO838901 | ||
| 17060000104534 | L17/dossiers | 17 | 17060000104533 | 17060000104533 | 1 | PO838901 | ||
| 17060000104537 | L17/dossiers | 17 | 17060000104536 | 17060000104536 | 1 | PO838901 | ||
| 17060000104543 | L17/dossiers | 17 | 17060000104542 | 17060000104542 | 1 | PO838901 | ||
| 17060000104547 | L17/dossiers | 17 | 17060000104546 | 17060000104546 | 1 | PO838901 | ||
| 17060000104550 | L17/dossiers | 17 | 17060000104549 | 17060000104549 | 1 | PO838901 | ||
| 17060000104553 | L17/dossiers | 17 | 17060000104552 | 17060000104552 | 1 | PO838901 | ||
| 17060000104557 | L17/dossiers | 17 | 17060000104556 | 17060000104556 | 1 | PO838901 | ||
| 17060000104559 | L17/dossiers | 17 | 17060000104558 | 17060000104558 | 1 | PO838901 | ||
| 17060000104562 | L17/dossiers | 17 | 17060000104561 | 17060000104561 | 1 | PO838901 | ||
| 17060000104565 | L17/dossiers | 17 | 17060000104564 | 17060000104564 | 1 | PO838901 | ||
| 17060000104568 | L17/dossiers | 17 | 17060000104567 | 17060000104567 | 1 | PO838901 | ||
| 17060000104571 | L17/dossiers | 17 | 17060000104570 | 17060000104570 | 1 | PO838901 | ||
| 17060000104574 | L17/dossiers | 17 | 17060000104573 | 17060000104573 | 1 | PO838901 | ||
| 17060000104577 | L17/dossiers | 17 | 17060000104576 | 17060000104576 | 1 | PO838901 | ||
| 17060000104580 | L17/dossiers | 17 | 17060000104579 | 17060000104579 | 1 | PO838901 | ||
| 17060000104584 | L17/dossiers | 17 | 17060000104583 | 17060000104583 | 1 | PO838901 | ||
| 17060000104587 | L17/dossiers | 17 | 17060000104586 | 17060000104586 | 1 | PO838901 | ||
| 17060000104589 | L17/dossiers | 17 | 17060000104588 | 17060000104588 | 1 | PO838901 | ||
| 17060000104592 | L17/dossiers | 17 | 17060000104591 | 17060000104591 | 1 | PO838901 | ||
| 17060000104596 | L17/dossiers | 17 | 17060000104595 | 17060000104595 | 1 | PO838901 | ||
| 17060000104600 | L17/dossiers | 17 | 17060000104599 | 17060000104599 | 1 | PO838901 | ||
| 17060000104605 | L17/dossiers | 17 | 17060000104604 | 17060000104604 | 1 | PO838901 | ||
| 17060000104608 | L17/dossiers | 17 | 17060000104607 | 17060000104607 | 1 | PO838901 | ||
| 17060000104611 | L17/dossiers | 17 | 17060000104610 | 17060000104610 | 1 | PO838901 | ||
| 17060000104614 | L17/dossiers | 17 | 17060000104613 | 17060000104613 | 1 | PO838901 | ||
| 17060000104616 | L17/dossiers | 17 | 17060000104615 | 17060000104615 | 1 | PO838901 | ||
| 17060000104618 | L17/dossiers | 17 | 17060000104617 | 17060000104617 | 1 | PO838901 | ||
| 17060000104621 | L17/dossiers | 17 | 17060000104620 | 17060000104620 | 1 | PO838901 | ||
| 17060000104623 | L17/dossiers | 17 | 17060000104622 | 17060000104622 | 1 | PO838901 | ||
| 17060000104626 | L17/dossiers | 17 | 17060000104625 | 17060000104625 | 1 | PO838901 | ||
| 17060000104629 | L17/dossiers | 17 | 17060000104628 | 17060000104628 | 1 | PO838901 | ||
| 17060000104639 | L17/dossiers | 17 | 17060000104638 | 17060000104638 | 1 | PO838901 | ||
| 17060000104641 | L17/dossiers | 17 | 17060000104640 | 17060000104640 | 1 | PO838901 | ||
| 17060000104644 | L17/dossiers | 17 | 17060000104643 | 17060000104643 | 1 | PO838901 | ||
| 17060000104647 | L17/dossiers | 17 | 17060000104646 | 17060000104646 | 1 | PO838901 | ||
| 17060000104650 | L17/dossiers | 17 | 17060000104649 | 17060000104649 | 1 | PO838901 | ||
| 17060000104653 | L17/dossiers | 17 | 17060000104652 | 17060000104652 | 1 | PO838901 | ||
| 17060000104657 | L17/dossiers | 17 | 17060000104656 | 17060000104656 | 1 | PO838901 | ||
| 17060000104660 | L17/dossiers | 17 | 17060000104659 | 17060000104659 | 1 | PO838901 | ||
| 17060000104667 | L17/dossiers | 17 | 17060000104666 | 17060000104666 | 1 | PO838901 | ||
| 17060000104670 | L17/dossiers | 17 | 17060000104669 | 17060000104669 | 1 | PO838901 | ||
| 17060000104673 | L17/dossiers | 17 | 17060000104672 | 17060000104672 | 1 | PO838901 | ||
| 17060000104676 | L17/dossiers | 17 | 17060000104675 | 17060000104675 | 1 | PO838901 | ||
| 17060000104679 | L17/dossiers | 17 | 17060000104678 | 17060000104678 | 1 | PO838901 | ||
| 17060000104682 | L17/dossiers | 17 | 17060000104681 | 17060000104681 | 1 | PO838901 | ||
| 17060000104684 | L17/dossiers | 17 | 17060000104683 | 17060000104683 | 1 | PO838901 | ||
| 17060000104687 | L17/dossiers | 17 | 17060000104686 | 17060000104686 | 1 | PO838901 | ||
| 17060000104691 | L17/dossiers | 17 | 17060000104690 | 17060000104690 | 1 | PO838901 | ||
| 17060000104694 | L17/dossiers | 17 | 17060000104693 | 17060000104693 | 1 | PO838901 |