states_current
Data source: Big Local News · About: big-local-datasette
24 rows where "dateChecked" is on date 2020-09-25 sorted by positiveTestsViral
This data as json, copyable, CSV (advanced)
Suggested facets: pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, recovered, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, positiveIncrease, negativeIncrease, totalTestResultsSource, totalTestResultsIncrease, deathIncrease, hospitalizedIncrease, dateModified (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7 | 7 | 20200926 | CO | 67926 | 804806 | 1277613 | 248 | 7479 | 6404 | A | 9/25/2020 01:59 | 2020-09-25T01:59:00Z | 09/24 21:59 | 1940 | 7479 | 2020-09-25T01:59:00Z | 63137 | 1277613 | 867943 | 166415 | 11592 | 154823 | 8 | 709 | 9218 | 872732 | totalTestEncountersViral | 16752 | 872732 | 5 | 25 | e66aa724278acdbfea40842a634bf1ac4a32fa77 | 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 | |||||||||||||||||||||
14 | 14 | 20200926 | HI | 11891 | 278076 | 289967 | 150 | 787 | 55 | 30 | 5397 | B | 9/25/2020 18:00 | 2020-09-25T18:00:00Z | 09/25 14:00 | 127 | 787 | 2020-09-25T18:00:00Z | 402010 | 289967 | 15 | 112 | 2980 | 289967 | posNeg | 3092 | 289967 | 3 | 8 | 6244d9b33b4882c0c4fd80e6a666219eab29ae6e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
16 | 16 | 20200926 | ID | 39757 | 262420 | 298652 | 135 | 1795 | 44 | 451 | 21291 | A | 9/25/2020 18:55 | 2020-09-25T18:55:00Z | 09/25 14:55 | 458 | 1795 | 2020-09-25T18:55:00Z | 298652 | 36232 | 421 | 37 | 16 | 523 | 1772 | 302177 | posNeg | 2240 | 302177 | 1 | 29 | 71c4c31498029adf59faba29c2c940f819b1402a | 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 | |||||||||||||||||||
21 | 21 | 20200926 | LA | 165152 | 2090913 | 2256065 | 570 | 86 | 149640 | A | 9/25/2020 13:00 | 2020-09-25T13:00:00Z | 09/25 09:00 | 5444 | 2020-09-25T13:00:00Z | 163928 | 5262 | 182 | 2254841 | 22 | 0 | 0 | 2256065 | posNeg | 0 | 2256065 | 0 | 0 | bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
26 | 26 | 20200926 | MN | 95659 | 1273023 | 1954715 | 340 | 7443 | 120 | 2085 | 85259 | A | 9/25/2020 17:00 | 2020-09-25T17:00:00Z | 09/25 13:00 | 2056 | 7443 | 2020-09-25T17:00:00Z | 95659 | 2004 | 52 | 1954715 | 1368682 | 27 | 1470 | 16056 | 1368682 | posNeg | 30695 | 1368682 | 10 | 52 | 9be7f926e01b9ff59c4df68144853a139533f186 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
28 | 28 | 20200926 | MP | 69 | 14776 | 14845 | 4 | 29 | D | 9/25/2020 00:00 | 2020-09-25T00:00:00Z | 09/24 20:00 | 2 | 4 | 2020-09-25T00:00:00Z | 19835 | 69 | 2 | 14845 | 69 | 0 | 0 | 14845 | posNeg | 0 | 14845 | 0 | 0 | 6fdb4898ec2dbbb6eafe41b19ae56eff50411718 | 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 | |||||||||||||||
33 | 33 | 20200926 | NE | 43162 | 397483 | 440645 | 225 | 2276 | 32238 | A | 9/25/2020 20:30 | 2020-09-25T20:30:00Z | 09/25 16:30 | 468 | 2276 | 2020-09-25T20:30:00Z | 595287 | 43162 | 440947 | 31 | 431 | 2910 | 440645 | posNeg | 3341 | 440645 | 6 | 17 | dff40db61c6d6203f6a42331a30731482bfd47e3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
36 | 36 | 20200926 | NM | 28487 | 865002 | 893489 | 75 | 3420 | 16020 | C | 9/25/2020 17:50 | 2020-09-25T17:50:00Z | 09/25 13:50 | 865 | 3420 | 2020-09-25T17:50:00Z | 893489 | 28487 | 35 | 263 | 7853 | 893489 | posNeg | 8116 | 893489 | 6 | 18 | ca61662b5c3adb6ac3a1bd588dfa0ca45978ca5b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
38 | 38 | 20200926 | NY | 454760 | 9968656 | 10423416 | 527 | 89995 | 164 | 75 | 76528 | A | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 25450 | 89995 | 2020-09-25T23:59:00Z | 454760 | 10423416 | 36 | 1005 | 98948 | 10423416 | posNeg | 99953 | 10423416 | 4 | 0 | bb7957fb78d761d4366fb1503123856475c70689 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
46 | 46 | 20200926 | SD | 21133 | 165001 | 186134 | 213 | 1434 | 17173 | A | 9/25/2020 14:00 | 2020-09-25T14:00:00Z | 09/25 10:00 | 218 | 1434 | 2020-09-25T14:00:00Z | 260219 | 186134 | 46 | 579 | 1608 | 186134 | posNeg | 2187 | 186134 | 2 | 34 | ca6a7392a4ed3947a93b80040d2c4fffc4abcbe2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
51 | 51 | 20200926 | VI | 1296 | 18676 | 8 | 19972 | 1209 | D | 9/25/2020 09:30 | 2020-09-25T09:30:00Z | 09/25 05:30 | 19 | 2020-09-25T09:30:00Z | 19980 | 19 | 78 | 0 | 0 | 19980 | posNeg | 0 | 19972 | 0 | 0 | 61739fb2efab7827062ca9cc633984208f34bc24 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
52 | 52 | 20200926 | VT | 1739 | 158537 | 160276 | 1 | 1580 | B | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 58 | 2020-09-25T23:59:00Z | 1739 | 58 | 160276 | 50 | 8 | 989 | 160276 | posNeg | 997 | 160276 | 0 | 0 | 21dc4138bae65a1c22e9f7756f9fd545cb820bea | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
53 | 53 | 20200926 | WA | 85226 | 1715795 | 1801021 | 264 | 7412 | 28 | B | 9/25/2020 02:59 | 2020-09-25T02:59:00Z | 09/24 22:59 | 2100 | 7412 | 2020-09-25T02:59:00Z | 85226 | 2100 | 1801021 | 53 | 988 | 16754 | 1801021 | posNeg | 17742 | 1801021 | 20 | 55 | fd6ce507d03586f2b0ac32e299f88b85d7393013 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
55 | 55 | 20200926 | WV | 15158 | 527133 | 542291 | 174 | 56 | 31 | 11121 | C | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 332 | 2020-09-25T23:59:00Z | 541883 | 14750 | 329 | 3 | 17205 | 54 | 205 | 6692 | 542291 | posNeg | 6897 | 542291 | 2 | 0 | a4823873f7e477ab8b531c7edd4b61423f7dbfdb | 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 | ||||||||||||||||
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 | |||||||||||
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 | |||||||||||||||||
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 | |||||||||||||
11 | 11 | 20200926 | FL | 698682 | 4536325 | 4001 | 5235007 | 2099 | 43964 | A | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 14190 | 43964 | 2020-09-25T23:59:00Z | 7383930 | 899158 | 6443064 | 698682 | 14190 | 5242163 | 505164 | 45080 | 460024 | 493810 | 44075 | 449702 | 16485 | 12 | 2795 | 26218 | 5239008 | posNeg | 29013 | 5235007 | 107 | 171 | dc9d1e1af52716f018602f6f32d66d5e9c263c88 | 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 );