Show the number of exclusivities granted by year

Created on May 6, 2025

Prompt

Chart

Query Results

SQL Query:

SELECT
  EXTRACT(YEAR FROM exclusivity_date) AS exclusivity_year,
  COUNT(*) AS number_of_exclusivities
FROM
  orange_book_exclusivities
WHERE
  exclusivity_date IS NOT NULL
GROUP BY
  exclusivity_year
ORDER BY
  exclusivity_year ASC
LIMIT 20;

Results:

exclusivity_year	number_of_exclusivities
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": "10%",
    "containLabel": true
  },
  "title": {
    "text": "Number of Exclusivities per Year"
  },
  "xAxis": {
    "data": [
      "2020",
      "2022",
      "2023",
      "2024",
      "2025",
      "2026",
      "2027",
      "2028",
      "2029",
      "2030",
      "2031",
      "2032",
      "2033",
      "2034",
      "2035"
    ],
    "name": "Category",
    "type": "category",
    "nameGap": 30,
    "axisTick": {
      "alignWithLabel": true
    },
    "axisLabel": {
      "rotate": 30,
      "interval": 0
    },
    "nameLocation": "middle"
  },
  "yAxis": {
    "name": "Number of Exclusivities",
    "type": "value",
    "nameGap": 40,
    "nameLocation": "middle"
  },
  "legend": {
    "top": "bottom",
    "data": [
      "Number of Exclusivities"
    ]
  },
  "series": [
    {
      "data": [
        7,
        15,
        6,
        36,
        491,
        481,
        426,
        206,
        148,
        129,
        106,
        3,
        4,
        3,
        1
      ],
      "name": "Number of Exclusivities",
      "type": "line",
      "label": {
        "show": true,
        "position": "top"
      },
      "smooth": true
    }
  ],
  "tooltip": {
    "trigger": "axis",
    "axisPointer": {
      "type": "shadow"
    }
  }
}