About this Dataset

Local Health Districts Status Maps

Included in the data set is :

-Local Health Department

-Planning Organization

-Director of Health (DoH) Name

- DoH title

-DoH Degree

-Doh Email

-LHD Status (District, Part time, Full Time)

-LHD Phone

-Agency Fax
Organization: State of Connecticut
Last updated: 2025-02-21T22:15:08.577584
Tags: boundaries, contact-information, dph, local-health, local-health-contact-information

Tables

Table 1

@usgov.state_of_connecticut_local_health_districts_status_for_maps.table_1

44.64 kB
169 rows
32 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "town_no" BIGINT,
  "town" VARCHAR,
  "county" VARCHAR,
  "plan_org" VARCHAR,
  "dep_dist" VARCHAR,
  "district" BIGINT,
  "local_heal" VARCHAR,
  "local_health_department" VARCHAR,
  "lhd_status" VARCHAR,
  "doh_name" VARCHAR,
  "doh_degrees" VARCHAR,
  "doh_title" VARCHAR,
  "lhd_street_address" VARCHAR,
  "lhd_address_2" VARCHAR,
  "lhd_town" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "lhd_phone" VARCHAR,
  "after_business_hours" VARCHAR,
  "agency_fax" VARCHAR,
  "doh_email" VARCHAR,
  "website" VARCHAR,
  "date_updated" TIMESTAMP,
  "total_sqmi" DOUBLE,
  "land_sqmi" DOUBLE,
  "water_sqmi" DOUBLE,
  "shape_leng" DOUBLE,
  "objectid_1" BIGINT,
  "shape_area" DOUBLE  -- SHAPE, Area,
  "shape_length" DOUBLE  -- SHAPE, Length,
  "date" VARCHAR
);