03-28-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

3,433 rows sorted by Province_State descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State ▲ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3255 3255     Western Australia Australia 3/28/20 23:11 -31.9505 115.8605 278 2 28 248 Western Australia, Australia
133 133 54001 Barbour West Virginia US 3/28/20 23:05 39.1307219 -80.00350858 0 0 0 0 Barbour, West Virginia, US
193 193 54003 Berkeley West Virginia US 3/28/20 23:05 39.46704621 -78.02414609 9 0 0 0 Berkeley, West Virginia, US
239 239 54005 Boone West Virginia US 3/28/20 23:05 38.01974191 -81.69888019 0 0 0 0 Boone, West Virginia, US
263 263 54007 Braxton West Virginia US 3/28/20 23:05 38.70036159 -80.72011184 0 0 0 0 Braxton, West Virginia, US
278 278 54009 Brooke West Virginia US 3/28/20 23:05 40.27367263 -80.57915332 0 0 0 0 Brooke, West Virginia, US
336 336 54011 Cabell West Virginia US 3/28/20 23:05 38.42424062 -82.23855912 0 0 0 0 Cabell, West Virginia, US
358 358 54013 Calhoun West Virginia US 3/28/20 23:05 38.84315422 -81.11934872 0 0 0 0 Calhoun, West Virginia, US
556 556 54015 Clay West Virginia US 3/28/20 23:05 38.46231092 -81.07652217 0 0 0 0 Clay, West Virginia, US
793 793 54017 Doddridge West Virginia US 3/28/20 23:05 39.27057157 -80.70671527 0 0 0 0 Doddridge, West Virginia, US
924 924 54019 Fayette West Virginia US 3/28/20 23:05 38.02974928 -81.08286634 0 0 0 0 Fayette, West Virginia, US
1045 1045 54021 Gilmer West Virginia US 3/28/20 23:05 38.9251277 -80.85952723 0 0 0 0 Gilmer, West Virginia, US
1094 1094 54023 Grant West Virginia US 3/28/20 23:05 39.10314817 -79.19440518 0 0 0 0 Grant, West Virginia, US
1110 1110 54025 Greenbrier West Virginia US 3/28/20 23:05 37.9463652 -80.45335881 1 0 0 0 Greenbrier, West Virginia, US
1173 1173 54027 Hampshire West Virginia US 3/28/20 23:05 39.32103553 -78.60826476 0 0 0 0 Hampshire, West Virginia, US
1185 1185 54029 Hancock West Virginia US 3/28/20 23:05 40.51943859 -80.57461608 1 0 0 0 Hancock, West Virginia, US
1202 1202 54031 Hardy West Virginia US 3/28/20 23:05 39.00683177 -78.85855301 0 0 0 0 Hardy, West Virginia, US
1220 1220 54033 Harrison West Virginia US 3/28/20 23:05 39.2853852 -80.37919577 4 0 0 0 Harrison, West Virginia, US
1386 1386 54035 Jackson West Virginia US 3/28/20 23:05 38.84263974 -81.68148753 6 0 0 0 Jackson, West Virginia, US
1424 1424 54037 Jefferson West Virginia US 3/28/20 23:05 39.30776166 -77.86014147 4 0 0 0 Jefferson, West Virginia, US
1468 1468 54039 Kanawha West Virginia US 3/28/20 23:05 38.33860077 -81.52857054 17 0 0 0 Kanawha, West Virginia, US
1653 1653 54041 Lewis West Virginia US 3/28/20 23:05 38.9947249 -80.49988181 0 0 0 0 Lewis, West Virginia, US
1685 1685 54043 Lincoln West Virginia US 3/28/20 23:05 38.172154 -82.07017953 0 0 0 0 Lincoln, West Virginia, US
1712 1712 54045 Logan West Virginia US 3/28/20 23:05 37.8299889 -81.93528571 1 0 0 0 Logan, West Virginia, US
1808 1808 54049 Marion West Virginia US 3/28/20 23:05 39.50984542 -80.24244659 3 0 0 0 Marion, West Virginia, US
1824 1824 54051 Marshall West Virginia US 3/28/20 23:05 39.86064362 -80.66591062 3 0 0 0 Marshall, West Virginia, US
1837 1837 54053 Mason West Virginia US 3/28/20 23:05 38.77071799 -82.02524219 3 0 0 0 Mason, West Virginia, US
1857 1857 54047 McDowell West Virginia US 3/28/20 23:05 37.38002939 -81.65083669 0 0 0 0 McDowell, West Virginia, US
1905 1905 54055 Mercer West Virginia US 3/28/20 23:05 37.40481169 -81.11023142 2 0 0 0 Mercer, West Virginia, US
1935 1935 54057 Mineral West Virginia US 3/28/20 23:05 39.41561583 -78.94104895 0 0 0 0 Mineral, West Virginia, US
1936 1936 54059 Mingo West Virginia US 3/28/20 23:05 37.73048351 -82.13338365 0 0 0 0 Mingo, West Virginia, US
1956 1956 54061 Monongalia West Virginia US 3/28/20 23:05 39.63218457 -80.04766838 23 0 0 0 Monongalia, West Virginia, US
1972 1972 54063 Monroe West Virginia US 3/28/20 23:05 37.56274716 -80.54577965 0 0 0 0 Monroe, West Virginia, US
2015 2015 54065 Morgan West Virginia US 3/28/20 23:05 39.55439028 -78.26311676 0 0 0 0 Morgan, West Virginia, US
2081 2081 54067 Nicholas West Virginia US 3/28/20 23:05 38.29617706 -80.79759588 0 0 0 0 Nicholas, West Virginia, US
2124 2124 54069 Ohio West Virginia US 3/28/20 23:05 40.0955451 -80.62203992 6 0 0 0 Ohio, West Virginia, US
2224 2224 54071 Pendleton West Virginia US 3/28/20 23:05 38.68314479 -79.35084086 0 0 0 0 Pendleton, West Virginia, US
2293 2293 54073 Pleasants West Virginia US 3/28/20 23:05 39.37091679 -81.16771771 1 0 0 0 Pleasants, West Virginia, US
2298 2298 54075 Pocahontas West Virginia US 3/28/20 23:05 38.32758728 -80.00993811 0 0 0 0 Pocahontas, West Virginia, US
2344 2344 54077 Preston West Virginia US 3/28/20 23:05 39.46770987 -79.66712803 1 0 0 0 Preston, West Virginia, US
2370 2370 54079 Putnam West Virginia US 3/28/20 23:05 38.50782345 -81.9082131 3 0 0 0 Putnam, West Virginia, US
2380 2380 54081 Raleigh West Virginia US 3/28/20 23:05 37.76936795 -81.2456041 3 0 0 0 Raleigh, West Virginia, US
2392 2392 54083 Randolph West Virginia US 3/28/20 23:05 38.769899 -79.87919615 0 0 0 0 Randolph, West Virginia, US
2439 2439 54085 Ritchie West Virginia US 3/28/20 23:05 39.18094587 -81.06356878 0 0 0 0 Ritchie, West Virginia, US
2442 2442 54087 Roane West Virginia US 3/28/20 23:05 38.71622686 -81.35243568 0 0 0 0 Roane, West Virginia, US
2730 2730 54089 Summers West Virginia US 3/28/20 23:05 37.65390597 -80.86009693 0 0 0 0 Summers, West Virginia, US
2774 2774 54091 Taylor West Virginia US 3/28/20 23:05 39.33602617 -80.0421439 0 0 0 0 Taylor, West Virginia, US
2837 2837 54093 Tucker West Virginia US 3/28/20 23:05 39.11240885 -79.57053576 2 0 0 0 Tucker, West Virginia, US
2850 2850 54095 Tyler West Virginia US 3/28/20 23:05 39.46811972 -80.88772676 0 0 0 0 Tyler, West Virginia, US
2898 2898 54097 Upshur West Virginia US 3/28/20 23:05 38.89285061 -80.23689136 1 0 0 0 Upshur, West Virginia, US
3032 3032 54099 Wayne West Virginia US 3/28/20 23:05 38.14901357 -82.42287994 0 0 0 0 Wayne, West Virginia, US
3044 3044 54101 Webster West Virginia US 3/28/20 23:05 38.49370949 -80.4202023 0 0 0 0 Webster, West Virginia, US
3055 3055 54103 Wetzel West Virginia US 3/28/20 23:05 39.6065771 -80.6401654 0 0 0 0 Wetzel, West Virginia, US
3113 3113 54105 Wirt West Virginia US 3/28/20 23:05 39.02775007 -81.37473928 0 0 0 0 Wirt, West Virginia, US
3119 3119 54107 Wood West Virginia US 3/28/20 23:05 39.20967886 -81.5162836 2 0 0 0 Wood, West Virginia, US
3141 3141 54109 Wyoming West Virginia US 3/28/20 23:05 37.612327 -81.54511071 0 0 0 0 Wyoming, West Virginia, US
19 19 53001 Adams Washington US 3/28/20 23:05 46.98299757 -118.5601734 5 0 0 0 Adams, Washington, US
95 95 53003 Asotin Washington US 3/28/20 23:05 46.18894415 -117.2022851 0 0 0 0 Asotin, Washington, US
189 189 53005 Benton Washington US 3/28/20 23:05 46.23946995 -119.5120834 42 5 0 0 Benton, Washington, US
469 469 53007 Chelan Washington US 3/28/20 23:05 47.87046092 -120.6173956 13 1 0 0 Chelan, Washington, US
517 517 53009 Clallam Washington US 3/28/20 23:05 48.04754642 -123.9226319 5 0 0 0 Clallam, Washington, US
531 531 53011 Clark Washington US 3/28/20 23:05 45.77568046 -122.4829204 82 6 0 0 Clark, Washington, US
612 612 53013 Columbia Washington US 3/28/20 23:05 46.29442881 -117.9051983 1 0 0 0 Columbia, Washington, US
650 650 53015 Cowlitz Washington US 3/28/20 23:05 46.19074721 -122.6782231 10 0 0 0 Cowlitz, Washington, US
817 817 53017 Douglas Washington US 3/28/20 23:05 47.7361335 -119.692937 5 0 0 0 Douglas, Washington, US
927 927 53019 Ferry Washington US 3/28/20 23:05 48.4711431 -118.5154041 1 0 0 0 Ferry, Washington, US
980 980 53021 Franklin Washington US 3/28/20 23:05 46.53351425 -118.9018212 12 0 0 0 Franklin, Washington, US
1018 1018 53023 Garfield Washington US 3/28/20 23:05 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
1093 1093 53025 Grant Washington US 3/28/20 23:05 47.20753737 -119.4500749 44 1 0 0 Grant, Washington, US
1101 1101 53027 Grays Harbor Washington US 3/28/20 23:05 47.14003705 -123.7820567 1 0 0 0 Grays Harbor, Washington, US
1357 1357 53029 Island Washington US 3/28/20 23:05 48.14713305 -122.5216407 80 1 0 0 Island, Washington, US
1423 1423 53031 Jefferson Washington US 3/28/20 23:05 47.75003077 -123.5609704 11 0 0 0 Jefferson, Washington, US
1506 1506 53033 King Washington US 3/28/20 23:05 47.49137892 -121.8346131 2077 136 0 0 King, Washington, US
1520 1520 53035 Kitsap Washington US 3/28/20 23:05 47.63479026 -122.6436061 42 1 0 0 Kitsap, Washington, US
1521 1521 53037 Kittitas Washington US 3/28/20 23:05 47.12521214 -120.679439 8 0 0 0 Kittitas, Washington, US
1525 1525 53039 Klickitat Washington US 3/28/20 23:05 45.87325839 -120.7913598 7 0 0 0 Klickitat, Washington, US
1652 1652 53041 Lewis Washington US 3/28/20 23:05 46.57756476 -122.3925769 7 0 0 0 Lewis, Washington, US
1684 1684 53043 Lincoln Washington US 3/28/20 23:05 47.57705241 -118.4194388 1 0 0 0 Lincoln, Washington, US
1836 1836 53045 Mason Washington US 3/28/20 23:05 47.35007586 -123.1863685 2 0 0 0 Mason, Washington, US
2126 2126 53047 Okanogan Washington US 3/28/20 23:05 48.54855019 -119.7387224 3 0 0 0 Okanogan, Washington, US
2190 2190 53049 Pacific Washington US 3/28/20 23:05 46.55418369 -123.7285716 0 0 0 0 Pacific, Washington, US
2221 2221 53051 Pend Oreille Washington US 3/28/20 23:05 48.53234021 -117.2741804 0 0 0 0 Pend Oreille, Washington, US
2265 2265 53053 Pierce Washington US 3/28/20 23:05 47.03892768 -122.1405958 231 5 0 0 Pierce, Washington, US
2515 2515 53055 San Juan Washington US 3/28/20 23:05 48.60182783 -122.96745 3 0 0 0 San Juan, Washington, US
2625 2625 53057 Skagit Washington US 3/28/20 23:05 48.48171488 -121.766131 91 1 0 0 Skagit, Washington, US
2627 2627 53059 Skamania Washington US 3/28/20 23:05 46.02408726 -121.9164403 1 0 0 0 Skamania, Washington, US
2634 2634 53061 Snohomish Washington US 3/28/20 23:05 48.04615983 -121.7170703 913 23 0 0 Snohomish, Washington, US
2651 2651 53063 Spokane Washington US 3/28/20 23:05 47.62113146 -117.4046494 108 2 0 0 Spokane, Washington, US
2705 2705 53065 Stevens Washington US 3/28/20 23:05 48.40035475 -117.8542701 3 0 0 0 Stevens, Washington, US
2797 2797 53067 Thurston Washington US 3/28/20 23:05 46.9291895 -122.8290656 27 0 0 0 Thurston, Washington, US
2876 2876   Unassigned Washington US 3/28/20 23:05 0.0 0.0 0 0 0 0 Unassigned, Washington, US
2937 2937 53069 Wahkiakum Washington US 3/28/20 23:05 46.2918004 -123.4250831 0 0 0 0 Wahkiakum, Washington, US
2944 2944 53071 Walla Walla Washington US 3/28/20 23:05 46.23040051 -118.4775539 4 0 0 0 Walla Walla, Washington, US
3058 3058 53073 Whatcom Washington US 3/28/20 23:05 48.82227976 -121.7490018 102 4 0 0 Whatcom, Washington, US
3074 3074 53075 Whitman Washington US 3/28/20 23:05 46.90022523 -117.5241763 6 0 0 0 Whitman, Washington, US
3144 3144 53077 Yakima Washington US 3/28/20 23:05 46.45738486 -120.7380126 82 2 0 0 Yakima, Washington, US
3 3 51001 Accomack Virginia US 3/28/20 23:05 37.76707161 -75.63234615 2 0 0 0 Accomack, Virginia, US
30 30 51003 Albemarle Virginia US 3/28/20 23:05 38.02080697 -78.55481085 16 0 0 0 Albemarle, Virginia, US
37 37 51510 Alexandria Virginia US 3/28/20 23:05 38.814003 -77.08183073 20 0 0 0 Alexandria, Virginia, US
45 45 51005 Alleghany Virginia US 3/28/20 23:05 37.78636074 -80.00222498 0 0 0 0 Alleghany, Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-28-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
);