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 |
|---|---|---|---|---|---|---|---|
| 17060000117652 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 9 | PA775202 | PM775502 |
| 17060000117653 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 10 | PA736245 | PM775821 |
| 17060000117654 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 11 | PA736192 | PM736353 |
| 17060000117655 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 12 | PA775216 | PM775522 |
| 17060000117656 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 13 | PA775218 | PM775518 |
| 17060000117657 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 14 | PA267673 | PM775865 |
| 17060000117658 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 15 | PA703530 | PM775689 |
| 17060000117659 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 16 | PA429887 | PM736274 |
| 17060000117660 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 17 | PA736206 | PM736351 |
| 17060000117661 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 18 | PA775234 | PM775536 |
| 17060000117662 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 19 | PA775236 | PM775542 |
| 17060000117663 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 20 | PA736238 | PM736352 |
| 17060000117664 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 21 | PA775242 | PM775528 |
| 17060000117665 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 22 | PA415451 | PM775787 |
| 17060000117666 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 23 | PA2337 | PM775691 |
| 17060000117667 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 24 | PA736239 | PM736317 |
| 17060000117668 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 25 | PA736237 | PM736417 |
| 17060000117669 | L17/dossiers | 17 | 17060000117643 | 17060000117643 | 26 | PA736214 | PM736290 |
| 17060000117692 | L17/dossiers | 17 | 17060000117691 | 17060000117691 | 1 | PA775260 | PM775550 |
| 17060000117715 | L17/dossiers | 17 | 17060000117714 | 17060000117714 | 1 | PA736166 | PM775765 |
| 17060000117716 | L17/dossiers | 17 | 17060000117714 | 17060000117714 | 2 | PA775172 | PM775474 |
| 17060000117742 | L17/dossiers | 17 | 17060000117741 | 17060000117741 | 1 | PA736196 | PM829865 |
| 17060000117782 | L17/dossiers | 17 | 17060000117781 | 17060000117781 | 1 | PA703521 | PM775707 |
| 17060000117821 | L17/dossiers | 17 | 17060000117820 | 17060000117820 | 1 | PA721328 | PM797250 |
| 17060000117889 | L17/dossiers | 17 | 17060000117888 | 17060000117888 | 1 | PA342415 | PM796659 |
| 17060000117918 | L17/dossiers | 17 | 17060000117917 | 17060000117917 | 1 | PA794038 | PM796668 |
| 17060000117948 | L17/dossiers | 17 | 17060000117947 | 17060000117947 | 1 | PA415446 | PM775783 |
| 17060000117949 | L17/dossiers | 17 | 17060000117947 | 17060000117947 | 2 | PA747420 | PM775761 |
| 17060000117972 | L17/dossiers | 17 | 17060000117971 | 17060000117971 | 1 | PA828016 | PM828876 |
| 17060000117996 | L17/dossiers | 17 | 17060000117995 | 17060000117995 | 1 | PA266795 | PM775711 |
| 17060000118019 | L17/dossiers | 17 | 17060000118018 | 17060000118018 | 1 | PA722162 | PM797475 |
| 17060000118051 | L17/dossiers | 17 | 17060000118050 | 17060000118050 | 1 | PA267241 | PM778080 |
| 17060000118082 | L17/dossiers | 17 | 17060000118081 | 17060000118081 | 1 | PA303997 | PM775743 |
| 17060000118105 | L17/dossiers | 17 | 17060000118104 | 17060000118104 | 1 | PA703540 | PM775723 |
| 17060000118128 | L17/dossiers | 17 | 17060000118127 | 17060000118127 | 1 | PA793122 | PM796161 |
| 17060000118180 | L17/dossiers | 17 | 17060000118179 | 17060000118179 | 1 | PA775276 | PM775566 |
| 17060000118204 | L17/dossiers | 17 | 17060000118203 | 17060000118203 | 1 | PA721584 | PM797712 |
| 17060000118240 | L17/dossiers | 17 | 17060000118239 | 17060000118239 | 1 | PA775292 | PM775582 |
| 17060000118307 | L17/dossiers | 17 | 17060000118306 | 17060000118306 | 1 | PA608172 | PM797064 |
| 17060000118367 | L17/dossiers | 17 | 17060000118366 | 17060000118366 | 1 | PA795762 | PM797670 |
| 17060000118411 | L17/dossiers | 17 | 17060000118410 | 17060000118410 | 1 | PA842137 | PM833737 |
| 17060000118450 | L17/dossiers | 17 | 17060000118449 | 17060000118449 | 1 | PA266795 | PM775711 |
| 17060000118451 | L17/dossiers | 17 | 17060000118449 | 17060000118449 | 2 | PA267340 | PM775731 |
| 17060000118452 | L17/dossiers | 17 | 17060000118449 | 17060000118449 | 3 | PA303997 | PM775743 |
| 17060000118453 | L17/dossiers | 17 | 17060000118449 | 17060000118449 | 4 | PA2538 | PM775801 |
| 17060000118454 | L17/dossiers | 17 | 17060000118449 | 17060000118449 | 5 | PA429832 | PM829723 |
| 17060000118525 | L17/dossiers | 17 | 17060000118524 | 17060000118524 | 1 | PA793306 | PM796254 |
| 17060000118577 | L17/dossiers | 17 | 17060000118576 | 17060000118576 | 1 | PA795026 | PM797259 |
| 17060000118628 | L17/dossiers | 17 | 17060000118627 | 17060000118627 | 1 | PA703518 | PM775673 |
| 17060000118629 | L17/dossiers | 17 | 17060000118627 | 17060000118627 | 2 | PA267081 | PM775733 |