states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
20,444 rows sorted by positive
This data as json, copyable, CSV (advanced)
Link | rowid | date | state | positive ▼ | probableCases | negative | pending | totalTestResultsSource | totalTestResults | hospitalizedCurrently | hospitalizedCumulative | inIcuCurrently | inIcuCumulative | onVentilatorCurrently | onVentilatorCumulative | recovered | lastUpdateEt | dateModified | checkTimeEt | death | hospitalized | hospitalizedDischarged | dateChecked | totalTestsViral | positiveTestsViral | negativeTestsViral | positiveCasesViral | deathConfirmed | deathProbable | totalTestEncountersViral | totalTestsPeopleViral | totalTestsAntibody | positiveTestsAntibody | negativeTestsAntibody | totalTestsPeopleAntibody | positiveTestsPeopleAntibody | negativeTestsPeopleAntibody | totalTestsPeopleAntigen | positiveTestsPeopleAntigen | totalTestsAntigen | positiveTestsAntigen | fips | positiveIncrease | negativeIncrease | total | totalTestResultsIncrease | posNeg | dataQualityGrade | deathIncrease | hospitalizedIncrease | hash | commercialScore | negativeRegularScore | negativeScore | positiveScore | score | grade |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18820 | 18820 | 20200330 | AS | totalTestsViral | 0 | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 0 | 2020-03-30T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 004b816ef91f35a4f320acec34f4ffce5b0209e7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
18876 | 18876 | 20200329 | AS | totalTestsViral | 0 | 3/27/2020 00:00 | 2020-03-27T00:00:00Z | 03/26 20:00 | 0 | 2020-03-27T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | e6490668178ef8846522fe1f268dd4cece97d769 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
18932 | 18932 | 20200328 | AS | totalTestsViral | 0 | 3/27/2020 00:00 | 2020-03-27T00:00:00Z | 03/26 20:00 | 0 | 2020-03-27T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | d376dc211ae901978e8d510d5db4b38600060c9e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
18988 | 18988 | 20200327 | AS | totalTestsViral | 0 | 3/27/2020 00:00 | 2020-03-27T00:00:00Z | 03/26 20:00 | 0 | 2020-03-27T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 6968e97c902983203b86e90f6d220ad67e81e3c5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19044 | 19044 | 20200326 | AS | totalTestsViral | 0 | 3/25/2020 00:00 | 2020-03-25T00:00:00Z | 03/24 20:00 | 0 | 2020-03-25T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 1f24a7f5f860eb0ba5d7cbdce87460c518410f95 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19100 | 19100 | 20200325 | AS | totalTestsViral | 0 | 3/25/2020 00:00 | 2020-03-25T00:00:00Z | 03/24 20:00 | 0 | 2020-03-25T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 869869a7db5b3f212191de5a60aa579d73cb0c6b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19156 | 19156 | 20200324 | AS | totalTestsViral | 0 | 3/24/2020 00:00 | 2020-03-24T00:00:00Z | 03/23 20:00 | 0 | 2020-03-24T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | f4a7693ca5532bca18ab2b406c2c245dad114038 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19212 | 19212 | 20200323 | AS | totalTestsViral | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | fc7ff8caf7fd20894021989993c3105f53c838ad | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19268 | 19268 | 20200322 | AS | totalTestsViral | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | c0fea22e3489a826d672a09734da086bf8680c52 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19324 | 19324 | 20200321 | AS | totalTestsViral | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 8b6bc7ea7d121617e510347c3adf17cf5df9dd4e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19380 | 19380 | 20200320 | AS | totalTestsViral | 0 | 3/19/2020 00:00 | 2020-03-19T00:00:00Z | 03/18 20:00 | 0 | 2020-03-19T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 898e11bf19ea5866a2170aa7e7d72928b45a8d1c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19436 | 19436 | 20200319 | AS | totalTestsViral | 0 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 0 | 2020-03-14T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 96ce3dd33249d94d05a920e5bd643bc1fcecf327 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19492 | 19492 | 20200318 | AS | totalTestsViral | 0 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 0 | 2020-03-14T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | b00fe019a68d6a6c3a0babcbfcb5409459705c32 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19548 | 19548 | 20200317 | AS | totalTestsViral | 0 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 2020-03-14T00:00:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | f578f0c81b40ba90e20d10dbbd3fb50e46f004d6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19601 | 19601 | 20200316 | AK | totalTestsViral | 144 | 1 | 3/16/2020 15:06 | 2020-03-16T15:06:00Z | 03/16 11:06 | 0 | 1 | 2020-03-16T15:06:00Z | 144 | 2 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 28d01bd157bf2a795abfa7b8391da75b973b744a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19604 | 19604 | 20200316 | AS | totalTestsViral | 0 | 3/16/2020 15:54 | 2020-03-16T15:54:00Z | 03/16 11:54 | 2020-03-16T15:54:00Z | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 45005046b1cb3f9d45947915fb45806aff13e095 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19657 | 19657 | 20200315 | AK | totalTestsViral | 144 | 1 | 3/13/2020 16:30 | 2020-03-13T16:30:00Z | 03/13 12:30 | 0 | 1 | 2020-03-13T16:30:00Z | 144 | 2 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | ff3699238049dcf3b1c96832b6dc80ddb4df3a99 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19708 | 19708 | 20200314 | AK | totalTestsViral | 144 | 1 | 3/13/2020 16:30 | 2020-03-13T16:30:00Z | 03/13 12:30 | 0 | 1 | 2020-03-13T16:30:00Z | 144 | 2 | 0 | 0 | 0 | 84 | 0 | 0.0 | 0.0 | dc754cc4c4e086cb906d986bf45986fd040d976b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19759 | 19759 | 20200313 | AK | totalTestsViral | 60 | 1 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 0 | 1 | 2020-03-13T00:00:00Z | 60 | 2 | 0 | 0 | 0 | 14 | 0 | 0.0 | 0.0 | 161c1b6d587bf2d0e7c2e392d0526c5bf5a19224 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19810 | 19810 | 20200312 | AK | 14 | totalTestsViral | 46 | 1 | 3/11/2020 16:30 | 2020-03-11T16:30:00Z | 03/11 12:30 | 0 | 1 | 2020-03-11T16:30:00Z | 46 | 2 | 0 | 0 | 14 | 0 | 0 | 0.0 | 0.0 | 020adeb48c1002ff06cb72e0490424953ef4c442 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
19861 | 19861 | 20200311 | AK | 14 | totalTestsViral | 46 | 1 | 0 | 1 | 46 | 2 | 0 | 0 | 14 | 23 | 0 | 0.0 | 0.0 | 1497b3f8301278f44cfdd139ffacc6163f5443a0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
19880 | 19880 | 20200311 | MA | totalTestsViral | 684 | 684 | 141 | 25 | 0 | 0 | 0 | 182 | 0 | 0.0 | 0.0 | 42bb6b9baa9e715d6cbdda7c547dbcb52c0cbb25 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19912 | 19912 | 20200310 | AK | 9 | totalTestsViral | 23 | 1 | 0 | 1 | 23 | 2 | 0 | 0 | 9 | 0 | 0 | 0.0 | 0.0 | 41ecc8af507387301652e0bb695c90af3caca45d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
19931 | 19931 | 20200310 | MA | totalTestsViral | 502 | 502 | 118 | 25 | 0 | 0 | 0 | 109 | 0 | 0.0 | 0.0 | 117e16dd591e1c8c777f9523040336bb42ea3b7c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19963 | 19963 | 20200309 | AK | 9 | totalTestsViral | 23 | 1 | 0 | 1 | 23 | 2 | 0 | 0 | 9 | 9 | 0 | 0.0 | 1.0 | e5fdecc645ef8aa383bb58cae9bdaf905ab33583 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
19982 | 19982 | 20200309 | MA | totalTestsViral | 393 | 393 | 104 | 25 | 0 | 0 | 0 | 81 | 0 | 0.0 | 0.0 | f0bab5be213707f5f7f69f2d3152409f9c8b2b1b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19991 | 19991 | 20200309 | ND | 0 | totalTestEncountersViral | 38 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 21b64f21381b6265c5d1ad6b2ceccd59a16ea053 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20014 | 20014 | 20200308 | AK | 6 | totalTestsViral | 14 | 0 | 14 | 2 | 0 | 0 | 6 | 2 | 0 | 0.0 | 0.0 | c90ce1a21475c44727e5853c22c009321728270c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20033 | 20033 | 20200308 | MA | totalTestsViral | 312 | 312 | 97 | 25 | 0 | 0 | 0 | 61 | 0 | 0.0 | 0.0 | 048e5ca2840d896c68c11cac22631c57bf7d5ab4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20042 | 20042 | 20200308 | ND | 0 | totalTestEncountersViral | 38 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 5913f63f45353688febba3adca7d7425eb228d93 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20065 | 20065 | 20200307 | AK | 2 | totalTestsViral | 12 | 0 | 12 | 2 | 0 | 0 | 2 | 4 | 0 | 0.0 | 0.0 | 7162c5ea37dd3e1693bfb3c2b9e97fe5e518755d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20084 | 20084 | 20200307 | MA | totalTestsViral | 251 | 251 | 77 | 25 | 0 | 0 | 0 | 100 | 0 | 0.0 | 0.0 | 1dca334cebc502c792977b97e98bfea49a3bd27e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20093 | 20093 | 20200307 | ND | 0 | totalTestEncountersViral | 38 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 25382ac2cd23abbb847374c2e8d122613edd4798 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20111 | 20111 | 20200307 | VT | totalTestsViral | 17 | 3/7/2020 00:00 | 2020-03-07T00:00:00Z | 03/06 19:00 | 2020-03-07T00:00:00Z | 17 | 50 | 0 | 0 | 0 | 7 | 0 | 0.0 | 0.0 | f439aafa1d4d3c2ebe6f7c9793431dd553e1a69e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
20116 | 20116 | 20200306 | AK | 1 | totalTestsViral | 8 | 0 | 8 | 2 | 0 | 0 | 1 | 0 | 0 | 0.0 | 0.0 | a342f77e8bb779edc91c9e1a1be309cd4338356b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20121 | 20121 | 20200306 | CT | totalTestsViral | 51 | 51 | 0 | 49 | 9 | 0 | 0 | 0 | 15 | 0 | 0.0 | 0.0 | dcaf3e096ce9613b12659c72a83f6b69b3181cc5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20126 | 20126 | 20200306 | HI | totalTestEncountersViral | 7 | 0 | 7 | 15 | 0 | 0 | 0 | 4 | 0 | 0.0 | 0.0 | 16beb6528d7ed952ab33cf6c295ae3de1d381cf4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20132 | 20132 | 20200306 | MA | totalTestsViral | 151 | 151 | 33 | 25 | 0 | 0 | 0 | 49 | 0 | 0.0 | 0.0 | 02bb0922271c9a459acd64f63e07807cebf155d1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20151 | 20151 | 20200306 | VT | totalTestsViral | 10 | 3/6/2020 00:00 | 2020-03-06T00:00:00Z | 03/05 19:00 | 2020-03-06T00:00:00Z | 10 | 50 | 0 | 0 | 0 | 4 | 0 | 0.0 | 0.0 | 7adac92149e9306135c41784dace1d3811e79aa7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
20155 | 20155 | 20200306 | WY | totalTestsViral | 8 | 8 | 0 | 8 | 56 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 034c507aa8f6087fa74443268ffd513a248de55a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20159 | 20159 | 20200305 | CT | totalTestsViral | 36 | 36 | 0 | 34 | 9 | 0 | 0 | 0 | 12 | 0 | 0.0 | 0.0 | 014e1da6f37bd50b70406e0101442c6165ea9718 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20163 | 20163 | 20200305 | HI | totalTestEncountersViral | 3 | 0 | 3 | 15 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | 11cc63effed19ca19f05b0ac2fcbec4a30f28149 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20165 | 20165 | 20200305 | IN | totalTestsViral | 17 | 3/4/2020 00:00 | 2020-03-04T00:00:00Z | 03/03 19:00 | 2020-03-04T00:00:00Z | 17 | 0 | 18 | 0 | 0 | 0 | 5 | 0 | 0.0 | 0.0 | 4edb81700ebbcbce27c75b97df05a8e1454dfbd1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20166 | 20166 | 20200305 | MA | totalTestsViral | 102 | 102 | 19 | 25 | 0 | 0 | 0 | 36 | 0 | 0.0 | 0.0 | 3b54800366d623306d8f26e1b5d1154d156a960e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20178 | 20178 | 20200305 | PA | totalTestEncountersViral | 7 | 7 | 42 | 0 | 0 | 0 | 2 | 0 | 0.0 | 0.0 | 1d3bb0c117a6194aeb4b3d49bd67cc1721ce341e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20184 | 20184 | 20200305 | VT | totalTestsViral | 6 | 6 | 50 | 0 | 0 | 0 | 3 | 0 | 0.0 | 0.0 | 1eee5a3173c343b7ea5bfbbd03e82bf5d892463a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20187 | 20187 | 20200305 | WY | totalTestsViral | 8 | 8 | 0 | 8 | 56 | 0 | 0 | 0 | 4 | 0 | 0.0 | 0.0 | 0b7bd10f8bbd4cccb010356a19bc9a1757cb2119 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20191 | 20191 | 20200304 | CT | totalTestsViral | 24 | 24 | 0 | 22 | 9 | 0 | 0 | 0 | 12 | 0 | 0.0 | 0.0 | 1d96b7238be1aff8512f0b0d3a374c18d879435e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20194 | 20194 | 20200304 | HI | totalTestEncountersViral | 2 | 0 | 2 | 15 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 977783fb48123570a49b5081f2a9e399e206b783 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20196 | 20196 | 20200304 | IN | totalTestsViral | 12 | 3/3/2020 00:00 | 2020-03-03T00:00:00Z | 03/02 19:00 | 2020-03-03T00:00:00Z | 12 | 0 | 18 | 0 | 0 | 0 | 4 | 0 | 0.0 | 0.0 | 817360f5c4dcc2de82eac0e7aa7550d88da67367 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20197 | 20197 | 20200304 | MA | totalTestsViral | 66 | 66 | 11 | 25 | 0 | 0 | 0 | 22 | 0 | 0.0 | 0.0 | fd839babf21466570f48d9f5bb304961381bde28 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20200 | 20200 | 20200304 | NE | totalTestsViral | 48 | 48 | 0 | 43 | 31 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | bb3c8470fc4306419cc4dbd3db04bbce328306da | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20202 | 20202 | 20200304 | NJ | posNeg | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | d3e8d69972e330825c56a48f1bde1008c2371c03 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20204 | 20204 | 20200304 | OR | totalTestsViral | 41 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | de536d9f10938dc7dc8107d6fbd68de557930cce | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
20205 | 20205 | 20200304 | PA | totalTestEncountersViral | 5 | 5 | 42 | 0 | 0 | 0 | 5 | 0 | 0.0 | 0.0 | 982ed7dffdb71612407e5907f3346ca700f66ee9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20209 | 20209 | 20200304 | VA | totalTestEncountersViral | 6452 | 2090 | 6452 | 18 | 1 | 51 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | 9efc56ab9d2b60b885a6ddce6d62175e07e13882 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
20210 | 20210 | 20200304 | VT | totalTestsViral | 3 | 3 | 50 | 0 | 0 | 0 | 3 | 0 | 0.0 | 0.0 | 8db55b2157df2046a566cd1b901bfcfcc44ab228 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20213 | 20213 | 20200304 | WY | totalTestsViral | 4 | 4 | 0 | 4 | 56 | 0 | 0 | 0 | 3 | 0 | 0.0 | 0.0 | 1bd2386f39b4f62687be38162bd4b3f03b28edc0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20214 | 20214 | 20200303 | CT | totalTestsViral | 12 | 12 | 0 | 12 | 9 | 0 | 0 | 0 | 4 | 0 | 0.0 | 0.0 | fd13e9478e68b25d808c0d6f57e371a803eef3fc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20216 | 20216 | 20200303 | IN | totalTestsViral | 8 | 3/2/2020 00:00 | 2020-03-02T00:00:00Z | 03/01 19:00 | 2020-03-02T00:00:00Z | 8 | 0 | 18 | 0 | 0 | 0 | 2 | 0 | 0.0 | 0.0 | 3e637502e8b588d01a217b9914a5675370e45de6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20217 | 20217 | 20200303 | MA | totalTestsViral | 44 | 44 | 9 | 25 | 0 | 0 | 0 | 15 | 0 | 0.0 | 0.0 | 256a22b87ce585c85d1ef6be452a3232157be50e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20219 | 20219 | 20200303 | NE | totalTestsViral | 48 | 48 | 0 | 43 | 31 | 0 | 0 | 0 | 12 | 0 | 0.0 | 0.0 | 3113b5ccbb7a865a5e52c0c1238a74506a13b889 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20220 | 20220 | 20200303 | NJ | posNeg | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 3511e7e3f204eb5fd894155f014fb31340049324 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20222 | 20222 | 20200303 | PA | totalTestEncountersViral | 0 | 0 | 42 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | e5c6bdab1cb35cece997dc6b622cbbe95d1dfa0e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20224 | 20224 | 20200303 | TX | totalTestsViral | 6 | 6 | 1 | 48 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 9fc44348b0e3f4b1b785453350a87af1ada11d3e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20225 | 20225 | 20200303 | VA | totalTestEncountersViral | 6451 | 2090 | 6451 | 18 | 1 | 51 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | 34c8b66d12aee9121677db6e66febe9468578e18 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
20226 | 20226 | 20200303 | VT | totalTestsViral | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 6c5e660a194737915b4e057f7e54508d55acb4b4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20228 | 20228 | 20200303 | WI | totalTestEncountersViral | 7 | 7 | 55 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 396b459dd3e046fa988c52d20decb73e17d331fc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20229 | 20229 | 20200303 | WY | totalTestsViral | 1 | 1 | 0 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 906862501215dfc37798975cf1c5dba4cc40344f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20230 | 20230 | 20200302 | CT | totalTestsViral | 8 | 8 | 0 | 8 | 9 | 0 | 0 | 0 | 4 | 0 | 0.0 | 0.0 | fd85b7545490bed622a443c73d41b794021162dd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20232 | 20232 | 20200302 | IN | totalTestsViral | 6 | 2/29/2020 00:00 | 2020-02-29T00:00:00Z | 02/28 19:00 | 2020-02-29T00:00:00Z | 6 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | c2adb0fb3217446f847fe02b17e019828aefbb9e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20233 | 20233 | 20200302 | MA | totalTestsViral | 29 | 29 | 8 | 25 | 0 | 0 | 0 | 6 | 0 | 0.0 | 0.0 | 002dae63c049dcae94e695918ad35aeb6659a406 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20235 | 20235 | 20200302 | NE | totalTestsViral | 36 | 36 | 0 | 33 | 31 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | c7956ade378c913b526c8b248b48c0040389c06a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20236 | 20236 | 20200302 | NJ | posNeg | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 25f4d9d6a926194839545da0a545b81b9ead5b88 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20239 | 20239 | 20200302 | VA | totalTestEncountersViral | 6450 | 2090 | 6450 | 18 | 1 | 51 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | 1c338935dbacdf82e2ec620559d2d7e37659d7a0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
20241 | 20241 | 20200302 | WY | totalTestsViral | 1 | 1 | 0 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | c1b97ada33d6f88e49324f2eec82840c5fb0b196 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20242 | 20242 | 20200301 | CT | totalTestsViral | 4 | 4 | 0 | 4 | 9 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | f1d4ecc3efd7e9b28793032edaa1e6fa2a5a6bd6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20244 | 20244 | 20200301 | IN | totalTestsViral | 6 | 2/29/2020 00:00 | 2020-02-29T00:00:00Z | 02/28 19:00 | 2020-02-29T00:00:00Z | 6 | 0 | 18 | 0 | 0 | 0 | 2 | 0 | 0.0 | 0.0 | ee3d4c0788657b648a3df53a9414741f01892c1d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20245 | 20245 | 20200301 | MA | totalTestsViral | 23 | 23 | 7 | 25 | 0 | 0 | 0 | 4 | 0 | 0.0 | 0.0 | bf2832de91818c875ff9857dbc8a07451671095e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20247 | 20247 | 20200301 | NE | totalTestsViral | 36 | 36 | 0 | 33 | 31 | 0 | 0 | 0 | 11 | 0 | 0.0 | 0.0 | b2b465284086b27e80dbe2126da766946206c7fd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20248 | 20248 | 20200301 | NJ | posNeg | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 25ac6e7c977e6481bede0ceb82cec820d1bbaa47 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20250 | 20250 | 20200301 | VA | totalTestEncountersViral | 6449 | 2090 | 6449 | 18 | 1 | 51 | 0 | 0 | 0 | 2 | 0 | 0.0 | 0.0 | de45a1162a8e9a2dc9ee34249c8c283eee176c46 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
20252 | 20252 | 20200301 | WY | totalTestsViral | 1 | 1 | 0 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | df3075a8cd255e3622d625c87dab85f2c6867ff3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20253 | 20253 | 20200229 | CT | totalTestsViral | 3 | 3 | 0 | 3 | 9 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 1d36be0707ed241c2013f29626740b85e8d81435 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20255 | 20255 | 20200229 | IN | totalTestsViral | 4 | 2/28/2020 00:00 | 2020-02-28T00:00:00Z | 02/27 19:00 | 2020-02-28T00:00:00Z | 4 | 0 | 18 | 0 | 0 | 0 | 2 | 0 | 0.0 | 0.0 | 86b04c6615d1765194b87df92123df680217c7af | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20256 | 20256 | 20200229 | MA | totalTestsViral | 19 | 19 | 6 | 25 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | 5169fcafa07a91ba5c7553ffe052ebd42761ee3a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20257 | 20257 | 20200229 | NE | totalTestsViral | 25 | 25 | 0 | 24 | 31 | 0 | 0 | 0 | 15 | 0 | 0.0 | 0.0 | 1680ba71076e81edcc4b51e0c3922b7bc0f53633 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20258 | 20258 | 20200229 | NJ | posNeg | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 53a63b63ad12d5fdc814b955636345f24e6149ca | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20259 | 20259 | 20200229 | VA | totalTestEncountersViral | 6447 | 2090 | 6447 | 17 | 1 | 51 | 0 | 0 | 0 | 2 | 0 | 0.0 | 0.0 | edbd996ecfe97559b93f8d774d8ca1311c43ffd4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
20262 | 20262 | 20200228 | IN | totalTestsViral | 2 | 2/27/2020 00:00 | 2020-02-27T00:00:00Z | 02/26 19:00 | 2020-02-27T00:00:00Z | 2 | 0 | 18 | 0 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | be1b5dc726d27c08cfc963009d0982d726c0129f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20263 | 20263 | 20200228 | MA | totalTestsViral | 18 | 18 | 6 | 25 | 0 | 0 | 0 | 2 | 0 | 0.0 | 0.0 | 19e567cabb753a5deed3f5c7eefee738b461743a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20264 | 20264 | 20200228 | NE | totalTestsViral | 10 | 10 | 0 | 9 | 31 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | afbac71e5d4fc04f2861804a9165d5e250c7a88b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20265 | 20265 | 20200228 | NJ | posNeg | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0d545bdd4f2ca83bee8dcdcd827598d941e8a343 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20266 | 20266 | 20200228 | VA | totalTestEncountersViral | 6445 | 2090 | 6445 | 14 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 6bd8852769254a3fe55c13d647731068f2d7a478 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
20269 | 20269 | 20200227 | IN | totalTestsViral | 1 | 2/26/2020 00:00 | 2020-02-26T00:00:00Z | 02/25 19:00 | 2020-02-26T00:00:00Z | 1 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 65302d94ca063a7d827d1ac29d1db05d54fe27ec | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
20270 | 20270 | 20200227 | MA | totalTestsViral | 16 | 16 | 5 | 25 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 6be091a7d47bda43ff2893572ead912709a724a8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20271 | 20271 | 20200227 | NE | totalTestsViral | 10 | 10 | 0 | 9 | 31 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | dbcefe6f6547b5a632fb0b380762c91821f06d2a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20272 | 20272 | 20200227 | NJ | posNeg | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 79b95ea58a8aeca6890c0b7a2e7c6da83c74fe48 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20273 | 20273 | 20200227 | VA | totalTestEncountersViral | 6445 | 6445 | 14 | 0 | 51 | 0 | 0 | 0 | 6445 | 0 | 0.0 | 0.0 | 4e32bc38c41e77467a4ee08088f6a69a45d40738 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20276 | 20276 | 20200226 | MA | totalTestsViral | 16 | 16 | 5 | 25 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 5419f4c618c73e974c4a9c0862ce32ed99cc6ac8 | 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, [probableCases] INTEGER, [negative] INTEGER, [pending] INTEGER, [totalTestResultsSource] TEXT, [totalTestResults] INTEGER, [hospitalizedCurrently] INTEGER, [hospitalizedCumulative] INTEGER, [inIcuCurrently] INTEGER, [inIcuCumulative] INTEGER, [onVentilatorCurrently] INTEGER, [onVentilatorCumulative] INTEGER, [recovered] INTEGER, [lastUpdateEt] TEXT, [dateModified] TEXT, [checkTimeEt] TEXT, [death] INTEGER, [hospitalized] INTEGER, [hospitalizedDischarged] INTEGER, [dateChecked] TEXT, [totalTestsViral] INTEGER, [positiveTestsViral] INTEGER, [negativeTestsViral] INTEGER, [positiveCasesViral] INTEGER, [deathConfirmed] INTEGER, [deathProbable] INTEGER, [totalTestEncountersViral] INTEGER, [totalTestsPeopleViral] INTEGER, [totalTestsAntibody] INTEGER, [positiveTestsAntibody] INTEGER, [negativeTestsAntibody] INTEGER, [totalTestsPeopleAntibody] INTEGER, [positiveTestsPeopleAntibody] INTEGER, [negativeTestsPeopleAntibody] INTEGER, [totalTestsPeopleAntigen] INTEGER, [positiveTestsPeopleAntigen] INTEGER, [totalTestsAntigen] INTEGER, [positiveTestsAntigen] INTEGER, [fips] INTEGER, [positiveIncrease] INTEGER, [negativeIncrease] INTEGER, [total] INTEGER, [totalTestResultsIncrease] INTEGER, [posNeg] INTEGER, [dataQualityGrade] TEXT, [deathIncrease] FLOAT, [hospitalizedIncrease] FLOAT, [hash] TEXT, [commercialScore] INTEGER, [negativeRegularScore] INTEGER, [negativeScore] INTEGER, [positiveScore] INTEGER, [score] INTEGER, [grade] TEXT );