Difference between revisions of "MSA Wage Table"
Jump to navigation
Jump to search
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
Return to [[Patent Data Specifications]]. | Return to [[Patent Data Specifications]]. | ||
| + | ==Table Structure== | ||
Table "public.msawage" | Table "public.msawage" | ||
Column | Type | Modifiers | Column | Type | Modifiers | ||
| Line 25: | Line 26: | ||
area_formatted_brackets | character varying(200) | | area_formatted_brackets | character varying(200) | | ||
| + | Example of table entries: | ||
fips | area | year_2000 | year_2001 | year_2002 | year_2003 | year_2004 | year_2005 | year_2006 | year_2007 | year_2008 | year_2009 | year_2010 | fips | area | year_2000 | year_2001 | year_2002 | year_2003 | year_2004 | year_2005 | year_2006 | year_2007 | year_2008 | year_2009 | year_2010 | ||
| Line 38: | Line 40: | ||
19740 | Denver-Aurora-Lakewood, CO (Metropolitan Statistical Area) | 51486474 | 52821396 | 52383692 | 52930729 | 55314026 | 58232191 | 62400252 | 66354988 | 68516060 | 66183671 | 67271495 | 19740 | Denver-Aurora-Lakewood, CO (Metropolitan Statistical Area) | 51486474 | 52821396 | 52383692 | 52930729 | 55314026 | 58232191 | 62400252 | 66354988 | 68516060 | 66183671 | 67271495 | ||
24540 | Greeley, CO (Metropolitan Statistical Area) | 2192156 | 2336366 | 2467713 | 2526951 | 2683003 | 2843108 | 3088574 | 3353496 | 3534668 | 3296657 | 3363728 | 24540 | Greeley, CO (Metropolitan Statistical Area) | 2192156 | 2336366 | 2467713 | 2526951 | 2683003 | 2843108 | 3088574 | 3353496 | 3534668 | 3296657 | 3363728 | ||
| + | |||
| + | fips | area | year_2011 | year_2012 | derived_are | msacode | msasupercode | area_formatted | area_formatted_brackets | ||
| + | ------+------------------------------------------------------------+-----------+-----------+-------------+---------+--------------+--------------------------------+-------------------------------- | ||
| + | 11260 | Anchorage, AK (Metropolitan Statistical Area) | 10090405 | 10594411 | AK | 380 | 380 | Anchorage, AK ( ) | Anchorage, AK ( ) | ||
| + | 44700 | Stockton-Lodi, CA (Metropolitan Statistical Area) | 8879206 | 9110692 | CA | 7320 | 7320 | Stockton-Lodi, CA ( ) | Stockton-Lodi, CA ( ) | ||
| + | 17020 | Chico, CA (Metropolitan Statistical Area) | 2714947 | 2828240 | CA | 7320 | 7320 | Chico, CA ( ) | Chico, CA ( ) | ||
| + | 20940 | El Centro, CA (Metropolitan Statistical Area) | 2137730 | 2201545 | CA | 7320 | 7320 | El Centro, CA ( ) | El Centro, CA ( ) | ||
| + | 14500 | Boulder, CO (Metropolitan Statistical Area) | 9313734 | 9850436 | CO | 2080 | 16 | Boulder, CO ( ) | Boulder, CO ( ) | ||
| + | 22660 | Fort Collins, CO (Metropolitan Statistical Area) | 5935538 | 6220280 | CO | 2080 | 16 | Fort Collins, CO ( ) | Fort Collins, CO ( ) | ||
| + | 39380 | Pueblo, CO (Metropolitan Statistical Area) | 2288748 | 2346371 | CO | 2080 | 16 | Pueblo, CO ( ) | Pueblo, CO ( ) | ||
| + | 17820 | Colorado Springs, CO (Metropolitan Statistical Area) | 13659312 | 14012710 | CO | 2080 | 16 | Colorado Springs, CO ( ) | Colorado Springs, CO ( ) | ||
| + | 19740 | Denver-Aurora-Lakewood, CO (Metropolitan Statistical Area) | 70351087 | 74791193 | CO | 2080 | 16 | Denver-Aurora-Lakewood, CO ( ) | Denver-Aurora-Lakewood, CO ( ) | ||
| + | 24540 | Greeley, CO (Metropolitan Statistical Area) | 3638651 | 3916170 | CO | 2080 | 16 | Greeley, CO ( ) | Greeley, CO ( ) | ||
| + | |||
| + | ==Table Variables== | ||
| + | ==Table Purpose== | ||
| + | ==Current Problems== | ||
| + | [[Category: Internal]] | ||
| + | [[Internal Classification: Data Tables| ]] | ||
Latest revision as of 16:43, 2 September 2016
Return to Patent Data Specifications.
Table Structure
Table "public.msawage"
Column | Type | Modifiers
------------------------+------------------------+-----------
fips | bigint |
area | character varying(200) |
year_2000 | bigint |
year_2001 | bigint |
year_2002 | bigint |
year_2003 | bigint |
year_2004 | bigint |
year_2005 | bigint |
year_2006 | bigint |
year_2007 | bigint |
year_2008 | bigint |
year_2009 | bigint |
year_2010 | bigint |
year_2011 | bigint |
year_2012 | bigint |
derived_are | character varying |
msacode | integer |
msasupercode | integer |
area_formatted | character varying(200) |
area_formatted_brackets | character varying(200) |
Example of table entries:
fips | area | year_2000 | year_2001 | year_2002 | year_2003 | year_2004 | year_2005 | year_2006 | year_2007 | year_2008 | year_2009 | year_2010 ------+------------------------------------------------------------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+----------- 11260 | Anchorage, AK (Metropolitan Statistical Area) | 5711506 | 6293180 | 6667099 | 6969784 | 7393457 | 7824171 | 8249578 | 8784452 | 9254789 | 9557363 | 9774606 44700 | Stockton-Lodi, CA (Metropolitan Statistical Area) | 6258508 | 6745468 | 7087380 | 7506553 | 7936461 | 8248293 | 8690322 | 9163532 | 9301303 | 8894536 | 8761826 17020 | Chico, CA (Metropolitan Statistical Area) | 1941482 | 2063167 | 2161375 | 2207859 | 2321523 | 2446534 | 2609351 | 2752485 | 2742205 | 2645686 | 2645104 20940 | El Centro, CA (Metropolitan Statistical Area) | 1290868 | 1385535 | 1475087 | 1573063 | 1621033 | 1730615 | 1863209 | 1998139 | 2119384 | 2094094 | 2101838 14500 | Boulder, CO (Metropolitan Statistical Area) | 8624732 | 8638782 | 7284976 | 7321119 | 7684009 | 8034613 | 8474168 | 8922102 | 9172240 | 8617451 | 8886119 22660 | Fort Collins, CO (Metropolitan Statistical Area) | 4127240 | 4351219 | 4473322 | 4535700 | 4732453 | 4979239 | 5263065 | 5554087 | 5712337 | 5544362 | 5653806 39380 | Pueblo, CO (Metropolitan Statistical Area) | 1521987 | 1616409 | 1656415 | 1692722 | 1800943 | 1804734 | 1899822 | 2053809 | 2167417 | 2150006 | 2181773 17820 | Colorado Springs, CO (Metropolitan Statistical Area) | 9343878 | 9839936 | 9947724 | 10134373 | 10659293 | 11372005 | 11920387 | 12406706 | 12805191 | 12829785 | 13213039 19740 | Denver-Aurora-Lakewood, CO (Metropolitan Statistical Area) | 51486474 | 52821396 | 52383692 | 52930729 | 55314026 | 58232191 | 62400252 | 66354988 | 68516060 | 66183671 | 67271495 24540 | Greeley, CO (Metropolitan Statistical Area) | 2192156 | 2336366 | 2467713 | 2526951 | 2683003 | 2843108 | 3088574 | 3353496 | 3534668 | 3296657 | 3363728
fips | area | year_2011 | year_2012 | derived_are | msacode | msasupercode | area_formatted | area_formatted_brackets ------+------------------------------------------------------------+-----------+-----------+-------------+---------+--------------+--------------------------------+-------------------------------- 11260 | Anchorage, AK (Metropolitan Statistical Area) | 10090405 | 10594411 | AK | 380 | 380 | Anchorage, AK ( ) | Anchorage, AK ( ) 44700 | Stockton-Lodi, CA (Metropolitan Statistical Area) | 8879206 | 9110692 | CA | 7320 | 7320 | Stockton-Lodi, CA ( ) | Stockton-Lodi, CA ( ) 17020 | Chico, CA (Metropolitan Statistical Area) | 2714947 | 2828240 | CA | 7320 | 7320 | Chico, CA ( ) | Chico, CA ( ) 20940 | El Centro, CA (Metropolitan Statistical Area) | 2137730 | 2201545 | CA | 7320 | 7320 | El Centro, CA ( ) | El Centro, CA ( ) 14500 | Boulder, CO (Metropolitan Statistical Area) | 9313734 | 9850436 | CO | 2080 | 16 | Boulder, CO ( ) | Boulder, CO ( ) 22660 | Fort Collins, CO (Metropolitan Statistical Area) | 5935538 | 6220280 | CO | 2080 | 16 | Fort Collins, CO ( ) | Fort Collins, CO ( ) 39380 | Pueblo, CO (Metropolitan Statistical Area) | 2288748 | 2346371 | CO | 2080 | 16 | Pueblo, CO ( ) | Pueblo, CO ( ) 17820 | Colorado Springs, CO (Metropolitan Statistical Area) | 13659312 | 14012710 | CO | 2080 | 16 | Colorado Springs, CO ( ) | Colorado Springs, CO ( ) 19740 | Denver-Aurora-Lakewood, CO (Metropolitan Statistical Area) | 70351087 | 74791193 | CO | 2080 | 16 | Denver-Aurora-Lakewood, CO ( ) | Denver-Aurora-Lakewood, CO ( ) 24540 | Greeley, CO (Metropolitan Statistical Area) | 3638651 | 3916170 | CO | 2080 | 16 | Greeley, CO ( ) | Greeley, CO ( )
