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 |
|---|---|---|---|---|---|---|---|
| 15060000184396 | L15/dossiers | 15 | 15060000184395 | 15060000184395 | 1 | PA721182 | PM723196 |
| 15060000184401 | L15/dossiers | 15 | 15060000184400 | 15060000184400 | 1 | PA340357 | PM747435 |
| 15060000184425 | L15/dossiers | 15 | 15060000184424 | 15060000184424 | 1 | PA721246 | PM723214 |
| 15060000184432 | L15/dossiers | 15 | 15060000184431 | 15060000184431 | 1 | PA721486 | PM723290 |
| 15060000184439 | L15/dossiers | 15 | 15060000184438 | 15060000184438 | 1 | PA2377 | PM723550 |
| 15060000184446 | L15/dossiers | 15 | 15060000184445 | 15060000184445 | 1 | PA721194 | PM723200 |
| 15060000184453 | L15/dossiers | 15 | 15060000184452 | 15060000184452 | 1 | PA588884 | PM723226 |
| 15060000184463 | L15/dossiers | 15 | 15060000184462 | 15060000184462 | 1 | PA720846 | PM723094 |
| 15060000184471 | L15/dossiers | 15 | 15060000184470 | 15060000184470 | 1 | PA341381 | PM775747 |
| 15060000184478 | L15/dossiers | 15 | 15060000184477 | 15060000184477 | 1 | PA722268 | PM723522 |
| 15060000184488 | L15/dossiers | 15 | 15060000184487 | 15060000184487 | 1 | PA773441 | PM773491 |
| 15060000184489 | L15/dossiers | 15 | 15060000184487 | 15060000184487 | 2 | PA717161 | PM773483 |
| 15060000184496 | L15/dossiers | 15 | 15060000184495 | 15060000184495 | 1 | PA773441 | PM773491 |
| 15060000184497 | L15/dossiers | 15 | 15060000184495 | 15060000184495 | 2 | PA1872 | PM773455 |
| 15060000184498 | L15/dossiers | 15 | 15060000184495 | 15060000184495 | 3 | PA703535 | PM774093 |
| 15060000184531 | L15/dossiers | 15 | 15060000184530 | 15060000184530 | 1 | PA429874 | PM736314 |
| 15060000184532 | L15/dossiers | 15 | 15060000184530 | 15060000184530 | 2 | PA2538 | PM775801 |
| 15060000184533 | L15/dossiers | 15 | 15060000184530 | 15060000184530 | 3 | PA736200 | PM736285 |
| 15060000184534 | L15/dossiers | 15 | 15060000184530 | 15060000184530 | 4 | PA736169 | PM736293 |
| 15060000184541 | L15/dossiers | 15 | 15060000184540 | 15060000184540 | 1 | PA773441 | PM773491 |
| 15060000184548 | L15/dossiers | 15 | 15060000184547 | 15060000184547 | 1 | PA773441 | PM773491 |
| 15060000184555 | L15/dossiers | 15 | 15060000184554 | 15060000184554 | 1 | PA736223 | PM736368 |
| 15060000184562 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 1 | PA775182 | PM775464 |
| 15060000184563 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 2 | PA429895 | PM736262 |
| 15060000184564 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 3 | PA267840 | PM736423 |
| 15060000184565 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 4 | PA703528 | PM775693 |
| 15060000184566 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 5 | PA268007 | PM736325 |
| 15060000184567 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 6 | PA775226 | PM775510 |
| 15060000184568 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 7 | PA736228 | PM736380 |
| 15060000184569 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 8 | PA1573 | PM775697 |
| 15060000184570 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 9 | PA775232 | PM775538 |
| 15060000184571 | L15/dossiers | 15 | 15060000184561 | 15060000184561 | 10 | PA703495 | PM775653 |
| 15060000184587 | L15/dossiers | 15 | 15060000184586 | 15060000184586 | 1 | PA429840 | PM736360 |
| 15060000184594 | L15/dossiers | 15 | 15060000184593 | 15060000184593 | 1 | PA429840 | PM736360 |
| 15060000184601 | L15/dossiers | 15 | 15060000184600 | 15060000184600 | 1 | PA736235 | PM775795 |
| 15060000184608 | L15/dossiers | 15 | 15060000184607 | 15060000184607 | 1 | PA721070 | PM723160 |
| 15060000184615 | L15/dossiers | 15 | 15060000184614 | 15060000184614 | 1 | PA721474 | PM723286 |
| 15060000184619 | L15/dossiers | 15 | 15060000184618 | 15060000184618 | 1 | PA722374 | PM723556 |
| 15060000184624 | L15/dossiers | 15 | 15060000184623 | 15060000184623 | 1 | PA605518 | PM722518 |
| 15060000184640 | L15/dossiers | 15 | 15060000184639 | 15060000184639 | 1 | PA719488 | PM722676 |
| 15060000184647 | L15/dossiers | 15 | 15060000184646 | 15060000184646 | 1 | PA267794 | PM722468 |
| 15060000184654 | L15/dossiers | 15 | 15060000184653 | 15060000184653 | 1 | PA721182 | PM723196 |
| 15060000184663 | L15/dossiers | 15 | 15060000184662 | 15060000184662 | 1 | PA720092 | PM722858 |
| 15060000184685 | L15/dossiers | 15 | 15060000184684 | 15060000184684 | 1 | PA719980 | PM722822 |
| 15060000184689 | L15/dossiers | 15 | 15060000184688 | 15060000184688 | 1 | PA721474 | PM723286 |
| 15060000184693 | L15/dossiers | 15 | 15060000184692 | 15060000184692 | 1 | PA721474 | PM723286 |
| 15060000184697 | L15/dossiers | 15 | 15060000184696 | 15060000184696 | 1 | PA1874 | PM722598 |
| 15060000184704 | L15/dossiers | 15 | 15060000184703 | 15060000184703 | 1 | PA721474 | PM723286 |
| 15060000184708 | L15/dossiers | 15 | 15060000184707 | 15060000184707 | 1 | PA721474 | PM723286 |
| 15060000184712 | L15/dossiers | 15 | 15060000184711 | 15060000184711 | 1 | PA721474 | PM723286 |