SCRIPT_DETAIL_TABLE
This table provides ingredient, company, and categorical detail for all FDA National Drug Codes (NDCs).
Queries that source from SCRIPT_DETAIL_TABLE table
What is in the SCRIPT_DETAIL_TABLE table?
Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).
feature | description | example |
|---|---|---|
ndc | FDA standardized National Drug Code 11 for a dispensed drug | 00002021301 |
labeler | A company or organization that is a manufacturer, repackager, relabeler, or distributor of drugs | eli lilly and company |
product_type | A classification of a drug product based on its intended use and how it is regulated by the FDA | human otc drug |
substance | A substance is the active ingredient in a drug product | insulin |
substance_unit | The unit of measurement for the active ingredient in a drug product | [iU]/mL |
dosage_form | The type of pharmaceutical formulation, such as a tablet, capsule, liquid, or injection, that a drug product is available in | injection, solution |
route | Method by which a drug product is administered to the body | parenteral |
marketing_category | A classification of a drug product based on its regulatory status and how it is marketed | bla |
application_number | A unique identifier for an NDC labeler's request to obtain an NDC labeler code | BLA018780 |
pharm_classes | A list of classifications of a drug product based on its therapeutic action, or how it works in the body | insulin [cs], |
Glossary Helper Function
CareQuery API Glossary helps users understand the underlying SCRIPT_DETAIL_TABLE dataset within the python SDK.
# import package
from care_query.care_query import CareQuery
# instantiate and connect
cq = CareQuery(email = "your-email",
token = "your-api-token")
# return details
print(cq.glossary.table_detail('SCRIPT_DETAIL_TABLE'))Updated about 1 month ago