Example of querying BigQuery's public dataset of SFPD crime incidents

bq-sfpd-query.sql

SELECT 
    unique_key
    , pddistrict AS pd_district
    , DATE(timestamp) AS incident_date
    , category
    , descript AS description
    , dayofweek AS day_of_week
    , resolution
    , UPPER(address) AS address
    , longitude
    , latitude
    , timestamp AS incident_timestamp
    , pdid AS pd_id

FROM 
    `bigquery-public-data.san_francisco.sfpd_incidents` 
ORDER BY
    incident_timestamp DESC
LIMIT 
    1000