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 |
|---|---|---|---|---|---|---|---|---|
| 14060000039671 | L14/dossiers | 14 | 14060000039670 | 14060000039670 | 1 | PA2603 | rapporteur | |
| 14060000039672 | L14/dossiers | 14 | 14060000039670 | 14060000039670 | 2 | PO713684 | ||
| 14060000039674 | L14/dossiers | 14 | 14060000039673 | 14060000039673 | 1 | PA606098 | auteur | |
| 14060000039699 | L14/dossiers | 14 | 14060000039698 | 14060000039698 | 1 | PA334654 | auteur | |
| 14060000039772 | L14/dossiers | 14 | 14060000039771 | 14060000039771 | 1 | PA267622 | auteur | |
| 14060000039776 | L14/dossiers | 14 | 14060000039775 | 14060000039775 | 1 | PA330684 | auteur | |
| 14060000039792 | L14/dossiers | 14 | 14060000039791 | 14060000039791 | 1 | PA267622 | auteur | |
| 14060000039794 | L14/dossiers | 14 | 14060000039793 | 14060000039793 | 1 | PA605703 | auteur | |
| 14060000039801 | L14/dossiers | 14 | 14060000039800 | 14060000039800 | 1 | PA569 | rapporteur | |
| 14060000039802 | L14/dossiers | 14 | 14060000039800 | 14060000039800 | 2 | PO211490 | ||
| 14060000039804 | L14/dossiers | 14 | 14060000039803 | 14060000039803 | 1 | PA1353 | rapporteur | |
| 14060000039805 | L14/dossiers | 14 | 14060000039803 | 14060000039803 | 2 | PO706223 | ||
| 14060000039807 | L14/dossiers | 14 | 14060000039806 | 14060000039806 | 1 | PA1353 | rapporteur | |
| 14060000039808 | L14/dossiers | 14 | 14060000039806 | 14060000039806 | 2 | PO419604 | ||
| 14060000039810 | L14/dossiers | 14 | 14060000039809 | 14060000039809 | 1 | PA569 | rapporteur | |
| 14060000039811 | L14/dossiers | 14 | 14060000039809 | 14060000039809 | 2 | PO706223 | ||
| 14060000039813 | L14/dossiers | 14 | 14060000039812 | 14060000039812 | 1 | PA1886 | auteur | |
| 14060000039951 | L14/dossiers | 14 | 14060000039950 | 14060000039950 | 1 | PA1353 | rapporteur | |
| 14060000039952 | L14/dossiers | 14 | 14060000039950 | 14060000039950 | 2 | PO419604 | ||
| 14060000039955 | L14/dossiers | 14 | 14060000039954 | 14060000039954 | 1 | PO644420 | ||
| 14060000039958 | L14/dossiers | 14 | 14060000039957 | 14060000039957 | 1 | PO78718 | ||
| 14060000039960 | L14/dossiers | 14 | 14060000039959 | 14060000039959 | 1 | PA334149 | auteur | |
| 14060000040000 | L14/dossiers | 14 | 14060000039999 | 14060000039999 | 1 | PA785 | auteur | |
| 14060000040003 | L14/dossiers | 14 | 14060000040002 | 14060000040002 | 1 | PA785 | auteur | |
| 14060000040005 | L14/dossiers | 14 | 14060000040004 | 14060000040004 | 1 | PA785 | auteur | |
| 14060000040007 | L14/dossiers | 14 | 14060000040006 | 14060000040006 | 1 | PA2690 | auteur | |
| 14060000040011 | L14/dossiers | 14 | 14060000040010 | 14060000040010 | 1 | PA875 | rapporteur | |
| 14060000040012 | L14/dossiers | 14 | 14060000040010 | 14060000040010 | 2 | PO273589 | ||
| 14060000040014 | L14/dossiers | 14 | 14060000040013 | 14060000040013 | 1 | PA332228 | rapporteur | |
| 14060000040015 | L14/dossiers | 14 | 14060000040013 | 14060000040013 | 2 | PO420120 | ||
| 14060000040017 | L14/dossiers | 14 | 14060000040016 | 14060000040016 | 1 | PA332228 | rapporteur | |
| 14060000040018 | L14/dossiers | 14 | 14060000040016 | 14060000040016 | 2 | PO420120 | ||
| 14060000040020 | L14/dossiers | 14 | 14060000040019 | 14060000040019 | 1 | PA332228 | auteur | |
| 14060000040025 | L14/dossiers | 14 | 14060000040024 | 14060000040024 | 1 | PA330684 | auteur | |
| 14060000040041 | L14/dossiers | 14 | 14060000040040 | 14060000040040 | 1 | PA736225 | rapporteur | |
| 14060000040042 | L14/dossiers | 14 | 14060000040040 | 14060000040040 | 2 | PO211493 | ||
| 14060000040044 | L14/dossiers | 14 | 14060000040043 | 14060000040043 | 1 | PO717460 | ||
| 14060000040047 | L14/dossiers | 14 | 14060000040046 | 14060000040046 | 1 | PA415488 | auteur | |
| 14060000040050 | L14/dossiers | 14 | 14060000040049 | 14060000040049 | 1 | PA606478 | auteur | |
| 14060000040114 | L14/dossiers | 14 | 14060000040113 | 14060000040113 | 1 | PA335054 | rapporteur | |
| 14060000040115 | L14/dossiers | 14 | 14060000040113 | 14060000040113 | 2 | PO415287 | ||
| 14060000040117 | L14/dossiers | 14 | 14060000040116 | 14060000040116 | 1 | PA328 | auteur | |
| 14060000040120 | L14/dossiers | 14 | 14060000040119 | 14060000040119 | 1 | PA1401 | rapporteur | |
| 14060000040121 | L14/dossiers | 14 | 14060000040119 | 14060000040119 | 2 | PO59051 | ||
| 14060000040124 | L14/dossiers | 14 | 14060000040123 | 14060000040123 | 1 | PO78718 | ||
| 14060000040126 | L14/dossiers | 14 | 14060000040125 | 14060000040125 | 1 | PO644420 | ||
| 14060000040129 | L14/dossiers | 14 | 14060000040128 | 14060000040128 | 1 | PA1515 | rapporteur | |
| 14060000040130 | L14/dossiers | 14 | 14060000040128 | 14060000040128 | 2 | PO211495 | ||
| 14060000040132 | L14/dossiers | 14 | 14060000040131 | 14060000040131 | 1 | PA1515 | rapporteur | |
| 14060000040133 | L14/dossiers | 14 | 14060000040131 | 14060000040131 | 2 | PO686534 |