states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
11,578 rows sorted by checkTimeEt
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11232 | 11232 | 20200309 | CO | 9 | 133 | 8 | 1 | 29 | 142 | totalTestEncountersViral | 0 | 142 | 0 | 0 | 3d368bb124f205e41980bb81b9aa8dd35fee69e1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11233 | 11233 | 20200309 | CT | 1 | 46 | 47 | 9 | 0 | 17 | 47 | posNeg | 17 | 47 | 0 | 0 | 3460d990629bee323004fe0c856bcfa236445872 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11234 | 11234 | 20200309 | DC | 1 | 14 | 3 | 15 | 15 | 11 | 0 | 4 | 18 | posNeg | 4 | 15 | 0 | 0 | 871b7cd94b9b8f24e9ce7b92599a3d8d74f9bcee | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11235 | 11235 | 20200309 | DE | 0 | 15 | 3 | 15 | 0 | 0 | 0 | 10 | 0 | 5 | 18 | posNeg | 5 | 15 | 0 | 0 | 823abf3528dd749d86b87805f871f9f3ae8462d7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11236 | 11236 | 20200309 | FL | 18 | 140 | 115 | 158 | 12 | 1 | 22 | 273 | posNeg | 23 | 158 | 0 | 0 | 272554ab2c8836c465fdca8b59256695d17670e3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11237 | 11237 | 20200309 | GA | 12 | 12 | 12 | 13 | 5 | 0 | 12 | posNeg | 5 | 12 | 0 | 0 | 5f5815f234e114a99fa2e89c41872d220ced0c2e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11238 | 11238 | 20200309 | HI | 2 | 2 | 15 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 8ee289ff9078e8033d2c7d9c46923f9418b544a5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11239 | 11239 | 20200309 | IA | 3 | 26 | 8 | 29 | 3 | 19 | 3 | 11 | 37 | posNeg | 14 | 29 | 0 | 0 | b8dc500cce3e739103e390d6c9f4f8b0a8e46328 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11240 | 11240 | 20200309 | ID | 0 | 41 | 41 | 41 | 16 | 0 | 14 | 41 | posNeg | 14 | 41 | 0 | 0 | 0bb8c14df250aac4cf5a3aaaa7328ec7c13f13be | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11241 | 11241 | 20200309 | IL | 7 | 191 | 44 | 198 | 17 | 1 | 0 | 242 | posNeg | 1 | 198 | 0 | 0 | 245224bbffc249298e668e251b7f75ad655de8b7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11242 | 11242 | 20200309 | IN | 2 | 2 | 18 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | d8eecf48ba3c86aafcc5a09a39ccb3f2dc81f9b2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11243 | 11243 | 20200309 | KS | 1 | 11 | 0 | 12 | 20 | 0 | 0 | 12 | posNeg | 0 | 12 | 0 | 0 | 3b07a260694a45339350ad295d3aadae35006680 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11244 | 11244 | 20200309 | KY | 4 | 17 | 21 | 21 | 21 | 3 | 4 | 21 | posNeg | 7 | 21 | 0 | 0 | 18b4aa37d777a24d97ddaa577042de1687aa6f66 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11245 | 11245 | 20200309 | LA | 1 | 5 | 6 | 1 | 22 | 1 | 0 | 6 | posNeg | 1 | 6 | 0 | 0 | be423464762f6e54b8e900805a923bdb76f313e5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11246 | 11246 | 20200309 | MA | 393 | 393 | 104 | 25 | 0 | 0 | 0 | totalTestsViral | 81 | 0 | 0 | 0 | c8737f3b8f8739dd2ab76899e8b1b8fe950b5060 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11247 | 11247 | 20200309 | MD | 5 | 73 | 78 | 5 | 24 | 2 | 21 | 78 | posNeg | 23 | 78 | 0 | 0 | 5d746abd07e2a42d0b9b0a1cf817452013ea252e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11248 | 11248 | 20200309 | ME | 0 | 1 | 1 | 0 | 23 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 151049d836a370c678897ad29c326c5c564a2748 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11249 | 11249 | 20200309 | MI | 372 | 36 | 11 | 408 | 372 | 0 | 0 | 26 | 121 | 10 | 419 | posNeg | 131 | 408 | 0 | 0 | 3db434f41b9fca9ceb5a93a44fa5701084cd2615 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11250 | 11250 | 20200309 | MN | 5 | 80 | 85 | 5 | 85 | 27 | 3 | 32 | 85 | posNeg | 35 | 85 | 0 | 0 | 31f992b88dc83549737b8d96b25c24e650a2e1f4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11251 | 11251 | 20200309 | MO | 1 | 1 | 36 | 7 | 29 | 1 | 29 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | 1a079fbedfc8d7a374c7de179459b5f80f1430f4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11252 | 11252 | 20200309 | MS | 0 | 0 | 28 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 73925bb7fe329e44af31e4bb25ff3381372fe665 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11253 | 11253 | 20200309 | MT | 0 | 11 | 11 | 30 | 0 | 0 | 11 | posNeg | 0 | 11 | 0 | 0 | 7389a58a4096673a163b6abf629c9c0a397e9da9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11254 | 11254 | 20200309 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 024fa80c3564c92b1a1c9bd6fde8eedbb6ca12ab | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11255 | 11255 | 20200309 | ND | 0 | 38 | 0 | 0 | 0 | totalTestEncountersViral | 0 | 0 | 0 | 0 | 4ad41844d2b76f5c0eb62e557a7831850a11d41e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
11256 | 11256 | 20200309 | NE | 3 | 36 | 9 | 39 | 31 | 2 | 19 | 48 | posNeg | 21 | 39 | 0 | 0 | 33b0c03c48cc9fdf7d864a6ade2aea5117db8b45 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11257 | 11257 | 20200309 | NH | 4 | 38 | 5 | 93 | 93 | 33 | 0 | 0 | 47 | posNeg | 17 | 42 | 0 | 0 | 2859407c6af11271b394398423375528dd9aadb5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11258 | 11258 | 20200309 | NJ | 11 | 35 | 14 | 46 | 0 | 15 | 0 | 46 | 34 | 5 | 4 | 60 | posNeg | 9 | 46 | 0 | 0 | bd5e7832140e711221e353279d2f7f4d92baffb4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11259 | 11259 | 20200309 | NM | 0 | 57 | 0 | 57 | 35 | 0 | 9 | 57 | posNeg | 9 | 57 | 0 | 0 | ac25a8d3406ff87fde418383f82e3d1f54976817 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11260 | 11260 | 20200309 | NV | 5 | 14 | 19 | 0 | 5 | 32 | 1 | 0 | 19 | posNeg | 1 | 19 | 0 | 0 | 0fb23255c1d8d2f83d8d02295d9f4e3a9afba207 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11261 | 11261 | 20200309 | NY | 142 | 92 | 234 | 36 | 37 | 0 | 234 | posNeg | 37 | 234 | 0 | 0 | 8ced4ee7303d4b53064272d89025d912aa9e0480 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11262 | 11262 | 20200309 | OH | 3 | 11 | 5 | 14 | 3 | 39 | 3 | 1 | 19 | posNeg | 4 | 14 | 0 | 0 | 88b2a6a796386e77dc29f202865af47c5a1f51b7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11263 | 11263 | 20200309 | OK | 1 | 8 | 10 | 9 | 40 | 0 | 0 | 19 | posNeg | 0 | 9 | 0 | 0 | 0ad8ae590b299814d0478e353d89422c055bf9c9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11264 | 11264 | 20200309 | OR | 14 | 165 | 52 | 179 | 41 | 0 | 65 | 231 | posNeg | 65 | 179 | 0 | 0 | 352e8fd3a8bc305ebe6c5a17c0853f9a4b156d7e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11265 | 11265 | 20200309 | PA | 10 | 10 | 42 | 4 | 0 | 10 | posNeg | 4 | 10 | 0 | 0 | 3c5d003242603efee2879b691f1c3bf469e35d0a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11267 | 11267 | 20200309 | SC | 7 | 24 | 31 | 7 | 45 | 5 | 16 | 31 | posNeg | 21 | 31 | 0 | 0 | 5a9ab8c08475f3817f2e1dd542f3fca081c52d00 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11268 | 11268 | 20200309 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | fd69eda5746c616093059afe31b23b3f20293319 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11269 | 11269 | 20200309 | TN | 3 | 3 | 47 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | 1611da9ace942c73343f7d59a9d088c604e3cb6a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11270 | 11270 | 20200309 | TX | 12 | 12 | 12 | 48 | 4 | 0 | 12 | posNeg | 4 | 12 | 0 | 0 | b283ff8631311d3d2f21c0bf4a85adabcc7aa3dc | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11271 | 11271 | 20200309 | UT | 1 | 1 | 1 | 49 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | fd93e289f042fae8dbafd8e636e48969b3516227 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11272 | 11272 | 20200309 | VA | 3 | 38 | 9 | 6463 | 2092 | 6463 | 51 | 1 | 2 | 50 | posNeg | 1 | 41 | 0 | 0 | b964b6ccdaf2b2e7c08bfc25225ee5c5ae7f3813 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11275 | 11275 | 20200309 | WI | 1 | 36 | 37 | 1 | 55 | 0 | 5 | 37 | posNeg | 5 | 37 | 0 | 0 | 6ffacef1b40b39a6c44596a184117c74d0b58f91 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11276 | 11276 | 20200309 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | a621da63913b2294614db788f9ffaa61cea7dce9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11277 | 11277 | 20200309 | WY | 0 | 0 | 56 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | da9229ffb7d8168343c69d6723f75c60ac582de4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11278 | 11278 | 20200308 | AK | 0 | 14 | 6 | 14 | 0 | 14 | 0 | 2 | 0 | 2 | 20 | posNeg | 2 | 14 | 0 | 0 | 6b81cc323d5c85c152509d7e64cf0e428abfee4f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11279 | 11279 | 20200308 | AL | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 8eb4159c94fe6df2dc1839181f800cd64839b28a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11280 | 11280 | 20200308 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | f279c3c9df7df0e71ad32775ff46df28a5524a4a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11281 | 11281 | 20200308 | AZ | 5 | 44 | 7 | 49 | 6 | 6 | 49 | 4 | 0 | 0 | 56 | posNeg | 0 | 49 | 0 | 0 | a5a637e9e8d91ff4d69f0ccfb308511249a3ce62 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11282 | 11282 | 20200308 | CA | 88 | 462 | 550 | 550 | 6 | 19 | 0 | 550 | posNeg | 19 | 550 | 0 | 0 | a3942f78a6e249860f262bc34ce2dcf62f37dbdd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11283 | 11283 | 20200308 | CO | 8 | 104 | 8 | 0 | 49 | 112 | totalTestEncountersViral | 0 | 112 | 0 | 0 | 317774d5a34dd4d0eef33343ca211cb2503d1d3b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11284 | 11284 | 20200308 | CT | 1 | 29 | 8 | 30 | 9 | 1 | 29 | 38 | posNeg | 30 | 30 | 0 | 0 | 7bfb078b056071aedacc4ed06b83e39e62833f26 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11285 | 11285 | 20200308 | DC | 1 | 10 | 0 | 11 | 11 | 11 | 1 | 2 | 11 | posNeg | 3 | 11 | 0 | 0 | 688541968c5c91129f3cac155fa3788425f4287d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11286 | 11286 | 20200308 | DE | 0 | 10 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | 418a26a20050481e80ea0e97a282e9b6e0df42a0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11287 | 11287 | 20200308 | FL | 17 | 118 | 108 | 135 | 12 | 3 | 18 | 243 | posNeg | 21 | 135 | 0 | 0 | 5a59fe82642c0a6e0bfd9bb98470c1e07a81e9f7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11288 | 11288 | 20200308 | GA | 7 | 7 | 7 | 13 | 1 | 0 | 7 | posNeg | 1 | 7 | 0 | 0 | ba0e1de92ee7d7a3ba88b7eb0aa563feb3dcbe97 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11289 | 11289 | 20200308 | HI | 1 | 1 | 15 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | fce32ebadc808697f80252996d531a82e417dc07 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11290 | 11290 | 20200308 | IA | 0 | 15 | 2 | 15 | 0 | 19 | 0 | 0 | 17 | posNeg | 0 | 15 | 0 | 0 | 43d95fae93a9fe11b86ff5acf7ae88c55d443577 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11291 | 11291 | 20200308 | ID | 0 | 27 | 27 | 27 | 16 | 0 | 0 | 27 | posNeg | 0 | 27 | 0 | 0 | b5205073e97a2e9539a0c92ee58ac8dcc755043e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11292 | 11292 | 20200308 | IL | 6 | 191 | 44 | 197 | 17 | 0 | 0 | 241 | posNeg | 0 | 197 | 0 | 0 | c73c83bd8a61155d40495d38d9a7c24ddfdb1def | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11293 | 11293 | 20200308 | IN | 2 | 2 | 18 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | f1a024c9493ca5c13fa1400447fdc64cb4fa13c8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11294 | 11294 | 20200308 | KS | 1 | 11 | 0 | 12 | 20 | 1 | 0 | 12 | posNeg | 1 | 12 | 0 | 0 | ab077c8d3b451599a6758b3239cc6bc6afd80293 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11295 | 11295 | 20200308 | KY | 1 | 13 | 14 | 14 | 21 | 0 | 4 | 14 | posNeg | 4 | 14 | 0 | 0 | 8d989de21dd25851afeae8309bcf335499423211 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11296 | 11296 | 20200308 | LA | 0 | 5 | 5 | 0 | 22 | 0 | 5 | 5 | posNeg | 5 | 5 | 0 | 0 | b2f8598087a737fc9a845252abe3223ffee9ba51 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11297 | 11297 | 20200308 | MA | 312 | 312 | 97 | 25 | 0 | 0 | 0 | totalTestsViral | 61 | 0 | 0 | 0 | 1814b674cd6bdce088b0eb60fb89488fb17e7e71 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11298 | 11298 | 20200308 | MD | 3 | 52 | 55 | 3 | 24 | 0 | 11 | 55 | posNeg | 11 | 55 | 0 | 0 | 3970b25a2743722fbd8236a32ab019e6035ba666 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11299 | 11299 | 20200308 | ME | 0 | 1 | 1 | 0 | 23 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | cb22017cc43ff01b5997c50e8f5be05c5d342bd2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11300 | 11300 | 20200308 | MI | 251 | 26 | 10 | 277 | 251 | 0 | 0 | 26 | 63 | 8 | 287 | posNeg | 71 | 277 | 0 | 0 | e2c37577317d1a8bea22069ba010581d9daf9e36 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11301 | 11301 | 20200308 | MN | 2 | 48 | 50 | 2 | 50 | 27 | 0 | 0 | 50 | posNeg | 0 | 50 | 0 | 0 | 9e5b3d3886236a0bb763d79cb58322c1045dc24d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11302 | 11302 | 20200308 | MO | 1 | 1 | 31 | 7 | 24 | 1 | 29 | 1 | 0 | 1 | posNeg | 1 | 1 | 0 | 0 | a9675ed0fffa1d3032f7ec9be2fcbdc716b9522e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11303 | 11303 | 20200308 | MS | 0 | 0 | 28 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | cc5746f5c7159063fc280b496210b12200c8f8ba | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11304 | 11304 | 20200308 | MT | 0 | 11 | 11 | 30 | 0 | 0 | 11 | posNeg | 0 | 11 | 0 | 0 | e8b2489a8e1a4aad59ecc05469bbc5f735ba53d4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11305 | 11305 | 20200308 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 2db7cf8e77c62d6f4dd1ec027d8a60e26f50323f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11306 | 11306 | 20200308 | ND | 0 | 38 | 0 | 0 | 0 | totalTestEncountersViral | 0 | 0 | 0 | 0 | b684c79b81d30d754ad2c80fa62ec200090b516c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
11307 | 11307 | 20200308 | NE | 1 | 17 | 5 | 18 | 31 | 0 | 0 | 23 | posNeg | 0 | 18 | 0 | 0 | c6feafa145e7943e034bbe36f9c8447091381a79 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11308 | 11308 | 20200308 | NH | 4 | 38 | 5 | 76 | 76 | 33 | 2 | 18 | 47 | posNeg | 30 | 42 | 0 | 0 | aecf5aee02f143dd271250cef46938ff78031cb9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11309 | 11309 | 20200308 | NJ | 6 | 31 | 0 | 37 | 0 | 6 | 0 | 37 | 34 | 2 | 31 | 37 | posNeg | 33 | 37 | 0 | 0 | a6c9627d5e04c1f8454b2702bd379d2268475c94 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11310 | 11310 | 20200308 | NM | 0 | 48 | 0 | 48 | 35 | 0 | 0 | 48 | posNeg | 0 | 48 | 0 | 0 | 36deae5cf36b2d7cd79e7e79e2a81713e9289562 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11311 | 11311 | 20200308 | NV | 4 | 14 | 18 | 0 | 4 | 32 | 0 | 0 | 18 | posNeg | 0 | 18 | 0 | 0 | ddda6650981f4cccff52afa77a60330154f8b5e9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11312 | 11312 | 20200308 | NY | 105 | 92 | 197 | 36 | 29 | 0 | 197 | posNeg | 29 | 197 | 0 | 0 | 8b4ccf56cc9ddfaacef5d4e42a99d94dfee8af12 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11313 | 11313 | 20200308 | OH | 0 | 10 | 4 | 10 | 0 | 39 | 0 | 1 | 14 | posNeg | 1 | 10 | 0 | 0 | d1556490881cee1bac170fcb6815a724458c19f6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11314 | 11314 | 20200308 | OK | 1 | 8 | 2 | 9 | 40 | 0 | 8 | 11 | posNeg | 8 | 9 | 0 | 0 | ad27cf7d0a09050ea38a384e59f4748614f2daaf | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11315 | 11315 | 20200308 | OR | 14 | 100 | 53 | 114 | 41 | 7 | 23 | 167 | posNeg | 30 | 114 | 0 | 0 | c08657ecf8300ee6c87a74f5a080cdc6a5516a89 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11316 | 11316 | 20200308 | PA | 6 | 6 | 42 | 2 | 0 | 6 | posNeg | 2 | 6 | 0 | 0 | c06d9371ae937eeaa1d3ded4fc30ec96b45a173b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11318 | 11318 | 20200308 | SC | 2 | 8 | 10 | 2 | 45 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | 06efb7f0d09fd6085072c864a041b228f6f02046 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11319 | 11319 | 20200308 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | 41976be1e052bda9301ee0e94670725da3ea87eb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11320 | 11320 | 20200308 | TN | 3 | 3 | 47 | 2 | 0 | 3 | posNeg | 2 | 3 | 0 | 0 | 4617ccbe70ea4376d978c1530ca256efb32e9c88 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11321 | 11321 | 20200308 | TX | 8 | 8 | 8 | 48 | 0 | 0 | 8 | posNeg | 0 | 8 | 0 | 0 | f94e478683fbfcc8099c8c30041dbacebf8d9550 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11322 | 11322 | 20200308 | UT | 1 | 1 | 1 | 49 | 0 | 0 | 1 | posNeg | 0 | 1 | 0 | 0 | df00cbca051e0e1dc323cc91af54c88361a9c4ad | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11323 | 11323 | 20200308 | VA | 2 | 36 | 6 | 6462 | 2092 | 6462 | 51 | 2 | 5 | 44 | posNeg | 5 | 38 | 0 | 0 | cdb4f172da273b46e108b0eae5d11a38b5e23a0f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11326 | 11326 | 20200308 | WI | 1 | 31 | 12 | 32 | 1 | 55 | 0 | 0 | 44 | posNeg | 0 | 32 | 0 | 0 | 1ae5a09fda475b413981a9919b9599b711119635 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11327 | 11327 | 20200308 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | a88a2c3fac00ba8ad7b58dcdac4ef6e995725c07 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11328 | 11328 | 20200308 | WY | 0 | 0 | 56 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 6f10e168a722b2a166508ec388d99c5eeb567a1b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11329 | 11329 | 20200307 | AK | 0 | 12 | 2 | 12 | 0 | 12 | 0 | 2 | 0 | 4 | 14 | posNeg | 4 | 12 | 0 | 0 | 8bfa10ec1a5b2be5876b88e6216bfea42987ea88 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11330 | 11330 | 20200307 | AL | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 062a875e155dc8ad644b12029c0c17d4666882d3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11331 | 11331 | 20200307 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | 1ece7893cfeed3ae7d761db447cb080f14977c61 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11332 | 11332 | 20200307 | AZ | 5 | 44 | 7 | 49 | 6 | 6 | 49 | 4 | 2 | 11 | 56 | posNeg | 13 | 49 | 0 | 0 | 2e72b8016a5e0a0e8de3dbb24eea7d0f472c18a8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11333 | 11333 | 20200307 | CA | 69 | 462 | 531 | 531 | 6 | 9 | 0 | 531 | posNeg | 9 | 531 | 0 | 0 | 368900bfcc9ba110fd8f8472b7726b3791504344 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11334 | 11334 | 20200307 | CO | 8 | 55 | 69 | 8 | 6 | 9 | 132 | totalTestEncountersViral | 0 | 63 | 0 | 0 | 39f9b7cdfbc31b49c063b576225e389f6961d5ea | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11335 | 11335 | 20200307 | CT | 0 | 0 | 9 | 0 | 0 | 0 | posNeg | 0 | 0 | 0 | 0 | 5f478e572f0f10d74cbfc6018e916f4a00905ad1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11336 | 11336 | 20200307 | DC | 0 | 8 | 1 | 8 | 8 | 11 | 0 | 0 | 9 | posNeg | 0 | 8 | 0 | 0 | 6ca390a3a8d83a1af1c763d44042115aa85d1175 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11337 | 11337 | 20200307 | DE | 0 | 10 | 0 | 10 | 10 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | c083cd6ee50c6645888f0bdf9e7b778d226d66a0 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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 );