API

Crimespotting data is available to developers and researchers via a simpe web service.

Download complete reports in a spreadsheet.
through in

Reports

Individual crime reports can be downloaded in a variety of formats, suitable for use in spreadsheets, feed readers, and more. All requests are simple HTTP GET, and there is no registration or authentiction requirement.

Example 1

Last ten reports from police beat 4X as tab-separated values suitable for use in a spreadsheet:

http://oakland.crimespotting.org/crime-data?format=tsv&beat=04X&count=10

Case Number	Description	Date, Time	Weekday	Time	Crime Type	Police Beat	Zip Code	Address	Latitude	Longitude	Accuracy	URL
09-029461	BURGLARY-FORCIBLE ENTRY	2009-04-29 03:14:00	Wednesday	03:14	BURGLARY	04X		1600 block of San Pablo Ave, Oakland 94612	37.806998	-122.272088	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-29/Burglary/127020
09-029432	ROBBERY - STRONG ARM (HANDS, FISTS, FEET, ETC.)	2009-04-29 00:15:00	Wednesday	00:15	ROBBERY	04X		1500 block of Madison St, Oakland 94612	37.803343	-122.262971	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-29/Robbery/127017
09-029433	ROBBERY - STRONG ARM (HANDS, FISTS, FEET, ETC.)	2009-04-29 00:00:00	Wednesday	00:00	ROBBERY	04X		1500 block of Madison St, Oakland 94612	37.803343	-122.262971	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-29/Robbery/127014
09-029454	GRAND THEFT	2009-04-28 00:00:00	Tuesday	00:00	THEFT	04X		600 block of 15th St, Oakland 94612	37.806967	-122.275693	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-28/Theft/127033
09-029175	VEHICLE THEFT - AUTO	2009-04-27 15:30:00	Monday	15:30	VEHICLE THEFT	04X		1500 block of Martin Luther King Jr Way, Oakland 94612	37.807417	-122.275233	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-27/Vehicle_Theft/126940
09-029000	BATTERY	2009-04-27 07:12:00	Monday	07:12	SIMPLE ASSAULT	04X		Telegraph Ave & 21st St, Oakland, CA 94612, USA	37.810356	-122.269397	Intersection	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-27/Simple_Assault/126493
09-028850	POSSESS CONTROLLED SUBSTANCE	2009-04-26 13:31:00	Sunday	13:31	NARCOTICS	04X		2200 block of Martin Luther King Jr Way, Oakland 94612	37.812631	-122.272733	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-26/Narcotics/126537
09-028843	THEFT/PETTY THEFT W/PRIOR	2009-04-26 12:30:00	Sunday	12:30	THEFT	04X		1900 block of Broadway, Oakland 94612	37.808606	-122.268495	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-26/Theft/126534
09-028679	BATTERY	2009-04-25 16:10:00	Saturday	16:10	SIMPLE ASSAULT	04X		1400 block of Jefferson St, Oakland 94612	37.806263	-122.27445	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-25/Simple_Assault/126607
09-028551	ATTEMPTED ROBBERY-STRONG-ARM	2009-04-25 12:00:00	Saturday	12:00	ROBBERY	04X		1900 block of Broadway, Oakland 94612	37.808606	-122.268495	Street	http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-25/Robbery/126592

Example 2

Last two theft, robbery, or simple assault reports from downtown Oakland in Atom format suitable for use in a feed reader.

http://oakland.crimespotting.org/crime-data?format=atom&bbox=-122.2777,37.7993,-122.2682,37.8077&type=theft,robbery,simple_assault&count=2

