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 |
|---|---|---|---|---|---|---|---|---|
| 15060000088376 | L15/dossiers | 15 | 15060000088375 | 15060000088375 | 1 | PO78718 | ||
| 15060000088378 | L15/dossiers | 15 | 15060000088377 | 15060000088377 | 1 | PO78718 | ||
| 15060000088380 | L15/dossiers | 15 | 15060000088379 | 15060000088379 | 1 | PO78718 | ||
| 15060000088382 | L15/dossiers | 15 | 15060000088381 | 15060000088381 | 1 | PO78718 | ||
| 15060000088384 | L15/dossiers | 15 | 15060000088383 | 15060000088383 | 1 | PO78718 | ||
| 15060000088386 | L15/dossiers | 15 | 15060000088385 | 15060000088385 | 1 | PO78718 | ||
| 15060000088388 | L15/dossiers | 15 | 15060000088387 | 15060000088387 | 1 | PO78718 | ||
| 15060000088390 | L15/dossiers | 15 | 15060000088389 | 15060000088389 | 1 | PO78718 | ||
| 15060000088392 | L15/dossiers | 15 | 15060000088391 | 15060000088391 | 1 | PO78718 | ||
| 15060000088394 | L15/dossiers | 15 | 15060000088393 | 15060000088393 | 1 | PO78718 | ||
| 15060000088396 | L15/dossiers | 15 | 15060000088395 | 15060000088395 | 1 | PO78718 | ||
| 15060000088398 | L15/dossiers | 15 | 15060000088397 | 15060000088397 | 1 | PO78718 | ||
| 15060000088400 | L15/dossiers | 15 | 15060000088399 | 15060000088399 | 1 | PO78718 | ||
| 15060000088402 | L15/dossiers | 15 | 15060000088401 | 15060000088401 | 1 | PO78718 | ||
| 15060000088404 | L15/dossiers | 15 | 15060000088403 | 15060000088403 | 1 | PO78718 | ||
| 15060000088406 | L15/dossiers | 15 | 15060000088405 | 15060000088405 | 1 | PO78718 | ||
| 15060000088408 | L15/dossiers | 15 | 15060000088407 | 15060000088407 | 1 | PO78718 | ||
| 15060000088410 | L15/dossiers | 15 | 15060000088409 | 15060000088409 | 1 | PO78718 | ||
| 15060000088412 | L15/dossiers | 15 | 15060000088411 | 15060000088411 | 1 | PO78718 | ||
| 15060000088414 | L15/dossiers | 15 | 15060000088413 | 15060000088413 | 1 | PO78718 | ||
| 15060000088416 | L15/dossiers | 15 | 15060000088415 | 15060000088415 | 1 | PO78718 | ||
| 15060000088418 | L15/dossiers | 15 | 15060000088417 | 15060000088417 | 1 | PO78718 | ||
| 15060000088420 | L15/dossiers | 15 | 15060000088419 | 15060000088419 | 1 | PA703523 | rapporteur | |
| 15060000088421 | L15/dossiers | 15 | 15060000088419 | 15060000088419 | 2 | PO785812 | ||
| 15060000088423 | L15/dossiers | 15 | 15060000088422 | 15060000088422 | 1 | PA736169 | rapporteur | |
| 15060000088424 | L15/dossiers | 15 | 15060000088422 | 15060000088422 | 2 | PO211495 | ||
| 15060000088426 | L15/dossiers | 15 | 15060000088425 | 15060000088425 | 1 | PA775208 | rapporteur | |
| 15060000088427 | L15/dossiers | 15 | 15060000088425 | 15060000088425 | 2 | PO516753 | ||
| 15060000088429 | L15/dossiers | 15 | 15060000088428 | 15060000088428 | 1 | PA703518 | rapporteur | |
| 15060000088430 | L15/dossiers | 15 | 15060000088428 | 15060000088428 | 2 | PO211493 | ||
| 15060000088432 | L15/dossiers | 15 | 15060000088431 | 15060000088431 | 1 | PA703515 | rapporteur | |
| 15060000088433 | L15/dossiers | 15 | 15060000088431 | 15060000088431 | 2 | PO211493 | ||
| 15060000088435 | L15/dossiers | 15 | 15060000088434 | 15060000088434 | 1 | PA775214 | rapporteur | |
| 15060000088436 | L15/dossiers | 15 | 15060000088434 | 15060000088434 | 2 | PO211490 | ||
| 15060000088438 | L15/dossiers | 15 | 15060000088437 | 15060000088437 | 1 | PA775248 | rapporteur | |
| 15060000088439 | L15/dossiers | 15 | 15060000088437 | 15060000088437 | 2 | PO211495 | ||
| 15060000088441 | L15/dossiers | 15 | 15060000088440 | 15060000088440 | 1 | PA736190 | rapporteur | |
| 15060000088442 | L15/dossiers | 15 | 15060000088440 | 15060000088440 | 2 | PO211495 | ||
| 15060000088444 | L15/dossiers | 15 | 15060000088443 | 15060000088443 | 1 | PA736225 | rapporteur | |
| 15060000088445 | L15/dossiers | 15 | 15060000088443 | 15060000088443 | 2 | PO211493 | ||
| 15060000088447 | L15/dossiers | 15 | 15060000088446 | 15060000088446 | 1 | PA775220 | rapporteur | |
| 15060000088448 | L15/dossiers | 15 | 15060000088446 | 15060000088446 | 2 | PA703492 | rapporteur | |
| 15060000088449 | L15/dossiers | 15 | 15060000088446 | 15060000088446 | 3 | PA702993 | rapporteur | |
| 15060000088450 | L15/dossiers | 15 | 15060000088446 | 15060000088446 | 4 | PO785819 | ||
| 15060000088452 | L15/dossiers | 15 | 15060000088451 | 15060000088451 | 1 | PA736211 | rapporteur | |
| 15060000088453 | L15/dossiers | 15 | 15060000088451 | 15060000088451 | 2 | PO211494 | ||
| 15060000088455 | L15/dossiers | 15 | 15060000088454 | 15060000088454 | 1 | PA736205 | rapporteur | |
| 15060000088456 | L15/dossiers | 15 | 15060000088454 | 15060000088454 | 2 | PO211495 | ||
| 15060000088458 | L15/dossiers | 15 | 15060000088457 | 15060000088457 | 1 | PA776985 | rapporteur | |
| 15060000088459 | L15/dossiers | 15 | 15060000088457 | 15060000088457 | 2 | PO211493 |