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 |
|---|---|---|---|---|---|---|---|---|
| 14060000051546 | L14/dossiers | 14 | 14060000051544 | 14060000051544 | 2 | PO415287 | ||
| 14060000051548 | L14/dossiers | 14 | 14060000051547 | 14060000051547 | 1 | PA267492 | auteur | |
| 14060000051559 | L14/dossiers | 14 | 14060000051558 | 14060000051558 | 1 | PA267622 | auteur | |
| 14060000051563 | L14/dossiers | 14 | 14060000051562 | 14060000051562 | 1 | PA2876 | rapporteur | |
| 14060000051564 | L14/dossiers | 14 | 14060000051562 | 14060000051562 | 2 | PO420120 | ||
| 14060000051566 | L14/dossiers | 14 | 14060000051565 | 14060000051565 | 1 | PA267576 | auteur | |
| 14060000051687 | L14/dossiers | 14 | 14060000051686 | 14060000051686 | 1 | PA328 | auteur | |
| 14060000051690 | L14/dossiers | 14 | 14060000051689 | 14060000051689 | 1 | PA1155 | auteur | |
| 14060000051693 | L14/dossiers | 14 | 14060000051692 | 14060000051692 | 1 | PA266788 | auteur | |
| 14060000051696 | L14/dossiers | 14 | 14060000051695 | 14060000051695 | 1 | PA2048 | auteur | |
| 14060000051699 | L14/dossiers | 14 | 14060000051698 | 14060000051698 | 1 | PO644420 | ||
| 14060000051702 | L14/dossiers | 14 | 14060000051701 | 14060000051701 | 1 | PA610354 | rapporteur | |
| 14060000051703 | L14/dossiers | 14 | 14060000051701 | 14060000051701 | 2 | PO59051 | ||
| 14060000051706 | L14/dossiers | 14 | 14060000051705 | 14060000051705 | 1 | PA610354 | rapporteur | |
| 14060000051707 | L14/dossiers | 14 | 14060000051705 | 14060000051705 | 2 | PO59051 | ||
| 14060000051710 | L14/dossiers | 14 | 14060000051709 | 14060000051709 | 1 | PO78718 | ||
| 14060000051712 | L14/dossiers | 14 | 14060000051711 | 14060000051711 | 1 | PO78718 | ||
| 14060000051714 | L14/dossiers | 14 | 14060000051713 | 14060000051713 | 1 | PA328 | auteur | |
| 14060000051717 | L14/dossiers | 14 | 14060000051716 | 14060000051716 | 1 | PA703522 | rapporteur | |
| 14060000051718 | L14/dossiers | 14 | 14060000051716 | 14060000051716 | 2 | PO211495 | ||
| 14060000051720 | L14/dossiers | 14 | 14060000051719 | 14060000051719 | 1 | PA1048 | rapporteur | |
| 14060000051721 | L14/dossiers | 14 | 14060000051719 | 14060000051719 | 2 | PO211495 | ||
| 14060000051723 | L14/dossiers | 14 | 14060000051722 | 14060000051722 | 1 | PA1048 | rapporteur | |
| 14060000051724 | L14/dossiers | 14 | 14060000051722 | 14060000051722 | 2 | PO693149 | ||
| 14060000051726 | L14/dossiers | 14 | 14060000051725 | 14060000051725 | 1 | PA610354 | rapporteur | |
| 14060000051727 | L14/dossiers | 14 | 14060000051725 | 14060000051725 | 2 | PO693149 | ||
| 14060000051729 | L14/dossiers | 14 | 14060000051728 | 14060000051728 | 1 | PA610354 | rapporteur | |
| 14060000051730 | L14/dossiers | 14 | 14060000051728 | 14060000051728 | 2 | PO59051 | ||
| 14060000051732 | L14/dossiers | 14 | 14060000051731 | 14060000051731 | 1 | PA610354 | rapporteur | |
| 14060000051733 | L14/dossiers | 14 | 14060000051731 | 14060000051731 | 2 | PO59051 | ||
| 14060000051735 | L14/dossiers | 14 | 14060000051734 | 14060000051734 | 1 | PA328 | auteur | |
| 14060000051737 | L14/dossiers | 14 | 14060000051736 | 14060000051736 | 1 | PA1048 | rapporteur | |
| 14060000051738 | L14/dossiers | 14 | 14060000051736 | 14060000051736 | 2 | PO211495 | ||
| 14060000051740 | L14/dossiers | 14 | 14060000051739 | 14060000051739 | 1 | PA330684 | auteur | |
| 14060000051756 | L14/dossiers | 14 | 14060000051755 | 14060000051755 | 1 | PO644420 | ||
| 14060000051759 | L14/dossiers | 14 | 14060000051758 | 14060000051758 | 1 | PA333335 | rapporteur | |
| 14060000051760 | L14/dossiers | 14 | 14060000051758 | 14060000051758 | 2 | PO419604 | ||
| 14060000051763 | L14/dossiers | 14 | 14060000051762 | 14060000051762 | 1 | PO78718 | ||
| 14060000051765 | L14/dossiers | 14 | 14060000051764 | 14060000051764 | 1 | PA267622 | auteur | |
| 14060000051769 | L14/dossiers | 14 | 14060000051768 | 14060000051768 | 1 | PA333335 | rapporteur | |
| 14060000051770 | L14/dossiers | 14 | 14060000051768 | 14060000051768 | 2 | PO705602 | ||
| 14060000051772 | L14/dossiers | 14 | 14060000051771 | 14060000051771 | 1 | PA333335 | rapporteur | |
| 14060000051773 | L14/dossiers | 14 | 14060000051771 | 14060000051771 | 2 | PO419604 | ||
| 14060000051775 | L14/dossiers | 14 | 14060000051774 | 14060000051774 | 1 | PA267622 | auteur | |
| 14060000051777 | L14/dossiers | 14 | 14060000051776 | 14060000051776 | 1 | PA304021 | rapporteur | |
| 14060000051778 | L14/dossiers | 14 | 14060000051776 | 14060000051776 | 2 | PO705602 | ||
| 14060000051780 | L14/dossiers | 14 | 14060000051779 | 14060000051779 | 1 | PO644420 | ||
| 14060000051783 | L14/dossiers | 14 | 14060000051782 | 14060000051782 | 1 | PA267622 | auteur | |
| 14060000051786 | L14/dossiers | 14 | 14060000051785 | 14060000051785 | 1 | PA1182 | rapporteur | |
| 14060000051787 | L14/dossiers | 14 | 14060000051785 | 14060000051785 | 2 | PO59047 |