Patents Missing From the Bulk Grant XML Files
There are 305 patents missing from the bulk grant xml files. The patentsview api's database is built from the bulk grant files so it's missing all of these patents.
ppubs has all but four of them but not all are fully searchable as they should be. The four missing ones behave as if they were withdrawn but they are not listed
on the
uspto's page of withdrawn patent numbers.
PEDS (the uspto's
Patent Examination Data System) has 182 of these missing patents. All 305 are in
the latest bulk uspc file and 242 of the utility patents are in the latest bulk cpc file (8 are missing, marked N in the in_bulk_cpcs column).
There is no bulk source of reissued or plant cpcs so there's a No for them in the in_bulk_cpcs column. Click on the patents that were reissued in 1985 below to see that they do have cpc assignments in ppubs,
despite not being in the bulk cpc file the uspto makes available (it, inexplicably, contains only cpc assignments for utility patents).
The patentsview api's database is missing
cpcs for
plant patents and reissued patents since they are not incuded in the bulk cpc file.
Design patents do not receive cpc assignments so they have a
N/A in the in_bulk_cpcs column.
Summary of things the uspto should fix:
- Make an xml file available that contains the data for the 305 missing patents.
- Add plant and reissued cpcs to the existing bulk cpc file or produce a new file with these cpcs.
- Fix the 261 patents in ppubs that are not fully searchable.
- Confirm or deny whether the four patents missing from ppubs were withdrawn and adjust accordingly (remove from bulk uspc file and bulk cpc file and add to the withdrawn file if they were withdrawn, provide xml data and make fully searchable in ppubs if they were not).
The patents are in PEDS and not in the withdrawn list.
- Add to PEDS the 123 patents with an N in the in_peds column below.
- Assign cpcs and add to the bulk cpc file the utility patent below where the in_bulk_cpcs column is an N. Only 5,992,909 currently have a cpc assignment.
Missing from bulk grant xml files |
---|
patent_no | issue_date | ppubs_status | in_peds | in_bulk_uspcs | in_bulk_cpcs |
3931263 | 1976-01-06 | partially searchable | N | Y | Y |
3932204 | 1976-01-13 | partially searchable | N | Y | Y |
3934073 | 1976-01-20 | partially searchable | N | Y | Y |
3942213 | 1976-03-09 | partially searchable | N | Y | Y |
3946341 | 1976-03-23 | partially searchable | N | Y | Y |
3949174 | 1976-04-06 | partially searchable | N | Y | Y |
3956983 | 1976-05-18 | partially searchable | N | Y | Y |
3960622 | 1976-06-01 | partially searchable | N | Y | Y |
3961722 | 1976-06-08 | partially searchable | N | Y | Y |
3961852 | 1976-06-08 | partially searchable | N | Y | Y |
3961853 | 1976-06-08 | partially searchable | N | Y | Y |
3964778 | 1976-06-22 | partially searchable | N | Y | Y |
3966388 | 1976-06-29 | partially searchable | N | Y | Y |
3966396 | 1976-06-29 | partially searchable | Y | Y | Y |
3967066 | 1976-06-29 | partially searchable | N | Y | Y |
3968524 | 1976-07-13 | partially searchable | N | Y | Y |
3969960 | 1976-07-20 | partially searchable | N | Y | Y |
3970709 | 1976-07-20 | partially searchable | N | Y | Y |
3970807 | 1976-07-20 | partially searchable | N | Y | Y |
3982944 | 1976-09-28 | partially searchable | N | Y | Y |
3982945 | 1976-09-28 | partially searchable | N | Y | Y |
3983991 | 1976-10-05 | partially searchable | N | Y | Y |
3984529 | 1976-10-05 | partially searchable | Y | Y | Y |
3986868 | 1976-10-19 | partially searchable | N | Y | Y |
3989820 | 1976-11-02 | partially searchable | N | Y | Y |
3990515 | 1976-11-09 | partially searchable | N | Y | Y |
3991224 | 1976-11-09 | partially searchable | N | Y | Y |
3992538 | 1976-11-16 | partially searchable | N | Y | Y |
3992704 | 1976-11-16 | partially searchable | N | Y | Y |
3994732 | 1976-11-30 | partially searchable | N | Y | Y |
3995162 | 1976-11-30 | partially searchable | N | Y | Y |
3997784 | 1976-12-14 | partially searchable | N | Y | Y |
4004892 | 1977-01-25 | partially searchable | Y | Y | Y |
4008242 | 1977-02-15 | partially searchable | N | Y | Y |
4009440 | 1977-02-22 | partially searchable | N | Y | Y |
4009605 | 1977-03-01 | partially searchable | Y | Y | Y |
4010111 | 1977-03-01 | partially searchable | N | Y | Y |
4010112 | 1977-03-01 | partially searchable | N | Y | Y |
4010127 | 1977-03-01 | partially searchable | N | Y | Y |
4010128 | 1977-03-01 | partially searchable | N | Y | Y |
4010175 | 1977-03-01 | partially searchable | N | Y | Y |
4010452 | 1977-03-01 | partially searchable | N | Y | Y |
4011910 | 1977-03-15 | partially searchable | N | Y | Y |
4012940 | 1977-03-22 | partially searchable | N | Y | Y |
4013780 | 1977-03-22 | partially searchable | N | Y | Y |
4015718 | 1977-04-05 | partially searchable | N | Y | Y |
4016076 | 1977-04-05 | partially searchable | N | Y | Y |
4016179 | 1977-04-05 | partially searchable | N | Y | Y |
4016221 | 1977-04-05 | partially searchable | N | Y | Y |
4016305 | 1977-04-05 | partially searchable | N | Y | Y |
4016976 | 1977-04-12 | partially searchable | N | Y | Y |
4017161 | 1977-04-12 | partially searchable | N | Y | Y |
4017322 | 1977-04-12 | partially searchable | N | Y | Y |
4017389 | 1977-04-12 | partially searchable | N | Y | Y |
4017609 | 1977-04-12 | partially searchable | N | Y | Y |
4017618 | 1977-04-12 | partially searchable | N | Y | Y |
4017712 | 1977-04-12 | partially searchable | N | Y | Y |
4019460 | 1977-04-26 | partially searchable | N | Y | Y |
4024868 | 1977-05-24 | partially searchable | Y | Y | Y |
4026893 | 1977-05-31 | partially searchable | N | Y | Y |
4026977 | 1977-05-31 | partially searchable | N | Y | Y |
4027030 | 1977-05-31 | partially searchable | N | Y | Y |
4032576 | 1977-06-28 | partially searchable | N | Y | Y |
4033492 | 1977-07-05 | partially searchable | N | Y | Y |
4035446 | 1977-07-12 | partially searchable | N | Y | Y |
4040783 | 1977-08-09 | partially searchable | N | Y | Y |
4040791 | 1977-08-09 | partially searchable | N | Y | Y |
4040826 | 1977-08-09 | partially searchable | N | Y | Y |
4042294 | 1977-08-16 | partially searchable | Y | Y | Y |
4042387 | 1977-08-16 | partially searchable | N | Y | Y |
4042477 | 1977-08-16 | partially searchable | N | Y | Y |
4043408 | 1977-08-23 | partially searchable | N | Y | Y |
4046281 | 1977-09-06 | partially searchable | N | Y | Y |
4048529 | 1977-09-13 | partially searchable | N | Y | Y |
4048656 | 1977-09-13 | partially searchable | N | Y | Y |
4051060 | 1977-09-27 | partially searchable | N | Y | Y |
4051061 | 1977-09-27 | partially searchable | N | Y | Y |
4052330 | 1977-10-04 | partially searchable | N | Y | Y |
4053675 | 1977-10-11 | partially searchable | N | Y | Y |
4054190 | 1977-10-18 | partially searchable | N | Y | Y |
4058593 | 1977-11-15 | partially searchable | N | Y | Y |
4058934 | 1977-11-22 | partially searchable | N | Y | Y |
4060128 | 1977-11-29 | partially searchable | N | Y | Y |
4064167 | 1977-12-20 | partially searchable | N | Y | Y |
4064943 | 1977-12-27 | partially searchable | N | Y | Y |
4065590 | 1977-12-27 | partially searchable | N | Y | Y |
4066338 | 1978-01-03 | partially searchable | N | Y | Y |
4067236 | 1978-01-10 | partially searchable | Y | Y | Y |
4067281 | 1978-01-10 | partially searchable | N | Y | Y |
4067895 | 1978-01-10 | partially searchable | N | Y | Y |
4070725 | 1978-01-31 | partially searchable | N | Y | Y |
4071514 | 1978-01-31 | partially searchable | Y | Y | Y |
4082989 | 1978-04-04 | partially searchable | N | Y | Y |
4084109 | 1978-04-11 | partially searchable | N | Y | Y |
4085757 | 1978-04-25 | partially searchable | Y | Y | Y |
4091051 | 1978-05-23 | partially searchable | N | Y | Y |
4093494 | 1978-06-06 | partially searchable | N | Y | Y |
4097517 | 1978-06-27 | fully searchable | N | Y | Y |
4105706 | 1978-08-08 | partially searchable | N | Y | Y |
4119626 | 1978-10-10 | partially searchable | N | Y | Y |
4120860 | 1978-10-17 | partially searchable | N | Y | Y |
4137203 | 1979-01-30 | partially searchable | N | Y | Y |
4140162 | 1979-02-20 | partially searchable | N | Y | Y |
4142896 | 1979-03-06 | partially searchable | N | Y | Y |
4148808 | 1979-04-10 | partially searchable | N | Y | Y |
4151103 | 1979-04-24 | partially searchable | N | Y | Y |
4153915 | 1979-05-08 | partially searchable | N | Y | Y |
4154917 | 1979-05-15 | partially searchable | Y | Y | Y |
4160807 | 1979-07-10 | partially searchable | N | Y | Y |
4160931 | 1979-07-10 | partially searchable | N | Y | Y |
4162335 | 1979-07-24 | partially searchable | Y | Y | Y |
4163071 | 1979-07-31 | partially searchable | N | Y | Y |
4177133 | 1979-12-04 | partially searchable | N | Y | Y |
4179901 | 1979-12-25 | partially searchable | N | Y | Y |
4189935 | 1980-02-26 | partially searchable | N | Y | Y |
4193297 | 1980-03-18 | partially searchable | N | Y | Y |
4205396 | 1980-05-27 | partially searchable | N | Y | Y |
4209112 | 1980-06-24 | partially searchable | Y | Y | Y |
4252923 | 1981-02-24 | partially searchable | Y | Y | Y |
4252990 | 1981-02-24 | partially searchable | Y | Y | Y |
4276415 | 1981-06-30 | partially searchable | Y | Y | Y |
4281334 | 1981-07-28 | partially searchable | Y | Y | Y |
4301982 | 1981-11-24 | partially searchable | Y | Y | Y |
4311002 | 1982-01-19 | partially searchable | Y | Y | Y |
4316968 | 1982-02-23 | partially searchable | Y | Y | Y |
4321708 | 1982-03-23 | partially searchable | Y | Y | Y |
4322341 | 1982-03-30 | partially searchable | Y | Y | Y |
4334283 | 1982-06-08 | partially searchable | Y | Y | Y |
4337499 | 1982-06-29 | partially searchable | Y | Y | Y |
4347399 | 1982-08-31 | partially searchable | Y | Y | Y |
4349466 | 1982-09-14 | partially searchable | Y | Y | Y |
4354500 | 1982-10-19 | partially searchable | Y | Y | Y |
4354501 | 1982-10-19 | partially searchable | Y | Y | Y |
4356522 | 1982-10-26 | partially searchable | Y | Y | Y |
4364214 | 1982-12-21 | partially searchable | Y | Y | Y |
4369678 | 1983-01-25 | partially searchable | Y | Y | Y |
4382867 | 1983-05-10 | partially searchable | Y | Y | Y |
4386171 | 1983-05-31 | partially searchable | Y | Y | Y |
4388879 | 1983-06-21 | partially searchable | Y | Y | Y |
4401511 | 1983-08-30 | partially searchable | Y | Y | Y |
4420687 | 1983-12-13 | partially searchable | Y | Y | Y |
4424514 | 1984-01-03 | fully searchable | Y | Y | Y |
4433996 | 1984-02-28 | partially searchable | Y | Y | Y |
4433997 | 1984-02-28 | partially searchable | Y | Y | Y |
4447250 | 1984-05-08 | partially searchable | Y | Y | Y |
4473462 | 1984-09-25 | partially searchable | Y | Y | Y |
4480077 | 1984-10-30 | fully searchable | Y | Y | Y |
4487876 | 1984-12-11 | fully searchable | Y | Y | Y |
4490276 | 1984-12-25 | partially searchable | Y | Y | Y |
4503137 | 1985-03-05 | partially searchable | Y | Y | Y |
4558191 | 1985-12-10 | partially searchable | Y | Y | Y |
4620084 | 1986-10-28 | partially searchable | Y | Y | Y |
4645531 | 1987-02-24 | partially searchable | Y | Y | Y |
4704648 | 1987-11-03 | fully searchable | Y | Y | Y |
4704721 | 1987-11-03 | fully searchable | Y | Y | Y |
4705017 | 1987-11-10 | fully searchable | Y | Y | Y |
4705031 | 1987-11-10 | fully searchable | Y | Y | Y |
4705032 | 1987-11-10 | fully searchable | Y | Y | Y |
4705036 | 1987-11-10 | fully searchable | Y | Y | Y |
4705037 | 1987-11-10 | fully searchable | Y | Y | Y |
4705097 | 1987-11-10 | fully searchable | Y | Y | Y |
4705107 | 1987-11-10 | fully searchable | Y | Y | Y |
4705125 | 1987-11-10 | fully searchable | Y | Y | Y |
4705142 | 1987-11-10 | fully searchable | Y | Y | Y |
4705169 | 1987-11-10 | fully searchable | Y | Y | Y |
4705170 | 1987-11-10 | fully searchable | Y | Y | Y |
4705230 | 1987-11-10 | fully searchable | Y | Y | Y |
4705274 | 1987-11-10 | fully searchable | Y | Y | Y |
4705328 | 1987-11-10 | fully searchable | Y | Y | Y |
4705412 | 1987-11-10 | fully searchable | Y | Y | Y |
4705416 | 1987-11-10 | fully searchable | Y | Y | Y |
4705437 | 1987-11-10 | fully searchable | Y | Y | Y |
4705455 | 1987-11-10 | fully searchable | Y | Y | Y |
4705462 | 1987-11-10 | fully searchable | Y | Y | Y |
4782789 | 1988-11-08 | partially searchable | Y | Y | Y |
4938892 | 1990-07-03 | partially searchable | Y | Y | Y |
4947381 | 1990-08-07 | partially searchable | Y | Y | Y |
4953540 | 1990-09-04 | partially searchable | Y | Y | Y |
4954955 | 1990-09-04 | partially searchable | Y | Y | Y |
4956028 | 1990-09-11 | partially searchable | Y | Y | Y |
4960922 | 1990-10-02 | partially searchable | Y | Y | Y |
4963562 | 1990-10-16 | partially searchable | Y | Y | Y |
4981859 | 1991-01-01 | partially searchable | Y | Y | Y |
4994927 | 1991-02-19 | partially searchable | Y | Y | Y |
5009956 | 1991-04-23 | partially searchable | Y | Y | Y |
5026795 | 1991-06-25 | partially searchable | Y | Y | Y |
5060646 | 1991-10-29 | partially searchable | Y | Y | Y |
5075785 | 1991-12-24 | partially searchable | Y | Y | Y |
5082960 | 1992-01-21 | partially searchable | Y | Y | Y |
5089501 | 1992-02-18 | partially searchable | Y | Y | Y |
5096482 | 1992-03-17 | partially searchable | Y | Y | Y |
5128084 | 1992-07-07 | partially searchable | Y | Y | Y |
5128719 | 1992-07-07 | partially searchable | Y | Y | Y |
5150588 | 1992-09-29 | partially searchable | Y | Y | Y |
5150752 | 1992-09-29 | partially searchable | Y | Y | Y |
5151296 | 1992-09-29 | partially searchable | Y | Y | Y |
5162542 | 1992-11-10 | partially searchable | Y | Y | Y |
5196503 | 1993-03-23 | partially searchable | Y | Y | Y |
5202960 | 1993-04-13 | partially searchable | Y | Y | Y |
5258510 | 1993-11-02 | partially searchable | Y | Y | Y |
5260365 | 1993-11-09 | partially searchable | Y | Y | Y |
5262383 | 1993-11-16 | partially searchable | Y | Y | Y |
5300546 | 1994-04-05 | partially searchable | Y | Y | Y |
5300583 | 1994-04-05 | partially searchable | Y | Y | Y |
5324727 | 1994-06-28 | partially searchable | Y | Y | Y |
5423835 | 1995-06-13 | partially searchable | Y | Y | Y |
5490180 | 1996-02-06 | partially searchable | Y | Y | Y |
5493812 | 1996-02-27 | fully searchable | Y | Y | Y |
5509710 | 1996-04-23 | fully searchable | Y | Y | Y |
5537451 | 1996-07-16 | partially searchable | Y | Y | Y |
5567115 | 1996-10-22 | partially searchable | Y | Y | Y |
5647301 | 1997-07-15 | partially searchable | Y | Y | Y |
5687635 | 1997-11-18 | partially searchable | Y | Y | Y |
5697964 | 1997-12-16 | fully searchable | Y | Y | Y |
5721216 | 1998-02-24 | partially searchable | Y | Y | Y |
5775961 | 1998-07-07 | partially searchable | Y | Y | Y |
5780035 | 1998-07-14 | partially searchable | Y | Y | Y |
5782628 | 1998-07-21 | partially searchable | Y | Y | Y |
5797003 | 1998-08-18 | partially searchable | Y | Y | Y |
5807733 | 1998-09-15 | partially searchable | Y | Y | Y |
5817623 | 1998-10-06 | partially searchable | Y | Y | Y |
5827889 | 1998-10-27 | partially searchable | Y | Y | Y |
5829312 | 1998-11-03 | partially searchable | Y | Y | Y |
5830465 | 1998-11-03 | partially searchable | Y | Y | Y |
5860381 | 1999-01-19 | partially searchable | Y | Y | Y |
5901831 | 1999-05-11 | partially searchable | Y | Y | Y |
5922850 | 1999-07-13 | fully searchable | Y | Y | N |
5948654 | 1999-09-07 | partially searchable | Y | Y | Y |
5992909 | 1999-11-30 | partially searchable | Y | Y | N |
6060090 | 2000-05-09 | partially searchable | Y | Y | Y |
6068996 | 2000-05-30 | partially searchable | Y | Y | N |
6087542 | 2000-07-11 | fully searchable | Y | Y | Y |
6102900 | 2000-08-15 | partially searchable | Y | Y | Y |
6154400 | 2000-11-28 | partially searchable | Y | Y | Y |
6165768 | 2000-12-26 | partially searchable | Y | Y | Y |
6206989 | 2001-03-27 | partially searchable | Y | Y | Y |
6287179 | 2001-09-11 | missing | Y | Y | N |
6347059 | 2002-02-12 | fully searchable | Y | Y | Y |
6392191 | 2002-05-21 | missing | Y | Y | N |
6394333 | 2002-05-28 | missing | Y | Y | N |
6558580 | 2003-05-06 | missing | Y | Y | N |
6680878 | 2004-01-20 | fully searchable | Y | Y | Y |
6988922 | 2006-01-24 | fully searchable | Y | Y | Y |
7151114 | 2006-12-19 | fully searchable | Y | Y | Y |
7200832 | 2007-04-03 | fully searchable | Y | Y | Y |
7464613 | 2008-12-16 | fully searchable | Y | Y | Y |
7488564 | 2009-02-10 | fully searchable | Y | Y | Y |
7606803 | 2009-10-20 | fully searchable | Y | Y | Y |
8309694 | 2012-11-13 | fully searchable | Y | Y | Y |
8455078 | 2013-06-04 | fully searchable | Y | Y | N |
D244877 | 1977-06-28 | partially searchable | N | Y | N/A |
D245794 | 1977-09-13 | partially searchable | N | Y | N/A |
D245796 | 1977-09-13 | partially searchable | N | Y | N/A |
D253680 | 1979-12-18 | partially searchable | N | Y | N/A |
D255500 | 1980-06-17 | partially searchable | N | Y | N/A |
D255961 | 1980-07-22 | partially searchable | N | Y | N/A |
D258139 | 1981-02-03 | partially searchable | Y | Y | N/A |
D263515 | 1982-03-23 | partially searchable | Y | Y | N/A |
D266687 | 1982-10-26 | partially searchable | Y | Y | N/A |
D267976 | 1983-02-15 | partially searchable | Y | Y | N/A |
D270707 | 1983-09-27 | partially searchable | Y | Y | N/A |
D275431 | 1984-09-11 | partially searchable | Y | Y | N/A |
D276130 | 1984-10-30 | partially searchable | Y | Y | N/A |
D279048 | 1985-06-04 | partially searchable | Y | Y | N/A |
D288908 | 1987-03-24 | partially searchable | Y | Y | N/A |
D303715 | 1989-09-26 | partially searchable | Y | Y | N/A |
D312641 | 1990-12-04 | partially searchable | Y | Y | N/A |
D318037 | 1991-07-09 | partially searchable | Y | Y | N/A |
D363898 | 1995-11-07 | partially searchable | Y | Y | N/A |
D363899 | 1995-11-07 | partially searchable | Y | Y | N/A |
D364118 | 1995-11-14 | partially searchable | Y | Y | N/A |
D364120 | 1995-11-14 | partially searchable | Y | Y | N/A |
D364121 | 1995-11-14 | partially searchable | Y | Y | N/A |
D364123 | 1995-11-14 | partially searchable | Y | Y | N/A |
D364362 | 1995-11-21 | partially searchable | Y | Y | N/A |
D364363 | 1995-11-21 | partially searchable | Y | Y | N/A |
D380415 | 1997-07-01 | partially searchable | Y | Y | N/A |
D386122 | 1997-11-11 | partially searchable | Y | Y | N/A |
D387010 | 1997-12-02 | partially searchable | Y | Y | N/A |
D400471 | 1998-11-03 | partially searchable | Y | Y | N/A |
D403371 | 1998-12-29 | partially searchable | Y | Y | N/A |
PP4832 | 1982-03-23 | partially searchable | N | Y | No |
PP9451 | 1996-02-06 | partially searchable | N | Y | No |
PP9453 | 1996-02-13 | partially searchable | N | Y | No |
RE28699 | 1976-01-27 | partially searchable | N | Y | No |
RE28723 | 1976-02-24 | partially searchable | N | Y | No |
RE28854 | 1976-06-08 | partially searchable | N | Y | No |
RE29295 | 1977-07-05 | partially searchable | N | Y | No |
RE29489 | 1977-12-06 | partially searchable | N | Y | No |
RE29490 | 1977-12-06 | partially searchable | N | Y | No |
RE29535 | 1978-02-07 | partially searchable | N | Y | No |
RE29605 | 1978-04-04 | partially searchable | N | Y | No |
RE29949 | 1979-03-27 | partially searchable | Y | Y | No |
RE30889 | 1982-03-23 | partially searchable | Y | Y | No |
RE32038 | 1985-11-26 | partially searchable | Y | Y | No |
RE32039 | 1985-11-26 | partially searchable | Y | Y | No |
RE32040 | 1985-11-26 | partially searchable | Y | Y | No |
RE32041 | 1985-11-26 | partially searchable | Y | Y | No |
RE33615 | 1991-06-18 | partially searchable | Y | Y | No |
RE35179 | 1996-03-12 | partially searchable | Y | Y | No |
RE35959 | 1998-11-17 | partially searchable | Y | Y | No |
RE36105 | 1999-02-16 | partially searchable | Y | Y | No |
RE36141 | 1999-03-09 | partially searchable | Y | Y | No |
RE36227 | 1999-06-08 | partially searchable | Y | Y | No |
RE36254 | 1999-07-13 | partially searchable | Y | Y | No |