Use case
Brooklyn NY Licensed Home Improvement Contractors with Phone Numbers
Active New York home improvement contractor licences in Brooklyn, with phone, street address, licence number and expiry.
Say you sell windows and siding to contractors, and your company has just opened a showroom in Sunset Park. Your manager wants a call list of every licensed home improvement contractor with a Brooklyn address by the end of the week, with phone numbers, so the two new reps can start dialling on Monday. Any contractor doing home improvement work in New York City needs a DCWP licence, so the licence rolls are the closest thing to a complete list. On 2026-10-27, 3,020 active licences had a Brooklyn address.
The manual way, and what it costs
For NYC alone, the manual way is good. DCWP publishes its licences on NYC Open Data, and you can filter the dataset to Home Improvement Contractor, Active and city Brooklyn, then export a CSV for free. That gets you 2,862 rows. If that is your whole list, do it that way. What it misses is 158 firms with a Brooklyn address that hold a Nassau County or Westchester County licence instead (89 and 69 on 2026-10-27). Nassau’s report shows 15 vendors a page and Westchester’s map answers one ZIP code or city at a time, and neither exports in the NYC column layout, so adding them means a second and third pass and a merge.
The faster way
New York Contractor License Lookup & Leads Scraper does the same search once and hands back every row at once.
{
"status": "Active",
"city": "Brooklyn",
"maxResults": 500
}
status: Active drops the expired NYC licences, 5,429 of them citywide on 2026-10-27. city: Brooklyn matches the address on the licence across all four rosters, so the Nassau and Westchester firms come along without you asking for them. maxResults: 500 is a cheap first look at $2.00; set it to 3,020 for the whole list at $12.08.
What comes back
{
"listing_id": "0760935-DCA",
"name": "ALL TYPE SIDING & ROOFING INC.",
"phone": "7187456718",
"phone_e164": "+17187456718",
"street": "814 64TH ST",
"city": "BROOKLYN",
"region": "NY",
"postal_code": "11220",
"country": "US",
"category": "home improvement contractor",
"categories": [
"home improvement contractor"
],
"lat": 40.63289693131491,
"lng": -74.01136331221319,
"source": "snapshot",
"source_url": "https://data.cityofnewyork.us/resource/w7w3-xahh.json?license_nbr=0760935-DCA",
"extras": {
"locality": "nyc",
"status": "Active",
"expires": "2027-02-28",
"dba": "ROCCO'S ALL TYPE ROOFING",
"borough": "Brooklyn",
"licensed_since": "2003-02-04"
}
}
| Field | Example value | Meaning |
|---|---|---|
listing_id | 0760935-DCA | Licence number: NYC DCWP (e.g. 0760935-DCA) or Nassau (e.g. H3811010000); empty for Westchester and Buffalo, which issue none publicly |
name | ALL TYPE SIDING & ROOFING INC. | Company name |
extras.locality | — | Which roster the row came from: nyc, westchester, nassau or buffalo |
extras.status | — | Active, Expired, Surrendered, Suspended, … |
extras.expires | — | Licence expiry date (NYC, Westchester, Buffalo) |
phone | 7187456718 | Phone as the agency printed it |
For the reps, phone_e164 is the column that matters: 2,936 of the 3,020 Brooklyn licences have one, already in +1 format for a dialler. Every one of the 3,020 has a street address, so the showroom can sort the list by postal_code and start with 11220 and the ZIP codes around it. extras.dba is worth keeping too. 462 firms trade under a name other than the one on the licence, and that is the name they answer the phone with.
What you’d do with it
Export the dataset as CSV, split it by postal_code between the two reps, and import it into the CRM with listing_id as the external ID where there is one. When the next refresh lands, the licence number lets you match rows back without creating duplicates.
Worth knowing
This is a licence list, not a contact database. No locality publishes email, so there is none in the data. NYC’s own dataset was last updated by the city on 2026-08-20, so a contractor licensed since then is not in it yet. Westchester and Nassau firms come without the NYC map coordinates unless Westchester geocoded the address. And the list covers licences, not activity: an active licence says a contractor may work in New York City, not that they are busy in Brooklyn this month.
Run it yourself: How to run New York Contractor License Lookup & Leads Scraper walks the whole thing step by step.
If your territory also crosses into New Jersey, New Jersey Contractor License Lookup returns New Jersey’s registered home improvement contractors the same way.
Last updated 2026-10-27