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 |
|---|---|---|---|---|---|---|---|
| 14060000106256 | L14/dossiers | 14 | 14060000106255 | 14060000106255 | 1 | PA2790 | PM429928 |
| 14060000106289 | L14/dossiers | 14 | 14060000106288 | 14060000106288 | 1 | PA1585 | PM645094 |
| 14060000106296 | L14/dossiers | 14 | 14060000106295 | 14060000106295 | 1 | PA267622 | PM700712 |
| 14060000106297 | L14/dossiers | 14 | 14060000106295 | 14060000106295 | 2 | PA2825 | PM700732 |
| 14060000106304 | L14/dossiers | 14 | 14060000106303 | 14060000106303 | 1 | PA609764 | PM645323 |
| 14060000106311 | L14/dossiers | 14 | 14060000106310 | 14060000106310 | 1 | PA610521 | PM645190 |
| 14060000106321 | L14/dossiers | 14 | 14060000106320 | 14060000106320 | 1 | PA335159 | PM645554 |
| 14060000106328 | L14/dossiers | 14 | 14060000106327 | 14060000106327 | 1 | PA267246 | PM645340 |
| 14060000106335 | L14/dossiers | 14 | 14060000106334 | 14060000106334 | 1 | PA334149 | PM645127 |
| 14060000106342 | L14/dossiers | 14 | 14060000106341 | 14060000106341 | 1 | PA1401 | PM645439 |
| 14060000106349 | L14/dossiers | 14 | 14060000106348 | 14060000106348 | 1 | PA1459 | PM645518 |
| 14060000106368 | L14/dossiers | 14 | 14060000106367 | 14060000106367 | 1 | PA328 | PM653228 |
| 14060000106398 | L14/dossiers | 14 | 14060000106397 | 14060000106397 | 1 | PA2775 | PM645461 |
| 14060000106405 | L14/dossiers | 14 | 14060000106404 | 14060000106404 | 1 | PA2796 | PM645520 |
| 14060000106412 | L14/dossiers | 14 | 14060000106411 | 14060000106411 | 1 | PA267622 | PM702957 |
| 14060000106443 | L14/dossiers | 14 | 14060000106442 | 14060000106442 | 1 | PA415482 | PM703556 |
| 14060000106453 | L14/dossiers | 14 | 14060000106452 | 14060000106452 | 1 | PA551 | PM645487 |
| 14060000106460 | L14/dossiers | 14 | 14060000106459 | 14060000106459 | 1 | PA343623 | PM645408 |
| 14060000106467 | L14/dossiers | 14 | 14060000106466 | 14060000106466 | 1 | PA330240 | PM645425 |
| 14060000106477 | L14/dossiers | 14 | 14060000106476 | 14060000106476 | 1 | PA1874 | PM645474 |
| 14060000106484 | L14/dossiers | 14 | 14060000106483 | 14060000106483 | 1 | PA2083 | PM645105 |
| 14060000106491 | L14/dossiers | 14 | 14060000106490 | 14060000106490 | 1 | PA1871 | PM645374 |
| 14060000106498 | L14/dossiers | 14 | 14060000106497 | 14060000106497 | 1 | PA267151 | PM645165 |
| 14060000106505 | L14/dossiers | 14 | 14060000106504 | 14060000106504 | 1 | PA2796 | PM645520 |
| 14060000106512 | L14/dossiers | 14 | 14060000106511 | 14060000106511 | 1 | PA267492 | PM645465 |
| 14060000106519 | L14/dossiers | 14 | 14060000106518 | 14060000106518 | 1 | PA267622 | PM702957 |
| 14060000106520 | L14/dossiers | 14 | 14060000106518 | 14060000106518 | 2 | PA335532 | PM702985 |
| 14060000106530 | L14/dossiers | 14 | 14060000106529 | 14060000106529 | 1 | PA606693 | PM645542 |
| 14060000106537 | L14/dossiers | 14 | 14060000106536 | 14060000106536 | 1 | PA267585 | PM645508 |
| 14060000106544 | L14/dossiers | 14 | 14060000106543 | 14060000106543 | 1 | PA266774 | PM645583 |
| 14060000106551 | L14/dossiers | 14 | 14060000106550 | 14060000106550 | 1 | PA267306 | PM645210 |
| 14060000106558 | L14/dossiers | 14 | 14060000106557 | 14060000106557 | 1 | PA687214 | PM687217 |
| 14060000106568 | L14/dossiers | 14 | 14060000106567 | 14060000106567 | 1 | PA2538 | PM303971 |
| 14060000106578 | L14/dossiers | 14 | 14060000106577 | 14060000106577 | 1 | PA267591 | PM645573 |
| 14060000106585 | L14/dossiers | 14 | 14060000106584 | 14060000106584 | 1 | PA712015 | PM712024 |
| 14060000106592 | L14/dossiers | 14 | 14060000106591 | 14060000106591 | 1 | PA330240 | PM645425 |
| 14060000106599 | L14/dossiers | 14 | 14060000106598 | 14060000106598 | 1 | PA328 | PM653228 |
| 14060000106600 | L14/dossiers | 14 | 14060000106598 | 14060000106598 | 2 | PA1268 | PM653525 |
| 14060000106632 | L14/dossiers | 14 | 14060000106631 | 14060000106631 | 1 | PA267241 | PM645246 |
| 14060000106642 | L14/dossiers | 14 | 14060000106641 | 14060000106641 | 1 | PA267551 | PM645372 |
| 14060000106649 | L14/dossiers | 14 | 14060000106648 | 14060000106648 | 1 | PA563 | PM645307 |
| 14060000106656 | L14/dossiers | 14 | 14060000106655 | 14060000106655 | 1 | PA563 | PM645307 |
| 14060000106663 | L14/dossiers | 14 | 14060000106662 | 14060000106662 | 1 | PA267622 | PM702957 |
| 14060000106699 | L14/dossiers | 14 | 14060000106698 | 14060000106698 | 1 | PA785 | PM715797 |
| 14060000106729 | L14/dossiers | 14 | 14060000106728 | 14060000106728 | 1 | PA332523 | PM645550 |
| 14060000106736 | L14/dossiers | 14 | 14060000106735 | 14060000106735 | 1 | PA381 | PM645125 |
| 14060000106758 | L14/dossiers | 14 | 14060000106757 | 14060000106757 | 1 | PA266788 | PM645294 |
| 14060000106765 | L14/dossiers | 14 | 14060000106764 | 14060000106764 | 1 | PA267622 | PM700712 |
| 14060000106766 | L14/dossiers | 14 | 14060000106764 | 14060000106764 | 2 | PA2679 | PM700726 |
| 14060000106818 | L14/dossiers | 14 | 14060000106817 | 14060000106817 | 1 | PA304090 | PM429922 |