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 |
|---|---|---|---|---|---|---|---|
| 14060000106847 | L14/dossiers | 14 | 14060000106846 | 14060000106846 | 1 | PA267492 | PM645465 |
| 14060000106854 | L14/dossiers | 14 | 14060000106853 | 14060000106853 | 1 | PA266788 | PM645294 |
| 14060000106861 | L14/dossiers | 14 | 14060000106860 | 14060000106860 | 1 | PA331567 | PM645186 |
| 14060000106868 | L14/dossiers | 14 | 14060000106867 | 14060000106867 | 1 | PA606212 | PM645330 |
| 14060000106875 | L14/dossiers | 14 | 14060000106874 | 14060000106874 | 1 | PA429848 | PM429951 |
| 14060000106904 | L14/dossiers | 14 | 14060000106903 | 14060000106903 | 1 | PA267165 | PM645360 |
| 14060000106911 | L14/dossiers | 14 | 14060000106910 | 14060000106910 | 1 | PA785 | PM715797 |
| 14060000106933 | L14/dossiers | 14 | 14060000106932 | 14060000106932 | 1 | PA267260 | PM645459 |
| 14060000106940 | L14/dossiers | 14 | 14060000106939 | 14060000106939 | 1 | PA266788 | PM645294 |
| 14060000106950 | L14/dossiers | 14 | 14060000106949 | 14060000106949 | 1 | PA1886 | PM645099 |
| 14060000106996 | L14/dossiers | 14 | 14060000106995 | 14060000106995 | 1 | PA328 | PM653228 |
| 14060000106997 | L14/dossiers | 14 | 14060000106995 | 14060000106995 | 2 | PA332364 | PM653307 |
| 14060000107087 | L14/dossiers | 14 | 14060000107086 | 14060000107086 | 1 | PA1699 | PM645390 |
| 14060000107094 | L14/dossiers | 14 | 14060000107093 | 14060000107093 | 1 | PA267622 | PM702957 |
| 14060000107108 | L14/dossiers | 14 | 14060000107107 | 14060000107107 | 1 | PA609709 | PM645302 |
| 14060000107115 | L14/dossiers | 14 | 14060000107114 | 14060000107114 | 1 | PA334149 | PM645127 |
| 14060000107122 | L14/dossiers | 14 | 14060000107121 | 14060000107121 | 1 | PA1886 | PM645099 |
| 14060000107130 | L14/dossiers | 14 | 14060000107129 | 14060000107129 | 1 | PA563 | PM645307 |
| 14060000107137 | L14/dossiers | 14 | 14060000107136 | 14060000107136 | 1 | PA330684 | PM645497 |
| 14060000107147 | L14/dossiers | 14 | 14060000107146 | 14060000107146 | 1 | PA1020 | PM645057 |
| 14060000107154 | L14/dossiers | 14 | 14060000107153 | 14060000107153 | 1 | PA1031 | PM645044 |
| 14060000107161 | L14/dossiers | 14 | 14060000107160 | 14060000107160 | 1 | PA713448 | PM713451 |
| 14060000107168 | L14/dossiers | 14 | 14060000107167 | 14060000107167 | 1 | PA607846 | PM645441 |
| 14060000107178 | L14/dossiers | 14 | 14060000107177 | 14060000107177 | 1 | PA810 | PM645557 |
| 14060000107248 | L14/dossiers | 14 | 14060000107247 | 14060000107247 | 1 | PA1206 | PM645054 |
| 14060000107258 | L14/dossiers | 14 | 14060000107257 | 14060000107257 | 1 | PA2796 | PM645520 |
| 14060000107265 | L14/dossiers | 14 | 14060000107264 | 14060000107264 | 1 | PA267285 | PM645140 |
| 14060000107272 | L14/dossiers | 14 | 14060000107271 | 14060000107271 | 1 | PA330684 | PM645497 |
| 14060000107279 | L14/dossiers | 14 | 14060000107278 | 14060000107278 | 1 | PA330684 | PM645497 |
| 14060000107286 | L14/dossiers | 14 | 14060000107285 | 14060000107285 | 1 | PA2200 | PM429909 |
| 14060000107315 | L14/dossiers | 14 | 14060000107314 | 14060000107314 | 1 | PA346886 | PM695110 |
| 14060000107322 | L14/dossiers | 14 | 14060000107321 | 14060000107321 | 1 | PA328 | PM653228 |
| 14060000107323 | L14/dossiers | 14 | 14060000107321 | 14060000107321 | 2 | PA1268 | PM653525 |
| 14060000107354 | L14/dossiers | 14 | 14060000107353 | 14060000107353 | 1 | PA266797 | PM645338 |
| 14060000107355 | L14/dossiers | 14 | 14060000107353 | 14060000107353 | 2 | PA333134 | PM645341 |
| 14060000107362 | L14/dossiers | 14 | 14060000107361 | 14060000107361 | 1 | PA1020 | PM645057 |
| 14060000107369 | L14/dossiers | 14 | 14060000107368 | 14060000107368 | 1 | PA1874 | PM645474 |
| 14060000107376 | L14/dossiers | 14 | 14060000107375 | 14060000107375 | 1 | PA687214 | PM687217 |
| 14060000107386 | L14/dossiers | 14 | 14060000107385 | 14060000107385 | 1 | PA2099 | PM645101 |
| 14060000107403 | L14/dossiers | 14 | 14060000107402 | 14060000107402 | 1 | PA2876 | PM645355 |
| 14060000107410 | L14/dossiers | 14 | 14060000107409 | 14060000107409 | 1 | PA267622 | PM702957 |
| 14060000107441 | L14/dossiers | 14 | 14060000107440 | 14060000107440 | 1 | PA267622 | PM702957 |
| 14060000107442 | L14/dossiers | 14 | 14060000107440 | 14060000107440 | 2 | PA1268 | PM702961 |
| 14060000107471 | L14/dossiers | 14 | 14060000107470 | 14060000107470 | 1 | PA588 | PM645491 |
| 14060000107479 | L14/dossiers | 14 | 14060000107478 | 14060000107478 | 1 | PA309643 | PM645326 |
| 14060000107486 | L14/dossiers | 14 | 14060000107485 | 14060000107485 | 1 | PA328 | PM653228 |
| 14060000107539 | L14/dossiers | 14 | 14060000107538 | 14060000107538 | 1 | PA1867 | PM415524 |
| 14060000107551 | L14/dossiers | 14 | 14060000107550 | 14060000107550 | 1 | PA2713 | PM645148 |
| 14060000107589 | L14/dossiers | 14 | 14060000107588 | 14060000107588 | 1 | PA2277 | PM645135 |
| 14060000107599 | L14/dossiers | 14 | 14060000107598 | 14060000107598 | 1 | PA267492 | PM645465 |