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 |
|---|---|---|---|---|---|---|---|
| 16060000092628 | L16/dossiers | 16 | 16060000092627 | 16060000092627 | 1 | PA703513 | PM703621 |
| 16060000092629 | L16/dossiers | 16 | 16060000092627 | 16060000092627 | 2 | PA758716 | PM758720 |
| 16060000092630 | L16/dossiers | 16 | 16060000092627 | 16060000092627 | 3 | PA758716 | PM758720 |
| 16060000092631 | L16/dossiers | 16 | 16060000092627 | 16060000092627 | 4 | PA415462 | PM703628 |
| 16060000092655 | L16/dossiers | 16 | 16060000092654 | 16060000092654 | 1 | PA429858 | PM736268 |
| 16060000092680 | L16/dossiers | 16 | 16060000092679 | 16060000092679 | 1 | PA429858 | PM736268 |
| 16060000092704 | L16/dossiers | 16 | 16060000092703 | 16060000092703 | 1 | PA415446 | PM703678 |
| 16060000092727 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 1 | PA415446 | PM703678 |
| 16060000092728 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 2 | PA429858 | PM736268 |
| 16060000092729 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 3 | PA429842 | PM736373 |
| 16060000092730 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 4 | PA343988 | PM736310 |
| 16060000092731 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 5 | PA736192 | PM736353 |
| 16060000092732 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 6 | PA736211 | PM736410 |
| 16060000092733 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 7 | PA744079 | PM744082 |
| 16060000092734 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 8 | PA425322 | PM736282 |
| 16060000092735 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 9 | PA1001 | PM736371 |
| 16060000092736 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 10 | PA736186 | PM736396 |
| 16060000092737 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 11 | PA267081 | PM703617 |
| 16060000092738 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 12 | PA736239 | PM736317 |
| 16060000092739 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 13 | PA703503 | PM703582 |
| 16060000092740 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 14 | PA415495 | PM703579 |
| 16060000092741 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 15 | PA703480 | PM703624 |
| 16060000092742 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 16 | PA703515 | PM703592 |
| 16060000092743 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 17 | PA341381 | PM703618 |
| 16060000092744 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 18 | PA720634 | PM736312 |
| 16060000092745 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 19 | PA429851 | PM736305 |
| 16060000092746 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 20 | PA703500 | PM703574 |
| 16060000092747 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 21 | PA736237 | PM736417 |
| 16060000092748 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 22 | PA736240 | PM736279 |
| 16060000092749 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 23 | PA708632 | PM708643 |
| 16060000092750 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 24 | PA736206 | PM736351 |
| 16060000092751 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 25 | PA736238 | PM736352 |
| 16060000092752 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 26 | PA736246 | PM736428 |
| 16060000092753 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 27 | PA429854 | PM736335 |
| 16060000092754 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 28 | PA415467 | PM703636 |
| 16060000092755 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 29 | PA703539 | PM703693 |
| 16060000092756 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 30 | PA767418 | PM767422 |
| 16060000092757 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 31 | PA703494 | PM703602 |
| 16060000092758 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 32 | PA736200 | PM736285 |
| 16060000092759 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 33 | PA607489 | PM736390 |
| 16060000092760 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 34 | PA227094 | PM736386 |
| 16060000092761 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 35 | PA404656 | PM736328 |
| 16060000092762 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 36 | PA267328 | PM703547 |
| 16060000092763 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 37 | PA345785 | PM736294 |
| 16060000092764 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 38 | PA313924 | PM703546 |
| 16060000092765 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 39 | PA569 | PM703710 |
| 16060000092766 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 40 | PA711156 | PM736319 |
| 16060000092767 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 41 | PA736213 | PM736431 |
| 16060000092768 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 42 | PA703527 | PM703580 |
| 16060000092769 | L16/dossiers | 16 | 16060000092726 | 16060000092726 | 43 | PA736218 | PM736257 |