Name: SF311 Prior Case Data Structure
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

SF311 Prior Case Data Structure

Demonstration data set for data prior to the changes made on 20 April 2017:
https://data.sfgov.org/City-Infrastructure/Case-Data-from-San-Francisco-311-SF311-/vw6y-z8j6
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:22.619958

Tables

Table 1

@usgov.city_of_san_francisco_sf311_prior_case_data_structure.table_1

44.69 MB
466,369 rows
16 columns

CREATE TABLE table_1 (
  "caseid" BIGINT,
  "opened" VARCHAR,
  "closed" VARCHAR,
  "updated" VARCHAR,
  "status" VARCHAR,
  "status_notes" VARCHAR,
  "responsible_agency" VARCHAR,
  "category" VARCHAR,
  "request_type" VARCHAR,
  "request_details" VARCHAR,
  "address" VARCHAR,
  "supervisor_district" BIGINT,
  "neighborhood" VARCHAR,
  "point" VARCHAR,
  "source" VARCHAR,
  "media_url" VARCHAR
);