Multi-State Childcare Licensing + Inspections avatar

Multi-State Childcare Licensing + Inspections

Pricing

Pay per usage

Go to Apify Store
Multi-State Childcare Licensing + Inspections

Multi-State Childcare Licensing + Inspections

Licensed childcare facilities across NY, NJ, CO, CT and DE in one unified schema — name, type, address, county, capacity, license status — plus the compliance record where the state publishes it: inspection counts (CT, DE) and cited-deficiency detail (DE).

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Bryan

Bryan

Maintained by Community

Actor stats

0

Bookmarked

1

Total users

0

Monthly active users

2 days ago

Last modified

Share

Every licensed childcare facility across five states — New York, New Jersey, Colorado, Connecticut and Delaware — in ONE unified schema. Daycares, licensed centers, family child-care homes: name, type, address, county, capacity, license status. And the field nobody else normalizes across states: the compliance record. Where the state publishes it, each facility carries its inspection count and, for Delaware, cited-deficiency counts with the top regulations cited.

Sister actor to our single-state ../childcare-licensing-tx — same buyers, wider map.

Coverage (all endpoints data-layer verified 2026-07-12)

StateFacilitiesInspection dataDeficiency data
NY New York16,798
NJ New Jersey4,163
CO Colorado4,508
CT Connecticut16,188inspection_count (97,283-row feed, join verified 107/107)
DE Delaware1,249inspection_count (visits)deficiency_count + top regulations cited (11,853-row feed, join verified 165/165)

Unified record

{
"state": "DE",
"name": "YMCA Of Delaware / Central Branch",
"type": "Licensed Early Care and Education",
"address": "11 W 11TH ST",
"city": "WILMINGTON", "county": "New Castle", "state_code": "DE", "zip": "19801",
"license_number": "27399", "license_status": "Licensed",
"capacity": 120, "issue_date": null, "expiration_date": null,
"inspection_count": 6,
"deficiency_count": 14,
"deficiency_details": { "non_compliance_count": 9, "top_regulations_cited": [ { "desc": "Ratios, Group Size, and Supervision", "count": 3 } ] },
"raw": { "...": "full original source row" }
}

Compliance fields are null, never fabricated, for states/facilities where the source publishes no inspection data. NY suppresses the street address for 655 family day-care homes (address_omitted) — those are honest nulls too.

Who uses this

  • Childcare insurers — underwrite across a multi-state book on actual deficiency history, not applications.
  • Childcare SaaS & marketplaces — market sizing and lead lists spanning states in one shape.
  • Franchise & site-selection teams — capacity and competitor gaps by county across states.
  • Journalists & researchers — cross-state compliance analysis.

Input examples

  • All five states, full compliance merge: {}
  • Just the inspection states: { "states": ["CT", "DE"] }
  • One county: { "states": ["DE"], "county": "Sussex" }
  • Compliance screen (DE deficiencies): { "states": ["DE"], "minDeficiencies": 5 }
  • Fast licensing-only pull: { "includeInspections": false }

Input reference

fieldmeaning
statessubset of ["NY","NJ","CO","CT","DE"] (default: all)
countyone county; server-side where the feed has a county column (CT has none)
licenseStatuscase-insensitive substring on license status
includeInspectionsmerge inspection/deficiency feeds (CT, DE). default true
minDeficienciesonly facilities with ≥ N cited deficiencies (DE only)
maxRecordsPerStatecap facilities per state
maxInspectionRowscap inspection rows read per state before building the lookup

Proof

npm run smoke (or node test_smoke.mjs) pulls real rows from every state against the live endpoints, asserts content + state tagging, and proves the CT/DE compliance joins produce non-null counts on real facilities. No account, no cost — all sources are public state open-data portals accessed logged-out.

Source & legality

Official state open-data portals (data.ny.gov, data.nj.gov, data.colorado.gov, data.ct.gov, data.delaware.gov), public, accessed logged-out via the Socrata SODA API. Re-run monthly for current license and compliance status.