ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
459 rows where cases = 1150 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 43
- Mississippi 37
- Kentucky 26
- Illinois 24
- Oklahoma 23
- Georgia 21
- Minnesota 20
- Missouri 19
- Iowa 18
- Arkansas 17
- Virginia 17
- Tennessee 14
- Montana 12
- Texas 12
- Wyoming 12
- North Carolina 11
- Louisiana 10
- Kansas 8
- Ohio 8
- Pennsylvania 7
- Puerto Rico 7
- Utah 7
- Idaho 6
- Indiana 6
- South Dakota 6
- West Virginia 6
- Wisconsin 6
- Colorado 5
- Massachusetts 5
- Michigan 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451399 | 2451399 | 2022-04-28 | Putnam | Illinois | 17155 | 1150 | 10 |
2369972 | 2369972 | 2022-04-03 | Henderson | Illinois | 17071 | 1150 | 27 |
2366719 | 2366719 | 2022-04-02 | Henderson | Illinois | 17071 | 1150 | 27 |
2363466 | 2363466 | 2022-04-01 | Henderson | Illinois | 17071 | 1150 | 27 |
2360212 | 2360212 | 2022-03-31 | Henderson | Illinois | 17071 | 1150 | 27 |
2356958 | 2356958 | 2022-03-30 | Henderson | Illinois | 17071 | 1150 | 27 |
2317268 | 2317268 | 2022-03-17 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2314015 | 2314015 | 2022-03-16 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2309114 | 2309114 | 2022-03-15 | Reynolds | Missouri | 29179 | 1150 | 25 |
2310762 | 2310762 | 2022-03-15 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2305862 | 2305862 | 2022-03-14 | Reynolds | Missouri | 29179 | 1150 | 25 |
2307509 | 2307509 | 2022-03-14 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2302611 | 2302611 | 2022-03-13 | Reynolds | Missouri | 29179 | 1150 | 25 |
2304258 | 2304258 | 2022-03-13 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2299359 | 2299359 | 2022-03-12 | Reynolds | Missouri | 29179 | 1150 | 25 |
2301006 | 2301006 | 2022-03-12 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2296107 | 2296107 | 2022-03-11 | Reynolds | Missouri | 29179 | 1150 | 25 |
2297754 | 2297754 | 2022-03-11 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2294502 | 2294502 | 2022-03-10 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2291250 | 2291250 | 2022-03-09 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2287998 | 2287998 | 2022-03-08 | Hot Springs | Wyoming | 56017 | 1150 | 15 |
2281810 | 2281810 | 2022-03-07 | Saguache | Colorado | 8109 | 1150 | 12 |
2269012 | 2269012 | 2022-03-03 | Schley | Georgia | 13249 | 1150 | 8 |
2266897 | 2266897 | 2022-03-02 | Pondera | Montana | 30073 | 1150 | 6 |
2245271 | 2245271 | 2022-02-23 | Martin | Texas | 48317 | 1150 | 26 |
2234478 | 2234478 | 2022-02-20 | Polk | Nebraska | 31143 | 1150 | 18 |
2231227 | 2231227 | 2022-02-19 | Polk | Nebraska | 31143 | 1150 | 18 |
2227976 | 2227976 | 2022-02-18 | Polk | Nebraska | 31143 | 1150 | 18 |
2145516 | 2145516 | 2022-01-24 | Alexander | Illinois | 17003 | 1150 | 13 |
2144753 | 2144753 | 2022-01-23 | Skamania | Washington | 53059 | 1150 | 10 |
2141498 | 2141498 | 2022-01-22 | Skamania | Washington | 53059 | 1150 | 10 |
2138242 | 2138242 | 2022-01-21 | Skamania | Washington | 53059 | 1150 | 10 |
2132581 | 2132581 | 2022-01-20 | Scott | Illinois | 17171 | 1150 | 10 |
2111654 | 2111654 | 2022-01-13 | Tripp | South Dakota | 46123 | 1150 | 21 |
2095622 | 2095622 | 2022-01-08 | Jim Hogg | Texas | 48247 | 1150 | 20 |
2080462 | 2080462 | 2022-01-04 | Power | Idaho | 16077 | 1150 | 17 |
2075051 | 2075051 | 2022-01-02 | Clay | Nebraska | 31035 | 1150 | 17 |
2071800 | 2071800 | 2022-01-01 | Clay | Nebraska | 31035 | 1150 | 17 |
2068549 | 2068549 | 2021-12-31 | Clay | Nebraska | 31035 | 1150 | 17 |
2065298 | 2065298 | 2021-12-30 | Clay | Nebraska | 31035 | 1150 | 17 |
2053210 | 2053210 | 2021-12-26 | Pickett | Tennessee | 47137 | 1150 | 28 |
2049960 | 2049960 | 2021-12-25 | Pickett | Tennessee | 47137 | 1150 | 28 |
2046710 | 2046710 | 2021-12-24 | Pickett | Tennessee | 47137 | 1150 | 28 |
2043460 | 2043460 | 2021-12-23 | Pickett | Tennessee | 47137 | 1150 | 28 |
2033450 | 2033450 | 2021-12-20 | Aibonito | Puerto Rico | 72009 | 1150 | |
2019420 | 2019420 | 2021-12-16 | Oscoda | Michigan | 26135 | 1150 | 49 |
2021049 | 2021049 | 2021-12-16 | Bland | Virginia | 51021 | 1150 | 18 |
2016170 | 2016170 | 2021-12-15 | Oscoda | Michigan | 26135 | 1150 | 49 |
2008542 | 2008542 | 2021-12-13 | Woodruff | Arkansas | 5147 | 1150 | 24 |
2005291 | 2005291 | 2021-12-12 | Woodruff | Arkansas | 5147 | 1150 | 24 |
2006041 | 2006041 | 2021-12-12 | Harper | Kansas | 20077 | 1150 | 25 |
2002040 | 2002040 | 2021-12-11 | Woodruff | Arkansas | 5147 | 1150 | 24 |
2002790 | 2002790 | 2021-12-11 | Harper | Kansas | 20077 | 1150 | 25 |
1999540 | 1999540 | 2021-12-10 | Harper | Kansas | 20077 | 1150 | 25 |
1995539 | 1995539 | 2021-12-09 | Woodruff | Arkansas | 5147 | 1150 | 24 |
1989108 | 1989108 | 2021-12-07 | Conejos | Colorado | 8021 | 1150 | 42 |
1990795 | 1990795 | 2021-12-07 | Gates | North Carolina | 37073 | 1150 | 18 |
1975982 | 1975982 | 2021-12-03 | Dallas | Arkansas | 5039 | 1150 | 19 |
1972882 | 1972882 | 2021-12-02 | Lake | Colorado | 8065 | 1150 | 1 |
1927778 | 1927778 | 2021-11-18 | Schuyler | Illinois | 17169 | 1150 | 24 |
1921897 | 1921897 | 2021-11-16 | Montmorency | Michigan | 26119 | 1150 | 32 |
1917503 | 1917503 | 2021-11-15 | Montgomery | Arkansas | 5097 | 1150 | 46 |
1918647 | 1918647 | 2021-11-15 | Montmorency | Michigan | 26119 | 1150 | 32 |
1914253 | 1914253 | 2021-11-14 | Montgomery | Arkansas | 5097 | 1150 | 46 |
1914523 | 1914523 | 2021-11-14 | Crawford | Georgia | 13079 | 1150 | 43 |
1911273 | 1911273 | 2021-11-13 | Crawford | Georgia | 13079 | 1150 | 43 |
1908024 | 1908024 | 2021-11-12 | Crawford | Georgia | 13079 | 1150 | 43 |
1892359 | 1892359 | 2021-11-07 | Bracken | Kentucky | 21023 | 1150 | 10 |
1889109 | 1889109 | 2021-11-06 | Bracken | Kentucky | 21023 | 1150 | 10 |
1885859 | 1885859 | 2021-11-05 | Bracken | Kentucky | 21023 | 1150 | 10 |
1870263 | 1870263 | 2021-10-31 | Stillwater | Montana | 30095 | 1150 | 26 |
1867014 | 1867014 | 2021-10-30 | Stillwater | Montana | 30095 | 1150 | 26 |
1863765 | 1863765 | 2021-10-29 | Stillwater | Montana | 30095 | 1150 | 26 |
1858741 | 1858741 | 2021-10-27 | Pocahontas | West Virginia | 54075 | 1150 | 18 |
1855505 | 1855505 | 2021-10-26 | Webster | West Virginia | 54101 | 1150 | 17 |
1832810 | 1832810 | 2021-10-19 | Pepin | Wisconsin | 55091 | 1150 | 10 |
1828400 | 1828400 | 2021-10-18 | Pembina | North Dakota | 38067 | 1150 | 11 |
1824827 | 1824827 | 2021-10-17 | Holt | Nebraska | 31089 | 1150 | 16 |
1821578 | 1821578 | 2021-10-16 | Holt | Nebraska | 31089 | 1150 | 16 |
1818329 | 1818329 | 2021-10-15 | Holt | Nebraska | 31089 | 1150 | 16 |
1814278 | 1814278 | 2021-10-14 | Coffey | Kansas | 20031 | 1150 | 26 |
1811029 | 1811029 | 2021-10-13 | Coffey | Kansas | 20031 | 1150 | 26 |
1807981 | 1807981 | 2021-10-12 | Trimble | Kentucky | 21223 | 1150 | 11 |
1806397 | 1806397 | 2021-10-11 | Marion | Texas | 48315 | 1150 | 46 |
1803147 | 1803147 | 2021-10-10 | Marion | Texas | 48315 | 1150 | 46 |
1799898 | 1799898 | 2021-10-09 | Marion | Texas | 48315 | 1150 | 46 |
1781036 | 1781036 | 2021-10-04 | Newton | Arkansas | 5101 | 1150 | 34 |
1781083 | 1781083 | 2021-10-04 | Mariposa | California | 6043 | 1150 | 13 |
1777786 | 1777786 | 2021-10-03 | Newton | Arkansas | 5101 | 1150 | 34 |
1774536 | 1774536 | 2021-10-02 | Newton | Arkansas | 5101 | 1150 | 34 |
1743539 | 1743539 | 2021-09-22 | Powell | Montana | 30077 | 1150 | 14 |
1722879 | 1722879 | 2021-09-16 | Miller | Georgia | 13201 | 1150 | 17 |
1725532 | 1725532 | 2021-09-16 | Summers | West Virginia | 54089 | 1150 | 26 |
1720675 | 1720675 | 2021-09-15 | Gentry | Missouri | 29075 | 1150 | 23 |
1721097 | 1721097 | 2021-09-15 | Jones | North Carolina | 37103 | 1150 | 29 |
1717490 | 1717490 | 2021-09-14 | St. Clair | Missouri | 29185 | 1150 | 9 |
1715530 | 1715530 | 2021-09-13 | Emery | Utah | 49015 | 1150 | 12 |
1712284 | 1712284 | 2021-09-12 | Emery | Utah | 49015 | 1150 | 12 |
1709037 | 1709037 | 2021-09-11 | Emery | Utah | 49015 | 1150 | 12 |
1674695 | 1674695 | 2021-09-01 | Elliott | Kentucky | 21063 | 1150 | 2 |
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);