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 |
|---|---|---|---|---|---|---|---|---|
| 14060000085123 | L14/dossiers | 14 | 14060000085122 | 14060000085122 | 1 | PA2056 | rapporteur | |
| 14060000085124 | L14/dossiers | 14 | 14060000085122 | 14060000085122 | 2 | PO211494 | ||
| 14060000085126 | L14/dossiers | 14 | 14060000085125 | 14060000085125 | 1 | PA606631 | rapporteur | |
| 14060000085127 | L14/dossiers | 14 | 14060000085125 | 14060000085125 | 2 | PO59051 | ||
| 14060000085129 | L14/dossiers | 14 | 14060000085128 | 14060000085128 | 1 | PA606631 | rapporteur | |
| 14060000085130 | L14/dossiers | 14 | 14060000085128 | 14060000085128 | 2 | PO59051 | ||
| 14060000085133 | L14/dossiers | 14 | 14060000085132 | 14060000085132 | 1 | PO644420 | ||
| 14060000085136 | L14/dossiers | 14 | 14060000085135 | 14060000085135 | 1 | PA2056 | auteur | |
| 14060000085137 | L14/dossiers | 14 | 14060000085135 | 14060000085135 | 2 | PA270 | auteur | |
| 14060000085139 | L14/dossiers | 14 | 14060000085138 | 14060000085138 | 1 | PA267306 | auteur | |
| 14060000085150 | L14/dossiers | 14 | 14060000085149 | 14060000085149 | 1 | PA314 | rapporteur | |
| 14060000085151 | L14/dossiers | 14 | 14060000085149 | 14060000085149 | 2 | PA606375 | rapporteur | |
| 14060000085152 | L14/dossiers | 14 | 14060000085149 | 14060000085149 | 3 | PO59046 | ||
| 14060000085154 | L14/dossiers | 14 | 14060000085153 | 14060000085153 | 1 | PA267743 | auteur | |
| 14060000085202 | L14/dossiers | 14 | 14060000085201 | 14060000085201 | 1 | PA703494 | rapporteur | |
| 14060000085203 | L14/dossiers | 14 | 14060000085201 | 14060000085201 | 2 | PO211495 | ||
| 14060000085205 | L14/dossiers | 14 | 14060000085204 | 14060000085204 | 1 | PA330357 | rapporteur | |
| 14060000085206 | L14/dossiers | 14 | 14060000085204 | 14060000085204 | 2 | PO59051 | ||
| 14060000085208 | L14/dossiers | 14 | 14060000085207 | 14060000085207 | 1 | PA2774 | auteur | |
| 14060000085210 | L14/dossiers | 14 | 14060000085209 | 14060000085209 | 1 | PO644420 | ||
| 14060000085213 | L14/dossiers | 14 | 14060000085212 | 14060000085212 | 1 | PA330357 | rapporteur | |
| 14060000085214 | L14/dossiers | 14 | 14060000085212 | 14060000085212 | 2 | PO59051 | ||
| 14060000085217 | L14/dossiers | 14 | 14060000085216 | 14060000085216 | 1 | PA2713 | auteur | |
| 14060000085234 | L14/dossiers | 14 | 14060000085233 | 14060000085233 | 1 | PA267695 | rapporteur | |
| 14060000085235 | L14/dossiers | 14 | 14060000085233 | 14060000085233 | 2 | PO402232 | ||
| 14060000085237 | L14/dossiers | 14 | 14060000085236 | 14060000085236 | 1 | PA330008 | rapporteur | |
| 14060000085238 | L14/dossiers | 14 | 14060000085236 | 14060000085236 | 2 | PA330981 | rapporteur | |
| 14060000085239 | L14/dossiers | 14 | 14060000085236 | 14060000085236 | 3 | PO420375 | ||
| 14060000085241 | L14/dossiers | 14 | 14060000085240 | 14060000085240 | 1 | PA335054 | auteur | |
| 14060000085244 | L14/dossiers | 14 | 14060000085243 | 14060000085243 | 1 | PA267622 | auteur | |
| 14060000085248 | L14/dossiers | 14 | 14060000085247 | 14060000085247 | 1 | PA610002 | rapporteur | |
| 14060000085249 | L14/dossiers | 14 | 14060000085247 | 14060000085247 | 2 | PO59048 | ||
| 14060000085251 | L14/dossiers | 14 | 14060000085250 | 14060000085250 | 1 | PA415447 | rapporteur | |
| 14060000085252 | L14/dossiers | 14 | 14060000085250 | 14060000085250 | 2 | PO211494 | ||
| 14060000085254 | L14/dossiers | 14 | 14060000085253 | 14060000085253 | 1 | PA610002 | rapporteur | |
| 14060000085255 | L14/dossiers | 14 | 14060000085253 | 14060000085253 | 2 | PO59048 | ||
| 14060000085258 | L14/dossiers | 14 | 14060000085257 | 14060000085257 | 1 | PO78718 | ||
| 14060000085260 | L14/dossiers | 14 | 14060000085259 | 14060000085259 | 1 | PA610002 | auteur | |
| 14060000085280 | L14/dossiers | 14 | 14060000085279 | 14060000085279 | 1 | PA1886 | auteur | |
| 14060000085560 | L14/dossiers | 14 | 14060000085559 | 14060000085559 | 1 | PA608186 | rapporteur | |
| 14060000085561 | L14/dossiers | 14 | 14060000085559 | 14060000085559 | 2 | PO415287 | ||
| 14060000085563 | L14/dossiers | 14 | 14060000085562 | 14060000085562 | 1 | PA2161 | rapporteur | |
| 14060000085564 | L14/dossiers | 14 | 14060000085562 | 14060000085562 | 2 | PO211495 | ||
| 14060000085566 | L14/dossiers | 14 | 14060000085565 | 14060000085565 | 1 | PA429858 | auteur | |
| 14060000085572 | L14/dossiers | 14 | 14060000085571 | 14060000085571 | 1 | PO644420 | ||
| 14060000085575 | L14/dossiers | 14 | 14060000085574 | 14060000085574 | 1 | PA606991 | rapporteur | |
| 14060000085576 | L14/dossiers | 14 | 14060000085574 | 14060000085574 | 2 | PA1699 | rapporteur | |
| 14060000085577 | L14/dossiers | 14 | 14060000085574 | 14060000085574 | 3 | PO420120 | ||
| 14060000085579 | L14/dossiers | 14 | 14060000085578 | 14060000085578 | 1 | PA1654 | auteur | |
| 14060000085584 | L14/dossiers | 14 | 14060000085583 | 14060000085583 | 1 | PA346886 | auteur |