Difference between revisions of "Cdomin12 Week 4"
Jump to navigation
Jump to search
(→Results: adding questions) |
(→Results: add bold to questions) |
||
| Line 9: | Line 9: | ||
==Results== | ==Results== | ||
| − | + | ===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 (activeingred) is ATROPINE?=== | |
| − | + | ||
| − | + | ===3. In what forms and dosages 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 (sponsor applicant column) by MERCK?=== | ||
| + | |||
| + | ===8.Which sponsor applicant 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?)=== | ||
==Scientific Conclusion== | ==Scientific Conclusion== | ||
Revision as of 10:50, 24 September 2019
Contents
- 1 Certificate
- 2 Purpose
- 3 Methods
- 4 Results
- 4.1 1.What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
- 4.2 2. What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
- 4.3 3. In what forms and dosages can the drug product named BENADRYL be administered?
- 4.4 4. Which drug products have a name ending in ESTROL?
- 4.5 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.)
- 4.6 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.)
- 4.7 7. What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
- 4.8 8.Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
- 4.9 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?)
- 5 Scientific Conclusion
