Data downloads
Every table on Clinic Check is available as a CSV file, rebuilt from the records pulled Nov 8, 2026. Free to reuse under CC BY 4.0 with a link back.
- clinics.csv: clinics, 6,391 rows
- license-records.csv: license records, 1,849 rows
- board-records.csv: board records, 118 rows
- board-record-searches.csv: board record searches, 301 rows
- fda-warning-letters.csv: fda warning letters matched to listings, 1 rows
- uhms-facilities.csv: uhms accredited hyperbaric facilities, 141 rows
- business-registrations.csv: state business registration searches, 1,037 rows
- oig-exclusions.csv: oig exclusion list checks (organizations), 6,391 rows
- fda-device-reports-by-year.csv: fda device report counts by product code and year, 298 rows
- census-establishments.csv: census county business patterns establishments by state, 1,836 rows
Clinics (clinics.csv)
One row per listing: the NPI organization or California permit, its location and a count of matched state license records.
| Field | Description |
|---|---|
slug | Clinic Check page id; the page is /clinic/<slug>/ |
name | Name as listed in NPPES or on the California permit |
other_names | Other names in NPPES, separated by semicolons |
categories | med-spa, iv-therapy or hyperbaric, separated by semicolons |
state | Two letter state code: the 50 states and DC |
city | City |
zip | ZIP code |
address | Street line from NPPES, blank when it looks like a residence |
phone | Phone from NPPES |
npi | National Provider Identifier, blank for California permit-only listings |
npi_issued | Date the NPI was issued |
npi_updated | Date the NPI record was last updated |
primary_taxonomy | Primary NPI taxonomy code and description |
authorized_official | Person the organization named on its NPI application, with title and credential as listed |
license_records | Number of matched state license or permit records |
first_record_status | Status of the first matched record as the board published it; blank when none matched |
florida_not_checked | yes for Florida listings, whose license status this index does not check |
license_not_checked | yes for listings in states whose license status this index does not check (Florida, New York, Georgia, North Carolina, Arizona, Nevada, New Jersey, Pennsylvania, Massachusetts, Virginia, Ohio, Tennessee, Minnesota, South Carolina, Missouri, Indiana, Wisconsin, Utah, Oregon, Oklahoma, Louisiana, Kentucky, Iowa, Arkansas, Kansas, Mississippi, New Mexico, Nebraska, Idaho, West Virginia, Hawaii, New Hampshire, Maine, Montana, Rhode Island, South Dakota, North Dakota, Alaska, District of Columbia, Vermont and Wyoming) |
chain | Chain name carried in the listing name or DBA, for the seven chains with pages; blank otherwise |
board_record_entries | Board record entries for individual licenses tied to the listing |
fda_letters | FDA warning letters matched by exact firm name and city |
url | Page URL |
License records (license-records.csv)
State license and permit records matched to a listing, with how each was matched.
| Field | Description |
|---|---|
clinic_slug | Listing the record is attached to |
clinic_name | Listing name |
state | State of the license |
board | Issuing board |
license_number | License or permit number |
type | License type as published |
holder | License holder as published for organization licenses and permits; blank for a practitioner’s license, which is not listed by name |
status | Status as published |
issued | Issue date, when published |
expires | Expiration date, when published |
matched_by | license-number (number on the NPI record) or exact-name-and-city (California permit) |
verify_url | Board lookup to check current status |
source_url | Public file the record came from |
Board records (board-records.csv)
Every board record entry attached by license number to a practitioner license listed on a listing’s NPI record (practitioners are not named; the listing page shows whose license it is): Texas Medical Board and Board of Nursing fields from the license row, Florida DOH practitioner enforcement actions, New York Professional Medical Conduct board actions, Illinois IDFPR and Colorado DORA discipline fields, the Maryland Board of Physicians roster Discipline column, the Alabama Board of Medical Examiners roster Public Actions column, Delaware Division of Professional Regulation disciplinary actions, and Medical Board of California public documents. Entries are the boards’ wording and include dismissed complaints, ended orders and allegations.
| Field | Description |
|---|---|
page | Page that shows the entry |
listing | Listing or physician name |
city | City |
state | State |
license_number | License number the entry is attached under |
board | Board |
entry | Entry type or status as published |
detail | Entry text as published, when the source gives one |
case_number | Case number, when the source gives one |
date | Entry date as published |
tie | How the license is tied to the listing: npi-license or hyperbaric-physician |
label | Fixed label for entries that record a charge being filed: charge, not a final decision |
document_url | Board document, when the source links one |
source | List the entry came from |
source_url | Where the list is published |
Board record searches (board-record-searches.csv)
One row per individual license tied to a listing and the list searched for it, including searches that found nothing. An empty search covers only that list and license number.
| Field | Description |
|---|---|
clinic_slug | Listing the license is tied to |
license_number | License number searched |
source | List searched |
searched | Date searched or file pulled |
entries | Number of entries listed |
tie | npi-license |
FDA warning letters matched to listings (fda-warning-letters.csv)
FDA warning letters matched to a listing by exact firm name and the city and state in the letter.
| Field | Description |
|---|---|
clinic_slug | Listing |
clinic_name | Listing name |
company | Firm as FDA lists it |
issued | Letter date |
office | Issuing office |
subject | Subject as FDA lists it |
url | Letter on fda.gov |
later_status | Response or close-out letter in FDA’s warning letter index, or the date after which none was listed |
UHMS accredited hyperbaric facilities (uhms-facilities.csv)
Facilities in the 50 states and DC on the UHMS accredited list as of 2026-10-01.
| Field | Description |
|---|---|
facility | Facility as listed |
parent | Hospital or parent as listed |
city | City |
state | State |
phone | Phone as listed |
distinction | yes when UHMS marks the facility as accredited with distinction |
State business registration searches (business-registrations.csv)
One row per listing searched in a state business entity file and per exact-name entity found (one row with blank entity fields when none was found). Matching is by exact normalized legal name only.
| Field | Description |
|---|---|
slug | Clinic Check page id; the page is /clinic/<slug>/ |
state | State whose file was searched |
name_searched | Legal business name on the listing’s NPI record |
file | File searched |
searched | Date searched |
result | match, no exact-name entity found, or incomplete |
entity_name | Entity name as filed |
entity_type | Entity type as published |
status | Status as published; blank when the file has no status field (active-only files) |
status_detail | Connecticut sub-status or Texas right to transact business code, as published |
formed | Formation or registration date, under the label each file uses |
state_id | State ID number of the entity |
OIG exclusion list checks (organizations) (oig-exclusions.csv)
One row per listing checked against the HHS OIG LEIE database file and monthly reinstatement files, and one per organization row matched (one row with blank match fields when none matched). Organization rows only; rows naming a person are never matched or included.
| Field | Description |
|---|---|
slug | Clinic Check page id; the page is /clinic/<slug>/ |
npi | The listing’s NPI, used for the NPI match; blank when it has none |
leie_file | OIG’s label for the LEIE database file searched |
reinstatement_files | Range of OIG monthly reinstatement files searched |
result | match, or no organization row matched |
matched_by | npi, exact-name-and-city or exact-name-and-zip |
source_file | File the matched row is in |
busname | Business name as published (OIG stores 30 characters) |
excltype | Exclusion type code as published |
excldate | Exclusion date as published |
reindate | Reinstatement date as published; blank when none |
FDA device report counts by product code and year (fda-device-reports-by-year.csv)
One row per FDA product code (or named-brand subset), year received and event type, counted from openFDA’s device adverse event API. Counts of reports, not rates; not matched to any clinic. No report text. A report is not proof the device caused the event. In FDA’s words, “The submission of an MDR itself does not necessarily demonstrate that the device caused or contributed to the adverse outcome or event.”
| Field | Description |
|---|---|
series | Product code, or GEI-RFMN for GEI reports with a listed radiofrequency microneedling brand name |
product_code | FDA product code |
device_name | FDA device name for the code, as openFDA’s classification file gives it |
year | Year FDA received the report |
event_type | Event type as the submitter chose it; Blank in the record when empty |
reports | Number of reports |
openfda_updated | openFDA last_updated date for the data |
Census County Business Patterns establishments by state (census-establishments.csv)
One row per state, NAICS code and year: establishments with paid employees, all legal forms combined, from the CBP state files. NAICS industries are broader than med spas.
| Field | Description |
|---|---|
state | Two letter state code |
naics | NAICS code |
naics_title | NAICS title |
year | CBP reference year |
establishments | Establishments as published |
Update schedule
The ingest reruns weekly and these files are rebuilt with it. The California DCA files refresh at the start of each month and the UHMS list every few months. Monthly reports are frozen once a month ends and do not change. How each record is found and matched is on the methodology page.
License
Free to reuse under CC BY 4.0 with a link back. The underlying records are public records of the agencies listed below; check the issuing board for current status before relying on any row.
Sources
- NPPES NPI Registry, CMS
- Texas Medical Board, All Licenses (data.texas.gov)
- Texas Board of Nursing, RN licenses (data.texas.gov)
- Texas Board of Nursing, APRN licenses (data.texas.gov)
- California DCA Public Information Files
- Medical Board of California public documents (BreEZe PDL)
- Florida DOH Enforcement Actions (Practitioner) search export
- Illinois IDFPR Professional Licensing file (data.illinois.gov)
- Colorado DORA Professional and Occupational Licenses file (data.colorado.gov)
- Washington DOH Health Care Provider Credential Data (data.wa.gov)
- Michigan LARA active license lists (MiPLUS reports)
- Maryland Board of Physicians rosters of active physicians and allied health practitioners
- Alabama Board of Medical Examiners roster of active licenses
- Connecticut State Licenses and Credentials (data.ct.gov)
- Delaware Professional and Occupational Licensing file (data.delaware.gov)
- Delaware Disciplinary Actions for Professional and Occupational Licensees (data.delaware.gov)
- New York DOH Professional Medical Conduct board actions (health.data.ny.gov)
- FDA warning letters
- HHS OIG List of Excluded Individuals/Entities (LEIE)
- CMS Medicare Fee-For-Service Public Provider Enrollment
- FDA MAUDE medical device reports, via the openFDA device adverse event API
- U.S. Census Bureau, County Business Patterns, state files
- UHMS accredited hyperbaric facilities (as of 2026-10-01)
- Colorado Secretary of State, Business Entities in Colorado (data.colorado.gov)
- Connecticut Business Registry, Business Master (data.ct.gov)
- Texas Comptroller, Active Franchise Taxpayers (data.texas.gov)
- New York Department of State, Active Corporations: Beginning 1800 (data.ny.gov)
- Oregon Secretary of State, Active Businesses - ALL (data.oregon.gov)
- Pennsylvania Department of State, Registered Businesses in PA Current (data.pa.gov)
Records last pulled Nov 8, 2026. Every entry links to the original public record.