crime-incidents-joined.json

{
  "version": "2",
  "header": {
    "title": "Crime Incidents 2015 - October 2016",
    "description": "Philadelphia Police Department crime incidents from calendar year 2006 to present, including Part I and Part II crimes. UCR codes are generalized and incident locations are rounded to the hundred block. These counts may not coincide exactly with data that is submitted to the Uniformed Crime Reporting (UCR) system.",
    "navigation": [
      {
        "label": "Download",
        "url": ""
      }
    ]
  },
  "cards": [
    {
      "x": 0,
      "y": 0,
      "width": 12,
      "height": 5,
      "vizwit": {
        "title": "Dispatch Date",
        "description": "The date and time that the officer was dispatched to the scene.",
        "chartType": "datetime",
        "provider": "cartodb",
        "domain": "timwis.carto.com",
        "dataset": "crimes_2015_to_oct_2016_joined",
        "groupBy": "date_trunc('month', dispatch_date)",
        "triggerField": "dispatch_date"
      }
    },
    {
      "x": 0,
      "y": 5,
      "width": 6,
      "height": 4,
      "vizwit": {
        "title": "Police District",
        "chartType": "pie",
        "provider": "cartodb",
        "domain": "timwis.carto.com",
        "dataset": "crimes_2015_to_oct_2016_joined",
        "groupBy": "dc_dist"
      }
    },
    {
      "x": 4,
      "y": 5,
      "width": 6,
      "height": 4,
      "vizwit": {
        "title": "Police Districts",
        "chartType": "choropleth",
        "provider": "cartodb",
        "domain": "timwis.cartodb.com",
        "dataset": "crimes_2015_to_oct_2016_joined",
        "groupBy": "police_district_label",
        "boundaries": "https://timwis.carto.com/api/v2/sql?q=select+*+from+public.police_district_boundaries&format=geojson",
        "boundariesLabel": "dist_num",
        "boundariesId": "cartodb_id"
      }
    },
    {
      "x": 0,
      "y": 9,
      "width": 12,
      "height": 5,
      "vizwit": {
        "title": "General Crime Category",
        "description": "The generalized text for the crime code",
        "chartType": "bar",
        "provider": "cartodb",
        "domain": "timwis.carto.com",
        "dataset": "crimes_2015_to_oct_2016_joined",
        "groupBy": "text_general_code"
      }
    },
    {
      "x": 0,
      "y": 14,
      "width": 12,
      "height": 7,
      "vizwit": {
        "title": "Crime Incidents",
        "chartType": "table",
        "provider": "cartodb",
        "domain": "timwis.carto.com",
        "dataset": "crimes_2015_to_oct_2016_joined",
        "columnsToHide": [
            "cartodb_id",
            "the_geom",
            "the_geom_webmercator"
        ]
      }
    }
  ]
}