Difference between revisions of "Ckaplan Week 8"

From LMU BioDB 2024
Jump to navigation Jump to search
(/* 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...)
(/* 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)
Line 97: Line 97:
  
 
===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.)===
 +
 +
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
  
 
===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:47, 13 March 2024

-add file here

  • Procedure:
  • Methods:
  • Results:
  • Conclusion:

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.)

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

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

Individual Journal Entry Pages

Shared Journal Entry Pages