states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
72 rows where "dateModified" is on date 2020-08-15 sorted by positiveTestsAntigen
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateChecked (date)
Link | rowid | date | state | positive | negative | pending | totalTestResults | hospitalizedCurrently | hospitalizedCumulative | inIcuCurrently | inIcuCumulative | onVentilatorCurrently | onVentilatorCumulative | recovered | dataQualityGrade | lastUpdateEt | dateModified | checkTimeEt | death | hospitalized | dateChecked | totalTestsViral | positiveTestsViral | negativeTestsViral | positiveCasesViral | deathConfirmed | deathProbable | totalTestEncountersViral | totalTestsPeopleViral | totalTestsAntibody | positiveTestsAntibody | negativeTestsAntibody | totalTestsPeopleAntibody | positiveTestsPeopleAntibody | negativeTestsPeopleAntibody | totalTestsPeopleAntigen | positiveTestsPeopleAntigen | totalTestsAntigen | positiveTestsAntigen ▼ | fips | positiveIncrease | negativeIncrease | total | totalTestResultsSource | totalTestResultsIncrease | posNeg | deathIncrease | hospitalizedIncrease | hash | commercialScore | negativeRegularScore | negativeScore | positiveScore | score | grade |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1068 | 1068 | 20200907 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 5085675dfa58821863ab561c420b108feb82868d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1124 | 1124 | 20200906 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 8e9a58f72785fb83c490d6b168f1467bd6c2e8f8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1180 | 1180 | 20200905 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 78615189f736f50add2170e1fb8468820dba264a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1236 | 1236 | 20200904 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | f60826de4e95b3f4a2a0f00c53e1bde01483b6c9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1292 | 1292 | 20200903 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 56dee75bc9943e7392a15213f148aadf8d45c564 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1348 | 1348 | 20200902 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 48ebb399ca7a84fe4e65df7be64d01c2adde9b27 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1404 | 1404 | 20200901 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 9cd47401a2852789f2ffe4df905e7afe7ba9b228 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1460 | 1460 | 20200831 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | cc53fe6dbb4b1014666071c8137e9ff61190de7f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1516 | 1516 | 20200830 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | ce7b74310cafa44752eb4f0e5b23a30c760ffe5d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1572 | 1572 | 20200829 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | ace3adead0e717a1908206d95a6a168ac0c5208b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1628 | 1628 | 20200828 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | bd007bf503cf21da89c9fd0e523fe8e68ef9e187 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1684 | 1684 | 20200827 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | c6b2cab54df3e413abedb75e185c329fb41c667b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1740 | 1740 | 20200826 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | aac13db6ec3c1cfe1cf1996b28556c8c7987084f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1796 | 1796 | 20200825 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 17628746dfe619ea73b6c7ebdea57a4cea7b032d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1852 | 1852 | 20200824 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 4f0106743bce29e4b2be1e0ed425a249b04eac22 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1908 | 1908 | 20200823 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | cab50c36423df76c89e980f16a7e67f16f338caf | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
1964 | 1964 | 20200822 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | f640c36732d354d6976e889445d31dbd7f1c03dc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2020 | 2020 | 20200821 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 442f7b8d2753c777a4c1efd773f4ea05ebed9b9b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2076 | 2076 | 20200820 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 253eb739540d6dbaf16c30e7466db850d97a06ee | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2132 | 2132 | 20200819 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | 1225ed95030e2d45094d43c0baec361e076bae4b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2188 | 2188 | 20200818 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | e15cbe743620ba84d77003b1c7a5b6cc567aadb9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2244 | 2244 | 20200817 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | d838330cd9e50683afbbc69c0eb84837d96ee231 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2300 | 2300 | 20200816 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 0 | 1514 | posNeg | 0 | 1514 | 0 | 0 | b2f3a955ecb58143d87cd4ccda3518f56268799a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2303 | 2303 | 20200816 | CO | 52838 | 573467 | 859734 | 236 | 6727 | 5660 | A | 8/15/2020 01:59 | 2020-08-15T01:59:00Z | 08/14 21:59 | 1768 | 6727 | 2020-08-15T01:59:00Z | 49278 | 859734 | 622745 | 148571 | 10222 | 138349 | 8 | 300 | 5680 | 626305 | totalTestEncountersViral | 10939 | 626305 | 0 | 9 | 63767717fbd8c2ac9530c72449abee54a0eed714 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2305 | 2305 | 20200816 | DC | 13220 | 229632 | 242852 | 79 | 28 | 9 | 10493 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 597 | 2020-08-15T00:00:00Z | 242852 | 156592 | 11 | 61 | 3575 | 242852 | posNeg | 3636 | 242852 | 0 | 0 | 60d4a83be47253bc0791d570334644ceb802fcb1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2306 | 2306 | 20200816 | DE | 16451 | 193934 | 210385 | 30 | 8 | 8671 | A+ | 8/15/2020 18:00 | 2020-08-15T18:00:00Z | 08/15 14:00 | 593 | 2020-08-15T18:00:00Z | 15448 | 524 | 69 | 210385 | 10 | 55 | 1569 | 210385 | posNeg | 1624 | 210385 | 0 | 0 | 60a2cda9d782dc1d963420a518c091d9f6859206 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2307 | 2307 | 20200816 | FL | 573416 | 3659212 | 3791 | 4232628 | 5690 | 34341 | A | 8/15/2020 23:59 | 2020-08-15T23:59:00Z | 08/15 19:59 | 9587 | 34341 | 2020-08-15T23:59:00Z | 5679906 | 732039 | 4917254 | 573416 | 9587 | 4239309 | 408950 | 27323 | 381574 | 401862 | 26788 | 375046 | 5703 | 12 | 3779 | 26124 | 4236419 | posNeg | 29903 | 4232628 | 107 | 267 | 2d6992b003852cdc46b349a4b735c19b63ee62f9 | 0 | 0 | 0 | 0 | 0 | |||||||||||
2309 | 2309 | 20200816 | GU | 516 | 27257 | 27773 | 12 | 3 | 345 | A | 8/15/2020 20:00 | 2020-08-15T20:00:00Z | 08/15 16:00 | 5 | 2020-08-15T20:00:00Z | 27086 | 508 | 27765 | 153 | 2 | 66 | 14 | 663 | 27773 | posNeg | 677 | 27773 | 0 | 0 | fafac0f79f01f79129f259d297c2ea1563e78c04 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2312 | 2312 | 20200816 | ID | 27477 | 195745 | 221406 | 206 | 1103 | 38 | 312 | 10616 | A | 8/15/2020 19:00 | 2020-08-15T19:00:00Z | 08/15 15:00 | 269 | 1103 | 2020-08-15T19:00:00Z | 221406 | 25661 | 241 | 28 | 16 | 304 | 1906 | 223222 | posNeg | 2182 | 223222 | 4 | 12 | 123cbe3ca0a88d8127c12f715eb08698d09dd4d7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2314 | 2314 | 20200816 | IN | 80415 | 826436 | 906851 | 944 | 9935 | 265 | 2035 | 92 | 59801 | A+ | 8/15/2020 23:59 | 2020-08-15T23:59:00Z | 08/15 19:59 | 3133 | 9935 | 2020-08-15T23:59:00Z | 1162594 | 2924 | 209 | 906851 | 18 | 739 | 8497 | 906851 | posNeg | 9236 | 906851 | 5 | 63 | ac9e7d2e5a1cbb4323ed2bf86893144048ca7673 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2320 | 2320 | 20200816 | ME | 4168 | 206055 | 210223 | 9 | 400 | 2 | 1 | 3624 | A+ | 8/15/2020 23:59 | 2020-08-15T23:59:00Z | 08/15 19:59 | 127 | 400 | 2020-08-15T23:59:00Z | 209802 | 5241 | 204335 | 3747 | 126 | 1 | 9254 | 454 | 8787 | 23 | 24 | 2845 | 210223 | posNeg | 2869 | 210223 | 0 | 1 | 9d3a7b4b9c4249a705e8f0d27d2a16ed47d36f1c | 0 | 0 | 0 | 0 | 0 | |||||||||||||
2322 | 2322 | 20200816 | MN | 65152 | 928902 | 1254208 | 290 | 5851 | 152 | 1700 | 58196 | A | 8/15/2020 17:00 | 2020-08-15T17:00:00Z | 08/15 13:00 | 1752 | 5851 | 2020-08-15T17:00:00Z | 65152 | 1706 | 46 | 1254208 | 994054 | 27 | 739 | 8842 | 994054 | posNeg | 17290 | 994054 | 7 | 29 | f9d8a410d5b1c8562ae1653f64515e11f9d21e38 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2329 | 2329 | 20200816 | NE | 30241 | 290635 | 320876 | 144 | 1883 | 22251 | A | 8/15/2020 20:20 | 2020-08-15T20:20:00Z | 08/15 16:20 | 361 | 1883 | 2020-08-15T20:20:00Z | 30241 | 321172 | 31 | 253 | 2940 | 320876 | posNeg | 3193 | 320876 | 0 | 3 | 49885f3b66a9bcdd4648e4b89bb6615875a629b6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2332 | 2332 | 20200816 | NM | 23302 | 641989 | 665291 | 113 | 2957 | 10391 | B | 8/15/2020 17:50 | 2020-08-15T17:50:00Z | 08/15 13:50 | 711 | 2957 | 2020-08-15T17:50:00Z | 665291 | 23302 | 35 | 142 | 6107 | 665291 | posNeg | 6249 | 665291 | 8 | 11 | 05a18102e926976f001dc432c9080770492f4a6c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2334 | 2334 | 20200816 | NY | 425508 | 6642688 | 7068196 | 527 | 89995 | 128 | 59 | 74154 | A | 8/15/2020 23:59 | 2020-08-15T23:59:00Z | 08/15 19:59 | 25250 | 89995 | 2020-08-15T23:59:00Z | 425508 | 7068196 | 36 | 607 | 77085 | 7068196 | posNeg | 77692 | 7068196 | 6 | 0 | de87641fe8ec35e31a507f8dceb5b5a89d1fcef4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2341 | 2341 | 20200816 | SC | 106497 | 761104 | 867601 | 1161 | 6852 | 290 | 188 | 42730 | A+ | 8/15/2020 23:59 | 2020-08-15T23:59:00Z | 08/15 19:59 | 2269 | 6852 | 2020-08-15T23:59:00Z | 866570 | 140201 | 726369 | 105466 | 2165 | 104 | 61005 | 4700 | 56305 | 45 | 615 | 6586 | 867601 | posNeg | 7201 | 867601 | 9 | 0 | 48edfea5a5c22e9c4d66d55f5abbc72e805814bb | 0 | 0 | 0 | 0 | 0 | |||||||||||||
2342 | 2342 | 20200816 | SD | 10274 | 118500 | 128774 | 66 | 916 | 8939 | A | 8/15/2020 14:00 | 2020-08-15T14:00:00Z | 08/15 10:00 | 153 | 916 | 2020-08-15T14:00:00Z | 164103 | 128774 | 46 | 156 | 1169 | 128774 | posNeg | 1325 | 128774 | 1 | 3 | 9a75dc3134a4feb4670daf75b9ed94add992f414 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2346 | 2346 | 20200816 | VA | 106687 | 1247161 | 341 | 1349460 | 1184 | 14967 | 283 | 165 | 13783 | A+ | 8/15/2020 17:00 | 2020-08-15T17:00:00Z | 08/15 13:00 | 2381 | 14967 | 2020-08-15T17:00:00Z | 123419 | 102299 | 2266 | 115 | 1349460 | 51 | 937 | 15671 | 1354189 | posNeg | 16522 | 1353848 | 0 | 2 | 6d81e0bbf69c44c229d628944dfd69814144bd55 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
2349 | 2349 | 20200816 | WA | 68729 | 1229199 | 1297928 | 395 | 6230 | 55 | B | 8/15/2020 02:59 | 2020-08-15T02:59:00Z | 08/14 22:59 | 1766 | 6230 | 2020-08-15T02:59:00Z | 68729 | 1766 | 1297928 | 53 | 150 | 4801 | 1297928 | posNeg | 4951 | 1297928 | 11 | 24 | 38a1b8bc903021c2967c993326b6f8da57e3a3b8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2353 | 2353 | 20200815 | AK | 4954 | 291723 | 296677 | 36 | 4 | 1384 | A | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 28 | 2020-08-15T00:00:00Z | 296677 | 4706 | 291666 | 4954 | 28 | 2 | 85 | 663 | 296677 | posNeg | 748 | 296677 | 1 | 0 | 75625a6848e00bb0b5c31019ec1a68cdf14d6eed | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2354 | 2354 | 20200815 | AL | 107580 | 729437 | 832794 | 1259 | 12607 | 1313 | 719 | 41523 | B | 8/15/2020 11:00 | 2020-08-15T11:00:00Z | 08/15 07:00 | 1896 | 12607 | 2020-08-15T11:00:00Z | 832794 | 103357 | 1828 | 68 | 1 | 1271 | 10762 | 837017 | posNeg | 11923 | 837017 | 3 | 151 | 97b64a5b235fc93fea605d61901e7268cc137ca2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2356 | 2356 | 20200815 | AS | 0 | 1514 | 1514 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 0 | 2020-08-15T00:00:00Z | 1514 | 0 | 60 | 0 | 118 | 1514 | posNeg | 118 | 1514 | 0 | 0 | 250992829fdc1c50f85105908daf8b8da0f9f9b6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
2357 | 2357 | 20200815 | AZ | 192654 | 884537 | 1075748 | 1282 | 20795 | 442 | 284 | 27339 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 4492 | 20795 | 2020-08-15T00:00:00Z | 191211 | 4238 | 254 | 1075748 | 250030 | 4 | 933 | 8683 | 1077191 | posNeg | 9602 | 1077191 | 69 | 280 | 9b5cd28903e3877ce86cc1283b2a8d07c2413004 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2358 | 2358 | 20200815 | CA | 613689 | 9067422 | 9681111 | 6327 | 1812 | B | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 11147 | 2020-08-15T00:00:00Z | 9681111 | 613689 | 6 | 12614 | 111899 | 9681111 | posNeg | 124513 | 9681111 | 151 | 0 | 8b7c090cadb57ecda1d063479100c5a88eee2e75 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
2364 | 2364 | 20200815 | GA | 235168 | 1752898 | 1988066 | 2586 | 22028 | 4042 | A | 8/15/2020 14:50 | 2020-08-15T14:50:00Z | 08/15 10:50 | 4669 | 22028 | 2020-08-15T14:50:00Z | 1988066 | 213697 | 1774369 | 235168 | 251604 | 17676 | 13 | 3273 | 14740 | 1988066 | posNeg | 18013 | 1988066 | 96 | 210 | a4fc2865c036ba0fc361d39f0b3b9bf829ce4434 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2367 | 2367 | 20200815 | IA | 51793 | 494281 | 546074 | 261 | 82 | 35 | 40381 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 973 | 2020-08-15T00:00:00Z | 51793 | 553559 | 43996 | 2911 | 41046 | 19 | 861 | 4976 | 546074 | posNeg | 5837 | 546074 | 7 | 0 | 86b88a5c1de2d6dd46cbbfd56e88fbf056fea37a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2369 | 2369 | 20200815 | IL | 205851 | 3125243 | 3331094 | 1538 | 330 | 127 | A | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 7937 | 2020-08-15T00:00:00Z | 3329762 | 204519 | 7726 | 211 | 17 | 1828 | 42586 | 3331094 | posNeg | 44414 | 3331094 | 5 | 0 | 39c3b6114f6f1b3f847515728e0d59e794226efe | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2372 | 2372 | 20200815 | KY | 38930 | 673046 | 709163 | 618 | 4193 | 131 | 1304 | 9091 | B | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 810 | 4193 | 2020-08-15T00:00:00Z | 709163 | 36117 | 805 | 5 | 45157 | 665 | 21 | 632 | 10702 | 711976 | posNeg | 11254 | 711976 | 6 | 35 | 1c0153cc5d7f80b6659b7d5b90128c91792bc7b5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
2374 | 2374 | 20200815 | MA | 122897 | 1311604 | 1886299 | 375 | 12170 | 65 | 27 | 100486 | A+ | 8/15/2020 10:00 | 2020-08-15T10:00:00Z | 08/15 06:00 | 8818 | 12170 | 2020-08-15T10:00:00Z | 1886299 | 150687 | 114095 | 8596 | 222 | 1425699 | 104872 | 66513 | 25 | 366 | 22603 | 1434501 | totalTestsViral | 33267 | 1434501 | 14 | 20 | 52b6a7945175be0a23f25ed493a1b8d2295a2ff2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
2375 | 2375 | 20200815 | MD | 99693 | 1027959 | 1127652 | 460 | 13556 | 107 | 5995 | A | 8/15/2020 10:00 | 2020-08-15T10:00:00Z | 08/15 06:00 | 3636 | 13556 | 2020-08-15T10:00:00Z | 1585670 | 117306 | 99693 | 3499 | 137 | 1127652 | 24 | 818 | 16561 | 1127652 | posNeg | 17379 | 1127652 | 5 | 48 | 947e1a776bddffd9a605959fa5d874c60c9ae7b3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2377 | 2377 | 20200815 | MI | 101782 | 2189997 | 2291779 | 713 | 184 | 87 | 67778 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 6586 | 2020-08-15T00:00:00Z | 2319557 | 129560 | 2189997 | 92155 | 6318 | 268 | 237323 | 26 | 1058 | 29570 | 2291779 | posNeg | 30628 | 2291779 | 20 | 0 | 7b2ca3e51432df23eeb43276113d73b22f037033 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2379 | 2379 | 20200815 | MO | 66397 | 769044 | 835441 | 871 | 113 | A | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 1346 | 2020-08-15T00:00:00Z | 1106583 | 77152 | 1027492 | 66397 | 835441 | 64229 | 2492 | 61737 | 29 | 1127 | 9445 | 835441 | posNeg | 10572 | 835441 | 11 | 0 | 70c6b7c7eb6a4a68eeac1d79443e95ec3be9aebb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2382 | 2382 | 20200815 | MT | 5659 | 195277 | 200936 | 90 | 324 | 4123 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 82 | 324 | 2020-08-15T00:00:00Z | 200936 | 5659 | 30 | 118 | 957 | 200936 | posNeg | 1075 | 200936 | 1 | 5 | a405ded6c017d2444c382fca9120d19d59f8091a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2383 | 2383 | 20200815 | NC | 143706 | 1759695 | 1903401 | 1032 | 320 | 116969 | A+ | 8/15/2020 12:30 | 2020-08-15T12:30:00Z | 08/15 08:30 | 2343 | 2020-08-15T12:30:00Z | 1903401 | 143706 | 2343 | 37 | 1536 | 24463 | 1903401 | posNeg | 25999 | 1903401 | 30 | 0 | 44d3c72c2c74fb799347ead944ed730f238e962a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
2384 | 2384 | 20200815 | ND | 8439 | 169701 | 379816 | 55 | 457 | 7161 | C | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 105 | 457 | 2020-08-15T00:00:00Z | 391750 | 8439 | 101 | 4 | 379816 | 175603 | 8007 | 293 | 7714 | 38 | 123 | 1420 | 178140 | totalTestEncountersViral | 6266 | 178140 | 0 | 2 | ed950e27f88f29c57f09a354098d24c56ebc4464 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
2386 | 2386 | 20200815 | NH | 6980 | 176397 | 278912 | 15 | 706 | 218 | 6264 | B | 8/15/2020 09:00 | 2020-08-15T09:00:00Z | 08/15 05:00 | 423 | 706 | 2020-08-15T09:00:00Z | 278912 | 6980 | 183377 | 29130 | 28528 | 33 | 59 | 1702 | 183377 | posNeg | 3409 | 183377 | 1 | 1 | 3351f2e05275452b800c5514a0e9716b78ec923f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2387 | 2387 | 20200815 | NJ | 187442 | 2273941 | 2461383 | 520 | 22197 | 99 | 43 | 33264 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 15860 | 22197 | 2020-08-15T00:00:00Z | 2461383 | 187442 | 14071 | 1789 | 34 | 278 | 31264 | 2461383 | posNeg | 31542 | 2461383 | 9 | 36 | 7fd1e88d5d1477aee119e478e0ccf6f25e0b76aa | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2389 | 2389 | 20200815 | NV | 60608 | 482242 | 542850 | 941 | 258 | 166 | 1423 | A+ | 8/15/2020 02:59 | 2020-08-15T02:59:00Z | 08/14 22:59 | 1069 | 2020-08-15T02:59:00Z | 743871 | 60608 | 538202 | 32 | 859 | 3787 | 542850 | posNeg | 4646 | 542850 | 24 | 0 | 770b91785d5ff65f5d9a42c71d0c851d44ac2538 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
2391 | 2391 | 20200815 | OH | 107674 | 1694676 | 1802350 | 899 | 12210 | 318 | 2767 | 166 | 86018 | A+ | 8/15/2020 14:00 | 2020-08-15T14:00:00Z | 08/15 10:00 | 3824 | 12210 | 2020-08-15T14:00:00Z | 1796692 | 102016 | 3546 | 278 | 39 | 1117 | 21824 | 1802350 | posNeg | 22941 | 1802350 | 40 | 82 | 99d5a5206f48a51709b6d8a5fe0d2e727d0b3380 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2392 | 2392 | 20200815 | OK | 47798 | 706619 | 754417 | 506 | 3998 | 236 | 39907 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 657 | 3998 | 2020-08-15T00:00:00Z | 762899 | 54870 | 706619 | 47798 | 65475 | 2649 | 40 | 901 | 10274 | 754417 | posNeg | 11175 | 754417 | 13 | 45 | da85f89d625aba01c2035525aae1400804fed3c8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2393 | 2393 | 20200815 | OR | 23018 | 461861 | 484879 | 224 | 1863 | 57 | 16 | 4355 | A+ | 8/15/2020 03:01 | 2020-08-15T03:01:00Z | 08/14 23:01 | 386 | 1863 | 2020-08-15T03:01:00Z | 461861 | 21441 | 471935 | 41 | 405 | 11367 | 484879 | posNeg | 11772 | 484879 | 1 | 0 | 5b35228b3b7b8358db1283b2616cbe0a86f02baa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2394 | 2394 | 20200815 | PA | 123800 | 1319884 | 1443684 | 572 | 99 | 96564 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 7465 | 2020-08-15T00:00:00Z | 120346 | 1440230 | 42 | 850 | 15145 | 1443684 | posNeg | 15995 | 1443684 | 20 | 0 | c5e00f84194e039c66ba532f43eead48ec5e6954 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
2395 | 2395 | 20200815 | PR | 25695 | 305972 | 331667 | 406 | 66 | 46 | B | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 329 | 2020-08-15T00:00:00Z | 310546 | 7002 | 303412 | 11069 | 201 | 128 | 14626 | 72 | 567 | 0 | 331667 | posNeg | 567 | 331667 | 12 | 0 | 929a0c87bc8738480f1dd7cfac5925565e48c538 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
2396 | 2396 | 20200815 | RI | 20439 | 211327 | 425315 | 85 | 2375 | 11 | 2 | 1972 | A+ | 8/15/2020 12:00 | 2020-08-15T12:00:00Z | 08/15 08:00 | 1022 | 2375 | 2020-08-15T12:00:00Z | 29154 | 396161 | 20439 | 425315 | 231766 | 44 | 104 | 1797 | 231766 | totalTestEncountersViral | 4582 | 231766 | 1 | 25 | 11d0facde1c11fe07d1f515d506072be1b9afdce | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2399 | 2399 | 20200815 | TN | 131747 | 1698011 | 1829758 | 1307 | 5813 | 392 | 187 | 92100 | A+ | 8/15/2020 15:00 | 2020-08-15T15:00:00Z | 08/15 11:00 | 1345 | 5813 | 2020-08-15T15:00:00Z | 1827520 | 155633 | 1671887 | 129509 | 1304 | 41 | 47 | 1289 | 16426 | 1829758 | posNeg | 17715 | 1829758 | 19 | 88 | b361b923236ab0267a3e3b651bafba1bfaaafe04 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
2404 | 2404 | 20200815 | VT | 1509 | 108788 | 110297 | 14 | 1332 | B | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 58 | 2020-08-15T00:00:00Z | 1509 | 58 | 110297 | 50 | 8 | 2872 | 110297 | posNeg | 2880 | 110297 | 0 | 0 | 2d33152bfd9fc62e00e698e2c1d388c863328644 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
2406 | 2406 | 20200815 | WI | 69547 | 1055119 | 239 | 1124666 | 337 | 5275 | 96 | 954 | 55172 | A+ | 8/15/2020 00:00 | 2020-08-15T00:00:00Z | 08/14 20:00 | 1045 | 5275 | 2020-08-15T00:00:00Z | 65056 | 1038 | 7 | 1120175 | 55 | 866 | 10506 | 1124905 | posNeg | 11372 | 1124666 | 13 | 40 | 6044f631692909d8c15c124d03a807b62e63b394 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2407 | 2407 | 20200815 | WV | 8457 | 341787 | 350244 | 132 | 54 | 21 | 6298 | B | 8/15/2020 10:00 | 2020-08-15T10:00:00Z | 08/15 06:00 | 160 | 2020-08-15T10:00:00Z | 350076 | 8289 | 159 | 1 | 15072 | 54 | 183 | 5361 | 350244 | posNeg | 5544 | 350244 | 3 | 0 | d06b507eee9c4235c49f1bb6fc8c3f528d993855 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2408 | 2408 | 20200815 | WY | 3227 | 56809 | 60036 | 13 | 191 | 2659 | B | 8/15/2020 12:11 | 2020-08-15T12:11:00Z | 08/15 08:11 | 30 | 191 | 2020-08-15T12:11:00Z | 85877 | 2748 | 83128 | 2730 | 59503 | 56 | 44 | 0 | 60036 | posNeg | 44 | 60036 | 0 | 0 | d5a022404f4289e8a93b01c00e5a772428747b9c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2355 | 2355 | 20200815 | AR | 51992 | 536268 | 588660 | 464 | 3562 | 108 | 460 | 44905 | A | 8/15/2020 16:31 | 2020-08-15T16:31:00Z | 08/15 12:31 | 600 | 3562 | 2020-08-15T16:31:00Z | 588660 | 536268 | 51992 | 7090 | 1085 | 5 | -400 | 0 | 588260 | posNeg | 0 | 588260 | 13 | -4 | 7073efb6076ddc4526493942dff0937f8e77e138 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2400 | 2400 | 20200815 | TX | 528838 | 3792838 | 4321676 | 6481 | 2306 | 393266 | A | 8/15/2020 16:00 | 2020-08-15T16:00:00Z | 08/15 12:00 | 9840 | 2020-08-15T16:00:00Z | 4321676 | 528838 | 318938 | 23192 | 17011 | 2591 | 48 | 8245 | 31390 | 4321676 | posNeg | 39635 | 4321676 | 238 | 0 | 98fcde62dbc7ca6c35e8cc74a4e83014cd29c265 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
2401 | 2401 | 20200815 | UT | 46321 | 548580 | 594901 | 186 | 2760 | 64 | 707 | 286 | 37346 | A+ | 8/15/2020 10:28 | 2020-08-15T10:28:00Z | 08/15 06:28 | 363 | 2760 | 2020-08-15T10:28:00Z | 724237 | 46321 | 594901 | 2215 | 690 | 2672 | 740 | 49 | 345 | 4739 | 594901 | posNeg | 5084 | 594901 | 3 | 16 | 30da9704be850c6708fc9796022b3c1ada9af853 | 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 );