CODEWITHSUNDEEP
sqlgoogle-bigquerygoogle-patent-search
LEBRON L
LEBRON L

Reputation: 17

Acquire lots of citation data from BigQuery by application

How can I realize my purpose there are ten of thousands of numbers like CN201510747352 in a Excel document.

SELECT 
  p.application_number AS app, 
  COUNT(DISTINCT c.publication_number) Citations 
FROM `patents-public-data.patents.publications` AS p,
UNNEST(citation) c
WHERE p.application_number **IN ('CN-201510747352-A')** 
GROUP BY p.application_number

I want search tens of thousands of data like CN-201510747352-A, is there any convenient ways to realize it?

Upvotes: 0

Views: 93

Answers (1)

Felipe Hoffa
Felipe Hoffa

Reputation: 59245

  1. Import your Excel spreadsheet into Google sheets.

  2. Create a federated BigQuery table pointing to your Google sheet:

enter image description here

  1. Now you can write queries that SELECT * FROM `patents-public-data.patents.publications, while filtering from your sheet with WHERE p.application_number IN (SELECT app_n FROM `my.sheet`).

Upvotes: 0

Related Questions