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 |
|---|---|---|---|---|---|---|---|---|
| 14060000050578 | L14/dossiers | 14 | 14060000050577 | 14060000050577 | 1 | PA267622 | auteur | |
| 14060000050580 | L14/dossiers | 14 | 14060000050579 | 14060000050579 | 1 | PA2876 | auteur | |
| 14060000050583 | L14/dossiers | 14 | 14060000050582 | 14060000050582 | 1 | PA328 | auteur | |
| 14060000050587 | L14/dossiers | 14 | 14060000050586 | 14060000050586 | 1 | PA2664 | auteur | |
| 14060000050646 | L14/dossiers | 14 | 14060000050645 | 14060000050645 | 1 | PA346886 | auteur | |
| 14060000050648 | L14/dossiers | 14 | 14060000050647 | 14060000050647 | 1 | PA1866 | rapporteur | |
| 14060000050649 | L14/dossiers | 14 | 14060000050647 | 14060000050647 | 2 | PO58974 | ||
| 14060000050651 | L14/dossiers | 14 | 14060000050650 | 14060000050650 | 1 | PO644420 | ||
| 14060000050654 | L14/dossiers | 14 | 14060000050653 | 14060000050653 | 1 | PO78718 | ||
| 14060000050656 | L14/dossiers | 14 | 14060000050655 | 14060000050655 | 1 | PO78718 | ||
| 14060000050658 | L14/dossiers | 14 | 14060000050657 | 14060000050657 | 1 | PA1401 | rapporteur | |
| 14060000050659 | L14/dossiers | 14 | 14060000050657 | 14060000050657 | 2 | PO59051 | ||
| 14060000050662 | L14/dossiers | 14 | 14060000050661 | 14060000050661 | 1 | PO644420 | ||
| 14060000050665 | L14/dossiers | 14 | 14060000050664 | 14060000050664 | 1 | PA328 | auteur | |
| 14060000050669 | L14/dossiers | 14 | 14060000050668 | 14060000050668 | 1 | PA1401 | rapporteur | |
| 14060000050670 | L14/dossiers | 14 | 14060000050668 | 14060000050668 | 2 | PO59051 | ||
| 14060000050672 | L14/dossiers | 14 | 14060000050671 | 14060000050671 | 1 | PA1401 | rapporteur | |
| 14060000050673 | L14/dossiers | 14 | 14060000050671 | 14060000050671 | 2 | PO59051 | ||
| 14060000050675 | L14/dossiers | 14 | 14060000050674 | 14060000050674 | 1 | PA328 | auteur | |
| 14060000050677 | L14/dossiers | 14 | 14060000050676 | 14060000050676 | 1 | PA1401 | rapporteur | |
| 14060000050678 | L14/dossiers | 14 | 14060000050676 | 14060000050676 | 2 | PO696274 | ||
| 14060000050680 | L14/dossiers | 14 | 14060000050679 | 14060000050679 | 1 | PA2876 | auteur | |
| 14060000050683 | L14/dossiers | 14 | 14060000050682 | 14060000050682 | 1 | PA610354 | rapporteur | |
| 14060000050684 | L14/dossiers | 14 | 14060000050682 | 14060000050682 | 2 | PO59051 | ||
| 14060000050687 | L14/dossiers | 14 | 14060000050686 | 14060000050686 | 1 | PO78718 | ||
| 14060000050689 | L14/dossiers | 14 | 14060000050688 | 14060000050688 | 1 | PA267622 | auteur | |
| 14060000050693 | L14/dossiers | 14 | 14060000050692 | 14060000050692 | 1 | PO644420 | ||
| 14060000050696 | L14/dossiers | 14 | 14060000050695 | 14060000050695 | 1 | PA267622 | auteur | |
| 14060000050698 | L14/dossiers | 14 | 14060000050697 | 14060000050697 | 1 | PA610354 | rapporteur | |
| 14060000050699 | L14/dossiers | 14 | 14060000050697 | 14060000050697 | 2 | PO59051 | ||
| 14060000050701 | L14/dossiers | 14 | 14060000050700 | 14060000050700 | 1 | PA610354 | rapporteur | |
| 14060000050702 | L14/dossiers | 14 | 14060000050700 | 14060000050700 | 2 | PO714525 | ||
| 14060000050704 | L14/dossiers | 14 | 14060000050703 | 14060000050703 | 1 | PA2161 | rapporteur | |
| 14060000050705 | L14/dossiers | 14 | 14060000050703 | 14060000050703 | 2 | PO714525 | ||
| 14060000050707 | L14/dossiers | 14 | 14060000050706 | 14060000050706 | 1 | PA2161 | rapporteur | |
| 14060000050708 | L14/dossiers | 14 | 14060000050706 | 14060000050706 | 2 | PO211495 | ||
| 14060000050710 | L14/dossiers | 14 | 14060000050709 | 14060000050709 | 1 | PA267622 | auteur | |
| 14060000050712 | L14/dossiers | 14 | 14060000050711 | 14060000050711 | 1 | PA2631 | rapporteur | |
| 14060000050713 | L14/dossiers | 14 | 14060000050711 | 14060000050711 | 2 | PO304272 | ||
| 14060000050715 | L14/dossiers | 14 | 14060000050714 | 14060000050714 | 1 | PA1874 | auteur | |
| 14060000050718 | L14/dossiers | 14 | 14060000050717 | 14060000050717 | 1 | PA605143 | rapporteur | |
| 14060000050719 | L14/dossiers | 14 | 14060000050717 | 14060000050717 | 2 | PA332886 | rapporteur | |
| 14060000050720 | L14/dossiers | 14 | 14060000050717 | 14060000050717 | 3 | PO59048 | ||
| 14060000050722 | L14/dossiers | 14 | 14060000050721 | 14060000050721 | 1 | PA2099 | auteur | |
| 14060000050778 | L14/dossiers | 14 | 14060000050777 | 14060000050777 | 1 | PA1654 | auteur | |
| 14060000050782 | L14/dossiers | 14 | 14060000050781 | 14060000050781 | 1 | PA345994 | rapporteur | |
| 14060000050783 | L14/dossiers | 14 | 14060000050781 | 14060000050781 | 2 | PO59047 | ||
| 14060000050786 | L14/dossiers | 14 | 14060000050785 | 14060000050785 | 1 | PA328 | auteur | |
| 14060000050789 | L14/dossiers | 14 | 14060000050788 | 14060000050788 | 1 | PO644420 | ||
| 14060000050792 | L14/dossiers | 14 | 14060000050791 | 14060000050791 | 1 | PA345994 | rapporteur |