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 |
|---|---|---|---|---|---|---|---|
| 14060000128879 | L14/dossiers | 14 | 14060000128878 | 14060000128878 | 1 | PA608416 | PM645586 |
| 14060000128886 | L14/dossiers | 14 | 14060000128885 | 14060000128885 | 1 | PA267358 | PM645602 |
| 14060000128893 | L14/dossiers | 14 | 14060000128892 | 14060000128892 | 1 | PA1886 | PM645099 |
| 14060000128928 | L14/dossiers | 14 | 14060000128927 | 14060000128927 | 1 | PA266788 | PM645294 |
| 14060000128935 | L14/dossiers | 14 | 14060000128934 | 14060000128934 | 1 | PA1874 | PM645474 |
| 14060000128942 | L14/dossiers | 14 | 14060000128941 | 14060000128941 | 1 | PA1886 | PM645099 |
| 14060000129007 | L14/dossiers | 14 | 14060000129006 | 14060000129006 | 1 | PA328 | PM653228 |
| 14060000129008 | L14/dossiers | 14 | 14060000129006 | 14060000129006 | 2 | PA267278 | PM695770 |
| 14060000129009 | L14/dossiers | 14 | 14060000129006 | 14060000129006 | 3 | PA334160 | PM695773 |
| 14060000129086 | L14/dossiers | 14 | 14060000129085 | 14060000129085 | 1 | PA303997 | PM703603 |
| 14060000129117 | L14/dossiers | 14 | 14060000129116 | 14060000129116 | 1 | PA1886 | PM645099 |
| 14060000129138 | L14/dossiers | 14 | 14060000129137 | 14060000129137 | 1 | PA1886 | PM645099 |
| 14060000129147 | L14/dossiers | 14 | 14060000129146 | 14060000129146 | 1 | PA333134 | PM645341 |
| 14060000129154 | L14/dossiers | 14 | 14060000129153 | 14060000129153 | 1 | PA333421 | PM645375 |
| 14060000129161 | L14/dossiers | 14 | 14060000129160 | 14060000129160 | 1 | PA1886 | PM645099 |
| 14060000129168 | L14/dossiers | 14 | 14060000129167 | 14060000129167 | 1 | PA267622 | PM702957 |
| 14060000129191 | L14/dossiers | 14 | 14060000129190 | 14060000129190 | 1 | PA267576 | PM645073 |
| 14060000129206 | L14/dossiers | 14 | 14060000129205 | 14060000129205 | 1 | PA1886 | PM645099 |
| 14060000129207 | L14/dossiers | 14 | 14060000129205 | 14060000129205 | 2 | PA608695 | PM645605 |
| 14060000129228 | L14/dossiers | 14 | 14060000129227 | 14060000129227 | 1 | PA1521 | PM645078 |
| 14060000129235 | L14/dossiers | 14 | 14060000129234 | 14060000129234 | 1 | PA267042 | PM645368 |
| 14060000129255 | L14/dossiers | 14 | 14060000129254 | 14060000129254 | 1 | PA2876 | PM645355 |
| 14060000129262 | L14/dossiers | 14 | 14060000129261 | 14060000129261 | 1 | PA267306 | PM645210 |
| 14060000129269 | L14/dossiers | 14 | 14060000129268 | 14060000129268 | 1 | PA267407 | PM645320 |
| 14060000129283 | L14/dossiers | 14 | 14060000129282 | 14060000129282 | 1 | PA1886 | PM645099 |
| 14060000129293 | L14/dossiers | 14 | 14060000129292 | 14060000129292 | 1 | PA345619 | PM717221 |
| 14060000129351 | L14/dossiers | 14 | 14060000129350 | 14060000129350 | 1 | PA785 | PM715797 |
| 14060000129358 | L14/dossiers | 14 | 14060000129357 | 14060000129357 | 1 | PA610891 | PM645221 |
| 14060000129359 | L14/dossiers | 14 | 14060000129357 | 14060000129357 | 2 | PA332305 | PM645562 |
| 14060000129360 | L14/dossiers | 14 | 14060000129357 | 14060000129357 | 3 | PA608380 | PM645578 |
| 14060000129370 | L14/dossiers | 14 | 14060000129369 | 14060000129369 | 1 | PA328 | PM653228 |
| 14060000129411 | L14/dossiers | 14 | 14060000129410 | 14060000129410 | 1 | PA1699 | PM645390 |
| 14060000129418 | L14/dossiers | 14 | 14060000129417 | 14060000129417 | 1 | PA998 | PM645034 |
| 14060000129436 | L14/dossiers | 14 | 14060000129435 | 14060000129435 | 1 | PA2664 | PM645139 |
| 14060000129443 | L14/dossiers | 14 | 14060000129442 | 14060000129442 | 1 | PA1031 | PM645044 |
| 14060000129450 | L14/dossiers | 14 | 14060000129449 | 14060000129449 | 1 | PA267492 | PM645465 |
| 14060000129457 | L14/dossiers | 14 | 14060000129456 | 14060000129456 | 1 | PA689 | PM645113 |
| 14060000129464 | L14/dossiers | 14 | 14060000129463 | 14060000129463 | 1 | PA328 | PM653228 |
| 14060000129465 | L14/dossiers | 14 | 14060000129463 | 14060000129463 | 2 | PA2240 | PM653295 |
| 14060000129558 | L14/dossiers | 14 | 14060000129557 | 14060000129557 | 1 | PA216574 | PM645629 |
| 14060000129565 | L14/dossiers | 14 | 14060000129564 | 14060000129564 | 1 | PA267457 | PM687216 |
| 14060000129572 | L14/dossiers | 14 | 14060000129571 | 14060000129571 | 1 | PA267457 | PM687216 |
| 14060000129579 | L14/dossiers | 14 | 14060000129578 | 14060000129578 | 1 | PA608186 | PM645202 |
| 14060000129589 | L14/dossiers | 14 | 14060000129588 | 14060000129588 | 1 | PA2048 | PM693013 |
| 14060000129596 | L14/dossiers | 14 | 14060000129595 | 14060000129595 | 1 | PA608380 | PM645578 |
| 14060000129606 | L14/dossiers | 14 | 14060000129605 | 14060000129605 | 1 | PA328 | PM653228 |
| 14060000129607 | L14/dossiers | 14 | 14060000129605 | 14060000129605 | 2 | PA1268 | PM653525 |
| 14060000129638 | L14/dossiers | 14 | 14060000129637 | 14060000129637 | 1 | PA810 | PM645557 |
| 14060000129705 | L14/dossiers | 14 | 14060000129704 | 14060000129704 | 1 | PA2664 | PM645139 |
| 14060000129712 | L14/dossiers | 14 | 14060000129711 | 14060000129711 | 1 | PA328 | PM653228 |