states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
70 rows where "dateModified" is on date 2020-03-13
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, hospitalizedCumulative, lastUpdateEt, dateModified, checkTimeEt, death, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, positiveIncrease, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateChecked (date)
Link | rowid ▼ | date | state | positive | negative | pending | totalTestResults | hospitalizedCurrently | hospitalizedCumulative | inIcuCurrently | inIcuCumulative | onVentilatorCurrently | onVentilatorCumulative | recovered | dataQualityGrade | lastUpdateEt | dateModified | checkTimeEt | death | hospitalized | dateChecked | totalTestsViral | positiveTestsViral | negativeTestsViral | positiveCasesViral | deathConfirmed | deathProbable | totalTestEncountersViral | totalTestsPeopleViral | totalTestsAntibody | positiveTestsAntibody | negativeTestsAntibody | totalTestsPeopleAntibody | positiveTestsPeopleAntibody | negativeTestsPeopleAntibody | totalTestsPeopleAntigen | positiveTestsPeopleAntigen | totalTestsAntigen | positiveTestsAntigen | fips | positiveIncrease | negativeIncrease | total | totalTestResultsSource | totalTestResultsIncrease | posNeg | deathIncrease | hospitalizedIncrease | hash | commercialScore | negativeRegularScore | negativeScore | positiveScore | score | grade |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10546 | 10546 | 20200322 | IN | 201 | 1293 | 1494 | 1 | 3/13/2020 00:59 | 2020-03-13T00:59:00Z | 03/12 20:59 | 6 | 1 | 2020-03-13T00:59:00Z | 18 | 75 | 586 | 1494 | posNeg | 661 | 1494 | 2 | 0 | 86f0cc71d1039d9646db64e659fa19e876b4337f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10921 | 10921 | 20200315 | AK | 1 | 143 | 144 | 3/13/2020 16:30 | 2020-03-13T16:30:00Z | 03/13 12:30 | 0 | 2020-03-13T16:30:00Z | 144 | 1 | 2 | 0 | 0 | 144 | posNeg | 0 | 144 | 0 | 0 | 8ccd28396c69c5d11e089da826bc82e814869e9e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10932 | 10932 | 20200315 | HI | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 09cbd692b373de9e0881bf7960a749433d5a1887 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10934 | 10934 | 20200315 | ID | 5 | 174 | 179 | 3/13/2020 22:45 | 2020-03-13T22:45:00Z | 03/13 18:45 | 2020-03-13T22:45:00Z | 179 | 16 | 3 | 0 | 179 | posNeg | 3 | 179 | 0 | 0 | 18300c62c893a07779a3c2f81fd55e38faa522ed | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10942 | 10942 | 20200315 | ME | 3 | 91 | 17 | 94 | 3/13/2020 14:00 | 2020-03-13T14:00:00Z | 03/13 10:00 | 2020-03-13T14:00:00Z | 3 | 23 | 0 | 0 | 111 | posNeg | 0 | 94 | 0 | 0 | c146dae0d3b95aff415b9d66c29dd099f487e5a1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10953 | 10953 | 20200315 | NM | 13 | 482 | 495 | 3/13/2020 13:00 | 2020-03-13T13:00:00Z | 03/13 09:00 | 2020-03-13T13:00:00Z | 35 | 3 | 245 | 495 | posNeg | 248 | 495 | 0 | 0 | 33d818a858c8c03846ab4fbf1032f75615487b22 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10972 | 10972 | 20200314 | AK | 1 | 143 | 144 | 3/13/2020 16:30 | 2020-03-13T16:30:00Z | 03/13 12:30 | 0 | 2020-03-13T16:30:00Z | 144 | 1 | 2 | 0 | 84 | 144 | posNeg | 84 | 144 | 0 | 0 | 10ebf2ed643f23916611d0cafaeca35813af10af | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10973 | 10973 | 20200314 | AL | 6 | 22 | 46 | 28 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 28 | 6 | 1 | 5 | 11 | 74 | posNeg | 16 | 28 | 0 | 0 | 97c1c03f3888551cdbddeb9a2ccaea2f8cf938d9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10974 | 10974 | 20200314 | AR | 12 | 65 | 26 | 77 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 77 | 12 | 5 | 3 | 35 | 103 | posNeg | 38 | 77 | 0 | 0 | 79cbdfd55040a4c57ffe3eb1be3c4ec9a9010cd2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10976 | 10976 | 20200314 | CA | 252 | 916 | 1168 | 3/13/2020 11:00 | 2020-03-13T11:00:00Z | 03/13 07:00 | 5 | 2020-03-13T11:00:00Z | 1168 | 6 | 50 | 0 | 1168 | posNeg | 50 | 1168 | 1 | 0 | b93372e78f3ce431424ddff15a98458162e300de | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10978 | 10978 | 20200314 | CT | 11 | 125 | 136 | 3/13/2020 16:00 | 2020-03-13T16:00:00Z | 03/13 12:00 | 2020-03-13T16:00:00Z | 9 | 5 | 26 | 136 | posNeg | 31 | 136 | 0 | 0 | 5adc07dbb5d9a159b0722754d0d81d779efb2cb1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10979 | 10979 | 20200314 | DC | 10 | 49 | 10 | 59 | 3/13/2020 19:00 | 2020-03-13T19:00:00Z | 03/13 15:00 | 2020-03-13T19:00:00Z | 59 | 11 | 0 | 29 | 69 | posNeg | 29 | 59 | 0 | 0 | 3cc56950394ed524de3e0d457a2ecdf351848a15 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10983 | 10983 | 20200314 | HI | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 105086157d7987b9e53ef719f5d160541fc58600 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10984 | 10984 | 20200314 | IA | 17 | 83 | 100 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 17 | 19 | 1 | 0 | 100 | posNeg | 1 | 100 | 0 | 0 | 8c7b9a78710019df9f55a3b01ec61806e83cc53e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10985 | 10985 | 20200314 | ID | 2 | 174 | 176 | 3/13/2020 22:45 | 2020-03-13T22:45:00Z | 03/13 18:45 | 2020-03-13T22:45:00Z | 176 | 16 | 2 | 43 | 176 | posNeg | 45 | 176 | 0 | 0 | 4a4e2bcb6abc15a890aa39e699a722f9b6a43df8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10986 | 10986 | 20200314 | IL | 46 | 316 | 82 | 362 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 17 | 14 | 22 | 444 | posNeg | 36 | 362 | 0 | 0 | 657af09832962e08870041f20b6e53d77bda3444 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10987 | 10987 | 20200314 | IN | 15 | 74 | 89 | 3/13/2020 23:59 | 2020-03-13T23:59:00Z | 03/13 19:59 | 0 | 2020-03-13T23:59:00Z | 18 | 3 | 13 | 89 | posNeg | 16 | 89 | 0 | 0 | 36436946a72a74ea14f8348fac022eac1c6bbfd1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10988 | 10988 | 20200314 | KS | 6 | 93 | 99 | 3/13/2020 11:00 | 2020-03-13T11:00:00Z | 03/13 07:00 | 1 | 2020-03-13T11:00:00Z | 20 | 0 | 0 | 99 | posNeg | 0 | 99 | 1 | 0 | 5ca38b230373445b8d08bbde91bd73100147a82a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10989 | 10989 | 20200314 | KY | 14 | 139 | 153 | 3/13/2020 17:00 | 2020-03-13T17:00:00Z | 03/13 13:00 | 1 | 2020-03-13T17:00:00Z | 153 | 21 | 3 | 32 | 153 | posNeg | 35 | 153 | 1 | 0 | 76cc46fa8101daf419ded217b2cd66fadde25f30 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10993 | 10993 | 20200314 | ME | 3 | 91 | 17 | 94 | 3/13/2020 14:00 | 2020-03-13T14:00:00Z | 03/13 10:00 | 2020-03-13T14:00:00Z | 3 | 23 | 0 | 0 | 111 | posNeg | 0 | 94 | 0 | 0 | a21bb8b2093f815119be425ebe398075383c0610 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10994 | 10994 | 20200314 | MI | 1728 | 205 | 26 | 1933 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 1717 | 0 | 1 | 26 | 367 | 72 | 1959 | posNeg | 439 | 1933 | 0 | 0 | f04a52bc78ea21e2eeb1bae6bfd76e3fc0f9dbda | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10996 | 10996 | 20200314 | MO | 4 | 90 | 94 | 3/13/2020 18:10 | 2020-03-13T18:10:00Z | 03/13 14:10 | 0 | 2020-03-13T18:10:00Z | 115 | 12 | 102 | 4 | 29 | 2 | 19 | 94 | posNeg | 21 | 94 | 0 | 0 | cd8377c11bcc300e6afbb877bed925f3aadc9209 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10997 | 10997 | 20200314 | MS | 6 | 84 | 90 | 3/13/2020 18:35 | 2020-03-13T18:35:00Z | 03/13 14:35 | 2020-03-13T18:35:00Z | 28 | 2 | 43 | 90 | posNeg | 45 | 90 | 0 | 0 | 5095164e89acd9d4455878b4c2ce45b9844f941b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10998 | 10998 | 20200314 | MT | 5 | 103 | 108 | 3/13/2020 19:00 | 2020-03-13T19:00:00Z | 03/13 15:00 | 2020-03-13T19:00:00Z | 30 | 4 | 48 | 108 | posNeg | 52 | 108 | 0 | 0 | 1797379e65bf8fbe83b4a1159824e19ed2a1aff7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11000 | 11000 | 20200314 | ND | 1 | 54 | 14 | 50 | 3/13/2020 13:00 | 2020-03-13T13:00:00Z | 03/13 09:00 | 0 | 2020-03-13T13:00:00Z | 63 | 1 | 50 | 49 | 38 | 0 | 15 | 69 | totalTestEncountersViral | 21 | 55 | 0 | 0 | a1bb16a2e7397906e581a203403aeceb1b26560f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11001 | 11001 | 20200314 | NE | 14 | 80 | 33 | 94 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 31 | 1 | 0 | 127 | posNeg | 1 | 94 | 0 | 0 | f2b5c97e72407c12721a8f0d4f49e46ea8a06a58 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11003 | 11003 | 20200314 | NJ | 50 | 97 | 80 | 147 | 3/13/2020 14:00 | 2020-03-13T14:00:00Z | 03/13 10:00 | 1 | 2020-03-13T14:00:00Z | 78 | 1 | 0 | 147 | 34 | 0 | 0 | 227 | posNeg | 0 | 147 | 0 | 0 | 3f964f911f23d7cd8e41afffb64bc54312b4d409 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11004 | 11004 | 20200314 | NM | 10 | 237 | 247 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 35 | 0 | 47 | 247 | posNeg | 47 | 247 | 0 | 0 | 3addeed5e708a9c832e1dd62118100dfca58e7cd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11007 | 11007 | 20200314 | OH | 13 | 50 | 159 | 63 | 3/13/2020 14:00 | 2020-03-13T14:00:00Z | 03/13 10:00 | 2020-03-13T14:00:00Z | 13 | 39 | 0 | 0 | 222 | posNeg | 0 | 63 | 0 | 0 | b6ca6514f3f7955c892e3ebbcae563a892c9edec | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11008 | 11008 | 20200314 | OK | 4 | 36 | 37 | 40 | 3/13/2020 22:30 | 2020-03-13T22:30:00Z | 03/13 18:30 | 2020-03-13T22:30:00Z | 40 | 1 | 0 | 77 | posNeg | 1 | 40 | 0 | 0 | 24db8b844c8d21975ab9da653ebf8a54595b0e2f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11009 | 11009 | 20200314 | OR | 30 | 337 | 157 | 367 | 3/13/2020 13:00 | 2020-03-13T13:00:00Z | 03/13 09:00 | 2020-03-13T13:00:00Z | 41 | 0 | 0 | 524 | posNeg | 0 | 367 | 0 | 0 | 446fd0bfab03fdccfcea07bdee4a062677597b77 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11012 | 11012 | 20200314 | SC | 13 | 110 | 123 | 3/13/2020 17:47 | 2020-03-13T17:47:00Z | 03/13 13:47 | 2020-03-13T17:47:00Z | 13 | 45 | 1 | 35 | 123 | posNeg | 36 | 123 | 0 | 0 | 1c9efc3f7ca182cab4b44bcd4ff8df6aee282d28 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11016 | 11016 | 20200314 | UT | 6 | 131 | 137 | 3/13/2020 15:00 | 2020-03-13T15:00:00Z | 03/13 11:00 | 2020-03-13T15:00:00Z | 6 | 49 | 0 | 0 | 137 | posNeg | 0 | 137 | 0 | 0 | 2c6adc322b7778ab316762e6f617ea3516cfae4f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11017 | 11017 | 20200314 | VA | 30 | 117 | 6680 | 3/13/2020 11:00 | 2020-03-13T11:00:00Z | 03/13 07:00 | 2020-03-13T11:00:00Z | 2098 | 6680 | 51 | 0 | 0 | 147 | posNeg | 79 | 147 | 0 | 0 | 8a371d4221b325516ce2928cd5a5e8f34fa0552c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11020 | 11020 | 20200314 | WI | 23 | 169 | 192 | 3/13/2020 15:00 | 2020-03-13T15:00:00Z | 03/13 11:00 | 2020-03-13T15:00:00Z | 19 | 55 | 0 | 0 | 192 | posNeg | 0 | 192 | 0 | 0 | 58f7f93d14cc95a887eeb639944de20cfd87e8b3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11021 | 11021 | 20200314 | WV | 0 | 26 | 5 | 26 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 0 | 54 | 0 | 9 | 31 | posNeg | 9 | 26 | 0 | 0 | 816f5b0cc9e3122e90d49f399018b14d64fdc139 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11022 | 11022 | 20200314 | WY | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 2 | 56 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 8d9d3ca4720cc8639b78c55ddcf27eb1b3337f3e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11023 | 11023 | 20200313 | AK | 1 | 59 | 60 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 0 | 2020-03-13T00:00:00Z | 60 | 1 | 2 | 1 | 13 | 60 | posNeg | 14 | 60 | 0 | 0 | 81b200d0a2e921ebb671f691670151352497e0d9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
11024 | 11024 | 20200313 | AL | 1 | 11 | 12 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 12 | 1 | 1 | 1 | 1 | 12 | posNeg | 2 | 12 | 0 | 0 | 5cef75e1fb829312ce63bccb212137c19b2a012b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11025 | 11025 | 20200313 | AR | 9 | 30 | 22 | 39 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 39 | 9 | 5 | 3 | 6 | 61 | posNeg | 9 | 39 | 0 | 0 | 6be8ef3b41ad4c59da0992534ff3f91364b3728d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
11026 | 11026 | 20200313 | AZ | 9 | 94 | 40 | 103 | 22 | 3/13/2020 12:01 | 2020-03-13T12:01:00Z | 03/13 08:01 | 0 | 22 | 2020-03-13T12:01:00Z | 103 | 4 | 0 | 12 | 143 | posNeg | 12 | 103 | 0 | 6 | 99c40024f87e9dabb93557d1895600d87f4faa5a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
11028 | 11028 | 20200313 | CO | 72 | 524 | 198 | 3/13/2020 14:00 | 2020-03-13T14:00:00Z | 03/13 10:00 | 2020-03-13T14:00:00Z | 198 | 8 | 27 | 226 | 596 | totalTestEncountersViral | 128 | 596 | 0 | 0 | 472c7b801c6136e05ba55c6aa357d46447247473 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11032 | 11032 | 20200313 | FL | 50 | 478 | 221 | 528 | 3/13/2020 13:53 | 2020-03-13T13:53:00Z | 03/13 09:53 | 2 | 2020-03-13T13:53:00Z | 12 | 18 | 177 | 749 | posNeg | 195 | 528 | 0 | 0 | 0ec56d07d095eee6303081d04bb1d26ae8918001 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11033 | 11033 | 20200313 | GA | 42 | 42 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 1 | 2020-03-13T00:00:00Z | 42 | 13 | 11 | 0 | 42 | posNeg | 11 | 42 | 1 | 0 | 929ebe15aebea765312e0303b6d64f2aaec252b4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11036 | 11036 | 20200313 | ID | 0 | 131 | 131 | 3/13/2020 08:00 | 2020-03-13T08:00:00Z | 03/13 04:00 | 2020-03-13T08:00:00Z | 131 | 16 | 0 | 38 | 131 | posNeg | 38 | 131 | 0 | 0 | a250ee2c8a32a9617b24f0aa5d4c92ce60c6190e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11039 | 11039 | 20200313 | KS | 6 | 93 | 99 | 3/13/2020 11:00 | 2020-03-13T11:00:00Z | 03/13 07:00 | 2020-03-13T11:00:00Z | 20 | 2 | 52 | 99 | posNeg | 54 | 99 | 0 | 0 | 2dccaac74ba5b8f85966a1fe98cbc91bc87cdd94 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11041 | 11041 | 20200313 | LA | 36 | 37 | 73 | 3/13/2020 16:00 | 2020-03-13T16:00:00Z | 03/13 12:00 | 2020-03-13T16:00:00Z | 36 | 22 | 22 | 0 | 73 | posNeg | 22 | 73 | 0 | 0 | 7419b63707d96e0586b0db5c188407b84285b3ca | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11042 | 11042 | 20200313 | MA | 23 | 2101 | 3/13/2020 16:00 | 2020-03-13T16:00:00Z | 03/13 12:00 | 2020-03-13T16:00:00Z | 2101 | 234 | 25 | 15 | 0 | 23 | totalTestsViral | 985 | 23 | 0 | 0 | dba1a4f4df634716856b361ccca691eca066ce31 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11043 | 11043 | 20200313 | MD | 17 | 94 | 111 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 17 | 24 | 5 | 0 | 111 | posNeg | 5 | 111 | 0 | 0 | 8152c27b65b6b3e8c0fae3732f606c12bac2c405 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11044 | 11044 | 20200313 | ME | 3 | 91 | 17 | 94 | 3/13/2020 14:00 | 2020-03-13T14:00:00Z | 03/13 10:00 | 2020-03-13T14:00:00Z | 3 | 23 | 2 | 26 | 111 | posNeg | 28 | 94 | 0 | 0 | de2ca0d6d03d2e25627e17af0f1355894c2d1e7b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11045 | 11045 | 20200313 | MI | 1361 | 133 | 26 | 1494 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 1353 | 0 | 1 | 26 | 364 | 42 | 1520 | posNeg | 406 | 1494 | 0 | 0 | 05224e61f3e0a99bf9444cc26350cdf228529371 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11046 | 11046 | 20200313 | MN | 62 | 541 | 603 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 62 | 603 | 27 | 19 | 234 | 603 | posNeg | 253 | 603 | 0 | 0 | e9f5677834cecf7c5edcd6e0fb70ed74f059bb04 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11050 | 11050 | 20200313 | NC | 15 | 86 | 101 | 3/13/2020 08:45 | 2020-03-13T08:45:00Z | 03/13 04:45 | 2020-03-13T08:45:00Z | 37 | 3 | 26 | 101 | posNeg | 29 | 101 | 0 | 0 | 0b914cb2eef80ba4d7f56fb7117d22a14f3b3a05 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11051 | 11051 | 20200313 | ND | 1 | 39 | 12 | 29 | 3/13/2020 13:00 | 2020-03-13T13:00:00Z | 03/13 09:00 | 0 | 2020-03-13T13:00:00Z | 40 | 1 | 29 | 28 | 38 | 0 | 27 | 52 | totalTestEncountersViral | 12 | 40 | 0 | 0 | bbf3598267e33d0bc2002aec6964c33f651138fd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11052 | 11052 | 20200313 | NE | 13 | 80 | 33 | 93 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 31 | 3 | 0 | 126 | posNeg | 3 | 93 | 0 | 0 | 58565cf78af90a9e1629b071b6a4681fcdfc22a8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11054 | 11054 | 20200313 | NJ | 50 | 97 | 80 | 147 | 3/13/2020 14:00 | 2020-03-13T14:00:00Z | 03/13 10:00 | 1 | 2020-03-13T14:00:00Z | 57 | 1 | 0 | 147 | 34 | 20 | 23 | 227 | posNeg | 43 | 147 | 0 | 0 | 190d16cc5f37fd1b417fa5f4e0f5cba6e14d033a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11058 | 11058 | 20200313 | OH | 13 | 50 | 159 | 63 | 3/13/2020 15:00 | 2020-03-13T15:00:00Z | 03/13 11:00 | 2020-03-13T15:00:00Z | 13 | 39 | 8 | 20 | 222 | posNeg | 28 | 63 | 0 | 0 | fad12f0c5e6050069d6c8efac5d8a4fdf56048ae | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11059 | 11059 | 20200313 | OK | 3 | 36 | 37 | 39 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 40 | 0 | 0 | 76 | posNeg | 0 | 39 | 0 | 0 | 10b29e63c2bc64f3e748be4708d8dc3755a5c826 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11060 | 11060 | 20200313 | OR | 30 | 337 | 157 | 367 | 3/13/2020 13:00 | 2020-03-13T13:00:00Z | 03/13 09:00 | 2020-03-13T13:00:00Z | 41 | 11 | 51 | 524 | posNeg | 62 | 367 | 0 | 0 | 4699438ff93e16f83317cdef2c78608a47a196b2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11061 | 11061 | 20200313 | PA | 41 | 140 | 130 | 181 | 3/13/2020 15:30 | 2020-03-13T15:30:00Z | 03/13 11:30 | 2020-03-13T15:30:00Z | 181 | 42 | 19 | 24 | 311 | posNeg | 43 | 181 | 0 | 0 | e110ffa4d972ab419f7e4a40ded46785d950a0cf | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11062 | 11062 | 20200313 | RI | 19 | 224 | 29 | 201 | 3/13/2020 03:00 | 2020-03-13T03:00:00Z | 03/12 23:00 | 2020-03-13T03:00:00Z | 257 | 21 | 236 | 19 | 201 | 243 | 44 | 6 | 48 | 272 | totalTestEncountersViral | 51 | 243 | 0 | 0 | f60cfe4fda290b6a63a3be524e29306d87010bc4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
11064 | 11064 | 20200313 | SD | 9 | 73 | 11 | 82 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 82 | 46 | 1 | 46 | 93 | posNeg | 47 | 82 | 0 | 0 | a93c350d7ba78a582bb535ecdd66152bb2cc93fa | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11065 | 11065 | 20200313 | TN | 26 | 116 | 142 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 47 | 8 | 37 | 142 | posNeg | 45 | 142 | 0 | 0 | 0394b9dde8962fcdab58e032defa15e41982e073 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11066 | 11066 | 20200313 | TX | 39 | 39 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 39 | 48 | 16 | 0 | 39 | posNeg | 16 | 39 | 0 | 0 | 89daff6981d900f5eb3da22dbc1d3e7aa7995235 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11067 | 11067 | 20200313 | UT | 6 | 131 | 137 | 3/13/2020 15:00 | 2020-03-13T15:00:00Z | 03/13 11:00 | 2020-03-13T15:00:00Z | 6 | 49 | 2 | 0 | 137 | posNeg | 2 | 137 | 0 | 0 | 568f036310f8825f5bc2f17a1a9beb21ddb57d7c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11068 | 11068 | 20200313 | VA | 30 | 117 | 6601 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 2095 | 6601 | 51 | 13 | 0 | 147 | posNeg | 85 | 147 | 0 | 0 | fb288a517905e6de8ad930f4da366ec5cc8d5301 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11069 | 11069 | 20200313 | VT | 5 | 223 | 228 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 50 | 3 | 87 | 228 | posNeg | 90 | 228 | 0 | 0 | 3b8623419424db6ccca1aa9bf84db3d9fc0e4d85 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11070 | 11070 | 20200313 | WA | 1018 | 14922 | 15940 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 47 | 2020-03-13T00:00:00Z | 1018 | 15940 | 15603 | 53 | 217 | 4109 | 15940 | posNeg | 4326 | 15940 | 3 | 0 | dff25eeca224ff30cbf017f7c391cf188ce2c0de | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11071 | 11071 | 20200313 | WI | 23 | 169 | 192 | 3/13/2020 15:00 | 2020-03-13T15:00:00Z | 03/13 11:00 | 2020-03-13T15:00:00Z | 19 | 55 | 14 | 85 | 192 | posNeg | 99 | 192 | 0 | 0 | 192f863b827358b9c3528749543ec1ebed79877e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11072 | 11072 | 20200313 | WV | 0 | 17 | 4 | 17 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 0 | 54 | 0 | 10 | 21 | posNeg | 10 | 17 | 0 | 0 | 1ebda648c633a00696ce290643b20eb8146381ab | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_daily_4pm_et] ( [date] INTEGER, [state] TEXT, [positive] INTEGER, [negative] INTEGER, [pending] TEXT, [totalTestResults] INTEGER, [hospitalizedCurrently] TEXT, [hospitalizedCumulative] TEXT, [inIcuCurrently] TEXT, [inIcuCumulative] TEXT, [onVentilatorCurrently] TEXT, [onVentilatorCumulative] TEXT, [recovered] TEXT, [dataQualityGrade] TEXT, [lastUpdateEt] TEXT, [dateModified] TEXT, [checkTimeEt] TEXT, [death] INTEGER, [hospitalized] TEXT, [dateChecked] TEXT, [totalTestsViral] TEXT, [positiveTestsViral] TEXT, [negativeTestsViral] TEXT, [positiveCasesViral] TEXT, [deathConfirmed] TEXT, [deathProbable] TEXT, [totalTestEncountersViral] TEXT, [totalTestsPeopleViral] TEXT, [totalTestsAntibody] TEXT, [positiveTestsAntibody] TEXT, [negativeTestsAntibody] TEXT, [totalTestsPeopleAntibody] TEXT, [positiveTestsPeopleAntibody] TEXT, [negativeTestsPeopleAntibody] TEXT, [totalTestsPeopleAntigen] TEXT, [positiveTestsPeopleAntigen] TEXT, [totalTestsAntigen] TEXT, [positiveTestsAntigen] TEXT, [fips] INTEGER, [positiveIncrease] INTEGER, [negativeIncrease] INTEGER, [total] INTEGER, [totalTestResultsSource] TEXT, [totalTestResultsIncrease] INTEGER, [posNeg] INTEGER, [deathIncrease] INTEGER, [hospitalizedIncrease] INTEGER, [hash] TEXT, [commercialScore] INTEGER, [negativeRegularScore] INTEGER, [negativeScore] INTEGER, [positiveScore] INTEGER, [score] INTEGER, [grade] TEXT );