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

2,437 rows sorted by Combined_Key descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key ▲
2437 2437       Zimbabwe 2020-03-31 23:43:43 -19.015438 29.154857 8 1 0 7 Zimbabwe
2260 2260     Zhejiang China 2020-03-31 01:23:49 29.1832 120.0934 1257 1 1226 30 Zhejiang, China
2436 2436       Zambia 2020-03-31 23:43:43 -13.133897 27.849332 35 0 0 35 Zambia
2259 2259     Yunnan China 2020-03-31 23:31:54 24.974 101.487 182 2 172 8 Yunnan, China
2172 2172 8125 Yuma Colorado US 2020-03-31 23:43:56 40.00346839 -102.4258673 2 0 0 0 Yuma, Colorado, US
2171 2171 4027 Yuma Arizona US 2020-03-31 23:43:56 32.76895712 -113.90666740000002 9 0 0 0 Yuma, Arizona, US
2170 2170 6115 Yuba California US 2020-03-31 23:43:56 39.26255932 -121.35356440000001 6 0 0 0 Yuba, California, US
2169 2169 48503 Young Texas US 2020-03-31 23:43:56 33.17659707 -98.68790885 1 0 0 0 Young, Texas, US
2168 2168 51199 York Virginia US 2020-03-31 23:43:56 37.24374789 -76.54412815 14 1 0 0 York, Virginia, US
2167 2167 45091 York South Carolina US 2020-03-31 23:43:56 34.97281497 -81.18085944 56 1 0 0 York, South Carolina, US
2166 2166 42133 York Pennsylvania US 2020-03-31 23:43:56 39.9210089 -76.73040131 66 0 0 0 York, Pennsylvania, US
2165 2165 31185 York Nebraska US 2020-03-31 23:43:56 40.87272618 -97.59710186 1 0 0 0 York, Nebraska, US
2164 2164 23031 York Maine US 2020-03-31 23:43:56 43.47808377 -70.71052375 59 1 0 0 York, Maine, US
2163 2163 6113 Yolo California US 2020-03-31 23:43:56 38.68278902 -121.90182879999999 24 1 0 0 Yolo, California, US
2162 2162 30111 Yellowstone Montana US 2020-03-31 23:43:56 45.93955949 -108.26914860000001 31 0 0 0 Yellowstone, Montana, US
2161 2161 28163 Yazoo Mississippi US 2020-03-31 23:43:56 32.77890365 -90.39656148 9 0 0 0 Yazoo, Mississippi, US
2160 2160 4025 Yavapai Arizona US 2020-03-31 23:43:56 34.59933926 -112.5538588 21 0 0 0 Yavapai, Arizona, US
2159 2159 46135 Yankton South Dakota US 2020-03-31 23:43:56 43.00924485 -97.39467635 6 0 0 0 Yankton, South Dakota, US
2158 2158 41071 Yamhill Oregon US 2020-03-31 23:43:56 45.23330449 -123.3086963 16 3 0 0 Yamhill, Oregon, US
2157 2157 28161 Yalobusha Mississippi US 2020-03-31 23:43:56 34.02824175 -89.70762049999998 6 0 0 0 Yalobusha, Mississippi, US
2156 2156 53077 Yakima Washington US 2020-03-31 23:43:56 46.45738486 -120.73801259999999 161 3 0 0 Yakima, Washington, US
2155 2155 37197 Yadkin North Carolina US 2020-03-31 23:43:56 36.16222629 -80.66239436 3 0 0 0 Yadkin, North Carolina, US
2257 2257     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2154 2154 51197 Wythe Virginia US 2020-03-31 23:43:56 36.91582035 -81.07834059 1 0 0 0 Wythe, Virginia, US
2153 2153 36121 Wyoming New York US 2020-03-31 23:43:56 42.70145109 -78.22199579 8 1 0 0 Wyoming, New York, US
2152 2152 20209 Wyandotte Kansas US 2020-03-31 23:43:56 39.11727348 -94.76378225 79 4 0 0 Wyandotte, Kansas, US
2151 2151 39175 Wyandot Ohio US 2020-03-31 23:43:56 40.84339621 -83.30734173 2 0 0 0 Wyandot, Ohio, US
2150 2150 29229 Wright Missouri US 2020-03-31 23:43:56 37.27029221 -92.46914488 4 0 0 0 Wright, Missouri, US
2149 2149 27171 Wright Minnesota US 2020-03-31 23:43:56 45.17297924 -93.96234781 6 0 0 0 Wright, Minnesota, US
2148 2148 19197 Wright Iowa US 2020-03-31 23:43:56 42.73305373 -93.73515113 1 0 0 0 Wright, Iowa, US
2147 2147 13321 Worth Georgia US 2020-03-31 23:43:56 31.55162306 -83.85090513 29 1 0 0 Worth, Georgia, US
2146 2146 25027 Worcester Massachusetts US 2020-03-31 23:43:56 42.35026951 -71.90493363 433 7 0 0 Worcester, Massachusetts, US
2145 2145 24047 Worcester Maryland US 2020-03-31 23:43:56 38.21274277 -75.33200012 3 0 0 0 Worcester, Maryland, US
2144 2144 20207 Woodson Kansas US 2020-03-31 23:43:56 37.8865336 -95.74006277 2 0 0 0 Woodson, Kansas, US
2143 2143 5147 Woodruff Arkansas US 2020-03-31 23:43:56 35.18902527 -91.2439489 1 0 0 0 Woodruff, Arkansas, US
2142 2142 21239 Woodford Kentucky US 2020-03-31 23:43:56 38.04178222 -84.7417556 5 0 0 0 Woodford, Kentucky, US
2141 2141 17203 Woodford Illinois US 2020-03-31 23:43:56 40.78579374 -89.20973757 3 0 0 0 Woodford, Illinois, US
2140 2140 19193 Woodbury Iowa US 2020-03-31 23:43:56 42.38979414 -96.0459439 4 0 0 0 Woodbury, Iowa, US
2139 2139 55141 Wood Wisconsin US 2020-03-31 23:43:56 44.45537896 -90.04158336 2 0 0 0 Wood, Wisconsin, US
2138 2138 54107 Wood West Virginia US 2020-03-31 23:43:56 39.20967886 -81.5162836 2 0 0 0 Wood, West Virginia, US
2137 2137 48499 Wood Texas US 2020-03-31 23:43:56 32.78722382 -95.38236368 1 0 0 0 Wood, Texas, US
2136 2136 39173 Wood Ohio US 2020-03-31 23:43:56 41.36224827 -83.62285108 15 0 0 0 Wood, Ohio, US
2135 2135 48497 Wise Texas US 2020-03-31 23:43:56 33.21570665 -97.65460265 1 0 0 0 Wise, Texas, US
2134 2134 54105 Wirt West Virginia US 2020-03-31 23:43:56 39.02775007 -81.37473928 1 0 0 0 Wirt, West Virginia, US
2133 2133 28159 Winston Mississippi US 2020-03-31 23:43:56 33.08747908 -89.03391385 7 0 0 0 Winston, Mississippi, US
2132 2132 1133 Winston Alabama US 2020-03-31 23:43:56 34.15030532 -87.37325922 2 0 0 0 Winston, Alabama, US
2131 2131 27169 Winona Minnesota US 2020-03-31 23:43:56 43.98772283 -91.78081305 10 0 0 0 Winona, Minnesota, US
2130 2130 19191 Winneshiek Iowa US 2020-03-31 23:43:56 43.29094334 -91.84422722 3 0 0 0 Winneshiek, Iowa, US
2129 2129 55139 Winnebago Wisconsin US 2020-03-31 23:43:56 44.06886922 -88.64477096 11 0 0 0 Winnebago, Wisconsin, US
2128 2128 17201 Winnebago Illinois US 2020-03-31 23:43:56 42.33641854 -89.16085327 15 0 0 0 Winnebago, Illinois, US
2127 2127 22127 Winn Louisiana US 2020-03-31 23:43:56 31.94449367 -92.63789413 1 0 0 0 Winn, Louisiana, US
2126 2126 50027 Windsor Vermont US 2020-03-31 23:43:56 43.58010937 -72.58595157 18 1 0 0 Windsor, Vermont, US
2125 2125 50025 Windham Vermont US 2020-03-31 23:43:56 42.986982 -72.71268875 11 0 0 0 Windham, Vermont, US
2124 2124 9015 Windham Connecticut US 2020-03-31 23:43:56 41.82972709 -71.98182316 11 0 0 0 Windham, Connecticut, US
2123 2123 51840 Winchester Virginia US 2020-03-31 23:43:56 39.17054517 -78.17325058 3 0 0 0 Winchester, Virginia, US
2122 2122 48493 Wilson Texas US 2020-03-31 23:43:56 29.1732598 -98.08693082 3 0 0 0 Wilson, Texas, US
2121 2121 47189 Wilson Tennessee US 2020-03-31 23:43:56 36.15496772 -86.29775884 39 0 0 0 Wilson, Tennessee, US
2120 2120 37195 Wilson North Carolina US 2020-03-31 23:43:56 35.70625477 -77.917978 13 0 0 0 Wilson, North Carolina, US
2119 2119 48491 Williamson Texas US 2020-03-31 23:43:56 30.64655664 -97.60048540000001 42 1 0 0 Williamson, Texas, US
2118 2118 47187 Williamson Tennessee US 2020-03-31 23:43:56 35.89099229 -86.89281867 131 0 0 0 Williamson, Tennessee, US
2117 2117 17199 Williamson Illinois US 2020-03-31 23:43:56 37.73033511 -88.92994027 1 0 0 0 Williamson, Illinois, US
2116 2116 51830 Williamsburg Virginia US 2020-03-31 23:43:56 37.28131268 -76.70905141 8 1 0 0 Williamsburg, Virginia, US
2115 2115 45089 Williamsburg South Carolina US 2020-03-31 23:43:56 33.62190129 -79.72767442 2 0 0 0 Williamsburg, South Carolina, US
2114 2114 38105 Williams North Dakota US 2020-03-31 23:43:56 48.34522353 -103.4793387 2 0 0 0 Williams, North Dakota, US
2113 2113 48489 Willacy Texas US 2020-03-31 23:43:56 26.47411727 -97.61535848 2 0 0 0 Willacy, Texas, US
2112 2112 17197 Will Illinois US 2020-03-31 23:43:56 41.44619267 -87.97862712 228 8 0 0 Will, Illinois, US
2111 2111 28157 Wilkinson Mississippi US 2020-03-31 23:43:56 31.16078225 -91.31018819 14 2 0 0 Wilkinson, Mississippi, US
2110 2110 13319 Wilkinson Georgia US 2020-03-31 23:43:56 32.80291082 -83.17140684 1 0 0 0 Wilkinson, Georgia, US
2109 2109 27167 Wilkin Minnesota US 2020-03-31 23:43:56 46.35721532 -96.4684375 1 0 0 0 Wilkin, Minnesota, US
2108 2108 37193 Wilkes North Carolina US 2020-03-31 23:43:56 36.2084135 -81.16232895 2 0 0 0 Wilkes, North Carolina, US
2107 2107 13317 Wilkes Georgia US 2020-03-31 23:43:56 33.78290391 -82.74286107 2 0 0 0 Wilkes, Georgia, US
2106 2106 13315 Wilcox Georgia US 2020-03-31 23:43:56 31.97496928 -83.43438555 1 0 0 0 Wilcox, Georgia, US
2105 2105 1131 Wilcox Alabama US 2020-03-31 23:43:56 31.98773215 -87.30891118 3 0 0 0 Wilcox, Alabama, US
2104 2104 24045 Wicomico Maryland US 2020-03-31 23:43:56 38.37301947 -75.62705831 7 1 0 0 Wicomico, Maryland, US
2103 2103 48485 Wichita Texas US 2020-03-31 23:43:56 33.98842886 -98.70410340000001 30 0 0 0 Wichita, Texas, US
2102 2102 53075 Whitman Washington US 2020-03-31 23:43:56 46.90022523 -117.52417630000001 8 0 0 0 Whitman, Washington, US
2101 2101 18183 Whitley Indiana US 2020-03-31 23:43:56 41.13863784 -85.50791236 2 0 0 0 Whitley, Indiana, US
2100 2100 13313 Whitfield Georgia US 2020-03-31 23:43:56 34.80987459 -84.96093476 10 1 0 0 Whitfield, Georgia, US
2099 2099 17195 Whiteside Illinois US 2020-03-31 23:43:56 41.75509713 -89.91556058 5 0 0 0 Whiteside, Illinois, US
2097 2097 47185 White Tennessee US 2020-03-31 23:43:56 35.92929884 -85.45591799 1 0 0 0 White, Tennessee, US
2096 2096 18181 White Indiana US 2020-03-31 23:43:56 40.74911165 -86.86492015 2 0 0 0 White, Indiana, US
2095 2095 13311 White Georgia US 2020-03-31 23:43:56 34.64624278 -83.74905525 3 0 0 0 White, Georgia, US
2094 2094 5145 White Arkansas US 2020-03-31 23:43:56 35.25688493 -91.74908296 10 0 0 0 White, Arkansas, US
2098 2098 32033 White Pine Nevada US 2020-03-31 23:43:56 39.44157041 -114.89996599999999 1 0 0 0 White Pine, Nevada, US
2093 2093 13309 Wheeler Georgia US 2020-03-31 23:43:56 32.12009104 -82.72574721 1 0 0 0 Wheeler, Georgia, US
2092 2092 53073 Whatcom Washington US 2020-03-31 23:43:56 48.82227976 -121.74900179999999 139 7 0 0 Whatcom, Washington, US
2091 2091 48481 Wharton Texas US 2020-03-31 23:43:56 29.27765923 -96.22319248 6 0 0 0 Wharton, Texas, US
2090 2090 26165 Wexford Michigan US 2020-03-31 23:43:56 44.33853602 -85.57712739 2 0 0 0 Wexford, Michigan, US
2089 2089 54103 Wetzel West Virginia US 2020-03-31 23:43:56 39.6065771 -80.64016540000001 1 0 0 0 Wetzel, West Virginia, US
2088 2088 42129 Westmoreland Pennsylvania US 2020-03-31 23:43:56 40.31377979999999 -79.46615476 61 0 0 0 Westmoreland, Pennsylvania, US
2256 2256     Western Australia Australia 2020-03-31 23:49:27 -31.9505 115.8605 364 2 41 321 Western Australia, Australia
2087 2087 36119 Westchester New York US 2020-03-31 23:43:56 41.16278376 -73.75741653 9967 10 0 0 Westchester, New York, US
2086 2086 22125 West Feliciana Louisiana US 2020-03-31 23:43:56 30.87882871 -91.41485379999999 4 0 0 0 West Feliciana, Louisiana, US
2085 2085 22121 West Baton Rouge Louisiana US 2020-03-31 23:43:56 30.46058217 -91.30989571 13 1 0 0 West Baton Rouge, Louisiana, US
2435 2435       West Bank and Gaza 2020-03-31 23:43:43 31.9522 35.2332 119 1 18 100 West Bank and Gaza
2084 2084 18179 Wells Indiana US 2020-03-31 23:43:56 40.72934187 -85.22132966 2 0 0 0 Wells, Indiana, US
2083 2083 8123 Weld Colorado US 2020-03-31 23:43:56 40.55499405 -104.39296209999999 255 12 0 0 Weld, Colorado, US
2082 2082 29225 Webster Missouri US 2020-03-31 23:43:56 37.2813734 -92.876329 2 0 0 0 Webster, Missouri, US
2081 2081 28155 Webster Mississippi US 2020-03-31 23:43:56 33.61300486 -89.28392912 5 1 0 0 Webster, Mississippi, US
2080 2080 22119 Webster Louisiana US 2020-03-31 23:43:56 32.70847669 -93.33121835 17 1 0 0 Webster, Louisiana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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