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 |
|---|---|---|---|---|---|---|---|---|
| 17060000110843 | L17/dossiers | 17 | 17060000110798 | 17060000110798 | 45 | PA827898 | rapporteur | |
| 17060000110844 | L17/dossiers | 17 | 17060000110798 | 17060000110798 | 46 | PA703509 | rapporteur | |
| 17060000110845 | L17/dossiers | 17 | 17060000110798 | 17060000110798 | 47 | PA736174 | rapporteur | |
| 17060000110846 | L17/dossiers | 17 | 17060000110798 | 17060000110798 | 48 | PA828000 | rapporteur | |
| 17060000110847 | L17/dossiers | 17 | 17060000110798 | 17060000110798 | 49 | PO211494 | ||
| 17060000110849 | L17/dossiers | 17 | 17060000110848 | 17060000110848 | 1 | PA267075 | rapporteur | |
| 17060000110850 | L17/dossiers | 17 | 17060000110848 | 17060000110848 | 2 | PO211491 | ||
| 17060000110852 | L17/dossiers | 17 | 17060000110851 | 17060000110851 | 1 | PA703498 | rapporteur | |
| 17060000110853 | L17/dossiers | 17 | 17060000110851 | 17060000110851 | 2 | PO875512 | ||
| 17060000110855 | L17/dossiers | 17 | 17060000110854 | 17060000110854 | 1 | PA429875 | rapporteur | |
| 17060000110856 | L17/dossiers | 17 | 17060000110854 | 17060000110854 | 2 | PO875551 | ||
| 17060000110858 | L17/dossiers | 17 | 17060000110857 | 17060000110857 | 1 | PA703492 | rapporteur | |
| 17060000110859 | L17/dossiers | 17 | 17060000110857 | 17060000110857 | 2 | PO211491 | ||
| 17060000110861 | L17/dossiers | 17 | 17060000110860 | 17060000110860 | 1 | PA775184 | rapporteur | |
| 17060000110862 | L17/dossiers | 17 | 17060000110860 | 17060000110860 | 2 | PO211495 | ||
| 17060000110864 | L17/dossiers | 17 | 17060000110863 | 17060000110863 | 1 | PA415454 | rapporteur | |
| 17060000110865 | L17/dossiers | 17 | 17060000110863 | 17060000110863 | 2 | PO211495 | ||
| 17060000110867 | L17/dossiers | 17 | 17060000110866 | 17060000110866 | 1 | PA827990 | rapporteur | |
| 17060000110868 | L17/dossiers | 17 | 17060000110866 | 17060000110866 | 2 | PO211495 | ||
| 17060000110870 | L17/dossiers | 17 | 17060000110869 | 17060000110869 | 1 | PA304017 | rapporteur | |
| 17060000110871 | L17/dossiers | 17 | 17060000110869 | 17060000110869 | 2 | PO211490 | ||
| 17060000110873 | L17/dossiers | 17 | 17060000110872 | 17060000110872 | 1 | PA267112 | rapporteur | |
| 17060000110874 | L17/dossiers | 17 | 17060000110872 | 17060000110872 | 2 | PO211493 | ||
| 17060000110876 | L17/dossiers | 17 | 17060000110875 | 17060000110875 | 1 | PA703498 | rapporteur | |
| 17060000110877 | L17/dossiers | 17 | 17060000110875 | 17060000110875 | 2 | PO211493 | ||
| 17060000110879 | L17/dossiers | 17 | 17060000110878 | 17060000110878 | 1 | PA828004 | rapporteur | |
| 17060000110880 | L17/dossiers | 17 | 17060000110878 | 17060000110878 | 2 | PO211493 | ||
| 17060000110882 | L17/dossiers | 17 | 17060000110881 | 17060000110881 | 1 | PA715745 | rapporteur | |
| 17060000110883 | L17/dossiers | 17 | 17060000110881 | 17060000110881 | 2 | PO516753 | ||
| 17060000110885 | L17/dossiers | 17 | 17060000110884 | 17060000110884 | 1 | PA606375 | rapporteur | |
| 17060000110886 | L17/dossiers | 17 | 17060000110884 | 17060000110884 | 2 | PO211493 | ||
| 17060000110888 | L17/dossiers | 17 | 17060000110887 | 17060000110887 | 1 | PA703512 | rapporteur | |
| 17060000110889 | L17/dossiers | 17 | 17060000110887 | 17060000110887 | 2 | PO211490 | ||
| 17060000110891 | L17/dossiers | 17 | 17060000110890 | 17060000110890 | 1 | PA429875 | rapporteur | |
| 17060000110892 | L17/dossiers | 17 | 17060000110890 | 17060000110890 | 2 | PO876895 | ||
| 17060000110894 | L17/dossiers | 17 | 17060000110893 | 17060000110893 | 1 | PA429875 | rapporteur | |
| 17060000110895 | L17/dossiers | 17 | 17060000110893 | 17060000110893 | 2 | PO211494 | ||
| 17060000110897 | L17/dossiers | 17 | 17060000110896 | 17060000110896 | 1 | PA758716 | rapporteur | |
| 17060000110898 | L17/dossiers | 17 | 17060000110896 | 17060000110896 | 2 | PA788192 | rapporteur | |
| 17060000110899 | L17/dossiers | 17 | 17060000110896 | 17060000110896 | 3 | PA873412 | rapporteur | |
| 17060000110900 | L17/dossiers | 17 | 17060000110896 | 17060000110896 | 4 | PO516753 | ||
| 17060000110902 | L17/dossiers | 17 | 17060000110901 | 17060000110901 | 1 | PA828016 | rapporteur | |
| 17060000110903 | L17/dossiers | 17 | 17060000110901 | 17060000110901 | 2 | PO211495 | ||
| 17060000110905 | L17/dossiers | 17 | 17060000110904 | 17060000110904 | 1 | PA775178 | rapporteur | |
| 17060000110906 | L17/dossiers | 17 | 17060000110904 | 17060000110904 | 2 | PO211495 | ||
| 17060000110908 | L17/dossiers | 17 | 17060000110907 | 17060000110907 | 1 | PA736198 | rapporteur | |
| 17060000110909 | L17/dossiers | 17 | 17060000110907 | 17060000110907 | 2 | PA2197 | rapporteur | |
| 17060000110910 | L17/dossiers | 17 | 17060000110907 | 17060000110907 | 3 | PO211493 | ||
| 17060000110912 | L17/dossiers | 17 | 17060000110911 | 17060000110911 | 1 | PA736246 | rapporteur | |
| 17060000110913 | L17/dossiers | 17 | 17060000110911 | 17060000110911 | 2 | PA736206 | rapporteur |