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 |
|---|---|---|---|---|---|---|---|
| 16060000107430 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 14 | PA775266 | PM775568 |
| 16060000107431 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 15 | PA736208 | PM736315 |
| 16060000107432 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 16 | PA775278 | PM775564 |
| 16060000107433 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 17 | PA303995 | PM775745 |
| 16060000107434 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 18 | PA736179 | PM736420 |
| 16060000107435 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 19 | PA736212 | PM736331 |
| 16060000107436 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 20 | PA721166 | PM785865 |
| 16060000107437 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 21 | PA429837 | PM736407 |
| 16060000107438 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 22 | PA736233 | PM736411 |
| 16060000107439 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 23 | PA775244 | PM775534 |
| 16060000107440 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 24 | PA736165 | PM736376 |
| 16060000107441 | L16/dossiers | 16 | 16060000107416 | 16060000107416 | 25 | PA2552 | PM736292 |
| 16060000107448 | L16/dossiers | 16 | 16060000107447 | 16060000107447 | 1 | PA720256 | PM796929 |
| 16060000107455 | L16/dossiers | 16 | 16060000107454 | 16060000107454 | 1 | PA2116 | PM736339 |
| 16060000107462 | L16/dossiers | 16 | 16060000107461 | 16060000107461 | 1 | PA720256 | PM796929 |
| 16060000107478 | L16/dossiers | 16 | 16060000107477 | 16060000107477 | 1 | PA717161 | PM791583 |
| 16060000107479 | L16/dossiers | 16 | 16060000107477 | 16060000107477 | 2 | PA773443 | PM791682 |
| 16060000107486 | L16/dossiers | 16 | 16060000107485 | 16060000107485 | 1 | PA346782 | PM797691 |
| 16060000107493 | L16/dossiers | 16 | 16060000107492 | 16060000107492 | 1 | PA736213 | PM775791 |
| 16060000107500 | L16/dossiers | 16 | 16060000107499 | 16060000107499 | 1 | PA717161 | PM791583 |
| 16060000107530 | L16/dossiers | 16 | 16060000107529 | 16060000107529 | 1 | PA610002 | PM797286 |
| 16060000107537 | L16/dossiers | 16 | 16060000107536 | 16060000107536 | 1 | PA793884 | PM796587 |
| 16060000107544 | L16/dossiers | 16 | 16060000107543 | 16060000107543 | 1 | PA795386 | PM797454 |
| 16060000107568 | L16/dossiers | 16 | 16060000107567 | 16060000107567 | 1 | PA703536 | PM775719 |
| 16060000107575 | L16/dossiers | 16 | 16060000107574 | 16060000107574 | 1 | PA429869 | PM736350 |
| 16060000107594 | L16/dossiers | 16 | 16060000107593 | 16060000107593 | 1 | PA712015 | PM796176 |
| 16060000107601 | L16/dossiers | 16 | 16060000107600 | 16060000107600 | 1 | PA794410 | PM796911 |
| 16060000107608 | L16/dossiers | 16 | 16060000107607 | 16060000107607 | 1 | PA775268 | PM775574 |
| 16060000107615 | L16/dossiers | 16 | 16060000107614 | 16060000107614 | 1 | PA703528 | PM775693 |
| 16060000107633 | L16/dossiers | 16 | 16060000107632 | 16060000107632 | 1 | PA330240 | PM796155 |
| 16060000107637 | L16/dossiers | 16 | 16060000107636 | 16060000107636 | 1 | PA794058 | PM796686 |
| 16060000107644 | L16/dossiers | 16 | 16060000107643 | 16060000107643 | 1 | PA608695 | PM797220 |
| 16060000107651 | L16/dossiers | 16 | 16060000107650 | 16060000107650 | 1 | PA793278 | PM796242 |
| 16060000107658 | L16/dossiers | 16 | 16060000107657 | 16060000107657 | 1 | PA1327 | PM796632 |
| 16060000107665 | L16/dossiers | 16 | 16060000107664 | 16060000107664 | 1 | PA345722 | PM797718 |
| 16060000107672 | L16/dossiers | 16 | 16060000107671 | 16060000107671 | 1 | PA721486 | PM797517 |
| 16060000107679 | L16/dossiers | 16 | 16060000107678 | 16060000107678 | 1 | PA720644 | PM797103 |
| 16060000107686 | L16/dossiers | 16 | 16060000107685 | 16060000107685 | 1 | PA721158 | PM797460 |
| 16060000107701 | L16/dossiers | 16 | 16060000107700 | 16060000107700 | 1 | PA333421 | PM796881 |
| 16060000107705 | L16/dossiers | 16 | 16060000107704 | 16060000107704 | 1 | PA332523 | PM796683 |
| 16060000107712 | L16/dossiers | 16 | 16060000107711 | 16060000107711 | 1 | PA793992 | PM796641 |
| 16060000107727 | L16/dossiers | 16 | 16060000107726 | 16060000107726 | 1 | PA720630 | PM797094 |
| 16060000107734 | L16/dossiers | 16 | 16060000107733 | 16060000107733 | 1 | PA717161 | PM791583 |
| 16060000107741 | L16/dossiers | 16 | 16060000107740 | 16060000107740 | 1 | PA2197 | PM775755 |
| 16060000107748 | L16/dossiers | 16 | 16060000107747 | 16060000107747 | 1 | PA794894 | PM797181 |
| 16060000107758 | L16/dossiers | 16 | 16060000107757 | 16060000107757 | 1 | PA2952 | PM796206 |
| 16060000107771 | L16/dossiers | 16 | 16060000107770 | 16060000107770 | 1 | PA267762 | PM736366 |
| 16060000107778 | L16/dossiers | 16 | 16060000107777 | 16060000107777 | 1 | PA267241 | PM778080 |
| 16060000107785 | L16/dossiers | 16 | 16060000107784 | 16060000107784 | 1 | PA429874 | PM736314 |
| 16060000107792 | L16/dossiers | 16 | 16060000107791 | 16060000107791 | 1 | PA736162 | PM736320 |