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 |
|---|---|---|---|---|---|---|---|
| 15060000157470 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 5 | PA341381 | PM703618 |
| 15060000157471 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 6 | PA703523 | PM703578 |
| 15060000157472 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 7 | PA736167 | PM736327 |
| 15060000157473 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 8 | PA736166 | PM736435 |
| 15060000157474 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 9 | PA736230 | PM736377 |
| 15060000157475 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 10 | PA227098 | PM736321 |
| 15060000157476 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 11 | PA736232 | PM736401 |
| 15060000157477 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 12 | PA736170 | PM736266 |
| 15060000157478 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 13 | PA736223 | PM736368 |
| 15060000157479 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 14 | PA304017 | PM703669 |
| 15060000157480 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 15 | PA227029 | PM736306 |
| 15060000157481 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 16 | PA550 | PM703612 |
| 15060000157482 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 17 | PA415446 | PM703678 |
| 15060000157483 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 18 | PA703501 | PM703629 |
| 15060000157484 | L15/dossiers | 15 | 15060000157465 | 15060000157465 | 19 | PA703532 | PM703568 |
| 15060000157491 | L15/dossiers | 15 | 15060000157490 | 15060000157490 | 1 | PA343775 | PM736367 |
| 15060000157498 | L15/dossiers | 15 | 15060000157497 | 15060000157497 | 1 | PA415446 | PM703678 |
| 15060000157505 | L15/dossiers | 15 | 15060000157504 | 15060000157504 | 1 | PA267328 | PM703547 |
| 15060000157512 | L15/dossiers | 15 | 15060000157511 | 15060000157511 | 1 | PA703513 | PM703621 |
| 15060000157519 | L15/dossiers | 15 | 15060000157518 | 15060000157518 | 1 | PA2116 | PM736339 |
| 15060000157526 | L15/dossiers | 15 | 15060000157525 | 15060000157525 | 1 | PA1122 | PM736304 |
| 15060000157533 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 1 | PA703528 | PM703588 |
| 15060000157534 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 2 | PA429866 | PM736287 |
| 15060000157535 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 3 | PA429835 | PM736397 |
| 15060000157536 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 4 | PA340419 | PM703553 |
| 15060000157537 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 5 | PA415468 | PM703648 |
| 15060000157538 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 6 | PA736167 | PM736327 |
| 15060000157539 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 7 | PA736233 | PM736411 |
| 15060000157540 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 8 | PA703509 | PM703687 |
| 15060000157541 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 9 | PA703536 | PM703563 |
| 15060000157542 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 10 | PA703533 | PM703593 |
| 15060000157543 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 11 | PA268048 | PM736422 |
| 15060000157544 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 12 | PA429888 | PM736379 |
| 15060000157545 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 13 | PA703512 | PM703575 |
| 15060000157546 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 14 | PA736209 | PM736400 |
| 15060000157547 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 15 | PA703495 | PM703708 |
| 15060000157548 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 16 | PA736201 | PM736347 |
| 15060000157549 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 17 | PA736217 | PM736384 |
| 15060000157550 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 18 | PA703481 | PM703670 |
| 15060000157551 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 19 | PA703491 | PM703634 |
| 15060000157552 | L15/dossiers | 15 | 15060000157532 | 15060000157532 | 20 | PA2870 | PM736316 |
| 15060000157559 | L15/dossiers | 15 | 15060000157558 | 15060000157558 | 1 | PA382672 | PM736263 |
| 15060000157566 | L15/dossiers | 15 | 15060000157565 | 15060000157565 | 1 | PA703500 | PM703574 |
| 15060000157579 | L15/dossiers | 15 | 15060000157578 | 15060000157578 | 1 | PA205280 | PM736412 |
| 15060000157586 | L15/dossiers | 15 | 15060000157585 | 15060000157585 | 1 | PA267081 | PM703617 |
| 15060000157593 | L15/dossiers | 15 | 15060000157592 | 15060000157592 | 1 | PA703485 | PM703654 |
| 15060000157600 | L15/dossiers | 15 | 15060000157599 | 15060000157599 | 1 | PA205280 | PM736412 |
| 15060000157607 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 1 | PA304082 | PM736354 |
| 15060000157608 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 2 | PA757676 | PM757692 |
| 15060000157609 | L15/dossiers | 15 | 15060000157606 | 15060000157606 | 3 | PA429891 | PM736329 |