dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
60 224 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 72 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 72 %, 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 58 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 14060000085587 | L14/dossiers | 14 | 14060000085586 | 14060000085586 | 1 | PA2250 | auteur | |
| 14060000085609 | L14/dossiers | 14 | 14060000085608 | 14060000085608 | 1 | PA1020 | auteur | |
| 14060000085618 | L14/dossiers | 14 | 14060000085617 | 14060000085617 | 1 | PA1152 | auteur | |
| 14060000085642 | L14/dossiers | 14 | 14060000085641 | 14060000085641 | 1 | PA267797 | auteur | |
| 14060000085747 | L14/dossiers | 14 | 14060000085746 | 14060000085746 | 1 | PA2631 | rapporteur | |
| 14060000085748 | L14/dossiers | 14 | 14060000085746 | 14060000085746 | 2 | PO304272 | ||
| 14060000085750 | L14/dossiers | 14 | 14060000085749 | 14060000085749 | 1 | PA429864 | rapporteur | |
| 14060000085751 | L14/dossiers | 14 | 14060000085749 | 14060000085749 | 2 | PO211490 | ||
| 14060000085753 | L14/dossiers | 14 | 14060000085752 | 14060000085752 | 1 | PA608292 | rapporteur | |
| 14060000085754 | L14/dossiers | 14 | 14060000085752 | 14060000085752 | 2 | PO419604 | ||
| 14060000085756 | L14/dossiers | 14 | 14060000085755 | 14060000085755 | 1 | PA429864 | auteur | |
| 14060000085760 | L14/dossiers | 14 | 14060000085759 | 14060000085759 | 1 | PO78718 | ||
| 14060000085762 | L14/dossiers | 14 | 14060000085761 | 14060000085761 | 1 | PA608292 | rapporteur | |
| 14060000085763 | L14/dossiers | 14 | 14060000085761 | 14060000085761 | 2 | PO419604 | ||
| 14060000085766 | L14/dossiers | 14 | 14060000085765 | 14060000085765 | 1 | PO644420 | ||
| 14060000085769 | L14/dossiers | 14 | 14060000085768 | 14060000085768 | 1 | PA267743 | auteur | |
| 14060000085819 | L14/dossiers | 14 | 14060000085818 | 14060000085818 | 1 | PA2631 | rapporteur | |
| 14060000085820 | L14/dossiers | 14 | 14060000085818 | 14060000085818 | 2 | PO304272 | ||
| 14060000085822 | L14/dossiers | 14 | 14060000085821 | 14060000085821 | 1 | PA304079 | auteur | |
| 14060000085824 | L14/dossiers | 14 | 14060000085823 | 14060000085823 | 1 | PA2631 | rapporteur | |
| 14060000085825 | L14/dossiers | 14 | 14060000085823 | 14060000085823 | 2 | PO304272 | ||
| 14060000085827 | L14/dossiers | 14 | 14060000085826 | 14060000085826 | 1 | PA609332 | auteur | |
| 14060000086117 | L14/dossiers | 14 | 14060000086116 | 14060000086116 | 1 | PA304086 | rapporteur | |
| 14060000086118 | L14/dossiers | 14 | 14060000086116 | 14060000086116 | 2 | PO211493 | ||
| 14060000086120 | L14/dossiers | 14 | 14060000086119 | 14060000086119 | 1 | PA304086 | auteur | |
| 14060000086181 | L14/dossiers | 14 | 14060000086180 | 14060000086180 | 1 | PO717460 | ||
| 14060000086184 | L14/dossiers | 14 | 14060000086183 | 14060000086183 | 1 | PO644420 | ||
| 14060000086187 | L14/dossiers | 14 | 14060000086186 | 14060000086186 | 1 | PO644420 | ||
| 14060000086190 | L14/dossiers | 14 | 14060000086189 | 14060000086189 | 1 | PA267622 | auteur | |
| 14060000086193 | L14/dossiers | 14 | 14060000086192 | 14060000086192 | 1 | PA304085 | rapporteur | |
| 14060000086194 | L14/dossiers | 14 | 14060000086192 | 14060000086192 | 2 | PO211491 | ||
| 14060000086196 | L14/dossiers | 14 | 14060000086195 | 14060000086195 | 1 | PA608686 | rapporteur | |
| 14060000086197 | L14/dossiers | 14 | 14060000086195 | 14060000086195 | 2 | PO59047 | ||
| 14060000086199 | L14/dossiers | 14 | 14060000086198 | 14060000086198 | 1 | PA267622 | auteur | |
| 14060000086201 | L14/dossiers | 14 | 14060000086200 | 14060000086200 | 1 | PA335054 | rapporteur | |
| 14060000086202 | L14/dossiers | 14 | 14060000086200 | 14060000086200 | 2 | PO415287 | ||
| 14060000086204 | L14/dossiers | 14 | 14060000086203 | 14060000086203 | 1 | PA267178 | auteur | |
| 14060000086227 | L14/dossiers | 14 | 14060000086226 | 14060000086226 | 1 | PA609726 | rapporteur | |
| 14060000086228 | L14/dossiers | 14 | 14060000086226 | 14060000086226 | 2 | PA605952 | rapporteur | |
| 14060000086229 | L14/dossiers | 14 | 14060000086226 | 14060000086226 | 3 | PO419865 | ||
| 14060000086231 | L14/dossiers | 14 | 14060000086230 | 14060000086230 | 1 | PA267785 | auteur | |
| 14060000086308 | L14/dossiers | 14 | 14060000086307 | 14060000086307 | 1 | PA267450 | auteur | |
| 14060000086365 | L14/dossiers | 14 | 14060000086364 | 14060000086364 | 1 | PA415483 | rapporteur | |
| 14060000086366 | L14/dossiers | 14 | 14060000086364 | 14060000086364 | 2 | PO211493 | ||
| 14060000086368 | L14/dossiers | 14 | 14060000086367 | 14060000086367 | 1 | PA642940 | rapporteur | |
| 14060000086369 | L14/dossiers | 14 | 14060000086367 | 14060000086367 | 2 | PO420120 | ||
| 14060000086371 | L14/dossiers | 14 | 14060000086370 | 14060000086370 | 1 | PO644420 | ||
| 14060000086374 | L14/dossiers | 14 | 14060000086373 | 14060000086373 | 1 | PA642940 | rapporteur | |
| 14060000086375 | L14/dossiers | 14 | 14060000086373 | 14060000086373 | 2 | PO420120 | ||
| 14060000086378 | L14/dossiers | 14 | 14060000086377 | 14060000086377 | 1 | PO78718 |