2022. feb 03.

Exploring public complaint data

írta: dataanalyticsdemo
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.

coyote2.jpg

Szólj hozzá