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 |
|---|---|---|---|---|---|---|---|---|
| 15060000115639 | L15/dossiers | 15 | 15060000115638 | 15060000115638 | 1 | PO717460 | ||
| 15060000115642 | L15/dossiers | 15 | 15060000115641 | 15060000115641 | 1 | PO717460 | ||
| 15060000115645 | L15/dossiers | 15 | 15060000115644 | 15060000115644 | 1 | PO717460 | ||
| 15060000115648 | L15/dossiers | 15 | 15060000115647 | 15060000115647 | 1 | PO717460 | ||
| 15060000115651 | L15/dossiers | 15 | 15060000115650 | 15060000115650 | 1 | PO717460 | ||
| 15060000115661 | L15/dossiers | 15 | 15060000115660 | 15060000115660 | 1 | PO717460 | ||
| 15060000115663 | L15/dossiers | 15 | 15060000115662 | 15060000115662 | 1 | PO717460 | ||
| 15060000115666 | L15/dossiers | 15 | 15060000115665 | 15060000115665 | 1 | PO717460 | ||
| 15060000115668 | L15/dossiers | 15 | 15060000115667 | 15060000115667 | 1 | PO717460 | ||
| 15060000115671 | L15/dossiers | 15 | 15060000115670 | 15060000115670 | 1 | PO717460 | ||
| 15060000115674 | L15/dossiers | 15 | 15060000115673 | 15060000115673 | 1 | PO717460 | ||
| 15060000115677 | L15/dossiers | 15 | 15060000115676 | 15060000115676 | 1 | PO717460 | ||
| 15060000115680 | L15/dossiers | 15 | 15060000115679 | 15060000115679 | 1 | PO717460 | ||
| 15060000115683 | L15/dossiers | 15 | 15060000115682 | 15060000115682 | 1 | PO717460 | ||
| 15060000115686 | L15/dossiers | 15 | 15060000115685 | 15060000115685 | 1 | PO717460 | ||
| 15060000115690 | L15/dossiers | 15 | 15060000115689 | 15060000115689 | 1 | PO717460 | ||
| 15060000115692 | L15/dossiers | 15 | 15060000115691 | 15060000115691 | 1 | PO717460 | ||
| 15060000115694 | L15/dossiers | 15 | 15060000115693 | 15060000115693 | 1 | PO717460 | ||
| 15060000115697 | L15/dossiers | 15 | 15060000115696 | 15060000115696 | 1 | PO717460 | ||
| 15060000115700 | L15/dossiers | 15 | 15060000115699 | 15060000115699 | 1 | PO717460 | ||
| 15060000115703 | L15/dossiers | 15 | 15060000115702 | 15060000115702 | 1 | PO717460 | ||
| 15060000115705 | L15/dossiers | 15 | 15060000115704 | 15060000115704 | 1 | PO717460 | ||
| 15060000115708 | L15/dossiers | 15 | 15060000115707 | 15060000115707 | 1 | PO717460 | ||
| 15060000115711 | L15/dossiers | 15 | 15060000115710 | 15060000115710 | 1 | PO717460 | ||
| 15060000115714 | L15/dossiers | 15 | 15060000115713 | 15060000115713 | 1 | PO717460 | ||
| 15060000115717 | L15/dossiers | 15 | 15060000115716 | 15060000115716 | 1 | PO717460 | ||
| 15060000115720 | L15/dossiers | 15 | 15060000115719 | 15060000115719 | 1 | PO717460 | ||
| 15060000115723 | L15/dossiers | 15 | 15060000115722 | 15060000115722 | 1 | PO717460 | ||
| 15060000115726 | L15/dossiers | 15 | 15060000115725 | 15060000115725 | 1 | PO717460 | ||
| 15060000115729 | L15/dossiers | 15 | 15060000115728 | 15060000115728 | 1 | PO717460 | ||
| 15060000115732 | L15/dossiers | 15 | 15060000115731 | 15060000115731 | 1 | PO717460 | ||
| 15060000115735 | L15/dossiers | 15 | 15060000115734 | 15060000115734 | 1 | PO717460 | ||
| 15060000115737 | L15/dossiers | 15 | 15060000115736 | 15060000115736 | 1 | PO717460 | ||
| 15060000115739 | L15/dossiers | 15 | 15060000115738 | 15060000115738 | 1 | PO717460 | ||
| 15060000115742 | L15/dossiers | 15 | 15060000115741 | 15060000115741 | 1 | PO717460 | ||
| 15060000115744 | L15/dossiers | 15 | 15060000115743 | 15060000115743 | 1 | PO717460 | ||
| 15060000115747 | L15/dossiers | 15 | 15060000115746 | 15060000115746 | 1 | PO717460 | ||
| 15060000115750 | L15/dossiers | 15 | 15060000115749 | 15060000115749 | 1 | PO717460 | ||
| 15060000115753 | L15/dossiers | 15 | 15060000115752 | 15060000115752 | 1 | PO717460 | ||
| 15060000115756 | L15/dossiers | 15 | 15060000115755 | 15060000115755 | 1 | PO717460 | ||
| 15060000115759 | L15/dossiers | 15 | 15060000115758 | 15060000115758 | 1 | PO717460 | ||
| 15060000115761 | L15/dossiers | 15 | 15060000115760 | 15060000115760 | 1 | PO717460 | ||
| 15060000115765 | L15/dossiers | 15 | 15060000115764 | 15060000115764 | 1 | PO717460 | ||
| 15060000115768 | L15/dossiers | 15 | 15060000115767 | 15060000115767 | 1 | PO717460 | ||
| 15060000115771 | L15/dossiers | 15 | 15060000115770 | 15060000115770 | 1 | PO717460 | ||
| 15060000115774 | L15/dossiers | 15 | 15060000115773 | 15060000115773 | 1 | PO717460 | ||
| 15060000115777 | L15/dossiers | 15 | 15060000115776 | 15060000115776 | 1 | PO717460 | ||
| 15060000115780 | L15/dossiers | 15 | 15060000115779 | 15060000115779 | 1 | PO717460 | ||
| 15060000115783 | L15/dossiers | 15 | 15060000115782 | 15060000115782 | 1 | PO717460 | ||
| 15060000115787 | L15/dossiers | 15 | 15060000115786 | 15060000115786 | 1 | PO717460 |