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 |
|---|---|---|---|---|---|---|---|
| 16060000113637 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 34 | PA703536 | PM775719 |
| 16060000113638 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 35 | PA736229 | PM736389 |
| 16060000113639 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 36 | PA736167 | PM736327 |
| 16060000113640 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 37 | PA429860 | PM736398 |
| 16060000113641 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 38 | PA605888 | PM775604 |
| 16060000113642 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 39 | PA415449 | PM775793 |
| 16060000113643 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 40 | PA342564 | PM736388 |
| 16060000113644 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 41 | PA268048 | PM736422 |
| 16060000113645 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 42 | PA429888 | PM736379 |
| 16060000113646 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 43 | PA2074 | PM775677 |
| 16060000113647 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 44 | PA775254 | PM775556 |
| 16060000113648 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 45 | PA429844 | PM736276 |
| 16060000113649 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 46 | PA775256 | PM775546 |
| 16060000113650 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 47 | PA703512 | PM775665 |
| 16060000113651 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 48 | PA643211 | PM775749 |
| 16060000113652 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 49 | PA775268 | PM775574 |
| 16060000113653 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 50 | PA606375 | PM775602 |
| 16060000113654 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 51 | PA736209 | PM736400 |
| 16060000113655 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 52 | PA703505 | PM775679 |
| 16060000113656 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 53 | PA775274 | PM775560 |
| 16060000113657 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 54 | PA429883 | PM736355 |
| 16060000113658 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 55 | PA429889 | PM736313 |
| 16060000113659 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 56 | PA775290 | PM775576 |
| 16060000113660 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 57 | PA2774 | PM736307 |
| 16060000113661 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 58 | PA736214 | PM736290 |
| 16060000113662 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 59 | PA736217 | PM736384 |
| 16060000113663 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 60 | PA227096 | PM736342 |
| 16060000113664 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 61 | PA775294 | PM775580 |
| 16060000113665 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 62 | PA2870 | PM736316 |
| 16060000113666 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 63 | PA736162 | PM736320 |
| 16060000113667 | L16/dossiers | 16 | 16060000113603 | 16060000113603 | 64 | PA429852 | PM736275 |
| 16060000113674 | L16/dossiers | 16 | 16060000113673 | 16060000113673 | 1 | PA788192 | PM788196 |
| 16060000113675 | L16/dossiers | 16 | 16060000113673 | 16060000113673 | 2 | PA703530 | PM775689 |
| 16060000113676 | L16/dossiers | 16 | 16060000113673 | 16060000113673 | 3 | PA2074 | PM775677 |
| 16060000113683 | L16/dossiers | 16 | 16060000113682 | 16060000113682 | 1 | PA775188 | PM775490 |
| 16060000113693 | L16/dossiers | 16 | 16060000113692 | 16060000113692 | 1 | PA382672 | PM736263 |
| 16060000113700 | L16/dossiers | 16 | 16060000113699 | 16060000113699 | 1 | PA717161 | PM791583 |
| 16060000113701 | L16/dossiers | 16 | 16060000113699 | 16060000113699 | 2 | PA331481 | PM791666 |
| 16060000113702 | L16/dossiers | 16 | 16060000113699 | 16060000113699 | 3 | PA793940 | PM826659 |
| 16060000114235 | L16/dossiers | 16 | 16060000114234 | 16060000114234 | 1 | PA720022 | PM796866 |
| 16060000114242 | L16/dossiers | 16 | 16060000114241 | 16060000114241 | 1 | PA719608 | PM796593 |
| 16060000114249 | L16/dossiers | 16 | 16060000114248 | 16060000114248 | 1 | PA719024 | PM796305 |
| 16060000114256 | L16/dossiers | 16 | 16060000114255 | 16060000114255 | 1 | PA722110 | PM797853 |
| 16060000114263 | L16/dossiers | 16 | 16060000114262 | 16060000114262 | 1 | PA340643 | PM796335 |
| 16060000114270 | L16/dossiers | 16 | 16060000114269 | 16060000114269 | 1 | PA642847 | PM796872 |
| 16060000114277 | L16/dossiers | 16 | 16060000114276 | 16060000114276 | 1 | PA718884 | PM796218 |
| 16060000114284 | L16/dossiers | 16 | 16060000114283 | 16060000114283 | 1 | PA793110 | PM796146 |
| 16060000114291 | L16/dossiers | 16 | 16060000114290 | 16060000114290 | 1 | PA608695 | PM797220 |
| 16060000114292 | L16/dossiers | 16 | 16060000114290 | 16060000114290 | 2 | PA721466 | PM797268 |
| 16060000114299 | L16/dossiers | 16 | 16060000114298 | 16060000114298 | 1 | PA794322 | PM796851 |