query.sf.data.sh

curl 'https://wabi-us-gov-iowa-api.analysis.usgovcloudapi.net/public/reports/querydata?synchronous=true'  \
 --data-binary \
'{"version":"1.0.0","queries":[{"Query":{"Commands":[{"SemanticQueryDataShapeCommand":{"Query":{"Version":2,"From":[{"Name":"d1","Entity":"Deaths_Comorbidities"}],"Select":[{"Column":{"Expression":{"SourceRef":{"Source":"d1"}},"Property":"comorbidities"},"Name":"Deaths_Comorbidities.comorbidities"},{"Aggregation":{"Expression":{"Column":{"Expression":{"SourceRef":{"Source":"d1"}},"Property":"Total Cases"}},"Function":0},"Name":"Sum(Deaths_Comorbidities.Total Cases)"}],"OrderBy":[{"Direction":1,"Expression":{"Column":{"Expression":{"SourceRef":{"Source":"d1"}},"Property":"comorbidities"}}}]},"Binding":{"Primary":{"Groupings":[{"Projections":[0,1]}]},"DataReduction":{"DataVolume":4,"Primary":{"Window":{"Count":1000}}},"Version":1}}}]},"CacheKey":"{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"d1\",\"Entity\":\"Deaths_Comorbidities\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"d1\"}},\"Property\":\"comorbidities\"},\"Name\":\"Deaths_Comorbidities.comorbidities\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"d1\"}},\"Property\":\"Total Cases\"}},\"Function\":0},\"Name\":\"Sum(Deaths_Comorbidities.Total Cases)\"}],\"OrderBy\":[{\"Direction\":1,\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"d1\"}},\"Property\":\"comorbidities\"}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0,1]}]},\"DataReduction\":{\"DataVolume\":4,\"Primary\":{\"Window\":{\"Count\":1000}}},\"Version\":1}}}]}","QueryId":"","ApplicationContext":{"DatasetId":"67aacd15-103e-455b-bf66-dfaf3171111b","Sources":[{"ReportId":"5d146273-cd1f-4175-b52c-d19fc932672c"}]}}],"cancelQueries":[],"modelId":276387}' \
--compressed