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 |
|---|---|---|---|---|---|---|---|---|
| 14060000030027 | L14/dossiers | 14 | 14060000030025 | 14060000030025 | 2 | PO702437 | ||
| 14060000030029 | L14/dossiers | 14 | 14060000030028 | 14060000030028 | 1 | PA267835 | rapporteur | |
| 14060000030030 | L14/dossiers | 14 | 14060000030028 | 14060000030028 | 2 | PO59051 | ||
| 14060000030032 | L14/dossiers | 14 | 14060000030031 | 14060000030031 | 1 | PA267835 | rapporteur | |
| 14060000030033 | L14/dossiers | 14 | 14060000030031 | 14060000030031 | 2 | PO59051 | ||
| 14060000030037 | L14/dossiers | 14 | 14060000030036 | 14060000030036 | 1 | PA810 | auteur | |
| 14060000030065 | L14/dossiers | 14 | 14060000030064 | 14060000030064 | 1 | PO644420 | ||
| 14060000030068 | L14/dossiers | 14 | 14060000030067 | 14060000030067 | 1 | PO78718 | ||
| 14060000030070 | L14/dossiers | 14 | 14060000030069 | 14060000030069 | 1 | PA610905 | rapporteur | |
| 14060000030071 | L14/dossiers | 14 | 14060000030069 | 14060000030069 | 2 | PO415287 | ||
| 14060000030073 | L14/dossiers | 14 | 14060000030072 | 14060000030072 | 1 | PA1206 | auteur | |
| 14060000030092 | L14/dossiers | 14 | 14060000030091 | 14060000030091 | 1 | PA608186 | rapporteur | |
| 14060000030093 | L14/dossiers | 14 | 14060000030091 | 14060000030091 | 2 | PO415287 | ||
| 14060000030095 | L14/dossiers | 14 | 14060000030094 | 14060000030094 | 1 | PA2796 | auteur | |
| 14060000030110 | L14/dossiers | 14 | 14060000030109 | 14060000030109 | 1 | PA267285 | auteur | |
| 14060000030170 | L14/dossiers | 14 | 14060000030169 | 14060000030169 | 1 | PA309643 | auteur | |
| 14060000030173 | L14/dossiers | 14 | 14060000030172 | 14060000030172 | 1 | PA330684 | auteur | |
| 14060000030256 | L14/dossiers | 14 | 14060000030255 | 14060000030255 | 1 | PA330684 | auteur | |
| 14060000030300 | L14/dossiers | 14 | 14060000030299 | 14060000030299 | 1 | PA267233 | rapporteur | |
| 14060000030301 | L14/dossiers | 14 | 14060000030299 | 14060000030299 | 2 | PO419865 | ||
| 14060000030303 | L14/dossiers | 14 | 14060000030302 | 14060000030302 | 1 | PA415495 | rapporteur | |
| 14060000030304 | L14/dossiers | 14 | 14060000030302 | 14060000030302 | 2 | PO516754 | ||
| 14060000030306 | L14/dossiers | 14 | 14060000030305 | 14060000030305 | 1 | PA267233 | rapporteur | |
| 14060000030307 | L14/dossiers | 14 | 14060000030305 | 14060000030305 | 2 | PO419865 | ||
| 14060000030310 | L14/dossiers | 14 | 14060000030309 | 14060000030309 | 1 | PO644420 | ||
| 14060000030313 | L14/dossiers | 14 | 14060000030312 | 14060000030312 | 1 | PA2200 | auteur | |
| 14060000030316 | L14/dossiers | 14 | 14060000030315 | 14060000030315 | 1 | PA346886 | auteur | |
| 14060000030319 | L14/dossiers | 14 | 14060000030318 | 14060000030318 | 1 | PA328 | auteur | |
| 14060000030323 | L14/dossiers | 14 | 14060000030322 | 14060000030322 | 1 | PO78718 | ||
| 14060000030325 | L14/dossiers | 14 | 14060000030324 | 14060000030324 | 1 | PA227097 | rapporteur | |
| 14060000030326 | L14/dossiers | 14 | 14060000030324 | 14060000030324 | 2 | PO211491 | ||
| 14060000030328 | L14/dossiers | 14 | 14060000030327 | 14060000030327 | 1 | PA1710 | rapporteur | |
| 14060000030329 | L14/dossiers | 14 | 14060000030327 | 14060000030327 | 2 | PO59047 | ||
| 14060000030331 | L14/dossiers | 14 | 14060000030330 | 14060000030330 | 1 | PA328 | auteur | |
| 14060000030333 | L14/dossiers | 14 | 14060000030332 | 14060000030332 | 1 | PA266797 | auteur | |
| 14060000030334 | L14/dossiers | 14 | 14060000030332 | 14060000030332 | 2 | PA333134 | auteur | |
| 14060000030391 | L14/dossiers | 14 | 14060000030390 | 14060000030390 | 1 | PA1020 | auteur | |
| 14060000030419 | L14/dossiers | 14 | 14060000030418 | 14060000030418 | 1 | PA1874 | auteur | |
| 14060000030478 | L14/dossiers | 14 | 14060000030477 | 14060000030477 | 1 | PA687214 | auteur | |
| 14060000030538 | L14/dossiers | 14 | 14060000030537 | 14060000030537 | 1 | PA267289 | rapporteur | |
| 14060000030539 | L14/dossiers | 14 | 14060000030537 | 14060000030537 | 2 | PO59051 | ||
| 14060000030541 | L14/dossiers | 14 | 14060000030540 | 14060000030540 | 1 | PA2099 | auteur | |
| 14060000030550 | L14/dossiers | 14 | 14060000030549 | 14060000030549 | 1 | PA2876 | auteur | |
| 14060000030553 | L14/dossiers | 14 | 14060000030552 | 14060000030552 | 1 | PO644420 | ||
| 14060000030556 | L14/dossiers | 14 | 14060000030555 | 14060000030555 | 1 | PA267622 | auteur | |
| 14060000030559 | L14/dossiers | 14 | 14060000030558 | 14060000030558 | 1 | PA609218 | rapporteur | |
| 14060000030560 | L14/dossiers | 14 | 14060000030558 | 14060000030558 | 2 | PO59047 | ||
| 14060000030562 | L14/dossiers | 14 | 14060000030561 | 14060000030561 | 1 | PA1142 | rapporteur | |
| 14060000030563 | L14/dossiers | 14 | 14060000030561 | 14060000030561 | 2 | PO211494 | ||
| 14060000030565 | L14/dossiers | 14 | 14060000030564 | 14060000030564 | 1 | PA267622 | auteur |