Multi-State Childcare Licensing + Inspections
Pricing
Pay per usage
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
Maintained by CommunityActor stats
0
Bookmarked
1
Total users
0
Monthly active users
2 days ago
Last modified
Categories
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)
| State | Facilities | Inspection data | Deficiency data |
|---|---|---|---|
| NY New York | 16,798 | — | — |
| NJ New Jersey | 4,163 | — | — |
| CO Colorado | 4,508 | — | — |
| CT Connecticut | 16,188 | inspection_count (97,283-row feed, join verified 107/107) | — |
| DE Delaware | 1,249 | inspection_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
| field | meaning |
|---|---|
states | subset of ["NY","NJ","CO","CT","DE"] (default: all) |
county | one county; server-side where the feed has a county column (CT has none) |
licenseStatus | case-insensitive substring on license status |
includeInspections | merge inspection/deficiency feeds (CT, DE). default true |
minDeficiencies | only facilities with ≥ N cited deficiencies (DE only) |
maxRecordsPerState | cap facilities per state |
maxInspectionRows | cap 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.