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 |
|---|---|---|---|---|---|---|---|---|
| 15060000088461 | L15/dossiers | 15 | 15060000088460 | 15060000088460 | 1 | PA736212 | rapporteur | |
| 15060000088462 | L15/dossiers | 15 | 15060000088460 | 15060000088460 | 2 | PO211490 | ||
| 15060000088464 | L15/dossiers | 15 | 15060000088463 | 15060000088463 | 1 | PA607489 | rapporteur | |
| 15060000088465 | L15/dossiers | 15 | 15060000088463 | 15060000088463 | 2 | PA736248 | rapporteur | |
| 15060000088466 | L15/dossiers | 15 | 15060000088463 | 15060000088463 | 3 | PO516754 | ||
| 15060000088468 | L15/dossiers | 15 | 15060000088467 | 15060000088467 | 1 | PA775276 | rapporteur | |
| 15060000088469 | L15/dossiers | 15 | 15060000088467 | 15060000088467 | 2 | PO516753 | ||
| 15060000088471 | L15/dossiers | 15 | 15060000088470 | 15060000088470 | 1 | PA709750 | rapporteur | |
| 15060000088472 | L15/dossiers | 15 | 15060000088470 | 15060000088470 | 2 | PO786071 | ||
| 15060000088474 | L15/dossiers | 15 | 15060000088473 | 15060000088473 | 1 | PA343775 | rapporteur | |
| 15060000088475 | L15/dossiers | 15 | 15060000088473 | 15060000088473 | 2 | PO211495 | ||
| 15060000088477 | L15/dossiers | 15 | 15060000088476 | 15060000088476 | 1 | PA429858 | rapporteur | |
| 15060000088478 | L15/dossiers | 15 | 15060000088476 | 15060000088476 | 2 | PO211495 | ||
| 15060000088480 | L15/dossiers | 15 | 15060000088479 | 15060000088479 | 1 | PA304021 | rapporteur | |
| 15060000088481 | L15/dossiers | 15 | 15060000088479 | 15060000088479 | 2 | PO211493 | ||
| 15060000088483 | L15/dossiers | 15 | 15060000088482 | 15060000088482 | 1 | PA736205 | rapporteur | |
| 15060000088484 | L15/dossiers | 15 | 15060000088482 | 15060000088482 | 2 | PO786613 | ||
| 15060000088486 | L15/dossiers | 15 | 15060000088485 | 15060000088485 | 1 | PA429875 | rapporteur | |
| 15060000088487 | L15/dossiers | 15 | 15060000088485 | 15060000088485 | 2 | PO785891 | ||
| 15060000088489 | L15/dossiers | 15 | 15060000088488 | 15060000088488 | 1 | PA736212 | rapporteur | |
| 15060000088490 | L15/dossiers | 15 | 15060000088488 | 15060000088488 | 2 | PO786588 | ||
| 15060000088492 | L15/dossiers | 15 | 15060000088491 | 15060000088491 | 1 | PA736244 | rapporteur | |
| 15060000088493 | L15/dossiers | 15 | 15060000088491 | 15060000088491 | 2 | PO211490 | ||
| 15060000088495 | L15/dossiers | 15 | 15060000088494 | 15060000088494 | 1 | PA703511 | rapporteur | |
| 15060000088496 | L15/dossiers | 15 | 15060000088494 | 15060000088494 | 2 | PO211490 | ||
| 15060000088498 | L15/dossiers | 15 | 15060000088497 | 15060000088497 | 1 | PA227089 | rapporteur | |
| 15060000088499 | L15/dossiers | 15 | 15060000088497 | 15060000088497 | 2 | PO516753 | ||
| 15060000088501 | L15/dossiers | 15 | 15060000088500 | 15060000088500 | 1 | PA747420 | rapporteur | |
| 15060000088502 | L15/dossiers | 15 | 15060000088500 | 15060000088500 | 2 | PO211495 | ||
| 15060000088504 | L15/dossiers | 15 | 15060000088503 | 15060000088503 | 1 | PA330684 | rapporteur | |
| 15060000088505 | L15/dossiers | 15 | 15060000088503 | 15060000088503 | 2 | PO211495 | ||
| 15060000088507 | L15/dossiers | 15 | 15060000088506 | 15060000088506 | 1 | PA775178 | rapporteur | |
| 15060000088508 | L15/dossiers | 15 | 15060000088506 | 15060000088506 | 2 | PO211495 | ||
| 15060000088510 | L15/dossiers | 15 | 15060000088509 | 15060000088509 | 1 | PA775218 | rapporteur | |
| 15060000088511 | L15/dossiers | 15 | 15060000088509 | 15060000088509 | 2 | PO211493 | ||
| 15060000088513 | L15/dossiers | 15 | 15060000088512 | 15060000088512 | 1 | PA757676 | rapporteur | |
| 15060000088514 | L15/dossiers | 15 | 15060000088512 | 15060000088512 | 2 | PO211493 | ||
| 15060000088516 | L15/dossiers | 15 | 15060000088515 | 15060000088515 | 1 | PA775276 | rapporteur | |
| 15060000088517 | L15/dossiers | 15 | 15060000088515 | 15060000088515 | 2 | PO787059 | ||
| 15060000088519 | L15/dossiers | 15 | 15060000088518 | 15060000088518 | 1 | PA776985 | rapporteur | |
| 15060000088520 | L15/dossiers | 15 | 15060000088518 | 15060000088518 | 2 | PO786866 | ||
| 15060000088522 | L15/dossiers | 15 | 15060000088521 | 15060000088521 | 1 | PA736211 | rapporteur | |
| 15060000088523 | L15/dossiers | 15 | 15060000088521 | 15060000088521 | 2 | PO786595 | ||
| 15060000088525 | L15/dossiers | 15 | 15060000088524 | 15060000088524 | 1 | PA747420 | rapporteur | |
| 15060000088526 | L15/dossiers | 15 | 15060000088524 | 15060000088524 | 2 | PO788093 | ||
| 15060000088528 | L15/dossiers | 15 | 15060000088527 | 15060000088527 | 1 | PA703494 | rapporteur | |
| 15060000088529 | L15/dossiers | 15 | 15060000088527 | 15060000088527 | 2 | PO211495 | ||
| 15060000088531 | L15/dossiers | 15 | 15060000088530 | 15060000088530 | 1 | PA304017 | rapporteur | |
| 15060000088532 | L15/dossiers | 15 | 15060000088530 | 15060000088530 | 2 | PO211490 | ||
| 15060000088534 | L15/dossiers | 15 | 15060000088533 | 15060000088533 | 1 | PA703538 | rapporteur |