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 |
|---|---|---|---|---|---|---|---|---|
| 16060000057321 | L16/dossiers | 16 | 16060000057320 | 16060000057320 | 1 | PA415482 | auteur | |
| 16060000057337 | L16/dossiers | 16 | 16060000057336 | 16060000057336 | 1 | PA1942 | auteur | |
| 16060000057496 | L16/dossiers | 16 | 16060000057495 | 16060000057495 | 1 | PA313924 | auteur | |
| 16060000057584 | L16/dossiers | 16 | 16060000057583 | 16060000057583 | 1 | PA429858 | auteur | |
| 16060000057625 | L16/dossiers | 16 | 16060000057624 | 16060000057624 | 1 | PO78718 | ||
| 16060000057627 | L16/dossiers | 16 | 16060000057626 | 16060000057626 | 1 | PO78718 | ||
| 16060000057629 | L16/dossiers | 16 | 16060000057628 | 16060000057628 | 1 | PA227094 | auteur | |
| 16060000057634 | L16/dossiers | 16 | 16060000057633 | 16060000057633 | 1 | PA227076 | auteur | |
| 16060000057661 | L16/dossiers | 16 | 16060000057660 | 16060000057660 | 1 | PA415488 | auteur | |
| 16060000057664 | L16/dossiers | 16 | 16060000057663 | 16060000057663 | 1 | PO78718 | ||
| 16060000057666 | L16/dossiers | 16 | 16060000057665 | 16060000057665 | 1 | PO78718 | ||
| 16060000057668 | L16/dossiers | 16 | 16060000057667 | 16060000057667 | 1 | PO78718 | ||
| 16060000057670 | L16/dossiers | 16 | 16060000057669 | 16060000057669 | 1 | PO78718 | ||
| 16060000057672 | L16/dossiers | 16 | 16060000057671 | 16060000057671 | 1 | PO78718 | ||
| 16060000057674 | L16/dossiers | 16 | 16060000057673 | 16060000057673 | 1 | PO78718 | ||
| 16060000057676 | L16/dossiers | 16 | 16060000057675 | 16060000057675 | 1 | PO78718 | ||
| 16060000057678 | L16/dossiers | 16 | 16060000057677 | 16060000057677 | 1 | PA703530 | rapporteur | |
| 16060000057679 | L16/dossiers | 16 | 16060000057677 | 16060000057677 | 2 | PO516753 | ||
| 16060000057681 | L16/dossiers | 16 | 16060000057680 | 16060000057680 | 1 | PA2905 | rapporteur | |
| 16060000057682 | L16/dossiers | 16 | 16060000057680 | 16060000057680 | 2 | PO211495 | ||
| 16060000057684 | L16/dossiers | 16 | 16060000057683 | 16060000057683 | 1 | PA267891 | rapporteur | |
| 16060000057685 | L16/dossiers | 16 | 16060000057683 | 16060000057683 | 2 | PO211495 | ||
| 16060000057687 | L16/dossiers | 16 | 16060000057686 | 16060000057686 | 1 | PA2161 | rapporteur | |
| 16060000057688 | L16/dossiers | 16 | 16060000057686 | 16060000057686 | 2 | PO211495 | ||
| 16060000057690 | L16/dossiers | 16 | 16060000057689 | 16060000057689 | 1 | PA429866 | rapporteur | |
| 16060000057691 | L16/dossiers | 16 | 16060000057689 | 16060000057689 | 2 | PO516753 | ||
| 16060000057693 | L16/dossiers | 16 | 16060000057692 | 16060000057692 | 1 | PA1562 | rapporteur | |
| 16060000057694 | L16/dossiers | 16 | 16060000057692 | 16060000057692 | 2 | PO211495 | ||
| 16060000057696 | L16/dossiers | 16 | 16060000057695 | 16060000057695 | 1 | PA703530 | rapporteur | |
| 16060000057697 | L16/dossiers | 16 | 16060000057695 | 16060000057695 | 2 | PO516753 | ||
| 16060000057699 | L16/dossiers | 16 | 16060000057698 | 16060000057698 | 1 | PA303997 | auteur | |
| 16060000057793 | L16/dossiers | 16 | 16060000057792 | 16060000057792 | 1 | PO78718 | ||
| 16060000057795 | L16/dossiers | 16 | 16060000057794 | 16060000057794 | 1 | PA2538 | auteur | |
| 16060000057912 | L16/dossiers | 16 | 16060000057911 | 16060000057911 | 1 | PA2538 | auteur | |
| 16060000057964 | L16/dossiers | 16 | 16060000057963 | 16060000057963 | 1 | PA643211 | auteur | |
| 16060000058076 | L16/dossiers | 16 | 16060000058075 | 16060000058075 | 1 | PA429858 | auteur | |
| 16060000058078 | L16/dossiers | 16 | 16060000058077 | 16060000058077 | 1 | PA429858 | auteur | |
| 16060000058080 | L16/dossiers | 16 | 16060000058079 | 16060000058079 | 1 | PA709298 | auteur | |
| 16060000058096 | L16/dossiers | 16 | 16060000058095 | 16060000058095 | 1 | PA703482 | auteur | |
| 16060000058136 | L16/dossiers | 16 | 16060000058135 | 16060000058135 | 1 | PO78718 | ||
| 16060000058138 | L16/dossiers | 16 | 16060000058137 | 16060000058137 | 1 | PO78718 | ||
| 16060000058140 | L16/dossiers | 16 | 16060000058139 | 16060000058139 | 1 | PO78718 | ||
| 16060000058142 | L16/dossiers | 16 | 16060000058141 | 16060000058141 | 1 | PO78718 | ||
| 16060000058144 | L16/dossiers | 16 | 16060000058143 | 16060000058143 | 1 | PA703494 | rapporteur | |
| 16060000058145 | L16/dossiers | 16 | 16060000058143 | 16060000058143 | 2 | PO211495 | ||
| 16060000058147 | L16/dossiers | 16 | 16060000058146 | 16060000058146 | 1 | PA429838 | rapporteur | |
| 16060000058148 | L16/dossiers | 16 | 16060000058146 | 16060000058146 | 2 | PO211495 | ||
| 16060000058150 | L16/dossiers | 16 | 16060000058149 | 16060000058149 | 1 | PA406065 | rapporteur | |
| 16060000058151 | L16/dossiers | 16 | 16060000058149 | 16060000058149 | 2 | PO211495 | ||
| 16060000058153 | L16/dossiers | 16 | 16060000058152 | 16060000058152 | 1 | PA267340 | rapporteur |