dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000093920 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 6 | PA736230 | PM736377 |
| 16060000093921 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 7 | PA775226 | PM775510 |
| 16060000093922 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 8 | PA775198 | PM775480 |
| 16060000093923 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 9 | PA331381 | PM775739 |
| 16060000093924 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 10 | PA758431 | PM758701 |
| 16060000093925 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 11 | PA267762 | PM736366 |
| 16060000093926 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 12 | PA736192 | PM736353 |
| 16060000093927 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 13 | PA703501 | PM775645 |
| 16060000093928 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 14 | PA703532 | PM775699 |
| 16060000093929 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 15 | PA736200 | PM736285 |
| 16060000093930 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 16 | PA775286 | PM775588 |
| 16060000093931 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 17 | PA736166 | PM775765 |
| 16060000093932 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 18 | PA736167 | PM736327 |
| 16060000093933 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 19 | PA775302 | PM775598 |
| 16060000093934 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 20 | PA775216 | PM775522 |
| 16060000093935 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 21 | PA429874 | PM736314 |
| 16060000093936 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 22 | PA703512 | PM775665 |
| 16060000093937 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 23 | PA703511 | PM775685 |
| 16060000093938 | L16/dossiers | 16 | 16060000093914 | 16060000093914 | 24 | PA429855 | PM736425 |
| 16060000093961 | L16/dossiers | 16 | 16060000093960 | 16060000093960 | 1 | PA429870 | PM736309 |
| 16060000094018 | L16/dossiers | 16 | 16060000094017 | 16060000094017 | 1 | PA703497 | PM775637 |
| 16060000094042 | L16/dossiers | 16 | 16060000094041 | 16060000094041 | 1 | PA720846 | PM723094 |
| 16060000094076 | L16/dossiers | 16 | 16060000094075 | 16060000094075 | 1 | PA773441 | PM773491 |
| 16060000094105 | L16/dossiers | 16 | 16060000094104 | 16060000094104 | 1 | PA773441 | PM773491 |
| 16060000094106 | L16/dossiers | 16 | 16060000094104 | 16060000094104 | 2 | PA1872 | PM773455 |
| 16060000094138 | L16/dossiers | 16 | 16060000094137 | 16060000094137 | 1 | PA736223 | PM736368 |
| 16060000094161 | L16/dossiers | 16 | 16060000094160 | 16060000094160 | 1 | PA425322 | PM736282 |
| 16060000094162 | L16/dossiers | 16 | 16060000094160 | 16060000094160 | 2 | PA736160 | PM736359 |
| 16060000094186 | L16/dossiers | 16 | 16060000094185 | 16060000094185 | 1 | PA773441 | PM773491 |
| 16060000094187 | L16/dossiers | 16 | 16060000094185 | 16060000094185 | 2 | PA331481 | PM773459 |
| 16060000094188 | L16/dossiers | 16 | 16060000094185 | 16060000094185 | 3 | PA729332 | PM773437 |
| 16060000094244 | L16/dossiers | 16 | 16060000094243 | 16060000094243 | 1 | PA340357 | PM747435 |
| 16060000094276 | L16/dossiers | 16 | 16060000094275 | 16060000094275 | 1 | PA703498 | PM736260 |
| 16060000094294 | L16/dossiers | 16 | 16060000094293 | 16060000094293 | 1 | PA718756 | PM722446 |
| 16060000094351 | L16/dossiers | 16 | 16060000094350 | 16060000094350 | 1 | PA773441 | PM773491 |
| 16060000094352 | L16/dossiers | 16 | 16060000094350 | 16060000094350 | 2 | PA1872 | PM773455 |
| 16060000094383 | L16/dossiers | 16 | 16060000094382 | 16060000094382 | 1 | PA773441 | PM773491 |
| 16060000094419 | L16/dossiers | 16 | 16060000094418 | 16060000094418 | 1 | PA773441 | PM773491 |
| 16060000094478 | L16/dossiers | 16 | 16060000094477 | 16060000094477 | 1 | PA773441 | PM773491 |
| 16060000094503 | L16/dossiers | 16 | 16060000094502 | 16060000094502 | 1 | PA773441 | PM773491 |
| 16060000094532 | L16/dossiers | 16 | 16060000094531 | 16060000094531 | 1 | PA267081 | PM775733 |
| 16060000094558 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 1 | PA2538 | PM775801 |
| 16060000094559 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 2 | PA425322 | PM736282 |
| 16060000094560 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 3 | PA775284 | PM775590 |
| 16060000094561 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 4 | PA703540 | PM775723 |
| 16060000094562 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 5 | PA775168 | PM775470 |
| 16060000094563 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 6 | PA736247 | PM736281 |
| 16060000094564 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 7 | PA775174 | PM775472 |
| 16060000094565 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 8 | PA736180 | PM785871 |
| 16060000094566 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 9 | PA736180 | PM785871 |