Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Historical Licenses

m4ph-grrmBusiness27 columns
This dataset features businesses and individuals that were issued a DCWP license and the status of those licenses as of October 2013. A license is required to legally operate in New York City.
View on NYC Open Data↗

Quality

C78.9 / 100

From a 500-row sample across 27 columns.

completeness86/ 25% weight
consistency72/ 20% weight
accuracy95/ 20% weight
timeliness26/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Historical License Applications0.56
    joins onbincommunity_boardnta2020+8
  • Issued Licenses0.47
    joins onbinaddress_buildingaddress_zip+12
  • License Applications0.43
    joins onbincommunity_boardbusiness_name+6
  • Archived DCWP Charges0.42
    joins onbincommunity_board

Geography

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

Open on the map →

Sample rows

dca_license_numberlicense_typelicense_creation_datelicense_expiration_datelicense_statuslicense_status_datebusiness_codebusiness_code_descriptionbusiness_nameaddress_buildingaddress_street_nameaddress_city
711Business1999-05-25T00:00:00.0002007-07-31T00:00:00.000FAILED TO RENEW2007-11-05T00:00:00.0006SECOND HAND DEALER GENERALM LEVIN INC269BOWERY

Columns

27 queryable · 27 profiled

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

FieldTypeDescriptionNullValues
dca_license_numberintegerAn identification number issued to businesses/individuals to operate legally for the duration of their license term.0%429844811831675660
license_typecategoricalIndicates whether the licensee is a business or an individual.0%BusinessIndividualof 2
license_creation_datedatetimeThe date the license record was created.0%2000-12-05T00:00:00.0002000-12-06T00:00:00.0002001-01-05T00:00:00.000
license_expiration_datedatetimeExpiration date of the License as of the last time the license was updated in the system.0%

Query this from your own app

GET /api/datasets/m4ph-grrm
GET /api/datasets/m4ph-grrm/quality
GET /api/datasets/m4ph-grrm/related
GET /api/columns?dataset=m4ph-grrm
nta2020
+5
  • DCWP Payments Received0.38
    joins onbusiness_name
  • DCWP Consumer Complaints0.36
    joins onbincommunity_boardbusiness_name+5
  • Archived DCWP Inspections0.36
    joins onbincommunity_boardnta2020+5
  • DCWP Charges0.35
    joins onbusiness_name
    • NEW YORK
    2902Business1992-05-06T00:00:00.0001993-04-30T00:00:00.000OUT OF BUSINESS1993-04-30T00:00:00.00080PAWNBROKERGEM PAWNBROKERS MANHATTAN CORP6088 AVENUENEW YORK
    2902Business2007-04-18T00:00:00.0002014-04-30T00:00:00.000CURRENT2013-02-27T00:00:00.00080PAWNBROKERGEM FINANCIAL SERVICES INC6088 AVENUENEW YORK
    6164Business1999-02-11T00:00:00.0002002-03-31T00:00:00.000FAILED TO RENEW2002-05-30T00:00:00.00024NEWSSTANDSACKLER, ADELAIDEN/W/C3 AVENUENEW YORK
    6840Business2007-11-02T00:00:00.0002015-07-31T00:00:00.000CURRENT2013-06-04T00:00:00.0006SECOND HAND DEALER GENERALFLORIAN PAPP INC962MADISON AVENUENEW YORK
    10636Business1989-03-22T00:00:00.0001994-03-31T00:00:00.000REPEALED LICENSE1999-08-12T00:00:00.00024NEWSSTANDCOLACIELLO, PHILIPS/E/C6 AVENUEMANHATTAN
    10669Business2002-03-25T00:00:00.0002014-03-31T00:00:00.000CURRENT2012-02-29T00:00:00.00024NEWSSTANDSAYYED, IQBALS/E/CBROADWAYNEW YORK
    10699Business2002-05-14T00:00:00.0002014-03-31T00:00:00.000CURRENT2012-02-21T00:00:00.00024NEWSSTANDKALOGIANNAKIS, MARINOSS/E/CST NICHOLAS AVENEW YORK
    10711Business1999-01-28T00:00:00.0002012-03-31T00:00:00.000OUT OF BUSINESS2011-06-23T00:00:00.00024NEWSSTANDTITEN, MARVINS/W/CEAST 28 STREETNEW YORK
    10723Business1999-04-01T00:00:00.0002006-03-31T00:00:00.000OUT OF BUSINESS2006-05-02T00:00:00.00024NEWSSTANDEDWARDS, THOMASN/E/CBROADWAYNEW YORK

    Showing 12 of 27 columns. All of them are listed below.

    2015-02-28T00:00:00.0002013-12-31T00:00:00.0002014-12-31T00:00:00.000
    license_statustextThis indicates the status of the license as of the license status date.0%CURRENTFAILED TO RENEWOUT OF BUSINESS
    license_status_datedatetimeThe date the license status was last updated in the system.0%2013-07-09T00:00:00.0002013-08-29T00:00:00.0002011-12-30T00:00:00.000
    business_codetextThe code associated with the business category or business activity requiring a DCA-issued license in order to operate leally.0%127101100
    business_code_descriptiontextThe business category or business activity requiring a DCA-issued license in order to operate legally.0%CIGARETTE RETAIL DEALERHOME IMPROVEMENT SALESPE…HOME IMPROVEMENT CONT…
    business_nametextThe legal business name as filed with the New York State Secretary of State or County Clerk or, if an individual, the person’s last name and first name.0%DUANE READERADIOSHACK CORPORATIONDUANE READE ETAL PTRS
    business_name2textIf applicable, the Doing-Business-As (DBA), or trade name.81%T-MOBILEVERIZON WIRELESSHUDSON NEWS
    address_buildingtextBuilding number of the business's premise address.33%2001N/W/C
    address_street_nametextStreet name where the business is located.33%BROADWAY3 AVENUEJAMAICA AVENUE
    secondary_address_streettextThe secondary cross street of the business's location.89%1ST FLOOR2ND FLOOR1 FL
    address_citytextCity where the business is located. If an individual license, the City of the licensee's mailing address.0%BROOKLYNNEW YORKBRONX
    address_statetextState where the business is located. If an individual license, the State of the licensee's mailing address.0%NYNJCT
    address_ziptextPostcode where the business is located. If an individual license, the postcode of the licensee's mailing address.1%113851121411220
    contact_phone_numbertextThe phone number of the business.33%999999999971899999992126869800
    borough_codetextBorough Code of the Borough where the business is located.0%341
    community_boardintegerThe Community District where the business is located.15%105407401
    council_districtintegerThe City Council District where the business is located.58%3126
    boroughcategoricalBorough in which the building is located40%BROOKLYNQUEENSMANHATTANof 5
    latitudefloatLatitude of the building's location40%40.57543340.75822740.586814
    longitudefloatLongitude of the building's location40%-73.978006-73.966066-74.092734
    binintegerThe BIN (Building Identification Number) is a unique identifier for each building in the City41%400000030000001000000
    bblintegerThe BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City41%308696021210134800494142600001
    ct2020integerhe Census Tract (Census 2020) field indicates the U.S. Census Tract where the building is located.40%9641138
    nta2020textThe Neighborhood Tabulation Area (Census 2020) field indicates the New York City Neighborhood area where the building is located40%MN0502MN0501QN1201