Show the number of exclusivities granted by year

Created on Apr 10, 2025

Prompt

Chart

Query Results

SQL Query:

SELECT
    EXTRACT(YEAR FROM exclusivity_date) AS category,
    COUNT(*) AS value
FROM
    orange_book_exclusivities
GROUP BY
    category
ORDER BY
    category;

Results:

category	value
2020	7
2022	15
2023	6
2024	36
2025	491
2026	481
2027	426
2028	206
2029	148
2030	129
2031	106
2032	3
2033	4
2034	3
2035	1

Chart Configuration

{
  "grid": {
    "left": "3%",
    "right": "4%",
    "bottom": "3%",
    "containLabel": true
  },
  "title": {
    "top": "20px",
    "left": "center",
    "text": "Number of Exclusivities Granted Per Year"
  },
  "xAxis": {
    "data": [
      "2020",
      "2022",
      "2023",
      "2024",
      "2025",
      "2026",
      "2027",
      "2028",
      "2029",
      "2030",
      "2031",
      "2032",
      "2033",
      "2034",
      "2035"
    ],
    "name": "Year",
    "type": "category",
    "nameGap": 30,
    "nameLocation": "middle"
  },
  "yAxis": {
    "name": "Number of Exclusivities",
    "type": "value",
    "nameGap": 50,
    "nameLocation": "middle"
  },
  "legend": {
    "top": "60px",
    "data": [
      "undefined"
    ]
  },
  "series": [
    {
      "data": [
        7,
        15,
        6,
        36,
        491,
        481,
        426,
        206,
        148,
        129,
        106,
        3,
        4,
        3,
        1
      ],
      "name": "undefined",
      "type": "bar"
    }
  ],
  "tooltip": {
    "trigger": "axis",
    "axisPointer": {
      "type": "shadow"
    }
  },
  "backgroundColor": "#fff"
}