Skip to content

Instantly share code, notes, and snippets.

@jalbertbowden

jalbertbowden/nevada-facilities-bi.json

Created November 20, 2020 07:06
Show Gist options
  • Save jalbertbowden/e740add6600ebe0f4cd4aab320de0501 to your computer and use it in GitHub Desktop.
Save jalbertbowden/e740add6600ebe0f4cd4aab320de0501 to your computer and use it in GitHub Desktop.
Download ZIP
Nevada Facilities with Reported COVID-19 Cases Power BI Dashboard CURL export
Raw
nevada-facilities-bi.json
{
"models": [
{
"id": 274097,
"vsName": "sobe_wowvirtualserver",
"dbName": "10a1e28c-bfcb-4358-bb18-0cb39b08a031",
"currentRefreshStartingTime": "",
"refreshSchedule": {
"importAndRefreshBehavior": 0,
"executionTime": null,
"localTimeZoneId": "UTC",
"refreshEnabled": false,
"isDaily": false,
"isRefreshable": false,
"numberOfTimeIntervals": 4,
"refreshNotificationEnabled": true,
"forceQueryRefreshEnabled": false,
"forceModelRefreshEnabled": false,
"refreshDisabledReason": 0
},
"nextRefreshTime": "/Date(1605875279000)/",
"NextRefreshTime": "2020-11-20T12:27:59",
"LastRefreshTime": "2020-11-19T19:22:35.717",
"nextRefreshTimeUtc": "2020-11-20T12:27:59Z",
"lastRefreshTime": "/Date(1605813755717)/",
"lastTimeAModelChangeWasDetectedInTheCluster": "",
"lastRefreshStatus": 0,
"permissions": 15,
"creatorUserId": 42327,
"directQueryMode": false,
"sizeInMBs": 2,
"qnaSupported": true,
"insightsSupported": true,
"name": "PowerBICompanionModelResource",
"displayName": "COVID-19 Facilities Dashboard",
"packageId": 277459,
"packageVersion": "ID-3458215",
"isRefreshedByContentProvider": false,
"isHidden": false,
"modelProperties": 4,
"modelFeatures": 0,
"features": 0,
"isOnPremisesGatewayOverride": false,
"lastNLResourceGenerationTime": "/Date(1605730051507)/",
"contentProviderId": 7,
"lastNLResourceUpdateStatus": 0,
"nlResourceGenerationFailureCount": 0,
"isPackageRefreshEnabled": false,
"featuresV2": [
0,
64,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sharedFromNonEnterpriseCapacity": true,
"isInEnterpriseCapacity": false,
"capacityId": null,
"capacityObjectId": null,
"cachedModelEnabled": true,
"dataCacheMode": 0,
"datasourceFormat": 1
}
],
"exploration": {
"id": 506714,
"sections": [
{
"id": 2648486,
"visualContainers": [
{
"id": 63029496,
"x": 10.76,
"y": 16.74,
"z": 0.0,
"width": 757.07,
"height": 89.7,
"config": "{\"name\":\"d443f783e9589ece54e1\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.764119601328904,\"y\":16.744186046511626,\"z\":0,\"width\":757.0764119601329,\"height\":89.70099667774086,\"tabOrder\":19000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Facilities with Reported COVID-19 Cases\",\"textStyle\":{\"fontWeight\":\"bold\",\"fontSize\":\"28pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Data were last updated on 11/19/2020 at 11:15 am.\",\"textStyle\":{\"fontSize\":\"9pt\"}},{\"value\":\" \"}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029497,
"x": 10.98,
"y": 199.14,
"z": 1000.0,
"width": 339.22,
"height": 71.41,
"config": "{\"name\":\"c3545d9736e3f455f36d\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.987124463519313,\"y\":199.14163090128756,\"z\":1000,\"width\":339.22746781115876,\"height\":71.41630901287553,\"tabOrder\":17000}}],\"singleVisual\":{\"visualType\":\"slicer\",\"projections\":{\"Values\":[{\"queryRef\":\"Sheet1.Facility_Type\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility_Type\"},\"Name\":\"Sheet1.Facility_Type\"}]},\"syncGroup\":{\"groupName\":\"Facility \",\"fieldChanges\":true,\"filterChanges\":true},\"drillFilterOtherVisuals\":true,\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Dropdown'\"}}}}}],\"header\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"selection\":[{\"properties\":{\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"items\":[{\"properties\":{\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":1,\"Percent\":0}}}}}}}],\"general\":[{\"properties\":{}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#a3b1be'\"}}}}}}}],\"title\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Facility Type'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Drop down box to select one or more facility types.'\"}}}}}]}}}",
"filters": "[{\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility type\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}]]}}}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"isHiddenInViewMode\":false}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility_Type\"},\"Name\":\"Sheet1.Facility_Type\"}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}]]}}}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Window\":{}}},\"IncludeEmptyGroups\":true,\"Version\":1}}}]}",
"queryHash": -4905617978697074961,
"dataTransforms": "{\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Dropdown'\"}}}}}],\"header\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"selection\":[{\"properties\":{\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"items\":[{\"properties\":{\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":1,\"Percent\":0}}}}}}}],\"general\":[{\"properties\":{}}]},\"projectionOrdering\":{\"Values\":[0]},\"projectionActiveItems\":{\"Values\":[{\"queryRef\":\"Sheet1.Facility_Type\",\"suppressConcat\":false}]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Facility_Type\",\"Name\":\"Sheet1.Facility_Type\",\"Type\":2048}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility type\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":true}]}],\"selects\":[{\"displayName\":\"Facility_Type\",\"queryName\":\"Sheet1.Facility_Type\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":1},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility_Type\"}}}]}"
},
{
"id": 63029498,
"x": 668.57,
"y": 206.91,
"z": 2000.0,
"width": 596.81,
"height": 235.61,
"config": "{\"name\":\"5d131af43a75575fe843\",\"layouts\":[{\"id\":0,\"position\":{\"x\":668.5714285714286,\"y\":206.91029900332225,\"z\":2000,\"width\":596.8106312292358,\"height\":235.61461794019934,\"tabOrder\":4000}}],\"singleVisual\":{\"visualType\":\"clusteredColumnChart\",\"projections\":{\"Y\":[{\"queryRef\":\"CountNonNull(Sheet1.Facility type)\"}],\"Category\":[{\"queryRef\":\"Sheet1.Facility_Type\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}},\"Function\":5},\"Name\":\"CountNonNull(Sheet1.Facility type)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility_Type\"},\"Name\":\"Sheet1.Facility_Type\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}},\"Function\":5}}}]},\"columnProperties\":{\"CountNonNull(Sheet1.Facility type)\":{\"displayName\":\"Count\"},\"Sheet1.Facility_Type\":{\"displayName\":\"Facility Type\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"valueAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"titleColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Facility Types'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Graph with the total number of facilities with confirmed COVID-19 cases per facility type.'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}},\"Function\":5},\"Name\":\"CountNonNull(Sheet1.Facility type)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility_Type\"},\"Name\":\"Sheet1.Facility_Type\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}},\"Function\":5}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0,1]}]},\"DataReduction\":{\"DataVolume\":4,\"Primary\":{\"Window\":{\"Count\":1000}}},\"Version\":1}}}]}",
"queryHash": -5702529083559365286,
"dataTransforms": "{\"objects\":{\"valueAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"titleColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]},\"projectionOrdering\":{\"Y\":[0],\"Category\":[1]},\"projectionActiveItems\":{\"Category\":[{\"queryRef\":\"Sheet1.Facility_Type\",\"suppressConcat\":false}]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Count\",\"Name\":\"CountNonNull(Sheet1.Facility type)\",\"Type\":3},{\"Restatement\":\"Facility Type\",\"Name\":\"Sheet1.Facility_Type\",\"Type\":2048}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Y\",\"Projection\":0,\"isActive\":false},{\"Name\":\"Category\",\"Projection\":1,\"isActive\":true}]}],\"selects\":[{\"displayName\":\"Count\",\"queryName\":\"CountNonNull(Sheet1.Facility type)\",\"roles\":{\"Y\":true},\"sort\":2,\"sortOrder\":0,\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility type\"}},\"Function\":5}}},{\"displayName\":\"Facility Type\",\"queryName\":\"Sheet1.Facility_Type\",\"roles\":{\"Category\":true},\"type\":{\"category\":null,\"underlyingType\":1},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility_Type\"}}}]}"
},
{
"id": 63029499,
"x": 668.84,
"y": 455.96,
"z": 3000.0,
"width": 596.05,
"height": 252.7,
"config": "{\"name\":\"e5fdd2698e65850212d9\",\"layouts\":[{\"id\":0,\"position\":{\"x\":668.8412017167382,\"y\":455.9656652360515,\"z\":3000,\"width\":596.0515021459228,\"height\":252.7038626609442,\"tabOrder\":0}}],\"singleVisual\":{\"visualType\":\"pieChart\",\"projections\":{\"Y\":[{\"queryRef\":\"CountNonNull(Sheet1.County)\"}],\"Category\":[{\"queryRef\":\"Sheet1.Facility County\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"County\"}},\"Function\":5},\"Name\":\"CountNonNull(Sheet1.County)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility County\"},\"Name\":\"Sheet1.Facility County\"}],\"OrderBy\":[{\"Direction\":1,\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility County\"}}}]},\"columnProperties\":{\"CountNonNull(Sheet1.County)\":{\"displayName\":\"Count\"}},\"drillFilterOtherVisuals\":true,\"objects\":{\"labels\":[{\"properties\":{\"labelStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'Data'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'preferOutside'\"}}},\"overflow\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"legend\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'BottomCenter'\"}}}}}],\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":4,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Clark'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":9,\"Percent\":-0.25}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Nye'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":8,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Carson City'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":4,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Clark'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#118DFF'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Washoe'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":8,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Carson City'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#12239E'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Lander'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":9,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'White Pine'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":5,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Humboldt'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":6,\"Percent\":0.2}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Elko'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#2bffee'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Pershing'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":4,\"Percent\":-0.5}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Nye'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":7,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Lyon'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff121c'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Churchill'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#0dff00'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Lincoln'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":-0.3}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Douglas'\"}}}}}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'County'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"County\"}},\"Function\":5},\"Name\":\"CountNonNull(Sheet1.County)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility County\"},\"Name\":\"Sheet1.Facility County\"}],\"OrderBy\":[{\"Direction\":1,\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility County\"}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0,1]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": -4210221720935686258,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"labelStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'Data'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'preferOutside'\"}}},\"overflow\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"legend\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'BottomCenter'\"}}}}}],\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":4,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Clark'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":9,\"Percent\":-0.25}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Nye'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":8,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Carson City'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":4,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Clark'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#118DFF'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Washoe'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":8,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Carson City'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#12239E'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Lander'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":9,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'White Pine'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":5,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Humboldt'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":6,\"Percent\":0.2}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Elko'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#2bffee'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Pershing'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":4,\"Percent\":-0.5}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Nye'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":7,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Lyon'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#ff121c'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Churchill'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#0dff00'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Lincoln'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":-0.3}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}},\"Right\":{\"Literal\":{\"Value\":\"'Douglas'\"}}}}}]}}]},\"projectionOrdering\":{\"Y\":[0],\"Category\":[1]},\"projectionActiveItems\":{\"Category\":[{\"queryRef\":\"Sheet1.Facility County\",\"suppressConcat\":false}]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Count\",\"Name\":\"CountNonNull(Sheet1.County)\",\"Type\":3},{\"Restatement\":\"Facility County\",\"Name\":\"Sheet1.Facility County\",\"Type\":2048}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Y\",\"Projection\":0,\"isActive\":false},{\"Name\":\"Category\",\"Projection\":1,\"isActive\":true}]}],\"selects\":[{\"displayName\":\"Count\",\"queryName\":\"CountNonNull(Sheet1.County)\",\"roles\":{\"Y\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"County\"}},\"Function\":5}}},{\"displayName\":\"Facility County\",\"queryName\":\"Sheet1.Facility County\",\"roles\":{\"Category\":true},\"sort\":1,\"sortOrder\":0,\"type\":{\"category\":null,\"underlyingType\":1},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}}}]}"
},
{
"id": 63029500,
"x": 365.98,
"y": 206.91,
"z": 4000.0,
"width": 289.43,
"height": 235.61,
"config": "{\"name\":\"9bc70cb7215b94e81249\",\"layouts\":[{\"id\":0,\"position\":{\"x\":365.98006644518273,\"y\":206.91029900332225,\"z\":4000,\"width\":289.43521594684387,\"height\":235.61461794019934,\"tabOrder\":5000}}],\"singleVisual\":{\"visualType\":\"clusteredColumnChart\",\"projections\":{\"Y\":[{\"queryRef\":\"Sum(Sheet1.Count of residents COVID+)\"},{\"queryRef\":\"Sum(Sheet1.Count of staff COVID+)\"},{\"queryRef\":\"CountNonNull(Sheet1.Count of Imported)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of residents COVID+\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Count of residents COVID+)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of staff COVID+\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Count of staff COVID+)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of Imported\"}},\"Function\":0},\"Name\":\"CountNonNull(Sheet1.Count of Imported)\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of residents COVID+\"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet1.Count of residents COVID+)\":{\"displayName\":\"Residents/Patients\"},\"Sum(Sheet1.Count of staff COVID+)\":{\"displayName\":\"Staff\"},\"CountNonNull(Sheet1.Count of Imported)\":{\"displayName\":\"Imported\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}}}}],\"valueAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}}}}],\"categoryAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"innerPadding\":{\"expr\":{\"Literal\":{\"Value\":\"0L\"}}},\"preferredCategoryWidth\":{\"expr\":{\"Literal\":{\"Value\":\"180D\"}}},\"maxMarginFactor\":{\"expr\":{\"Literal\":{\"Value\":\"32L\"}}}}}],\"legend\":[{\"properties\":{\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'BottomCenter'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Confirmed COVID-19 Cases'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Graph with the total number of confirmed COVID-19 cases, broken down by resident and staff.'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of residents COVID+\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Count of residents COVID+)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of staff COVID+\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Count of staff COVID+)\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of Imported\"}},\"Function\":0},\"Name\":\"CountNonNull(Sheet1.Count of Imported)\"}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0,1,2]}]},\"Version\":1}}}]}",
"queryHash": -7344272782357427877,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}}}}],\"valueAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}},\"labelDisplayUnits\":{\"expr\":{\"Literal\":{\"Value\":\"1D\"}}}}}],\"categoryAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"innerPadding\":{\"expr\":{\"Literal\":{\"Value\":\"0L\"}}},\"preferredCategoryWidth\":{\"expr\":{\"Literal\":{\"Value\":\"180D\"}}},\"maxMarginFactor\":{\"expr\":{\"Literal\":{\"Value\":\"32L\"}}}}}],\"legend\":[{\"properties\":{\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'BottomCenter'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Y\":[0,1,2]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Residents/Patients\",\"Name\":\"Sum(Sheet1.Count of residents COVID+)\",\"Type\":3,\"Format\":\"#,0\"},{\"Restatement\":\"Staff\",\"Name\":\"Sum(Sheet1.Count of staff COVID+)\",\"Type\":3,\"Format\":\"#,0\"},{\"Restatement\":\"Imported\",\"Name\":\"CountNonNull(Sheet1.Count of Imported)\",\"Type\":3,\"Format\":\"0\"}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Y\",\"Projection\":0,\"isActive\":false},{\"Name\":\"Y\",\"Projection\":1,\"isActive\":false},{\"Name\":\"Y\",\"Projection\":2,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Residents/Patients\",\"format\":\"#,0\",\"queryName\":\"Sum(Sheet1.Count of residents COVID+)\",\"roles\":{\"Y\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Count of residents COVID+\"}},\"Function\":0}}},{\"displayName\":\"Staff\",\"format\":\"#,0\",\"queryName\":\"Sum(Sheet1.Count of staff COVID+)\",\"roles\":{\"Y\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Count of staff COVID+\"}},\"Function\":0}}},{\"displayName\":\"Imported\",\"format\":\"0\",\"queryName\":\"CountNonNull(Sheet1.Count of Imported)\",\"roles\":{\"Y\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Count of Imported\"}},\"Function\":0}}}]}"
},
{
"id": 63029501,
"x": 10.98,
"y": 359.82,
"z": 5000.0,
"width": 339.22,
"height": 126.35,
"config": "{\"name\":\"c0e99882293ec36a1b3c\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.987124463519313,\"y\":359.8283261802575,\"z\":5000,\"width\":339.22746781115876,\"height\":126.3519313304721,\"tabOrder\":10000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet1.Count of confirmed COVID+)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of confirmed COVID+\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Count of confirmed COVID+)\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of active cases\"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet1.Count of confirmed COVID+)\":{\"displayName\":\"Unique Confirmed Cases\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Active Cases'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Total number of confirmed COVID-19 cases.'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Count of confirmed COVID+\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Count of confirmed COVID+)\"}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": -2729015571801517127,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Unique Confirmed Cases\",\"Name\":\"Sum(Sheet1.Count of confirmed COVID+)\",\"Type\":3,\"Format\":\"#,0\"}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Unique Confirmed Cases\",\"format\":\"#,0\",\"queryName\":\"Sum(Sheet1.Count of confirmed COVID+)\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Count of confirmed COVID+\"}},\"Function\":0}}}]}"
},
{
"id": 63029502,
"x": 10.76,
"y": 582.45,
"z": 14000.0,
"width": 181.79,
"height": 126.77,
"config": "{\"name\":\"618dd5aaa8cc988c05be\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.764119601328904,\"y\":582.4584717607974,\"z\":14000,\"width\":181.7940199335548,\"height\":126.77740863787375,\"tabOrder\":7000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet1.Sum of COVID+ deaths among residents)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Sum of COVID+ deaths among residents\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Sum of COVID+ deaths among residents)\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Sum of COVID+ deaths among residents\"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet1.Sum of COVID+ deaths among residents)\":{\"displayName\":\"Residents/Patients\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Active Cases'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Total number of COVID-19 resident deaths.'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Sum of COVID+ deaths among residents\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Sum of COVID+ deaths among residents)\"}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": -3029539408806621727,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Residents/Patients\",\"Name\":\"Sum(Sheet1.Sum of COVID+ deaths among residents)\",\"Type\":3,\"Format\":\"0\"}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Residents/Patients\",\"format\":\"0\",\"queryName\":\"Sum(Sheet1.Sum of COVID+ deaths among residents)\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Sum of COVID+ deaths among residents\"}},\"Function\":0}}}]}"
},
{
"id": 63029503,
"x": 365.98,
"y": 455.68,
"z": 13000.0,
"width": 148.3,
"height": 253.55,
"config": "{\"name\":\"3bf7c84aa7c0a7da3529\",\"layouts\":[{\"id\":0,\"position\":{\"x\":365.98006644518273,\"y\":455.68106312292355,\"z\":13000,\"width\":148.30564784053155,\"height\":253.5548172757475,\"tabOrder\":2000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sheet1.Final_Res_Attack\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Final_Res_Attack\"},\"Name\":\"Sheet1.Final_Res_Attack\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Final_Res_Attack\"}}}]},\"columnProperties\":{\"Sum(Sheet1.Attack rate of COVID on residents)\":{\"displayName\":\"Residents\"},\"Sum(Sheet1.Attack rate of COVID on staff)\":{\"displayName\":\"Staff\"},\"Sheet1.Final_Res_Attack\":{\"displayName\":\"Residents/Patients\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'28'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Average Attack Rate of COVID-19'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Attack rate of COVID-19 for residents.'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Final_Res_Attack\"},\"Name\":\"Sheet1.Final_Res_Attack\"}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": -695191411139833455,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'28'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Residents/Patients\",\"Name\":\"Sheet1.Final_Res_Attack\",\"Type\":1,\"Format\":\"0.00%;-0.00%;0.00%\"}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Residents/Patients\",\"format\":\"0.00%;-0.00%;0.00%\",\"queryName\":\"Sheet1.Final_Res_Attack\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":259},\"expr\":{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Final_Res_Attack\"}}}]}"
},
{
"id": 63029504,
"x": 507.1,
"y": 455.68,
"z": 6000.0,
"width": 148.3,
"height": 253.55,
"config": "{\"name\":\"e91add6d42267d5c9dc3\",\"layouts\":[{\"id\":0,\"position\":{\"x\":507.109634551495,\"y\":455.68106312292355,\"z\":6000,\"width\":148.30564784053155,\"height\":253.5548172757475,\"tabOrder\":1000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sheet1.Final_Staff_Attack\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Final_Staff_Attack\"},\"Name\":\"Sheet1.Final_Staff_Attack\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Final_Staff_Attack\"}}}]},\"columnProperties\":{\"Sum(Sheet1.Attack rate of COVID on residents)\":{\"displayName\":\"Residents\"},\"Sheet1.Final_Staff_Attack\":{\"displayName\":\"Staff\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'28'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Average Attack Rate of COVID-19'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Attack rate of COVID-19 for staff.'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Final_Staff_Attack\"},\"Name\":\"Sheet1.Final_Staff_Attack\"}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": -1143010872174395215,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'28'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Staff\",\"Name\":\"Sheet1.Final_Staff_Attack\",\"Type\":1,\"Format\":\"0.00%;-0.00%;0.00%\"}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Staff\",\"format\":\"0.00%;-0.00%;0.00%\",\"queryName\":\"Sheet1.Final_Staff_Attack\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":259},\"expr\":{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Final_Staff_Attack\"}}}]}"
},
{
"id": 63029505,
"x": 365.98,
"y": 461.66,
"z": 16000.0,
"width": 289.43,
"height": 47.84,
"config": "{\"name\":\"deda2d3dcc11a7cba266\",\"layouts\":[{\"id\":0,\"position\":{\"x\":365.98006644518273,\"y\":461.6611295681063,\"z\":16000,\"width\":289.43521594684387,\"height\":47.840531561461795,\"tabOrder\":3000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Attack Rates of COVID-19\",\"textStyle\":{\"fontSize\":\"16pt\",\"color\":\"#ffffff\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029506,
"x": 748.49,
"y": 2.43,
"z": 7000.0,
"width": 199.92,
"height": 119.46,
"config": "{\"name\":\"bca5fa2d1a86cd454113\",\"layouts\":[{\"id\":0,\"position\":{\"x\":748.495238095238,\"y\":2.4380952380952383,\"z\":7000,\"width\":199.92380952380952,\"height\":119.46666666666667,\"tabOrder\":-9998000}}],\"singleVisual\":{\"visualType\":\"image\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"imageUrl\":{\"expr\":{\"ResourcePackageItem\":{\"PackageName\":\"RegisteredResources\",\"PackageType\":1,\"ItemName\":\"Seal_221416845334902135.PNG\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029507,
"x": 926.47,
"y": 17.06,
"z": 8000.0,
"width": 198.7,
"height": 90.2,
"config": "{\"name\":\"a063b0956ab23ef780cc\",\"layouts\":[{\"id\":0,\"position\":{\"x\":926.4761904761905,\"y\":17.066666666666666,\"z\":8000,\"width\":198.7047619047619,\"height\":90.20952380952382,\"tabOrder\":-9999000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"State of Nevada \",\"textStyle\":{\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Department of Health and \",\"textStyle\":{\"fontWeight\":\"bold\",\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Human Services\",\"textStyle\":{\"fontWeight\":\"bold\",\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Office of Analytics\",\"textStyle\":{\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#c8c8c8'\"}}}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029508,
"x": 1097.14,
"y": 1.21,
"z": 9000.0,
"width": 182.85,
"height": 119.46,
"config": "{\"name\":\"b8a6aedc42b31813b376\",\"layouts\":[{\"id\":0,\"position\":{\"x\":1097.142857142857,\"y\":1.2190476190476192,\"z\":9000,\"width\":182.85714285714286,\"height\":119.46666666666667,\"tabOrder\":-9997000}}],\"singleVisual\":{\"visualType\":\"image\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"imageUrl\":{\"expr\":{\"ResourcePackageItem\":{\"PackageName\":\"RegisteredResources\",\"PackageType\":1,\"ItemName\":\"Logo560168588277643.PNG\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029509,
"x": 10.98,
"y": 122.23,
"z": 10000.0,
"width": 339.22,
"height": 64.54,
"config": "{\"name\":\"7f4fe33ff318540547dc\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.987124463519313,\"y\":122.23175965665236,\"z\":10000,\"width\":339.22746781115876,\"height\":64.54935622317596,\"tabOrder\":18000}}],\"singleVisual\":{\"visualType\":\"slicer\",\"projections\":{\"Values\":[{\"queryRef\":\"Sheet1.Facility Name\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Name\"},\"Name\":\"Sheet1.Facility Name\"}]},\"drillFilterOtherVisuals\":true,\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Dropdown'\"}}}}}],\"header\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"selection\":[{\"properties\":{\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"items\":[{\"properties\":{\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":1,\"Percent\":0}}}}}}}],\"general\":[{\"properties\":{}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#a3b1be'\"}}}}}}}],\"title\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Facility Name'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Drop down box to select one or more facilities.'\"}}}}}]}}}",
"filters": "[{\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility \"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility \"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}]]}}}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"isHiddenInViewMode\":false}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Name\"},\"Name\":\"Sheet1.Facility Name\"}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility \"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}]]}}}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Window\":{}}},\"IncludeEmptyGroups\":true,\"Version\":1}}}]}",
"queryHash": 5262228804119334537,
"dataTransforms": "{\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Dropdown'\"}}}}}],\"header\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"selection\":[{\"properties\":{\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"items\":[{\"properties\":{\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":1,\"Percent\":0}}}}}}}],\"general\":[{\"properties\":{}}]},\"projectionOrdering\":{\"Values\":[0]},\"projectionActiveItems\":{\"Values\":[{\"queryRef\":\"Sheet1.Facility Name\",\"suppressConcat\":false}]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Facility Name\",\"Name\":\"Sheet1.Facility Name\",\"Type\":2048}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility \"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":true}]}],\"selects\":[{\"displayName\":\"Facility Name\",\"queryName\":\"Sheet1.Facility Name\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":1},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility Name\"}}}]}"
},
{
"id": 63029510,
"x": 168.92,
"y": 582.31,
"z": 11000.0,
"width": 181.28,
"height": 126.35,
"config": "{\"name\":\"2dbbc2cff00ed9dfed2d\",\"layouts\":[{\"id\":0,\"position\":{\"x\":168.92703862660943,\"y\":582.3175965665235,\"z\":11000,\"width\":181.28755364806867,\"height\":126.3519313304721,\"tabOrder\":6000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet1.Sum of COVID+ deaths among staff)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Sum of COVID+ deaths among staff\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Sum of COVID+ deaths among staff)\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Sum of COVID+ deaths among residents\"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet1.Sum of COVID+ deaths among staff)\":{\"displayName\":\"Staff\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Active Cases'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Total number of COVID-19 staff deaths.'\"}}}}}]}}}",
"filters": "[]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Sum of COVID+ deaths among staff\"}},\"Function\":0},\"Name\":\"Sum(Sheet1.Sum of COVID+ deaths among staff)\"}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": 3354450587185768465,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Staff\",\"Name\":\"Sum(Sheet1.Sum of COVID+ deaths among staff)\",\"Type\":3,\"Format\":\"0\"}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Staff\",\"format\":\"0\",\"queryName\":\"Sum(Sheet1.Sum of COVID+ deaths among staff)\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Sum of COVID+ deaths among staff\"}},\"Function\":0}}}]}"
},
{
"id": 63029511,
"x": 10.98,
"y": 582.31,
"z": 15000.0,
"width": 339.22,
"height": 43.94,
"config": "{\"name\":\"5135c5d2ce82baa70432\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.987124463519313,\"y\":582.3175965665235,\"z\":15000,\"width\":339.22746781115876,\"height\":43.94849785407725,\"tabOrder\":8000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Deaths\",\"textStyle\":{\"fontSize\":\"18pt\",\"color\":\"#ffffff\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029512,
"x": 10.98,
"y": 477.93,
"z": 12000.0,
"width": 181.28,
"height": 116.73,
"config": "{\"name\":\"2c00bc0dd4e12ce5630b\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.987124463519313,\"y\":477.9399141630901,\"z\":12000,\"width\":181.28755364806867,\"height\":116.7381974248927,\"tabOrder\":9000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"CountNonNull(Sheet1.Resident Recoveries)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Resident Recoveries\"}},\"Function\":0},\"Name\":\"CountNonNull(Sheet1.Resident Recoveries)\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Resident Recoveries\"}},\"Function\":0}}}]},\"columnProperties\":{\"CountNonNull(Sheet1.Resident Recoveries)\":{\"displayName\":\"Residents/Patients\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Active Cases'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Total number of recovered COVID-19 cases.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filterd4014c6c3a10f0d2f95f\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Resident'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0},{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Resident Recoveries\"}},\"Function\":0},\"Name\":\"CountNonNull(Sheet1.Resident Recoveries)\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Resident'\"}}]]}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": 1396889451157573734,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Residents/Patients\",\"Name\":\"CountNonNull(Sheet1.Resident Recoveries)\",\"Type\":3,\"Format\":\"#,0\"}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Residents/Patients\",\"format\":\"#,0\",\"queryName\":\"CountNonNull(Sheet1.Resident Recoveries)\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Resident Recoveries\"}},\"Function\":0}}}]}"
},
{
"id": 63029513,
"x": 477.2,
"y": 121.99,
"z": 22000.0,
"width": 162.65,
"height": 76.54,
"config": "{\"name\":\"5716c04bbb884303a89b\",\"layouts\":[{\"id\":0,\"position\":{\"x\":477.2093023255814,\"y\":121.99335548172758,\"z\":22000,\"width\":162.6578073089701,\"height\":76.54485049833887,\"tabOrder\":15000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet3 (2).Total Facilities )\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet3 (2).Total Facilities )\":{\"displayName\":\"Assisted Living\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'There are 382 assisted living facilities in Nevada.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filter\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Assisted living'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Assisted living'\"}}]]}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": 3999031784985166846,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Assisted Living\",\"Name\":\"Sum(Sheet3 (2).Total Facilities )\",\"Type\":3,\"Format\":\"0\"}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Assisted Living\",\"format\":\"0\",\"queryName\":\"Sum(Sheet3 (2).Total Facilities )\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]}"
},
{
"id": 63029514,
"x": 621.92,
"y": 122.0,
"z": 17000.0,
"width": 181.79,
"height": 77.0,
"config": "{\"name\":\"6bb009bbce03b9980208\",\"layouts\":[{\"id\":0,\"position\":{\"x\":621.9269102990033,\"y\":122,\"z\":17000,\"width\":181.7940199335548,\"height\":77,\"tabOrder\":14000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet3 (2).Total Facilities )\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet3 (2).Total Facilities )\":{\"displayName\":\"Behavioral Inpatient\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'There are 183 behavioral inpatient facilities in Nevada.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filter\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Behavioral inpatient'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Behavioral inpatient'\"}}]]}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": -4066840998641677878,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Behavioral Inpatient\",\"Name\":\"Sum(Sheet3 (2).Total Facilities )\",\"Type\":3,\"Format\":\"0\"}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Behavioral Inpatient\",\"format\":\"0\",\"queryName\":\"Sum(Sheet3 (2).Total Facilities )\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]}"
},
{
"id": 63029515,
"x": 791.76,
"y": 122.0,
"z": 18000.0,
"width": 156.67,
"height": 77.0,
"config": "{\"name\":\"4c24c467b101af51f6a2\",\"layouts\":[{\"id\":0,\"position\":{\"x\":791.7607973421926,\"y\":122,\"z\":18000,\"width\":156.67774086378736,\"height\":77,\"tabOrder\":13000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet3 (2).Total Facilities )\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet3 (2).Total Facilities )\":{\"displayName\":\"Childcare\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'There are 443 childcare facilities in Nevada.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filter\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Childcare'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Childcare'\"}}]]}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": 6805365687275212634,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Childcare\",\"Name\":\"Sum(Sheet3 (2).Total Facilities )\",\"Type\":3,\"Format\":\"0\"}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Childcare\",\"format\":\"0\",\"queryName\":\"Sum(Sheet3 (2).Total Facilities )\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]}"
},
{
"id": 63029516,
"x": 926.91,
"y": 122.0,
"z": 19000.0,
"width": 179.4,
"height": 77.0,
"config": "{\"name\":\"dc195a92f29fc002e417\",\"layouts\":[{\"id\":0,\"position\":{\"x\":926.9102990033223,\"y\":122,\"z\":19000,\"width\":179.40199335548172,\"height\":77,\"tabOrder\":12000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet3 (2).Total Facilities )\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet3 (2).Total Facilities )\":{\"displayName\":\"Correctional\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'There are 22 correctional facilities in Nevada.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filter\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Correctional'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Correctional'\"}}]]}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": 940787160308937270,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Correctional\",\"Name\":\"Sum(Sheet3 (2).Total Facilities )\",\"Type\":3,\"Format\":\"0\"}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Correctional\",\"format\":\"0\",\"queryName\":\"Sum(Sheet3 (2).Total Facilities )\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]}"
},
{
"id": 63029517,
"x": 1096.16,
"y": 122.1,
"z": 20000.0,
"width": 168.74,
"height": 77.0,
"config": "{\"name\":\"94230c4336b520e19561\",\"layouts\":[{\"id\":0,\"position\":{\"x\":1096.1629153269025,\"y\":122.10075026795285,\"z\":20000,\"width\":168.74598070739552,\"height\":77,\"tabOrder\":11000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"Sum(Sheet3 (2).Total Facilities )\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]},\"columnProperties\":{\"Sum(Sheet3 (2).Total Facilities )\":{\"displayName\":\"Skilled Nursing\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'There are 64 skilled nursing facilities in Nevada.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filter\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Skilled nursing'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet3 (2)\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Total Facilities \"}},\"Function\":0},\"Name\":\"Sum(Sheet3 (2).Total Facilities )\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility Type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Skilled nursing'\"}}]]}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": -5044782781767686745,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'20'\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Skilled Nursing\",\"Name\":\"Sum(Sheet3 (2).Total Facilities )\",\"Type\":3,\"Format\":\"0\"}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Facility Type\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Skilled Nursing\",\"format\":\"0\",\"queryName\":\"Sum(Sheet3 (2).Total Facilities )\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet3 (2)\"}},\"Property\":\"Total Facilities \"}},\"Function\":0}}}]}"
},
{
"id": 63029518,
"x": 365.98,
"y": 121.99,
"z": 21000.0,
"width": 119.6,
"height": 77.0,
"config": "{\"name\":\"950d38d1b6194fecca78\",\"layouts\":[{\"id\":0,\"position\":{\"x\":365.98006644518273,\"y\":121.99335548172758,\"z\":21000,\"width\":119.60132890365448,\"height\":77,\"tabOrder\":16000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Total Licensed Facilities in Nevada\",\"textStyle\":{\"fontSize\":\"12pt\",\"color\":\"#ffffff\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029519,
"x": 168.92,
"y": 477.93,
"z": 23000.0,
"width": 181.28,
"height": 115.36,
"config": "{\"name\":\"fe487c7d3194dbb8c4d1\",\"layouts\":[{\"id\":0,\"position\":{\"x\":168.92703862660943,\"y\":477.9399141630901,\"z\":23000,\"width\":181.28755364806867,\"height\":115.36480686695279,\"tabOrder\":20000}}],\"singleVisual\":{\"visualType\":\"card\",\"projections\":{\"Values\":[{\"queryRef\":\"CountNonNull(Sheet1.Staff Recoveries)\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Staff Recoveries\"}},\"Function\":0},\"Name\":\"CountNonNull(Sheet1.Staff Recoveries)\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Staff Recoveries\"}},\"Function\":0}}}]},\"columnProperties\":{\"CountNonNull(Sheet1.Staff Recoveries)\":{\"displayName\":\"Staff\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Active Cases'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Total number of recovered COVID-19 cases.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filterd4014c6c3a10f0d2f95f\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Staff'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"objects\":{}}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0},{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Staff Recoveries\"}},\"Function\":0},\"Name\":\"CountNonNull(Sheet1.Staff Recoveries)\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Staff'\"}}]]}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Top\":{}}},\"Version\":1}}}]}",
"queryHash": 7556324506353278324,
"dataTransforms": "{\"objects\":{\"labels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#FFF'\"}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'40'\"}}}}}],\"categoryLabels\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Values\":[0]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Staff\",\"Name\":\"CountNonNull(Sheet1.Staff Recoveries)\",\"Type\":3,\"Format\":\"#,0\"}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Staff\",\"format\":\"#,0\",\"queryName\":\"CountNonNull(Sheet1.Staff Recoveries)\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Staff Recoveries\"}},\"Function\":0}}}]}"
},
{
"id": 63029520,
"x": 9.61,
"y": 465.57,
"z": 24000.0,
"width": 340.6,
"height": 43.94,
"config": "{\"name\":\"486eff21b43e40287040\",\"layouts\":[{\"id\":0,\"position\":{\"x\":9.613733905579398,\"y\":465.5793991416309,\"z\":24000,\"width\":340.6008583690987,\"height\":43.94849785407725,\"tabOrder\":21000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Recoveries\",\"textStyle\":{\"fontSize\":\"18pt\",\"color\":\"#ffffff\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029521,
"x": 10.98,
"y": 280.17,
"z": 25000.0,
"width": 339.22,
"height": 70.04,
"config": "{\"name\":\"82421f532db57fc8f735\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.987124463519313,\"y\":280.17167381974247,\"z\":25000,\"width\":339.22746781115876,\"height\":70.04291845493562,\"tabOrder\":22000}}],\"singleVisual\":{\"visualType\":\"slicer\",\"projections\":{\"Values\":[{\"queryRef\":\"Sheet1.Facility County\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility County\"},\"Name\":\"Sheet1.Facility County\"}]},\"drillFilterOtherVisuals\":true,\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Dropdown'\"}}}}}],\"header\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"selection\":[{\"properties\":{\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"items\":[{\"properties\":{\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":1,\"Percent\":0}}}}}}}],\"general\":[{\"properties\":{}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#a3b1be'\"}}}}}}}],\"title\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'County'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Drop down box to select one or more facility types.'\"}}}}}]}}}",
"filters": "[{\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility type\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}]]}}}}}]},\"type\":\"Categorical\",\"howCreated\":1,\"isHiddenInViewMode\":false}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Sheet1\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility County\"},\"Name\":\"Sheet1.Facility County\"}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Property\":\"Facility type\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}]]}}}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0]}]},\"DataReduction\":{\"DataVolume\":3,\"Primary\":{\"Window\":{}}},\"IncludeEmptyGroups\":true,\"Version\":1}}}]}",
"queryHash": 2436032603459667359,
"dataTransforms": "{\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Dropdown'\"}}}}}],\"header\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"selection\":[{\"properties\":{\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"items\":[{\"properties\":{\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":1,\"Percent\":0}}}}}}}],\"general\":[{\"properties\":{}}]},\"projectionOrdering\":{\"Values\":[0]},\"projectionActiveItems\":{\"Values\":[{\"queryRef\":\"Sheet1.Facility County\",\"suppressConcat\":false}]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Facility County\",\"Name\":\"Sheet1.Facility County\",\"Type\":2048}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility type\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Values\",\"Projection\":0,\"isActive\":true}]}],\"selects\":[{\"displayName\":\"Facility County\",\"queryName\":\"Sheet1.Facility County\",\"roles\":{\"Values\":true},\"type\":{\"category\":null,\"underlyingType\":1},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Sheet1\"}},\"Property\":\"Facility County\"}}}]}"
}
],
"name": "ReportSection",
"filters": "[]",
"width": 1280.0,
"height": 720.0,
"config": "{\"objects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#c8c8c8'\"}}}}},\"transparency\":{\"expr\":{\"Literal\":{\"Value\":\"0D\"}}}}}]}}",
"displayName": "Facility Results",
"objectId": "33600a63-a0e9-4e6d-9e05-d8de4bafa3f3",
"displayOption": 1
},
{
"id": 2648487,
"visualContainers": [
{
"id": 63029522,
"x": 3.57,
"y": 29.75,
"z": 0.0,
"width": 744.99,
"height": 76.16,
"config": "{\"name\":\"d443f783e9589ece54e1\",\"layouts\":[{\"id\":0,\"position\":{\"x\":3.5702479338842976,\"y\":29.75206611570248,\"z\":0,\"width\":744.99173553719,\"height\":76.16528925619835,\"tabOrder\":3000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Facilities with Reported COVID-19 Cases\",\"textStyle\":{\"fontWeight\":\"bold\",\"fontSize\":\"28pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"The epi curve and primary symptoms are collective of all facilities and are not reflective of any one individual facility. \"}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029523,
"x": 11.96,
"y": 119.6,
"z": 1000.0,
"width": 1257.0,
"height": 296.61,
"config": "{\"name\":\"e75248462ce2296a6931\",\"layouts\":[{\"id\":0,\"position\":{\"x\":11.960132890365449,\"y\":119.60132890365448,\"z\":1000,\"width\":1257.0099667774086,\"height\":296.6112956810631,\"tabOrder\":1000}}],\"singleVisual\":{\"visualType\":\"columnChart\",\"projections\":{\"Category\":[{\"queryRef\":\"Epi Curve.Onset Date\",\"active\":true}],\"Y\":[{\"queryRef\":\"CountNonNull(Epi Curve.Facility)\"}],\"Series\":[{\"queryRef\":\"Epi Curve.Title\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Onset Date\"},\"Name\":\"Epi Curve.Onset Date\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Facility\"}},\"Function\":5},\"Name\":\"CountNonNull(Epi Curve.Facility)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"},\"Name\":\"Epi Curve.Title\"}],\"OrderBy\":[{\"Direction\":1,\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Onset Date\"}}}]},\"columnProperties\":{\"CountNonNull(Epi Curve.Facility)\":{\"displayName\":\"Count\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"categoryAxis\":[{\"properties\":{\"axisType\":{\"expr\":{\"Literal\":{\"Value\":\"'Categorical'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"titleColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"valueAxis\":[{\"properties\":{\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"labelOverflow\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"legend\":[{\"properties\":{\"showTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'BottomCenter'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":2,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}},\"Right\":{\"Literal\":{\"Value\":\"'Resident'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#12239E'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}},\"Right\":{\"Literal\":{\"Value\":\"'Staff'\"}}}}}]}}]},\"vcObjects\":{\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Epidemic Curve'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"border\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}],\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Epidemic curve with the number of cases by onset date for residents and staff.'\"}}}}}]}}}",
"filters": "[{\"name\":\"Filtera2231fa9fba513f3e528\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Onset Date\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Onset Date\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}],[{\"Literal\":{\"Value\":\"datetime'1920-07-30T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1936-10-31T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1940-08-02T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1962-04-01T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1968-07-28T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1975-09-11T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1977-11-10T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2010-05-08T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2010-11-02T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2010-11-04T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2019-07-24T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2020-01-05T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2020-02-10T00:00:00'\"}}]]}}}}}]},\"type\":\"Categorical\",\"howCreated\":0,\"objects\":{\"general\":[{\"properties\":{\"isInvertedSelectionMode\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}]},\"isHiddenInViewMode\":false},{\"name\":\"Filter449152abbe75a05ea763\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Resident'\"}}],[{\"Literal\":{\"Value\":\"'Staff'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":0,\"objects\":{},\"isHiddenInViewMode\":false}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Onset Date\"},\"Name\":\"Epi Curve.Onset Date\"},{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Facility\"}},\"Function\":5},\"Name\":\"CountNonNull(Epi Curve.Facility)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"},\"Name\":\"Epi Curve.Title\"}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Onset Date\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"null\"}}],[{\"Literal\":{\"Value\":\"datetime'1920-07-30T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1936-10-31T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1940-08-02T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1962-04-01T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1968-07-28T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1975-09-11T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'1977-11-10T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2010-05-08T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2010-11-02T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2010-11-04T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2019-07-24T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2020-01-05T00:00:00'\"}}],[{\"Literal\":{\"Value\":\"datetime'2020-02-10T00:00:00'\"}}]]}}}}},{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Title\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Resident'\"}}],[{\"Literal\":{\"Value\":\"'Staff'\"}}]]}}}],\"OrderBy\":[{\"Direction\":1,\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Onset Date\"}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0,1]}]},\"Secondary\":{\"Groupings\":[{\"Projections\":[2]}]},\"DataReduction\":{\"DataVolume\":4,\"Primary\":{\"Window\":{\"Count\":200}},\"Secondary\":{\"Top\":{\"Count\":60}}},\"Version\":1}}}]}",
"queryHash": 8604786039119498450,
"dataTransforms": "{\"objects\":{\"categoryAxis\":[{\"properties\":{\"axisType\":{\"expr\":{\"Literal\":{\"Value\":\"'Categorical'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"titleColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"valueAxis\":[{\"properties\":{\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"labelOverflow\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"legend\":[{\"properties\":{\"showTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'BottomCenter'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"dataPoint\":[{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":2,\"Percent\":0}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}},\"Right\":{\"Literal\":{\"Value\":\"'Resident'\"}}}}}]}},{\"properties\":{\"fill\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#12239E'\"}}}}}},\"selector\":{\"data\":[{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}},\"Right\":{\"Literal\":{\"Value\":\"'Staff'\"}}}}}]}}]},\"projectionOrdering\":{\"Category\":[0],\"Y\":[1],\"Series\":[2]},\"projectionActiveItems\":{\"Category\":[{\"queryRef\":\"Epi Curve.Onset Date\",\"suppressConcat\":false}]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Onset Date\",\"Name\":\"Epi Curve.Onset Date\",\"Type\":4,\"Format\":\"%M/%d/yyyy\"},{\"Restatement\":\"Count\",\"Name\":\"CountNonNull(Epi Curve.Facility)\",\"Type\":3},{\"Restatement\":\"Title\",\"Name\":\"Epi Curve.Title\",\"Type\":2048}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Onset Date\"}}},{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Category\",\"Projection\":0,\"isActive\":true},{\"Name\":\"Y\",\"Projection\":1,\"isActive\":false},{\"Name\":\"Series\",\"Projection\":2,\"isActive\":false}]}],\"selects\":[{\"displayName\":\"Onset Date\",\"format\":\"%M/%d/yyyy\",\"queryName\":\"Epi Curve.Onset Date\",\"roles\":{\"Category\":true},\"sort\":1,\"sortOrder\":0,\"type\":{\"category\":null,\"underlyingType\":519},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Onset Date\"}}},{\"displayName\":\"Count\",\"queryName\":\"CountNonNull(Epi Curve.Facility)\",\"roles\":{\"Y\":true},\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Facility\"}},\"Function\":5}}},{\"displayName\":\"Title\",\"queryName\":\"Epi Curve.Title\",\"roles\":{\"Series\":true},\"type\":{\"category\":null,\"underlyingType\":1},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Title\"}}}]}"
},
{
"id": 63029524,
"x": 11.9,
"y": 424.85,
"z": 2000.0,
"width": 1256.72,
"height": 278.47,
"config": "{\"name\":\"c4ba8dd35135b8b35622\",\"layouts\":[{\"id\":0,\"position\":{\"x\":11.900826446280991,\"y\":424.8595041322314,\"z\":2000,\"width\":1256.7272727272727,\"height\":278.4793388429752,\"tabOrder\":0}}],\"singleVisual\":{\"visualType\":\"clusteredColumnChart\",\"projections\":{\"Y\":[{\"queryRef\":\"CountNonNull(Epi Curve.Facility Name)\"}],\"Category\":[{\"queryRef\":\"Epi Curve.Symptom\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Facility Name\"}},\"Function\":5},\"Name\":\"CountNonNull(Epi Curve.Facility Name)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"},\"Name\":\"Epi Curve.Symptom\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Facility Name\"}},\"Function\":5}}}]},\"columnProperties\":{\"CountNonNull(Epi Curve.Facility Name)\":{\"displayName\":\"Count\"}},\"drillFilterOtherVisuals\":true,\"hasDefaultSort\":true,\"objects\":{\"legend\":[{\"properties\":{\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'RightCenter'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"preferredCategoryWidth\":{\"expr\":{\"Literal\":{\"Value\":\"20D\"}}},\"maxMarginFactor\":{\"expr\":{\"Literal\":{\"Value\":\"15L\"}}},\"innerPadding\":{\"expr\":{\"Literal\":{\"Value\":\"28L\"}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"concatenateLabels\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'8'\"}}}}}],\"valueAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"vcObjects\":{\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Primary Symptoms'\"}}},\"fontColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'16'\"}}}}}],\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#47647D'\"}}}}}}}],\"general\":[{\"properties\":{\"altText\":{\"expr\":{\"Literal\":{\"Value\":\"'Chart with the number of cases for each primary symptom.'\"}}}}}]}}}",
"filters": "[{\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Symptom\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"''\"}}]]}}}}}]},\"type\":\"Categorical\",\"howCreated\":0,\"isHiddenInViewMode\":false},{\"name\":\"Filter72235f04e9b7dda16dde\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Symptom\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"subquery\",\"Expression\":{\"Subquery\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"},\"Name\":\"field\"}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"}},\"Function\":5}}}],\"Top\":10}}},\"Type\":2},{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"}}],\"Table\":{\"SourceRef\":{\"Source\":\"subquery\"}}}}}]},\"type\":\"TopN\",\"howCreated\":1}]",
"query": "{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Epi Curve\",\"Type\":0},{\"Name\":\"subquery\",\"Expression\":{\"Subquery\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"e1\",\"Entity\":\"Epi Curve\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e1\"}},\"Property\":\"Symptom\"},\"Name\":\"field\"}],\"Where\":[{\"Condition\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e1\"}},\"Property\":\"Symptom\"}},\"Right\":{\"AnyValue\":{\"DefaultValueOverridesAncestors\":true}}}}},{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e1\"}},\"Property\":\"Symptom\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"''\"}}]]}}}}}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e1\"}},\"Property\":\"Symptom\"}},\"Function\":5}}}],\"Top\":10}}},\"Type\":2}],\"Select\":[{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Facility Name\"}},\"Function\":5},\"Name\":\"CountNonNull(Epi Curve.Facility Name)\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"},\"Name\":\"Epi Curve.Symptom\"}],\"Where\":[{\"Condition\":{\"Not\":{\"Expression\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"''\"}}]]}}}}},{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Symptom\"}}],\"Table\":{\"SourceRef\":{\"Source\":\"subquery\"}}}}}],\"OrderBy\":[{\"Direction\":2,\"Expression\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Facility Name\"}},\"Function\":5}}}]},\"Binding\":{\"Primary\":{\"Groupings\":[{\"Projections\":[0,1]}]},\"DataReduction\":{\"DataVolume\":4,\"Primary\":{\"Window\":{\"Count\":1000}}},\"Version\":1}}}]}",
"queryHash": 5197915199692625028,
"dataTransforms": "{\"objects\":{\"legend\":[{\"properties\":{\"position\":{\"expr\":{\"Literal\":{\"Value\":\"'RightCenter'\"}}},\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}],\"categoryAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"preferredCategoryWidth\":{\"expr\":{\"Literal\":{\"Value\":\"20D\"}}},\"maxMarginFactor\":{\"expr\":{\"Literal\":{\"Value\":\"15L\"}}},\"innerPadding\":{\"expr\":{\"Literal\":{\"Value\":\"28L\"}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"concatenateLabels\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"fontSize\":{\"expr\":{\"Literal\":{\"Value\":\"'8'\"}}}}}],\"valueAxis\":[{\"properties\":{\"labelColor\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}},\"showAxisTitle\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"gridlineStyle\":{\"expr\":{\"Literal\":{\"Value\":\"'solid'\"}}}}}],\"labels\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}},\"color\":{\"solid\":{\"color\":{\"expr\":{\"ThemeDataColor\":{\"ColorId\":0,\"Percent\":0}}}}}}}]},\"projectionOrdering\":{\"Y\":[0],\"Category\":[1]},\"projectionActiveItems\":{\"Category\":[{\"queryRef\":\"Epi Curve.Symptom\",\"suppressConcat\":false}]},\"queryMetadata\":{\"Select\":[{\"Restatement\":\"Count\",\"Name\":\"CountNonNull(Epi Curve.Facility Name)\",\"Type\":3},{\"Restatement\":\"Symptom\",\"Name\":\"Epi Curve.Symptom\",\"Type\":2048}],\"Filters\":[{\"type\":0,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Symptom\"}}},{\"type\":5,\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Symptom\"}}}]},\"visualElements\":[{\"DataRoles\":[{\"Name\":\"Y\",\"Projection\":0,\"isActive\":false},{\"Name\":\"Category\",\"Projection\":1,\"isActive\":true}]}],\"selects\":[{\"displayName\":\"Count\",\"queryName\":\"CountNonNull(Epi Curve.Facility Name)\",\"roles\":{\"Y\":true},\"sort\":2,\"sortOrder\":0,\"type\":{\"category\":null,\"underlyingType\":260},\"expr\":{\"Aggregation\":{\"Expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Facility Name\"}},\"Function\":5}}},{\"displayName\":\"Symptom\",\"queryName\":\"Epi Curve.Symptom\",\"roles\":{\"Category\":true},\"type\":{\"category\":null,\"underlyingType\":1},\"expr\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Epi Curve\"}},\"Property\":\"Symptom\"}}}]}"
},
{
"id": 63029525,
"x": 748.6,
"y": 0.0,
"z": 3000.0,
"width": 200.26,
"height": 119.2,
"config": "{\"name\":\"7860a73df59556e8ddae\",\"layouts\":[{\"id\":0,\"position\":{\"x\":748.6092715231788,\"y\":0,\"z\":3000,\"width\":200.26490066225165,\"height\":119.20529801324503,\"tabOrder\":-9997000}}],\"singleVisual\":{\"visualType\":\"image\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"imageUrl\":{\"expr\":{\"ResourcePackageItem\":{\"PackageName\":\"RegisteredResources\",\"PackageType\":1,\"ItemName\":\"Seal_221416845334902135.PNG\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029526,
"x": 928.86,
"y": 15.42,
"z": 4000.0,
"width": 199.29,
"height": 90.15,
"config": "{\"name\":\"ff2ccf906c093f950bb1\",\"layouts\":[{\"id\":0,\"position\":{\"x\":928.8600556070435,\"y\":15.421686746987952,\"z\":4000,\"width\":199.2956441149212,\"height\":90.1575532900834,\"tabOrder\":-9998000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"State of Nevada \",\"textStyle\":{\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Department of Health and \",\"textStyle\":{\"fontWeight\":\"bold\",\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Human Services\",\"textStyle\":{\"fontWeight\":\"bold\",\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Office of Analytics\",\"textStyle\":{\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#c8c8c8'\"}}}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029527,
"x": 1097.61,
"y": 0.0,
"z": 5000.0,
"width": 182.38,
"height": 119.2,
"config": "{\"name\":\"b0e4869411c23319e9ec\",\"layouts\":[{\"id\":0,\"position\":{\"x\":1097.6158940397352,\"y\":0,\"z\":5000,\"width\":182.3841059602649,\"height\":119.20529801324503,\"tabOrder\":-9999000}}],\"singleVisual\":{\"visualType\":\"image\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"imageUrl\":{\"expr\":{\"ResourcePackageItem\":{\"PackageName\":\"RegisteredResources\",\"PackageType\":1,\"ItemName\":\"Logo560168588277643.PNG\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029528,
"x": 705.64,
"y": 119.6,
"z": 6000.0,
"width": 559.73,
"height": 41.86,
"config": "{\"name\":\"3af420b4a85b7f4c0072\",\"layouts\":[{\"id\":0,\"position\":{\"x\":705.6478405315614,\"y\":119.60132890365448,\"z\":6000,\"width\":559.7342192691029,\"height\":41.860465116279066,\"tabOrder\":2000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"To see most recent data use the scroll bar under the bar chart to scroll to the right. \",\"textStyle\":{\"fontSize\":\"11pt\",\"color\":\"#ffffff\"}}]}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029529,
"x": 11.96,
"y": 687.7,
"z": 7000.0,
"width": 1257.0,
"height": 32.29,
"config": "{\"name\":\"49d686e7ee7e0116ca54\",\"layouts\":[{\"id\":0,\"position\":{\"x\":11.960132890365449,\"y\":687.7076411960132,\"z\":7000,\"width\":1257.0099667774086,\"height\":32.29235880398671,\"tabOrder\":4000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"\"}]}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
}
],
"name": "ReportSectione33c2ce5aa43bf266286",
"filters": "[]",
"width": 1280.0,
"height": 720.0,
"config": "{\"objects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#c8c8c8'\"}}}}},\"transparency\":{\"expr\":{\"Literal\":{\"Value\":\"0D\"}}}}}]}}",
"displayName": "Epi Curve and Symptoms",
"ordinal": 1,
"objectId": "767857c2-51d3-40b6-8973-3fd010e6fe6c",
"displayOption": 1
},
{
"id": 2648488,
"visualContainers": [
{
"id": 63029530,
"x": 3.58,
"y": 27.5,
"z": 0.0,
"width": 745.11,
"height": 66.97,
"config": "{\"name\":\"d443f783e9589ece54e1\",\"layouts\":[{\"id\":0,\"position\":{\"x\":3.5880398671096345,\"y\":27.50830564784053,\"z\":0,\"width\":745.1162790697674,\"height\":66.9767441860465,\"tabOrder\":0}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Facilities with Reported COVID-19 Cases\",\"textStyle\":{\"fontWeight\":\"bold\",\"fontSize\":\"28pt\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029531,
"x": 748.6,
"y": 0.0,
"z": 1000.0,
"width": 200.26,
"height": 119.2,
"config": "{\"name\":\"7860a73df59556e8ddae\",\"layouts\":[{\"id\":0,\"position\":{\"x\":748.6092715231788,\"y\":0,\"z\":1000,\"width\":200.26490066225165,\"height\":119.20529801324503,\"tabOrder\":-9997000}}],\"singleVisual\":{\"visualType\":\"image\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"imageUrl\":{\"expr\":{\"ResourcePackageItem\":{\"PackageName\":\"RegisteredResources\",\"PackageType\":1,\"ItemName\":\"Seal_221416845334902135.PNG\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029532,
"x": 928.86,
"y": 15.42,
"z": 2000.0,
"width": 199.29,
"height": 90.15,
"config": "{\"name\":\"ff2ccf906c093f950bb1\",\"layouts\":[{\"id\":0,\"position\":{\"x\":928.8600556070435,\"y\":15.421686746987952,\"z\":2000,\"width\":199.2956441149212,\"height\":90.1575532900834,\"tabOrder\":-9998000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"State of Nevada \",\"textStyle\":{\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Department of Health and \",\"textStyle\":{\"fontWeight\":\"bold\",\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Human Services\",\"textStyle\":{\"fontWeight\":\"bold\",\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"},{\"textRuns\":[{\"value\":\"Office of Analytics\",\"textStyle\":{\"fontFamily\":\"Calibri\",\"fontSize\":\"12pt\"}}],\"horizontalTextAlignment\":\"center\"}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#c8c8c8'\"}}}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029533,
"x": 1097.61,
"y": 0.0,
"z": 3000.0,
"width": 182.38,
"height": 119.2,
"config": "{\"name\":\"b0e4869411c23319e9ec\",\"layouts\":[{\"id\":0,\"position\":{\"x\":1097.6158940397352,\"y\":0,\"z\":3000,\"width\":182.3841059602649,\"height\":119.20529801324503,\"tabOrder\":-9999000}}],\"singleVisual\":{\"visualType\":\"image\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"imageUrl\":{\"expr\":{\"ResourcePackageItem\":{\"PackageName\":\"RegisteredResources\",\"PackageType\":1,\"ItemName\":\"Logo560168588277643.PNG\"}}}}}]}}}",
"filters": "[]"
},
{
"id": 63029534,
"x": 10.98,
"y": 119.48,
"z": 4000.0,
"width": 1253.9,
"height": 600.17,
"config": "{\"name\":\"2e3ac0253b3a4ec17c15\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.987124463519313,\"y\":119.48497854077253,\"z\":4000,\"width\":1253.9055793991415,\"height\":600.1716738197425,\"tabOrder\":1000}}],\"singleVisual\":{\"visualType\":\"textbox\",\"drillFilterOtherVisuals\":true,\"objects\":{\"general\":[{\"properties\":{\"paragraphs\":[{\"textRuns\":[{\"value\":\"Technical Notes:\",\"textStyle\":{\"fontSize\":\"16pt\",\"color\":\"#ffffff\"}},{\"value\":\" \",\"textStyle\":{\"fontSize\":\"18pt\",\"color\":\"#ffffff\"}}]},{\"textRuns\":[{\"value\":\"These data reflect state regulated facilities in Nevada that have laboratory confirmed COVID-19 positive cases. Data are collected by investigators in the Office of Public Health Investigations and Epidemiology (OPHIE) and self-reported by facilities through REDCap. Facility data are updated in the mornings, Monday through Friday, with the previous day\u2019s reporting. \",\"textStyle\":{\"fontSize\":\"12pt\"}}]},{\"textRuns\":[{\"value\":\"\"}]},{\"textRuns\":[{\"value\":\"A facility outbreak is defined as a situation with either of the following criteria: 1) During (and because of) a case investigation and contact tracing, two or more contacts are identified as having active COVID-19, regardless of their assigned priority, or 2) Two or more clients with COVID-19 are discovered to be linked, and the linkage is established outside of a case investigation and contract tracing (e.g., two clients who received a diagnosis of COVID-19 are found to work in the same office, and only one or neither of them was listed as a contact to the other). The Division of Public and Behavioral Health (DPBH) investigates a facility when one case is reported. \",\"textStyle\":{\"fontSize\":\"12pt\"}}]},{\"textRuns\":[{\"value\":\"\"}]},{\"textRuns\":[{\"value\":\"Imported cases are residents who were confirmed COVID-19 positive prior to entering the facility. Total facility counts are from Health Care Quality and Compliance (HCQC) and the Department of Corrections (DOC). The epi curve and primary symptoms are collective of all facilities and are not reflective of any one individual facility. \",\"textStyle\":{\"fontSize\":\"12pt\"}}]},{\"textRuns\":[{\"value\":\"\"}]},{\"textRuns\":[{\"value\":\"Recoveries reflect data supplied by a facility as symptoms resolved and meeting either the test-based strategy or the symptom-based strategy provided by the Centers for Disease Control and Prevention and includes confirmed positive staff, residents, and imported cases. Total unique confirmed cases includes residents and staff that tested COVID-19 positive at that facility, and does not include imported cases. COVID-19 data are reported as timely, accurately, and completely as we have available. Data are updated as we receive information that is more complete and will change over time as we learn more. \",\"textStyle\":{\"fontSize\":\"12pt\"}}]},{\"textRuns\":[{\"value\":\"\"}]},{\"textRuns\":[{\"value\":\"\\\"Other\\\" primary symptom includes having symptoms other than abdominal pain, abscess, blister, boil, bumps, chills, congestion, cough, diarrhea, dry/cracked skin, fever (100\u00b0F or more), headache, itching, malaise/body aches, nausea, rash, runny/stuffy nose, sore throat, or vomiting. \",\"textStyle\":{\"fontSize\":\"12pt\"}}]},{\"textRuns\":[{\"value\":\"\"}]},{\"textRuns\":[{\"value\":\"Effective 7/31 the attack rate is calculated using the following formulas: total confirmed residents/total resident census and total confirmed staff/total staff census.\u00a0This calculation\u00a0better accounts for current information provided by facilities through both staff and resident/patient census data.\",\"textStyle\":{\"fontSize\":\"12pt\"}}]},{\"textRuns\":[{\"value\":\"\"}]},{\"textRuns\":[{\"value\":\"\"}]},{\"textRuns\":[{\"value\":\"The DHHS Office of Analytics also maintains a statewide COVID-19 Dashboard, available here: \",\"textStyle\":{\"fontWeight\":\"bold\",\"fontSize\":\"12pt\"}},{\"value\":\"COVID-19 Dashboard.\",\"textStyle\":{\"fontWeight\":\"bold\",\"fontSize\":\"12pt\"},\"url\":\"https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9\"}]}]}}]},\"vcObjects\":{\"background\":[{\"properties\":{\"show\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}}}}]}}}",
"filters": "[]"
}
],
"name": "ReportSection717cc3d130a62019b9b5",
"filters": "[]",
"width": 1280.0,
"height": 720.0,
"config": "{\"objects\":{\"background\":[{\"properties\":{\"color\":{\"solid\":{\"color\":{\"expr\":{\"Literal\":{\"Value\":\"'#c8c8c8'\"}}}}},\"transparency\":{\"expr\":{\"Literal\":{\"Value\":\"0D\"}}}}}]}}",
"displayName": "Technical Notes",
"ordinal": 2,
"objectId": "eceafc7d-4aef-4d07-b453-56813bb42853",
"displayOption": 1
}
],
"pods": [
{
"id": 4470444,
"name": "Pod",
"objectId": "5fcd4482-dfae-4e6b-acbf-ce5bb7b7119a",
"boundSection": "ReportSectione33c2ce5aa43bf266286",
"config": "{}"
},
{
"id": 4470445,
"name": "Pod3",
"objectId": "fb7e7688-8b80-4297-90f0-3e340d52f24b",
"boundSection": "ReportSection",
"config": "{}"
},
{
"id": 4470446,
"name": "Pod1",
"objectId": "823744f5-783d-43c0-8ca7-d2fe3358474f",
"boundSection": "ReportSection717cc3d130a62019b9b5",
"config": "{}"
}
],
"config": "{\"version\":\"5.9\",\"themeCollection\":{\"baseTheme\":{\"name\":\"CY19SU12\",\"version\":\"5.8\",\"type\":2}},\"activeSectionIndex\":0,\"defaultDrillFilterOtherVisuals\":true,\"slowDataSourceSettings\":{\"isCrossHighlightingDisabled\":false,\"isSlicerSelectionsButtonEnabled\":false,\"isFilterSelectionsButtonEnabled\":false,\"isFieldWellButtonEnabled\":false,\"isApplyAllButtonEnabled\":false},\"linguisticSchemaSyncVersion\":2,\"settings\":{\"isPersistentUserStateDisabled\":false,\"hideVisualContainerHeader\":false,\"useStylableVisualContainerHeader\":true,\"exportDataMode\":2,\"useNewFilterPaneExperience\":true,\"optOutNewFilterPaneExperience\":false,\"defaultFilterActionIsDataFilter\":false,\"useCrossReportDrillthrough\":false,\"allowChangeFilterTypes\":true,\"allowInlineExploration\":false,\"disableFilterPaneSearch\":false,\"allowDataPointLassoSelect\":false},\"objects\":{\"section\":[{\"properties\":{\"verticalAlignment\":{\"expr\":{\"Literal\":{\"Value\":\"'Top'\"}}}}}],\"outspacePane\":[{\"properties\":{\"expanded\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}]}}",
"reportId": 142156,
"report": {
"resourcePackages": [
{
"id": 978003,
"type": 2,
"name": "SharedResources",
"items": [
{
"id": 3924068,
"resourcePackageId": 978003,
"type": 202,
"path": "BaseThemes/CY19SU12.json",
"name": "CY19SU12"
}
],
"reportId": 142156,
"disabled": false
},
{
"id": 986744,
"type": 1,
"name": "RegisteredResources",
"items": [
{
"id": 3985843,
"resourcePackageId": 986744,
"type": 100,
"path": "1/e4a340e6-b89e-4e68-8eaa-1544d2703980/ResourcePackage/BlobIdV2-4abfe62c-489e-415f-b16a-b7a1dea114975M.PNG",
"name": "Logo560168588277643.PNG",
"resourcePackageItemBlobInfoId": 1668995
},
{
"id": 3985844,
"resourcePackageId": 986744,
"type": 100,
"path": "1/e4a340e6-b89e-4e68-8eaa-1544d2703980/ResourcePackage/BlobIdV2-c036ca85-5bfa-4d33-aeb4-55419e341b14aGLALXB1MSSQLZupcCT3H7pB1hK.PNG",
"name": "Seal_221416845334902135.PNG",
"resourcePackageItemBlobInfoId": 1668996
}
],
"reportId": 142156
}
],
"annotationsEnabled": true,
"id": 142156,
"modelId": 274097,
"objectId": "8205b174-a4b1-479c-b62f-2b95a348fe98",
"name": "resources/Layout.layout",
"displayName": "COVID-19 Facilities Dashboard",
"model": {
"id": 274097,
"vsName": "sobe_wowvirtualserver",
"dbName": "10a1e28c-bfcb-4358-bb18-0cb39b08a031",
"currentRefreshStartingTime": "",
"refreshSchedule": {
"importAndRefreshBehavior": 0,
"executionTime": null,
"localTimeZoneId": "UTC",
"refreshEnabled": false,
"isDaily": false,
"isRefreshable": false,
"numberOfTimeIntervals": 4,
"refreshNotificationEnabled": true,
"forceQueryRefreshEnabled": false,
"forceModelRefreshEnabled": false,
"refreshDisabledReason": 0
},
"nextRefreshTime": "/Date(1605875279000)/",
"NextRefreshTime": "2020-11-20T12:27:59",
"LastRefreshTime": "2020-11-19T19:22:35.717",
"nextRefreshTimeUtc": "2020-11-20T12:27:59Z",
"lastRefreshTime": "/Date(1605813755717)/",
"lastTimeAModelChangeWasDetectedInTheCluster": "",
"lastRefreshStatus": 0,
"permissions": 15,
"creatorUserId": 42327,
"directQueryMode": false,
"sizeInMBs": 2,
"qnaSupported": true,
"insightsSupported": true,
"name": "PowerBICompanionModelResource",
"displayName": "COVID-19 Facilities Dashboard",
"packageId": 277459,
"packageVersion": "ID-3458215",
"isRefreshedByContentProvider": false,
"isHidden": false,
"modelProperties": 4,
"modelFeatures": 0,
"features": 0,
"isOnPremisesGatewayOverride": false,
"lastNLResourceGenerationTime": "/Date(1605730051507)/",
"contentProviderId": 7,
"lastNLResourceUpdateStatus": 0,
"nlResourceGenerationFailureCount": 0,
"isPackageRefreshEnabled": false,
"featuresV2": [
0,
64,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sharedFromNonEnterpriseCapacity": true,
"isInEnterpriseCapacity": false,
"capacityId": null,
"capacityObjectId": null,
"cachedModelEnabled": true,
"dataCacheMode": 0,
"datasourceFormat": 1
},
"reportSlides": [],
"packageId": 277459,
"permissions": 15,
"packageVersion": "ID-3458215",
"contentProviderId": 7,
"linguisticSchemaId": 67025,
"featuresV2": [
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sharedFromNonEnterpriseCapacity": true,
"folderId": 1622,
"ownerInfo": {
"artifactId": 142156,
"artifactType": 2,
"givenName": "Office Of Analytics Test Group",
"familyName": null,
"emailAddress": null,
"userObjectId": null,
"groupObjectId": "37931D6D-0872-4264-A86A-7FC73A24A3D6"
}
},
"resourcePackages": [
{
"resourcePackage": {
"id": 978003,
"type": 2,
"name": "SharedResources",
"items": [
{
"id": 3924068,
"resourcePackageId": 978003,
"type": 202,
"path": "BaseThemes/CY19SU12.json",
"name": "CY19SU12"
}
],
"reportId": 142156,
"disabled": false
}
},
{
"resourcePackage": {
"id": 986744,
"type": 1,
"name": "RegisteredResources",
"items": [
{
"id": 3985843,
"resourcePackageId": 986744,
"type": 100,
"path": "1/e4a340e6-b89e-4e68-8eaa-1544d2703980/ResourcePackage/BlobIdV2-4abfe62c-489e-415f-b16a-b7a1dea114975M.PNG",
"name": "Logo560168588277643.PNG",
"resourcePackageItemBlobInfoId": 1668995
},
{
"id": 3985844,
"resourcePackageId": 986744,
"type": 100,
"path": "1/e4a340e6-b89e-4e68-8eaa-1544d2703980/ResourcePackage/BlobIdV2-c036ca85-5bfa-4d33-aeb4-55419e341b14aGLALXB1MSSQLZupcCT3H7pB1hK.PNG",
"name": "Seal_221416845334902135.PNG",
"resourcePackageItemBlobInfoId": 1668996
}
],
"reportId": 142156
}
}
],
"layoutOptimization": 0
},
"package": {
"id": 277459,
"version": "ID-3458215",
"name": "COVID-19 Facilities Dashboard.pbix",
"contentProviderId": 7,
"lastRefreshTime": "/Date(1605813755717)/",
"publishOrRefreshStatus": 0,
"refreshInterval": 2147483647,
"NextRefreshTime": "9999-12-31T23:59:59.997Z",
"LastRefreshTime": "2020-11-19T19:22:35.717",
"IsRefreshEnabled": true,
"ObjectId": "6a17b934-a44e-43d4-af82-e4bac6e2a7fc",
"storageProviderType": 0,
"extendedDataAccessInfos": [
{
"ContentProviderId": 7,
"Sid": "16121e3b-aff9-4c35-8a87-47c9654243af",
"Dsid": "6f6c5c97-6e94-4101-aebb-eb2af1e7b733",
"PackageId": 277459,
"UserId": 42327,
"User": null,
"Payload": "{\"ExtendedDsid\":{\"blobCollectionId\":1507822,\"databaseName\":\"10a1e28c-bfcb-4358-bb18-0cb39b08a031\",\"details\":null,\"errorCode\":null,\"exceptionCulprit\":0,\"fileName\":\"COVID-19 Facilities Dashboard.pbix\",\"fileSize\":203008,\"informationProtectionLabelIssuerId\":null,\"isConfigureMode\":true,\"originIdentifier\":\"COVID-19 Facilities Dashboard.pbix\",\"packageContentBlobUri\":\"companionprovider\\/4cdb543d-0638-4bd7-8722-baad809dde591tZ4YcjFOFM1eGEnIWE6HsbME-PL4YWwGXi9zqxrzoY=.zip\",\"resourceId\":null,\"serializedViewsBlobUri\":null,\"shadowWorkbookBlobUri\":null,\"sharePointDocumentProperties\":null,\"shouldRestreamFileFromSource\":true,\"sourceFileBlobId\":3458215,\"storageProviderType\":0,\"version\":\"ID-3458215\",\"virtualServerName\":\"sobe_wowvirtualserver\",\"workbookArtifacts\":1},\"ExtendedSid\":null}",
"OriginalPackageId": null,
"OriginalSid": null,
"OriginalDsid": null,
"BlobInfoId": null,
"BlobInfo": null
}
],
"permissions": 7,
"pbixResources": [
{
"id": 415554,
"packageId": 277459,
"pbixResourceBlobInfoId": 3458216
}
],
"featuresV2": [
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
},
"featureSwitches": {
"aADGroupCreationSettingMigratedEnabled": true,
"allowAccessOverPrivateLinksEnabled": false,
"allowAccessOverPublicLinksEnabled": true,
"allowFreeTrialEnabled": true,
"allowGuestUserToAccessSharedContentEnabled": true,
"allowManageGuestUserPermissionsEnabled": true,
"allowServicePrincipalsUseReadAdminAPIsEnabled": false,
"appPushEnabled": true,
"artifactSearchTenantEnabled": true,
"aSConnectorEnabled": true,
"auditingEnabled": false,
"azureMapEnabled": false,
"azureStreamAnalyticsManagedIdentityAuthorizationEnabled": true,
"cdsaExternalComputeManagementEnabled": false,
"cDSAManagementEnabled": true,
"certifiedCustomVisualsTenantEnabled": false,
"certifyDatasetsEnabled": false,
"contentAuthoringUIEnabled": true,
"cortanaEnabled": true,
"createAppWorkspacesEnabled": true,
"customVisualsTenantEnabled": true,
"developServiceAppsEnabled": true,
"disableWorkspaceV1CreationEnabled": false,
"eimInformationProtectionEditEnabled": false,
"eimInformationProtectionMandatoryLabelSettingEnabled": false,
"eimInformationProtectionViewEnabled": false,
"elevatedGuestsTenantEnabled": false,
"emailSecurityGroupsOnOutageEnabled": false,
"emailSubscriptionTenantEnabled": true,
"embeddingEnabled": true,
"enableExcelYellowIntegrationEnabled": true,
"enableMarketingPipelineEnabled": false,
"esriVisualEnabled": false,
"expFlightingTenantEnabled": true,
"exportDataEnabled": true,
"exportReportEnabled": true,
"exportToCsvEnabled": true,
"exportToExcelSettingEnabled": true,
"exportToImageEnabled": false,
"exportToMHTMLEnabled": true,
"exportToPowerPointEnabled": true,
"exportToWordEnabled": true,
"exportToXMLEnabled": true,
"exportUnderlyingDataEnabled": true,
"exportVisualImageTenantEnabled": true,
"externalSharingEnabled": true,
"externalSharingV2Enabled": true,
"hideWorkspaceV1WithoutContentEnabled": false,
"importExternalDataEnabled": true,
"installNonvalidatedTemplateAppsEnabled": false,
"installServiceAppsEnabled": true,
"isExportToExcelSeparatedFromExportDataEnabled": false,
"liveConnectionEnabled": true,
"logAnalyticsAttachForTenantEnabled": false,
"logAnalyticsAttachForWorkspaceAdminsEnabled": false,
"newLookAdminSettingEnabled": true,
"onPremAnalyzeInExcelEnabled": true,
"premiumCapacityTenantKeyManagementEnabled": false,
"printingEnabled": true,
"promoteContentEnabled": false,
"publishContentPackEnabled": true,
"publishToWebEnabled": true,
"qnaFeedbackLoopEnabled": true,
"restrictServiceOutboundFlowsEnabled": false,
"rScriptVisualEnabled": true,
"serviceAppSubscriptionsReportLinkEnabled": true,
"servicePrincipalAccessEnabled": false,
"shareToTeamsTenantEnabled": true,
"smartAlertsTenantEnabled": true,
"snowflakeSSOEnabled": false,
"storageAccountAttachForWorkspaceAdminsEnabled": false,
"templatePublishEnabled": false,
"tenantDisableCommentingEnabled": false,
"tenantSettingPublishGetHelpInfoEnabled": false,
"urlBookmarksTenantEnabled": true,
"usageMetricsEnabled": true,
"usageMetricsTrackUserLevelInfoEnabled": true,
"useDatasetsAcrossWorkspacesEnabled": true,
"webContentTilesTenantEnabled": true,
"csvContentProviderEnabled": true,
"sparkAppEnabled": true,
"sharePointEmbedEnabled": true,
"excelWorkbooksInContentPackEnabled": true,
"ffxlChartSelectionEnabled": true,
"closeAccountEnabled": true,
"salesforceAndOneDriveCredentialsEnabled": true,
"readOnlyGroupEnabled": true,
"anonymousEmbeddingEnabled": true,
"dashboardEmbedEnabled": true,
"scriptVisualEnabled": true,
"scriptVisualAnonymousEmbeddingEnabled": true,
"enterpriseGatewayEnabled": true,
"enterpriseGatewayETLEnabled": true,
"sharePointDocumentLibrariesEnabled": true,
"analyzeInExcelEnabled": true,
"analyzeInExcelSovereignFormatEnabled": true,
"dataClassificationEnabled": true,
"permissionCenterEnabled": true,
"insightsStoreEnabled": true,
"importPbiviz": true,
"exportReportToPowerPointEnabled": true,
"exportVisualToExcelEnabled": true,
"saasMarketplace": true,
"adminAuditingEnabled": true,
"socialSharingEnabled": true,
"esriEnabled": true,
"downloadReportEnabled": true,
"emailSubscriptionEnabled": true,
"isSovereignCloud": true,
"pivotTableVisualEnabled": true,
"directQueryScheduledRefresh": true,
"fullFidelityExcelEnabled": true,
"embedFullFidelityWorkbooks": true,
"ffxlLocalFilesEnabled": true,
"cloudRlsImpersonationEnabled": true,
"cloudRlsRoleMembershipEnabled": true,
"sandboxVisualsEnabled": true,
"oneGBUploadFileSizeEnabled": true,
"dynamicMessageEnabled": true,
"allUpSaveReport": true,
"serviceAppsEnabled": true,
"granularTenantControls": true,
"adminCapacityEnabled": true,
"datasetDownloadPbix": true,
"dashboardEmailSubscription": true,
"clientUsageMetricsEnabled": true,
"customVisualsUseStaticSandbox": true,
"groupCapacity": true,
"reportMeasures": true,
"binnedLineSampling": true,
"multipleODataPredicates": true,
"altTextForVisual": true,
"customVisuals": true,
"customVisualsStore": true,
"lineMarkersEnabled": true,
"onPremDirectQuerySingleSignOnForSql": true,
"onPremDirectQuerySingleSignOnForOracle": true,
"onPremDirectQuerySingleSignOnForSAP": true,
"onPremDirectQuerySingleSignOnForTeradata": true,
"whatIf": true,
"dataViewTargeted": true,
"lineStylesEnabled": true,
"overlappingPointsSampling": true,
"drillthrough": true,
"drillthroughText": true,
"canvasItemsPane": true,
"instantEmail": true,
"usageMetricsRetroactiveDisable": true,
"usageMetricsUpgrade": true,
"customCommands": true,
"slowDataSourceModeEnabled": true,
"capacitiesVCores": true,
"trackUserInfo": true,
"scatterWithDataVolume": true,
"loadBaseTheme": true,
"baseTheme": true,
"customVisualsGallery": true,
"capacitiesAzureTab": true,
"reportSharingUI": true,
"scatterXYGrouping": true,
"capacitiesMigrateSpecificWorkspaces": true,
"zOrder": true,
"dsrV2": true,
"slicerSyncing": true,
"workspacesV2": true,
"drillFilterOtherVisuals": true,
"stickyUserStateUI": true,
"customVisualsTenantSwitch": true,
"mapPointSampling": true,
"themeRelative": true,
"useBatchGeocoding": true,
"defaultSortMethodology": true,
"stickyUserStateUIThrottling": true,
"subscribeOthersUI": true,
"qnaPopout": true,
"paginatedReports": true,
"measureDrillthrough": true,
"htmlLegend": true,
"dashboardThemesUI": true,
"capacityMetricDrilldown": true,
"workspacesV2UnifiedGroups": true,
"cdsaFrontend": true,
"createAppWorkspaceSettingMigration": true,
"advancedSlicerSyncing": true,
"annotationsUI": true,
"urlBookmarksUI": true,
"appAccessRequestUI": true,
"spoIntegration": true,
"workspacesV2UsageMetrics": true,
"insightApps": true,
"comparisonODataPredicates": true,
"donutImprovements": true,
"stickyUserStateCustomViz": true,
"dateODataType": true,
"personalBookmarksUI": true,
"bookmarkGrouping": true,
"outspaceBackground": true,
"securePublishToWeb": true,
"nonAsciiODataNames": true,
"inODataPredicates": true,
"redlineAlignment": true,
"capacityWorkloads": true,
"onPremDirectQuerySingleSignOnForSapBw": true,
"cartesianConditionalFormatting": true,
"rdlReportSharingUI": true,
"lessIntrusiveNpsDialog": true,
"autoMlModelAuthoring": true,
"certifyDatasetsSetting": true,
"datasetPropertiesSection": true,
"allowExploreDatasetOfApp": true,
"exportExcelExcludeMeasures": true,
"exportDataMode": true,
"capacitySettingsTabs": true,
"reportAnnotationsUI": true,
"onPremDirectQuerySingleSignOnForSapBwMessageServer": true,
"rolloutCapacitiesList": true,
"capacityRestartButton": true,
"cdsaExperimentalConnectors": true,
"rdlReportPrint": true,
"keyDrivers": true,
"scheduledSubscriptionUI": true,
"sharedDatasetDiscovery": true,
"cdsaCDMFolderReferenceUI": true,
"optimizePublishToWeb": true,
"elevatedGuests": true,
"rdlReportJsonRplRenderer": true,
"cdsaSettingsTakeover": true,
"workloadMetrics": true,
"removeAuthoringToolSaveButton": true,
"dashboardB2BSharingWithRegularHost": true,
"servicePrincipalTenantAdminSettings": true,
"workspacesV2GA": true,
"cdsaSendEmailOnRefreshFailureUI": true,
"useModernFooter": true,
"useModernVisual": true,
"useVisualModern": true,
"useModernExploreCanvas": true,
"useModernExplorationContainer": true,
"exportReportToPdfEnabled": true,
"newLookUI": true,
"cdsaStorageAccountDetachUI": true,
"singleFilterPane": true,
"exprBoundVisualTitle": true,
"httpServiceModern": true,
"skipTestConnection": true,
"dataSourceVariablesOverride": true,
"defaultTooltipFormatting": true,
"axisInteractivity": true,
"helpAndSupportSettings": true,
"capacityBanner": true,
"copyReportsToWorkspacesV2": true,
"modernDashboard": true,
"cdsaEntitiesRelationships": true,
"removeDataflowPreviewTag": true,
"rdlReportInApps": true,
"userFavoriteResourcePackagesEnabled": true,
"showDataflowsInGetData": true,
"newDSCompInDataset": true,
"cdsaFastCombineDefaultOffFrontend": true,
"unreadAnnotationsBadge": true,
"addPreviewTagToAttachExternalDataflow": true,
"emailSubscriptionTenantAdminSettings": true,
"capacityWorkloadMemoryControls": true,
"queryCancellation": true,
"paginatedReportsSubscriptions": true,
"cdsaStorageUpdateMissingParamsUI": true,
"workspacesV2GAFeatures": true,
"keyDriverPaas": true,
"scheduledRefreshCCNotifications": true,
"keyDriversVisualColor": true,
"lineChartLabelPosition": true,
"exprBoundColors": true,
"adminBranding": true,
"tablixPreserveScrollFix": true,
"visualsOutsideNgZone": true,
"workspacesV2ViewerRole": true,
"tablixIcons": true,
"gaugeConditionalFormatting": true,
"visualHeaderTooltip": true,
"decompositionTree": true,
"stagingRdlInApps": true,
"exprBoundColorValidation": true,
"copyRdlReportToWorkspaceV2": true,
"visualLevelSlicerFilters": true,
"gatewayMultipleCredentials": true,
"gatewayMultipleCredentialsRDLReports": true,
"inlineExplore": true,
"tablixTotalLabel": true,
"allowFreeUsersToSubscribeInPremiumAppsUI": true,
"useModernLicenseStrategyService": true,
"allowEmailSecurityGroupsOnOutage": true,
"qnaVisual": true,
"dataSourceVariablesOverrideShared": true,
"playAxisDataColors": true,
"contactsSettingsList": true,
"disableExportDataOnVisualError": true,
"workspacesV2OptInUpgrade": true,
"workspacesV2OptInUpgradeButton": true,
"workspacesV2Downgrade": true,
"modernWebReportLoad": true,
"rdlReportInGlobalSearch": true,
"keyDriversCounting": true,
"useNewCY19SU06BaseTheme": true,
"paginatedReportsSqlAzureSSO": true,
"propertyEvaluationWarnings": true,
"skipTestConnectionOnPrem": true,
"sharedDataflowDiscoveryUI": true,
"enableSearchFilters": true,
"rdlReportAnnotationsUI": true,
"fluentListUI": true,
"modernFolderService": true,
"importJsonModel": true,
"realTimeRefresh": true,
"changeDetection": true,
"pipelines": true,
"externalConnectorSSO": true,
"themeTextStyles": true,
"keyDriversDetails": true,
"pbiMarketplace": true,
"tenantOutOfBoxVisualsEnabled": true,
"exprBoundBorderColor": true,
"exprBoundGaugeColors": true,
"exprBoundAltText": true,
"rdlSecureEmbed": true,
"promotedContentUI": true,
"artifactDescriptionsUI": true,
"personalVisualizationPaneEnabled": true,
"newUsageMetrics": true,
"rdlGenerateLinkUI": true,
"subscribeExternalUsers": true,
"queryApplicationContext": true,
"northStarBreadcrumb": true,
"narrativeTextbox": true,
"lazyAngularJSInfra": true,
"additionalKPISettings": true,
"disablePublishToWebCreation": true,
"exprBoundActions": true,
"modernDatasetDialog": true,
"hierarchicalSlicer": true,
"invitationHostDeprecation": true,
"useModernPromiseFactory": true,
"deprecateArchivedContent": true,
"InsightsContinuationTokens": true,
"insightsContinuationTokensUX": true,
"gradientLegend": true,
"conditionalTablixWebURL": true,
"lazyLoadLandingContainer": true,
"kerberosDqRefresh": true,
"directToMwc": true,
"forceMigrateNewFilterPane": true,
"copyVisualImage": true,
"qnaAngularMigration": true,
"adlsBasedModelTakeover": true,
"scopedAggregates": true,
"refreshCenterHistory": true,
"refreshCenterTimetable": true,
"visualDropShadow": true,
"navAndDrillthroughActionTypes": true,
"homeIsAngularOnly": true,
"manageMarketplaceVisuals": true,
"hideReportVerticalPane": true,
"optimizedAppMetadataForReportLanding": true,
"hierarchicalSlicerCreation": true,
"forceCapacityFolderAlmPipeline": true,
"useNewPhoneCanvasGrid": true,
"embedUseModernExplorationContainer": true,
"pbiRSKey": true,
"appNavGA": true,
"modernPackageRefreshListener": true,
"decompTreeBarsPerLevel": true,
"emailSubscriptionV2": true,
"instantEmailSubscriptionV2": true,
"tableMultiSort": true,
"allowSubscribingOnlyExternalUsers": true,
"decompTreeTooltipMeasure": true,
"decompositionTreeCoreVisual": true,
"visualInsights": true,
"totalsConditionalFormatting": true,
"o365LauncherV2": true,
"visualContainerLassoSelect": true,
"fluentTopLevelList": true,
"drillthroughButtonGA": true,
"allowGatewayForRDLWithCloudDS": true,
"cdsaGranularSQLUI": true,
"decompositionTreeCrossHighlight": true,
"decompositionTreeResponsiveLayout": true,
"categoricalDynamicFormatting": true,
"deleteSharedDatasetUi": true,
"rebindReportUi": true,
"almConsumerInfoVisibility": true,
"decompositionTreeConditionalFormat": true,
"d3v5": true,
"qnaPopoutModern": true,
"useExplicitParentTelemetry": true,
"configureAppContacts": true,
"allowContributorUpdateApp": true,
"fileExportPolling": true,
"freeTrialTenantSetting": true,
"dataPointLassoSelect": true,
"rdlAnaheimWebApp": true,
"personalizeVisualsPerspectives": true,
"lineChartExplicitDots": true,
"interactivityServiceOptimization": true,
"QnaDirectQuerySupport": true,
"QnaInterpretVersion": true,
"ShowQnaSettingForAllModels": true,
"anomalyDetection": true,
"stackedTotalDataLabels": true,
"increasedExportSectionLimit": true,
"exportHostErrorList": true,
"federatedSelectionManager": true,
"singlePageExports": true,
"blankCanvasWatermark": true,
"manageLicensesControl": true,
"granularExternalSharingControl": true,
"insightsPane": true,
"useModernVisualTypesContainer": true,
"homeBannerText": true,
"handleErrorOnQueryDataAPIThrottling": true,
"reportPagePanePositionSetting": true,
"newLookAdminSettingUI": true,
"qnaExport": true,
"axisZoom": true,
"databricksSSO": true,
"commonDataServiceSSO": true
}
}
@jalbertbowden
Copy link
Author

https://app.powerbigov.us/view?r=eyJrIjoiNDMwMDI0YmQtNmUyYS00ZmFjLWI0MGItZDM0OTY1Y2Y0YzNhIiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment