PATENT npl_class: Parsing and Consolidation ?

[cverluise]

Hello,

Since v0.2-npl, we have introduced a PATENT npl_class

Question

How should this class of citations be structured and consolidated?

Food for thoughts

Below is a sample of 100 citations for this class.

WITH
  tmp AS (
  SELECT
    npl_publn_id
  FROM
    `npl-parsing.patcit.v02_npl`
  WHERE
    npl_class="PATENT")
SELECT
  npl_biblio
FROM
  `usptobias.patstat.tls214` AS tls214,
  tmp
WHERE
  tmp.npl_publn_id = tls214.npl_publn_id

Row	npl_biblio
1	Specification and Drawings for U.S. Appl. No. 13/718,951, filed Dec. 18, 2012, 64 pages.
2	Eto (US Application No. 14/666,752) date 3/24/2015
3	PATENT ABSTRACTS OF JAPAN vol. 3, no. 54 6 July 1979 (1979-07-06)
4	PATENT ABSTRACTS OF JAPAN, vol. 6, no. 162 (P-137)[1040], 25th August 1982; & JP-A- 57 078 670 (HITACHI SEISAKUSHO K.K.) 17-05-1982
5	Google Content-Targeted Advertising FAQ (Mar. 12, 2007).
6	PATENT ABSTRACTS OF JAPAN vol. 015, no. 461 (C - 0887) 22 November 1991 (1991-11-22)
7	U.S. Appl. No. 12/701,089 / Issue Fee Payment, filed May 15, 2014, 1 page.
8	PATENT ABSTRACTS OF JAPAN vol. 0120, no. 89 (E - 592) 23 March 1988 (1988-03-23)
9	PATENT ABSTRACTS OF JAPAN vol. 1995, no. 09 31 October 1995 (1995-10-31)
10	U.S. Appl. No. 13/663,022, filed Oct. 29, 2012.
11	Machine Translation, Kameda et al., JP 2003-213369, Jul. 2003.
12	U.S. Appl. No. 10/837,142, filed on Apr. 30, 2004.
13	JP 07.248211A (Toyota Central Research & Development Lab Inc.), Sep. 26, 1995.
14	Patent Abstracts of Japan vol 6 no 181 (M-156) 1982 & JP 57 088 963 A
15	Ohashi 717 discloses an ink ejecting device having a multi layer protective film for electrode.
16	PATENT ABSTRACTS OF JAPAN vol. 1996, no. 10 31 October 1996 (1996-10-31)
17	PATENT ABSTRACTS OF JAPAN vol. 011, no. 080 (C - 409) 11 March 1987 (1987-03-11)
18	U.S. Appl. No. 14/598,568, filed Jan. 16, 2015, Vascular Implant and Delivery Method.
19	PATENT ABSTRACTS OF JAPAN vol. 1999, no. 08 30 June 1999 (1999-06-30)
20	CN 2928231 Y, Bai et al. Derwent, Abstract, English Translation, Aug. 1, 2007.
21	U.S. Appl. No. 14/332,828, filed Jul. 16, 2014, Customizing Offers for Sales of Combinations of Virtual Items.
22	PATENT ABSTRACTS OF JAPAN vol. 008, no. 281 (E - 286) 21 December 1984 (1984-12-21)
23	PATENT ABSTRACTS OF JAPAN vol. 015, no. 443 (M - 1178) 12 November 1991 (1991-11-12)
24	Patent Abstracts of Japan, vol. 7, No. 9, Japanese Publication No. JP57168051, Oct. 16, 1982.
25	JP 2-118251 A., In: Patents Abstracts of Japan, Sect. M-1001, July 23, 1990, Vol. 14, No. 339
26	PATENT ABSTRACTS OF JAPAN vol. 8, no. 80 (M - 289) 12 April 1984 (1984-04-12)
27	Patent Abstracts of Japan, Publication No. 2000 057483, Published on Feb. 25, 2000, Nippon Telegr. & AMP; Teleph Corp.
28	PATENT ABSTRACTS OF JAPAN vol. 010, no. 154 (P - 463) 4 June 1986 (1986-06-04)
29	'Patent Abstracts of Japan', Vol. 12, No. 424 (M-761), Nov. 10, 1988 & JP 63 159040 A (Sumitomo Rubber Ind Ltd), Jul. 1, 1988.
30	PATENT ABSTRACTS OF JAPAN vol. 012, no. 071 (P - 673) 5 March 1988 (1988-03-05)
31	Inert Anode Containing Oxides of Nickel, Iron and Zinc Useful for the Electrolytic Production of Metals-Ray et al., U.S. Ser. No. 09/542,318, filed Apr. 4, 2000.
32	U.S. Appl. No. 13/113,231, filed May 23, 2011, David M. Garrison.
33	PATENT ABSTRACTS OF JAPAN vol. 006, no. 026 (M - 112) 16 February 1982 (1982-02-16)
34	PATENT ABSTRACTS OF JAPAN
35	U.S. Appl. No. 60/189,862.
36	'INJECTION, FONCTIONNEMENT AFFIN ET MAINTENANCE FACILIT E', REVUE TECHNIQUE AUTOMOBILE, vol. 50, no. 570, 1 February 1995 (1995-02-01), pages XXVI - XXXIII, XP000494843
37	ERNEST M.HODNETT等，: 'Schiff bases of salicylaldehyde and their cobalt(II) derivatives as antitumor agents', 《PROCEEDINGS OF THE OKLAHOMA ACADEMY OF SCIENCE》
38	Translation of Opponents Grounds of Appeal Sep. 8, 2010 (EP Patent No. 1539115).
39	English Abstract CN102643985, 'Method for extracting valuable metals from high-iron bauxite with step-by-step acid leaching', published on Aug. 22, 2012.
40	RoHS-Richtlinie 2011/65/EU
41	U.S. Appl. No. 14/102,379, filed Dec. 10, 2013, Fernando.
42	U.S. Appl. No. 09/739,122, Mar. 17, 2004, Interview Summary.
43	U.S. Appl. No. 14/350,467, filed Apr. 8, 2014, Cimpeanu, et al.
44	U.S. Appl. No. 61/073,542, entitled “Dynamic Media Bit Rates Based on Enterprise Data Transfer Policies,” filed Jun. 18, 2008.
45	U.S. Appl. No. 12/792,008, filed Jun. 2, 2010, Duane E. Kerr.
46	U.S. Appl. No. 12/913,650, filed Oct. 27, 2010, Dholakia et al.
47	U.S. Appl. No. 14/226,421, Amendment and Response filed Aug. 5, 2016, 8 pgs.
48	Authors et al. Apparatus and Method of Tenant Context Generation and Propagation in SaaS Environment. Aug. 19, 2010. IP.com. pp. 1-4.
49	Anthony Anthony et al., Pending specification, claims, figures for U.S. Appl. No. 09/996,355, Claims 1-73; filed Nov. 29, 2001.
50	U.S. Appl. No. 61/706,692, by Xiang Li, filed Sep. 27, 2012.
51	Junker, E., 2004, PIRSCH, 2: 4-10
52	Patent Abstracts of Japan, 13, 355 (P-914) for JP 1-114780, dated May 8, 1989.
53	DATABASE WPI ON EPOQUE, Week 9109, LONDON: DERWENT PUBLICATIONS LTD., AN 91-058363, Class D16; & BR,A,89 03571 (CRUZ F O).
54	Patent Abstracts of Japan, vol. 96, No. 10, Oct. 31, 1996 & JP 08 167801 A (Murata Mfg Co Ltd), Jun. 25, 1996, abstract.
55	PATENT ABSTRACTS OF JAPAN vol. 010, no. 140 (P - 458) 23 May 1986 (1986-05-23)
56	PATENT ABSTRACTS OF JAPAN vol. 017, no. 279 (M - 1419) 28 May 1993 (1993-05-28)
57	Patent Abstract of Japan, for publication No.: 10-228431.
58	Patent Abstract of Japanese Application No. 4 140783, May 14, 1992.
59	JP 2003003944 A (Abstract)
60	Gregory Nieminen. U.S. Appl. No. 11/458,040, entitled 'Mitral Valve Annuloplasty Device with Twisted Anchor,' filed Jul. 17, 2006.
61	PATENT ABSTRACTS OF JAPAN vol. 009, no. 132 (M - 385) 7 June 1985 (1985-06-07)
62	Kilpatrick Stockton, LLP, Answers to Complaint, Affirmative Defenses and Counterclaims, dated Feb. 4, 2010.
63	File History for U.S. Appl. No. 12/638,692, filed Dec. 15, 2009, Inventor: Timothy Haines.
64	U.S. Appl. No. 11/933,019, filed Oct. 31, 2007, Kurth et al.
65	United States Patent and Trademark Office, 'Notice of Allowance and Fee(s) Due,' U.S. Appl. No. 12/420,907, May 6, 2010.
66	Machine translation of the description of JP 2003340190 A.
67	U.S. Appl. No. 12/990,296, filed Mar. 1, 2011, Claremon et al.
68	Su, Qiaojuan, et al., U.S. Appl. No. 12/234,435 titled, 'Directional Expression-Based Scientific Information Knowledge Management,' filed Sep. 19, 2008.
69	Patent Abstracts of Japan vol. 017, No. 332 (P-1562), Jun. 23, 1993 & JP 05 040418 A (Canon Inc.).
70	Patent Abstracts of Japan & JP 62002560 A. E-511, May 30,1987,Vol.11,No.169
71	Abstract: Nakano et al., 'Biodegradable microspheres for Prolonged Anesthesia', HCAPLUS 102:209896 (1985).
72	PATENT ABSTRACTS OF JAPAN vol. 095, no. 004 31 May 1995 (1995-05-31)
73	WPI Abstract accession no. 99-076491 & JP10316720 Kunhoseokyui [2/12/98]
74	Translation, Tokairin, JP H05-299702, Translation Date June 2013, FLS, Inc., all pages.
75	PATENT ABSTRACTS OF JAPAN vol. 009, no. 307 (M - 435) 4 December 1985 (1985-12-04)
76	PATENT ABSTRACTS OF JAPAN vol. 009, no. 234 (E - 344) 20 September 1985 (1985-09-20)
77	English language abstract of German Publication No.3920879.
78	Patent Abstracts of Japan vol. 018, No. 335 (M-1627), Jun. 24, 1994 & JP 06 080071 A (Sumitomo Electric Ind Ltd), Mar. 22, 1994, siehe Zusammenfassung; Abbildungen 1,2,5,6.
79	PATENT ABSTRACTS OF JAPAN vol. 013, no. 067 (M - 798) 15 February 1989 (1989-02-15)
80	PATENT ABSTRACTS OF JAPAN vol. 017, no. 327 (C - 1073) 22 June 1993 (1993-06-22)
81	Ltd. Tetsutani Nippon Aerosil - Google machine translation of webpage http://www.tetsutani.co.jp/ganryou_evo_04.html downloaded on September 13, 2014.
82	U.S. Appl. No. 11/763,363, filed Jun. 14, 2007, James Reztlaff II; Thomas Ryan, 'Search Results Generation and Sorting.'
83	U.S. Appl. No. 61/154,945, filed Feb. 24, 2009.
84	PATENT ABSTRACTS OF JAPAN vol. 017, no. 264 (E - 1370) 24 May 1993 (1993-05-24)
85	U.S. Application No. 08/664,262 filed May 13, 1996 Automatic Funds Processing System.
86	DATABASE WPI Week 8527, Derwent World Patents Index; AN 85-162563
87	U.S. Appl. No. 60/198,014, Bretl et al.
88	English translation of JP 06 211511, Aug. 1994.
89	Persson, Carl J., et al., 'Head-up Display Communication System and Method', filed Nov. 6, 2007, U.S. Appl. No. 11/936,074.
90	PATENT ABSTRACTS OF JAPAN vol. 012, no. 491 (C - 554) 21 December 1988 (1988-12-21)
91	PATENT ABSTRACTS OF JAPAN vol. 014, no. 165 (P - 1030) 30 March 1990 (1990-03-30)
92	U.S. Appl. No. 10/761,524, filed Jan. 21, 2004, Robert Wham.
93	Kato et al.: 'Wireless IC Device and Wireless IC Device Composite Component'; U.S. Appl. No. 12/276,444, filed Nov. 24, 2008.
94	PATENT ABSTRACTS OF JAPAN vol. 017, no. 085 (E - 1322) 19 February 1993 (1993-02-19)
95	Pending U.S. Patent Application entitled 'Data Breakout Appliance At the Edge of a Mobile Data Network', U.S. Appl. No. 13/297,807, filed Nov. 16, 2011 by William F. Berg et al.
96	PATENT ABSTRACTS OF JAPAN vol. 1995, no. 08 29 September 1995 (1995-09-29)
97	PATENT ABSTRACTS OF JAPAN vol. 1998, no. 13 30 November 1998 (1998-11-30)
98	PATENT ABSTRACTS OF JAPAN vol. 1998, no. 02 30 January 1998 (1998-01-30)
99	PATENT ABSTRACTS OF JAPAN vol. 015, no. 181 (C - 0830) 9 May 1991 (1991-05-09)
100	PATENT ABSTRACTS OF JAPAN vol. 1998, no. 09 31 July 1998 (1998-07-31)

