dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000003388 | L17/dossiers | 17 | 17060000003387 | 17060000003387 | 1 | PO717460 | ||
| 17060000003391 | L17/dossiers | 17 | 17060000003390 | 17060000003390 | 1 | PO717460 | ||
| 17060000003394 | L17/dossiers | 17 | 17060000003393 | 17060000003393 | 1 | PO717460 | ||
| 17060000003397 | L17/dossiers | 17 | 17060000003396 | 17060000003396 | 1 | PO717460 | ||
| 17060000003400 | L17/dossiers | 17 | 17060000003399 | 17060000003399 | 1 | PO717460 | ||
| 17060000003403 | L17/dossiers | 17 | 17060000003402 | 17060000003402 | 1 | PO717460 | ||
| 17060000003406 | L17/dossiers | 17 | 17060000003405 | 17060000003405 | 1 | PO717460 | ||
| 17060000003409 | L17/dossiers | 17 | 17060000003408 | 17060000003408 | 1 | PO717460 | ||
| 17060000003412 | L17/dossiers | 17 | 17060000003411 | 17060000003411 | 1 | PO717460 | ||
| 17060000003415 | L17/dossiers | 17 | 17060000003414 | 17060000003414 | 1 | PO717460 | ||
| 17060000003418 | L17/dossiers | 17 | 17060000003417 | 17060000003417 | 1 | PO717460 | ||
| 17060000003421 | L17/dossiers | 17 | 17060000003420 | 17060000003420 | 1 | PO717460 | ||
| 17060000003424 | L17/dossiers | 17 | 17060000003423 | 17060000003423 | 1 | PO717460 | ||
| 17060000003427 | L17/dossiers | 17 | 17060000003426 | 17060000003426 | 1 | PO717460 | ||
| 17060000003430 | L17/dossiers | 17 | 17060000003429 | 17060000003429 | 1 | PO717460 | ||
| 17060000003433 | L17/dossiers | 17 | 17060000003432 | 17060000003432 | 1 | PO717460 | ||
| 17060000003436 | L17/dossiers | 17 | 17060000003435 | 17060000003435 | 1 | PO717460 | ||
| 17060000003439 | L17/dossiers | 17 | 17060000003438 | 17060000003438 | 1 | PO717460 | ||
| 17060000003442 | L17/dossiers | 17 | 17060000003441 | 17060000003441 | 1 | PO717460 | ||
| 17060000003445 | L17/dossiers | 17 | 17060000003444 | 17060000003444 | 1 | PO717460 | ||
| 17060000003448 | L17/dossiers | 17 | 17060000003447 | 17060000003447 | 1 | PO717460 | ||
| 17060000003451 | L17/dossiers | 17 | 17060000003450 | 17060000003450 | 1 | PO717460 | ||
| 17060000003454 | L17/dossiers | 17 | 17060000003453 | 17060000003453 | 1 | PO717460 | ||
| 17060000003457 | L17/dossiers | 17 | 17060000003456 | 17060000003456 | 1 | PO717460 | ||
| 17060000003460 | L17/dossiers | 17 | 17060000003459 | 17060000003459 | 1 | PO717460 | ||
| 17060000003463 | L17/dossiers | 17 | 17060000003462 | 17060000003462 | 1 | PO717460 | ||
| 17060000003466 | L17/dossiers | 17 | 17060000003465 | 17060000003465 | 1 | PO717460 | ||
| 17060000003469 | L17/dossiers | 17 | 17060000003468 | 17060000003468 | 1 | PO717460 | ||
| 17060000003472 | L17/dossiers | 17 | 17060000003471 | 17060000003471 | 1 | PO717460 | ||
| 17060000003475 | L17/dossiers | 17 | 17060000003474 | 17060000003474 | 1 | PO717460 | ||
| 17060000003478 | L17/dossiers | 17 | 17060000003477 | 17060000003477 | 1 | PO717460 | ||
| 17060000003481 | L17/dossiers | 17 | 17060000003480 | 17060000003480 | 1 | PO717460 | ||
| 17060000003484 | L17/dossiers | 17 | 17060000003483 | 17060000003483 | 1 | PO717460 | ||
| 17060000003487 | L17/dossiers | 17 | 17060000003486 | 17060000003486 | 1 | PO717460 | ||
| 17060000003490 | L17/dossiers | 17 | 17060000003489 | 17060000003489 | 1 | PO717460 | ||
| 17060000003493 | L17/dossiers | 17 | 17060000003492 | 17060000003492 | 1 | PO717460 | ||
| 17060000003496 | L17/dossiers | 17 | 17060000003495 | 17060000003495 | 1 | PO717460 | ||
| 17060000003499 | L17/dossiers | 17 | 17060000003498 | 17060000003498 | 1 | PO717460 | ||
| 17060000003502 | L17/dossiers | 17 | 17060000003501 | 17060000003501 | 1 | PO717460 | ||
| 17060000003505 | L17/dossiers | 17 | 17060000003504 | 17060000003504 | 1 | PO717460 | ||
| 17060000003508 | L17/dossiers | 17 | 17060000003507 | 17060000003507 | 1 | PO717460 | ||
| 17060000003511 | L17/dossiers | 17 | 17060000003510 | 17060000003510 | 1 | PO717460 | ||
| 17060000003514 | L17/dossiers | 17 | 17060000003513 | 17060000003513 | 1 | PO717460 | ||
| 17060000003517 | L17/dossiers | 17 | 17060000003516 | 17060000003516 | 1 | PO717460 | ||
| 17060000003520 | L17/dossiers | 17 | 17060000003519 | 17060000003519 | 1 | PO717460 | ||
| 17060000003523 | L17/dossiers | 17 | 17060000003522 | 17060000003522 | 1 | PO717460 | ||
| 17060000003526 | L17/dossiers | 17 | 17060000003525 | 17060000003525 | 1 | PO717460 | ||
| 17060000003529 | L17/dossiers | 17 | 17060000003528 | 17060000003528 | 1 | PO717460 | ||
| 17060000003532 | L17/dossiers | 17 | 17060000003531 | 17060000003531 | 1 | PO717460 | ||
| 17060000003535 | L17/dossiers | 17 | 17060000003534 | 17060000003534 | 1 | PO717460 |