From a 500-row sample across 29 columns.
industrycert_nbrbiz_name+21outcomect2020latitudebbl+5latitudebbllongitude+3Mappable — coordinate pair `y_coord` / `x_coord`.
Open on the map →| rec_id | cert_nbr | biz_name | vio_dt | industry | boro | chrg | chrg_ct | bldg_nbr | street | city | state |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 00005760-1-ENFO | 00005760 | LEE, SEONG BEOM | 2004-05-26T00:00:00.000 | Laundry Jobber - 066 | Queens | NYC Admin Code º 20-700 - ENGAGED IN DECEPTIVE PRACTICES | 2 | 4437 | KISSENA BLVD | FLUSHING | NY |
| 00006692-1-ENFO |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
rec_id | text | An identification number assigned by DCWP to record each charge against a business. For DCWP office tracking purposes. | 0% | 654-2014-LEGL671-2014-LEGLDD500135629-LEGL |
cert_nbr | text | An identification number assigned by DCWP to record each charge against a business. For DCWP office tracking purposes. Certificate number issued to the business upon inspection. Note that there may be multiple certificate numbers for a single inspection. | 0% | 500135629c047201400008713 |
biz_name | text | Primary Business Name. | 0% | DUANE READECENTRAL PARKING SYSTEM O…RITE AID OF NEW YORK, IN… |
vio_dt | datetime | Date when violation occurred. |
GET /api/datasets/wyj6-frpa GET /api/datasets/wyj6-frpa/quality GET /api/datasets/wyj6-frpa/related GET /api/columns?dataset=wyj6-frpa
citystatect2020+7street2citystate+6streetunitcity+8citystatelatitude+3| 00006692 |
| SWATCH GROUP INC. #262 |
| 2008-12-12T00:00:00.000 |
| Retail Store - 820 |
| Queens |
| NYC Admin Code º 20-700 - ENGAGED IN DECEPTIVE PRACTICES |
| 1 |
| 9015 |
| QUEENS BLVD |
| ELMHURST |
| NY |
| 00007014-1-ENFO | 00007014 | W & Z'S ASSOCIATES CORP. | 2008-03-04T00:00:00.000 | Cigarette Retail Dealer - 127 | Brooklyn | 6 RCNY º 3-10 - NO/IMPROPER DECLARATION OF COUNT | 1 | 2316 | NOSTRAND AVE | BROOKLYN | NY |
| 00007144-1-ENFO | 00007144 | VIP SHOE RESTORES INC | 2008-03-17T00:00:00.000 | Wearing Apparel - 450 | Manhattan | 6 RCNY º 5-32(b) - RECEIPT NOT IN COMPLIANCE | 1 | 135 | E 56TH ST | NEW YORK | NY |
| 00007918-1-ENFO | 00007918 | SH FINE HOMES & SERVICES LLC | 2009-02-04T00:00:00.000 | Tax Preparers - 891 | Queens | 6 RCNY º 5-66(c)(1)(i) - FAIL TO POST/IMPROPER FEE SIGN | 1 | 16701 | HILLSIDE AVE | JAMAICA | NY |
| 00007918-1-ENFO | 00007918 | SH FINE HOMES & SERVICES LLC | 2009-02-04T00:00:00.000 | Tax Preparers - 891 | Queens | 6 RCNY º 5-66(c)(1)(iii) - NO SIGN RE PREP/PAYER MUST SIGN RETURN | 1 | 16701 | HILLSIDE AVE | JAMAICA | NY |
| 00020118-1-ENFO | 00020118 | GOLDEN TOUCH UNISEX SALON | 2010-08-05T00:00:00.000 | Misc Non-Food Retail - 817 | Bronx | 6 RCNY º 5-70(a) - FAILED TO POST PRICE LIST | 1 | 3582 | WHITE PLAINS RD | BRONX | NY |
| 00020393-1-ENFO | 00020393 | BAH UPTOWN DISCOUNTS | 2010-08-24T00:00:00.000 | Misc Non-Food Retail - 817 | Bronx | 6 RCNY º 5-37 - NO/IMPROPER DISCLOSURE OF REFUND POLICY | 1 | 4729 | WHITE PLAINS RD | BRONX | NY |
| 00020550-1-ENFO | 00020550 | TOP MAGIC 99 | 2010-08-26T00:00:00.000 | Misc Non-Food Retail - 817 | Queens | NYC Admin Code º 20-700 - ENGAGED IN DECEPTIVE PRACTICES | 1 | 9114 | ROOSEVELT AVE | JACKSON HEIGHTS | NY |
| 00020695-1-ENFO | 00020695 | HALLA BACK | 2010-08-31T00:00:00.000 | Retail Store - 820 | Brooklyn | 6 RCNY º 5-70(a) - FAILED TO POST PRICE LIST | 1 | 313 | UTICA AVE | BROOKLYN | NY |
Showing 12 of 25 columns. All of them are listed below.
| 0% |
2007-07-05T00:00:00.0002011-11-02T00:00:00.0002011-04-12T00:00:00.000 |
industry | text | The category that describes the business. | 0% | Grocery-Retail - 808Cigarette Retail Dealer …Tobacco Retail Dealer |
boro | categorical | The borough where the business is located. | 3% | BrooklynManhattanQueensof 11 |
chrg | text | Charge description and legal code. | 0% | NYC Admin Code º 20-700 …NYC Admin Code º 17-706 …6 RCNY º 5-37 - NO/IMPRO… |
chrg_ct | integer | Number of charges of this type. | 1% | 123 |
outcome | categorical | Result after a charge has been adjudicated or settled based on the key. | 10% | PleadedDefault DecisionDecision (Conversion)of 10 |
ct_settl | integer | Number of charges settled or cured. | 43% | 123 |
ct_guilty | integer | Number of charges found guilty via decision. | 68% | 123 |
ct_not_glty | text | Number of charges found not guilty. | 98% | 1202 |
bldg_nbr | text | The building number of the business’s address. | 10% | 20012 |
street | text | The street name of the business’s address. | 9% | BROADWAY3RD AVEJAMAICA AVE |
street2 | text | The cross-street of the business’s address. | 99% | BROADWAY8 AVENUE6 AVENUE |
unit_typ | categorical | The unit type of the business’s address (e.g., Apartment/Suite/Other). | 98% | STEFRNTFLof 19 |
unit | integer | The unit number of the business’s address. | 99% | 123 |
descr | text | Additional description of the location of the business. | 97% | N/W/CS/E/CN/E/C |
city | text | The city where the business is located. | 0% | BROOKLYNNEW YORKBRONX |
state | text | The state where the business is located. | 0% | NYNJGA |
zip | text | The zip code where the business is located. | 0% | 112201120711226 |
x_coord | integer | X Coordinate of business’s address. | 9% | -7401019841 |
y_coord | integer | Y Coordinate of business’s address. | 9% | 410206663 |
latitude | float | Latitude of the business’s address. | 11% | 40.73384840.64832140.582305 |
longitude | float | Longitude of the business’s address. | 11% | -73.871578-73.788281-74.169053 |
community_board | integer | 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 Community District. Note: as a column header, “Community Board” ( | 11% | 105108412 |
council_district | integer | 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. | 11% | 314 |
bin | integer | The BIN (Building Identification Number) is 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. | 12% | 300000010000004000000 |
bbl | integer | The BBL (Borough, Block, and Lot) is 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. | 12% | 401860010041426000015024000180 |
ct2020 | integer | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note: as part of the geocoding process, leading and trailing zeros are dropped. | 11% | 412165 |
nta2020 | text | The Neighborhood Tabulation Area (Census 2020) 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 not definitiv | 11% | MN0502QN1201QN0401 |