dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
| 8 | mandat_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|
| 17060000139557 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 85 | PA794778 | PM843239 |
| 17060000139558 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 86 | PA795876 | PM843725 |
| 17060000139559 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 87 | PA722142 | PM843500 |
| 17060000139560 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 88 | PA795076 | PM840366 |
| 17060000139561 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 89 | PA795808 | PM843644 |
| 17060000139562 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 90 | PA796018 | PM843425 |
| 17060000139563 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 91 | PA841845 | PM843407 |
| 17060000139564 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 92 | PA795982 | PM840432 |
| 17060000139565 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 93 | PA610002 | PM840363 |
| 17060000139566 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 94 | PA795466 | PM843443 |
| 17060000139567 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 95 | PA793744 | PM842696 |
| 17060000139568 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 96 | PA720952 | PM843755 |
| 17060000139569 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 97 | PA736201 | PM840423 |
| 17060000139570 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 98 | PA794106 | PM842885 |
| 17060000139571 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 99 | PA794166 | PM842924 |
| 17060000139572 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 100 | PA841713 | PM843275 |
| 17060000139573 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 101 | PA793948 | PM842615 |
| 17060000139574 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 102 | PA842299 | PM843791 |
| 17060000139575 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 103 | PA795164 | PM840444 |
| 17060000139576 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 104 | PA795596 | PM840456 |
| 17060000139580 | L17/dossiers | 17 | 17060000139579 | 17060000139579 | 1 | PA794114 | PM842888 |
| 17060000139587 | L17/dossiers | 17 | 17060000139586 | 17060000139586 | 1 | PA793174 | PM842384 |
| 17060000139594 | L17/dossiers | 17 | 17060000139593 | 17060000139593 | 1 | PA794042 | PM858577 |
| 17060000139604 | L17/dossiers | 17 | 17060000139603 | 17060000139603 | 1 | PA847089 | PM847093 |
| 17060000139622 | L17/dossiers | 17 | 17060000139621 | 17060000139621 | 1 | PA303995 | PM775745 |
| 17060000139629 | L17/dossiers | 17 | 17060000139628 | 17060000139628 | 1 | PA607489 | PM829715 |
| 17060000139636 | L17/dossiers | 17 | 17060000139635 | 17060000139635 | 1 | PA722142 | PM843500 |
| 17060000139653 | L17/dossiers | 17 | 17060000139652 | 17060000139652 | 1 | PA335054 | PM843332 |
| 17060000139671 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 1 | PA850008 | PM850016 |
| 17060000139672 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 2 | PA736173 | PM829799 |
| 17060000139673 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 3 | PA757676 | PM829801 |
| 17060000139674 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 4 | PA756685 | PM775777 |
| 17060000139675 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 5 | PA828002 | PM828856 |
| 17060000139676 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 6 | PA775172 | PM775474 |
| 17060000139677 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 7 | PA827898 | PM828454 |
| 17060000139678 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 8 | PA827912 | PM828488 |
| 17060000139679 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 9 | PA827930 | PM828544 |
| 17060000139680 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 10 | PA268007 | PM829695 |
| 17060000139681 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 11 | PA429886 | PM829757 |
| 17060000139682 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 12 | PA736195 | PM829855 |
| 17060000139683 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 13 | PA775246 | PM775532 |
| 17060000139684 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 14 | PA827962 | PM828676 |
| 17060000139685 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 15 | PA736243 | PM829929 |
| 17060000139686 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 16 | PA736175 | PM829795 |
| 17060000139687 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 17 | PA775296 | PM775596 |
| 17060000139688 | L17/dossiers | 17 | 17060000139670 | 17060000139670 | 18 | PA828020 | PM828864 |
| 17060000139695 | L17/dossiers | 17 | 17060000139694 | 17060000139694 | 1 | PA775254 | PM775556 |
| 17060000139702 | L17/dossiers | 17 | 17060000139701 | 17060000139701 | 1 | PA695512 | PM842963 |
| 17060000139709 | L17/dossiers | 17 | 17060000139708 | 17060000139708 | 1 | PA841295 | PM842882 |
| 17060000139716 | L17/dossiers | 17 | 17060000139715 | 17060000139715 | 1 | PA712015 | PM842381 |