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 |
|---|---|---|---|---|---|---|---|---|
| 16060000059446 | L16/dossiers | 16 | 16060000059445 | 16060000059445 | 1 | PA267340 | rapporteur | |
| 16060000059447 | L16/dossiers | 16 | 16060000059445 | 16060000059445 | 2 | PA266795 | rapporteur | |
| 16060000059448 | L16/dossiers | 16 | 16060000059445 | 16060000059445 | 3 | PO211495 | ||
| 16060000059450 | L16/dossiers | 16 | 16060000059449 | 16060000059449 | 1 | PA703497 | rapporteur | |
| 16060000059451 | L16/dossiers | 16 | 16060000059449 | 16060000059449 | 2 | PO516754 | ||
| 16060000059453 | L16/dossiers | 16 | 16060000059452 | 16060000059452 | 1 | PA607489 | rapporteur | |
| 16060000059454 | L16/dossiers | 16 | 16060000059452 | 16060000059452 | 2 | PA736248 | rapporteur | |
| 16060000059455 | L16/dossiers | 16 | 16060000059452 | 16060000059452 | 3 | PO516754 | ||
| 16060000059457 | L16/dossiers | 16 | 16060000059456 | 16060000059456 | 1 | PA736213 | rapporteur | |
| 16060000059458 | L16/dossiers | 16 | 16060000059456 | 16060000059456 | 2 | PO211495 | ||
| 16060000059460 | L16/dossiers | 16 | 16060000059459 | 16060000059459 | 1 | PA736169 | rapporteur | |
| 16060000059461 | L16/dossiers | 16 | 16060000059459 | 16060000059459 | 2 | PO211495 | ||
| 16060000059463 | L16/dossiers | 16 | 16060000059462 | 16060000059462 | 1 | PA775184 | rapporteur | |
| 16060000059464 | L16/dossiers | 16 | 16060000059462 | 16060000059462 | 2 | PO516753 | ||
| 16060000059466 | L16/dossiers | 16 | 16060000059465 | 16060000059465 | 1 | PA736187 | rapporteur | |
| 16060000059467 | L16/dossiers | 16 | 16060000059465 | 16060000059465 | 2 | PO516754 | ||
| 16060000059469 | L16/dossiers | 16 | 16060000059468 | 16060000059468 | 1 | PA227098 | rapporteur | |
| 16060000059470 | L16/dossiers | 16 | 16060000059468 | 16060000059468 | 2 | PO211493 | ||
| 16060000059472 | L16/dossiers | 16 | 16060000059471 | 16060000059471 | 1 | PA747422 | rapporteur | |
| 16060000059473 | L16/dossiers | 16 | 16060000059471 | 16060000059471 | 2 | PO516754 | ||
| 16060000059475 | L16/dossiers | 16 | 16060000059474 | 16060000059474 | 1 | PA775208 | rapporteur | |
| 16060000059476 | L16/dossiers | 16 | 16060000059474 | 16060000059474 | 2 | PO516753 | ||
| 16060000059478 | L16/dossiers | 16 | 16060000059477 | 16060000059477 | 1 | PA429840 | rapporteur | |
| 16060000059479 | L16/dossiers | 16 | 16060000059477 | 16060000059477 | 2 | PO211495 | ||
| 16060000059481 | L16/dossiers | 16 | 16060000059480 | 16060000059480 | 1 | PA703534 | rapporteur | |
| 16060000059482 | L16/dossiers | 16 | 16060000059480 | 16060000059480 | 2 | PO211493 | ||
| 16060000059484 | L16/dossiers | 16 | 16060000059483 | 16060000059483 | 1 | PA736205 | rapporteur | |
| 16060000059485 | L16/dossiers | 16 | 16060000059483 | 16060000059483 | 2 | PO211495 | ||
| 16060000059487 | L16/dossiers | 16 | 16060000059486 | 16060000059486 | 1 | PA775236 | rapporteur | |
| 16060000059488 | L16/dossiers | 16 | 16060000059486 | 16060000059486 | 2 | PO211490 | ||
| 16060000059490 | L16/dossiers | 16 | 16060000059489 | 16060000059489 | 1 | PA703523 | rapporteur | |
| 16060000059491 | L16/dossiers | 16 | 16060000059489 | 16060000059489 | 2 | PO516753 | ||
| 16060000059493 | L16/dossiers | 16 | 16060000059492 | 16060000059492 | 1 | PA709750 | rapporteur | |
| 16060000059494 | L16/dossiers | 16 | 16060000059492 | 16060000059492 | 2 | PO516753 | ||
| 16060000059496 | L16/dossiers | 16 | 16060000059495 | 16060000059495 | 1 | PO78718 | ||
| 16060000059498 | L16/dossiers | 16 | 16060000059497 | 16060000059497 | 1 | PA703497 | auteur | |
| 16060000059500 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 1 | PA304017 | auteur | |
| 16060000059501 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 2 | PA736216 | auteur | |
| 16060000059502 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 3 | PA736243 | auteur | |
| 16060000059503 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 4 | PA736182 | auteur | |
| 16060000059504 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 5 | PA775250 | auteur | |
| 16060000059505 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 6 | PA736230 | auteur | |
| 16060000059506 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 7 | PA775226 | auteur | |
| 16060000059507 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 8 | PA775198 | auteur | |
| 16060000059508 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 9 | PA331381 | auteur | |
| 16060000059509 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 10 | PA758431 | auteur | |
| 16060000059510 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 11 | PA267762 | auteur | |
| 16060000059511 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 12 | PA736192 | auteur | |
| 16060000059512 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 13 | PA703501 | auteur | |
| 16060000059513 | L16/dossiers | 16 | 16060000059499 | 16060000059499 | 14 | PA703532 | auteur |