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. patft 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 patft, 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:
  1. Make an xml file available that contains the data for the 305 missing patents.
  2. Add plant and reissued cpcs to the existing bulk cpc file or produce a new file with these cpcs.
  3. Fix the 261 patents in patft that are not fully searchable.
  4. Confirm or deny whether the four patents missing from patft 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 patft if they were not). The patents are in PEDS and not in the withdrawn list.
  5. Add to PEDS the 123 patents with an N in the in_peds column below.
  6. 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_noissue_datepatft_statusin_pedsin_bulk_uspcsin_bulk_cpcs
39312631976-01-06partially searchableNYY
39322041976-01-13partially searchableNYY
39340731976-01-20partially searchableNYY
39422131976-03-09partially searchableNYY
39463411976-03-23partially searchableNYY
39491741976-04-06partially searchableNYY
39569831976-05-18partially searchableNYY
39606221976-06-01partially searchableNYY
39617221976-06-08partially searchableNYY
39618521976-06-08partially searchableNYY
39618531976-06-08partially searchableNYY
39647781976-06-22partially searchableNYY
39663881976-06-29partially searchableNYY
39663961976-06-29partially searchableYYY
39670661976-06-29partially searchableNYY
39685241976-07-13partially searchableNYY
39699601976-07-20partially searchableNYY
39707091976-07-20partially searchableNYY
39708071976-07-20partially searchableNYY
39829441976-09-28partially searchableNYY
39829451976-09-28partially searchableNYY
39839911976-10-05partially searchableNYY
39845291976-10-05partially searchableYYY
39868681976-10-19partially searchableNYY
39898201976-11-02partially searchableNYY
39905151976-11-09partially searchableNYY
39912241976-11-09partially searchableNYY
39925381976-11-16partially searchableNYY
39927041976-11-16partially searchableNYY
39947321976-11-30partially searchableNYY
39951621976-11-30partially searchableNYY
39977841976-12-14partially searchableNYY
40048921977-01-25partially searchableYYY
40082421977-02-15partially searchableNYY
40094401977-02-22partially searchableNYY
40096051977-03-01partially searchableYYY
40101111977-03-01partially searchableNYY
40101121977-03-01partially searchableNYY
40101271977-03-01partially searchableNYY
40101281977-03-01partially searchableNYY
40101751977-03-01partially searchableNYY
40104521977-03-01partially searchableNYY
40119101977-03-15partially searchableNYY
40129401977-03-22partially searchableNYY
40137801977-03-22partially searchableNYY
40157181977-04-05partially searchableNYY
40160761977-04-05partially searchableNYY
40161791977-04-05partially searchableNYY
40162211977-04-05partially searchableNYY
40163051977-04-05partially searchableNYY
40169761977-04-12partially searchableNYY
40171611977-04-12partially searchableNYY
40173221977-04-12partially searchableNYY
40173891977-04-12partially searchableNYY
40176091977-04-12partially searchableNYY
40176181977-04-12partially searchableNYY
40177121977-04-12partially searchableNYY
40194601977-04-26partially searchableNYY
40248681977-05-24partially searchableYYY
40268931977-05-31partially searchableNYY
40269771977-05-31partially searchableNYY
40270301977-05-31partially searchableNYY
40325761977-06-28partially searchableNYY
40334921977-07-05partially searchableNYY
40354461977-07-12partially searchableNYY
40407831977-08-09partially searchableNYY
40407911977-08-09partially searchableNYY
40408261977-08-09partially searchableNYY
40422941977-08-16partially searchableYYY
40423871977-08-16partially searchableNYY
40424771977-08-16partially searchableNYY
40434081977-08-23partially searchableNYY
40462811977-09-06partially searchableNYY
40485291977-09-13partially searchableNYY
40486561977-09-13partially searchableNYY
40510601977-09-27partially searchableNYY
40510611977-09-27partially searchableNYY
40523301977-10-04partially searchableNYY
40536751977-10-11partially searchableNYY
40541901977-10-18partially searchableNYY
40585931977-11-15partially searchableNYY
40589341977-11-22partially searchableNYY
40601281977-11-29partially searchableNYY
40641671977-12-20partially searchableNYY
40649431977-12-27partially searchableNYY
40655901977-12-27partially searchableNYY
40663381978-01-03partially searchableNYY
40672361978-01-10partially searchableYYY
40672811978-01-10partially searchableNYY
40678951978-01-10partially searchableNYY
40707251978-01-31partially searchableNYY
40715141978-01-31partially searchableYYY
40829891978-04-04partially searchableNYY
40841091978-04-11partially searchableNYY
40857571978-04-25partially searchableYYY
40910511978-05-23partially searchableNYY
40934941978-06-06partially searchableNYY
40975171978-06-27fully searchableNYY
41057061978-08-08partially searchableNYY
41196261978-10-10partially searchableNYY
41208601978-10-17partially searchableNYY
41372031979-01-30partially searchableNYY
41401621979-02-20partially searchableNYY
41428961979-03-06partially searchableNYY
41488081979-04-10partially searchableNYY
41511031979-04-24partially searchableNYY
41539151979-05-08partially searchableNYY
41549171979-05-15partially searchableYYY
41608071979-07-10partially searchableNYY
41609311979-07-10partially searchableNYY
41623351979-07-24partially searchableYYY
41630711979-07-31partially searchableNYY
41771331979-12-04partially searchableNYY
41799011979-12-25partially searchableNYY
41899351980-02-26partially searchableNYY
41932971980-03-18partially searchableNYY
42053961980-05-27partially searchableNYY
42091121980-06-24partially searchableYYY
42529231981-02-24partially searchableYYY
42529901981-02-24partially searchableYYY
42764151981-06-30partially searchableYYY
42813341981-07-28partially searchableYYY
43019821981-11-24partially searchableYYY
43110021982-01-19partially searchableYYY
43169681982-02-23partially searchableYYY
43217081982-03-23partially searchableYYY
43223411982-03-30partially searchableYYY
43342831982-06-08partially searchableYYY
43374991982-06-29partially searchableYYY
43473991982-08-31partially searchableYYY
43494661982-09-14partially searchableYYY
43545001982-10-19partially searchableYYY
43545011982-10-19partially searchableYYY
43565221982-10-26partially searchableYYY
43642141982-12-21partially searchableYYY
43696781983-01-25partially searchableYYY
43828671983-05-10partially searchableYYY
43861711983-05-31partially searchableYYY
43888791983-06-21partially searchableYYY
44015111983-08-30partially searchableYYY
44206871983-12-13partially searchableYYY
44245141984-01-03fully searchableYYY
44339961984-02-28partially searchableYYY
44339971984-02-28partially searchableYYY
44472501984-05-08partially searchableYYY
44734621984-09-25partially searchableYYY
44800771984-10-30fully searchableYYY
44878761984-12-11fully searchableYYY
44902761984-12-25partially searchableYYY
45031371985-03-05partially searchableYYY
45581911985-12-10partially searchableYYY
46200841986-10-28partially searchableYYY
46455311987-02-24partially searchableYYY
47046481987-11-03fully searchableYYY
47047211987-11-03fully searchableYYY
47050171987-11-10fully searchableYYY
47050311987-11-10fully searchableYYY
47050321987-11-10fully searchableYYY
47050361987-11-10fully searchableYYY
47050371987-11-10fully searchableYYY
47050971987-11-10fully searchableYYY
47051071987-11-10fully searchableYYY
47051251987-11-10fully searchableYYY
47051421987-11-10fully searchableYYY
47051691987-11-10fully searchableYYY
47051701987-11-10fully searchableYYY
47052301987-11-10fully searchableYYY
47052741987-11-10fully searchableYYY
47053281987-11-10fully searchableYYY
47054121987-11-10fully searchableYYY
47054161987-11-10fully searchableYYY
47054371987-11-10fully searchableYYY
47054551987-11-10fully searchableYYY
47054621987-11-10fully searchableYYY
47827891988-11-08partially searchableYYY
49388921990-07-03partially searchableYYY
49473811990-08-07partially searchableYYY
49535401990-09-04partially searchableYYY
49549551990-09-04partially searchableYYY
49560281990-09-11partially searchableYYY
49609221990-10-02partially searchableYYY
49635621990-10-16partially searchableYYY
49818591991-01-01partially searchableYYY
49949271991-02-19partially searchableYYY
50099561991-04-23partially searchableYYY
50267951991-06-25partially searchableYYY
50606461991-10-29partially searchableYYY
50757851991-12-24partially searchableYYY
50829601992-01-21partially searchableYYY
50895011992-02-18partially searchableYYY
50964821992-03-17partially searchableYYY
51280841992-07-07partially searchableYYY
51287191992-07-07partially searchableYYY
51505881992-09-29partially searchableYYY
51507521992-09-29partially searchableYYY
51512961992-09-29partially searchableYYY
51625421992-11-10partially searchableYYY
51965031993-03-23partially searchableYYY
52029601993-04-13partially searchableYYY
52585101993-11-02partially searchableYYY
52603651993-11-09partially searchableYYY
52623831993-11-16partially searchableYYY
53005461994-04-05partially searchableYYY
53005831994-04-05partially searchableYYY
53247271994-06-28partially searchableYYY
54238351995-06-13partially searchableYYY
54901801996-02-06partially searchableYYY
54938121996-02-27fully searchableYYY
55097101996-04-23fully searchableYYY
55374511996-07-16partially searchableYYY
55671151996-10-22partially searchableYYY
56473011997-07-15partially searchableYYY
56876351997-11-18partially searchableYYY
56979641997-12-16fully searchableYYY
57212161998-02-24partially searchableYYY
57759611998-07-07partially searchableYYY
57800351998-07-14partially searchableYYY
57826281998-07-21partially searchableYYY
57970031998-08-18partially searchableYYY
58077331998-09-15partially searchableYYY
58176231998-10-06partially searchableYYY
58278891998-10-27partially searchableYYY
58293121998-11-03partially searchableYYY
58304651998-11-03partially searchableYYY
58603811999-01-19partially searchableYYY
59018311999-05-11partially searchableYYY
59228501999-07-13fully searchableYYN
59486541999-09-07partially searchableYYY
59929091999-11-30partially searchableYYN
60600902000-05-09partially searchableYYY
60689962000-05-30partially searchableYYN
60875422000-07-11fully searchableYYY
61029002000-08-15partially searchableYYY
61544002000-11-28partially searchableYYY
61657682000-12-26partially searchableYYY
62069892001-03-27partially searchableYYY
62871792001-09-11missingYYN
63470592002-02-12fully searchableYYY
63921912002-05-21missingYYN
63943332002-05-28missingYYN
65585802003-05-06missingYYN
66808782004-01-20fully searchableYYY
69889222006-01-24fully searchableYYY
71511142006-12-19fully searchableYYY
72008322007-04-03fully searchableYYY
74646132008-12-16fully searchableYYY
74885642009-02-10fully searchableYYY
76068032009-10-20fully searchableYYY
83096942012-11-13fully searchableYYY
84550782013-06-04fully searchableYYN
D2448771977-06-28partially searchableNYN/A
D2457941977-09-13partially searchableNYN/A
D2457961977-09-13partially searchableNYN/A
D2536801979-12-18partially searchableNYN/A
D2555001980-06-17partially searchableNYN/A
D2559611980-07-22partially searchableNYN/A
D2581391981-02-03partially searchableYYN/A
D2635151982-03-23partially searchableYYN/A
D2666871982-10-26partially searchableYYN/A
D2679761983-02-15partially searchableYYN/A
D2707071983-09-27partially searchableYYN/A
D2754311984-09-11partially searchableYYN/A
D2761301984-10-30partially searchableYYN/A
D2790481985-06-04partially searchableYYN/A
D2889081987-03-24partially searchableYYN/A
D3037151989-09-26partially searchableYYN/A
D3126411990-12-04partially searchableYYN/A
D3180371991-07-09partially searchableYYN/A
D3638981995-11-07partially searchableYYN/A
D3638991995-11-07partially searchableYYN/A
D3641181995-11-14partially searchableYYN/A
D3641201995-11-14partially searchableYYN/A
D3641211995-11-14partially searchableYYN/A
D3641231995-11-14partially searchableYYN/A
D3643621995-11-21partially searchableYYN/A
D3643631995-11-21partially searchableYYN/A
D3804151997-07-01partially searchableYYN/A
D3861221997-11-11partially searchableYYN/A
D3870101997-12-02partially searchableYYN/A
D4004711998-11-03partially searchableYYN/A
D4033711998-12-29partially searchableYYN/A
PP48321982-03-23partially searchableNYNo
PP94511996-02-06partially searchableNYNo
PP94531996-02-13partially searchableNYNo
RE286991976-01-27partially searchableNYNo
RE287231976-02-24partially searchableNYNo
RE288541976-06-08partially searchableNYNo
RE292951977-07-05partially searchableNYNo
RE294891977-12-06partially searchableNYNo
RE294901977-12-06partially searchableNYNo
RE295351978-02-07partially searchableNYNo
RE296051978-04-04partially searchableNYNo
RE299491979-03-27partially searchableYYNo
RE308891982-03-23partially searchableYYNo
RE320381985-11-26partially searchableYYNo
RE320391985-11-26partially searchableYYNo
RE320401985-11-26partially searchableYYNo
RE320411985-11-26partially searchableYYNo
RE336151991-06-18partially searchableYYNo
RE351791996-03-12partially searchableYYNo
RE359591998-11-17partially searchableYYNo
RE361051999-02-16partially searchableYYNo
RE361411999-03-09partially searchableYYNo
RE362271999-06-08partially searchableYYNo
RE362541999-07-13partially searchableYYNo