Download the data

Every table on this site is available as a CSV file, rebuilt from FDA sources each week. Free to reuse under CC BY 4.0 with a link back.

Files built from records pulled Nov 15, 2026. Dates are ISO (YYYY-MM-DD). Multiple values in one cell are separated by semicolons. Text from FDA is copied verbatim.

companies.csv

Companies: One row per company named in a GLP-1 warning letter or recall report. 161 rows.

ColumnMeaning
keyStable identifier used in the page URL
nameName as FDA most recently gave it
other_namesOther names FDA used for the same company, separated by semicolons
typesType FDA named in a letter subject line, or 503B when on FDA’s outsourcing facility list
warning_lettersNumber of GLP-1 warning letters in this index
recall_reportsNumber of openFDA recall reports in this index
on_503b_listyes when the company is on FDA’s registered 503B outsourcing facility list
drugsTracked drugs named in its records
first_recordEarliest record date (ISO)
latest_recordLatest record date (ISO)
pageRecord page on this site

warning-letters.csv

FDA warning letters: Every FDA warning letter whose text names a tracked GLP-1 drug. 155 rows.

ColumnMeaning
idFDA’s URL slug for the letter
companyRecipient as FDA lists it
company_keyJoins to companies.csv
issuedDate on the letter (ISO)
postedDate FDA posted it (ISO)
officeIssuing FDA office
subjectFDA’s subject line, verbatim
seller_typeType FDA named in the subject line, if any
drugsTracked drugs named in the letter text
other_ingredientsOther GLP-1 or related ingredients named
mentions_compoundedyes when the letter text uses the word “compounded”
mentions_research_labelyes when the letter quotes research-use or not-for-human-consumption labeling
close_outClose-out letter date, when FDA posted one
websitesWebsite addresses named in the letter text, separated by semicolons
urlThe letter on fda.gov

recalls.csv

Recall reports: Every openFDA drug recall enforcement report for a compounded or unapproved GLP-1 product. 81 rows.

ColumnMeaning
recall_numberFDA recall number
firmRecalling firm as FDA lists it
firm_keyJoins to companies.csv
productProduct description, verbatim
reasonReason for recall, verbatim
classFDA classification
statusFDA status at the last pull
initiatedRecall initiation date (ISO)
reportedFDA report date (ISO)
terminatedTermination date, when given (ISO)
stateFirm state
distributionDistribution pattern, verbatim
quantityProduct quantity, verbatim
drugsTracked drugs named
urlopenFDA record

503b-facilities.csv

503B outsourcing facilities: FDA’s registered 503B outsourcing facility list, without contact names or phone numbers. 100 rows.

ColumnMeaning
nameFacility name as FDA lists it
company_keyJoins to companies.csv when the facility also has GLP-1 records
cityCity
stateState
initial_registrationInitial registration date (ISO)
latest_registrationLatest registration date (ISO)
last_inspectionLast inspection date (ISO), or FDA’s text when not inspected
form_483Whether FDA issued a Form 483 at that inspection, as FDA states it
recallFDA’s recall column
actionFDA’s action on the last inspection
prior_actionyes when FDA notes an earlier inspection led to a 483, warning letter or other action
pageFacility page on this site
pharmacy_pagePharmacy page on this site

pharmacies.csv

Compounding pharmacies and outsourcing facilities: One row per pharmacy page: every compounding pharmacy or outsourcing facility named on FDA’s 503B list or its compounding inspections and actions page, merged only when name, city and state match. 460 rows.

