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 |
|---|---|---|---|---|---|---|---|
| 14060000095248 | L14/dossiers | 14 | 14060000095247 | 14060000095247 | 1 | PA267680 | PM645427 |
| 14060000095255 | L14/dossiers | 14 | 14060000095254 | 14060000095254 | 1 | PA267622 | PM702957 |
| 14060000095266 | L14/dossiers | 14 | 14060000095265 | 14060000095265 | 1 | PA328 | PM653228 |
| 14060000095267 | L14/dossiers | 14 | 14060000095265 | 14060000095265 | 2 | PA267622 | PM653322 |
| 14060000095301 | L14/dossiers | 14 | 14060000095300 | 14060000095300 | 1 | PA334149 | PM645127 |
| 14060000095310 | L14/dossiers | 14 | 14060000095309 | 14060000095309 | 1 | PA267306 | PM645210 |
| 14060000095314 | L14/dossiers | 14 | 14060000095313 | 14060000095313 | 1 | PA785 | PM715797 |
| 14060000095322 | L14/dossiers | 14 | 14060000095321 | 14060000095321 | 1 | PA267622 | PM702957 |
| 14060000095356 | L14/dossiers | 14 | 14060000095355 | 14060000095355 | 1 | PA1574 | PM645430 |
| 14060000095363 | L14/dossiers | 14 | 14060000095362 | 14060000095362 | 1 | PA332747 | PM645155 |
| 14060000095373 | L14/dossiers | 14 | 14060000095372 | 14060000095372 | 1 | PA1886 | PM645099 |
| 14060000095391 | L14/dossiers | 14 | 14060000095390 | 14060000095390 | 1 | PA328 | PM653228 |
| 14060000095392 | L14/dossiers | 14 | 14060000095390 | 14060000095390 | 2 | PA1268 | PM653525 |
| 14060000095424 | L14/dossiers | 14 | 14060000095423 | 14060000095423 | 1 | PA345937 | PM645177 |
| 14060000095428 | L14/dossiers | 14 | 14060000095427 | 14060000095427 | 1 | PA267605 | PM645189 |
| 14060000095435 | L14/dossiers | 14 | 14060000095434 | 14060000095434 | 1 | PA330684 | PM645497 |
| 14060000095446 | L14/dossiers | 14 | 14060000095445 | 14060000095445 | 1 | PA815 | PM645544 |
| 14060000095453 | L14/dossiers | 14 | 14060000095452 | 14060000095452 | 1 | PA1521 | PM645078 |
| 14060000095463 | L14/dossiers | 14 | 14060000095462 | 14060000095462 | 1 | PA605745 | PM645435 |
| 14060000095470 | L14/dossiers | 14 | 14060000095469 | 14060000095469 | 1 | PA1263 | PM645432 |
| 14060000095477 | L14/dossiers | 14 | 14060000095476 | 14060000095476 | 1 | PA267492 | PM645465 |
| 14060000095484 | L14/dossiers | 14 | 14060000095483 | 14060000095483 | 1 | PA345937 | PM645177 |
| 14060000095491 | L14/dossiers | 14 | 14060000095490 | 14060000095490 | 1 | PA267289 | PM645242 |
| 14060000095498 | L14/dossiers | 14 | 14060000095497 | 14060000095497 | 1 | PA1206 | PM645054 |
| 14060000095508 | L14/dossiers | 14 | 14060000095507 | 14060000095507 | 1 | PA328 | PM653228 |
| 14060000095509 | L14/dossiers | 14 | 14060000095507 | 14060000095507 | 2 | PA267278 | PM695770 |
| 14060000095517 | L14/dossiers | 14 | 14060000095516 | 14060000095516 | 1 | PA606212 | PM645330 |
| 14060000095525 | L14/dossiers | 14 | 14060000095524 | 14060000095524 | 1 | PA267336 | PM645424 |
| 14060000095535 | L14/dossiers | 14 | 14060000095534 | 14060000095534 | 1 | PA330240 | PM645425 |
| 14060000095542 | L14/dossiers | 14 | 14060000095541 | 14060000095541 | 1 | PA268019 | PM645116 |
| 14060000095549 | L14/dossiers | 14 | 14060000095548 | 14060000095548 | 1 | PA267605 | PM645189 |
| 14060000095556 | L14/dossiers | 14 | 14060000095555 | 14060000095555 | 1 | PA713448 | PM713451 |
| 14060000095563 | L14/dossiers | 14 | 14060000095562 | 14060000095562 | 1 | PA2277 | PM645135 |
| 14060000095570 | L14/dossiers | 14 | 14060000095569 | 14060000095569 | 1 | PA608851 | PM645559 |
| 14060000095580 | L14/dossiers | 14 | 14060000095579 | 14060000095579 | 1 | PA267628 | PM645046 |
| 14060000095605 | L14/dossiers | 14 | 14060000095604 | 14060000095604 | 1 | PA608172 | PM645197 |
| 14060000095616 | L14/dossiers | 14 | 14060000095615 | 14060000095615 | 1 | PA610521 | PM645190 |
| 14060000095623 | L14/dossiers | 14 | 14060000095622 | 14060000095622 | 1 | PA606888 | PM645543 |
| 14060000095630 | L14/dossiers | 14 | 14060000095629 | 14060000095629 | 1 | PA2952 | PM645464 |
| 14060000095637 | L14/dossiers | 14 | 14060000095636 | 14060000095636 | 1 | PA551 | PM645487 |
| 14060000095645 | L14/dossiers | 14 | 14060000095644 | 14060000095644 | 1 | PA267506 | PM645270 |
| 14060000095652 | L14/dossiers | 14 | 14060000095651 | 14060000095651 | 1 | PA2971 | PM645392 |
| 14060000095659 | L14/dossiers | 14 | 14060000095658 | 14060000095658 | 1 | PA2971 | PM645392 |
| 14060000095666 | L14/dossiers | 14 | 14060000095665 | 14060000095665 | 1 | PA1699 | PM645390 |
| 14060000095673 | L14/dossiers | 14 | 14060000095672 | 14060000095672 | 1 | PA2098 | PM645351 |
| 14060000095680 | L14/dossiers | 14 | 14060000095679 | 14060000095679 | 1 | PA267605 | PM645189 |
| 14060000095690 | L14/dossiers | 14 | 14060000095689 | 14060000095689 | 1 | PA266788 | PM645294 |
| 14060000095697 | L14/dossiers | 14 | 14060000095696 | 14060000095696 | 1 | PA1263 | PM645432 |
| 14060000095707 | L14/dossiers | 14 | 14060000095706 | 14060000095706 | 1 | PA1886 | PM645099 |
| 14060000095708 | L14/dossiers | 14 | 14060000095706 | 14060000095706 | 2 | PA606623 | PM645513 |