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 |
|---|---|---|---|---|---|---|---|
| 15060000185334 | L15/dossiers | 15 | 15060000185333 | 15060000185333 | 1 | PA721742 | PM723370 |
| 15060000185342 | L15/dossiers | 15 | 15060000185341 | 15060000185341 | 1 | PA720746 | PM723064 |
| 15060000185350 | L15/dossiers | 15 | 15060000185349 | 15060000185349 | 1 | PA266788 | PM722914 |
| 15060000185357 | L15/dossiers | 15 | 15060000185356 | 15060000185356 | 1 | PA266788 | PM722914 |
| 15060000185364 | L15/dossiers | 15 | 15060000185363 | 15060000185363 | 1 | PA721486 | PM723290 |
| 15060000185371 | L15/dossiers | 15 | 15060000185370 | 15060000185370 | 1 | PA721486 | PM723290 |
| 15060000185378 | L15/dossiers | 15 | 15060000185377 | 15060000185377 | 1 | PA721984 | PM723440 |
| 15060000185385 | L15/dossiers | 15 | 15060000185384 | 15060000185384 | 1 | PA2116 | PM736339 |
| 15060000185392 | L15/dossiers | 15 | 15060000185391 | 15060000185391 | 1 | PA775292 | PM775582 |
| 15060000185393 | L15/dossiers | 15 | 15060000185391 | 15060000185391 | 2 | PA341381 | PM775747 |
| 15060000185394 | L15/dossiers | 15 | 15060000185391 | 15060000185391 | 3 | PA703497 | PM775637 |
| 15060000185404 | L15/dossiers | 15 | 15060000185403 | 15060000185403 | 1 | PA608695 | PM723564 |
| 15060000185408 | L15/dossiers | 15 | 15060000185407 | 15060000185407 | 1 | PA722252 | PM723518 |
| 15060000185415 | L15/dossiers | 15 | 15060000185414 | 15060000185414 | 1 | PA330909 | PM722548 |
| 15060000185422 | L15/dossiers | 15 | 15060000185421 | 15060000185421 | 1 | PA335054 | PM723254 |
| 15060000185423 | L15/dossiers | 15 | 15060000185421 | 15060000185421 | 2 | PA721372 | PM723252 |
| 15060000185433 | L15/dossiers | 15 | 15060000185432 | 15060000185432 | 1 | PA569 | PM775717 |
| 15060000185452 | L15/dossiers | 15 | 15060000185451 | 15060000185451 | 1 | PA773441 | PM773491 |
| 15060000185459 | L15/dossiers | 15 | 15060000185458 | 15060000185458 | 1 | PA773441 | PM773491 |
| 15060000185479 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 1 | PA702993 | PM736362 |
| 15060000185480 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 2 | PA429855 | PM736425 |
| 15060000185481 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 3 | PA736219 | PM736387 |
| 15060000185482 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 4 | PA304002 | PM736326 |
| 15060000185483 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 5 | PA736199 | PM736284 |
| 15060000185484 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 6 | PA775186 | PM775484 |
| 15060000185485 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 7 | PA415488 | PM775641 |
| 15060000185486 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 8 | PA775194 | PM775476 |
| 15060000185487 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 9 | PA775196 | PM775482 |
| 15060000185488 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 10 | PA775200 | PM775504 |
| 15060000185489 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 11 | PA775206 | PM775506 |
| 15060000185490 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 12 | PA590034 | PM775606 |
| 15060000185491 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 13 | PA785855 | PM785869 |
| 15060000185492 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 14 | PA736234 | PM736424 |
| 15060000185493 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 15 | PA429835 | PM736397 |
| 15060000185494 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 16 | PA429835 | PM736397 |
| 15060000185495 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 17 | PA775210 | PM775492 |
| 15060000185496 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 18 | PA732419 | PM775647 |
| 15060000185497 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 19 | PA732419 | PM775647 |
| 15060000185498 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 20 | PA703538 | PM775715 |
| 15060000185499 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 21 | PA429867 | PM736298 |
| 15060000185500 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 22 | PA429833 | PM736271 |
| 15060000185501 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 23 | PA736191 | PM736336 |
| 15060000185502 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 24 | PA708633 | PM775669 |
| 15060000185503 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 25 | PA415477 | PM775809 |
| 15060000185504 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 26 | PA415477 | PM775809 |
| 15060000185505 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 27 | PA736187 | PM736365 |
| 15060000185506 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 28 | PA766947 | PM775799 |
| 15060000185507 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 29 | PA642756 | PM775779 |
| 15060000185508 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 30 | PA736248 | PM736269 |
| 15060000185509 | L15/dossiers | 15 | 15060000185478 | 15060000185478 | 31 | PA736241 | PM736300 |