ColumnMeaning
slugStable identifier used in the page URL
nameName used on the page (the 503B list spelling when the pharmacy is on that list)
other_namesOther legal and dba names FDA uses, separated by semicolons
former_namesNames FDA gives as “formerly”, separated by semicolons
cityCity
stateState
fda_type503A, 503B or both as FDA labels the entries; a 503B list row counts as 503B
fda_503b_listRecord found, No matching record found, or No match possible (no location given), as of the date in checked
compounding_entry_idsfacility_id values in compounding-actions.csv merged into this page
form_483sForm 483s and amended 483s FDA lists across the merged entries, one per document
warning_lettersWarning letters FDA lists across the merged entries
other_fda_lettersUntitled, FMD-145, close-out, state referral and handoff letters FDA lists
latest_actionLatest dated action FDA lists (ISO)
glp1_company_keyJoins to companies.csv when a GLP-1 company shares this pharmacy’s name and no other pharmacy page does
state_board_statusLicense found (the home state board file lists a license with the same name, city and state), No exact match (it does not; not a finding that the pharmacy is unlicensed), Not checked (this index does not read that board’s license records; for New York, Tennessee, Virginia and Maryland it reads board actions only, listed in state_board_actions), or No match possible (no location given)
state_license_numberLicense numbers of the matching home state board rows, as the board prints them, separated by semicolons
state_license_statusStatus of each matching license, in the board’s words, in the same order
state_board_actionsHome state board actions matched to this pharmacy, each as ISO date (year and month only for Tennessee, whose monthly reports date actions by month), the board’s wording and case or calendar number, separated by semicolons; empty for Connecticut, whose license data does not include actions; for Texas, the file’s prior disciplinary orders flag (DISP ACTN Y or N) per license
state_board_source_dateDate of the home state board file used, or for New York, Tennessee, Virginia and Maryland the date this index read the board actions (ISO); empty when not checked
fda_dashboard_statusSite found (the FDA Data Dashboard lists an inspected site with the same name, city and state), No matching site found (not a finding that it was never inspected), No match possible (no location given), or Not checked
fda_dashboard_feiFEI numbers of the matched dashboard sites, separated by semicolons
fda_inspectionsClassified FDA inspections the dashboard lists for the matched sites; empty when no site matched
fda_inspections_oaiOf those, inspections classified Official Action Indicated (OAI)
fda_latest_inspection_endEnd date of the latest of those inspections (ISO)
fda_latest_classificationNAI, VAI or OAI for that inspection
fda_published_483sForm 483s the dashboard lists as published for the matched FEI numbers
checkedDate this index last pulled both FDA lists (ISO)
pagePharmacy page on this site

compounding-actions.csv

FDA compounding inspections and actions: One row per dated action on FDA’s “Compounding: Inspections, Recalls, and other Actions” page, for every 503A pharmacy and 503B outsourcing facility it lists. 1,292 rows.

ColumnMeaning
facility_idStable identifier for the facility entry
facilityFacility heading as FDA gives it, including any dba name
cityCity
stateState
facility_type503A or 503B as FDA labels the entry; empty when FDA gives neither
fda_noteAnything FDA adds after the type, verbatim
dateDate in FDA’s listing (ISO)
record_typePlain grouping of FDA’s wording (Form 483, Warning letter, Warning letter close-out, FMD-145 letter, State referral letter and others)
fda_listingFDA’s line, verbatim apart from file-size notes
urlDocument FDA links, when it links one
pharmacy_slugJoins to pharmacies.csv

fda-statements.csv

Dated FDA statements: FDA and Federal Register statements on compounding these drugs, each restated from the source page with its date. 17 rows.

ColumnMeaning
idStatement identifier
dateDate FDA attached to the statement (ISO)
statementThe statement as restated on this site
drugsDrugs it concerns
sourceSource page title
urlSource page

drug-shortages.csv

FDA drug shortage entries: Entries in FDA’s drug shortage data for the tracked drugs. 14 rows.

ColumnMeaning
drugTracked drug
generic_nameGeneric name as FDA lists it
presentationPresentation
companyCompany
statusFDA shortage status
updatedDate FDA updated the entry (ISO)
urlSource

import-alert-66-80-green-list.csv

FDA Import Alert 66-80 Green List: Every Green List entry on FDA’s import alert for GLP-1 bulk drug substances, in FDA’s order. FDA redacts the firm names. 21 rows.

ColumnMeaning
entryPosition on FDA’s list
firm_nameFirm name as FDA prints it; empty where FDA redacts it
countryCountry as FDA prints it
productsProduct codes and FDA descriptions listed for the entry
alert_publishedAlert publish date FDA shows (ISO)
urlAlert page

glp1-import-refusals.csv

FDA import refusals naming GLP-1 drugs: Refused import lines whose FDA product code description names semaglutide, tirzepatide, liraglutide, retatrutide or GLP-1. Declared manufacturer names that do not read as a business are left empty. 717 rows.

ColumnMeaning
shipment_idFDA Data Dashboard Shipment ID (entry/document/line)
refusal_dateRefusal date (ISO)
declared_manufacturerDeclared manufacturer, business names only
feiFEI number on the line, business names only
countryDeclared manufacturer country
product_codeFDA product code
product_descriptionFDA product code description, verbatim
form_per_import_alert_66_80The code’s form in Import Alert 66-80’s words, where the alert lists it
chargesFDA charge codes and statements, verbatim
fda_sample_analysisFDA sample analysis flag
sourceirr (bulk file) or dashboard (FDA Data Dashboard, not yet in a bulk file)

form-483-observations.csv

Form 483 observations: One row per numbered observation on each FDA Form 483 shown in this index, quoted from FDA’s PDF. A Form 483 lists an investigator’s observations and is not a final FDA determination. Names of people on the form are not included. 2,714 rows.

