🔎 Connecticut Certified Suppliers

One record per CT certified small business (certification type, services, codes, DAS prequalification, employee-size band, dates, location) from the keyless CT Socrata resource. Certification and ownership labels are copied VERBATIM as published — the actor never infers an ownership or certification attribute.

Public, robots-honoured.

Output is one ct_certified_supplier row per result; billing is pay-per-event, the value event being one registry record (a $0.02 start fee per run, then $0.02 per registry record). Source: data.ct.gov.

No login, no API key and no CAPTCHA solving are involved: the source is read logged-out with an identified contact User-Agent.

📊 Sample Output

Real rows from run URIQR8qdNl6XUEjWF on build 0.1.4 (2026-09-18), the same input as the Quick start below — every value is as the source published it (emails masked, long text shortened):

vendor_name	business_address	class_description	woman_owned	race_gender_certification	disability_status
Promotional Solutions, LLC	3 Robertson Rd	No minority race/ethnicity identified	Woman-owned	Woman-owned, Race/ethnicity unidentified	Not disabled-owned
Project Clean, LLC	759 Capitol Ave	Black American	Woman-owned	Woman-owned, Race/ethnicity identified	Not disabled-owned
FirePro Integrated Systems LLC	480 Barnum Ave	Black American	Woman-owned	Woman-owned, Race/ethnicity identified	Not disabled-owned
Architx, LLC	5 Topsy Drive	No minority race/ethnicity identified	Woman-owned	Woman-owned, Race/ethnicity unidentified	Not disabled-owned
Heaven Electrical Contractor LLC	12 Clover Lane	Black American	Not Identified as Women-Owned	Not woman-owned, Race/ethnicity identified	Not disabled-owned
Reliable Refrigeration Plus, Inc.	280 Welton Street	No minority race/ethnicity identified	Not Identified as Women-Owned	Not woman-owned, Race/ethnicity unidentified	Not disabled-owned
Manchester Awning and Canvas Products, LLC	819 Middle Turnpike	No minority race/ethnicity identified	Not Identified as Women-Owned	Not woman-owned, Race/ethnicity unidentified	Disabled-owned
Jada Contracting, LLC	1881 park st	Hispanic American	Not Identified as Women-Owned	Not woman-owned, Race/ethnicity identified	Not disabled-owned

The run finished with the status message: NORMAL: 50 unique rows (0 duplicates collapsed). billable=50

✅ What you get

Each row is flat JSON with these fields (from the dataset schema and the sample run; a field the source does not publish for a given row is null):

