ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
488 rows where cases = 793 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 51
- Kansas 46
- Georgia 34
- Missouri 27
- Virginia 25
- Nebraska 19
- South Dakota 19
- Kentucky 17
- Mississippi 16
- North Carolina 16
- Illinois 14
- Colorado 13
- Oklahoma 13
- Puerto Rico 12
- Minnesota 11
- Wisconsin 11
- Tennessee 10
- Indiana 9
- Utah 9
- Iowa 8
- Alabama 7
- Arkansas 7
- Louisiana 7
- Oregon 7
- South Carolina 7
- Alaska 6
- New Mexico 6
- North Dakota 6
- West Virginia 6
- Michigan 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492313 | 2492313 | 2022-05-10 | Marshall | South Dakota | 46091 | 793 | 13 |
2489055 | 2489055 | 2022-05-09 | Marshall | South Dakota | 46091 | 793 | 13 |
2485798 | 2485798 | 2022-05-08 | Marshall | South Dakota | 46091 | 793 | 13 |
2482540 | 2482540 | 2022-05-07 | Marshall | South Dakota | 46091 | 793 | 13 |
2479282 | 2479282 | 2022-05-06 | Marshall | South Dakota | 46091 | 793 | 13 |
2476024 | 2476024 | 2022-05-05 | Marshall | South Dakota | 46091 | 793 | 13 |
2472767 | 2472767 | 2022-05-04 | Marshall | South Dakota | 46091 | 793 | 13 |
2383350 | 2383350 | 2022-04-07 | Woodson | Kansas | 20207 | 793 | 15 |
2380095 | 2380095 | 2022-04-06 | Woodson | Kansas | 20207 | 793 | 15 |
2376840 | 2376840 | 2022-04-05 | Woodson | Kansas | 20207 | 793 | 15 |
2373588 | 2373588 | 2022-04-04 | Woodson | Kansas | 20207 | 793 | 15 |
2370335 | 2370335 | 2022-04-03 | Woodson | Kansas | 20207 | 793 | 15 |
2367082 | 2367082 | 2022-04-02 | Woodson | Kansas | 20207 | 793 | 15 |
2363829 | 2363829 | 2022-04-01 | Woodson | Kansas | 20207 | 793 | 15 |
2360542 | 2360542 | 2022-03-31 | Osborne | Kansas | 20141 | 793 | 17 |
2360575 | 2360575 | 2022-03-31 | Woodson | Kansas | 20207 | 793 | 15 |
2357288 | 2357288 | 2022-03-30 | Osborne | Kansas | 20141 | 793 | 17 |
2357321 | 2357321 | 2022-03-30 | Woodson | Kansas | 20207 | 793 | 15 |
2354035 | 2354035 | 2022-03-29 | Osborne | Kansas | 20141 | 793 | 17 |
2354068 | 2354068 | 2022-03-29 | Woodson | Kansas | 20207 | 793 | 15 |
2350783 | 2350783 | 2022-03-28 | Osborne | Kansas | 20141 | 793 | 17 |
2350816 | 2350816 | 2022-03-28 | Woodson | Kansas | 20207 | 793 | 15 |
2347530 | 2347530 | 2022-03-27 | Osborne | Kansas | 20141 | 793 | 17 |
2344277 | 2344277 | 2022-03-26 | Osborne | Kansas | 20141 | 793 | 17 |
2341024 | 2341024 | 2022-03-25 | Osborne | Kansas | 20141 | 793 | 17 |
2337771 | 2337771 | 2022-03-24 | Osborne | Kansas | 20141 | 793 | 17 |
2334517 | 2334517 | 2022-03-23 | Osborne | Kansas | 20141 | 793 | 17 |
2331263 | 2331263 | 2022-03-22 | Osborne | Kansas | 20141 | 793 | 17 |
2328011 | 2328011 | 2022-03-21 | Osborne | Kansas | 20141 | 793 | 17 |
2324758 | 2324758 | 2022-03-20 | Osborne | Kansas | 20141 | 793 | 17 |
2321504 | 2321504 | 2022-03-19 | Osborne | Kansas | 20141 | 793 | 17 |
2318250 | 2318250 | 2022-03-18 | Osborne | Kansas | 20141 | 793 | 17 |
2314997 | 2314997 | 2022-03-17 | Osborne | Kansas | 20141 | 793 | 16 |
2311744 | 2311744 | 2022-03-16 | Osborne | Kansas | 20141 | 793 | 16 |
2279257 | 2279257 | 2022-03-06 | Woodson | Kansas | 20207 | 793 | 12 |
2276004 | 2276004 | 2022-03-05 | Woodson | Kansas | 20207 | 793 | 12 |
2272751 | 2272751 | 2022-03-04 | Woodson | Kansas | 20207 | 793 | 12 |
2266979 | 2266979 | 2022-03-02 | Nance | Nebraska | 31125 | 793 | 10 |
2263728 | 2263728 | 2022-03-01 | Nance | Nebraska | 31125 | 793 | 10 |
2260477 | 2260477 | 2022-02-28 | Nance | Nebraska | 31125 | 793 | 10 |
2243082 | 2243082 | 2022-02-23 | Oneida | Idaho | 16071 | 793 | 11 |
2239831 | 2239831 | 2022-02-22 | Oneida | Idaho | 16071 | 793 | 11 |
2194765 | 2194765 | 2022-02-08 | Hickman | Kentucky | 21105 | 793 | 22 |
2164501 | 2164501 | 2022-01-30 | Aleutians East Borough | Alaska | 2013 | 793 | 3 |
2161246 | 2161246 | 2022-01-29 | Aleutians East Borough | Alaska | 2013 | 793 | 3 |
2161470 | 2161470 | 2022-01-29 | Ouray | Colorado | 8091 | 793 | 6 |
2157990 | 2157990 | 2022-01-28 | Aleutians East Borough | Alaska | 2013 | 793 | 3 |
2160744 | 2160744 | 2022-01-28 | Reagan | Texas | 48383 | 793 | 12 |
2154961 | 2154961 | 2022-01-27 | Ouray | Colorado | 8091 | 793 | 6 |
2126939 | 2126939 | 2022-01-18 | Knox | Missouri | 29103 | 793 | 10 |
2107525 | 2107525 | 2022-01-12 | Musselshell | Montana | 30065 | 793 | 26 |
2104274 | 2104274 | 2022-01-11 | Musselshell | Montana | 30065 | 793 | 26 |
2101222 | 2101222 | 2022-01-10 | Union | New Mexico | 35059 | 793 | 12 |
2099173 | 2099173 | 2022-01-09 | Surry | Virginia | 51181 | 793 | 13 |
2095583 | 2095583 | 2022-01-08 | Garza | Texas | 48169 | 793 | 25 |
2095922 | 2095922 | 2022-01-08 | Surry | Virginia | 51181 | 793 | 13 |
2092670 | 2092670 | 2022-01-07 | Surry | Virginia | 51181 | 793 | 13 |
2087955 | 2087955 | 2022-01-06 | Putnam | Missouri | 29171 | 793 | 20 |
2076036 | 2076036 | 2022-01-02 | Concho | Texas | 48095 | 793 | 10 |
2072785 | 2072785 | 2022-01-01 | Concho | Texas | 48095 | 793 | 10 |
2069534 | 2069534 | 2021-12-31 | Concho | Texas | 48095 | 793 | 10 |
2066283 | 2066283 | 2021-12-30 | Concho | Texas | 48095 | 793 | 10 |
2032813 | 2032813 | 2021-12-20 | Fillmore | Nebraska | 31059 | 793 | 13 |
2013363 | 2013363 | 2021-12-14 | Thayer | Nebraska | 31169 | 793 | 8 |
1998033 | 1998033 | 2021-12-09 | Crockett | Texas | 48105 | 793 | 17 |
1994782 | 1994782 | 2021-12-08 | Crockett | Texas | 48105 | 793 | 17 |
1991531 | 1991531 | 2021-12-07 | Crockett | Texas | 48105 | 793 | 17 |
1988091 | 1988091 | 2021-12-06 | Gregory | South Dakota | 46053 | 793 | 31 |
1988280 | 1988280 | 2021-12-06 | Crockett | Texas | 48105 | 793 | 17 |
1984055 | 1984055 | 2021-12-05 | Furnas | Nebraska | 31065 | 793 | 5 |
1985030 | 1985030 | 2021-12-05 | Crockett | Texas | 48105 | 793 | 17 |
1980805 | 1980805 | 2021-12-04 | Furnas | Nebraska | 31065 | 793 | 5 |
1981780 | 1981780 | 2021-12-04 | Crockett | Texas | 48105 | 793 | 17 |
1977555 | 1977555 | 2021-12-03 | Furnas | Nebraska | 31065 | 793 | 5 |
1963151 | 1963151 | 2021-11-29 | Saguache | Colorado | 8109 | 793 | 9 |
1943439 | 1943439 | 2021-11-23 | Yukon-Koyukuk Census Area | Alaska | 2290 | 793 | 7 |
1937482 | 1937482 | 2021-11-21 | Henderson | Illinois | 17071 | 793 | 23 |
1934232 | 1934232 | 2021-11-20 | Henderson | Illinois | 17071 | 793 | 23 |
1930981 | 1930981 | 2021-11-19 | Henderson | Illinois | 17071 | 793 | 23 |
1928061 | 1928061 | 2021-11-18 | Ottawa | Kansas | 20143 | 793 | 14 |
1924811 | 1924811 | 2021-11-17 | Ottawa | Kansas | 20143 | 793 | 14 |
1921197 | 1921197 | 2021-11-16 | Alexander | Illinois | 17003 | 793 | 13 |
1915745 | 1915745 | 2021-11-14 | Pondera | Montana | 30073 | 793 | 6 |
1912495 | 1912495 | 2021-11-13 | Pondera | Montana | 30073 | 793 | 6 |
1909245 | 1909245 | 2021-11-12 | Pondera | Montana | 30073 | 793 | 6 |
1906096 | 1906096 | 2021-11-11 | Sheridan | Nebraska | 31161 | 793 | 23 |
1902847 | 1902847 | 2021-11-10 | Sheridan | Nebraska | 31161 | 793 | 23 |
1898411 | 1898411 | 2021-11-09 | Boise | Idaho | 16015 | 793 | 10 |
1899435 | 1899435 | 2021-11-09 | Reynolds | Missouri | 29179 | 793 | 9 |
1895184 | 1895184 | 2021-11-08 | Lewis | Idaho | 16061 | 793 | 22 |
1896185 | 1896185 | 2021-11-08 | Reynolds | Missouri | 29179 | 793 | 9 |
1892935 | 1892935 | 2021-11-07 | Reynolds | Missouri | 29179 | 793 | 9 |
1889685 | 1889685 | 2021-11-06 | Reynolds | Missouri | 29179 | 793 | 9 |
1886435 | 1886435 | 2021-11-05 | Reynolds | Missouri | 29179 | 793 | 9 |
1883186 | 1883186 | 2021-11-04 | Reynolds | Missouri | 29179 | 793 | 9 |
1875354 | 1875354 | 2021-11-02 | Clear Creek | Colorado | 8019 | 793 | 5 |
1876057 | 1876057 | 2021-11-02 | Mitchell | Kansas | 20123 | 793 | 16 |
1876081 | 1876081 | 2021-11-02 | Scott | Kansas | 20171 | 793 | 28 |
1872808 | 1872808 | 2021-11-01 | Mitchell | Kansas | 20123 | 793 | 16 |
1872832 | 1872832 | 2021-11-01 | Scott | Kansas | 20171 | 793 | 28 |
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);