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 |
|---|---|---|---|---|---|---|---|---|
| 14060000050793 | L14/dossiers | 14 | 14060000050791 | 14060000050791 | 2 | PO59047 | ||
| 14060000050795 | L14/dossiers | 14 | 14060000050794 | 14060000050794 | 1 | PA267459 | auteur | |
| 14060000050798 | L14/dossiers | 14 | 14060000050797 | 14060000050797 | 1 | PA270 | rapporteur | |
| 14060000050799 | L14/dossiers | 14 | 14060000050797 | 14060000050797 | 2 | PO211494 | ||
| 14060000050801 | L14/dossiers | 14 | 14060000050800 | 14060000050800 | 1 | PA2713 | auteur | |
| 14060000050816 | L14/dossiers | 14 | 14060000050815 | 14060000050815 | 1 | PA1886 | auteur | |
| 14060000050920 | L14/dossiers | 14 | 14060000050919 | 14060000050919 | 1 | PA267091 | rapporteur | |
| 14060000050921 | L14/dossiers | 14 | 14060000050919 | 14060000050919 | 2 | PO419610 | ||
| 14060000050923 | L14/dossiers | 14 | 14060000050922 | 14060000050922 | 1 | PA563 | auteur | |
| 14060000050927 | L14/dossiers | 14 | 14060000050926 | 14060000050926 | 1 | PA334 | rapporteur | |
| 14060000050928 | L14/dossiers | 14 | 14060000050926 | 14060000050926 | 2 | PO59051 | ||
| 14060000050930 | L14/dossiers | 14 | 14060000050929 | 14060000050929 | 1 | PA303996 | rapporteur | |
| 14060000050931 | L14/dossiers | 14 | 14060000050929 | 14060000050929 | 2 | PO211495 | ||
| 14060000050933 | L14/dossiers | 14 | 14060000050932 | 14060000050932 | 1 | PO78718 | ||
| 14060000050935 | L14/dossiers | 14 | 14060000050934 | 14060000050934 | 1 | PA334 | rapporteur | |
| 14060000050936 | L14/dossiers | 14 | 14060000050934 | 14060000050934 | 2 | PO59051 | ||
| 14060000050939 | L14/dossiers | 14 | 14060000050938 | 14060000050938 | 1 | PA1886 | auteur | |
| 14060000051227 | L14/dossiers | 14 | 14060000051226 | 14060000051226 | 1 | PA267492 | auteur | |
| 14060000051239 | L14/dossiers | 14 | 14060000051238 | 14060000051238 | 1 | PA267492 | auteur | |
| 14060000051250 | L14/dossiers | 14 | 14060000051249 | 14060000051249 | 1 | PA330240 | rapporteur | |
| 14060000051251 | L14/dossiers | 14 | 14060000051249 | 14060000051249 | 2 | PO59051 | ||
| 14060000051253 | L14/dossiers | 14 | 14060000051252 | 14060000051252 | 1 | PA330240 | auteur | |
| 14060000051308 | L14/dossiers | 14 | 14060000051307 | 14060000051307 | 1 | PA441 | auteur | |
| 14060000051311 | L14/dossiers | 14 | 14060000051310 | 14060000051310 | 1 | PA785 | auteur | |
| 14060000051315 | L14/dossiers | 14 | 14060000051314 | 14060000051314 | 1 | PO78718 | ||
| 14060000051317 | L14/dossiers | 14 | 14060000051316 | 14060000051316 | 1 | PA267336 | rapporteur | |
| 14060000051318 | L14/dossiers | 14 | 14060000051316 | 14060000051316 | 2 | PO59051 | ||
| 14060000051320 | L14/dossiers | 14 | 14060000051319 | 14060000051319 | 1 | PA267336 | rapporteur | |
| 14060000051321 | L14/dossiers | 14 | 14060000051319 | 14060000051319 | 2 | PO59051 | ||
| 14060000051324 | L14/dossiers | 14 | 14060000051323 | 14060000051323 | 1 | PA267336 | auteur | |
| 14060000051344 | L14/dossiers | 14 | 14060000051343 | 14060000051343 | 1 | PA267151 | auteur | |
| 14060000051381 | L14/dossiers | 14 | 14060000051380 | 14060000051380 | 1 | PA328 | auteur | |
| 14060000051385 | L14/dossiers | 14 | 14060000051384 | 14060000051384 | 1 | PA415465 | rapporteur | |
| 14060000051386 | L14/dossiers | 14 | 14060000051384 | 14060000051384 | 2 | PO211495 | ||
| 14060000051388 | L14/dossiers | 14 | 14060000051387 | 14060000051387 | 1 | PO717460 | ||
| 14060000051391 | L14/dossiers | 14 | 14060000051390 | 14060000051390 | 1 | PA406065 | auteur | |
| 14060000051394 | L14/dossiers | 14 | 14060000051393 | 14060000051393 | 1 | PO644420 | ||
| 14060000051397 | L14/dossiers | 14 | 14060000051396 | 14060000051396 | 1 | PA342935 | auteur | |
| 14060000051463 | L14/dossiers | 14 | 14060000051462 | 14060000051462 | 1 | PA330788 | auteur | |
| 14060000051505 | L14/dossiers | 14 | 14060000051504 | 14060000051504 | 1 | PA332747 | auteur | |
| 14060000051523 | L14/dossiers | 14 | 14060000051522 | 14060000051522 | 1 | PA2971 | auteur | |
| 14060000051526 | L14/dossiers | 14 | 14060000051525 | 14060000051525 | 1 | PA266788 | auteur | |
| 14060000051529 | L14/dossiers | 14 | 14060000051528 | 14060000051528 | 1 | PA606230 | rapporteur | |
| 14060000051530 | L14/dossiers | 14 | 14060000051528 | 14060000051528 | 2 | PO419610 | ||
| 14060000051532 | L14/dossiers | 14 | 14060000051531 | 14060000051531 | 1 | PA335054 | rapporteur | |
| 14060000051533 | L14/dossiers | 14 | 14060000051531 | 14060000051531 | 2 | PO415287 | ||
| 14060000051535 | L14/dossiers | 14 | 14060000051534 | 14060000051534 | 1 | PA606230 | rapporteur | |
| 14060000051536 | L14/dossiers | 14 | 14060000051534 | 14060000051534 | 2 | PO419610 | ||
| 14060000051538 | L14/dossiers | 14 | 14060000051537 | 14060000051537 | 1 | PA680 | auteur | |
| 14060000051545 | L14/dossiers | 14 | 14060000051544 | 14060000051544 | 1 | PA335054 | rapporteur |