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 |
|---|---|---|---|---|---|---|---|---|
| 15060000129442 | L15/dossiers | 15 | 15060000129441 | 15060000129441 | 1 | PO717460 | ||
| 15060000129444 | L15/dossiers | 15 | 15060000129443 | 15060000129443 | 1 | PO717460 | ||
| 15060000129446 | L15/dossiers | 15 | 15060000129445 | 15060000129445 | 1 | PO717460 | ||
| 15060000129448 | L15/dossiers | 15 | 15060000129447 | 15060000129447 | 1 | PO717460 | ||
| 15060000129450 | L15/dossiers | 15 | 15060000129449 | 15060000129449 | 1 | PO717460 | ||
| 15060000129452 | L15/dossiers | 15 | 15060000129451 | 15060000129451 | 1 | PO717460 | ||
| 15060000129454 | L15/dossiers | 15 | 15060000129453 | 15060000129453 | 1 | PO717460 | ||
| 15060000129456 | L15/dossiers | 15 | 15060000129455 | 15060000129455 | 1 | PO717460 | ||
| 15060000129458 | L15/dossiers | 15 | 15060000129457 | 15060000129457 | 1 | PO717460 | ||
| 15060000129460 | L15/dossiers | 15 | 15060000129459 | 15060000129459 | 1 | PO717460 | ||
| 15060000129462 | L15/dossiers | 15 | 15060000129461 | 15060000129461 | 1 | PO717460 | ||
| 15060000129464 | L15/dossiers | 15 | 15060000129463 | 15060000129463 | 1 | PO717460 | ||
| 15060000129466 | L15/dossiers | 15 | 15060000129465 | 15060000129465 | 1 | PO717460 | ||
| 15060000129468 | L15/dossiers | 15 | 15060000129467 | 15060000129467 | 1 | PO717460 | ||
| 15060000129470 | L15/dossiers | 15 | 15060000129469 | 15060000129469 | 1 | PO717460 | ||
| 14060000000002 | L14/dossiers | 14 | 14060000000001 | 14060000000001 | 1 | PO717460 | ||
| 14060000000005 | L14/dossiers | 14 | 14060000000004 | 14060000000004 | 1 | PA429841 | rapporteur | |
| 14060000000006 | L14/dossiers | 14 | 14060000000004 | 14060000000004 | 2 | PO211493 | ||
| 14060000000008 | L14/dossiers | 14 | 14060000000007 | 14060000000007 | 1 | PO78718 | ||
| 14060000000010 | L14/dossiers | 14 | 14060000000009 | 14060000000009 | 1 | PA336439 | rapporteur | |
| 14060000000011 | L14/dossiers | 14 | 14060000000009 | 14060000000009 | 2 | PA267785 | rapporteur | |
| 14060000000012 | L14/dossiers | 14 | 14060000000009 | 14060000000009 | 3 | PO59051 | ||
| 14060000000014 | L14/dossiers | 14 | 14060000000013 | 14060000000013 | 1 | PA719130 | rapporteur | |
| 14060000000015 | L14/dossiers | 14 | 14060000000013 | 14060000000013 | 2 | PO59047 | ||
| 14060000000017 | L14/dossiers | 14 | 14060000000016 | 14060000000016 | 1 | PA722150 | rapporteur | |
| 14060000000018 | L14/dossiers | 14 | 14060000000016 | 14060000000016 | 2 | PO59051 | ||
| 14060000000024 | L14/dossiers | 14 | 14060000000020 | 14060000000020 | 1 | PA722150 | rapporteur | |
| 14060000000025 | L14/dossiers | 14 | 14060000000020 | 14060000000020 | 2 | PO59051 | ||
| 14060000000027 | L14/dossiers | 14 | 14060000000026 | 14060000000026 | 1 | PA721530 | rapporteur | |
| 14060000000028 | L14/dossiers | 14 | 14060000000026 | 14060000000026 | 2 | PA721968 | rapporteur | |
| 14060000000029 | L14/dossiers | 14 | 14060000000026 | 14060000000026 | 3 | PO419865 | ||
| 14060000000031 | L14/dossiers | 14 | 14060000000030 | 14060000000030 | 1 | PA267622 | auteur | |
| 14060000000034 | L14/dossiers | 14 | 14060000000033 | 14060000000033 | 1 | PA1214 | rapporteur | |
| 14060000000035 | L14/dossiers | 14 | 14060000000033 | 14060000000033 | 2 | PO419604 | ||
| 14060000000037 | L14/dossiers | 14 | 14060000000036 | 14060000000036 | 1 | PA415459 | rapporteur | |
| 14060000000038 | L14/dossiers | 14 | 14060000000036 | 14060000000036 | 2 | PO211490 | ||
| 14060000000046 | L14/dossiers | 14 | 14060000000039 | 14060000000039 | 1 | PA1214 | rapporteur | |
| 14060000000047 | L14/dossiers | 14 | 14060000000039 | 14060000000039 | 2 | PO419604 | ||
| 14060000000049 | L14/dossiers | 14 | 14060000000048 | 14060000000048 | 1 | PA267355 | rapporteur | |
| 14060000000050 | L14/dossiers | 14 | 14060000000048 | 14060000000048 | 2 | PO419610 | ||
| 14060000000052 | L14/dossiers | 14 | 14060000000051 | 14060000000051 | 1 | PA703530 | rapporteur | |
| 14060000000053 | L14/dossiers | 14 | 14060000000051 | 14060000000051 | 2 | PO516753 | ||
| 14060000000055 | L14/dossiers | 14 | 14060000000054 | 14060000000054 | 1 | PA703530 | rapporteur | |
| 14060000000056 | L14/dossiers | 14 | 14060000000054 | 14060000000054 | 2 | PO516753 | ||
| 14060000000058 | L14/dossiers | 14 | 14060000000057 | 14060000000057 | 1 | PO717460 | ||
| 14060000000061 | L14/dossiers | 14 | 14060000000060 | 14060000000060 | 1 | PO78718 | ||
| 14060000000063 | L14/dossiers | 14 | 14060000000062 | 14060000000062 | 1 | PA1942 | auteur | |
| 14060000000222 | L14/dossiers | 14 | 14060000000221 | 14060000000221 | 1 | PO644420 | ||
| 14060000000225 | L14/dossiers | 14 | 14060000000224 | 14060000000224 | 1 | PO644420 | ||
| 14060000000228 | L14/dossiers | 14 | 14060000000227 | 14060000000227 | 1 | PA1866 | rapporteur |