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 |
|---|---|---|---|---|---|---|---|
| 16060000092443 | L16/dossiers | 16 | 16060000092442 | 16060000092442 | 1 | PA313924 | PM703546 |
| 16060000092467 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 1 | PA732420 | PM763170 |
| 16060000092468 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 2 | PA732420 | PM763170 |
| 16060000092469 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 3 | PA429895 | PM736262 |
| 16060000092470 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 4 | PA703486 | PM703718 |
| 16060000092471 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 5 | PA267840 | PM736423 |
| 16060000092472 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 6 | PA703528 | PM703588 |
| 16060000092473 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 7 | PA736190 | PM736255 |
| 16060000092474 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 8 | PA703531 | PM703701 |
| 16060000092475 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 9 | PA905 | PM703566 |
| 16060000092476 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 10 | PA268007 | PM736325 |
| 16060000092477 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 11 | PA429845 | PM736278 |
| 16060000092478 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 12 | PA736235 | PM736426 |
| 16060000092479 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 13 | PA703487 | PM703711 |
| 16060000092480 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 14 | PA736228 | PM736380 |
| 16060000092481 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 15 | PA1573 | PM703652 |
| 16060000092482 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 16 | PA736168 | PM736301 |
| 16060000092483 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 17 | PA703509 | PM703687 |
| 16060000092484 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 18 | PA703529 | PM703650 |
| 16060000092485 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 19 | PA415464 | PM703627 |
| 16060000092486 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 20 | PA736242 | PM736349 |
| 16060000092487 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 21 | PA703495 | PM703708 |
| 16060000092488 | L16/dossiers | 16 | 16060000092466 | 16060000092466 | 22 | PA415480 | PM709303 |
| 16060000092511 | L16/dossiers | 16 | 16060000092510 | 16060000092510 | 1 | PA736186 | PM736396 |
| 16060000092512 | L16/dossiers | 16 | 16060000092510 | 16060000092510 | 2 | PA415454 | PM703689 |
| 16060000092536 | L16/dossiers | 16 | 16060000092535 | 16060000092535 | 1 | PA702993 | PM736362 |
| 16060000092537 | L16/dossiers | 16 | 16060000092535 | 16060000092535 | 2 | PA703505 | PM703626 |
| 16060000092538 | L16/dossiers | 16 | 16060000092535 | 16060000092535 | 3 | PA429867 | PM736298 |
| 16060000092539 | L16/dossiers | 16 | 16060000092535 | 16060000092535 | 4 | PA429889 | PM736313 |
| 16060000092540 | L16/dossiers | 16 | 16060000092535 | 16060000092535 | 5 | PA429889 | PM736313 |
| 16060000092541 | L16/dossiers | 16 | 16060000092535 | 16060000092535 | 6 | PA703490 | PM703631 |
| 16060000092564 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 1 | PA429886 | PM736385 |
| 16060000092565 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 2 | PA304082 | PM736354 |
| 16060000092566 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 3 | PA757676 | PM757692 |
| 16060000092567 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 4 | PA429891 | PM736329 |
| 16060000092568 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 5 | PA429894 | PM736364 |
| 16060000092569 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 6 | PA756685 | PM756689 |
| 16060000092570 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 7 | PA429836 | PM736345 |
| 16060000092571 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 8 | PA304071 | PM703676 |
| 16060000092572 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 9 | PA736195 | PM736357 |
| 16060000092573 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 10 | PA736177 | PM736318 |
| 16060000092574 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 11 | PA736173 | PM736369 |
| 16060000092575 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 12 | PA1978 | PM736337 |
| 16060000092576 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 13 | PA678263 | PM736330 |
| 16060000092577 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 14 | PA736243 | PM736413 |
| 16060000092578 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 15 | PA703499 | PM703641 |
| 16060000092579 | L16/dossiers | 16 | 16060000092563 | 16060000092563 | 16 | PA736175 | PM736344 |
| 16060000092602 | L16/dossiers | 16 | 16060000092601 | 16060000092601 | 1 | PA429875 | PM736302 |
| 16060000092603 | L16/dossiers | 16 | 16060000092601 | 16060000092601 | 2 | PA757678 | PM757684 |
| 16060000092604 | L16/dossiers | 16 | 16060000092601 | 16060000092601 | 3 | PA404656 | PM736328 |