San Mateo County And California Crime Rates 2000-2014

Violent and property crime rates per 100,000 population for San Mateo County and the State of California. The total crimes used to calculate the rates for San Mateo County include data from: Sheriff's Department Unincorporated, Atherton, Belmont, Brisbane, Broadmoor, Burlingame, Colma, Daly City, East Palo Alto, Foster City, Half Moon Bay, Hillsborough, Menlo Park, Millbrae, Pacifica, Redwood City, San Bruno, San Carlos, San Mateo, South San Francisco, Bay Area DPR, BART, Union Pacific Railroad, and CA Highway Patrol.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"performance-smcgov/san-mateo-county-and-california-crime-rates-ejv8-n6ca\".\"san_mateo_county_and_california_crime_rates\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.