dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
60 224 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 72 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 72 %, 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 58 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 14060000074711 | L14/dossiers | 14 | 14060000074709 | 14060000074709 | 2 | PO211495 | ||
| 14060000074713 | L14/dossiers | 14 | 14060000074712 | 14060000074712 | 1 | PA227076 | auteur | |
| 14060000074740 | L14/dossiers | 14 | 14060000074739 | 14060000074739 | 1 | PO644420 | ||
| 14060000074743 | L14/dossiers | 14 | 14060000074742 | 14060000074742 | 1 | PO717460 | ||
| 14060000074746 | L14/dossiers | 14 | 14060000074745 | 14060000074745 | 1 | PA1585 | auteur | |
| 14060000074749 | L14/dossiers | 14 | 14060000074748 | 14060000074748 | 1 | PA608662 | auteur | |
| 14060000074788 | L14/dossiers | 14 | 14060000074787 | 14060000074787 | 1 | PA333818 | rapporteur | |
| 14060000074789 | L14/dossiers | 14 | 14060000074787 | 14060000074787 | 2 | PO420120 | ||
| 14060000074791 | L14/dossiers | 14 | 14060000074790 | 14060000074790 | 1 | PA267622 | auteur | |
| 14060000074795 | L14/dossiers | 14 | 14060000074794 | 14060000074794 | 1 | PO78718 | ||
| 14060000074797 | L14/dossiers | 14 | 14060000074796 | 14060000074796 | 1 | PA304015 | rapporteur | |
| 14060000074798 | L14/dossiers | 14 | 14060000074796 | 14060000074796 | 2 | PO211491 | ||
| 14060000074800 | L14/dossiers | 14 | 14060000074799 | 14060000074799 | 1 | PA1116 | rapporteur | |
| 14060000074801 | L14/dossiers | 14 | 14060000074799 | 14060000074799 | 2 | PO59047 | ||
| 14060000074803 | L14/dossiers | 14 | 14060000074802 | 14060000074802 | 1 | PA267622 | auteur | |
| 14060000074805 | L14/dossiers | 14 | 14060000074804 | 14060000074804 | 1 | PA2952 | auteur | |
| 14060000074808 | L14/dossiers | 14 | 14060000074807 | 14060000074807 | 1 | PA227083 | rapporteur pour avis | |
| 14060000074809 | L14/dossiers | 14 | 14060000074807 | 14060000074807 | 2 | PO516754 | ||
| 14060000074811 | L14/dossiers | 14 | 14060000074810 | 14060000074810 | 1 | PA429875 | rapporteur | |
| 14060000074812 | L14/dossiers | 14 | 14060000074810 | 14060000074810 | 2 | PA267419 | rapporteur | |
| 14060000074813 | L14/dossiers | 14 | 14060000074810 | 14060000074810 | 3 | PO211494 | ||
| 14060000074815 | L14/dossiers | 14 | 14060000074814 | 14060000074814 | 1 | PA429881 | auteur | |
| 14060000074826 | L14/dossiers | 14 | 14060000074825 | 14060000074825 | 1 | PA267266 | auteur | |
| 14060000074829 | L14/dossiers | 14 | 14060000074828 | 14060000074828 | 1 | PA328 | auteur | |
| 14060000074833 | L14/dossiers | 14 | 14060000074832 | 14060000074832 | 1 | PA998 | auteur | |
| 14060000074873 | L14/dossiers | 14 | 14060000074872 | 14060000074872 | 1 | PA332747 | auteur | |
| 14060000074889 | L14/dossiers | 14 | 14060000074888 | 14060000074888 | 1 | PA267622 | auteur | |
| 14060000074893 | L14/dossiers | 14 | 14060000074892 | 14060000074892 | 1 | PO78718 | ||
| 14060000074895 | L14/dossiers | 14 | 14060000074894 | 14060000074894 | 1 | PO644420 | ||
| 14060000074898 | L14/dossiers | 14 | 14060000074897 | 14060000074897 | 1 | PO78718 | ||
| 14060000074900 | L14/dossiers | 14 | 14060000074899 | 14060000074899 | 1 | PO644420 | ||
| 14060000074909 | L14/dossiers | 14 | 14060000074902 | 14060000074902 | 1 | PA2056 | rapporteur | |
| 14060000074910 | L14/dossiers | 14 | 14060000074902 | 14060000074902 | 2 | PO211494 | ||
| 14060000074918 | L14/dossiers | 14 | 14060000074911 | 14060000074911 | 1 | PA609590 | rapporteur | |
| 14060000074919 | L14/dossiers | 14 | 14060000074911 | 14060000074911 | 2 | PO59048 | ||
| 14060000074921 | L14/dossiers | 14 | 14060000074920 | 14060000074920 | 1 | PA609590 | rapporteur | |
| 14060000074922 | L14/dossiers | 14 | 14060000074920 | 14060000074920 | 2 | PO702527 | ||
| 14060000074924 | L14/dossiers | 14 | 14060000074923 | 14060000074923 | 1 | PA2056 | rapporteur | |
| 14060000074925 | L14/dossiers | 14 | 14060000074923 | 14060000074923 | 2 | PO211494 | ||
| 14060000074927 | L14/dossiers | 14 | 14060000074926 | 14060000074926 | 1 | PA609590 | rapporteur | |
| 14060000074928 | L14/dossiers | 14 | 14060000074926 | 14060000074926 | 2 | PO59048 | ||
| 14060000074930 | L14/dossiers | 14 | 14060000074929 | 14060000074929 | 1 | PA2056 | rapporteur | |
| 14060000074931 | L14/dossiers | 14 | 14060000074929 | 14060000074929 | 2 | PO702527 | ||
| 14060000074933 | L14/dossiers | 14 | 14060000074932 | 14060000074932 | 1 | PA609590 | rapporteur | |
| 14060000074934 | L14/dossiers | 14 | 14060000074932 | 14060000074932 | 2 | PO59048 | ||
| 14060000074936 | L14/dossiers | 14 | 14060000074935 | 14060000074935 | 1 | PA429836 | rapporteur | |
| 14060000074937 | L14/dossiers | 14 | 14060000074935 | 14060000074935 | 2 | PO211493 | ||
| 14060000074939 | L14/dossiers | 14 | 14060000074938 | 14060000074938 | 1 | PA429836 | auteur | |
| 14060000074960 | L14/dossiers | 14 | 14060000074959 | 14060000074959 | 1 | PA267801 | auteur | |
| 14060000074979 | L14/dossiers | 14 | 14060000074978 | 14060000074978 | 1 | PA267801 | auteur |