Seattle Crime Data Scraper avatar

Seattle Crime Data Scraper

Pricing

from $19.00 / 1,000 results

Go to Apify Store
Seattle Crime Data Scraper

Seattle Crime Data Scraper

Collects Seattle Police Department incident reports from the city's open-data portal. Returns each incident as a flat row with date, offense, precinct, and coordinates. Filter by precinct or NIBRS crime category.

Pricing

from $19.00 / 1,000 results

Rating

0.0

(0)

Developer

Acquisition Automation Co.

Acquisition Automation Co.

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

6 days ago

Last modified

Share

Acquisition Automation Co. Search less. Close more.

πŸš“ Seattle Crime Data Scraper

Seattle Police Department incident reports as flat rows, with offense, NIBRS classification, precinct, beat, neighborhood, block address and coordinates. Filter by precinct or crime against category, cap the run, export to CSV, Excel, JSON or XML. No API key and no registration.

Seattle publishes every SPD offense report to its open data portal, back to 2008. The portal is built for browsing, not for attaching to a diligence file. This Actor pulls the records you ask for and writes each offense into a dataset you can filter by neighborhood, by beat or by the block the business sits on.

Who uses itWhat they use the reports for
πŸͺ Buyers of Seattle storefronts and service businessesChecking what has been reported around an address before agreeing a price or a lease
πŸ“‹ Insurance and risk analystsCounting property offenses by beat rather than by impression
🏒 Commercial landlords and property managersComparing precincts and neighborhoods with the same set of columns
πŸ“° Journalists and civic researchersBuilding a dated incident set with NIBRS categories attached

πŸ“‹ What it does

πŸ’‘ Why it matters: a retail or service business is bought at a specific corner. The city's own offense record is the cheapest way to see what happens on that corner, and it is public.

  • πŸ—Ί Filters by SPD precinct, for example WEST or NORTH.
  • 🏷 Filters by NIBRS crime against category: PERSON, PROPERTY, SOCIETY or NOT_A_CRIME.
  • πŸ“ Returns coordinates and the block address where the city publishes them, plus beat, sector, neighborhood and reporting area.
  • 🧾 Keeps the report and offense identifiers, so one report with several offenses stays traceable.
  • ⏱ Carries both timestamps: when the offense happened and when it was reported.
  • πŸ’Ύ Exports to CSV, Excel, JSON or XML, from the run page or the API.

πŸ“Š Output

Every offense is one flat row. One report can produce several rows, one per offense. REDACTED is what the city itself publishes when it withholds a location, and - is its blank marker.

FieldTypeDescription
πŸš” offensestringOffense name, for example Simple Assault
🏷 offense_categorystringBroad category, for example VIOLENT CRIME or ALL OTHER
πŸ—‚ offense_sub_categorystringSub category, for example ASSAULT OFFENSES
βš–οΈ nibrs_crime_against_categorystringNIBRS crime against category: PERSON, PROPERTY, SOCIETY, ANY or NOT_A_CRIME
πŸ”€ nibrs_group_a_bstringNIBRS reporting group, A or B
πŸ”« shooting_type_groupstringShooting classification where one applies, - when it does not
🧾 report_numberstringSPD report number, for example 2026-273587
πŸ†” idstringRow identifier, the same value as report_number
πŸ†” offense_idstringIdentifier for the individual offense inside the report
πŸ“… offense_datestringWhen the offense occurred, local time
πŸ•“ report_date_timestringWhen the report was filed, local time
πŸ“ block_addressstringBlock level address, for example 48XX BLOCK OF SAND POINT WAY NE. REDACTED on withheld locations
🧭 latitudenumberLatitude in decimal degrees. null on withheld locations
🧭 longitudenumberLongitude in decimal degrees. null on withheld locations
πŸš“ precinctstringSPD precinct, for example North
πŸ—Ί sectorstringSPD sector letter
πŸ“Œ beatstringSPD beat, for example L2
🏘 neighborhoodstringNeighborhood name, for example NORTHGATE, or - where none is published
πŸ”’ reporting_areastringReporting area code. REDACTED on withheld locations
πŸ“ titlestringRepeats the offense name
πŸ”— urlstringLink to the city's SPD crime dataset page
πŸ”— sourceUrlstringThe same dataset page, kept for traceability
πŸ–Ό imageUrlstringImage field carried by the Actor template. null on every row
πŸ•’ scrapedAtstringISO timestamp of collection
⚠️ errorstringnull on a normal row

Example rows

