Difference between revisions of "MSA Wage Table"

From edegan.com
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 17:43, 2 September 2016

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

Table Variables

Table Purpose

Current Problems