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 |
|---|---|---|---|---|---|---|---|
| 15060000169958 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 11 | PA736230 | PM736377 |
| 15060000169959 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 12 | PA415467 | PM775803 |
| 15060000169960 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 13 | PA775250 | PM775552 |
| 15060000169961 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 14 | PA341381 | PM775747 |
| 15060000169962 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 15 | PA736226 | PM736280 |
| 15060000169963 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 16 | PA767418 | PM775767 |
| 15060000169964 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 17 | PA736204 | PM736338 |
| 15060000169965 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 18 | PA736184 | PM736272 |
| 15060000169966 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 19 | PA736166 | PM775765 |
| 15060000169967 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 20 | PA736167 | PM736327 |
| 15060000169968 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 21 | PA747420 | PM775761 |
| 15060000169975 | L15/dossiers | 15 | 15060000169974 | 15060000169974 | 1 | PA608172 | PM723048 |
| 15060000169979 | L15/dossiers | 15 | 15060000169978 | 15060000169978 | 1 | PA773441 | PM773491 |
| 15060000169980 | L15/dossiers | 15 | 15060000169978 | 15060000169978 | 2 | PA331481 | PM773459 |
| 15060000169987 | L15/dossiers | 15 | 15060000169986 | 15060000169986 | 1 | PA429858 | PM736268 |
| 15060000169994 | L15/dossiers | 15 | 15060000169993 | 15060000169993 | 1 | PA341381 | PM775747 |
| 15060000170001 | L15/dossiers | 15 | 15060000170000 | 15060000170000 | 1 | PA773441 | PM773491 |
| 15060000170011 | L15/dossiers | 15 | 15060000170010 | 15060000170010 | 1 | PA703513 | PM775671 |
| 15060000170012 | L15/dossiers | 15 | 15060000170010 | 15060000170010 | 2 | PA607489 | PM736390 |
| 15060000170013 | L15/dossiers | 15 | 15060000170010 | 15060000170010 | 3 | PA736248 | PM736269 |
| 15060000170014 | L15/dossiers | 15 | 15060000170010 | 15060000170010 | 4 | PA415446 | PM775783 |
| 15060000170066 | L15/dossiers | 15 | 15060000170065 | 15060000170065 | 1 | PA643089 | PM758076 |
| 15060000170073 | L15/dossiers | 15 | 15060000170072 | 15060000170072 | 1 | PA643089 | PM758076 |
| 15060000170080 | L15/dossiers | 15 | 15060000170079 | 15060000170079 | 1 | PA330240 | PM722492 |
| 15060000170087 | L15/dossiers | 15 | 15060000170086 | 15060000170086 | 1 | PA712015 | PM722448 |
| 15060000170094 | L15/dossiers | 15 | 15060000170093 | 15060000170093 | 1 | PA405480 | PM723118 |
| 15060000170098 | L15/dossiers | 15 | 15060000170097 | 15060000170097 | 1 | PA606098 | PM722642 |
| 15060000170105 | L15/dossiers | 15 | 15060000170104 | 15060000170104 | 1 | PA720568 | PM723002 |
| 15060000170122 | L15/dossiers | 15 | 15060000170121 | 15060000170121 | 1 | PA605036 | PM722444 |
| 15060000170129 | L15/dossiers | 15 | 15060000170128 | 15060000170128 | 1 | PA605036 | PM722444 |
| 15060000170136 | L15/dossiers | 15 | 15060000170135 | 15060000170135 | 1 | PA267794 | PM722468 |
| 15060000170143 | L15/dossiers | 15 | 15060000170142 | 15060000170142 | 1 | PA342601 | PM761932 |
| 15060000170150 | L15/dossiers | 15 | 15060000170149 | 15060000170149 | 1 | PA330240 | PM722492 |
| 15060000170157 | L15/dossiers | 15 | 15060000170156 | 15060000170156 | 1 | PA720538 | PM722994 |
| 15060000170164 | L15/dossiers | 15 | 15060000170163 | 15060000170163 | 1 | PA711156 | PM736319 |
| 15060000170171 | L15/dossiers | 15 | 15060000170170 | 15060000170170 | 1 | PA721270 | PM723220 |
| 15060000170178 | L15/dossiers | 15 | 15060000170177 | 15060000170177 | 1 | PA721702 | PM723360 |
| 15060000170258 | L15/dossiers | 15 | 15060000170257 | 15060000170257 | 1 | PA605036 | PM722444 |
| 15060000170265 | L15/dossiers | 15 | 15060000170264 | 15060000170264 | 1 | PA721486 | PM723290 |
| 15060000170272 | L15/dossiers | 15 | 15060000170271 | 15060000170271 | 1 | PA345722 | PM723428 |
| 15060000170279 | L15/dossiers | 15 | 15060000170278 | 15060000170278 | 1 | PA330240 | PM722492 |
| 15060000170283 | L15/dossiers | 15 | 15060000170282 | 15060000170282 | 1 | PA720066 | PM722848 |
| 15060000170291 | L15/dossiers | 15 | 15060000170290 | 15060000170290 | 1 | PA415449 | PM775793 |
| 15060000170298 | L15/dossiers | 15 | 15060000170297 | 15060000170297 | 1 | PA736192 | PM736353 |
| 15060000170308 | L15/dossiers | 15 | 15060000170307 | 15060000170307 | 1 | PA720996 | PM723134 |
| 15060000170316 | L15/dossiers | 15 | 15060000170315 | 15060000170315 | 1 | PA773441 | PM773491 |
| 15060000170317 | L15/dossiers | 15 | 15060000170315 | 15060000170315 | 2 | PA609520 | PM773503 |
| 15060000170318 | L15/dossiers | 15 | 15060000170315 | 15060000170315 | 3 | PA717161 | PM773483 |
| 15060000170326 | L15/dossiers | 15 | 15060000170325 | 15060000170325 | 1 | PA773441 | PM773491 |
| 15060000170327 | L15/dossiers | 15 | 15060000170325 | 15060000170325 | 2 | PA642788 | PM773495 |