Denied TW and Wholesale Market Companies

exsg-kpyaBusiness22 columns

Denied TW and Wholesale Market Companies dataset has a list of Trade Waste and Wholesale Market Companies that were denied to receive a license or a registration by Business Integrity Commission. This data is collected on the entities that apply with the commission to operate as licensees, registrants or wholesale market companies throughout the City of New York. Each record represents an entity that is denied or revoked to operate in the City of New York by the Commission. The Application Type field denotes the class of application. The Application Industry field indicates the industry an applicant wishes to operate a business within. The BIC Number field is unique to every company that applies to the Commission.

View on NYC Open Data

Quality

A90.1 / 100

From a 290-row sample across 22 columns.

completeness81/ 25% weight

consistency80/ 20% weight

accuracy95/ 20% weight

timeliness100/ 15% weight

usability100/ 20% weight

· Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

BIC Complaints Inquiries0.42
joins onboroughcensus_tractcommunity_board+8
Licensees and Registrants Fleet Information0.41
joins onexport_datebic_numberaccount_name
BIC Issued Violations0.40
joins oncensus_tractcommunity_boardlatitude+8
Small Business Services (SBS) Equal Employment Opportunity (EO 50) Certified Businesses0.40
joins onboroughcitycommunity_board+8

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

bic_number	account_name	trade_name	application_type	application_industry	application_status	application_status_date	street	city	state	postcode	renewal_application
BIC-2170	CIRCLE INTERIOR DEMOLITION, INC.	CIRCLE INTERIOR DEMOLITION, INC.	CL2 - Exempt	Trade Waste	Denied	2007-05-08T00:00:00.000	56-00 GRAND AVENUE	MASPETH	NY	11378-	False

Columns

22 queryable · 22 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`bic_number`	text	—	0%	`BIC-82BIC-1994BIC-103`
`account_name`	text	—	0%	`DECOSTOLE CARTING, INC.RMR CARTING CO. INCPEBBLE ROCK, LTD.`
`trade_name`	text	—	28%	`ANCAR TRUCKING CORP.HARMAN CONTRACTING INC.EARLY MORNING SEAFOOD`
`application_type`	categorical	—	0%	`CL2 - ExemptLicensePublic Wholesale Market`

Query this from your own app

GET /api/datasets/exsg-kpya
GET /api/datasets/exsg-kpya/quality
GET /api/datasets/exsg-kpya/related
GET /api/columns?dataset=exsg-kpya