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.
| Column | Meaning |
|---|---|
key | Stable identifier used in the page URL |
name | Name as FDA most recently gave it |
other_names | Other names FDA used for the same company, separated by semicolons |
types | Type FDA named in a letter subject line, or 503B when on FDA’s outsourcing facility list |
warning_letters | Number of GLP-1 warning letters in this index |
recall_reports | Number of openFDA recall reports in this index |
on_503b_list | yes when the company is on FDA’s registered 503B outsourcing facility list |
drugs | Tracked drugs named in its records |
first_record | Earliest record date (ISO) |
latest_record | Latest record date (ISO) |
page | Record page on this site |
warning-letters.csv
FDA warning letters: Every FDA warning letter whose text names a tracked GLP-1 drug. 155 rows.
| Column | Meaning |
|---|---|
id | FDA’s URL slug for the letter |
company | Recipient as FDA lists it |
company_key | Joins to companies.csv |
issued | Date on the letter (ISO) |
posted | Date FDA posted it (ISO) |
office | Issuing FDA office |
subject | FDA’s subject line, verbatim |
seller_type | Type FDA named in the subject line, if any |
drugs | Tracked drugs named in the letter text |
other_ingredients | Other GLP-1 or related ingredients named |
mentions_compounded | yes when the letter text uses the word “compounded” |
mentions_research_label | yes when the letter quotes research-use or not-for-human-consumption labeling |
close_out | Close-out letter date, when FDA posted one |
websites | Website addresses named in the letter text, separated by semicolons |
url | The letter on fda.gov |
recalls.csv
Recall reports: Every openFDA drug recall enforcement report for a compounded or unapproved GLP-1 product. 81 rows.
| Column | Meaning |
|---|---|
recall_number | FDA recall number |
firm | Recalling firm as FDA lists it |
firm_key | Joins to companies.csv |
product | Product description, verbatim |
reason | Reason for recall, verbatim |
class | FDA classification |
status | FDA status at the last pull |
initiated | Recall initiation date (ISO) |
reported | FDA report date (ISO) |
terminated | Termination date, when given (ISO) |
state | Firm state |
distribution | Distribution pattern, verbatim |
quantity | Product quantity, verbatim |
drugs | Tracked drugs named |
url | openFDA record |
503b-facilities.csv
503B outsourcing facilities: FDA’s registered 503B outsourcing facility list, without contact names or phone numbers. 100 rows.
| Column | Meaning |
|---|---|
name | Facility name as FDA lists it |
company_key | Joins to companies.csv when the facility also has GLP-1 records |
city | City |
state | State |
initial_registration | Initial registration date (ISO) |
latest_registration | Latest registration date (ISO) |
last_inspection | Last inspection date (ISO), or FDA’s text when not inspected |
form_483 | Whether FDA issued a Form 483 at that inspection, as FDA states it |
recall | FDA’s recall column |
action | FDA’s action on the last inspection |
prior_action | yes when FDA notes an earlier inspection led to a 483, warning letter or other action |
page | Facility page on this site |
pharmacy_page | Pharmacy 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.
| Column | Meaning |
|---|---|
slug | Stable identifier used in the page URL |
name | Name used on the page (the 503B list spelling when the pharmacy is on that list) |
other_names | Other legal and dba names FDA uses, separated by semicolons |
former_names | Names FDA gives as “formerly”, separated by semicolons |
city | City |
state | State |
fda_type | 503A, 503B or both as FDA labels the entries; a 503B list row counts as 503B |
fda_503b_list | Record found, No matching record found, or No match possible (no location given), as of the date in checked |
compounding_entry_ids | facility_id values in compounding-actions.csv merged into this page |
form_483s | Form 483s and amended 483s FDA lists across the merged entries, one per document |
warning_letters | Warning letters FDA lists across the merged entries |
other_fda_letters | Untitled, FMD-145, close-out, state referral and handoff letters FDA lists |
latest_action | Latest dated action FDA lists (ISO) |
glp1_company_key | Joins to companies.csv when a GLP-1 company shares this pharmacy’s name and no other pharmacy page does |
state_board_status | License 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_number | License numbers of the matching home state board rows, as the board prints them, separated by semicolons |
state_license_status | Status of each matching license, in the board’s words, in the same order |
state_board_actions | Home 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_date | Date 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_status | Site 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_fei | FEI numbers of the matched dashboard sites, separated by semicolons |
fda_inspections | Classified FDA inspections the dashboard lists for the matched sites; empty when no site matched |
fda_inspections_oai | Of those, inspections classified Official Action Indicated (OAI) |
fda_latest_inspection_end | End date of the latest of those inspections (ISO) |
fda_latest_classification | NAI, VAI or OAI for that inspection |
fda_published_483s | Form 483s the dashboard lists as published for the matched FEI numbers |
checked | Date this index last pulled both FDA lists (ISO) |
page | Pharmacy 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.
| Column | Meaning |
|---|---|
facility_id | Stable identifier for the facility entry |
facility | Facility heading as FDA gives it, including any dba name |
city | City |
state | State |
facility_type | 503A or 503B as FDA labels the entry; empty when FDA gives neither |
fda_note | Anything FDA adds after the type, verbatim |
date | Date in FDA’s listing (ISO) |
record_type | Plain grouping of FDA’s wording (Form 483, Warning letter, Warning letter close-out, FMD-145 letter, State referral letter and others) |
fda_listing | FDA’s line, verbatim apart from file-size notes |
url | Document FDA links, when it links one |
pharmacy_slug | Joins 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.
| Column | Meaning |
|---|---|
id | Statement identifier |
date | Date FDA attached to the statement (ISO) |
statement | The statement as restated on this site |
drugs | Drugs it concerns |
source | Source page title |
url | Source page |
drug-shortages.csv
FDA drug shortage entries: Entries in FDA’s drug shortage data for the tracked drugs. 14 rows.
| Column | Meaning |
|---|---|
drug | Tracked drug |
generic_name | Generic name as FDA lists it |
presentation | Presentation |
company | Company |
status | FDA shortage status |
updated | Date FDA updated the entry (ISO) |
url | Source |
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.
| Column | Meaning |
|---|---|
entry | Position on FDA’s list |
firm_name | Firm name as FDA prints it; empty where FDA redacts it |
country | Country as FDA prints it |
products | Product codes and FDA descriptions listed for the entry |
alert_published | Alert publish date FDA shows (ISO) |
url | Alert 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.
| Column | Meaning |
|---|---|
shipment_id | FDA Data Dashboard Shipment ID (entry/document/line) |
refusal_date | Refusal date (ISO) |
declared_manufacturer | Declared manufacturer, business names only |
fei | FEI number on the line, business names only |
country | Declared manufacturer country |
product_code | FDA product code |
product_description | FDA product code description, verbatim |
form_per_import_alert_66_80 | The code’s form in Import Alert 66-80’s words, where the alert lists it |
charges | FDA charge codes and statements, verbatim |
fda_sample_analysis | FDA sample analysis flag |
source | irr (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.
| Column | Meaning |
|---|---|
fda_media_id | FDA media id of the PDF (fda.gov/media/<id>/download) |
fda_url | Link to the PDF FDA publishes or links |
page_url | This index’s page for the pharmacy or facility |
firm_on_cover | Firm name as printed on the form |
fei | FEI number on the form |
city_state_zip | Firm city, state and ZIP code on the form |
establishment_type | Type of establishment inspected, as printed |
fda_district_office | FDA district office address on the form, without phone numbers |
inspection_start | First date of inspection (ISO) |
inspection_end | Last date of inspection (ISO) |
matched_by | FEI or name (how the form was matched to the page) |
text_layer | clean (typed text) or ocr (character recognition of a scanned page) |
observation_number | Observation number as printed |
themes | Themes from the fixed keyword table (see the Form 483 answer page) |
observation_text | Observation 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.
| Column | Meaning |
|---|---|
product_ndc | Labeler and product code segments of the NDC |
fda_file | FDA file the row came from: finished, unfinished, compounded or excluded |
labeler | LabelerName as FDA gives it |
proprietary_name | ProprietaryName and suffix |
nonproprietary_name | NonProprietaryName |
substances | SubstanceName |
dosage_form | DosageFormName |
route | RouteName |
strength | Strength as FDA’s file gives it |
marketing_category | MarketingCategoryName, verbatim |
application_number | ApplicationNumber, blank when none |
marketing_start | StartMarketingDate (ISO), blank in the compounded file |
marketing_end | EndMarketingDate (ISO), blank when none |
listing_certified_through | LISTING_RECORD_CERTIFIED_THROUGH (ISO) |
exclude_flag | NDC_EXCLUDE_FLAG and FDA’s meaning, excluded file only |
reporting_periods | Compounded file only: reporting periods as FDA writes them |
package_ndcs | Compounded file only: package NDCs |
drugs | Tracked drugs named |
page_url | This 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.
| Column | Meaning |
|---|---|
brand | Brand name (CMS Brnd_Name) |
generic | Generic name (CMS Gnrc_Name) |
ingredient | Ingredient group used on this site |
year | Calendar year |
total_spending | Tot_Spndng: total gross spending, dollars |
total_claims | Tot_Clms: claims |
total_beneficiaries | Tot_Benes: beneficiaries (blank when CMS leaves it blank) |
total_dosage_units | Tot_Dsg_Unts: dosage units |
avg_spend_per_claim | Avg_Spnd_Per_Clm |
avg_spend_per_beneficiary | Avg_Spnd_Per_Bene |
avg_spend_per_dosage_unit | Avg_Spnd_Per_Dsg_Unt_Wghtd |
cms_outlier_flag | 1 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.
| Column | Meaning |
|---|---|
state | Two-letter state code as CMS gives it (XX is national) |
year | Calendar year |
quarter | Calendar quarter |
ingredient | Ingredient group used on this site |
product | Product, from the first word of CMS’s 10-character product name |
rows | NDC-level rows CMS published for this state, quarter and product |
suppressed_rows | Of those, rows CMS suppressed |
units_reimbursed | Sum of units reimbursed over unsuppressed rows |
prescriptions | Sum of number of prescriptions over unsuppressed rows |
total_amount_reimbursed | Sum of total amount reimbursed over unsuppressed rows, dollars |
medicaid_amount_reimbursed | Sum of Medicaid amount reimbursed over unsuppressed rows, dollars |
Sources
- FDA warning letters (fda.gov full-text search)
- openFDA drug recall enforcement reports
- FDA Registered Outsourcing Facilities (503B)
- FDA: Compounding: Inspections, Recalls, and other Actions
- FDA Drug Shortages (via openFDA drug shortages endpoint)
- FDA: FDA clarifies policies for compounders as national GLP-1 supply begins to stabilize
- FDA: FDA’s Concerns with Unapproved GLP-1 Drugs Used for Weight Loss
- FDA news release: FDA Proposes to Exclude Semaglutide, Tirzepatide, and Liraglutide on 503B Bulks List
- Federal Register, May 1, 2026: List of Bulk Drug Substances for Which There Is a Clinical Need Under Section 503B
- Federal Register, June 26, 2026: Extension of Comment Period
- FDA news release: FDA Launches Green List to Protect Americans from Illegal Imported GLP-1 Drug Ingredients
- FDA Import Alert 66-80
- FDA news release: FDA Warns 30 Telehealth Companies Against Illegal Marketing of Compounded GLP-1s
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.