From a 500-row sample across 44 columns.
boroughlocation_statetaxi_company_borough+58boroughlocation_statetaxi_company_borough+58Mappable — Socrata point column `location`.
Open on the map →| unique_key | created_date | closed_date | agency | agency_name | complaint_type | descriptor | location_type | facility_type | status | due_date | resolution_action_updated_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 100677 | 2007-02-06T00:00:00.000 | 2007-02-07T00:00:00.000 | DOT | Department of Transportation | Ferry Inquiry | Lost and Found | Ferry | N/A | Closed | 2007-03-08T00:00:00.000 | 2007-02-07T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_key | text | — | 0% | 100000011000000210000003 |
created_date | datetime | — | 0% | 2007-02-05T00:00:00.0002007-01-26T00:00:00.0002007-02-06T00:00:00.000 |
closed_date | datetime | — | 2% | 2007-12-06T00:00:00.0002007-04-16T00:00:00.0002007-02-08T00:00:00.000 |
agency | categorical | — | 0% | HPDDOTDEPof 12 |
GET /api/datasets/aiww-p3af GET /api/datasets/aiww-p3af/quality GET /api/datasets/aiww-p3af/related GET /api/columns?dataset=aiww-p3af
boroughlocation_statetaxi_company_borough+58boroughlocation_statetaxi_company_borough+58boroughlocation_statetaxi_company_borough+58boroughtaxi_company_boroughlocation+37boroughtaxi_company_boroughlocation+37boroughlongitudecreated_date+8| 169606 | 2007-01-21T00:00:00.000 | 2007-01-23T00:00:00.000 | DPR | Department of Parks and Recreation | Maintenance or Facility | Garbage or Litter | Park | N/A | Closed | 2007-01-24T00:00:00.000 | 2007-01-23T00:00:00.000 |
| 170753 | 2007-02-01T00:00:00.000 | 2007-02-01T00:00:00.000 | TLC | Taxi and Limousine Commission | Taxi Complaint | Driver Complaint | Bridge | N/A | Closed | — | 2007-02-01T00:00:00.000 |
| 170967 | 2007-01-30T00:00:00.000 | 2007-01-30T00:00:00.000 | DOT | Department of Transportation | Ferry Inquiry | Lost and Found | Ferry | N/A | Closed | 2007-03-01T00:00:00.000 | 2007-01-30T00:00:00.000 |
| 587093 | 2007-01-25T00:00:00.000 | 2007-01-25T00:00:00.000 | DOT | Department of Transportation | Traffic Signal Condition | Cable | — | N/A | Closed | — | 2007-01-25T00:00:00.000 |
| 171743 | 2007-02-05T00:00:00.000 | 2007-02-08T00:00:00.000 | DOT | Department of Transportation | Ferry Complaint | General Complaint | Terminal | N/A | Closed | 2007-04-06T00:00:00.000 | 2007-02-08T00:00:00.000 |
| 168682 | 2007-01-13T00:00:00.000 | 2007-01-16T00:00:00.000 | DOT | Department of Transportation | Ferry Inquiry | Lost and Found | Ferry | N/A | Closed | 2007-02-12T00:00:00.000 | 2007-01-16T00:00:00.000 |
| 168537 | 2007-01-18T00:00:00.000 | 2007-01-19T00:00:00.000 | DOT | Department of Transportation | Ferry Inquiry | Lost and Found | Ferry | N/A | Closed | 2007-02-17T00:00:00.000 | 2007-01-19T00:00:00.000 |
| 169448 | 2007-01-20T00:00:00.000 | 2007-01-20T00:00:00.000 | DPR | Department of Parks and Recreation | Violation of Park Rules | Tree Damage or Arboricide | Park | N/A | Closed | 2007-02-03T00:00:00.000 | 2007-01-20T00:00:00.000 |
| 167314 | 2007-01-08T00:00:00.000 | 2007-01-24T00:00:00.000 | DCA | Department of Consumer Affairs | Consumer Complaint | Harassment | — | N/A | Closed | 2007-01-23T00:00:00.000 | 2007-01-08T00:00:00.000 |
Showing 12 of 38 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 | — | 36% | RESIDENTIAL BUILDINGStreetStreet/Sidewalk |
incident_zip | text | — | 7% | 112261122110467 |
incident_address | text | — | 22% | 223 EAST 32 STREET249 OCEAN PARKWAY BELT PKWY |
street_name | text | — | 22% | BROADWAYGRAND CONCOURSEOCEAN AVENUE |
cross_street_1 | text | — | 25% | BENDBROADWAY5 AVENUE |
cross_street_2 | text | — | 25% | BENDBROADWAY7 AVENUE |
intersection_street_1 | text | — | 80% | BROADWAY3 AVEATLANTIC AVENUE |
intersection_street_2 | text | — | 80% | BROADWAY5 AVENUE2 AVENUE |
address_type | categorical | — | 3% | ADDRESSINTERSECTIONBLOCKFACEof 4 |
city | text | — | 7% | BROOKLYNNEW YORKBRONX |
landmark | text | — | 100% | LA GUARDIA AIRPORTJ F K AIRPORTCENTRAL PARK |
facility_type | categorical | — | 0% | N/APrecinctDSNY Garageof 5 |
status | categorical | — | 0% | ClosedPendingAssignedof 8 |
due_date | datetime | — | 79% | 2007-07-22T00:00:00.0002007-08-12T00:00:00.0002007-08-19T00:00:00.000 |
resolution_action_updated_date | datetime | — | 1% | 2008-06-30T00:00:00.0002007-04-16T00:00:00.0002007-12-06T00:00:00.000 |
community_board | text | — | 0% | 0 Unspecified12 QUEENSUnspecified MANHATTAN |
borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
x_coordinate_state_plane_ | integer | — | 8% | 9902509914971003546 |
y_coordinate_state_plane_ | integer | — | 8% | 210392173821171929 |
park_facility_name | text | — | 0% | UnspecifiedRiverside ParkCentral Park |
park_borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
school_name | text | — | 0% | UnspecifiedRiverside ParkCentral Park |
school_number | text | — | 0% | UnspecifiedM010M071 |
school_region | categorical | — | 0% | UnspecifiedRegion 7Region 2of 13 |
school_code | text | — | 0% | Unspecified28Q15708X071 |
school_phone_number | text | — | 0% | Unspecified21240801007189658900 |
school_address | text | — | 0% | UnspecifiedRiverside Drive to Hudso…5th Avenue to Central Pa… |
school_city | text | — | 0% | UnspecifiedBROOKLYNNEW YORK |
school_state | categorical | — | 0% | UnspecifiedNYof 2 |
school_zip | text | — | 0% | Unspecified1002310021 |
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% | BROOKLYNQUEENSMANHATTANof 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/Long Island BoundEast/Queens Bound |
road_ramp | categorical | — | 100% | RoadwayRampN/Aof 3 |
bridge_highway_segment | text | — | 100% | RoadwayRampN/A |
garage_lot_name | text | — | 100% | Flushing #1 FieldFlushing #3 FieldSt. George Field |
ferry_direction | categorical | — | 100% | Staten Island BoundManhattan BoundN/Aof 3 |
ferry_terminal_name | categorical | — | 100% | UnknownSt. George Terminal (Sta…Whitehall Terminal (Manh…of 13 |
latitude | float | — | 8% | 40.7441520003032840.6437721569908440.6385706801265 |
longitude | float | — | 8% | -73.97834694751151-73.97388606641485-73.94900486982377 |
location | coordinate | — | — | — |