states_daily_4pm_et

Table actions

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

61 rows where "dateChecked" is on date 2020-04-14

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-04-14 · 61 ✖
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
9135 9135 20200416 CO 8280 32253   44683 859 1636           A 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 357 1636 2020-04-14T00:00:00Z             44683 40533                     8 339 614 40533 totalTestEncountersViral 1182 40533 28 80 a5893e31358c3c611eb48e275d2d99bb66f0fde6 0 0 0 0 0  
9190 9190 20200415 CA 24424 192062 13200 216486 5163   1175         B 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 821   2020-04-14T00:00:00Z 216486                                   6 1086 13192 229686 posNeg 14278 216486 63 0 93c6a689f4f71bb04890af537c9424cb7adc6cfe 0 0 0 0 0  
9198 9198 20200415 HI 517 19286   19803   45         333 A 4/14/2020 18:00 2020-04-14T18:00:00Z 04/14 14:00 9 45 2020-04-14T18:00:00Z                                     15 13 370 19803 posNeg 383 19803 0 1 8e5c5398cffe252e87af929aa827bbea8434becd 0 0 0 0 0  
9199 9199 20200415 IA 1995 17874   19869 171   78   43   908 A 4/14/2020 12:00 2020-04-14T12:00:00Z 04/14 08:00 53   2020-04-14T12:00:00Z       1995                             19 96 888 19869 posNeg 984 19869 4 0 900a730d3f8c6d8bf0aaef8daee2311ad5a197ef 0 0 0 0 0  
9200 9200 20200415 ID 1464 13934   15398 66 141   43       A 4/14/2020 19:00 2020-04-14T19:00:00Z 04/14 15:00 39 141 2020-04-14T19:00:00Z 15398                                   16 11 273 15398 posNeg 284 15398 6 6 020b1ec06c0be3ecb021e609e1ca56d624b159bb 0 0 0 0 0  
9202 9202 20200415 IN 8955 39441   48396     737   422     B 4/14/2020 11:59 2020-04-14T11:59:00Z 04/14 07:59 436   2020-04-14T11:59:00Z                                     18 428 1951 48396 posNeg 2379 48396 48 0 82af495510bd94d626504607add3512f6340a73e 0 0 0 0 0  
9204 9204 20200415 KY 2210 25487   27697 305 687 137 263     653 A 4/14/2020 17:00 2020-04-14T17:00:00Z 04/14 13:00 115 687 2020-04-14T17:00:00Z 27697                                   21 162 852 27697 posNeg 1014 27697 11 14 0e408c9761e8c1f4114a35b67464080de0066637 0 0 0 0 0  
9210 9210 20200415 MN 2321 41245   43566 197 445 93 175     853 A 4/14/2020 17:00 2020-04-14T17:00:00Z 04/14 13:00 87 445 2020-04-14T17:00:00Z       2321     43566                       27 156 1540 43566 posNeg 1696 43566 8 40 44ac6ccb814c4c412763b21cc1acf603d9072e92 0 0 0 0 0  
9212 9212 20200415 MP 13 27 7 40                 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 2   2020-04-14T00:00:00Z                                     69 0 0 47 posNeg 0 40 0 0 02da72379bc061da243ff20bb1f7c8d0459c755f 0 0 0 0 0  
9213 9213 20200415 MS 3360 34791   38151   645 154   99     A 4/14/2020 19:00 2020-04-14T19:00:00Z 04/14 15:00 122 645 2020-04-14T19:00:00Z                                     28 273 0 38151 posNeg 273 38151 11 49 1af57693f26ce9d8d4789c0b4cfd22d3eed76f2f 0 0 0 0 0  
9217 9217 20200415 NE 901 10828   11729               A 4/14/2020 19:45 2020-04-14T19:45:00Z 04/14 15:45 20   2020-04-14T19:45:00Z               11757                     31 30 342 11729 posNeg 372 11729 2 0 68e3a18d75086d86d2a707f895a9c608f819ab8a 0 0 0 0 0  
9220 9220 20200415 NM 1407 31443   32850 87 181         340 A 4/14/2020 18:56 2020-04-14T18:56:00Z 04/14 14:56 36 181 2020-04-14T18:56:00Z                                     35 62 818 32850 posNeg 880 32850 5 0 f1ffc76d0417ecd4471d2146d05fb7135fca5b05 0 0 0 0 0  
9235 9235 20200415 VI 51 331 35 382             44   4/14/2020 17:30 2020-04-14T17:30:00Z 04/14 13:30 1   2020-04-14T17:30:00Z                                     78 0 5 417 posNeg 5 382 0 0 963cda497d4a427f758c411995f054411ab8c95d 0 0 0 0 0  
9241 9241 20200414 AK 285 8063   8348   32         98 A 4/14/2020 14:15 2020-04-14T14:15:00Z 04/14 10:15 9 32 2020-04-14T14:15:00Z 8348     285                             2 8 510 8348 posNeg 518 8348 1 0 c40f6cdede1ff652304218f53d925bc593dc58a8 0 0 0 0 0  
9242 9242 20200414 AL 3876 29241   33117 380 493   210   132   B 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 110 493 2020-04-14T00:00:00Z 33117     3876                             1 142 3793 33117 posNeg 3935 33117 11 36 80eef6ad7858861185e409fb6810a3d32069c700 0 0 0 0 0  
9243 9243 20200414 AR 1480 19651   21131 81 130   43 29 39 427 A 4/14/2020 14:46 2020-04-14T14:46:00Z 04/14 10:46 30 130 2020-04-14T14:46:00Z 21131     1480                             5 70 257 21131 posNeg 327 21131 0 0 7e6cf5c757d33b7a300b560d4aee3f2da2d999d1 0 0 0 0 0  
9245 9245 20200414 AZ 3806 40290   44096 580 1171 286   216   249 B 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 131 1171 2020-04-14T00:00:00Z               44096                     4 104 645 44096 posNeg 749 44096 9 49 846b72e24052baecc7c9b7e6d6bdf9c65e6ec704 0 0 0 0 0  
9248 9248 20200414 CT 13989 31852   45841 1779             A 4/14/2020 16:00 2020-04-14T16:00:00Z 04/14 12:00 671   2020-04-14T16:00:00Z 45841       380                           9 608 924 45841 posNeg 1532 45841 69 0 0b26f5bd4ec316e6141d261b5790699bc8edd788 0 0 0 0 0  
9249 9249 20200414 DC 2058 9226   11284 295   95   31   518 A 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 67   2020-04-14T00:00:00Z             11284                       11 103 247 11284 posNeg 350 11284 14 0 7c24c4a33c51acc7ac53d5f8930ffed6f291e304 0 0 0 0 0  
9250 9250 20200414 DE 1761 10543   12304 204           277 A 4/14/2020 17:45 2020-04-14T17:45:00Z 04/14 13:45 60   2020-04-14T17:45:00Z         53 7                         10 136 348 12304 posNeg 484 12304 7 0 95c258db81925557697e655c1d703ec3e3cfd291 0 0 0 0 0  
9251 9251 20200414 FL 21367 181813 1275 203180   3060           A 4/14/2020 16:59 2020-04-14T16:59:00Z 04/14 12:59 537 3060 2020-04-14T16:59:00Z                                     12 766 6207 204455 posNeg 6973 203180 54 227 928e9d166566c0a74cf2f0c6fadfbf165e718406 0 0 0 0 0  
9252 9252 20200414 GA 14223 47572   61795   2769           A 4/14/2020 18:28 2020-04-14T18:28:00Z 04/14 14:28 501 2769 2020-04-14T18:28:00Z 61795                                   13 908 3866 61795 posNeg 4774 61795 37 180 3fa7b68221a56d10b9747a0f205a344bf301e71f 0 0 0 0 0  
9253 9253 20200414 GU 133 811   944 13   2   2   66   4/14/2020 08:15 2020-04-14T08:15:00Z 04/14 04:15 5   2020-04-14T08:15:00Z                                     66 0 41 944 posNeg 41 944 0 0 39779129f7f3b9c365983aeec2d8ee9114fdba7c 0 0 0 0 0  
9254 9254 20200414 HI 504 18916   19420   44         315 A 4/14/2020 18:00 2020-04-14T18:00:00Z 04/14 14:00 9 44 2020-04-14T18:00:00Z                                     15 5 571 19420 posNeg 576 19420 0 0 5fd85edc399e9cf93b0898569e2fd4701bcddc9b 0 0 0 0 0  
9255 9255 20200414 IA 1899 16986   18885 163   73   41   741 A 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 49   2020-04-14T00:00:00Z       1899                             19 189 0 18885 posNeg 189 18885 6 0 1e7c9d0b6331ff41480c5e775161c5c8b03097ce 0 0 0 0 0  
9256 9256 20200414 ID 1453 13661   15114 59 135   38       A 4/14/2020 19:00 2020-04-14T19:00:00Z 04/14 15:00 33 135 2020-04-14T19:00:00Z 15114                                   16 27 206 15114 posNeg 233 15114 6 3 553a104a037f3012faa9e8d6d586384206fd136c 0 0 0 0 0  
9257 9257 20200414 IL 23247 87369   110616 4283   1189   796     A 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 868   2020-04-14T00:00:00Z                                     17 1222 3626 110616 posNeg 4848 110616 74 0 885ce89f0ab079ac01cd38ab9870d532968cdab0 0 0 0 0 0  
9258 9258 20200414 IN 8527 37490   46017     721   435     B 4/14/2020 13:00 2020-04-14T13:00:00Z 04/14 09:00 388   2020-04-14T13:00:00Z                                     18 291 1187 46017 posNeg 1478 46017 38 0 119e7fe282ddbda1ee1608186af98a2310a84673 0 0 0 0 0  
9259 9259 20200414 KS 1426 12721   14147   327           B 4/14/2020 12:00 2020-04-14T12:00:00Z 04/14 08:00 69 327 2020-04-14T12:00:00Z                                     20 50 233 14147 posNeg 283 14147 7 18 db260dd383ccb665681dfda3b1f1050db0be72c2 0 0 0 0 0  
9260 9260 20200414 KY 2048 24635   26683 299 673 136 259     629 A 4/14/2020 17:00 2020-04-14T17:00:00Z 04/14 13:00 104 673 2020-04-14T17:00:00Z 26683                                   21 85 732 26683 posNeg 817 26683 7 6 9203e8ff46dbb84a8eefc91ee3fd3f804c927da4 0 0 0 0 0  
9262 9262 20200414 MA 28109 98820   158730 3616 3616           B 4/14/2020 10:00 2020-04-14T10:00:00Z 04/14 06:00 1329 3616 2020-04-14T10:00:00Z 158730 36432                                 25 1315 3320 126929 totalTestsViral 11345 126929 118 131 42f12b21af81e57e7c7c7953a78df8adee21290b 0 0 0 0 0  
9263 9263 20200414 MD 9472 44261   53733   2122         607 A 4/14/2020 10:00 2020-04-14T10:00:00Z 04/14 06:00 421 2122 2020-04-14T10:00:00Z 60051 11399   9472 396 25                         24 536 1446 53733 posNeg 1982 53733 37 147 18839db4aeb03a00befb0b91efab59fb8faa186b 0 0 0 0 0  
9264 9264 20200414 ME 734 11608   12342 58 124 21   9   292 A 4/14/2020 11:45 2020-04-14T11:45:00Z 04/14 07:45 20 124 2020-04-14T11:45:00Z       734                             23 36 0 12342 posNeg 36 12342 1 0 f808a36f3c27d2d096b3bd51aab1e99afc8dbc5b 0 0 0 0 0  
9265 9265 20200414 MI 33613 70675   104288 3910   1497   1235   452 B 4/14/2020 11:00 2020-04-14T11:00:00Z 04/14 07:00 2532   2020-04-14T11:00:00Z 106183 35508 70675 32572 2537 131                         26 911 3612 104288 posNeg 4523 104288 141 0 608d5aab174ea368fa6f368e3814ec3c48561395 0 0 0 0 0  
9267 9267 20200414 MO 4686 43292   47978 1041             A 4/14/2020 15:00 2020-04-14T15:00:00Z 04/14 11:00 133   2020-04-14T15:00:00Z 45977 5262 40667 4686               3 0 3         29 298 2252 47978 posNeg 2550 47978 19 0 44e6226f4963179ff022cb504a219ddab2429130 0 0 0 0 0  
9268 9268 20200414 MP 13 27 7 40                 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 2   2020-04-14T00:00:00Z                                     69 2 0 47 posNeg 2 40 0 0 02127f2bddebefd1e36afee53e28e6dc4e8d5101 0 0 0 0 0  
9270 9270 20200414 MT 399 8835   9234 24 50         197 A 4/14/2020 11:56 2020-04-14T11:56:00Z 04/14 07:56 7 50 2020-04-14T11:56:00Z 9234                                   30 5 131 9234 posNeg 136 9234 0 3 e9e81358ec72a9d570fa8a529e9c2080a308cc39 0 0 0 0 0  
9271 9271 20200414 NC 5024 60015   65039 418             A 4/14/2020 11:00 2020-04-14T11:00:00Z 04/14 07:00 108   2020-04-14T11:00:00Z                                     37 208 1443 65039 posNeg 1651 65039 22 0 96ca5108bf19400df2cb2b3da81bf5af3de657ec 0 0 0 0 0  
9272 9272 20200414 ND 341 10575   11070 13 42         138 B 4/14/2020 13:00 2020-04-14T13:00:00Z 04/14 09:00 9 42 2020-04-14T13:00:00Z 11169     341     11070 10492                     38 10 125 10916 totalTestEncountersViral 206 10916 1 2 31470c23a4093bbbeef9f99ea453c0d396f5e9a1 0 0 0 0 0  
9273 9273 20200414 NE 871 10486   11357               A 4/14/2020 19:45 2020-04-14T19:45:00Z 04/14 15:45 18   2020-04-14T19:45:00Z               11384                     31 57 328 11357 posNeg 385 11357 1 0 3e5a1a7542f5f315838b6a3de43f1e7567be9f1f 0 0 0 0 0  
9274 9274 20200414 NH 1020 10590 25 12323 72 152         249 B 4/14/2020 09:00 2020-04-14T09:00:00Z 04/14 05:00 23 152 2020-04-14T09:00:00Z 12323                                   33 35 368 11635 posNeg 225 11610 0 0 0e140e6108d158a1dce7b6dc39cfaaa42179d08d 0 0 0 0 0  
9275 9275 20200414 NJ 68824 70950   139774 8185   2051   1626     A 4/14/2020 13:00 2020-04-14T13:00:00Z 04/14 09:00 3661   2020-04-14T13:00:00Z       68824 2805 856   139774                     34 4240 6065 139774 posNeg 10305 139774 411 0 1db7028a6744e5c2429418b45172a903458ff9f6 0 0 0 0 0  
9276 9276 20200414 NM 1345 30625   31970 87 181         304 A 4/14/2020 20:56 2020-04-14T20:56:00Z 04/14 16:56 31 181 2020-04-14T20:56:00Z                                     35 100 1355 31970 posNeg 1455 31970 5 181 6b9befa7ae97a2bedd587ef9da67bfcf254784f2 0 0 0 0 0  
9277 9277 20200414 NV 3088 23573   26661               A 4/14/2020 18:00 2020-04-14T18:00:00Z 04/14 14:00 141   2020-04-14T18:00:00Z 32178     3088                             32 117 1080 26661 posNeg 1197 26661 8 0 cc329f4104ba0d61da21c5a945ce68d532a13dec 0 0 0 0 0  
9278 9278 20200414 NY 202208 296935   499143 18697 54653 5225       25589 A 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 10834 54653 2020-04-14T00:00:00Z                                     36 7177 13609 499143 posNeg 20786 499143 778 1717 fbe9e820db81caa991f69da8969b0d5d0386e206 0 0 0 0 0  
9279 9279 20200414 OH 7280 60721   68001   2156   654       B 4/14/2020 14:00 2020-04-14T14:00:00Z 04/14 10:00 324 2156 2020-04-14T14:00:00Z       7153 309 15                         39 305 2584 68001 posNeg 2889 68001 50 123 a64cbbbfc8b72270c3e92a783e9c323698a199e8 0 0 0 0 0  
9280 9280 20200414 OK 2184 26085   28269 194 488 107       1060 B 4/14/2020 08:00 2020-04-14T08:00:00Z 04/14 04:00 108 488 2020-04-14T08:00:00Z       2184                             40 115 5295 28269 posNeg 5410 28269 9 31 09c113947a1d0febd48e3307ef9917eded4b17f8 0 0 0 0 0  
9281 9281 20200414 OR 1633 30730   32363 311 381 88   44     A 4/14/2020 11:00 2020-04-14T11:00:00Z 04/14 07:00 55 381 2020-04-14T11:00:00Z                                     41 49 1193 32363 posNeg 1242 32363 2 12 4347594ac1aaf9688ae94a6c14849cc847307645 0 0 0 0 0  
9282 9282 20200414 PA 25345 108286   133631 2317       675     A 4/14/2020 12:00 2020-04-14T12:00:00Z 04/14 08:00 584   2020-04-14T12:00:00Z               133631                     42 1146 2693 133631 posNeg 3839 133631 60 0 1dc48c70cd18ffac71d811676533e07cb295e80f 0 0 0 0 0  
9283 9283 20200414 PR 923 6284 1322 7207               A 4/14/2020 07:00 2020-04-14T07:00:00Z 04/14 03:00 45   2020-04-14T07:00:00Z                                     72 20 324 8529 posNeg 344 7207 0 0 9f53ac11c46a132d15f5a8269e90b5a278bd629c 0 0 0 0 0  
9284 9284 20200414 RI 3596 20990   24612 213 331 48       135 B 4/14/2020 03:00 2020-04-14T03:00:00Z 04/13 23:00 80 331 2020-04-14T03:00:00Z 26761 3706 23055 3596     24612 24586                     44 267 1559 24586 totalTestEncountersViral 1096 24586 7 0 0ceb1bc404683ddfa002f83de1809160b957985d 0 0 0 0 0  
9285 9285 20200414 SC 3553 30319   33872   675           B 4/14/2020 15:55 2020-04-14T15:55:00Z 04/14 11:55 97 675 2020-04-14T15:55:00Z       3553                             45 234 2213 33872 posNeg 2447 33872 15 179 1ef8bbab1547c505e0ff6860ba79edf1dcacd7e1 0 0 0 0 0  
9287 9287 20200414 TN 5823 73008   78831 443 633         1969 A 4/14/2020 15:00 2020-04-14T15:00:00Z 04/14 11:00 124 633 2020-04-14T15:00:00Z                                     47 213 2423 78831 posNeg 2636 78831 15 54 7d1187eb0d557e2823f6d45eec3806f28a399080 0 0 0 0 0  
9288 9288 20200414 TX 14624 131843   146467 1409           2580 A 4/14/2020 12:45 2020-04-14T12:45:00Z 04/14 08:45 318   2020-04-14T12:45:00Z       14624                             48 718 12523 146467 posNeg 13241 146467 31 0 6b220b82cc01038d8a7b5a7c76bcd8be6c197062 0 0 0 0 0  
9289 9289 20200414 UT 2412 44064   46476   213         218 A 4/14/2020 15:00 2020-04-14T15:00:00Z 04/14 11:00 19 213 2020-04-14T15:00:00Z       2412                             49 49 640 46476 posNeg 689 46476 1 12 c8b08541d190ad0c3e22f7e9d36caf4feab81fe9 0 0 0 0 0  
9291 9291 20200414 VI 51 326 23 377             44   4/14/2020 17:30 2020-04-14T17:30:00Z 04/14 13:30 1   2020-04-14T17:30:00Z                                     78 0 4 400 posNeg 4 377 0 0 5356dac1811f009855d5aafd6e343fde15040395 0 0 0 0 0  
9292 9292 20200414 VT 770 9491   10261 64           15 A 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 29   2020-04-14T00:00:00Z       770                             50 9 216 10261 posNeg 225 10261 1 0 891faf38f877d56710add6776ab428b2feb6a490 0 0 0 0 0  
9293 9293 20200414 WA 11330 134871   146201 387   98         C 4/14/2020 00:00 2020-04-14T00:00:00Z 04/13 20:00 542   2020-04-14T00:00:00Z       11330     146201 140247                     53 302 4356 146201 posNeg 4658 146201 16 0 6711a24f996d0a24845793e2c65185c605acfda2 0 0 0 0 0  
9294 9294 20200414 WI 4246 37997 277 42243 441 1049 161 283       A 4/14/2020 16:00 2020-04-14T16:00:00Z 04/14 12:00 170 1049 2020-04-14T16:00:00Z       3555                             55 166 1228 42520 posNeg 1394 42243 16 56 448513c4b897eabdb590a053c7e217b1af58ba0d 0 0 0 0 0  
9295 9295 20200414 WV 640 16398   17038 87 164 38 73 25 50 147 B 4/14/2020 17:00 2020-04-14T17:00:00Z 04/14 13:00 9 164 2020-04-14T17:00:00Z       640                             54 14 369 17038 posNeg 383 17038 0 0 15a96703ce2aa698640a57724d392b17834acd51 0 0 0 0 0  
9296 9296 20200414 WY 275 5689   5964   43         140 A 4/14/2020 16:05 2020-04-14T16:05:00Z 04/14 12:05 1 43 2020-04-14T16:05:00Z       275                             56 0 0 5964 posNeg 0 5964 0 2 c3e8ec87a4e88a935ea14a9e277904e1e0ef74eb 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
);