 CREATE INDEX dw_secondary_jurisdictions_jurisdiction_id_ix
     ON dw_secondary_jurisdictions (jurisdiction_id);
 
+UPDATE dw_morbidity_events dme
+    SET secondary_jurisdictions = foo.juris
+    FROM (
+        SELECT
+            ',' || trisano.text_join_agg(name, ',') || ',' AS juris,
+            dw_morbidity_events_id AS event_id
+        FROM
+            dw_secondary_jurisdictions
+        GROUP BY dw_morbidity_events_id
+    ) foo
+    WHERE foo.event_id = dme.id;
+
 CREATE TABLE dw_events_hospitals AS
 SELECT
     hpart.id,

        'dw_place_questions',
        'dw_encounter_questions',
        'dw_telephones',
        'dw_prf',
        'dw_email_addresses'
    );
COMMIT;

        ELSE ''
    END AS public_health_status,
    newhstore AS morbidity_formbuilder,
    ',,'::TEXT secondary_jurisdictions,

    1::integer AS always_one     -- This column joins against the population.population_years view
                                 -- to associate every event with every population year, and keep
