Which known-exploited CVEs have the highest CVSS scores?
SELECT cve_id, published_at, cvss_score FROM demo.security.exploited_vulnerabilities WHERE cvss_score IS NOT NULL ORDER BY cvss_score DESC, published_at DESC LIMIT 10
The CVEs in the CISA KEV catalog, with their NVD publication date, CVSS score and CVSS vector.
Live from the table, no sign-in needed.
SELECT cve_id, published_at, cvss_score, cvss_vector FROM demo.security.exploited_vulnerabilities LIMIT 10
Run any of these here, or open it in Studio to change the SQL. Studio is free to start: 100 queries a day.
SELECT cve_id, published_at, cvss_score FROM demo.security.exploited_vulnerabilities WHERE cvss_score IS NOT NULL ORDER BY cvss_score DESC, published_at DESC LIMIT 10
SELECT COUNT(*) AS cves FROM demo.security.exploited_vulnerabilities WHERE cvss_score < 7
| Column | Type |
|---|---|
| cve_id | VARCHAR |
| published_at | TIMESTAMP |
| cvss_score | FLOAT64 |
| cvss_vector | VARCHAR |