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 |
|---|---|---|---|---|---|---|---|---|
| 15060000086996 | L15/dossiers | 15 | 15060000086995 | 15060000086995 | 1 | PO78718 | ||
| 15060000086998 | L15/dossiers | 15 | 15060000086997 | 15060000086997 | 1 | PO78718 | ||
| 15060000087000 | L15/dossiers | 15 | 15060000086999 | 15060000086999 | 1 | PO78718 | ||
| 15060000087002 | L15/dossiers | 15 | 15060000087001 | 15060000087001 | 1 | PO78718 | ||
| 15060000087004 | L15/dossiers | 15 | 15060000087003 | 15060000087003 | 1 | PO78718 | ||
| 15060000087006 | L15/dossiers | 15 | 15060000087005 | 15060000087005 | 1 | PO78718 | ||
| 15060000087008 | L15/dossiers | 15 | 15060000087007 | 15060000087007 | 1 | PO78718 | ||
| 15060000087010 | L15/dossiers | 15 | 15060000087009 | 15060000087009 | 1 | PO78718 | ||
| 15060000087012 | L15/dossiers | 15 | 15060000087011 | 15060000087011 | 1 | PO78718 | ||
| 15060000087014 | L15/dossiers | 15 | 15060000087013 | 15060000087013 | 1 | PO78718 | ||
| 15060000087016 | L15/dossiers | 15 | 15060000087015 | 15060000087015 | 1 | PO78718 | ||
| 15060000087018 | L15/dossiers | 15 | 15060000087017 | 15060000087017 | 1 | PO78718 | ||
| 15060000087020 | L15/dossiers | 15 | 15060000087019 | 15060000087019 | 1 | PO78718 | ||
| 15060000087022 | L15/dossiers | 15 | 15060000087021 | 15060000087021 | 1 | PO78718 | ||
| 15060000087024 | L15/dossiers | 15 | 15060000087023 | 15060000087023 | 1 | PO78718 | ||
| 15060000087026 | L15/dossiers | 15 | 15060000087025 | 15060000087025 | 1 | PO78718 | ||
| 15060000087028 | L15/dossiers | 15 | 15060000087027 | 15060000087027 | 1 | PO78718 | ||
| 15060000087030 | L15/dossiers | 15 | 15060000087029 | 15060000087029 | 1 | PO78718 | ||
| 15060000087032 | L15/dossiers | 15 | 15060000087031 | 15060000087031 | 1 | PO78718 | ||
| 15060000087034 | L15/dossiers | 15 | 15060000087033 | 15060000087033 | 1 | PO78718 | ||
| 15060000087036 | L15/dossiers | 15 | 15060000087035 | 15060000087035 | 1 | PO78718 | ||
| 15060000087038 | L15/dossiers | 15 | 15060000087037 | 15060000087037 | 1 | PO78718 | ||
| 15060000087040 | L15/dossiers | 15 | 15060000087039 | 15060000087039 | 1 | PO78718 | ||
| 15060000087042 | L15/dossiers | 15 | 15060000087041 | 15060000087041 | 1 | PO78718 | ||
| 15060000087044 | L15/dossiers | 15 | 15060000087043 | 15060000087043 | 1 | PO78718 | ||
| 15060000087046 | L15/dossiers | 15 | 15060000087045 | 15060000087045 | 1 | PO78718 | ||
| 15060000087048 | L15/dossiers | 15 | 15060000087047 | 15060000087047 | 1 | PO78718 | ||
| 15060000087050 | L15/dossiers | 15 | 15060000087049 | 15060000087049 | 1 | PO78718 | ||
| 15060000087052 | L15/dossiers | 15 | 15060000087051 | 15060000087051 | 1 | PO78718 | ||
| 15060000087054 | L15/dossiers | 15 | 15060000087053 | 15060000087053 | 1 | PO78718 | ||
| 15060000087056 | L15/dossiers | 15 | 15060000087055 | 15060000087055 | 1 | PO78718 | ||
| 15060000087058 | L15/dossiers | 15 | 15060000087057 | 15060000087057 | 1 | PO78718 | ||
| 15060000087060 | L15/dossiers | 15 | 15060000087059 | 15060000087059 | 1 | PO78718 | ||
| 15060000087062 | L15/dossiers | 15 | 15060000087061 | 15060000087061 | 1 | PO78718 | ||
| 15060000087064 | L15/dossiers | 15 | 15060000087063 | 15060000087063 | 1 | PO78718 | ||
| 15060000087066 | L15/dossiers | 15 | 15060000087065 | 15060000087065 | 1 | PO78718 | ||
| 15060000087068 | L15/dossiers | 15 | 15060000087067 | 15060000087067 | 1 | PO78718 | ||
| 15060000087070 | L15/dossiers | 15 | 15060000087069 | 15060000087069 | 1 | PO78718 | ||
| 15060000087072 | L15/dossiers | 15 | 15060000087071 | 15060000087071 | 1 | PO78718 | ||
| 15060000087074 | L15/dossiers | 15 | 15060000087073 | 15060000087073 | 1 | PO78718 | ||
| 15060000087076 | L15/dossiers | 15 | 15060000087075 | 15060000087075 | 1 | PO78718 | ||
| 15060000087078 | L15/dossiers | 15 | 15060000087077 | 15060000087077 | 1 | PO78718 | ||
| 15060000087080 | L15/dossiers | 15 | 15060000087079 | 15060000087079 | 1 | PO78718 | ||
| 15060000087082 | L15/dossiers | 15 | 15060000087081 | 15060000087081 | 1 | PO78718 | ||
| 15060000087084 | L15/dossiers | 15 | 15060000087083 | 15060000087083 | 1 | PO78718 | ||
| 15060000087086 | L15/dossiers | 15 | 15060000087085 | 15060000087085 | 1 | PO78718 | ||
| 15060000087088 | L15/dossiers | 15 | 15060000087087 | 15060000087087 | 1 | PO78718 | ||
| 15060000087090 | L15/dossiers | 15 | 15060000087089 | 15060000087089 | 1 | PA736239 | rapporteur | |
| 15060000087091 | L15/dossiers | 15 | 15060000087089 | 15060000087089 | 2 | PO211493 | ||
| 15060000087093 | L15/dossiers | 15 | 15060000087092 | 15060000087092 | 1 | PA703523 | rapporteur |