Proximity Home PageResources to create and apply insight





Main Page

Ordering Information

Register

Q & A


  Features

  • MetroProfile
  • Comparative Analysis
  • Ranking Analysis
  • Metro Map Viewer
  • Database & Updates
 
MetroDynamics: Ranking Analysis

MetroDynamics (MD) is a relational database management system that knits together disparate data from many sources centric to metropolitan areas using the Core-Based Statistical Area (CBSA) code. MD data are for varying time intervals (start and end dates) and relate to different reference dates/time units including month, quarter, and year. An important feature of MD is the ability to extract selected subject matter so that you can rank, view, and analyze data of interest to you.

As an example, you can view/analyze the most recent population estimates side-by-side with employment for the most quarter for and industry/type of business of interest to you. By using the MD table building operation, you can select data on establishments, employment, and earnings by type of business from approximately 1,500 types of business (the number of types of business vary by metro and average 1,500 across all metros).

A summary of the fields and content in the standard extract table generated by the MD build table operation is presented below. After you build the table, it becomes immediately available for the MD built-in ranking analysis. You are also able to open this file in other applications, such as Excel or Access, that can process dbase file structures.

Item Description Attributes Source
RANK Dynamic Rank Computed during ranking Dynamic
NAME CBSA Name   OMB/Census
CODE CBSA Code   OMB/Census
EST05 Establishments, most recent year /1 By type of business /3 BLS/CEW
EMP05 Employment, most recent year /1 By type of business /3 /W BLS/CEW
WAGES05 Wages, most recent year /1 By type of business /3 /W BLS/CEW
AWW05 Avg Weekly Wages, most recent year /1By type of business /3 /W BLS/CEW
PAY05 Pay, most recent year /1 By type of business /3 /W BLS/CEW
EMP06Q2 Employment, Past Quarter /2 By type of business /3 /W BLS/CEW
EMP06Q3 Employment, Current Qtr /2 By type of business /3 /W BLS/CEW
EMPQC Employment, Change Q1-Q2 By type of business /3 /W Computed
EMPQPCT Employment, Percent Change Q1-Q2 By type of business /3 /W Computed
EST06Q2 Establishments, Past Quarter /2 By type of business /3 BLS/CEW
EST06Q3 Establishments, Current Qtr /2 By type of business /3 BLS/CEW
ESTQC Establishments, Change Q1-Q2 By type of business /3 Computed
ESTQPCT Establishments, Percent Change Q1-Q2 By type of business /3 Computed
AWW06Q2 Avg Weekly Wages, Past Qtr /2 By type of business /3 /W BLS/CEW
AWW06Q3 Avg Weekly Wages, Current Qtr /2 By type of business /3 /W BLS/CEW
QCAWW Avg Weekly Wages, Change Q1-Q2 /2 By type of business /3 /W Computed
QCAWWPCT Avg Weekly Wages, Pct Change Q1-Q2 By type of business /3 /W Computed
HPI1 Housing Price Index, Same Qtr Prev Yr /2   OFFEO
HPI2 Housing Price Index, Current Qtr /2   OFFEO
HPIC Housing Price Index, Change Q1-Q2   Computed
HPICPCT Housing Price Index, Pct Change Q1-Q2   Computed
P2000 Population, 7/1/00   Census Bureau
P2006 Population, 7/1 most recent year   Census Bureau
P0006 Population, Change Change 2000-latest year   Computed
P0006PCT Population, Pct Change 2000-latest year   Computed
PCI2000 Per Capita Personal Income, 2000   BEA
PCI2004 Per Capita Personal Income, most recent year   BEA
PCI0004 Per Capita Personal Income, 2000-latest year   Computed
PCI0004PCTPer Capita Personal Income, Pct Change 2000-latest year   Computed
EMP2000 Full & Part-time Employment, 2000 /W BEA
EMP2004 Full & Part-time Employment, most recent year /W BEA
EMP0004 Full & Part-time Employment, 2000-latest year /W Computed
EMP0004PCTFull & Part-time Employment, Pct Change 2000-latest year /W Computed
D51001 Total Population, 2005   Census/ACS 2005
D51032   White (one race), 2005   Census/ACS 2005
D51032p   % White (one race), 2005   Census/ACS 2005
D51033   Black (one race), 2005   Census/ACS 2005
D51033p   % Black (one race), 2005   Census/ACS 2005
D51034   American Indian or Alaska Native (one race), 2005   Census/ACS 2005
D51034p   % American Indian or Alaska Native (one race), 2005   Census/ACS 2005
D51039   Asian (one race), 2005   Census/ACS 2005
D51039p   % Asian (one race), 2005   Census/ACS 2005
D51047   Native Hawaii & Other Pacific Islander (one race), 2005   Census/ACS 2005
D51047p   % Native Hawaii & Other Pacific Islander (one race), 2005   Census/ACS 2005
D51066   Hispanic, 2005   Census/ACS 2005
D51066p   % Hispanic, 2005   Census/ACS 2005
D52015 Percent high school graduate or higher, 2005 of pop 25 years & over Census/ACS 2005
D52016 Percent bachelor's degree or higher, 2005 of pop 25 years & over Census/ACS 2005
D53001 Population 16 Years and Over, 2005   Census/ACS 2005
D53002   In Labor Force, 2005 /R Census/ACS 2005
D53003     Civilian Labor Force, 2005 /R Census/ACS 2005
D53004     Employed, 2005 /R Census/ACS 2005
D53004p     % Employed, 2005 of total pop age 16 yrs & over Census/ACS 2005
D53005     Unemployed, 2005 /R Census/ACS 2005
D53005p     % Unemployed, 2005 of civilian labor force Census/ACS 2005
D53061 Median Household Income, 2005 /R Census/ACS 2005
D54001 Total Housing Units, 2005   Census/ACS 2005
D54002   Occupied Housing Units, 2005   Census/ACS 2005
D54002p   % Occupied Housing Units, 2005   Census/ACS 2005
D54003   Vacant Housing Units, 2005   Census/ACS 2005
D54003p   % Vacant Housing Units, 2005   Census/ACS 2005
D54079 Median Value, Occupied Housing Units, 2005   Census/ACS 2005

/1 Current year: most recent year in database
/2 Current quarter: most recent quarter in database
  Past quarter: previous quarter to most recent quarter in database
/3 Based on NAICS code selected by user when table created
/W by place of work
/R by place of residence


Copyright © . Proximity. All Rights Reserved.
Sitemap | Contact Us | News