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 |
|---|---|---|---|---|---|---|---|
| 15060000187345 | L15/dossiers | 15 | 15060000187344 | 15060000187344 | 1 | PA2116 | PM736339 |
| 15060000187352 | L15/dossiers | 15 | 15060000187351 | 15060000187351 | 1 | PA721118 | PM723176 |
| 15060000187359 | L15/dossiers | 15 | 15060000187358 | 15060000187358 | 1 | PA721118 | PM723176 |
| 15060000187366 | L15/dossiers | 15 | 15060000187365 | 15060000187365 | 1 | PA773441 | PM773491 |
| 15060000187367 | L15/dossiers | 15 | 15060000187365 | 15060000187365 | 2 | PA607846 | PM773469 |
| 15060000187377 | L15/dossiers | 15 | 15060000187376 | 15060000187376 | 1 | PA719266 | PM722610 |
| 15060000187387 | L15/dossiers | 15 | 15060000187386 | 15060000187386 | 1 | PA719778 | PM722760 |
| 15060000187394 | L15/dossiers | 15 | 15060000187393 | 15060000187393 | 1 | PA605069 | PM722424 |
| 15060000187401 | L15/dossiers | 15 | 15060000187400 | 15060000187400 | 1 | PA720822 | PM723086 |
| 15060000187408 | L15/dossiers | 15 | 15060000187407 | 15060000187407 | 1 | PA720684 | PM723040 |
| 15060000187415 | L15/dossiers | 15 | 15060000187414 | 15060000187414 | 1 | PA1874 | PM722598 |
| 15060000187422 | L15/dossiers | 15 | 15060000187421 | 15060000187421 | 1 | PA718780 | PM722454 |
| 15060000187429 | L15/dossiers | 15 | 15060000187428 | 15060000187428 | 1 | PA415447 | PM775785 |
| 15060000187436 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 1 | PA775202 | PM775502 |
| 15060000187437 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 2 | PA205280 | PM736412 |
| 15060000187438 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 3 | PA267081 | PM775733 |
| 15060000187439 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 4 | PA703532 | PM775699 |
| 15060000187440 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 5 | PA429858 | PM736268 |
| 15060000187441 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 6 | PA1993 | PM736402 |
| 15060000187442 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 7 | PA1001 | PM736371 |
| 15060000187443 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 8 | PA429870 | PM736309 |
| 15060000187444 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 9 | PA703537 | PM775721 |
| 15060000187445 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 10 | PA775178 | PM775460 |
| 15060000187446 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 11 | PA736184 | PM736272 |
| 15060000187447 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 12 | PA775240 | PM775530 |
| 15060000187448 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 13 | PA415486 | PM775813 |
| 15060000187449 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 14 | PA736237 | PM736417 |
| 15060000187450 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 15 | PA778908 | PM778928 |
| 15060000187451 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 16 | PA343775 | PM736367 |
| 15060000187452 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 17 | PA715322 | PM775713 |
| 15060000187453 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 18 | PA775192 | PM775478 |
| 15060000187454 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 19 | PA736207 | PM736391 |
| 15060000187455 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 20 | PA342665 | PM736382 |
| 15060000187456 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 21 | PA775184 | PM775486 |
| 15060000187457 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 22 | PA757678 | PM757684 |
| 15060000187458 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 23 | PA341381 | PM775747 |
| 15060000187459 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 24 | PA720634 | PM736312 |
| 15060000187460 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 25 | PA736194 | PM736291 |
| 15060000187461 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 26 | PA736200 | PM736285 |
| 15060000187462 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 27 | PA429874 | PM736314 |
| 15060000187463 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 28 | PA343988 | PM736310 |
| 15060000187464 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 29 | PA703500 | PM775643 |
| 15060000187465 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 30 | PA1122 | PM736304 |
| 15060000187466 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 31 | PA736218 | PM736257 |
| 15060000187467 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 32 | PA736247 | PM736281 |
| 15060000187468 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 33 | PA775302 | PM775598 |
| 15060000187469 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 34 | PA429851 | PM736305 |
| 15060000187470 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 35 | PA415451 | PM775787 |
| 15060000187471 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 36 | PA1344 | PM736383 |
| 15060000187472 | L15/dossiers | 15 | 15060000187435 | 15060000187435 | 37 | PA775288 | PM775578 |