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 |
|---|---|---|---|---|---|---|---|
| 15060000132255 | L15/dossiers | 15 | 15060000132254 | 15060000132254 | 1 | PA266788 | PM722914 |
| 15060000132262 | L15/dossiers | 15 | 15060000132261 | 15060000132261 | 1 | PA721418 | PM723268 |
| 15060000132269 | L15/dossiers | 15 | 15060000132268 | 15060000132268 | 1 | PA267260 | PM722476 |
| 15060000132276 | L15/dossiers | 15 | 15060000132275 | 15060000132275 | 1 | PA712014 | PM722984 |
| 15060000132283 | L15/dossiers | 15 | 15060000132282 | 15060000132282 | 1 | PA330240 | PM722492 |
| 15060000132290 | L15/dossiers | 15 | 15060000132289 | 15060000132289 | 1 | PA608826 | PM723276 |
| 15060000132297 | L15/dossiers | 15 | 15060000132296 | 15060000132296 | 1 | PA608826 | PM723276 |
| 15060000132304 | L15/dossiers | 15 | 15060000132303 | 15060000132303 | 1 | PA720468 | PM722972 |
| 15060000132311 | L15/dossiers | 15 | 15060000132310 | 15060000132310 | 1 | PA330684 | PM722528 |
| 15060000132318 | L15/dossiers | 15 | 15060000132317 | 15060000132317 | 1 | PA2952 | PM722480 |
| 15060000132325 | L15/dossiers | 15 | 15060000132324 | 15060000132324 | 1 | PA767 | PM723568 |
| 15060000132326 | L15/dossiers | 15 | 15060000132324 | 15060000132324 | 2 | PA267355 | PM723524 |
| 15060000132327 | L15/dossiers | 15 | 15060000132324 | 15060000132324 | 3 | PA2377 | PM723550 |
| 15060000132328 | L15/dossiers | 15 | 15060000132324 | 15060000132324 | 4 | PA642868 | PM722992 |
| 15060000132335 | L15/dossiers | 15 | 15060000132334 | 15060000132334 | 1 | PA605694 | PM722558 |
| 15060000132351 | L15/dossiers | 15 | 15060000132350 | 15060000132350 | 1 | PA643134 | PM722824 |
| 15060000132358 | L15/dossiers | 15 | 15060000132357 | 15060000132357 | 1 | PA330240 | PM722492 |
| 15060000132365 | L15/dossiers | 15 | 15060000132364 | 15060000132364 | 1 | PA267785 | PM723310 |
| 15060000132372 | L15/dossiers | 15 | 15060000132371 | 15060000132371 | 1 | PA605991 | PM722660 |
| 15060000132380 | L15/dossiers | 15 | 15060000132379 | 15060000132379 | 1 | PA721314 | PM723236 |
| 15060000132387 | L15/dossiers | 15 | 15060000132386 | 15060000132386 | 1 | PA345619 | PM725692 |
| 15060000132388 | L15/dossiers | 15 | 15060000132386 | 15060000132386 | 2 | PA607846 | PM730066 |
| 15060000132395 | L15/dossiers | 15 | 15060000132394 | 15060000132394 | 1 | PA720692 | PM723042 |
| 15060000132402 | L15/dossiers | 15 | 15060000132401 | 15060000132401 | 1 | PA267673 | PM723306 |
| 15060000132409 | L15/dossiers | 15 | 15060000132408 | 15060000132408 | 1 | PA267260 | PM722476 |
| 15060000132416 | L15/dossiers | 15 | 15060000132415 | 15060000132415 | 1 | PA2150 | PM722506 |
| 15060000132423 | L15/dossiers | 15 | 15060000132422 | 15060000132422 | 1 | PA429858 | PM429958 |
| 15060000132443 | L15/dossiers | 15 | 15060000132442 | 15060000132442 | 1 | PA429858 | PM429958 |
| 15060000132466 | L15/dossiers | 15 | 15060000132465 | 15060000132465 | 1 | PA345619 | PM725692 |
| 15060000132473 | L15/dossiers | 15 | 15060000132472 | 15060000132472 | 1 | PA712015 | PM722448 |
| 15060000132480 | L15/dossiers | 15 | 15060000132479 | 15060000132479 | 1 | PA267260 | PM722476 |
| 15060000132487 | L15/dossiers | 15 | 15060000132486 | 15060000132486 | 1 | PA608826 | PM723276 |
| 15060000132494 | L15/dossiers | 15 | 15060000132493 | 15060000132493 | 1 | PA721506 | PM723296 |
| 15060000132501 | L15/dossiers | 15 | 15060000132500 | 15060000132500 | 1 | PA709298 | PM709304 |
| 15060000132520 | L15/dossiers | 15 | 15060000132519 | 15060000132519 | 1 | PA267527 | PM723274 |
| 15060000132534 | L15/dossiers | 15 | 15060000132533 | 15060000132533 | 1 | PA345619 | PM725692 |
| 15060000132535 | L15/dossiers | 15 | 15060000132533 | 15060000132533 | 2 | PA607846 | PM730066 |
| 15060000132536 | L15/dossiers | 15 | 15060000132533 | 15060000132533 | 3 | PA717153 | PM730062 |
| 15060000132655 | L15/dossiers | 15 | 15060000132654 | 15060000132654 | 1 | PA345619 | PM725692 |
| 15060000132656 | L15/dossiers | 15 | 15060000132654 | 15060000132654 | 2 | PA1872 | PM730104 |
| 15060000132689 | L15/dossiers | 15 | 15060000132688 | 15060000132688 | 1 | PA345619 | PM725692 |
| 15060000132696 | L15/dossiers | 15 | 15060000132695 | 15060000132695 | 1 | PA1695 | PM723322 |
| 15060000132707 | L15/dossiers | 15 | 15060000132706 | 15060000132706 | 1 | PA267527 | PM723274 |
| 15060000132714 | L15/dossiers | 15 | 15060000132713 | 15060000132713 | 1 | PA709315 | PM722526 |
| 15060000132721 | L15/dossiers | 15 | 15060000132720 | 15060000132720 | 1 | PA346218 | PM723348 |
| 15060000132728 | L15/dossiers | 15 | 15060000132727 | 15060000132727 | 1 | PA346218 | PM723348 |
| 15060000132735 | L15/dossiers | 15 | 15060000132734 | 15060000132734 | 1 | PA331582 | PM722646 |
| 15060000132751 | L15/dossiers | 15 | 15060000132750 | 15060000132750 | 1 | PA718838 | PM722474 |
| 15060000132758 | L15/dossiers | 15 | 15060000132757 | 15060000132757 | 1 | PA721486 | PM723290 |
| 15060000132765 | L15/dossiers | 15 | 15060000132764 | 15060000132764 | 1 | PA718838 | PM722474 |