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 |
|---|---|---|---|---|---|---|---|---|
| 14060000051789 | L14/dossiers | 14 | 14060000051788 | 14060000051788 | 1 | PA2528 | rapporteur | |
| 14060000051790 | L14/dossiers | 14 | 14060000051788 | 14060000051788 | 2 | PO211491 | ||
| 14060000051792 | L14/dossiers | 14 | 14060000051791 | 14060000051791 | 1 | PA346886 | auteur | |
| 14060000051795 | L14/dossiers | 14 | 14060000051794 | 14060000051794 | 1 | PA1071 | rapporteur | |
| 14060000051796 | L14/dossiers | 14 | 14060000051794 | 14060000051794 | 2 | PO211491 | ||
| 14060000051798 | L14/dossiers | 14 | 14060000051797 | 14060000051797 | 1 | PA610891 | auteur | |
| 14060000051799 | L14/dossiers | 14 | 14060000051797 | 14060000051797 | 2 | PA345897 | auteur | |
| 14060000051801 | L14/dossiers | 14 | 14060000051800 | 14060000051800 | 1 | PA942 | rapporteur | |
| 14060000051802 | L14/dossiers | 14 | 14060000051800 | 14060000051800 | 2 | PO59051 | ||
| 14060000051804 | L14/dossiers | 14 | 14060000051803 | 14060000051803 | 1 | PA942 | rapporteur | |
| 14060000051805 | L14/dossiers | 14 | 14060000051803 | 14060000051803 | 2 | PO59051 | ||
| 14060000051807 | L14/dossiers | 14 | 14060000051806 | 14060000051806 | 1 | PA588 | auteur | |
| 14060000051837 | L14/dossiers | 14 | 14060000051836 | 14060000051836 | 1 | PA608416 | auteur | |
| 14060000051872 | L14/dossiers | 14 | 14060000051871 | 14060000051871 | 1 | PA872 | rapporteur | |
| 14060000051873 | L14/dossiers | 14 | 14060000051871 | 14060000051871 | 2 | PO694085 | ||
| 14060000051875 | L14/dossiers | 14 | 14060000051874 | 14060000051874 | 1 | PA2377 | auteur | |
| 14060000051878 | L14/dossiers | 14 | 14060000051877 | 14060000051877 | 1 | PO644420 | ||
| 14060000051881 | L14/dossiers | 14 | 14060000051880 | 14060000051880 | 1 | PO644420 | ||
| 14060000051884 | L14/dossiers | 14 | 14060000051883 | 14060000051883 | 1 | PO78718 | ||
| 14060000051886 | L14/dossiers | 14 | 14060000051885 | 14060000051885 | 1 | PO644420 | ||
| 14060000051889 | L14/dossiers | 14 | 14060000051888 | 14060000051888 | 1 | PA267622 | auteur | |
| 14060000051892 | L14/dossiers | 14 | 14060000051891 | 14060000051891 | 1 | PA267835 | rapporteur | |
| 14060000051893 | L14/dossiers | 14 | 14060000051891 | 14060000051891 | 2 | PA605426 | rapporteur | |
| 14060000051894 | L14/dossiers | 14 | 14060000051891 | 14060000051891 | 3 | PO59051 | ||
| 14060000051897 | L14/dossiers | 14 | 14060000051896 | 14060000051896 | 1 | PO78718 | ||
| 14060000051899 | L14/dossiers | 14 | 14060000051898 | 14060000051898 | 1 | PA267835 | rapporteur | |
| 14060000051900 | L14/dossiers | 14 | 14060000051898 | 14060000051898 | 2 | PA605426 | rapporteur | |
| 14060000051901 | L14/dossiers | 14 | 14060000051898 | 14060000051898 | 3 | PO59051 | ||
| 14060000051904 | L14/dossiers | 14 | 14060000051903 | 14060000051903 | 1 | PA267622 | auteur | |
| 14060000051906 | L14/dossiers | 14 | 14060000051905 | 14060000051905 | 1 | PA267340 | rapporteur | |
| 14060000051907 | L14/dossiers | 14 | 14060000051905 | 14060000051905 | 2 | PO211495 | ||
| 14060000051909 | L14/dossiers | 14 | 14060000051908 | 14060000051908 | 1 | PA267835 | rapporteur | |
| 14060000051910 | L14/dossiers | 14 | 14060000051908 | 14060000051908 | 2 | PA605426 | rapporteur | |
| 14060000051911 | L14/dossiers | 14 | 14060000051908 | 14060000051908 | 3 | PO59051 | ||
| 14060000051913 | L14/dossiers | 14 | 14060000051912 | 14060000051912 | 1 | PA267835 | rapporteur | |
| 14060000051914 | L14/dossiers | 14 | 14060000051912 | 14060000051912 | 2 | PA605426 | rapporteur | |
| 14060000051915 | L14/dossiers | 14 | 14060000051912 | 14060000051912 | 3 | PO59051 | ||
| 14060000051917 | L14/dossiers | 14 | 14060000051916 | 14060000051916 | 1 | PA267835 | rapporteur | |
| 14060000051918 | L14/dossiers | 14 | 14060000051916 | 14060000051916 | 2 | PA605426 | rapporteur | |
| 14060000051919 | L14/dossiers | 14 | 14060000051916 | 14060000051916 | 3 | PO716278 | ||
| 14060000051921 | L14/dossiers | 14 | 14060000051920 | 14060000051920 | 1 | PA267340 | rapporteur | |
| 14060000051922 | L14/dossiers | 14 | 14060000051920 | 14060000051920 | 2 | PO211495 | ||
| 14060000051924 | L14/dossiers | 14 | 14060000051923 | 14060000051923 | 1 | PA267340 | rapporteur | |
| 14060000051925 | L14/dossiers | 14 | 14060000051923 | 14060000051923 | 2 | PO716278 | ||
| 14060000051927 | L14/dossiers | 14 | 14060000051926 | 14060000051926 | 1 | PA267622 | auteur | |
| 14060000051929 | L14/dossiers | 14 | 14060000051928 | 14060000051928 | 1 | PA267622 | auteur | |
| 14060000051933 | L14/dossiers | 14 | 14060000051932 | 14060000051932 | 1 | PA2631 | rapporteur | |
| 14060000051934 | L14/dossiers | 14 | 14060000051932 | 14060000051932 | 2 | PO304272 | ||
| 14060000051936 | L14/dossiers | 14 | 14060000051935 | 14060000051935 | 1 | PA2503 | rapporteur | |
| 14060000051937 | L14/dossiers | 14 | 14060000051935 | 14060000051935 | 2 | PA345937 | rapporteur |