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 |
|---|---|---|---|---|---|---|---|
| 14060000122847 | L14/dossiers | 14 | 14060000122846 | 14060000122846 | 1 | PA607090 | PM645143 |
| 14060000122854 | L14/dossiers | 14 | 14060000122853 | 14060000122853 | 1 | PA266797 | PM645338 |
| 14060000122861 | L14/dossiers | 14 | 14060000122860 | 14060000122860 | 1 | PA266774 | PM645583 |
| 14060000122868 | L14/dossiers | 14 | 14060000122867 | 14060000122867 | 1 | PA267492 | PM645465 |
| 14060000122875 | L14/dossiers | 14 | 14060000122874 | 14060000122874 | 1 | PA1198 | PM645393 |
| 14060000122883 | L14/dossiers | 14 | 14060000122882 | 14060000122882 | 1 | PA785 | PM715797 |
| 14060000122890 | L14/dossiers | 14 | 14060000122889 | 14060000122889 | 1 | PA330240 | PM645425 |
| 14060000122897 | L14/dossiers | 14 | 14060000122896 | 14060000122896 | 1 | PA309643 | PM645326 |
| 14060000122904 | L14/dossiers | 14 | 14060000122903 | 14060000122903 | 1 | PA605625 | PM645398 |
| 14060000122911 | L14/dossiers | 14 | 14060000122910 | 14060000122910 | 1 | PA2796 | PM645520 |
| 14060000122918 | L14/dossiers | 14 | 14060000122917 | 14060000122917 | 1 | PA346886 | PM695110 |
| 14060000122926 | L14/dossiers | 14 | 14060000122925 | 14060000122925 | 1 | PA266788 | PM645294 |
| 14060000122942 | L14/dossiers | 14 | 14060000122941 | 14060000122941 | 1 | PA266788 | PM645294 |
| 14060000122949 | L14/dossiers | 14 | 14060000122948 | 14060000122948 | 1 | PA2907 | PM645289 |
| 14060000122956 | L14/dossiers | 14 | 14060000122955 | 14060000122955 | 1 | PA267506 | PM645270 |
| 14060000122973 | L14/dossiers | 14 | 14060000122972 | 14060000122972 | 1 | PA606888 | PM645543 |
| 14060000122980 | L14/dossiers | 14 | 14060000122979 | 14060000122979 | 1 | PA609345 | PM645173 |
| 14060000122996 | L14/dossiers | 14 | 14060000122995 | 14060000122995 | 1 | PA328 | PM653228 |
| 14060000122997 | L14/dossiers | 14 | 14060000122995 | 14060000122995 | 2 | PA1268 | PM653525 |
| 14060000123005 | L14/dossiers | 14 | 14060000123004 | 14060000123004 | 1 | PA608495 | PM645569 |
| 14060000123017 | L14/dossiers | 14 | 14060000123016 | 14060000123016 | 1 | PA2971 | PM645392 |
| 14060000123024 | L14/dossiers | 14 | 14060000123023 | 14060000123023 | 1 | PA230 | PM645553 |
| 14060000123031 | L14/dossiers | 14 | 14060000123030 | 14060000123030 | 1 | PA785 | PM715797 |
| 14060000123039 | L14/dossiers | 14 | 14060000123038 | 14060000123038 | 1 | PA346886 | PM695110 |
| 14060000123046 | L14/dossiers | 14 | 14060000123045 | 14060000123045 | 1 | PA609764 | PM645323 |
| 14060000123056 | L14/dossiers | 14 | 14060000123055 | 14060000123055 | 1 | PA785 | PM715797 |
| 14060000123085 | L14/dossiers | 14 | 14060000123084 | 14060000123084 | 1 | PA785 | PM715797 |
| 14060000123092 | L14/dossiers | 14 | 14060000123091 | 14060000123091 | 1 | PA267419 | PM703658 |
| 14060000123165 | L14/dossiers | 14 | 14060000123164 | 14060000123164 | 1 | PA606098 | PM645171 |
| 14060000123175 | L14/dossiers | 14 | 14060000123174 | 14060000123174 | 1 | PA267506 | PM645270 |
| 14060000123182 | L14/dossiers | 14 | 14060000123181 | 14060000123181 | 1 | PA328 | PM653228 |
| 14060000123183 | L14/dossiers | 14 | 14060000123181 | 14060000123181 | 2 | PA267622 | PM653322 |
| 14060000123273 | L14/dossiers | 14 | 14060000123272 | 14060000123272 | 1 | PA689 | PM645113 |
| 14060000123283 | L14/dossiers | 14 | 14060000123282 | 14060000123282 | 1 | PA267762 | PM645455 |
| 14060000123301 | L14/dossiers | 14 | 14060000123300 | 14060000123300 | 1 | PA330684 | PM645497 |
| 14060000123308 | L14/dossiers | 14 | 14060000123307 | 14060000123307 | 1 | PA267622 | PM702957 |
| 14060000123309 | L14/dossiers | 14 | 14060000123307 | 14060000123307 | 2 | PA2051 | PM702986 |
| 14060000123316 | L14/dossiers | 14 | 14060000123315 | 14060000123315 | 1 | PA331567 | PM645186 |
| 14060000123323 | L14/dossiers | 14 | 14060000123322 | 14060000123322 | 1 | PA2011 | PM645434 |
| 14060000123333 | L14/dossiers | 14 | 14060000123332 | 14060000123332 | 1 | PA429894 | PM429941 |
| 14060000123345 | L14/dossiers | 14 | 14060000123344 | 14060000123344 | 1 | PA330684 | PM645497 |
| 14060000123352 | L14/dossiers | 14 | 14060000123351 | 14060000123351 | 1 | PA606212 | PM645330 |
| 14060000123359 | L14/dossiers | 14 | 14060000123358 | 14060000123358 | 1 | PA267200 | PM645502 |
| 14060000123369 | L14/dossiers | 14 | 14060000123368 | 14060000123368 | 1 | PA328 | PM653228 |
| 14060000123437 | L14/dossiers | 14 | 14060000123436 | 14060000123436 | 1 | PA267622 | PM702957 |
| 14060000123468 | L14/dossiers | 14 | 14060000123467 | 14060000123467 | 1 | PA1886 | PM645099 |
| 14060000123552 | L14/dossiers | 14 | 14060000123551 | 14060000123551 | 1 | PA267622 | PM700712 |
| 14060000123553 | L14/dossiers | 14 | 14060000123551 | 14060000123551 | 2 | PA2825 | PM700732 |
| 14060000123560 | L14/dossiers | 14 | 14060000123559 | 14060000123559 | 1 | PA346886 | PM695110 |
| 14060000123567 | L14/dossiers | 14 | 14060000123566 | 14060000123566 | 1 | PA608186 | PM645202 |