About this Dataset

VetRep Data

This feature layer contains contact and location information for Municipal Veterans Representatives across Connecticut, as designated under Connecticut General Statutes §27-135. Each record represents a municipality or regional entity responsible for assisting Veterans at the local level. The data supports the "Find a Veterans Representative" tool by providing accurate and up-to-date information on local Veterans service contacts.

Classifications:

• OPM, DVA

• Authoritativeness: Non-Authoritative

• Sensitivity: Public

• Usage: Public Use

Currency (time):

• Created: September 2024

• Update Frequency (estimated): as necessary

• Last Updated: May 2025

Lineage:

• Originated: CT Department of Veterans Affairs
Organization: State of Connecticut
Last updated: 2025-05-24T17:21:13.101806
Tags: connecticut, ct, department-of-veterans-affairs, dva, gis-office, giso, office-of-policy-and-management, opm

Tables

Table 1

@usgov.state_of_connecticut_vetrep_data.table_1

56.87 kB
185 rows
34 columns

CREATE TABLE table_1 (
  "municipality" VARCHAR,
  "councilsofgovernments" VARCHAR,
  "county" VARCHAR,
  "planningregion" VARCHAR,
  "statefips" BIGINT,
  "councilsofgovernmentsfips" BIGINT,
  "municipalityfips" BIGINT,
  "municipalityfips_geoid" BIGINT,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length,
  "municipality_1746545383634" VARCHAR,
  "district" DOUBLE,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_initial" VARCHAR,
  "suffix" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "e_mail_address" VARCHAR,
  "phone_number" VARCHAR,
  "website" VARCHAR,
  "district_office_address" VARCHAR,
  "district_office_address_line_2" VARCHAR,
  "district_office_city" VARCHAR,
  "district_office_state" VARCHAR,
  "district_office_e_mail" VARCHAR,
  "district_office_phone_number" VARCHAR,
  "objectid2" DOUBLE,
  "globalid_2" VARCHAR,
  "district_office_zip" DOUBLE,
  "objectid" BIGINT
);