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 |
|---|---|---|---|---|---|---|---|---|
| 16060000084571 | L16/dossiers | 16 | 16060000084569 | 16060000084569 | 2 | PO211495 | ||
| 16060000084573 | L16/dossiers | 16 | 16060000084572 | 16060000084572 | 1 | PA267907 | rapporteur | |
| 16060000084574 | L16/dossiers | 16 | 16060000084572 | 16060000084572 | 2 | PO211491 | ||
| 16060000084576 | L16/dossiers | 16 | 16060000084575 | 16060000084575 | 1 | PA827998 | rapporteur | |
| 16060000084577 | L16/dossiers | 16 | 16060000084575 | 16060000084575 | 2 | PO211491 | ||
| 16060000084579 | L16/dossiers | 16 | 16060000084578 | 16060000084578 | 1 | PA788192 | rapporteur | |
| 16060000084580 | L16/dossiers | 16 | 16060000084578 | 16060000084578 | 2 | PO516753 | ||
| 16060000084582 | L16/dossiers | 16 | 16060000084581 | 16060000084581 | 1 | PA736204 | rapporteur | |
| 16060000084583 | L16/dossiers | 16 | 16060000084581 | 16060000084581 | 2 | PO211494 | ||
| 16060000084585 | L16/dossiers | 16 | 16060000084584 | 16060000084584 | 1 | PA703514 | rapporteur | |
| 16060000084586 | L16/dossiers | 16 | 16060000084584 | 16060000084584 | 2 | PO211494 | ||
| 16060000084588 | L16/dossiers | 16 | 16060000084587 | 16060000084587 | 1 | PA429840 | rapporteur | |
| 16060000084589 | L16/dossiers | 16 | 16060000084587 | 16060000084587 | 2 | PO211495 | ||
| 16060000084591 | L16/dossiers | 16 | 16060000084590 | 16060000084590 | 1 | PA304085 | rapporteur | |
| 16060000084592 | L16/dossiers | 16 | 16060000084590 | 16060000084590 | 2 | PO211491 | ||
| 16060000084594 | L16/dossiers | 16 | 16060000084593 | 16060000084593 | 1 | PA747422 | rapporteur | |
| 16060000084595 | L16/dossiers | 16 | 16060000084593 | 16060000084593 | 2 | PO211491 | ||
| 16060000084597 | L16/dossiers | 16 | 16060000084596 | 16060000084596 | 1 | PA827894 | rapporteur | |
| 16060000084598 | L16/dossiers | 16 | 16060000084596 | 16060000084596 | 2 | PO211493 | ||
| 16060000084600 | L16/dossiers | 16 | 16060000084599 | 16060000084599 | 1 | PA827952 | rapporteur | |
| 16060000084601 | L16/dossiers | 16 | 16060000084599 | 16060000084599 | 2 | PO835130 | ||
| 16060000084603 | L16/dossiers | 16 | 16060000084602 | 16060000084602 | 1 | PA703540 | rapporteur | |
| 16060000084604 | L16/dossiers | 16 | 16060000084602 | 16060000084602 | 2 | PO211491 | ||
| 16060000084606 | L16/dossiers | 16 | 16060000084605 | 16060000084605 | 1 | PA788192 | rapporteur | |
| 16060000084607 | L16/dossiers | 16 | 16060000084605 | 16060000084605 | 2 | PO835431 | ||
| 16060000084609 | L16/dossiers | 16 | 16060000084608 | 16060000084608 | 1 | PA736173 | rapporteur | |
| 16060000084610 | L16/dossiers | 16 | 16060000084608 | 16060000084608 | 2 | PO211491 | ||
| 16060000084612 | L16/dossiers | 16 | 16060000084611 | 16060000084611 | 1 | PA703513 | rapporteur | |
| 16060000084613 | L16/dossiers | 16 | 16060000084611 | 16060000084611 | 2 | PA703492 | rapporteur | |
| 16060000084614 | L16/dossiers | 16 | 16060000084611 | 16060000084611 | 3 | PO830146 | ||
| 16060000084616 | L16/dossiers | 16 | 16060000084615 | 16060000084615 | 1 | PA827952 | rapporteur | |
| 16060000084617 | L16/dossiers | 16 | 16060000084615 | 16060000084615 | 2 | PO211495 | ||
| 16060000084619 | L16/dossiers | 16 | 16060000084618 | 16060000084618 | 1 | PA767418 | rapporteur | |
| 16060000084620 | L16/dossiers | 16 | 16060000084618 | 16060000084618 | 2 | PA703513 | rapporteur | |
| 16060000084621 | L16/dossiers | 16 | 16060000084618 | 16060000084618 | 3 | PO836135 | ||
| 16060000084623 | L16/dossiers | 16 | 16060000084622 | 16060000084622 | 1 | PA827942 | rapporteur | |
| 16060000084624 | L16/dossiers | 16 | 16060000084622 | 16060000084622 | 2 | PA703541 | rapporteur | |
| 16060000084625 | L16/dossiers | 16 | 16060000084622 | 16060000084622 | 3 | PO836128 | ||
| 16060000084627 | L16/dossiers | 16 | 16060000084626 | 16060000084626 | 1 | PA827894 | rapporteur | |
| 16060000084628 | L16/dossiers | 16 | 16060000084626 | 16060000084626 | 2 | PO211493 | ||
| 16060000084630 | L16/dossiers | 16 | 16060000084629 | 16060000084629 | 1 | PA827968 | rapporteur | |
| 16060000084631 | L16/dossiers | 16 | 16060000084629 | 16060000084629 | 2 | PO211491 | ||
| 16060000084633 | L16/dossiers | 16 | 16060000084632 | 16060000084632 | 1 | PA736227 | rapporteur | |
| 16060000084634 | L16/dossiers | 16 | 16060000084632 | 16060000084632 | 2 | PO211491 | ||
| 16060000084636 | L16/dossiers | 16 | 16060000084635 | 16060000084635 | 1 | PA703494 | rapporteur | |
| 16060000084637 | L16/dossiers | 16 | 16060000084635 | 16060000084635 | 2 | PA827906 | rapporteur | |
| 16060000084638 | L16/dossiers | 16 | 16060000084635 | 16060000084635 | 3 | PO765977 | ||
| 16060000084640 | L16/dossiers | 16 | 16060000084639 | 16060000084639 | 1 | PA429842 | rapporteur | |
| 16060000084641 | L16/dossiers | 16 | 16060000084639 | 16060000084639 | 2 | PA788192 | rapporteur | |
| 16060000084642 | L16/dossiers | 16 | 16060000084639 | 16060000084639 | 3 | PO516753 |