states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
61 rows where "dateChecked" is on date 2020-04-14 sorted by negativeIncrease
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||
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 | |||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||
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 | |||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | ||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | |||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 |
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 );