| unique_key | created_date | closed_date | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | incident_address | street_name | cross_street_1 | cross_street_2 | intersection_street_1 | intersection_street_2 | address_type | city | landmark | facility_type | status | due_date | resolution_action_updated_date | community_board | borough | x_coordinate_state_plane | y_coordinate_state_plane | park_facility_name | park_borough | school_name | school_number | school_region | school_code | school_phone_number | school_address | school_city | school_state | school_zip | school_not_found | school_or_citywide_complaint | vehicle_type | taxi_company_borough | taxi_pick_up_location | bridge_highway_name | bridge_highway_direction | road_ramp | bridge_highway_segment | garage_lot_name | ferry_direction | ferry_terminal_name | latitude | longitude | location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29265730.0 |
2014-11-10T03:30:20 |
2014-11-10T03:30:20 |
DOB |
Department of Buildings |
Elevator |
Elevator - Defective/Not Working |
10456 |
280 EAST 170 STREET |
EAST 170 STREET |
MORRIS AVENUE |
COLLEGE AVENUE |
ADDRESS |
BRONX |
N/A |
Open |
2014-11-10T00:00:00 |
04 BRONX |
BRONX |
1008864.0 |
244486.0 |
Unspecified |
BRONX |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
40.8376985772017 |
-73.9110470456048 |
(40.83769857720166, -73.91104704560485) |
|||||||||||||||||
29181980.0 |
2014-10-30T12:20:06 |
2014-10-30T12:20:06 |
DOB |
Department of Buildings |
General Construction/Plumbing |
Cons - Contrary/Beyond Approved Plans/Permits |
10451 |
615 COURTLANDT AVENUE |
COURTLANDT AVENUE |
EAST 151 STREET |
EAST 152 STREET |
ADDRESS |
BRONX |
N/A |
Closed |
2014-10-30T00:00:00 |
01 BRONX |
BRONX |
1006710.0 |
237355.0 |
Unspecified |
BRONX |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
40.8181317677885 |
-73.9188552907969 |
(40.818131767788465, -73.91885529079687) |
|||||||||||||||||
29216290.0 |
2014-11-03T14:47:01 |
2014-11-03T21:28:32 |
NYPD |
New York City Police Department |
Illegal Parking |
Overnight Commercial Storage |
Street/Sidewalk |
11206 |
153 HEYWARD STREET |
HEYWARD STREET |
LEE AVENUE |
MARCY AVENUE |
ADDRESS |
BROOKLYN |
Precinct |
Closed |
2014-11-03T22:47:01 |
2014-11-03T21:28:32 |
01 BROOKLYN |
BROOKLYN |
996697.0 |
195166.0 |
Unspecified |
BROOKLYN |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
N |
40.7023535985916 |
-73.9551089050392 |
(40.70235359859161, -73.95510890503915) |
||||||||||||||
29259870.0 |
2014-11-10T09:48:00 |
2014-11-10T12:00:00 |
DSNY |
BCC - Queens West |
Sanitation Condition |
15 Street Cond/Dump-Out/Drop-Off |
Street |
11385 |
70-14 65 STREET |
65 STREET |
OTTO ROAD |
CENTRAL AVENUE |
ADDRESS |
Ridgewood |
DSNY Garage |
Closed |
2014-11-10T12:00:00 |
05 QUEENS |
QUEENS |
1014433.0 |
195518.0 |
Unspecified |
QUEENS |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
40.7032770332787 |
-73.8911410799892 |
(40.70327703327868, -73.89114107998917) |
||||||||||||||||
29181357.0 |
2014-10-30T07:24:00 |
2014-10-30T16:30:00 |
DEP |
Department of Environmental Protection |
Water System |
Hydrant Running (WC3) |
11249 |
93 WYTHE AVENUE |
WYTHE AVENUE |
NORTH 10 STREET |
NORTH 9 STREET |
ADDRESS |
BROOKLYN |
N/A |
Closed |
2014-10-30T16:30:00 |
01 BROOKLYN |
BROOKLYN |
995690.0 |
201993.0 |
Unspecified |
BROOKLYN |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
40.7210934467404 |
-73.9587291294771 |
(40.72109344674039, -73.95872912947712) |
|||||||||||||||||
29168972.0 |
2014-10-28T14:47:34 |
2014-10-28T15:28:26 |
NYPD |
New York City Police Department |
Bike/Roller/Skate Chronic |
N/A |
Street/Sidewalk |
10128 |
EAST 90 STREET |
5 AVENUE |
INTERSECTION |
NEW YORK |
Precinct |
Closed |
2014-10-28T22:47:34 |
2014-10-28T15:28:26 |
08 MANHATTAN |
MANHATTAN |
995724.0 |
224942.0 |
Unspecified |
MANHATTAN |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
N |
40.7840825835527 |
-73.9585673120901 |
(40.78408258355265, -73.95856731209008) |
||||||||||||||||
29300159.0 |
2014-11-15T00:00:00 |
HPD |
Department of Housing Preservation and Development |
HEAT/HOT WATER |
ENTIRE BUILDING |
RESIDENTIAL BUILDING |
10011 |
224 8 AVENUE |
8 AVENUE |
WEST 21 STREET |
WEST 22 STREET |
ADDRESS |
NEW YORK |
N/A |
Open |
2014-11-15T00:00:00 |
04 MANHATTAN |
MANHATTAN |
984470.0 |
210442.0 |
Unspecified |
MANHATTAN |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
40.744291270478 |
-73.9992060530905 |
(40.74429127047803, -73.99920605309049) |
|||||||||||||||||
29268103.0 |
2014-11-11T00:00:00 |
2014-11-13T00:00:00 |
HPD |
Department of Housing Preservation and Development |
HEAT/HOT WATER |
APARTMENT ONLY |
RESIDENTIAL BUILDING |
10029 |
2060 2 AVENUE |
2 AVENUE |
EAST 105 STREET |
EAST 106 STREET |
ADDRESS |
NEW YORK |
N/A |
Closed |
2014-11-13T00:00:00 |
11 MANHATTAN |
MANHATTAN |
1000164.0 |
227275.0 |
Unspecified |
MANHATTAN |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
40.7904791634932 |
-73.9425289202899 |
(40.7904791634932, -73.94252892028989) |
||||||||||||||||
29187462.0 |
2014-11-01T01:16:22 |
2014-11-01T03:33:32 |
NYPD |
New York City Police Department |
Noise - Street/Sidewalk |
Loud Talking |
Street/Sidewalk |
10459 |
1083 LONGFELLOW AVENUE |
LONGFELLOW AVENUE |
EAST 165 STREET |
LOWELL STREET |
ADDRESS |
BRONX |
Precinct |
Closed |
2014-11-01T09:16:22 |
2014-11-01T03:33:32 |
02 BRONX |
BRONX |
1015294.0 |
240146.0 |
Unspecified |
BRONX |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
N |
40.8257662713477 |
-73.8878296659518 |
(40.8257662713477, -73.88782966595178) |
||||||||||||||
29250728.0 |
2014-11-08T10:28:41 |
2014-11-08T12:09:30 |
NYPD |
New York City Police Department |
Derelict Vehicle |
With License Plate |
Street/Sidewalk |
11422 |
243-19 144 AVENUE |
144 AVENUE |
243 STREET |
249 STREET |
ADDRESS |
ROSEDALE |
Precinct |
Closed |
2014-11-08T18:28:41 |
2014-11-08T12:09:30 |
13 QUEENS |
QUEENS |
1056660.0 |
179911.0 |
Unspecified |
QUEENS |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
Unspecified |
N |
40.660194767689 |
-73.7390122508209 |
(40.660194767688985, -73.73901225082093) |