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 |
|---|---|---|---|---|---|---|---|---|
| 15060000115057 | L15/dossiers | 15 | 15060000115054 | 15060000115054 | 3 | PA702052 | rapporteur | |
| 15060000115058 | L15/dossiers | 15 | 15060000115054 | 15060000115054 | 4 | PO59051 | ||
| 15060000115064 | L15/dossiers | 15 | 15060000115063 | 15060000115063 | 1 | PA721836 | rapporteur | |
| 15060000115065 | L15/dossiers | 15 | 15060000115063 | 15060000115063 | 2 | PA721542 | rapporteur | |
| 15060000115066 | L15/dossiers | 15 | 15060000115063 | 15060000115063 | 3 | PO786857 | ||
| 15060000115069 | L15/dossiers | 15 | 15060000115068 | 15060000115068 | 1 | PA2449 | rapporteur | |
| 15060000115070 | L15/dossiers | 15 | 15060000115068 | 15060000115068 | 2 | PO59051 | ||
| 15060000115073 | L15/dossiers | 15 | 15060000115072 | 15060000115072 | 1 | PA720170 | rapporteur | |
| 15060000115074 | L15/dossiers | 15 | 15060000115072 | 15060000115072 | 2 | PO787461 | ||
| 15060000115076 | L15/dossiers | 15 | 15060000115075 | 15060000115075 | 1 | PA720862 | rapporteur | |
| 15060000115077 | L15/dossiers | 15 | 15060000115075 | 15060000115075 | 2 | PO419610 | ||
| 15060000115080 | L15/dossiers | 15 | 15060000115079 | 15060000115079 | 1 | PA722090 | rapporteur | |
| 15060000115081 | L15/dossiers | 15 | 15060000115079 | 15060000115079 | 2 | PO788291 | ||
| 15060000115083 | L15/dossiers | 15 | 15060000115082 | 15060000115082 | 1 | PA722336 | rapporteur | |
| 15060000115084 | L15/dossiers | 15 | 15060000115082 | 15060000115082 | 2 | PO419865 | ||
| 15060000115087 | L15/dossiers | 15 | 15060000115086 | 15060000115086 | 1 | PA2449 | rapporteur | |
| 15060000115088 | L15/dossiers | 15 | 15060000115086 | 15060000115086 | 2 | PO59051 | ||
| 15060000115091 | L15/dossiers | 15 | 15060000115090 | 15060000115090 | 1 | PA719814 | rapporteur | |
| 15060000115092 | L15/dossiers | 15 | 15060000115090 | 15060000115090 | 2 | PO419604 | ||
| 15060000115095 | L15/dossiers | 15 | 15060000115094 | 15060000115094 | 1 | PA721542 | rapporteur | |
| 15060000115096 | L15/dossiers | 15 | 15060000115094 | 15060000115094 | 2 | PO788753 | ||
| 15060000115098 | L15/dossiers | 15 | 15060000115097 | 15060000115097 | 1 | PA643127 | rapporteur | |
| 15060000115099 | L15/dossiers | 15 | 15060000115097 | 15060000115097 | 2 | PA719874 | rapporteur | |
| 15060000115100 | L15/dossiers | 15 | 15060000115097 | 15060000115097 | 3 | PA702052 | rapporteur | |
| 15060000115101 | L15/dossiers | 15 | 15060000115097 | 15060000115097 | 4 | PO788650 | ||
| 15060000115103 | L15/dossiers | 15 | 15060000115102 | 15060000115102 | 1 | PA719668 | rapporteur | |
| 15060000115104 | L15/dossiers | 15 | 15060000115102 | 15060000115102 | 2 | PO789233 | ||
| 15060000115106 | L15/dossiers | 15 | 15060000115105 | 15060000115105 | 1 | PA720862 | rapporteur | |
| 15060000115107 | L15/dossiers | 15 | 15060000115105 | 15060000115105 | 2 | PO789667 | ||
| 15060000115109 | L15/dossiers | 15 | 15060000115108 | 15060000115108 | 1 | PO717460 | ||
| 15060000115112 | L15/dossiers | 15 | 15060000115111 | 15060000115111 | 1 | PO717460 | ||
| 15060000115115 | L15/dossiers | 15 | 15060000115114 | 15060000115114 | 1 | PO717460 | ||
| 15060000115119 | L15/dossiers | 15 | 15060000115118 | 15060000115118 | 1 | PO717460 | ||
| 15060000115122 | L15/dossiers | 15 | 15060000115121 | 15060000115121 | 1 | PO717460 | ||
| 15060000115125 | L15/dossiers | 15 | 15060000115124 | 15060000115124 | 1 | PO717460 | ||
| 15060000115128 | L15/dossiers | 15 | 15060000115127 | 15060000115127 | 1 | PO717460 | ||
| 15060000115131 | L15/dossiers | 15 | 15060000115130 | 15060000115130 | 1 | PO717460 | ||
| 15060000115133 | L15/dossiers | 15 | 15060000115132 | 15060000115132 | 1 | PO717460 | ||
| 15060000115136 | L15/dossiers | 15 | 15060000115135 | 15060000115135 | 1 | PO717460 | ||
| 15060000115140 | L15/dossiers | 15 | 15060000115139 | 15060000115139 | 1 | PO717460 | ||
| 15060000115143 | L15/dossiers | 15 | 15060000115142 | 15060000115142 | 1 | PO717460 | ||
| 15060000115146 | L15/dossiers | 15 | 15060000115145 | 15060000115145 | 1 | PO717460 | ||
| 15060000115151 | L15/dossiers | 15 | 15060000115150 | 15060000115150 | 1 | PO717460 | ||
| 15060000115154 | L15/dossiers | 15 | 15060000115153 | 15060000115153 | 1 | PO717460 | ||
| 15060000115157 | L15/dossiers | 15 | 15060000115156 | 15060000115156 | 1 | PO717460 | ||
| 15060000115160 | L15/dossiers | 15 | 15060000115159 | 15060000115159 | 1 | PO717460 | ||
| 15060000115163 | L15/dossiers | 15 | 15060000115162 | 15060000115162 | 1 | PO717460 | ||
| 15060000115166 | L15/dossiers | 15 | 15060000115165 | 15060000115165 | 1 | PO717460 | ||
| 15060000115168 | L15/dossiers | 15 | 15060000115167 | 15060000115167 | 1 | PO717460 | ||
| 15060000115170 | L15/dossiers | 15 | 15060000115169 | 15060000115169 | 1 | PO717460 |