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 |
|---|---|---|---|---|---|---|---|
| 17060000138476 | L17/dossiers | 17 | 17060000138475 | 17060000138475 | 1 | PA793980 | PM842750 |
| 17060000138483 | L17/dossiers | 17 | 17060000138482 | 17060000138482 | 1 | PA795528 | PM843455 |
| 17060000138490 | L17/dossiers | 17 | 17060000138489 | 17060000138489 | 1 | PA721474 | PM843608 |
| 17060000138497 | L17/dossiers | 17 | 17060000138496 | 17060000138496 | 1 | PA840721 | PM842378 |
| 17060000138504 | L17/dossiers | 17 | 17060000138503 | 17060000138503 | 1 | PA267780 | PM843395 |
| 17060000138511 | L17/dossiers | 17 | 17060000138510 | 17060000138510 | 1 | PA720560 | PM843032 |
| 17060000138518 | L17/dossiers | 17 | 17060000138517 | 17060000138517 | 1 | PA793342 | PM842345 |
| 17060000138525 | L17/dossiers | 17 | 17060000138524 | 17060000138524 | 1 | PA2952 | PM842414 |
| 17060000138538 | L17/dossiers | 17 | 17060000138537 | 17060000138537 | 1 | PA841243 | PM842825 |
| 17060000138545 | L17/dossiers | 17 | 17060000138544 | 17060000138544 | 1 | PA841885 | PM843446 |
| 17060000138552 | L17/dossiers | 17 | 17060000138551 | 17060000138551 | 1 | PA330240 | PM842357 |
| 17060000138559 | L17/dossiers | 17 | 17060000138558 | 17060000138558 | 1 | PA841023 | PM842645 |
| 17060000138566 | L17/dossiers | 17 | 17060000138565 | 17060000138565 | 1 | PA794146 | PM842912 |
| 17060000138573 | L17/dossiers | 17 | 17060000138572 | 17060000138572 | 1 | PA795310 | PM840453 |
| 17060000138580 | L17/dossiers | 17 | 17060000138579 | 17060000138579 | 1 | PA719890 | PM842855 |
| 17060000138587 | L17/dossiers | 17 | 17060000138586 | 17060000138586 | 1 | PA817203 | PM842978 |
| 17060000138594 | L17/dossiers | 17 | 17060000138593 | 17060000138593 | 1 | PA793452 | PM842453 |
| 17060000138601 | L17/dossiers | 17 | 17060000138600 | 17060000138600 | 1 | PA794008 | PM842768 |
| 17060000138608 | L17/dossiers | 17 | 17060000138607 | 17060000138607 | 1 | PA795108 | PM843338 |
| 17060000138615 | L17/dossiers | 17 | 17060000138614 | 17060000138614 | 1 | PA842117 | PM843635 |
| 17060000138622 | L17/dossiers | 17 | 17060000138621 | 17060000138621 | 1 | PA841539 | PM843119 |
| 17060000138629 | L17/dossiers | 17 | 17060000138628 | 17060000138628 | 1 | PA793444 | PM840270 |
| 17060000138636 | L17/dossiers | 17 | 17060000138635 | 17060000138635 | 1 | PA841215 | PM842801 |
| 17060000138643 | L17/dossiers | 17 | 17060000138642 | 17060000138642 | 1 | PA794094 | PM840291 |
| 17060000138650 | L17/dossiers | 17 | 17060000138649 | 17060000138649 | 1 | PA794094 | PM840291 |
| 17060000138657 | L17/dossiers | 17 | 17060000138656 | 17060000138656 | 1 | PA794094 | PM840291 |
| 17060000138664 | L17/dossiers | 17 | 17060000138663 | 17060000138663 | 1 | PA720430 | PM843092 |
| 17060000138671 | L17/dossiers | 17 | 17060000138670 | 17060000138670 | 1 | PA794870 | PM843185 |
| 17060000138678 | L17/dossiers | 17 | 17060000138677 | 17060000138677 | 1 | PA720430 | PM843092 |
| 17060000138685 | L17/dossiers | 17 | 17060000138684 | 17060000138684 | 1 | PA795084 | PM840369 |
| 17060000138692 | L17/dossiers | 17 | 17060000138691 | 17060000138691 | 1 | PA794082 | PM842810 |
| 17060000138699 | L17/dossiers | 17 | 17060000138698 | 17060000138698 | 1 | PA841845 | PM843407 |
| 17060000138706 | L17/dossiers | 17 | 17060000138705 | 17060000138705 | 1 | PA793904 | PM840288 |
| 17060000138713 | L17/dossiers | 17 | 17060000138712 | 17060000138712 | 1 | PA841251 | PM842837 |
| 17060000138720 | L17/dossiers | 17 | 17060000138719 | 17060000138719 | 1 | PA793816 | PM842657 |
| 17060000138727 | L17/dossiers | 17 | 17060000138726 | 17060000138726 | 1 | PA827908 | PM828500 |
| 17060000138728 | L17/dossiers | 17 | 17060000138726 | 17060000138726 | 2 | PA736174 | PM829797 |
| 17060000138735 | L17/dossiers | 17 | 17060000138734 | 17060000138734 | 1 | PA610002 | PM840363 |
| 17060000138742 | L17/dossiers | 17 | 17060000138741 | 17060000138741 | 1 | PA795808 | PM843644 |
| 17060000138746 | L17/dossiers | 17 | 17060000138745 | 17060000138745 | 1 | PA775254 | PM775556 |
| 17060000138753 | L17/dossiers | 17 | 17060000138752 | 17060000138752 | 1 | PA410 | PM855580 |
| 17060000138784 | L17/dossiers | 17 | 17060000138783 | 17060000138783 | 1 | PA793342 | PM842345 |
| 17060000138791 | L17/dossiers | 17 | 17060000138790 | 17060000138790 | 1 | PA703513 | PM775671 |
| 17060000138792 | L17/dossiers | 17 | 17060000138790 | 17060000138790 | 2 | PA775284 | PM775590 |
| 17060000138799 | L17/dossiers | 17 | 17060000138798 | 17060000138798 | 1 | PA703485 | PM775811 |
| 17060000138806 | L17/dossiers | 17 | 17060000138805 | 17060000138805 | 1 | PA827964 | PM828652 |
| 17060000138813 | L17/dossiers | 17 | 17060000138812 | 17060000138812 | 1 | PA410 | PM855580 |
| 17060000138850 | L17/dossiers | 17 | 17060000138849 | 17060000138849 | 1 | PA267285 | PM842900 |
| 17060000138858 | L17/dossiers | 17 | 17060000138857 | 17060000138857 | 1 | PA720552 | PM843029 |
| 17060000138874 | L17/dossiers | 17 | 17060000138873 | 17060000138873 | 1 | PA720552 | PM843029 |