dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 14060000104111 | L14/dossiers | 14 | 14060000104110 | 14060000104110 | 1 | PA609345 | PM645173 |
| 14060000104118 | L14/dossiers | 14 | 14060000104117 | 14060000104117 | 1 | PA1459 | PM645518 |
| 14060000104125 | L14/dossiers | 14 | 14060000104124 | 14060000104124 | 1 | PA267178 | PM645473 |
| 14060000104132 | L14/dossiers | 14 | 14060000104131 | 14060000104131 | 1 | PA328 | PM653228 |
| 14060000104133 | L14/dossiers | 14 | 14060000104131 | 14060000104131 | 2 | PA2679 | PM653358 |
| 14060000104230 | L14/dossiers | 14 | 14060000104229 | 14060000104229 | 1 | PA785 | PM715797 |
| 14060000104237 | L14/dossiers | 14 | 14060000104236 | 14060000104236 | 1 | PA1574 | PM645430 |
| 14060000104244 | L14/dossiers | 14 | 14060000104243 | 14060000104243 | 1 | PA1931 | PM645042 |
| 14060000104254 | L14/dossiers | 14 | 14060000104253 | 14060000104253 | 1 | PA267743 | PM645058 |
| 14060000104261 | L14/dossiers | 14 | 14060000104260 | 14060000104260 | 1 | PA610002 | PM645053 |
| 14060000104268 | L14/dossiers | 14 | 14060000104267 | 14060000104267 | 1 | PA267622 | PM702957 |
| 14060000104275 | L14/dossiers | 14 | 14060000104274 | 14060000104274 | 1 | PA328 | PM653228 |
| 14060000104276 | L14/dossiers | 14 | 14060000104274 | 14060000104274 | 2 | PA2791 | PM653325 |
| 14060000104375 | L14/dossiers | 14 | 14060000104374 | 14060000104374 | 1 | PA333818 | PM645451 |
| 14060000104386 | L14/dossiers | 14 | 14060000104385 | 14060000104385 | 1 | PA1263 | PM645432 |
| 14060000104393 | L14/dossiers | 14 | 14060000104392 | 14060000104392 | 1 | PA735 | PM645089 |
| 14060000104403 | L14/dossiers | 14 | 14060000104402 | 14060000104402 | 1 | PA332523 | PM645550 |
| 14060000104413 | L14/dossiers | 14 | 14060000104412 | 14060000104412 | 1 | PA1886 | PM645099 |
| 14060000104436 | L14/dossiers | 14 | 14060000104435 | 14060000104435 | 1 | PA346 | PM645086 |
| 14060000104443 | L14/dossiers | 14 | 14060000104442 | 14060000104442 | 1 | PA2774 | PM429910 |
| 14060000104467 | L14/dossiers | 14 | 14060000104466 | 14060000104466 | 1 | PA267622 | PM702957 |
| 14060000104468 | L14/dossiers | 14 | 14060000104466 | 14060000104466 | 2 | PA2679 | PM714646 |
| 14060000104475 | L14/dossiers | 14 | 14060000104474 | 14060000104474 | 1 | PA268019 | PM645116 |
| 14060000104482 | L14/dossiers | 14 | 14060000104481 | 14060000104481 | 1 | PA610521 | PM645190 |
| 14060000104489 | L14/dossiers | 14 | 14060000104488 | 14060000104488 | 1 | PA267622 | PM702957 |
| 14060000104589 | L14/dossiers | 14 | 14060000104588 | 14060000104588 | 1 | PA2374 | PM645217 |
| 14060000104599 | L14/dossiers | 14 | 14060000104598 | 14060000104598 | 1 | PA2345 | PM645548 |
| 14060000104609 | L14/dossiers | 14 | 14060000104608 | 14060000104608 | 1 | PA267622 | PM702957 |
| 14060000104619 | L14/dossiers | 14 | 14060000104618 | 14060000104618 | 1 | PA268019 | PM645116 |
| 14060000104626 | L14/dossiers | 14 | 14060000104625 | 14060000104625 | 1 | PA415493 | PM415603 |
| 14060000104643 | L14/dossiers | 14 | 14060000104642 | 14060000104642 | 1 | PA2971 | PM645392 |
| 14060000104650 | L14/dossiers | 14 | 14060000104649 | 14060000104649 | 1 | PA267605 | PM645189 |
| 14060000104657 | L14/dossiers | 14 | 14060000104656 | 14060000104656 | 1 | PA785 | PM715797 |
| 14060000104665 | L14/dossiers | 14 | 14060000104664 | 14060000104664 | 1 | PA610521 | PM645190 |
| 14060000104672 | L14/dossiers | 14 | 14060000104671 | 14060000104671 | 1 | PA267622 | PM702957 |
| 14060000104673 | L14/dossiers | 14 | 14060000104671 | 14060000104671 | 2 | PA2650 | PM702973 |
| 14060000104674 | L14/dossiers | 14 | 14060000104671 | 14060000104671 | 3 | PA2912 | PM702991 |
| 14060000104681 | L14/dossiers | 14 | 14060000104680 | 14060000104680 | 1 | PA1031 | PM645044 |
| 14060000104688 | L14/dossiers | 14 | 14060000104687 | 14060000104687 | 1 | PA1031 | PM645044 |
| 14060000104695 | L14/dossiers | 14 | 14060000104694 | 14060000104694 | 1 | PA606212 | PM645330 |
| 14060000104702 | L14/dossiers | 14 | 14060000104701 | 14060000104701 | 1 | PA331567 | PM645186 |
| 14060000104712 | L14/dossiers | 14 | 14060000104711 | 14060000104711 | 1 | PA1874 | PM645474 |
| 14060000104722 | L14/dossiers | 14 | 14060000104721 | 14060000104721 | 1 | PA267429 | PM645130 |
| 14060000104729 | L14/dossiers | 14 | 14060000104728 | 14060000104728 | 1 | PA1886 | PM645099 |
| 14060000104736 | L14/dossiers | 14 | 14060000104735 | 14060000104735 | 1 | PA267622 | PM702957 |
| 14060000104743 | L14/dossiers | 14 | 14060000104742 | 14060000104742 | 1 | PA754 | PM645050 |
| 14060000104758 | L14/dossiers | 14 | 14060000104757 | 14060000104757 | 1 | PA330788 | PM645510 |
| 14060000104765 | L14/dossiers | 14 | 14060000104764 | 14060000104764 | 1 | PA267622 | PM702957 |
| 14060000104766 | L14/dossiers | 14 | 14060000104764 | 14060000104764 | 2 | PA2679 | PM702976 |
| 14060000104843 | L14/dossiers | 14 | 14060000104842 | 14060000104842 | 1 | PA709315 | PM709318 |