From a 500-row sample across 39 columns.
school_zip:@computed_region_yeji_bk3qunique_key+58school_zip:@computed_region_yeji_bk3qunique_key+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 111 | 2004-04-02T00:00:00.000 | 2004-04-06T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Cabaret License | 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 | — | 0% | 574542767419902483755 |
created_date | datetime | — | 0% | 2004-12-20T00:00:00.0002004-12-21T00:00:00.0002004-12-28T00:00:00.000 |
closed_date | datetime | — | 1% | 2004-10-18T00:00:00.0002005-01-07T00:00:00.0002004-12-23T00:00:00.000 |
agency | categorical | — | 0% | HPDNYPDDEPof 15 |
GET /api/datasets/sqcr-6mww GET /api/datasets/sqcr-6mww/quality GET /api/datasets/sqcr-6mww/related GET /api/columns?dataset=sqcr-6mww
school_zip:@computed_region_yeji_bk3qunique_key+58school_zip:@computed_region_yeji_bk3qunique_key+58school_zip:@computed_region_yeji_bk3qunique_key+58:@computed_region_yeji_bk3qunique_keycross_street_2+37:@computed_region_yeji_bk3qunique_keycross_street_2+37:@computed_region_yeji_bk3qborough:@computed_region_f5dn_yrer+8| 112 | 2004-04-02T00:00:00.000 | 2004-04-06T00:00:00.000 | DCA | Department of Consumer Affairs | DCA / DOH New License Application Request | Day Auctioneer License | N/A | Closed | 0 Unspecified | Unspecified | Unspecified |
| 116 | 2004-04-06T00:00:00.000 | 2004-04-09T00:00:00.000 | DOT | Department of Transportation | Street Sign - Damaged | No Parking, Standing, Stopping | N/A | Closed | 02 STATEN ISLAND | STATEN ISLAND | Unspecified |
| 118 | 2004-04-06T00:00:00.000 | 2004-06-16T00:00:00.000 | TLC | Taxi and Limousine Commission | Taxi Complaint | Driver Complaint | N/A | Closed | 14 BROOKLYN | BROOKLYN | Unspecified |
| 141 | 2004-04-06T00:00:00.000 | 2004-04-06T00:00:00.000 | DOT | Department of Transportation | Street Condition | Plate Condition - Shifted | N/A | Closed | Unspecified BROOKLYN | BROOKLYN | Unspecified |
| 143 | 2004-04-06T00:00:00.000 | 2004-04-08T00:00:00.000 | DOT | Department of Transportation | Street Sign - Damaged | No Parking, Standing, Stopping | N/A | Closed | 05 BROOKLYN | BROOKLYN | Unspecified |
| 161 | 2004-09-01T00:00:00.000 | 2004-09-22T00:00:00.000 | DOT | Department of Transportation | Street Sign - Damaged | Stop | N/A | Closed | Unspecified STATEN ISLAND | STATEN ISLAND | Unspecified |
| 163 | 2004-04-06T00:00:00.000 | 2004-04-06T00:00:00.000 | DOT | Department of Transportation | Street Condition | Plate Condition - Shifted | N/A | Closed | Unspecified BROOKLYN | BROOKLYN | Unspecified |
| 948 | 2004-04-11T00:00:00.000 | 2007-02-06T00:00:00.000 | 3-1-1 | 311 Quality Assurance | Highway Condition | Dead Animal | N/A | Closed | Unspecified BRONX | BRONX | Unspecified |
| 952 | 2004-04-09T00:00:00.000 | 2004-04-10T00:00:00.000 | DOT | Department of Transportation | Street Condition | Plate Condition - Shifted | N/A | Closed | Unspecified STATEN ISLAND | STATEN ISLAND | Unspecified |
Showing 12 of 35 columns. All of them are listed below.
agency_name | text | — | 0% | Department of Housing Pr…New York City Police Dep…Department of Environmen… |
complaint_type | text | — | 0% | HEATINGSewerGENERAL CONSTRUCTION |
descriptor | text | — | 0% | N/AHEATNo Access |
location_type | text | — | 32% | RESIDENTIAL BUILDINGN/AStreet/Sidewalk |
incident_zip | text | — | 5% | 112261122111207 |
incident_address | text | — | 16% | 726 PROSPECT PLACE2913 FOSTER AVENUE34 HILLSIDE AVENUE |
street_name | text | — | 16% | BROADWAYGRAND CONCOURSEOCEAN AVENUE |
cross_street_1 | text | — | 17% | BENDBROADWAY3 AVENUE |
cross_street_2 | text | — | 17% | BROADWAYBEND7 AVENUE |
intersection_street_1 | text | — | 87% | BROADWAY2 AVENUE3 AVENUE |
intersection_street_2 | text | — | 87% | BROADWAY5 AVENUE1 AVENUE |
address_type | categorical | — | 3% | ADDRESSINTERSECTIONBLOCKFACEof 4 |
city | text | — | 5% | BROOKLYNNEW YORKBRONX |
landmark | text | — | 100% | LA GUARDIA AIRPORTJ F K AIRPORTCENTRAL PARK |
facility_type | categorical | — | 0% | N/APrecinctDSNY Garageof 6 |
status | categorical | — | 0% | ClosedPendingOpenof 7 |
due_date | datetime | — | 100% | 1900-01-02T00:00:00.0002006-04-12T00:00:00.0002007-04-26T00:00:00.000of 19 |
resolution_action_updated_date | datetime | — | 26% | 2004-10-18T00:00:00.0002005-01-07T00:00:00.0002004-12-22T00:00:00.000 |
community_board | text | — | 0% | 0 Unspecified12 QUEENS07 QUEENS |
borough | categorical | — | 0% | UnspecifiedBROOKLYNQUEENSof 6 |
x_coordinate_state_plane_ | integer | — | 6% | 997496998403998388 |
y_coordinate_state_plane_ | integer | — | 6% | 184990171929244888 |
park_facility_name | text | — | 0% | UnspecifiedSchool - Boys and Girls …School - JHS 98 Herman R… |
park_borough | categorical | — | 0% | UnspecifiedBROOKLYNQUEENSof 6 |
school_name | text | — | 0% | UnspecifiedSchool - Boys and Girls …School - JHS 98 Herman R… |
school_number | text | — | 0% | Unspecified455460 |
school_region | categorical | — | 0% | UnspecifiedRegion 2Region 5of 12 |
school_code | text | — | 0% | Unspecified16K45512X098 |
school_phone_number | text | — | 0% | UnspecifiedNA 0/07184671700 |
school_address | text | — | 0% | Unspecified1700 Fulton Street1619 Boston Road |
school_city | text | — | 0% | UnspecifiedBROOKLYNBRONX |
school_state | categorical | — | 0% | UnspecifiedNYof 2 |
school_zip | text | — | 0% | Unspecified1046011221 |
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 | categorical | — | 100% | Other - Please ValidateWilliamsburg BrBrooklyn Brof 19 |
bridge_highway_direction | categorical | — | 100% | N/BS/BE/Bof 8 |
road_ramp | text | — | 100% | — |
bridge_highway_segment | text | — | 100% | — |
garage_lot_name | text | — | 100% | — |
ferry_direction | categorical | — | 100% | Staten Island FerryStaten Island BoundManhattan Boundof 5 |
ferry_terminal_name | text | — | 100% | — |
latitude | float | — | 6% | 40.67442165986276640.638570680126540.861566680800784 |
longitude | float | — | 6% | -73.95224725551087-73.94900486982377-73.92960412921278 |
location | coordinate | — | — | — |