Acquire lots of citation data from BigQuery by application

Question

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?

Answer 1

1. Import your Excel spreadsheet into Google sheets.

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

3. 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`).