Open questions

• Need for further sub-classification? If yes, which sub-classes?
• Fields to be parsed?
• Corpus/ reference database for consolidation?

I leave these questions open to discussion.

Cheers

[cverluise]

Some ideas:

• Corpus: Patent abstracts of Japan, derwent abstract, etc
• Corpus metadata: volume, issue, date
• Patent: original, status (consolidation), orgname (consolidation), epodoc (consolidation)

[cverluise]

Hello,

Some thoughts on the consolidation task.

There is a key question: from the bibliographical data reported on the Patent Abstracts of Japan, can we get back a high quality/richer database. Here is what I was able to find on the EPO website

Where can I find English abstracts of Japanese patent documents?
You can find English abstracts of Japanese patent documents (Patent Abstracts of Japan, PAJ) on the website of the JPO's Japan Platform for Patent Information (J-PlatPat). The JPA include bibliographic information, the abstract and a representative drawing for Japanese unexamined patent publications from 1976 to date. Due to the translation work involved, the time delay between publication of an unexamined patent application in Japan and the availability of the corresponding PAJ abstract is approximately four months.
https://www.epo.org/service-support/faq/searching-patents/asian/japan.html

There is also this document which explains how to access PAJ on the JpatPlat website. However, I still can't find how to map the data in PAJ citations (e.g. "PATENT ABSTRACTS OF JAPAN vol. 017, no. 279 (M - 1419) 28 May 1993 (1993-05-28)" to a publication_number... which is what we want in the end.

Cheers