🏛️ Illinois IDFPR Professional License Scraper

Extract 1.2M+ professional license records from the Illinois Department of Financial and Professional Regulation (IDFPR) via the public Socrata API. Covers 100+ professional categories across pharmacy, nursing, physician, real estate, engineering, law and more.

---

⚡ How It Works

IDFPR publishes its entire professional licensing database on Illinois' Socrata open data portal as dataset pzzh-kp68. This actor queries it directly via the Socrata API — no browser, no login, no scraping.

GET https://data.illinois.gov/resource/pzzh-kp68.json
    ?$where=license_type='PHARMACY' AND license_status='ACTIVE'
    &$limit=1000&$offset=0
    &$order=license_number ASC

Pagination uses $offset increments. The actor builds SoQL $where clauses from your input filters automatically.

---

🔧 Input

{
  "licenseTypes": ["PHARMACY"],
  "descriptions": [],
  "statusFilter": "active_only",
  "counties": [],
  "cities": [],
  "disciplineFilter": "all",
  "issuedAfter": "",
  "maxRecords": 100,
  "pageSize": 1000,
  "requestDelay": 300
}

Parameters

Parameter	Type	Default	Description
licenseTypes	array	[]	Filter by type: PHARMACY, NURSE, PHYSICIAN, REAL ESTATE etc.
descriptions	array	[]	Filter by description: PHARMACIST, REGISTERED NURSE etc.
statusFilter	string	all	all / active_only / inactive_only
counties	array	[]	Illinois county filter: COOK, DUPAGE, LAKE etc.
cities	array	[]	City filter: CHICAGO, SPRINGFIELD etc.
disciplineFilter	string	all	all / clean_only / disciplined_only
issuedAfter	string	""	Only licenses issued after date (YYYY-MM-DD)
maxRecords	integer	0	Max records (0 = unlimited)
pageSize	integer	1000	Records per API call (max 50000)
requestDelay	integer	300	Delay between API calls (ms)

---

📋 License Categories (100+)

🏥 Healthcare

PHARMACY (Pharmacist, Pharmacy Technician) · NURSE (RN, LPN, APRN) · PHYSICIAN (MD, DO) · DENTIST · PHYSICAL THERAPY · CLINICAL PSYCHOLOGY · CLINICAL SOCIAL WORKER · COUNSELOR · OPTOMETRY · PODIATRY · OCCUPATIONAL THERAPY · SPEECH LANGUAGE PATH · RESPIRATORY CARE · PHYSICIAN ASSISTANT · ACUPUNCTURE · ATHLETIC TRAINER · DIETITIAN

🔧 Technical

ARCHITECT · PROFESSIONAL ENGINEER · STRUCTURAL ENGINEER · LAND SURVEYOR · HOME INSPECTOR · ENVIRONMENTAL HEALTH

💼 Legal & Financial

ATTORNEY · CPA · PUBLIC ACCOUNTANT · COLLECTION AGENCY · CURRENCY EXCHANGE · PAWN BROKER

🏠 Real Estate

REAL ESTATE (Agent, Broker, Appraiser, Home Inspector)

💇 Beauty

COSMETOLOGY · BARBER · NAIL TECHNICIAN · ESTHETICS

---

📊 License Status Codes

Status	Meaning
ACTIVE	License is current and valid
NOT RENEWED	Expired — not renewed by deadline
EXPIRED	Past expiration date
REVOKED	Permanently removed by Board
SUSPENDED	Temporarily barred
INACTIVE	Voluntarily inactive
CLOSED	Business closed

---

📦 Output

Example Record

{
  "licenseType": "PHARMACY",
  "description": "PHARMACIST",
  "licenseNumber": "051-012345",
  "licenseStatus": "ACTIVE",
  "isBusiness": false,
  "firstName": "SARAH",
  "middleName": "M",
  "lastName": "JOHNSON",
  "originalIssueDate": "2015-06-12",
  "effectiveDate": "2025-07-01",
  "expirationDate": "2027-06-30",
  "city": "CHICAGO",
  "state": "IL",
  "zip": "60601",
  "county": "COOK",
  "specialtyQualifier": null,
  "controlledSubstanceSchedule": "2, 3, 4, 5",
  "everDisciplined": false,
  "lastModifiedDate": "2025-07-01",
  "licenseCategory": "Healthcare",
  "scrapedAt": "2026-05-06T09:00:00.000Z"
}

🔑 Unique Data Fields

Field	Why It's Valuable
controlledSubstanceSchedule	Which drug schedules (II-V) the pharmacist can dispense — critical for DEA compliance
everDisciplined	Boolean flag — instant screening for clean-record verification
disciplineReason	Full text reason for Board action — no other state provides this in bulk
caseNumber	Links to specific discipline case for legal research
county	Illinois county — enables geo-targeted B2B campaigns

---

🎯 Use Cases

🏥 Healthcare Staffing & Credentialing

Verify Illinois pharmacist, nurse, and physician licenses. Joint Commission, NCQA and AOA accept IDFPR as a primary source for credential verification.

💊 Pharmacy Compliance (Controlled Substances)

controlledSubstanceSchedule field shows exactly which drug schedules each pharmacist can handle. Critical for DEA compliance audits and pharmacy chain operations.

✅ Discipline Screening

everDisciplined + disciplineReason enable instant background screening. Filter disciplined_only to find all licensees with Board actions across any profession.

🏠 Real Estate Intelligence

Active Illinois real estate agents, brokers, and appraisers. Cook County alone (Chicago metro) has the highest density of real estate professionals in the Midwest.

📈 B2B Lead Generation

1.2M+ records across 100+ professions. Build targeted lead lists by license type, city, county, and status for pharmaceutical sales, medical equipment, legal tech, and SaaS products.

---

🏙️ Major Illinois Counties

County	Major City	Population	Key Industries
Cook	Chicago	5.2M	Healthcare, Finance, Law
DuPage	Naperville	930K	Pharma, Tech, Healthcare
Lake	Waukegan	700K	Pharma (AbbVie, Takeda HQ)
Will	Joliet	690K	Healthcare, Logistics
Kane	Aurora	520K	Manufacturing, Healthcare
Winnebago	Rockford	280K	Healthcare, Engineering
Sangamon	Springfield	195K	State Government, Healthcare
Champaign	Champaign	210K	University, Research

---

💰 Cost & Performance

Metric	Value
Engine	Socrata API — no browser overhead
Runtime	~30s for 1K records, ~10min for 100K
Cost	~0.002 CU per 1K records
Data freshness	Daily
Auth required	None
Proxy required	None

---

⚠️ Technical Notes

• Socrata API — public, no authentication required. App tokens optional but recommended for heavy usage.
• SoQL queries — the actor builds $where clauses automatically from your input filters. Complex queries are supported.
• 1.2M+ records — full dataset scrape takes ~20 minutes with default settings. Use filters to narrow scope.
• Deduplication — records are deduplicated by license_number to avoid duplicates from overlapping pages.
• Daily updates — IDFPR refreshes the Socrata dataset daily. lastModifiedDate shows when each record was last changed.

---

📜 Changelog

Version	Date	Notes
1.0.0	2026-05-06	Initial release — Socrata API, SoQL filtering, 100+ categories, discipline data, CS schedules