Close Menu

    Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    What's Hot

    Nationalist group leaders agree to stop hoisting St George’s flags in Oxfordshire | Oxfordshire

    How worried should we be about bird flu? – Full Story podcast | Bird flu

    US AI stock sell-off shakes markets from Wall Street to Asia | Stock markets

    Facebook X (Twitter) Instagram
    Facebook X (Twitter) YouTube LinkedIn
    Naija Global News |
    Tuesday, June 23
    • Business
    • Health
    • Politics
    • Science
    • Sports
    • Education
    • Social Issues
    • Technology
    • More
      • Crime & Justice
      • Environment
      • Entertainment
    Naija Global News |
    You are at:Home»Social Issues»How ProPublica Created Its Generic Prescription Drug Lookup Tool — ProPublica
    Social Issues

    How ProPublica Created Its Generic Prescription Drug Lookup Tool — ProPublica

    onlyplanz_80y6mtBy onlyplanz_80y6mtDecember 18, 2025008 Mins Read
    Share Facebook Twitter Pinterest LinkedIn Tumblr Email
    How ProPublica Created Its Generic Prescription Drug Lookup Tool — ProPublica
    Sophi Miyoko Gullbrants for ProPublica
    Share
    Facebook Twitter LinkedIn Pinterest Email

    To understand how risky drugs could end up in your medicine cabinet, ProPublica spent more than a year and a half investigating the Food and Drug Administration’s oversight of the foreign factories that make generic medications and have been cited for violating critical quality standards.

    It quickly became clear through our reporting that patients and doctors don’t reliably have the information they need to make informed decisions about the medicines they take or prescribe.

    ProPublica has created Rx Inspector, a tool that aims to help. 

    You can look up your generic prescription drugs, and we’ll guide you to the specific facility that made them. We were able to link more than 80% of generic prescription drug products in our database to a factory that made them using databases of label information, manufacturing facilities and location data that we sued the FDA for. Additionally, we included the history of FDA actions at those facilities based on a trove of inspection records we assembled.

    Keep in mind that if you turn up a troubling inspection report, it doesn’t necessarily mean that your drug is compromised. Doctors and pharmacists advise that you not stop taking your medications. Instead, you should talk to your health care provider about any concerns.

    Look up your prescriptions using the tool here.

    Our ongoing reporting has focused on the safety of generic drugs, which represent the vast majority of all prescriptions filled in the United States. Thus, Rx Inspector does not include brand-name or over-the-counter drugs, at least for now. We excluded gases (like oxygen tanks) and intradermal route drugs (many of these were allergy tests for things like feline hair).

    ProPublica described the app and the methodology used to build it to the FDA, which did not comment. The agency previously told ProPublica that it doesn’t reveal where drugs are made on inspection reports to protect what it deemed confidential commercial information.

    Here’s how we did it:

    Getting Lists of Drugs and Facilities

    First, we needed to get a list of prescription drugs. We downloaded the National Drug Code product list from the FDA. A company that wants to make a generic must file an Abbreviated New Drug Application for approval. We used those ANDA numbers to filter our list to generic drugs only. 

    We included biological drug products, such as insulin. We opted to include authorized generics, which are brand-name drugs that are marketed without the brand-name label, because we thought consumers may not know their “generic” is actually a brand-name drug.

    We then joined that list of drugs to the Structured Product Labeling database from DailyMed, a National Institutes of Health resource that contains information on more than 155,000 drug labels submitted to the FDA by companies. We used that data to get basic information about the drugs, like the form (pill, injectable, etc.), dose, color, imprints and more. In some, but not all, cases, it also contained identifiers or addresses that we could use to link to the agency’s official list of manufacturing locations. 

    We then matched the drugs to three different facility lists:

    The first and primary list comes from the FDA’s Electronic Drug Registration and Listing System. That database contains the addresses of drugmakers’ factories. It also has two numeric identifiers: the FDA Establishment Identifier and a Dun & Bradstreet, or DUNS, number.

    The second facility list comes from a federal lawsuit we filed against the FDA for a list of manufacturer addresses connected to their ANDA numbers among other information. We received a partial list, which we used when we only had ANDA numbers for a drug. 

    And finally, we have a list of historical facilities, which allows us to identify production sites and link to them via FEI number if other routes don’t work.

    Joining Them Together

    In October, we detailed our unsuccessful search for the original manufacturer of a popular cholesterol generic through a labyrinth of company names and complex databases that few consumers would even know exist. We decided we had to do something similar for nearly 47,000 drug products.  

    Different datasets had varying identifiers, and we had to link multiple together to find the correct facilities. For example, if all we had was an ANDA number, we used the facility list we obtained from our lawsuit, which also was listed by ANDA. If we had an FEI, we could link it to the FDA’s official list of facilities. 

    Sometimes, we had neither. In cases where we did not have any useful identifiers, we searched the product labeling data for any manufacturing addresses and attempted to match them to our facility lists. We used both fuzzy text matching and geocoding to do this and then manually reviewed our matches. 

    For repackaged or relabeled drugs, we traced back to the original label using the source NDC code.

    In total, we were able to match more than 39,250 products to a manufacturing facility.

    Getting the Inspection Data 

    Linking up individual drugs was only half the battle. The next thing we did was acquire the FDA’s inspection outcomes for facilities and join them back to our facility lists. 

    We acquired data on FDA inspections from a variety of sources. First, we turned to the FDA’s public inspections dashboard for inspections since 2008. We used only information related to drugs or biologics, excluding inspections related to food, cosmetics, tobacco, medical devices and veterinary products. This dashboard contained the dates and outcomes of inspections, as well as citations detailing any violations of federal code. We linked these reports back to a facility with a matching FEI number.

    That still only gave us limited information for inspections. For documents with more details, we needed what’s known as a Form 483, which is where inspectors document problems they observe at a facility. Unfortunately, the FDA does not make all 483s public. We began by exporting those that have been published in the inspections dashboard, though we know this is incomplete.

    We also went directly to the FDA and asked for all the 483s that had already been released publicly. They delivered a trove of almost 40,000 documents.

    We linked the 483s to an inspection by extracting text from the documents using optical character recognition, connecting them to a facility using the FEI number and finding inspections of that facility within 10 days of the date of the letter. We were unable to link every 483 to an inspection because the FDA’s public inspections data does not include every inspection the agency conducts. 

    The FDA publishes warning letters that detail “significant violation(s) of federal requirement(s).” We obtained these from the FDA’s website going back to 2020, filtered out the ones not related to drugs and connected the rest to a facility using the FEI number. 

    Some facilities are outright banned from sending drugs to the U.S. market for a time, with exceptions for certain drugs as ProPublica detailed in reporting this year. The FDA calls this an import alert.

    We used the Internet Archive’s Wayback Machine to find hundreds of import alert lists published by the FDA over more than 15 years. The lists identified factories banned from shipping drugs to the United States because the FDA found manufacturing violations. 

    We focused on 66-40 alerts, which call out drug manufacturing facilities that do not meet “good manufacturing practice” standards. We considered the published date on the alert as the start date. We are unable to tell when an alert was lifted and instead approximate it using the date we last see the facility on the list. Import alerts do not include FEI numbers to easily identify the facility in question, so we used the entity name and address to tie them back to a facility.

    We attempted to identify exemptions to import alerts by looking for strings like “excluded from DWPE” (“detention without physical examination”), then parse it manually to get a clean list of drugs.

    To support our research, we paid for access to Redica Systems, a quality and regulatory intelligence company with a vast collection of FDA inspection documents. We used Redica’s database to spot-check our own work.

    We know that much of the data represented here is likely an undercount. Clerical errors could have resulted in missed connections. The FDA sometimes removes inspection outcomes from its dashboard, and our method of scraping through the Internet Archive is subject to availability. We were also limited in how completely we could obtain 483s, warning letters and import alerts. There may be additional communications between the company and the FDA that are not reflected in our database because they have not been made public. 

    Still, this is the most comprehensive public list of FDA actions tied to drugs that has ever been assembled.

    created Drug generic Lookup Prescription ProPublica tool
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
    Previous ArticleI want my sons to know masculinity can be kind – and my daughter to live without fear | David Lammy
    Next Article Instacart settles Federal Trade Commission’s claim it deceived US shoppers | Business and Economy News
    onlyplanz_80y6mt
    • Website

    Related Posts

    Muscle growth drug ‘could reduce loss of lean tissue’ when using slimming jabs | Weight-loss drugs

    June 8, 2026

    Life-prolonging drug for advanced ovarian cancer gets go-ahead in England | Ovarian cancer

    June 4, 2026

    Doctors hail drug that spares bladder cancer patients ‘life-changing’ surgery | Cancer research

    June 2, 2026
    Add A Comment
    Leave A Reply Cancel Reply

    Top Posts

    The science influencers going viral on TikTok to fight misinformation

    February 17, 20262 Views

    Watch Lady Gaga’s Perform ‘Vanish Into You’ on ‘Colbert’

    September 9, 20251 Views

    Advertisers flock to Fox seeking an ‘audience of one’ — Donald Trump

    July 13, 20251 Views
    Stay In Touch
    • Facebook
    • YouTube
    • TikTok
    • WhatsApp
    • Twitter
    • Instagram
    Latest Reviews

    At Chile’s Vera Rubin Observatory, Earth’s Largest Camera Surveys the Sky

    By onlyplanz_80y6mtJune 19, 2025

    SpaceX Starship Explodes Before Test Fire

    By onlyplanz_80y6mtJune 19, 2025

    How the L.A. Port got hit by Trump’s Tariffs

    By onlyplanz_80y6mtJune 19, 2025

    Subscribe to Updates

    Get the latest tech news from FooBar about tech, design and biz.

    Most Popular

    The science influencers going viral on TikTok to fight misinformation

    February 17, 20262 Views

    Watch Lady Gaga’s Perform ‘Vanish Into You’ on ‘Colbert’

    September 9, 20251 Views

    Advertisers flock to Fox seeking an ‘audience of one’ — Donald Trump

    July 13, 20251 Views
    Our Picks

    Nationalist group leaders agree to stop hoisting St George’s flags in Oxfordshire | Oxfordshire

    How worried should we be about bird flu? – Full Story podcast | Bird flu

    US AI stock sell-off shakes markets from Wall Street to Asia | Stock markets

    Recent Posts
    • Nationalist group leaders agree to stop hoisting St George’s flags in Oxfordshire | Oxfordshire
    • How worried should we be about bird flu? – Full Story podcast | Bird flu
    • US AI stock sell-off shakes markets from Wall Street to Asia | Stock markets
    • The experience that coloured everything Britten went on to write | Classical music
    • Paraquat will continue to be used in Australia despite 70 countries banning weedkiller over Parkinson’s disease fears | Herbicides
    © 2026 naijaglobalnews. Designed by Pro.
    • About Us
    • Disclaimer
    • Get In Touch
    • Privacy Policy
    • Terms and Conditions

    Type above and press Enter to search. Press Esc to cancel.