Get drugs on the market #10

So I need to get the drugs on the market.

There is a current version of what is on the market:
National Drug Code Directory
which represents the drugs on the market.

But when a drug comes off the market, it is removed from the current version of the dataset.

Dailymed has all the labels of all drugs, but I can't tell if it hase the same restrictions.

I think I'll need to reach out. The ideal version is the national drug code directory version.

What I want to capture is how many different manufacturers/brands exist for each compound, and the indications for each compound. Product labels include information about indications. I am still looking for information on what is approved for marketing.

So I need to get the drugs on the market. There is a current version of what is on the market: [National Drug Code Directory](https://www.fda.gov/drugs/drug-approvals-and-databases/national-drug-code-directory) which represents the drugs on the market. But when a drug comes off the market, it is removed from the current version of the dataset. Dailymed has all the labels of all drugs, but I can't tell if it hase the same restrictions. I think I'll need to reach out. The ideal version is the national drug code directory version. **What I want to capture is how many different manufacturers/brands exist for each compound, and the indications for each compound. Product labels include information about indications. I am still looking for information on what is approved for marketing.**

Hello,

My name is Will King and I'm a PhD Student in Economics working on a project regarding drug development for my dissertation. Currently I'm trying to find or build a dataset describing which compounds were on the market at a given time between 2010 and 2020 and have found that the National Drug Code Directory contains the marketing information, including dates, for drugs currently on the market. Unfortunatly for my purposes, drugs that were pulled from the market are no longer available in the public version. Is there a way that I could get the historical market availability dates? I'm really sorry if I've missed some link to something.

Thank you for your help,

Will King

Hello, My name is Will King and I'm a PhD Student in Economics working on a project regarding drug development for my dissertation. Currently I'm trying to find or build a dataset describing which compounds were on the market at a given time between 2010 and 2020 and have found that the National Drug Code Directory contains the marketing information, including dates, for drugs currently on the market. Unfortunatly for my purposes, drugs that were pulled from the market are no longer available in the public version. Is there a way that I could get the historical market availability dates? I'm really sorry if I've missed some link to something. Thank you for your help, Will King

Marketing dates are found in SPL data

Structured product labels are electronic versions of labels submitted to the FDA. They are updated regularly and are available for download.
The file Comprehensive_NDC_SPL_Data_Elements_file.csv has all of the marketing dates.
SPL files overview
https://en.wikipedia.org/wiki/Structured_Product_Labeling
- Data downloaded Logseq - Sep 9th, 2022
- SPL human RX labels
- SPL indexing and mapping files
  - Pharmacologic_class_indexing_files
    - Seem to represent different types of "What does this do/how does it do it"
  - Product Concept indexing
    - no idea, but seems to contain references to other compounds and approval status
  - Substance indexing
  - rxnorm_mappings
    - Maps SETIDs -(SPL identifiers) to concepts (specific compounts in this case) in rxnorm, such as active ingredients and dosages
      - I hope there is a link between trials and rxnorm
    - https://dailymed.nlm.nih.gov/dailymed/app-support-mapping-files.cfm#spl-rxnorm-mapping
- SPL mapping files
- SPL metadata files

Marketing dates are found in SPL data - Structured product labels are electronic versions of labels submitted to the FDA. They are updated regularly and are available for download. - The file Comprehensive_NDC_SPL_Data_Elements_file.csv has all of the marketing dates. - # SPL files overview https://en.wikipedia.org/wiki/Structured_Product_Labeling - Data downloaded Logseq - Sep 9th, 2022 - ## SPL human RX labels - ## SPL indexing and mapping files - Pharmacologic_class_indexing_files - Seem to represent different types of "What does this do/how does it do it" - Product Concept indexing - no idea, but seems to contain references to other compounds and approval status - Substance indexing - rxnorm_mappings - Maps SETIDs -(SPL identifiers) to concepts (specific compounts in this case) in rxnorm, such as active ingredients and dosages - I hope there is a link between trials and rxnorm - https://dailymed.nlm.nih.gov/dailymed/app-support-mapping-files.cfm#spl-rxnorm-mapping - ## SPL mapping files - ## SPL metadata files -

I found a the list of drugs on the market and have integrated it using the spl nsde dataset in commit fa37dcc.
The table SQL was added in commit 266c1c96

I found a the list of drugs on the market and have integrated it using the spl nsde dataset in commit fa37dcc. The table SQL was added in commit 266c1c96

Labels Milestones

Get drugs on the market #10

SPL files overview

SPL human RX labels

SPL indexing and mapping files

SPL mapping files

SPL metadata files