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 |
|---|---|---|---|---|---|---|---|
| 15060000176244 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 7 | PA642756 | PM775779 |
| 15060000176245 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 8 | PA2074 | PM775677 |
| 15060000176246 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 9 | PA2774 | PM736307 |
| 15060000176247 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 10 | PA429889 | PM736313 |
| 15060000176248 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 11 | PA429889 | PM736313 |
| 15060000176249 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 12 | PA429852 | PM736275 |
| 15060000176250 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 13 | PA429855 | PM736425 |
| 15060000176251 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 14 | PA736219 | PM736387 |
| 15060000176252 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 15 | PA429888 | PM736379 |
| 15060000176253 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 16 | PA415488 | PM775641 |
| 15060000176254 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 17 | PA590034 | PM775606 |
| 15060000176255 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 18 | PA775210 | PM775492 |
| 15060000176256 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 19 | PA732419 | PM775647 |
| 15060000176257 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 20 | PA732419 | PM775647 |
| 15060000176258 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 21 | PA736191 | PM736336 |
| 15060000176259 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 22 | PA736187 | PM736365 |
| 15060000176260 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 23 | PA736241 | PM736300 |
| 15060000176261 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 24 | PA703509 | PM775687 |
| 15060000176262 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 25 | PA703536 | PM775719 |
| 15060000176263 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 26 | PA342564 | PM736388 |
| 15060000176264 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 27 | PA429844 | PM736276 |
| 15060000176265 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 28 | PA703512 | PM775665 |
| 15060000176266 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 29 | PA643211 | PM775749 |
| 15060000176267 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 30 | PA775268 | PM775574 |
| 15060000176268 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 31 | PA703505 | PM775679 |
| 15060000176269 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 32 | PA775274 | PM775560 |
| 15060000176270 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 33 | PA703511 | PM775685 |
| 15060000176271 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 34 | PA775290 | PM775576 |
| 15060000176272 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 35 | PA736214 | PM736290 |
| 15060000176273 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 36 | PA227096 | PM736342 |
| 15060000176274 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 37 | PA227096 | PM736342 |
| 15060000176275 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 38 | PA736162 | PM736320 |
| 15060000176285 | L15/dossiers | 15 | 15060000176284 | 15060000176284 | 1 | PA775192 | PM775478 |
| 15060000176292 | L15/dossiers | 15 | 15060000176291 | 15060000176291 | 1 | PA773441 | PM773491 |
| 15060000176321 | L15/dossiers | 15 | 15060000176320 | 15060000176320 | 1 | PA2116 | PM736339 |
| 15060000176328 | L15/dossiers | 15 | 15060000176327 | 15060000176327 | 1 | PA773441 | PM773491 |
| 15060000176341 | L15/dossiers | 15 | 15060000176340 | 15060000176340 | 1 | PA774954 | PM774972 |
| 15060000176351 | L15/dossiers | 15 | 15060000176350 | 15060000176350 | 1 | PA736207 | PM736391 |
| 15060000176352 | L15/dossiers | 15 | 15060000176350 | 15060000176350 | 2 | PA703495 | PM775653 |
| 15060000176353 | L15/dossiers | 15 | 15060000176350 | 15060000176350 | 3 | PA425322 | PM736282 |
| 15060000176354 | L15/dossiers | 15 | 15060000176350 | 15060000176350 | 4 | PA303997 | PM775743 |
| 15060000176355 | L15/dossiers | 15 | 15060000176350 | 15060000176350 | 5 | PA429858 | PM736268 |
| 15060000176356 | L15/dossiers | 15 | 15060000176350 | 15060000176350 | 6 | PA2538 | PM775801 |
| 15060000176357 | L15/dossiers | 15 | 15060000176350 | 15060000176350 | 7 | PA736235 | PM775795 |
| 15060000176376 | L15/dossiers | 15 | 15060000176375 | 15060000176375 | 1 | PA703485 | PM775811 |
| 15060000176383 | L15/dossiers | 15 | 15060000176382 | 15060000176382 | 1 | PA227098 | PM736321 |
| 15060000176384 | L15/dossiers | 15 | 15060000176382 | 15060000176382 | 2 | PA425322 | PM736282 |
| 15060000176385 | L15/dossiers | 15 | 15060000176382 | 15060000176382 | 3 | PA429851 | PM736305 |
| 15060000176386 | L15/dossiers | 15 | 15060000176382 | 15060000176382 | 4 | PA2197 | PM775755 |
| 15060000176393 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 1 | PA1978 | PM736337 |