Show the most common dosage forms

Created on May 6, 2025

Prompt

Chart

Query Results

SQL Query:

SELECT
  route AS dosage_form,
  COUNT(*) AS frequency
FROM
  orange_book_products
WHERE
  route IS NOT NULL
GROUP BY
  route
ORDER BY
  frequency DESC
LIMIT 20;

Results:

dosage_form	frequency
TABLET;ORAL	18838
INJECTABLE;INJECTION	7018
CAPSULE;ORAL	5113
TABLET, EXTENDED RELEASE;ORAL	2487
CAPSULE, EXTENDED RELEASE;ORAL	1164
SOLUTION;INTRAVENOUS	831
SOLUTION;ORAL	668
CREAM;TOPICAL	586
INJECTABLE;INTRAVENOUS	556
SOLUTION/DROPS;OPHTHALMIC	555
FOR SUSPENSION;ORAL	481
TABLET, ORALLY DISINTEGRATING;ORAL	406
TABLET, DELAYED RELEASE;ORAL	370
OINTMENT;TOPICAL	344
SUSPENSION;ORAL	330
SYRUP;ORAL	302
POWDER;INTRAVENOUS	298
CAPSULE, DELAYED REL PELLETS;ORAL	256
SOLUTION;TOPICAL	248
TABLET, CHEWABLE;ORAL	245

Chart Configuration

{
  "grid": {
    "left": "3%",
    "right": "4%",
    "bottom": "10%",
    "containLabel": true
  },
  "title": {
    "text": "Dosage Form Count by Route"
  },
  "xAxis": {
    "data": [
      "TABLET;ORAL",
      "INJECTABLE;INJECTION",
      "CAPSULE;ORAL",
      "TABLET, EXTENDED RELEASE;ORAL",
      "CAPSULE, EXTENDED RELEASE;ORAL",
      "SOLUTION;INTRAVENOUS",
      "SOLUTION;ORAL",
      "CREAM;TOPICAL",
      "INJECTABLE;INTRAVENOUS",
      "SOLUTION/DROPS;OPHTHALMIC",
      "FOR SUSPENSION;ORAL",
      "TABLET, ORALLY DISINTEGRATING;ORAL",
      "TABLET, DELAYED RELEASE;ORAL",
      "OINTMENT;TOPICAL",
      "SUSPENSION;ORAL",
      "SYRUP;ORAL",
      "POWDER;INTRAVENOUS",
      "CAPSULE, DELAYED REL PELLETS;ORAL",
      "SOLUTION;TOPICAL",
      "TABLET, CHEWABLE;ORAL"
    ],
    "name": "Category",
    "type": "category",
    "nameGap": 30,
    "axisLabel": {
      "rotate": 30,
      "interval": 0
    },
    "nameLocation": "middle"
  },
  "yAxis": {
    "name": "Count",
    "type": "value",
    "nameGap": 40,
    "nameLocation": "middle"
  },
  "legend": {},
  "series": [
    {
      "data": [
        18838,
        7018,
        5113,
        2487,
        1164,
        831,
        668,
        586,
        556,
        555,
        481,
        406,
        370,
        344,
        330,
        302,
        298,
        256,
        248,
        245
      ],
      "name": "Dosage Form Count",
      "type": "bar",
      "label": {
        "show": true,
        "position": "top"
      }
    }
  ],
  "tooltip": {
    "trigger": "axis",
    "axisPointer": {
      "type": "shadow"
    }
  }
}