states_daily_4pm_et

Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: README

3,825 rows

View and edit SQL

Suggested facets: dataQualityGrade, dateChecked (date), downloaded_by_bln (date)

Link rowid ▼ date state positive negative pending hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered dataQualityGrade lastUpdateEt hash dateChecked death hospitalized total totalTestResults posNeg fips deathIncrease hospitalizedIncrease negativeIncrease positiveIncrease totalTestResultsIncrease downloaded_by_bln
1 20200512 AK 383.0 29578.0   10.0           334.0 B 5/12/2020 00:00 ad64932142ec53f8eee1158369c6db3eb643ceed 2020-05-12T20:00:00Z 10.0   29961 29961 29961 2 0.0 0.0 1279.0 2.0 1281.0 2020-05-13T05:15:01+00:00
2 20200512 AL 10310.0 122908.0     1287.0   468.0   280.0   B 5/12/2020 00:00 dc0d90e43e92b36fb107e2ec174f64c4e91412e9 2020-05-12T20:00:00Z 429.0 1287.0 133218 133218 133218 1 28.0 31.0 3473.0 301.0 3774.0 2020-05-13T05:15:01+00:00
3 20200512 AR 4164.0 66280.0   59.0 485.0     12.0 98.0 3220.0 A 5/11/2020 18:55 c6b2b29faaf304a3e36270f55c766b0fc9773bc2 2020-05-12T20:00:00Z 95.0 485.0 70444 70444 70444 5 1.0 5.0 1284.0 130.0 1414.0 2020-05-13T05:15:01+00:00
4 20200512 AS 0.0 105.0                 C 5/10/2020 00:00 92e4d4fafe1a2e9955e7a0bac38789993d7da480 2020-05-12T20:00:00Z 0.0   105 105 105 60 0.0 0.0 0.0 0.0 0.0 2020-05-13T05:15:01+00:00
5 20200512 AZ 11736.0 111106.0   765.0 1564.0 318.0   204.0   2909.0 A+ 5/12/2020 00:00 e1f3e3aa6e1b798039369c830077e7267e4a6cde 2020-05-12T20:00:00Z 562.0 1564.0 122842 122842 122842 4 20.0 27.0 6022.0 356.0 6378.0 2020-05-13T05:15:01+00:00
6 20200512 CA 69382.0 963988.0   4544.0   1349.0         B 5/12/2020 00:00 1c3c812803c41f5b0c75e07b15a8a4428e7d662f 2020-05-12T20:00:00Z 2847.0   1033370 1033370 1033370 6 77.0 0.0 40030.0 1443.0 41473.0 2020-05-13T05:15:01+00:00
7 20200512 CO 19879.0 88778.0   738.0 3663.0         3114.0 A 5/11/2020 00:00 be4d64bed3daa1a877ec46a117750a6be309aaca 2020-05-12T20:00:00Z 987.0 3663.0 108657 108657 108657 8 6.0 -26.0 -113.0 -20.0 -133.0 2020-05-13T05:15:01+00:00
8 20200512 CT 34333.0 104091.0   1189.0 9389.0         5413.0 B 5/12/2020 14:00 94125cc6367af615dfdf3201a4acadd5160e7787 2020-05-12T20:00:00Z 3041.0 9389.0 138424 138424 138424 9 33.0 0.0 5348.0 568.0 5916.0 2020-05-13T05:15:01+00:00
9 20200512 DC 6485.0 24565.0   416.0       82.0   886.0 A 5/11/2020 00:00 9437f63c6fb36500cb3681a8b3667804ea58935d 2020-05-12T20:00:00Z 336.0   31050 31050 31050 11 8.0 0.0 693.0 96.0 789.0 2020-05-13T05:15:01+00:00
10 20200512 DE 6741.0 26550.0   276.0   467.0   263.0   2802.0 B 5/11/2020 18:00 f9a07cf2bc409487b6aac94345eba84c3af2c3a6 2020-05-12T20:00:00Z 237.0   33291 33291 33291 10 12.0 0.0 1187.0 176.0 1363.0 2020-05-13T05:15:01+00:00
11 20200512 FL 41923.0 537681.0 1064.0   7654.0           A+ 5/12/2020 09:28 c095dad326b6e29d6cdc568a6f8b53a910be8121 2020-05-12T20:00:00Z 1849.0 7654.0 580668 579604 579604 12 44.0 196.0 17606.0 941.0 18547.0 2020-05-13T05:15:01+00:00
12 20200512 GA 34635.0 227544.0     6130.0   1443.0       A+ 5/11/2020 13:00 b0656969e39a973d0cb2d4fdbf46bac5ffc9f638 2020-05-12T20:00:00Z 1461.0 6130.0 262179 262179 262179 13 20.0 115.0 10183.0 708.0 10891.0 2020-05-13T05:15:01+00:00
13 20200512 GU 152.0 3939.0               124.0 C 5/11/2020 18:00 b07de06424b91c7563ec1fd794d01ec27c2988d9 2020-05-12T20:00:00Z 5.0   4091 4091 4091 66 0.0 0.0 101.0 1.0 102.0 2020-05-13T05:15:01+00:00
14 20200512 HI 634.0 37305.0     81.0         561.0 B 5/11/2020 18:00 4c15f93f1f310f449317b691c7504e27d4b0a992 2020-05-12T20:00:00Z 17.0 81.0 37939 37939 37939 15 0.0 0.0 254.0 2.0 256.0 2020-05-13T05:15:01+00:00
15 20200512 IA 12912.0 68376.0   385.0   143.0   101.0   5618.0 A+ 5/12/2020 00:00 851003bc001f9d3c6070b7a0744f75232b70cfef 2020-05-12T20:00:00Z 289.0   81288 81288 81288 19 18.0 0.0 2957.0 539.0 3496.0 2020-05-13T05:15:01+00:00
16 20200512 ID 2260.0 30445.0     210.0   87.0     1508.0 B 5/11/2020 19:00 cdfbbe6e13eb9a49d4af2261bc1c8e26d78e13a9 2020-05-12T20:00:00Z 70.0 210.0 32705 32705 32705 16 3.0 3.0 533.0 30.0 563.0 2020-05-13T05:15:01+00:00
17 20200512 IL 83021.0 388670.0   4626.0   1215.0   730.0     A 5/12/2020 00:00 7eeee0fea9bfea9b5d442150defcb14e725265a0 2020-05-12T20:00:00Z 3601.0   471691 471691 471691 17 142.0 0.0 25252.0 4014.0 29266.0 2020-05-13T05:15:01+00:00
18 20200512 IN 25127.0 125383.0   1283.0   472.0   212.0     A+ 5/11/2020 23:59 070d23433b10418a1f1e8924d73c6edaf55446a3 2020-05-12T20:00:00Z 1578.0   150510 150510 150510 18 38.0 0.0 3322.0 500.0 3822.0 2020-05-13T05:15:01+00:00
19 20200512 KS 7116.0 46993.0     660.0   233.0   101.0 376.0 A 5/11/2020 10:00 e4e4b08f70f7483e20e2d1ab1e8a88a904c403de 2020-05-12T20:00:00Z 158.0 660.0 54109 54109 54109 20 0.0 0.0 0.0 0.0 0.0 2020-05-13T05:15:01+00:00
20 20200512 KY 6677.0 97347.0   383.0 1767.0 220.0 768.0     2335.0 A+ 5/11/2020 17:00 49f080fd95b649d6f35a2acacf5d6189f063f556 2020-05-12T20:00:00Z 311.0 1767.0 104024 104024 104024 21 7.0 10.0 16864.0 237.0 17101.0 2020-05-13T05:15:01+00:00
21 20200512 LA 32050.0 195962.0   1320.0       146.0   22608.0 B 5/12/2020 13:00 725798364fbd1d9d469c7f8d7a9f48c9d6dc5826 2020-05-12T20:00:00Z 2347.0   228012 228012 228012 22 39.0 0.0 6947.0 235.0 7182.0 2020-05-13T05:15:01+00:00
22 20200512 MA 79332.0 322164.0   3127.0 7842.0 818.0         A+ 5/12/2020 10:00 c0ec660677afe7ab283ad8476d692eac9ab0c5c5 2020-05-12T20:00:00Z 5141.0 7842.0 401496 401496 401496 25 33.0 110.0 5898.0 870.0 6768.0 2020-05-13T05:15:01+00:00
23 20200512 MD 34061.0 135442.0   1563.0 6287.0 590.0       2394.0   5/12/2020 10:00 1b2bdc997453e056cd3567e9331675dee5759225 2020-05-12T20:00:00Z 1756.0 6287.0 169503 169503 169503 24 73.0 104.0 4035.0 688.0 4723.0 2020-05-13T05:15:01+00:00
24 20200512 ME 1477.0 22092.0   34.0 202.0 17.0   8.0   913.0 B 5/12/2020 12:30 8d555f344de837c9297183826a631604f9095d84 2020-05-12T20:00:00Z 65.0 202.0 23569 23569 23569 23 0.0 2.0 0.0 15.0 15.0 2020-05-13T05:15:01+00:00
25 20200512 MI 48021.0 259869.0   1384.0   693.0   525.0   22686.0 A+ 5/12/2020 11:00 f89a13701a2f7ee5383d462bde185e0e48ce1c94 2020-05-12T20:00:00Z 4674.0   307890 307890 307890 26 90.0 0.0 8473.0 469.0 8942.0 2020-05-13T05:15:01+00:00
26 20200512 MN 12494.0 108340.0   496.0 1799.0 199.0 625.0       A 5/11/2020 17:00 b7f43bbd409a8641550236b0176e1b3f08de3720 2020-05-12T20:00:00Z 614.0 1799.0 120834 120834 120834 27 23.0 83.0 4358.0 695.0 5053.0 2020-05-13T05:15:01+00:00
27 20200512 MO 10006.0 111290.0   787.0       140.0     B 5/12/2020 15:00 a0b380a66f7e018682c96854e0dc4ebd6529dba4 2020-05-12T20:00:00Z 524.0   121296 121296 121296 29 36.0 0.0 5588.0 88.0 5676.0 2020-05-13T05:15:01+00:00
28 20200512 MP 19.0 2854.0               12.0 D 5/12/2020 00:00 de6e7a04c4dcd1ab903b996dfb4990a2a9981bba 2020-05-12T20:00:00Z 2.0   2873 2873 2873 69 0.0 0.0 178.0 0.0 178.0 2020-05-13T05:15:01+00:00
29 20200512 MS 9908.0 87784.0   604.0 1582.0 146.0   75.0   6268.0 A 5/11/2020 19:00 c2ad322a2ca23780c0423744f1c8d342b86e2cde 2020-05-12T20:00:00Z 457.0 1582.0 97692 97692 97692 28 22.0 36.0 1573.0 234.0 1807.0 2020-05-13T05:15:01+00:00
30 20200512 MT 461.0 22574.0   4.0 63.0         425.0 B 5/12/2020 00:00 2b3dc441154f5955223ec8be3d6b25315ae87038 2020-05-12T20:00:00Z 16.0 63.0 23035 23035 23035 30 0.0 1.0 461.0 2.0 463.0 2020-05-13T05:15:01+00:00
31 20200512 NC 15346.0 186898.0   475.0           9115.0 A 5/12/2020 11:00 99811235d4384d8dc44fb9b020be9a445fca0410 2020-05-12T20:00:00Z 577.0   202244 202244 202244 37 27.0 0.0 6078.0 301.0 6379.0 2020-05-13T05:15:01+00:00
32 20200512 ND 1571.0 46261.0   38.0 122.0         877.0 C 5/12/2020 12:10 6439186903c6409dca9c56820e62dc85e6ab838e 2020-05-12T20:00:00Z 38.0 122.0 47832 47832 47832 38 2.0 7.0 765.0 53.0 818.0 2020-05-13T05:15:01+00:00
33 20200512 NE 8572.0 39371.0   192.0   81.0   56.0     B 5/11/2020 20:05 82de0819c060549c93f72549b792b5de897151e2 2020-05-12T20:00:00Z 100.0   47943 47943 47943 31 2.0 0.0 1447.0 257.0 1704.0 2020-05-13T05:15:01+00:00
34 20200512 NH 3160.0 32401.0 54.0 117.0 318.0   97.0     1231.0 B 5/11/2020 09:00 4ea2337b6353839aa3392a0949b5de5037f18200 2020-05-12T20:00:00Z 133.0 318.0 35615 35561 35561 33 0.0 0.0 678.0 0.0 678.0 2020-05-13T05:15:01+00:00
35 20200512 NJ 140743.0 292317.0   4328.0   1306.0   982.0   15642.0 A+ 5/12/2020 13:00 a551c9bb3078185c8537e653e9855a75e1844e2f 2020-05-12T20:00:00Z 9508.0   433060 433060 433060 34 198.0 0.0 6329.0 798.0 7127.0 2020-05-13T05:15:01+00:00
36 20200512 NM 5069.0 101652.0   207.0 886.0         1300.0 C 5/11/2020 22:33 6d7039f5d1bc3661cde6775cc8c8f54088ec2a2b 2020-05-12T20:00:00Z 208.0 886.0 106721 106721 106721 35 8.0 97.0 4017.0 206.0 4223.0 2020-05-13T05:15:01+00:00
37 20200512 NV 6311.0 57764.0   522.0   121.0   64.0   185.0 C 5/12/2020 12:30 a1ac2e2156586d3396c44f016461670c4d570e8e 2020-05-12T20:00:00Z 312.0   64075 64075 64075 32 6.0 0.0 3832.0 159.0 3991.0 2020-05-13T05:15:01+00:00
38 20200512 NY 338485.0 886628.0   7063.0 73143.0 2375.0   1964.0   58679.0 A 5/12/2020 00:00 557195b2b5a5899f0b86cf3d014ed6a5b11dd26a 2020-05-12T20:00:00Z 21845.0 73143.0 1225113 1225113 1225113 36 205.0 0.0 19032.0 1430.0 20462.0 2020-05-13T05:15:01+00:00
39 20200512 OH 25250.0 192481.0   1032.0 4539.0 401.0 1232.0 270.0     B 5/12/2020 14:00 de8d2b78e3adb0f6a856466164f7abbfe651e297 2020-05-12T20:00:00Z 1436.0 4539.0 217731 217731 217731 39 79.0 126.0 6728.0 473.0 7201.0 2020-05-13T05:15:01+00:00
40 20200512 OK 4732.0 91379.0   190.0 828.0 83.0       3423.0 A+ 5/12/2020 00:00 ab5d94f248233e426e55e603e11be5d53cb0fc1d 2020-05-12T20:00:00Z 278.0 828.0 96111 96111 96111 40 4.0 0.0 0.0 119.0 119.0 2020-05-13T05:15:01+00:00
41 20200512 OR 3286.0 74320.0   165.0 673.0 39.0   25.0   1125.0 A+ 5/12/2020 11:52 2d615f054ea8e40981ad1c1119401e4cfae83193 2020-05-12T20:00:00Z 130.0 673.0 77606 77606 77606 41 0.0 0.0 0.0 0.0 0.0 2020-05-13T05:15:01+00:00
42 20200512 PA 57991.0 237989.0   2187.0       497.0     C 5/12/2020 12:00 fa3ba6d4689c14fb4158f6072afa997b7d6078e3 2020-05-12T20:00:00Z 3806.0   295980 295980 295980 42 75.0 0.0 6285.0 837.0 7122.0 2020-05-13T05:15:01+00:00
43 20200512 PR 2299.0                   C 5/12/2020 06:30 dd849b252fa9866c8bba2f82baae46c6f552e95d 2020-05-12T20:00:00Z 114.0   2299 2299 2299 72 1.0 0.0 0.0 43.0 43.0 2020-05-13T05:15:01+00:00
44 20200512 RI 11614.0 83625.0   277.0 1307.0 72.0   53.0   863.0 A+ 5/12/2020 12:00 0b3efb331e4b384182d3a043259392a9b43e03e5 2020-05-12T20:00:00Z 444.0 1307.0 95239 95239 95239 44 14.0 27.0 1743.0 164.0 1907.0 2020-05-13T05:15:01+00:00
45 20200512 SC 7927.0 85213.0     1338.0         6817.0 A 5/12/2020 16:14 d9ad2effd29087d5acdaddd770ddf5116ff02f21 2020-05-12T20:00:00Z 355.0 1338.0 93140 93140 93140 45 24.0 86.0 8409.0 274.0 8683.0 2020-05-13T05:15:01+00:00
46 20200512 SD 3663.0 21534.0   74.0 271.0         2309.0 B 5/12/2020 11:30 398b44ebe956f8b3706040627f7a9fbc550424f1 2020-05-12T20:00:00Z 39.0 271.0 25197 25197 25197 46 5.0 8.0 570.0 49.0 619.0 2020-05-13T05:15:01+00:00
47 20200512 TN 16111.0 267713.0     1363.0         8336.0 A 5/12/2020 16:00 b54071de6f6bdd53a83161c3100769996827243e 2020-05-12T20:00:00Z 265.0 1363.0 283824 283824 283824 47 14.0 19.0 9980.0 567.0 10547.0 2020-05-13T05:15:01+00:00
48 20200512 TX 39869.0 485828.0   1725.0           21713.0 A 5/11/2020 16:25 c2be51d8e637f5f56c233abd72c96b7e10cc1cbf 2020-05-12T20:00:00Z 1100.0   525697 525697 525697 48 0.0 0.0 0.0 0.0 0.0 2020-05-13T05:15:01+00:00
49 20200512 UT 6432.0 147053.0   166.0 535.0   178.0   80.0 3267.0 B 5/12/2020 15:00 529a080f15d8f439a8f5d45ba54214b08fd1cdbc 2020-05-12T20:00:00Z 73.0 535.0 153485 153485 153485 49 5.0 18.0 2830.0 70.0 2900.0 2020-05-13T05:15:01+00:00
50 20200512 VA 25800.0 129529.0 447.0 1529.0 4929.0 364.0   201.0   3400.0 A+ 5/12/2020 09:00 45d4f6b36abd4c2c07613461218de47ff5c0c389 2020-05-12T20:00:00Z 891.0 4929.0 155776 155329 155329 51 41.0 152.0 3982.0 730.0 4712.0 2020-05-13T05:15:01+00:00
51 20200512 VI 69.0 1115.0 58.0             61.0 C 5/12/2020 14:19 866582e0254dc6dd9d7793bd722ba6661a15affc 2020-05-12T20:00:00Z 6.0   1242 1184 1184 78 1.0 0.0 5.0 0.0 5.0 2020-05-13T05:15:01+00:00
52 20200512 VT 927.0 20335.0   18.0           787.0 B 5/12/2020 00:00 753bba5966252600f220802d111cf2b2235eb5e0 2020-05-12T20:00:00Z 53.0   21262 21262 21262 50 0.0 0.0 390.0 1.0 391.0 2020-05-13T05:15:01+00:00
53 20200512 WA 17122.0 234986.0   321.0   94.0         A 5/11/2020 02:59 b72b86f14cbadf67317ae856d016fbfc5eb67ebd 2020-05-12T20:00:00Z 945.0   252108 252108 252108 53 14.0 0.0 3002.0 231.0 3233.0 2020-05-13T05:15:01+00:00
54 20200512 WI 10611.0 112748.0 180.0 520.0 1877.0 116.0 464.0     5371.0 A+ 5/12/2020 12:23 0f63f7dde4112e772bcdfc22930c6a3f586ed906 2020-05-12T20:00:00Z 418.0 1877.0 123539 123359 123359 55 9.0 31.0 4715.0 193.0 4908.0 2020-05-13T05:15:01+00:00
55 20200512 WV 1371.0 63698.0   50.0   9.0   5.0   803.0 C 5/12/2020 10:00 f37078141cf9d5c1e30b4386d7cb47825c2621bd 2020-05-12T20:00:00Z 57.0   65069 65069 65069 54 3.0 0.0 1595.0 5.0 1600.0 2020-05-13T05:15:01+00:00
56 20200512 WY 675.0 14384.0   10.0 67.0         477.0 B 5/12/2020 15:50 edb8d27bf5882660de5e5b0543f7624c2b51f9d2 2020-05-12T20:00:00Z 7.0 67.0 15059 15059 15059 56 0.0 1.0 2981.0 13.0 2994.0 2020-05-13T05:15:01+00:00
57 20200511 AK 381.0 28299.0   7.0           328.0 C 5/11/2020 00:00 a7223546ea51f5c1f4befbca92cbba972c4254a3 2020-05-11T20:00:00Z 10.0   28680 28680 28680 2 0.0 0.0 1314.0 2.0 1316.0 2020-05-13T05:15:01+00:00
58 20200511 AL 10009.0 119435.0     1256.0   463.0   276.0   B 5/11/2020 00:00 7a458a485ba87dec00819901d27fc50e4fbfdb01 2020-05-11T20:00:00Z 401.0 1256.0 129444 129444 129444 1 8.0 16.0 1791.0 232.0 2023.0 2020-05-13T05:15:01+00:00
59 20200511 AR 4034.0 64996.0   61.0 480.0     11.0 98.0 3149.0 A 5/10/2020 19:05 dbe584b0f033faf71ab1255e32755841c0161597 2020-05-11T20:00:00Z 94.0 480.0 69030 69030 69030 5 6.0 9.0 3215.0 287.0 3502.0 2020-05-13T05:15:01+00:00
60 20200511 AS 0.0 105.0                 D 5/10/2020 00:00 9b5ed3d398c7403c615f2cb9e18aff10510c6d39 2020-05-11T20:00:00Z 0.0   105 105 105 60 0.0 0.0 22.0 0.0 22.0 2020-05-13T05:15:01+00:00
61 20200511 AZ 11380.0 105084.0   717.0 1537.0 297.0   201.0   2852.0 A+ 5/11/2020 00:00 afa17a1ea8cc6e6a5c171643105c247148ac1517 2020-05-11T20:00:00Z 542.0 1537.0 116464 116464 116464 4 6.0 9.0 5826.0 261.0 6087.0 2020-05-13T05:15:01+00:00
62 20200511 CA 67939.0 923958.0   4549.0   1329.0         B 5/11/2020 00:00 53613cacac307d4a734c079025735a0eec798c35 2020-05-11T20:00:00Z 2770.0   991897 991897 991897 6 25.0 0.0 34974.0 1259.0 36233.0 2020-05-13T05:15:01+00:00
63 20200511 CO 19899.0 88891.0   573.0 3689.0         3076.0 B 5/10/2020 00:00 4228d219947f9f2ce5463646f15dca0f339d5c51 2020-05-11T20:00:00Z 981.0 3689.0 108790 108790 108790 8 14.0 66.0 7656.0 524.0 8180.0 2020-05-13T05:15:01+00:00
64 20200511 CT 33765.0 98743.0   1212.0 9389.0         5413.0 B 5/11/2020 14:00 725f98630b953261d0e361ea3ce240eb58dd87a5 2020-05-11T20:00:00Z 3008.0 9389.0 132508 132508 132508 9 41.0 0.0 2105.0 211.0 2316.0 2020-05-13T05:15:01+00:00
65 20200511 DC 6389.0 23872.0   416.0       82.0   881.0 A 5/10/2020 00:00 96823a86d077b838aa718a491d8ad8e667579778 2020-05-11T20:00:00Z 328.0   30261 30261 30261 11 5.0 0.0 574.0 117.0 691.0 2020-05-13T05:15:01+00:00
66 20200511 DE 6565.0 25363.0   275.0           2619.0 B 5/10/2020 18:00 b495a3c92d603717fcb0e0353a8b46934f687d7a 2020-05-11T20:00:00Z 225.0   31928 31928 31928 10 1.0 0.0 771.0 118.0 889.0 2020-05-13T05:15:01+00:00
67 20200511 FL 40982.0 520075.0 1080.0   7458.0           B 5/11/2020 09:31 41a0c5448dd172e1de13ee660933da7aca6920e0 2020-05-11T20:00:00Z 1805.0 7458.0 562137 561057 561057 12 14.0 54.0 21723.0 386.0 22109.0 2020-05-13T05:15:01+00:00
68 20200511 GA 33927.0 217361.0     6015.0   1414.0       A 5/11/2020 13:00 36622751034808e79ec4a2f2a0e717a7238d62c4 2020-05-11T20:00:00Z 1441.0 6015.0 251288 251288 251288 13 36.0 18.0 7255.0 486.0 7741.0 2020-05-13T05:15:01+00:00
69 20200511 GU 151.0 3838.0               124.0 C 5/11/2020 06:45 344915c252ec72e2897d08cedf0096c076238394 2020-05-11T20:00:00Z 5.0   3989 3989 3989 66 0.0 0.0 195.0 0.0 195.0 2020-05-13T05:15:01+00:00
70 20200511 HI 632.0 37051.0     81.0         561.0 B 5/10/2020 18:00 c1a3fdf904f506a49beb3904919cfb214d1056b1 2020-05-11T20:00:00Z 17.0 81.0 37683 37683 37683 15 0.0 0.0 412.0 1.0 413.0 2020-05-13T05:15:01+00:00
71 20200511 IA 12373.0 65419.0   394.0   152.0   107.0   5249.0 A+ 5/11/2020 00:00 6dc1fea55734472dff46f44afd605f1af78a08de 2020-05-11T20:00:00Z 271.0   77792 77792 77792 19 6.0 0.0 3204.0 414.0 3618.0 2020-05-13T05:15:01+00:00
72 20200511 ID 2230.0 29912.0     207.0   87.0     1473.0 B 5/9/2020 19:00 320a48fe6833d123bb557c59e853aa6f0948fc96 2020-05-11T20:00:00Z 67.0 207.0 32142 32142 32142 16 0.0 0.0 0.0 0.0 0.0 2020-05-13T05:15:01+00:00
73 20200511 IL 79007.0 363418.0   4319.0   1248.0   730.0     A 5/11/2020 00:00 f44cdbee224288e9756f9c879b4330cf1a40125a 2020-05-11T20:00:00Z 3459.0   442425 442425 442425 17 53.0 0.0 11175.0 1266.0 12441.0 2020-05-13T05:15:01+00:00
74 20200511 IN 24627.0 122061.0   1346.0 4389.0 452.0 990.0 213.0     A+ 5/10/2020 23:59 a57c95bf26ced24d8dba4841fca0b3ed92f8ddfd 2020-05-11T20:00:00Z 1540.0 4389.0 146688 146688 146688 18 32.0 0.0 6158.0 501.0 6659.0 2020-05-13T05:15:01+00:00
75 20200511 KS 7116.0 46993.0     660.0   233.0   101.0 376.0 A 5/11/2020 10:00 37cb8fd29d5e89ecc06556f7e2c38e2870d68a69 2020-05-11T20:00:00Z 158.0 660.0 54109 54109 54109 20 1.0 3.0 1436.0 168.0 1604.0 2020-05-13T05:15:01+00:00
76 20200511 KY 6440.0 80483.0   394.0 1757.0 226.0 758.0     2308.0 A 5/9/2020 17:00 65bd44bbae0cf8f21518a61a2cf25ccc1bd682fc 2020-05-11T20:00:00Z 304.0 1757.0 86923 86923 86923 21 0.0 0.0 0.0 0.0 0.0 2020-05-13T05:15:01+00:00
77 20200511 LA 31815.0 189015.0   1310.0       157.0   22608.0 B 5/11/2020 13:00 882c80ef83db3a2040f72edd1c0b65c14bcf63be 2020-05-11T20:00:00Z 2308.0   220830 220830 220830 22 22.0 0.0 4743.0 215.0 4958.0 2020-05-13T05:15:01+00:00
78 20200511 MA 78462.0 316266.0   3102.0 7732.0 813.0         A 5/11/2020 10:00 6e951327a5d89abb820241523b201fdd432bb5e9 2020-05-11T20:00:00Z 5108.0 7732.0 394728 394728 394728 25 129.0 115.0 5670.0 669.0 6339.0 2020-05-13T05:15:01+00:00
79 20200511 MD 33373.0 131407.0   1544.0 6183.0 585.0       2298.0   5/11/2020 10:00 18b34eceb38d5a6ff1b85aebb7018b36d8ef661a 2020-05-11T20:00:00Z 1683.0 6183.0 164780 164780 164780 24 39.0 228.0 4063.0 786.0 4849.0 2020-05-13T05:15:01+00:00
80 20200511 ME 1462.0 22092.0   37.0 200.0 17.0   9.0   872.0 B 5/11/2020 12:00 c25684830089eb770ad7aedc26e6565286ebfbab 2020-05-11T20:00:00Z 65.0 200.0 23554 23554 23554 23 1.0 1.0 0.0 26.0 26.0 2020-05-13T05:15:01+00:00
81 20200511 MI 47552.0 251396.0   1424.0   685.0   557.0   22686.0 A+ 5/11/2020 11:00 a5d0f888a8b221813babc8a27f5015b598c9a9c2 2020-05-11T20:00:00Z 4584.0   298948 298948 298948 26 33.0 0.0 12856.0 414.0 13270.0 2020-05-13T05:15:01+00:00
82 20200511 MN 11799.0 103982.0   452.0 1716.0 194.0 600.0     7536.0 A 5/10/2020 17:00 f6a5865209748cf8637acf820d4467b408af499d 2020-05-11T20:00:00Z 591.0 1716.0 115781 115781 115781 27 13.0 59.0 4165.0 528.0 4693.0 2020-05-13T05:15:01+00:00
83 20200511 MO 9918.0 105702.0   824.0       137.0     B 5/11/2020 15:00 0a40716dc1fc6b5028e3a0b211783ea46f043cd9 2020-05-11T20:00:00Z 488.0   115620 115620 115620 29 6.0 0.0 0.0 74.0 74.0 2020-05-13T05:15:01+00:00
84 20200511 MP 19.0 2676.0               12.0 D 5/11/2020 00:00 5083b9724765025f257e7b96c00732bf25063219 2020-05-11T20:00:00Z 2.0   2695 2695 2695 69 0.0 0.0 355.0 3.0 358.0 2020-05-13T05:15:01+00:00
85 20200511 MS 9674.0 86211.0   507.0 1546.0 132.0   68.0   6268.0 A 5/10/2020 19:00 7b98e0ac888e25cb18aced67458df0e038dbf2cb 2020-05-11T20:00:00Z 435.0 1546.0 95885 95885 95885 28 5.0 15.0 14110.0 173.0 14283.0 2020-05-13T05:15:01+00:00
86 20200511 MT 459.0 22113.0   4.0 62.0         423.0 C 5/10/2020 00:00 8bbba487e4da82581b0cf57a838d1c0a9b85971f 2020-05-11T20:00:00Z 16.0 62.0 22572 22572 22572 30 0.0 0.0 867.0 1.0 868.0 2020-05-13T05:15:01+00:00
87 20200511 NC 15045.0 180820.0   464.0           9115.0 B 5/11/2020 14:00 df1be569ae745bfd298a930e35362f09b2dad0c9 2020-05-11T20:00:00Z 550.0   195865 195865 195865 37 3.0 0.0 3449.0 281.0 3730.0 2020-05-13T05:15:01+00:00
88 20200511 ND 1518.0 45496.0   34.0 115.0         846.0 C 5/11/2020 12:10 0d5f52057ed67028f24db06f823d35bd8a25a4fa 2020-05-11T20:00:00Z 36.0 115.0 47014 47014 47014 38 1.0 5.0 2118.0 27.0 2145.0 2020-05-13T05:15:01+00:00
89 20200511 NE 8315.0 37924.0                 D 5/10/2020 19:45 e58065fd1954d908292eee28a9f7fa0147c1658f 2020-05-11T20:00:00Z 98.0   46239 46239 46239 31 2.0 0.0 589.0 81.0 670.0 2020-05-13T05:15:01+00:00
90 20200511 NH 3160.0 31723.0 261.0 113.0 318.0   97.0     1229.0 B 5/10/2020 09:00 1e4d21c6c7cb4723f7c568bff5bb5287f0176a6c 2020-05-11T20:00:00Z 133.0 318.0 35144 34883 34883 33 2.0 5.0 1281.0 149.0 1430.0 2020-05-13T05:15:01+00:00
91 20200511 NJ 139945.0 285988.0   4195.0   1255.0   970.0   15642.0 A+ 5/11/2020 13:00 94fa78b2e3195af312b3de2382d6da9df5a34c2d 2020-05-11T20:00:00Z 9310.0   425933 425933 425933 34 55.0 0.0 112073.0 1413.0 113486.0 2020-05-13T05:15:01+00:00
92 20200511 NM 4863.0 97635.0   194.0 789.0         1285.0 C 5/10/2020 17:50 431ea4a184bf3daa6990f2048eadb3bbffd4e3a3 2020-05-11T20:00:00Z 200.0 789.0 102498 102498 102498 35 9.0 0.0 5360.0 85.0 5445.0 2020-05-13T05:15:01+00:00
93 20200511 NV 6152.0 53932.0   482.0   117.0   60.0   183.0 C 5/11/2020 13:30 835d3bc0c7cb54e6e40f6e63266d5675959a69a6 2020-05-11T20:00:00Z 306.0   60084 60084 60084 32 0.0 0.0 1221.0 54.0 1275.0 2020-05-13T05:15:01+00:00
94 20200511 NY 337055.0 867596.0   7226.0 73143.0 2450.0   2020.0   58363.0 A 5/10/2020 00:00 c605cd69fc6d8af2586f5f00c31106bff9a1edd9 2020-05-11T20:00:00Z 21640.0 73143.0 1204651 1204651 1204651 36 162.0 428.0 19993.0 1660.0 21653.0 2020-05-13T05:15:01+00:00
95 20200511 OH 24777.0 185753.0   1011.0 4413.0 391.0 1217.0 256.0     B 5/11/2020 14:00 cdf49b3d1bbbb6ee921c935e2760c07c4064d760 2020-05-11T20:00:00Z 1357.0 4413.0 210530 210530 210530 39 16.0 62.0 4972.0 696.0 5668.0 2020-05-13T05:15:01+00:00
96 20200511 OK 4613.0 91379.0   177.0 828.0 93.0       3241.0 A+ 5/11/2020 00:00 04935b380656454e2afe3546d5ca7532a81d5efa 2020-05-11T20:00:00Z 274.0 828.0 95992 95992 95992 40 2.0 2.0 0.0 24.0 24.0 2020-05-13T05:15:01+00:00
97 20200511 OR 3286.0 74320.0   164.0 673.0 40.0   23.0   1125.0 A+ 5/11/2020 11:00 04658e44200d2f00f1f31ece71de204266d1e870 2020-05-11T20:00:00Z 130.0 673.0 77606 77606 77606 41 3.0 3.0 2041.0 58.0 2099.0 2020-05-13T05:15:01+00:00
98 20200511 PA 57154.0 231704.0   2176.0       497.0     C 5/11/2020 00:00 76cf6b30b46ddf22c8cd3d091eea7ae6fde2279b 2020-05-11T20:00:00Z 3731.0   288858 288858 288858 42 24.0 0.0 3932.0 543.0 4475.0 2020-05-13T05:15:01+00:00
99 20200511 PR 2256.0                   D 5/11/2020 05:57 c241a9b6b383c2725aa95666ccfb34e74c9bf690 2020-05-11T20:00:00Z 113.0   2256 2256 2256 72 2.0 0.0 0.0 58.0 58.0 2020-05-13T05:15:01+00:00
100 20200511 RI 11450.0 81882.0   276.0 1280.0 73.0   52.0   841.0 A+ 5/11/2020 12:00 5d97783cd28918685ef4cd8e2b2a4452ced74fc9 2020-05-11T20:00:00Z 430.0 1280.0 93332 93332 93332 44 8.0 29.0 1943.0 176.0 2119.0 2020-05-13T05:15:01+00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [states_daily_4pm_et] (
   [date] INTEGER,
   [state] TEXT,
   [positive] TEXT,
   [negative] TEXT,
   [pending] TEXT,
   [hospitalizedCurrently] TEXT,
   [hospitalizedCumulative] TEXT,
   [inIcuCurrently] TEXT,
   [inIcuCumulative] TEXT,
   [onVentilatorCurrently] TEXT,
   [onVentilatorCumulative] TEXT,
   [recovered] TEXT,
   [dataQualityGrade] TEXT,
   [lastUpdateEt] TEXT,
   [hash] TEXT,
   [dateChecked] TEXT,
   [death] TEXT,
   [hospitalized] TEXT,
   [total] INTEGER,
   [totalTestResults] INTEGER,
   [posNeg] INTEGER,
   [fips] INTEGER,
   [deathIncrease] TEXT,
   [hospitalizedIncrease] TEXT,
   [negativeIncrease] TEXT,
   [positiveIncrease] TEXT,
   [totalTestResultsIncrease] TEXT,
   [downloaded_by_bln] TEXT
);
Powered by Datasette · Query took 330.076ms · Data source: Big Local News · About: README