03-29-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,437 rows sorted by Admin2 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
3074 3074 17195 Whiteside Illinois US 3/29/20 23:08 41.75509713 -89.91556058 3 0 0 0 Whiteside, Illinois, US
3073 3073 32033 White Pine Nevada US 3/29/20 23:08 39.44157041 -114.899966 0 0 0 0 White Pine, Nevada, US
3068 3068 5145 White Arkansas US 3/29/20 23:08 35.25688493 -91.74908296 6 0 0 0 White, Arkansas, US
3069 3069 13311 White Georgia US 3/29/20 23:08 34.64624278 -83.74905525 1 0 0 0 White, Georgia, US
3070 3070 17193 White Illinois US 3/29/20 23:08 38.08706198 -88.17657461 0 0 0 0 White, Illinois, US
3071 3071 18181 White Indiana US 3/29/20 23:08 40.74911165 -86.86492015 1 0 0 0 White, Indiana, US
3072 3072 47185 White Tennessee US 3/29/20 23:08 35.92929884 -85.45591799 1 0 0 0 White, Tennessee, US
3064 3064 13309 Wheeler Georgia US 3/29/20 23:08 32.12009104 -82.72574721 1 0 0 0 Wheeler, Georgia, US
3065 3065 31183 Wheeler Nebraska US 3/29/20 23:08 41.91482725 -98.52798941 0 0 0 0 Wheeler, Nebraska, US
3066 3066 41069 Wheeler Oregon US 3/29/20 23:08 44.72698162 -120.0281427 0 0 0 0 Wheeler, Oregon, US
3067 3067 48483 Wheeler Texas US 3/29/20 23:08 35.40114335 -100.2699514 0 0 0 0 Wheeler, Texas, US
3063 3063 30107 Wheatland Montana US 3/29/20 23:08 46.46652491 -109.8464636 0 0 0 0 Wheatland, Montana, US
3062 3062 53073 Whatcom Washington US 3/29/20 23:08 48.82227976 -121.7490018 116 7 0 0 Whatcom, Washington, US
3061 3061 48481 Wharton Texas US 3/29/20 23:08 29.27765923 -96.22319248 3 0 0 0 Wharton, Texas, US
3060 3060 26165 Wexford Michigan US 3/29/20 23:08 44.33853602 -85.57712739 1 0 0 0 Wexford, Michigan, US
3059 3059 54103 Wetzel West Virginia US 3/29/20 23:08 39.6065771 -80.6401654 0 0 0 0 Wetzel, West Virginia, US
3058 3058 56045 Weston Wyoming US 3/29/20 23:08 43.83961191 -104.5674881 0 0 0 0 Weston, Wyoming, US
3056 3056 42129 Westmoreland Pennsylvania US 3/29/20 23:08 40.3137798 -79.46615476 47 0 0 0 Westmoreland, Pennsylvania, US
3057 3057 51193 Westmoreland Virginia US 3/29/20 23:08 38.11021557 -76.80213247 0 0 0 0 Westmoreland, Virginia, US
3055 3055 36119 Westchester New York US 3/29/20 23:08 41.16278376 -73.75741653 8519 10 0 0 Westchester, New York, US
3054 3054 22125 West Feliciana Louisiana US 3/29/20 23:08 30.87882871 -91.4148538 4 0 0 0 West Feliciana, Louisiana, US
3053 3053 22123 West Carroll Louisiana US 3/29/20 23:08 32.78550125 -91.461201 0 0 0 0 West Carroll, Louisiana, US
3052 3052 22121 West Baton Rouge Louisiana US 3/29/20 23:08 30.46058217 -91.30989571 12 1 0 0 West Baton Rouge, Louisiana, US
3050 3050 18179 Wells Indiana US 3/29/20 23:08 40.72934187 -85.22132966 1 0 0 0 Wells, Indiana, US
3051 3051 38103 Wells North Dakota US 3/29/20 23:08 47.58614526 -99.65904998 0 0 0 0 Wells, North Dakota, US
3049 3049 8123 Weld Colorado US 3/29/20 23:08 40.55499405 -104.3929621 180 9 0 0 Weld, Colorado, US
3041 3041 13307 Webster Georgia US 3/29/20 23:08 32.04066113 -84.54742852 0 0 0 0 Webster, Georgia, US
3042 3042 19187 Webster Iowa US 3/29/20 23:08 42.42853483 -94.17987389 1 0 0 0 Webster, Iowa, US
3043 3043 21233 Webster Kentucky US 3/29/20 23:08 37.52168356 -87.67989953 2 0 0 0 Webster, Kentucky, US
3044 3044 22119 Webster Louisiana US 3/29/20 23:08 32.70847669 -93.33121835 9 1 0 0 Webster, Louisiana, US
3045 3045 28155 Webster Mississippi US 3/29/20 23:08 33.61300486 -89.28392912 3 1 0 0 Webster, Mississippi, US
3046 3046 29225 Webster Missouri US 3/29/20 23:08 37.2813734 -92.876329 0 0 0 0 Webster, Missouri, US
3047 3047 31181 Webster Nebraska US 3/29/20 23:08 40.17642643 -98.50019851 0 0 0 0 Webster, Nebraska, US
3048 3048 54101 Webster West Virginia US 3/29/20 23:08 38.49370949 -80.4202023 0 0 0 0 Webster, West Virginia, US
3040 3040 49057 Weber Utah US 3/29/20 23:08 41.27116049 -111.9145117 37 0 0 0 Weber,Utah,US
3039 3039 48479 Webb Texas US 3/29/20 23:08 27.7610369 -99.33237355 30 1 0 0 Webb, Texas, US
3038 3038 47183 Weakley Tennessee US 3/29/20 23:08 36.29896232 -88.71990865 1 0 0 0 Weakley, Tennessee, US
3037 3037 51820 Waynesboro Virginia US 3/29/20 23:08 38.06451466 -78.90293905 0 0 0 0 Waynesboro, Virginia, US
3021 3021 13305 Wayne Georgia US 3/29/20 23:08 31.5521809 -81.91894878 0 0 0 0 Wayne, Georgia, US
3022 3022 17191 Wayne Illinois US 3/29/20 23:08 38.42955355 -88.42586459 0 0 0 0 Wayne, Illinois, US
3023 3023 18177 Wayne Indiana US 3/29/20 23:08 39.8633444 -85.01044989 1 0 0 0 Wayne, Indiana, US
3024 3024 19185 Wayne Iowa US 3/29/20 23:08 40.73969028 -93.32752197 0 0 0 0 Wayne, Iowa, US
3025 3025 21231 Wayne Kentucky US 3/29/20 23:08 36.80310688 -84.8251971 1 0 0 0 Wayne, Kentucky, US
3026 3026 26163 Wayne Michigan US 3/29/20 23:08 42.278056 -83.378611 2704 56 0 0 Wayne,Michigan,US
3027 3027 28153 Wayne Mississippi US 3/29/20 23:08 31.64135687 -88.69573913 0 0 0 0 Wayne, Mississippi, US
3028 3028 29223 Wayne Missouri US 3/29/20 23:08 37.11303869 -90.46001416 0 0 0 0 Wayne, Missouri, US
3029 3029 31179 Wayne Nebraska US 3/29/20 23:08 42.20934475 -97.11926964 0 0 0 0 Wayne, Nebraska, US
3030 3030 36117 Wayne New York US 3/29/20 23:08 43.15494365 -77.02976528 12 0 0 0 Wayne, New York, US
3031 3031 37191 Wayne North Carolina US 3/29/20 23:08 35.36438125 -78.00027268 3 0 0 0 Wayne, North Carolina, US
3032 3032 39169 Wayne Ohio US 3/29/20 23:08 40.82925852 -81.88844833 4 0 0 0 Wayne, Ohio, US
3033 3033 42127 Wayne Pennsylvania US 3/29/20 23:08 41.64938475 -75.29956506 7 0 0 0 Wayne, Pennsylvania, US
3034 3034 47181 Wayne Tennessee US 3/29/20 23:08 35.23868267 -87.78644456 0 0 0 0 Wayne, Tennessee, US
3035 3035 49055 Wayne Utah US 3/29/20 23:08 38.32335822 -110.9096801 0 0 0 0 Wayne, Utah, US
3036 3036 54099 Wayne West Virginia US 3/29/20 23:08 38.14901357 -82.42287994 0 0 0 0 Wayne, West Virginia, US
3020 3020 55137 Waushara Wisconsin US 3/29/20 23:08 44.11324419 -89.24317107 0 0 0 0 Waushara, Wisconsin, US
3019 3019 55135 Waupaca Wisconsin US 3/29/20 23:08 44.47068056 -88.96534501 1 1 0 0 Waupaca, Wisconsin, US
3018 3018 55133 Waukesha Wisconsin US 3/29/20 23:08 43.01833055 -88.30431188 83 0 0 0 Waukesha, Wisconsin, US
3017 3017 27165 Watonwan Minnesota US 3/29/20 23:08 43.97823903 -94.61413846 0 0 0 0 Watonwan, Minnesota, US
3016 3016 37189 Watauga North Carolina US 3/29/20 23:08 36.23103603 -81.70033724 5 0 0 0 Watauga, North Carolina, US
3015 3015 26161 Washtenaw Michigan US 3/29/20 23:08 42.253105 -83.83853204 233 5 0 0 Washtenaw, Michigan, US
3014 3014 32031 Washoe Nevada US 3/29/20 23:08 40.66562265 -119.6631594 107 1 0 0 Washoe, Nevada, US
3013 3013 40149 Washita Oklahoma US 3/29/20 23:08 35.29071824 -98.99180434 0 0 0 0 Washita, Oklahoma, US
2982 2982 1129 Washington Alabama US 3/29/20 23:08 31.4092794 -88.20689944 3 0 0 0 Washington, Alabama, US
2983 2983 5143 Washington Arkansas US 3/29/20 23:08 35.976844 -94.21800746 14 0 0 0 Washington, Arkansas, US
2984 2984 8121 Washington Colorado US 3/29/20 23:08 39.97015535 -103.202587 1 0 0 0 Washington, Colorado, US
2985 2985 12133 Washington Florida US 3/29/20 23:08 30.61359259 -85.66002461 1 0 0 0 Washington, Florida, US
2986 2986 13303 Washington Georgia US 3/29/20 23:08 32.96711864 -82.79357039 2 0 0 0 Washington, Georgia, US
2987 2987 16087 Washington Idaho US 3/29/20 23:08 44.45275475 -116.7847688 0 0 0 0 Washington, Idaho, US
2988 2988 17189 Washington Illinois US 3/29/20 23:08 38.35309213 -89.40982703 1 0 0 0 Washington, Illinois, US
2989 2989 18175 Washington Indiana US 3/29/20 23:08 38.60219804 -86.1049363 5 0 0 0 Washington, Indiana, US
2990 2990 19183 Washington Iowa US 3/29/20 23:08 41.33577126 -91.71725711 13 0 0 0 Washington, Iowa, US
2991 2991 20201 Washington Kansas US 3/29/20 23:08 39.78420784 -97.0875323 0 0 0 0 Washington, Kansas, US
2992 2992 21229 Washington Kentucky US 3/29/20 23:08 37.75599461 -85.17407732 1 0 0 0 Washington, Kentucky, US
2993 2993 22117 Washington Louisiana US 3/29/20 23:08 30.85288548 -90.03866652 12 1 0 0 Washington, Louisiana, US
2994 2994 23029 Washington Maine US 3/29/20 23:08 45.01607142 -67.62813524 0 0 0 0 Washington, Maine, US
2995 2995 24043 Washington Maryland US 3/29/20 23:08 39.60835778 -77.82002295 6 0 0 0 Washington, Maryland, US
2996 2996 27163 Washington Minnesota US 3/29/20 23:08 45.03864533 -92.88429635 27 0 0 0 Washington, Minnesota, US
2997 2997 28151 Washington Mississippi US 3/29/20 23:08 33.28392041 -90.94196237 16 0 0 0 Washington, Mississippi, US
2998 2998 29221 Washington Missouri US 3/29/20 23:08 37.96130078 -90.87948158 0 0 0 0 Washington, Missouri, US
2999 2999 31177 Washington Nebraska US 3/29/20 23:08 41.52815707 -96.22019892 5 0 0 0 Washington, Nebraska, US
3000 3000 36115 Washington New York US 3/29/20 23:08 43.31153794 -73.43043448 9 0 0 0 Washington, New York, US
3001 3001 37187 Washington North Carolina US 3/29/20 23:08 35.83810081 -76.57299037 1 0 0 0 Washington, North Carolina, US
3002 3002 39167 Washington Ohio US 3/29/20 23:08 39.45690571 -81.49121382 3 0 0 0 Washington, Ohio, US
3003 3003 40147 Washington Oklahoma US 3/29/20 23:08 36.71380786 -95.90514104 18 0 0 0 Washington, Oklahoma, US
3004 3004 41067 Washington Oregon US 3/29/20 23:08 45.55972701 -123.0955257 154 3 0 0 Washington, Oregon, US
3005 3005 42125 Washington Pennsylvania US 3/29/20 23:08 40.19208869 -80.24582867 24 0 0 0 Washington, Pennsylvania, US
3006 3006 44009 Washington Rhode Island US 3/29/20 23:08 41.45961631 -71.61435303 23 0 0 0 Washington, Rhode Island, US
3007 3007 47179 Washington Tennessee US 3/29/20 23:08 36.29472368 -82.4945472 14 0 0 0 Washington, Tennessee, US
3008 3008 48477 Washington Texas US 3/29/20 23:08 30.21498498 -96.40946246 6 0 0 0 Washington, Texas, US
3009 3009 49053 Washington Utah US 3/29/20 23:08 37.28003525 -113.504698 8 1 0 0 Washington, Utah, US
3010 3010 50023 Washington Vermont US 3/29/20 23:08 44.27343241 -72.61604978 12 0 0 0 Washington, Vermont, US
3011 3011 51191 Washington Virginia US 3/29/20 23:08 36.72341572 -81.95666289 2 0 0 0 Washington, Virginia, US
3012 3012 55131 Washington Wisconsin US 3/29/20 23:08 43.36863664 -88.22974712 31 0 0 0 Washington, Wisconsin, US
2981 2981 55129 Washburn Wisconsin US 3/29/20 23:08 45.89838588 -91.79050449 0 0 0 0 Washburn, Wisconsin, US
2980 2980 56043 Washakie Wyoming US 3/29/20 23:08 43.90451606 -107.680187 1 0 0 0 Washakie, Wyoming, US
2979 2979 27161 Waseca Minnesota US 3/29/20 23:08 44.02211116 -93.58720034 3 0 0 0 Waseca, Minnesota, US
2978 2978 41065 Wasco Oregon US 3/29/20 23:08 45.16292781 -121.1670954 3 0 0 0 Wasco, Oregon, US
2977 2977 49051 Wasatch Utah US 3/29/20 23:08 40.33110236 -111.1691419 39 0 0 0 Wasatch, Utah, US
2976 2976 18173 Warrick Indiana US 3/29/20 23:08 38.08922676 -87.2716085 8 0 0 0 Warrick, Indiana, US
2962 2962 13301 Warren Georgia US 3/29/20 23:08 33.41146451 -82.67795848 0 0 0 0 Warren, Georgia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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