states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
11,578 rows sorted by date
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11481 | 11481 | 20200229 | WA | 18 | 24 | 42 | 2/29/2020 00:00 | 2020-02-29T00:00:00Z | 02/28 19:00 | 5 | 2020-02-29T00:00:00Z | 18 | 42 | 41 | 53 | 18 | 24 | 42 | posNeg | 42 | 42 | 1 | 0 | 8972c1ea9ca75f42476706b212482111eb222a95 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11472 | 11472 | 20200301 | MA | 23 | 23 | 7 | 25 | 0 | 0 | 0 | totalTestsViral | 4 | 0 | 0 | 0 | 8a65286f40aa6fc4872bb67709e297acfb6210f2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11473 | 11473 | 20200301 | MI | 14 | 14 | 14 | 0 | 0 | 26 | 0 | 0 | 14 | posNeg | 0 | 14 | 0 | 0 | a3a203b724e8167d055ed791a24d182f468b0624 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11474 | 11474 | 20200301 | NJ | 0 | 0 | 0 | 34 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | fb574b9660e6bdfd753291806bc31a21c8d9a366 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11475 | 11475 | 20200301 | RI | 2 | 2 | 3/1/2020 03:00 | 2020-03-01T03:00:00Z | 02/29 22:00 | 2020-03-01T03:00:00Z | 4 | 2 | 2 | 2 | 4 | 44 | 0 | 0 | 4 | totalTestEncountersViral | 0 | 4 | 0 | 0 | 008b0080959373e1f9483cf91a55ae015b5b31af | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11476 | 11476 | 20200301 | VA | 6449 | 2090 | 6449 | 51 | 0 | 0 | 0 | posNeg | 2 | 0 | 0 | 0 | d7c186427590681553bdfa396f0803a279868fe4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11477 | 11477 | 20200301 | WA | 34 | 83 | 117 | 3/1/2020 00:00 | 2020-03-01T00:00:00Z | 02/29 19:00 | 8 | 2020-03-01T00:00:00Z | 34 | 117 | 114 | 53 | 16 | 59 | 117 | posNeg | 75 | 117 | 3 | 0 | 49466d84a8bbbc4af877bb32cbfda3a86cfe82a8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11466 | 11466 | 20200302 | MA | 29 | 29 | 8 | 25 | 0 | 0 | 0 | totalTestsViral | 6 | 0 | 0 | 0 | 851790b128ea6e959af38c06dd22ab98af7c4a4d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11467 | 11467 | 20200302 | MI | 27 | 27 | 27 | 0 | 26 | 13 | 0 | 27 | posNeg | 13 | 27 | 0 | 0 | 188b36197a3a6f3e207a4214c18430304bbe6ac3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11468 | 11468 | 20200302 | NJ | 0 | 0 | 0 | 34 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 159d78f5cc076f8e16d0b3afcbce25b545337f47 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11469 | 11469 | 20200302 | RI | 2 | 3 | 4 | 3/2/2020 03:00 | 2020-03-02T03:00:00Z | 03/01 22:00 | 2020-03-02T03:00:00Z | 5 | 2 | 3 | 2 | 4 | 5 | 44 | 0 | 1 | 5 | totalTestEncountersViral | 4 | 5 | 0 | 0 | b5b45c6219dace9942c021bc2c7b0114fff7eb3f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11470 | 11470 | 20200302 | VA | 6450 | 2090 | 6450 | 51 | 0 | 0 | 0 | posNeg | 1 | 0 | 0 | 0 | 1c53123e9227988889fd6cbcb2f472dc9918ea52 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11471 | 11471 | 20200302 | WA | 65 | 240 | 305 | 3/2/2020 00:00 | 2020-03-02T00:00:00Z | 03/01 19:00 | 11 | 2020-03-02T00:00:00Z | 65 | 305 | 298 | 53 | 31 | 157 | 305 | posNeg | 188 | 305 | 3 | 0 | 40b881326f8ffe5ec8c7f330496b23041803ec5c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11460 | 11460 | 20200303 | MA | 44 | 44 | 9 | 25 | 0 | 0 | 0 | totalTestsViral | 15 | 0 | 0 | 0 | e8d2deeaa93bf087dbae5f369316ec1cac2df3b3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11461 | 11461 | 20200303 | MI | 50 | 50 | 50 | 0 | 26 | 23 | 0 | 50 | posNeg | 23 | 50 | 0 | 0 | faceabe5b082bdfad5f82a60e4cadb3cbf97d9dd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11462 | 11462 | 20200303 | NJ | 0 | 0 | 0 | 34 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | fcd4e5d8c24caf424c91ef5e1d87f702e07cdb13 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11463 | 11463 | 20200303 | RI | 2 | 5 | 5 | 3/3/2020 03:00 | 2020-03-03T03:00:00Z | 03/02 22:00 | 2020-03-03T03:00:00Z | 7 | 2 | 5 | 2 | 5 | 7 | 44 | 0 | 2 | 7 | totalTestEncountersViral | 1 | 7 | 0 | 0 | 4f5646cf6f957ccf8cc678537a1f9034095dd5bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11464 | 11464 | 20200303 | VA | 6451 | 2090 | 6451 | 51 | 0 | 0 | 0 | posNeg | 1 | 0 | 0 | 0 | 002a7f6b45d366a19f7f44b24f0cb7bbf81ea723 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11465 | 11465 | 20200303 | WA | 90 | 441 | 531 | 3/3/2020 00:00 | 2020-03-03T00:00:00Z | 03/02 19:00 | 14 | 2020-03-03T00:00:00Z | 90 | 531 | 523 | 53 | 25 | 201 | 531 | posNeg | 226 | 531 | 3 | 0 | 332628a0c194c806a406a24f61c4792f1c58993b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11442 | 11442 | 20200304 | AZ | 2 | 27 | 5 | 29 | 4 | 4 | 29 | 4 | 0 | 0 | 34 | posNeg | 0 | 29 | 0 | 0 | b253a8a5dab72eeecbc888ec33fca16d36cf1346 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11443 | 11443 | 20200304 | CA | 53 | 462 | 515 | 515 | 6 | 0 | 0 | 515 | posNeg | 0 | 515 | 0 | 0 | eee11b9054ebbbddec83c9d905bce3e48413be5b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11444 | 11444 | 20200304 | FL | 2 | 24 | 16 | 26 | 12 | 0 | 0 | 42 | posNeg | 0 | 26 | 0 | 0 | 032fc4f857ebba230a7ae251a9ab4ffa7f3a4807 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11445 | 11445 | 20200304 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 05981c7c64c1a7574528bd621b73ca93c88c3a53 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11446 | 11446 | 20200304 | IL | 4 | 124 | 27 | 128 | 17 | 0 | 0 | 155 | posNeg | 0 | 128 | 0 | 0 | 0150bd027110b1073c49d25c27e32e66985bceba | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11447 | 11447 | 20200304 | MA | 66 | 66 | 11 | 25 | 0 | 0 | 0 | totalTestsViral | 22 | 0 | 0 | 0 | ae77ed084117540fcdbf8f2bb226bee3925108d1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11448 | 11448 | 20200304 | MI | 74 | 74 | 74 | 0 | 0 | 26 | 24 | 0 | 74 | posNeg | 24 | 74 | 0 | 0 | 74651357dffe8528681e2f298af8de77b32fd381 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11449 | 11449 | 20200304 | NC | 1 | 1 | 37 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 4d1b2fa487067a2fcbf1f564cbb7aee6d90f48e3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11450 | 11450 | 20200304 | NH | 2 | 10 | 7 | 6 | 6 | 33 | 0 | 0 | 19 | posNeg | 0 | 12 | 0 | 0 | db4d1fb991fd24e70a18808ef146ecbf3060a4a4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11451 | 11451 | 20200304 | NJ | 0 | 0 | 0 | 34 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | fac52d1c2ce88e125e369b84425fa04ae39818ab | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11452 | 11452 | 20200304 | NY | 6 | 48 | 24 | 54 | 14 | 0 | 36 | 0 | 0 | 78 | posNeg | 0 | 54 | 0 | 0 | 0644baa482efb061cc2a48b2dad420a97e21e6c3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11453 | 11453 | 20200304 | OR | 3 | 29 | 18 | 32 | 41 | 0 | 0 | 50 | posNeg | 0 | 32 | 0 | 0 | 3c10eed6b5e81c23046f285f802f8432ab5651ca | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11454 | 11454 | 20200304 | RI | 2 | 15 | 7 | 3/4/2020 03:00 | 2020-03-04T03:00:00Z | 03/03 22:00 | 2020-03-04T03:00:00Z | 19 | 2 | 17 | 2 | 7 | 17 | 44 | 0 | 10 | 17 | totalTestEncountersViral | 2 | 17 | 0 | 0 | bc136a430b6c596c2b4fd4559edc37e4935f4c0a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11455 | 11455 | 20200304 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | cebf83dff216f187b0b9d36b2b7859294acd9e75 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11456 | 11456 | 20200304 | TX | 1 | 1 | 1 | 48 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | ac3e4cd42d64afbbf5c925dc09ff26549fc509bc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11457 | 11457 | 20200304 | VA | 6452 | 2090 | 6452 | 51 | 0 | 0 | 0 | posNeg | 1 | 0 | 0 | 0 | a550f68ec0f50d9d9a8f536cdbe2f9b804aef29f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11458 | 11458 | 20200304 | WA | 128 | 654 | 782 | 3/4/2020 00:00 | 2020-03-04T00:00:00Z | 03/03 19:00 | 16 | 2020-03-04T00:00:00Z | 128 | 782 | 768 | 53 | 38 | 213 | 782 | posNeg | 251 | 782 | 2 | 0 | 51c80f0cb4eca1fc54a16e163583edaa57ac35ae | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11459 | 11459 | 20200304 | WI | 1 | 19 | 6 | 20 | 1 | 55 | 0 | 0 | 26 | posNeg | 0 | 20 | 0 | 0 | 4f7342c8053027f3d749974e3336f4773ecab8da | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11417 | 11417 | 20200305 | AZ | 2 | 28 | 6 | 30 | 5 | 5 | 30 | 4 | 0 | 1 | 36 | posNeg | 1 | 30 | 0 | 1 | 076f7175e4c179602dc09e59552f72e7b7379002 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11418 | 11418 | 20200305 | CA | 53 | 462 | 515 | 515 | 6 | 0 | 0 | 515 | posNeg | 0 | 515 | 0 | 0 | f12fe649e62021d58624a953413c7c28b734ec3b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11419 | 11419 | 20200305 | CO | 2 | 19 | 21 | 8 | 0 | 0 | 42 | totalTestEncountersViral | 0 | 21 | 0 | 0 | 441da6fe37b08d014f7bca1b3e3b532a4d57d0dc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11420 | 11420 | 20200305 | DC | 0 | 6 | 2 | 6 | 6 | 11 | 0 | 0 | 8 | posNeg | 0 | 6 | 0 | 0 | 511da9e0387d34eaf2f0ab354f6de9ce58caff3b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11421 | 11421 | 20200305 | FL | 9 | 31 | 69 | 40 | 12 | 7 | 7 | 109 | posNeg | 14 | 40 | 0 | 0 | 5ac125cdc1543f8435bc3c1e4df60418af9cb237 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11422 | 11422 | 20200305 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | d4d80e64fc6aaa79af0a071cf69fca98219493f5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11423 | 11423 | 20200305 | IL | 5 | 165 | 27 | 170 | 17 | 1 | 41 | 197 | posNeg | 42 | 170 | 0 | 0 | 17bd281d6122f17f6282742e4f8c0ab97dae9ba3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11424 | 11424 | 20200305 | MA | 102 | 102 | 19 | 25 | 0 | 0 | 0 | totalTestsViral | 36 | 0 | 0 | 0 | b4ea31e65c1accfaf98eedb1c60d0dbe7798d02b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11425 | 11425 | 20200305 | MD | 0 | 17 | 14 | 17 | 0 | 24 | 0 | 0 | 31 | posNeg | 0 | 17 | 0 | 0 | 2d2e59f6f001197506f4931ee38d712e98556d15 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11426 | 11426 | 20200305 | MI | 100 | 8 | 0 | 108 | 100 | 0 | 0 | 26 | 26 | 8 | 108 | posNeg | 34 | 108 | 0 | 0 | 78953c4abcf5d8990b83eea5b2595a34ddccb1cc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11427 | 11427 | 20200305 | NC | 1 | 1 | 37 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 473807abe52be5725eaf2be038a408c589d97a1c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11428 | 11428 | 20200305 | NE | 0 | 17 | 5 | 17 | 31 | 0 | 0 | 22 | posNeg | 0 | 17 | 0 | 0 | 4ec3ed406eaf3240ec3216db8ab3aaef80bf4479 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11429 | 11429 | 20200305 | NH | 2 | 16 | 4 | 9 | 9 | 33 | 0 | 6 | 22 | posNeg | 3 | 18 | 0 | 0 | 69e0d4d0fb341cdde8198d43f7402a084ef98a73 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11430 | 11430 | 20200305 | NJ | 1 | 1 | 0 | 2 | 0 | 1 | 34 | 1 | 0 | 1 | posNeg | 1 | 1 | 0 | 0 | 684c48748966f7f3221e7a5150a1fda9fc49b037 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11431 | 11431 | 20200305 | NV | 1 | 14 | 15 | 0 | 1 | 32 | 0 | 0 | 15 | posNeg | 0 | 15 | 0 | 0 | a29795351261cfb15690f1d9c848d1f3549d4c76 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11432 | 11432 | 20200305 | NY | 22 | 76 | 24 | 98 | 36 | 16 | 28 | 122 | posNeg | 44 | 98 | 0 | 0 | 4e6700472deb64bcf0ae6c56393e0cb700af0510 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11433 | 11433 | 20200305 | OH | 0 | 7 | 3 | 7 | 0 | 39 | 0 | 0 | 10 | posNeg | 0 | 7 | 0 | 0 | 459bc305b63235074b9f4ea5633d9719bd1fc8ff | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11434 | 11434 | 20200305 | OR | 3 | 45 | 13 | 48 | 41 | 0 | 16 | 61 | posNeg | 16 | 48 | 0 | 0 | 19a5850ad89dbdb7318d865e9ee5f397063260a6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11435 | 11435 | 20200305 | RI | 3 | 19 | 19 | 3/5/2020 03:00 | 2020-03-05T03:00:00Z | 03/04 22:00 | 2020-03-05T03:00:00Z | 23 | 2 | 21 | 3 | 19 | 22 | 44 | 1 | 4 | 22 | totalTestEncountersViral | 12 | 22 | 0 | 0 | b78016563ac5e311c829ea6dbc8fc5835dde47ea | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11436 | 11436 | 20200305 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | d1b9c8d019f752b3382e9e77b37ca59d1446c88a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11437 | 11437 | 20200305 | TN | 1 | 1 | 47 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | e0c627b4f17cfed2252487b1cea86a069800fcbd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11438 | 11438 | 20200305 | TX | 1 | 1 | 1 | 48 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | b6c2d2da54bf32da455dc064c25b46362e2c5249 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11439 | 11439 | 20200305 | VA | 0 | 18 | 3 | 6453 | 2091 | 6453 | 51 | 0 | 18 | 21 | posNeg | 1 | 18 | 0 | 0 | e6d65ab3dbd920ba98b3b4dabbbb0f1798b9ec7a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11440 | 11440 | 20200305 | WA | 179 | 977 | 1156 | 3/5/2020 00:00 | 2020-03-05T00:00:00Z | 03/04 19:00 | 20 | 2020-03-05T00:00:00Z | 179 | 1156 | 1128 | 53 | 51 | 323 | 1156 | posNeg | 374 | 1156 | 4 | 0 | 959291c7ea6f320e7b1ab1ddb3af16b6ac69f7a8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11441 | 11441 | 20200305 | WI | 1 | 19 | 6 | 20 | 1 | 55 | 0 | 0 | 26 | posNeg | 0 | 20 | 0 | 0 | 96745110da7f5cc1601d3684d033d9153876dd3f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11380 | 11380 | 20200306 | AK | 0 | 8 | 1 | 8 | 0 | 8 | 0 | 2 | 0 | 0 | 9 | posNeg | 0 | 8 | 0 | 0 | 21a9fd54bd38e461fd39885bfa77c8aaf7559737 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11381 | 11381 | 20200306 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | d2ee5fcc83ed0c711dcd518c7cc9cdf86ba7acc7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11382 | 11382 | 20200306 | AZ | 3 | 33 | 15 | 36 | 6 | 6 | 36 | 4 | 1 | 5 | 51 | posNeg | 6 | 36 | 0 | 1 | eff86c4389b1978fe0749edaf3bb54a75683d3af | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11383 | 11383 | 20200306 | CA | 60 | 462 | 522 | 522 | 6 | 7 | 0 | 522 | posNeg | 7 | 522 | 0 | 0 | 5ecbe8b49ff1d40977dae99b4f483ff44971650d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11384 | 11384 | 20200306 | CO | 2 | 46 | 30 | 8 | 0 | 27 | 78 | totalTestEncountersViral | 0 | 48 | 0 | 0 | 297841f2ab3485310e34cc752522202f245a5d04 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11385 | 11385 | 20200306 | DC | 0 | 8 | 1 | 8 | 8 | 11 | 0 | 2 | 9 | posNeg | 2 | 8 | 0 | 0 | 49d91289f6bdaf15b3933057e6330a0a91a5cf25 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11386 | 11386 | 20200306 | DE | 0 | 10 | 0 | 10 | 10 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | 791a5103c9735e64919ff50aea2f9b8fb1150c0a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11387 | 11387 | 20200306 | FL | 9 | 55 | 51 | 64 | 12 | 0 | 24 | 115 | posNeg | 24 | 64 | 0 | 0 | 74d47679332785f9c4a47af0baad965efdc01a5a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11388 | 11388 | 20200306 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | cec1802d5dfc5229646abf26fec428e1481db1e3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11389 | 11389 | 20200306 | IA | 0 | 15 | 2 | 15 | 0 | 19 | 0 | 0 | 17 | posNeg | 0 | 15 | 0 | 0 | 57fd972e8dcf67c72ffbe414e01945cdf2e4913b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11390 | 11390 | 20200306 | IL | 5 | 180 | 35 | 185 | 17 | 0 | 15 | 220 | posNeg | 15 | 185 | 0 | 0 | 23fff42d1571029e425ea9a040ba0f3c249bf7c0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11391 | 11391 | 20200306 | IN | 1 | 1 | 18 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 48879bb87fc6d7f888ad73cf855f11578aa51ad0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11392 | 11392 | 20200306 | KS | 0 | 4 | 0 | 4 | 20 | 0 | 0 | 4 | posNeg | 0 | 4 | 0 | 0 | 869916ef064b6274b1c4d30feee19fe80e419f3c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11393 | 11393 | 20200306 | KY | 0 | 7 | 3 | 7 | 7 | 21 | 0 | 0 | 10 | posNeg | 0 | 7 | 0 | 0 | 95f887923437832032211bf91cff3cbd10741796 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11394 | 11394 | 20200306 | MA | 151 | 151 | 33 | 25 | 0 | 0 | 0 | totalTestsViral | 49 | 0 | 0 | 0 | a1dc05d9c438d8dd5d951330d290ece011b49b59 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11395 | 11395 | 20200306 | MD | 3 | 26 | 12 | 29 | 3 | 24 | 3 | 9 | 41 | posNeg | 12 | 29 | 0 | 0 | 99b9c12dedad337d0d8be15dbc1bd2a117b65ada | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11396 | 11396 | 20200306 | MI | 140 | 8 | 8 | 148 | 140 | 0 | 0 | 26 | 40 | 0 | 156 | posNeg | 40 | 148 | 0 | 0 | f456fc42c900ee27fd1e9fd8a0d36032c04c8e50 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11397 | 11397 | 20200306 | MN | 1 | 36 | 37 | 1 | 37 | 27 | 0 | 0 | 37 | posNeg | 0 | 37 | 0 | 0 | 618608ebdf7de7554f93a26951b8a3643d2182dc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11398 | 11398 | 20200306 | NC | 2 | 2 | 37 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | a4aed27dbdb2f9ff71c0f348fc90c564f2210717 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11399 | 11399 | 20200306 | NE | 0 | 17 | 5 | 17 | 31 | 0 | 0 | 22 | posNeg | 0 | 17 | 0 | 0 | 6da56387670a728983f956f991e0cf19846bdde2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11400 | 11400 | 20200306 | NH | 2 | 20 | 3 | 37 | 37 | 33 | 0 | 4 | 25 | posNeg | 28 | 22 | 0 | 0 | d4532943732dc63d6cbdb82f87e5f6966f043976 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11401 | 11401 | 20200306 | NJ | 1 | 1 | 0 | 4 | 0 | 1 | 34 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | d102d32355139886ec0279ef7e8f8c2edfda0aa6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11402 | 11402 | 20200306 | NM | 0 | 16 | 0 | 16 | 35 | 0 | 0 | 16 | posNeg | 0 | 16 | 0 | 0 | 414a0f66e731f99a7f9d317e7dca274c3902d71a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11403 | 11403 | 20200306 | NV | 3 | 14 | 17 | 0 | 3 | 0 | 32 | 2 | 0 | 17 | posNeg | 2 | 17 | 0 | 0 | c53d6487557461195c3d7e0f32b1764a4cf8d27e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11404 | 11404 | 20200306 | NY | 33 | 92 | 236 | 125 | 36 | 11 | 16 | 361 | posNeg | 27 | 125 | 0 | 0 | d6fb329fc7e2f5a6593ed3c3f4cdf8302dd618e0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11405 | 11405 | 20200306 | OH | 0 | 8 | 2 | 8 | 0 | 39 | 0 | 1 | 10 | posNeg | 1 | 8 | 0 | 0 | 668ec08d6188e1b95f66e01cfa4da7b5e159f9f4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11406 | 11406 | 20200306 | OR | 3 | 64 | 28 | 67 | 41 | 0 | 19 | 95 | posNeg | 19 | 67 | 0 | 0 | f2fd7b5ce756072c36971f105d5826f943a4479e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11407 | 11407 | 20200306 | PA | 2 | 2 | 42 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | e74dee4abf0f448eb5615b7c32b274c90d5cf773 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11408 | 11408 | 20200306 | RI | 3 | 30 | 23 | 3/6/2020 03:00 | 2020-03-06T03:00:00Z | 03/05 22:00 | 2020-03-06T03:00:00Z | 36 | 3 | 33 | 3 | 23 | 33 | 44 | 0 | 11 | 33 | totalTestEncountersViral | 4 | 33 | 0 | 0 | 94cf3581a7e7e8a9ccd01036d382b25a6ee05f7f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11409 | 11409 | 20200306 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | 3de143faa1d246d3569a4d73c92ce18796435321 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11410 | 11410 | 20200306 | TN | 1 | 1 | 47 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 7a49afb734c07d6d2218079f31202689c4f5cb75 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11411 | 11411 | 20200306 | TX | 5 | 5 | 5 | 48 | 4 | 0 | 5 | posNeg | 4 | 5 | 0 | 0 | 2e9ea0bb353851b7cc519c04dfb73aaa9b780b2e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11412 | 11412 | 20200306 | VA | 0 | 21 | 10 | 6455 | 2091 | 6455 | 51 | 0 | 3 | 31 | posNeg | 2 | 21 | 0 | 0 | 3e9d225703ba0e91aef31e54e91f29c40f90c47a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11413 | 11413 | 20200306 | VT | 0 | 0 | 0 | 3/6/2020 00:00 | 2020-03-06T00:00:00Z | 03/05 19:00 | 2020-03-06T00:00:00Z | 50 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 7007a9ae12fcf966fd1dfa485e055f1c22231ac4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11414 | 11414 | 20200306 | WA | 218 | 1449 | 1667 | 3/6/2020 00:00 | 2020-03-06T00:00:00Z | 03/05 19:00 | 26 | 2020-03-06T00:00:00Z | 218 | 1667 | 1604 | 53 | 39 | 472 | 1667 | posNeg | 511 | 1667 | 6 | 0 | d7697ac8b757e288de564fc3e921f159f5edced6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11415 | 11415 | 20200306 | WI | 1 | 31 | 12 | 32 | 1 | 55 | 0 | 12 | 44 | posNeg | 12 | 32 | 0 | 0 | 12346684fb2931edfd5aa8d3e50b09ba5276b57d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11416 | 11416 | 20200306 | WV | 0 | 1 | 4 | 1 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 1 | 0 | 0 | 72a7abd8de92bd9baf3046acd3ea566699d21e31 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11329 | 11329 | 20200307 | AK | 0 | 12 | 2 | 12 | 0 | 12 | 0 | 2 | 0 | 4 | 14 | posNeg | 4 | 12 | 0 | 0 | 8bfa10ec1a5b2be5876b88e6216bfea42987ea88 | 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 );