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 |
|---|---|---|---|---|---|---|---|---|
| 16060000056373 | L16/dossiers | 16 | 16060000056372 | 16060000056372 | 1 | PO791932 | ||
| 16060000056376 | L16/dossiers | 16 | 16060000056375 | 16060000056375 | 1 | PO791932 | ||
| 16060000056378 | L16/dossiers | 16 | 16060000056377 | 16060000056377 | 1 | PO791932 | ||
| 16060000056381 | L16/dossiers | 16 | 16060000056380 | 16060000056380 | 1 | PO791932 | ||
| 16060000056384 | L16/dossiers | 16 | 16060000056383 | 16060000056383 | 1 | PO791932 | ||
| 16060000056387 | L16/dossiers | 16 | 16060000056386 | 16060000056386 | 1 | PO791932 | ||
| 16060000056390 | L16/dossiers | 16 | 16060000056389 | 16060000056389 | 1 | PO791932 | ||
| 16060000056393 | L16/dossiers | 16 | 16060000056392 | 16060000056392 | 1 | PO791932 | ||
| 16060000056396 | L16/dossiers | 16 | 16060000056395 | 16060000056395 | 1 | PO791932 | ||
| 16060000056399 | L16/dossiers | 16 | 16060000056398 | 16060000056398 | 1 | PO791932 | ||
| 16060000056402 | L16/dossiers | 16 | 16060000056401 | 16060000056401 | 1 | PO791932 | ||
| 16060000056405 | L16/dossiers | 16 | 16060000056404 | 16060000056404 | 1 | PO791932 | ||
| 16060000056408 | L16/dossiers | 16 | 16060000056407 | 16060000056407 | 1 | PO791932 | ||
| 16060000056411 | L16/dossiers | 16 | 16060000056410 | 16060000056410 | 1 | PO791932 | ||
| 16060000056414 | L16/dossiers | 16 | 16060000056413 | 16060000056413 | 1 | PO791932 | ||
| 16060000056416 | L16/dossiers | 16 | 16060000056415 | 16060000056415 | 1 | PO791932 | ||
| 16060000056418 | L16/dossiers | 16 | 16060000056417 | 16060000056417 | 1 | PO791932 | ||
| 16060000056420 | L16/dossiers | 16 | 16060000056419 | 16060000056419 | 1 | PO791932 | ||
| 16060000056422 | L16/dossiers | 16 | 16060000056421 | 16060000056421 | 1 | PO791932 | ||
| 16060000056425 | L16/dossiers | 16 | 16060000056424 | 16060000056424 | 1 | PO791932 | ||
| 16060000056428 | L16/dossiers | 16 | 16060000056427 | 16060000056427 | 1 | PO791932 | ||
| 16060000056431 | L16/dossiers | 16 | 16060000056430 | 16060000056430 | 1 | PO791932 | ||
| 16060000056434 | L16/dossiers | 16 | 16060000056433 | 16060000056433 | 1 | PO791932 | ||
| 16060000056437 | L16/dossiers | 16 | 16060000056436 | 16060000056436 | 1 | PO791932 | ||
| 16060000056440 | L16/dossiers | 16 | 16060000056439 | 16060000056439 | 1 | PO791932 | ||
| 16060000056443 | L16/dossiers | 16 | 16060000056442 | 16060000056442 | 1 | PO791932 | ||
| 16060000056446 | L16/dossiers | 16 | 16060000056445 | 16060000056445 | 1 | PO791932 | ||
| 16060000056449 | L16/dossiers | 16 | 16060000056448 | 16060000056448 | 1 | PO791932 | ||
| 16060000056452 | L16/dossiers | 16 | 16060000056451 | 16060000056451 | 1 | PO791932 | ||
| 16060000056455 | L16/dossiers | 16 | 16060000056454 | 16060000056454 | 1 | PO791932 | ||
| 16060000056458 | L16/dossiers | 16 | 16060000056457 | 16060000056457 | 1 | PO791932 | ||
| 16060000056461 | L16/dossiers | 16 | 16060000056460 | 16060000056460 | 1 | PO791932 | ||
| 16060000056464 | L16/dossiers | 16 | 16060000056463 | 16060000056463 | 1 | PO791932 | ||
| 16060000056467 | L16/dossiers | 16 | 16060000056466 | 16060000056466 | 1 | PO791932 | ||
| 16060000056470 | L16/dossiers | 16 | 16060000056469 | 16060000056469 | 1 | PO791932 | ||
| 16060000056473 | L16/dossiers | 16 | 16060000056472 | 16060000056472 | 1 | PO791932 | ||
| 16060000056476 | L16/dossiers | 16 | 16060000056475 | 16060000056475 | 1 | PO791932 | ||
| 16060000056479 | L16/dossiers | 16 | 16060000056478 | 16060000056478 | 1 | PO791932 | ||
| 16060000056482 | L16/dossiers | 16 | 16060000056481 | 16060000056481 | 1 | PO791932 | ||
| 16060000056485 | L16/dossiers | 16 | 16060000056484 | 16060000056484 | 1 | PO791932 | ||
| 16060000056488 | L16/dossiers | 16 | 16060000056487 | 16060000056487 | 1 | PO791932 | ||
| 16060000056490 | L16/dossiers | 16 | 16060000056489 | 16060000056489 | 1 | PO791932 | ||
| 16060000056492 | L16/dossiers | 16 | 16060000056491 | 16060000056491 | 1 | PO791932 | ||
| 16060000056495 | L16/dossiers | 16 | 16060000056494 | 16060000056494 | 1 | PO791932 | ||
| 16060000056498 | L16/dossiers | 16 | 16060000056497 | 16060000056497 | 1 | PO791932 | ||
| 16060000056500 | L16/dossiers | 16 | 16060000056499 | 16060000056499 | 1 | PO791932 | ||
| 16060000056503 | L16/dossiers | 16 | 16060000056502 | 16060000056502 | 1 | PO791932 | ||
| 16060000056506 | L16/dossiers | 16 | 16060000056505 | 16060000056505 | 1 | PO791932 | ||
| 16060000056509 | L16/dossiers | 16 | 16060000056508 | 16060000056508 | 1 | PO791932 | ||
| 16060000056512 | L16/dossiers | 16 | 16060000056511 | 16060000056511 | 1 | PO791932 |