ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
597 rows where cases = 767 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 59
- South Dakota 58
- Nebraska 43
- Kansas 37
- Puerto Rico 32
- Georgia 27
- Virginia 26
- Iowa 23
- Missouri 23
- Idaho 20
- Colorado 17
- Indiana 17
- North Carolina 16
- Arkansas 14
- Montana 14
- Minnesota 11
- Oklahoma 11
- Alaska 9
- Kentucky 9
- Alabama 8
- Maryland 8
- Michigan 8
- Mississippi 8
- North Dakota 8
- West Virginia 8
- Louisiana 7
- New Mexico 7
- Ohio 6
- Oregon 6
- California 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378308 | 2378308 | 2022-04-05 | Aurora | South Dakota | 46003 | 767 | 17 |
2375054 | 2375054 | 2022-04-04 | Aurora | South Dakota | 46003 | 767 | 17 |
2371802 | 2371802 | 2022-04-03 | Aurora | South Dakota | 46003 | 767 | 17 |
2368549 | 2368549 | 2022-04-02 | Aurora | South Dakota | 46003 | 767 | 17 |
2365296 | 2365296 | 2022-04-01 | Aurora | South Dakota | 46003 | 767 | 17 |
2362043 | 2362043 | 2022-03-31 | Aurora | South Dakota | 46003 | 767 | 17 |
2358789 | 2358789 | 2022-03-30 | Aurora | South Dakota | 46003 | 767 | 17 |
2355535 | 2355535 | 2022-03-29 | Aurora | South Dakota | 46003 | 767 | 17 |
2352282 | 2352282 | 2022-03-28 | Aurora | South Dakota | 46003 | 767 | 17 |
2349030 | 2349030 | 2022-03-27 | Aurora | South Dakota | 46003 | 767 | 17 |
2345777 | 2345777 | 2022-03-26 | Aurora | South Dakota | 46003 | 767 | 17 |
2342524 | 2342524 | 2022-03-25 | Aurora | South Dakota | 46003 | 767 | 17 |
2339271 | 2339271 | 2022-03-24 | Aurora | South Dakota | 46003 | 767 | 17 |
2336017 | 2336017 | 2022-03-23 | Aurora | South Dakota | 46003 | 767 | 17 |
2332763 | 2332763 | 2022-03-22 | Aurora | South Dakota | 46003 | 767 | 17 |
2329510 | 2329510 | 2022-03-21 | Aurora | South Dakota | 46003 | 767 | 17 |
2326258 | 2326258 | 2022-03-20 | Aurora | South Dakota | 46003 | 767 | 17 |
2323005 | 2323005 | 2022-03-19 | Aurora | South Dakota | 46003 | 767 | 17 |
2319007 | 2319007 | 2022-03-18 | Kimball | Nebraska | 31105 | 767 | 9 |
2319751 | 2319751 | 2022-03-18 | Aurora | South Dakota | 46003 | 767 | 17 |
2315754 | 2315754 | 2022-03-17 | Kimball | Nebraska | 31105 | 767 | 9 |
2316497 | 2316497 | 2022-03-17 | Aurora | South Dakota | 46003 | 767 | 17 |
2312501 | 2312501 | 2022-03-16 | Kimball | Nebraska | 31105 | 767 | 9 |
2312954 | 2312954 | 2022-03-16 | Ellis | Oklahoma | 40045 | 767 | 7 |
2313244 | 2313244 | 2022-03-16 | Aurora | South Dakota | 46003 | 767 | 17 |
2309248 | 2309248 | 2022-03-15 | Kimball | Nebraska | 31105 | 767 | 9 |
2309701 | 2309701 | 2022-03-15 | Ellis | Oklahoma | 40045 | 767 | 7 |
2309991 | 2309991 | 2022-03-15 | Aurora | South Dakota | 46003 | 767 | 17 |
2305996 | 2305996 | 2022-03-14 | Kimball | Nebraska | 31105 | 767 | 9 |
2306448 | 2306448 | 2022-03-14 | Ellis | Oklahoma | 40045 | 767 | 7 |
2306738 | 2306738 | 2022-03-14 | Aurora | South Dakota | 46003 | 767 | 17 |
2302745 | 2302745 | 2022-03-13 | Kimball | Nebraska | 31105 | 767 | 9 |
2303197 | 2303197 | 2022-03-13 | Ellis | Oklahoma | 40045 | 767 | 7 |
2303487 | 2303487 | 2022-03-13 | Aurora | South Dakota | 46003 | 767 | 17 |
2299493 | 2299493 | 2022-03-12 | Kimball | Nebraska | 31105 | 767 | 9 |
2299945 | 2299945 | 2022-03-12 | Ellis | Oklahoma | 40045 | 767 | 7 |
2300235 | 2300235 | 2022-03-12 | Aurora | South Dakota | 46003 | 767 | 17 |
2296241 | 2296241 | 2022-03-11 | Kimball | Nebraska | 31105 | 767 | 9 |
2296693 | 2296693 | 2022-03-11 | Ellis | Oklahoma | 40045 | 767 | 7 |
2296983 | 2296983 | 2022-03-11 | Aurora | South Dakota | 46003 | 767 | 17 |
2293441 | 2293441 | 2022-03-10 | Ellis | Oklahoma | 40045 | 767 | 7 |
2293731 | 2293731 | 2022-03-10 | Aurora | South Dakota | 46003 | 767 | 17 |
2290479 | 2290479 | 2022-03-09 | Aurora | South Dakota | 46003 | 767 | 17 |
2287227 | 2287227 | 2022-03-08 | Aurora | South Dakota | 46003 | 767 | 17 |
2283975 | 2283975 | 2022-03-07 | Aurora | South Dakota | 46003 | 767 | 17 |
2270162 | 2270162 | 2022-03-03 | Sweet Grass | Montana | 30097 | 767 | 11 |
2266909 | 2266909 | 2022-03-02 | Sweet Grass | Montana | 30097 | 767 | 11 |
2218948 | 2218948 | 2022-02-15 | Bennett | South Dakota | 46007 | 767 | 12 |
2218988 | 2218988 | 2022-02-15 | Marshall | South Dakota | 46091 | 767 | 12 |
2194711 | 2194711 | 2022-02-08 | Woodson | Kansas | 20207 | 767 | 12 |
2191457 | 2191457 | 2022-02-07 | Woodson | Kansas | 20207 | 767 | 12 |
2187797 | 2187797 | 2022-02-06 | Oneida | Idaho | 16071 | 767 | 10 |
2184544 | 2184544 | 2022-02-05 | Oneida | Idaho | 16071 | 767 | 10 |
2181292 | 2181292 | 2022-02-04 | Oneida | Idaho | 16071 | 767 | 10 |
2171906 | 2171906 | 2022-02-01 | Ness | Kansas | 20135 | 767 | 18 |
2168653 | 2168653 | 2022-01-31 | Ness | Kansas | 20135 | 767 | 18 |
2164039 | 2164039 | 2022-01-29 | Upton | Texas | 48461 | 767 | 17 |
2159951 | 2159951 | 2022-01-28 | Hettinger | North Dakota | 38041 | 767 | 7 |
2147831 | 2147831 | 2022-01-24 | Grand Isle | Vermont | 50013 | 767 | 4 |
2132012 | 2132012 | 2022-01-20 | Calhoun | Arkansas | 5013 | 767 | 9 |
2098146 | 2098146 | 2022-01-09 | Foster | North Dakota | 38031 | 767 | 19 |
2078261 | 2078261 | 2022-01-03 | Musselshell | Montana | 30065 | 767 | 26 |
2075010 | 2075010 | 2022-01-02 | Musselshell | Montana | 30065 | 767 | 26 |
2075082 | 2075082 | 2022-01-02 | Johnson | Nebraska | 31097 | 767 | 10 |
2076073 | 2076073 | 2022-01-02 | Garza | Texas | 48169 | 767 | 25 |
2071759 | 2071759 | 2022-01-01 | Musselshell | Montana | 30065 | 767 | 26 |
2071831 | 2071831 | 2022-01-01 | Johnson | Nebraska | 31097 | 767 | 10 |
2072822 | 2072822 | 2022-01-01 | Garza | Texas | 48169 | 767 | 25 |
2068508 | 2068508 | 2021-12-31 | Musselshell | Montana | 30065 | 767 | 26 |
2068580 | 2068580 | 2021-12-31 | Johnson | Nebraska | 31097 | 767 | 10 |
2069571 | 2069571 | 2021-12-31 | Garza | Texas | 48169 | 767 | 25 |
2065257 | 2065257 | 2021-12-30 | Musselshell | Montana | 30065 | 767 | 26 |
2065329 | 2065329 | 2021-12-30 | Johnson | Nebraska | 31097 | 767 | 10 |
2066320 | 2066320 | 2021-12-30 | Garza | Texas | 48169 | 767 | 25 |
2062007 | 2062007 | 2021-12-29 | Musselshell | Montana | 30065 | 767 | 26 |
2058696 | 2058696 | 2021-12-28 | Putnam | Missouri | 29171 | 767 | 19 |
2058758 | 2058758 | 2021-12-28 | Musselshell | Montana | 30065 | 767 | 26 |
2054168 | 2054168 | 2021-12-27 | Washington | Colorado | 8121 | 767 | 24 |
2050918 | 2050918 | 2021-12-26 | Washington | Colorado | 8121 | 767 | 24 |
2051173 | 2051173 | 2021-12-26 | Bear Lake | Idaho | 16007 | 767 | 15 |
2047668 | 2047668 | 2021-12-25 | Washington | Colorado | 8121 | 767 | 24 |
2047923 | 2047923 | 2021-12-25 | Bear Lake | Idaho | 16007 | 767 | 15 |
2044418 | 2044418 | 2021-12-24 | Washington | Colorado | 8121 | 767 | 24 |
2044673 | 2044673 | 2021-12-24 | Bear Lake | Idaho | 16007 | 767 | 15 |
2041424 | 2041424 | 2021-12-23 | Bear Lake | Idaho | 16007 | 767 | 15 |
2039332 | 2039332 | 2021-12-22 | Johnson | Nebraska | 31097 | 767 | 10 |
2033141 | 2033141 | 2021-12-20 | LaMoure | North Dakota | 38045 | 767 | 17 |
2021283 | 2021283 | 2021-12-16 | Florence | Wisconsin | 55037 | 767 | 14 |
2015448 | 2015448 | 2021-12-15 | Lincoln | Idaho | 16063 | 767 | 14 |
2012197 | 2012197 | 2021-12-14 | Lincoln | Idaho | 16063 | 767 | 14 |
2010619 | 2010619 | 2021-12-13 | Wallowa | Oregon | 41063 | 767 | 13 |
2007368 | 2007368 | 2021-12-12 | Wallowa | Oregon | 41063 | 767 | 13 |
2004117 | 2004117 | 2021-12-11 | Wallowa | Oregon | 41063 | 767 | 13 |
2000866 | 2000866 | 2021-12-10 | Wallowa | Oregon | 41063 | 767 | 13 |
1997616 | 1997616 | 2021-12-09 | Wallowa | Oregon | 41063 | 767 | 13 |
1991335 | 1991335 | 2021-12-07 | Deuel | South Dakota | 46039 | 767 | 11 |
1923460 | 1923460 | 2021-11-16 | Wheeler | Texas | 48483 | 767 | 14 |
1920300 | 1920300 | 2021-11-15 | Covington city | Virginia | 51580 | 767 | 18 |
1915770 | 1915770 | 2021-11-14 | Boone | Nebraska | 31011 | 767 | 4 |
1912520 | 1912520 | 2021-11-13 | Boone | Nebraska | 31011 | 767 | 4 |
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);