ATX

https://dev.socrata.com/docs/functions

Austin Crash Report Data - Crash Level Records
https://datahub.austintexas.gov/id/y2wy-tgr5.json?$order=crash_timestamp%20desc

Austin traffic crashes
https://datahub.austintexas.gov/id/dx9v-zd7x.json

By Year

$select=date_extract_y(crash_timestamp) as year,sum(pedestrian_death_count)
&$group=year
&$where=pedestrian_death_count>0

By year and month:

$select=date*extract_y(crash_timestamp)||'*' ||date_extract_m(crash_timestamp) as year_month,sum(pedestrian_death_count)
&$group=year_month
&$where=pedestrian_death_count>0
&$order=year_month DESC

Austin Crash Victim Profile
https://datahub.austintexas.gov/resource/xecs-rpy9.json?$order=crash_timestamp%20DESC

prsn_injry_sev_id: with 1 indicating an incapacitating or suspected serious injury and 4 indicating a fatal injury
xecs-rpy9:id -> y2wy-tgr5:crash_pk

Austin Projects
https://data.austintexas.gov/resource/ngdb-nm9b.json

2017 Traffic Fatalities
https://data.austintexas.gov/resource/rx3x-btgd.json

Employee turnover rate
https://data.austintexas.gov/resource/ym8w-n945.json

LGBTQIA+ Quality of Life Study
https://data.austintexas.gov/resource/34qp-i76m.json
questions: https://data.austintexas.gov/api/views/34qp-i76m

APD use of force incidents in 2020
https://data.austintexas.gov/resource/n3c7-xtu8.json
https://data.austintexas.gov/resource/n3c7-xtu8.json?$limit=5000&$order=occurred_date%20DESC

APD use of force incidents occurred in 2020 (shows sex, race, and ethnicity)
https://data.austintexas.gov/resource/hira-6bvc.json
&$order=occurred_date DESC

Average age at death in Travis County by ZIP Code, 2011-2015
https://data.austintexas.gov/resource/ci7a-cwah.json

APD Average Response Time by Day and Hour
https://data.austintexas.gov/resource/fsje-8gq2.json
https://data.austintexas.gov/resource/fsje-8gq2.json?&$order=response_datetime%20DESC

DEATH

Male suicide by age group https://data.austintexas.gov/resource/cxhd-bvc3.json?&$select=gender,age_group_in_years,COUNT(record_number)&$group=gender,age_group_in_years&$where=gender=%27MALE%27

APD