Difference between revisions of "Ckaplan Week 8"
(→What are the names of the drug products that are sponsored (sponsorname column) by MERCK?: redoing answer) |
(/* 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...) |
||
| Line 98: | Line 98: | ||
===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.)=== | ===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.)=== | ||
| − | + | ||
| − | + | I couldn't complete this column because the data was outdated and deleted. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
===What are the names of the drug products that are sponsored (sponsorname column) by MERCK?=== | ===What are the names of the drug products that are sponsored (sponsorname column) by MERCK?=== | ||
Revision as of 18:50, 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?
DrugName DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL DIENESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL
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.)
I couldn't complete this column because the data was outdated and deleted.
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.)
I couldn't complete this column because the data was outdated and deleted.
What are the names of the drug products that are sponsored (sponsorname column) by MERCK?
DrugName HYDRODIURIL HUMORSOL HUMORSOL HYDROPRES 25 HYDROPRES 50 DECADRON DECADRON DECADRON HYDROCORTONE DECADRON DECADRON DECADRON COLBENEMID PERIACTIN DECASPRAY PERIACTIN DECADRON W/ XYLOCAINE ALDOMET ALDOMET ALDOMET ALDOMET ALDORIL 15 ALDORIL 25 ALDORIL D30 ALDORIL D50 DECADERM ALDOCLOR-150 ALDOCLOR-250 DECADRON-LA CLINORIL CLINORIL BLOCADREN BLOCADREN BLOCADREN TIMOLIDE 10-25 MODURETIC 5-50 ALDOMET DOLOBID DOLOBID NOROXIN PEPCID PEPCID PRESERVATIVE FREE PRINIVIL PRINIVIL PRINIVIL PRINIVIL PRINIVIL MEVACOR MEVACOR MEVACOR CHIBROXIN PRINZIDE PRINZIDE PRINZIDE TIAMATE TIAMATE TIAMATE PEPCID RPD PEPCID RPD VIOXX VIOXX VIOXX VIOXX VIOXX CANCIDAS CANCIDAS EMEND EMEND EMEND FOSAMAX VIOXX VIOXX VIOXX NEODECADRON NEODECADRON NEO-HYDELTRASOL MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER PRIMAXIN PRIMAXIN PRIMAXIN PRIMAXIN PRIMAXIN PRIMAXIN ALPHAREDISOL ELSPAR
Which sponsorname companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
SponsorName WATSON LABS NOSTRUM LABS INC WATSON LABS WATSON LABS WATSON LABS DR REDDYS LABS SA
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
