Learn About Patents Around the World

 
 
 
IN THIS SECTION
3 posts
ksur
Last seen: 01/24/2019 - 17:38
Joined: 01/24/2019 - 16:00
Missing data on application year?

Hi, I am trying to get data by app_year and had written a code for it which worked solid multiple times (pasted below)

But today, the app_year data seems to have disappeared, including in the data query (pasted below). Is this normal?

Image removed.

 

search_pv(
    query =  with_qfuns(and(
      qry_funs$gte(app_date="2007-01-01"), 
      qry_funs$lte(app_date="2016-12-31"),   
      qry_funs$eq(patent_type="utility"),
      or(qry_funs$contains(cpc_subgroup_id = "Y02C"),
         qry_funs$contains(cpc_subgroup_id = "Y02W"))
    )),
    method = "GET",
    fields = c("patent_number","inventor_state", "inventor_country", "assignee_organization", 
               "assignee_state", "assignee_country", "app_date", "patent_year", "cpc_subgroup_id"),  
    sort = NULL,
    subent_cnts = TRUE,
    mtchd_subent_only = TRUE,
    all_pages=TRUE
)

Sun, 02/17/2019 - 12:02
Russ
Last seen: 03/21/2024 - 09:05
Joined: 11/14/2017 - 22:15
re: MISSING DATA ON APPLICATION YEAR?

ksur,

It looks like the patentsview team has fixed the problem you saw.  Application years are coming back in the query tool and through queries like yours using the R package.  I thought I'd reply to say that there is a field cpc_group_id that you could use directly instead of using contains on cpc_subgroup_id.  Your search could also be written as


search_pv(
    query =  with_qfuns(and(
      qry_funs$gte(app_date="2007-01-01"), 
      qry_funs$lte(app_date="2016-12-31"),   
      qry_funs$eq(patent_type="utility"),
      qry_funs$eq(cpc_group_id = c("Y02C","Y02W"))
    )),
    method = "GET",
    fields = c("patent_number","inventor_state", "inventor_country", "assignee_organization", 
               "assignee_state", "assignee_country", "app_date", "patent_year", "cpc_subgroup_id"),  
    sort = NULL,
    subent_cnts = TRUE,
    mtchd_subent_only = TRUE,
    all_pages=TRUE
)

or as a direct api post for those not familiar with the R package's domain specific language (dsl)

{
  "q": {"_and": [
      {"_gte":{"app_date":"2007-01-01"}},
      {"_lte":{"app_date":"2016-12-31"}},
      { "_eq":{"patent_type":"utility"}},
      {"cpc_group_id":["Y02C","Y02W"]}
      ]},

  "f":["patent_number","inventor_state", "inventor_country", "assignee_organization", "assignee_state", "assignee_country", "app_date", "patent_year", "cpc_subgroup_id","cpc_group_id"], 

"o":{"matched_subentities_only":"true","include_subentity_total_counts":"true"}
}

Thu, 02/21/2019 - 17:27
PVTeam
Role: moderator
Last seen: 04/24/2024 - 12:31
Joined: 10/17/2017 - 10:47
Re: MISSING DATA ON APPLICATION YEAR?

Hi ksur,

Yes, we have resolved the issue you were facing with the QueryTool: data by app_year is available, even with the search criteria you used (Application Filing Date greater or equal to 2016-01-01).

Additionally, your code using the R package also works – it takes a few minutes to obtain data in the response from running your query with all the parameters.

Russ – thank you for your insight!

Thank you,

PVTeam