         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

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

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,
