Changes

Jump to navigation Jump to search
6 bytes added ,  14:02, 17 February 2020
WITH Patent_Matches AS
(SELECT PARSE_DATE('%Y', SAFE_CAST(ANY_VALUE(patentsdb.filing_date) AS STRING)) AS Patent_Filing_year,
patentsdb.application_number AS Patent_Application_Number, ANY_VALUE(assignee_name.name) AS AssigneeName
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==

Navigation menu