Show the number of exclusivities granted by year

Created on Jul 8, 2025

Prompt

Chart

Query Results

SQL Query:

SELECT
  EXTRACT(YEAR FROM e.exclusivity_date)::integer AS exclusivity_year,
  COUNT(e.id) AS number_of_exclusivities
FROM
  orange_book_exclusivities e
WHERE
  e.exclusivity_date IS NOT NULL
GROUP BY
  exclusivity_year
ORDER BY
  exclusivity_year
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": "3%",
    "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
    ],
    "type": "category",
    "axisLabel": {
      "interval": 0
    }
  },
  "yAxis": {
    "type": "value",
    "axisLabel": {
      "formatter": "{value}"
    }
  },
  "legend": {
    "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": "bar"
    }
  ],
  "tooltip": {
    "trigger": "axis",
    "axisPointer": {
      "type": "shadow"
    }
  }
}