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 |
|---|---|---|---|---|---|---|---|
| 15060000173971 | L15/dossiers | 15 | 15060000173970 | 15060000173970 | 1 | PA773441 | PM773491 |
| 15060000173978 | L15/dossiers | 15 | 15060000173977 | 15060000173977 | 1 | PA2116 | PM736339 |
| 15060000173988 | L15/dossiers | 15 | 15060000173987 | 15060000173987 | 1 | PA774952 | PM774983 |
| 15060000173992 | L15/dossiers | 15 | 15060000173991 | 15060000173991 | 1 | PA719980 | PM722822 |
| 15060000174000 | L15/dossiers | 15 | 15060000173999 | 15060000173999 | 1 | PA774952 | PM774983 |
| 15060000174007 | L15/dossiers | 15 | 15060000174006 | 15060000174006 | 1 | PA334768 | PM723548 |
| 15060000174014 | L15/dossiers | 15 | 15060000174013 | 15060000174013 | 1 | PA722102 | PM723472 |
| 15060000174049 | L15/dossiers | 15 | 15060000174048 | 15060000174048 | 1 | PA721750 | PM723372 |
| 15060000174136 | L15/dossiers | 15 | 15060000174135 | 15060000174135 | 1 | PA720500 | PM722982 |
| 15060000174140 | L15/dossiers | 15 | 15060000174139 | 15060000174139 | 1 | PA719608 | PM722710 |
| 15060000174147 | L15/dossiers | 15 | 15060000174146 | 15060000174146 | 1 | PA719798 | PM722766 |
| 15060000174154 | L15/dossiers | 15 | 15060000174153 | 15060000174153 | 1 | PA720746 | PM723064 |
| 15060000174180 | L15/dossiers | 15 | 15060000174179 | 15060000174179 | 1 | PA773441 | PM773491 |
| 15060000174181 | L15/dossiers | 15 | 15060000174179 | 15060000174179 | 2 | PA1872 | PM773455 |
| 15060000174193 | L15/dossiers | 15 | 15060000174192 | 15060000174192 | 1 | PA2116 | PM736339 |
| 15060000174203 | L15/dossiers | 15 | 15060000174202 | 15060000174202 | 1 | PA703485 | PM775811 |
| 15060000174210 | L15/dossiers | 15 | 15060000174209 | 15060000174209 | 1 | PA720500 | PM722982 |
| 15060000174214 | L15/dossiers | 15 | 15060000174213 | 15060000174213 | 1 | PA703485 | PM775811 |
| 15060000174221 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 1 | PA429835 | PM736397 |
| 15060000174222 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 2 | PA429835 | PM736397 |
| 15060000174223 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 3 | PA736214 | PM736290 |
| 15060000174224 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 4 | PA775206 | PM775506 |
| 15060000174225 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 5 | PA703536 | PM775719 |
| 15060000174226 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 6 | PA736187 | PM736365 |
| 15060000174227 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 7 | PA736229 | PM736389 |
| 15060000174228 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 8 | PA590034 | PM775606 |
| 15060000174229 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 9 | PA736217 | PM736384 |
| 15060000174230 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 10 | PA736191 | PM736336 |
| 15060000174231 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 11 | PA775274 | PM775560 |
| 15060000174232 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 12 | PA736219 | PM736387 |
| 15060000174233 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 13 | PA415488 | PM775641 |
| 15060000174234 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 14 | PA775268 | PM775574 |
| 15060000174235 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 15 | PA227096 | PM736342 |
| 15060000174236 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 16 | PA227096 | PM736342 |
| 15060000174237 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 17 | PA429855 | PM736425 |
| 15060000174238 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 18 | PA703512 | PM775665 |
| 15060000174239 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 19 | PA766947 | PM775799 |
| 15060000174240 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 20 | PA342564 | PM736388 |
| 15060000174241 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 21 | PA732419 | PM775647 |
| 15060000174242 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 22 | PA732419 | PM775647 |
| 15060000174243 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 23 | PA703511 | PM775685 |
| 15060000174244 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 24 | PA429852 | PM736275 |
| 15060000174245 | L15/dossiers | 15 | 15060000174220 | 15060000174220 | 25 | PA2774 | PM736307 |
| 15060000174255 | L15/dossiers | 15 | 15060000174254 | 15060000174254 | 1 | PA703485 | PM775811 |
| 15060000174262 | L15/dossiers | 15 | 15060000174261 | 15060000174261 | 1 | PA721932 | PM734586 |
| 15060000174279 | L15/dossiers | 15 | 15060000174278 | 15060000174278 | 1 | PA773441 | PM773491 |
| 15060000174280 | L15/dossiers | 15 | 15060000174278 | 15060000174278 | 2 | PA642788 | PM773495 |
| 15060000174287 | L15/dossiers | 15 | 15060000174286 | 15060000174286 | 1 | PA266797 | PM722884 |
| 15060000174291 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 1 | PA736173 | PM736369 |
| 15060000174292 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 2 | PA429836 | PM736345 |