ColumnMeaning
fda_media_idFDA media id of the PDF (fda.gov/media/<id>/download)
fda_urlLink to the PDF FDA publishes or links
page_urlThis index’s page for the pharmacy or facility
firm_on_coverFirm name as printed on the form
feiFEI number on the form
city_state_zipFirm city, state and ZIP code on the form
establishment_typeType of establishment inspected, as printed
fda_district_officeFDA district office address on the form, without phone numbers
inspection_startFirst date of inspection (ISO)
inspection_endLast date of inspection (ISO)
matched_byFEI or name (how the form was matched to the page)
text_layerclean (typed text) or ocr (character recognition of a scanned page)
observation_numberObservation number as printed
themesThemes from the fixed keyword table (see the Form 483 answer page)
observation_textObservation text as extracted; dashes written as hyphens

ndc-listings.csv

GLP-1 listings in FDA’s NDC Directory: One row per product listing in FDA’s NDC Directory download files that names semaglutide, tirzepatide, liraglutide, retatrutide or cagrilintide. Fields are as FDA’s files give them. FDA says assignment of an NDC number does not in any way denote FDA approval of the product. 467 rows.

ColumnMeaning
product_ndcLabeler and product code segments of the NDC
fda_fileFDA file the row came from: finished, unfinished, compounded or excluded
labelerLabelerName as FDA gives it
proprietary_nameProprietaryName and suffix
nonproprietary_nameNonProprietaryName
substancesSubstanceName
dosage_formDosageFormName
routeRouteName
strengthStrength as FDA’s file gives it
marketing_categoryMarketingCategoryName, verbatim
application_numberApplicationNumber, blank when none
marketing_startStartMarketingDate (ISO), blank in the compounded file
marketing_endEndMarketingDate (ISO), blank when none
listing_certified_throughLISTING_RECORD_CERTIFIED_THROUGH (ISO)
exclude_flagNDC_EXCLUDE_FLAG and FDA’s meaning, excluded file only
reporting_periodsCompounded file only: reporting periods as FDA writes them
package_ndcsCompounded file only: package NDCs
drugsTracked drugs named
page_urlThis index’s page for the labeler, when one matches by exact name or the labeler has its own page

medicare-part-d-glp1-spending.csv

Medicare Part D spending on GLP-1 drugs: One row per GLP-1 brand and year from CMS’s Medicare Part D Spending by Drug file (the “Overall” row per brand). Gross drug cost, which CMS says does not reflect manufacturer rebates or other price concessions. A blank year means CMS has no figure for that brand that year. 65 rows.

ColumnMeaning
brandBrand name (CMS Brnd_Name)
genericGeneric name (CMS Gnrc_Name)
ingredientIngredient group used on this site
yearCalendar year
total_spendingTot_Spndng: total gross spending, dollars
total_claimsTot_Clms: claims
total_beneficiariesTot_Benes: beneficiaries (blank when CMS leaves it blank)
total_dosage_unitsTot_Dsg_Unts: dosage units
avg_spend_per_claimAvg_Spnd_Per_Clm
avg_spend_per_beneficiaryAvg_Spnd_Per_Bene
avg_spend_per_dosage_unitAvg_Spnd_Per_Dsg_Unt_Wghtd
cms_outlier_flag1 when CMS’s Outlier_Flag is set

medicaid-glp1-by-state-quarter.csv

Medicaid GLP-1 drug utilization by state and quarter: CMS State Drug Utilization Data rows for GLP-1 products, added up by state (XX is CMS’s national code), year, quarter and product, fee-for-service and managed care together. Sums cover only rows CMS did not suppress; suppressed_rows says how many were suppressed, and when it equals rows there is no figure. Amounts are before the rebates manufacturers pay states. 12,851 rows.

ColumnMeaning
stateTwo-letter state code as CMS gives it (XX is national)
yearCalendar year
quarterCalendar quarter
ingredientIngredient group used on this site
productProduct, from the first word of CMS’s 10-character product name
rowsNDC-level rows CMS published for this state, quarter and product
suppressed_rowsOf those, rows CMS suppressed
units_reimbursedSum of units reimbursed over unsuppressed rows
prescriptionsSum of number of prescriptions over unsuppressed rows
total_amount_reimbursedSum of total amount reimbursed over unsuppressed rows, dollars
medicaid_amount_reimbursedSum of Medicaid amount reimbursed over unsuppressed rows, dollars

Sources

Update schedule

The records are pulled from FDA weekly and these files are rebuilt with each pull. Monthly reports are frozen after each month ends and do not change. The methodology page explains how records are matched and what is excluded.

License

Free to reuse under CC BY 4.0 with a link back. The underlying FDA records are U.S. government works.