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 |
|---|---|---|---|---|---|---|---|---|
| 17060000109835 | L17/dossiers | 17 | 17060000109833 | 17060000109833 | 2 | PO211493 | ||
| 17060000109837 | L17/dossiers | 17 | 17060000109836 | 17060000109836 | 1 | PA736224 | rapporteur | |
| 17060000109838 | L17/dossiers | 17 | 17060000109836 | 17060000109836 | 2 | PO516753 | ||
| 17060000109840 | L17/dossiers | 17 | 17060000109839 | 17060000109839 | 1 | PA429886 | rapporteur | |
| 17060000109841 | L17/dossiers | 17 | 17060000109839 | 17060000109839 | 2 | PO211495 | ||
| 17060000109843 | L17/dossiers | 17 | 17060000109842 | 17060000109842 | 1 | PA429875 | rapporteur | |
| 17060000109844 | L17/dossiers | 17 | 17060000109842 | 17060000109842 | 2 | PA415448 | rapporteur | |
| 17060000109845 | L17/dossiers | 17 | 17060000109842 | 17060000109842 | 3 | PO211494 | ||
| 17060000109847 | L17/dossiers | 17 | 17060000109846 | 17060000109846 | 1 | PA429889 | rapporteur | |
| 17060000109848 | L17/dossiers | 17 | 17060000109846 | 17060000109846 | 2 | PO211493 | ||
| 17060000109850 | L17/dossiers | 17 | 17060000109849 | 17060000109849 | 1 | PA736177 | rapporteur | |
| 17060000109851 | L17/dossiers | 17 | 17060000109849 | 17060000109849 | 2 | PO211491 | ||
| 17060000109853 | L17/dossiers | 17 | 17060000109852 | 17060000109852 | 1 | PA773891 | rapporteur | |
| 17060000109854 | L17/dossiers | 17 | 17060000109852 | 17060000109852 | 2 | PO211495 | ||
| 17060000109856 | L17/dossiers | 17 | 17060000109855 | 17060000109855 | 1 | PA703492 | rapporteur | |
| 17060000109857 | L17/dossiers | 17 | 17060000109855 | 17060000109855 | 2 | PO211495 | ||
| 17060000109859 | L17/dossiers | 17 | 17060000109858 | 17060000109858 | 1 | PA267512 | rapporteur | |
| 17060000109860 | L17/dossiers | 17 | 17060000109858 | 17060000109858 | 2 | PO211495 | ||
| 17060000109862 | L17/dossiers | 17 | 17060000109861 | 17060000109861 | 1 | PA775226 | rapporteur | |
| 17060000109863 | L17/dossiers | 17 | 17060000109861 | 17060000109861 | 2 | PO211490 | ||
| 17060000109865 | L17/dossiers | 17 | 17060000109864 | 17060000109864 | 1 | PA330684 | rapporteur | |
| 17060000109866 | L17/dossiers | 17 | 17060000109864 | 17060000109864 | 2 | PO211495 | ||
| 17060000109868 | L17/dossiers | 17 | 17060000109867 | 17060000109867 | 1 | PA744079 | rapporteur | |
| 17060000109869 | L17/dossiers | 17 | 17060000109867 | 17060000109867 | 2 | PO211494 | ||
| 17060000109871 | L17/dossiers | 17 | 17060000109870 | 17060000109870 | 1 | PA331381 | rapporteur | |
| 17060000109872 | L17/dossiers | 17 | 17060000109870 | 17060000109870 | 2 | PO211490 | ||
| 17060000109874 | L17/dossiers | 17 | 17060000109873 | 17060000109873 | 1 | PA775212 | rapporteur | |
| 17060000109875 | L17/dossiers | 17 | 17060000109873 | 17060000109873 | 2 | PO516754 | ||
| 17060000109877 | L17/dossiers | 17 | 17060000109876 | 17060000109876 | 1 | PA775284 | rapporteur | |
| 17060000109878 | L17/dossiers | 17 | 17060000109876 | 17060000109876 | 2 | PO211494 | ||
| 17060000109880 | L17/dossiers | 17 | 17060000109879 | 17060000109879 | 1 | PA1452 | rapporteur | |
| 17060000109881 | L17/dossiers | 17 | 17060000109879 | 17060000109879 | 2 | PO516753 | ||
| 17060000109883 | L17/dossiers | 17 | 17060000109882 | 17060000109882 | 1 | PA736247 | rapporteur | |
| 17060000109884 | L17/dossiers | 17 | 17060000109882 | 17060000109882 | 2 | PO516753 | ||
| 17060000109886 | L17/dossiers | 17 | 17060000109885 | 17060000109885 | 1 | PA775198 | rapporteur | |
| 17060000109887 | L17/dossiers | 17 | 17060000109885 | 17060000109885 | 2 | PO211490 | ||
| 17060000109889 | L17/dossiers | 17 | 17060000109888 | 17060000109888 | 1 | PA429858 | rapporteur | |
| 17060000109890 | L17/dossiers | 17 | 17060000109888 | 17060000109888 | 2 | PO211495 | ||
| 17060000109892 | L17/dossiers | 17 | 17060000109891 | 17060000109891 | 1 | PA703514 | rapporteur | |
| 17060000109893 | L17/dossiers | 17 | 17060000109891 | 17060000109891 | 2 | PO211494 | ||
| 17060000109895 | L17/dossiers | 17 | 17060000109894 | 17060000109894 | 1 | PA736238 | rapporteur | |
| 17060000109896 | L17/dossiers | 17 | 17060000109894 | 17060000109894 | 2 | PO211490 | ||
| 17060000109898 | L17/dossiers | 17 | 17060000109897 | 17060000109897 | 1 | PA736237 | rapporteur | |
| 17060000109899 | L17/dossiers | 17 | 17060000109897 | 17060000109897 | 2 | PO211493 | ||
| 17060000109901 | L17/dossiers | 17 | 17060000109900 | 17060000109900 | 1 | PA304085 | rapporteur | |
| 17060000109902 | L17/dossiers | 17 | 17060000109900 | 17060000109900 | 2 | PO211491 | ||
| 17060000109904 | L17/dossiers | 17 | 17060000109903 | 17060000109903 | 1 | PA304085 | rapporteur | |
| 17060000109905 | L17/dossiers | 17 | 17060000109903 | 17060000109903 | 2 | PO826014 | ||
| 17060000109907 | L17/dossiers | 17 | 17060000109906 | 17060000109906 | 1 | PA703520 | rapporteur | |
| 17060000109908 | L17/dossiers | 17 | 17060000109906 | 17060000109906 | 2 | PO516753 |