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 |
|---|---|---|---|---|---|---|---|---|
| 16060000054336 | L16/dossiers | 16 | 16060000054335 | 16060000054335 | 1 | PA794914 | auteur | |
| 16060000054358 | L16/dossiers | 16 | 16060000054357 | 16060000054357 | 1 | PA719024 | auteur | |
| 16060000054361 | L16/dossiers | 16 | 16060000054360 | 16060000054360 | 1 | PA795844 | auteur | |
| 16060000054457 | L16/dossiers | 16 | 16060000054456 | 16060000054456 | 1 | PA793616 | auteur | |
| 16060000054521 | L16/dossiers | 16 | 16060000054520 | 16060000054520 | 1 | PA794030 | auteur | |
| 16060000054568 | L16/dossiers | 16 | 16060000054567 | 16060000054567 | 1 | PA606098 | auteur | |
| 16060000054630 | L16/dossiers | 16 | 16060000054629 | 16060000054629 | 1 | PA794562 | auteur | |
| 16060000054691 | L16/dossiers | 16 | 16060000054690 | 16060000054690 | 1 | PA795156 | auteur | |
| 16060000054724 | L16/dossiers | 16 | 16060000054723 | 16060000054723 | 1 | PA795808 | auteur | |
| 16060000054780 | L16/dossiers | 16 | 16060000054779 | 16060000054779 | 1 | PA2952 | auteur | |
| 16060000054783 | L16/dossiers | 16 | 16060000054782 | 16060000054782 | 1 | PA774954 | auteur | |
| 16060000054805 | L16/dossiers | 16 | 16060000054804 | 16060000054804 | 1 | PA266788 | auteur | |
| 16060000054820 | L16/dossiers | 16 | 16060000054819 | 16060000054819 | 1 | PA793394 | auteur | |
| 16060000054842 | L16/dossiers | 16 | 16060000054841 | 16060000054841 | 1 | PA720468 | auteur | |
| 16060000054911 | L16/dossiers | 16 | 16060000054910 | 16060000054910 | 1 | PA720684 | auteur | |
| 16060000054917 | L16/dossiers | 16 | 16060000054916 | 16060000054916 | 1 | PA2952 | auteur | |
| 16060000054920 | L16/dossiers | 16 | 16060000054919 | 16060000054919 | 1 | PA794270 | auteur | |
| 16060000054953 | L16/dossiers | 16 | 16060000054952 | 16060000054952 | 1 | PA330240 | auteur | |
| 16060000054956 | L16/dossiers | 16 | 16060000054955 | 16060000054955 | 1 | PA1327 | auteur | |
| 16060000054966 | L16/dossiers | 16 | 16060000054965 | 16060000054965 | 1 | PA793122 | auteur | |
| 16060000055000 | L16/dossiers | 16 | 16060000054999 | 16060000054999 | 1 | PO791932 | ||
| 16060000055003 | L16/dossiers | 16 | 16060000055002 | 16060000055002 | 1 | PO791932 | ||
| 16060000055006 | L16/dossiers | 16 | 16060000055005 | 16060000055005 | 1 | PO791932 | ||
| 16060000055009 | L16/dossiers | 16 | 16060000055008 | 16060000055008 | 1 | PO791932 | ||
| 16060000055012 | L16/dossiers | 16 | 16060000055011 | 16060000055011 | 1 | PO791932 | ||
| 16060000055015 | L16/dossiers | 16 | 16060000055014 | 16060000055014 | 1 | PA795310 | auteur | |
| 16060000055091 | L16/dossiers | 16 | 16060000055090 | 16060000055090 | 1 | PO791932 | ||
| 16060000055093 | L16/dossiers | 16 | 16060000055092 | 16060000055092 | 1 | PO791932 | ||
| 16060000055096 | L16/dossiers | 16 | 16060000055095 | 16060000055095 | 1 | PO791932 | ||
| 16060000055099 | L16/dossiers | 16 | 16060000055098 | 16060000055098 | 1 | PO791932 | ||
| 16060000055102 | L16/dossiers | 16 | 16060000055101 | 16060000055101 | 1 | PO791932 | ||
| 16060000055105 | L16/dossiers | 16 | 16060000055104 | 16060000055104 | 1 | PO791932 | ||
| 16060000055108 | L16/dossiers | 16 | 16060000055107 | 16060000055107 | 1 | PO791932 | ||
| 16060000055111 | L16/dossiers | 16 | 16060000055110 | 16060000055110 | 1 | PO791932 | ||
| 16060000055114 | L16/dossiers | 16 | 16060000055113 | 16060000055113 | 1 | PO791932 | ||
| 16060000055117 | L16/dossiers | 16 | 16060000055116 | 16060000055116 | 1 | PO791932 | ||
| 16060000055120 | L16/dossiers | 16 | 16060000055119 | 16060000055119 | 1 | PO791932 | ||
| 16060000055123 | L16/dossiers | 16 | 16060000055122 | 16060000055122 | 1 | PO791932 | ||
| 16060000055126 | L16/dossiers | 16 | 16060000055125 | 16060000055125 | 1 | PO791932 | ||
| 16060000055129 | L16/dossiers | 16 | 16060000055128 | 16060000055128 | 1 | PO791932 | ||
| 16060000055132 | L16/dossiers | 16 | 16060000055131 | 16060000055131 | 1 | PO791932 | ||
| 16060000055135 | L16/dossiers | 16 | 16060000055134 | 16060000055134 | 1 | PO791932 | ||
| 16060000055138 | L16/dossiers | 16 | 16060000055137 | 16060000055137 | 1 | PO791932 | ||
| 16060000055141 | L16/dossiers | 16 | 16060000055140 | 16060000055140 | 1 | PO791932 | ||
| 16060000055144 | L16/dossiers | 16 | 16060000055143 | 16060000055143 | 1 | PO791932 | ||
| 16060000055147 | L16/dossiers | 16 | 16060000055146 | 16060000055146 | 1 | PO791932 | ||
| 16060000055150 | L16/dossiers | 16 | 16060000055149 | 16060000055149 | 1 | PO791932 | ||
| 16060000055153 | L16/dossiers | 16 | 16060000055152 | 16060000055152 | 1 | PO791932 | ||
| 16060000055156 | L16/dossiers | 16 | 16060000055155 | 16060000055155 | 1 | PO791932 | ||
| 16060000055159 | L16/dossiers | 16 | 16060000055158 | 16060000055158 | 1 | PO791932 |