ZIP*Data II:Database Layouts - Revision history

Admin at 20:42, 14 August 2024

2024-08-14T20:42:31Z

← Older revision		Revision as of 20:42, 14 August 2024
Line 74:		Line 74:
	!Code		!Code
	!style="border-right:0px;"\|Definition		!style="border-right:0px;"\|Definition
	\|-
	~~\|A\|\|Airport Mail Facility (AMF)~~
	\|-		\|-
	\|B\|\|Branch		\|B\|\|Branch
	\|-		\|-
	\|C\|\|Community Post Office (BMF)		\|C\|\|Community Post Office (BMF)
	\|-
	~~\|D\|\|Area Distribution Center~~
	\|-
	~~\|E\|\|Sectional Center Facility (SCF)~~
	\|-
	~~\|F\|\|Delivery Distribution Center~~
	\|-
	~~\|G\|\|General Mail Facility~~
	\|-
	~~\|K\|\|Bulk Mail Center~~
	\|-
	~~\|M\|\|Money Order Unit~~
	\|-		\|-
	\|N\|\|Community Name, Former Postal Facility or Place Name		\|N\|\|Community Name, Former Postal Facility or Place Name
	\|-		\|-
	\|P\|\|Post Office		\|P\|\|Post Office
	\|-
	~~\|S\|\|Station~~
	\|-		\|-
	\|U\|\|Urbanization		\|U\|\|Urbanization

2022-08-11T17:31:36Z

2022-06-08T00:41:42Z

← Older revision		Revision as of 00:41, 8 June 2022
Line 206:		Line 206:
	\|-		\|-
	\|CBSADivision		\|CBSADivision
	\|~~char~~		\|Char
	\|5		\|5
	\|The numeric code for the division within the CBSA containing the ZIP Code. Some CBSA’s are broken into parts known as divisions.		\|The numeric code for the division within the CBSA containing the ZIP Code. Some CBSA’s are broken into parts known as divisions.

2022-06-08T00:11:01Z

← Older revision		Revision as of 00:11, 8 June 2022
Line 206:		Line 206:
	\|-		\|-
	\|CBSADivision		\|CBSADivision
	\|~~Varchar~~		\|char
	\|1		\|5
	\|The numeric code for the division within the CBSA containing the ZIP Code. Some CBSA’s are broken into parts known as divisions.		\|The numeric code for the division within the CBSA containing the ZIP Code. Some CBSA’s are broken into parts known as divisions.
	\|-		\|-
	\|CBSADivisionTitle		\|CBSADivisionTitle
	\|~~Char~~		\|Varchar
	\|5		\|50
	\|The official U.S. Census Bureau’s official name for the division within the CBSA containing the ZIP Code.		\|The official U.S. Census Bureau’s official name for the division within the CBSA containing the ZIP Code.
	\|-		\|-
	\|CBSADivisionStatus		\|CBSADivisionStatus
	\|Varchar		\|Varchar
	\|50		\|1
	\|		\|
	{\|class="alternate01" cellspacing="0"		{\|class="alternate01" cellspacing="0"

2021-09-21T18:21:20Z

2021-09-20T23:11:34Z

2021-07-29T23:49:12Z

← Older revision	Revision as of 23:49, 29 July 2021
(No difference)

2019-08-22T22:49:25Z

← Older revision		Revision as of 22:49, 22 August 2019
Line 260:		Line 260:
	\|A code representing the ZIP Code time zone.		\|A code representing the ZIP Code time zone.
	{\|class="alternate01" cellspacing="0"		{\|class="alternate01" cellspacing="0"
	!~~Hours~~		!Code
	!style="border-right:0px;"\|Time Zone		!style="border-right:0px;"\|Time Zone
	\|-		\|-

2019-08-22T22:21:34Z

← Older revision		Revision as of 22:21, 22 August 2019
Line 258:		Line 258:
	\|-		\|-
	\|Time Zone		\|Time Zone
	\|~~The number of hours past UTC Time Standard~~.		\|A code representing the ZIP Code time zone.
	{\|class="alternate01" cellspacing="0"		{\|class="alternate01" cellspacing="0"
	!Hours		!Hours
	!style="border-right:0px;"\|Time Zone		!style="border-right:0px;"\|Time Zone
	\|-		\|-
	\|4		\|AKST
	\|~~Atlantic~~		\|Alaska Standard Time
	\|-		\|-
	\|5		\|AST
	\|~~Eastern~~		\|Atlantic Standard time
	\|-		\|-
	\|6		\|CHST
	\|~~Central~~		\|Chamorro Standard Time
	\|-		\|-
	\|7		\|CST
	\|~~Mountain~~		\|Central Standard Time
	\|-		\|-
	\|7		\|EST
	\|~~Arizona~~		\|Eastern Standard Time
	\|-		\|-
	\|8		\|HAST
	\|~~Pacific~~		\|Hawaiian-Aleutian Standard Time
	\|-		\|-
	\|9		\|HST
	\|~~Alaska~~		\|Hawaii Standard time
	\|-		\|-
	\|10		\|MHT
	\|~~Hawaii-Aleutian~~		\|Marshall Islands Time
	\|-		\|-
	\|11		\|MST
	\|~~Samoa~~		\|Mountain Standard Time / Mountain Time
	\|-		\|-
	\|13		\|PST
	\|~~Marshall Islands~~		\|Pacific Standard Time / Pacific Time
	\|-		\|-
	\|14		\|PWT
	\|~~Guam~~		\|Palau Time (standard time)
	\|-		\|-
	\|15		\|SST
	\|~~Palau~~		\|Samoa Standard Time
	\|}		\|}

2017-08-30T16:40:59Z

@@ Line 256: / Line 256: @@
 |MedianHomeValue
 |The median home value in the ZIP Code.
 |}
 [[Category:ZIP*Data]]