Us Core Lmi Dat Crime
US CORE LMI DAT_CRIME
| Column Name | Snowflake | Big Query | Databricks | Parquet | Comment |
|---|---|---|---|---|---|
| AGGASSAULT | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of aggravated assaults reported. |
| 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. |
| ARSONS | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of arsons reported. |
| BURGLARIES | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of burglaries reported. |
| FORCIBLERAPES | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of forcible rapes reported. |
| LARCENIES | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of larcenies reported. |
| MTRVEHTHEFTS | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of motor vehicle thefts reported. |
| MURDERS | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of murders reported. |
| PROPERTYCRIMES | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of property crimes reported. |
| ROBBERIES | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of robberies reported. |
| VIOLENTCRIMES | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | The number of violent crimes reported. |
| YEAR | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | Year of data. |
Updated about 8 hours ago