FILE LAYOUT FOR 00CA_MSA.DBF 2000 COUNTY EDITION OF DUSA - METRO FILE ITEM FIELDNAME FORMAT CONTENTS ____ __________ _______ ________ 1 MSA_FIPSST {A2} FIPS STATE OF THE METROPOLITAN AREA 2 MSA_CODE {A4} METROPOLITAN AREA CODE 3 MSA_NAME {A45} METROPOLITAN AREA NAME 4 XCOORD {I11} X COORDINATE 5 YCOORD {I11} Y COORDINATE 6 TOT_POP {I10} TOTAL POPULATION 7 POPCHG9000 {F10.1} POP CHANGE FROM CENSUS TO ESTIMATE YEAR 8 WHT_POP {I10} WHITE POPULATION 9 BLK_POP {I10} BLACK POPULATION 10 APAC_POP {I10} ASIAN PACIFIC ISLANDER POPULATION 11 HSP_POP {I10} HISPANIC POPULATION 12 DENSITY {I10} POPULATION PER SQUARE MILE (DENSITY) 13 TOT_HHLD {I10} TOTAL HOUSEHOLDS 14 EBI {I10} EFFECTIVE BUYING INCOME ($000) 15 BPI {F10.4} BUYING POWER INDEX 16 ECOPRI_BPI {F10.4} ECONOMY PRICED BPI 17 MODPRI_BPI {F10.4} MODERATE PRICED BPI 18 PREPRI_BPI {F10.4} PREMIUM PRICED BPI 19 TMAL_POP {I10} TOTAL MALE POPULATION 20 TFEM_POP {I10} TOTAL FEMALE POPULATION 21 MAL_MED {F10.1} TOTAL MALE MEDIAN AGE 22 FEM_MED {F10.1} TOTAL FEMALE MEDIAN AGE 23 TMAL_0_5 {I10} TOTAL MALE POPULATION 0-5 YEARS OLD 24 TMAL_6_11 {I10} TOTAL MALE POPULATION 6-11 YEARS OLD 25 TMAL_12_17 {I10} TOTAL MALE POPULATION 12-17 YEARS OLD 26 TMAL_18_24 {I10} TOTAL MALE POPULATION 18-24 YEARS OLD 27 TMAL_25_34 {I10} TOTAL MALE POPULATION 25-34 YEARS OLD 28 TMAL_35_44 {I10} TOTAL MALE POPULATION 35-44 YEARS OLD 29 TMAL_45_54 {I10} TOTAL MALE POPULATION 45-54 YEARS OLD 30 TMAL_55_64 {I10} TOTAL MALE POPULATION 55-64 YEARS OLD 31 TMAL_65_74 {I10} TOTAL MALE POPULATION 65-74 YEARS OLD 32 TMAL_75P {I10} TOTAL MALE POPULATION 75 PLUS YEARS OLD 33 TFEM_0_5 {I10} TOTAL FEMALE POPULATION 0-5 YEARS OLD 34 TFEM_6_11 {I10} TOTAL FEMALE POPULATION 6-11 YEARS OLD 35 TFEM_12_17 {I10} TOTAL FEMALE POPULATION 12-17 YEARS OLD 36 TFEM_18_24 {I10} TOTAL FEMALE POPULATION 18-24 YEARS OLD 37 TFEM_25_34 {I10} TOTAL FEMALE POPULATION 25-34 YEARS OLD 38 TFEM_35_44 {I10} TOTAL FEMALE POPULATION 35-44 YEARS OLD 39 TFEM_45_54 {I10} TOTAL FEMALE POPULATION 45-54 YEARS OLD 40 TFEM_55_64 {I10} TOTAL FEMALE POPULATION 55-64 YEARS OLD 41 TFEM_65_74 {I10} TOTAL FEMALE POPULATION 65-74 YEARS OLD 42 TFEM_75P {I10} TOTAL FEMALE POPULATION 75 PLUS YEARS OLD 43 IND_MAGE_M {I10} MEDIAN AGE INDEX, MALES 44 IND_MAGE_F {I10} MEDIAN AGE INDEX, FEMALES 45 AHH_L25 {I10} TOTAL AGE OF HOUSEHOLDER - <25 YEARS OLD 46 AHH_25_34 {I10} TOTAL AGE OF HOUSEHOLDER - 25-34 YEARS OLD 47 AHH_35_44 {I10} TOTAL AGE OF HOUSEHOLDER - 35-44 YEARS OLD 48 AHH_45_54 {I10} TOTAL AGE OF HOUSEHOLDER - 45-54 YEARS OLD 49 AHH_55_64 {I10} TOTAL AGE OF HOUSEHOLDER - 55-64 YEARS OLD 50 AHH_65P {I10} TOTAL AGE OF HOUSEHOLDER - 65 PLUS YEARS OLD 51 SZHH_1 {I10} TOTAL SIZE OF HOUSEHOLD - 1 PERSON 52 SZHH_2 {I10} TOTAL SIZE OF HOUSEHOLD - 2 PERSONS 53 SZHH_3 {I10} TOTAL SIZE OF HOUSEHOLD - 3 PERSONS 54 SZHH_4 {I10} TOTAL SIZE OF HOUSEHOLD - 4 PERSONS 55 SZHH_5 {I10} TOTAL SIZE OF HOUSEHOLD - 5 PERSONS 56 SZHH_6 {I10} TOTAL SIZE OF HOUSEHOLD - 6 OR MORE PERSONS 57 AVER_HH_SZ {F10.2} PERSONS PER HOUSEHOLD 58 HIDL15K {I10} HOUSEHOLD INCOME DISTRIBUTION - < $15,000 59 HID15_24K {I10} HOUSEHOLD INCOME DISTRIBUTION - $15,000-$24,999 60 HID25_49K {I10} HOUSEHOLD INCOME DISTRIBUTION - $25,000-$49,999 61 HID50_74K {I10} HOUSEHOLD INCOME DISTRIBUTION - $50,000-$74,999 62 HID75_99K {I10} HOUSEHOLD INCOME DISTRIBUTION - $75,000-$99,999 63 HID100_149 {I10} HOUSEHOLD INCOME DISTRIBUTION - $100,000-$149,999 64 HID150KP {I10} HOUSEHOLD INCOME DISTRIBUTION - $150,000 AND OVER 65 AVER_EBI {I10} AVERAGE HOUSEHOLD EBI 66 MED_EBI {I10} MEDIAN HOUSEHOLD EBI 67 MED_EBI_IN {I10} MEDIAN EBI INDEX 68 PERCAP_EBI {I10} PER CAPITA EBI 69 PER_HH_TRS {I10} PER HOUSEHOLD TRS 70 TRS {I10} TOTAL RETAIL + EATING & DRINKING SALES ($000) 71 FOOD_S {I10} FOOD & BEVERAGE STORES (NAICS-445) ($000) 72 GROC_S {I10} GROCERY STORES (NAICS-4451) ($000) 73 E_D_S {I10} EATING & DRINKING (NAICS-722) ($000) 74 GM_S {I10} GENERAL MERCHANDISE STORES (NAICS-452) ($000) 75 DEPT_S {I10} DEPARTMENT STORES (NAICS-45211) ($000) 76 APP_S {I10} CLOTHING & ACCESSORY STORES (NAICS-448) ($000) 77 FUR_HF_A_S {I10} FURNITURE, HOME FURNISHINGS, APPLIANCES (NAICS-442,443) ($000) 78 FUR_HF_S {I10} FURNITURE & HOME FURNISHINGS (NAICS-442) ($000) 79 AUTO_S {I10} MOTOR VEHICLES & PARTS (NAICS-441) ($000) 80 GAS_S {I10} GASOLINE SERVICE STATIONS (NAICS-447) ($000) 81 BM_S {I10} BUILDING MATERIALS & GARDEN SUPPLIES (NAICS-444) ($000) 82 DRUG_S {I10} HEALTH & PERSONAL CARE STORES (NAICS-446) ($000) 83 TRS_N {I10} TOTAL RETAIL + EATING & DRINKING SALES (#) 84 FOOD_N {I10} FOOD STORES (NAICS-445) (#) 85 GROC_N {I10} GROCERY STORES (NAICS-4451) (#) 86 E_D_N {I10} EATING & DRINKING (NAICS-722) (#) 87 GM_N {I10} GENERAL MERCHANDISE STORES (NAICS-452) (#) 88 DEPT_N {I10} DEPARTMENT STORES (NAICS-45211) (#) 89 APP_N {I10} CLOTHING & ACCESSORY STORES (NAICS-48) (#) 90 FUR_HF_A_N {I10} FURNITURE, HOME FURNISHINGS, APPLIANCES (NAICS-442,443) (#) 91 FUR_HF_N {I10} FURNITURE & HOME FURNISHINGS (NAICS-442) (#) 92 AUTO_N {I10} MOTOR VEHICLES & PARTS (NAICS-441) (#) 93 GAS_N {I10} GASOLINE SERVICE STATIONS (NAICS-447) (#) 94 BM_N {I10} BUILDING MATERIALS & GARDEN SUPPLIES (NAICS-444) (#) 95 DRUG_N {I10} HEALTH & PERSONAL CARE STORES (NAICS-446) (#) 96 MLGROC_TOT {I10} ML 100 GROCERIES & OTHER FOODS IN TOTAL 97 MLPKGA_TOT {I10} ML 140 PACKAGED ALCOHOLIC BEVERAGES IN TOTAL 98 MLMBWR_TOT {I10} ML 200 MEN'S & BOYS' WEAR IN TOTAL 99 MLWGWR_TOT {I10} ML 220 WOMEN'S & GIRLS' WEAR IN TO 100 MLDRUG_TOT {I10} ML 160 DRUGS, HEALTH AIDS, AND BEAUTY AIDS IN TOTAL 101 MLFOOT_TOT {I10} ML 260 FOOTWEAR IN TOTAL 102 MLHHAP_TOT {I10} ML 300 MAJOR HOUSEHOLD APPLIANCES IN TOTAL 103 MLTVCR_TOT {I10} ML 320 TELEVISIONS, VIDEO RECORDERS & TAPES IN TOTAL 104 MLFURN_TOT {I10} ML 340 FURNITURE & SLEEP EQUIPMENT IN TOTAL 105 MLFLRC_TOT {I10} ML 360 FLOOR COVERINGS IN TOTAL 106 MLCOMP_TOT {I10} ML 370 COMPUTER HARDWARE & SOFTWARE, ETC. IN TOTAL 107 MLJEWL_TOT {I10} ML 400 JEWELRY IN TOTAL 108 TOT_POP_PJ {I10} TOTAL POPULATION PROJECTION (5 YEAR) 109 POP9904 {F10.1} POP CHANGE FROM ESTIMATE YEAR TO PROJECTION YEAR 110 TOT_HH_PJ {I10} TOTAL HOUSEHOLDS PROJECTION (5 YEAR) 111 HHLD9904 {F10.1} HOUSEHOLD CHANGE FROM ESTIMATE YEAR TO PROJECTION YEAR 112 EBI_PJ {I10} EFFECTIVE BUYING INCOME ($000) PROJECTION (5 YEAR) 113 EBI9904 {F10.1} EBI CHANGE FROM ESTIMATE YEAR TO PROJECTION YEAR 114 AVHHEBIPJ {I10} AVERAGE HOUSEHOLD EBI (PROJECTION YEAR) 115 TRS_PJ {I10} TOTAL RETAIL SALES ($000) PROJECTION (5 YEAR) 116 TRS0005 {F10.1} TRS CHANGE FROM ESTIMATE YEAR TO PROJECTION YEAR 117 TRSPERHHPJ {I10} TRS PER HOUSEHOLD (PROJECTION YEAR) 118 BPI_PJ {F10.4} BUYING POWER INDEX PROJECTION (5 YEAR) 119 CEX_TOTAL {I10} TOTAL EXPENDITURES 120 CEX_FOOD_H {I10} CEX - FOOD (CONSUMED AT HOME) ($000) 121 CEX_FOOD_O {I10} CEX - FOOD (CONSUMED OUTSIDE HOME) ($000) 122 CEX_HOUSNG {I10} CEX - HOUSING ($000) 123 CEX_APPTOT {I10} CEX - APPAREL ($000) 124 CEX_HEALTH {I10} CEX - HEALTH CARE ($000) 125 CEX_TRANSP {I10} CEX - TRANSPORTATION ($000) 126 CEX_ENTERT {I10} CEX - ENTERTAINMENT ($000) 127 CEX_PERSON {I10} CEX - PERSONAL CARE PRODUCTS & SERVICES ($000) 128 CEX_READNG {I10} CEX - READING ($000) 129 CEX_EDUCAT {I10} CEX - EDUCATION ($000) 130 CEX_TOBACC {I10} CEX - TOBACCO PRODUCTS & SMOKING SUPPLIES ($000) 131 CEX_INSURN {I10} CEX - PERSONAL INSURANCE & PENSIONS ($000) 132 CEX_HSKPNG {I10} CEX - HOUSEKEEPING SUPPLIES ($000) 133 SICTOT_EMP {I10} SIC TOTAL EMPLOYMENT 134 AGRICL_EMP {I10} AGRICULTURAL SERVICES FORESTRY, FISHERIES TOT EMPLOYMENT 135 MINING_EMP {I10} MINING TOTAL EMPLOYMENT 136 CONTRC_EMP {I10} CONTRACT CONSTRUCTION EMPLOYMENT 137 MANUFG_EMP {I10} MANUFACTURING EMPLOYMENT 138 TRANSP_EMP {I10} TRANSPORTATION & OTHER PUBLIC UTILITIES EMPLOYMENT 139 WHLSTR_EMP {I10} WHOLESALE TRADE EMPLOYMENT 140 RETAIL_EMP {I10} RETAIL TRADE EMPLOYMENT 141 FINANC_EMP {I10} FINANCE, INSURANCE, & REAL ESTATE EMPLOYMENT 142 SRVCS_EMP {I10} SERVICES EMPLOYMENT 143 SICTOT_EST {I10} SIC TOTAL ESTABLISHMENTS 144 AGRICL_EST {I10} AGRICULTURAL SERVICES FORESTRY, FISHERIES TOT ESTABLISHMENTS 145 MINING_EST {I10} MINING TOTAL ESTABLISHMENTS 146 CONTRC_EST {I10} CONTRACT CONSTRUCTION ESTABLISHMENTS 147 MANUFG_EST {I10} MANUFACTURING ESTABLISHMENTS 148 TRANSP_EST {I10} TRANSPORTATION & OTHER PUBLIC UTILITIES ESTABLISHMENT 149 WHLSTR_EST {I10} WHOLESALE TRADE ESTABLISHMENTS 150 RETAIL_EST {I10} RETAIL TRADE ESTABLISHMENTS 151 FINANC_EST {I10} FINANCE, INSURANCE, & REAL ESTATE ESTABLISHMENTS 152 SRVCS_EST {I10} SERVICES ESTABLISHMENTS 153 BUSNSS_BPI {F10.4} BUSINESS BPI 154 HIGTEC_BPI {F10.4} HIGH TECH BPI 155 MFG_BPI {F10.4} MANUFACTURING BPI 156 TOTAL_OCC {I10} TOTAL OCCUPATIONS 157 WHITE_COLL {I10} WHITE COLLAR OCCUPATIONS 158 BLUE_COLLA {I10} BLUE COLLAR OCCUPATIONS 159 SERVCS_OCC {I10} SERVICE OCCUPATIONS 160 ADMIN_SUPP {I10} ADMINISTRATIVE SUPPORT OCCUPATIONS 161 LABOR_OCC {I10} OPERATORS, FABRICATORS & LABORERS 162 PROF_SPEC {I10} PROFESSIONAL SPECIALTY OCCUPATIONS 163 REPAIR_OCC {I10} PRECISION PRODUCTION, CRAFT & REPAIR OCCUPATIONS 164 MARKET_OCC {I10} MARKETING & SALES OCCUPATIONS 165 ADMIN_EXEC {I10} EXECUTIVE, ADMINISTRATIVE & MANAGERIAL OCCUPATIONS 166 AGRIC_OCC {I10} AGRICULTURAL, FORESTRY, FISHING & RELATED OCCUPATIONS 167 FEDER_WRKS {I10} FEDERAL WORKERS 168 ST_LOC_WKS {I10} STATE & LOCAL WORKERS