Skip to content

Instantly share code, notes, and snippets.

@timwis
Last active November 4, 2015 11:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timwis/59b8b851c27d8e6b11f6 to your computer and use it in GitHub Desktop.
Save timwis/59b8b851c27d8e6b11f6 to your computer and use it in GitHub Desktop.
Prisons VizWit Config
{
"version": "2",
"header": {
"title": "Philadelphia Prison System",
"description": "Mission: To provide a secure correctional environment that adequately detains persons accused or convicted of illegal acts; to provide programs, services, and supervision in a safe, lawful, clean, humane environment; and to prepare incarcerated persons for reentry into society in a frame of mind that will facilitate their becoming law-abiding citizens."
},
"cards": [
{
"x": 0,
"y": 0,
"width": 4,
"height": 2,
"vizwit": {
"chartType": "callout",
"title": "Total Population",
"domain": "localhost",
"dataset": "qkv3-xw76",
"valueField": "date as label, total_population",
"valueFormat": "0,0",
"labelFormat": "[As of] M/D/YYYY",
"order": "date desc",
"limit": 1,
"channel": null
}
},
{
"x": 4,
"y": 0,
"width": 4,
"height": 2,
"vizwit": {
"chartType": "callout",
"title": "Admissions",
"domain": "localhost",
"dataset": "qkv3-xw76",
"groupBy": "date_trunc_ym(date)",
"aggregateField": "admissions",
"aggregateFunction": "sum",
"valueFormat": "0,0",
"labelFormat": "MMM YYYY",
"order": "label desc",
"limit": 1,
"channel": null
}
},
{
"x": 4,
"y": 0,
"width": 4,
"height": 2,
"vizwit": {
"chartType": "callout",
"title": "Releases",
"domain": "localhost",
"dataset": "qkv3-xw76",
"groupBy": "date_trunc_ym(date)",
"aggregateField": "releases",
"aggregateFunction": "sum",
"valueFormat": "0,0",
"labelFormat": "MMM YYYY",
"order": "label desc",
"limit": 1,
"channel": null
}
},
{
"x": 0,
"y": 2,
"width": 12,
"height": 4,
"vizwit": {
"chartType": "datetime",
"title": "Total Population",
"domain": "localhost",
"dataset": "qkv3-xw76",
"groupBy": "date_trunc_ym(date)",
"triggerField": "date",
"aggregateFunction": "avg",
"aggregateField": "total_population"
}
},
{
"x": 0,
"y": 2,
"width": 12,
"height": 4,
"vizwit": {
"chartType": "stacked",
"title": "Total Population",
"domain": "localhost",
"dataset": "qkv3-xw76",
"groupBy": "date_trunc_y(date)",
"triggerField": "date",
"fields": ["avg(total_male_population)", "avg(total_female_population)"]
}
},
{
"x": 0,
"y": 2,
"width": 12,
"height": 4,
"vizwit": {
"chartType": "table",
"title": "Daily Stats",
"domain": "localhost",
"dataset": "qkv3-xw76"
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment