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 |
|---|---|---|---|---|---|---|---|---|
| 15060000088535 | L15/dossiers | 15 | 15060000088533 | 15060000088533 | 2 | PO211495 | ||
| 15060000088537 | L15/dossiers | 15 | 15060000088536 | 15060000088536 | 1 | PA775288 | rapporteur | |
| 15060000088538 | L15/dossiers | 15 | 15060000088536 | 15060000088536 | 2 | PO516753 | ||
| 15060000088540 | L15/dossiers | 15 | 15060000088539 | 15060000088539 | 1 | PA227094 | rapporteur | |
| 15060000088541 | L15/dossiers | 15 | 15060000088539 | 15060000088539 | 2 | PO211491 | ||
| 15060000088543 | L15/dossiers | 15 | 15060000088542 | 15060000088542 | 1 | PA736237 | rapporteur | |
| 15060000088544 | L15/dossiers | 15 | 15060000088542 | 15060000088542 | 2 | PO211493 | ||
| 15060000088546 | L15/dossiers | 15 | 15060000088545 | 15060000088545 | 1 | PA429874 | rapporteur | |
| 15060000088547 | L15/dossiers | 15 | 15060000088545 | 15060000088545 | 2 | PO211490 | ||
| 15060000088549 | L15/dossiers | 15 | 15060000088548 | 15060000088548 | 1 | PA343988 | rapporteur | |
| 15060000088550 | L15/dossiers | 15 | 15060000088548 | 15060000088548 | 2 | PO211490 | ||
| 15060000088552 | L15/dossiers | 15 | 15060000088551 | 15060000088551 | 1 | PA429889 | rapporteur | |
| 15060000088553 | L15/dossiers | 15 | 15060000088551 | 15060000088551 | 2 | PO211493 | ||
| 15060000088555 | L15/dossiers | 15 | 15060000088554 | 15060000088554 | 1 | PA227098 | rapporteur | |
| 15060000088556 | L15/dossiers | 15 | 15060000088554 | 15060000088554 | 2 | PO785908 | ||
| 15060000088558 | L15/dossiers | 15 | 15060000088557 | 15060000088557 | 1 | PA703530 | rapporteur | |
| 15060000088559 | L15/dossiers | 15 | 15060000088557 | 15060000088557 | 2 | PO516753 | ||
| 15060000088561 | L15/dossiers | 15 | 15060000088560 | 15060000088560 | 1 | PA736205 | rapporteur | |
| 15060000088562 | L15/dossiers | 15 | 15060000088560 | 15060000088560 | 2 | PO211495 | ||
| 15060000088564 | L15/dossiers | 15 | 15060000088563 | 15060000088563 | 1 | PA429889 | rapporteur | |
| 15060000088565 | L15/dossiers | 15 | 15060000088563 | 15060000088563 | 2 | PA429889 | rapporteur | |
| 15060000088566 | L15/dossiers | 15 | 15060000088563 | 15060000088563 | 3 | PO788997 | ||
| 15060000088568 | L15/dossiers | 15 | 15060000088567 | 15060000088567 | 1 | PA736198 | rapporteur | |
| 15060000088569 | L15/dossiers | 15 | 15060000088567 | 15060000088567 | 2 | PO211493 | ||
| 15060000088571 | L15/dossiers | 15 | 15060000088570 | 15060000088570 | 1 | PA758716 | rapporteur | |
| 15060000088572 | L15/dossiers | 15 | 15060000088570 | 15060000088570 | 2 | PO516753 | ||
| 15060000088574 | L15/dossiers | 15 | 15060000088573 | 15060000088573 | 1 | PA736223 | rapporteur | |
| 15060000088575 | L15/dossiers | 15 | 15060000088573 | 15060000088573 | 2 | PO211493 | ||
| 15060000088577 | L15/dossiers | 15 | 15060000088576 | 15060000088576 | 1 | PA775238 | rapporteur | |
| 15060000088578 | L15/dossiers | 15 | 15060000088576 | 15060000088576 | 2 | PO211493 | ||
| 15060000088580 | L15/dossiers | 15 | 15060000088579 | 15060000088579 | 1 | PA429874 | rapporteur | |
| 15060000088581 | L15/dossiers | 15 | 15060000088579 | 15060000088579 | 2 | PO789115 | ||
| 15060000088583 | L15/dossiers | 15 | 15060000088582 | 15060000088582 | 1 | PA703494 | rapporteur | |
| 15060000088584 | L15/dossiers | 15 | 15060000088582 | 15060000088582 | 2 | PO789151 | ||
| 15060000088586 | L15/dossiers | 15 | 15060000088585 | 15060000088585 | 1 | PA227098 | rapporteur | |
| 15060000088587 | L15/dossiers | 15 | 15060000088585 | 15060000088585 | 2 | PO211493 | ||
| 15060000088589 | L15/dossiers | 15 | 15060000088588 | 15060000088588 | 1 | PA343988 | rapporteur | |
| 15060000088590 | L15/dossiers | 15 | 15060000088588 | 15060000088588 | 2 | PO789332 | ||
| 15060000088592 | L15/dossiers | 15 | 15060000088591 | 15060000088591 | 1 | PA775208 | rapporteur | |
| 15060000088593 | L15/dossiers | 15 | 15060000088591 | 15060000088591 | 2 | PO516753 | ||
| 15060000088595 | L15/dossiers | 15 | 15060000088594 | 15060000088594 | 1 | PA703530 | rapporteur | |
| 15060000088596 | L15/dossiers | 15 | 15060000088594 | 15060000088594 | 2 | PO789339 | ||
| 15060000088598 | L15/dossiers | 15 | 15060000088597 | 15060000088597 | 1 | PA775168 | rapporteur | |
| 15060000088599 | L15/dossiers | 15 | 15060000088597 | 15060000088597 | 2 | PO516754 | ||
| 15060000088601 | L15/dossiers | 15 | 15060000088600 | 15060000088600 | 1 | PA708632 | rapporteur | |
| 15060000088602 | L15/dossiers | 15 | 15060000088600 | 15060000088600 | 2 | PO211495 | ||
| 15060000088604 | L15/dossiers | 15 | 15060000088603 | 15060000088603 | 1 | PA703523 | rapporteur | |
| 15060000088605 | L15/dossiers | 15 | 15060000088603 | 15060000088603 | 2 | PO516753 | ||
| 15060000088607 | L15/dossiers | 15 | 15060000088606 | 15060000088606 | 1 | PA775208 | rapporteur | |
| 15060000088608 | L15/dossiers | 15 | 15060000088606 | 15060000088606 | 2 | PO789573 |