💊 Texas Pharmacy License Scraper

Extract pharmacist, pharmacy, intern & technician license records from the Texas State Board of Pharmacy (TSBP) — daily-updated public data covering 100K+ licensees across the second-largest US state.

---

⚡ How It Works

TSBP publishes four CSV files that are updated every business day. This actor downloads them directly — no browser, no login, no API key required:

File	URL	Content
phtdsk.csv	pharmacy.texas.gov/downloads/phtdsk.csv	Pharmacist licenses
phydsk.csv	pharmacy.texas.gov/downloads/phydsk.csv	Pharmacy (facility) licenses
intdsk.csv	pharmacy.texas.gov/downloads/intdsk.csv	Intern registrations
techdsk.csv	pharmacy.texas.gov/downloads/techdsk.csv	Technician registrations

The actor downloads each CSV, parses it, applies your filters, and pushes structured JSON records to the Apify dataset.

---

🔧 Input

{
  "licenseTypes": ["pharmacist", "pharmacy", "intern", "technician"],
  "statusFilter": "all",
  "cities": [],
  "states": [],
  "disciplinaryFilter": "all",
  "maxRecords": 0
}

Parameters

Parameter	Type	Default	Description
licenseTypes	array	all four	Which categories to scrape: pharmacist, pharmacy, intern, technician
statusFilter	string	all	all / active_only / inactive_only
cities	array	[]	Filter by city (case-insensitive). Example: ["Houston", "Dallas"]
states	array	[]	Filter by state abbreviation. Example: ["TX"]
disciplinaryFilter	string	all	all / clean_only / disciplined_only
maxRecords	integer	0	Max records to output (0 = unlimited)
proxyConfiguration	object	none	Optional proxy — usually not needed

---

📊 License Status Codes

TSBP uses these status codes across all license types:

✅ Active Statuses (may practice)

Status	Meaning
Active	License is current and valid
Probation	Licensed with Board-imposed conditions
Restricted	Limited practice — contact Board for details

🚫 Inactive Statuses (may NOT practice)

Status	Meaning
Suspended	Temporarily barred from practice
Revoked	Permanently removed
Cancelled	License cancelled
Surrender	Voluntarily surrendered
Retired	Retired status
Expired	Not renewed by expiration date
Closed	Facility closed (pharmacy records)

---

📦 Output

Pharmacist Record Example

{
  "licenseCategory": "Pharmacist",
  "licenseNumber": "45123",
  "lastName": "MARTINEZ",
  "firstName": "CARLOS",
  "middleName": "A",
  "pharmacyName": null,
  "pharmacyType": null,
  "licenseStatus": "Active",
  "issueDate": "2016-08-15",
  "expirationDate": "2027-03-31",
  "address": "1234 MAIN ST",
  "city": "Houston",
  "state": "TX",
  "zip": "77001",
  "phone": null,
  "pharmacistInCharge": null,
  "disciplinaryAction": false,
  "sourceFile": "phtdsk.csv",
  "scrapedAt": "2026-05-06T09:00:00.000Z"
}

Pharmacy (Facility) Record Example

{
  "licenseCategory": "Pharmacy",
  "licenseNumber": "18765",
  "lastName": null,
  "firstName": null,
  "middleName": null,
  "pharmacyName": "WALGREENS #5432",
  "pharmacyType": "Community",
  "licenseStatus": "Active",
  "issueDate": "2005-01-10",
  "expirationDate": "2027-01-31",
  "address": "9876 WESTHEIMER RD",
  "city": "Houston",
  "state": "TX",
  "zip": "77042",
  "phone": "713-555-0100",
  "pharmacistInCharge": "SMITH, JANE R",
  "disciplinaryAction": false,
  "sourceFile": "phydsk.csv",
  "scrapedAt": "2026-05-06T09:00:00.000Z"
}

Output Fields

Field	Type	Description
licenseCategory	string	Pharmacist / Pharmacy / Intern / Technician
licenseNumber	string	TSBP license or registration number
lastName	string	Individual last name (null for pharmacies)
firstName	string	Individual first name (null for pharmacies)
middleName	string	Middle name or initial
pharmacyName	string	Facility name (pharmacy records only)
pharmacyType	string	Community, Hospital, Mail Order, Nuclear etc.
licenseStatus	string	Current license status
issueDate	string	License issue date (YYYY-MM-DD)
expirationDate	string	License expiration date (YYYY-MM-DD)
address	string	Street address
city	string	City
state	string	State abbreviation
zip	string	ZIP code
phone	string	Phone number (pharmacy records only)
pharmacistInCharge	string	Responsible pharmacist (pharmacy records only)
disciplinaryAction	boolean	Whether Board disciplinary action exists
sourceFile	string	CSV filename this record was parsed from
scrapedAt	string	ISO timestamp when record was scraped

---

🎯 Use Cases

🏥 Healthcare Staffing & Credentialing

Verify Texas pharmacist and technician licenses for travel pharmacists, new hires, and credential renewals. Daily updates ensure near real-time verification.

✅ Compliance Monitoring

Pharmacy chains (CVS, Walgreens, H-E-B) can monitor all employee pharmacist license statuses across 5,000+ Texas locations. Disciplinary action flag catches Board actions immediately.

💼 Insurance & PBM Network Management

Pharmacy benefit managers can verify facility licenses across their Texas network. Track expirations, closures, and status changes for provider directory accuracy.

📈 B2B Sales Intelligence

Pharmaceutical companies, medical equipment vendors, and pharmacy software providers can build targeted lead lists of active Texas pharmacists and pharmacies by city.

🔬 Workforce Analytics & Market Research

Analyze pharmacist supply/demand by Texas metro area, track license growth trends, qualification distribution, and technician-to-pharmacist ratios.

---

🏙️ Major Texas Cities

City	Metro Population	Healthcare Significance
Houston	7.1M	Texas Medical Center — world's largest medical complex
Dallas–Fort Worth	7.6M	Major hospital systems: Baylor, UT Southwestern
San Antonio	2.6M	Military medical hub (BAMC, Brooke Army)
Austin	2.3M	Fastest-growing major metro, expanding pharmacy networks
Fort Worth	1.0M	Cook Children's, JPS Health Network
El Paso	0.9M	Border healthcare, bilingual pharmacy workforce

---

💰 Cost & Performance

Metric	Value
Engine	Direct CSV download — no browser overhead
Runtime	~30–60 seconds for all four files
Cost	~0.001 CU per full run
Data freshness	Daily (previous business day)
Auth required	None
Proxy required	None

---

📝 Notes

• Daily updates — TSBP updates all four CSV files every business day with data current through the previous business day.
• No authentication — all CSV files are publicly accessible with no login or API key.
• Disciplinary action — the disciplinary flag is most reliable for pharmacist and intern records. Pharmacy and technician files may not always include this field.
• Pharmacy types — include Community, Hospital, Mail Order, Nuclear, Sterile Compounding, Non-Sterile Compounding, Central Fill, and others per TSBP classification.
• Out-of-state records — the pharmacy file may include facilities licensed in Texas but physically located in other states (e.g., mail-order pharmacies). Use the states filter to narrow results.

---

📜 Changelog

Version	Date	Notes
1.0.0	2026-05-06	Initial release — direct CSV download, four license categories, full filtering