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 |
|---|---|---|---|---|---|---|---|---|
| 14060000064605 | L14/dossiers | 14 | 14060000064604 | 14060000064604 | 1 | PA328 | auteur | |
| 14060000064609 | L14/dossiers | 14 | 14060000064608 | 14060000064608 | 1 | PO78718 | ||
| 14060000064611 | L14/dossiers | 14 | 14060000064610 | 14060000064610 | 1 | PA1243 | rapporteur | |
| 14060000064612 | L14/dossiers | 14 | 14060000064610 | 14060000064610 | 2 | PO678157 | ||
| 14060000064615 | L14/dossiers | 14 | 14060000064614 | 14060000064614 | 1 | PO644420 | ||
| 14060000064618 | L14/dossiers | 14 | 14060000064617 | 14060000064617 | 1 | PA415483 | rapporteur pour avis | |
| 14060000064619 | L14/dossiers | 14 | 14060000064617 | 14060000064617 | 2 | PO211493 | ||
| 14060000064621 | L14/dossiers | 14 | 14060000064620 | 14060000064620 | 1 | PA1243 | rapporteur | |
| 14060000064622 | L14/dossiers | 14 | 14060000064620 | 14060000064620 | 2 | PO678157 | ||
| 14060000064624 | L14/dossiers | 14 | 14060000064623 | 14060000064623 | 1 | PA2056 | rapporteur | |
| 14060000064625 | L14/dossiers | 14 | 14060000064623 | 14060000064623 | 2 | PO211494 | ||
| 14060000064627 | L14/dossiers | 14 | 14060000064626 | 14060000064626 | 1 | PA1243 | rapporteur | |
| 14060000064628 | L14/dossiers | 14 | 14060000064626 | 14060000064626 | 2 | PO683757 | ||
| 14060000064630 | L14/dossiers | 14 | 14060000064629 | 14060000064629 | 1 | PA2056 | rapporteur | |
| 14060000064631 | L14/dossiers | 14 | 14060000064629 | 14060000064629 | 2 | PO683757 | ||
| 14060000064633 | L14/dossiers | 14 | 14060000064632 | 14060000064632 | 1 | PO644420 | ||
| 14060000064636 | L14/dossiers | 14 | 14060000064635 | 14060000064635 | 1 | PA391505 | rapporteur | |
| 14060000064637 | L14/dossiers | 14 | 14060000064635 | 14060000064635 | 2 | PO310693 | ||
| 14060000064639 | L14/dossiers | 14 | 14060000064638 | 14060000064638 | 1 | PA609983 | rapporteur | |
| 14060000064640 | L14/dossiers | 14 | 14060000064638 | 14060000064638 | 2 | PO697810 | ||
| 14060000064648 | L14/dossiers | 14 | 14060000064641 | 14060000064641 | 1 | PA429844 | rapporteur | |
| 14060000064649 | L14/dossiers | 14 | 14060000064641 | 14060000064641 | 2 | PO699895 | ||
| 14060000064651 | L14/dossiers | 14 | 14060000064650 | 14060000064650 | 1 | PA429844 | rapporteur | |
| 14060000064652 | L14/dossiers | 14 | 14060000064650 | 14060000064650 | 2 | PO709717 | ||
| 14060000064654 | L14/dossiers | 14 | 14060000064653 | 14060000064653 | 1 | PA429844 | rapporteur | |
| 14060000064655 | L14/dossiers | 14 | 14060000064653 | 14060000064653 | 2 | PO699895 | ||
| 14060000064657 | L14/dossiers | 14 | 14060000064656 | 14060000064656 | 1 | PA609983 | rapporteur | |
| 14060000064658 | L14/dossiers | 14 | 14060000064656 | 14060000064656 | 2 | PO709717 | ||
| 14060000064660 | L14/dossiers | 14 | 14060000064659 | 14060000064659 | 1 | PA429844 | rapporteur | |
| 14060000064661 | L14/dossiers | 14 | 14060000064659 | 14060000064659 | 2 | PO699895 | ||
| 14060000064663 | L14/dossiers | 14 | 14060000064662 | 14060000064662 | 1 | PA609983 | rapporteur | |
| 14060000064664 | L14/dossiers | 14 | 14060000064662 | 14060000064662 | 2 | PO697810 | ||
| 14060000064666 | L14/dossiers | 14 | 14060000064665 | 14060000064665 | 1 | PA609983 | rapporteur | |
| 14060000064667 | L14/dossiers | 14 | 14060000064665 | 14060000064665 | 2 | PO697810 | ||
| 14060000064669 | L14/dossiers | 14 | 14060000064668 | 14060000064668 | 1 | PO78718 | ||
| 14060000064671 | L14/dossiers | 14 | 14060000064670 | 14060000064670 | 1 | PA609983 | rapporteur | |
| 14060000064672 | L14/dossiers | 14 | 14060000064670 | 14060000064670 | 2 | PO697810 | ||
| 14060000064675 | L14/dossiers | 14 | 14060000064674 | 14060000064674 | 1 | PO644420 | ||
| 14060000064678 | L14/dossiers | 14 | 14060000064677 | 14060000064677 | 1 | PA1886 | auteur | |
| 14060000064800 | L14/dossiers | 14 | 14060000064799 | 14060000064799 | 1 | PO78718 | ||
| 14060000064802 | L14/dossiers | 14 | 14060000064801 | 14060000064801 | 1 | PA334 | rapporteur | |
| 14060000064803 | L14/dossiers | 14 | 14060000064801 | 14060000064801 | 2 | PO59047 | ||
| 14060000064805 | L14/dossiers | 14 | 14060000064804 | 14060000064804 | 1 | PO644420 | ||
| 14060000064808 | L14/dossiers | 14 | 14060000064807 | 14060000064807 | 1 | PA609983 | rapporteur | |
| 14060000064809 | L14/dossiers | 14 | 14060000064807 | 14060000064807 | 2 | PO697810 | ||
| 14060000064812 | L14/dossiers | 14 | 14060000064811 | 14060000064811 | 1 | PO78718 | ||
| 14060000064814 | L14/dossiers | 14 | 14060000064813 | 14060000064813 | 1 | PA609983 | rapporteur | |
| 14060000064815 | L14/dossiers | 14 | 14060000064813 | 14060000064813 | 2 | PO697810 | ||
| 14060000064818 | L14/dossiers | 14 | 14060000064817 | 14060000064817 | 1 | PO644420 | ||
| 14060000064821 | L14/dossiers | 14 | 14060000064820 | 14060000064820 | 1 | PA330240 | auteur |