Skip to main content
2 posts
Last seen: 11/27/2023 - 14:47
Joined: 11/21/2023 - 04:16
IPC data's Issue

In analyzing the September 2020 PatentView Database, I observed an anomaly in the data integration between the 'g_ipc_at_issue' table and the 'g_patent' table, , particularly in the tracking of International Patent Classification (IPC) counts by year. Notably, the 'ipc_sequence' values within the 'g_ipc_at_issue' table, corresponding to the 'patent_date' from the 'g_patent' table, uniformly register as '0' for the years 2002, 2003, and 2004. This uniformity raises questions about data accuracy, as illustrated by Patent 6335051 (issued in 2002), which is categorized under three IPCs but also exhibits a '0' ipc_sequence value. 


Role: moderator
Last seen: 01/29/2024 - 13:14
Joined: 10/17/2017 - 10:47
IPC at issue data issue

Hi Yuting

Thank you for bringing this to our attention. After taking a close look at the data file, we can confirm that the records for the years you mentioned (2002-2004) are accurate but incomplete. The sequence value 0 indicates the first record for any given patent*, but any additional IPC values for patents within that date range are missing. We will address this data gap in a future update. In the meantime, we will note in the data dictionary that the data for that date range is incomplete.

Thank you for your feedback as we work to make PatentsView as complete and valuable as possible.



*our data dictionary indicates for each table whether the starting sequence value is 1 or 0. Standardization between tables is planned for a future update