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 |
|---|---|---|---|---|---|---|---|
| 15060000180079 | L15/dossiers | 15 | 15060000180078 | 15060000180078 | 1 | PA267306 | PM723054 |
| 15060000180086 | L15/dossiers | 15 | 15060000180085 | 15060000180085 | 1 | PA330788 | PM722570 |
| 15060000180096 | L15/dossiers | 15 | 15060000180095 | 15060000180095 | 1 | PA429855 | PM736425 |
| 15060000180103 | L15/dossiers | 15 | 15060000180102 | 15060000180102 | 1 | PA773441 | PM773491 |
| 15060000180104 | L15/dossiers | 15 | 15060000180102 | 15060000180102 | 2 | PA729332 | PM773437 |
| 15060000180111 | L15/dossiers | 15 | 15060000180110 | 15060000180110 | 1 | PA719330 | PM722628 |
| 15060000180118 | L15/dossiers | 15 | 15060000180117 | 15060000180117 | 1 | PA773441 | PM773491 |
| 15060000180119 | L15/dossiers | 15 | 15060000180117 | 15060000180117 | 2 | PA717157 | PM773477 |
| 15060000180120 | L15/dossiers | 15 | 15060000180117 | 15060000180117 | 3 | PA758792 | PM773493 |
| 15060000180128 | L15/dossiers | 15 | 15060000180127 | 15060000180127 | 1 | PA773441 | PM773491 |
| 15060000180129 | L15/dossiers | 15 | 15060000180127 | 15060000180127 | 2 | PA1872 | PM773455 |
| 15060000180160 | L15/dossiers | 15 | 15060000180159 | 15060000180159 | 1 | PA773441 | PM773491 |
| 15060000180161 | L15/dossiers | 15 | 15060000180159 | 15060000180159 | 2 | PA1872 | PM773455 |
| 15060000180195 | L15/dossiers | 15 | 15060000180194 | 15060000180194 | 1 | PA2377 | PM723550 |
| 15060000180202 | L15/dossiers | 15 | 15060000180201 | 15060000180201 | 1 | PA718810 | PM722464 |
| 15060000180212 | L15/dossiers | 15 | 15060000180211 | 15060000180211 | 1 | PA773441 | PM773491 |
| 15060000180254 | L15/dossiers | 15 | 15060000180253 | 15060000180253 | 1 | PA607553 | PM722956 |
| 15060000180278 | L15/dossiers | 15 | 15060000180277 | 15060000180277 | 1 | PA335054 | PM723254 |
| 15060000180279 | L15/dossiers | 15 | 15060000180277 | 15060000180277 | 2 | PA720738 | PM723062 |
| 15060000180289 | L15/dossiers | 15 | 15060000180288 | 15060000180288 | 1 | PA774956 | PM774979 |
| 15060000180296 | L15/dossiers | 15 | 15060000180295 | 15060000180295 | 1 | PA719186 | PM722588 |
| 15060000180303 | L15/dossiers | 15 | 15060000180302 | 15060000180302 | 1 | PA719778 | PM722760 |
| 15060000180310 | L15/dossiers | 15 | 15060000180309 | 15060000180309 | 1 | PA1874 | PM722598 |
| 15060000180317 | L15/dossiers | 15 | 15060000180316 | 15060000180316 | 1 | PA775188 | PM775490 |
| 15060000180327 | L15/dossiers | 15 | 15060000180326 | 15060000180326 | 1 | PA718926 | PM722502 |
| 15060000180331 | L15/dossiers | 15 | 15060000180330 | 15060000180330 | 1 | PA267330 | PM723392 |
| 15060000180338 | L15/dossiers | 15 | 15060000180337 | 15060000180337 | 1 | PA719608 | PM722710 |
| 15060000180348 | L15/dossiers | 15 | 15060000180347 | 15060000180347 | 1 | PA721932 | PM734586 |
| 15060000180355 | L15/dossiers | 15 | 15060000180354 | 15060000180354 | 1 | PA773441 | PM773491 |
| 15060000180356 | L15/dossiers | 15 | 15060000180354 | 15060000180354 | 2 | PA1872 | PM773455 |
| 15060000180383 | L15/dossiers | 15 | 15060000180382 | 15060000180382 | 1 | PA773441 | PM773491 |
| 15060000180384 | L15/dossiers | 15 | 15060000180382 | 15060000180382 | 2 | PA642788 | PM773495 |
| 15060000180391 | L15/dossiers | 15 | 15060000180390 | 15060000180390 | 1 | PA773441 | PM773491 |
| 15060000180392 | L15/dossiers | 15 | 15060000180390 | 15060000180390 | 2 | PA717157 | PM773477 |
| 15060000180393 | L15/dossiers | 15 | 15060000180390 | 15060000180390 | 3 | PA643210 | PM773481 |
| 15060000180394 | L15/dossiers | 15 | 15060000180390 | 15060000180390 | 4 | PA717159 | PM773461 |
| 15060000180403 | L15/dossiers | 15 | 15060000180402 | 15060000180402 | 1 | PA773441 | PM773491 |
| 15060000180404 | L15/dossiers | 15 | 15060000180402 | 15060000180402 | 2 | PA717161 | PM773483 |
| 15060000180456 | L15/dossiers | 15 | 15060000180455 | 15060000180455 | 1 | PA773441 | PM773491 |
| 15060000180463 | L15/dossiers | 15 | 15060000180462 | 15060000180462 | 1 | PA721832 | PM771998 |
| 15060000180467 | L15/dossiers | 15 | 15060000180466 | 15060000180466 | 1 | PA266788 | PM722914 |
| 15060000180480 | L15/dossiers | 15 | 15060000180479 | 15060000180479 | 1 | PA267260 | PM722476 |
| 15060000180497 | L15/dossiers | 15 | 15060000180496 | 15060000180496 | 1 | PA720500 | PM722982 |
| 15060000180502 | L15/dossiers | 15 | 15060000180501 | 15060000180501 | 1 | PA720746 | PM723064 |
| 15060000180559 | L15/dossiers | 15 | 15060000180558 | 15060000180558 | 1 | PA736171 | PM736322 |
| 15060000180560 | L15/dossiers | 15 | 15060000180558 | 15060000180558 | 2 | PA703492 | PM775657 |
| 15060000180567 | L15/dossiers | 15 | 15060000180566 | 15060000180566 | 1 | PA720568 | PM723002 |
| 15060000180574 | L15/dossiers | 15 | 15060000180573 | 15060000180573 | 1 | PA720746 | PM723064 |
| 15060000180630 | L15/dossiers | 15 | 15060000180629 | 15060000180629 | 1 | PA722110 | PM723474 |
| 15060000180637 | L15/dossiers | 15 | 15060000180636 | 15060000180636 | 1 | PA721182 | PM723196 |