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 |
|---|---|---|---|---|---|---|---|---|
| 15060000076654 | L15/dossiers | 15 | 15060000076653 | 15060000076653 | 1 | PO717460 | ||
| 15060000076657 | L15/dossiers | 15 | 15060000076656 | 15060000076656 | 1 | PO717460 | ||
| 15060000076660 | L15/dossiers | 15 | 15060000076659 | 15060000076659 | 1 | PO717460 | ||
| 15060000076664 | L15/dossiers | 15 | 15060000076663 | 15060000076663 | 1 | PO717460 | ||
| 15060000076667 | L15/dossiers | 15 | 15060000076666 | 15060000076666 | 1 | PO717460 | ||
| 15060000076670 | L15/dossiers | 15 | 15060000076669 | 15060000076669 | 1 | PO717460 | ||
| 15060000076673 | L15/dossiers | 15 | 15060000076672 | 15060000076672 | 1 | PO717460 | ||
| 15060000076675 | L15/dossiers | 15 | 15060000076674 | 15060000076674 | 1 | PO717460 | ||
| 15060000076678 | L15/dossiers | 15 | 15060000076677 | 15060000076677 | 1 | PO717460 | ||
| 15060000076681 | L15/dossiers | 15 | 15060000076680 | 15060000076680 | 1 | PO717460 | ||
| 15060000076684 | L15/dossiers | 15 | 15060000076683 | 15060000076683 | 1 | PO717460 | ||
| 15060000076687 | L15/dossiers | 15 | 15060000076686 | 15060000076686 | 1 | PO717460 | ||
| 15060000076690 | L15/dossiers | 15 | 15060000076689 | 15060000076689 | 1 | PO717460 | ||
| 15060000076693 | L15/dossiers | 15 | 15060000076692 | 15060000076692 | 1 | PO717460 | ||
| 15060000076696 | L15/dossiers | 15 | 15060000076695 | 15060000076695 | 1 | PO717460 | ||
| 15060000076699 | L15/dossiers | 15 | 15060000076698 | 15060000076698 | 1 | PO717460 | ||
| 15060000076702 | L15/dossiers | 15 | 15060000076701 | 15060000076701 | 1 | PO717460 | ||
| 15060000076705 | L15/dossiers | 15 | 15060000076704 | 15060000076704 | 1 | PO717460 | ||
| 15060000076708 | L15/dossiers | 15 | 15060000076707 | 15060000076707 | 1 | PO717460 | ||
| 15060000076711 | L15/dossiers | 15 | 15060000076710 | 15060000076710 | 1 | PO717460 | ||
| 15060000076714 | L15/dossiers | 15 | 15060000076713 | 15060000076713 | 1 | PO717460 | ||
| 15060000076717 | L15/dossiers | 15 | 15060000076716 | 15060000076716 | 1 | PO717460 | ||
| 15060000076720 | L15/dossiers | 15 | 15060000076719 | 15060000076719 | 1 | PO717460 | ||
| 15060000076723 | L15/dossiers | 15 | 15060000076722 | 15060000076722 | 1 | PO717460 | ||
| 15060000076726 | L15/dossiers | 15 | 15060000076725 | 15060000076725 | 1 | PO717460 | ||
| 15060000076729 | L15/dossiers | 15 | 15060000076728 | 15060000076728 | 1 | PO717460 | ||
| 15060000076731 | L15/dossiers | 15 | 15060000076730 | 15060000076730 | 1 | PO717460 | ||
| 15060000076733 | L15/dossiers | 15 | 15060000076732 | 15060000076732 | 1 | PO717460 | ||
| 15060000076736 | L15/dossiers | 15 | 15060000076735 | 15060000076735 | 1 | PO717460 | ||
| 15060000076739 | L15/dossiers | 15 | 15060000076738 | 15060000076738 | 1 | PO717460 | ||
| 15060000076742 | L15/dossiers | 15 | 15060000076741 | 15060000076741 | 1 | PO717460 | ||
| 15060000076745 | L15/dossiers | 15 | 15060000076744 | 15060000076744 | 1 | PO717460 | ||
| 15060000076748 | L15/dossiers | 15 | 15060000076747 | 15060000076747 | 1 | PO717460 | ||
| 15060000076751 | L15/dossiers | 15 | 15060000076750 | 15060000076750 | 1 | PO717460 | ||
| 15060000076754 | L15/dossiers | 15 | 15060000076753 | 15060000076753 | 1 | PO717460 | ||
| 15060000076757 | L15/dossiers | 15 | 15060000076756 | 15060000076756 | 1 | PO717460 | ||
| 15060000076759 | L15/dossiers | 15 | 15060000076758 | 15060000076758 | 1 | PO717460 | ||
| 15060000076762 | L15/dossiers | 15 | 15060000076761 | 15060000076761 | 1 | PO717460 | ||
| 15060000076765 | L15/dossiers | 15 | 15060000076764 | 15060000076764 | 1 | PO717460 | ||
| 15060000076767 | L15/dossiers | 15 | 15060000076766 | 15060000076766 | 1 | PO717460 | ||
| 15060000076769 | L15/dossiers | 15 | 15060000076768 | 15060000076768 | 1 | PO717460 | ||
| 15060000076772 | L15/dossiers | 15 | 15060000076771 | 15060000076771 | 1 | PO717460 | ||
| 15060000076775 | L15/dossiers | 15 | 15060000076774 | 15060000076774 | 1 | PO717460 | ||
| 15060000076778 | L15/dossiers | 15 | 15060000076777 | 15060000076777 | 1 | PO717460 | ||
| 15060000076781 | L15/dossiers | 15 | 15060000076780 | 15060000076780 | 1 | PO717460 | ||
| 15060000076784 | L15/dossiers | 15 | 15060000076783 | 15060000076783 | 1 | PO717460 | ||
| 15060000076787 | L15/dossiers | 15 | 15060000076786 | 15060000076786 | 1 | PO717460 | ||
| 15060000076790 | L15/dossiers | 15 | 15060000076789 | 15060000076789 | 1 | PO717460 | ||
| 15060000076793 | L15/dossiers | 15 | 15060000076792 | 15060000076792 | 1 | PO717460 | ||
| 15060000076796 | L15/dossiers | 15 | 15060000076795 | 15060000076795 | 1 | PO717460 |