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 |
|---|---|---|---|---|---|---|---|
| 15060000155805 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 29 | PA736203 | PM736432 |
| 15060000155806 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 30 | PA703488 | PM703632 |
| 15060000155807 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 31 | PA703501 | PM703629 |
| 15060000155808 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 32 | PA736246 | PM736428 |
| 15060000155809 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 33 | PA415447 | PM703616 |
| 15060000155810 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 34 | PA736186 | PM736396 |
| 15060000155811 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 35 | PA736213 | PM736431 |
| 15060000155812 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 36 | PA415489 | PM703714 |
| 15060000155813 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 37 | PA703517 | PM703625 |
| 15060000155814 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 38 | PA2197 | PM703640 |
| 15060000155815 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 39 | PA2237 | PM703705 |
| 15060000155816 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 40 | PA343988 | PM736310 |
| 15060000155817 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 41 | PA703521 | PM703544 |
| 15060000155818 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 42 | PA267872 | PM736409 |
| 15060000155819 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 43 | PA267328 | PM703547 |
| 15060000155820 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 44 | PA736200 | PM736285 |
| 15060000155821 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 45 | PA304076 | PM703694 |
| 15060000155822 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 46 | PA313924 | PM703546 |
| 15060000155823 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 47 | PA267018 | PM703564 |
| 15060000155824 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 48 | PA711156 | PM736319 |
| 15060000155825 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 49 | PA736193 | PM736394 |
| 15060000155826 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 50 | PA429851 | PM736305 |
| 15060000155827 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 51 | PA227094 | PM736386 |
| 15060000155828 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 52 | PA345785 | PM736294 |
| 15060000155829 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 53 | PA303996 | PM703614 |
| 15060000155830 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 54 | PA703527 | PM703580 |
| 15060000155831 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 55 | PA736222 | PM736436 |
| 15060000155838 | L15/dossiers | 15 | 15060000155837 | 15060000155837 | 1 | PA2116 | PM736339 |
| 15060000155845 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 1 | PA720634 | PM736312 |
| 15060000155846 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 2 | PA736247 | PM736281 |
| 15060000155847 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 3 | PA744079 | PM744082 |
| 15060000155848 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 4 | PA736188 | PM736289 |
| 15060000155849 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 5 | PA736198 | PM736406 |
| 15060000155850 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 6 | PA703522 | PM703702 |
| 15060000155851 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 7 | PA703500 | PM703574 |
| 15060000155852 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 8 | PA736216 | PM736273 |
| 15060000155853 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 9 | PA415456 | PM736433 |
| 15060000155854 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 10 | PA415456 | PM736433 |
| 15060000155855 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 11 | PA303997 | PM703603 |
| 15060000155856 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 12 | PA703510 | PM703672 |
| 15060000155857 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 13 | PA736197 | PM736378 |
| 15060000155858 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 14 | PA703513 | PM703621 |
| 15060000155859 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 15 | PA429854 | PM736335 |
| 15060000155860 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 16 | PA736172 | PM736415 |
| 15060000155861 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 17 | PA715745 | PM736297 |
| 15060000155862 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 18 | PA736192 | PM736353 |
| 15060000155863 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 19 | PA1001 | PM736371 |
| 15060000155864 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 20 | PA736160 | PM736359 |
| 15060000155865 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 21 | PA425322 | PM736282 |
| 15060000155866 | L15/dossiers | 15 | 15060000155844 | 15060000155844 | 22 | PA1183 | PM706347 |