states_current
Data source: Big Local News · About: big-local-datasette
24 rows where dataQualityGrade = "A+"
This data as json, copyable, CSV (advanced)
Suggested facets: pending, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, positiveIncrease, negativeIncrease, totalTestResultsSource, totalTestResultsIncrease, deathIncrease, hospitalizedIncrease, dateModified (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | 20200926 | AR | 80755 | 855635 | 933895 | 447 | 5202 | 213 | 91 | 657 | 72051 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1285 | 5202 | 2020-09-26T00:00:00Z | 933895 | 855635 | 78260 | 1137 | 148 | 10264 | 2706 | 21856 | 3300 | 5 | 809 | 6813 | 936390 | posNeg | 7601 | 936390 | 19 | 0 | 1177f6d15b81adb770caebd6b66b47189c93f198 | 0 | 0 | 0 | 0 | 0 | ||||||||||||
5 | 5 | 20200926 | AZ | 216826 | 1221851 | 1434227 | 509 | 22005 | 115 | 56 | 34730 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 5622 | 22005 | 2020-09-26T00:00:00Z | 212376 | 5355 | 267 | 1434227 | 290470 | 4 | 459 | 10194 | 1438677 | posNeg | 10624 | 1438677 | 35 | 33 | 130636fd317b3160d4644679abe3501863463881 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
9 | 9 | 20200926 | DC | 15215 | 362764 | 377979 | 101 | 25 | 17 | 12029 | A+ | 9/25/2020 00:00 | 2020-09-25T00:00:00Z | 09/24 20:00 | 624 | 2020-09-25T00:00:00Z | 377979 | 211599 | 11 | 52 | 4341 | 377979 | posNeg | 4393 | 377979 | 1 | 0 | 5dd3065a746eea8ae0e9a70d3218cd0129db3054 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
10 | 10 | 20200926 | DE | 20156 | 260243 | 280399 | 57 | 10 | 10541 | A+ | 9/25/2020 18:00 | 2020-09-25T18:00:00Z | 09/25 14:00 | 633 | 2020-09-25T18:00:00Z | 19103 | 556 | 77 | 280399 | 10 | 71 | 954 | 280399 | posNeg | 1025 | 280399 | 2 | 0 | e3e0fc4116a2a29665fe6bffd51a89a13780977a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
15 | 15 | 20200926 | IA | 82944 | 667954 | 750898 | 334 | 84 | 29 | 65490 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1311 | 2020-09-26T00:00:00Z | 82944 | 752449 | 57997 | 3389 | 54568 | 20350 | 2645 | 19 | 899 | 5018 | 750898 | posNeg | 5917 | 750898 | 4 | 0 | 47decf503735f781b057e655041ca39b2b4fb714 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
18 | 18 | 20200926 | IN | 116549 | 1233841 | 1350390 | 910 | 12521 | 259 | 2497 | 92 | 92306 | A+ | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 3577 | 12521 | 2020-09-25T23:59:00Z | 1989928 | 3351 | 226 | 1350390 | 18 | 1142 | 7786 | 1350390 | posNeg | 8928 | 1350390 | 11 | 58 | c434c8dc087571d7e42607998e7613c3f97def2f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
19 | 19 | 20200926 | KS | 56592 | 446178 | 502770 | 343 | 2816 | 121 | 768 | 34 | 250 | 2039 | A+ | 9/25/2020 10:00 | 2020-09-25T10:00:00Z | 09/25 06:00 | 632 | 2816 | 2020-09-25T10:00:00Z | 502770 | 20 | 0 | 0 | 502770 | posNeg | 0 | 502770 | 0 | 0 | 1468f023cf5cebe6e0d2f0752a5b054eecc06b87 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
22 | 22 | 20200926 | MA | 130050 | 2046728 | 3780020 | 354 | 12637 | 77 | 28 | 111479 | A+ | 9/26/2020 08:00 | 2020-09-26T08:00:00Z | 09/26 04:00 | 9391 | 12637 | 2020-09-26T08:00:00Z | 3780020 | 167823 | 127832 | 9178 | 213 | 2174560 | 119693 | 126039 | 25 | 569 | 13795 | 2176778 | totalTestsViral | 73292 | 2176778 | 18 | 18 | 6b3d0a05572af2a2470ddc16f5fda3df4be4692c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
24 | 24 | 20200926 | ME | 5260 | 401159 | 406419 | 8 | 443 | 1 | 0 | 4538 | A+ | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 140 | 443 | 2020-09-25T23:59:00Z | 405850 | 6490 | 399070 | 4713 | 139 | 1 | 10270 | 516 | 9740 | 23 | 25 | 0 | 406419 | posNeg | 25 | 406419 | 0 | 1 | 7ed34c8487da7bfb9b9473f129d8e5a25a1c0056 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
25 | 25 | 20200926 | MI | 134373 | 3408684 | 3543057 | 558 | 139 | 52 | 95051 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 7044 | 2020-09-26T00:00:00Z | 3578584 | 169900 | 3408684 | 121427 | 6723 | 321 | 291180 | 26 | 996 | 39749 | 3543057 | posNeg | 40745 | 3543057 | 17 | 0 | 2e49e36255f6a6daef66f967af21b911b45c97ad | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
29 | 29 | 20200926 | MS | 96677 | 634036 | 730713 | 601 | 5607 | 147 | 68 | 85327 | A+ | 9/25/2020 00:00 | 2020-09-25T00:00:00Z | 09/24 20:00 | 2911 | 5607 | 2020-09-25T00:00:00Z | 723389 | 89353 | 2686 | 225 | 38425 | 95 | 55557 | 28 | 645 | 3682 | 730713 | posNeg | 4327 | 730713 | 17 | 0 | 25c406301ef686539186978256312931e29136fe | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
31 | 31 | 20200926 | NC | 206090 | 2741713 | 2947803 | 914 | 272 | 176422 | A+ | 9/26/2020 12:00 | 2020-09-26T12:00:00Z | 09/26 08:00 | 3440 | 2020-09-26T12:00:00Z | 2943144 | 201431 | 3440 | 37 | 1759 | 38427 | 2947803 | posNeg | 40186 | 2947803 | 31 | 0 | 20a1b19461a3df0fea54c6dfb6ffc967453a835b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
35 | 35 | 20200926 | NJ | 202850 | 3309718 | 3512568 | 426 | 23324 | 88 | 38 | 34650 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 16103 | 23324 | 2020-09-26T00:00:00Z | 3512568 | 202850 | 14312 | 1791 | 34 | 750 | 33107 | 3512568 | posNeg | 33857 | 3512568 | 6 | 39 | cd73d3de8c388876eca2bfe00d66d734af82857f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
37 | 37 | 20200926 | NV | 78355 | 607323 | 685678 | 442 | 125 | 64 | 2075 | A+ | 9/26/2020 02:59 | 2020-09-26T02:59:00Z | 09/25 22:59 | 1582 | 2020-09-26T02:59:00Z | 1026486 | 78355 | 684796 | 32 | 602 | 3740 | 685678 | posNeg | 4342 | 685678 | 9 | 0 | 6562d5250f6a1ba7ad8affc64c3a68a2b09dd5cd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
39 | 39 | 20200926 | OH | 150009 | 2883978 | 3033987 | 625 | 15185 | 205 | 3247 | 95 | 129498 | A+ | 9/26/2020 14:00 | 2020-09-26T14:00:00Z | 09/26 10:00 | 4740 | 15185 | 2020-09-26T14:00:00Z | 3025649 | 141671 | 4439 | 301 | 39 | 1115 | 37279 | 3033987 | posNeg | 38394 | 3033987 | 6 | 58 | bc6ac50a6f9a24d96bc3280b69d405cfab1f7ca9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
40 | 40 | 20200926 | OK | 83510 | 1075475 | 6653 | 1158985 | 579 | 6252 | 223 | 69754 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1004 | 6252 | 2020-09-26T00:00:00Z | 1172554 | 94741 | 1075475 | 83510 | 78836 | 3997 | 40 | 990 | 17331 | 1165638 | posNeg | 18321 | 1158985 | 11 | 60 | 832a286352d7b6c33cd6f7c2aca41c1e843e62b5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
41 | 41 | 20200926 | OR | 32581 | 636090 | 668671 | 199 | 2496 | 40 | 14 | 5490 | A+ | 9/26/2020 03:01 | 2020-09-26T03:01:00Z | 09/25 23:01 | 546 | 2496 | 2020-09-26T03:01:00Z | 636090 | 30742 | 661334 | 41 | 267 | 5498 | 668671 | posNeg | 5765 | 668671 | 4 | 0 | 76f49d2ef6b4e575aed9232f25aefd8711244bf3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
42 | 42 | 20200926 | PA | 155232 | 1830292 | 1985524 | 444 | 60 | 127290 | A+ | 9/26/2020 12:00 | 2020-09-26T12:00:00Z | 09/26 08:00 | 8103 | 2020-09-26T12:00:00Z | 2898629 | 150393 | 1980685 | 42 | 1029 | 13895 | 1985524 | posNeg | 14924 | 1985524 | 22 | 0 | 95db3b8c62ccc9249c12e799648a8351f5b7337f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
44 | 44 | 20200926 | RI | 24181 | 305853 | 727469 | 94 | 2725 | 8 | 4 | 2278 | A+ | 9/25/2020 12:00 | 2020-09-25T12:00:00Z | 09/25 08:00 | 1107 | 2725 | 2020-09-25T12:00:00Z | 34299 | 693170 | 24181 | 727469 | 330034 | 44 | 0 | 0 | 330034 | totalTestEncountersViral | 0 | 330034 | 0 | 0 | e5a147d241db0ad3830218c1038dc29b79d42bcc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
45 | 45 | 20200926 | SC | 145273 | 1097524 | 1242797 | 727 | 9028 | 186 | 99 | 69629 | A+ | 9/25/2020 11:59 | 2020-09-25T11:59:00Z | 09/25 07:59 | 3323 | 9028 | 2020-09-25T11:59:00Z | 1238862 | 181055 | 1057807 | 141338 | 3141 | 182 | 70491 | 6831 | 63660 | 39995 | 9972 | 45 | 1371 | 14959 | 1242797 | posNeg | 16330 | 1242797 | 26 | 34 | f961ffe6bba29cf00c45195b6b3d192e8cd6b734 | 0 | 0 | 0 | 0 | 0 | |||||||||||
47 | 47 | 20200926 | TN | 190891 | 2598988 | 2789879 | 855 | 8528 | 267 | 119 | 174044 | A+ | 9/26/2020 15:00 | 2020-09-26T15:00:00Z | 09/26 11:00 | 2374 | 8528 | 2020-09-26T15:00:00Z | 2782844 | 224629 | 2558215 | 183856 | 2281 | 93 | 47 | 1437 | 25597 | 2789879 | posNeg | 27034 | 2789879 | 22 | 51 | 053b3f4cd24a0ce9d35d93dfa59a783a7b6091cb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
49 | 49 | 20200926 | UT | 69547 | 735532 | 805079 | 191 | 3702 | 77 | 890 | 358 | 53806 | A+ | 9/26/2020 11:02 | 2020-09-26T11:02:00Z | 09/26 07:02 | 448 | 3702 | 2020-09-26T11:02:00Z | 1037414 | 69547 | 805079 | 13698 | 1793 | 23618 | 1900 | 49 | 1017 | 8845 | 805079 | posNeg | 9862 | 805079 | 0 | 34 | 3670fa0d15d16f24a5287b6b4adede4295b71342 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
50 | 50 | 20200926 | VA | 145408 | 1855171 | 310 | 1993344 | 924 | 18179 | 202 | 111 | 17255 | A+ | 9/25/2020 17:00 | 2020-09-25T17:00:00Z | 09/25 13:00 | 3144 | 18179 | 2020-09-25T17:00:00Z | 165048 | 138173 | 2937 | 207 | 1993344 | 51 | 975 | 18955 | 2000889 | posNeg | 19845 | 2000579 | 8 | 29 | 5f2f6648c9200ea7be7a0d221a8b6dffb911ae4c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
54 | 54 | 20200926 | WI | 120231 | 1393412 | 211 | 1513643 | 574 | 7041 | 161 | 1153 | 94094 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1291 | 7041 | 2020-09-26T00:00:00Z | 113645 | 1281 | 10 | 1507057 | 55 | 2902 | 9767 | 1513854 | posNeg | 12669 | 1513643 | 7 | 79 | fb3c2ebb10eddd0158608674af0e708a51da7173 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_current] ( [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 );