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 |
|---|---|---|---|---|---|---|---|
| 16060000118083 | L16/dossiers | 16 | 16060000118082 | 16060000118082 | 1 | PA717161 | PM791583 |
| 16060000118124 | L16/dossiers | 16 | 16060000118123 | 16060000118123 | 1 | PA717161 | PM791583 |
| 16060000118147 | L16/dossiers | 16 | 16060000118146 | 16060000118146 | 1 | PA793948 | PM796617 |
| 16060000118165 | L16/dossiers | 16 | 16060000118164 | 16060000118164 | 1 | PA795722 | PM797649 |
| 16060000118172 | L16/dossiers | 16 | 16060000118171 | 16060000118171 | 1 | PA717161 | PM791583 |
| 16060000118180 | L16/dossiers | 16 | 16060000118179 | 16060000118179 | 1 | PA721722 | PM797502 |
| 16060000118188 | L16/dossiers | 16 | 16060000118187 | 16060000118187 | 1 | PA827922 | PM828580 |
| 16060000118189 | L16/dossiers | 16 | 16060000118187 | 16060000118187 | 2 | PA404656 | PM829669 |
| 16060000118190 | L16/dossiers | 16 | 16060000118187 | 16060000118187 | 3 | PA828008 | PM828826 |
| 16060000118200 | L16/dossiers | 16 | 16060000118199 | 16060000118199 | 1 | PA736167 | PM829803 |
| 16060000118207 | L16/dossiers | 16 | 16060000118206 | 16060000118206 | 1 | PA795058 | PM797277 |
| 16060000118217 | L16/dossiers | 16 | 16060000118216 | 16060000118216 | 1 | PA791824 | PM797808 |
| 16060000118236 | L16/dossiers | 16 | 16060000118235 | 16060000118235 | 1 | PA717161 | PM791583 |
| 16060000118243 | L16/dossiers | 16 | 16060000118242 | 16060000118242 | 1 | PA794906 | PM797187 |
| 16060000118250 | L16/dossiers | 16 | 16060000118249 | 16060000118249 | 1 | PA795820 | PM797700 |
| 16060000118258 | L16/dossiers | 16 | 16060000118257 | 16060000118257 | 1 | PA266795 | PM775711 |
| 16060000118276 | L16/dossiers | 16 | 16060000118275 | 16060000118275 | 1 | PA382672 | PM829681 |
| 16060000118283 | L16/dossiers | 16 | 16060000118282 | 16060000118282 | 1 | PA267241 | PM778080 |
| 16060000118290 | L16/dossiers | 16 | 16060000118289 | 16060000118289 | 1 | PA720900 | PM797553 |
| 16060000118308 | L16/dossiers | 16 | 16060000118307 | 16060000118307 | 1 | PA793246 | PM796227 |
| 16060000118315 | L16/dossiers | 16 | 16060000118314 | 16060000118314 | 1 | PA793322 | PM796260 |
| 16060000118322 | L16/dossiers | 16 | 16060000118321 | 16060000118321 | 1 | PA720704 | PM797067 |
| 16060000118329 | L16/dossiers | 16 | 16060000118328 | 16060000118328 | 1 | PA721482 | PM797514 |
| 16060000118362 | L16/dossiers | 16 | 16060000118361 | 16060000118361 | 1 | PA721984 | PM797367 |
| 16060000118369 | L16/dossiers | 16 | 16060000118368 | 16060000118368 | 1 | PA794830 | PM797145 |
| 16060000118421 | L16/dossiers | 16 | 16060000118420 | 16060000118420 | 1 | PA718978 | PM796320 |
| 16060000118428 | L16/dossiers | 16 | 16060000118427 | 16060000118427 | 1 | PA722038 | PM797847 |
| 16060000118436 | L16/dossiers | 16 | 16060000118435 | 16060000118435 | 1 | PA793860 | PM803290 |
| 16060000118449 | L16/dossiers | 16 | 16060000118448 | 16060000118448 | 1 | PA718850 | PM796203 |
| 16060000118456 | L16/dossiers | 16 | 16060000118455 | 16060000118455 | 1 | PA720846 | PM797328 |
| 16060000118464 | L16/dossiers | 16 | 16060000118463 | 16060000118463 | 1 | PA795508 | PM797526 |
| 16060000118516 | L16/dossiers | 16 | 16060000118515 | 16060000118515 | 1 | PA643089 | PM797439 |
| 16060000118523 | L16/dossiers | 16 | 16060000118522 | 16060000118522 | 1 | PA267306 | PM797073 |
| 16060000118530 | L16/dossiers | 16 | 16060000118529 | 16060000118529 | 1 | PA722102 | PM797850 |
| 16060000118537 | L16/dossiers | 16 | 16060000118536 | 16060000118536 | 1 | PA722162 | PM797475 |
| 16060000118561 | L16/dossiers | 16 | 16060000118560 | 16060000118560 | 1 | PA720908 | PM797556 |
| 16060000118568 | L16/dossiers | 16 | 16060000118567 | 16060000118567 | 1 | PA794066 | PM796689 |
| 16060000118575 | L16/dossiers | 16 | 16060000118574 | 16060000118574 | 1 | PA722344 | PM797244 |
| 16060000118582 | L16/dossiers | 16 | 16060000118581 | 16060000118581 | 1 | PA793680 | PM796476 |
| 16060000118589 | L16/dossiers | 16 | 16060000118588 | 16060000118588 | 1 | PA721984 | PM797367 |
| 16060000118596 | L16/dossiers | 16 | 16060000118595 | 16060000118595 | 1 | PA793736 | PM796503 |
| 16060000118603 | L16/dossiers | 16 | 16060000118602 | 16060000118602 | 1 | PA607090 | PM796761 |
| 16060000118610 | L16/dossiers | 16 | 16060000118609 | 16060000118609 | 1 | PA793632 | PM796443 |
| 16060000118617 | L16/dossiers | 16 | 16060000118616 | 16060000118616 | 1 | PA608416 | PM797133 |
| 16060000118624 | L16/dossiers | 16 | 16060000118623 | 16060000118623 | 1 | PA793122 | PM796161 |
| 16060000118631 | L16/dossiers | 16 | 16060000118630 | 16060000118630 | 1 | PA719294 | PM796431 |
| 16060000118638 | L16/dossiers | 16 | 16060000118637 | 16060000118637 | 1 | PA719318 | PM796470 |
| 16060000118645 | L16/dossiers | 16 | 16060000118644 | 16060000118644 | 1 | PA720908 | PM797556 |
| 16060000118655 | L16/dossiers | 16 | 16060000118654 | 16060000118654 | 1 | PA795482 | PM797508 |
| 16060000118659 | L16/dossiers | 16 | 16060000118658 | 16060000118658 | 1 | PA717161 | PM791583 |