Difference between revisions of "Kmill104 Week 8"
Jump to navigation
Jump to search
(creating week 8 page) |
(→Results: answering questions) |
||
| Line 5: | Line 5: | ||
==Results== | ==Results== | ||
#What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS? | #What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS? | ||
| + | LOVENOX, VELCADE, APIDRA, ENOXOPARIN SODIUM, ACTEMRA, BORTEZOMIB, WEZLANA | ||
#What are the names of the drug products whose active ingredient (activeingred) is ATROPINE? | #What are the names of the drug products whose active ingredient (activeingred) is ATROPINE? | ||
| + | |||
#In what forms and dosages can the drug product named BENADRYL be administered? | #In what forms and dosages can the drug product named BENADRYL be administered? | ||
| + | 1. Form: Capsule;Oral and Strength: 50MG | ||
| + | 2. Form: Elixir;Oral and Strength: 12.5MG/5ML | ||
| + | 3. Form: Capsule;Oral and Strength: 25 MG | ||
| + | 4. Form: Injectable;Injection and Strength: 10MG/ML | ||
| + | 5. Form: Injectable;Injection and Strength: 50 MG/ML | ||
| + | |||
#Which drug products have a name ending in ESTROL? | #Which drug products have a name ending in ESTROL? | ||
#Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.) | #Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.) | ||
Revision as of 14:05, 12 March 2024
Purpose
Methods
Results
- What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
LOVENOX, VELCADE, APIDRA, ENOXOPARIN SODIUM, ACTEMRA, BORTEZOMIB, WEZLANA
- What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
- In what forms and dosages can the drug product named BENADRYL be administered?
1. Form: Capsule;Oral and Strength: 50MG 2. Form: Elixir;Oral and Strength: 12.5MG/5ML 3. Form: Capsule;Oral and Strength: 25 MG 4. Form: Injectable;Injection and Strength: 10MG/ML 5. Form: Injectable;Injection and Strength: 50 MG/ML
- Which drug products have a name ending in ESTROL?
- Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.)
- Produce a table listing all of the known values for the chemical_type column in the application table and how many application records there are of each. (Side note: The chemical_type codes are explained in the ChemTypeLookup.txt file, in case you’re interested.)
- What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
- Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
- Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
