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 |
|---|---|---|---|---|---|---|---|
| 15060000166551 | L15/dossiers | 15 | 15060000166549 | 15060000166549 | 2 | PA773443 | PM773510 |
| 15060000166648 | L15/dossiers | 15 | 15060000166647 | 15060000166647 | 1 | PA2377 | PM723550 |
| 15060000166655 | L15/dossiers | 15 | 15060000166654 | 15060000166654 | 1 | PA643089 | PM758076 |
| 15060000166667 | L15/dossiers | 15 | 15060000166666 | 15060000166666 | 1 | PA720210 | PM722892 |
| 15060000166674 | L15/dossiers | 15 | 15060000166673 | 15060000166673 | 1 | PA605036 | PM722444 |
| 15060000166685 | L15/dossiers | 15 | 15060000166684 | 15060000166684 | 1 | PA721486 | PM723290 |
| 15060000166692 | L15/dossiers | 15 | 15060000166691 | 15060000166691 | 1 | PA719318 | PM722624 |
| 15060000166699 | L15/dossiers | 15 | 15060000166698 | 15060000166698 | 1 | PA266788 | PM722914 |
| 15060000166709 | L15/dossiers | 15 | 15060000166708 | 15060000166708 | 1 | PA267440 | PM722522 |
| 15060000166716 | L15/dossiers | 15 | 15060000166715 | 15060000166715 | 1 | PA719480 | PM722674 |
| 15060000166723 | L15/dossiers | 15 | 15060000166722 | 15060000166722 | 1 | PA719480 | PM722674 |
| 15060000166730 | L15/dossiers | 15 | 15060000166729 | 15060000166729 | 1 | PA773441 | PM773491 |
| 15060000166762 | L15/dossiers | 15 | 15060000166761 | 15060000166761 | 1 | PA721270 | PM723220 |
| 15060000166769 | L15/dossiers | 15 | 15060000166768 | 15060000166768 | 1 | PA719448 | PM722666 |
| 15060000166803 | L15/dossiers | 15 | 15060000166802 | 15060000166802 | 1 | PA608416 | PM723540 |
| 15060000166807 | L15/dossiers | 15 | 15060000166806 | 15060000166806 | 1 | PA2774 | PM736307 |
| 15060000166814 | L15/dossiers | 15 | 15060000166813 | 15060000166813 | 1 | PA2774 | PM736307 |
| 15060000166827 | L15/dossiers | 15 | 15060000166826 | 15060000166826 | 1 | PA429835 | PM736397 |
| 15060000166834 | L15/dossiers | 15 | 15060000166833 | 15060000166833 | 1 | PA341381 | PM703618 |
| 15060000166844 | L15/dossiers | 15 | 15060000166843 | 15060000166843 | 1 | PA773441 | PM773491 |
| 15060000166845 | L15/dossiers | 15 | 15060000166843 | 15060000166843 | 2 | PA331481 | PM773459 |
| 15060000166846 | L15/dossiers | 15 | 15060000166843 | 15060000166843 | 3 | PA1872 | PM773455 |
| 15060000166847 | L15/dossiers | 15 | 15060000166843 | 15060000166843 | 4 | PA332 | PM773507 |
| 15060000166930 | L15/dossiers | 15 | 15060000166929 | 15060000166929 | 1 | PA773441 | PM773491 |
| 15060000166937 | L15/dossiers | 15 | 15060000166936 | 15060000166936 | 1 | PA736182 | PM736346 |
| 15060000166980 | L15/dossiers | 15 | 15060000166979 | 15060000166979 | 1 | PA223837 | PM722458 |
| 15060000166987 | L15/dossiers | 15 | 15060000166986 | 15060000166986 | 1 | PA711156 | PM736319 |
| 15060000166997 | L15/dossiers | 15 | 15060000166996 | 15060000166996 | 1 | PA712015 | PM722448 |
| 15060000166998 | L15/dossiers | 15 | 15060000166996 | 15060000166996 | 2 | PA718838 | PM722474 |
| 15060000167010 | L15/dossiers | 15 | 15060000167009 | 15060000167009 | 1 | PA718838 | PM722474 |
| 15060000167018 | L15/dossiers | 15 | 15060000167017 | 15060000167017 | 1 | PA720278 | PM722916 |
| 15060000167028 | L15/dossiers | 15 | 15060000167027 | 15060000167027 | 1 | PA266797 | PM722884 |
| 15060000167035 | L15/dossiers | 15 | 15060000167034 | 15060000167034 | 1 | PA721486 | PM723290 |
| 15060000167045 | L15/dossiers | 15 | 15060000167044 | 15060000167044 | 1 | PA721816 | PM748964 |
| 15060000167052 | L15/dossiers | 15 | 15060000167051 | 15060000167051 | 1 | PA773441 | PM773491 |
| 15060000167053 | L15/dossiers | 15 | 15060000167051 | 15060000167051 | 2 | PA717159 | PM773461 |
| 15060000167134 | L15/dossiers | 15 | 15060000167133 | 15060000167133 | 1 | PA773441 | PM773491 |
| 15060000167135 | L15/dossiers | 15 | 15060000167133 | 15060000167133 | 2 | PA609520 | PM773503 |
| 15060000167136 | L15/dossiers | 15 | 15060000167133 | 15060000167133 | 3 | PA759830 | PM773473 |
| 15060000167146 | L15/dossiers | 15 | 15060000167145 | 15060000167145 | 1 | PA773441 | PM773491 |
| 15060000167147 | L15/dossiers | 15 | 15060000167145 | 15060000167145 | 2 | PA331481 | PM773459 |
| 15060000167182 | L15/dossiers | 15 | 15060000167181 | 15060000167181 | 1 | PA330684 | PM722528 |
| 15060000167186 | L15/dossiers | 15 | 15060000167185 | 15060000167185 | 1 | PA609332 | PM723378 |
| 15060000167199 | L15/dossiers | 15 | 15060000167198 | 15060000167198 | 1 | PA720278 | PM722916 |
| 15060000167209 | L15/dossiers | 15 | 15060000167208 | 15060000167208 | 1 | PA205280 | PM736412 |
| 15060000167216 | L15/dossiers | 15 | 15060000167215 | 15060000167215 | 1 | PA205280 | PM736412 |
| 15060000167223 | L15/dossiers | 15 | 15060000167222 | 15060000167222 | 1 | PA773441 | PM773491 |
| 15060000167230 | L15/dossiers | 15 | 15060000167229 | 15060000167229 | 1 | PA773441 | PM773491 |
| 15060000167237 | L15/dossiers | 15 | 15060000167236 | 15060000167236 | 1 | PA703522 | PM703702 |
| 15060000167244 | L15/dossiers | 15 | 15060000167243 | 15060000167243 | 1 | PA304086 | PM736348 |