From a 500-row sample across 23 columns.
inspection_typeinspection_datecensus_tract+5ntabinbblfacility_namecensus_tractnta+4census_tractntabin+3Mappable — coordinate pair `lat` / `long`.
Open on the map →| permit_type | accela | facility_name | address_no | address_st | bo | zip | inspection_date | inspection_type | of_all_violations | of_phh_violations | of_critical_violations |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Indoor | 41576475 | SPA 88 LLC | 88 | FULTON STREET | MA | 10038 | 2019-01-02T00:00:00.000 | Routine Inspection | 6 | 3 | 3 |
| Indoor |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permit_type | categorical | Type of permit for the pool: indooor for indoor pool and outdoor for outdoor pool | 0% | IndoorOutdoorof 2 |
accela | text | Permit number | 0% | 500335444075003641365725 |
facility_name | text | Name of the facility operating the permit | 0% | TOWN SPORTS INTERNATIONA…YMCA OF GREATER NEW YORKCRUNCH LLC |
address_no | text | Building number for the facility location | 0% | 1200250 |
GET /api/datasets/3kfa-rvez GET /api/datasets/3kfa-rvez/quality GET /api/datasets/3kfa-rvez/related GET /api/columns?dataset=3kfa-rvez
zipinspection_datecensus_tract+5census_tractntabin+3census_tractntabin+3| 50052652 |
| WEST 30TH HL LLC |
| 520 |
| WEST 30 STREET |
| MA |
| 10001 |
| 2019-01-02T00:00:00.000 |
| Routine Inspection |
| 1 |
| 0 |
| 0 |
| Indoor | 50039431 | XSPORT FITNESS | 200 | BAYCHESTER AVENUE | BX | 10475 | 2019-01-02T00:00:00.000 | Complaint Re-inspection | 0 | 0 | 0 |
| Indoor | 50064867 | ALBERT EINSTEIN COLLEGE OF MEDICINE INC | 1300 | MORRIS PARK AVENUE | BX | 10461 | 2019-01-02T00:00:00.000 | Routine Inspection | 1 | 0 | 0 |
| Indoor | 40425690 | NYC BD OF ED/JOHN ADAMS HIGH SCHOOL | 101-01 | ROCKAWAY BOULEVARD | QU | 11471 | 2019-01-02T00:00:00.000 | Re-Inspection | 1 | 0 | 1 |
| Indoor | 41109531 | JEWISH COMMUNITY CENTER OF STATEN ISLAND INC | 1466 | MANOR ROAD | SI | 10314 | 2019-01-02T00:00:00.000 | Routine Inspection | 2 | 0 | 1 |
| Indoor | 50004851 | FITNESS INTERNATIONAL LLC | 3231 | RICHMOND AVENUE | SI | 10312 | 2019-01-02T00:00:00.000 | Routine Inspection | 3 | 0 | 2 |
| Indoor | 41412914 | 111 FULTON STREET CONDOMINIUM | 111 | FULTON STREET | MA | 10038 | 2019-01-03T00:00:00.000 | Re-Inspection | 0 | 0 | 0 |
| Indoor | 50060208 | THE RESIDENTIAL SECTION OF 140 WEST STREET CONDOMINIUM | 100 | BARCLAY STREET | MA | 10007 | 2019-01-03T00:00:00.000 | Routine Inspection | 1 | 0 | 0 |
| Indoor | 40839641 | EQUINOX GREENWICH AVE INC | 97 | GREENWICH AVENUE | MA | 10014 | 2019-01-03T00:00:00.000 | Complaint Inspection | 0 | 0 | 0 |
Showing 12 of 23 columns. All of them are listed below.
address_st | text | Street name for the facility location | 0% | BROADWAYPARK AVENUEQUEENS BOULEVARD |
bo | categorical | Borough of facility location | 0% | MABKQUof 5 |
zip | text | Zip code of facility location | 0% | 100191001610023 |
inspection_date | datetime | Date of inspection | 0% | 2019-08-27T00:00:00.0002019-08-20T00:00:00.0002025-08-13T00:00:00.000 |
inspection_type | categorical | "Type of inspection: - Complaint Inspection - Complaint Re-Inspection - Investigation - Re-Inspection - Routine Inspection" | 0% | Routine InspectionRe-InspectionComplaint Inspectionof 8 |
of_all_violations | categorical | Total number of violations during this inspection | 0% | 012of 13 |
of_phh_violations | categorical | Number of public health hazard violations during this inspection | 27% | 012of 6 |
of_critical_violations | categorical | Number of critical violations during this inspection | 27% | 012of 6 |
of_general_violations | categorical | Number of general violations during this inspection | 27% | 012of 7 |
docket | text | A unique identifier for the summons | 83% | 03221-21S000324-19S000038-19S0 |
lat | float | Latitude | 0% | 40.67301340.787540.757426 |
long | float | Longitude | 0% | -73.857779-73.837352-73.978465 |
community_board | text | Community Board of the location of the bathing establishment. Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Commu | 2% | 105108101 |
council_district | text | NYC Council District of the location of the bathing establishment. The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. To find your own Council District, go here. | 2% | 040301 |
census_tract | text | The Census Tract of the location of the bathing establishment | 2% | 003300002100009900 |
bbl | text | Borough Block Lot (BBL): A combination of three numeric codes -- a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) -- designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 5% | 101373000140401100244113580001 |
bin | text | Building Identification Number (BIN): A unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 5% | 100000040972834541230 |
nta | text | NTA name of the location of the bathing establishment. NTAs are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area.. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do | 67% | Midtown-Midtown SouthTurtle Bay-East MidtownLincoln Square |
nta_code | text | NTA code of the location of the bathing establishment. NTAs are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area.. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do | 2% | MN17MN13MN19 |