About this Dataset

Calls For Service Open Data (2024) - Deprecated Dataset

Note: This dataset was deprecated effective April 30, 2025. Please refer to the Calls for Service (Consolidated) dataset for current data and access to historical records, including prior reporting years.

Current reporting period's call for service data (2024 - 2027)
Organization: City of Tempe
Last updated: 2024-02-09T14:58:32.533578
Tags: calls-for-service, open-data, police-transparency, view-layer

Tables

Table 1

@usgov.city_of_tempe_calls_for_service_open_data_2024.table_1

5.09 MB
95,500 rows
37 columns

CREATE TABLE table_1 (
  "x" BIGINT,
  "y" BIGINT,
  "objectid" BIGINT,
  "primarykey" VARCHAR,
  "occurrencedatetime" TIMESTAMP,
  "occurrenceyear" BIGINT,
  "occurrencemonth" BIGINT,
  "occurrencehour" BIGINT,
  "occurrenceweek" BIGINT,
  "occurrencedatepart" BIGINT,
  "occurrenceweekday" VARCHAR,
  "obfuscatedaddress" VARCHAR,
  "finalcasetype" VARCHAR,
  "priority" BIGINT,
  "zone" VARCHAR,
  "grid" VARCHAR,
  "howreceived" VARCHAR,
  "unitid1" VARCHAR,
  "unitid2" VARCHAR,
  "unitid3" VARCHAR,
  "reportflag" VARCHAR,
  "casestatus" VARCHAR,
  "clearedby" VARCHAR,
  "xcoordinate" BIGINT,
  "ycoordinate" BIGINT,
  "disclaimer" VARCHAR,
  "placename" VARCHAR,
  "calltype" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "characterarea" VARCHAR,
  "reportdistrict" VARCHAR,
  "reportbeat" VARCHAR,
  "postalcode" DOUBLE,
  "censustractid" DOUBLE,
  "parkname" VARCHAR,
  "neighborhoodname" VARCHAR
);