ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
587 rows where cases = 563 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 61
- Puerto Rico 34
- Georgia 30
- Iowa 27
- Minnesota 24
- Oklahoma 24
- South Dakota 22
- Mississippi 21
- Virginia 21
- Michigan 20
- North Carolina 19
- North Dakota 19
- Montana 18
- Idaho 15
- Kansas 15
- Louisiana 14
- Missouri 14
- Indiana 13
- Kentucky 13
- Nevada 13
- Arizona 11
- Illinois 11
- Nebraska 11
- Washington 11
- Colorado 9
- Alabama 8
- Arkansas 8
- Tennessee 8
- Wyoming 8
- Oregon 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442297 | 2442297 | 2022-04-25 | Cook | Minnesota | 27031 | 563 | 4 |
2417715 | 2417715 | 2022-04-17 | Oldham | Texas | 48359 | 563 | 6 |
2414459 | 2414459 | 2022-04-16 | Oldham | Texas | 48359 | 563 | 6 |
2411203 | 2411203 | 2022-04-15 | Oldham | Texas | 48359 | 563 | 6 |
2407947 | 2407947 | 2022-04-14 | Oldham | Texas | 48359 | 563 | 6 |
2404691 | 2404691 | 2022-04-13 | Oldham | Texas | 48359 | 563 | 6 |
2401436 | 2401436 | 2022-04-12 | Oldham | Texas | 48359 | 563 | 6 |
2355558 | 2355558 | 2022-03-29 | Faulk | South Dakota | 46049 | 563 | 16 |
2352305 | 2352305 | 2022-03-28 | Faulk | South Dakota | 46049 | 563 | 16 |
2349053 | 2349053 | 2022-03-27 | Faulk | South Dakota | 46049 | 563 | 16 |
2345800 | 2345800 | 2022-03-26 | Faulk | South Dakota | 46049 | 563 | 16 |
2342547 | 2342547 | 2022-03-25 | Faulk | South Dakota | 46049 | 563 | 16 |
2339294 | 2339294 | 2022-03-24 | Faulk | South Dakota | 46049 | 563 | 16 |
2336040 | 2336040 | 2022-03-23 | Faulk | South Dakota | 46049 | 563 | 16 |
2312944 | 2312944 | 2022-03-16 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2309691 | 2309691 | 2022-03-15 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2306438 | 2306438 | 2022-03-14 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2303187 | 2303187 | 2022-03-13 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2299935 | 2299935 | 2022-03-12 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2296683 | 2296683 | 2022-03-11 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2293431 | 2293431 | 2022-03-10 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2261237 | 2261237 | 2022-02-28 | Hand | South Dakota | 46059 | 563 | 11 |
2256422 | 2256422 | 2022-02-27 | Graham | Kansas | 20065 | 563 | 13 |
2253171 | 2253171 | 2022-02-26 | Graham | Kansas | 20065 | 563 | 13 |
2249920 | 2249920 | 2022-02-25 | Graham | Kansas | 20065 | 563 | 13 |
2233657 | 2233657 | 2022-02-20 | Elk | Kansas | 20049 | 563 | 8 |
2230406 | 2230406 | 2022-02-19 | Elk | Kansas | 20049 | 563 | 8 |
2227155 | 2227155 | 2022-02-18 | Elk | Kansas | 20049 | 563 | 8 |
2223904 | 2223904 | 2022-02-17 | Elk | Kansas | 20049 | 563 | 8 |
2225008 | 2225008 | 2022-02-17 | Griggs | North Dakota | 38039 | 563 | 2 |
2220653 | 2220653 | 2022-02-16 | Elk | Kansas | 20049 | 563 | 8 |
2221757 | 2221757 | 2022-02-16 | Griggs | North Dakota | 38039 | 563 | 2 |
2218506 | 2218506 | 2022-02-15 | Griggs | North Dakota | 38039 | 563 | 2 |
2212499 | 2212499 | 2022-02-13 | Sanborn | South Dakota | 46111 | 563 | 6 |
2209246 | 2209246 | 2022-02-12 | Sanborn | South Dakota | 46111 | 563 | 6 |
2205993 | 2205993 | 2022-02-11 | Sanborn | South Dakota | 46111 | 563 | 6 |
2202740 | 2202740 | 2022-02-10 | Sanborn | South Dakota | 46111 | 563 | 6 |
2199486 | 2199486 | 2022-02-09 | Sanborn | South Dakota | 46111 | 563 | 6 |
2160628 | 2160628 | 2022-01-28 | Fisher | Texas | 48151 | 563 | 20 |
2081493 | 2081493 | 2022-01-04 | Fallon | Montana | 30025 | 563 | 10 |
2078274 | 2078274 | 2022-01-03 | Sheridan | Montana | 30091 | 563 | 10 |
2075023 | 2075023 | 2022-01-02 | Sheridan | Montana | 30091 | 563 | 10 |
2071772 | 2071772 | 2022-01-01 | Sheridan | Montana | 30091 | 563 | 10 |
2068521 | 2068521 | 2021-12-31 | Sheridan | Montana | 30091 | 563 | 10 |
2065270 | 2065270 | 2021-12-30 | Sheridan | Montana | 30091 | 563 | 10 |
2062020 | 2062020 | 2021-12-29 | Sheridan | Montana | 30091 | 563 | 10 |
2062866 | 2062866 | 2021-12-29 | Marshall | South Dakota | 46091 | 563 | 8 |
2058771 | 2058771 | 2021-12-28 | Sheridan | Montana | 30091 | 563 | 10 |
2058873 | 2058873 | 2021-12-28 | Webster | Nebraska | 31181 | 563 | 9 |
2054421 | 2054421 | 2021-12-27 | Adams | Idaho | 16003 | 563 | 14 |
2051171 | 2051171 | 2021-12-26 | Adams | Idaho | 16003 | 563 | 14 |
2047921 | 2047921 | 2021-12-25 | Adams | Idaho | 16003 | 563 | 14 |
2044671 | 2044671 | 2021-12-24 | Adams | Idaho | 16003 | 563 | 14 |
2041422 | 2041422 | 2021-12-23 | Adams | Idaho | 16003 | 563 | 14 |
2016726 | 2016726 | 2021-12-15 | Hamilton | New York | 36041 | 563 | 3 |
2006865 | 2006865 | 2021-12-12 | Valley | Nebraska | 31175 | 563 | 5 |
2003614 | 2003614 | 2021-12-11 | Valley | Nebraska | 31175 | 563 | 5 |
2000364 | 2000364 | 2021-12-10 | Valley | Nebraska | 31175 | 563 | 5 |
1997695 | 1997695 | 2021-12-09 | Arroyo | Puerto Rico | 72015 | 563 | |
1994444 | 1994444 | 2021-12-08 | Arroyo | Puerto Rico | 72015 | 563 | |
1991193 | 1991193 | 2021-12-07 | Arroyo | Puerto Rico | 72015 | 563 | |
1987621 | 1987621 | 2021-12-06 | Eddy | North Dakota | 38027 | 563 | 6 |
1987942 | 1987942 | 2021-12-06 | Arroyo | Puerto Rico | 72015 | 563 | |
1983258 | 1983258 | 2021-12-05 | Chautauqua | Kansas | 20019 | 563 | 12 |
1984371 | 1984371 | 2021-12-05 | Eddy | North Dakota | 38027 | 563 | 6 |
1980008 | 1980008 | 2021-12-04 | Chautauqua | Kansas | 20019 | 563 | 12 |
1981121 | 1981121 | 2021-12-04 | Eddy | North Dakota | 38027 | 563 | 6 |
1976758 | 1976758 | 2021-12-03 | Chautauqua | Kansas | 20019 | 563 | 12 |
1977871 | 1977871 | 2021-12-03 | Eddy | North Dakota | 38027 | 563 | 6 |
1966352 | 1966352 | 2021-11-30 | Baca | Colorado | 8009 | 563 | 6 |
1967044 | 1967044 | 2021-11-30 | Jewell | Kansas | 20089 | 563 | 11 |
1968319 | 1968319 | 2021-11-30 | Roger Mills | Oklahoma | 40129 | 563 | 12 |
1963792 | 1963792 | 2021-11-29 | Jewell | Kansas | 20089 | 563 | 11 |
1964026 | 1964026 | 2021-11-29 | Tensas | Louisiana | 22107 | 563 | 10 |
1965068 | 1965068 | 2021-11-29 | Roger Mills | Oklahoma | 40129 | 563 | 12 |
1961816 | 1961816 | 2021-11-28 | Roger Mills | Oklahoma | 40129 | 563 | 12 |
1958565 | 1958565 | 2021-11-27 | Roger Mills | Oklahoma | 40129 | 563 | 12 |
1955314 | 1955314 | 2021-11-26 | Roger Mills | Oklahoma | 40129 | 563 | 12 |
1952063 | 1952063 | 2021-11-25 | Roger Mills | Oklahoma | 40129 | 563 | 12 |
1948812 | 1948812 | 2021-11-24 | Roger Mills | Oklahoma | 40129 | 563 | 12 |
1919808 | 1919808 | 2021-11-15 | Aurora | South Dakota | 46003 | 563 | 17 |
1906339 | 1906339 | 2021-11-11 | Tyrrell | North Carolina | 37177 | 563 | 7 |
1906809 | 1906809 | 2021-11-11 | Aurora | South Dakota | 46003 | 563 | 17 |
1903090 | 1903090 | 2021-11-10 | Tyrrell | North Carolina | 37177 | 563 | 7 |
1903116 | 1903116 | 2021-11-10 | Emmons | North Dakota | 38029 | 563 | 16 |
1903477 | 1903477 | 2021-11-10 | Maunabo | Puerto Rico | 72095 | 563 | |
1903560 | 1903560 | 2021-11-10 | Aurora | South Dakota | 46003 | 563 | 17 |
1898439 | 1898439 | 2021-11-09 | Oneida | Idaho | 16071 | 563 | 9 |
1900227 | 1900227 | 2021-11-09 | Maunabo | Puerto Rico | 72095 | 563 | |
1896977 | 1896977 | 2021-11-08 | Maunabo | Puerto Rico | 72095 | 563 | |
1892751 | 1892751 | 2021-11-07 | Traverse | Minnesota | 27155 | 563 | 5 |
1893727 | 1893727 | 2021-11-07 | Maunabo | Puerto Rico | 72095 | 563 | |
1889501 | 1889501 | 2021-11-06 | Traverse | Minnesota | 27155 | 563 | 5 |
1889909 | 1889909 | 2021-11-06 | Unknown | New Jersey | 563 | 0 | |
1886251 | 1886251 | 2021-11-05 | Traverse | Minnesota | 27155 | 563 | 5 |
1886659 | 1886659 | 2021-11-05 | Unknown | New Jersey | 563 | 0 | |
1874816 | 1874816 | 2021-11-01 | Falls Church city | Virginia | 51610 | 563 | 12 |
1842138 | 1842138 | 2021-10-22 | Mason | Texas | 48319 | 563 | 7 |
1830289 | 1830289 | 2021-10-19 | Putnam | Illinois | 17155 | 563 | 5 |
1831437 | 1831437 | 2021-10-19 | Hidalgo | New Mexico | 35023 | 563 | 11 |
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);