04-28-2020
Data source: Big Local News · About: README
3,165 rows sorted by Admin2 descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2893 | 2893 | 48507 | Zavala | Texas | US | 2020-04-29 02:32:29 | 28.86617238 | -99.76050829 | 1 | 0 | 0 | 1 | Zavala, Texas, US |
2892 | 2892 | 48505 | Zapata | Texas | US | 2020-04-29 02:32:29 | 27.00156391 | -99.16987152 | 7 | 0 | 0 | 7 | Zapata, Texas, US |
2890 | 2890 | 4027 | Yuma | Arizona | US | 2020-04-29 02:32:29 | 32.76895712 | -113.90666740000002 | 67 | 1 | 0 | 66 | Yuma, Arizona, US |
2891 | 2891 | 8125 | Yuma | Colorado | US | 2020-04-29 02:32:29 | 40.00346839 | -102.4258673 | 7 | 0 | 0 | 7 | Yuma, Colorado, US |
2889 | 2889 | 2290 | Yukon-Koyukuk | Alaska | US | 2020-04-29 02:32:29 | 65.50815459 | -151.3907387 | 1 | 0 | 0 | 1 | Yukon-Koyukuk, Alaska, US |
2888 | 2888 | 6115 | Yuba | California | US | 2020-04-29 02:32:29 | 39.26255932 | -121.3535644 | 16 | 1 | 0 | 15 | Yuba, California, US |
2887 | 2887 | 48503 | Young | Texas | US | 2020-04-29 02:32:29 | 33.17659707 | -98.68790885 | 4 | 1 | 0 | 3 | Young, Texas, US |
2882 | 2882 | 23031 | York | Maine | US | 2020-04-29 02:32:29 | 43.47808377 | -70.71052375 | 200 | 7 | 0 | 193 | York, Maine, US |
2883 | 2883 | 31185 | York | Nebraska | US | 2020-04-29 02:32:29 | 40.87272618 | -97.59710186 | 11 | 0 | 0 | 11 | York, Nebraska, US |
2884 | 2884 | 42133 | York | Pennsylvania | US | 2020-04-29 02:32:29 | 39.9210089 | -76.73040131 | 614 | 9 | 0 | 605 | York, Pennsylvania, US |
2885 | 2885 | 45091 | York | South Carolina | US | 2020-04-29 02:32:29 | 34.97281497 | -81.18085944 | 188 | 3 | 0 | 185 | York, South Carolina, US |
2886 | 2886 | 51199 | York | Virginia | US | 2020-04-29 02:32:29 | 37.24374789 | -76.54412815 | 45 | 1 | 0 | 44 | York, Virginia, US |
2881 | 2881 | 6113 | Yolo | California | US | 2020-04-29 02:32:29 | 38.68278902 | -121.9018288 | 162 | 16 | 0 | 146 | Yolo, California, US |
2880 | 2880 | 48501 | Yoakum | Texas | US | 2020-04-29 02:32:29 | 33.17320212 | -102.8276433 | 1 | 0 | 0 | 1 | Yoakum, Texas, US |
2879 | 2879 | 30111 | Yellowstone | Montana | US | 2020-04-29 02:32:29 | 45.93955949 | -108.2691486 | 80 | 1 | 0 | 79 | Yellowstone, Montana, US |
2878 | 2878 | 27173 | Yellow Medicine | Minnesota | US | 2020-04-29 02:32:29 | 44.71710183 | -95.86842453 | 3 | 0 | 0 | 3 | Yellow Medicine, Minnesota, US |
2877 | 2877 | 5149 | Yell | Arkansas | US | 2020-04-29 02:32:29 | 35.00292371 | -93.41171338 | 3 | 0 | 0 | 3 | Yell, Arkansas, US |
2876 | 2876 | 28163 | Yazoo | Mississippi | US | 2020-04-29 02:32:29 | 32.77890365 | -90.39656148 | 129 | 1 | 0 | 128 | Yazoo, Mississippi, US |
2875 | 2875 | 4025 | Yavapai | Arizona | US | 2020-04-29 02:32:29 | 34.59933926 | -112.5538588 | 77 | 1 | 0 | 76 | Yavapai, Arizona, US |
2874 | 2874 | 36123 | Yates | New York | US | 2020-04-29 02:32:29 | 42.63505484 | -77.10369919 | 17 | 1 | 0 | 16 | Yates, New York, US |
2873 | 2873 | 46135 | Yankton | South Dakota | US | 2020-04-29 02:32:29 | 43.00924485 | -97.39467635 | 27 | 0 | 0 | 27 | Yankton, South Dakota, US |
2872 | 2872 | 41071 | Yamhill | Oregon | US | 2020-04-29 02:32:29 | 45.23330449 | -123.3086963 | 38 | 7 | 0 | 31 | Yamhill, Oregon, US |
2871 | 2871 | 28161 | Yalobusha | Mississippi | US | 2020-04-29 02:32:29 | 34.02824175 | -89.70762049999998 | 19 | 0 | 0 | 19 | Yalobusha, Mississippi, US |
2870 | 2870 | 53077 | Yakima | Washington | US | 2020-04-29 02:32:29 | 46.45738486 | -120.7380126 | 1046 | 47 | 0 | 1001 | Yakima, Washington, US |
2869 | 2869 | 37197 | Yadkin | North Carolina | US | 2020-04-29 02:32:29 | 36.16222629 | -80.66239436 | 15 | 1 | 0 | 14 | Yadkin, North Carolina, US |
2868 | 2868 | 51197 | Wythe | Virginia | US | 2020-04-29 02:32:29 | 36.91582035 | -81.07834059 | 11 | 1 | 0 | 10 | Wythe, Virginia, US |
2865 | 2865 | 36121 | Wyoming | New York | US | 2020-04-29 02:32:29 | 42.70145109 | -78.22199579 | 63 | 5 | 0 | 58 | Wyoming, New York, US |
2866 | 2866 | 42131 | Wyoming | Pennsylvania | US | 2020-04-29 02:32:29 | 41.51955538 | -76.01074915 | 18 | 2 | 0 | 16 | Wyoming, Pennsylvania, US |
2867 | 2867 | 54109 | Wyoming | West Virginia | US | 2020-04-29 02:32:29 | 37.612327 | -81.54511071 | 1 | 0 | 0 | 1 | Wyoming, West Virginia, US |
2864 | 2864 | 20209 | Wyandotte | Kansas | US | 2020-04-29 02:32:29 | 39.11727348 | -94.76378225 | 585 | 53 | 0 | 532 | Wyandotte, Kansas, US |
2863 | 2863 | 39175 | Wyandot | Ohio | US | 2020-04-29 02:32:29 | 40.84339621 | -83.30734173 | 24 | 2 | 0 | 22 | Wyandot, Ohio, US |
2860 | 2860 | 19197 | Wright | Iowa | US | 2020-04-29 02:32:29 | 42.73305373 | -93.73515113 | 2 | 0 | 0 | 2 | Wright, Iowa, US |
2861 | 2861 | 27171 | Wright | Minnesota | US | 2020-04-29 02:32:29 | 45.17297924 | -93.96234781 | 35 | 1 | 0 | 34 | Wright, Minnesota, US |
2862 | 2862 | 29229 | Wright | Missouri | US | 2020-04-29 02:32:29 | 37.27029221 | -92.46914488 | 9 | 0 | 0 | 9 | Wright, Missouri, US |
2857 | 2857 | 13321 | Worth | Georgia | US | 2020-04-29 02:32:29 | 31.55162306 | -83.85090513 | 144 | 8 | 0 | 136 | Worth, Georgia, US |
2858 | 2858 | 19195 | Worth | Iowa | US | 2020-04-29 02:32:29 | 43.37750768 | -93.26087602 | 1 | 0 | 0 | 1 | Worth, Iowa, US |
2859 | 2859 | 29227 | Worth | Missouri | US | 2020-04-29 02:32:29 | 40.47945588 | -94.42328751 | 1 | 0 | 0 | 1 | Worth, Missouri, US |
2855 | 2855 | 24047 | Worcester | Maryland | US | 2020-04-29 02:32:29 | 38.21274277 | -75.33200012 | 54 | 1 | 0 | 53 | Worcester, Maryland, US |
2856 | 2856 | 25027 | Worcester | Massachusetts | US | 2020-04-29 02:32:29 | 42.35026951 | -71.90493363 | 4999 | 229 | 0 | 4770 | Worcester, Massachusetts, US |
2854 | 2854 | 40153 | Woodward | Oklahoma | US | 2020-04-29 02:32:29 | 36.42316318 | -99.26283045 | 1 | 0 | 0 | 1 | Woodward, Oklahoma, US |
2853 | 2853 | 20207 | Woodson | Kansas | US | 2020-04-29 02:32:29 | 37.8865336 | -95.74006277 | 5 | 0 | 0 | 5 | Woodson, Kansas, US |
2852 | 2852 | 40151 | Woods | Oklahoma | US | 2020-04-29 02:32:29 | 36.76705782 | -98.86573064 | 3 | 0 | 0 | 3 | Woods, Oklahoma, US |
2851 | 2851 | 5147 | Woodruff | Arkansas | US | 2020-04-29 02:32:29 | 35.18902527 | -91.2439489 | 1 | 0 | 0 | 1 | Woodruff, Arkansas, US |
2849 | 2849 | 17203 | Woodford | Illinois | US | 2020-04-29 02:32:29 | 40.78579374 | -89.20973757 | 12 | 1 | 0 | 11 | Woodford, Illinois, US |
2850 | 2850 | 21239 | Woodford | Kentucky | US | 2020-04-29 02:32:29 | 38.04178222 | -84.7417556 | 17 | 0 | 0 | 17 | Woodford, Kentucky, US |
2848 | 2848 | 19193 | Woodbury | Iowa | US | 2020-04-29 02:32:29 | 42.38979414 | -96.0459439 | 695 | 1 | 0 | 694 | Woodbury, Iowa, US |
2844 | 2844 | 39173 | Wood | Ohio | US | 2020-04-29 02:32:29 | 41.36224827 | -83.62285108 | 145 | 23 | 0 | 126 | Wood, Ohio, US |
2845 | 2845 | 48499 | Wood | Texas | US | 2020-04-29 02:32:29 | 32.78722382 | -95.38236368 | 7 | 0 | 0 | 7 | Wood, Texas, US |
2846 | 2846 | 54107 | Wood | West Virginia | US | 2020-04-29 02:32:29 | 39.20967886 | -81.5162836 | 39 | 2 | 0 | 37 | Wood, West Virginia, US |
2847 | 2847 | 55141 | Wood | Wisconsin | US | 2020-04-29 02:32:29 | 44.45537896 | -90.04158336 | 2 | 0 | 0 | 2 | Wood, Wisconsin, US |
2842 | 2842 | 48497 | Wise | Texas | US | 2020-04-29 02:32:29 | 33.21570665 | -97.65460265 | 15 | 2 | 0 | 13 | Wise, Texas, US |
2843 | 2843 | 51195 | Wise | Virginia | US | 2020-04-29 02:32:29 | 36.9746148 | -82.62410519 | 22 | 1 | 0 | 21 | Wise, Virginia, US |
2841 | 2841 | 54105 | Wirt | West Virginia | US | 2020-04-29 02:32:29 | 39.02775007 | -81.37473928 | 3 | 0 | 0 | 3 | Wirt, West Virginia, US |
2839 | 2839 | 1133 | Winston | Alabama | US | 2020-04-29 02:32:29 | 34.15030532 | -87.37325922 | 12 | 0 | 0 | 13 | Winston, Alabama, US |
2840 | 2840 | 28159 | Winston | Mississippi | US | 2020-04-29 02:32:29 | 33.08747908 | -89.03391385 | 41 | 0 | 0 | 41 | Winston, Mississippi, US |
2838 | 2838 | 27169 | Winona | Minnesota | US | 2020-04-29 02:32:29 | 43.98772283 | -91.78081305 | 66 | 14 | 0 | 52 | Winona, Minnesota, US |
2837 | 2837 | 19191 | Winneshiek | Iowa | US | 2020-04-29 02:32:29 | 43.29094334 | -91.84422722 | 15 | 0 | 0 | 15 | Winneshiek, Iowa, US |
2834 | 2834 | 17201 | Winnebago | Illinois | US | 2020-04-29 02:32:29 | 42.33641854 | -89.16085327 | 365 | 10 | 0 | 355 | Winnebago, Illinois, US |
2835 | 2835 | 19189 | Winnebago | Iowa | US | 2020-04-29 02:32:29 | 43.37751174 | -93.73407298 | 2 | 0 | 0 | 2 | Winnebago, Iowa, US |
2836 | 2836 | 55139 | Winnebago | Wisconsin | US | 2020-04-29 02:32:29 | 44.06886922 | -88.64477096 | 48 | 1 | 0 | 47 | Winnebago, Wisconsin, US |
2833 | 2833 | 22127 | Winn | Louisiana | US | 2020-04-29 02:32:29 | 31.94449367 | -92.63789413 | 26 | 2 | 0 | 24 | Winn, Louisiana, US |
2832 | 2832 | 48495 | Winkler | Texas | US | 2020-04-29 02:32:29 | 31.85008651 | -103.0485163 | 3 | 0 | 0 | 3 | Winkler, Texas, US |
2831 | 2831 | 50027 | Windsor | Vermont | US | 2020-04-29 02:32:29 | 43.58010937 | -72.58595157 | 40 | 2 | 0 | 38 | Windsor, Vermont, US |
2829 | 2829 | 9015 | Windham | Connecticut | US | 2020-04-29 02:32:29 | 41.82972709 | -71.98182316 | 164 | 3 | 0 | 161 | Windham, Connecticut, US |
2830 | 2830 | 50025 | Windham | Vermont | US | 2020-04-29 02:32:29 | 42.986982 | -72.71268875 | 71 | 2 | 0 | 69 | Windham, Vermont, US |
2828 | 2828 | 51840 | Winchester | Virginia | US | 2020-04-29 02:32:29 | 39.17054517 | -78.17325058 | 36 | 0 | 0 | 36 | Winchester, Virginia, US |
2824 | 2824 | 20205 | Wilson | Kansas | US | 2020-04-29 02:32:29 | 37.55937174 | -95.74323255 | 1 | 0 | 0 | 1 | Wilson, Kansas, US |
2825 | 2825 | 37195 | Wilson | North Carolina | US | 2020-04-29 02:32:29 | 35.70625477 | -77.917978 | 155 | 6 | 0 | 149 | Wilson, North Carolina, US |
2826 | 2826 | 47189 | Wilson | Tennessee | US | 2020-04-29 02:32:29 | 36.15496772 | -86.29775884 | 249 | 3 | 0 | 246 | Wilson, Tennessee, US |
2827 | 2827 | 48493 | Wilson | Texas | US | 2020-04-29 02:32:29 | 29.1732598 | -98.08693082 | 29 | 2 | 0 | 27 | Wilson, Texas, US |
2821 | 2821 | 17199 | Williamson | Illinois | US | 2020-04-29 02:32:29 | 37.73033511 | -88.92994027 | 28 | 0 | 0 | 28 | Williamson, Illinois, US |
2822 | 2822 | 47187 | Williamson | Tennessee | US | 2020-04-29 02:32:29 | 35.89099229 | -86.89281867 | 399 | 8 | 0 | 391 | Williamson, Tennessee, US |
2823 | 2823 | 48491 | Williamson | Texas | US | 2020-04-29 02:32:29 | 30.64655664 | -97.6004854 | 287 | 6 | 0 | 281 | Williamson, Texas, US |
2819 | 2819 | 45089 | Williamsburg | South Carolina | US | 2020-04-29 02:32:29 | 33.62190129 | -79.72767442 | 60 | 0 | 0 | 60 | Williamsburg, South Carolina, US |
2820 | 2820 | 51830 | Williamsburg | Virginia | US | 2020-04-29 02:32:29 | 37.28131268 | -76.70905141 | 18 | 1 | 0 | 17 | Williamsburg, Virginia, US |
2817 | 2817 | 38105 | Williams | North Dakota | US | 2020-04-29 02:32:29 | 48.34522353 | -103.4793387 | 10 | 0 | 0 | 10 | Williams, North Dakota, US |
2818 | 2818 | 39171 | Williams | Ohio | US | 2020-04-29 02:32:29 | 41.56052014 | -84.58429552 | 31 | 1 | 0 | 30 | Williams, Ohio, US |
2816 | 2816 | 48489 | Willacy | Texas | US | 2020-04-29 02:32:29 | 26.47411727 | -97.61535848 | 13 | 1 | 0 | 12 | Willacy, Texas, US |
2815 | 2815 | 17197 | Will | Illinois | US | 2020-04-29 02:32:29 | 41.44619267 | -87.97862712 | 2254 | 145 | 0 | 2109 | Will, Illinois, US |
2813 | 2813 | 13319 | Wilkinson | Georgia | US | 2020-04-29 02:32:29 | 32.80291082 | -83.17140684 | 34 | 2 | 0 | 32 | Wilkinson, Georgia, US |
2814 | 2814 | 28157 | Wilkinson | Mississippi | US | 2020-04-29 02:32:29 | 31.16078225 | -91.31018819 | 68 | 7 | 0 | 61 | Wilkinson, Mississippi, US |
2812 | 2812 | 27167 | Wilkin | Minnesota | US | 2020-04-29 02:32:29 | 46.35721532 | -96.4684375 | 12 | 3 | 0 | 9 | Wilkin, Minnesota, US |
2810 | 2810 | 13317 | Wilkes | Georgia | US | 2020-04-29 02:32:29 | 33.78290391 | -82.74286107 | 23 | 0 | 0 | 23 | Wilkes, Georgia, US |
2811 | 2811 | 37193 | Wilkes | North Carolina | US | 2020-04-29 02:32:29 | 36.2084135 | -81.16232895 | 22 | 1 | 0 | 21 | Wilkes, North Carolina, US |
2808 | 2808 | 1131 | Wilcox | Alabama | US | 2020-04-29 02:32:29 | 31.98773215 | -87.30891118 | 59 | 1 | 0 | 59 | Wilcox, Alabama, US |
2809 | 2809 | 13315 | Wilcox | Georgia | US | 2020-04-29 02:32:29 | 31.97496928 | -83.43438555 | 89 | 8 | 0 | 81 | Wilcox, Georgia, US |
2807 | 2807 | 48487 | Wilbarger | Texas | US | 2020-04-29 02:32:29 | 34.07945812 | -99.24178437 | 1 | 0 | 0 | 1 | Wilbarger, Texas, US |
2806 | 2806 | 24045 | Wicomico | Maryland | US | 2020-04-29 02:32:29 | 38.37301947 | -75.62705831 | 340 | 5 | 0 | 335 | Wicomico, Maryland, US |
2805 | 2805 | 48485 | Wichita | Texas | US | 2020-04-29 02:32:29 | 33.98842886 | -98.7041034 | 63 | 2 | 0 | 61 | Wichita, Texas, US |
2804 | 2804 | 53075 | Whitman | Washington | US | 2020-04-29 02:32:29 | 46.90022523 | -117.5241763 | 14 | 0 | 0 | 14 | Whitman, Washington, US |
2802 | 2802 | 18183 | Whitley | Indiana | US | 2020-04-29 02:32:29 | 41.13863784 | -85.50791236 | 16 | 1 | 0 | 15 | Whitley, Indiana, US |
2803 | 2803 | 21235 | Whitley | Kentucky | US | 2020-04-29 02:32:29 | 36.75700531 | -84.14541217 | 11 | 0 | 0 | 11 | Whitley, Kentucky, US |
2801 | 2801 | 13313 | Whitfield | Georgia | US | 2020-04-29 02:32:29 | 34.80987459 | -84.96093476 | 75 | 4 | 0 | 71 | Whitfield, Georgia, US |
2800 | 2800 | 17195 | Whiteside | Illinois | US | 2020-04-29 02:32:29 | 41.75509713 | -89.91556058 | 76 | 5 | 0 | 71 | Whiteside, Illinois, US |
2799 | 2799 | 32033 | White Pine | Nevada | US | 2020-04-29 02:32:29 | 39.44157041 | -114.899966 | 3 | 0 | 0 | 3 | White Pine, Nevada, US |
2794 | 2794 | 5145 | White | Arkansas | US | 2020-04-29 02:32:29 | 35.25688493 | -91.74908296 | 31 | 1 | 0 | 30 | White, Arkansas, US |
2795 | 2795 | 13311 | White | Georgia | US | 2020-04-29 02:32:29 | 34.64624278 | -83.74905525 | 56 | 0 | 0 | 56 | White, Georgia, US |
2796 | 2796 | 17193 | White | Illinois | US | 2020-04-29 02:32:29 | 38.08706198 | -88.17657461 | 2 | 0 | 0 | 2 | White, Illinois, US |
2797 | 2797 | 18181 | White | Indiana | US | 2020-04-29 02:32:29 | 40.74911165 | -86.86492015 | 42 | 0 | 0 | 42 | White, Indiana, US |
2798 | 2798 | 47185 | White | Tennessee | US | 2020-04-29 02:32:29 | 35.92929884 | -85.45591799 | 5 | 0 | 0 | 5 | White, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [04-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 );