Name: Graffiti Reports
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Graffiti Reports

This data set contains selected information for Graffiti service requests currently in progress or resolved within the past six years.
Organization: City of Seattle
Last updated: 2024-12-16T22:29:04.057927
Tags: customer, maintenance, neighborhood, service-request

Tables

Table 1

@usgov.city_of_seattle_graffiti_reports.table_1

6.56 MB
129,662 rows
19 columns

CREATE TABLE table_1 (
  "service_request_number" VARCHAR,
  "created_date" VARCHAR,
  "method_received" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "x_value" DOUBLE,
  "y_value" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "latitude_longitude" VARCHAR,
  "zip_code" VARCHAR,
  "council_district" DOUBLE,
  "police_precinct" VARCHAR,
  "neighborhood" VARCHAR,
  "what_is_the_graffiti_on" VARCHAR  -- What Is The Graffiti On?,
  "are_you_the_owner_of_the_property_the_graffiti_is_on" VARCHAR  -- Are You The Owner Of The Property The Graffiti Is On?,
  "pay_station_number_or_location_number" VARCHAR,
  "stop_id" DOUBLE,
  "is_the_graffiti_obscene_racial_or_hateful" VARCHAR  -- Is The Graffiti Obscene, Racial, Or Hateful?
);