Ny Retail Food Stores Scraper

Collect licensed retail food store records across New York State. Retrieve business names, license numbers, store addresses, county information, square footage, and geographic coordinates. Export structured results in JSON, CSV, Excel, or other supported Apify dataset formats.

What It Does

This actor collects records from New York's Retail Food Stores dataset. It supports full dataset collection, keyword searches, custom filters, and dataset metadata retrieval.

Use the results for business research, lead generation, market analysis, and compliance-related workflows.

Available Modes

• All Rows: Collect records across the dataset.
• Full-Text Search: Find records matching a search term across searchable text fields.
• SoQL Filter: Apply custom conditions to narrow results, such as filtering by city or update date.
• Dataset Metadata: Retrieve available column names, data types, and descriptions.

Input Example

Collect all rows

{
  "mode": "all_rows",
  "maxItems": 50,
  "orderBy": ":id",
  "requestDelayMs": 500
}

Search for stores

{
  "mode": "search",
  "searchText": "inc",
  "maxItems": 25,
  "requestDelayMs": 500
}

Filter records

{
  "mode": "filter",
  "where": ":updated_at>'2020-01-01'",
  "maxItems": 25,
  "requestDelayMs": 500
}

Output Example

{
  "county": "ALBANY",
  "license_number": "722121",
  "operation_type": "Store",
  "estab_type": "AC",
  "entity_name": "1095 LOUDON INC",
  "dba_name": "BOGHT CORNERS MOBIL",
  "street_number": "1095",
  "street_name": "LOUDON ROAD",
  "city": "COHOES",
  "state": "NY",
  "zip_code": "12047",
  "square_footage": "3700",
  "georeference": {
    "type": "Point",
    "coordinates": [-73.74296, 42.78386]
  },
  "scraped_at": "2026-10-26T00:00:00+00:00"
}

Output Fields

Field	Description
county	County where the store is located
license_number	Retail food store license number
operation_type	Type of operation
estab_type	Establishment type code
entity_name	Registered business name
dba_name	Doing-business-as name
street_number	Street number
street_name	Street name
city	Store city
state	State abbreviation
zip_code	ZIP code
square_footage	Reported store square footage
georeference	Geographic point coordinates
scraped_at	Collection timestamp

Additional source fields are preserved in the output when available.

Use Cases

• Business Lead Generation: Build lists of licensed retail food stores across New York.
• Market Research: Analyze store locations by county, city, or ZIP code.
• Location Analysis: Use geographic coordinates to map retail food establishments.
• License Research: Organize license numbers and establishment classifications.
• Dataset Building: Export structured store records for reporting and further analysis.

FAQ

What information does this actor collect?

It collects business names, license numbers, addresses, county information, establishment types, square footage, and geographic coordinates when available.

Can I search for stores by business name?

Yes. Select Full-Text Search mode and provide a keyword through searchText.

Can I filter stores by city or county?

Yes. Select SoQL Filter mode and provide a condition through where, such as city='COHOES'.

Can I collect records from a specific county?

Yes. Use Filter mode with a suitable county condition to narrow the results.

Can I export the results to Excel or CSV?

Yes. Apify supports JSON, CSV, Excel, and other dataset export formats.

Can I schedule recurring collections?

Yes. Use Apify Schedules to refresh the dataset automatically at your preferred intervals.

Trademark Notice and Disclaimer

New York State Department of Agriculture and Markets and its related names, logos, and trademarks belong to their respective owners. This actor is an independent data collection tool and is not affiliated with, sponsored by, or endorsed by the department.

Is Web Scraping Legal?

This actor collects publicly accessible retail food store information without bypassing login screens, paywalls, or technical security measures. How collected information can be used depends on applicable laws and the source website's policies.

• Personal Data: Business records may contain names or other identifying details. Handle any personal information responsibly and follow applicable privacy laws, including GDPR or CCPA where relevant.
• Copyright and Licensing: Publicly accessible government datasets may still have applicable usage, licensing, and attribution requirements. Review the dataset's terms before reusing or redistributing collected information.
• Platform Terms and Rate Limits: Respect the source platform's policies, attribution requirements, and reasonable request intervals.
• Disclaimer: This information is general guidance, not legal advice. Consult a qualified legal professional if you have questions about your intended use.

Is web scraping legal?