states_current
Data source: Big Local News · About: big-local-datasette
15 rows where dataQualityGrade = "A"
This data as json, copyable, CSV (advanced)
Suggested facets: pending, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, recovered, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 20200926 | AK | 8315 | 434554 | 442869 | 43 | 14 | 3267 | A | 9/26/2020 03:59 | 2020-09-26T03:59:00Z | 09/25 23:59 | 52 | 2020-09-26T03:59:00Z | 442869 | 7411 | 435171 | 8315 | 52 | 2 | 113 | 1424 | 442869 | posNeg | 1537 | 442869 | 1 | 0 | bf7518dcc571d23d1d8206a95e1a1c12173bcb0a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2 | 2 | 20200926 | AL | 151591 | 970048 | 1104932 | 709 | 16852 | 1791 | 1007 | 64583 | A | 9/26/2020 11:00 | 2020-09-26T11:00:00Z | 09/26 07:00 | 2501 | 16852 | 2020-09-26T11:00:00Z | 1104932 | 134884 | 2364 | 137 | 57800 | 1 | 933 | 6684 | 1121639 | posNeg | 7337 | 1121639 | 10 | 0 | 88370a431af70a13b1499a5cd6afe94a14fc9fb3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
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 | ||||||||||||||||||
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 | |||||||||||
12 | 12 | 20200926 | GA | 313873 | 2558482 | 2872355 | 1831 | 28153 | 5176 | A | 9/26/2020 14:50 | 2020-09-26T14:50:00Z | 09/26 10:50 | 6914 | 28153 | 2020-09-26T14:50:00Z | 2872355 | 292318 | 2580037 | 313873 | 299555 | 24723 | 13 | 1359 | 23502 | 2872355 | posNeg | 24861 | 2872355 | 40 | 118 | 9ab79841fa3a6c3d058ce3f94b9671540d5a8880 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
13 | 13 | 20200926 | GU | 2354 | 46365 | 48719 | 30 | 9 | 1668 | A | 9/26/2020 09:45 | 2020-09-26T09:45:00Z | 09/26 05:45 | 43 | 2020-09-26T09:45:00Z | 48254 | 2354 | 48719 | 179 | 3 | 66 | 68 | 395 | 48719 | posNeg | 463 | 48719 | 2 | 0 | 7185eba890dd8a1d9ad81f1a7efd70101c32b967 | 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 | ||||||||||||||||||
17 | 17 | 20200926 | IL | 288815 | 5142362 | 5431177 | 1597 | 355 | 141 | A | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 8832 | 2020-09-26T00:00:00Z | 5428688 | 286326 | 8588 | 244 | 17 | 2441 | 62776 | 5431177 | posNeg | 65217 | 5431177 | 25 | 0 | 2620e4472a6793bd94436e1e6a2f1efbe8f39315 | 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 | |||||||||||||||||||||
23 | 23 | 20200926 | MD | 122972 | 1461328 | 1584300 | 347 | 15382 | 81 | 7458 | A | 9/26/2020 10:00 | 2020-09-26T10:00:00Z | 09/26 06:00 | 3925 | 15382 | 2020-09-26T10:00:00Z | 2525658 | 147256 | 122972 | 3780 | 145 | 1584300 | 24 | 613 | 11203 | 1584300 | posNeg | 11816 | 1584300 | 8 | 54 | cf952879908e5d11013c8da79ad58cd91ef3a04b | 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 | |||||||||||||||||
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 | |||||||||||||||||||||
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 | ||||||||||||||||||||||
48 | 48 | 20200926 | TX | 733438 | 5261375 | 5994813 | 3209 | 1056 | 649580 | A | 9/26/2020 16:20 | 2020-09-26T16:20:00Z | 09/26 12:20 | 15485 | 2020-09-26T16:20:00Z | 5994813 | 733438 | 399337 | 35847 | 80294 | 9297 | 48 | 4886 | 76478 | 5994813 | posNeg | 81364 | 5994813 | 121 | 0 | 118422653c167fc9d3ed0bd4ad4d2a32d4f6a49a | 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 );