04-24-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: README

47 rows where "Last_Update" is on date 2020-04-24

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Province_State, Country_Region, Last_Update, Deaths, Recovered, Last_Update (date)

Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
17 17 53001 Adams Washington US 2020-04-24 00:00:00 46.98299757 -118.5601734 45 0 0 45 Adams, Washington, US
87 87 53003 Asotin Washington US 2020-04-24 00:00:00 46.18894415 -117.2022851 16 1 0 15 Asotin, Washington, US
169 169 53005 Benton Washington US 2020-04-24 00:00:00 46.23946995 -119.5120834 383 39 0 347 Benton, Washington, US
420 420 53007 Chelan Washington US 2020-04-24 00:00:00 47.87046092 -120.6173956 89 5 0 84 Chelan, Washington, US
465 465 53009 Clallam Washington US 2020-04-24 00:00:00 48.04754642 -123.9226319 14 0 0 14 Clallam, Washington, US
478 478 53011 Clark Washington US 2020-04-24 00:00:00 45.77568046 -122.4829204 293 20 0 277 Clark, Washington, US
554 554 53013 Columbia Washington US 2020-04-24 00:00:00 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
588 588 53015 Cowlitz Washington US 2020-04-24 00:00:00 46.19074721 -122.6782231 36 0 0 36 Cowlitz, Washington, US
732 732 53017 Douglas Washington US 2020-04-24 00:00:00 47.7361335 -119.692937 69 1 0 68 Douglas, Washington, US
825 825 53019 Ferry Washington US 2020-04-24 00:00:00 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
873 873 53021 Franklin Washington US 2020-04-24 00:00:00 46.53351425 -118.9018212 239 5 0 234 Franklin, Washington, US
905 905 53023 Garfield Washington US 2020-04-24 00:00:00 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
967 967 53025 Grant Washington US 2020-04-24 00:00:00 47.20753737 -119.4500749 149 3 0 147 Grant, Washington, US
975 975 53027 Grays Harbor Washington US 2020-04-24 00:00:00 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1198 1198 53029 Island Washington US 2020-04-24 00:00:00 48.14713305 -122.5216407 160 8 0 151 Island, Washington, US
1259 1259 53031 Jefferson Washington US 2020-04-24 00:00:00 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1328 1328 53033 King Washington US 2020-04-24 00:00:00 47.49137892 -121.8346131 5637 418 0 5244 King, Washington, US
1338 1338 53035 Kitsap Washington US 2020-04-24 00:00:00 47.63479026 -122.6436061 143 2 0 141 Kitsap, Washington, US
1339 1339 53037 Kittitas Washington US 2020-04-24 00:00:00 47.12521214 -120.679439 14 0 0 14 Kittitas, Washington, US
1343 1343 53039 Klickitat Washington US 2020-04-24 00:00:00 45.87325839 -120.7913598 16 2 0 13 Klickitat, Washington, US
1456 1456 53041 Lewis Washington US 2020-04-24 00:00:00 46.57756476 -122.3925769 25 3 0 22 Lewis, Washington, US
1487 1487 53043 Lincoln Washington US 2020-04-24 00:00:00 47.57705241 -118.4194388 2 0 0 2 Lincoln, Washington, US
1627 1627 53045 Mason Washington US 2020-04-24 00:00:00 47.35007586 -123.1863685 22 0 0 22 Mason, Washington, US
1895 1895 53047 Okanogan Washington US 2020-04-24 00:00:00 48.54855019 -119.7387224 16 1 0 16 Okanogan, Washington, US
1959 1959 53049 Pacific Washington US 2020-04-24 00:00:00 46.55418369 -123.7285716 4 0 0 4 Pacific, Washington, US
1986 1986 53051 Pend Oreille Washington US 2020-04-24 00:00:00 48.53234021 -117.2741804 2 0 0 2 Pend Oreille, Washington, US
2025 2025 53053 Pierce Washington US 2020-04-24 00:00:00 47.03892768 -122.1405958 1212 51 0 1169 Pierce, Washington, US
2241 2241 53055 San Juan Washington US 2020-04-24 00:00:00 48.60182783 -122.96745 14 0 0 14 San Juan, Washington, US
2333 2333 53057 Skagit Washington US 2020-04-24 00:00:00 48.48171488 -121.766131 283 10 0 273 Skagit, Washington, US
2334 2334 53059 Skamania Washington US 2020-04-24 00:00:00 46.02408726 -121.9164403 3 0 0 3 Skamania, Washington, US
2341 2341 53061 Snohomish Washington US 2020-04-24 00:00:00 48.04615983 -121.7170703 2243 102 0 2141 Snohomish, Washington, US
2360 2360 53063 Spokane Washington US 2020-04-24 00:00:00 47.62113146 -117.4046494 330 19 0 311 Spokane, Washington, US
2411 2411 53065 Stevens Washington US 2020-04-24 00:00:00 48.40035475 -117.8542701 9 1 0 8 Stevens, Washington, US
2490 2490 53067 Thurston Washington US 2020-04-24 00:00:00 46.9291895 -122.8290656 98 1 0 97 Thurston, Washington, US
2589 2589 90053 Unassigned Washington US 2020-04-24 00:00:00     100 0 0 100 Unassigned, Washington, US
2645 2645 53069 Wahkiakum Washington US 2020-04-24 00:00:00 46.29180039999999 -123.4250831 2 0 0 2 Wahkiakum, Washington, US
2652 2652 53071 Walla Walla Washington US 2020-04-24 00:00:00 46.23040051 -118.4775539 48 0 0 48 Walla Walla, Washington, US
2757 2757 53073 Whatcom Washington US 2020-04-24 00:00:00 48.82227976 -121.7490018 282 27 0 255 Whatcom, Washington, US
2771 2771 53075 Whitman Washington US 2020-04-24 00:00:00 46.90022523 -117.5241763 14 0 0 14 Whitman, Washington, US
2837 2837 53077 Yakima Washington US 2020-04-24 00:00:00 46.45738486 -120.7380126 923 43 0 880 Yakima, Washington, US
2863 2863     Anhui China 2020-04-24 12:04:47 31.8257 117.2264 991 6 985 0 Anhui, China
2872 2872     Chongqing China 2020-04-24 00:43:27 30.0572 107.874 579 6 573 0 Chongqing, China
2894 2894     Hong Kong China 2020-04-24 12:45:30 22.3 114.2 1035 4 725 306 Hong Kong, China
2899 2899     Jiangsu China 2020-04-24 01:27:14 32.9711 119.455 653 0 646 7 Jiangsu, China
2929 2929     Sichuan China 2020-04-24 01:27:14 30.6171 102.7103 561 3 558 0 Sichuan, China
2939 2939     Zhejiang China 2020-04-24 01:36:27 29.1832 120.0934 1268 1 1256 11 Zhejiang, China
3101 3101       Taiwan* 2020-04-24 06:54:42 23.7 121.0 428 6 264 158 Taiwan*

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-24-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);