states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
20,444 rows sorted by totalTestResults
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18913 | 18913 | 20200329 | OR | 479 | 9693 | totalTestsViral | 107 | 117 | 31 | 3/27/2020 12:30 | 2020-03-27T12:30:00Z | 03/27 08:30 | 13 | 117 | 2020-03-27T12:30:00Z | 41 | 65 | 1183 | 10172 | 0 | 10172 | 1.0 | 15.0 | 3c1b2b1d5416caba02fcff8ccf02aa0effb67e20 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
18969 | 18969 | 20200328 | OR | 414 | 8510 | totalTestsViral | 91 | 102 | 31 | 3/27/2020 12:30 | 2020-03-27T12:30:00Z | 03/27 08:30 | 12 | 102 | 2020-03-27T12:30:00Z | 41 | 87 | 1557 | 8924 | 0 | 8924 | 1.0 | 12.0 | 96b3705d0ece0a7cb7d11c4e52c3fee1f35181e0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
19025 | 19025 | 20200327 | OR | 327 | 6953 | totalTestsViral | 90 | 3/26/2020 16:31 | 2020-03-26T16:31:00Z | 03/26 12:31 | 11 | 90 | 2020-03-26T16:31:00Z | 41 | 118 | 2603 | 7280 | 0 | 7280 | 3.0 | 29.0 | fea0a8d68b9bf4cc54c51e761b8adf49f68a23ef | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19081 | 19081 | 20200326 | OR | 209 | 4350 | totalTestsViral | 61 | 3/24/2020 11:00 | 2020-03-24T11:00:00Z | 03/24 07:00 | 8 | 61 | 2020-03-24T11:00:00Z | 41 | 0 | 0 | 4559 | 0 | 4559 | 0.0 | 0.0 | 1d9117afef4ebf9f090d95c6ed649c81209c0672 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19137 | 19137 | 20200325 | OR | 209 | 4350 | totalTestsViral | 61 | 3/24/2020 11:00 | 2020-03-24T11:00:00Z | 03/24 07:00 | 8 | 61 | 2020-03-24T11:00:00Z | 41 | 18 | 701 | 4559 | 0 | 4559 | 3.0 | 5.0 | efe0b3aef69120e97962a7017a57d87421b7b17e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19193 | 19193 | 20200324 | OR | 191 | 3649 | totalTestsViral | 56 | 3/23/2020 11:00 | 2020-03-23T11:00:00Z | 03/23 07:00 | 5 | 56 | 2020-03-23T11:00:00Z | 41 | 30 | 785 | 3840 | 0 | 3840 | 1.0 | 13.0 | bc089b40e8f93b586ae0717d7823a3acd1c1dff9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19231 | 19231 | 20200323 | MD | 288 | 94 | totalTestsViral | 3/23/2020 10:00 | 2020-03-23T10:00:00Z | 03/23 06:00 | 4 | 2020-03-23T10:00:00Z | 288 | 4 | 24 | 44 | 0 | 382 | 0 | 382 | 0.0 | 0.0 | bee735ffe84a11a287e60e61e64f9c157cf6f9a4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19249 | 19249 | 20200323 | OR | 161 | 2864 | totalTestsViral | 43 | 3/22/2020 11:00 | 2020-03-22T11:00:00Z | 03/22 07:00 | 4 | 43 | 2020-03-22T11:00:00Z | 41 | 47 | 861 | 3025 | 0 | 3025 | 1.0 | 43.0 | 1452a696fffa7420b274e5fea5053ed5eb39cf41 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19255 | 19255 | 20200323 | TN | 615 | totalTestsViral | 3/23/2020 15:00 | 2020-03-23T15:00:00Z | 03/23 11:00 | 2 | 2020-03-23T15:00:00Z | 47 | 110 | 0 | 615 | 0 | 615 | 2.0 | 0.0 | 04bf8f580860bdc09b17c40c01e560fafe39ad98 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
19287 | 19287 | 20200322 | MD | 244 | 94 | totalTestsViral | 3/22/2020 10:00 | 2020-03-22T10:00:00Z | 03/22 06:00 | 4 | 2020-03-22T10:00:00Z | 244 | 4 | 24 | 54 | 0 | 338 | 0 | 338 | 1.0 | 0.0 | bc6ebded08c0c2044cbb2bcaacb37f55ea1e5a42 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19305 | 19305 | 20200322 | OR | 114 | 2003 | 433 | totalTestsViral | 3/20/2020 11:00 | 2020-03-20T11:00:00Z | 03/20 07:00 | 3 | 2020-03-20T11:00:00Z | 41 | 0 | 0 | 2550 | 0 | 2117 | 0.0 | 0.0 | 409ffc86a7a302ba259b8e7c7d39f4ded1c191e4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19311 | 19311 | 20200322 | TN | 505 | totalTestsViral | 3/22/2020 15:00 | 2020-03-22T15:00:00Z | 03/22 11:00 | 2020-03-22T15:00:00Z | 47 | 134 | 0 | 505 | 0 | 505 | 0.0 | 0.0 | 1aea9b0d76ca61b94b44715b21d1285d32547f12 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19343 | 19343 | 20200321 | MD | 190 | 94 | totalTestsViral | 3/21/2020 10:00 | 2020-03-21T10:00:00Z | 03/21 06:00 | 3 | 2020-03-21T10:00:00Z | 190 | 3 | 24 | 41 | 0 | 284 | 0 | 284 | 0.0 | 0.0 | b8480e61d56ec00602b1c7eb65d12d3c81ab30d9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19361 | 19361 | 20200321 | OR | 114 | 2003 | 433 | totalTestsViral | 3/20/2020 11:00 | 2020-03-20T11:00:00Z | 03/20 07:00 | 3 | 2020-03-20T11:00:00Z | 41 | 26 | 674 | 2550 | 0 | 2117 | 0.0 | 0.0 | 89f133decb338650afbe926187024076ff0056aa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19367 | 19367 | 20200321 | TN | 371 | totalTestsViral | 3/20/2020 22:48 | 2020-03-20T22:48:00Z | 03/20 18:48 | 2020-03-20T22:48:00Z | 47 | 143 | 0 | 371 | 0 | 371 | 0.0 | 0.0 | 00372aedf2263f2243b08c2cfbb074cfe8c8c0ba | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19399 | 19399 | 20200320 | MD | 149 | 94 | totalTestsViral | 3/20/2020 10:00 | 2020-03-20T10:00:00Z | 03/20 06:00 | 3 | 2020-03-20T10:00:00Z | 149 | 3 | 24 | 42 | 0 | 243 | 0 | 243 | 1.0 | 0.0 | 5e483620c7914598550743ec87600b943dc8bcf2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19417 | 19417 | 20200320 | OR | 88 | 1329 | 437 | totalTestsViral | 3/19/2020 11:00 | 2020-03-19T11:00:00Z | 03/19 07:00 | 3 | 2020-03-19T11:00:00Z | 41 | 13 | 211 | 1854 | 0 | 1417 | 0.0 | 0.0 | 8f3639089cceacb186aeed5617d38d314631b28c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19423 | 19423 | 20200320 | TN | 228 | totalTestsViral | 3/20/2020 15:00 | 2020-03-20T15:00:00Z | 03/20 11:00 | 2020-03-20T15:00:00Z | 47 | 74 | 0 | 228 | 0 | 228 | 0.0 | 0.0 | 13e685af5f105ed84a58c9c659849a5ac44b2315 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19455 | 19455 | 20200319 | MD | 107 | 94 | totalTestsViral | 3/19/2020 10:00 | 2020-03-19T10:00:00Z | 03/19 06:00 | 2 | 2020-03-19T10:00:00Z | 107 | 2 | 24 | 22 | 0 | 201 | 0 | 201 | 0.0 | 0.0 | ecdb2444413dd1aa332333a5a0b6c353f1fa9d26 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19473 | 19473 | 20200319 | OR | 75 | 1118 | 361 | totalTestsViral | 3/17/2020 12:00 | 2020-03-17T12:00:00Z | 03/17 08:00 | 3 | 2020-03-17T12:00:00Z | 41 | 28 | 429 | 1554 | 0 | 1193 | 3.0 | 0.0 | 8b76113facaad87fda8f2f67fb6556334f80796b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19479 | 19479 | 20200319 | TN | 154 | totalTestsViral | 3/19/2020 15:00 | 2020-03-19T15:00:00Z | 03/19 11:00 | 2020-03-19T15:00:00Z | 47 | 56 | 0 | 154 | 0 | 154 | 0.0 | 0.0 | 6e3730b2fe415f6b6bb59b4ddd907a651c83b520 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19511 | 19511 | 20200318 | MD | 85 | 94 | totalTestsViral | 3/18/2020 10:00 | 2020-03-18T10:00:00Z | 03/18 06:00 | 2 | 2020-03-18T10:00:00Z | 85 | 2 | 24 | 28 | 0 | 179 | 0 | 179 | 2.0 | 0.0 | acf1ce5eb45cc49ad661e17c6c9c2f3ea5bb6c15 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
19529 | 19529 | 20200318 | OR | 47 | 689 | 184 | totalTestsViral | 3/16/2020 13:51 | 2020-03-16T13:51:00Z | 03/16 09:51 | 2020-03-16T13:51:00Z | 41 | 8 | 110 | 920 | 0 | 736 | 0.0 | 0.0 | a652168e1762e2a1406e4b2e5863e925d279f0d1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19535 | 19535 | 20200318 | TN | 98 | totalTestsViral | 3/17/2020 15:00 | 2020-03-17T15:00:00Z | 03/17 11:00 | 2020-03-17T15:00:00Z | 47 | 25 | 0 | 98 | 0 | 98 | 0.0 | 0.0 | e453b037f984edbc4c17efe3f0d60de09a0b2a2c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19567 | 19567 | 20200317 | MD | 57 | 94 | totalTestsViral | 3/17/2020 10:00 | 2020-03-17T10:00:00Z | 03/17 06:00 | 2020-03-17T10:00:00Z | 57 | 24 | 20 | 0 | 151 | 0 | 151 | -2.0 | 0.0 | a16306c13daace7a9c97f28e4e33b104d8f3e022 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19585 | 19585 | 20200317 | OR | 39 | 579 | 182 | totalTestsViral | 3/16/2020 15:38 | 2020-03-16T15:38:00Z | 03/16 11:38 | 2020-03-16T15:38:00Z | 41 | 3 | 159 | 800 | 0 | 618 | 0.0 | 0.0 | f4a4115aa38409ae93746a2d50dfeb62c9a0366f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19591 | 19591 | 20200317 | TN | 73 | totalTestsViral | 3/17/2020 15:00 | 2020-03-17T15:00:00Z | 03/17 11:00 | 2020-03-17T15:00:00Z | 47 | 21 | 0 | 73 | 0 | 73 | 0.0 | 0.0 | d343b638a1b2ae318d5d261d9e3d27af8c54d706 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19623 | 19623 | 20200316 | MD | 37 | 94 | totalTestsViral | 3/16/2020 15:49 | 2020-03-16T15:49:00Z | 03/16 11:49 | 2 | 2020-03-16T15:49:00Z | 37 | 24 | 6 | 0 | 131 | 0 | 131 | 2.0 | 0.0 | 11ee0bf4e08b8e5a4809aca2a24b87f6491ca6a4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
19641 | 19641 | 20200316 | OR | 36 | 420 | 225 | totalTestsViral | 3/14/2020 14:00 | 2020-03-14T14:00:00Z | 03/14 10:00 | 2020-03-14T14:00:00Z | 41 | 6 | 83 | 681 | 0 | 456 | 0.0 | 0.0 | 2f7c252836cb37d2712b8890bf0a22664dd596c1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19647 | 19647 | 20200316 | TN | 52 | totalTestsViral | 3/16/2020 15:23 | 2020-03-16T15:23:00Z | 03/16 11:23 | 2020-03-16T15:23:00Z | 47 | 13 | 0 | 52 | 0 | 52 | 0.0 | 0.0 | 0a9422448883fcffe6ab064e711741116bccff87 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19677 | 19677 | 20200315 | MD | 31 | 94 | totalTestsViral | 3/15/2020 00:00 | 2020-03-15T00:00:00Z | 03/14 20:00 | 2020-03-15T00:00:00Z | 31 | 24 | 5 | 0 | 125 | 0 | 125 | 0.0 | 0.0 | b4f2a4a49ced67e60aa899a26c321bbf9c78168f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19694 | 19694 | 20200315 | OR | 30 | 337 | 157 | totalTestsViral | 3/13/2020 13:00 | 2020-03-13T13:00:00Z | 03/13 09:00 | 2020-03-13T13:00:00Z | 41 | 0 | 0 | 524 | 0 | 367 | 0.0 | 0.0 | 3c8fd9d629b3f0a9b50ef50effb7eda87383e153 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19699 | 19699 | 20200315 | TN | 39 | totalTestsViral | 3/15/2020 15:00 | 2020-03-15T15:00:00Z | 03/15 11:00 | 2020-03-15T15:00:00Z | 47 | 7 | 0 | 39 | 0 | 39 | 0.0 | 0.0 | cfd5401971a45d98636e5285d2dc3ed47330a057 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19728 | 19728 | 20200314 | MD | 26 | 94 | totalTestsViral | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 2020-03-14T00:00:00Z | 26 | 24 | 9 | 0 | 120 | 0 | 120 | 0.0 | 0.0 | d3d1bf50124915115953d84a1d684059b067839e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19745 | 19745 | 20200314 | OR | 30 | 337 | 157 | totalTestsViral | 3/13/2020 13:00 | 2020-03-13T13:00:00Z | 03/13 09:00 | 2020-03-13T13:00:00Z | 41 | 11 | 51 | 524 | 0 | 367 | 0.0 | 0.0 | 424eec8be4f28a4fa52f3c1b7f6dc59d982476b9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19750 | 19750 | 20200314 | TN | 32 | totalTestsViral | 3/14/2020 15:00 | 2020-03-14T15:00:00Z | 03/14 11:00 | 2020-03-14T15:00:00Z | 47 | 6 | 0 | 32 | 0 | 32 | 0.0 | 0.0 | 9f242adf6239366d7259ca7c8abca296469611c1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19779 | 19779 | 20200313 | MD | 17 | 94 | totalTestsViral | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 17 | 24 | 5 | 0 | 111 | 0 | 111 | 0.0 | 0.0 | 3d233a885f98ea4a1819f19abab2398c362e71c4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19796 | 19796 | 20200313 | OR | 19 | 286 | 62 | totalTestsViral | 3/11/2020 13:00 | 2020-03-11T13:00:00Z | 03/11 09:00 | 2020-03-11T13:00:00Z | 41 | 0 | 0 | 367 | 0 | 305 | 0.0 | 0.0 | b5bf3d19ca45c16e6644bf7f888b075a2f13e6de | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19801 | 19801 | 20200313 | TN | 26 | totalTestsViral | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 47 | 8 | 0 | 26 | 0 | 26 | 0.0 | 0.0 | 4741e12617156a17b764dc2bc828db5d81433e36 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19830 | 19830 | 20200312 | MD | 12 | 94 | totalTestsViral | 3/12/2020 00:00 | 2020-03-12T00:00:00Z | 03/11 20:00 | 2020-03-12T00:00:00Z | 12 | 24 | 3 | 0 | 106 | 0 | 106 | 0.0 | 0.0 | 47b9a89ae2d30bd2d080b55b2cec32e26005e201 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
19847 | 19847 | 20200312 | OR | 19 | 286 | 62 | totalTestsViral | 41 | 4 | 73 | 367 | 0 | 305 | 0.0 | 0.0 | 51b69dc5e69df9eb782202f62cb6f9c627fa9c51 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19852 | 19852 | 20200312 | TN | 18 | totalTestsViral | 3/12/2020 15:00 | 2020-03-12T15:00:00Z | 03/12 11:00 | 2020-03-12T15:00:00Z | 47 | 11 | 0 | 18 | 0 | 18 | 0.0 | 0.0 | f2ef418035ffe550d11d64306468d103a4c37f5c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
19881 | 19881 | 20200311 | MD | 9 | 94 | totalTestsViral | 9 | 24 | 3 | 5 | 103 | 0 | 103 | 0.0 | 0.0 | 34a35718dc2fd0879b5686500705267b79905906 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19898 | 19898 | 20200311 | OR | 15 | 213 | 67 | totalTestsViral | 41 | 1 | 48 | 295 | 0 | 228 | 0.0 | 0.0 | 8bc7bef26b39a2665b8266b5d8afa81a169ef723 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19903 | 19903 | 20200311 | TN | 7 | totalTestsViral | 47 | 0 | 0 | 7 | 0 | 7 | 0.0 | 0.0 | 8141126966b303ad30994b6157447e5e8fc07413 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
19917 | 19917 | 20200310 | CO | 28 | 251 | totalTestEncountersViral | 8 | 16 | 109 | 279 | 0 | 279 | 0.0 | 0.0 | fdb6d145df704364139f3a30188ad11b653224b0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
19920 | 19920 | 20200310 | DE | 0 | 17 | 3 | totalTestEncountersViral | 0 | 0 | 0 | 10 | 0 | 2 | 20 | 0 | 17 | 0.0 | 0.0 | 5e6b86f19cdfebe9b9a5bee2bbca1c009784d974 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
19932 | 19932 | 20200310 | MD | 6 | 89 | totalTestsViral | 6 | 24 | 1 | 16 | 95 | 0 | 95 | 0.0 | 0.0 | 869987d76b0078cbee672bb75ad99e12fbfedffe | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19949 | 19949 | 20200310 | OR | 14 | 165 | 52 | totalTestsViral | 41 | 0 | 65 | 231 | 0 | 179 | 0.0 | 0.0 | b32a160700872616b2ad9b037822127458c051eb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19954 | 19954 | 20200310 | TN | 7 | totalTestsViral | 47 | 4 | 0 | 7 | 0 | 7 | 0.0 | 0.0 | 5f9272294b1ed15bd517a9241be9080e708b7351 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
19968 | 19968 | 20200309 | CO | 12 | 142 | 1 | totalTestEncountersViral | 8 | 3 | 9 | 155 | 0 | 154 | 0.0 | 0.0 | 4bb1deda7e34d8e65830457740fcf503a28bcb98 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
19971 | 19971 | 20200309 | DE | 0 | 15 | 3 | totalTestEncountersViral | 0 | 0 | 0 | 10 | 0 | 5 | 18 | 0 | 15 | 0.0 | 0.0 | 88983d0a85f0541fdbdf787ebc882515c3422a75 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
19983 | 19983 | 20200309 | MD | 5 | 73 | totalTestsViral | 5 | 24 | 2 | 21 | 78 | 0 | 78 | 0.0 | 0.0 | 49689750cf69b1460f3623e9217a2eefb2e8be7a | 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 | ||||||||||||||||||||||||||||||||||||||
20000 | 20000 | 20200309 | OR | 14 | 100 | 53 | totalTestsViral | 41 | 7 | 23 | 167 | 0 | 114 | 0.0 | 0.0 | 087742cc0188dc35510cce21485d8302c7244d8f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20005 | 20005 | 20200309 | TN | 3 | totalTestsViral | 47 | 0 | 0 | 3 | 0 | 3 | 0.0 | 0.0 | 5006d2a84c692a7a4ea0cef92589c779cb2f3bff | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20019 | 20019 | 20200308 | CO | 9 | 133 | totalTestEncountersViral | 8 | 1 | 29 | 142 | 0 | 142 | 0.0 | 0.0 | 22b7dbcad8c3365c3b2994d6ebf2daf8854e46d0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20022 | 20022 | 20200308 | DE | 0 | 10 | 0 | totalTestEncountersViral | 0 | 0 | 0 | 10 | 0 | 0 | 10 | 0 | 10 | 0.0 | 0.0 | 0b4c55701d6d63fb72f5d7b372d8feb714e99b3b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
20034 | 20034 | 20200308 | MD | 3 | 52 | totalTestsViral | 3 | 24 | 0 | 11 | 55 | 0 | 55 | 0.0 | 0.0 | 7560e5b2b281187a97dc570188867bfdcb504627 | 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 | ||||||||||||||||||||||||||||||||||||||
20051 | 20051 | 20200308 | OR | 7 | 77 | 40 | totalTestsViral | 41 | 4 | 13 | 124 | 0 | 84 | 0.0 | 0.0 | 2fa9e573079de029dd21723d6bfdd6e99339d9a1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20056 | 20056 | 20200308 | TN | 3 | totalTestsViral | 47 | 2 | 0 | 3 | 0 | 3 | 0.0 | 0.0 | 682bf06fe90ab31975cc11ef86a75585ef6d16f1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20070 | 20070 | 20200307 | CO | 8 | 104 | totalTestEncountersViral | 8 | 0 | 49 | 112 | 0 | 112 | 0.0 | 0.0 | a740f37f9869f05b4944020a602adc83fda37700 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20073 | 20073 | 20200307 | DE | 0 | 10 | 0 | totalTestEncountersViral | 10 | 0 | 0 | 10 | 0 | 10 | 0.0 | 0.0 | 656dd5d9b7fc2b7f3cd38ec24081435adf941a54 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20085 | 20085 | 20200307 | MD | 3 | 41 | totalTestsViral | 3 | 24 | 0 | 15 | 44 | 0 | 44 | 0.0 | 0.0 | 753d37519fcf121f566ec64c4f14f0f45067c8db | 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 | ||||||||||||||||||||||||||||||||||||||
20102 | 20102 | 20200307 | OR | 3 | 64 | 28 | totalTestsViral | 41 | 0 | 19 | 95 | 0 | 67 | 0.0 | 0.0 | 6f2e24541279bd147d70419668851904ceb693c4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20107 | 20107 | 20200307 | TN | 1 | totalTestsViral | 47 | 0 | 0 | 1 | 0 | 1 | 0.0 | 0.0 | 8d7cb76a12322dd775cac0b813e8789c10e37f6e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20120 | 20120 | 20200306 | CO | 8 | 55 | 69 | totalTestEncountersViral | 8 | 6 | 9 | 132 | 0 | 63 | 0.0 | 0.0 | c492794852e64c6421f977dfe64ec04c0cb76dfe | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20123 | 20123 | 20200306 | DE | 0 | 10 | 0 | totalTestEncountersViral | 10 | 0 | 0 | 10 | 0 | 10 | 0.0 | 0.0 | 2c664d30d7ad4c9dc61a0c40ae0f7a19a51ac11b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20133 | 20133 | 20200306 | MD | 3 | 26 | 12 | totalTestsViral | 3 | 24 | 3 | 9 | 41 | 0 | 29 | 0.0 | 0.0 | a36e80f7cb1492a364ff231da86842d1fdb76028 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20144 | 20144 | 20200306 | OR | 3 | 45 | 13 | totalTestsViral | 41 | 0 | 16 | 61 | 0 | 48 | 0.0 | 0.0 | e3f06c6ba9a718104894fd449ee760abb92ee32e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20148 | 20148 | 20200306 | TN | 1 | totalTestsViral | 47 | 0 | 0 | 1 | 0 | 1 | 0.0 | 0.0 | e6938cee8227bc5d5a67c910e39b7aef5d77e0fc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20158 | 20158 | 20200305 | CO | 2 | 46 | 30 | totalTestEncountersViral | 8 | 0 | 27 | 78 | 0 | 48 | 0.0 | 0.0 | 4583bdb5be51ae02ad0dd181453d79d7980fc94f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20167 | 20167 | 20200305 | MD | 0 | 17 | 14 | totalTestsViral | 0 | 24 | 0 | 0 | 31 | 0 | 17 | 0.0 | 0.0 | 69ee5909835eb9c725ef2300bb9d8d46ea3b8a7b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
20176 | 20176 | 20200305 | OH | 0 | 3 | totalTestsViral | 0 | 39 | 0 | 0 | 3 | 0 | 0 | 0.0 | 0.0 | 53f8e6ad3b0cc2959ab746cb608d9c85e6a4b456 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20177 | 20177 | 20200305 | OR | 3 | 29 | 18 | totalTestsViral | 41 | 3 | 29 | 50 | 0 | 32 | 0.0 | 0.0 | ecabfe85ebfa3eade761ad031bd0b8ed6a8ede5e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
20181 | 20181 | 20200305 | TN | 1 | totalTestsViral | 47 | 0 | 0 | 1 | 0 | 1 | 0.0 | 0.0 | 698562374ec8b2716564b071accdab4d5d6e5f56 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
20190 | 20190 | 20200304 | CO | 2 | 19 | 21 | totalTestEncountersViral | 8 | 0 | 0 | 42 | 0 | 21 | 0.0 | 0.0 | c03e1974116558c11e659456ca9702b99577082e | 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 | |||||||||||||||||||||||||||||||||||||||
20249 | 20249 | 20200301 | RI | 2 | 2 | totalTestEncountersViral | 3/1/2020 03:00 | 2020-03-01T03:00:00Z | 02/29 22:00 | 2020-03-01T03:00:00Z | 4 | 2 | 2 | 4 | 44 | 0 | 0 | 4 | 0 | 4 | 0.0 | 0.0 | 3793fbfc26f9b3c4a602a20759707b3ca81aaf55 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
20279 | 20279 | 20200226 | VA | totalTestEncountersViral | 14 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 4ed1b3e873a0e2aa32ce2d4e0d0bf3240f448a46 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20285 | 20285 | 20200225 | VA | totalTestEncountersViral | 14 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 7597ac0047f9f18651a015debba006a98a7fb6ec | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20291 | 20291 | 20200224 | VA | totalTestEncountersViral | 14 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 5579a8432593be88cd3c5f4d73e28da420db2979 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20297 | 20297 | 20200223 | VA | totalTestEncountersViral | 12 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 927caa4b13c27d889ba02676e3b75b8fe2bf77b0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20303 | 20303 | 20200222 | VA | totalTestEncountersViral | 11 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | bb9ec66a9493cefd7342437ffdaff76adf75e5bb | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20309 | 20309 | 20200221 | VA | totalTestEncountersViral | 9 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 689b8304f4727a8e1b4993d61d5658301bf721f6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20315 | 20315 | 20200220 | VA | totalTestEncountersViral | 9 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | f1db14196c174d33e2c3c419a6c220f256797ac4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20321 | 20321 | 20200219 | VA | totalTestEncountersViral | 9 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 3037d607d946f234ad4f2e780de7f5e70d311e63 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20327 | 20327 | 20200218 | VA | totalTestEncountersViral | 7 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0bdd5f66afec31cf18a1cbc5b478bad622a10994 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20333 | 20333 | 20200217 | VA | totalTestEncountersViral | 5 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | d27ef1a07f9d3113c870f6c3e41e38fcbdec01f6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20339 | 20339 | 20200216 | VA | totalTestEncountersViral | 4 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 06eb427c7a2d8d653802a51f68ff830be866405a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20345 | 20345 | 20200215 | VA | totalTestEncountersViral | 4 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | b1930f06d277bb242b1fd492ce406df2d18481c4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20350 | 20350 | 20200214 | VA | totalTestEncountersViral | 4 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0a17d5c8e851e6a3ab11a49f1bd37fdc2ee189d0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20355 | 20355 | 20200213 | VA | totalTestEncountersViral | 4 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 319bdbea8d7ab9d6b65662caf5d30197e16693dc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20360 | 20360 | 20200212 | VA | totalTestEncountersViral | 4 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | cd90c7e24ae29701c258ed0fef41d3b80857b913 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20365 | 20365 | 20200211 | VA | totalTestEncountersViral | 4 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | ffb52c196063981c0491640f101c43a743011ec4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20370 | 20370 | 20200210 | VA | totalTestEncountersViral | 3 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 59e11298dd237aaf256f9da8dc8c545b38940c34 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20374 | 20374 | 20200209 | VA | totalTestEncountersViral | 3 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 599ba8f0a75a7efcd1ae9baa62ed9388eb32a9f1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
20378 | 20378 | 20200208 | VA | totalTestEncountersViral | 3 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 386bb3a1198c6238d0eb8a3d1810b2ee5b8cd9f7 | 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 );