Patent ID Table - Revision history

Carlin at 21:56, 2 September 2016

2016-09-02T21:56:51Z

MarcelaInteriano: /* Table Purpose */

2016-07-28T22:15:33Z

Table Purpose

MarcelaInteriano at 22:13, 28 July 2016

2016-07-28T22:13:41Z

MarcelaInteriano at 20:18, 28 July 2016

2016-07-28T20:18:23Z

MarcelaInteriano: /* Current Problems */

2016-07-28T15:59:57Z

Current Problems

MarcelaInteriano: /* Current Problems */

2016-07-28T15:59:48Z

Current Problems

MarcelaInteriano: /* Current Problems */

2016-07-28T15:58:02Z

Current Problems

MarcelaInteriano: /* Current Problems */

2016-07-28T15:57:51Z

Current Problems

MarcelaInteriano: /* Table Variables */

2016-07-28T15:54:40Z

Table Variables

MarcelaInteriano: /* Table Structure */

2016-07-27T18:08:47Z

Table Structure

← Older revision		Revision as of 21:56, 2 September 2016
Line 39:		Line 39:
	==Current Problems==		==Current Problems==
	{{#section:Patent_Data_Issues\|patentid}}		{{#section:Patent_Data_Issues\|patentid}}
		+	[[Category: Internal]]
		+	[[Internal Classification: Data Tables\| ]]

@@ Line 2: / Line 2: @@
 ==Table Purpose==
-<section begin="patentid />
+<section begin="patentid" />
 The Patent ID Table contains a record of all patents and patent applications involved in US assignments. The table includes all types of patents as well as foreign patents. Since the table identifies the type of patent as well as whether the patentid corresponds to a patent or an application number, the patents of interest, [[Patent Types|utility patents]], for the McNair Center academic projects may be distinguished and separated. Additionally, the Patent ID Table tracks the assignment history of a patent.
 <section end="patentid" />
 ==Table Structure==
                   Table "public.patentid"

@@ Line 2: / Line 2: @@
 ==Table Purpose==
-Allows us to find th epatents of interest for us (utility).
+<section begin="patentid />
 ==Table Structure==
                   Table "public.patentid"
@@ Line 32: / Line 34: @@
 ==Table Variables==
-Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate gives the date the assignment was recorded by the USPTO. Patentid is the patent number, either foreign or American, or the application number of the patent involved in the transaction. The country is the country of the original inventor or patent applicant. Kind identifies the type of patent, when it was granted, and whether the patentid corresponds to a patent or a patent application. The filing date is the date the patent application was filed. Inventiontitle is the title of the patent.
+Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate gives the date the assignment was recorded by the USPTO. Patentid is the patent number, either foreign or American, or the application number of the patent involved in the transaction. The patentid column entries are not only integers but also include letters indicating type of patent or foreign patents. The country is the country of the original inventor or patent applicant. Kind identifies the type of patent, when it was granted, and whether the patentid corresponds to a patent or a patent application. The filing date is the date the patent application was filed. Inventiontitle is the title of the patent.
 ==Current Problems==
 {{#section:Patent_Data_Issues|patentid}}

@@ Line 2: / Line 2: @@
 ==Table Purpose==
+Allows us to find th epatents of interest for us (utility).
 ==Table Structure==
                   Table "public.patentid"
@@ Line 32: / Line 32: @@
 ==Table Variables==
-Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor.
+Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate gives the date the assignment was recorded by the USPTO. Patentid is the patent number, either foreign or American, or the application number of the patent involved in the transaction. The country is the country of the original inventor or patent applicant. Kind identifies the type of patent, when it was granted, and whether the patentid corresponds to a patent or a patent application. The filing date is the date the patent application was filed. Inventiontitle is the title of the patent.
 ==Current Problems==
 {{#section:Patent_Data_Issues|patentid}}

← Older revision		Revision as of 15:59, 28 July 2016
Line 36:		Line 36:
	==Current Problems==		==Current Problems==
	{{#section:Patent_Data_Issues\|patentid}}		{{#section:Patent_Data_Issues\|patentid}}
−	~~{{#section:Patent_Data_Issues\|lexjudge}}~~

← Older revision		Revision as of 15:59, 28 July 2016
Line 35:		Line 35:

	==Current Problems==		==Current Problems==
−	{{#section:Patent_Data_Issues\| patentid}}	+	{{#section:Patent_Data_Issues\|patentid}}
		+	{{#section:Patent_Data_Issues\|lexjudge}}

← Older revision		Revision as of 15:58, 28 July 2016
Line 35:		Line 35:

	==Current Problems==		==Current Problems==
−	{{#section:Patent_Data_Issues\|patentid}}	+	{{#section:Patent_Data_Issues\| patentid}}

← Older revision		Revision as of 15:57, 28 July 2016
Line 35:		Line 35:

	==Current Problems==		==Current Problems==
		+	{{#section:Patent_Data_Issues\|patentid}}

← Older revision		Revision as of 15:54, 28 July 2016
Line 32:		Line 32:

	==Table Variables==		==Table Variables==
		+	Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor.

	==Current Problems==		==Current Problems==