jeffreyk/homelessness-dashboard
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
No description
4 commits 1 branch 0 tags 29 KiB
  • Python 70.3%
  • Dockerfile 29.7%
Find a file
Exact
Jeffrey Kersh 73ecd501a0 Stop tracking .env
2026-04-18 21:26:35 -07:00
dashboard initial commit 2026-04-18 21:14:15 -07:00
sql initial commit 2026-04-18 21:14:15 -07:00
.dockerignore initial commit 2026-04-18 21:14:15 -07:00
.env.example initial commit 2026-04-18 21:14:15 -07:00
.gitignore remove .env (and change db name/pw) 2026-04-18 21:21:45 -07:00
docker-compose.yml initial commit 2026-04-18 21:14:15 -07:00
Dockerfile initial commit 2026-04-18 21:14:15 -07:00
README.md update readme 2026-04-18 21:25:07 -07:00
requirements.txt initial commit 2026-04-18 21:14:15 -07:00

README.md

README

Project

The Question

This dashboard investigates whether homelessness and crime in Seattle changed meaningfully between 2018 and 2024, and whether those changes track each other.

Specifically:
1. Did homelessness rise significantly post-2020 in Seattle?
2. Was the trend underway before 2020, or was it an inflection?
3. Did overall crime rise or specific types?
4. Did it rise citywide or in specific areas?
5. Was there an inflection point in 2020, or was this already a trend?
6. Is there any correlation between homelessness and crime rates? Possibly any relationships?

The Audience

People who want to know if Seattle is a worse place to visit due to crime and homelessness.

The Dashboard

Top - Headline/key metric
Middle - why, what drives this, where is it
Bottom - details for those who want to verify/drill down

Tech Stack

  • ETL - python/sql
  • Data Storage - postgres
  • Scheduling - cron job
  • Dashboard - Streamlit

Next Steps

Pull the HUD Point-in-Time counts for King County 2018–2024 (getting a couple years pre-Covid gives you a baseline) Pull SPD incident data by year and crime category