Dataset Currency Report

Information about the the timeliness of datasets published on the portal as measured by age of most recent data in each dataset compared with Max Expected Data Age. This dataset is populated via FME workflow that checks Socrata dataset currency by having the workflow keep a history of the dataset currency in Data Services data warehouse. A second FME workflow sends that currency data to this Socrata dataset. To remove a dataset from this check, enter 0 as the Max Expected Data Age metadata field for the relevant dataset.

Not included in the check are datasets that have:

a) RETIRED or DUPLICATE in the dataset name

b) 0 for Max Expected Data Age metadata field

c) no Max Expected Data Age value / does not have Date & Time formatted columns

d) no Date/Time formatted columns in the dataset.

e) draft dataset (not published)

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 \"citydata-mesaaz-gov/dataset-currency-report-rdq6-swwe\".\"dataset_currency_report\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.