ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
341 rows where cases = 1575 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 42
- Georgia 35
- Iowa 28
- Texas 26
- Mississippi 23
- Kentucky 16
- Missouri 16
- Illinois 15
- Virginia 13
- Montana 11
- Puerto Rico 11
- Kansas 10
- Michigan 10
- North Carolina 10
- Arkansas 9
- South Dakota 9
- Indiana 8
- Minnesota 8
- Florida 7
- Wisconsin 7
- Alabama 6
- Ohio 6
- Tennessee 6
- Maryland 5
- New York 4
- North Dakota 4
- Washington 4
- California 3
- Colorado 3
- New Mexico 3
- Oregon 3
- Pennsylvania 3
- South Carolina 3
- West Virginia 3
- Idaho 2
- Louisiana 2
- New Jersey 2
- Utah 2
- Nevada 1
- New Hampshire 1
- Oklahoma 1
- Vermont 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461965 | 2461965 | 2022-05-01 | Quitman | Mississippi | 28119 | 1575 | 31 |
2458709 | 2458709 | 2022-04-30 | Quitman | Mississippi | 28119 | 1575 | 31 |
2455453 | 2455453 | 2022-04-29 | Quitman | Mississippi | 28119 | 1575 | 31 |
2452197 | 2452197 | 2022-04-28 | Quitman | Mississippi | 28119 | 1575 | 31 |
2448941 | 2448941 | 2022-04-27 | Quitman | Mississippi | 28119 | 1575 | 31 |
2445685 | 2445685 | 2022-04-26 | Quitman | Mississippi | 28119 | 1575 | 31 |
2442429 | 2442429 | 2022-04-25 | Quitman | Mississippi | 28119 | 1575 | 31 |
2439173 | 2439173 | 2022-04-24 | Quitman | Mississippi | 28119 | 1575 | 31 |
2435917 | 2435917 | 2022-04-23 | Quitman | Mississippi | 28119 | 1575 | 31 |
2432661 | 2432661 | 2022-04-22 | Quitman | Mississippi | 28119 | 1575 | 31 |
2429405 | 2429405 | 2022-04-21 | Quitman | Mississippi | 28119 | 1575 | 31 |
2426149 | 2426149 | 2022-04-20 | Quitman | Mississippi | 28119 | 1575 | 31 |
2422893 | 2422893 | 2022-04-19 | Quitman | Mississippi | 28119 | 1575 | 31 |
2419637 | 2419637 | 2022-04-18 | Quitman | Mississippi | 28119 | 1575 | 31 |
2395831 | 2395831 | 2022-04-11 | Hancock | Georgia | 13141 | 1575 | 89 |
2392575 | 2392575 | 2022-04-10 | Hancock | Georgia | 13141 | 1575 | 89 |
2393213 | 2393213 | 2022-04-10 | Owsley | Kentucky | 21189 | 1575 | 25 |
2389319 | 2389319 | 2022-04-09 | Hancock | Georgia | 13141 | 1575 | 89 |
2389957 | 2389957 | 2022-04-09 | Owsley | Kentucky | 21189 | 1575 | 25 |
2386064 | 2386064 | 2022-04-08 | Hancock | Georgia | 13141 | 1575 | 89 |
2386701 | 2386701 | 2022-04-08 | Owsley | Kentucky | 21189 | 1575 | 25 |
2383446 | 2383446 | 2022-04-07 | Owsley | Kentucky | 21189 | 1575 | 25 |
2380191 | 2380191 | 2022-04-06 | Owsley | Kentucky | 21189 | 1575 | 25 |
2376936 | 2376936 | 2022-04-05 | Owsley | Kentucky | 21189 | 1575 | 25 |
2373684 | 2373684 | 2022-04-04 | Owsley | Kentucky | 21189 | 1575 | 25 |
2337264 | 2337264 | 2022-03-24 | Hancock | Georgia | 13141 | 1575 | 88 |
2334010 | 2334010 | 2022-03-23 | Hancock | Georgia | 13141 | 1575 | 88 |
2330756 | 2330756 | 2022-03-22 | Hancock | Georgia | 13141 | 1575 | 88 |
2327504 | 2327504 | 2022-03-21 | Hancock | Georgia | 13141 | 1575 | 88 |
2308396 | 2308396 | 2022-03-15 | Pocahontas | Iowa | 19151 | 1575 | 27 |
2305145 | 2305145 | 2022-03-14 | Pocahontas | Iowa | 19151 | 1575 | 27 |
2301893 | 2301893 | 2022-03-13 | Pocahontas | Iowa | 19151 | 1575 | 27 |
2298641 | 2298641 | 2022-03-12 | Pocahontas | Iowa | 19151 | 1575 | 27 |
2295389 | 2295389 | 2022-03-11 | Pocahontas | Iowa | 19151 | 1575 | 27 |
2292137 | 2292137 | 2022-03-10 | Pocahontas | Iowa | 19151 | 1575 | 27 |
2288885 | 2288885 | 2022-03-09 | Pocahontas | Iowa | 19151 | 1575 | 27 |
2270019 | 2270019 | 2022-03-03 | Clark | Missouri | 29045 | 1575 | 32 |
2263515 | 2263515 | 2022-03-01 | Clark | Missouri | 29045 | 1575 | 32 |
2260264 | 2260264 | 2022-02-28 | Clark | Missouri | 29045 | 1575 | 32 |
2258161 | 2258161 | 2022-02-27 | Coleman | Texas | 48083 | 1575 | 69 |
2254910 | 2254910 | 2022-02-26 | Coleman | Texas | 48083 | 1575 | 69 |
2247750 | 2247750 | 2022-02-24 | Bottineau | North Dakota | 38009 | 1575 | 25 |
2240799 | 2240799 | 2022-02-22 | Maries | Missouri | 29125 | 1575 | 32 |
2232135 | 2232135 | 2022-02-19 | Brooks | Texas | 48047 | 1575 | 50 |
2174000 | 2174000 | 2022-02-01 | Williamsburg city | Virginia | 51830 | 1575 | 13 |
2135308 | 2135308 | 2022-01-21 | Newton | Arkansas | 5101 | 1575 | 45 |
2128204 | 2128204 | 2022-01-18 | Rains | Texas | 48379 | 1575 | 49 |
2105047 | 2105047 | 2022-01-11 | Allendale | South Carolina | 45005 | 1575 | 22 |
2086530 | 2086530 | 2022-01-06 | Nevada | Arkansas | 5099 | 1575 | 43 |
2063496 | 2063496 | 2021-12-29 | Pleasants | West Virginia | 54073 | 1575 | 31 |
2046497 | 2046497 | 2021-12-24 | Naguabo | Puerto Rico | 72103 | 1575 | |
2043247 | 2043247 | 2021-12-23 | Naguabo | Puerto Rico | 72103 | 1575 | |
2037605 | 2037605 | 2021-12-21 | Platte | Wyoming | 56031 | 1575 | 35 |
2015332 | 2015332 | 2021-12-15 | Johnson | Georgia | 13167 | 1575 | 64 |
2016518 | 2016518 | 2021-12-15 | Sanders | Montana | 30089 | 1575 | 40 |
2012081 | 2012081 | 2021-12-14 | Johnson | Georgia | 13167 | 1575 | 64 |
2013150 | 2013150 | 2021-12-14 | Howard | Missouri | 29089 | 1575 | 19 |
2008830 | 2008830 | 2021-12-13 | Johnson | Georgia | 13167 | 1575 | 64 |
2006725 | 2006725 | 2021-12-12 | Carbon | Montana | 30009 | 1575 | 22 |
2003474 | 2003474 | 2021-12-11 | Carbon | Montana | 30009 | 1575 | 22 |
2000224 | 2000224 | 2021-12-10 | Carbon | Montana | 30009 | 1575 | 22 |
1998499 | 1998499 | 2021-12-09 | Summers | West Virginia | 54089 | 1575 | 34 |
1982763 | 1982763 | 2021-12-05 | Candler | Georgia | 13043 | 1575 | 90 |
1979513 | 1979513 | 2021-12-04 | Candler | Georgia | 13043 | 1575 | 90 |
1976263 | 1976263 | 2021-12-03 | Candler | Georgia | 13043 | 1575 | 90 |
1973014 | 1973014 | 2021-12-02 | Candler | Georgia | 13043 | 1575 | 90 |
1973852 | 1973852 | 2021-12-02 | Baraga | Michigan | 26013 | 1575 | 47 |
1969764 | 1969764 | 2021-12-01 | Candler | Georgia | 13043 | 1575 | 90 |
1970603 | 1970603 | 2021-12-01 | Baraga | Michigan | 26013 | 1575 | 47 |
1966514 | 1966514 | 2021-11-30 | Candler | Georgia | 13043 | 1575 | 89 |
1967445 | 1967445 | 2021-11-30 | Clearwater | Minnesota | 27029 | 1575 | 20 |
1960148 | 1960148 | 2021-11-28 | Wilkes | Georgia | 13317 | 1575 | 38 |
1961654 | 1961654 | 2021-11-28 | Traill | North Dakota | 38097 | 1575 | 21 |
1956897 | 1956897 | 2021-11-27 | Wilkes | Georgia | 13317 | 1575 | 38 |
1953646 | 1953646 | 2021-11-26 | Wilkes | Georgia | 13317 | 1575 | 38 |
1950395 | 1950395 | 2021-11-25 | Wilkes | Georgia | 13317 | 1575 | 38 |
1947144 | 1947144 | 2021-11-24 | Wilkes | Georgia | 13317 | 1575 | 38 |
1943893 | 1943893 | 2021-11-23 | Wilkes | Georgia | 13317 | 1575 | 38 |
1942758 | 1942758 | 2021-11-22 | Clay | Texas | 48077 | 1575 | 25 |
1938203 | 1938203 | 2021-11-21 | Jackson | Minnesota | 27063 | 1575 | 16 |
1939508 | 1939508 | 2021-11-21 | Clay | Texas | 48077 | 1575 | 25 |
1934953 | 1934953 | 2021-11-20 | Jackson | Minnesota | 27063 | 1575 | 16 |
1936258 | 1936258 | 2021-11-20 | Clay | Texas | 48077 | 1575 | 25 |
1931703 | 1931703 | 2021-11-19 | Jackson | Minnesota | 27063 | 1575 | 16 |
1933008 | 1933008 | 2021-11-19 | Clay | Texas | 48077 | 1575 | 25 |
1929897 | 1929897 | 2021-11-18 | Ochiltree | Texas | 48357 | 1575 | 38 |
1926647 | 1926647 | 2021-11-17 | Ochiltree | Texas | 48357 | 1575 | 37 |
1923397 | 1923397 | 2021-11-16 | Ochiltree | Texas | 48357 | 1575 | 37 |
1898878 | 1898878 | 2021-11-09 | Edmonson | Kentucky | 21061 | 1575 | 30 |
1884114 | 1884114 | 2021-11-04 | Roberts | South Dakota | 46109 | 1575 | 43 |
1874351 | 1874351 | 2021-11-01 | Lake | South Dakota | 46079 | 1575 | 20 |
1856183 | 1856183 | 2021-10-27 | Franklin | Idaho | 16041 | 1575 | 23 |
1850114 | 1850114 | 2021-10-25 | Bath | Kentucky | 21011 | 1575 | 30 |
1844144 | 1844144 | 2021-10-23 | Grundy | Missouri | 29079 | 1575 | 47 |
1838630 | 1838630 | 2021-10-21 | Todd | South Dakota | 46121 | 1575 | 36 |
1829321 | 1829321 | 2021-10-18 | Dickenson | Virginia | 51051 | 1575 | 26 |
1823330 | 1823330 | 2021-10-17 | Plumas | California | 6063 | 1575 | 6 |
1820081 | 1820081 | 2021-10-16 | Plumas | California | 6063 | 1575 | 6 |
1816832 | 1816832 | 2021-10-15 | Plumas | California | 6063 | 1575 | 6 |
1810715 | 1810715 | 2021-10-13 | Teton | Idaho | 16081 | 1575 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);