Santa Clara County COVID-19 cases

scc-covid.sh

#!/bin/bash

# Prerequisites: curl, jq, termgraph

curl 'https://wabi-us-gov-virginia-api.analysis.usgovcloudapi.net/public/reports/querydata?synchronous=true' \
  --data-raw '{"version":"1.0.0","queries":[{"Query":{"Commands":[{"SemanticQueryDataShapeCommand":{"Query":{"Version":2,"From":[{"Name":"c","Entity":"cases_date","Type":0}],"Select":[{"Column":{"Expression":{"SourceRef":{"Source":"c"}},"Property":"Date"},"Name":"cases_date.Date"},{"Aggregation":{"Expression":{"Column":{"Expression":{"SourceRef":{"Source":"c"}},"Property":"New_cases"}},"Function":0},"Name":"Sum(cases_date.New_cases)"},{"Aggregation":{"Expression":{"Column":{"Expression":{"SourceRef":{"Source":"c"}},"Property":"New_cases_7davg"}},"Function":0},"Name":"Sum(cases_date.New_cases_7davg)"}]},"Binding":{"Primary":{"Groupings":[{"Projections":[0,1,2]}]},"DataReduction":{"DataVolume":4,"Primary":{"Sample":{}}},"Version":1}}}]},"QueryId":""}],"cancelQueries":[],"modelId":344055}' \
  --compressed | jq '.results[0].result.data.dsr.DS[0].PH[0].DM0[].C | (.[0]/1000|todate|"\(.[0:10])"), .[1]' | paste -d "," - - | grep -v null | termgraph