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 |
|---|---|---|---|---|---|---|---|---|
| 16060000087759 | L16/dossiers | 16 | 16060000087758 | 16060000087758 | 1 | PA267340 | rapporteur | |
| 16060000087760 | L16/dossiers | 16 | 16060000087758 | 16060000087758 | 2 | PO211495 | ||
| 16060000087762 | L16/dossiers | 16 | 16060000087761 | 16060000087761 | 1 | PA775168 | rapporteur | |
| 16060000087763 | L16/dossiers | 16 | 16060000087761 | 16060000087761 | 2 | PO516754 | ||
| 16060000087765 | L16/dossiers | 16 | 16060000087764 | 16060000087764 | 1 | PA415486 | rapporteur | |
| 16060000087766 | L16/dossiers | 16 | 16060000087764 | 16060000087764 | 2 | PO211491 | ||
| 16060000087768 | L16/dossiers | 16 | 16060000087767 | 16060000087767 | 1 | PA703525 | rapporteur | |
| 16060000087769 | L16/dossiers | 16 | 16060000087767 | 16060000087767 | 2 | PO211491 | ||
| 16060000087771 | L16/dossiers | 16 | 16060000087770 | 16060000087770 | 1 | PA703523 | rapporteur | |
| 16060000087772 | L16/dossiers | 16 | 16060000087770 | 16060000087770 | 2 | PO516753 | ||
| 16060000087774 | L16/dossiers | 16 | 16060000087773 | 16060000087773 | 1 | PA736160 | rapporteur | |
| 16060000087775 | L16/dossiers | 16 | 16060000087773 | 16060000087773 | 2 | PO211493 | ||
| 16060000087777 | L16/dossiers | 16 | 16060000087776 | 16060000087776 | 1 | PA590034 | rapporteur | |
| 16060000087778 | L16/dossiers | 16 | 16060000087776 | 16060000087776 | 2 | PO211491 | ||
| 16060000087780 | L16/dossiers | 16 | 16060000087779 | 16060000087779 | 1 | PA736218 | rapporteur | |
| 16060000087781 | L16/dossiers | 16 | 16060000087779 | 16060000087779 | 2 | PO789667 | ||
| 16060000087783 | L16/dossiers | 16 | 16060000087782 | 16060000087782 | 1 | PA426327 | rapporteur | |
| 16060000087784 | L16/dossiers | 16 | 16060000087782 | 16060000087782 | 2 | PO211495 | ||
| 16060000087786 | L16/dossiers | 16 | 16060000087785 | 16060000087785 | 1 | PA429887 | rapporteur | |
| 16060000087787 | L16/dossiers | 16 | 16060000087785 | 16060000087785 | 2 | PO211491 | ||
| 16060000087789 | L16/dossiers | 16 | 16060000087788 | 16060000087788 | 1 | PA703537 | rapporteur | |
| 16060000087790 | L16/dossiers | 16 | 16060000087788 | 16060000087788 | 2 | PO211491 | ||
| 16060000087792 | L16/dossiers | 16 | 16060000087791 | 16060000087791 | 1 | PA720634 | rapporteur | |
| 16060000087793 | L16/dossiers | 16 | 16060000087791 | 16060000087791 | 2 | PO211491 | ||
| 16060000087795 | L16/dossiers | 16 | 16060000087794 | 16060000087794 | 1 | PA227096 | rapporteur | |
| 16060000087796 | L16/dossiers | 16 | 16060000087794 | 16060000087794 | 2 | PO211491 | ||
| 16060000087798 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 1 | PA429875 | rapporteur | |
| 16060000087799 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 2 | PA429869 | rapporteur | |
| 16060000087800 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 3 | PA736191 | rapporteur | |
| 16060000087801 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 4 | PA775200 | rapporteur | |
| 16060000087802 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 5 | PA757678 | rapporteur | |
| 16060000087803 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 6 | PA736181 | rapporteur | |
| 16060000087804 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 7 | PA703514 | rapporteur | |
| 16060000087805 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 8 | PA429895 | rapporteur | |
| 16060000087806 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 9 | PA394676 | rapporteur | |
| 16060000087807 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 10 | PA775184 | rapporteur | |
| 16060000087808 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 11 | PA709298 | rapporteur | |
| 16060000087809 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 12 | PA775182 | rapporteur | |
| 16060000087810 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 13 | PA429867 | rapporteur | |
| 16060000087811 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 14 | PA736208 | rapporteur | |
| 16060000087812 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 15 | PA415467 | rapporteur | |
| 16060000087813 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 16 | PA775262 | rapporteur | |
| 16060000087814 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 17 | PA736211 | rapporteur | |
| 16060000087815 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 18 | PA415446 | rapporteur | |
| 16060000087816 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 19 | PA775284 | rapporteur | |
| 16060000087817 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 20 | PA429884 | rapporteur | |
| 16060000087818 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 21 | PA775210 | rapporteur | |
| 16060000087819 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 22 | PA429833 | rapporteur | |
| 16060000087820 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 23 | PA744079 | rapporteur | |
| 16060000087821 | L16/dossiers | 16 | 16060000087797 | 16060000087797 | 24 | PA1993 | rapporteur |