SIC Dataset #1 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_ds1_TYPE | char(4) | 2017 Geography Type (represents Block Group (BG) only) |
bs_ds1_buscyemp | float | 2017 Total: Employees (S) |
bs_ds1_buscyest | float | 2017 Total: Establishments (S) |
bs_ds1_buscypay | float | 2017 Total: Payroll (S) |
bs_ds1_buscyrtl | float | 2017 Total: Retail Sales (S) |
bs_ds1_occmangmt | float | 2017 Occupation: Management occupations (S) |
bs_ds1_occbusfn | float | 2017 Occupation: Business and financial operations occupations (S) |
bs_ds1_occcomp | float | 2017 Occupation: Computer and mathematical occupations (S) |
bs_ds1_occengin | float | 2017 Occupation: Architecture and engineering occupations (S) |
bs_ds1_occsscie | float | 2017 Occupation: Life, physical, and social science occupations (S) |
bs_ds1_occcomm | float | 2017 Occupation: Community and social services occupations (S) |
bs_ds1_occlegal | float | 2017 Occupation: Legal occupations (S) |
bs_ds1_occeduc | float | 2017 Occupation: Education, training, and library occupations (S) |
bs_ds1_occarts | float | 2017 Occupation: Arts, design, entertainment, sports, and media occupations (S) |
bs_ds1_occhlprac | float | 2017 Occupation: Healthcare practitioners and technical occupations (S) |
bs_ds1_occhlsupp | float | 2017 Occupation: Healthcare support occupations (S) |
bs_ds1_occprot | float | 2017 Occupation: Protective service occupations (S) |
bs_ds1_occfood | float | 2017 Occupation: Food preparation and serving related occupations (S) |
bs_ds1_occbuild | float | 2017 Occupation: Building and grounds cleaning and maintenance occupations (S) |
bs_ds1_occpers | float | 2017 Occupation: Personal care and service occupations (S) |
bs_ds1_occsale | float | 2017 Occupation: Sales and related occupations (S) |
bs_ds1_occadmin | float | 2017 Occupation: Office and administrative support occupations (S) |
bs_ds1_occagri | float | 2017 Occupation: Farming, fishing, and forestry occupations (S) |
bs_ds1_occconst | float | 2017 Occupation: Construction and extraction occupations (S) |
bs_ds1_occinstl | float | 2017 Occupation: Installation, maintenance, and repair occupations (S) |
bs_ds1_occprod | float | 2017 Occupation: Production occupations (S) |
bs_ds1_occtrans | float | 2017 Occupation: Transportation and material moving occupations (S) |
bs_ds1_empcyagric | float | 2017 Emp: Agricultural, Forestry, Fishing (S) |
bs_ds1_empcyconst | float | 2017 Emp: Construction (S) |
bs_ds1_empcyfire | float | 2017 Emp: Finance, Insurance and Real Estate (S) |
bs_ds1_empcymanuf | float | 2017 Emp: Manufacturing (S) |
bs_ds1_empcymine | float | 2017 Emp: Mining (S) |
bs_ds1_empcypubad | float | 2017 Emp: Public Administration (S) |
bs_ds1_empcyrtrad | float | 2017 Emp: Retail Trade (S) |
bs_ds1_empcysrv | float | 2017 Emp: Services (S) |
bs_ds1_empcytrans | float | 2017 Emp: Transportation and Communications (S) |
bs_ds1_empcywtrad | float | 2017 Emp: Wholesale Trade (S) |
bs_ds1_empcyuncla | float | 2017 Emp: Unclassified (S) |
bs_ds1_estcyagric | float | 2017 Est: Agricultural, Forestry, Fishing (S) |
bs_ds1_estcyconst | float | 2017 Est: Construction (S) |
bs_ds1_estcyfire | float | 2017 Est: Finance, Insurance and Real Estate (S) |
bs_ds1_estcymanuf | float | 2017 Est: Manufacturing (S) |
bs_ds1_estcymine | float | 2017 Est: Mining (S) |
bs_ds1_estcypubad | float | 2017 Est: Public Administration (S) |
bs_ds1_estcyrtrad | float | 2017 Est: Retail Trade (S) |
bs_ds1_estcysrv | float | 2017 Est: Services (S) |
bs_ds1_estcytrans | float | 2017 Est: Transportation and Communications (S) |
bs_ds1_estcywtrad | float | 2017 Est: Wholesale Trade (S) |
bs_ds1_estcyuncla | float | 2017 Est: Unclassified (S) |
bs_ds1_empacccy87 | float | 2017 Emp: Accounting, Architecture, and Engineering (S) |
bs_ds1_empagrcy01 | float | 2017 Emp: Agricultural Production - Crops (S) |
bs_ds1_empagrcy02 | float | 2017 Emp: Agricultural Production - Livestock (S) |
bs_ds1_empagrcy07 | float | 2017 Emp: Agricultural Services (S) |
bs_ds1_empagrcy08 | float | 2017 Emp: Forestry (S) |
bs_ds1_empagrcy09 | float | 2017 Emp: Fishing, Hunting and Trapping (S) |
bs_ds1_empagrcy10 | float | 2017 Emp: Metal Mining (S) |
bs_ds1_empagrcy12 | float | 2017 Emp: Coal Mining (S) |
bs_ds1_empagrcy13 | float | 2017 Emp: Oil and Gas Extraction (S) |
bs_ds1_empagrcy14 | float | 2017 Emp: Nonmetallic Minerals, Except Fuels (S) |
bs_ds1_empbuscy70 | float | 2017 Emp: Hotels and Other Lodging Places (S) |
bs_ds1_empbuscy72 | float | 2017 Emp: Personal Services (S) |
bs_ds1_empbuscy73 | float | 2017 Emp: Business Services (S) |
bs_ds1_empbuscy75 | float | 2017 Emp: Auto Repair, Services, and Parking (S) |
bs_ds1_empbuscy76 | float | 2017 Emp: Miscellaneous Repair Services (S) |
bs_ds1_empbuscy78 | float | 2017 Emp: Motion Pictures (S) |
bs_ds1_empbuscy79 | float | 2017 Emp: Amusement and Recreation Services (S) |
bs_ds1_empcnscy15 | float | 2017 Emp: General Building Contractors (S) |
bs_ds1_empcnscy16 | float | 2017 Emp: Heavy Construction, Ex. Building (S) |
bs_ds1_empcnscy17 | float | 2017 Emp: Special Trade Contractors (S) |
bs_ds1_empeducy82 | float | 2017 Emp: Educational Services (S) |
bs_ds1_empeducy83 | float | 2017 Emp: Social Services (S) |
bs_ds1_empfircy60 | float | 2017 Emp: Depository Institutions (S) |
bs_ds1_empfircy61 | float | 2017 Emp: Nondepository Institutions (S) |
bs_ds1_empfircy62 | float | 2017 Emp: Security and Commodity Brokers (S) |
bs_ds1_empfircy63 | float | 2017 Emp: Insurance Carriers (S) |
bs_ds1_empfircy64 | float | 2017 Emp: Insurance Agents, Brokers, and Services (S) |
bs_ds1_empfircy65 | float | 2017 Emp: Real Estate (S) |
bs_ds1_empfircy67 | float | 2017 Emp: Holding and Other Investment Offices (S) |
bs_ds1_empgovcy91 | float | 2017 Emp: Executive, Legislative, and General (S) |
bs_ds1_empgovcy92 | float | 2017 Emp: Justice, Public Order, and Safety (S) |
bs_ds1_empgovcy93 | float | 2017 Emp: Finance, Taxation and Monetary Policy (S) |
bs_ds1_empgovcy94 | float | 2017 Emp: Administration of Human Resources (S) |
bs_ds1_empgovcy95 | float | 2017 Emp: Environmental Quality and Housing (S) |
bs_ds1_empgovcy96 | float | 2017 Emp: Administration of Economic Programs (S) |
bs_ds1_empgovcy97 | float | 2017 Emp: National Security and Intl. Affairs (S) |
bs_ds1_emphthcy80 | float | 2017 Emp: Health Services (S) |
bs_ds1_emphhdcy88 | float | 2017 Emp: Private Households (S) |
bs_ds1_emphhdcy89 | float | 2017 Emp: Miscellaneous Services NEC (S) |
bs_ds1_emplglcy81 | float | 2017 Emp: Legal Services (S) |
bs_ds1_empmancy20 | float | 2017 Emp: Food and Kindred Products (S) |
bs_ds1_empmancy21 | float | 2017 Emp: Tobacco Products (S) |
bs_ds1_empmancy22 | float | 2017 Emp: Textile Mill Products (S) |
bs_ds1_empmancy23 | float | 2017 Emp: Apparel and Other Textile Products (S) |
bs_ds1_empmancy24 | float | 2017 Emp: Lumber and Wood Products (S) |
bs_ds1_empmancy25 | float | 2017 Emp: Furniture and Fixtures (S) |
bs_ds1_empmancy26 | float | 2017 Emp: Paper and Allied Products (S) |
bs_ds1_empmancy27 | float | 2017 Emp: Printing and Publishing (S) |
bs_ds1_empmancy28 | float | 2017 Emp: Chemicals and Allied Products (S) |
bs_ds1_empmancy29 | float | 2017 Emp: Petroleum and Coal Products (S) |
bs_ds1_empmancy30 | float | 2017 Emp: Rubber and Misc. Plastics Products (S) |
bs_ds1_empmancy31 | float | 2017 Emp: Leather and Leather Products (S) |
bs_ds1_empmancy32 | float | 2017 Emp: Stone, Clay and Glass Products (S) |
bs_ds1_empmancy33 | float | 2017 Emp: Primary Metal Industries (S) |
bs_ds1_empmancy34 | float | 2017 Emp: Fabricated Metal Products (S) |
bs_ds1_empmancy35 | float | 2017 Emp: Industrial Machinery and Equipment (S) |
bs_ds1_empmancy36 | float | 2017 Emp: Electronic and Other Electric Equipment (S) |
bs_ds1_empmancy37 | float | 2017 Emp: Transportation Equipment (S) |
bs_ds1_empmancy38 | float | 2017 Emp: Instruments and Related Products (S) |
bs_ds1_empmancy39 | float | 2017 Emp: Miscellaneous Manufacturing Industries (S) |
bs_ds1_empmemcy84 | float | 2017 Emp: Museums, Botanical, Zoological Gardens (S) |
bs_ds1_empmemcy86 | float | 2017 Emp: Membership Organizations (S) |
bs_ds1_empncecy99 | float | 2017 Emp: Non-Classified Establishments (S) |
bs_ds1_empretcy52 | float | 2017 Emp: Building Materials and Garden Supplies (S) |
bs_ds1_empretcy53 | float | 2017 Emp: General Merchandise Stores (S) |
bs_ds1_empretcy54 | float | 2017 Emp: Food Stores (S) |
bs_ds1_empretcy55 | float | 2017 Emp: Automotive Dealers and Service Stations (S) |
bs_ds1_empretcy56 | float | 2017 Emp: Apparel and Accessory Stores (S) |
bs_ds1_empretcy57 | float | 2017 Emp: Furniture and Homefurnishings Stores (S) |
bs_ds1_empretcy58 | float | 2017 Emp: Eating and Drinking Places (S) |
bs_ds1_empretcy59 | float | 2017 Emp: Miscellaneous Retail (S) |
bs_ds1_emptrncy40 | float | 2017 Emp: Railroad Transportation (S) |
bs_ds1_emptrncy41 | float | 2017 Emp: Local and Interurban Passenger Transit (S) |
bs_ds1_emptrncy42 | float | 2017 Emp: Trucking and Warehousing (S) |
bs_ds1_emptrncy43 | float | 2017 Emp: U.S. Postal Service (S) |
bs_ds1_emptrncy44 | float | 2017 Emp: Water Transportation (S) |
bs_ds1_emptrncy45 | float | 2017 Emp: Transportation by Air (S) |
bs_ds1_emptrncy46 | float | 2017 Emp: Pipelines, Except Natural Gas (S) |
bs_ds1_emptrncy47 | float | 2017 Emp: Transportation Services (S) |
bs_ds1_emptrncy48 | float | 2017 Emp: Communication (S) |
bs_ds1_emptrncy49 | float | 2017 Emp: Electric, Gas and Sanitary Services (S) |
bs_ds1_empwhlcy50 | float | 2017 Emp: Wholesale Trade - Durable Goods (S) |
bs_ds1_empwhlcy51 | float | 2017 Emp: Wholesale Trade - Non-Durable Goods (S) |
bs_ds1_estacccy87 | float | 2017 Est: Engineering and Management Services (S) |
bs_ds1_estagrcy01 | float | 2017 Est: Agricultural Production - Crops (S) |
bs_ds1_estagrcy02 | float | 2017 Est: Agricultural Production - Livestock (S) |
bs_ds1_estagrcy07 | float | 2017 Est: Agricultural Services (S) |
bs_ds1_estagrcy08 | float | 2017 Est: Forestry (S) |
bs_ds1_estagrcy09 | float | 2017 Est: Fishing, Hunting and Trapping (S) |
bs_ds1_estagrcy10 | float | 2017 Est: Metal Mining (S) |
bs_ds1_estagrcy12 | float | 2017 Est: Coal Mining (S) |
bs_ds1_estagrcy13 | float | 2017 Est: Oil and Gas Extraction (S) |
bs_ds1_estagrcy14 | float | 2017 Est: Nonmetallic Minerals, Except Fuels (S) |
bs_ds1_estbuscy70 | float | 2017 Est: Hotels and Other Lodging Places (S) |
bs_ds1_estbuscy72 | float | 2017 Est: Personal Services (S) |
bs_ds1_estbuscy73 | float | 2017 Est: Business Services (S) |
bs_ds1_estbuscy75 | float | 2017 Est: Auto Repair, Services, and Parking (S) |
bs_ds1_estbuscy76 | float | 2017 Est: Miscellaneous Repair Services (S) |
bs_ds1_estbuscy78 | float | 2017 Est: Motion Pictures (S) |
bs_ds1_estbuscy79 | float | 2017 Est: Amusement and Recreation Services (S) |
bs_ds1_estcnscy15 | float | 2017 Est: General Building Contractors (S) |
bs_ds1_estcnscy16 | float | 2017 Est: Heavy Construction, Ex. Building (S) |
bs_ds1_estcnscy17 | float | 2017 Est: Special Trade Contractors (S) |
bs_ds1_esteducy82 | float | 2017 Est: Educational Services (S) |
bs_ds1_esteducy83 | float | 2017Est: Social Services (S) |
bs_ds1_estfircy60 | float | 2017 Est: Depository Institutions (S) |
bs_ds1_estfircy61 | float | 2017 Est: Nondepository Institutions (S) |
bs_ds1_estfircy62 | float | 2017 Est: Security and Commodity Brokers (S) |
bs_ds1_estfircy63 | float | 2017 Est: Insurance Carriers (S) |
bs_ds1_estfircy64 | float | 2017 Est: Insurance Agents, Brokers, and Services (S) |
bs_ds1_estfircy65 | float | 2017 Est: Real Estate (S) |
bs_ds1_estfircy67 | float | 2017 Est: Holding and Other Investment Offices (S) |
bs_ds1_estgovcy91 | float | 2017 Est: Executive, Legislative, and General (S) |
bs_ds1_estgovcy92 | float | 2017 Est: Justice, Public Order, and Safety (S) |
bs_ds1_estgovcy93 | float | 2017 Est: Finance, Taxation and Monetary Policy (S) |
bs_ds1_estgovcy94 | float | 2017 Est: Administration of Human Resources (S) |
bs_ds1_estgovcy95 | float | 2017 Est: Environmental Quality and Housing (S) |
bs_ds1_estgovcy96 | float | 2017 Est: Administration of Economic Programs (S) |
bs_ds1_estgovcy97 | float | 2017 Est: National Security and Intl. Affairs (S) |
bs_ds1_esththcy80 | float | 2017 Est: Health Services (S) |
bs_ds1_esthhdcy88 | float | 2017 Est: Private Households (S) |
bs_ds1_esthhdcy89 | float | 2017 Est: Miscellaneous Services NEC (S) |
bs_ds1_estlglcy81 | float | 2017 Est: Legal Services (S) |
bs_ds1_estmancy20 | float | 2017 Est: Food and Kindred Products (S) |
bs_ds1_estmancy21 | float | 2017 Est: Tobacco Products (S) |
bs_ds1_estmancy22 | float | 2017 Est: Textile Mill Products (S) |
bs_ds1_estmancy23 | float | 2017 Est: Apparel and Other Textile Products (S) |
bs_ds1_estmancy24 | float | 2017 Est: Lumber and Wood Products (S) |
bs_ds1_estmancy25 | float | 2017 Est: Furniture and Fixtures (S) |
bs_ds1_estmancy26 | float | 2017 Est: Paper and Allied Products (S) |
bs_ds1_estmancy27 | float | 2017 Est: Printing and Publishing (S) |
bs_ds1_estmancy28 | float | 2017 Est: Chemicals and Allied Products (S) |
bs_ds1_estmancy29 | float | 2017 Est: Petroleum and Coal Products (S) |
bs_ds1_estmancy30 | float | 2017 Est: Rubber and Misc. Plastics Products (S) |
bs_ds1_estmancy31 | float | 2017 Est: Leather and Leather Products (S) |
bs_ds1_estmancy32 | float | 2017 Est: Stone, Clay and Glass Products (S) |
bs_ds1_estmancy33 | float | 2017 Est: Primary Metal Industries (S) |
bs_ds1_estmancy34 | float | 2017 Est: Fabricated Metal Products (S) |
bs_ds1_estmancy35 | float | 2017 Est: Industrial Machinery and Equipment (S) |
bs_ds1_estmancy36 | float | 2017 Est: Electronic and Other Electric Equipment (S) |
bs_ds1_estmancy37 | float | 2017 Est: Transportation Equipment (S) |
bs_ds1_estmancy38 | float | 2017 Est: Instruments and Related Products (S) |
bs_ds1_estmancy39 | float | 2017 Est: Miscellaneous Manufacturing Industries (S) |
bs_ds1_estmemcy84 | float | 2017 Est: Museums, Botanical, Zoological Gardens (S) |
bs_ds1_estmemcy86 | float | 2017 Est: Membership Organizations (S) |
bs_ds1_estncecy99 | float | 2017 Est: Non-Classified Establishments (S) |
bs_ds1_estretcy52 | float | 2017 Est: Building Materials and Garden Supplies (S) |
bs_ds1_estretcy53 | float | 2017 Est: General Merchandise Stores (S) |
bs_ds1_estretcy54 | float | 2017 Est: Food Stores (S) |
bs_ds1_estretcy55 | float | 2017 Est: Automotive Dealers and Service Stations (S) |
bs_ds1_estretcy56 | float | 2017 Est: Apparel and Accessory Stores (S) |
bs_ds1_estretcy57 | float | 2017 Est: Furniture and Homefurnishings Stores (S) |
bs_ds1_estretcy58 | float | 2017 Est: Eating and Drinking Places (S) |
bs_ds1_estretcy59 | float | 2017 Est: Miscellaneous Retail (S) |
bs_ds1_esttrncy40 | float | 2017 Est: Railroad Transportation (S) |
bs_ds1_esttrncy41 | float | 2017 Est: Local and Interurban Passenger Transit (S) |
bs_ds1_esttrncy42 | float | 2017 Est: Trucking and Warehousing (S) |
bs_ds1_esttrncy43 | float | 2017 Est: U.S. Postal Service (S) |
bs_ds1_esttrncy44 | float | 2017 Est: Water Transportation (S) |
bs_ds1_esttrncy45 | float | 2017 Est: Transportation by Air (S) |
bs_ds1_esttrncy46 | float | 2017 Est: Pipelines, Except Natural Gas (S) |
bs_ds1_esttrncy47 | float | 2017 Est: Transportation Services (S) |
bs_ds1_esttrncy48 | float | 2017 Est: Communication (S) |
bs_ds1_esttrncy49 | float | 2017 Est: Electric, Gas and Sanitary Services (S) |
bs_ds1_estwhlcy50 | float | 2017 Est: Wholesale Trade - Durable Goods (S) |
bs_ds1_estwhlcy51 | float | 2017 Est: Wholesale Trade - Non-Durable Goods (S) |
bs_ds1_paycyagric | float | 2017 Payroll: Agricultural, Forestry, Fishing (S) |
bs_ds1_paycyconst | float | 2017 Payroll: Construction (S) |
bs_ds1_paycyfire | float | 2017 Payroll: Finance, Insurance and Real Estate (S) |
bs_ds1_paycymanuf | float | 2017 Payroll: Manufacturing (S) |
bs_ds1_paycymine | float | 2017 Payroll: Mining (S) |
bs_ds1_paycypubad | float | 2017 Payroll: Public Administration (S) |
bs_ds1_paycyrtrad | float | 2017 Payroll: Retail Trade (S) |
bs_ds1_paycysrv | float | 2017 Payroll: Services (S) |
bs_ds1_paycytrans | float | 2017 Payroll: Transportation and Communications (S) |
bs_ds1_paycywtrad | float | 2017 Payroll: Wholesale Trade (S) |
bs_ds1_paycyuncla | float | 2017 Payroll: Unclassified (S) |
bs_ds1_eszcya | float | 2017 Est: 1 - 4 Employees (S) |
bs_ds1_eszcyb | float | 2017 Est: 5 - 9 Employees (S) |
bs_ds1_eszcyc | float | 2017 Est: 10 - 19 Employees (S) |
bs_ds1_eszcyd | float | 2017 Est: 20 - 49 Employees (S) |
bs_ds1_eszcye | float | 2017 Est: 50 - 99 Employees (S) |
bs_ds1_eszcyf | float | 2017 Est: 100 - 249 Employees (S) |
bs_ds1_eszcyg | float | 2017 Est: 250 - 499 Employees (S) |
bs_ds1_eszcyh | float | 2017 Est: 500 - 999 Employees (S) |
bs_ds1_eszcyi | float | 2017 Est: 1000 - 2499 Employees (S) |
bs_ds1_eszcyo | float | 2017 Est: 2500 or more Employees (S) |