05-08-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,232 rows sorted by Confirmed

✎ 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
595 595 46031 Corson South Dakota US 2020-05-09 02:32:35 45.70889983 -101.1970473 1 0 0 1 Corson, South Dakota, US
631 631 41013 Crook Oregon US 2020-05-09 02:32:35 44.14230227 -120.356297 1 0 0 1 Crook, Oregon, US
662 662 5039 Dallas Arkansas US 2020-05-09 02:32:35 33.97042763 -92.65167437 1 0 0 1 Dallas, Arkansas, US
715 715 48119 Delta Texas US 2020-05-09 02:32:35 33.38570922 -95.66921122 1 0 0 1 Delta, Texas, US
721 721 46039 Deuel South Dakota US 2020-05-09 02:32:35 44.75994309 -96.66943645 1 0 0 1 Deuel, South Dakota, US
723 723 46041 Dewey South Dakota US 2020-05-09 02:32:35 45.15639647 -100.8709139 1 0 0 1 Dewey, South Dakota, US
724 724 48125 Dickens Texas US 2020-05-09 02:32:35 33.61616822 -100.7788855 1 0 0 1 Dickens, Texas, US
731 731 48127 Dimmit Texas US 2020-05-09 02:32:35 28.42270064 -99.75645095 1 0 0 1 Dimmit, Texas, US
734 734 38023 Divide North Dakota US 2020-05-09 02:32:35 48.814938700000006 -103.4873611 1 0 0 1 Divide, North Dakota, US
757 757 46043 Douglas South Dakota US 2020-05-09 02:32:35 43.38520741 -98.36978007 1 0 0 1 Douglas, South Dakota, US
785 785 38027 Eddy North Dakota US 2020-05-09 02:32:35 47.71701474 -98.90432337 1 0 0 1 Eddy, North Dakota, US
809 809 38029 Emmons North Dakota US 2020-05-09 02:32:35 46.28398398 -100.2389766 1 1 0 0 Emmons, North Dakota, US
838 838 46049 Faulk South Dakota US 2020-05-09 02:32:35 45.07082625 -99.14535601 1 0 0 1 Faulk, South Dakota, US
855 855 53019 Ferry Washington US 2020-05-09 02:32:35 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
875 875 55041 Forest Wisconsin US 2020-05-09 02:32:35 45.66678019 -88.77084892 1 0 0 1 Forest, Wisconsin, US
880 880 38031 Foster North Dakota US 2020-05-09 02:32:35 47.4571084 -98.88279923 1 0 0 1 Foster, North Dakota, US
914 914 19071 Fremont Iowa US 2020-05-09 02:32:35 40.74542720000001 -95.60129045 1 0 0 1 Fremont, Iowa, US
918 918 31063 Frontier Nebraska US 2020-05-09 02:32:35 40.52993007 -100.3924658 1 0 0 1 Frontier, Nebraska, US
923 923 21075 Fulton Kentucky US 2020-05-09 02:32:35 36.55238827 -89.20140068 1 0 0 1 Fulton, Kentucky, US
933 933 21077 Gallatin Kentucky US 2020-05-09 02:32:35 38.75398691 -84.8558382 1 0 0 1 Gallatin, Kentucky, US
954 954 29075 Gentry Missouri US 2020-05-09 02:32:35 40.21097916 -94.40944419 1 0 0 1 Gentry, Missouri, US
966 966 8047 Gilpin Colorado US 2020-05-09 02:32:35 39.85646523 -105.5252597 1 0 0 1 Gilpin, Colorado, US
970 970 13125 Glascock Georgia US 2020-05-09 02:32:35 33.22879932 -82.61297636 1 1 0 0 Glascock, Georgia, US
971 971 48173 Glasscock Texas US 2020-05-09 02:32:35 31.86942909 -101.5207776 1 0 0 1 Glasscock, Texas, US
986 986 20063 Gove Kansas US 2020-05-09 02:32:35 38.91588178 -100.4829321 1 0 0 1 Gove, Kansas, US
1004 1004 38037 Grant North Dakota US 2020-05-09 02:32:35 46.35821257 -101.6390013 1 0 0 1 Grant, North Dakota, US
1006 1006 41023 Grant Oregon US 2020-05-09 02:32:35 44.49024544 -119.0068631 1 0 0 1 Grant, Oregon, US
1021 1021 21087 Green Kentucky US 2020-05-09 02:32:35 37.26484328 -85.5540745 1 0 0 1 Green, Kentucky, US
1056 1056 12045 Gulf Florida US 2020-05-09 02:32:35 29.93543004 -85.24270990000002 1 0 0 1 Gulf, Florida, US
1094 1094 46059 Hand South Dakota US 2020-05-09 02:32:35 44.54708407 -99.00386459 1 0 0 1 Hand, South Dakota, US
1100 1100 17069 Hardin Illinois US 2020-05-09 02:32:35 37.51810645 -88.26873022 1 0 0 1 Hardin, Illinois, US
1106 1106 35021 Harding New Mexico US 2020-05-09 02:32:35 35.85751555 -103.8220938 1 0 0 1 Harding, New Mexico, US
1109 1109 21095 Harlan Kentucky US 2020-05-09 02:32:35 36.85699301 -83.21899516 1 0 0 1 Harlan, Kentucky, US
1111 1111 41025 Harney Oregon US 2020-05-09 02:32:35 43.06422669 -118.9666306 1 0 0 1 Harney, Oregon, US
1112 1112 20077 Harper Kansas US 2020-05-09 02:32:35 37.19175361 -98.07578384 1 0 0 1 Harper, Kansas, US
1113 1113 40059 Harper Oklahoma US 2020-05-09 02:32:35 36.78836519 -99.6679804 1 0 0 1 Harper, Oklahoma, US
1138 1138 48211 Hemphill Texas US 2020-05-09 02:32:35 35.83764858 -100.2703577 1 0 0 1 Hemphill, Texas, US
1169 1169 30041 Hill Montana US 2020-05-09 02:32:35 48.62879827 -110.1129252 1 0 0 1 Hill, Montana, US
1176 1176 31087 Hitchcock Nebraska US 2020-05-09 02:32:35 40.17609175 -101.0416477 1 0 0 1 Hitchcock, Nebraska, US
1183 1183 29087 Holt Missouri US 2020-05-09 02:32:35 40.09799248 -95.2163888 1 0 0 1 Holt, Missouri, US
1184 1184 31089 Holt Nebraska US 2020-05-09 02:32:35 42.45522056 -98.78402558 1 0 0 1 Holt, Nebraska, US
1225 1225 37095 Hyde North Carolina US 2020-05-09 02:32:35 35.42017674 -76.15180542 1 0 0 1 Hyde, North Carolina, US
1226 1226 46069 Hyde South Dakota US 2020-05-09 02:32:35 44.54747703 -99.48572582 1 0 0 1 Hyde, South Dakota, US
1254 1254 5067 Jackson Arkansas US 2020-05-09 02:32:35 35.59802983 -91.21494602 1 0 0 1 Jackson, Arkansas, US
1380 1380 48267 Kimble Texas US 2020-05-09 02:32:35 30.48678918 -99.74856473 1 0 0 1 Kimble, Texas, US
1393 1393 27069 Kittson Minnesota US 2020-05-09 02:32:35 48.77754106 -96.78317184 1 0 0 1 Kittson, Minnesota, US
1405 1405 48275 Knox Texas US 2020-05-09 02:32:35 33.60519951 -99.7422906 1 0 0 1 Knox, Texas, US
1406 1406 2150 Kodiak Island Alaska US 2020-05-09 02:32:35 57.65529415 -153.7493579 1 0 0 1 Kodiak Island, Alaska, US
1407 1407 27071 Koochiching Minnesota US 2020-05-09 02:32:35 48.24539665 -93.78352843 1 0 0 1 Koochiching, Minnesota, US
1414 1414 48283 La Salle Texas US 2020-05-09 02:32:35 28.34453111 -99.09908775 1 0 0 1 La Salle, Texas, US
1435 1435 27075 Lake Minnesota US 2020-05-09 02:32:35 47.64270764 -91.44557998 1 0 0 1 Lake, Minnesota, US
1472 1472 21127 Lawrence Kentucky US 2020-05-09 02:32:35 38.07136018 -82.72882223 1 0 0 1 Lawrence, Kentucky, US
1499 1499 16059 Lemhi Idaho US 2020-05-09 02:32:35 44.9438088 -113.9309747 1 0 0 1 Lemhi, Idaho, US
1519 1519 30051 Liberty Montana US 2020-05-09 02:32:35 48.56084317 -111.024307 1 0 0 1 Liberty, Montana, US
1536 1536 32017 Lincoln Nevada US 2020-05-09 02:32:35 37.64268459 -114.8790388 1 0 0 1 Lincoln, Nevada, US
1545 1545 55069 Lincoln Wisconsin US 2020-05-09 02:32:35 45.33737523 -89.73411273 1 0 0 1 Lincoln, Wisconsin, US
1584 1584 26095 Luce Michigan US 2020-05-09 02:32:35 46.47227431 -85.54471223 1 0 0 1 Luce, Michigan, US
1609 1609 5087 Madison Arkansas US 2020-05-09 02:32:35 36.01038185 -93.72524943 1 0 0 1 Madison, Arkansas, US
1623 1623 37115 Madison North Carolina US 2020-05-09 02:32:35 35.85402722 -82.71346418 1 0 0 1 Madison, North Carolina, US
1645 1645 5089 Marion Arkansas US 2020-05-09 02:32:35 36.26844485 -92.68451899 1 0 0 1 Marion, Arkansas, US
1673 1673 46091 Marshall South Dakota US 2020-05-09 02:32:35 45.75870838 -97.59855639 1 0 0 1 Marshall, South Dakota, US
1710 1710 38049 McHenry North Dakota US 2020-05-09 02:32:35 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
1712 1712 38051 McIntosh North Dakota US 2020-05-09 02:32:35 46.11182017 -99.44145858 1 0 0 1 McIntosh, North Dakota, US
1726 1726 46089 McPherson South Dakota US 2020-05-09 02:32:35 45.76626028 -99.22118798 1 0 0 1 McPherson, South Dakota, US
1730 1730 30059 Meagher Montana US 2020-05-09 02:32:35 46.59907074 -110.8898557 1 0 0 1 Meagher, Montana, US
1776 1776 46097 Miner South Dakota US 2020-05-09 02:32:35 44.02197882 -97.60992207 1 0 0 1 Miner, South Dakota, US
1791 1791 48335 Mitchell Texas US 2020-05-09 02:32:35 32.30623474 -100.9212058 1 0 0 1 Mitchell, Texas, US
1821 1821 5097 Montgomery Arkansas US 2020-05-09 02:32:35 34.53704874 -93.65824478 1 0 0 1 Montgomery, Arkansas, US
1851 1851 21175 Morgan Kentucky US 2020-05-09 02:32:35 37.92465657 -83.25558245 1 0 0 1 Morgan, Kentucky, US
1865 1865 48345 Motley Texas US 2020-05-09 02:32:35 34.07408766 -100.779722 1 0 0 1 Motley, Texas, US
1879 1879 30065 Musselshell Montana US 2020-05-09 02:32:35 46.49684637 -108.39498 1 0 0 1 Musselshell, Montana, US
1891 1891 38063 Nelson North Dakota US 2020-05-09 02:32:35 47.9226426 -98.19038437 1 0 0 1 Nelson, North Dakota, US
1893 1893 20131 Nemaha Kansas US 2020-05-09 02:32:35 39.78345387 -96.01392079 1 0 0 1 Nemaha, Kansas, US
1894 1894 31127 Nemaha Nebraska US 2020-05-09 02:32:35 40.38514847 -95.85433992 1 0 0 1 Nemaha, Nebraska, US
1918 1918 21181 Nicholas Kentucky US 2020-05-09 02:32:35 38.33342292 -84.01889177 1 0 0 1 Nicholas, Kentucky, US
1928 1928 2180 Nome Alaska US 2020-05-09 02:32:35 64.90320724 -164.0353804 1 0 0 1 Nome, Alaska, US
1954 1954 46102 Oglala Lakota South Dakota US 2020-05-09 02:32:35 43.33749164 -102.5555498 1 0 0 1 Oglala Lakota, South Dakota, US
1963 1963 40107 Okfuskee Oklahoma US 2020-05-09 02:32:35 35.46485198 -96.32639984 1 0 0 1 Okfuskee, Oklahoma, US
1969 1969 38065 Oliver North Dakota US 2020-05-09 02:32:35 47.11530482 -101.3406158 1 0 0 1 Oliver, North Dakota, US
2022 2022 21187 Owen Kentucky US 2020-05-09 02:32:35 38.51679143 -84.82404619 1 0 0 1 Owen, Kentucky, US
2031 2031 19147 Palo Alto Iowa US 2020-05-09 02:32:35 43.08193849 -94.67824621 1 0 0 1 Palo Alto, Iowa, US
2038 2038 56029 Park Wyoming US 2020-05-09 02:32:35 44.52157546 -109.5852825 1 0 0 1 Park, Wyoming, US
2060 2060 27113 Pennington Minnesota US 2020-05-09 02:32:35 48.06642577 -96.0370814 1 0 0 1 Pennington, Minnesota, US
2086 2086 20147 Phillips Kansas US 2020-05-09 02:32:35 39.78465501 -99.34668865 1 0 0 1 Phillips, Kansas, US
2093 2093 31139 Pierce Nebraska US 2020-05-09 02:32:35 42.26434853 -97.60122773 1 0 0 1 Pierce, Nebraska, US
2100 2100 17149 Pike Illinois US 2020-05-09 02:32:35 39.62265059 -90.8877017 1 0 0 1 Pike, Illinois, US
2112 2112 23021 Piscataquis Maine US 2020-05-09 02:32:35 45.83839062 -69.2860223 1 0 0 1 Piscataquis, Maine, US
2135 2135 29167 Polk Missouri US 2020-05-09 02:32:35 37.6162296 -93.39828174 1 0 0 1 Polk, Missouri, US
2146 2146 17151 Pope Illinois US 2020-05-09 02:32:35 37.41391284 -88.56152109 1 0 0 1 Pope, Illinois, US
2159 2159 21197 Powell Kentucky US 2020-05-09 02:32:35 37.83218794 -83.82553961 1 0 0 1 Powell, Kentucky, US
2164 2164 20151 Pratt Kansas US 2020-05-09 02:32:35 37.64780729 -98.73922153 1 0 0 1 Pratt, Kansas, US
2169 2169 55099 Price Wisconsin US 2020-05-09 02:32:35 45.68051754 -90.3609888 1 0 0 1 Price, Wisconsin, US
2185 2185 40127 Pushmataha Oklahoma US 2020-05-09 02:32:35 34.41635232 -95.37603505 1 0 0 1 Pushmataha, Oklahoma, US
2202 2202 29173 Ralls Missouri US 2020-05-09 02:32:35 39.52817427 -91.51838643 1 0 0 1 Ralls, Missouri, US
2220 2220 27125 Red Lake Minnesota US 2020-05-09 02:32:35 47.87197525 -96.09561104 1 0 0 1 Red Lake, Minnesota, US
2226 2226 48391 Refugio Texas US 2020-05-09 02:32:35 28.3238976 -97.15766311 1 0 0 1 Refugio, Texas, US
2230 2230 38075 Renville North Dakota US 2020-05-09 02:32:35 48.71982533 -101.6603912 1 0 0 1 Renville, North Dakota, US
2249 2249 8103 Rio Blanco Colorado US 2020-05-09 02:32:35 39.97913541 -108.2179009 1 0 0 1 Rio Blanco, Colorado, US
2253 2253 54085 Ritchie West Virginia US 2020-05-09 02:32:35 39.18094587 -81.06356878 1 0 0 1 Ritchie, West Virginia, US
2281 2281 27135 Roseau Minnesota US 2020-05-09 02:32:35 48.77501878 -95.81079919 1 0 0 1 Roseau, Minnesota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [05-08-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
);