
Use GPCI values listed under MSA 5160 in the file. This represents Baldwin County, AL The MSA number is 5160. The state code01, county code003. Each MSA has a GPCI value for work, practice expense, and malpractice. Where there is a MSA/PMSA/NECMA number listed for the county, use the GPCI values for that MSA.

Use this reference:Tools » Reference Files » Geographies » USA - Metropolitan Areas (CBSA) - 2010 Based » worksheet:Metropolitan Areas by StateFor example, Connecticut contains four MSAs, with geo codes of IUSA_MBRP, IUSA_MHAR, IUSA_MNEH and IUSA_MNOW.Menu:Tools » Geography Lists » Create a new list3. Determine which MSAs are within the state of interest. It's pointless for us to embed the state geo code within the MSA geo code, hence there's no commonality on which to formulate a wild card.Instead, you can create and apply a custom geo list, which can contain any combination of geo codes, in a specific order.1. Fort Smith, AR-OK) or even three (e.g., Wilmington DE-MD-NJ). Many MSAs cross state borders, so you can think of them as "belonging" to two states (e.g. For example, PA denotes Pennsylvania, PA011 is Berks County within Pennsylvania, and PA^^^ is a geo wild card for all counties in Pennsylvania.Unfortunately, it's not so simple with metro areas.
County To Msa Crosswalk Download Separate Series
Instead, you can write a formula. This will retrieve four separate time series.You can download separate series using a wild card, but you cannot write a wild card expression that will aggregate the series to one value. In the Description column, click "GEO LIST" and in the popup menu, "View Expanded List." If no such series exist, the Title column will be blank.)5.

