This project is an overview of how safe the areas in Stockton CA are. The dataset that I obtained is from the Stockton County Website. The original dataset spanned from 2019 - June 2024. The file size was massive and I thought it would make sense to focus on 2023 - June 2024.
You can checkout the python notebooks to see how I cleaned and explored the data. It is detailed with the steps I took.
SELECT COUNT(*) FROM data_final;
// *********************************************************************************** //
SELECT
COUNT(*)
FROM data_final
WHERE call_entry_date <= '2023-12-31';
// *********************************************************************************** //
SELECT
COUNT(*)
FROM data_final
WHERE call_entry_date >= '2024-01-01';
// *********************************************************************************** //
| DISTRICT_COUNT | DISTRICT_NAME |
|---|---|
| 181484 | CIVIC |
| 108081 | LAKEVIEW |
| 96621 | SEAPORT |
| 93007 | VALLEY OAK |
| 88484 | PARK |
SELECT
COUNT(*) AS DISTRICT_COUNT, district_name
FROM data_final
GROUP BY district_name
LIMIT 5;
// *********************************************************************************** //
amazon-quicksight-project-analytics.pdf
- 654,888 from 2023 - June 2024 and counting
- Bear Creek and SJC are the two districts with the least amount of police presence
- Top Three reasons for police calls are 911 hangups, ambulance requests, and disturbing the peace
- Year over Year SJC and Bear Creek have kept a low police call count