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 |
|---|---|---|---|---|---|---|---|---|
| 16060000055935 | L16/dossiers | 16 | 16060000055933 | 16060000055933 | 2 | PO831690 | ||
| 16060000055937 | L16/dossiers | 16 | 16060000055936 | 16060000055936 | 1 | PA722162 | rapporteur | |
| 16060000055938 | L16/dossiers | 16 | 16060000055936 | 16060000055936 | 2 | PO420120 | ||
| 16060000055941 | L16/dossiers | 16 | 16060000055940 | 16060000055940 | 1 | PA721760 | rapporteur | |
| 16060000055942 | L16/dossiers | 16 | 16060000055940 | 16060000055940 | 2 | PO59047 | ||
| 16060000055945 | L16/dossiers | 16 | 16060000055944 | 16060000055944 | 1 | PA793860 | rapporteur | |
| 16060000055946 | L16/dossiers | 16 | 16060000055944 | 16060000055944 | 2 | PO59051 | ||
| 16060000055949 | L16/dossiers | 16 | 16060000055948 | 16060000055948 | 1 | PA720560 | rapporteur | |
| 16060000055950 | L16/dossiers | 16 | 16060000055948 | 16060000055948 | 2 | PO59051 | ||
| 16060000055953 | L16/dossiers | 16 | 16060000055952 | 16060000055952 | 1 | PA721482 | rapporteur | |
| 16060000055954 | L16/dossiers | 16 | 16060000055952 | 16060000055952 | 2 | PO59051 | ||
| 16060000055957 | L16/dossiers | 16 | 16060000055956 | 16060000055956 | 1 | PA795508 | rapporteur | |
| 16060000055958 | L16/dossiers | 16 | 16060000055956 | 16060000055956 | 2 | PO59051 | ||
| 16060000055961 | L16/dossiers | 16 | 16060000055960 | 16060000055960 | 1 | PA718784 | rapporteur | |
| 16060000055962 | L16/dossiers | 16 | 16060000055960 | 16060000055960 | 2 | PA721328 | rapporteur | |
| 16060000055963 | L16/dossiers | 16 | 16060000055960 | 16060000055960 | 3 | PO59051 | ||
| 16060000055966 | L16/dossiers | 16 | 16060000055965 | 16060000055965 | 1 | PA794778 | rapporteur | |
| 16060000055967 | L16/dossiers | 16 | 16060000055965 | 16060000055965 | 2 | PO419865 | ||
| 16060000055970 | L16/dossiers | 16 | 16060000055969 | 16060000055969 | 1 | PA606639 | rapporteur | |
| 16060000055971 | L16/dossiers | 16 | 16060000055969 | 16060000055969 | 2 | PO420120 | ||
| 16060000055974 | L16/dossiers | 16 | 16060000055973 | 16060000055973 | 1 | PA793122 | rapporteur | |
| 16060000055975 | L16/dossiers | 16 | 16060000055973 | 16060000055973 | 2 | PO419610 | ||
| 16060000055978 | L16/dossiers | 16 | 16060000055977 | 16060000055977 | 1 | PA605745 | rapporteur | |
| 16060000055979 | L16/dossiers | 16 | 16060000055977 | 16060000055977 | 2 | PA721976 | rapporteur | |
| 16060000055980 | L16/dossiers | 16 | 16060000055977 | 16060000055977 | 3 | PO59051 | ||
| 16060000055983 | L16/dossiers | 16 | 16060000055982 | 16060000055982 | 1 | PA794486 | rapporteur | |
| 16060000055984 | L16/dossiers | 16 | 16060000055982 | 16060000055982 | 2 | PO59051 | ||
| 16060000055987 | L16/dossiers | 16 | 16060000055986 | 16060000055986 | 1 | PA793624 | rapporteur | |
| 16060000055988 | L16/dossiers | 16 | 16060000055986 | 16060000055986 | 2 | PA722202 | rapporteur | |
| 16060000055989 | L16/dossiers | 16 | 16060000055986 | 16060000055986 | 3 | PO59048 | ||
| 16060000055992 | L16/dossiers | 16 | 16060000055991 | 16060000055991 | 1 | PA342196 | rapporteur | |
| 16060000055993 | L16/dossiers | 16 | 16060000055991 | 16060000055991 | 2 | PO419604 | ||
| 16060000055996 | L16/dossiers | 16 | 16060000055995 | 16060000055995 | 1 | PA608172 | rapporteur | |
| 16060000055997 | L16/dossiers | 16 | 16060000055995 | 16060000055995 | 2 | PO59048 | ||
| 16060000056000 | L16/dossiers | 16 | 16060000055999 | 16060000055999 | 1 | PA795762 | rapporteur | |
| 16060000056001 | L16/dossiers | 16 | 16060000055999 | 16060000055999 | 2 | PO420120 | ||
| 16060000056004 | L16/dossiers | 16 | 16060000056003 | 16060000056003 | 1 | PA333285 | rapporteur | |
| 16060000056005 | L16/dossiers | 16 | 16060000056003 | 16060000056003 | 2 | PO419610 | ||
| 16060000056008 | L16/dossiers | 16 | 16060000056007 | 16060000056007 | 1 | PA609590 | rapporteur | |
| 16060000056009 | L16/dossiers | 16 | 16060000056007 | 16060000056007 | 2 | PO420120 | ||
| 16060000056012 | L16/dossiers | 16 | 16060000056011 | 16060000056011 | 1 | PA774960 | rapporteur | |
| 16060000056013 | L16/dossiers | 16 | 16060000056011 | 16060000056011 | 2 | PA708632 | rapporteur | |
| 16060000056014 | L16/dossiers | 16 | 16060000056011 | 16060000056011 | 3 | PO834687 | ||
| 16060000056016 | L16/dossiers | 16 | 16060000056015 | 16060000056015 | 1 | PA794486 | rapporteur | |
| 16060000056017 | L16/dossiers | 16 | 16060000056015 | 16060000056015 | 2 | PO834614 | ||
| 16060000056019 | L16/dossiers | 16 | 16060000056018 | 16060000056018 | 1 | PA719814 | rapporteur | |
| 16060000056020 | L16/dossiers | 16 | 16060000056018 | 16060000056018 | 2 | PA718884 | rapporteur | |
| 16060000056021 | L16/dossiers | 16 | 16060000056018 | 16060000056018 | 3 | PO419604 | ||
| 16060000056024 | L16/dossiers | 16 | 16060000056023 | 16060000056023 | 1 | PA795386 | rapporteur | |
| 16060000056025 | L16/dossiers | 16 | 16060000056023 | 16060000056023 | 2 | PO59051 |