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 |
|---|---|---|---|---|---|---|---|---|
| 16060000087039 | L16/dossiers | 16 | 16060000087035 | 16060000087035 | 1 | PA720960 | rapporteur | |
| 16060000087040 | L16/dossiers | 16 | 16060000087035 | 16060000087035 | 2 | PO59051 | ||
| 16060000087042 | L16/dossiers | 16 | 16060000087041 | 16060000087041 | 1 | PA720022 | rapporteur | |
| 16060000087043 | L16/dossiers | 16 | 16060000087041 | 16060000087041 | 2 | PA795794 | rapporteur | |
| 16060000087044 | L16/dossiers | 16 | 16060000087041 | 16060000087041 | 3 | PO835801 | ||
| 16060000087046 | L16/dossiers | 16 | 16060000087045 | 16060000087045 | 1 | PA720342 | rapporteur | |
| 16060000087047 | L16/dossiers | 16 | 16060000087045 | 16060000087045 | 2 | PA266795 | rapporteur | |
| 16060000087048 | L16/dossiers | 16 | 16060000087045 | 16060000087045 | 3 | PO835822 | ||
| 16060000087050 | L16/dossiers | 16 | 16060000087049 | 16060000087049 | 1 | PA736201 | rapporteur | |
| 16060000087051 | L16/dossiers | 16 | 16060000087049 | 16060000087049 | 2 | PO419604 | ||
| 16060000087056 | L16/dossiers | 16 | 16060000087052 | 16060000087052 | 1 | PA793664 | rapporteur | |
| 16060000087057 | L16/dossiers | 16 | 16060000087052 | 16060000087052 | 2 | PO419610 | ||
| 16060000087059 | L16/dossiers | 16 | 16060000087058 | 16060000087058 | 1 | PA795664 | rapporteur | |
| 16060000087060 | L16/dossiers | 16 | 16060000087058 | 16060000087058 | 2 | PA794810 | rapporteur | |
| 16060000087061 | L16/dossiers | 16 | 16060000087058 | 16060000087058 | 3 | PA720146 | rapporteur | |
| 16060000087062 | L16/dossiers | 16 | 16060000087058 | 16060000087058 | 4 | PA719294 | rapporteur | |
| 16060000087063 | L16/dossiers | 16 | 16060000087058 | 16060000087058 | 5 | PO830146 | ||
| 16060000087068 | L16/dossiers | 16 | 16060000087064 | 16060000087064 | 1 | PA793708 | rapporteur | |
| 16060000087069 | L16/dossiers | 16 | 16060000087064 | 16060000087064 | 2 | PO420120 | ||
| 16060000087071 | L16/dossiers | 16 | 16060000087070 | 16060000087070 | 1 | PA794022 | rapporteur | |
| 16060000087072 | L16/dossiers | 16 | 16060000087070 | 16060000087070 | 2 | PO59051 | ||
| 16060000087077 | L16/dossiers | 16 | 16060000087073 | 16060000087073 | 1 | PA793948 | rapporteur | |
| 16060000087078 | L16/dossiers | 16 | 16060000087073 | 16060000087073 | 2 | PO419865 | ||
| 16060000087083 | L16/dossiers | 16 | 16060000087079 | 16060000087079 | 1 | PA794146 | rapporteur | |
| 16060000087084 | L16/dossiers | 16 | 16060000087079 | 16060000087079 | 2 | PO419610 | ||
| 16060000087086 | L16/dossiers | 16 | 16060000087085 | 16060000087085 | 1 | PA795362 | rapporteur | |
| 16060000087087 | L16/dossiers | 16 | 16060000087085 | 16060000087085 | 2 | PO59051 | ||
| 16060000087089 | L16/dossiers | 16 | 16060000087088 | 16060000087088 | 1 | PA794008 | rapporteur | |
| 16060000087090 | L16/dossiers | 16 | 16060000087088 | 16060000087088 | 2 | PO59048 | ||
| 16060000087092 | L16/dossiers | 16 | 16060000087091 | 16060000087091 | 1 | PA795240 | rapporteur | |
| 16060000087093 | L16/dossiers | 16 | 16060000087091 | 16060000087091 | 2 | PO59047 | ||
| 16060000087095 | L16/dossiers | 16 | 16060000087094 | 16060000087094 | 1 | PA720908 | rapporteur | |
| 16060000087096 | L16/dossiers | 16 | 16060000087094 | 16060000087094 | 2 | PO415287 | ||
| 16060000087098 | L16/dossiers | 16 | 16060000087097 | 16060000087097 | 1 | PA794214 | rapporteur | |
| 16060000087099 | L16/dossiers | 16 | 16060000087097 | 16060000087097 | 2 | PO835915 | ||
| 16060000087104 | L16/dossiers | 16 | 16060000087100 | 16060000087100 | 1 | PA721722 | rapporteur | |
| 16060000087105 | L16/dossiers | 16 | 16060000087100 | 16060000087100 | 2 | PO59051 | ||
| 16060000087110 | L16/dossiers | 16 | 16060000087106 | 16060000087106 | 1 | PA720480 | rapporteur | |
| 16060000087111 | L16/dossiers | 16 | 16060000087106 | 16060000087106 | 2 | PO420120 | ||
| 16060000087116 | L16/dossiers | 16 | 16060000087112 | 16060000087112 | 1 | PA721150 | rapporteur | |
| 16060000087117 | L16/dossiers | 16 | 16060000087112 | 16060000087112 | 2 | PO59048 | ||
| 16060000087122 | L16/dossiers | 16 | 16060000087118 | 16060000087118 | 1 | PA643048 | rapporteur | |
| 16060000087123 | L16/dossiers | 16 | 16060000087118 | 16060000087118 | 2 | PO419604 | ||
| 16060000087125 | L16/dossiers | 16 | 16060000087124 | 16060000087124 | 1 | PA722366 | rapporteur | |
| 16060000087126 | L16/dossiers | 16 | 16060000087124 | 16060000087124 | 2 | PA795144 | rapporteur | |
| 16060000087127 | L16/dossiers | 16 | 16060000087124 | 16060000087124 | 3 | PO836121 | ||
| 16060000087129 | L16/dossiers | 16 | 16060000087128 | 16060000087128 | 1 | PA722366 | rapporteur | |
| 16060000087130 | L16/dossiers | 16 | 16060000087128 | 16060000087128 | 2 | PO836135 | ||
| 16060000087132 | L16/dossiers | 16 | 16060000087131 | 16060000087131 | 1 | PA720370 | rapporteur | |
| 16060000087133 | L16/dossiers | 16 | 16060000087131 | 16060000087131 | 2 | PA719798 | rapporteur |