<pack :service-config='' :time-zone='' :workspace='' access_mode='readonly' authentication='auth-none' author-locale='en_US' class='hyper' dbname='Data/tableau-temp/TEMP_18sxeys1l8ow251fk0i6i0buwcvn.hyper' default-settings='yes' ec-data-ts='2124651686290000' ec-logical-query='&lt;logical-query-extended-cache-key&gt;&#10;&lt;relation-xml&gt;&amp;lt;relations&amp;gt;&amp;#10;  &amp;lt;relation connection=&amp;apos;conn1&amp;apos;&amp;gt;&amp;#10;    &amp;lt;relation name=&amp;apos;Extract&amp;apos; table=&amp;apos;[Extract].[Extract]&amp;apos; type=&amp;apos;table&amp;apos; /&amp;gt;&amp;#10;    &amp;lt;is-not-distinct-join-semantics&amp;gt;false&amp;lt;/is-not-distinct-join-semantics&amp;gt;&amp;#10;  &amp;lt;/relation&amp;gt;&amp;#10;&amp;lt;/relations&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10;&lt;logical-query&gt;&#10;&lt;selects&gt;&#10;&lt;field&gt;[Calculation_4096938708093771779]&lt;/field&gt;&#10;&lt;field&gt;[PATIENT_COUNTY]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(Calculation_1047368445586305025)(1791449825)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(Calculation_5849331522079748098)(3272637736)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:Calculation_1331939630305484800:ok)(3655532646)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:Calculation_1331939630305484800:ok)(3956863597)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:Calculation_4096938708094570500:nk)(373729966)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:Calculation_4096938708094570500:nk)(992781555)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:Calculation_5563493683036377089:nk)(620277131)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:Calculation_5563493683036377089:nk)(679694725)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:DATA_REFRESH_DT:ok)(2698766023)(0)]&lt;/field&gt;&#10;&lt;field&gt;[TEMP(attr:DATA_REFRESH_DT:ok)(274201900)(0)]&lt;/field&gt;&#10;&lt;field&gt;[max:Timestamp (copy)_3620542288481976321:ok]&lt;/field&gt;&#10;&lt;field&gt;[min:Timestamp (copy)_3620542288481976321:ok]&lt;/field&gt;&#10;&lt;field&gt;[sum:HOSPITALIZATIONS:ok]&lt;/field&gt;&#10;&lt;field&gt;[sum:RECOVERIES:ok]&lt;/field&gt;&#10;&lt;field&gt;[usr:Calculation_5563493683036119040:ok]&lt;/field&gt;&#10;&lt;field&gt;[usr:Calculation_5849331522079748098:ok]&lt;/field&gt;&#10;&lt;/selects&gt;&#10;&lt;dictionaryOp class=&apos;logical-operator&apos;&gt;&#10;&lt;bindings&gt;&#10;&lt;binding ref=&apos;1&apos;&gt;&#10;&lt;relationOp class=&apos;logical-operator&apos; connection=&apos;conn1&apos; name=&apos;[Extract].[Extract]&apos;&gt;&#10;&lt;relation name=&apos;Extract&apos; type=&apos;table&apos; /&gt;&#10;&lt;cols&gt;&#10;&lt;/cols&gt;&#10;&lt;type&gt;&#10;&lt;schema&gt;&#10;&lt;field name=&apos;[2018_POP]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[CASES]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[DATA_AS_OF_DT]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[DATA_REFRESH_DT]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[DEATHS]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[HOSPITALIZATIONS]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[INV_CASE_STATUS]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[LATEST_STATUS_DATE]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[PATIENT_COUNTY]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[RECOVERIES]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;/schema&gt;&#10;&lt;/type&gt;&#10;&lt;/relationOp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding ref=&apos;2&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;MAX&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[DATA_REFRESH_DT]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding ref=&apos;3&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;SUM&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;caseExp class=&apos;logical-expression&apos;&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;boolean&apos; value=&apos;true&apos; /&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;==&apos; shape=&apos;scalar&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[PATIENT_COUNTY]&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LEN_RUS_S2&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;Unknown&amp;quot;&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[CASES]&apos; /&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;integer&apos; value=&apos;%null%&apos; /&gt;&#10;&lt;/caseExp&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding ref=&apos;4&apos;&gt;&#10;&lt;caseExp class=&apos;logical-expression&apos;&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;boolean&apos; value=&apos;true&apos; /&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;$IN_SET$&apos; shape=&apos;scalar&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[PATIENT_COUNTY]&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LEN_RUS_S2&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;Androscoggin&amp;quot;&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LEN_RUS_S2&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;Cumberland&amp;quot;&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LEN_RUS_S2&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;Penobscot&amp;quot;&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LEN_RUS_S2&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;York&amp;quot;&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;boolean&apos; value=&apos;true&apos; /&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;boolean&apos; value=&apos;false&apos; /&gt;&#10;&lt;/caseExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding ref=&apos;5&apos;&gt;&#10;&lt;caseExp class=&apos;logical-expression&apos;&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;boolean&apos; value=&apos;true&apos; /&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;4&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;Community transmission detected&amp;quot;&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;Community transmission not detected&amp;quot;&apos; /&gt;&#10;&lt;/caseExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding ref=&apos;6&apos;&gt;&#10;&lt;caseExp class=&apos;logical-expression&apos;&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;boolean&apos; value=&apos;true&apos; /&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;==&apos; shape=&apos;scalar&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[$temp1_import]&apos; /&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;integer&apos; value=&apos;1&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;case&amp;quot;&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;cases&amp;quot;&apos; /&gt;&#10;&lt;/caseExp&gt;&#10;&lt;/binding&gt;&#10;&lt;/bindings&gt;&#10;&lt;projectOp class=&apos;logical-operator&apos;&gt;&#10;&lt;expressions&gt;&#10;&lt;binding name=&apos;[Calculation_4096938708093771779]&apos;&gt;&#10;&lt;caseExp class=&apos;logical-expression&apos;&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;boolean&apos; value=&apos;true&apos; /&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;4&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;•&amp;quot;&apos; /&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;%null%&apos; /&gt;&#10;&lt;/caseExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[PATIENT_COUNTY]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[PATIENT_COUNTY]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(Calculation_5849331522079748098)(3272637736)(0)]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[__measure__1]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:Calculation_1331939630305484800:ok)(3655532646)(0)]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[$temp0_import]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:Calculation_1331939630305484800:ok)(3956863597)(0)]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[$temp0_import]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:Calculation_4096938708094570500:nk)(373729966)(0)]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;5&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:Calculation_4096938708094570500:nk)(992781555)(0)]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;5&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:Calculation_5563493683036377089:nk)(620277131)(0)]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;6&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:Calculation_5563493683036377089:nk)(679694725)(0)]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;6&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[usr:Calculation_5849331522079748098:ok]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[__measure__1]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/expressions&gt;&#10;&lt;joinOp assume-ri=&apos;true&apos; class=&apos;logical-operator&apos; join=&apos;inner&apos; join-constraints=&apos;none&apos;&gt;&#10;&lt;aggregateOp class=&apos;logical-operator&apos;&gt;&#10;&lt;measures&gt;&#10;&lt;binding name=&apos;[TEMP(Calculation_1047368445586305025)(1791449825)(0)]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;SUM&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[CASES]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:DATA_REFRESH_DT:ok)(2698766023)(0)]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;2&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[TEMP(attr:DATA_REFRESH_DT:ok)(274201900)(0)]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;MIN&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[DATA_REFRESH_DT]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[__measure__1]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;MAX&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[2018_POP]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[max:Timestamp (copy)_3620542288481976321:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;MAX&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[LATEST_STATUS_DATE]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[min:Timestamp (copy)_3620542288481976321:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;MIN&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[LATEST_STATUS_DATE]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[sum:HOSPITALIZATIONS:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;SUM&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[HOSPITALIZATIONS]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[sum:RECOVERIES:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;SUM&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[RECOVERIES]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[usr:Calculation_5563493683036119040:ok]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;3&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/measures&gt;&#10;&lt;groupbys&gt;&#10;&lt;binding name=&apos;[PATIENT_COUNTY]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[PATIENT_COUNTY]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/groupbys&gt;&#10;&lt;referenceOp class=&apos;logical-operator&apos; ref=&apos;1&apos; /&gt;&#10;&lt;/aggregateOp&gt;&#10;&lt;aggregateOp class=&apos;logical-operator&apos;&gt;&#10;&lt;measures&gt;&#10;&lt;binding name=&apos;[__measure__2]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;2&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[__measure__3]&apos;&gt;&#10;&lt;referenceExp class=&apos;logical-expression&apos; ref=&apos;3&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/measures&gt;&#10;&lt;groupbys&gt;&#10;&lt;/groupbys&gt;&#10;&lt;referenceOp class=&apos;logical-operator&apos; ref=&apos;1&apos; /&gt;&#10;&lt;/aggregateOp&gt;&#10;&lt;conditions&gt;&#10;&lt;/conditions&gt;&#10;&lt;imports&gt;&#10;&lt;binding name=&apos;[$temp0_import]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;DATEADD&apos; shape=&apos;scalar&apos;&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;minute&amp;quot;&apos; /&gt;&#10;&lt;literalExp class=&apos;logical-expression&apos; datatype=&apos;integer&apos; value=&apos;-1&apos; /&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[__measure__2]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[$temp1_import]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[__measure__3]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/imports&gt;&#10;&lt;/joinOp&gt;&#10;&lt;/projectOp&gt;&#10;&lt;/dictionaryOp&gt;&#10;&lt;/logical-query&gt;&#10;&lt;/logical-query-extended-cache-key&gt;&#10;' schema='Extract' sslmode='' updated-database='/var/folders/y6/mrljv2f12c56x4bmwb18gr8h0000gp/T/tableau-temp/1436114862/Data/Extracts/federated_0f8bqj80p60onn11aok3q0.hyper' username='tableau_internal_user'>
</pack>
