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 |
|---|---|---|---|---|---|---|---|
| 15060000170407 | L15/dossiers | 15 | 15060000170406 | 15060000170406 | 1 | PA720066 | PM722848 |
| 15060000170491 | L15/dossiers | 15 | 15060000170490 | 15060000170490 | 1 | PA343988 | PM736310 |
| 15060000170498 | L15/dossiers | 15 | 15060000170497 | 15060000170497 | 1 | PA773441 | PM773491 |
| 15060000170505 | L15/dossiers | 15 | 15060000170504 | 15060000170504 | 1 | PA773441 | PM773491 |
| 15060000170512 | L15/dossiers | 15 | 15060000170511 | 15060000170511 | 1 | PA429869 | PM736350 |
| 15060000170513 | L15/dossiers | 15 | 15060000170511 | 15060000170511 | 2 | PA227089 | PM736372 |
| 15060000170544 | L15/dossiers | 15 | 15060000170543 | 15060000170543 | 1 | PA712014 | PM722984 |
| 15060000170553 | L15/dossiers | 15 | 15060000170552 | 15060000170552 | 1 | PA720500 | PM722982 |
| 15060000170561 | L15/dossiers | 15 | 15060000170560 | 15060000170560 | 1 | PA720214 | PM722894 |
| 15060000170569 | L15/dossiers | 15 | 15060000170568 | 15060000170568 | 1 | PA2116 | PM736339 |
| 15060000170576 | L15/dossiers | 15 | 15060000170575 | 15060000170575 | 1 | PA2150 | PM722506 |
| 15060000170591 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 1 | PA775276 | PM775566 |
| 15060000170592 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 2 | PA703527 | PM775709 |
| 15060000170593 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 3 | PA736172 | PM736415 |
| 15060000170594 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 4 | PA775298 | PM775594 |
| 15060000170595 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 5 | PA716 | PM736261 |
| 15060000170596 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 6 | PA703503 | PM775639 |
| 15060000170597 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 7 | PA775284 | PM775590 |
| 15060000170598 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 8 | PA703494 | PM775651 |
| 15060000170599 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 9 | PA736218 | PM736257 |
| 15060000170600 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 10 | PA736231 | PM736381 |
| 15060000170601 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 11 | PA715322 | PM775713 |
| 15060000170602 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 12 | PA1344 | PM736383 |
| 15060000170603 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 13 | PA415451 | PM775787 |
| 15060000170604 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 14 | PA744079 | PM744082 |
| 15060000170605 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 15 | PA736202 | PM775775 |
| 15060000170606 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 16 | PA736186 | PM736396 |
| 15060000170607 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 17 | PA773891 | PM773895 |
| 15060000170608 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 18 | PA415462 | PM775797 |
| 15060000170609 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 19 | PA415447 | PM775785 |
| 15060000170610 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 20 | PA429851 | PM736305 |
| 15060000170611 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 21 | PA415467 | PM775803 |
| 15060000170612 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 22 | PA720634 | PM736312 |
| 15060000170613 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 23 | PA429870 | PM736309 |
| 15060000170614 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 24 | PA703541 | PM775725 |
| 15060000170615 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 25 | PA267340 | PM775731 |
| 15060000170616 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 26 | PA415486 | PM775813 |
| 15060000170617 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 27 | PA715745 | PM736297 |
| 15060000170618 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 28 | PA425322 | PM736282 |
| 15060000170619 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 29 | PA703539 | PM703693 |
| 15060000170620 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 30 | PA736216 | PM736273 |
| 15060000170621 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 31 | PA343988 | PM736310 |
| 15060000170622 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 32 | PA736239 | PM736317 |
| 15060000170623 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 33 | PA342665 | PM736382 |
| 15060000170624 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 34 | PA267081 | PM775733 |
| 15060000170625 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 35 | PA736213 | PM775791 |
| 15060000170626 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 36 | PA703537 | PM775721 |
| 15060000170627 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 37 | PA757678 | PM757684 |
| 15060000170628 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 38 | PA703500 | PM775643 |
| 15060000170629 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 39 | PA736192 | PM736353 |