{
"imageUrl": null,
"title": "All Other Offenses",
"url": "https://data.seattle.gov/Public-Safety/SPD-Crime-Data-2008-Present/tazs-3rd5",
"id": "2026-273587",
"report_number": "2026-273587",
"report_date_time": "2026-09-13T22:48:11.000",
"offense_id": "73116934051",
"offense_date": "2026-09-13T21:27:00.000",
"nibrs_group_a_b": "B",
"nibrs_crime_against_category": "ANY",
"offense_sub_category": "ALL OTHER",
"shooting_type_group": "-",
"block_address": "REDACTED",
"latitude": null,
"longitude": null,
"beat": "L2",
"precinct": "North",
"sector": "L",
"neighborhood": "NORTHGATE",
"reporting_area": "REDACTED",
"offense_category": "ALL OTHER",
"offense": "All Other Offenses",
"sourceUrl": "https://data.seattle.gov/Public-Safety/SPD-Crime-Data-2008-Present/tazs-3rd5",
"scrapedAt": "2026-09-14T16:38:05.377Z",
"error": null
}
{
"imageUrl": null,
"title": "Simple Assault",
"url": "https://data.seattle.gov/Public-Safety/SPD-Crime-Data-2008-Present/tazs-3rd5",
"id": "2026-273587",
"report_number": "2026-273587",
"report_date_time": "2026-09-13T22:48:11.000",
"offense_id": "73116915953",
"offense_date": "2026-09-13T21:27:00.000",
"nibrs_group_a_b": "A",
"nibrs_crime_against_category": "PERSON",
"offense_sub_category": "ASSAULT OFFENSES",
"shooting_type_group": "-",
"block_address": "REDACTED",
"latitude": null,
"longitude": null,
"beat": "L2",
"precinct": "North",
"sector": "L",
"neighborhood": "-",
"reporting_area": "REDACTED",
"offense_category": "ALL OTHER",
"offense": "Simple Assault",
"sourceUrl": "https://data.seattle.gov/Public-Safety/SPD-Crime-Data-2008-Present/tazs-3rd5",
"scrapedAt": "2026-09-14T16:38:05.473Z",
"error": null
}

✨ Why choose this Actor

What you get
The city's own recordRows come from Seattle's open data portal, not from a crime map app.
No credentialsThe portal is public. No key, no account, no quota.
25 fields, every runSame columns each time, so several precincts stack into one table.
Offense level detailA report with three offenses gives three rows, each with its own NIBRS classification.
You pay per rowNo subscription. A filtered run costs what it returns.

πŸš€ How to use it

  1. Create a free Apify account. New accounts start with $5 of credit.
  2. Open the Actor and select Try for free.
  3. Set precinct, category, or neither for everything.
  4. Set maxItems to cap the run.
  5. Select Start, then export from the Dataset tab as CSV, Excel, JSON or XML.

A first run:

{
"maxItems": 10
}

Property offenses in the West precinct:

{
"precinct": "WEST",
"category": "PROPERTY",
"maxItems": 500
}

βš™οΈ Input

FieldRequiredDescription
precinctNoSPD precinct to filter on, for example WEST, NORTH. Empty returns every precinct
categoryNoNIBRS crime against category: PERSON, PROPERTY, SOCIETY or NOT_A_CRIME
maxItemsNoHow many incidents to collect per run. Default 10

πŸ’° Pricing

Pay per result. No subscription, and no Apify platform usage on top.

Apify planFreeBronzeSilverGoldPlatinumDiamond
Per incident row$0.021$0.0203$0.0197$0.019$0.019$0.019
Rows collectedCost on the Free plan
100$2.10
1,000$21.00
10,000$210.00

Free plan runs return up to 10 rows as a preview. Any paid Apify plan lifts that to 1,000,000 per run.

πŸ”Œ Integrate with any app

The dataset is available through the Apify API as soon as the run finishes. Use run-sync-get-dataset-items for a one-shot call, webhooks to trigger what happens next, or the Make, Zapier, Airbyte and LangChain integrations listed on the Actor page.

πŸ€– Use with an AI agent

Give an agent live access to the incident record over the Model Context Protocol:

$claude mcp add --transport http apify "https://mcp.apify.com?tools=acquistion-automation/seattle-crime-data-scraper"

Then ask it in plain language what was reported in a precinct and have it read the result back.

❓ Frequently asked questions

Why do some rows say REDACTED and have no coordinates? Seattle withholds the location on certain reports, such as those involving sensitive offenses. The Actor returns the record as published, so block_address and reporting_area read REDACTED and the coordinates are null. Most rows carry a block address and a latitude and longitude.

Why do two rows share one report number? One report can list several offenses. Each offense gets its own row and its own offense_id, while report_number stays the same.

How do I look at one address? Filter by precinct or beat, then match on block_address, which is published at block level, or compute distance from latitude and longitude.

What is the NIBRS crime against category? The federal classification of who or what the offense was against: a person, property or society. category in the input filters on it.

Are title, url and imageUrl useful? Not for analysis. title repeats the offense, url repeats sourceUrl, and imageUrl is null on every row. They are kept so the schema stays stable between runs.

What can I export? CSV, Excel, JSON and XML from the run page, or JSON straight from the API.

πŸ”— More from Acquisition Automation Co.

About Acquisition Automation Co.

We build automation for people buying businesses. The repetitive part of an acquisition search, checking listings, pulling public records, tracking owners and assets, is work a machine should do, so the buyer's time goes into judging deals instead of collecting them.

We add new Actors regularly. If there is a source you need and do not see here, tell us.

πŸ†˜ Support

Open an issue in the Issues tab of this Actor with your run ID, the input you used, and what you expected to get back.

⚠️ Disclaimer

This Actor is independent and is not affiliated with, endorsed by, or sponsored by the City of Seattle or the Seattle Police Department. It collects only publicly available data. Police reports describe allegations, not convictions. You are responsible for using that data in compliance with the source's terms of service and applicable law.