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 (clinics.csv)

One row per listing: the NPI organization or California permit, its location and a count of matched state license records.

FieldDescription
slugClinic Check page id; the page is /clinic/<slug>/
nameName as listed in NPPES or on the California permit
other_namesOther names in NPPES, separated by semicolons
categoriesmed-spa, iv-therapy or hyperbaric, separated by semicolons
stateTwo letter state code: the 50 states and DC
cityCity
zipZIP code
addressStreet line from NPPES, blank when it looks like a residence
phonePhone from NPPES
npiNational Provider Identifier, blank for California permit-only listings
npi_issuedDate the NPI was issued
npi_updatedDate the NPI record was last updated
primary_taxonomyPrimary NPI taxonomy code and description
authorized_officialPerson the organization named on its NPI application, with title and credential as listed
license_recordsNumber of matched state license or permit records
first_record_statusStatus of the first matched record as the board published it; blank when none matched
florida_not_checkedyes for Florida listings, whose license status this index does not check
license_not_checkedyes 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)
chainChain name carried in the listing name or DBA, for the seven chains with pages; blank otherwise
board_record_entriesBoard record entries for individual licenses tied to the listing
fda_lettersFDA warning letters matched by exact firm name and city
urlPage URL

License records (license-records.csv)

State license and permit records matched to a listing, with how each was matched.

FieldDescription
clinic_slugListing the record is attached to
clinic_nameListing name
stateState of the license
boardIssuing board
license_numberLicense or permit number
typeLicense type as published
holderLicense holder as published for organization licenses and permits; blank for a practitioner’s license, which is not listed by name
statusStatus as published
issuedIssue date, when published
expiresExpiration date, when published
matched_bylicense-number (number on the NPI record) or exact-name-and-city (California permit)
verify_urlBoard lookup to check current status
source_urlPublic 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.

FieldDescription
pagePage that shows the entry
listingListing or physician name
cityCity
stateState
license_numberLicense number the entry is attached under
boardBoard
entryEntry type or status as published
detailEntry text as published, when the source gives one
case_numberCase number, when the source gives one
dateEntry date as published
tieHow the license is tied to the listing: npi-license or hyperbaric-physician
labelFixed label for entries that record a charge being filed: charge, not a final decision
document_urlBoard document, when the source links one
sourceList the entry came from
source_urlWhere 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.

FieldDescription
clinic_slugListing the license is tied to
license_numberLicense number searched
sourceList searched
searchedDate searched or file pulled
entriesNumber of entries listed
tienpi-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.

FieldDescription
clinic_slugListing
clinic_nameListing name
companyFirm as FDA lists it
issuedLetter date
officeIssuing office
subjectSubject as FDA lists it
urlLetter on fda.gov
later_statusResponse 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.

FieldDescription
facilityFacility as listed
parentHospital or parent as listed
cityCity
stateState
phonePhone as listed
distinctionyes 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.

FieldDescription
slugClinic Check page id; the page is /clinic/<slug>/
stateState whose file was searched
name_searchedLegal business name on the listing’s NPI record
fileFile searched
searchedDate searched
resultmatch, no exact-name entity found, or incomplete
entity_nameEntity name as filed
entity_typeEntity type as published
statusStatus as published; blank when the file has no status field (active-only files)
status_detailConnecticut sub-status or Texas right to transact business code, as published
formedFormation or registration date, under the label each file uses
state_idState 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.

FieldDescription
slugClinic Check page id; the page is /clinic/<slug>/
npiThe listing’s NPI, used for the NPI match; blank when it has none
leie_fileOIG’s label for the LEIE database file searched
reinstatement_filesRange of OIG monthly reinstatement files searched
resultmatch, or no organization row matched
matched_bynpi, exact-name-and-city or exact-name-and-zip
source_fileFile the matched row is in
busnameBusiness name as published (OIG stores 30 characters)
excltypeExclusion type code as published
excldateExclusion date as published
reindateReinstatement 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.”

FieldDescription
seriesProduct code, or GEI-RFMN for GEI reports with a listed radiofrequency microneedling brand name
product_codeFDA product code
device_nameFDA device name for the code, as openFDA’s classification file gives it
yearYear FDA received the report
event_typeEvent type as the submitter chose it; Blank in the record when empty
reportsNumber of reports
openfda_updatedopenFDA 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.

FieldDescription
stateTwo letter state code
naicsNAICS code
naics_titleNAICS title
yearCBP reference year
establishmentsEstablishments 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

Records last pulled Nov 8, 2026. Every entry links to the original public record.