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 |
|---|---|---|---|---|---|---|---|---|
| 17060000006560 | L17/dossiers | 17 | 17060000006559 | 17060000006559 | 1 | PO838901 | ||
| 17060000006563 | L17/dossiers | 17 | 17060000006562 | 17060000006562 | 1 | PO838901 | ||
| 17060000006566 | L17/dossiers | 17 | 17060000006565 | 17060000006565 | 1 | PO838901 | ||
| 17060000006569 | L17/dossiers | 17 | 17060000006568 | 17060000006568 | 1 | PO838901 | ||
| 17060000006572 | L17/dossiers | 17 | 17060000006571 | 17060000006571 | 1 | PO838901 | ||
| 17060000006575 | L17/dossiers | 17 | 17060000006574 | 17060000006574 | 1 | PO838901 | ||
| 17060000006578 | L17/dossiers | 17 | 17060000006577 | 17060000006577 | 1 | PO838901 | ||
| 17060000006581 | L17/dossiers | 17 | 17060000006580 | 17060000006580 | 1 | PO838901 | ||
| 17060000006584 | L17/dossiers | 17 | 17060000006583 | 17060000006583 | 1 | PO838901 | ||
| 17060000006587 | L17/dossiers | 17 | 17060000006586 | 17060000006586 | 1 | PO838901 | ||
| 17060000006590 | L17/dossiers | 17 | 17060000006589 | 17060000006589 | 1 | PO838901 | ||
| 17060000006593 | L17/dossiers | 17 | 17060000006592 | 17060000006592 | 1 | PO838901 | ||
| 17060000006596 | L17/dossiers | 17 | 17060000006595 | 17060000006595 | 1 | PO838901 | ||
| 17060000006599 | L17/dossiers | 17 | 17060000006598 | 17060000006598 | 1 | PO838901 | ||
| 17060000006602 | L17/dossiers | 17 | 17060000006601 | 17060000006601 | 1 | PO838901 | ||
| 17060000006605 | L17/dossiers | 17 | 17060000006604 | 17060000006604 | 1 | PO838901 | ||
| 17060000006608 | L17/dossiers | 17 | 17060000006607 | 17060000006607 | 1 | PO838901 | ||
| 17060000006611 | L17/dossiers | 17 | 17060000006610 | 17060000006610 | 1 | PO838901 | ||
| 17060000006614 | L17/dossiers | 17 | 17060000006613 | 17060000006613 | 1 | PO838901 | ||
| 17060000006617 | L17/dossiers | 17 | 17060000006616 | 17060000006616 | 1 | PO838901 | ||
| 17060000006620 | L17/dossiers | 17 | 17060000006619 | 17060000006619 | 1 | PO838901 | ||
| 17060000006623 | L17/dossiers | 17 | 17060000006622 | 17060000006622 | 1 | PO838901 | ||
| 17060000006626 | L17/dossiers | 17 | 17060000006625 | 17060000006625 | 1 | PO838901 | ||
| 17060000006629 | L17/dossiers | 17 | 17060000006628 | 17060000006628 | 1 | PO838901 | ||
| 17060000006632 | L17/dossiers | 17 | 17060000006631 | 17060000006631 | 1 | PO838901 | ||
| 17060000006635 | L17/dossiers | 17 | 17060000006634 | 17060000006634 | 1 | PO838901 | ||
| 17060000006638 | L17/dossiers | 17 | 17060000006637 | 17060000006637 | 1 | PO838901 | ||
| 17060000006641 | L17/dossiers | 17 | 17060000006640 | 17060000006640 | 1 | PO838901 | ||
| 17060000006644 | L17/dossiers | 17 | 17060000006643 | 17060000006643 | 1 | PO838901 | ||
| 17060000006647 | L17/dossiers | 17 | 17060000006646 | 17060000006646 | 1 | PO838901 | ||
| 17060000006650 | L17/dossiers | 17 | 17060000006649 | 17060000006649 | 1 | PO838901 | ||
| 17060000006653 | L17/dossiers | 17 | 17060000006652 | 17060000006652 | 1 | PO838901 | ||
| 17060000006656 | L17/dossiers | 17 | 17060000006655 | 17060000006655 | 1 | PO838901 | ||
| 17060000006659 | L17/dossiers | 17 | 17060000006658 | 17060000006658 | 1 | PO838901 | ||
| 17060000006662 | L17/dossiers | 17 | 17060000006661 | 17060000006661 | 1 | PO838901 | ||
| 17060000006665 | L17/dossiers | 17 | 17060000006664 | 17060000006664 | 1 | PO838901 | ||
| 17060000006668 | L17/dossiers | 17 | 17060000006667 | 17060000006667 | 1 | PO838901 | ||
| 17060000006671 | L17/dossiers | 17 | 17060000006670 | 17060000006670 | 1 | PO838901 | ||
| 17060000006674 | L17/dossiers | 17 | 17060000006673 | 17060000006673 | 1 | PO838901 | ||
| 17060000006677 | L17/dossiers | 17 | 17060000006676 | 17060000006676 | 1 | PO838901 | ||
| 17060000006680 | L17/dossiers | 17 | 17060000006679 | 17060000006679 | 1 | PO838901 | ||
| 17060000006683 | L17/dossiers | 17 | 17060000006682 | 17060000006682 | 1 | PO838901 | ||
| 17060000006686 | L17/dossiers | 17 | 17060000006685 | 17060000006685 | 1 | PO838901 | ||
| 17060000006689 | L17/dossiers | 17 | 17060000006688 | 17060000006688 | 1 | PO838901 | ||
| 17060000006692 | L17/dossiers | 17 | 17060000006691 | 17060000006691 | 1 | PO838901 | ||
| 17060000006695 | L17/dossiers | 17 | 17060000006694 | 17060000006694 | 1 | PO838901 | ||
| 17060000006698 | L17/dossiers | 17 | 17060000006697 | 17060000006697 | 1 | PO838901 | ||
| 17060000006701 | L17/dossiers | 17 | 17060000006700 | 17060000006700 | 1 | PO838901 | ||
| 17060000006704 | L17/dossiers | 17 | 17060000006703 | 17060000006703 | 1 | PO838901 | ||
| 17060000006707 | L17/dossiers | 17 | 17060000006706 | 17060000006706 | 1 | PO838901 |