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 |
|---|---|---|---|---|---|---|---|
| 15060000155737 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 39 | PA708632 | PM708643 |
| 15060000155738 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 40 | PA2197 | PM703640 |
| 15060000155739 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 41 | PA705750 | PM705821 |
| 15060000155740 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 42 | PA2237 | PM703705 |
| 15060000155741 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 43 | PA703541 | PM703644 |
| 15060000155742 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 44 | PA736200 | PM736285 |
| 15060000155743 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 45 | PA304076 | PM703694 |
| 15060000155744 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 46 | PA313924 | PM703546 |
| 15060000155745 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 47 | PA267728 | PM736277 |
| 15060000155746 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 48 | PA736239 | PM736317 |
| 15060000155747 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 49 | PA711156 | PM736319 |
| 15060000155748 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 50 | PA426327 | PM703630 |
| 15060000155749 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 51 | PA429851 | PM736305 |
| 15060000155750 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 52 | PA429874 | PM736314 |
| 15060000155751 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 53 | PA301592 | PM736375 |
| 15060000155752 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 54 | PA227094 | PM736386 |
| 15060000155753 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 55 | PA345785 | PM736294 |
| 15060000155754 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 56 | PA703482 | PM703642 |
| 15060000155761 | L15/dossiers | 15 | 15060000155760 | 15060000155760 | 1 | PA415446 | PM703678 |
| 15060000155768 | L15/dossiers | 15 | 15060000155767 | 15060000155767 | 1 | PA2116 | PM736339 |
| 15060000155769 | L15/dossiers | 15 | 15060000155767 | 15060000155767 | 2 | PA736236 | PM736341 |
| 15060000155770 | L15/dossiers | 15 | 15060000155767 | 15060000155767 | 3 | PA736203 | PM736432 |
| 15060000155777 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 1 | PA205280 | PM736412 |
| 15060000155778 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 2 | PA429858 | PM736268 |
| 15060000155779 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 3 | PA528 | PM736270 |
| 15060000155780 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 4 | PA736216 | PM736273 |
| 15060000155781 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 5 | PA303997 | PM703603 |
| 15060000155782 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 6 | PA304085 | PM736343 |
| 15060000155783 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 7 | PA415462 | PM703628 |
| 15060000155784 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 8 | PA736172 | PM736415 |
| 15060000155785 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 9 | PA980 | PM736356 |
| 15060000155786 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 10 | PA736192 | PM736353 |
| 15060000155787 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 11 | PA1001 | PM736371 |
| 15060000155788 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 12 | PA267762 | PM736366 |
| 15060000155789 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 13 | PA425322 | PM736282 |
| 15060000155790 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 14 | PA703539 | PM703693 |
| 15060000155791 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 15 | PA1183 | PM706347 |
| 15060000155792 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 16 | PA404656 | PM736328 |
| 15060000155793 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 17 | PA736218 | PM736257 |
| 15060000155794 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 18 | PA703520 | PM703665 |
| 15060000155795 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 19 | PA736169 | PM736293 |
| 15060000155796 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 20 | PA266867 | PM703554 |
| 15060000155797 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 21 | PA1344 | PM736383 |
| 15060000155798 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 22 | PA715322 | PM715327 |
| 15060000155799 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 23 | PA267989 | PM703655 |
| 15060000155800 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 24 | PA703530 | PM703695 |
| 15060000155801 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 25 | PA1562 | PM736340 |
| 15060000155802 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 26 | PA227078 | PM736258 |
| 15060000155803 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 27 | PA736223 | PM736368 |
| 15060000155804 | L15/dossiers | 15 | 15060000155776 | 15060000155776 | 28 | PA415476 | PM703653 |