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 |
|---|---|---|---|---|---|---|---|---|
| 16060000089678 | L16/dossiers | 16 | 16060000089675 | 16060000089675 | 3 | PO419610 | ||
| 16060000089680 | L16/dossiers | 16 | 16060000089679 | 16060000089679 | 1 | PA719032 | rapporteur | |
| 16060000089681 | L16/dossiers | 16 | 16060000089679 | 16060000089679 | 2 | PO304272 | ||
| 16060000089683 | L16/dossiers | 16 | 16060000089682 | 16060000089682 | 1 | PA720684 | rapporteur | |
| 16060000089684 | L16/dossiers | 16 | 16060000089682 | 16060000089682 | 2 | PA719550 | rapporteur | |
| 16060000089685 | L16/dossiers | 16 | 16060000089682 | 16060000089682 | 3 | PO415287 | ||
| 16060000089687 | L16/dossiers | 16 | 16060000089686 | 16060000089686 | 1 | PA719472 | rapporteur | |
| 16060000089688 | L16/dossiers | 16 | 16060000089686 | 16060000089686 | 2 | PO59048 | ||
| 16060000089690 | L16/dossiers | 16 | 16060000089689 | 16060000089689 | 1 | PA795164 | rapporteur | |
| 16060000089691 | L16/dossiers | 16 | 16060000089689 | 16060000089689 | 2 | PO415287 | ||
| 16060000089693 | L16/dossiers | 16 | 16060000089692 | 16060000089692 | 1 | PA795046 | rapporteur | |
| 16060000089694 | L16/dossiers | 16 | 16060000089692 | 16060000089692 | 2 | PA793246 | rapporteur | |
| 16060000089695 | L16/dossiers | 16 | 16060000089692 | 16060000089692 | 3 | PO419610 | ||
| 16060000089697 | L16/dossiers | 16 | 16060000089696 | 16060000089696 | 1 | PA719396 | rapporteur | |
| 16060000089698 | L16/dossiers | 16 | 16060000089696 | 16060000089696 | 2 | PA643089 | rapporteur | |
| 16060000089699 | L16/dossiers | 16 | 16060000089696 | 16060000089696 | 3 | PO59046 | ||
| 16060000089707 | L16/dossiers | 16 | 16060000089700 | 16060000089700 | 1 | PA793520 | rapporteur | |
| 16060000089708 | L16/dossiers | 16 | 16060000089700 | 16060000089700 | 2 | PO825342 | ||
| 16060000089710 | L16/dossiers | 16 | 16060000089709 | 16060000089709 | 1 | PA794510 | rapporteur | |
| 16060000089711 | L16/dossiers | 16 | 16060000089709 | 16060000089709 | 2 | PO59048 | ||
| 16060000089713 | L16/dossiers | 16 | 16060000089712 | 16060000089712 | 1 | PA795950 | rapporteur | |
| 16060000089714 | L16/dossiers | 16 | 16060000089712 | 16060000089712 | 2 | PA794450 | rapporteur | |
| 16060000089715 | L16/dossiers | 16 | 16060000089712 | 16060000089712 | 3 | PO59048 | ||
| 16060000089717 | L16/dossiers | 16 | 16060000089716 | 16060000089716 | 1 | PA795200 | rapporteur | |
| 16060000089718 | L16/dossiers | 16 | 16060000089716 | 16060000089716 | 2 | PA793884 | rapporteur | |
| 16060000089719 | L16/dossiers | 16 | 16060000089716 | 16060000089716 | 3 | PO59048 | ||
| 16060000089721 | L16/dossiers | 16 | 16060000089720 | 16060000089720 | 1 | PA794802 | rapporteur | |
| 16060000089722 | L16/dossiers | 16 | 16060000089720 | 16060000089720 | 2 | PO59048 | ||
| 16060000089724 | L16/dossiers | 16 | 16060000089723 | 16060000089723 | 1 | PA720146 | rapporteur | |
| 16060000089725 | L16/dossiers | 16 | 16060000089723 | 16060000089723 | 2 | PA795786 | rapporteur | |
| 16060000089726 | L16/dossiers | 16 | 16060000089723 | 16060000089723 | 3 | PO415287 | ||
| 16060000089728 | L16/dossiers | 16 | 16060000089727 | 16060000089727 | 1 | PA942 | rapporteur | |
| 16060000089729 | L16/dossiers | 16 | 16060000089727 | 16060000089727 | 2 | PO59048 | ||
| 16060000089731 | L16/dossiers | 16 | 16060000089730 | 16060000089730 | 1 | PA721632 | rapporteur | |
| 16060000089732 | L16/dossiers | 16 | 16060000089730 | 16060000089730 | 2 | PA793816 | rapporteur | |
| 16060000089733 | L16/dossiers | 16 | 16060000089730 | 16060000089730 | 3 | PO59046 | ||
| 16060000089735 | L16/dossiers | 16 | 16060000089734 | 16060000089734 | 1 | PA721024 | rapporteur | |
| 16060000089736 | L16/dossiers | 16 | 16060000089734 | 16060000089734 | 2 | PA720846 | rapporteur | |
| 16060000089737 | L16/dossiers | 16 | 16060000089734 | 16060000089734 | 3 | PO59046 | ||
| 16060000089739 | L16/dossiers | 16 | 16060000089738 | 16060000089738 | 1 | PA793616 | rapporteur | |
| 16060000089740 | L16/dossiers | 16 | 16060000089738 | 16060000089738 | 2 | PO59048 | ||
| 16060000089742 | L16/dossiers | 16 | 16060000089741 | 16060000089741 | 1 | PA793624 | rapporteur | |
| 16060000089743 | L16/dossiers | 16 | 16060000089741 | 16060000089741 | 2 | PO59048 | ||
| 16060000089745 | L16/dossiers | 16 | 16060000089744 | 16060000089744 | 1 | PA722292 | rapporteur | |
| 16060000089746 | L16/dossiers | 16 | 16060000089744 | 16060000089744 | 2 | PA794494 | rapporteur | |
| 16060000089747 | L16/dossiers | 16 | 16060000089744 | 16060000089744 | 3 | PO59051 | ||
| 16060000089749 | L16/dossiers | 16 | 16060000089748 | 16060000089748 | 1 | PA719024 | rapporteur | |
| 16060000089750 | L16/dossiers | 16 | 16060000089748 | 16060000089748 | 2 | PA794458 | rapporteur | |
| 16060000089751 | L16/dossiers | 16 | 16060000089748 | 16060000089748 | 3 | PO59046 | ||
| 16060000089753 | L16/dossiers | 16 | 16060000089752 | 16060000089752 | 1 | PA721426 | rapporteur |