# Seattle 911 overdose calls by address (Jan 2023 - Oct 2026)

How the tables were made. All pulls were made on 2026-11-10 from Seattle's open data portal (Socrata API).

## 1. Overdose calls by address
Source: Seattle Real Time Fire 911 Calls, https://data.seattle.gov/resource/kzjm-xkqj.json

Overdose call types (from `$select=type,count(*) ... $group=type`): "Medic Response- Overdose" (first used 2022-08-18), "Medic Response- Overdose 14" (first used 2023-09-20), "BC Med Response Overdose" (one row).

For each period (2023, 2024, 2025, and 2026-01-01 to 2026-10-31):

    $select=address,count(*) as n
    $where=type in('Medic Response- Overdose','Medic Response- Overdose 14','BC Med Response Overdose') AND datetime between '<start>T00:00:00' and '<end>T23:59:59'
    $group=address  $order=n DESC  $limit=50000

Addresses were upper-cased and their spaces trimmed. Addresses containing "/" are intersections (street scenes) and are left out of the building rankings. They are still counted in the citywide totals.

## 2. Building sizes (comparison group)
Source: Seattle Rental Property Registration, https://data.seattle.gov/resource/j2xh-c7vt.json

    $select=permitnum,propertyname,originaladdress1,rentalhousingunits,statuscurrent,registereddate
    $where=rentalhousingunits >= 20

Units were summed by address. The comparison group is every registered address with 50 or more units that is not a supportive housing address, Mary Pilgrim Inn (14115 Aurora Ave N) or The Gateway (13300 Stone Ave N).

## 3. Supportive housing list
Permanent supportive housing buildings in Seattle were taken from operator websites (DESC, Plymouth Housing, Catholic Community Services, Chief Seattle Club, Low Income Housing Institute), the King County Regional Homelessness Authority's services database (https://kcrha.github.io/regional_services_database/resources.json) and the Seattle Office of Housing renters map. The table has one row per address with a street address; `source_url` gives the main source for each.

## 4. Coding check
All call types at the supportive housing addresses, and citywide, 2023-01-01 to 2026-10-31, grouped by type. "Medical" means any type containing "Aid" or "Medic", excluding mutual-aid types.

## Scripts
`match.js` joins the registration data to the call counts (it writes rrio_with_calls.json). `build_tables.js` writes the CSVs. They read the raw API responses from a `data/` folder; that folder is not included, and the queries above recreate it. Run with Node.js.