dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000081941 | L17/dossiers | 17 | 17060000081940 | 17060000081940 | 1 | PA703513 | rapporteur | |
| 17060000081942 | L17/dossiers | 17 | 17060000081940 | 17060000081940 | 2 | PO516753 | ||
| 17060000081944 | L17/dossiers | 17 | 17060000081943 | 17060000081943 | 1 | PA775212 | rapporteur | |
| 17060000081945 | L17/dossiers | 17 | 17060000081943 | 17060000081943 | 2 | PO211493 | ||
| 17060000081947 | L17/dossiers | 17 | 17060000081946 | 17060000081946 | 1 | PA775288 | rapporteur | |
| 17060000081948 | L17/dossiers | 17 | 17060000081946 | 17060000081946 | 2 | PO211494 | ||
| 17060000081950 | L17/dossiers | 17 | 17060000081949 | 17060000081949 | 1 | PA304017 | rapporteur | |
| 17060000081951 | L17/dossiers | 17 | 17060000081949 | 17060000081949 | 2 | PO211490 | ||
| 17060000081953 | L17/dossiers | 17 | 17060000081952 | 17060000081952 | 1 | PA775184 | rapporteur | |
| 17060000081954 | L17/dossiers | 17 | 17060000081952 | 17060000081952 | 2 | PO211495 | ||
| 17060000081956 | L17/dossiers | 17 | 17060000081955 | 17060000081955 | 1 | PA849528 | rapporteur | |
| 17060000081957 | L17/dossiers | 17 | 17060000081955 | 17060000081955 | 2 | PO211495 | ||
| 17060000081959 | L17/dossiers | 17 | 17060000081958 | 17060000081958 | 1 | PA775258 | rapporteur | |
| 17060000081960 | L17/dossiers | 17 | 17060000081958 | 17060000081958 | 2 | PO211493 | ||
| 17060000081962 | L17/dossiers | 17 | 17060000081961 | 17060000081961 | 1 | PA736192 | rapporteur | |
| 17060000081963 | L17/dossiers | 17 | 17060000081961 | 17060000081961 | 2 | PO211490 | ||
| 17060000081965 | L17/dossiers | 17 | 17060000081964 | 17060000081964 | 1 | PA703530 | rapporteur | |
| 17060000081966 | L17/dossiers | 17 | 17060000081964 | 17060000081964 | 2 | PA775208 | rapporteur | |
| 17060000081967 | L17/dossiers | 17 | 17060000081964 | 17060000081964 | 3 | PA775256 | rapporteur | |
| 17060000081968 | L17/dossiers | 17 | 17060000081964 | 17060000081964 | 4 | PA736195 | rapporteur | |
| 17060000081969 | L17/dossiers | 17 | 17060000081964 | 17060000081964 | 5 | PO516753 | ||
| 17060000081971 | L17/dossiers | 17 | 17060000081970 | 17060000081970 | 1 | PA784534 | rapporteur | |
| 17060000081972 | L17/dossiers | 17 | 17060000081970 | 17060000081970 | 2 | PO211493 | ||
| 17060000081974 | L17/dossiers | 17 | 17060000081973 | 17060000081973 | 1 | PA775204 | rapporteur | |
| 17060000081975 | L17/dossiers | 17 | 17060000081973 | 17060000081973 | 2 | PO516753 | ||
| 17060000081977 | L17/dossiers | 17 | 17060000081976 | 17060000081976 | 1 | PA642756 | rapporteur | |
| 17060000081978 | L17/dossiers | 17 | 17060000081976 | 17060000081976 | 2 | PO879833 | ||
| 17060000081980 | L17/dossiers | 17 | 17060000081979 | 17060000081979 | 1 | PA827906 | rapporteur | |
| 17060000081981 | L17/dossiers | 17 | 17060000081979 | 17060000081979 | 2 | PO516753 | ||
| 17060000081983 | L17/dossiers | 17 | 17060000081982 | 17060000081982 | 1 | PA827964 | rapporteur | |
| 17060000081984 | L17/dossiers | 17 | 17060000081982 | 17060000081982 | 2 | PO516753 | ||
| 17060000081986 | L17/dossiers | 17 | 17060000081985 | 17060000081985 | 1 | PA827966 | rapporteur | |
| 17060000081987 | L17/dossiers | 17 | 17060000081985 | 17060000081985 | 2 | PO211495 | ||
| 17060000081989 | L17/dossiers | 17 | 17060000081988 | 17060000081988 | 1 | PA788192 | rapporteur | |
| 17060000081990 | L17/dossiers | 17 | 17060000081988 | 17060000081988 | 2 | PO879950 | ||
| 17060000081992 | L17/dossiers | 17 | 17060000081991 | 17060000081991 | 1 | PA703510 | rapporteur | |
| 17060000081993 | L17/dossiers | 17 | 17060000081991 | 17060000081991 | 2 | PO211495 | ||
| 17060000081995 | L17/dossiers | 17 | 17060000081994 | 17060000081994 | 1 | PA775184 | rapporteur | |
| 17060000081996 | L17/dossiers | 17 | 17060000081994 | 17060000081994 | 2 | PO211495 | ||
| 17060000081998 | L17/dossiers | 17 | 17060000081997 | 17060000081997 | 1 | PA767418 | rapporteur | |
| 17060000081999 | L17/dossiers | 17 | 17060000081997 | 17060000081997 | 2 | PO516754 | ||
| 17060000082001 | L17/dossiers | 17 | 17060000082000 | 17060000082000 | 1 | PA703514 | rapporteur | |
| 17060000082002 | L17/dossiers | 17 | 17060000082000 | 17060000082000 | 2 | PO211494 | ||
| 17060000082004 | L17/dossiers | 17 | 17060000082003 | 17060000082003 | 1 | PA736246 | rapporteur | |
| 17060000082005 | L17/dossiers | 17 | 17060000082003 | 17060000082003 | 2 | PA736206 | rapporteur | |
| 17060000082006 | L17/dossiers | 17 | 17060000082003 | 17060000082003 | 3 | PO211493 | ||
| 17060000082008 | L17/dossiers | 17 | 17060000082007 | 17060000082007 | 1 | PA736198 | rapporteur | |
| 17060000082009 | L17/dossiers | 17 | 17060000082007 | 17060000082007 | 2 | PA2197 | rapporteur | |
| 17060000082010 | L17/dossiers | 17 | 17060000082007 | 17060000082007 | 3 | PO211493 | ||
| 17060000082012 | L17/dossiers | 17 | 17060000082011 | 17060000082011 | 1 | PA827988 | rapporteur |