states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
61 rows where "dateModified" is on date 2020-03-30
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, recovered, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, deathIncrease, hospitalizedIncrease, dateChecked (date)
totalTestResultsSource ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9748 | 9748 | 20200405 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 50b0bf581bf52acb2f058136f521846cd6d93af2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9804 | 9804 | 20200404 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 45297872049fc2bc64ae664b1ffcd484db810b9f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9860 | 9860 | 20200403 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | d0ff9647302f774881b902572c312f142af3e56f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9916 | 9916 | 20200402 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | cccc2f8f22906b58a34ea2dacde38a8d2a318c96 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9972 | 9972 | 20200401 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | d3e447c2aa5e4107ee614da8de801a5d0a3105a9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10025 | 10025 | 20200331 | AK | 119 | 3594 | 3713 | 7 | A | 3/30/2020 19:00 | 2020-03-30T19:00:00Z | 03/30 15:00 | 3 | 7 | 2020-03-30T19:00:00Z | 3713 | 119 | 2 | 5 | 54 | 3713 | posNeg | 59 | 3713 | 0 | 0 | 905a33815e32c4645e4cfa40909151ef3b5086f8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10028 | 10028 | 20200331 | AS | 0 | 3 | 2 | 3 | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 0 | 2020-03-30T00:00:00Z | 3 | 0 | 60 | 0 | 3 | 5 | posNeg | 3 | 3 | 0 | 0 | 1aa73b4235d97ea1e7c69f21a3cce6807b07fb59 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10031 | 10031 | 20200331 | CO | 2627 | 12737 | 17107 | 503 | 414 | A | 3/30/2020 18:00 | 2020-03-30T18:00:00Z | 03/30 14:00 | 51 | 414 | 2020-03-30T18:00:00Z | 17107 | 15364 | 8 | 0 | 0 | 15364 | totalTestEncountersViral | 1633 | 15364 | 0 | 0 | bc99ee8c7f6dc958bd4b54570110af56d6f31601 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
10033 | 10033 | 20200331 | DC | 495 | 3262 | 2 | 3757 | 121 | A | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 9 | 2020-03-30T00:00:00Z | 3757 | 11 | 94 | 580 | 3759 | posNeg | 674 | 3757 | 0 | 0 | 143b12eb5157016f78ec8ba8d79d06423e42936b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10038 | 10038 | 20200331 | HI | 204 | 8471 | 8675 | 12 | 6 | 49 | A | 3/30/2020 18:00 | 2020-03-30T18:00:00Z | 03/30 14:00 | 12 | 2020-03-30T18:00:00Z | 15 | 29 | 646 | 8675 | posNeg | 675 | 8675 | 0 | 0 | 00d460f4d453510f32d4be9b42616db69ce8e694 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10040 | 10040 | 20200331 | ID | 415 | 5297 | 5712 | 45 | 45 | 6 | A | 3/30/2020 19:00 | 2020-03-30T19:00:00Z | 03/30 15:00 | 7 | 45 | 2020-03-30T19:00:00Z | 5712 | 16 | 105 | 901 | 5712 | posNeg | 1006 | 5712 | 1 | 6 | 9b9c84da628727306d61aacd3349dc0ea617149f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
10042 | 10042 | 20200331 | IN | 2159 | 11214 | 13373 | B | 3/30/2020 12:59 | 2020-03-30T12:59:00Z | 03/30 08:59 | 49 | 2020-03-30T12:59:00Z | 18 | 373 | 1342 | 13373 | posNeg | 1715 | 13373 | 14 | 0 | 28c79e87e40c2f383d39d1a409491d0882b4bacb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10044 | 10044 | 20200331 | KY | 480 | 6330 | 6810 | A | 3/30/2020 17:00 | 2020-03-30T17:00:00Z | 03/30 13:00 | 11 | 2020-03-30T17:00:00Z | 6810 | 21 | 41 | 751 | 6810 | posNeg | 792 | 6810 | 2 | 0 | 210f317b71e198ff8f761c0eaeefed3c08dbe692 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10052 | 10052 | 20200331 | MP | 2 | 2 | 3/30/2020 18:30 | 2020-03-30T18:30:00Z | 03/30 14:30 | 2020-03-30T18:30:00Z | 69 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | dbbaa90d13abe787feca37e2927d9037e8d75027 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10053 | 10053 | 20200331 | MS | 937 | 3537 | 4474 | 211 | B | 3/30/2020 19:00 | 2020-03-30T19:00:00Z | 03/30 15:00 | 20 | 211 | 2020-03-30T19:00:00Z | 28 | 90 | 548 | 4474 | posNeg | 638 | 4474 | 4 | 16 | 61a67082103a06b265cf4912321ef39c5e1f60d5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10058 | 10058 | 20200331 | NH | 314 | 5413 | 65 | 6240 | 45 | B | 3/30/2020 09:00 | 2020-03-30T09:00:00Z | 03/30 05:00 | 3 | 45 | 2020-03-30T09:00:00Z | 6240 | 33 | 0 | 27 | 5792 | posNeg | 250 | 5727 | 0 | 0 | 0531660af4d1814ad46545ceaa3453689c4967c5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10067 | 10067 | 20200331 | PR | 239 | 1195 | 854 | 1434 | A | 3/30/2020 07:00 | 2020-03-30T07:00:00Z | 03/30 03:00 | 8 | 2020-03-30T07:00:00Z | 72 | 65 | 264 | 2288 | posNeg | 329 | 1434 | 2 | 0 | 3ddaa0a96149b3f8d28224622e11be3631f0fa99 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10075 | 10075 | 20200331 | VI | 30 | 126 | 24 | 156 | 21 | 3/30/2020 17:00 | 2020-03-30T17:00:00Z | 03/30 13:00 | 2020-03-30T17:00:00Z | 78 | 0 | 0 | 180 | posNeg | 0 | 156 | 0 | 0 | 0e9c61cbce62c1aeae970340105d7cd5de406c50 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10083 | 10083 | 20200330 | AR | 473 | 5262 | 5735 | 62 | 21 | 29 | A | 3/30/2020 15:42 | 2020-03-30T15:42:00Z | 03/30 11:42 | 7 | 2020-03-30T15:42:00Z | 5735 | 473 | 5 | 47 | 2235 | 5735 | posNeg | 2282 | 5735 | 1 | 0 | e6ccb74dba98f14e6fd9ec41f5666479d976a7c1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
10084 | 10084 | 20200330 | AS | 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 | posNeg | 0 | 0 | 0 | 0 | c49b358f37e9f829975f04b2f83c70581fd3a503 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10085 | 10085 | 20200330 | AZ | 1157 | 15602 | 16759 | 478 | B | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 20 | 478 | 2020-03-30T00:00:00Z | 16759 | 4 | 238 | 2649 | 16759 | posNeg | 2887 | 16759 | 3 | 51 | 7deab55382f30912abd1024fb527ba346162b159 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10086 | 10086 | 20200330 | CA | 6447 | 20549 | 64400 | 26996 | 1432 | 597 | B | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 133 | 2020-03-30T00:00:00Z | 26996 | 6 | 739 | 0 | 91396 | posNeg | 739 | 26996 | 10 | 0 | 91974451ba9ca5788549dd50e578e8fb2253da3e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10087 | 10087 | 20200330 | CO | 2627 | 12737 | 15474 | 358 | 414 | A | 3/30/2020 17:00 | 2020-03-30T17:00:00Z | 03/30 13:00 | 51 | 414 | 2020-03-30T17:00:00Z | 15474 | 14470 | 8 | 566 | 1522 | 15364 | totalTestEncountersViral | 1283 | 15364 | 7 | 140 | 7e065a3286986b529b4f46f11ebe461311a4e2bd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
10088 | 10088 | 20200330 | CT | 2571 | 12029 | 14600 | 517 | A | 3/30/2020 11:30 | 2020-03-30T11:30:00Z | 03/30 07:30 | 36 | 2020-03-30T11:30:00Z | 14600 | 19 | 9 | 578 | 2122 | 14600 | posNeg | 2700 | 14600 | 2 | 0 | 99bad43dcd006c7cdd6c2439a2379aca95dd03f3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10090 | 10090 | 20200330 | DE | 264 | 2216 | 2480 | 45 | 9 | C | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 11 | 2020-03-30T00:00:00Z | 11 | 0 | 10 | 32 | 2180 | 2480 | posNeg | 2212 | 2480 | 1 | 0 | 13a76336f57d6262a375e081bca1fdaee6b4bd8c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10091 | 10091 | 20200330 | FL | 5473 | 48225 | 53698 | 652 | A | 3/30/2020 11:30 | 2020-03-30T11:30:00Z | 03/30 07:30 | 63 | 652 | 2020-03-30T11:30:00Z | 12 | 1227 | 9155 | 53698 | posNeg | 10382 | 53698 | 7 | 58 | 3cf80b2362aefc960f8b7fb8e2ec10e4359bf685 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10092 | 10092 | 20200330 | GA | 2809 | 9915 | 12724 | 707 | A | 3/30/2020 11:28 | 2020-03-30T11:28:00Z | 03/30 07:28 | 87 | 707 | 2020-03-30T11:28:00Z | 12724 | 13 | 158 | 2 | 12724 | posNeg | 160 | 12724 | 7 | 41 | 33363e74ee45f8741e4df205cc9f57feae182382 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10093 | 10093 | 20200330 | GU | 58 | 352 | 410 | 19 | 2 | 7 | 3/30/2020 04:30 | 2020-03-30T04:30:00Z | 03/30 00:30 | 1 | 2020-03-30T04:30:00Z | 66 | 2 | 18 | 410 | posNeg | 20 | 410 | 0 | 0 | 7e5e7b14454c455dd2c6a6e23c39a63a23d59157 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10095 | 10095 | 20200330 | IA | 424 | 6162 | 6586 | 51 | 74 | 23 | C | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 6 | 74 | 2020-03-30T00:00:00Z | 424 | 19 | 88 | 1149 | 6586 | posNeg | 1237 | 6586 | 2 | 6 | b5ecf3da502eab44484d9f5caada6a2671ae8ebf | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
10099 | 10099 | 20200330 | KS | 368 | 4554 | 4922 | 66 | B | 3/30/2020 11:00 | 2020-03-30T11:00:00Z | 03/30 07:00 | 8 | 66 | 2020-03-30T11:00:00Z | 20 | 49 | 360 | 4922 | posNeg | 409 | 4922 | 2 | 11 | c56f0a6656acb354c82dccce62d80893ced422f3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10101 | 10101 | 20200330 | LA | 4025 | 30008 | 34033 | 1185 | 385 | A | 3/30/2020 13:00 | 2020-03-30T13:00:00Z | 03/30 09:00 | 185 | 2020-03-30T13:00:00Z | 4025 | 22 | 485 | 5677 | 34033 | posNeg | 6162 | 34033 | 34 | 0 | 926facbb164ca72b15e8e332443a32237516580f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10102 | 10102 | 20200330 | MA | 5653 | 37166 | 58064 | 453 | B | 3/30/2020 16:15 | 2020-03-30T16:15:00Z | 03/30 12:15 | 124 | 453 | 2020-03-30T16:15:00Z | 58064 | 9117 | 25 | 797 | 2932 | 42819 | totalTestsViral | 5581 | 42819 | 25 | 54 | 47baf105b140bc2b64ca6a8b21f6b0493add42b1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10103 | 10103 | 20200330 | MD | 1413 | 13316 | 14729 | 353 | A | 3/30/2020 10:00 | 2020-03-30T10:00:00Z | 03/30 06:00 | 35 | 353 | 2020-03-30T10:00:00Z | 13204 | 1537 | 1413 | 34 | 1 | 24 | 174 | 962 | 14729 | posNeg | 1136 | 14729 | 11 | 76 | 81d3e1d2ef85c5bad3ec6b21dc7b615178e2fe7e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
10104 | 10104 | 20200330 | ME | 275 | 3394 | 3669 | 49 | 41 | A | 3/30/2020 12:00 | 2020-03-30T12:00:00Z | 03/30 08:00 | 3 | 49 | 2020-03-30T12:00:00Z | 275 | 23 | 22 | 0 | 3669 | posNeg | 22 | 3669 | 0 | 49 | 7c6a8f84d8931ec456ea2c1e2eb0bb918cf5b113 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10105 | 10105 | 20200330 | MI | 17363 | 23263 | 40626 | B | 3/30/2020 16:00 | 2020-03-30T16:00:00Z | 03/30 12:00 | 437 | 2020-03-30T16:00:00Z | 32172 | 8909 | 23263 | 17058 | 518 | 29 | 26 | 1579 | 5846 | 40626 | posNeg | 7425 | 40626 | 86 | 0 | 349800c122ab3392fa9a11e39275a49889c44d14 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
10106 | 10106 | 20200330 | MN | 823 | 19512 | 20335 | 56 | 92 | 24 | 24 | A | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 10 | 92 | 2020-03-30T00:00:00Z | 823 | 20335 | 27 | 98 | 946 | 20335 | posNeg | 1044 | 20335 | 1 | 17 | e6ea27d08ca9b9822914ff94c26e73fed795d68e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
10107 | 10107 | 20200330 | MO | 1031 | 13204 | 14235 | C | 3/30/2020 16:00 | 2020-03-30T16:00:00Z | 03/30 12:00 | 13 | 2020-03-30T16:00:00Z | 18299 | 1898 | 16387 | 1031 | 29 | 193 | 1657 | 14235 | posNeg | 1850 | 14235 | 3 | 0 | 700f6f143d67c0e709caad7d19242910b798576e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10108 | 10108 | 20200330 | MP | 2 | 2 | 3/30/2020 01:30 | 2020-03-30T01:30:00Z | 03/29 21:30 | 2020-03-30T01:30:00Z | 69 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 6ffdffde1257371ad982b7061de5df8345fc225c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10110 | 10110 | 20200330 | MT | 171 | 4143 | 4314 | 10 | A | 3/30/2020 10:00 | 2020-03-30T10:00:00Z | 03/30 06:00 | 4 | 10 | 2020-03-30T10:00:00Z | 3885 | 30 | 17 | 0 | 4314 | posNeg | 17 | 4314 | 3 | 2 | 76133602f3bfea6f5d00a8a9d3b1d5b4039d9fd9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10111 | 10111 | 20200330 | NC | 1307 | 19557 | 20864 | 137 | A | 3/30/2020 11:00 | 2020-03-30T11:00:00Z | 03/30 07:00 | 6 | 2020-03-30T11:00:00Z | 37 | 267 | 1652 | 20864 | posNeg | 1919 | 20864 | 2 | 0 | d23fb6e92aff3cdc0c77e8575e1d2f9eca213b11 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10112 | 10112 | 20200330 | ND | 107 | 3728 | 3868 | 19 | 19 | B | 3/30/2020 12:00 | 2020-03-30T12:00:00Z | 03/30 08:00 | 2 | 19 | 2020-03-30T12:00:00Z | 3892 | 107 | 3868 | 3743 | 38 | 10 | 373 | 3835 | totalTestEncountersViral | 294 | 3835 | 1 | 2 | 5e6c20c3a848abd62b2687cc1f28e1d867a56fa6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
10113 | 10113 | 20200330 | NE | 145 | 2584 | 5 | 2729 | A | 3/30/2020 14:30 | 2020-03-30T14:30:00Z | 03/30 10:30 | 2 | 2020-03-30T14:30:00Z | 2734 | 31 | 37 | 616 | 2734 | posNeg | 653 | 2729 | 0 | 0 | 7e957680c836c5762343c239214626d83d6a5a18 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10117 | 10117 | 20200330 | NV | 996 | 10207 | 11203 | A | 3/30/2020 12:00 | 2020-03-30T12:00:00Z | 03/30 08:00 | 32 | 2020-03-30T12:00:00Z | 13349 | 996 | 32 | 258 | 1795 | 11203 | posNeg | 2053 | 11203 | 4 | 0 | 98d2fbfc18d5f7feeb8f7bf9e7dd0835a8cbe170 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10119 | 10119 | 20200330 | OH | 1933 | 25342 | 27275 | 475 | 163 | B | 3/30/2020 14:00 | 2020-03-30T14:00:00Z | 03/30 10:00 | 39 | 475 | 2020-03-30T14:00:00Z | 1933 | 39 | 280 | 6330 | 27275 | posNeg | 6610 | 27275 | 10 | 72 | cc34ca508f108a9c54a59523c56304175ec6a0f8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10120 | 10120 | 20200330 | OK | 481 | 1207 | 1688 | 153 | 103 | B | 3/30/2020 08:00 | 2020-03-30T08:00:00Z | 03/30 04:00 | 17 | 153 | 2020-03-30T08:00:00Z | 40 | 52 | 2 | 1688 | posNeg | 54 | 1688 | 1 | 13 | 405bc10c4a5a9b52ad33a715006473b5be86b9af | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10121 | 10121 | 20200330 | OR | 606 | 12277 | 12883 | 132 | 140 | 39 | A | 3/30/2020 11:00 | 2020-03-30T11:00:00Z | 03/30 07:00 | 16 | 140 | 2020-03-30T11:00:00Z | 41 | 58 | 1399 | 12883 | posNeg | 1457 | 12883 | 3 | 11 | 3a4b8e7ef2fc6ed651434fab880f4941b2e44c00 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10122 | 10122 | 20200330 | PA | 4087 | 33777 | 37864 | 386 | A | 3/30/2020 12:00 | 2020-03-30T12:00:00Z | 03/30 08:00 | 49 | 386 | 2020-03-30T12:00:00Z | 37864 | 42 | 693 | 3716 | 37864 | posNeg | 4409 | 37864 | 11 | 33 | 432cfc467aaa022a92745f9dcfdcec45791f73ab | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10123 | 10123 | 20200330 | PR | 174 | 931 | 794 | 1105 | A | 3/30/2020 07:00 | 2020-03-30T07:00:00Z | 03/30 03:00 | 6 | 2020-03-30T07:00:00Z | 72 | 47 | 90 | 1899 | posNeg | 137 | 1105 | 1 | 0 | 7c293601a5d8b51f2a4bc5e73e79f51a49c59c55 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10124 | 10124 | 20200330 | RI | 495 | 3246 | 3613 | 41 | 9 | 6 | B | 3/30/2020 03:00 | 2020-03-30T03:00:00Z | 03/29 23:00 | 4 | 2020-03-30T03:00:00Z | 3933 | 484 | 3449 | 495 | 3613 | 3741 | 44 | 78 | 190 | 3741 | totalTestEncountersViral | 450 | 3741 | 1 | 0 | c3635901cfdc15ad7006fb61d2866ac538599a60 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
10125 | 10125 | 20200330 | SC | 925 | 4160 | 5085 | 102 | B | 3/30/2020 16:00 | 2020-03-30T16:00:00Z | 03/30 12:00 | 18 | 102 | 2020-03-30T16:00:00Z | 925 | 45 | 151 | 1145 | 5085 | posNeg | 1296 | 5085 | 2 | 0 | 8222bb4aa469657003fa0e4e5809479ae1196d60 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10126 | 10126 | 20200330 | SD | 101 | 3478 | 0 | 3579 | 34 | A | 3/30/2020 12:30 | 2020-03-30T12:30:00Z | 03/30 08:30 | 1 | 2020-03-30T12:30:00Z | 3579 | 46 | 11 | 351 | 3579 | posNeg | 362 | 3579 | 0 | 0 | 3b99fe44d0fbf10566fc0b8dd321e33744c4d751 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10127 | 10127 | 20200330 | TN | 1834 | 21470 | 23304 | 148 | A | 3/30/2020 15:00 | 2020-03-30T15:00:00Z | 03/30 11:00 | 13 | 148 | 2020-03-30T15:00:00Z | 47 | 297 | 2433 | 23304 | posNeg | 2730 | 23304 | 6 | 15 | 4df4fab4340f6daab5f4125d83061cbaf5f632b4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10128 | 10128 | 20200330 | TX | 2877 | 33003 | 35880 | 38 | A | 3/30/2020 12:45 | 2020-03-30T12:45:00Z | 03/30 08:45 | 34 | 2020-03-30T12:45:00Z | 2877 | 48 | 325 | 9795 | 35880 | posNeg | 10120 | 35880 | 0 | 0 | 617d02733d60699547d971ceb681de58963336d6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10129 | 10129 | 20200330 | UT | 806 | 15197 | 16003 | A | 3/30/2020 15:00 | 2020-03-30T15:00:00Z | 03/30 11:00 | 4 | 2020-03-30T15:00:00Z | 806 | 49 | 87 | 1923 | 16003 | posNeg | 2010 | 16003 | 2 | 0 | b4fc20abfe884d22c68fb7e0559caafad291169e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10130 | 10130 | 20200330 | VA | 1020 | 11018 | 19708 | 136 | A | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 25 | 136 | 2020-03-30T00:00:00Z | 3613 | 19708 | 51 | 130 | 1299 | 12038 | posNeg | 1386 | 12038 | 3 | 24 | f4662d0203413e7ed39b21a4afd5ebed2aef0a02 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10131 | 10131 | 20200330 | VI | 30 | 126 | 24 | 156 | 3/30/2020 11:00 | 2020-03-30T11:00:00Z | 03/30 07:00 | 2020-03-30T11:00:00Z | 78 | 7 | 3 | 180 | posNeg | 10 | 156 | 0 | 0 | a60a10a532d97dc76143af465e60e8612183efce | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
10132 | 10132 | 20200330 | VT | 293 | 3718 | 4011 | 18 | A | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 12 | 18 | 2020-03-30T00:00:00Z | 293 | 50 | 37 | 235 | 4011 | posNeg | 272 | 4011 | 0 | 0 | 16cc44766d4240fdc47056aca64fee06c0a694b9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10133 | 10133 | 20200330 | WA | 6484 | 77047 | 83531 | A | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 248 | 2020-03-30T00:00:00Z | 6484 | 83531 | 80687 | 53 | 563 | 4887 | 83531 | posNeg | 5450 | 83531 | 11 | 0 | 1803a5560bf9e6d72b9e6b9f473c2a2ca066cf14 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
10134 | 10134 | 20200330 | WI | 1422 | 15856 | 17278 | A | 3/30/2020 16:00 | 2020-03-30T16:00:00Z | 03/30 12:00 | 14 | 2020-03-30T16:00:00Z | 1221 | 55 | 146 | -694 | 17278 | posNeg | -548 | 17278 | 1 | 0 | 63cc9b10a51a4e91a14af125188942da51998d96 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
10135 | 10135 | 20200330 | WV | 126 | 2984 | 0 | 3110 | 1 | B | 3/30/2020 14:10 | 2020-03-30T14:10:00Z | 03/30 10:10 | 1 | 1 | 2020-03-30T14:10:00Z | 126 | 54 | 13 | 279 | 3110 | posNeg | 292 | 3110 | 1 | 0 | 5f8ac5e1685384f03374dfe2ce528cabd8511332 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
10136 | 10136 | 20200330 | WY | 94 | 1840 | 1934 | 17 | 24 | A | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 0 | 17 | 2020-03-30T00:00:00Z | 87 | 56 | 8 | 286 | 1934 | posNeg | 294 | 1934 | 0 | 2 | 801e151b2494908fa8d772721975cff4fe9d05ef | 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 );