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 |
|---|---|---|---|---|---|---|---|
| 14060000133778 | L14/dossiers | 14 | 14060000133777 | 14060000133777 | 1 | PA331582 | PM645198 |
| 14060000133785 | L14/dossiers | 14 | 14060000133784 | 14060000133784 | 1 | PA267622 | PM702957 |
| 14060000133847 | L14/dossiers | 14 | 14060000133846 | 14060000133846 | 1 | PA1695 | PM645157 |
| 14060000133859 | L14/dossiers | 14 | 14060000133858 | 14060000133858 | 1 | PA609726 | PM645311 |
| 14060000133866 | L14/dossiers | 14 | 14060000133865 | 14060000133865 | 1 | PA267622 | PM702957 |
| 14060000133867 | L14/dossiers | 14 | 14060000133865 | 14060000133865 | 2 | PA2650 | PM702973 |
| 14060000133919 | L14/dossiers | 14 | 14060000133918 | 14060000133918 | 1 | PA1886 | PM645099 |
| 14060000133941 | L14/dossiers | 14 | 14060000133940 | 14060000133940 | 1 | PA1699 | PM645390 |
| 14060000133957 | L14/dossiers | 14 | 14060000133956 | 14060000133956 | 1 | PA609764 | PM645323 |
| 14060000133964 | L14/dossiers | 14 | 14060000133963 | 14060000133963 | 1 | PA1931 | PM645042 |
| 14060000133968 | L14/dossiers | 14 | 14060000133967 | 14060000133967 | 1 | PA267735 | PM645237 |
| 14060000133984 | L14/dossiers | 14 | 14060000133983 | 14060000133983 | 1 | PA785 | PM715797 |
| 14060000133994 | L14/dossiers | 14 | 14060000133993 | 14060000133993 | 1 | PA1886 | PM645099 |
| 14060000133998 | L14/dossiers | 14 | 14060000133997 | 14060000133997 | 1 | PA785 | PM715797 |
| 14060000134011 | L14/dossiers | 14 | 14060000134010 | 14060000134010 | 1 | PA267075 | PM645258 |
| 14060000134018 | L14/dossiers | 14 | 14060000134017 | 14060000134017 | 1 | PA687214 | PM687217 |
| 14060000134025 | L14/dossiers | 14 | 14060000134024 | 14060000134024 | 1 | PA267622 | PM702957 |
| 14060000134076 | L14/dossiers | 14 | 14060000134075 | 14060000134075 | 1 | PA1886 | PM645099 |
| 14060000134108 | L14/dossiers | 14 | 14060000134107 | 14060000134107 | 1 | PA606478 | PM645457 |
| 14060000134115 | L14/dossiers | 14 | 14060000134114 | 14060000134114 | 1 | PA606888 | PM645543 |
| 14060000134122 | L14/dossiers | 14 | 14060000134121 | 14060000134121 | 1 | PA267492 | PM645465 |
| 14060000134129 | L14/dossiers | 14 | 14060000134128 | 14060000134128 | 1 | PA415460 | PM703657 |
| 14060000134161 | L14/dossiers | 14 | 14060000134160 | 14060000134160 | 1 | PA267622 | PM702957 |
| 14060000134162 | L14/dossiers | 14 | 14060000134160 | 14060000134160 | 2 | PA2650 | PM711559 |
| 14060000134170 | L14/dossiers | 14 | 14060000134169 | 14060000134169 | 1 | PA267622 | PM702957 |
| 14060000134171 | L14/dossiers | 14 | 14060000134169 | 14060000134169 | 2 | PA1872 | PM702970 |
| 14060000134178 | L14/dossiers | 14 | 14060000134177 | 14060000134177 | 1 | PA608120 | PM645159 |
| 14060000134185 | L14/dossiers | 14 | 14060000134184 | 14060000134184 | 1 | PA695100 | PM695111 |
| 14060000134192 | L14/dossiers | 14 | 14060000134191 | 14060000134191 | 1 | PA2713 | PM645148 |
| 14060000134199 | L14/dossiers | 14 | 14060000134198 | 14060000134198 | 1 | PA2664 | PM645139 |
| 14060000134206 | L14/dossiers | 14 | 14060000134205 | 14060000134205 | 1 | PA610427 | PM645158 |
| 14060000134210 | L14/dossiers | 14 | 14060000134209 | 14060000134209 | 1 | PA267178 | PM645473 |
| 14060000134220 | L14/dossiers | 14 | 14060000134219 | 14060000134219 | 1 | PA643069 | PM701218 |
| 14060000134230 | L14/dossiers | 14 | 14060000134229 | 14060000134229 | 1 | PA267492 | PM645465 |
| 14060000134240 | L14/dossiers | 14 | 14060000134239 | 14060000134239 | 1 | PA267622 | PM700712 |
| 14060000134241 | L14/dossiers | 14 | 14060000134239 | 14060000134239 | 2 | PA785 | PM700742 |
| 14060000134348 | L14/dossiers | 14 | 14060000134347 | 14060000134347 | 1 | PA267551 | PM645372 |
| 14060000134358 | L14/dossiers | 14 | 14060000134357 | 14060000134357 | 1 | PA331146 | PM645306 |
| 14060000134365 | L14/dossiers | 14 | 14060000134364 | 14060000134364 | 1 | PA267469 | PM645314 |
| 14060000134372 | L14/dossiers | 14 | 14060000134371 | 14060000134371 | 1 | PA2952 | PM645464 |
| 14060000134379 | L14/dossiers | 14 | 14060000134378 | 14060000134378 | 1 | PA563 | PM645307 |
| 14060000134389 | L14/dossiers | 14 | 14060000134388 | 14060000134388 | 1 | PA785 | PM715797 |
| 14060000134390 | L14/dossiers | 14 | 14060000134388 | 14060000134388 | 2 | PA2650 | PM715803 |
| 14060000134398 | L14/dossiers | 14 | 14060000134397 | 14060000134397 | 1 | PA267794 | PM645442 |
| 14060000134405 | L14/dossiers | 14 | 14060000134404 | 14060000134404 | 1 | PA267622 | PM702957 |
| 14060000134406 | L14/dossiers | 14 | 14060000134404 | 14060000134404 | 2 | PA2825 | PM702962 |
| 14060000134413 | L14/dossiers | 14 | 14060000134412 | 14060000134412 | 1 | PA267317 | PM645623 |
| 14060000134420 | L14/dossiers | 14 | 14060000134419 | 14060000134419 | 1 | PA267358 | PM645602 |
| 14060000134427 | L14/dossiers | 14 | 14060000134426 | 14060000134426 | 1 | PA267457 | PM687216 |
| 14060000134436 | L14/dossiers | 14 | 14060000134435 | 14060000134435 | 1 | PA334149 | PM645127 |