Aterio Datasets
US Unemployment Statistics
| STATE_CODE | CITY_NAME | ZIP_CODE | TOT_POP_CIVILIAN_EMPLOYED_LY | TOT_POP_CIVILIAN_UNEMPLOYED_LY |
|---|---|---|---|---|
| OR | Lake Oswego | 97034 | 9511 | 691 |
| WA | Seattle | 98112 | 13901 | 945 |
| OR | Toledo | 97391 | 2319 | 378 |
| WA | Seattle | 98190 | 17730 | 1533 |
| OR | Dillard | 97432 | 3022 | 146 |
| WA | Granger | 98932 | 2252 | 383 |
| OR | Salem | 97306 | 16286 | 719 |
Dive into the heart of economic dynamics with Aterio's Unemployment Data, now available on Snowflake Marketplace. Our dataset offers a month-by-month breakdown of unemployment trends from the height of the COVID pandemic to the latest available data (2023), categorized into civilian and armed employment numbers. This rich dataset allows you to explore how unemployment in specific zip codes has evolved, providing a valuable economic indicator for real estate investors and decision-makers.
Key Features:
-
COVID-Era Tracking: Gain a deep understanding of how unemployment rates have shifted from the peak of the pandemic to the present, offering a valuable perspective on economic recovery.
-
Zip Code Granularity: Drill down to the local level, with data organized by zip code, enabling targeted analysis.
-
Latest Data: Stay on top of the most current employment figures with monthly updates, ensuring you have the latest insights for your investment strategies.
Fields
| Column Name | Description |
|---|---|
| ZIP_CODE | US Zip Code |
| CITY_NAME | City name |
| COUNTY_NAME | County name |
| COUNTY_FIPS_CODE | Federal Information Processing Standards (FIPS) code for counties |
| STATE_CODE | State code |
| TOT_POP_OVER_16_LY | Total population over 16 years |
| TOT_POP_LABOR_FORCE_LY | Total population in the labor force |
| TOT_POP_CIVILIAN_EMPLOYED_LY | Total civilian population employed |
| TOT_POP_CIVILIAN_UNEMPLOYED_LY | Total civilian population unemployed |
| TOT_POP_ARMED_EMPLOYED_LY | Total armed population employed |
| RT_ARMED_EMPLOYED_LY | Rate of armed population employed |
| AVG_RT_UNEMPLOYMENT_COUNTY_6M | Average county unemployment rate over the last 6 months |
| RT_UNEMPLOYMENT_COUNTY_LM | County unemployment rate |
| JANUARY_2023 | Unemployment rate for January 2023 |
| FEBRUARY_2023 | Unemployment rate for February 2023 |
| MARCH_2023 | Unemployment rate for March 2023 |
| APRIL_2023 | Unemployment rate for April 2023 |
| MAY_2023 | Unemployment rate for May 2023 |
| JUNE_2023 | Unemployment rate for June 2023 |
| JULY_2023 | Unemployment rate for July 2023 |
| AUGUST_2023 | Unemployment rate for August 2023 |
| SEPTEMBER_2023 | Unemployment rate for September 2023 |
| OCTOBER_2023 | Unemployment rate for October 2023 |
| NOVEMBER_2023 | Unemployment rate for November 2023 |
| LATEST_UPDATE | Date of the last data update |