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 |
|---|---|---|---|---|---|---|---|---|
| 17060000110647 | L17/dossiers | 17 | 17060000110646 | 17060000110646 | 1 | PA828008 | rapporteur | |
| 17060000110648 | L17/dossiers | 17 | 17060000110646 | 17060000110646 | 2 | PO211495 | ||
| 17060000110650 | L17/dossiers | 17 | 17060000110649 | 17060000110649 | 1 | PA775234 | rapporteur | |
| 17060000110651 | L17/dossiers | 17 | 17060000110649 | 17060000110649 | 2 | PO211491 | ||
| 17060000110653 | L17/dossiers | 17 | 17060000110652 | 17060000110652 | 1 | PA736177 | rapporteur | |
| 17060000110654 | L17/dossiers | 17 | 17060000110652 | 17060000110652 | 2 | PO211491 | ||
| 17060000110656 | L17/dossiers | 17 | 17060000110655 | 17060000110655 | 1 | PA703498 | rapporteur | |
| 17060000110657 | L17/dossiers | 17 | 17060000110655 | 17060000110655 | 2 | PO211493 | ||
| 17060000110659 | L17/dossiers | 17 | 17060000110658 | 17060000110658 | 1 | PA827952 | rapporteur | |
| 17060000110660 | L17/dossiers | 17 | 17060000110658 | 17060000110658 | 2 | PO870658 | ||
| 17060000110662 | L17/dossiers | 17 | 17060000110661 | 17060000110661 | 1 | PA736223 | rapporteur | |
| 17060000110663 | L17/dossiers | 17 | 17060000110661 | 17060000110661 | 2 | PO211493 | ||
| 17060000110665 | L17/dossiers | 17 | 17060000110664 | 17060000110664 | 1 | PA736233 | rapporteur | |
| 17060000110666 | L17/dossiers | 17 | 17060000110664 | 17060000110664 | 2 | PO211493 | ||
| 17060000110668 | L17/dossiers | 17 | 17060000110667 | 17060000110667 | 1 | PA775248 | rapporteur | |
| 17060000110669 | L17/dossiers | 17 | 17060000110667 | 17060000110667 | 2 | PO211495 | ||
| 17060000110671 | L17/dossiers | 17 | 17060000110670 | 17060000110670 | 1 | PA703494 | rapporteur | |
| 17060000110672 | L17/dossiers | 17 | 17060000110670 | 17060000110670 | 2 | PO211495 | ||
| 17060000110674 | L17/dossiers | 17 | 17060000110673 | 17060000110673 | 1 | PA1127 | rapporteur | |
| 17060000110675 | L17/dossiers | 17 | 17060000110673 | 17060000110673 | 2 | PO870970 | ||
| 17060000110677 | L17/dossiers | 17 | 17060000110676 | 17060000110676 | 1 | PA715745 | rapporteur | |
| 17060000110678 | L17/dossiers | 17 | 17060000110676 | 17060000110676 | 2 | PO870155 | ||
| 17060000110680 | L17/dossiers | 17 | 17060000110679 | 17060000110679 | 1 | PA775204 | rapporteur | |
| 17060000110681 | L17/dossiers | 17 | 17060000110679 | 17060000110679 | 2 | PA775208 | rapporteur | |
| 17060000110682 | L17/dossiers | 17 | 17060000110679 | 17060000110679 | 3 | PO516753 | ||
| 17060000110684 | L17/dossiers | 17 | 17060000110683 | 17060000110683 | 1 | PA773891 | rapporteur | |
| 17060000110685 | L17/dossiers | 17 | 17060000110683 | 17060000110683 | 2 | PO871555 | ||
| 17060000110687 | L17/dossiers | 17 | 17060000110686 | 17060000110686 | 1 | PA736227 | rapporteur | |
| 17060000110688 | L17/dossiers | 17 | 17060000110686 | 17060000110686 | 2 | PO211491 | ||
| 17060000110690 | L17/dossiers | 17 | 17060000110689 | 17060000110689 | 1 | PA775302 | rapporteur | |
| 17060000110691 | L17/dossiers | 17 | 17060000110689 | 17060000110689 | 2 | PO211490 | ||
| 17060000110693 | L17/dossiers | 17 | 17060000110692 | 17060000110692 | 1 | PA827918 | rapporteur | |
| 17060000110694 | L17/dossiers | 17 | 17060000110692 | 17060000110692 | 2 | PA758716 | rapporteur | |
| 17060000110695 | L17/dossiers | 17 | 17060000110692 | 17060000110692 | 3 | PO871404 | ||
| 17060000110697 | L17/dossiers | 17 | 17060000110696 | 17060000110696 | 1 | PA703510 | rapporteur | |
| 17060000110698 | L17/dossiers | 17 | 17060000110696 | 17060000110696 | 2 | PA827902 | rapporteur | |
| 17060000110699 | L17/dossiers | 17 | 17060000110696 | 17060000110696 | 3 | PO872142 | ||
| 17060000110701 | L17/dossiers | 17 | 17060000110700 | 17060000110700 | 1 | PA827952 | rapporteur | |
| 17060000110702 | L17/dossiers | 17 | 17060000110700 | 17060000110700 | 2 | PO211495 | ||
| 17060000110704 | L17/dossiers | 17 | 17060000110703 | 17060000110703 | 1 | PA736239 | rapporteur | |
| 17060000110705 | L17/dossiers | 17 | 17060000110703 | 17060000110703 | 2 | PA827976 | rapporteur | |
| 17060000110706 | L17/dossiers | 17 | 17060000110703 | 17060000110703 | 3 | PO872327 | ||
| 17060000110708 | L17/dossiers | 17 | 17060000110707 | 17060000110707 | 1 | PA827952 | rapporteur | |
| 17060000110709 | L17/dossiers | 17 | 17060000110707 | 17060000110707 | 2 | PO211495 | ||
| 17060000110711 | L17/dossiers | 17 | 17060000110710 | 17060000110710 | 1 | PO78718 | ||
| 17060000110713 | L17/dossiers | 17 | 17060000110712 | 17060000110712 | 1 | PO78718 | ||
| 17060000110715 | L17/dossiers | 17 | 17060000110714 | 17060000110714 | 1 | PA703510 | rapporteur | |
| 17060000110716 | L17/dossiers | 17 | 17060000110714 | 17060000110714 | 2 | PA610850 | rapporteur | |
| 17060000110717 | L17/dossiers | 17 | 17060000110714 | 17060000110714 | 3 | PO211495 | ||
| 17060000110719 | L17/dossiers | 17 | 17060000110718 | 17060000110718 | 1 | PA429875 | rapporteur |