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 |
|---|---|---|---|---|---|---|---|
| 16060000120219 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 61 | PA736214 | PM829883 |
| 16060000120220 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 62 | PA775294 | PM775580 |
| 16060000120221 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 63 | PA828014 | PM828818 |
| 16060000120222 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 64 | PA828022 | PM828870 |
| 16060000120229 | L16/dossiers | 16 | 16060000120228 | 16060000120228 | 1 | PA827958 | PM828690 |
| 16060000120236 | L16/dossiers | 16 | 16060000120235 | 16060000120235 | 1 | PA720614 | PM797055 |
| 16060000120247 | L16/dossiers | 16 | 16060000120246 | 16060000120246 | 1 | PA793322 | PM796260 |
| 16060000120254 | L16/dossiers | 16 | 16060000120253 | 16060000120253 | 1 | PA736235 | PM775795 |
| 16060000120261 | L16/dossiers | 16 | 16060000120260 | 16060000120260 | 1 | PA736235 | PM775795 |
| 16060000120288 | L16/dossiers | 16 | 16060000120287 | 16060000120287 | 1 | PA795164 | PM797337 |
| 16060000120298 | L16/dossiers | 16 | 16060000120297 | 16060000120297 | 1 | PA720892 | PM797520 |
| 16060000120308 | L16/dossiers | 16 | 16060000120307 | 16060000120307 | 1 | PA793744 | PM796506 |
| 16060000120315 | L16/dossiers | 16 | 16060000120314 | 16060000120314 | 1 | PA793736 | PM796503 |
| 16060000120322 | L16/dossiers | 16 | 16060000120321 | 16060000120321 | 1 | PA722038 | PM797847 |
| 16060000120338 | L16/dossiers | 16 | 16060000120337 | 16060000120337 | 1 | PA794938 | PM797202 |
| 16060000120345 | L16/dossiers | 16 | 16060000120344 | 16060000120344 | 1 | PA722336 | PM797139 |
| 16060000120367 | L16/dossiers | 16 | 16060000120366 | 16060000120366 | 1 | PA795026 | PM797259 |
| 16060000120390 | L16/dossiers | 16 | 16060000120389 | 16060000120389 | 1 | PA794838 | PM797148 |
| 16060000120405 | L16/dossiers | 16 | 16060000120404 | 16060000120404 | 1 | PA793624 | PM796440 |
| 16060000120412 | L16/dossiers | 16 | 16060000120411 | 16060000120411 | 1 | PA342384 | PM796656 |
| 16060000120419 | L16/dossiers | 16 | 16060000120418 | 16060000120418 | 1 | PA783457 | PM796992 |
| 16060000120426 | L16/dossiers | 16 | 16060000120425 | 16060000120425 | 1 | PA719578 | PM796620 |
| 16060000120433 | L16/dossiers | 16 | 16060000120432 | 16060000120432 | 1 | PA720286 | PM796878 |
| 16060000120440 | L16/dossiers | 16 | 16060000120439 | 16060000120439 | 1 | PA793322 | PM796260 |
| 16060000120447 | L16/dossiers | 16 | 16060000120446 | 16060000120446 | 1 | PA794118 | PM796725 |
| 16060000120454 | L16/dossiers | 16 | 16060000120453 | 16060000120453 | 1 | PA722190 | PM833697 |
| 16060000120488 | L16/dossiers | 16 | 16060000120487 | 16060000120487 | 1 | PA722190 | PM833697 |
| 16060000120525 | L16/dossiers | 16 | 16060000120524 | 16060000120524 | 1 | PA569 | PM775717 |
| 16060000120526 | L16/dossiers | 16 | 16060000120524 | 16060000120524 | 2 | PA429832 | PM829723 |
| 16060000120533 | L16/dossiers | 16 | 16060000120532 | 16060000120532 | 1 | PA703485 | PM775811 |
| 16060000120540 | L16/dossiers | 16 | 16060000120539 | 16060000120539 | 1 | PA266788 | PM796788 |
| 16060000120548 | L16/dossiers | 16 | 16060000120547 | 16060000120547 | 1 | PA795184 | PM797346 |
| 16060000120552 | L16/dossiers | 16 | 16060000120551 | 16060000120551 | 1 | PA721474 | PM797511 |
| 16060000120559 | L16/dossiers | 16 | 16060000120558 | 16060000120558 | 1 | PA607553 | PM796875 |
| 16060000120566 | L16/dossiers | 16 | 16060000120565 | 16060000120565 | 1 | PA794008 | PM796653 |
| 16060000120573 | L16/dossiers | 16 | 16060000120572 | 16060000120572 | 1 | PA703518 | PM775673 |
| 16060000120574 | L16/dossiers | 16 | 16060000120572 | 16060000120572 | 2 | PA267081 | PM775733 |
| 16060000120575 | L16/dossiers | 16 | 16060000120572 | 16060000120572 | 3 | PA2538 | PM775801 |
| 16060000120576 | L16/dossiers | 16 | 16060000120572 | 16060000120572 | 4 | PA736218 | PM829869 |
| 16060000120595 | L16/dossiers | 16 | 16060000120594 | 16060000120594 | 1 | PA715322 | PM775713 |
| 16060000120602 | L16/dossiers | 16 | 16060000120601 | 16060000120601 | 1 | PA794906 | PM797187 |
| 16060000120609 | L16/dossiers | 16 | 16060000120608 | 16060000120608 | 1 | PA722150 | PM797445 |
| 16060000120663 | L16/dossiers | 16 | 16060000120662 | 16060000120662 | 1 | PA722202 | PM797358 |
| 16060000120664 | L16/dossiers | 16 | 16060000120662 | 16060000120662 | 2 | PA794486 | PM796953 |
| 16060000120671 | L16/dossiers | 16 | 16060000120670 | 16060000120670 | 1 | PA722366 | PM797193 |
| 16060000120684 | L16/dossiers | 16 | 16060000120683 | 16060000120683 | 1 | PA795330 | PM823122 |
| 16060000120688 | L16/dossiers | 16 | 16060000120687 | 16060000120687 | 1 | PA722190 | PM833697 |
| 16060000120689 | L16/dossiers | 16 | 16060000120687 | 16060000120687 | 2 | PA833735 | PM833737 |
| 16060000120719 | L16/dossiers | 16 | 16060000120718 | 16060000120718 | 1 | PA793374 | PM796290 |
| 16060000120723 | L16/dossiers | 16 | 16060000120722 | 16060000120722 | 1 | PA605745 | PM796419 |