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 |
|---|---|---|---|---|---|---|---|
| 16060000102195 | L16/dossiers | 16 | 16060000102194 | 16060000102194 | 1 | PA795422 | PM797478 |
| 16060000102202 | L16/dossiers | 16 | 16060000102201 | 16060000102201 | 1 | PA795552 | PM797547 |
| 16060000102209 | L16/dossiers | 16 | 16060000102208 | 16060000102208 | 1 | PA722046 | PM797625 |
| 16060000102262 | L16/dossiers | 16 | 16060000102261 | 16060000102261 | 1 | PA794570 | PM796998 |
| 16060000102269 | L16/dossiers | 16 | 16060000102268 | 16060000102268 | 1 | PA794570 | PM796998 |
| 16060000102276 | L16/dossiers | 16 | 16060000102275 | 16060000102275 | 1 | PA721896 | PM797664 |
| 16060000102283 | L16/dossiers | 16 | 16060000102282 | 16060000102282 | 1 | PA720468 | PM796983 |
| 16060000102298 | L16/dossiers | 16 | 16060000102297 | 16060000102297 | 1 | PA266788 | PM796788 |
| 16060000102305 | L16/dossiers | 16 | 16060000102304 | 16060000102304 | 1 | PA718926 | PM796326 |
| 16060000102306 | L16/dossiers | 16 | 16060000102304 | 16060000102304 | 2 | PA720838 | PM797865 |
| 16060000102307 | L16/dossiers | 16 | 16060000102304 | 16060000102304 | 3 | PA721118 | PM797376 |
| 16060000102308 | L16/dossiers | 16 | 16060000102304 | 16060000102304 | 4 | PA795192 | PM797349 |
| 16060000102315 | L16/dossiers | 16 | 16060000102314 | 16060000102314 | 1 | PA795778 | PM797682 |
| 16060000102334 | L16/dossiers | 16 | 16060000102333 | 16060000102333 | 1 | PA718884 | PM796218 |
| 16060000102341 | L16/dossiers | 16 | 16060000102340 | 16060000102340 | 1 | PA717161 | PM791583 |
| 16060000102357 | L16/dossiers | 16 | 16060000102356 | 16060000102356 | 1 | PA266788 | PM796788 |
| 16060000102364 | L16/dossiers | 16 | 16060000102363 | 16060000102363 | 1 | PA793322 | PM796260 |
| 16060000102371 | L16/dossiers | 16 | 16060000102370 | 16060000102370 | 1 | PA717379 | PM797265 |
| 16060000102403 | L16/dossiers | 16 | 16060000102402 | 16060000102402 | 1 | PA266788 | PM796788 |
| 16060000102410 | L16/dossiers | 16 | 16060000102409 | 16060000102409 | 1 | PA266788 | PM796788 |
| 16060000102417 | L16/dossiers | 16 | 16060000102416 | 16060000102416 | 1 | PA720822 | PM797058 |
| 16060000102424 | L16/dossiers | 16 | 16060000102423 | 16060000102423 | 1 | PA721486 | PM797517 |
| 16060000102431 | L16/dossiers | 16 | 16060000102430 | 16060000102430 | 1 | PA719272 | PM796347 |
| 16060000102438 | L16/dossiers | 16 | 16060000102437 | 16060000102437 | 1 | PA794402 | PM796905 |
| 16060000102445 | L16/dossiers | 16 | 16060000102444 | 16060000102444 | 1 | PA720754 | PM797121 |
| 16060000102452 | L16/dossiers | 16 | 16060000102451 | 16060000102451 | 1 | PA718838 | PM796197 |
| 16060000102459 | L16/dossiers | 16 | 16060000102458 | 16060000102458 | 1 | PA794198 | PM796776 |
| 16060000102467 | L16/dossiers | 16 | 16060000102466 | 16060000102466 | 1 | PA720138 | PM796800 |
| 16060000102474 | L16/dossiers | 16 | 16060000102473 | 16060000102473 | 1 | PA795912 | PM797751 |
| 16060000102493 | L16/dossiers | 16 | 16060000102492 | 16060000102492 | 1 | PA608826 | PM797256 |
| 16060000102500 | L16/dossiers | 16 | 16060000102499 | 16060000102499 | 1 | PA720822 | PM797058 |
| 16060000102519 | L16/dossiers | 16 | 16060000102518 | 16060000102518 | 1 | PA720468 | PM796983 |
| 16060000102526 | L16/dossiers | 16 | 16060000102525 | 16060000102525 | 1 | PA794502 | PM796962 |
| 16060000102543 | L16/dossiers | 16 | 16060000102542 | 16060000102542 | 1 | PA266788 | PM796788 |
| 16060000102550 | L16/dossiers | 16 | 16060000102549 | 16060000102549 | 1 | PA266788 | PM796788 |
| 16060000102557 | L16/dossiers | 16 | 16060000102556 | 16060000102556 | 1 | PA266788 | PM796788 |
| 16060000102564 | L16/dossiers | 16 | 16060000102563 | 16060000102563 | 1 | PA266788 | PM796788 |
| 16060000102571 | L16/dossiers | 16 | 16060000102570 | 16060000102570 | 1 | PA266788 | PM796788 |
| 16060000102578 | L16/dossiers | 16 | 16060000102577 | 16060000102577 | 1 | PA266788 | PM796788 |
| 16060000102585 | L16/dossiers | 16 | 16060000102584 | 16060000102584 | 1 | PA266788 | PM796788 |
| 16060000102592 | L16/dossiers | 16 | 16060000102591 | 16060000102591 | 1 | PA266788 | PM796788 |
| 16060000102599 | L16/dossiers | 16 | 16060000102598 | 16060000102598 | 1 | PA266788 | PM796788 |
| 16060000102606 | L16/dossiers | 16 | 16060000102605 | 16060000102605 | 1 | PA266788 | PM796788 |
| 16060000102613 | L16/dossiers | 16 | 16060000102612 | 16060000102612 | 1 | PA266788 | PM796788 |
| 16060000102620 | L16/dossiers | 16 | 16060000102619 | 16060000102619 | 1 | PA793246 | PM796227 |
| 16060000102627 | L16/dossiers | 16 | 16060000102626 | 16060000102626 | 1 | PA718926 | PM796326 |
| 16060000102634 | L16/dossiers | 16 | 16060000102633 | 16060000102633 | 1 | PA720644 | PM797103 |
| 16060000102641 | L16/dossiers | 16 | 16060000102640 | 16060000102640 | 1 | PA794178 | PM796755 |
| 16060000102648 | L16/dossiers | 16 | 16060000102647 | 16060000102647 | 1 | PA266788 | PM796788 |
| 16060000102652 | L16/dossiers | 16 | 16060000102651 | 16060000102651 | 1 | PA266788 | PM796788 |