Vulnerabilities per week

Every CVE with the week it was published, its vendor and its CVSS score — shaped for counting and charting disclosure volume over time.

Table
demo.security.vulnerabilities_per_week
Source
Opteryx view over NVD
Query it in Studio Use the OData API
Preview

The first ten rows

Live from the table, no sign-in needed.

SELECT week, published_at, vendor, cvss_score
  FROM demo.security.vulnerabilities_per_week
 LIMIT 10
Example questions

Ask it something

Run any of these here, or open it in Studio to change the SQL. Studio is free to start: 100 queries a day.

How many CVEs were published in each of the last twelve weeks?

SELECT week, COUNT(*) AS cves
  FROM demo.security.vulnerabilities_per_week
 GROUP BY week
 ORDER BY week DESC
 LIMIT 12
Edit in Studio

Which vendors have published the most CVEs?

SELECT vendor, COUNT(*) AS cves
  FROM demo.security.vulnerabilities_per_week
 WHERE vendor IS NOT NULL
 GROUP BY vendor
 ORDER BY cves DESC, vendor
 LIMIT 10
Edit in Studio
Schema

Columns

ColumnType
weekTIMESTAMP
published_atTIMESTAMP
vendorVARCHAR
cvss_scoreFLOAT64