[
  {
    "name": "unique_key",
    "type": "INTEGER",
    "description": "A unique identifier for each crime record."
  },
  {
    "name": "case_number",
    "type": "STRING",
    "description": "The official case number assigned to the incident."
  },
  {
    "name": "date",
    "type": "TIMESTAMP",
    "description": "The date and time of the incident in UTC."
  },
  {
    "name": "block",
    "type": "STRING",
    "description": "The street block where the incident occurred."
  },
  {
    "name": "iucr",
    "type": "STRING",
    "description": "Illinois Uniform Crime Reporting code."
  },
  {
    "name": "primary_type",
    "type": "STRING",
    "description": "The main category of the crime."
  },
  {
    "name": "description",
    "type": "STRING",
    "description": "A detailed description of the crime."
  },
  {
    "name": "location_description",
    "type": "STRING",
    "description": "Description of the location where the incident took place."
  },
  {
    "name": "arrest",
    "type": "BOOLEAN",
    "description": "Indicates whether an arrest was made."
  },
  {
    "name": "domestic",
    "type": "BOOLEAN",
    "description": "Indicates whether the incident was domestic-related."
  },
  {
    "name": "beat",
    "type": "INTEGER",
    "description": "The police beat number."
  },
  {
    "name": "district",
    "type": "INTEGER",
    "description": "The police district number."
  },
  {
    "name": "ward",
    "type": "INTEGER",
    "description": "The city ward number."
  },
  {
    "name": "community_area",
    "type": "INTEGER",
    "description": "The community area number."
  },
  {
    "name": "fbi_code",
    "type": "STRING",
    "description": "FBI crime classification code."
  },
  {
    "name": "x_coordinate",
    "type": "FLOAT",
    "description": "The x-coordinate of the location."
  },
  {
    "name": "y_coordinate",
    "type": "FLOAT",
    "description": "The y-coordinate of the location."
  },
  {
    "name": "year",
    "type": "INTEGER",
    "description": "The year the incident occurred."
  },
  {
    "name": "updated_on",
    "type": "TIMESTAMP",
    "description": "The date and time the record was last updated in UTC."
  },
  {
    "name": "latitude",
    "type": "FLOAT",
    "description": "The latitude of the location."
  },
  {
    "name": "longitude",
    "type": "FLOAT",
    "description": "The longitude of the location."
  },
  {
    "name": "location",
    "type": "STRING",
    "description": "A string representation of the latitude and longitude coordinates."
  }
]