Difference between revisions of "Ckaplan Week 8"
Jump to navigation
Jump to search
(→What are the names of the drug products whose active ingredient (activeingredient) is ATROPINE?: answer from query 2) |
(→In what forms and strengths can the drug product named BENADRYL be administered?: answer from query 3) |
||
| Line 56: | Line 56: | ||
===In what forms and strengths can the drug product named BENADRYL be administered?=== | ===In what forms and strengths can the drug product named BENADRYL be administered?=== | ||
| + | |||
| + | Form Strength | ||
| + | CAPSULE;ORAL 50MG | ||
| + | ELIXIR;ORAL 12.5MG/5ML | ||
| + | CAPSULE;ORAL 25MG | ||
| + | INJECTABLE;INJECTION 10MG/ML | ||
| + | INJECTABLE;INJECTION 50MG/ML **Federal Register determination that product was not discontinued or withdrawn for safety or effectiveness reasons** | ||
===Which drug products have a name ending in ESTROL?=== | ===Which drug products have a name ending in ESTROL?=== | ||
Revision as of 18:36, 13 March 2024
-add file here
- Procedure:
- Methods:
- Results:
- Conclusion:
Contents
- 1 What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
- 2 What are the names of the drug products whose active ingredient (activeingredient) is ATROPINE?
- 3 In what forms and strengths can the drug product named BENADRYL be administered?
- 4 Which drug products have a name ending in ESTROL?
- 5 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.)
- 6 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.)
- 7 What are the names of the drug products that are sponsored (sponsorname column) by MERCK?
- 8 Which sponsorname companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
- 9 Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
- 10 Assignment Pages
- 11 Individual Journal Entry Pages
- 12 Shared Journal Entry Pages
What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
DrugName LOVENOX VELCADE APIDRA APIDRA ENOXAPARIN SODIUM ACTEMRA BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB ENOXAPARIN SODIUM BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB ENOXAPARIN SODIUM BORTEZOMIB BORTEZOMIB WEZLANA WEZLANA WEZLANA WEZLANA WEZLANA WEZLANA
What are the names of the drug products whose active ingredient (activeingredient) is ATROPINE?
DrugName ATROPEN ATROPEN ATROPEN ATROPEN ATROPINE ATROPINE (AUTOINJECTOR)
In what forms and strengths can the drug product named BENADRYL be administered?
Form Strength CAPSULE;ORAL 50MG ELIXIR;ORAL 12.5MG/5ML CAPSULE;ORAL 25MG INJECTABLE;INJECTION 10MG/ML INJECTABLE;INJECTION 50MG/ML **Federal Register determination that product was not discontinued or withdrawn for safety or effectiveness reasons**
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 (sponsorname column) by MERCK?
Which sponsorname 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?)
Assignment Pages
- Week 1
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- Week 13
- Week 14
- Week 15
Individual Journal Entry Pages
- ckaplan Week 1
- ckaplan Week 2
- SIR2 Week 3
- AgeAnnoMO Week 4
- ckaplan Week 5
- ckaplan Week 6
- ckaplan Week 8
- ckaplan Week 9
- ckaplan Week 10
- ckaplan Week 11
- ckaplan Week 12
- ckaplan Week 13
- ckaplan Week 14
- ckaplan Week 15
