Skip to main content
 
 
 
IN THIS SECTION
3 posts
jeremyrutman
Last seen: 04/02/2021 - 04:59
Joined: 03/30/2021 - 14:59
help formulating query

I'd like to get a list of the inventors with the most patents e.g. since 2010 in Canada.

I can do this easily from the advanced seatch tool but this gives me only 50 rows per page, requiring an untenable number of mouseclicks to get the whole dataset.

Is there an api query or other method that would allow me to do this?

For instance will this do the trick - I guess I am wondering about the function of &s at the end, whether it works as a group-by type of function.

https://api.patentsview.org/inventors/query?q={"_and":[{"inventor_country":"canada"},{"_gte":{"patent_date":"2010-01-01"}}]}&f=["inventor_id","inventor_first_name","inventor_last_name","location_city","location_latitude","location_longitude","assignee_first_name","assignee_organization"]&s=[{"inventor_id":"asc"}]

jeremyrutman
Last seen: 04/02/2021 - 04:59
Joined: 03/30/2021 - 14:59
thanks!!

Fantastic, this is almost exactly what I was after!

With your query I get results with several inventors per record, which I think I can avoid by use of the inventors endpoint instead of patents endpoint -  and if not I can pare down the results your query returns. Thanks for the fast answer!!!