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 |
|---|---|---|---|---|---|---|---|---|
| 16060000086059 | L16/dossiers | 16 | 16060000086058 | 16060000086058 | 1 | PA720354 | rapporteur | |
| 16060000086060 | L16/dossiers | 16 | 16060000086058 | 16060000086058 | 2 | PA719822 | rapporteur | |
| 16060000086061 | L16/dossiers | 16 | 16060000086058 | 16060000086058 | 3 | PO826014 | ||
| 16060000086063 | L16/dossiers | 16 | 16060000086062 | 16060000086062 | 1 | PA722366 | rapporteur | |
| 16060000086064 | L16/dossiers | 16 | 16060000086062 | 16060000086062 | 2 | PA736200 | rapporteur | |
| 16060000086065 | L16/dossiers | 16 | 16060000086062 | 16060000086062 | 3 | PO273589 | ||
| 16060000086067 | L16/dossiers | 16 | 16060000086066 | 16060000086066 | 1 | PA796018 | rapporteur | |
| 16060000086068 | L16/dossiers | 16 | 16060000086066 | 16060000086066 | 2 | PO817720 | ||
| 16060000086070 | L16/dossiers | 16 | 16060000086069 | 16060000086069 | 1 | PA719404 | rapporteur | |
| 16060000086071 | L16/dossiers | 16 | 16060000086069 | 16060000086069 | 2 | PO420120 | ||
| 16060000086073 | L16/dossiers | 16 | 16060000086072 | 16060000086072 | 1 | PA642847 | rapporteur | |
| 16060000086074 | L16/dossiers | 16 | 16060000086072 | 16060000086072 | 2 | PO420120 | ||
| 16060000086079 | L16/dossiers | 16 | 16060000086075 | 16060000086075 | 1 | PA721608 | rapporteur | |
| 16060000086080 | L16/dossiers | 16 | 16060000086075 | 16060000086075 | 2 | PO59047 | ||
| 16060000086082 | L16/dossiers | 16 | 16060000086081 | 16060000086081 | 1 | PA720728 | rapporteur | |
| 16060000086083 | L16/dossiers | 16 | 16060000086081 | 16060000086081 | 2 | PO419610 | ||
| 16060000086085 | L16/dossiers | 16 | 16060000086084 | 16060000086084 | 1 | PA335612 | rapporteur | |
| 16060000086086 | L16/dossiers | 16 | 16060000086084 | 16060000086084 | 2 | PO59047 | ||
| 16060000086088 | L16/dossiers | 16 | 16060000086087 | 16060000086087 | 1 | PA795828 | rapporteur | |
| 16060000086089 | L16/dossiers | 16 | 16060000086087 | 16060000086087 | 2 | PO820615 | ||
| 16060000086091 | L16/dossiers | 16 | 16060000086090 | 16060000086090 | 1 | PA795326 | rapporteur | |
| 16060000086092 | L16/dossiers | 16 | 16060000086090 | 16060000086090 | 2 | PO59047 | ||
| 16060000086098 | L16/dossiers | 16 | 16060000086093 | 16060000086093 | 1 | PA642868 | rapporteur | |
| 16060000086099 | L16/dossiers | 16 | 16060000086093 | 16060000086093 | 2 | PA719756 | rapporteur | |
| 16060000086100 | L16/dossiers | 16 | 16060000086093 | 16060000086093 | 3 | PO420120 | ||
| 16060000086109 | L16/dossiers | 16 | 16060000086101 | 16060000086101 | 1 | PA795664 | rapporteur | |
| 16060000086110 | L16/dossiers | 16 | 16060000086101 | 16060000086101 | 2 | PA794810 | rapporteur | |
| 16060000086111 | L16/dossiers | 16 | 16060000086101 | 16060000086101 | 3 | PA794426 | rapporteur | |
| 16060000086112 | L16/dossiers | 16 | 16060000086101 | 16060000086101 | 4 | PA719294 | rapporteur | |
| 16060000086113 | L16/dossiers | 16 | 16060000086101 | 16060000086101 | 5 | PA720146 | rapporteur | |
| 16060000086114 | L16/dossiers | 16 | 16060000086101 | 16060000086101 | 6 | PO826232 | ||
| 16060000086125 | L16/dossiers | 16 | 16060000086115 | 16060000086115 | 1 | PA719472 | rapporteur | |
| 16060000086126 | L16/dossiers | 16 | 16060000086115 | 16060000086115 | 2 | PO59048 | ||
| 16060000086131 | L16/dossiers | 16 | 16060000086127 | 16060000086127 | 1 | PA795652 | rapporteur | |
| 16060000086132 | L16/dossiers | 16 | 16060000086127 | 16060000086127 | 2 | PO419610 | ||
| 16060000086134 | L16/dossiers | 16 | 16060000086133 | 16060000086133 | 1 | PA793314 | rapporteur | |
| 16060000086135 | L16/dossiers | 16 | 16060000086133 | 16060000086133 | 2 | PO59051 | ||
| 16060000086137 | L16/dossiers | 16 | 16060000086136 | 16060000086136 | 1 | PA722150 | rapporteur | |
| 16060000086138 | L16/dossiers | 16 | 16060000086136 | 16060000086136 | 2 | PO402232 | ||
| 16060000086143 | L16/dossiers | 16 | 16060000086139 | 16060000086139 | 1 | PA720754 | rapporteur | |
| 16060000086144 | L16/dossiers | 16 | 16060000086139 | 16060000086139 | 2 | PO59051 | ||
| 16060000086146 | L16/dossiers | 16 | 16060000086145 | 16060000086145 | 1 | PA642988 | rapporteur | |
| 16060000086147 | L16/dossiers | 16 | 16060000086145 | 16060000086145 | 2 | PO419604 | ||
| 16060000086149 | L16/dossiers | 16 | 16060000086148 | 16060000086148 | 1 | PA794590 | rapporteur | |
| 16060000086150 | L16/dossiers | 16 | 16060000086148 | 16060000086148 | 2 | PO419610 | ||
| 16060000086152 | L16/dossiers | 16 | 16060000086151 | 16060000086151 | 1 | PA793382 | rapporteur | |
| 16060000086153 | L16/dossiers | 16 | 16060000086151 | 16060000086151 | 2 | PO420120 | ||
| 16060000086158 | L16/dossiers | 16 | 16060000086154 | 16060000086154 | 1 | PA774960 | rapporteur | |
| 16060000086159 | L16/dossiers | 16 | 16060000086154 | 16060000086154 | 2 | PO59051 | ||
| 16060000086161 | L16/dossiers | 16 | 16060000086160 | 16060000086160 | 1 | PA793330 | rapporteur |