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 |
|---|---|---|---|---|---|---|---|---|
| 14060000035546 | L14/dossiers | 14 | 14060000035545 | 14060000035545 | 1 | PA2538 | auteur | |
| 14060000035663 | L14/dossiers | 14 | 14060000035662 | 14060000035662 | 1 | PO644420 | ||
| 14060000035666 | L14/dossiers | 14 | 14060000035665 | 14060000035665 | 1 | PA2960 | auteur | |
| 14060000035793 | L14/dossiers | 14 | 14060000035792 | 14060000035792 | 1 | PO717460 | ||
| 14060000035796 | L14/dossiers | 14 | 14060000035795 | 14060000035795 | 1 | PA923 | rapporteur | |
| 14060000035797 | L14/dossiers | 14 | 14060000035795 | 14060000035795 | 2 | PA1243 | rapporteur | |
| 14060000035798 | L14/dossiers | 14 | 14060000035795 | 14060000035795 | 3 | PO420375 | ||
| 14060000035800 | L14/dossiers | 14 | 14060000035799 | 14060000035799 | 1 | PA267330 | auteur | |
| 14060000035818 | L14/dossiers | 14 | 14060000035817 | 14060000035817 | 1 | PA406065 | rapporteur | |
| 14060000035819 | L14/dossiers | 14 | 14060000035817 | 14060000035817 | 2 | PO211495 | ||
| 14060000035821 | L14/dossiers | 14 | 14060000035820 | 14060000035820 | 1 | PA406065 | rapporteur | |
| 14060000035822 | L14/dossiers | 14 | 14060000035820 | 14060000035820 | 2 | PO211495 | ||
| 14060000035824 | L14/dossiers | 14 | 14060000035823 | 14060000035823 | 1 | PA606098 | rapporteur | |
| 14060000035825 | L14/dossiers | 14 | 14060000035823 | 14060000035823 | 2 | PO59051 | ||
| 14060000035828 | L14/dossiers | 14 | 14060000035827 | 14060000035827 | 1 | PO644420 | ||
| 14060000035831 | L14/dossiers | 14 | 14060000035830 | 14060000035830 | 1 | PO78718 | ||
| 14060000035833 | L14/dossiers | 14 | 14060000035832 | 14060000035832 | 1 | PA332796 | rapporteur | |
| 14060000035834 | L14/dossiers | 14 | 14060000035832 | 14060000035832 | 2 | PO419604 | ||
| 14060000035836 | L14/dossiers | 14 | 14060000035835 | 14060000035835 | 1 | PA328 | auteur | |
| 14060000035840 | L14/dossiers | 14 | 14060000035839 | 14060000035839 | 1 | PO78718 | ||
| 14060000035842 | L14/dossiers | 14 | 14060000035841 | 14060000035841 | 1 | PA429835 | rapporteur | |
| 14060000035843 | L14/dossiers | 14 | 14060000035841 | 14060000035841 | 2 | PO211491 | ||
| 14060000035845 | L14/dossiers | 14 | 14060000035844 | 14060000035844 | 1 | PA2685 | rapporteur | |
| 14060000035846 | L14/dossiers | 14 | 14060000035844 | 14060000035844 | 2 | PO59047 | ||
| 14060000035848 | L14/dossiers | 14 | 14060000035847 | 14060000035847 | 1 | PA328 | auteur | |
| 14060000035850 | L14/dossiers | 14 | 14060000035849 | 14060000035849 | 1 | PO644420 | ||
| 14060000035853 | L14/dossiers | 14 | 14060000035852 | 14060000035852 | 1 | PA267622 | auteur | |
| 14060000035856 | L14/dossiers | 14 | 14060000035855 | 14060000035855 | 1 | PA267622 | auteur | |
| 14060000035858 | L14/dossiers | 14 | 14060000035857 | 14060000035857 | 1 | PA1886 | auteur | |
| 14060000035976 | L14/dossiers | 14 | 14060000035975 | 14060000035975 | 1 | PA610667 | rapporteur | |
| 14060000035977 | L14/dossiers | 14 | 14060000035975 | 14060000035975 | 2 | PO59047 | ||
| 14060000035979 | L14/dossiers | 14 | 14060000035978 | 14060000035978 | 1 | PA606495 | rapporteur | |
| 14060000035980 | L14/dossiers | 14 | 14060000035978 | 14060000035978 | 2 | PO415287 | ||
| 14060000035982 | L14/dossiers | 14 | 14060000035981 | 14060000035981 | 1 | PA543 | rapporteur | |
| 14060000035983 | L14/dossiers | 14 | 14060000035981 | 14060000035981 | 2 | PO419604 | ||
| 14060000035985 | L14/dossiers | 14 | 14060000035984 | 14060000035984 | 1 | PA267622 | auteur | |
| 14060000035989 | L14/dossiers | 14 | 14060000035988 | 14060000035988 | 1 | PA267622 | auteur | |
| 14060000035991 | L14/dossiers | 14 | 14060000035990 | 14060000035990 | 1 | PA267605 | auteur | |
| 14060000036012 | L14/dossiers | 14 | 14060000036011 | 14060000036011 | 1 | PA1155 | auteur | |
| 14060000036015 | L14/dossiers | 14 | 14060000036014 | 14060000036014 | 1 | PA230 | auteur | |
| 14060000036072 | L14/dossiers | 14 | 14060000036071 | 14060000036071 | 1 | PA328 | auteur | |
| 14060000036076 | L14/dossiers | 14 | 14060000036075 | 14060000036075 | 1 | PA703539 | rapporteur | |
| 14060000036077 | L14/dossiers | 14 | 14060000036075 | 14060000036075 | 2 | PO211495 | ||
| 14060000036079 | L14/dossiers | 14 | 14060000036078 | 14060000036078 | 1 | PA382672 | rapporteur | |
| 14060000036080 | L14/dossiers | 14 | 14060000036078 | 14060000036078 | 2 | PO211491 | ||
| 14060000036082 | L14/dossiers | 14 | 14060000036081 | 14060000036081 | 1 | PA1496 | rapporteur | |
| 14060000036083 | L14/dossiers | 14 | 14060000036081 | 14060000036081 | 2 | PO59047 | ||
| 14060000036085 | L14/dossiers | 14 | 14060000036084 | 14060000036084 | 1 | PA328 | auteur | |
| 14060000036087 | L14/dossiers | 14 | 14060000036086 | 14060000036086 | 1 | PA266776 | auteur | |
| 14060000036090 | L14/dossiers | 14 | 14060000036089 | 14060000036089 | 1 | PA429871 | auteur |