Patent Table - Revision history

Carlin at 21:57, 2 September 2016

2016-09-02T21:57:29Z

2016-07-29T16:12:23Z

2016-07-29T15:47:40Z

2016-07-22T18:03:35Z

2016-07-22T17:57:33Z

Table Purpose

2016-07-22T17:57:18Z

Table Variables

2016-07-22T17:56:00Z

2016-07-22T17:31:43Z

Table Variables

2016-07-13T19:14:07Z

2016-07-13T19:10:30Z

← Older revision		Revision as of 21:57, 2 September 2016
Line 53:		Line 53:

	The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].		The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].
		+	[[Category: Internal]]
		+	[[Internal Classification: Data Tables\| ]]

@@ Line 1: / Line 1: @@
 Return to [[Patent]].
 ==Table Structure==
                        Table "public.patent"
@@ Line 46: / Line 50: @@
 Patent is the primary key for the table.
 ==Current Problems==
 The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].

← Older revision		Revision as of 15:47, 29 July 2016
Line 1:		Line 1:
−	Return to [[Patent ~~Data Specifications~~]].	+	Return to [[Patent]].

	==Table Structure==		==Table Structure==

@@ Line 47: / Line 47: @@
 ==Table Purpose==
+<section begin="patent" />
 ==Current Problems==
 The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].

@@ Line 47: / Line 47: @@
 ==Table Purpose==
 ==Current Problems==
 The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].

@@ Line 43: / Line 43: @@
 ==Table Variables==
 Patent stands for patent number. The gdate is the date each patent was granted. The priority date is the date of the earliest application filing that is given priority in determining the length of enforceability for the patent. Priority country is where the patent was originally filed. Priority patent number is the application number of the application that is given priority. CPCsubgroup is a classification number in the Cooperative Patent  Classification system. The PCTpatentnumber is a patent number given under the Patent Cooperative Treaty that allows countries to apply for international patent  rights. Claims gives how many claims are included in the patent. Appnum is the patent application number. Gyear is the year the patent was granted. The appdate is the date the patent application was filed and appyear is the year the patent application was filed. The NBER two digit code assigns a patent to a sub-category of granted utility patents developed by the NBER. The USPC (U.S. Patent Classification) codes categorize patents based on similar subject matter. USPC_sub codes subdivide patents within the same USPC class into sub-categories based on structural, procedural, or functional differences. [http://www.uspto.gov/sites/default/files/patents/resources/classification/overview.pdf]
 ==Table Purpose==

← Older revision		Revision as of 17:56, 22 July 2016
Line 42:		Line 42:

	==Table Variables==		==Table Variables==
		+	Patent stands for patent number. The gdate is the date each patent was granted. The priority date is the date of the earliest application filing that is given priority in determining the length of enforceability for the patent. Priority country is where the patent was originally filed. Priority patent number is the application number of the application that is given priority. CPCsubgroup is a classification number in the Cooperative Patent Classification system. The PCTpatentnumber is a patent number given under the Patent Cooperative Treaty that allows countries to apply for international patent rights. Claims gives how many claims are included in the patent. Appnum is the patent application number. Gyear is the year the patent was granted. The appdate is the date the patent application was filed and appyear is the year the patent application was filed. The NBER two digit code assigns a patent to a sub-category of granted utility patents developed by the NBER. The USPC (U.S. Patent Classification) codes categorize patents based on similar subject matter. USPC_sub codes subdivide patents within the same USPC class into sub-categories based on structural, procedural, or functional differences. [http://www.uspto.gov/sites/default/files/patents/resources/classification/overview.pdf]

	==Table Purpose==		==Table Purpose==

@@ Line 1: / Line 1: @@
 Return to [[Patent Data Specifications]].
                        Table "public.patent"
          Column        |       Type        | Modifiers
@@ Line 22: / Line 23: @@
      "patents_pkey" PRIMARY KEY, btree (patent)
      "patent_idx" UNIQUE, btree (patent)
   patent  |   gdate    | prioritydate | prioritycountry | prioritypatentnumber | cpcsubgroup |  pctpatentnumber  | claims |  appnum  | gyear |  appdate   | appyear | nber | uspc | uspc_sub
@@ Line 37: / Line 40: @@
   8580666 | 2013-11-12 |              |                 |                      | 28052       |                   |     16 | 13246146 |  2013 | 2011-09-27 |    2011 |   46 | 438  | 438
   8585041 | 2013-11-19 | 2011-11-02   | JP              | 2011-241111          | 18          |                   |      8 | 13664916 |  2013 | 2012-10-31 |    2012 |   51 | 271  | 271
 The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].

← Older revision		Revision as of 19:10, 13 July 2016
Line 37:		Line 37:
	8580666 \| 2013-11-12 \| \| \| \| 28052 \| \| 16 \| 13246146 \| 2013 \| 2011-09-27 \| 2011 \| 46 \| 438 \| 438		8580666 \| 2013-11-12 \| \| \| \| 28052 \| \| 16 \| 13246146 \| 2013 \| 2011-09-27 \| 2011 \| 46 \| 438 \| 438
	8585041 \| 2013-11-19 \| 2011-11-02 \| JP \| 2011-241111 \| 18 \| \| 8 \| 13664916 \| 2013 \| 2012-10-31 \| 2012 \| 51 \| 271 \| 271		8585041 \| 2013-11-19 \| 2011-11-02 \| JP \| 2011-241111 \| 18 \| \| 8 \| 13664916 \| 2013 \| 2012-10-31 \| 2012 \| 51 \| 271 \| 271
		+
		+	The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].