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 |
|---|---|---|---|---|---|---|---|
| 14060000133063 | L14/dossiers | 14 | 14060000133061 | 14060000133061 | 2 | PA702992 | PM702994 |
| 14060000133119 | L14/dossiers | 14 | 14060000133118 | 14060000133118 | 1 | PA334149 | PM645127 |
| 14060000133129 | L14/dossiers | 14 | 14060000133128 | 14060000133128 | 1 | PA267336 | PM645424 |
| 14060000133155 | L14/dossiers | 14 | 14060000133154 | 14060000133154 | 1 | PA2774 | PM429910 |
| 14060000133187 | L14/dossiers | 14 | 14060000133186 | 14060000133186 | 1 | PA2075 | PM645260 |
| 14060000133194 | L14/dossiers | 14 | 14060000133193 | 14060000133193 | 1 | PA2775 | PM645461 |
| 14060000133210 | L14/dossiers | 14 | 14060000133209 | 14060000133209 | 1 | PA334149 | PM645127 |
| 14060000133217 | L14/dossiers | 14 | 14060000133216 | 14060000133216 | 1 | PA267492 | PM645465 |
| 14060000133224 | L14/dossiers | 14 | 14060000133223 | 14060000133223 | 1 | PA330788 | PM645510 |
| 14060000133234 | L14/dossiers | 14 | 14060000133233 | 14060000133233 | 1 | PA328 | PM653228 |
| 14060000133235 | L14/dossiers | 14 | 14060000133233 | 14060000133233 | 2 | PA2240 | PM653295 |
| 14060000133244 | L14/dossiers | 14 | 14060000133243 | 14060000133243 | 1 | PA2796 | PM645520 |
| 14060000133245 | L14/dossiers | 14 | 14060000133243 | 14060000133243 | 2 | PA2775 | PM645461 |
| 14060000133249 | L14/dossiers | 14 | 14060000133248 | 14060000133248 | 1 | PA735 | PM645089 |
| 14060000133264 | L14/dossiers | 14 | 14060000133263 | 14060000133263 | 1 | PA267492 | PM645465 |
| 14060000133271 | L14/dossiers | 14 | 14060000133270 | 14060000133270 | 1 | PA2664 | PM645139 |
| 14060000133282 | L14/dossiers | 14 | 14060000133281 | 14060000133281 | 1 | PA266774 | PM645583 |
| 14060000133289 | L14/dossiers | 14 | 14060000133288 | 14060000133288 | 1 | PA266797 | PM645338 |
| 14060000133310 | L14/dossiers | 14 | 14060000133309 | 14060000133309 | 1 | PA267551 | PM645372 |
| 14060000133317 | L14/dossiers | 14 | 14060000133316 | 14060000133316 | 1 | PA1748 | PM645566 |
| 14060000133324 | L14/dossiers | 14 | 14060000133323 | 14060000133323 | 1 | PA1886 | PM645099 |
| 14060000133342 | L14/dossiers | 14 | 14060000133341 | 14060000133341 | 1 | PA608011 | PM645066 |
| 14060000133343 | L14/dossiers | 14 | 14060000133341 | 14060000133341 | 2 | PA336576 | PM645364 |
| 14060000133358 | L14/dossiers | 14 | 14060000133357 | 14060000133357 | 1 | PA2952 | PM645464 |
| 14060000133365 | L14/dossiers | 14 | 14060000133364 | 14060000133364 | 1 | PA267457 | PM687216 |
| 14060000133375 | L14/dossiers | 14 | 14060000133374 | 14060000133374 | 1 | PA266788 | PM645294 |
| 14060000133382 | L14/dossiers | 14 | 14060000133381 | 14060000133381 | 1 | PA1654 | PM703255 |
| 14060000133383 | L14/dossiers | 14 | 14060000133381 | 14060000133381 | 2 | PA2791 | PM702981 |
| 14060000133423 | L14/dossiers | 14 | 14060000133422 | 14060000133422 | 1 | PA267260 | PM645459 |
| 14060000133430 | L14/dossiers | 14 | 14060000133429 | 14060000133429 | 1 | PA267622 | PM702957 |
| 14060000133463 | L14/dossiers | 14 | 14060000133462 | 14060000133462 | 1 | PA2597 | PM645126 |
| 14060000133470 | L14/dossiers | 14 | 14060000133469 | 14060000133469 | 1 | PA2828 | PM645402 |
| 14060000133477 | L14/dossiers | 14 | 14060000133476 | 14060000133476 | 1 | PA267551 | PM645372 |
| 14060000133484 | L14/dossiers | 14 | 14060000133483 | 14060000133483 | 1 | PA2960 | PM645040 |
| 14060000133491 | L14/dossiers | 14 | 14060000133490 | 14060000133490 | 1 | PA2086 | PM645043 |
| 14060000133498 | L14/dossiers | 14 | 14060000133497 | 14060000133497 | 1 | PA267492 | PM645465 |
| 14060000133505 | L14/dossiers | 14 | 14060000133504 | 14060000133504 | 1 | PA328 | PM653228 |
| 14060000133545 | L14/dossiers | 14 | 14060000133544 | 14060000133544 | 1 | PA1886 | PM645099 |
| 14060000133554 | L14/dossiers | 14 | 14060000133553 | 14060000133553 | 1 | PA332950 | PM645251 |
| 14060000133576 | L14/dossiers | 14 | 14060000133575 | 14060000133575 | 1 | PA295 | PM645103 |
| 14060000133583 | L14/dossiers | 14 | 14060000133582 | 14060000133582 | 1 | PA267622 | PM700712 |
| 14060000133584 | L14/dossiers | 14 | 14060000133582 | 14060000133582 | 2 | PA2679 | PM700726 |
| 14060000133585 | L14/dossiers | 14 | 14060000133582 | 14060000133582 | 3 | PA2825 | PM700732 |
| 14060000133680 | L14/dossiers | 14 | 14060000133679 | 14060000133679 | 1 | PA346 | PM645086 |
| 14060000133691 | L14/dossiers | 14 | 14060000133690 | 14060000133690 | 1 | PA267622 | PM702957 |
| 14060000133692 | L14/dossiers | 14 | 14060000133690 | 14060000133690 | 2 | PA2650 | PM711559 |
| 14060000133747 | L14/dossiers | 14 | 14060000133746 | 14060000133746 | 1 | PA330684 | PM645497 |
| 14060000133754 | L14/dossiers | 14 | 14060000133753 | 14060000133753 | 1 | PA267622 | PM702957 |
| 14060000133761 | L14/dossiers | 14 | 14060000133760 | 14060000133760 | 1 | PA785 | PM715797 |
| 14060000133771 | L14/dossiers | 14 | 14060000133770 | 14060000133770 | 1 | PA689 | PM645113 |