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 |
|---|---|---|---|---|---|---|---|---|
| 15060000081688 | L15/dossiers | 15 | 15060000081686 | 15060000081686 | 2 | PO516754 | ||
| 15060000081690 | L15/dossiers | 15 | 15060000081689 | 15060000081689 | 1 | PA708632 | rapporteur | |
| 15060000081691 | L15/dossiers | 15 | 15060000081689 | 15060000081689 | 2 | PO211495 | ||
| 15060000081693 | L15/dossiers | 15 | 15060000081692 | 15060000081692 | 1 | PA415459 | rapporteur | |
| 15060000081694 | L15/dossiers | 15 | 15060000081692 | 15060000081692 | 2 | PO516754 | ||
| 15060000081696 | L15/dossiers | 15 | 15060000081695 | 15060000081695 | 1 | PA429840 | rapporteur | |
| 15060000081697 | L15/dossiers | 15 | 15060000081695 | 15060000081695 | 2 | PO211495 | ||
| 15060000081699 | L15/dossiers | 15 | 15060000081698 | 15060000081698 | 1 | PA703510 | rapporteur | |
| 15060000081700 | L15/dossiers | 15 | 15060000081698 | 15060000081698 | 2 | PO211495 | ||
| 15060000081702 | L15/dossiers | 15 | 15060000081701 | 15060000081701 | 1 | PA415454 | rapporteur | |
| 15060000081703 | L15/dossiers | 15 | 15060000081701 | 15060000081701 | 2 | PO211495 | ||
| 15060000081705 | L15/dossiers | 15 | 15060000081704 | 15060000081704 | 1 | PA703522 | rapporteur | |
| 15060000081706 | L15/dossiers | 15 | 15060000081704 | 15060000081704 | 2 | PO211495 | ||
| 15060000081708 | L15/dossiers | 15 | 15060000081707 | 15060000081707 | 1 | PA703481 | rapporteur | |
| 15060000081709 | L15/dossiers | 15 | 15060000081707 | 15060000081707 | 2 | PO516754 | ||
| 15060000081711 | L15/dossiers | 15 | 15060000081710 | 15060000081710 | 1 | PA744079 | rapporteur | |
| 15060000081712 | L15/dossiers | 15 | 15060000081710 | 15060000081710 | 2 | PO211494 | ||
| 15060000081714 | L15/dossiers | 15 | 15060000081713 | 15060000081713 | 1 | PA703522 | rapporteur | |
| 15060000081715 | L15/dossiers | 15 | 15060000081713 | 15060000081713 | 2 | PO755721 | ||
| 15060000081717 | L15/dossiers | 15 | 15060000081716 | 15060000081716 | 1 | PA415454 | rapporteur | |
| 15060000081718 | L15/dossiers | 15 | 15060000081716 | 15060000081716 | 2 | PO755798 | ||
| 15060000081720 | L15/dossiers | 15 | 15060000081719 | 15060000081719 | 1 | PA703518 | rapporteur | |
| 15060000081721 | L15/dossiers | 15 | 15060000081719 | 15060000081719 | 2 | PO211493 | ||
| 15060000081723 | L15/dossiers | 15 | 15060000081722 | 15060000081722 | 1 | PA736211 | rapporteur | |
| 15060000081724 | L15/dossiers | 15 | 15060000081722 | 15060000081722 | 2 | PO211494 | ||
| 15060000081726 | L15/dossiers | 15 | 15060000081725 | 15060000081725 | 1 | PA425322 | rapporteur | |
| 15060000081727 | L15/dossiers | 15 | 15060000081725 | 15060000081725 | 2 | PO211493 | ||
| 15060000081729 | L15/dossiers | 15 | 15060000081728 | 15060000081728 | 1 | PA736196 | rapporteur | |
| 15060000081730 | L15/dossiers | 15 | 15060000081728 | 15060000081728 | 2 | PO211495 | ||
| 15060000081732 | L15/dossiers | 15 | 15060000081731 | 15060000081731 | 1 | PA266795 | rapporteur | |
| 15060000081733 | L15/dossiers | 15 | 15060000081731 | 15060000081731 | 2 | PO211495 | ||
| 15060000081735 | L15/dossiers | 15 | 15060000081734 | 15060000081734 | 1 | PA267340 | rapporteur | |
| 15060000081736 | L15/dossiers | 15 | 15060000081734 | 15060000081734 | 2 | PO211495 | ||
| 15060000081738 | L15/dossiers | 15 | 15060000081737 | 15060000081737 | 1 | PA736183 | rapporteur | |
| 15060000081739 | L15/dossiers | 15 | 15060000081737 | 15060000081737 | 2 | PO516753 | ||
| 15060000081741 | L15/dossiers | 15 | 15060000081740 | 15060000081740 | 1 | PA703492 | rapporteur | |
| 15060000081742 | L15/dossiers | 15 | 15060000081740 | 15060000081740 | 2 | PO211495 | ||
| 15060000081744 | L15/dossiers | 15 | 15060000081743 | 15060000081743 | 1 | PA736200 | rapporteur | |
| 15060000081745 | L15/dossiers | 15 | 15060000081743 | 15060000081743 | 2 | PO211490 | ||
| 15060000081747 | L15/dossiers | 15 | 15060000081746 | 15060000081746 | 1 | PA703492 | rapporteur | |
| 15060000081748 | L15/dossiers | 15 | 15060000081746 | 15060000081746 | 2 | PO756918 | ||
| 15060000081750 | L15/dossiers | 15 | 15060000081749 | 15060000081749 | 1 | PA415454 | rapporteur | |
| 15060000081751 | L15/dossiers | 15 | 15060000081749 | 15060000081749 | 2 | PO211495 | ||
| 15060000081753 | L15/dossiers | 15 | 15060000081752 | 15060000081752 | 1 | PA736169 | rapporteur | |
| 15060000081754 | L15/dossiers | 15 | 15060000081752 | 15060000081752 | 2 | PO211495 | ||
| 15060000081756 | L15/dossiers | 15 | 15060000081755 | 15060000081755 | 1 | PA703522 | rapporteur | |
| 15060000081757 | L15/dossiers | 15 | 15060000081755 | 15060000081755 | 2 | PO211495 | ||
| 15060000081759 | L15/dossiers | 15 | 15060000081758 | 15060000081758 | 1 | PA304017 | rapporteur | |
| 15060000081760 | L15/dossiers | 15 | 15060000081758 | 15060000081758 | 2 | PO211490 | ||
| 15060000081762 | L15/dossiers | 15 | 15060000081761 | 15060000081761 | 1 | PA736200 | rapporteur |