Name: Open311
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Open311

Comprehensive activity from our Open311 system, uReport.
Organization: City of Bloomington
Last updated: 2023-05-20T03:39:11.613591

Tables

Table 1

@usgov.city_of_bloomington_open311_263e3.table_1

11.39 MB
119845 rows
19 columns


CREATE TABLE table_1 (
  "service_request_id" BIGINT,
  "requested_datetime" VARCHAR,
  "updated_datetime" VARCHAR,
  "closed_date" VARCHAR,
  "status_description" VARCHAR,
  "source" VARCHAR,
  "service_name" VARCHAR,
  "description" VARCHAR,
  "agency_responsible" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "lat" DOUBLE,
  "long" DOUBLE,
  "georeference" VARCHAR,
  "sla_days" DOUBLE,
  "request_complete_days" DOUBLE,
  "sla_diff_days" DOUBLE
);