From a 500-row sample across 44 columns.
ferry_terminal_namelongitudeschool_zip+58ferry_terminal_namelongitudeschool_zip+58Mappable — Socrata point column `location`.
Open on the map →| unique_key | created_date | closed_date | agency | agency_name | complaint_type | descriptor | facility_type | status | due_date | resolution_action_updated_date | community_board |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 22665 | 2006-08-23T00:00:00.000 | 2006-08-23T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Sidewalk Cafe License | N/A | Closed | 2006-08-30T00:00:00.000 | 2006-08-23T00:00:00.000 | 0 Unspecified |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_key | text | — | 0% | 100001410000181000039 |
created_date | datetime | — | 0% | 2006-10-24T00:00:00.0002006-02-13T00:00:00.0002006-07-18T00:00:00.000 |
closed_date | datetime | — | 2% | 2008-06-30T00:00:00.0002009-05-29T00:00:00.0002006-07-17T00:00:00.000 |
agency | categorical | — | 0% | HPDDOTDEPof 14 |
GET /api/datasets/hy4q-igkk GET /api/datasets/hy4q-igkk/quality GET /api/datasets/hy4q-igkk/related GET /api/columns?dataset=hy4q-igkk
ferry_terminal_namelongitudeschool_zip+58ferry_terminal_namelongitudeschool_zip+58ferry_terminal_namelongitudeschool_zip+58longitudefacility_typebridge_highway_direction+37longitudefacility_typebridge_highway_direction+37longitudecreated_datelatitude+8| 218 | 2006-09-18T00:00:00.000 | 2006-09-18T00:00:00.000 | DOT | Department of Transportation | Ferry Inquiry | Lost and Found | N/A | Closed | 2006-10-18T00:00:00.000 | 2006-09-18T00:00:00.000 | 0 Unspecified |
| 220 | 2006-09-18T00:00:00.000 | 2006-09-26T00:00:00.000 | DPR | Department of Parks and Recreation | Maintenance or Facility | Unsecured Facility | N/A | Closed | 2006-09-21T00:00:00.000 | 2006-09-26T00:00:00.000 | 14 QUEENS |
| 2355 | 2006-09-18T00:00:00.000 | 2006-09-18T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Day Auctioneer License | N/A | Closed | 2006-09-25T00:00:00.000 | 2006-09-18T00:00:00.000 | 0 Unspecified |
| 8638 | 2006-08-29T00:00:00.000 | 2006-09-14T00:00:00.000 | DCA | Department of Consumer Affairs | Consumer Complaint | Harassment | N/A | Closed | 2006-09-14T00:00:00.000 | 2006-08-30T00:00:00.000 | 0 Unspecified |
| 13582 | 2006-08-23T00:00:00.000 | 2006-08-23T00:00:00.000 | DPR | Department of Parks and Recreation | Overgrown Tree/Branches | Regular/Routine Pruning | N/A | Closed | 2006-08-30T00:00:00.000 | — | Unspecified BROOKLYN |
| 13383 | 2006-08-23T00:00:00.000 | 2006-08-23T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Cabaret License | N/A | Closed | 2006-08-30T00:00:00.000 | 2006-08-23T00:00:00.000 | 0 Unspecified |
| 13384 | 2006-08-23T00:00:00.000 | 2006-08-23T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Sidewalk Cafe License | N/A | Closed | 2006-08-30T00:00:00.000 | 2006-08-23T00:00:00.000 | 0 Unspecified |
| 29831 | 2006-07-27T00:00:00.000 | 2006-07-27T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Sidewalk Cafe License | N/A | Closed | 2006-08-03T00:00:00.000 | 2006-07-27T00:00:00.000 | 0 Unspecified |
| 32593 | 2006-07-27T00:00:00.000 | 2006-07-27T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Dealer in Devices for Disabled License | N/A | Closed | 2006-08-03T00:00:00.000 | 2006-07-27T00:00:00.000 | 0 Unspecified |
Showing 12 of 33 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 OutN/A |
location_type | text | — | 36% | RESIDENTIAL BUILDINGStreetStreet/Sidewalk |
incident_zip | text | — | 8% | 112261122110467 |
incident_address | text | — | 23% | 1055 DR M L KING JR BOUL…223 EAST 32 STREET2913 FOSTER AVENUE |
street_name | text | — | 23% | BROADWAYGRAND CONCOURSEOCEAN AVENUE |
cross_street_1 | text | — | 23% | BENDBROADWAY3 AVENUE |
cross_street_2 | text | — | 23% | BROADWAYBEND7 AVENUE |
intersection_street_1 | text | — | 79% | BROADWAY3 AVENORTHERN BOULEVARD |
intersection_street_2 | text | — | 79% | BROADWAY5 AVENUE3 AVENUE |
address_type | categorical | — | 2% | 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% | ClosedPendingOpenof 8 |
due_date | datetime | — | 86% | 2006-09-17T00:00:00.0002006-09-10T00:00:00.0002006-08-13T00:00:00.000 |
resolution_action_updated_date | datetime | — | 9% | 2008-06-30T00:00:00.0002009-05-29T00:00:00.0002006-11-27T00:00:00.000 |
community_board | text | — | 0% | 0 UnspecifiedUnspecified MANHATTAN12 QUEENS |
borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
x_coordinate_state_plane_ | integer | — | 8% | 1003546990250998403 |
y_coordinate_state_plane_ | integer | — | 8% | 243380210392171929 |
park_facility_name | text | — | 0% | UnspecifiedSchool - JHS 223 The Mon…School - Boys and Girls … |
park_borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
school_name | text | — | 0% | UnspecifiedSchool - JHS 223 The Mon…School - Boys and Girls … |
school_number | text | — | 0% | Unspecified455223 |
school_region | categorical | — | 0% | UnspecifiedRegion 7Region 2of 13 |
school_code | text | — | 0% | Unspecified20K22316K455 |
school_phone_number | text | — | 0% | UnspecifiedNA 0/07184380155 |
school_address | text | — | 0% | Unspecified4200 16 Avenue1700 Fulton Street |
school_city | text | — | 0% | UnspecifiedBROOKLYNBRONX |
school_state | categorical | — | 0% | UnspecifiedNYof 2 |
school_zip | text | — | 0% | Unspecified1045611204 |
school_not_found | categorical | — | 100% | NYof 2 |
school_or_citywide_complaint | categorical | — | 100% | N/ASchoolCitywide Complaintof 3 |
vehicle_type | text | — | 100% | — |
taxi_company_borough | text | — | 100% | — |
taxi_pick_up_location | categorical | — | 99% | OtherIntersectionJFK Airportof 7 |
bridge_highway_name | text | — | 100% | BQE/Gowanus ExpwyBelt PkwyGrand Central Pkwy |
bridge_highway_direction | text | — | 100% | North BoundWest/Staten Island BoundEast/Queens Bound |
road_ramp | categorical | — | 100% | RoadwayRampN/Aof 3 |
bridge_highway_segment | text | — | 100% | RoadwayRampN/A |
garage_lot_name | text | — | 100% | St. George FieldFlushing #1 FieldFlushing #2 Field |
ferry_direction | categorical | — | 100% | Staten Island BoundManhattan BoundN/Aof 4 |
ferry_terminal_name | categorical | — | 100% | UnknownSt. George Terminal (Sta…Whitehall Terminal (Manh…of 12 |
latitude | float | — | 8% | 40.83467614925315640.7441520003032840.6385706801265 |
longitude | float | — | 8% | -73.93026902903412-73.97834694751151-73.94900486982377 |
location | coordinate | — | — | — |