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 |
|---|---|---|---|---|---|---|---|---|
| 17060000112079 | L17/dossiers | 17 | 17060000112077 | 17060000112077 | 2 | PO59048 | ||
| 17060000112081 | L17/dossiers | 17 | 17060000112080 | 17060000112080 | 1 | PA720146 | rapporteur | |
| 17060000112082 | L17/dossiers | 17 | 17060000112080 | 17060000112080 | 2 | PO59048 | ||
| 17060000112084 | L17/dossiers | 17 | 17060000112083 | 17060000112083 | 1 | PA795528 | rapporteur | |
| 17060000112085 | L17/dossiers | 17 | 17060000112083 | 17060000112083 | 2 | PO59048 | ||
| 17060000112087 | L17/dossiers | 17 | 17060000112086 | 17060000112086 | 1 | PA841563 | rapporteur | |
| 17060000112088 | L17/dossiers | 17 | 17060000112086 | 17060000112086 | 2 | PA610002 | rapporteur | |
| 17060000112089 | L17/dossiers | 17 | 17060000112086 | 17060000112086 | 3 | PO59048 | ||
| 17060000112091 | L17/dossiers | 17 | 17060000112090 | 17060000112090 | 1 | PA346782 | rapporteur | |
| 17060000112092 | L17/dossiers | 17 | 17060000112090 | 17060000112090 | 2 | PO59048 | ||
| 17060000112094 | L17/dossiers | 17 | 17060000112093 | 17060000112093 | 1 | PA721426 | rapporteur | |
| 17060000112095 | L17/dossiers | 17 | 17060000112093 | 17060000112093 | 2 | PO201269 | ||
| 17060000112097 | L17/dossiers | 17 | 17060000112096 | 17060000112096 | 1 | PA720038 | rapporteur | |
| 17060000112098 | L17/dossiers | 17 | 17060000112096 | 17060000112096 | 2 | PA795108 | rapporteur | |
| 17060000112099 | L17/dossiers | 17 | 17060000112096 | 17060000112096 | 3 | PO201269 | ||
| 17060000112101 | L17/dossiers | 17 | 17060000112100 | 17060000112100 | 1 | PA841487 | rapporteur | |
| 17060000112102 | L17/dossiers | 17 | 17060000112100 | 17060000112100 | 2 | PO59048 | ||
| 17060000112104 | L17/dossiers | 17 | 17060000112103 | 17060000112103 | 1 | PA642847 | rapporteur | |
| 17060000112105 | L17/dossiers | 17 | 17060000112103 | 17060000112103 | 2 | PA1567 | rapporteur | |
| 17060000112106 | L17/dossiers | 17 | 17060000112103 | 17060000112103 | 3 | PA794678 | rapporteur | |
| 17060000112107 | L17/dossiers | 17 | 17060000112103 | 17060000112103 | 4 | PO847238 | ||
| 17060000112109 | L17/dossiers | 17 | 17060000112108 | 17060000112108 | 1 | PA795454 | rapporteur | |
| 17060000112110 | L17/dossiers | 17 | 17060000112108 | 17060000112108 | 2 | PA719640 | rapporteur | |
| 17060000112111 | L17/dossiers | 17 | 17060000112108 | 17060000112108 | 3 | PO870864 | ||
| 17060000112113 | L17/dossiers | 17 | 17060000112112 | 17060000112112 | 1 | PA722284 | rapporteur | |
| 17060000112114 | L17/dossiers | 17 | 17060000112112 | 17060000112112 | 2 | PO59047 | ||
| 17060000112116 | L17/dossiers | 17 | 17060000112115 | 17060000112115 | 1 | PA794198 | rapporteur | |
| 17060000112117 | L17/dossiers | 17 | 17060000112115 | 17060000112115 | 2 | PA720190 | rapporteur | |
| 17060000112118 | L17/dossiers | 17 | 17060000112115 | 17060000112115 | 3 | PO419604 | ||
| 17060000112120 | L17/dossiers | 17 | 17060000112119 | 17060000112119 | 1 | PA720354 | rapporteur | |
| 17060000112121 | L17/dossiers | 17 | 17060000112119 | 17060000112119 | 2 | PO59046 | ||
| 17060000112123 | L17/dossiers | 17 | 17060000112122 | 17060000112122 | 1 | PA795100 | rapporteur | |
| 17060000112124 | L17/dossiers | 17 | 17060000112122 | 17060000112122 | 2 | PA840657 | rapporteur | |
| 17060000112125 | L17/dossiers | 17 | 17060000112122 | 17060000112122 | 3 | PO59051 | ||
| 17060000112127 | L17/dossiers | 17 | 17060000112126 | 17060000112126 | 1 | PA1592 | rapporteur | |
| 17060000112128 | L17/dossiers | 17 | 17060000112126 | 17060000112126 | 2 | PA267794 | rapporteur | |
| 17060000112129 | L17/dossiers | 17 | 17060000112126 | 17060000112126 | 3 | PO871239 | ||
| 17060000112131 | L17/dossiers | 17 | 17060000112130 | 17060000112130 | 1 | PO838901 | ||
| 17060000112133 | L17/dossiers | 17 | 17060000112132 | 17060000112132 | 1 | PO838901 | ||
| 17060000112135 | L17/dossiers | 17 | 17060000112134 | 17060000112134 | 1 | PO838901 | ||
| 17060000112137 | L17/dossiers | 17 | 17060000112136 | 17060000112136 | 1 | PO838901 | ||
| 17060000112139 | L17/dossiers | 17 | 17060000112138 | 17060000112138 | 1 | PO838901 | ||
| 17060000112141 | L17/dossiers | 17 | 17060000112140 | 17060000112140 | 1 | PO838901 | ||
| 17060000112143 | L17/dossiers | 17 | 17060000112142 | 17060000112142 | 1 | PO838901 | ||
| 17060000112145 | L17/dossiers | 17 | 17060000112144 | 17060000112144 | 1 | PO838901 | ||
| 17060000112147 | L17/dossiers | 17 | 17060000112146 | 17060000112146 | 1 | PO838901 | ||
| 17060000112149 | L17/dossiers | 17 | 17060000112148 | 17060000112148 | 1 | PO838901 | ||
| 17060000112151 | L17/dossiers | 17 | 17060000112150 | 17060000112150 | 1 | PO838901 | ||
| 17060000112153 | L17/dossiers | 17 | 17060000112152 | 17060000112152 | 1 | PO838901 | ||
| 17060000112155 | L17/dossiers | 17 | 17060000112154 | 17060000112154 | 1 | PO838901 |