states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
63 rows where "dateModified" is on date 2020-03-27
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, dateChecked (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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 );