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 |
|---|---|---|---|---|---|---|---|---|
| 15060000078371 | L15/dossiers | 15 | 15060000078370 | 15060000078370 | 1 | PO717460 | ||
| 15060000078374 | L15/dossiers | 15 | 15060000078373 | 15060000078373 | 1 | PO717460 | ||
| 15060000078378 | L15/dossiers | 15 | 15060000078377 | 15060000078377 | 1 | PO717460 | ||
| 15060000078381 | L15/dossiers | 15 | 15060000078380 | 15060000078380 | 1 | PO717460 | ||
| 15060000078385 | L15/dossiers | 15 | 15060000078384 | 15060000078384 | 1 | PO717460 | ||
| 15060000078388 | L15/dossiers | 15 | 15060000078387 | 15060000078387 | 1 | PO717460 | ||
| 15060000078391 | L15/dossiers | 15 | 15060000078390 | 15060000078390 | 1 | PO717460 | ||
| 15060000078394 | L15/dossiers | 15 | 15060000078393 | 15060000078393 | 1 | PO717460 | ||
| 15060000078397 | L15/dossiers | 15 | 15060000078396 | 15060000078396 | 1 | PO717460 | ||
| 15060000078400 | L15/dossiers | 15 | 15060000078399 | 15060000078399 | 1 | PO717460 | ||
| 15060000078403 | L15/dossiers | 15 | 15060000078402 | 15060000078402 | 1 | PO717460 | ||
| 15060000078406 | L15/dossiers | 15 | 15060000078405 | 15060000078405 | 1 | PO717460 | ||
| 15060000078409 | L15/dossiers | 15 | 15060000078408 | 15060000078408 | 1 | PO717460 | ||
| 15060000078412 | L15/dossiers | 15 | 15060000078411 | 15060000078411 | 1 | PO717460 | ||
| 15060000078414 | L15/dossiers | 15 | 15060000078413 | 15060000078413 | 1 | PO717460 | ||
| 15060000078417 | L15/dossiers | 15 | 15060000078416 | 15060000078416 | 1 | PO717460 | ||
| 15060000078420 | L15/dossiers | 15 | 15060000078419 | 15060000078419 | 1 | PO717460 | ||
| 15060000078423 | L15/dossiers | 15 | 15060000078422 | 15060000078422 | 1 | PO717460 | ||
| 15060000078426 | L15/dossiers | 15 | 15060000078425 | 15060000078425 | 1 | PO717460 | ||
| 15060000078429 | L15/dossiers | 15 | 15060000078428 | 15060000078428 | 1 | PO717460 | ||
| 15060000078431 | L15/dossiers | 15 | 15060000078430 | 15060000078430 | 1 | PO717460 | ||
| 15060000078434 | L15/dossiers | 15 | 15060000078433 | 15060000078433 | 1 | PO717460 | ||
| 15060000078436 | L15/dossiers | 15 | 15060000078435 | 15060000078435 | 1 | PO717460 | ||
| 15060000078438 | L15/dossiers | 15 | 15060000078437 | 15060000078437 | 1 | PO717460 | ||
| 15060000078441 | L15/dossiers | 15 | 15060000078440 | 15060000078440 | 1 | PO717460 | ||
| 15060000078444 | L15/dossiers | 15 | 15060000078443 | 15060000078443 | 1 | PO717460 | ||
| 15060000078446 | L15/dossiers | 15 | 15060000078445 | 15060000078445 | 1 | PO717460 | ||
| 15060000078448 | L15/dossiers | 15 | 15060000078447 | 15060000078447 | 1 | PO717460 | ||
| 15060000078451 | L15/dossiers | 15 | 15060000078450 | 15060000078450 | 1 | PO717460 | ||
| 15060000078454 | L15/dossiers | 15 | 15060000078453 | 15060000078453 | 1 | PO717460 | ||
| 15060000078457 | L15/dossiers | 15 | 15060000078456 | 15060000078456 | 1 | PO717460 | ||
| 15060000078460 | L15/dossiers | 15 | 15060000078459 | 15060000078459 | 1 | PO717460 | ||
| 15060000078463 | L15/dossiers | 15 | 15060000078462 | 15060000078462 | 1 | PO717460 | ||
| 15060000078466 | L15/dossiers | 15 | 15060000078465 | 15060000078465 | 1 | PO717460 | ||
| 15060000078469 | L15/dossiers | 15 | 15060000078468 | 15060000078468 | 1 | PO717460 | ||
| 15060000078472 | L15/dossiers | 15 | 15060000078471 | 15060000078471 | 1 | PO717460 | ||
| 15060000078475 | L15/dossiers | 15 | 15060000078474 | 15060000078474 | 1 | PO717460 | ||
| 15060000078478 | L15/dossiers | 15 | 15060000078477 | 15060000078477 | 1 | PO717460 | ||
| 15060000078481 | L15/dossiers | 15 | 15060000078480 | 15060000078480 | 1 | PO717460 | ||
| 15060000078483 | L15/dossiers | 15 | 15060000078482 | 15060000078482 | 1 | PO717460 | ||
| 15060000078485 | L15/dossiers | 15 | 15060000078484 | 15060000078484 | 1 | PO717460 | ||
| 15060000078487 | L15/dossiers | 15 | 15060000078486 | 15060000078486 | 1 | PO717460 | ||
| 15060000078490 | L15/dossiers | 15 | 15060000078489 | 15060000078489 | 1 | PO717460 | ||
| 15060000078492 | L15/dossiers | 15 | 15060000078491 | 15060000078491 | 1 | PO717460 | ||
| 15060000078495 | L15/dossiers | 15 | 15060000078494 | 15060000078494 | 1 | PO717460 | ||
| 15060000078498 | L15/dossiers | 15 | 15060000078497 | 15060000078497 | 1 | PO717460 | ||
| 15060000078501 | L15/dossiers | 15 | 15060000078500 | 15060000078500 | 1 | PO717460 | ||
| 15060000078504 | L15/dossiers | 15 | 15060000078503 | 15060000078503 | 1 | PO717460 | ||
| 15060000078507 | L15/dossiers | 15 | 15060000078506 | 15060000078506 | 1 | PO717460 | ||
| 15060000078509 | L15/dossiers | 15 | 15060000078508 | 15060000078508 | 1 | PO717460 |