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 |
|---|---|---|---|---|---|---|---|
| 15060000177261 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 23 | PA775272 | PM775562 |
| 15060000177262 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 24 | PA736209 | PM736400 |
| 15060000177263 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 25 | PA736201 | PM736347 |
| 15060000177279 | L15/dossiers | 15 | 15060000177278 | 15060000177278 | 1 | PA720278 | PM722916 |
| 15060000177286 | L15/dossiers | 15 | 15060000177285 | 15060000177285 | 1 | PA721486 | PM723290 |
| 15060000177293 | L15/dossiers | 15 | 15060000177292 | 15060000177292 | 1 | PA721486 | PM723290 |
| 15060000177300 | L15/dossiers | 15 | 15060000177299 | 15060000177299 | 1 | PA721506 | PM723296 |
| 15060000177304 | L15/dossiers | 15 | 15060000177303 | 15060000177303 | 1 | PA643134 | PM722824 |
| 15060000177311 | L15/dossiers | 15 | 15060000177310 | 15060000177310 | 1 | PA721398 | PM723262 |
| 15060000177321 | L15/dossiers | 15 | 15060000177320 | 15060000177320 | 1 | PA405480 | PM723118 |
| 15060000177325 | L15/dossiers | 15 | 15060000177324 | 15060000177324 | 1 | PA721286 | PM723224 |
| 15060000177332 | L15/dossiers | 15 | 15060000177331 | 15060000177331 | 1 | PA721776 | PM723380 |
| 15060000177339 | L15/dossiers | 15 | 15060000177338 | 15060000177338 | 1 | PA267785 | PM723310 |
| 15060000177346 | L15/dossiers | 15 | 15060000177345 | 15060000177345 | 1 | PA722280 | PM772999 |
| 15060000177353 | L15/dossiers | 15 | 15060000177352 | 15060000177352 | 1 | PA643134 | PM722824 |
| 15060000177360 | L15/dossiers | 15 | 15060000177359 | 15060000177359 | 1 | PA330240 | PM722492 |
| 15060000177367 | L15/dossiers | 15 | 15060000177366 | 15060000177366 | 1 | PA773441 | PM773491 |
| 15060000177374 | L15/dossiers | 15 | 15060000177373 | 15060000177373 | 1 | PA718884 | PM722488 |
| 15060000177381 | L15/dossiers | 15 | 15060000177380 | 15060000177380 | 1 | PA2116 | PM736339 |
| 15060000177388 | L15/dossiers | 15 | 15060000177387 | 15060000177387 | 1 | PA719002 | PM775857 |
| 15060000177395 | L15/dossiers | 15 | 15060000177394 | 15060000177394 | 1 | PA719002 | PM775857 |
| 15060000177399 | L15/dossiers | 15 | 15060000177398 | 15060000177398 | 1 | PA2538 | PM775801 |
| 15060000177418 | L15/dossiers | 15 | 15060000177417 | 15060000177417 | 1 | PA703513 | PM775671 |
| 15060000177425 | L15/dossiers | 15 | 15060000177424 | 15060000177424 | 1 | PA773441 | PM773491 |
| 15060000177426 | L15/dossiers | 15 | 15060000177424 | 15060000177424 | 2 | PA607846 | PM773469 |
| 15060000177522 | L15/dossiers | 15 | 15060000177521 | 15060000177521 | 1 | PA773441 | PM773491 |
| 15060000177586 | L15/dossiers | 15 | 15060000177585 | 15060000177585 | 1 | PA773441 | PM773491 |
| 15060000177587 | L15/dossiers | 15 | 15060000177585 | 15060000177585 | 2 | PA721670 | PM773499 |
| 15060000177594 | L15/dossiers | 15 | 15060000177593 | 15060000177593 | 1 | PA773441 | PM773491 |
| 15060000177601 | L15/dossiers | 15 | 15060000177600 | 15060000177600 | 1 | PA722202 | PM723502 |
| 15060000177619 | L15/dossiers | 15 | 15060000177618 | 15060000177618 | 1 | PA721968 | PM723436 |
| 15060000177626 | L15/dossiers | 15 | 15060000177625 | 15060000177625 | 1 | PA720214 | PM722894 |
| 15060000177633 | L15/dossiers | 15 | 15060000177632 | 15060000177632 | 1 | PA719778 | PM722760 |
| 15060000177637 | L15/dossiers | 15 | 15060000177636 | 15060000177636 | 1 | PA718876 | PM722486 |
| 15060000177691 | L15/dossiers | 15 | 15060000177690 | 15060000177690 | 1 | PA266788 | PM722914 |
| 15060000177698 | L15/dossiers | 15 | 15060000177697 | 15060000177697 | 1 | PA721896 | PM723414 |
| 15060000177712 | L15/dossiers | 15 | 15060000177711 | 15060000177711 | 1 | PA2116 | PM736339 |
| 15060000177719 | L15/dossiers | 15 | 15060000177718 | 15060000177718 | 1 | PA267306 | PM723054 |
| 15060000177750 | L15/dossiers | 15 | 15060000177749 | 15060000177749 | 1 | PA703513 | PM775671 |
| 15060000177751 | L15/dossiers | 15 | 15060000177749 | 15060000177749 | 2 | PA736226 | PM736280 |
| 15060000177752 | L15/dossiers | 15 | 15060000177749 | 15060000177749 | 3 | PA775206 | PM775506 |
| 15060000177759 | L15/dossiers | 15 | 15060000177758 | 15060000177758 | 1 | PA695100 | PM723198 |
| 15060000177760 | L15/dossiers | 15 | 15060000177758 | 15060000177758 | 2 | PA345722 | PM723428 |
| 15060000177772 | L15/dossiers | 15 | 15060000177771 | 15060000177771 | 1 | PA719072 | PM722552 |
| 15060000177841 | L15/dossiers | 15 | 15060000177840 | 15060000177840 | 1 | PA643103 | PM722614 |
| 15060000177845 | L15/dossiers | 15 | 15060000177844 | 15060000177844 | 1 | PA720878 | PM723102 |
| 15060000177846 | L15/dossiers | 15 | 15060000177844 | 15060000177844 | 2 | PA2960 | PM723006 |
| 15060000177901 | L15/dossiers | 15 | 15060000177900 | 15060000177900 | 1 | PA719072 | PM722552 |
| 15060000177972 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 1 | PA2774 | PM736307 |
| 15060000177973 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 2 | PA703511 | PM775685 |