Report not found

There was a problem finding this report.

Report

Query 1

Query 2

Query 3

Query 4

Query 5

Query 6

Created in the Mode Community
March 26, 2016 · Refreshed over 1 year ago
Crime in SF

Collaborators

Run History
SELECT pd_district, COUNT(id), SUM(CASE WHEN RESOLUTION = 'NONE' then 1 ELSE 0 END) as unsolved, SUM(CASE WHEN RESOLUTION = 'NONE' then 0 ELSE 1 END) * 100 / COUNT(RESOLUTION) || '%' as percent_resolved FROM tutorial.sf_crime_incidents_cleandate GROUP BY 1 ORDER BY 2 DESC
SELECT pd_district, COUNT(id), SUM(CASE WHEN RESOLUTION = 'NONE' then 1 ELSE 0 END) as unsolved, SUM(CASE WHEN RESOLUTION = 'NONE' then 0 ELSE 1 END) * 100 / COUNT(RESOLUTION) || '%' as percent_resolved FROM tutorial.sf_crime_incidents_cleandate GROUP BY 1 ORDER BY 2 DESC
SELECT pd_district, COUNT(id), SUM(CASE WHEN RESOLUTION = 'NONE' then 1 ELSE 0 END) as unsolved, SUM(CASE WHEN RESOLUTION = 'NONE' then 0 ELSE 1 END) * 100 / COUNT(RESOLUTION) || '%' as percent_resolved FROM tutorial.sf_crime_incidents_cleandate GROUP BY 1 ORDER BY 4 DESC
SELECT pd_district, COUNT(id), SUM(CASE WHEN RESOLUTION = 'NONE' then 1 ELSE 0 END) as unsolved, SUM(CASE WHEN RESOLUTION = 'NONE' then 0 ELSE 1 END) * 100 / COUNT(RESOLUTION) || '%' as percent_resolved FROM tutorial.sf_crime_incidents_cleandate GROUP BY 1 ORDER BY 4 DESC
SELECT * FROM tutorial.sf_crime_incidents_cleandate LIMIT 100
SELECT * FROM tutorial.sf_crime_incidents_cleandate
SELECT sub.* FROM ( SELECT * FROM tutorial.sf_crime_incidents_2014_01 WHERE descript = 'WARRANT ARREST' ) sub WHERE sub.resolution = 'NONE'
SELECT sub.* FROM ( SELECT * FROM tutorial.sf_crime_incidents_2014_01 WHERE descript = 'WARRANT ARREST' ) sub WHERE sub.resolution = 'NONE'
SELECT descript, cleaned_date AS date, NOW() AT TIME ZONE 'PST' - cleaned_date AS time_ago FROM tutorial.sf_crime_incidents_cleandate ORDER BY 3 DESC
SELECT descript, cleaned_date AS date, NOW() AT TIME ZONE 'PST' - cleaned_date AS time_ago FROM tutorial.sf_crime_incidents_cleandate ORDER BY 3 DESC
SELECT DATE_TRUNC('week', cleaned_date)::date as Week, COUNT(*) as Incidents FROM tutorial.sf_crime_incidents_cleandate GROUP BY 1 ORDER BY 1
SELECT DATE_TRUNC('week', cleaned_date)::date as Week, COUNT(*) as Incidents FROM tutorial.sf_crime_incidents_cleandate GROUP BY 1 ORDER BY 1
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_1554a7f98dd0" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_443710165520" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_0e58e8e54014" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_75ea70b45bd5" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_9cac87e83892" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_0b1e439ff0e4" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_d2a44fa9b911" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_318b33a4bca1" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_34d216e28b1e" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_417cac4139b6" dataset="dataset" options="table_options"></mode-table> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_5aa58e8652f2" dataset="dataset" options="table_options"></mode-table> </div> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query. Get help here.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled