Name: NYC 311-2010 To Present
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

NYC 311-2010 To Present

Context

The data provides a detailed information about the NYC 311 service requests recently acquired.

Content

The data has a wide description of the Service Requests.
The requests are recently acquired ones, i.e. from 2010 to the present

Inspiration

The purpose of this data is to help analyse the most common complaints or the major locations which demands service often.

Tables

N 311 Service Requests From 2010 To Present

@kaggle.sherinclaudia_nyc311_2010.n_311_service_requests_from_2010_to_present

37.92 MB
364,558 rows
53 columns

CREATE TABLE n_311_service_requests_from_2010_to_present (
  "unique_key" BIGINT,
  "created_date" VARCHAR,
  "closed_date" VARCHAR,
  "agency" VARCHAR,
  "agency_name" VARCHAR,
  "complaint_type" VARCHAR,
  "descriptor" VARCHAR,
  "location_type" VARCHAR,
  "incident_zip" DOUBLE,
  "incident_address" VARCHAR,
  "street_name" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "intersection_street_1" VARCHAR,
  "intersection_street_2" VARCHAR,
  "address_type" VARCHAR,
  "city" VARCHAR,
  "landmark" VARCHAR,
  "facility_type" VARCHAR,
  "status" VARCHAR,
  "due_date" VARCHAR,
  "resolution_description" VARCHAR,
  "resolution_action_updated_date" VARCHAR,
  "community_board" VARCHAR,
  "borough" VARCHAR,
  "x_coordinate_state_plane" DOUBLE  -- X Coordinate (State Plane),
  "y_coordinate_state_plane" DOUBLE  -- Y Coordinate (State Plane),
  "park_facility_name" VARCHAR,
  "park_borough" VARCHAR,
  "school_name" VARCHAR,
  "school_number" VARCHAR,
  "school_region" VARCHAR,
  "school_code" VARCHAR,
  "school_phone_number" VARCHAR,
  "school_address" VARCHAR,
  "school_city" VARCHAR,
  "school_state" VARCHAR,
  "school_zip" VARCHAR,
  "school_not_found" VARCHAR,
  "school_or_citywide_complaint" VARCHAR,
  "vehicle_type" VARCHAR,
  "taxi_company_borough" VARCHAR,
  "taxi_pick_up_location" VARCHAR,
  "bridge_highway_name" VARCHAR,
  "bridge_highway_direction" VARCHAR,
  "road_ramp" VARCHAR,
  "bridge_highway_segment" VARCHAR,
  "garage_lot_name" VARCHAR,
  "ferry_direction" VARCHAR,
  "ferry_terminal_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);