Close Menu

    Subscribe to Updates

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

    What's Hot

    EbonyLife Brings “The Secret Lives of Baba Segi’s Wives” to the Big Screen in 2026

    January 18, 2026

    Louvre and Versailles hike prices for foreign visitors: Who should pay for France’s heritage?

    January 18, 2026

    How much does it cost to withdraw from a multiemployer pension plan?

    January 18, 2026
    Facebook X (Twitter) Instagram
    • Home
    • Contact Us
    • About Us
    • Privacy Policy
    • Terms Of Service
    • Advertisement
    Sunday, January 18
    Facebook X (Twitter) Instagram Pinterest Vimeo
    ABSA Africa TV
    • Breaking News
    • Africa News
    • World News
    • Editorial
    • Environ/Climate
    • More
      • Cameroon
      • Ambazonia
      • Politics
      • Culture
      • Travel
      • Sports
      • Technology
      • AfroSingles
    • Donate
    ABSLive
    ABSA Africa TV
    Home»World News»How ProPublica Created Its Generic Prescription Drug Lookup Tool — ProPublica
    World News

    How ProPublica Created Its Generic Prescription Drug Lookup Tool — ProPublica

    Olive MetugeBy Olive MetugeDecember 26, 2025No Comments8 Mins Read
    Facebook Twitter Pinterest Telegram LinkedIn Tumblr Email Reddit
    How ProPublica Created Its Generic Prescription Drug Lookup Tool — ProPublica
    Share
    Facebook Twitter LinkedIn Pinterest Email Copy Link


    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.



    Source link

    Post Views: 25
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
    Olive Metuge

    Related Posts

    How much does it cost to withdraw from a multiemployer pension plan?

    January 18, 2026

    Jurors will remain anonymous in first social media addiction trial

    January 18, 2026

    Top 6 Lebanese restaurants to add to your Dubai foodie list

    January 17, 2026
    Leave A Reply Cancel Reply

    Top Posts

    Who is Duma Boko, Botswana’s new President?

    November 6, 2024

    Kamto Not Qualified for 2025 Presidential Elections on Technicality Reasons, Despite Declaration of Candidacy

    January 18, 2025

    As African Leaders Gather in Addis Ababa to Pick a New Chairperson, They are Reminded That it is Time For a Leadership That Represents True Pan-Africanism

    January 19, 2025

    BREAKING NEWS: Tapang Ivo Files Federal Lawsuit Against Nsahlai Law Firm for Defamation, Seeks $100K in Damages

    March 14, 2025
    Don't Miss

    EbonyLife Brings “The Secret Lives of Baba Segi’s Wives” to the Big Screen in 2026

    By Prudence MakogeJanuary 18, 2026

    One of Africa’s most cherished literary works is officially making its way to the big…

    Your Poster Your Poster

    Louvre and Versailles hike prices for foreign visitors: Who should pay for France’s heritage?

    January 18, 2026

    How much does it cost to withdraw from a multiemployer pension plan?

    January 18, 2026

    MOTD analysis: What does the future look like for Thomas Frank?

    January 18, 2026
    Stay In Touch
    • Facebook
    • Twitter
    • Pinterest
    • Instagram
    • YouTube
    • Vimeo

    Subscribe to Updates

    Sign up and get the latest breaking ABS Africa news before others get it.

    About Us
    About Us

    ABS TV, the first pan-African news channel broadcasting 24/7 from the diaspora, is a groundbreaking platform that bridges Africa with the rest of the world.

    We're accepting new partnerships right now.

    Address: 9894 Bissonette St, Houston TX. USA, 77036
    Contact: +1346-504-3666

    Facebook X (Twitter) Pinterest YouTube WhatsApp
    Our Picks

    EbonyLife Brings “The Secret Lives of Baba Segi’s Wives” to the Big Screen in 2026

    January 18, 2026

    Louvre and Versailles hike prices for foreign visitors: Who should pay for France’s heritage?

    January 18, 2026

    How much does it cost to withdraw from a multiemployer pension plan?

    January 18, 2026
    Most Popular

    EbonyLife Brings “The Secret Lives of Baba Segi’s Wives” to the Big Screen in 2026

    January 18, 2026

    Did Paul Biya Actually Return to Cameroon on Monday? The Suspicion Behind the Footage

    October 23, 2024

    Surrender 1.9B CFA and Get Your D.O’: Pirates Tell Cameroon Gov’t

    October 23, 2024
    Facebook X (Twitter) Instagram Pinterest YouTube
    • About Us
    • Contact Us
    • Privacy Policy
    • Terms Of Service
    © 2026 Absa Africa TV. All right reserved by absafricatv.

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