Exploring public complaint data
Special focus on the coyotes
Let's see the metadata first
SELECT column_name, data_type, description
FROM
`bigquery-public-data`
.austin_311.
INFORMATION_SCHEMA.COLUMN_FIELD_PATHS
WHERE
table_name="311_service_requests"
Let's see how many years this database encompasses:
Looks like a lot of time.
As the dataset seems to have changed or disappeared from the public database, this is the end of this analysis.