7,649
edits
Changes
Jump to navigation
Jump to search
patentsdb.application_number AS Patent_Application_Number, ANY_VALUE(assignee_name.name) AS AssigneeName
→BigQuery Code
WITH Patent_Matches AS
(SELECT PARSE_DATE('%Y', SAFE_CAST(ANY_VALUE(patentsdb.filing_date) AS STRING)) AS Patent_Filing_year,
FROM `patents-public-data.patents.publications` AS patentsdb, UNNEST(assignee_harmonized) AS assignee_name
WHERE LOWER(assignee_name.name) LIKE '%univ vermont%' AND patentsdb.country_code = 'US'
ORDER BY Patent_Filing_year;
Note that UVM's harmonized assignee name is UNIV VERMONT. Also, I could only go up to 2017, as patent applications are typically not disclosed for 18 months to protect their investors.
==Results==
