Dataset: NYC 311-2010 To Present

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

36.16 MB
364558 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,
  "y_coordinate_state_plane" DOUBLE,
  "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
);