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 |
|---|---|---|---|---|---|---|---|---|
| 16060000083604 | L16/dossiers | 16 | 16060000083603 | 16060000083603 | 1 | PO791932 | ||
| 16060000083607 | L16/dossiers | 16 | 16060000083606 | 16060000083606 | 1 | PO791932 | ||
| 16060000083610 | L16/dossiers | 16 | 16060000083609 | 16060000083609 | 1 | PO791932 | ||
| 16060000083612 | L16/dossiers | 16 | 16060000083611 | 16060000083611 | 1 | PO791932 | ||
| 16060000083614 | L16/dossiers | 16 | 16060000083613 | 16060000083613 | 1 | PO791932 | ||
| 16060000083617 | L16/dossiers | 16 | 16060000083616 | 16060000083616 | 1 | PO791932 | ||
| 16060000083619 | L16/dossiers | 16 | 16060000083618 | 16060000083618 | 1 | PO791932 | ||
| 16060000083621 | L16/dossiers | 16 | 16060000083620 | 16060000083620 | 1 | PO791932 | ||
| 16060000083624 | L16/dossiers | 16 | 16060000083623 | 16060000083623 | 1 | PO791932 | ||
| 16060000083629 | L16/dossiers | 16 | 16060000083628 | 16060000083628 | 1 | PO791932 | ||
| 16060000083631 | L16/dossiers | 16 | 16060000083630 | 16060000083630 | 1 | PO78718 | ||
| 16060000083633 | L16/dossiers | 16 | 16060000083632 | 16060000083632 | 1 | PA773441 | auteur | |
| 16060000083638 | L16/dossiers | 16 | 16060000083637 | 16060000083637 | 1 | PO78718 | ||
| 16060000083640 | L16/dossiers | 16 | 16060000083639 | 16060000083639 | 1 | PA773441 | auteur | |
| 16060000083643 | L16/dossiers | 16 | 16060000083642 | 16060000083642 | 1 | PA773441 | auteur | |
| 16060000083646 | L16/dossiers | 16 | 16060000083645 | 16060000083645 | 1 | PO78718 | ||
| 16060000083648 | L16/dossiers | 16 | 16060000083647 | 16060000083647 | 1 | PO78718 | ||
| 16060000083650 | L16/dossiers | 16 | 16060000083649 | 16060000083649 | 1 | PO78718 | ||
| 16060000083652 | L16/dossiers | 16 | 16060000083651 | 16060000083651 | 1 | PO78718 | ||
| 16060000083654 | L16/dossiers | 16 | 16060000083653 | 16060000083653 | 1 | PO78718 | ||
| 16060000083656 | L16/dossiers | 16 | 16060000083655 | 16060000083655 | 1 | PO78718 | ||
| 16060000083658 | L16/dossiers | 16 | 16060000083657 | 16060000083657 | 1 | PO78718 | ||
| 16060000083660 | L16/dossiers | 16 | 16060000083659 | 16060000083659 | 1 | PO78718 | ||
| 16060000083662 | L16/dossiers | 16 | 16060000083661 | 16060000083661 | 1 | PA703541 | rapporteur | |
| 16060000083663 | L16/dossiers | 16 | 16060000083661 | 16060000083661 | 2 | PO516754 | ||
| 16060000083665 | L16/dossiers | 16 | 16060000083664 | 16060000083664 | 1 | PA775292 | rapporteur | |
| 16060000083666 | L16/dossiers | 16 | 16060000083664 | 16060000083664 | 2 | PA767418 | rapporteur | |
| 16060000083667 | L16/dossiers | 16 | 16060000083664 | 16060000083664 | 3 | PA736197 | rapporteur | |
| 16060000083668 | L16/dossiers | 16 | 16060000083664 | 16060000083664 | 4 | PO516754 | ||
| 16060000083670 | L16/dossiers | 16 | 16060000083669 | 16060000083669 | 1 | PA227094 | rapporteur | |
| 16060000083671 | L16/dossiers | 16 | 16060000083669 | 16060000083669 | 2 | PO211491 | ||
| 16060000083673 | L16/dossiers | 16 | 16060000083672 | 16060000083672 | 1 | PA775232 | rapporteur | |
| 16060000083674 | L16/dossiers | 16 | 16060000083672 | 16060000083672 | 2 | PO211491 | ||
| 16060000083676 | L16/dossiers | 16 | 16060000083675 | 16060000083675 | 1 | PA736197 | rapporteur | |
| 16060000083677 | L16/dossiers | 16 | 16060000083675 | 16060000083675 | 2 | PA775292 | rapporteur | |
| 16060000083678 | L16/dossiers | 16 | 16060000083675 | 16060000083675 | 3 | PA767418 | rapporteur | |
| 16060000083679 | L16/dossiers | 16 | 16060000083675 | 16060000083675 | 4 | PA429842 | rapporteur | |
| 16060000083680 | L16/dossiers | 16 | 16060000083675 | 16060000083675 | 5 | PO784067 | ||
| 16060000083682 | L16/dossiers | 16 | 16060000083681 | 16060000083681 | 1 | PA703541 | rapporteur | |
| 16060000083683 | L16/dossiers | 16 | 16060000083681 | 16060000083681 | 2 | PO784473 | ||
| 16060000083685 | L16/dossiers | 16 | 16060000083684 | 16060000083684 | 1 | PA773441 | auteur | |
| 16060000083688 | L16/dossiers | 16 | 16060000083687 | 16060000083687 | 1 | PA773441 | auteur | |
| 16060000083691 | L16/dossiers | 16 | 16060000083690 | 16060000083690 | 1 | PA773441 | auteur | |
| 16060000083694 | L16/dossiers | 16 | 16060000083693 | 16060000083693 | 1 | PO78718 | ||
| 16060000083696 | L16/dossiers | 16 | 16060000083695 | 16060000083695 | 1 | PA773441 | auteur | |
| 16060000083699 | L16/dossiers | 16 | 16060000083698 | 16060000083698 | 1 | PA773441 | auteur | |
| 16060000083702 | L16/dossiers | 16 | 16060000083701 | 16060000083701 | 1 | PO78718 | ||
| 16060000083704 | L16/dossiers | 16 | 16060000083703 | 16060000083703 | 1 | PO78718 | ||
| 16060000083706 | L16/dossiers | 16 | 16060000083705 | 16060000083705 | 1 | PO78718 | ||
| 16060000083708 | L16/dossiers | 16 | 16060000083707 | 16060000083707 | 1 | PA773441 | auteur |