dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
60 224 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 72 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 72 %, 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 58 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 14060000070952 | L14/dossiers | 14 | 14060000070950 | 14060000070950 | 2 | PO419865 | ||
| 14060000070955 | L14/dossiers | 14 | 14060000070954 | 14060000070954 | 1 | PA328 | auteur | |
| 14060000070959 | L14/dossiers | 14 | 14060000070958 | 14060000070958 | 1 | PO644420 | ||
| 14060000070962 | L14/dossiers | 14 | 14060000070961 | 14060000070961 | 1 | PA227029 | rapporteur pour avis | |
| 14060000070963 | L14/dossiers | 14 | 14060000070961 | 14060000070961 | 2 | PO211490 | ||
| 14060000070965 | L14/dossiers | 14 | 14060000070964 | 14060000070964 | 1 | PA415460 | rapporteur pour avis | |
| 14060000070966 | L14/dossiers | 14 | 14060000070964 | 14060000070964 | 2 | PO211495 | ||
| 14060000070968 | L14/dossiers | 14 | 14060000070967 | 14060000070967 | 1 | PA429842 | rapporteur pour avis | |
| 14060000070969 | L14/dossiers | 14 | 14060000070967 | 14060000070967 | 2 | PO516753 | ||
| 14060000070971 | L14/dossiers | 14 | 14060000070970 | 14060000070970 | 1 | PA2374 | rapporteur | |
| 14060000070972 | L14/dossiers | 14 | 14060000070970 | 14060000070970 | 2 | PO419865 | ||
| 14060000070980 | L14/dossiers | 14 | 14060000070973 | 14060000070973 | 1 | PA513 | rapporteur | |
| 14060000070981 | L14/dossiers | 14 | 14060000070973 | 14060000070973 | 2 | PO516754 | ||
| 14060000070983 | L14/dossiers | 14 | 14060000070982 | 14060000070982 | 1 | PA513 | rapporteur | |
| 14060000070984 | L14/dossiers | 14 | 14060000070982 | 14060000070982 | 2 | PO516754 | ||
| 14060000070992 | L14/dossiers | 14 | 14060000070985 | 14060000070985 | 1 | PA2374 | rapporteur | |
| 14060000070993 | L14/dossiers | 14 | 14060000070985 | 14060000070985 | 2 | PO419865 | ||
| 14060000070995 | L14/dossiers | 14 | 14060000070994 | 14060000070994 | 1 | PA2374 | rapporteur | |
| 14060000070996 | L14/dossiers | 14 | 14060000070994 | 14060000070994 | 2 | PO419865 | ||
| 14060000070998 | L14/dossiers | 14 | 14060000070997 | 14060000070997 | 1 | PA2374 | rapporteur | |
| 14060000070999 | L14/dossiers | 14 | 14060000070997 | 14060000070997 | 2 | PO419865 | ||
| 14060000071001 | L14/dossiers | 14 | 14060000071000 | 14060000071000 | 1 | PA2374 | rapporteur | |
| 14060000071002 | L14/dossiers | 14 | 14060000071000 | 14060000071000 | 2 | PO712837 | ||
| 14060000071004 | L14/dossiers | 14 | 14060000071003 | 14060000071003 | 1 | PA513 | rapporteur | |
| 14060000071005 | L14/dossiers | 14 | 14060000071003 | 14060000071003 | 2 | PO516754 | ||
| 14060000071007 | L14/dossiers | 14 | 14060000071006 | 14060000071006 | 1 | PA513 | rapporteur | |
| 14060000071008 | L14/dossiers | 14 | 14060000071006 | 14060000071006 | 2 | PO712837 | ||
| 14060000071010 | L14/dossiers | 14 | 14060000071009 | 14060000071009 | 1 | PA328 | auteur | |
| 14060000071012 | L14/dossiers | 14 | 14060000071011 | 14060000071011 | 1 | PA1585 | auteur | |
| 14060000071041 | L14/dossiers | 14 | 14060000071040 | 14060000071040 | 1 | PA267266 | auteur | |
| 14060000071072 | L14/dossiers | 14 | 14060000071071 | 14060000071071 | 1 | PA606212 | auteur | |
| 14060000071075 | L14/dossiers | 14 | 14060000071074 | 14060000071074 | 1 | PA1699 | rapporteur | |
| 14060000071076 | L14/dossiers | 14 | 14060000071074 | 14060000071074 | 2 | PA334768 | rapporteur | |
| 14060000071077 | L14/dossiers | 14 | 14060000071074 | 14060000071074 | 3 | PO420375 | ||
| 14060000071079 | L14/dossiers | 14 | 14060000071078 | 14060000071078 | 1 | PA406065 | rapporteur pour avis | |
| 14060000071080 | L14/dossiers | 14 | 14060000071078 | 14060000071078 | 2 | PO211495 | ||
| 14060000071082 | L14/dossiers | 14 | 14060000071081 | 14060000071081 | 1 | PA703519 | rapporteur | |
| 14060000071083 | L14/dossiers | 14 | 14060000071081 | 14060000071081 | 2 | PA1090 | rapporteur | |
| 14060000071084 | L14/dossiers | 14 | 14060000071081 | 14060000071081 | 3 | PO211493 | ||
| 14060000071086 | L14/dossiers | 14 | 14060000071085 | 14060000071085 | 1 | PA872 | rapporteur | |
| 14060000071087 | L14/dossiers | 14 | 14060000071085 | 14060000071085 | 2 | PO709882 | ||
| 14060000071089 | L14/dossiers | 14 | 14060000071088 | 14060000071088 | 1 | PA872 | rapporteur | |
| 14060000071090 | L14/dossiers | 14 | 14060000071088 | 14060000071088 | 2 | PA1946 | rapporteur | |
| 14060000071091 | L14/dossiers | 14 | 14060000071088 | 14060000071088 | 3 | PO420120 | ||
| 14060000071093 | L14/dossiers | 14 | 14060000071092 | 14060000071092 | 1 | PA1090 | rapporteur | |
| 14060000071094 | L14/dossiers | 14 | 14060000071092 | 14060000071092 | 2 | PO709882 | ||
| 14060000071096 | L14/dossiers | 14 | 14060000071095 | 14060000071095 | 1 | PA703519 | rapporteur | |
| 14060000071097 | L14/dossiers | 14 | 14060000071095 | 14060000071095 | 2 | PA1090 | rapporteur | |
| 14060000071098 | L14/dossiers | 14 | 14060000071095 | 14060000071095 | 3 | PO211493 | ||
| 14060000071100 | L14/dossiers | 14 | 14060000071099 | 14060000071099 | 1 | PA872 | rapporteur |