Skip to main content
 
 
 
IN THIS SECTION
11 posts
foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Missing data

Dear PatentsView team,

I recently have been querying PatentsView for my research project. I wrote code to save the ones that return "null". So far, the number of nulls is approaching 60,000. I manually searched some of them on https://appft.uspto.gov/netahtml/PTO/index.html and apparently they are existing and valid patents. (examples: 10521471, 10592732)

I was wondering why those patents are not accessible in PatentsView database. Is it possible I shared those patent numbers with your team to investigate?

Thank you!

 

foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Update: 60,722 data missing

Update: hi, I finished my queries, there are 60,772 nulls. I have them saved in a csv file (1.5M). Please let me know how I can share this file with you. I don't see any option uploading files to this forum. 

Thank you!

foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Update: hi, I tested some of…

Update: hi, I tested some of the error numbers, they now exist in PatentsView. Thanks! I'll re-query these and let you know if there's any error.

foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Update: hi, there are 146…

Update: hi, there are 146 patents that return null, as listed below:


[10061989,
 10061870,
 10061854,
 10061982,
 10061864,
 10010038,
 10061916,
 10061985,
 10061999,
 10062029,
 10062031,
 10061969,
 10061922,
 10062030,
 10025210,
 10061974,
 10062042,
 10061983,
 10062028,
 10061898,
 10061895,
 10061940,
 10061997,
 10062052,
 10061859,
 4275968,
 10061861,
 10061845,
 10061925,
 9568327,
 10061901,
 10061986,
 10061890,
 10061853,
 10061887,
 10062035,
 10061958,
 10062050,
 10062057,
 10061856,
 10062036,
 10062069,
 10061921,
 10062053,
 10061862,
 10061888,
 10061860,
 10062055,
 10010039,
 10062009,
 10062063,
 10061971,
 10061937,
 10062012,
 10061851,
 10061847,
 10062003,
 10061865,
 10061855,
 10010047,
 10061863,
 10061977,
 10062011,
 10061970,
 10061894,
 10061850,
 10061867,
 10061980,
 10061979,
 10061984,
 10061871,
 10062066,
 10061930,
 10061846,
 10025271,
 10062032,
 10061936,
 10061938,
 10061939,
 10061849,
 6125341,
 10061875,
 10062033,
 10061891,
 10061844,
 10062008,
 10061900,
 10061873,
 10062038,
 10061915,
 10062041,
 10061889,
 10062004,
 10061897,
 10062014,
 10061866,
 10062060,
 10061987,
 10061886,
 10010042,
 10061878,
 10061973,
 10061919,
 10062010,
 10062015,
 10062005,
 10025276,
 10062054,
 10062064,
 10062062,
 10061950,
 10061972,
 10061931,
 10061874,
 10061990,
 7639937,
 10062037,
 10062034,
 10061852,
 10062006,
 10061906,
 10062045,
 10061876,
 10062051,
 10062002,
 10062007,
 10062013,
 10062043,
 10062071,
 10062072,
 10061924,
 10061994,
 10061946,
 10061857,
 10061858,
 10062044,
 10061877,
 10061976,
 8538743,
 10061872,
 10061909,
 10061848,
 10061996,
 10062039,
 10061881,
 10062001]

emelluso
Role: administrator
Last seen: 06/04/2024 - 13:23
Joined: 10/21/2020 - 10:51
Hello, we have checked each…

Hello, we have checked each ID in the list and have records in the bulk download file for them. Can you check your ingest code? 

Thank you,

PVTeam

foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Hi PVTeam, thank you very…

Hi PVTeam, thank you very much for your reply. Apologies for the confusion. They are missing when queried through the API. For instance, the following query (for the first number in the list above) returns null:

https://api.patentsview.org/patents/query?q={"patent_number":"10061989"}&f=["patent_title", "app_date", "patent_type"]

emelluso
Role: administrator
Last seen: 06/04/2024 - 13:23
Joined: 10/21/2020 - 10:51
Thank you for letting us…

Thank you for letting us know, this is very appreciated! We found that ~400 patents were missing in the production copy of the database which has now been reloaded. Thank you also for your patience. 

-PVTeam

foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Hi PVTeam, Thank you very…

Hi PVTeam,

Thank you very much for your reply and resolving the issue. It's really helpful. I appreciate it.

I re-queried the 146 patents listed above and found most of them return successful results now. There are five in the list still are not accessible. Could you take a look? Thank you so much for your time!

[4275968, 9568327, 6125341, 7639937, 8538743]

emelluso
Role: administrator
Last seen: 06/04/2024 - 13:23
Joined: 10/21/2020 - 10:51
Try clearing your cache/…

Try clearing your cache/ hard reload ! That should fix this issue!

Best,

PVTeam

foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Hi PVTeam, thank you for…

Hi PVTeam, thank you for your answer. They all return successful results. My issue has been resolved. Thanks again! I really appreciate your help!

PVTeam
Role: moderator
Last seen: 07/15/2024 - 16:10
Joined: 10/17/2017 - 10:47
Thank you very much for…

Thank you very much for alerting us to missing cases in the API database! We appreciate it greatly!

Best,

PVTeam