states_daily_4pm_et

Table actions

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

63 rows where "dateChecked" is on date 2020-03-27

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, recovered, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-03-27 · 63 ✖
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
10140 10140 20200329 AS       0                 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 0   2020-03-27T00:00:00Z 0     0                             60 0 0 0 posNeg 0 0 0 0 4f077407c270312266c25ae3eb34b51dfe3bfc79 0 0 0 0 0  
10193 10193 20200328 AK 85 2836   2921   5           A 3/27/2020 19:00 2020-03-27T19:00:00Z 03/27 15:00 2 5 2020-03-27T19:00:00Z 2921     85                             2 16 517 2921 posNeg 533 2921 1 2 7a680df11eff663d720067a7685f28cb60ee1e24 0 0 0 0 0  
10196 10196 20200328 AS       0                 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 0   2020-03-27T00:00:00Z 0     0                             60 0 0 0 posNeg 0 0 0 0 1f2264c644cfc97a4110d286bf8fb9c306304cdd 0 0 0 0 0  
10198 10198 20200328 CA 4643 20549 64400 25192 1034   410         B 3/27/2020 17:00 2020-03-27T17:00:00Z 03/27 13:00 101   2020-03-27T17:00:00Z 25192                                   6 764 3169 89592 posNeg 3933 25192 23 0 404fd5bcb686e7e13cdd3dd5fa4d8af97402d176 0 0 0 0 0  
10199 10199 20200328 CO 1734 9942   12504 307 239           A 3/27/2020 18:00 2020-03-27T18:00:00Z 03/27 14:00 31 239 2020-03-27T18:00:00Z             12504 11676                     8 304 1250 11676 totalTestEncountersViral 1593 11676 7 55 8be026251a256f61a3d484b137560e36a8570416 0 0 0 0 0  
10200 10200 20200328 CT 1291 7109   8400 173             A 3/27/2020 13:30 2020-03-27T13:30:00Z 03/27 09:30 27   2020-03-27T13:30:00Z         10                           9 0 0 8400 posNeg 0 8400 0 0 a19d1d96eb0638ebad43d8f9fb68f9f44d758d7f 0 0 0 0 0  
10201 10201 20200328 DC 304 2211 1 2515             51 A 3/27/2020 20:30 2020-03-27T20:30:00Z 03/27 16:30 4   2020-03-27T20:30:00Z             2515                       11 37 314 2516 posNeg 351 2515 1 0 feb029fd0c4bb392eb162e8c13860090d5623723 0 0 0 0 0  
10206 10206 20200328 HI 120 4357   4477   8           A 3/27/2020 18:00 2020-03-27T18:00:00Z 03/27 14:00   8 2020-03-27T18:00:00Z                                     15 14 0 4477 posNeg 14 4477 0 1 c72f3db7f5bc0b9a7643597e079d5e3549a1b7be 0 0 0 0 0  
10208 10208 20200328 ID 230 3342   3572 37 25           A 3/27/2020 19:00 2020-03-27T19:00:00Z 03/27 15:00 4 25 2020-03-27T19:00:00Z 3572                                   16 41 674 3572 posNeg 715 3572 1 25 4e3c13e261282c4191ba3fc4bc58d6a8dc73e910 0 0 0 0 0  
10211 10211 20200328 KS 261 3671   3932   27           B 3/27/2020 09:00 2020-03-27T09:00:00Z 03/27 05:00 5 27 2020-03-27T09:00:00Z                                     20 59 442 3932 posNeg 501 3932 1 0 16e11cb19f70f03160529e1342093ee213124bb2 0 0 0 0 0  
10212 10212 20200328 KY 302 4821   5123               A 3/27/2020 17:00 2020-03-27T17:00:00Z 03/27 13:00 8   2020-03-27T17:00:00Z 5123                                   21 54 1053 5123 posNeg 1107 5123 2 0 c4080056be49170fba1fa593b0a1993c72cc9a0c 0 0 0 0 0  
10214 10214 20200328 MA 4158 30915   50010   350           B 3/27/2020 12:30 2020-03-27T12:30:00Z 03/27 08:30 72 350 2020-03-27T12:30:00Z 50010 7224                                 25 1007 4671 35073 totalTestsViral 3202 35073 15 131 3561a7ff794d5c52ae19e7e3eabb57ccb1e64263 0 0 0 0 0  
10217 10217 20200328 MI 14865 15902   30767               B 3/27/2020 16:00 2020-03-27T16:00:00Z 03/27 12:00 283   2020-03-27T16:00:00Z 21920 6018 15902 14625 326 19                         26 1066 1762 30767 posNeg 2828 30767 71 0 cc04102864497d4c45248eae2eb1f35cac14b981 0 0 0 0 0  
10226 10226 20200328 NH 187 3656 296 5000   30           B 3/27/2020 09:00 2020-03-27T09:00:00Z 03/27 05:00 2 30 2020-03-27T09:00:00Z 5000                                   33 29 261 4139 posNeg 662 3843 1 5 ddece88e6c6be3fdb4d32699e1b9e576bbb69a9a 0 0 0 0 0  
10228 10228 20200328 NM 191 9196   9387 17             A 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 1   2020-03-27T00:00:00Z                                     35 55 819 9387 posNeg 874 9387 0 0 ff0f18617c6f578e7216b0033fe7d7605896c520 0 0 0 0 0  
10229 10229 20200328 NV 621 7901   8522               A 3/27/2020 22:00 2020-03-27T22:00:00Z 03/27 18:00 25   2020-03-27T22:00:00Z 9973     621                             32 86 1740 8522 posNeg 1826 8522 4 0 19a8e4286d5c8f1b2efd780c7fe0b50cacede3b6 0 0 0 0 0  
10232 10232 20200328 OK 377 1180   1557   126           A 3/27/2020 08:00 2020-03-27T08:00:00Z 03/27 04:00 15 126 2020-03-27T08:00:00Z                                     40 55 96 1557 posNeg 151 1557 7 21 ce0abc1655e8272ee7af0c76e821e4a685f9aafb 0 0 0 0 0  
10233 10233 20200328 OR 479 9693   10172 107 117     31     A 3/27/2020 12:30 2020-03-27T12:30:00Z 03/27 08:30 13 117 2020-03-27T12:30:00Z                                     41 65 1183 10172 posNeg 1248 10172 1 15 4dd51c02acd2a53e5a93d3e4363d1a522b1fb5c0 0 0 0 0 0  
10237 10237 20200328 SC 539 2408   2947   102           B 3/27/2020 16:32 2020-03-27T16:32:00Z 03/27 12:32 13 102 2020-03-27T16:32:00Z       539                             45 83 101 2947 posNeg 184 2947 4 0 ac7d2183cdf926048df832724a1442143899b247 0 0 0 0 0  
10239 10239 20200328 TN 1373 16965   18338   118           A 3/27/2020 15:00 2020-03-27T15:00:00Z 03/27 11:00 6 118 2020-03-27T15:00:00Z                                     47 170 2077 18338 posNeg 2247 18338 0 15 d9374654227937be1c51657e8e0f0411a00dc2d5 0 0 0 0 0  
10247 10247 20200328 WV 96 2331 6 2427   1           B 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 0 1 2020-03-27T00:00:00Z       96                             54 20 552 2433 posNeg 572 2427 0 0 a617302a9885e798a7854406654ceeee93fc7ba4 0 0 0 0 0  
10250 10250 20200327 AL 587 4184   4771 112             B 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 3   2020-03-27T00:00:00Z 4771     587                             1 81 591 4771 posNeg 672 4771 2 0 187381ca795e6315a9028448e93e91a0ed13043e 0 0 0 0 0  
10251 10251 20200327 AR 381 1545   1926 48       17   19 A 3/27/2020 14:05 2020-03-27T14:05:00Z 03/27 10:05 3   2020-03-27T14:05:00Z 1926     381                             5 46 41 1926 posNeg 87 1926 0 0 215f748d25652ad59a882ded0b2dc99b4bc05730 0 0 0 0 0  
10252 10252 20200327 AS       0                 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 0   2020-03-27T00:00:00Z 0     0                             60 0 0 0 posNeg 0 0 0 0 99727726922a66fd40f1d0f077032f44ef5ed5ce 0 0 0 0 0  
10253 10253 20200327 AZ 736 7455 30 8191   343           B 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 13 343 2020-03-27T00:00:00Z               8191                     4 159 7108 8221 posNeg 7267 8191 5 40 4a96be8101c7974b7e7aa5f2350d7cab2093b8fd 0 0 0 0 0  
10254 10254 20200327 CA 3879 17380 57400 21259 746   200         B 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 78   2020-03-27T00:00:00Z 21259                                   6 873 0 78659 posNeg 873 21259 13 0 a0d994640236bcdc24a03aa5afd9ec14d5dc4e1c 0 0 0 0 0  
10256 10256 20200327 CT 1291 7109   8400 173             A 3/27/2020 13:30 2020-03-27T13:30:00Z 03/27 09:30 27   2020-03-27T13:30:00Z         5                           9 279 1484 8400 posNeg 1763 8400 6 0 248bc103249e3f8ac885c66f02a8a1b985a8deed 0 0 0 0 0  
10258 10258 20200327 DE 163 36   199 15           9 C 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 5   2020-03-27T00:00:00Z         5 0                         10 33 0 199 posNeg 33 199 2 0 7e11d778739e2f95aa0f8064e6e5993f83a32088 0 0 0 0 0  
10259 10259 20200327 FL 2765 28186 1517 30951   456           A 3/27/2020 12:00 2020-03-27T12:00:00Z 03/27 08:00 34 456 2020-03-27T12:00:00Z                                     12 410 4445 32468 posNeg 4855 30951 6 50 1477ccdc4e8e5339fbc64092dd5a95fd47dbc5b7 0 0 0 0 0  
10260 10260 20200327 GA 2001 7864   9865   566           A 3/27/2020 12:00 2020-03-27T12:00:00Z 03/27 08:00 64 566 2020-03-27T12:00:00Z 9865                                   13 476 463 9865 posNeg 939 9865 16 93 e63d5f52ec800bf5bcd6cc63f2a2ac9aa015c1bc 0 0 0 0 0  
10261 10261 20200327 GU 51 299   350 13               3/27/2020 07:00 2020-03-27T07:00:00Z 03/27 03:00 1   2020-03-27T07:00:00Z                                     66 6 36 350 posNeg 42 350 0 0 65083973224b84d29a32e6d975141ecb4e88f384 0 0 0 0 0  
10263 10263 20200327 IA 235 3740   3975 32 50         18 C 3/27/2020 15:40 2020-03-27T15:40:00Z 03/27 11:40 3 50 2020-03-27T15:40:00Z       235                             19 56 1162 3975 posNeg 1218 3975 2 4 7986084ba7095633a1c6fc5e13d855d1c432dbbd 0 0 0 0 0  
10265 10265 20200327 IL 3026 18516   21542               A 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 34   2020-03-27T00:00:00Z                                     17 488 4423 21542 posNeg 4911 21542 8 0 7cb39d63e709e97adb9ccfd92e460e774e574f12 0 0 0 0 0  
10267 10267 20200327 KS 202 3229   3431   27           B 3/27/2020 09:00 2020-03-27T09:00:00Z 03/27 05:00 4 27 2020-03-27T09:00:00Z                                     20 34 360 3431 posNeg 394 3431 1 27 1272463c6e2372da2eac19e1d0e9a4232fb0b832 0 0 0 0 0  
10269 10269 20200327 LA 2746 18613   21359 773       270     A 3/27/2020 13:00 2020-03-27T13:00:00Z 03/27 09:00 119   2020-03-27T13:00:00Z       2746                             22 441 2889 21359 posNeg 3330 21359 36 0 10e7db86f6fc011ab54f829cf757692c9054ca90 0 0 0 0 0  
10270 10270 20200327 MA 3151 26244   46808   219           B 3/27/2020 12:30 2020-03-27T12:30:00Z 03/27 08:30 57 219 2020-03-27T12:30:00Z 46808 6520                                 25 833 4917 29395 totalTestsViral 4815 29395 15 0 c87f76932ab31484439d767ae13de35e930c482a 0 0 0 0 0  
10271 10271 20200327 MD 774 94   868   173         25 D 3/27/2020 10:00 2020-03-27T10:00:00Z 03/27 06:00 10 173 2020-03-27T10:00:00Z 7236 769   774 10                           24 194 0 868 posNeg 194 868 3 41 3cfce44188f99a501d3789479831e8f90f7cb6b3 0 0 0 0 0  
10272 10272 20200327 ME 168 3394   3562             24 A 3/27/2020 11:30 2020-03-27T11:30:00Z 03/27 07:30 1   2020-03-27T11:30:00Z       168                             23 13 0 3562 posNeg 13 3562 1 0 bf0381c279a9ef2d79797280df8b06bacf631ce7 0 0 0 0 0  
10273 10273 20200327 MI 13799 14140   27939               B 3/27/2020 11:00 2020-03-27T11:00:00Z 03/27 07:00 212   2020-03-27T11:00:00Z 19133 4993 14140 13585 264 15                         26 1324 2410 27939 posNeg 3734 27939 53 0 b53dd4b144d477ccd8626754ff19ace3876c5e14 0 0 0 0 0  
10274 10274 20200327 MN 640 13605   14245 34 51   17     176 A 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 4 51 2020-03-27T00:00:00Z       640     14245                       27 75 1001 14245 posNeg 1076 14245 2 10 31eb4828f0825065bb3126647dfe047302eb9b21 0 0 0 0 0  
10275 10275 20200327 MO 669 369   1038               C 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 8   2020-03-27T00:00:00Z 12479 1144 11324 669                             29 167 0 1038 posNeg 167 1038 0 0 f072a24768cc81069c07959b143df01c9dada0ff 0 0 0 0 0  
10278 10278 20200327 MT 108 2590   2698   7           A 3/27/2020 10:00 2020-03-27T10:00:00Z 03/27 06:00   7 2020-03-27T10:00:00Z                                     30 37 462 2698 posNeg 499 2698 0 6 cf4356a522dddd4f8b55eda224e9779eea4fb5c0 0 0 0 0 0  
10279 10279 20200327 NC 763 14373   15136 77             A 3/27/2020 11:40 2020-03-27T11:40:00Z 03/27 07:40 3   2020-03-27T11:40:00Z                                     37 127 2099 15136 posNeg 2226 15136 1 0 45b1300e58b125895ea014ffe1b93218ca0b8abf 0 0 0 0 0  
10280 10280 20200327 ND 61 2427   2549   13         15 B 3/27/2020 11:31 2020-03-27T11:31:00Z 03/27 07:31 0 13 2020-03-27T11:31:00Z 2568     61     2549 2482                     38 9 388 2488 totalTestEncountersViral 462 2488 0 3 509dc3cee49868c80578332f612f1fd54c7b03ef 0 0 0 0 0  
10281 10281 20200327 NE 85 1761   1846               A 3/27/2020 14:30 2020-03-27T14:30:00Z 03/27 10:30 0   2020-03-27T14:30:00Z               1903                     31 12 177 1846 posNeg 189 1846 0 0 2e077e992c7ddbedc172ff9a9b775d61b675a7e9 0 0 0 0 0  
10283 10283 20200327 NJ 8825 16547   25372 2000             A 3/27/2020 13:30 2020-03-27T13:30:00Z 03/27 09:30 141   2020-03-27T13:30:00Z       8825 108 33   25372                     34 1949 2886 25372 posNeg 4835 25372 32 0 6730858a26598f80f57b223c5c4bcb40253d14b2 0 0 0 0 0  
10286 10286 20200327 NY 44635 101118   145753 6481 8732 1583       2045 A 3/27/2020 11:15 2020-03-27T11:15:00Z 03/27 07:15 519 8732 2020-03-27T11:15:00Z                                     36 7377 16272 145753 posNeg 23649 145753 134 1811 43456c4f1d95bbed1adb7498de53b3a7258391bc 0 0 0 0 0  
10287 10287 20200327 OH 1137 19012   20149   276   107       B 3/27/2020 14:00 2020-03-27T14:00:00Z 03/27 10:00 19 276 2020-03-27T14:00:00Z       1137                             39 270 2563 20149 posNeg 2833 20149 4 53 6cef88b022bf6d9f80bb2d07f56022d841904aad 0 0 0 0 0  
10288 10288 20200327 OK 322 1084   1406   105           A 3/27/2020 08:00 2020-03-27T08:00:00Z 03/27 04:00 8 105 2020-03-27T08:00:00Z                                     40 74 126 1406 posNeg 200 1406 1 19 e9c0e48aecff83e2a47bc38b84b2fd6b08623b32 0 0 0 0 0  
10289 10289 20200327 OR 414 8510   8924 91 102     31     A 3/27/2020 12:30 2020-03-27T12:30:00Z 03/27 08:30 12 102 2020-03-27T12:30:00Z                                     41 87 1557 8924 posNeg 1644 8924 1 12 1e7a2137554c1a4020d71c0d30ba49ed44ea2ab5 0 0 0 0 0  
10290 10290 20200327 PA 2218 21016   23234   241           A 3/27/2020 12:00 2020-03-27T12:00:00Z 03/27 08:00 22 241 2020-03-27T12:00:00Z               23234                     42 531 4575 23234 posNeg 5106 23234 6 241 4a86d666629719e0b3b54d15dee5ff3582a966c2 0 0 0 0 0  
10291 10291 20200327 PR 79 519 334 598               A 3/27/2020 07:00 2020-03-27T07:00:00Z 03/27 03:00 3   2020-03-27T07:00:00Z                                     72 15 142 932 posNeg 157 598 1 0 8ca8399afd8cc4affd2db86a87223c37547094fd 0 0 0 0 0  
10292 10292 20200327 RI 248 2502 138 2603 28   9   6     B 3/27/2020 03:00 2020-03-27T03:00:00Z 03/26 23:00     2020-03-27T03:00:00Z 2868 257 2611 248     2603 2750                     44 31 202 2888 totalTestEncountersViral 216 2750 0 0 4c4cf933977833ac0d36b746ebb54158291d0d96 0 0 0 0 0  
10294 10294 20200327 SD 58 2387 20 2445             21 A 3/27/2020 12:30 2020-03-27T12:30:00Z 03/27 08:30 1   2020-03-27T12:30:00Z               2445                     46 12 414 2465 posNeg 426 2445 0 0 1d010aa8e358d516f11dbdff2a2bb4840542c3e3 0 0 0 0 0  
10295 10295 20200327 TN 1203 14888   16091   103           A 3/27/2020 15:00 2020-03-27T15:00:00Z 03/27 11:00 6 103 2020-03-27T15:00:00Z                                     47 246 936 16091 posNeg 1182 16091 3 27 7c0e59ea7c26db3dbddef0d5e3685499475daa00 0 0 0 0 0  
10296 10296 20200327 TX 1731 21935   23666               A 3/27/2020 13:00 2020-03-27T13:00:00Z 03/27 09:00 23   2020-03-27T13:00:00Z       1731                             48 335 1907 23666 posNeg 2242 23666 5 0 c51c9445f48d4156202650a226bb3d64b422caf6 0 0 0 0 0  
10297 10297 20200327 UT 480 8764   9244               A 3/27/2020 15:00 2020-03-27T15:00:00Z 03/27 11:00 2   2020-03-27T15:00:00Z       480                             49 78 1456 9244 posNeg 1534 9244 1 0 164888c409a6320602c8e2c8d79fed7b2fa114a5 0 0 0 0 0  
10298 10298 20200327 VA 604 6733   14778   83           A 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 14 83 2020-03-27T00:00:00Z   2967         14778                       51 144 1004 7337 posNeg 1404 7337 1 18 0da8de012a1c8cba12f35abdc4bbb3a349698f4a 0 0 0 0 0  
10299 10299 20200327 VI 19 55 2 74                 3/27/2020 14:00 2020-03-27T14:00:00Z 03/27 10:00     2020-03-27T14:00:00Z                                     78 2 0 76 posNeg 2 74 0 0 5d3b7549782c33f3578c42757d975b3ac870dfd8 0 0 0 0 0  
10300 10300 20200327 VT 213 2868   3081   18           A 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 10 18 2020-03-27T00:00:00Z       213                             50 28 124 3081 posNeg 152 3081 1 18 f9ca09025f2adcbc07541c417496923962b3c495 0 0 0 0 0  
10301 10301 20200327 WA 5391 67906   73297               A 3/27/2020 00:00 2020-03-27T00:00:00Z 03/26 20:00 199   2020-03-27T00:00:00Z       5391     73297 71103                     53 464 4153 73297 posNeg 4617 73297 16 0 707d1eb5ebc7f471b5094ea90575d98bfdf79137 0 0 0 0 0  
10302 10302 20200327 WI 969 13140   14109               A 3/27/2020 16:00 2020-03-27T16:00:00Z 03/27 12:00 13   2020-03-27T16:00:00Z       842                             55 163 1557 14109 posNeg 1720 14109 5 0 72fda9555bad8c93a1447e3727c6e517f3ffaa72 0 0 0 0 0  
10304 10304 20200327 WY 70 1211   1281   11         17 A 3/27/2020 12:50 2020-03-27T12:50:00Z 03/27 08:50 0 11 2020-03-27T12:50:00Z       54                             56 17 159 1281 posNeg 176 1281 0 11 1555b71409f85f074b2fb9d872444cf07161f3b9 0 0 0 0 0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [states_daily_4pm_et] (
   [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
);