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 |
|---|---|---|---|---|---|---|---|---|
| 15060000077658 | L15/dossiers | 15 | 15060000077656 | 15060000077656 | 2 | PO782096 | ||
| 15060000077660 | L15/dossiers | 15 | 15060000077659 | 15060000077659 | 1 | PA719146 | rapporteur | |
| 15060000077661 | L15/dossiers | 15 | 15060000077659 | 15060000077659 | 2 | PO59051 | ||
| 15060000077664 | L15/dossiers | 15 | 15060000077663 | 15060000077663 | 1 | PA607619 | rapporteur | |
| 15060000077665 | L15/dossiers | 15 | 15060000077663 | 15060000077663 | 2 | PO419604 | ||
| 15060000077668 | L15/dossiers | 15 | 15060000077667 | 15060000077667 | 1 | PA605694 | rapporteur | |
| 15060000077669 | L15/dossiers | 15 | 15060000077667 | 15060000077667 | 2 | PO420120 | ||
| 15060000077672 | L15/dossiers | 15 | 15060000077671 | 15060000077671 | 1 | PA718918 | rapporteur | |
| 15060000077673 | L15/dossiers | 15 | 15060000077671 | 15060000077671 | 2 | PO59051 | ||
| 15060000077676 | L15/dossiers | 15 | 15060000077675 | 15060000077675 | 1 | PA722252 | rapporteur | |
| 15060000077677 | L15/dossiers | 15 | 15060000077675 | 15060000077675 | 2 | PO420120 | ||
| 15060000077680 | L15/dossiers | 15 | 15060000077679 | 15060000077679 | 1 | PA720696 | rapporteur | |
| 15060000077681 | L15/dossiers | 15 | 15060000077679 | 15060000077679 | 2 | PO419604 | ||
| 15060000077684 | L15/dossiers | 15 | 15060000077683 | 15060000077683 | 1 | PA720780 | rapporteur | |
| 15060000077685 | L15/dossiers | 15 | 15060000077683 | 15060000077683 | 2 | PO419610 | ||
| 15060000077689 | L15/dossiers | 15 | 15060000077688 | 15060000077688 | 1 | PA721800 | rapporteur | |
| 15060000077690 | L15/dossiers | 15 | 15060000077688 | 15060000077688 | 2 | PO59051 | ||
| 15060000077693 | L15/dossiers | 15 | 15060000077692 | 15060000077692 | 1 | PA722336 | rapporteur | |
| 15060000077694 | L15/dossiers | 15 | 15060000077692 | 15060000077692 | 2 | PO419865 | ||
| 15060000077698 | L15/dossiers | 15 | 15060000077697 | 15060000077697 | 1 | PA267306 | rapporteur | |
| 15060000077699 | L15/dossiers | 15 | 15060000077697 | 15060000077697 | 2 | PO420120 | ||
| 15060000077702 | L15/dossiers | 15 | 15060000077701 | 15060000077701 | 1 | PA721270 | rapporteur | |
| 15060000077703 | L15/dossiers | 15 | 15060000077701 | 15060000077701 | 2 | PA608292 | rapporteur | |
| 15060000077704 | L15/dossiers | 15 | 15060000077701 | 15060000077701 | 3 | PO420120 | ||
| 15060000077707 | L15/dossiers | 15 | 15060000077706 | 15060000077706 | 1 | PA719640 | rapporteur | |
| 15060000077708 | L15/dossiers | 15 | 15060000077706 | 15060000077706 | 2 | PO419604 | ||
| 15060000077711 | L15/dossiers | 15 | 15060000077710 | 15060000077710 | 1 | PA719874 | rapporteur | |
| 15060000077712 | L15/dossiers | 15 | 15060000077710 | 15060000077710 | 2 | PO59051 | ||
| 15060000077715 | L15/dossiers | 15 | 15060000077714 | 15060000077714 | 1 | PA718876 | rapporteur | |
| 15060000077716 | L15/dossiers | 15 | 15060000077714 | 15060000077714 | 2 | PO419610 | ||
| 15060000077719 | L15/dossiers | 15 | 15060000077718 | 15060000077718 | 1 | PA719072 | rapporteur | |
| 15060000077720 | L15/dossiers | 15 | 15060000077718 | 15060000077718 | 2 | PO782816 | ||
| 15060000077723 | L15/dossiers | 15 | 15060000077722 | 15060000077722 | 1 | PA719072 | rapporteur | |
| 15060000077724 | L15/dossiers | 15 | 15060000077722 | 15060000077722 | 2 | PO782816 | ||
| 15060000077727 | L15/dossiers | 15 | 15060000077726 | 15060000077726 | 1 | PA720878 | rapporteur | |
| 15060000077728 | L15/dossiers | 15 | 15060000077726 | 15060000077726 | 2 | PO782816 | ||
| 15060000077731 | L15/dossiers | 15 | 15060000077730 | 15060000077730 | 1 | PA720878 | rapporteur | |
| 15060000077732 | L15/dossiers | 15 | 15060000077730 | 15060000077730 | 2 | PO782816 | ||
| 15060000077735 | L15/dossiers | 15 | 15060000077734 | 15060000077734 | 1 | PA720170 | rapporteur | |
| 15060000077736 | L15/dossiers | 15 | 15060000077734 | 15060000077734 | 2 | PA720480 | rapporteur | |
| 15060000077737 | L15/dossiers | 15 | 15060000077734 | 15060000077734 | 3 | PO784418 | ||
| 15060000077739 | L15/dossiers | 15 | 15060000077738 | 15060000077738 | 1 | PA722194 | rapporteur | |
| 15060000077740 | L15/dossiers | 15 | 15060000077738 | 15060000077738 | 2 | PO419604 | ||
| 15060000077743 | L15/dossiers | 15 | 15060000077742 | 15060000077742 | 1 | PA720900 | rapporteur | |
| 15060000077744 | L15/dossiers | 15 | 15060000077742 | 15060000077742 | 2 | PO419604 | ||
| 15060000077747 | L15/dossiers | 15 | 15060000077746 | 15060000077746 | 1 | PA774954 | rapporteur | |
| 15060000077748 | L15/dossiers | 15 | 15060000077746 | 15060000077746 | 2 | PO419604 | ||
| 15060000077751 | L15/dossiers | 15 | 15060000077750 | 15060000077750 | 1 | PA720256 | rapporteur | |
| 15060000077752 | L15/dossiers | 15 | 15060000077750 | 15060000077750 | 2 | PO419604 | ||
| 15060000077755 | L15/dossiers | 15 | 15060000077754 | 15060000077754 | 1 | PA718728 | rapporteur |