Show the number of patents expiring by year for...

Created on Apr 10, 2025

Prompt

Show the number of patents expiring by year for the next 10 years

Chart

Query Results

SQL Query:

SELECT
    EXTRACT(YEAR FROM patent_expire_date) AS category,
    COUNT(*) AS value,
    'Patents' AS series,
    CAST(EXTRACT(YEAR FROM patent_expire_date) AS VARCHAR) AS label,
    FALSE AS highlight
FROM
    orange_book_patents
WHERE
    patent_expire_date >= CURRENT_DATE
    AND patent_expire_date <= CURRENT_DATE + INTERVAL '10 year'
GROUP BY
    category
ORDER BY
    category;

Results:

category	value	series	label	highlight
2025	278	Patents	2025	false
2026	1573	Patents	2026	false
2027	2053	Patents	2027	false
2028	1247	Patents	2028	false
2029	1506	Patents	2029	false
2030	1503	Patents	2030	false
2031	1739	Patents	2031	false
2032	1173	Patents	2032	false
2033	1221	Patents	2033	false
2034	1127	Patents	2034	false
2035	894	Patents	2035	false

Chart Configuration

{
  "grid": {
    "left": "3%",
    "right": "4%",
    "bottom": "10%",
    "containLabel": true
  },
  "title": {
    "top": "20px",
    "left": "center",
    "text": "Number of Patents Expiring by Year (Next 10 Years)"
  },
  "xAxis": [
    {
      "data": [],
      "name": "Year",
      "type": "category",
      "nameGap": 30,
      "boundaryGap": false,
      "nameLocation": "middle"
    }
  ],
  "yAxis": [
    {
      "name": "Number of Patents",
      "type": "value",
      "nameGap": 50,
      "nameLocation": "middle"
    }
  ],
  "legend": {
    "top": "bottom",
    "data": [
      "Patents"
    ]
  },
  "series": [
    {
      "data": [
        1186,
        1573,
        2053,
        1247,
        1506,
        1503,
        1739,
        1173,
        1221,
        1127,
        289
      ],
      "name": "Patents",
      "type": "bar"
    }
  ],
  "toolbox": {
    "feature": {
      "restore": {
        "show": true
      },
      "dataView": {
        "show": true,
        "readOnly": false
      },
      "magicType": {
        "show": true,
        "type": [
          "line",
          "bar"
        ]
      },
      "saveAsImage": {
        "show": true
      }
    }
  },
  "tooltip": {
    "trigger": "axis",
    "axisPointer": {
      "type": "cross",
      "label": {
        "backgroundColor": "#6a7985"
      }
    }
  }
}