• record_type (string) — e.g. ct_certified_supplier
• vendor_name (string/null) — e.g. Promotional Solutions, LLC
• business_address (string/null) — e.g. 3 Robertson Rd
• town (string/null) — e.g. Cromwell
• zip (string/null) — e.g. 06416
• county (string/null) — e.g. NA
• business_state (string/null) — e.g. CT
• certification_type (string/null) — e.g. MBE
• class_description (string/null) — e.g. No minority race/ethnicity identified
• woman_owned (string/null) — e.g. Woman-owned
• race_gender_certification (string/null) — e.g. Woman-owned, Race/ethnicity unidentified
• disability_status (string/null) — e.g. Not disabled-owned
• active_date (string/null) — e.g. 2023-09-08T00:00:00.000
• expiration_date (string/null) — e.g. 2024-03-08T00:00:00.000
• active_year (string/null) — e.g. 2023
• status (string/null) — e.g. Expired
• detail_page_link (string/null) — e.g. {'url': 'https://ct-gateway.formverse5.com/AUTOCENESERVER/WebApp/FillFormWO.aspx
• product (string/null) — e.g. promotionalsolutionsllc.netapparel, writing instruments, awards, gifts, folders,
• das_prequalified (string/null) — e.g. N
• business_structure (string/null) — e.g. General
• employee_count (string/null) — e.g. <50
• new_certification (string/null) — e.g. New certification
• gs_code (string/null) — e.g. 44-45
• goods_and_services (string/null) — e.g. Other
• source (string/null) — e.g. connecticut-certified-suppliers
• release_date (string/null) — null in every sample row
• source_url (string/null) — e.g. https://data.ct.gov/resource/y4ub-e4dd.json
• observed_at (string/null) — e.g. 2026-09-18T19:36:57Z
• terminal (string/integer/null) — null in every sample row
• reported_total (string/integer/null) — null in every sample row
• raw_seen (string/integer/null) — null in every sample row
• duplicates (string/integer/null) — null in every sample row
• unique_found (string/integer/null) — null in every sample row
• delivered (string/integer/null) — null in every sample row
• scope (string/integer/null) — null in every sample row
• note (string/integer/null) — null in every sample row
• license (string/integer/null) — null in every sample row
• attribution (string/integer/null) — null in every sample row

What you get

One registry_record per entity, deduplicated on the source-native id. Fields the source does not publish are honest null. A run_receipt row carries the source URL, scope, reconciliation counts, and delivered/duplicate totals.

⚙️ Sample inputs

1. Quick start — the Store example (this is what the sample above came from)

{
  "maxRecords": 50
}

The sample run charged exactly: 2 × $0.02 apify-actor-start + 50 × $0.02 registry_record = $1.04 on the Free tier — every delivered row was billed.

2. A smaller, narrowed run

{
  "maxRecords": 5
}

Caps the run at 5 rows — about $0.12 on the Free tier ($0.02 start + 5 × $0.02).

3. A full-size run

{
  "maxRecords": 5000
}

Up to 5000 rows (the schema default for maxRecords) — about $100.02 on the Free tier ($0.02 start + 5000 × $0.02) if the source has that many.

🧾 JSON sample record

One real record from run URIQR8qdNl6XUEjWF, exactly as it lands in the dataset (emails masked, long text shortened):

{
  "record_type": "ct_certified_supplier",
  "vendor_name": "Promotional Solutions, LLC",
  "business_address": "3 Robertson Rd",
  "town": "Cromwell",
  "zip": "06416",
  "county": "NA",
  "business_state": "CT",
  "certification_type": "MBE",
  "class_description": "No minority race/ethnicity identified",
  "woman_owned": "Woman-owned",
  "race_gender_certification": "Woman-owned, Race/ethnicity unidentified",
  "disability_status": "Not disabled-owned",
  "active_date": "2023-09-08T00:00:00.000",
  "expiration_date": "2024-03-08T00:00:00.000",
  "active_year": "2023",
  "status": "Expired",
  "detail_page_link": "{'url': 'https://ct-gateway.formverse5.com/AUTOCENESERVER/WebApp/FillFormWO.aspx?templateId=be7593ed-a2d5-481b-9bbd-8691262425cf&vendorId=6D81E0F5-B00B-425E-8ACF-9EDA334D36F3'}",
  "product": "promotionalsolutionsllc.netapparel, writing instruments, awards, gifts, folders, bags/totes, silkscreen, embroidery, hot stamping, portfolios, umbrellas, lapel pins, buttons, desk items, calendars, tee shirts, jackets, hats, lanyards, poste",
  "das_prequalified": "N",
  "business_structure": "General",
  "employee_count": "<50",
  "new_certification": "New certification",
  "gs_code": "44-45",
  "goods_and_services": "Other",
  "source": "connecticut-certified-suppliers",
  "release_date": null,
  "source_url": "https://data.ct.gov/resource/y4ub-e4dd.json",
  "observed_at": "2026-09-18T19:36:57Z"
}

🔧 How it works

Transport. Plain HTTPS from the Apify platform, no proxy. robots.txt is read first and a disallowed path is never fetched. Every request carries an identified contact User-Agent. Pacing: CRAWL_DELAY=0.0.

Charging. Each registry record is charged at the moment it is pushed (registry_record); a row that fails to charge is not delivered, so the dataset count always equals the charged count.

How it behaves

Rows are paged from the CT Socrata resource (:id order, $limit/$offset); optional statusFilter narrows the published status. Ownership/certification fields (woman_owned, race_gender, disability) are copied exactly as published; nulls preserved. Socrata count(*) reconciled; bounded to maxRecords.

Source

https://data.ct.gov/resource/y4ub-e4dd.json

What is not done. No login, no cookie or CAPTCHA bypass, no private or personal-account data, no browser automation.

💰 Pricing example

Event	Free	Bronze	Silver	Gold
Actor Start (apify-actor-start)	$0.02	$0.02	$0.02	$0.02
Registry Record (registry_record)	$0.02	$0.02	$0.02	$0.01

Worked at the live Free-tier price:

• 8 registry records: $0.02 start + 8 × $0.02 = $0.18
• 25 registry records: $0.02 start + 25 × $0.02 = $0.52
• 5000 registry records: $0.02 start + 5000 × $0.02 = $100.02

A run that delivers zero rows charges the $0.02 start fee only. A BLOCKED run (source refused) fails loud and charges no value event. The start fee is charged once per GB of run memory; the default run memory is 4096 MB.

Yield on the sample run: NORMAL: 50 unique rows (0 duplicates collapsed). billable=50. maxRecords is a hard ceiling on what is delivered and billed, never a target.

⚖️ Legal & ToS

This actor reads public, logged-out pages and feeds published by data.ct.gov. It collects only what the source publishes to any visitor, keeps to the source's robots rules (checked on every run), identifies itself with a contact User-Agent, and does not access accounts, private data or anything behind authentication. Use the output in line with the source's terms and your local law; the intended use is B2B research and monitoring.

❓ FAQ

Q: Do I need an API key or a login?
A: No. The source (data.ct.gov) is read logged-out; the input schema has no key field and the actor carries no secrets.

Q: Why did my run return 0 rows?
A: Read the run's status message. GENUINE_EMPTY means the source was read and had nothing in scope for your input; BLOCKED means the source refused and the run failed without billing a value event — retry later or narrow the input. A zero-row run bills the start fee only.

Q: How many rows can one run return?
A: Up to maxRecords (default 5000). Raise the cap for a bigger run; you pay per delivered row.

Q: How fresh is the data?
A: Every run reads the source live at run time; nothing is cached between runs. Put it on a schedule for a continuous feed.

Q: What formats can I export?
A: The dataset downloads as JSON, CSV, Excel, XML or RSS from the run's Dataset tab or the Apify API, and any run can push to a webhook or integration.

Q: How is this different from the other company registry checks actors?
A: Same output shape and billing model; this one covers data.ct.gov. The siblings under Related Actors cover the other sources or slices — run several on one schedule for a combined feed.

Q: Are there rate limits?
A: The actor paces itself against the source (CRAWL_DELAY=0.0) and honours its robots rules; there is no per-buyer limit beyond your Apify plan's concurrency.

🆘 Troubleshooting

• Run FAILED with BLOCKED → the source refused the request or changed its page shape → nothing was billed beyond the start fee; retry after a while, and if it persists open an Issue with the run id.
• Status says CAPPED → your cap (maxRecords) was reached → raise it for a bigger run.
• Input validation error on start → a field is outside the schema's allowed values → start from the Quick start block and change one field at a time.
• Run TIMED-OUT → a very wide request on a slow day → raise the run timeout in Run options or narrow the input; what was delivered before the timeout is still in the dataset.

🔗 Related Actors

• Connecticut Business Filing Events — One structured registryrecord per record from the official public source, logged-out. Public, robots-honoured
• Connecticut Business Registry (Master) — One structured registryrecord per record from the official public source, logged-out. Public, robots-honoured
• Connecticut Business Status Check — Check Connecticut business identities against the official state registry (data.ct.gov) — one official answer per identifier: registry status, regist…
• CQC Care Provider Directory — One structured registryrecord per record from the CQC weekly official 'CQC directory' CSV (~56,976 locations). Public, logged-out, robots-honoured
• CQC Provider Verification Check — Verify UK care providers and locations against the official CQC weekly directory — one present/absent verdict per identifier. Billed per PRESENT verd…
• EU EORI Customs Registration Check — Validates EORI numbers against the European Commission's official EORI service — one definitive registered / not-registered answer per identifier wit…
• 🏢 About NexGenData — NexGen Watch is NexGenData's fleet of 256 public monitoring and lookup actors built on official sources, pay-per-result. Browse the catalog at apify.com/nexgenwatch.

⭐ Found this useful?

If this actor saved you a manual check, a quick review on the Apify Store helps other teams find it. Feature request or a source that changed? Open it from the Issues tab — every one is read.