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 |
|---|---|---|---|---|---|---|---|---|
| 16060000085959 | L16/dossiers | 16 | 16060000085958 | 16060000085958 | 1 | PA719640 | rapporteur | |
| 16060000085960 | L16/dossiers | 16 | 16060000085958 | 16060000085958 | 2 | PA719632 | rapporteur | |
| 16060000085961 | L16/dossiers | 16 | 16060000085958 | 16060000085958 | 3 | PA719382 | rapporteur | |
| 16060000085962 | L16/dossiers | 16 | 16060000085958 | 16060000085958 | 4 | PA794330 | rapporteur | |
| 16060000085963 | L16/dossiers | 16 | 16060000085958 | 16060000085958 | 5 | PA718784 | rapporteur | |
| 16060000085964 | L16/dossiers | 16 | 16060000085958 | 16060000085958 | 6 | PO824144 | ||
| 16060000085969 | L16/dossiers | 16 | 16060000085965 | 16060000085965 | 1 | PA794974 | rapporteur | |
| 16060000085970 | L16/dossiers | 16 | 16060000085965 | 16060000085965 | 2 | PO420120 | ||
| 16060000085972 | L16/dossiers | 16 | 16060000085971 | 16060000085971 | 1 | PA605782 | rapporteur | |
| 16060000085973 | L16/dossiers | 16 | 16060000085971 | 16060000085971 | 2 | PO824749 | ||
| 16060000085978 | L16/dossiers | 16 | 16060000085974 | 16060000085974 | 1 | PA719814 | rapporteur | |
| 16060000085979 | L16/dossiers | 16 | 16060000085974 | 16060000085974 | 2 | PO419604 | ||
| 16060000085981 | L16/dossiers | 16 | 16060000085980 | 16060000085980 | 1 | PA720560 | rapporteur | |
| 16060000085982 | L16/dossiers | 16 | 16060000085980 | 16060000085980 | 2 | PO415287 | ||
| 16060000085984 | L16/dossiers | 16 | 16060000085983 | 16060000085983 | 1 | PA1008 | rapporteur | |
| 16060000085985 | L16/dossiers | 16 | 16060000085983 | 16060000085983 | 2 | PO59047 | ||
| 16060000086002 | L16/dossiers | 16 | 16060000085986 | 16060000085986 | 1 | PA721584 | rapporteur | |
| 16060000086003 | L16/dossiers | 16 | 16060000085986 | 16060000085986 | 2 | PA719558 | rapporteur | |
| 16060000086004 | L16/dossiers | 16 | 16060000085986 | 16060000085986 | 3 | PA793306 | rapporteur | |
| 16060000086005 | L16/dossiers | 16 | 16060000085986 | 16060000085986 | 4 | PO59051 | ||
| 16060000086010 | L16/dossiers | 16 | 16060000086006 | 16060000086006 | 1 | PA719202 | rapporteur | |
| 16060000086011 | L16/dossiers | 16 | 16060000086006 | 16060000086006 | 2 | PO59051 | ||
| 16060000086013 | L16/dossiers | 16 | 16060000086012 | 16060000086012 | 1 | PA718674 | rapporteur | |
| 16060000086014 | L16/dossiers | 16 | 16060000086012 | 16060000086012 | 2 | PA736200 | rapporteur | |
| 16060000086015 | L16/dossiers | 16 | 16060000086012 | 16060000086012 | 3 | PO273589 | ||
| 16060000086017 | L16/dossiers | 16 | 16060000086016 | 16060000086016 | 1 | PA721482 | rapporteur | |
| 16060000086018 | L16/dossiers | 16 | 16060000086016 | 16060000086016 | 2 | PO419865 | ||
| 16060000086020 | L16/dossiers | 16 | 16060000086019 | 16060000086019 | 1 | PA721296 | rapporteur | |
| 16060000086021 | L16/dossiers | 16 | 16060000086019 | 16060000086019 | 2 | PO825231 | ||
| 16060000086023 | L16/dossiers | 16 | 16060000086022 | 16060000086022 | 1 | PA722054 | rapporteur | |
| 16060000086024 | L16/dossiers | 16 | 16060000086022 | 16060000086022 | 2 | PO825399 | ||
| 16060000086026 | L16/dossiers | 16 | 16060000086025 | 16060000086025 | 1 | PA794802 | rapporteur | |
| 16060000086027 | L16/dossiers | 16 | 16060000086025 | 16060000086025 | 2 | PO825406 | ||
| 16060000086029 | L16/dossiers | 16 | 16060000086028 | 16060000086028 | 1 | PA722150 | rapporteur | |
| 16060000086030 | L16/dossiers | 16 | 16060000086028 | 16060000086028 | 2 | PO402232 | ||
| 16060000086032 | L16/dossiers | 16 | 16060000086031 | 16060000086031 | 1 | PA1008 | rapporteur | |
| 16060000086033 | L16/dossiers | 16 | 16060000086031 | 16060000086031 | 2 | PO59047 | ||
| 16060000086035 | L16/dossiers | 16 | 16060000086034 | 16060000086034 | 1 | PA763158 | rapporteur | |
| 16060000086036 | L16/dossiers | 16 | 16060000086034 | 16060000086034 | 2 | PA642868 | rapporteur | |
| 16060000086037 | L16/dossiers | 16 | 16060000086034 | 16060000086034 | 3 | PO826002 | ||
| 16060000086039 | L16/dossiers | 16 | 16060000086038 | 16060000086038 | 1 | PA719814 | rapporteur | |
| 16060000086040 | L16/dossiers | 16 | 16060000086038 | 16060000086038 | 2 | PO825929 | ||
| 16060000086042 | L16/dossiers | 16 | 16060000086041 | 16060000086041 | 1 | PA795730 | rapporteur | |
| 16060000086043 | L16/dossiers | 16 | 16060000086041 | 16060000086041 | 2 | PO825849 | ||
| 16060000086052 | L16/dossiers | 16 | 16060000086044 | 16060000086044 | 1 | PA719372 | rapporteur | |
| 16060000086053 | L16/dossiers | 16 | 16060000086044 | 16060000086044 | 2 | PA794510 | rapporteur | |
| 16060000086054 | L16/dossiers | 16 | 16060000086044 | 16060000086044 | 3 | PA795270 | rapporteur | |
| 16060000086055 | L16/dossiers | 16 | 16060000086044 | 16060000086044 | 4 | PA793560 | rapporteur | |
| 16060000086056 | L16/dossiers | 16 | 16060000086044 | 16060000086044 | 5 | PA722038 | rapporteur | |
| 16060000086057 | L16/dossiers | 16 | 16060000086044 | 16060000086044 | 6 | PO825530 |