Difference between revisions of "MSA Wage Table"

From edegan.com
Jump to navigation Jump to search
(Created page with "Return to Patent Data Specifications. Table "public.msawage" Column | Type | Modifiers ----------------------...")
 
Line 26: Line 26:
  
  
  fips  |                            area                            | year_2000 | year_2001 | year_2002 | year_2003 | year_2004 | year_2005 | year_2006 | year_2007 | year_2008  
+
  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
+
  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
+
  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
+
  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
+
  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
+
  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
+
  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
+
  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
+
  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
+
  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
+
  24540 | Greeley, CO (Metropolitan Statistical Area)                |  2192156 |  2336366 |  2467713 |  2526951 |  2683003 |  2843108 |  3088574 |  3353496 |  3534668 |  3296657 |  3363728

Revision as of 12:51, 13 July 2016

Return to Patent Data Specifications.

                      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) |


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