Skip to main content
 
 
 
IN THIS SECTION
4 posts
foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
Filling year errors

Hi, in the g_application table, I found the following patents are associated with invalid application date (i.e., year larger than 2023)

patent_id filing_date
3943504 2975-02-25
3964954 9173-05-31
3969699 9175-04-11
4010353 9174-09-11
4020425 2976-03-26
4032532 9173-03-01
4041523 9176-06-01
4135654 9177-04-11
4198308 7978-07-21
4255928 9178-12-11
4469216 8198-04-05
4474874 9183-03-11
4542062 2982-01-20
4596904 2984-05-25
4709214 2986-04-28
4725260 2987-03-24
4732727 9186-04-03
4739365 2987-05-28
D245522 2976-07-29


 

 

foundwonder
Last seen: 10/18/2023 - 01:42
Joined: 08/10/2021 - 02:38
There are also some patents…

There are also some patents associated with impossibly early years, like 1074.

['3933359',
 '3936670',
 '3937110',
 '3941467',
 '3943740',
 '3963197',
 '3967129',
 '4003200',
 '4003574',
 '4049770',
 '4078170',
 '4121678',
 '4134235',
 '4143614',
 '4143969',
 '4174887',
 '4187870',
 '4202168',
 '4204772',
 '4261723',
 '4379065',
 '4381219',
 '4423140',
 '4433811',
 '4513204',
 '4544017',
 '4689471',
 '4726367',
 '4739747',
 '4875871',
 '4912292',
 '4949581',
 '4956130',
 '5173280',
 '5180907',
 '5243083',
 '5266650',
 '5298141',
 '5323976',
 '5340165',
 '5381357',
 '5405412',
 '5471304',
 '5479042',
 '5484917',
 '5512877',
 '5547108',
 '5570648',
 'D249410',
 'D268871',
 'D284161',
 'D356729',
 'D368472']

Russ
Last seen: 03/21/2024 - 09:05
Joined: 11/14/2017 - 22:15
underlying data issues

Hi foundwonder,

It looks like the errors come from the underlying data provided by the USPTO.  I didn't check the bulk xml files patentsview uses, but online the same errors are present for your first batch of patent numbers.  

Russ Allen

 

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

Hi Russ, thank you for checking it for me!