Canada Core Lmi Dat Wf Demog
CANADA CORE LMI DAT_WF_DEMOG
| Column Name | Snowflake | Big Query | Databricks | Parquet | Comment |
|---|---|---|---|---|---|
| AGEID | VARCHAR | STRING | STRING | STRING | ID of the age range. |
| AGEID_NAME | VARCHAR | STRING | STRING | STRING | Name of the age range. |
| AREAID | VARCHAR | STRING | STRING | STRING | ID of the geographic region. |
| AREAID_NAME | VARCHAR | STRING | STRING | STRING | Name of the geographic region. |
| AREAID_TYPE | VARCHAR | STRING | STRING | STRING | Geographic area type. |
| GENDERID | VARCHAR | STRING | STRING | STRING | ID of the gender. |
| GENDERID_NAME | VARCHAR | STRING | STRING | STRING | Name of the gender. |
| OCCID | VARCHAR | STRING | STRING | STRING | NOC code. |
| OCCID_NAME | VARCHAR | STRING | STRING | STRING | NOC name. |
| RACEID | VARCHAR | STRING | STRING | STRING | ID of the race. |
| RACEID_NAME | VARCHAR | STRING | STRING | STRING | Name of the race. |
| WORKERS | FLOAT | FLOAT | DOUBLE | FLOAT | The number of workers in the area matching the designated dimensions. |
| YEAR | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | Year of data. |
Updated about 8 hours ago
