ArcGIS REST Services Directory Login
JSON

Layer: Employment - County 2021 (ID: 31)

View In:   ArcGIS Online Map Viewer

Name: Employment - County 2021

Display Field: county

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: ---------- Processing Steps ----------The County Business Patterns CSV dataset (CBP2021.CB2100CBP) was imported into a pandas DataFrame, and specific NAICS codes were selected, focusing on establishments regardless of size (EMPSZES == '001'). The DataFrame was filtered to retain only critical columns: GEO_ID, NAME, EMPSZES_LABEL, YEAR, ESTAB, and EMP. An output DataFrame was created to store the restructured data, with each row uniquely identifying a county via GEO_ID. The number of establishments (ESTAB) and employees (EMP) were compiled for each selected NAICS code. Missing values were replaced with zeros to ensure continuity. The data was spatially enriched by joining with a 2019 County Shapefile, and a thorough consistency check was conducted to guarantee full national coverage, marking counties with no data appropriately.---------- Additional Information ----------Data Fields:GEO_ID: Geographic identifier codeNAME: County nameYEAR: Data year (2021 for all records)EMPSZES: Employment size category ('001' for all records)EMPSZES_LABEL: Employment size descriptor ('All establishments')ESTAB: Number of establishments (summed by NAICS code)EMP: Number of employees (summed by NAICS code)Additional columns are prefixed with 'NAICS_' plus the code, with suffixes '_ESTAB' and '_EMP' indicating the data type.Included NAICS Codes:NAICS Codes and Descriptions:00: Total for all sectors2213: Waste, Sewer, and Other Systems31-33: Manufacturing211: Oil and Gas Extraction2121: Coal Mining213111: Drilling Oil and Gas Wells213112: Support Activities for Oil and Gas Operations213113: Support Activities for Coal Mining32411: Petroleum Refineries4861: Pipeline Transportation of Crude Oil4862: Pipeline Transportation of Natural Gas311000: Food Manufacturing312000: Beverage and Tobacco Product Manufacturing313000: Textile Mills314000: Textile Product Mills315000: Apparel Manufacturing316000: Leather and Allied Product Manufacturing321000: Wood Product Manufacturing322000: Paper Manufacturing3221: Pulp, Paper, and Paperboard Mills3222: Converted Paper Product Manufacturing323000: Printing and Related Support Activities324000: Petroleum and Coal Products Manufacturing325000: Chemical Manufacturing3251: Basic Chemical Manufacturing3252: Resin, Synthetic Rubber, and Artificial and Synthetic Fibers and Filaments Manufacturing3253: Pesticide, Fertilizer, and Other Agricultural Chemical Manufacturing3254: Pharmaceutical and Medicine Manufacturing3255: Paint, Coating, and Adhesive Manufacturing326000: Plastics and Rubber Products Manufacturing327000: Nonmetallic Mineral Product Manufacturing3271: Clay Product and Refractory Manufacturing3272: Glass and Glass Product Manufacturing3273: Cement and Concrete Product Manufacturing3274: Lime and Gypsum Product Manufacturing3279: Other Nonmetallic Mineral Product Manufacturing331000: Primary Metal Manufacturing3311: Iron and Steel Mills and Ferroalloy Manufacturing3312: Steel Product Manufacturing from Purchased Steel3313: Alumina and Aluminum Production and Processing3314: Nonferrous Metal (except Aluminum) Production and Processing3315: Foundries332000: Fabricated Metal Product Manufacturing3321: Forging and Stamping3323: Architectural and Structural Metals Manufacturing333000: Machinery Manufacturing3331: Agriculture, Construction, and Mining Machinery Manufacturing3332: Industrial Machinery Manufacturing3333: Commercial and Service Industry Machinery Manufacturing3334: Ventilation, Heating, Air-Conditioning, and Commercial Refrigeration Equipment Manufacturing3335: Metalworking Machinery Manufacturing3336: Engine, Turbine, and Power Transmission Equipment Manufacturing3339: Other General Purpose Machinery Manufacturing334000: Computer and Electronic Product Manufacturing3341: Computer and Peripheral Equipment Manufacturing3342: Communications Equipment Manufacturing3344: Semiconductor and Other Electronic Component Manufacturing3345: Navigational, Measuring, Electromedical, and Control Instruments Manufacturing3346: Manufacturing and Reproducing Magnetic and Optical Media335000: Electrical Equipment, Appliance, and Component Manufacturing3351: Electric Lighting Equipment Manufacturing3352: Household Appliance Manufacturing3353: Electrical Equipment Manufacturing3359: Other Electrical Equipment and Component Manufacturing33591: Battery Manufacturing335910: Battery Manufacturing336000: Transportation Equipment Manufacturing3361: Motor Vehicle Manufacturing3362: Motor Vehicle Body and Trailer Manufacturing3363: Motor Vehicle Parts Manufacturing3364: Aerospace Product and Parts Manufacturing3365: Railroad Rolling StockMethodology and Limitations:For more details on the original data collection and production methods, refer to the U.S. Census Bureau's [Program Methodology](https://www.census.gov/programs-surveys/cbp/technical-documentation/methodology.html).Additional Information from Original Data Source:Original data uses Noise disclosure methodology from 2007 for confidentiality, includes only establishments with payroll. certain employment-size classes are available at specific geographic levels only. Original data was released April 27, 2023.Source Use Restrictions: This dataset is public domain and can be freely used, with proper citation to the U.S. Census Bureau's County Business Patterns as the original data source.

Service Item Id: ea8ab62f67d3480895831512cc10c85d

Copyright Text: Original Data: U.S. Census Bureau's County Business Patterns 2021 (CBP2021.CB2100CBP) Original Data Source Weblink: https://www.census.gov/programs-surveys/cbp.html

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1155581.108577

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
Drawing Info: Advanced Query Capabilities:
HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields: Templates:
Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata