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 |
|---|---|---|---|---|---|---|---|
| 15060000144279 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 46 | PA429842 | PM736373 |
| 15060000144280 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 47 | PA703530 | PM703695 |
| 15060000144281 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 48 | PA415489 | PM703714 |
| 15060000144282 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 49 | PA736231 | PM736381 |
| 15060000144283 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 50 | PA742505 | PM742506 |
| 15060000144284 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 51 | PA736246 | PM736428 |
| 15060000144285 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 52 | PA703539 | PM703693 |
| 15060000144286 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 53 | PA736244 | PM736333 |
| 15060000144287 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 54 | PA703518 | PM703704 |
| 15060000144288 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 55 | PA703483 | PM703613 |
| 15060000144289 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 56 | PA415447 | PM703616 |
| 15060000144290 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 57 | PA1993 | PM736402 |
| 15060000144291 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 58 | PA736172 | PM736415 |
| 15060000144292 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 59 | PA703506 | PM703680 |
| 15060000144293 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 60 | PA528 | PM736270 |
| 15060000144294 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 61 | PA429854 | PM736335 |
| 15060000144295 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 62 | PA703541 | PM703644 |
| 15060000144296 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 63 | PA980 | PM736356 |
| 15060000144297 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 64 | PA705750 | PM705821 |
| 15060000144298 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 65 | PA711156 | PM736319 |
| 15060000144299 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 66 | PA267989 | PM703655 |
| 15060000144300 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 67 | PA703510 | PM703672 |
| 15060000144301 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 68 | PA607489 | PM736390 |
| 15060000144302 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 69 | PA415455 | PM703587 |
| 15060000144303 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 70 | PA415451 | PM703594 |
| 15060000144304 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 71 | PA703503 | PM703582 |
| 15060000144305 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 72 | PA304737 | PM703551 |
| 15060000144306 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 73 | PA304076 | PM703694 |
| 15060000144307 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 74 | PA267328 | PM703547 |
| 15060000144308 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 75 | PA267018 | PM703564 |
| 15060000144309 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 76 | PA267340 | PM703713 |
| 15060000144310 | L15/dossiers | 15 | 15060000144233 | 15060000144233 | 77 | PA227094 | PM736386 |
| 15060000144329 | L15/dossiers | 15 | 15060000144328 | 15060000144328 | 1 | PA266795 | PM703637 |
| 15060000144370 | L15/dossiers | 15 | 15060000144369 | 15060000144369 | 1 | PA429887 | PM736274 |
| 15060000144392 | L15/dossiers | 15 | 15060000144391 | 15060000144391 | 1 | PA718838 | PM722474 |
| 15060000144399 | L15/dossiers | 15 | 15060000144398 | 15060000144398 | 1 | PA1874 | PM722598 |
| 15060000144409 | L15/dossiers | 15 | 15060000144408 | 15060000144408 | 1 | PA345619 | PM725692 |
| 15060000144410 | L15/dossiers | 15 | 15060000144408 | 15060000144408 | 2 | PA332747 | PM758790 |
| 15060000144480 | L15/dossiers | 15 | 15060000144479 | 15060000144479 | 1 | PA345619 | PM725692 |
| 15060000144481 | L15/dossiers | 15 | 15060000144479 | 15060000144479 | 2 | PA332747 | PM758790 |
| 15060000144550 | L15/dossiers | 15 | 15060000144549 | 15060000144549 | 1 | PA345619 | PM725692 |
| 15060000144590 | L15/dossiers | 15 | 15060000144589 | 15060000144589 | 1 | PA720614 | PM723016 |
| 15060000144597 | L15/dossiers | 15 | 15060000144596 | 15060000144596 | 1 | PA336316 | PM723406 |
| 15060000144604 | L15/dossiers | 15 | 15060000144603 | 15060000144603 | 1 | PA1327 | PM722762 |
| 15060000144611 | L15/dossiers | 15 | 15060000144610 | 15060000144610 | 1 | PA718838 | PM722474 |
| 15060000144618 | L15/dossiers | 15 | 15060000144617 | 15060000144617 | 1 | PA718838 | PM722474 |
| 15060000144625 | L15/dossiers | 15 | 15060000144624 | 15060000144624 | 1 | PA721506 | PM723296 |
| 15060000144632 | L15/dossiers | 15 | 15060000144631 | 15060000144631 | 1 | PA718838 | PM722474 |
| 15060000144639 | L15/dossiers | 15 | 15060000144638 | 15060000144638 | 1 | PA267780 | PM723504 |
| 15060000144684 | L15/dossiers | 15 | 15060000144683 | 15060000144683 | 1 | PA720822 | PM723086 |