ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
409 rows where cases = 1356 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 31
- Minnesota 30
- Nebraska 25
- Georgia 24
- Texas 23
- Illinois 21
- Tennessee 21
- Iowa 20
- Mississippi 18
- Kansas 17
- Kentucky 16
- Puerto Rico 15
- South Dakota 14
- Virginia 13
- Michigan 12
- Missouri 11
- North Carolina 10
- Wisconsin 7
- Florida 6
- Alabama 5
- Connecticut 5
- Idaho 5
- Oklahoma 5
- California 4
- Indiana 4
- Louisiana 4
- Oregon 4
- Utah 4
- Maryland 3
- Montana 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501271 | 2501271 | 2022-05-13 | Dawes | Nebraska | 31045 | 1356 | 21 |
2492767 | 2492767 | 2022-05-10 | Cumberland | Virginia | 51049 | 1356 | 27 |
2476439 | 2476439 | 2022-05-05 | Unknown | Vermont | 1356 | 2 | |
2443182 | 2443182 | 2022-04-25 | Unknown | Oklahoma | 1356 | 0 | |
2439926 | 2439926 | 2022-04-24 | Unknown | Oklahoma | 1356 | 0 | |
2436670 | 2436670 | 2022-04-23 | Unknown | Oklahoma | 1356 | 0 | |
2424150 | 2424150 | 2022-04-19 | Hartley | Texas | 48205 | 1356 | 3 |
2420894 | 2420894 | 2022-04-18 | Hartley | Texas | 48205 | 1356 | 3 |
2417638 | 2417638 | 2022-04-17 | Hartley | Texas | 48205 | 1356 | 3 |
2414382 | 2414382 | 2022-04-16 | Hartley | Texas | 48205 | 1356 | 3 |
2411126 | 2411126 | 2022-04-15 | Hartley | Texas | 48205 | 1356 | 3 |
2407870 | 2407870 | 2022-04-14 | Hartley | Texas | 48205 | 1356 | 3 |
2345664 | 2345664 | 2022-03-26 | Ceiba | Puerto Rico | 72037 | 1356 | |
2338498 | 2338498 | 2022-03-24 | Dawes | Nebraska | 31045 | 1356 | 21 |
2335244 | 2335244 | 2022-03-23 | Dawes | Nebraska | 31045 | 1356 | 21 |
2331990 | 2331990 | 2022-03-22 | Dawes | Nebraska | 31045 | 1356 | 21 |
2328737 | 2328737 | 2022-03-21 | Dawes | Nebraska | 31045 | 1356 | 21 |
2316414 | 2316414 | 2022-03-17 | Maunabo | Puerto Rico | 72095 | 1356 | |
2312471 | 2312471 | 2022-03-16 | Dawes | Nebraska | 31045 | 1356 | 21 |
2307933 | 2307933 | 2022-03-15 | Calhoun | Georgia | 13037 | 1356 | 22 |
2309218 | 2309218 | 2022-03-15 | Dawes | Nebraska | 31045 | 1356 | 21 |
2302715 | 2302715 | 2022-03-13 | Dawes | Nebraska | 31045 | 1356 | 21 |
2299463 | 2299463 | 2022-03-12 | Dawes | Nebraska | 31045 | 1356 | 21 |
2296211 | 2296211 | 2022-03-11 | Dawes | Nebraska | 31045 | 1356 | 21 |
2289707 | 2289707 | 2022-03-09 | Dawes | Nebraska | 31045 | 1356 | 21 |
2286455 | 2286455 | 2022-03-08 | Dawes | Nebraska | 31045 | 1356 | 21 |
2283203 | 2283203 | 2022-03-07 | Dawes | Nebraska | 31045 | 1356 | 21 |
2270192 | 2270192 | 2022-03-03 | Dawes | Nebraska | 31045 | 1356 | 21 |
2268049 | 2268049 | 2022-03-02 | Newton | Texas | 48351 | 1356 | 59 |
2240571 | 2240571 | 2022-02-22 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2237320 | 2237320 | 2022-02-21 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2234069 | 2234069 | 2022-02-20 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2230818 | 2230818 | 2022-02-19 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2227567 | 2227567 | 2022-02-18 | Big Stone | Minnesota | 27011 | 1356 | 8 |
2215865 | 2215865 | 2022-02-14 | Bailey | Texas | 48017 | 1356 | 37 |
2210975 | 2210975 | 2022-02-13 | Washington | Kansas | 20201 | 1356 | 20 |
2212504 | 2212504 | 2022-02-13 | Tripp | South Dakota | 46123 | 1356 | 22 |
2212614 | 2212614 | 2022-02-13 | Bailey | Texas | 48017 | 1356 | 37 |
2207722 | 2207722 | 2022-02-12 | Washington | Kansas | 20201 | 1356 | 20 |
2209251 | 2209251 | 2022-02-12 | Tripp | South Dakota | 46123 | 1356 | 22 |
2204469 | 2204469 | 2022-02-11 | Washington | Kansas | 20201 | 1356 | 20 |
2205998 | 2205998 | 2022-02-11 | Tripp | South Dakota | 46123 | 1356 | 22 |
2201216 | 2201216 | 2022-02-10 | Washington | Kansas | 20201 | 1356 | 20 |
2197962 | 2197962 | 2022-02-09 | Washington | Kansas | 20201 | 1356 | 20 |
2187443 | 2187443 | 2022-02-06 | Trinity | California | 6105 | 1356 | 20 |
2184190 | 2184190 | 2022-02-05 | Trinity | California | 6105 | 1356 | 20 |
2180938 | 2180938 | 2022-02-04 | Trinity | California | 6105 | 1356 | 20 |
2182225 | 2182225 | 2022-02-04 | Dade | Missouri | 29057 | 1356 | 38 |
2171900 | 2171900 | 2022-02-01 | Mitchell | Kansas | 20123 | 1356 | 18 |
2168647 | 2168647 | 2022-01-31 | Mitchell | Kansas | 20123 | 1356 | 18 |
2165881 | 2165881 | 2022-01-30 | Jefferson | Mississippi | 28063 | 1356 | 35 |
2162626 | 2162626 | 2022-01-29 | Jefferson | Mississippi | 28063 | 1356 | 35 |
2159371 | 2159371 | 2022-01-28 | Jefferson | Mississippi | 28063 | 1356 | 35 |
2151927 | 2151927 | 2022-01-26 | Randolph | Georgia | 13243 | 1356 | 45 |
2150764 | 2150764 | 2022-01-25 | Pickett | Tennessee | 47137 | 1356 | 28 |
2147512 | 2147512 | 2022-01-24 | Pickett | Tennessee | 47137 | 1356 | 28 |
2141817 | 2141817 | 2022-01-23 | Montgomery | Arkansas | 5097 | 1356 | 53 |
2144258 | 2144258 | 2022-01-23 | Pickett | Tennessee | 47137 | 1356 | 28 |
2141003 | 2141003 | 2022-01-22 | Pickett | Tennessee | 47137 | 1356 | 28 |
2137747 | 2137747 | 2022-01-21 | Pickett | Tennessee | 47137 | 1356 | 28 |
2134493 | 2134493 | 2022-01-20 | Pickett | Tennessee | 47137 | 1356 | 28 |
2131134 | 2131134 | 2022-01-19 | Hamlin | South Dakota | 46057 | 1356 | 40 |
2131241 | 2131241 | 2022-01-19 | Pickett | Tennessee | 47137 | 1356 | 28 |
2109659 | 2109659 | 2022-01-13 | Treutlen | Georgia | 13283 | 1356 | 55 |
2107396 | 2107396 | 2022-01-12 | Chariton | Missouri | 29041 | 1356 | 32 |
2108699 | 2108699 | 2022-01-12 | Refugio | Texas | 48391 | 1356 | 31 |
2103252 | 2103252 | 2022-01-11 | Edwards | Illinois | 17047 | 1356 | 23 |
2097653 | 2097653 | 2022-01-09 | Daviess | Missouri | 29061 | 1356 | 18 |
2082706 | 2082706 | 2022-01-04 | Stephens | Texas | 48429 | 1356 | 38 |
2017581 | 2017581 | 2021-12-15 | Hamilton | Texas | 48193 | 1356 | 29 |
2005590 | 2005590 | 2021-12-12 | Macon | Georgia | 13193 | 1356 | 45 |
2006119 | 2006119 | 2021-12-12 | Bracken | Kentucky | 21023 | 1356 | 19 |
2008071 | 2008071 | 2021-12-12 | Essex | Virginia | 51057 | 1356 | 20 |
2002339 | 2002339 | 2021-12-11 | Macon | Georgia | 13193 | 1356 | 45 |
2002868 | 2002868 | 2021-12-11 | Bracken | Kentucky | 21023 | 1356 | 19 |
2004820 | 2004820 | 2021-12-11 | Essex | Virginia | 51057 | 1356 | 20 |
1999089 | 1999089 | 2021-12-10 | Macon | Georgia | 13193 | 1356 | 45 |
1999618 | 1999618 | 2021-12-10 | Bracken | Kentucky | 21023 | 1356 | 19 |
2001569 | 2001569 | 2021-12-10 | Essex | Virginia | 51057 | 1356 | 20 |
1995838 | 1995838 | 2021-12-09 | Macon | Georgia | 13193 | 1356 | 45 |
1998228 | 1998228 | 2021-12-09 | Winkler | Texas | 48495 | 1356 | 32 |
1992587 | 1992587 | 2021-12-08 | Macon | Georgia | 13193 | 1356 | 45 |
1993641 | 1993641 | 2021-12-08 | Harrison | Missouri | 29081 | 1356 | 21 |
1973393 | 1973393 | 2021-12-02 | Warren | Indiana | 18171 | 1356 | 18 |
1959701 | 1959701 | 2021-11-28 | Greenlee | Arizona | 4011 | 1356 | 22 |
1956450 | 1956450 | 2021-11-27 | Greenlee | Arizona | 4011 | 1356 | 21 |
1940184 | 1940184 | 2021-11-22 | Southeast Fairbanks Census Area | Alaska | 2240 | 1356 | 11 |
1942133 | 1942133 | 2021-11-22 | Pembina | North Dakota | 38067 | 1356 | 13 |
1922309 | 1922309 | 2021-11-16 | Holt | Nebraska | 31089 | 1356 | 16 |
1923253 | 1923253 | 2021-11-16 | Castro | Texas | 48069 | 1356 | 38 |
1915519 | 1915519 | 2021-11-14 | Choctaw | Mississippi | 28019 | 1356 | 27 |
1912269 | 1912269 | 2021-11-13 | Choctaw | Mississippi | 28019 | 1356 | 27 |
1909019 | 1909019 | 2021-11-12 | Choctaw | Mississippi | 28019 | 1356 | 27 |
1905379 | 1905379 | 2021-11-11 | Elliott | Kentucky | 21063 | 1356 | 8 |
1905770 | 1905770 | 2021-11-11 | Choctaw | Mississippi | 28019 | 1356 | 27 |
1906036 | 1906036 | 2021-11-11 | Custer | Nebraska | 31041 | 1356 | 21 |
1902129 | 1902129 | 2021-11-10 | Elliott | Kentucky | 21063 | 1356 | 8 |
1902521 | 1902521 | 2021-11-10 | Choctaw | Mississippi | 28019 | 1356 | 27 |
1890458 | 1890458 | 2021-11-06 | Guayama | Puerto Rico | 72057 | 1356 | |
1875733 | 1875733 | 2021-11-02 | Hamilton | Illinois | 17065 | 1356 | 25 |
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);