COVID_COVID19Tracker

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

Custom SQL query returning 41 rows (hide)

Query parameters

This data as json, copyable, CSV

rowiddatestatepositivenegativependingtotalTestResultshospitalizedCurrentlyhospitalizedCumulativeinIcuCurrentlyinIcuCumulativeonVentilatorCurrentlyonVentilatorCumulativerecovereddataQualityGradelastUpdateEtdateModifiedcheckTimeEtdeathhospitalizeddateCheckedtotalTestsViralpositiveTestsViralnegativeTestsViralpositiveCasesViraldeathConfirmeddeathProbabletotalTestEncountersViraltotalTestsPeopleViraltotalTestsAntibodypositiveTestsAntibodynegativeTestsAntibodytotalTestsPeopleAntibodypositiveTestsPeopleAntibodynegativeTestsPeopleAntibodytotalTestsPeopleAntigenpositiveTestsPeopleAntigentotalTestsAntigenpositiveTestsAntigenfipspositiveIncreasenegativeIncreasetotaltotalTestResultsSourcetotalTestResultsIncreaseposNegdeathIncreasehospitalizedIncreasehashcommercialScorenegativeRegularScorenegativeScorepositiveScorescoregrade
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 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  
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  
4 20200926 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 b9eccb7369bdc4ee75708c7a892c5437ab915d83 0 0 0 0 0  
6 20200926 CA 798237 13384493   14182730 3203   862         B 9/26/2020 02:59 2020-09-26T02:59:00Z 09/25 22:59 15532   2020-09-26T02:59:00Z 14182730     798237                             6 4197 126286 14182730 posNeg 130483 14182730 134 0 bc22d39302ce5646a61aef19adbfa503f5de5e76 0 0 0 0 0  
8 20200926 CT 56587 1462564   1519151 76 11560         9310 B 9/24/2020 20:30 2020-09-24T20:30:00Z 09/24 16:30 4501 11560 2020-09-24T20:30:00Z 1516780     54216 3604 897                         9 0 0 1519151 posNeg 0 1519151 0 0 597a6f3bd03d5e8297830e769c3da2cb90e767e7 0 0 0 0 0  
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 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 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  
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  
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 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  
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 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 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  
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  
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 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  
27 20200926 MO 122014 1167155   1289169 1101             B 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 2063   2020-09-26T00:00:00Z 1687509 128009 1556710 122014       1289169       74093 3508 70585         29 1716 14288 1289169 posNeg 16004 1289169 69 0 de543358a328e51d3abdbaecc32041460021841e 0 0 0 0 0  
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  
30 20200926 MT 11907 317378   329285 147 684         8749 C 9/26/2020 01:59 2020-09-26T01:59:00Z 09/25 21:59 171 684 2020-09-26T01:59:00Z 329285     11907                             30 343 2826 329285 posNeg 3169 329285 1 9 2b25a5d9191b4d38560392a23353c41e646042be 0 0 0 0 0  
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  
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  
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  
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  
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  
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  
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  
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 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  
43 20200926 PR 45413 305972   351385 342   59   33     C 9/26/2020 00:00 2020-09-26T00:00:00Z 09/25 20:00 642   2020-09-26T00:00:00Z 310546 7002 303412 22164 471 171       23249                 72 508 0 351385 posNeg 508 351385 7 0 347836cd67621b97708a39d1a47689f42650b1b1 0 0 0 0 0  
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  
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  
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 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  
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 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  
56 20200926 WY 5465 92406   97871 22 258         4479 B 9/26/2020 11:55 2020-09-26T11:55:00Z 09/26 07:55 50 258 2020-09-26T11:55:00Z 155082 4497 150584 4618       96991                     56 45 0 97871 posNeg 45 97871 0 2 9c1be43cf5db286c8a903c0b3ed654e3d5b588c2 0 0 0 0 0  
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  
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  
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