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 |
|---|---|---|---|---|---|---|---|
| 15060000156253 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 2 | PA703507 | PM703567 |
| 15060000156254 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 3 | PA703515 | PM703592 |
| 15060000156255 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 4 | PA1344 | PM736383 |
| 15060000156256 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 5 | PA703488 | PM703632 |
| 15060000156257 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 6 | PA415447 | PM703616 |
| 15060000156258 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 7 | PA267018 | PM703564 |
| 15060000156259 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 8 | PA267328 | PM703547 |
| 15060000156260 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 9 | PA205280 | PM736412 |
| 15060000156261 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 10 | PA343775 | PM736367 |
| 15060000156262 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 11 | PA736192 | PM736353 |
| 15060000156263 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 12 | PA703539 | PM703693 |
| 15060000156264 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 13 | PA736163 | PM736253 |
| 15060000156265 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 14 | PA720634 | PM736312 |
| 15060000156266 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 15 | PA703500 | PM703574 |
| 15060000156267 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 16 | PA736231 | PM736381 |
| 15060000156268 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 17 | PA736218 | PM736257 |
| 15060000156269 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 18 | PA429874 | PM736314 |
| 15060000156270 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 19 | PA304737 | PM703551 |
| 15060000156271 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 20 | PA415451 | PM703594 |
| 15060000156272 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 21 | PA429870 | PM736309 |
| 15060000156273 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 22 | PA703513 | PM703621 |
| 15060000156274 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 23 | PA425322 | PM736282 |
| 15060000156275 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 24 | PA705750 | PM705821 |
| 15060000156276 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 25 | PA736172 | PM736415 |
| 15060000156277 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 26 | PA343988 | PM736310 |
| 15060000156278 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 27 | PA429854 | PM736335 |
| 15060000156279 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 28 | PA736246 | PM736428 |
| 15060000156280 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 29 | PA415495 | PM703579 |
| 15060000156281 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 30 | PA715745 | PM736297 |
| 15060000156282 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 31 | PA267112 | PM703608 |
| 15060000156283 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 32 | PA342665 | PM736382 |
| 15060000156284 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 33 | PA736216 | PM736273 |
| 15060000156285 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 34 | PA736198 | PM736406 |
| 15060000156286 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 35 | PA736188 | PM736289 |
| 15060000156293 | L15/dossiers | 15 | 15060000156292 | 15060000156292 | 1 | PA415476 | PM703653 |
| 15060000156300 | L15/dossiers | 15 | 15060000156299 | 15060000156299 | 1 | PA2116 | PM736339 |
| 15060000156301 | L15/dossiers | 15 | 15060000156299 | 15060000156299 | 2 | PA736236 | PM736341 |
| 15060000156302 | L15/dossiers | 15 | 15060000156299 | 15060000156299 | 3 | PA736203 | PM736432 |
| 15060000156309 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 1 | PA736235 | PM736426 |
| 15060000156310 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 2 | PA703486 | PM703718 |
| 15060000156311 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 3 | PA267840 | PM736423 |
| 15060000156312 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 4 | PA429890 | PM736393 |
| 15060000156313 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 5 | PA703487 | PM703711 |
| 15060000156314 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 6 | PA736224 | PM736403 |
| 15060000156315 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 7 | PA429895 | PM736262 |
| 15060000156316 | L15/dossiers | 15 | 15060000156308 | 15060000156308 | 8 | PA703495 | PM703708 |
| 15060000156323 | L15/dossiers | 15 | 15060000156322 | 15060000156322 | 1 | PA313924 | PM703546 |
| 15060000156330 | L15/dossiers | 15 | 15060000156329 | 15060000156329 | 1 | PA267328 | PM703547 |
| 15060000156337 | L15/dossiers | 15 | 15060000156336 | 15060000156336 | 1 | PA944 | PM703562 |
| 15060000156344 | L15/dossiers | 15 | 15060000156343 | 15060000156343 | 1 | PA736218 | PM736257 |