SIC Dataset #2 Description
| Field Name | Field Type | Description |
|---|---|---|
| pbkey | char(12) | 2017 Geography Layer Code Note: This field represents the Code value only but,
it is named as a "pbkey" to support the Spectrum Platform while loading the
data.
|
| bs_ds2_TYPE | char(4) | 2017 Geography Type (represents Block Group (BG) only) |
| bs_ds2_rtmcy5211 | float | 2017 Emp: Lumber and other building materials (S) |
| bs_ds2_rtmcy5231 | float | 2017 Emp: Paint, Glass, and wallpaper stores (S) |
| bs_ds2_rtmcy5251 | float | 2017 Emp: Hardware stores (S) |
| bs_ds2_rtmcy5261 | float | 2017 Emp: Retail nurseries and garden stores (S) |
| bs_ds2_rtmcy5271 | float | 2017 Emp: Mobile home dealers (S) |
| bs_ds2_rtmcy5311 | float | 2017 Emp: Department Stores (S) |
| bs_ds2_rtmcy5331 | float | 2017 Emp: Variety Stores (S) |
| bs_ds2_rtmcy5399 | float | 2017 Emp: Miscellaneous general merchandise stores (S) |
| bs_ds2_rtmcy5411 | float | 2017 Emp: Grocery Stores (S) |
| bs_ds2_rtmcy5421 | float | 2017 Emp: Meat and Fish Markets (S) |
| bs_ds2_rtmcy5431 | float | 2017 Emp: Fruit and vegetable markets (S) |
| bs_ds2_rtmcy5441 | float | 2017 Emp: Candy, nut and confectionery stores (S) |
| bs_ds2_rtmcy5451 | float | 2017 Emp: Dairy products stores (S) |
| bs_ds2_rtmcy5461 | float | 2017 Emp: Retail Bakeries (S) |
| bs_ds2_rtmcy5499 | float | 2017 Emp: Miscellaneous food stores (S) |
| bs_ds2_rtmcy5511 | float | 2017 Emp: New and used car dealers (S) |
| bs_ds2_rtmcy5521 | float | 2017 Emp: Used car dealers (S) |
| bs_ds2_rtmcy5531 | float | 2017 Emp: Auto and home supply stores (S) |
| bs_ds2_rtmcy5541 | float | 2017 Emp: Gasoline service stations (S) |
| bs_ds2_rtmcy5551 | float | 2017 Emp: Boat dealers (S) |
| bs_ds2_rtmcy5561 | float | 2017 Emp: Recreational vehicle dealers (S) |
| bs_ds2_rtmcy5571 | float | 2017 Emp: Motorcycle dealers (S) |
| bs_ds2_rtmcy5599 | float | 2017 Emp: Automotive dealers, nec (S) |
| bs_ds2_rtmcy5611 | float | 2017 Emp: Men's and boys' clothing stores (S) |
| bs_ds2_rtmcy5621 | float | 2017 Emp: Women's clothing stores (S) |
| bs_ds2_rtmcy5632 | float | 2017 Emp: Women's accessory and specialty stores (S) |
| bs_ds2_rtmcy5641 | float | 2017 Emp: Children's and infants' wear stores (S) |
| bs_ds2_rtmcy5651 | float | 2017 Emp: Family clothing stores (S) |
| bs_ds2_rtmcy5661 | float | 2017 Emp: Shoe stores (S) |
| bs_ds2_rtmcy5699 | float | 2017 Emp: Miscellaneous apparel and accessory stores (S) |
| bs_ds2_rtmcy5712 | float | 2017 Emp: Furniture stores (S) |
| bs_ds2_rtmcy5713 | float | 2017 Emp: Floor covering stores (S) |
| bs_ds2_rtmcy5714 | float | 2017 Emp: Drapery and upholstery stores (S) |
| bs_ds2_rtmcy5719 | float | 2017 Emp: Miscellaneous homefurnishings (S) |
| bs_ds2_rtmcy5722 | float | 2017 Emp: Household appliance stores (S) |
| bs_ds2_rtmcy5731 | float | 2017 Emp: Radio, television and electronics stores (S) |
| bs_ds2_rtmcy5734 | float | 2017 Emp: Computer and software stores (S) |
| bs_ds2_rtmcy5735 | float | 2017 Emp: Record and prerecorded tape stores (S) |
| bs_ds2_rtmcy5736 | float | 2017 Emp: Musical instrument stores (S) |
| bs_ds2_rtmcy5812 | float | 2017 Emp: Eating places (S) |
| bs_ds2_rtmcy5813 | float | 2017 Emp: Drinking places (S) |
| bs_ds2_rtmcy5912 | float | 2017 Emp: Drug stores and proprietary stores (S) |
| bs_ds2_rtmcy5921 | float | 2017 Emp: Liquor stores (S) |
| bs_ds2_rtmcy5932 | float | 2017 Emp: Use merchandise stores (S) |
| bs_ds2_rtmcy5941 | float | 2017 Emp: Sporting goods and bicycle shops (S) |
| bs_ds2_rtmcy5942 | float | 2017 Emp: Book stores (S) |
| bs_ds2_rtmcy5943 | float | 2017 Emp: Stationery stores (S) |
| bs_ds2_rtmcy5944 | float | 2017 Emp: Jewelry stores (S) |
| bs_ds2_rtmcy5945 | float | 2017 Emp: Hobby, toy and game shops (S) |
| bs_ds2_rtmcy5946 | float | 2017 Emp: Camera and photographic supply stores (S) |
| bs_ds2_rtmcy5947 | float | 2017 Emp: Gift, novelty and souvenir shop (S) |
| bs_ds2_rtmcy5948 | float | 2017 Emp: Luggage and leather goods stores (S) |
| bs_ds2_rtmcy5949 | float | 2017 Emp: Sewing, needlework, and piece goods (S) |
| bs_ds2_rtmcy5961 | float | 2017 Emp: Catalog and mail-order houses (S) |
| bs_ds2_rtmcy5962 | float | 2017 Emp: Merchandising machine operators (S) |
| bs_ds2_rtmcy5963 | float | 2017 Emp: Direct selling establishments (S) |
| bs_ds2_rtmcy5983 | float | 2017 Emp: Fuel oil dealers (S) |
| bs_ds2_rtmcy5984 | float | 2017Emp: Liquefied petroleum gas dealers (S) |
| bs_ds2_rtmcy5989 | float | 2017 Emp: Fuel dealers, nec (S) |
| bs_ds2_rtmcy5992 | float | 2017 Emp: Florists (S) |
| bs_ds2_rtmcy5993 | float | 2017 Emp: Tobacco stores and stands (S) |
| bs_ds2_rtmcy5994 | float | 2017 Emp: News dealers and newsstands (S) |
| bs_ds2_rtmcy5995 | float | 2017 Emp: Optical goods stores (S) |
| bs_ds2_rtmcy5999 | float | 2017 Emp: Miscellaneous retail stores, nec (S) |
| bs_ds2_rtecy5211 | float | 2017 Est: Lumber and other building materials (S) |
| bs_ds2_rtecy5231 | float | 2017 Est: Paint, Glass, and wallpaper stores (S) |
| bs_ds2_rtecy5251 | float | 2017 Est: Hardware stores (S) |
| bs_ds2_rtecy5261 | float | 2017 Est: Retail nurseries and garden stores (S) |
| bs_ds2_rtecy5271 | float | 2017 Est: Mobile home dealers (S) |
| bs_ds2_rtecy5311 | float | 2017 Est: Department Stores (S) |
| bs_ds2_rtecy5331 | float | 2017 Est: Variety Stores (S) |
| bs_ds2_rtecy5399 | float | 2017 Est: Miscellaneous general merchandise stores (S) |
| bs_ds2_rtecy5411 | float | 2017 Est: Grocery Stores (S) |
| bs_ds2_rtecy5421 | float | 2017Est: Meat and Fish Markets (S) |
| bs_ds2_rtecy5431 | float | 2017 Est: Fruit and vegetable markets (S) |
| bs_ds2_rtecy5441 | float | 2017 Est: Candy, nut and confectionery stores (S) |
| bs_ds2_rtecy5451 | float | 2017 Est: Dairy products stores (S) |
| bs_ds2_rtecy5461 | float | 2017 Est: Retail Bakeries (S) |
| bs_ds2_rtecy5499 | float | 2017 Est: Miscellaneous food stores (S) |
| bs_ds2_rtecy5511 | float | 2017 Est: New and used car dealers (S) |
| bs_ds2_rtecy5521 | float | 2017 Est: Used car dealers (S) |
| bs_ds2_rtecy5531 | float | 2017 Est: Auto and home supply stores (S) |
| bs_ds2_rtecy5541 | float | 2017 Est: Gasoline service stations (S) |
| bs_ds2_rtecy5551 | float | 2017 Est: Boat dealers (S) |
| bs_ds2_rtecy5561 | float | 2017 Est: Recreational vehicle dealers (S) |
| bs_ds2_rtecy5571 | float | 2017 Est: Motorcycle dealers (S) |
| bs_ds2_rtecy5599 | float | 2017 Est: Automotive dealers, nec (S) |
| bs_ds2_rtecy5611 | float | 2017 Est: Men's and boys' clothing stores (S) |
| bs_ds2_rtecy5621 | float | 2017 Est: Women's clothing stores (S) |
| bs_ds2_rtecy5632 | float | 2017 Est: Women's accessory and specialty stores (S) |
| bs_ds2_rtecy5641 | float | 2017 Est: Children's and infants' wear stores (S) |
| bs_ds2_rtecy5651 | float | 2017 Est: Family clothing stores (S) |
| bs_ds2_rtecy5661 | float | 2017 Est: Shoe stores (S) |
| bs_ds2_rtecy5699 | float | 2017 Est: Miscellaneous apparel and accessory stores (S) |
| bs_ds2_rtecy5712 | float | 2017 Est: Furniture stores (S) |
| bs_ds2_rtecy5713 | float | 2017 Est: Floor covering stores (S) |
| bs_ds2_rtecy5714 | float | 2017 Est: Drapery and upholstery stores (S) |
| bs_ds2_rtecy5719 | float | 2017 Est: Miscellaneous homefurnishings (S) |
| bs_ds2_rtecy5722 | float | 2017 Est: Household appliance stores (S) |
| bs_ds2_rtecy5731 | float | 2017 Est: Radio, television and electronics stores (S) |
| bs_ds2_rtecy5734 | float | 2017 Est: Computer and software stores (S) |
| bs_ds2_rtecy5735 | float | 2017 Est: Record and prerecorded tape stores (S) |
| bs_ds2_rtecy5736 | float | 2017 Est: Musical instrument stores (S) |
| bs_ds2_rtecy5812 | float | 2017 Est: Eating places (S) |
| bs_ds2_rtecy5813 | float | 2017 Est: Drinking places (S) |
| bs_ds2_rtecy5912 | float | 2017 Est: Drug stores and proprietary stores (S) |
| bs_ds2_rtecy5921 | float | 2017 Est: Liquor stores (S) |
| bs_ds2_rtecy5932 | float | 2017 Est: Use merchandise stores (S) |
| bs_ds2_rtecy5941 | float | 2017 Est: Sporting goods and bicycle shops (S) |
| bs_ds2_rtecy5942 | float | 2017 Est: Book stores (S) |
| bs_ds2_rtecy5943 | float | 2017 Est: Stationery stores (S) |
| bs_ds2_rtecy5944 | float | 2017 Est: Jewelry stores (S) |
| bs_ds2_rtecy5945 | float | 2017 Est: Hobby, toy and game shops (S) |
| bs_ds2_rtecy5946 | float | 2017 Est: Camera and photographic supply stores (S) |
| bs_ds2_rtecy5947 | float | 2017 Est: Gift, novelty and souvenir shop (S) |
| bs_ds2_rtecy5948 | float | 2017 Est: Luggage and leather goods stores (S) |
| bs_ds2_rtecy5949 | float | 2017 Est: Sewing, needlework, and piece goods (S) |
| bs_ds2_rtecy5961 | float | 2017 Est: Catalog and mail-order houses (S) |
| bs_ds2_rtecy5962 | float | 2017 Est: Merchandising machine operators (S) |
| bs_ds2_rtecy5963 | float | 2017 Est: Direct selling establishments (S) |
| bs_ds2_rtecy5983 | float | 2017 Est: Fuel oil dealers (S) |
| bs_ds2_rtecy5984 | float | 2017 Est: Liquefied petroleum gas dealers (S) |
| bs_ds2_rtecy5989 | float | 2017 Est: Fuel dealers, nec (S) |
| bs_ds2_rtecy5992 | float | 2017 Est: Florists (S) |
| bs_ds2_rtecy5993 | float | 2017 Est: Tobacco stores and stands (S) |
| bs_ds2_rtecy5994 | float | 2017 Est: News dealers and newsstands (S) |
| bs_ds2_rtecy5995 | float | 2017 Est: Optical goods stores (S) |
| bs_ds2_rtecy5999 | float | 2017 Est: Miscellaneous retail stores, nec (S) |
| bs_ds2_rtscy5211 | float | 2017 Retail Sales: Lumber and other building materials (S) |
| bs_ds2_rtscy5231 | float | 2017 Retail Sales: Paint, Glass, and wallpaper stores (S) |
| bs_ds2_rtscy5251 | float | 2017 Retail Sales: Hardware stores (S) |
| bs_ds2_rtscy5261 | float | 2017 Retail Sales: Retail nurseries and garden stores (S) |
| bs_ds2_rtscy5271 | float | 2017 Retail Sales: Mobile home dealers (S) |
| bs_ds2_rtscy5311 | float | 2017 Retail Sales: Department Stores (S) |
| bs_ds2_rtscy5331 | float | 2017 Retail Sales: Variety Stores (S) |
| bs_ds2_rtscy5399 | float | 2017 Retail Sales: Miscellaneous general merchandise stores (S) |
| bs_ds2_rtscy5411 | float | 2017 Retail Sales: Grocery Stores (S) |
| bs_ds2_rtscy5421 | float | 2017 Retail Sales: Meat and Fish Markets (S) |
| bs_ds2_rtscy5431 | float | 2017 Retail Sales: Fruit and vegetable markets (S) |
| bs_ds2_rtscy5441 | float | 2017 Retail Sales: Candy, nut and confectionery stores (S) |
| bs_ds2_rtscy5451 | float | 2017 Retail Sales: Dairy products stores (S) |
| bs_ds2_rtscy5461 | float | 2017 Retail Sales: Retail Bakeries (S) |
| bs_ds2_rtscy5499 | float | 2017 Retail Sales: Miscellaneous food stores (S) |
| bs_ds2_rtscy5511 | float | 2017 Retail Sales: New and used car dealers (S) |
| bs_ds2_rtscy5521 | float | 2017 Retail Sales: Used car dealers (S) |
| bs_ds2_rtscy5531 | float | 2017 Retail Sales: Auto and home supply stores (S) |
| bs_ds2_rtscy5541 | float | 2017 Retail Sales: Gasoline service stations (S) |
| bs_ds2_rtscy5551 | float | 2017 Retail Sales: Boat dealers (S) |
| bs_ds2_rtscy5561 | float | 2017 Retail Sales: Recreational vehicle dealers (S) |
| bs_ds2_rtscy5571 | float | 2017 Retail Sales: Motorcycle dealers (S) |
| bs_ds2_rtscy5599 | float | 2017 Retail Sales: Automotive dealers, nec (S) |
| bs_ds2_rtscy5611 | float | 2017 Retail Sales: Men's and boys' clothing stores (S) |
| bs_ds2_rtscy5621 | float | 2017 Retail Sales: Women's clothing stores (S) |
| bs_ds2_rtscy5632 | float | 2017 Retail Sales: Women's accessory and specialty stores (S) |
| bs_ds2_rtscy5641 | float | 2017 Retail Sales: Children's and infants' wear stores (S) |
| bs_ds2_rtscy5651 | float | 2017 Retail Sales: Family clothing stores (S) |
| bs_ds2_rtscy5661 | float | 2017 Retail Sales: Shoe stores (S) |
| bs_ds2_rtscy5699 | float | 2017 Retail Sales: Miscellaneous apparel and accessory stores (S) |
| bs_ds2_rtscy5712 | float | 2017 Retail Sales: Furniture stores (S) |
| bs_ds2_rtscy5713 | float | 2017 Retail Sales: Floor covering stores (S) |
| bs_ds2_rtscy5714 | float | 2017 Retail Sales: Drapery and upholstery stores (S) |
| bs_ds2_rtscy5719 | float | 2017 Retail Sales: Miscellaneous homefurnishings (S) |
| bs_ds2_rtscy5722 | float | 2017 Retail Sales: Household appliance stores (S) |
| bs_ds2_rtscy5731 | float | 2017 Retail Sales: Radio, television and electronics stores (S) |
| bs_ds2_rtscy5734 | float | 2017 Retail Sales: Computer and software stores (S) |
| bs_ds2_rtscy5735 | float | 2017 Retail Sales: Record and prerecorded tape stores (S) |
| bs_ds2_rtscy5736 | float | 2017 Retail Sales: Musical instrument stores (S) |
| bs_ds2_rtscy5812 | float | 2017 Retail Sales: Eating places (S) |
| bs_ds2_rtscy5813 | float | 2017 Retail Sales: Drinking places (S) |
| bs_ds2_rtscy5912 | float | 2017 Retail Sales: Drug stores and proprietary stores (S) |
| bs_ds2_rtscy5921 | float | 2017 Retail Sales: Liquor stores (S) |
| bs_ds2_rtscy5932 | float | 2017 Retail Sales: Use merchandise stores (S) |
| bs_ds2_rtscy5941 | float | 2017 Retail Sales: Sporting goods and bicycle shops (S) |
| bs_ds2_rtscy5942 | float | 2017 Retail Sales: Book stores (S) |
| bs_ds2_rtscy5943 | float | 2017 Retail Sales: Stationery stores (S) |
| bs_ds2_rtscy5944 | float | 2017 Retail Sales: Jewelry stores (S) |
| bs_ds2_rtscy5945 | float | 2017 Retail Sales: Hobby, toy and game shops (S) |
| bs_ds2_rtscy5946 | float | 2017 Retail Sales: Camera and photographic supply stores (S) |
| bs_ds2_rtscy5947 | float | 2017 Retail Sales: Gift, novelty and souvenir shop (S) |
| bs_ds2_rtscy5948 | float | 2017 Retail Sales: Luggage and leather goods stores (S) |
| bs_ds2_rtscy5949 | float | 2017 Retail Sales: Sewing, needlework, and piece goods (S) |
| bs_ds2_rtscy5961 | float | 2017 Retail Sales: Catalog and mail-order houses (S) |
| bs_ds2_rtscy5962 | float | 2017 Retail Sales: Merchandising machine operators (S) |
| bs_ds2_rtscy5963 | float | 2017 Retail Sales: Direct selling establishments (S) |
| bs_ds2_rtscy5983 | float | 2017 Retail Sales: Fuel oil dealers (S) |
| bs_ds2_rtscy5984 | float | 2017 Retail Sales: Liquefied petroleum gas dealers (S) |
| bs_ds2_rtscy5989 | float | 2017 Retail Sales: Fuel dealers, nec (S) |
| bs_ds2_rtscy5992 | float | 2017 Retail Sales: Florists (S) |
| bs_ds2_rtscy5993 | float | 2017 Retail Sales: Tobacco stores and stands (S) |
| bs_ds2_rtscy5994 | float | 2017 Retail Sales: News dealers and newsstands (S) |
| bs_ds2_rtscy5995 | float | 2017 Retail Sales: Optical goods stores (S) |
| bs_ds2_rtscy5999 | float | 2017 Retail Sales: Miscellaneous retail stores, nec (S) |
| bs_ds2_srecy70 | float | 2017 Est: Hotels and Other Lodging Places (S) |
| bs_ds2_srecy72 | float | 2017 Est: Personal Services (S) |
| bs_ds2_srecy73 | float | 2017 Est: Business Services (S) |
| bs_ds2_srecy75 | float | 2017 Est: Auto Repair, Services and Parking (S) |
| bs_ds2_srecy76 | float | 2017 Est: Miscellaneous Repair Services (S) |
| bs_ds2_srecy78 | float | 2017 Est: Motion Pictures (S) |
| bs_ds2_srecy79 | float | 2017 Est: Amusement and Recreation Services (S) |
| bs_ds2_srecy80 | float | 2017 Est: Health Services (S) |
| bs_ds2_srecy81 | float | 2017 Est: Legal Services (S) |
| bs_ds2_srecy82 | float | 2017 Est: Educational Services (S) |
| bs_ds2_srecy83 | float | 2017 Est: Social Service (S) |
| bs_ds2_srecy84 | float | 2017 Est: Museums, Botanical, Zoological Gardens (S) |
| bs_ds2_srecy86 | float | 2017 Est: Membership Organizations (S) |
| bs_ds2_srecy87 | float | 2017 Est: Engineering and Management Services (S) |
| bs_ds2_srecy88 | float | 2017 Est: Private Households (S) |
| bs_ds2_srecy89 | float | 2017 Est: Services, Nec (S) |
| bs_ds2_srmcy70 | float | 2017 Emp: Hotels and Other Lodging Places (S) |
| bs_ds2_srmcy72 | float | 2017 Emp: Personal Services (S) |
| bs_ds2_srmcy73 | float | 2017 Emp: Business Services (S) |
| bs_ds2_srmcy75 | float | 2017 Emp: Auto Repair, Services and Parking (S) |
| bs_ds2_srmcy76 | float | 2017 Emp: Miscellaneous Repair Services (S) |
| bs_ds2_srmcy78 | float | 2017 Emp: Motion Pictures (S) |
| bs_ds2_srmcy79 | float | 2017 Emp: Amusement and Recreation Services (S) |
| bs_ds2_srmcy80 | float | 2017 Emp: Health Services (S) |
| bs_ds2_srmcy81 | float | 2017 Emp: Legal Services (S) |
| bs_ds2_srmcy82 | float | 2017 Emp: Educational Services (S) |
| bs_ds2_srmcy83 | float | 2017 Emp: Social Service (S) |
| bs_ds2_srmcy84 | float | 2017 Emp: Museums, Botanical, Zoological Gardens (S) |
| bs_ds2_srmcy86 | float | 2017 Emp: Membership Organizations (S) |
| bs_ds2_srmcy87 | float | 2017 Emp: Engineering and Management Services (S) |
| bs_ds2_srmcy88 | float | 2017 Emp: Private Households (S) |
| bs_ds2_srmcy89 | float | 2017 Emp: Services, Nec (S) |