<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:georss="http://www.georss.org/georss" xmlns:local="http://oakland.crimespotting.org/ns">
  <title>Oakland Crime Feed</title>
  <link href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www"/>
  <updated local:date="Wednesday, Apr 29, 2009" local:time="6:30pm">2009-04-29T18:30:00-07:00</updated>
  <entry>
    <title>THEFT</title>
    <link rel="alternate" href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-29/Theft/127204"/>
    <id>crime:oakland/09-029660/THEFT</id>
    <updated local:date="Wednesday, Apr 29, 2009" local:time="6:30pm">2009-04-29T18:30:00-07:00</updated>
    <category term="THEFT" label="Theft"/>
    <georss:point>37.807417 -122.275233</georss:point>
    <content type="html"><![CDATA[<h3>Theft</h3><h4>Wednesday, Apr 29, 2009 6:30pm</h4><p><a href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-29/Theft/127204"><img border="1" src="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-29/Theft/127204.jpg?context=small"/></a></p><p><tt>THEFT</tt> <tt style="white-space: nowrap;">(<a href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-29/Theft/127204">09-029660</a>, beat <a href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/beat/04X">04X</a>)</tt></p><p>1500 block of Martin Luther King Jr Way, Oakland 94612</p>]]></content>
  </entry>
  <entry>
    <title>GRAND THEFT</title>
    <link rel="alternate" href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-28/Theft/127033"/>
    <id>crime:oakland/09-029454/GRANDTHEFT</id>
    <updated local:date="Tuesday, Apr 28, 2009" local:time="12:00am">2009-04-28T00:00:00-07:00</updated>
    <category term="THEFT" label="Theft"/>
    <georss:point>37.806967 -122.275693</georss:point>
    <content type="html"><![CDATA[<h3>Theft</h3><h4>Tuesday, Apr 28, 2009 12:00am</h4><p><a href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-28/Theft/127033"><img border="1" src="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-28/Theft/127033.jpg?context=small"/></a></p><p><tt>GRAND THEFT</tt> <tt style="white-space: nowrap;">(<a href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/crime/2009-04-28/Theft/127033">09-029454</a>, beat <a href="http://oakland.crimespotting.org/~migurski/oaklandcrime/www/beat/04X">04X</a>)</tt></p><p>600 block of 15th St, Oakland 94612</p>]]></content>
  </entry>
</feed>

Arguments

format
Data format to return.
Possible values are:
xml
Raw XML, fast to parse and used by the dynamic map.
csv
Comma-separated values, useful in spreadsheet software.
tsv
Tab-separated values, useful in spreadsheet or database software.
json
GeoJSON, useful with geographic software.
atom
Atom symdication format, useful in feed-reader software such as Bloglines, NetNewsWire, FeedDemon, or Google Reader.
Suggestions for additional formats welcome.
beat
Police beat number.
See the list of beats for a selection of possible values, e.g. 10X.
type
Crime type(s) as comma-separated list.
Possible values include: aggravated_assault, murder, robbery, simple_assault, arson, burglary, theft, vandalism, vehicle_theft, alcohol, disturbing_the_peace, narcotics, prostitution, e.g. vehicle_theft or burglary,theft,vandalism.
Also acceptable are the short versions of each crime type from the key: AA, Mu, Ro, SA, Ar, Bu, Th, Va, VT, Al, DP, Na, Pr, note that these are case-sensitive.
dstart
Start date of included reports.
Must be in YYYY-MM-DD form, e.g. April 20th, 2009 is 2009-04-20.
If dtstart is provided, this is ignored.
Defaults to one week in the past.
dend
End date of included reports.
Must be in YYYY-MM-DD form, e.g. April 30th, 2009 is 2009-04-30.
If dtend is provided, this is ignored.
Defaults to now.
dtstart
Start datetime of included reports.
Must be in YYYY-MM-DDTHH:MM:SSZ (GMT) or YYYY-MM-DDTHH:MM:SS+HHMM form, e.g. April 30th, 2009 8:00am PDT is 2009-04-30T08:00:00-0700.
Overrides dstart if provided.
Defaults to one week in the past.
dtend
End datetime of included reports.
Must be in YYYY-MM-DDTHH:MM:SSZ (GMT) or YYYY-MM-DDTHH:MM:SS+HHMM form, e.g. April 30th, 2009 2:00pm PDT is 2009-04-30T14:00:00-0700.
Overrides dend if provided.
Defaults to now.
bbox
Geographical bounding box of included reports.
Must be in west,south,east,north form, where values are floating point, e.g. downtown Oakland is -122.2777,37.7993,-122.2682,37.8077.
GetLatLon.com can help you figure out specific geographical coordinates.
count
Number of reports to return.
Defaults to 20 if omitted.
offset
Offset in the list of reports to return.
Defaults to 0 if omitted.