From a 500-row sample across 48 columns.
taxi_company_boroughferry_terminal_namelocation_zip+58taxi_company_boroughferry_terminal_namelocation_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 | community_board | borough | park_facility_name |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 33827 | 2005-01-04T00:00:00.000 | 2005-01-12T00:00:00.000 | TLC | Correspondence - Taxi and Limousine Commission | Taxi Compliment | Driver Compliment | N/A | Closed | 0 Unspecified | Unspecified | Unspecified |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_key | text | Unique identifier of a Service Request (SR) in the open data set. This is NOT the Service Request (SR) # provided to the initiating customer. SR #s are not available in this data set. | 0% | 468880434385187746416 |
created_date | datetime | Date SR was created | 0% | 2005-10-25T00:00:00.0002005-01-18T00:00:00.0002005-10-24T00:00:00.000 |
closed_date | datetime | Date SR was closed by responding agency | 1% | 2005-10-31T00:00:00.0002005-11-14T00:00:00.0002009-05-29T00:00:00.000 |
agency | categorical | Acronym of responding City Government Agency | 0% |
GET /api/datasets/sxmw-f24h GET /api/datasets/sxmw-f24h/quality GET /api/datasets/sxmw-f24h/related GET /api/columns?dataset=sxmw-f24h
taxi_company_boroughferry_terminal_namelocation_zip+58taxi_company_boroughferry_terminal_namelocation_zip+58taxi_company_boroughferry_terminal_namelocation_zip+58taxi_company_boroughaddress_typeclosed_date+37taxi_company_boroughaddress_typeclosed_date+37boroughcommunity_board:@computed_region_yeji_bk3q+8| 33840 | 2005-01-03T00:00:00.000 | 2005-01-03T00:00:00.000 | DPR | Department of Parks and Recreation | Animal in a Park | Domestic Strays | N/A | Closed | 10 MANHATTAN | MANHATTAN | Unspecified |
| 33845 | 2005-01-04T00:00:00.000 | 2005-01-07T00:00:00.000 | DPR | Department of Parks and Recreation | Maintenance or Facility | Graffiti or Vandalism | N/A | Closed | 06 BROOKLYN | BROOKLYN | Unspecified |
| 33846 | 2005-01-04T00:00:00.000 | 2005-01-07T00:00:00.000 | DPR | Department of Parks and Recreation | Maintenance or Facility | Graffiti or Vandalism | N/A | Closed | 16 BROOKLYN | BROOKLYN | Unspecified |
| 34152 | 2005-01-04T00:00:00.000 | 2005-01-04T00:00:00.000 | DOT | Department of Transportation | Highway Condition | Dead Animal | N/A | Closed | Unspecified MANHATTAN | MANHATTAN | Unspecified |
| 34142 | 2005-01-01T00:00:00.000 | 2005-01-01T00:00:00.000 | DPR | Department of Parks and Recreation | Maintenance or Facility | Graffiti or Vandalism | N/A | Closed | 07 MANHATTAN | MANHATTAN | Unspecified |
| 34150 | 2005-01-04T00:00:00.000 | 2005-01-19T00:00:00.000 | DOT | Department of Transportation | Ferry Inquiry | Lost and Found | N/A | Closed | 0 Unspecified | Unspecified | Unspecified |
| 34163 | 2005-01-04T00:00:00.000 | 2005-01-04T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Debt Collection Agency License | N/A | Closed | 0 Unspecified | Unspecified | Unspecified |
| 35687 | 2005-01-19T00:00:00.000 | 2005-01-20T00:00:00.000 | TLC | Correspondence - Taxi and Limousine Commission | Taxi Compliment | Driver Compliment | N/A | Closed | 0 Unspecified | Unspecified | Unspecified |
| 35690 | 2005-01-19T00:00:00.000 | 2005-01-25T00:00:00.000 | DOT | Department of Transportation | Street Sign - Damaged | Stop | N/A | Closed | Unspecified BROOKLYN | BROOKLYN | Unspecified |
Showing 12 of 29 columns. All of them are listed below.
HPDDEPDOTof 15 |
agency_name | text | Full Agency name of responding City Government Agency | 0% | Department of Housing Pr…Department of Environmen…Department of Transporta… |
complaint_type | text | This is the fist level of a hierarchy identifying the topic of the incident or condition. Complaint Type may have a corresponding Descriptor (below) or may stand alone. | 0% | HEATINGStreet Light ConditionGENERAL CONSTRUCTION |
descriptor | text | This is associated to the Complaint Type, and provides further detail on the incident or condition. Descriptor values are dependent on the Complaint Type, and are not always required in SR. | 0% | HEATN/AStreet Light Out |
location_type | text | Describes the type of location used in the address information | 34% | RESIDENTIAL BUILDINGN/ASidewalk |
incident_zip | text | Incident location zip code, provided by geo validation. | 6% | 112261045711221 |
incident_address | text | House number of incident address provided by submitter. | 18% | 223 EAST 32 STREET2913 FOSTER AVENUE726 PROSPECT PLACE |
street_name | text | Street name of incident address provided by the submitter | 18% | BROADWAYGRAND CONCOURSEOCEAN AVENUE |
cross_street_1 | text | First Cross street based on the geo validated incident location | 18% | BENDBROADWAYAMSTERDAM AVENUE |
cross_street_2 | text | Second Cross Street based on the geo validated incident location | 18% | BROADWAYBENDNOSTRAND AVENUE |
intersection_street_1 | text | First intersecting street based on geo validated incident location | 84% | BROADWAY5 AVENUE3 AVENUE |
intersection_street_2 | text | Second intersecting street based on geo validated incident location | 84% | BROADWAY5 AVENUE1 AVENUE |
address_type | categorical | Type of incident location information available. | 2% | ADDRESSINTERSECTIONBLOCKFACEof 4 |
city | text | City of the incident location provided by geovalidation. | 6% | BROOKLYNNEW YORKBRONX |
landmark | text | If the incident location is identified as a Landmark the name of the landmark will display here | 100% | J F K AIRPORTLA GUARDIA AIRPORTCENTRAL PARK |
facility_type | categorical | If available, this field describes the type of city facility associated to the SR | 0% | N/APrecinctDSNY Garageof 6 |
status | categorical | — | 0% | ClosedPendingOpenof 9 |
due_date | datetime | — | 100% | 2006-06-15T00:00:00.0001900-01-02T00:00:00.0002006-03-03T00:00:00.000 |
resolution_action_updated_date | datetime | — | 18% | 2005-10-31T00:00:00.0002009-05-29T00:00:00.0002005-11-14T00:00:00.000 |
community_board | text | — | 0% | 0 Unspecified12 QUEENS13 QUEENS |
borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
x_coordinate_state_plane_ | integer | — | 7% | 990250998403997496 |
y_coordinate_state_plane_ | integer | — | 7% | 210392171929184990 |
park_facility_name | text | — | 0% | UnspecifiedSchool - Boys and Girls …Closed School - Powell M… |
park_borough | categorical | — | 0% | UnspecifiedQUEENSBROOKLYNof 6 |
school_name | text | — | 0% | UnspecifiedSchool - Boys and Girls …Closed School - Powell M… |
school_number | text | — | 0% | Unspecified455435 |
school_region | categorical | — | 0% | UnspecifiedRegion 2Region 5of 13 |
school_code | text | — | 0% | Unspecified16K45505M172 |
school_phone_number | text | — | 0% | UnspecifiedNA 0/07184671700 |
school_address | text | — | 0% | Unspecified1700 Fulton Street509 West 129 Street |
school_city | text | — | 0% | UnspecifiedBROOKLYNBRONX |
school_state | categorical | — | 0% | UnspecifiedNYof 2 |
school_zip | text | — | 0% | Unspecified1045611221 |
school_not_found | text | — | 100% | — |
school_or_citywide_complaint | text | — | 100% | N/Aof 1 |
vehicle_type | text | — | 100% | — |
taxi_company_borough | text | — | 100% | — |
taxi_pick_up_location | text | — | 99% | Otherof 1 |
bridge_highway_name | text | — | 100% | Queensboro/59th St BrBrooklyn BrOther Bridge in Queens |
bridge_highway_direction | categorical | — | 100% | North BoundSouth BoundEast Boundof 4 |
road_ramp | text | — | 100% | — |
bridge_highway_segment | text | — | 100% | — |
garage_lot_name | text | — | 100% | — |
ferry_direction | categorical | — | 100% | Manhattan BoundStaten Island BoundNone Neededof 3 |
ferry_terminal_name | text | — | 100% | — |
latitude | float | — | 7% | 40.7441520003032840.638570680126540.834676149253156 |
longitude | float | — | 7% | -73.97834694751151-73.94900486982377-73.93026902903412 |
location | coordinate | — | — | — |