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 |
|---|---|---|---|---|---|---|---|
| 15060000174730 | L15/dossiers | 15 | 15060000174729 | 15060000174729 | 1 | PA721932 | PM734586 |
| 15060000174737 | L15/dossiers | 15 | 15060000174736 | 15060000174736 | 1 | PA773441 | PM773491 |
| 15060000174738 | L15/dossiers | 15 | 15060000174736 | 15060000174736 | 2 | PA609520 | PM773503 |
| 15060000174873 | L15/dossiers | 15 | 15060000174872 | 15060000174872 | 1 | PA2116 | PM736339 |
| 15060000174880 | L15/dossiers | 15 | 15060000174879 | 15060000174879 | 1 | PA718784 | PM722456 |
| 15060000174901 | L15/dossiers | 15 | 15060000174900 | 15060000174900 | 1 | PA721486 | PM723290 |
| 15060000174909 | L15/dossiers | 15 | 15060000174908 | 15060000174908 | 1 | PA774952 | PM774983 |
| 15060000174916 | L15/dossiers | 15 | 15060000174915 | 15060000174915 | 1 | PA720892 | PM723106 |
| 15060000174920 | L15/dossiers | 15 | 15060000174919 | 15060000174919 | 1 | PA719946 | PM722808 |
| 15060000174927 | L15/dossiers | 15 | 15060000174926 | 15060000174926 | 1 | PA303997 | PM775743 |
| 15060000174976 | L15/dossiers | 15 | 15060000174975 | 15060000174975 | 1 | PA346054 | PM723510 |
| 15060000174983 | L15/dossiers | 15 | 15060000174982 | 15060000174982 | 1 | PA774952 | PM774983 |
| 15060000174993 | L15/dossiers | 15 | 15060000174992 | 15060000174992 | 1 | PA718926 | PM722502 |
| 15060000175000 | L15/dossiers | 15 | 15060000174999 | 15060000174999 | 1 | PA703495 | PM775653 |
| 15060000175010 | L15/dossiers | 15 | 15060000175009 | 15060000175009 | 1 | PA773441 | PM773491 |
| 15060000175011 | L15/dossiers | 15 | 15060000175009 | 15060000175009 | 2 | PA331481 | PM773459 |
| 15060000175018 | L15/dossiers | 15 | 15060000175017 | 15060000175017 | 1 | PA736228 | PM736380 |
| 15060000175036 | L15/dossiers | 15 | 15060000175035 | 15060000175035 | 1 | PA736187 | PM736365 |
| 15060000175046 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 1 | PA775296 | PM775596 |
| 15060000175047 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 2 | PA775246 | PM775532 |
| 15060000175048 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 3 | PA757676 | PM757692 |
| 15060000175049 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 4 | PA304082 | PM736354 |
| 15060000175050 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 5 | PA775172 | PM775474 |
| 15060000175051 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 6 | PA429894 | PM736364 |
| 15060000175052 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 7 | PA756685 | PM775777 |
| 15060000175053 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 8 | PA429836 | PM736345 |
| 15060000175054 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 9 | PA429886 | PM736385 |
| 15060000175055 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 10 | PA736195 | PM736357 |
| 15060000175056 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 11 | PA736173 | PM736369 |
| 15060000175057 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 12 | PA1978 | PM736337 |
| 15060000175058 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 13 | PA678263 | PM736330 |
| 15060000175059 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 14 | PA736243 | PM736413 |
| 15060000175060 | L15/dossiers | 15 | 15060000175045 | 15060000175045 | 15 | PA736175 | PM736344 |
| 15060000175070 | L15/dossiers | 15 | 15060000175069 | 15060000175069 | 1 | PA773441 | PM773491 |
| 15060000175104 | L15/dossiers | 15 | 15060000175103 | 15060000175103 | 1 | PA689 | PM723090 |
| 15060000175111 | L15/dossiers | 15 | 15060000175110 | 15060000175110 | 1 | PA1838 | PM723068 |
| 15060000175126 | L15/dossiers | 15 | 15060000175125 | 15060000175125 | 1 | PA719002 | PM775857 |
| 15060000175133 | L15/dossiers | 15 | 15060000175132 | 15060000175132 | 1 | PA721286 | PM723224 |
| 15060000175140 | L15/dossiers | 15 | 15060000175139 | 15060000175139 | 1 | PA606098 | PM722642 |
| 15060000175147 | L15/dossiers | 15 | 15060000175146 | 15060000175146 | 1 | PA267429 | PM722818 |
| 15060000175154 | L15/dossiers | 15 | 15060000175153 | 15060000175153 | 1 | PA718894 | PM722494 |
| 15060000175161 | L15/dossiers | 15 | 15060000175160 | 15060000175160 | 1 | PA718780 | PM722454 |
| 15060000175168 | L15/dossiers | 15 | 15060000175167 | 15060000175167 | 1 | PA721418 | PM723268 |
| 15060000175175 | L15/dossiers | 15 | 15060000175174 | 15060000175174 | 1 | PA720672 | PM774356 |
| 15060000175182 | L15/dossiers | 15 | 15060000175181 | 15060000175181 | 1 | PA720952 | PM723122 |
| 15060000175189 | L15/dossiers | 15 | 15060000175188 | 15060000175188 | 1 | PA2538 | PM775801 |
| 15060000175196 | L15/dossiers | 15 | 15060000175195 | 15060000175195 | 1 | PA267429 | PM722818 |
| 15060000175197 | L15/dossiers | 15 | 15060000175195 | 15060000175195 | 2 | PA718850 | PM722478 |
| 15060000175201 | L15/dossiers | 15 | 15060000175200 | 15060000175200 | 1 | PA609726 | PM723426 |
| 15060000175208 | L15/dossiers | 15 | 15060000175207 | 15060000175207 | 1 | PA722390 | PM723560 |