Show the most common dosage forms

Created on Apr 11, 2025

Prompt

Chart

Query Results

SQL Query:

SELECT
    route AS category,
    COUNT(*) AS value,
    'Dosage Form' AS series,
    route AS label,
    FALSE AS highlight
FROM
    orange_book_products
GROUP BY
    route
ORDER BY
    value DESC
LIMIT 10;

Results:

category	value	series	label	highlight
TABLET;ORAL	18838	Dosage Form	TABLET;ORAL	false
INJECTABLE;INJECTION	7018	Dosage Form	INJECTABLE;INJECTION	false
CAPSULE;ORAL	5113	Dosage Form	CAPSULE;ORAL	false
TABLET, EXTENDED RELEASE;ORAL	2487	Dosage Form	TABLET, EXTENDED RELEASE;ORAL	false
CAPSULE, EXTENDED RELEASE;ORAL	1164	Dosage Form	CAPSULE, EXTENDED RELEASE;ORAL	false
SOLUTION;INTRAVENOUS	831	Dosage Form	SOLUTION;INTRAVENOUS	false
SOLUTION;ORAL	668	Dosage Form	SOLUTION;ORAL	false
CREAM;TOPICAL	586	Dosage Form	CREAM;TOPICAL	false
INJECTABLE;INTRAVENOUS	556	Dosage Form	INJECTABLE;INTRAVENOUS	false
SOLUTION/DROPS;OPHTHALMIC	555	Dosage Form	SOLUTION/DROPS;OPHTHALMIC	false

Chart Configuration

{
  "grid": {
    "bottom": "15%"
  },
  "title": {
    "top": "20px",
    "left": "center",
    "text": "Distribution of Dosage Forms"
  },
  "xAxis": {
    "data": [
      "CAPSULE, EXTENDED RELEASE;ORAL",
      "CAPSULE;ORAL",
      "CREAM;TOPICAL",
      "INJECTABLE;INJECTION",
      "INJECTABLE;INTRAVENOUS",
      "SOLUTION/DROPS;OPHTHALMIC",
      "SOLUTION;INTRAVENOUS",
      "SOLUTION;ORAL",
      "TABLET, EXTENDED RELEASE;ORAL",
      "TABLET;ORAL"
    ],
    "type": "category",
    "axisLabel": {
      "rotate": 30,
      "interval": 0
    }
  },
  "yAxis": {
    "type": "value"
  },
  "legend": {
    "top": "center",
    "data": [
      "Dosage Form"
    ],
    "left": "left",
    "orient": "vertical"
  },
  "series": [
    {
      "data": [
        1164,
        5113,
        586,
        7018,
        556,
        555,
        831,
        668,
        2487,
        18838
      ],
      "name": "Dosage Form",
      "type": "bar"
    }
  ],
  "tooltip": {
    "trigger": "item",
    "formatter": "{b} : {c} ({d}%)"
  }
}