From a 500-row sample across 39 columns.
cross_street_1:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+58cross_street_1:@computed_region_sbqj_enihroad_ramp+37Mappable — Socrata point column `location`.
Open on the map →| unique_key | created_date | closed_date | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | city | facility_type | status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 12824180 | 2009-01-01T00:00:00.000 | 2009-01-08T00:00:00.000 | DPR | Department of Parks and Recreation | Maintenance or Facility | Structure - Outdoors | Park | 10033 | NEW YORK | N/A | Closed |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_key | text | — | 0% | 128179741281797512817976 |
created_date | datetime | — | 0% | 2009-01-16T00:00:00.0002009-03-03T00:00:00.0002009-12-29T00:00:00.000 |
closed_date | datetime | — | 3% | 2009-06-11T00:00:00.0002009-12-28T00:00:00.0002009-12-10T00:00:00.000 |
agency | categorical | — | 0% | HPDDOTDEPof 15 |
GET /api/datasets/3rfa-3xsf GET /api/datasets/3rfa-3xsf/quality GET /api/datasets/3rfa-3xsf/related GET /api/columns?dataset=3rfa-3xsf
cross_street_1:@computed_region_sbqj_enihroad_ramp+37:@computed_region_sbqj_enih:@computed_region_efsh_h5xistatus+8cross_street_1:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+7:@computed_region_sbqj_enih:@computed_region_efsh_h5xicity+7boroughfacility_type| 12882475 |
| 2009-01-08T00:00:00.000 |
| 2009-01-08T00:00:00.000 |
| DOT |
| Department of Transportation |
| Street Light Condition |
| Street Light Out |
| — |
| — |
| — |
| N/A |
| Closed |
| 12891071 | 2009-01-09T00:00:00.000 | 2009-01-09T00:00:00.000 | DOT | Department of Transportation | Traffic Signal Condition | Flashing Hazard | — | — | — | N/A | Closed |
| 12828000 | 2009-01-01T00:00:00.000 | 2009-01-05T00:00:00.000 | DOT | Department of Transportation | Street Light Condition | Street Light Out | — | — | — | N/A | Closed |
| 12828002 | 2009-01-01T00:00:00.000 | 2009-01-06T00:00:00.000 | DOT | Department of Transportation | Street Light Condition | Street Light Out | — | — | — | N/A | Closed |
| 12832944 | 2009-01-02T00:00:00.000 | 2009-01-21T00:00:00.000 | HPD | Department of Housing Preservation and Development | HEATING | HEAT | RESIDENTIAL BUILDING | — | — | N/A | Closed |
| 12829299 | 2009-01-01T00:00:00.000 | 2009-05-08T00:00:00.000 | DOT | Department of Transportation | Street Light Condition | Street Light Out | — | — | — | N/A | Closed |
| 12826101 | 2009-01-01T00:00:00.000 | 2009-01-02T00:00:00.000 | DOT | Department of Transportation | Street Light Condition | Street Light Out | — | — | — | N/A | Closed |
| 12918755 | 2009-01-13T00:00:00.000 | 2009-01-14T00:00:00.000 | DOT | Department of Transportation | Street Light Condition | Street Light Out | — | — | — | N/A | Closed |
| 12853360 | 2009-01-05T00:00:00.000 | 2009-01-05T00:00:00.000 | DOT | Department of Transportation | Traffic Signal Condition | Controller | — | — | — | N/A | Closed |
Showing 12 of 34 columns. All of them are listed below.
agency_name | text | — | 0% | Department of Housing Pr…Department of Transporta…Department of Environmen… |
complaint_type | text | — | 0% | HEATINGStreet Light ConditionGENERAL CONSTRUCTION |
descriptor | text | — | 0% | HEATStreet Light OutPothole |
location_type | text | — | 32% | RESIDENTIAL BUILDINGStreetStreet/Sidewalk |
incident_zip | text | — | 7% | 112261045810467 |
incident_address | text | — | 21% | GRAND CENTRAL PKWY BELT PKWY2706 BAINBRIDGE AVENUE |
street_name | text | — | 21% | BROADWAYGRAND CONCOURSEOCEAN AVENUE |
cross_street_1 | text | — | 22% | BENDBROADWAY3 AVENUE |
cross_street_2 | text | — | 22% | BENDBROADWAY7 AVENUE |
intersection_street_1 | text | — | 80% | BROADWAYATLANTIC AVENUE5 AVENUE |
intersection_street_2 | text | — | 80% | BROADWAY2 AVENUE5 AVENUE |
address_type | categorical | — | 3% | ADDRESSINTERSECTIONBLOCKFACEof 4 |
city | text | — | 7% | BROOKLYNBRONXNEW YORK |
landmark | text | — | 100% | J F K AIRPORTLA GUARDIA AIRPORTCENTRAL PARK |
facility_type | categorical | — | 0% | N/APrecinctDSNY Garageof 5 |
status | categorical | — | 0% | ClosedPendingAssignedof 7 |
due_date | datetime | — | 71% | 1900-01-02T00:00:00.0002009-06-07T00:00:00.0002009-07-25T00:00:00.000 |
resolution_action_updated_date | datetime | — | 1% | 2009-06-11T00:00:00.0002009-12-28T00:00:00.0002009-12-10T00:00:00.000 |
community_board | text | — | 0% | 0 Unspecified12 QUEENS07 QUEENS |
borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
x_coordinate_state_plane_ | integer | — | 7% | 10143849900881013705 |
y_coordinate_state_plane_ | integer | — | 7% | 254766162370252414 |
park_facility_name | text | — | 0% | UnspecifiedCentral ParkRiverside Park |
park_borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
school_name | text | — | 0% | UnspecifiedCentral ParkRiverside Park |
school_number | text | — | 0% | UnspecifiedM010M071 |
school_region | categorical | — | 0% | UnspecifiedRegion 3Region 7of 13 |
school_code | text | — | 0% | Unspecified30Q07603M415 |
school_phone_number | text | — | 0% | Unspecified21240801007189658900 |
school_address | text | — | 0% | Unspecified5th Avenue to Central Pa…Riverside Drive to Hudso… |
school_city | text | — | 0% | UnspecifiedNEW YORKBROOKLYN |
school_state | categorical | — | 0% | UnspecifiedNYof 2 |
school_zip | text | — | 0% | Unspecified1002110023 |
school_not_found | categorical | — | 100% | NYof 2 |
school_or_citywide_complaint | categorical | — | 100% | SchoolCitywide Complaintof 2 |
vehicle_type | categorical | — | 100% | Car ServiceAmbulette / ParatransitCommuter Vanof 3 |
taxi_company_borough | categorical | — | 100% | BROOKLYNQUEENSBRONXof 5 |
taxi_pick_up_location | categorical | — | 99% | OtherIntersectionJFK Airportof 7 |
bridge_highway_name | text | — | 100% | BQE/Gowanus ExpwyBelt PkwyFDR Dr |
bridge_highway_direction | text | — | 100% | West/Staten Island BoundEast/Queens BoundEast/Long Island Bound |
road_ramp | categorical | — | 100% | RoadwayRampN/Aof 3 |
bridge_highway_segment | text | — | 100% | RampRoadwayRockaway Pkwy (Exit 13) … |
garage_lot_name | text | — | 100% | Flushing #1 FieldSI Ferry TerminalFlushing #2 Field |
ferry_direction | categorical | — | 100% | N/AStaten Island BoundManhattan Boundof 3 |
ferry_terminal_name | text | — | 100% | UnknownSt. George Terminal (Sta…Whitehall Terminal (Manh… |
latitude | float | — | 7% | 40.8658969942657640.612342614511240.85944376109474 |
longitude | float | — | 7% | -73.89105203598722-73.9789731797154-73.89351726080064 |
location | coordinate | — | — | — |