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 |
|---|---|---|---|---|---|---|---|
| 14060000119227 | L14/dossiers | 14 | 14060000119226 | 14060000119226 | 1 | PA606212 | PM645330 |
| 14060000119234 | L14/dossiers | 14 | 14060000119233 | 14060000119233 | 1 | PA267306 | PM645210 |
| 14060000119249 | L14/dossiers | 14 | 14060000119248 | 14060000119248 | 1 | PA267622 | PM700712 |
| 14060000119250 | L14/dossiers | 14 | 14060000119248 | 14060000119248 | 2 | PA415496 | PM700736 |
| 14060000119251 | L14/dossiers | 14 | 14060000119248 | 14060000119248 | 3 | PA1243 | PM700871 |
| 14060000119338 | L14/dossiers | 14 | 14060000119337 | 14060000119337 | 1 | PA267429 | PM645130 |
| 14060000119345 | L14/dossiers | 14 | 14060000119344 | 14060000119344 | 1 | PA1466 | PM645240 |
| 14060000119352 | L14/dossiers | 14 | 14060000119351 | 14060000119351 | 1 | PA267743 | PM645058 |
| 14060000119359 | L14/dossiers | 14 | 14060000119358 | 14060000119358 | 1 | PA1886 | PM645099 |
| 14060000119387 | L14/dossiers | 14 | 14060000119386 | 14060000119386 | 1 | PA1654 | PM703255 |
| 14060000119388 | L14/dossiers | 14 | 14060000119386 | 14060000119386 | 2 | PA2791 | PM653325 |
| 14060000119399 | L14/dossiers | 14 | 14060000119398 | 14060000119398 | 1 | PA737 | PM703646 |
| 14060000119418 | L14/dossiers | 14 | 14060000119417 | 14060000119417 | 1 | PA606745 | PM645560 |
| 14060000119419 | L14/dossiers | 14 | 14060000119417 | 14060000119417 | 2 | PA1790 | PM645324 |
| 14060000119429 | L14/dossiers | 14 | 14060000119428 | 14060000119428 | 1 | PA267151 | PM645165 |
| 14060000119436 | L14/dossiers | 14 | 14060000119435 | 14060000119435 | 1 | PA606098 | PM645171 |
| 14060000119443 | L14/dossiers | 14 | 14060000119442 | 14060000119442 | 1 | PA267492 | PM645465 |
| 14060000119450 | L14/dossiers | 14 | 14060000119449 | 14060000119449 | 1 | PA267622 | PM700712 |
| 14060000119451 | L14/dossiers | 14 | 14060000119449 | 14060000119449 | 2 | PA2224 | PM700729 |
| 14060000119458 | L14/dossiers | 14 | 14060000119457 | 14060000119457 | 1 | PA785 | PM715797 |
| 14060000119459 | L14/dossiers | 14 | 14060000119457 | 14060000119457 | 2 | PA1886 | PM715827 |
| 14060000119490 | L14/dossiers | 14 | 14060000119489 | 14060000119489 | 1 | PA267622 | PM702957 |
| 14060000119491 | L14/dossiers | 14 | 14060000119489 | 14060000119489 | 2 | PA2650 | PM711559 |
| 14060000119543 | L14/dossiers | 14 | 14060000119542 | 14060000119542 | 1 | PA2828 | PM645402 |
| 14060000119638 | L14/dossiers | 14 | 14060000119637 | 14060000119637 | 1 | PA606478 | PM645457 |
| 14060000119645 | L14/dossiers | 14 | 14060000119644 | 14060000119644 | 1 | PA2713 | PM645148 |
| 14060000119652 | L14/dossiers | 14 | 14060000119651 | 14060000119651 | 1 | PA268019 | PM645116 |
| 14060000119659 | L14/dossiers | 14 | 14060000119658 | 14060000119658 | 1 | PA328 | PM653228 |
| 14060000119666 | L14/dossiers | 14 | 14060000119665 | 14060000119665 | 1 | PA785 | PM715797 |
| 14060000119673 | L14/dossiers | 14 | 14060000119672 | 14060000119672 | 1 | PA1871 | PM645374 |
| 14060000119681 | L14/dossiers | 14 | 14060000119680 | 14060000119680 | 1 | PA2775 | PM645461 |
| 14060000119688 | L14/dossiers | 14 | 14060000119687 | 14060000119687 | 1 | PA1012 | PM645168 |
| 14060000119695 | L14/dossiers | 14 | 14060000119694 | 14060000119694 | 1 | PA267622 | PM702957 |
| 14060000119726 | L14/dossiers | 14 | 14060000119725 | 14060000119725 | 1 | PA267622 | PM702957 |
| 14060000119727 | L14/dossiers | 14 | 14060000119725 | 14060000119725 | 2 | PA702992 | PM702994 |
| 14060000119734 | L14/dossiers | 14 | 14060000119733 | 14060000119733 | 1 | PA303996 | PM703614 |
| 14060000119753 | L14/dossiers | 14 | 14060000119752 | 14060000119752 | 1 | PA346886 | PM695110 |
| 14060000119757 | L14/dossiers | 14 | 14060000119756 | 14060000119756 | 1 | PA606478 | PM645457 |
| 14060000119764 | L14/dossiers | 14 | 14060000119763 | 14060000119763 | 1 | PA608662 | PM645592 |
| 14060000119774 | L14/dossiers | 14 | 14060000119773 | 14060000119773 | 1 | PA1874 | PM645474 |
| 14060000119784 | L14/dossiers | 14 | 14060000119783 | 14060000119783 | 1 | PA1206 | PM645054 |
| 14060000119791 | L14/dossiers | 14 | 14060000119790 | 14060000119790 | 1 | PA267622 | PM700712 |
| 14060000119925 | L14/dossiers | 14 | 14060000119924 | 14060000119924 | 1 | PA328 | PM653228 |
| 14060000119926 | L14/dossiers | 14 | 14060000119924 | 14060000119924 | 2 | PA1268 | PM653525 |
| 14060000119957 | L14/dossiers | 14 | 14060000119956 | 14060000119956 | 1 | PA230 | PM645553 |
| 14060000119964 | L14/dossiers | 14 | 14060000119963 | 14060000119963 | 1 | PA605349 | PM645483 |
| 14060000119971 | L14/dossiers | 14 | 14060000119970 | 14060000119970 | 1 | PA605694 | PM645416 |
| 14060000119978 | L14/dossiers | 14 | 14060000119977 | 14060000119977 | 1 | PA267459 | PM645564 |
| 14060000119982 | L14/dossiers | 14 | 14060000119981 | 14060000119981 | 1 | PA267673 | PM645249 |
| 14060000119989 | L14/dossiers | 14 | 14060000119988 | 14060000119988 | 1 | PA267622 | PM700712 |