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 |
|---|---|---|---|---|---|---|---|---|
| 14060000021687 | L14/dossiers | 14 | 14060000021676 | 14060000021676 | 3 | PO273589 | ||
| 14060000021689 | L14/dossiers | 14 | 14060000021688 | 14060000021688 | 1 | PA343623 | auteur | |
| 14060000021733 | L14/dossiers | 14 | 14060000021732 | 14060000021732 | 1 | PA346 | auteur | |
| 14060000021753 | L14/dossiers | 14 | 14060000021752 | 14060000021752 | 1 | PA608328 | rapporteur | |
| 14060000021754 | L14/dossiers | 14 | 14060000021752 | 14060000021752 | 2 | PO201269 | ||
| 14060000021756 | L14/dossiers | 14 | 14060000021755 | 14060000021755 | 1 | PA267622 | auteur | |
| 14060000021760 | L14/dossiers | 14 | 14060000021759 | 14060000021759 | 1 | PO78718 | ||
| 14060000021762 | L14/dossiers | 14 | 14060000021761 | 14060000021761 | 1 | PA642699 | rapporteur | |
| 14060000021763 | L14/dossiers | 14 | 14060000021761 | 14060000021761 | 2 | PO420120 | ||
| 14060000021766 | L14/dossiers | 14 | 14060000021765 | 14060000021765 | 1 | PO644420 | ||
| 14060000021772 | L14/dossiers | 14 | 14060000021768 | 14060000021768 | 1 | PA642699 | rapporteur | |
| 14060000021773 | L14/dossiers | 14 | 14060000021768 | 14060000021768 | 2 | PO420120 | ||
| 14060000021775 | L14/dossiers | 14 | 14060000021774 | 14060000021774 | 1 | PA360 | rapporteur | |
| 14060000021776 | L14/dossiers | 14 | 14060000021774 | 14060000021774 | 2 | PO211493 | ||
| 14060000021778 | L14/dossiers | 14 | 14060000021777 | 14060000021777 | 1 | PA642699 | rapporteur | |
| 14060000021779 | L14/dossiers | 14 | 14060000021777 | 14060000021777 | 2 | PO715032 | ||
| 14060000021781 | L14/dossiers | 14 | 14060000021780 | 14060000021780 | 1 | PA360 | rapporteur | |
| 14060000021782 | L14/dossiers | 14 | 14060000021780 | 14060000021780 | 2 | PO715032 | ||
| 14060000021784 | L14/dossiers | 14 | 14060000021783 | 14060000021783 | 1 | PA267622 | auteur | |
| 14060000021786 | L14/dossiers | 14 | 14060000021785 | 14060000021785 | 1 | PA330240 | auteur | |
| 14060000021839 | L14/dossiers | 14 | 14060000021830 | 14060000021830 | 1 | PA606555 | rapporteur | |
| 14060000021840 | L14/dossiers | 14 | 14060000021830 | 14060000021830 | 2 | PA227094 | rapporteur | |
| 14060000021841 | L14/dossiers | 14 | 14060000021830 | 14060000021830 | 3 | PO273589 | ||
| 14060000021843 | L14/dossiers | 14 | 14060000021842 | 14060000021842 | 1 | PA735 | rapporteur | |
| 14060000021844 | L14/dossiers | 14 | 14060000021842 | 14060000021842 | 2 | PO59048 | ||
| 14060000021846 | L14/dossiers | 14 | 14060000021845 | 14060000021845 | 1 | PA735 | auteur | |
| 14060000021848 | L14/dossiers | 14 | 14060000021847 | 14060000021847 | 1 | PA735 | rapporteur | |
| 14060000021849 | L14/dossiers | 14 | 14060000021847 | 14060000021847 | 2 | PO59048 | ||
| 14060000021851 | L14/dossiers | 14 | 14060000021850 | 14060000021850 | 1 | PA267622 | auteur | |
| 14060000021856 | L14/dossiers | 14 | 14060000021855 | 14060000021855 | 1 | PA607193 | rapporteur | |
| 14060000021857 | L14/dossiers | 14 | 14060000021855 | 14060000021855 | 2 | PO702090 | ||
| 14060000021860 | L14/dossiers | 14 | 14060000021859 | 14060000021859 | 1 | PO78718 | ||
| 14060000021862 | L14/dossiers | 14 | 14060000021861 | 14060000021861 | 1 | PO644420 | ||
| 14060000021865 | L14/dossiers | 14 | 14060000021864 | 14060000021864 | 1 | PA304086 | rapporteur pour avis | |
| 14060000021866 | L14/dossiers | 14 | 14060000021864 | 14060000021864 | 2 | PO211493 | ||
| 14060000021868 | L14/dossiers | 14 | 14060000021867 | 14060000021867 | 1 | PA304010 | rapporteur pour avis | |
| 14060000021869 | L14/dossiers | 14 | 14060000021867 | 14060000021867 | 2 | PO211494 | ||
| 14060000021871 | L14/dossiers | 14 | 14060000021870 | 14060000021870 | 1 | PA922 | rapporteur pour avis | |
| 14060000021872 | L14/dossiers | 14 | 14060000021870 | 14060000021870 | 2 | PO516754 | ||
| 14060000021874 | L14/dossiers | 14 | 14060000021873 | 14060000021873 | 1 | PA304000 | rapporteur pour avis | |
| 14060000021875 | L14/dossiers | 14 | 14060000021873 | 14060000021873 | 2 | PO516753 | ||
| 14060000021877 | L14/dossiers | 14 | 14060000021876 | 14060000021876 | 1 | PA607193 | rapporteur | |
| 14060000021878 | L14/dossiers | 14 | 14060000021876 | 14060000021876 | 2 | PO704567 | ||
| 14060000021880 | L14/dossiers | 14 | 14060000021879 | 14060000021879 | 1 | PA426327 | rapporteur | |
| 14060000021881 | L14/dossiers | 14 | 14060000021879 | 14060000021879 | 2 | PO704567 | ||
| 14060000021883 | L14/dossiers | 14 | 14060000021882 | 14060000021882 | 1 | PA607193 | rapporteur | |
| 14060000021884 | L14/dossiers | 14 | 14060000021882 | 14060000021882 | 2 | PO702090 | ||
| 14060000021886 | L14/dossiers | 14 | 14060000021885 | 14060000021885 | 1 | PA426327 | rapporteur | |
| 14060000021887 | L14/dossiers | 14 | 14060000021885 | 14060000021885 | 2 | PO211495 | ||
| 14060000021889 | L14/dossiers | 14 | 14060000021888 | 14060000021888 | 1 | PA267622 | auteur |