Service Request 20240101 To 20241231 by US Government | Demographics and Population Studies

About this Dataset

Service Request 20240101 To 20241231

This information is from Hartford 311 which is a toll-free, non-emergency call center, designed to connect Hartford residents, businesses and visitors to City services, resources and information.
Organization: City of Hartford
Last updated: 2025-06-09T20:47:05.850522
Tags: 311, community, hartford-ct, service-request

Tables

Table 1

@usgov.city_of_hartford_service_request_20240101_to_20241231.table_1

1.03 MB
13166 rows
81 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "status" VARCHAR,
  "score" DOUBLE,
  "match_type" VARCHAR,
  "match_addr" VARCHAR,
  "longlabel" VARCHAR,
  "shortlabel" VARCHAR,
  "addr_type" VARCHAR,
  "type" VARCHAR,
  "placename" VARCHAR,
  "place_addr" VARCHAR,
  "phone" VARCHAR,
  "url" VARCHAR,
  "rank" BIGINT,
  "addbldg" VARCHAR,
  "addnum" DOUBLE,
  "addnumfrom" DOUBLE,
  "addnumto" DOUBLE,
  "addrange" VARCHAR,
  "side" VARCHAR,
  "stpredir" VARCHAR,
  "stpretype" VARCHAR,
  "stname" VARCHAR,
  "sttype" VARCHAR,
  "stdir" VARCHAR,
  "bldgtype" VARCHAR,
  "bldgname" VARCHAR,
  "leveltype" VARCHAR,
  "levelname" VARCHAR,
  "unittype" VARCHAR,
  "unitname" VARCHAR,
  "subaddr" VARCHAR,
  "staddr" VARCHAR,
  "block" VARCHAR,
  "sector" VARCHAR,
  "nbrhd" VARCHAR,
  "district" VARCHAR,
  "city" VARCHAR,
  "metroarea" VARCHAR,
  "subregion" VARCHAR,
  "region" VARCHAR,
  "regionabbr" VARCHAR,
  "territory" VARCHAR,
  "zone" VARCHAR,
  "postal" VARCHAR,
  "postalext" VARCHAR,
  "country" VARCHAR,
  "cntryname" VARCHAR,
  "langcode" VARCHAR,
  "distance" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE,
  "displayx" DOUBLE,
  "displayy" DOUBLE,
  "xmin" DOUBLE,
  "xmax" DOUBLE,
  "ymin" DOUBLE,
  "ymax" DOUBLE,
  "exinfo" VARCHAR,
  "in_address" VARCHAR,
  "in_address2" VARCHAR,
  "in_address3" VARCHAR,
  "in_neighborhood" VARCHAR,
  "in_city" VARCHAR,
  "in_subregion" VARCHAR,
  "in_region" VARCHAR,
  "in_postal" VARCHAR,
  "in_postalext" VARCHAR,
  "in_countrycode" VARCHAR,
  "user_record_number" VARCHAR,
  "user_record_type" VARCHAR,
  "user_application_name" VARCHAR,
  "user_record_status" VARCHAR,
  "user_opened_date" TIMESTAMP,
  "user_closed_date" TIMESTAMP,
  "user_address" VARCHAR,
  "user_unit" VARCHAR,
  "user_parcelid" DOUBLE,
  "user_record_module" VARCHAR,
  "user_dept_division" VARCHAR,
  "shape" VARCHAR
);