Us Core Lmi Dat Unemp Occ
US CORE LMI DAT_UNEMP_OCC
| Column Name | Snowflake | Big Query | Databricks | Parquet | Comment |
|---|---|---|---|---|---|
| AREAID | VARCHAR | STRING | STRING | STRING | Geographic region code. |
| AREAID_NAME | VARCHAR | STRING | STRING | STRING | Geographic region name. |
| AREAID_TYPE | VARCHAR | STRING | STRING | STRING | Geographic area type. |
| EMP | FLOAT | FLOAT | DOUBLE | FLOAT | The number of occupied positions. One worker might fill more than one position. |
| MONTH | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | Month of data. |
| OCCID | VARCHAR | STRING | STRING | STRING | SOC code. |
| OCCID_NAME | VARCHAR | STRING | STRING | STRING | SOC name. |
| TWELVEMONTHEMPAVERAGE | FLOAT | FLOAT | DOUBLE | FLOAT | The average employment over the last 12 months. |
| TWELVEMONTHUNEMPAVERAGE | FLOAT | FLOAT | DOUBLE | FLOAT | The average unemployment over the last 12 months. |
| UNEMP | FLOAT | FLOAT | DOUBLE | FLOAT | The number of unemployed people in the area. |
| YEAR | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | Year of data. |
Updated about 8 hours ago
