How to get German Drug Shortage Monitor
Open medicine shortage reports from the German BfArM / PharmNet-Bund public CSV. A run saves one row per result.
One row per result
A row has Product Name, Atc Code, Substances, Start Date. The columns are listed in the schema on this page.
The next run
Put the run on a schedule and the next file is the latest rows.
German Drug Shortage Monitor in Excel, Sheets, or Power BI
The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.
Schema
Examples come from the actor sample, not a live result.
| Name | Description | Example |
|---|---|---|
productName | Product Name | Aciclovir |
atcCode | Atc Code | D06BB03 |
substances | Substances | Aciclovir |
startDate | Start Date | 2026-10-15 |
endDate | End Date | 2026-10-15 |
firstReportDate | First Report Date | 2026-10-15 |
lastReportDate | Last Report Date | 2026-10-15 |
scrapedAt | Scraped At | 2026-09-24T12:00:00.000Z |
productNameProduct NameAciclovirAbZ Lippenherpescreme atcCodeAtc CodeD06BB03substancesSubstancesAciclovirstartDateStart Date2026-10-15endDateEnd Date2026-10-15firstReportDateFirst Report Date2026-10-15lastReportDateLast Report Date2026-10-15scrapedAtScraped At2026-09-24T12:00:00.000Z