states_current

Table actions

Data source: Big Local News · About: big-local-datasette

24 rows where "dateChecked" is on date 2020-09-25 sorted by positiveCasesViral

✎ View and edit SQL

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)

dateChecked (date) ✖

  • 2020-09-25 · 24 ✖
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
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);