ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
669 rows where cases = 400 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 48
- Kansas 33
- North Dakota 32
- Georgia 30
- Virginia 30
- South Dakota 28
- Colorado 27
- Kentucky 26
- Minnesota 26
- Nebraska 24
- Alaska 23
- Missouri 22
- Puerto Rico 22
- California 20
- Idaho 20
- Oklahoma 20
- Montana 19
- Illinois 18
- Tennessee 14
- Iowa 13
- Michigan 13
- Alabama 12
- Ohio 11
- Utah 11
- Indiana 10
- Mississippi 9
- New Mexico 9
- Pennsylvania 9
- Washington 8
- Arkansas 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491516 | 2491516 | 2022-05-10 | Harlan | Nebraska | 31083 | 400 | 3 |
2488258 | 2488258 | 2022-05-09 | Harlan | Nebraska | 31083 | 400 | 3 |
2485001 | 2485001 | 2022-05-08 | Harlan | Nebraska | 31083 | 400 | 3 |
2481743 | 2481743 | 2022-05-07 | Harlan | Nebraska | 31083 | 400 | 3 |
2478485 | 2478485 | 2022-05-06 | Harlan | Nebraska | 31083 | 400 | 3 |
2475227 | 2475227 | 2022-05-05 | Harlan | Nebraska | 31083 | 400 | 3 |
2452435 | 2452435 | 2022-04-28 | Harlan | Nebraska | 31083 | 400 | 3 |
2449179 | 2449179 | 2022-04-27 | Harlan | Nebraska | 31083 | 400 | 3 |
2445922 | 2445922 | 2022-04-26 | Harlan | Nebraska | 31083 | 400 | 3 |
2421488 | 2421488 | 2022-04-19 | Denali Borough | Alaska | 2068 | 400 | 1 |
2418232 | 2418232 | 2022-04-18 | Denali Borough | Alaska | 2068 | 400 | 1 |
2414976 | 2414976 | 2022-04-17 | Denali Borough | Alaska | 2068 | 400 | 1 |
2411720 | 2411720 | 2022-04-16 | Denali Borough | Alaska | 2068 | 400 | 1 |
2408464 | 2408464 | 2022-04-15 | Denali Borough | Alaska | 2068 | 400 | 1 |
2405208 | 2405208 | 2022-04-14 | Denali Borough | Alaska | 2068 | 400 | 1 |
2401953 | 2401953 | 2022-04-13 | Denali Borough | Alaska | 2068 | 400 | 1 |
2398698 | 2398698 | 2022-04-12 | Denali Borough | Alaska | 2068 | 400 | 1 |
2395443 | 2395443 | 2022-04-11 | Denali Borough | Alaska | 2068 | 400 | 1 |
2392187 | 2392187 | 2022-04-10 | Denali Borough | Alaska | 2068 | 400 | 1 |
2388931 | 2388931 | 2022-04-09 | Denali Borough | Alaska | 2068 | 400 | 1 |
2385676 | 2385676 | 2022-04-08 | Denali Borough | Alaska | 2068 | 400 | 1 |
2382421 | 2382421 | 2022-04-07 | Denali Borough | Alaska | 2068 | 400 | 1 |
2379166 | 2379166 | 2022-04-06 | Denali Borough | Alaska | 2068 | 400 | 1 |
2224627 | 2224627 | 2022-02-17 | Meagher | Montana | 30059 | 400 | 10 |
2221376 | 2221376 | 2022-02-16 | Meagher | Montana | 30059 | 400 | 10 |
2218125 | 2218125 | 2022-02-15 | Meagher | Montana | 30059 | 400 | 10 |
2165372 | 2165372 | 2022-01-30 | Hodgeman | Kansas | 20083 | 400 | 10 |
2162117 | 2162117 | 2022-01-29 | Hodgeman | Kansas | 20083 | 400 | 10 |
2158862 | 2158862 | 2022-01-28 | Hodgeman | Kansas | 20083 | 400 | 10 |
2155666 | 2155666 | 2022-01-27 | Wallace | Kansas | 20199 | 400 | 5 |
2152413 | 2152413 | 2022-01-26 | Wallace | Kansas | 20199 | 400 | 5 |
2148258 | 2148258 | 2022-01-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 400 | 5 |
2148708 | 2148708 | 2022-01-25 | Webster | Georgia | 13307 | 400 | 7 |
2145006 | 2145006 | 2022-01-24 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 400 | 5 |
2144168 | 2144168 | 2022-01-23 | McPherson | South Dakota | 46089 | 400 | 9 |
2140913 | 2140913 | 2022-01-22 | McPherson | South Dakota | 46089 | 400 | 9 |
2137657 | 2137657 | 2022-01-21 | McPherson | South Dakota | 46089 | 400 | 9 |
2132885 | 2132885 | 2022-01-20 | Stanton | Kansas | 20187 | 400 | 7 |
2133907 | 2133907 | 2022-01-20 | Burke | North Dakota | 38013 | 400 | 3 |
2134543 | 2134543 | 2022-01-20 | Briscoe | Texas | 48045 | 400 | 8 |
2129632 | 2129632 | 2022-01-19 | Stanton | Kansas | 20187 | 400 | 7 |
2126386 | 2126386 | 2022-01-18 | Wichita | Kansas | 20203 | 400 | 8 |
2123134 | 2123134 | 2022-01-17 | Wichita | Kansas | 20203 | 400 | 8 |
2124627 | 2124627 | 2022-01-17 | Haakon | South Dakota | 46055 | 400 | 11 |
2119882 | 2119882 | 2022-01-16 | Wichita | Kansas | 20203 | 400 | 8 |
2121375 | 2121375 | 2022-01-16 | Haakon | South Dakota | 46055 | 400 | 11 |
2116630 | 2116630 | 2022-01-15 | Wichita | Kansas | 20203 | 400 | 8 |
2118123 | 2118123 | 2022-01-15 | Haakon | South Dakota | 46055 | 400 | 11 |
2113379 | 2113379 | 2022-01-14 | Wichita | Kansas | 20203 | 400 | 8 |
2114872 | 2114872 | 2022-01-14 | Haakon | South Dakota | 46055 | 400 | 11 |
2115214 | 2115214 | 2022-01-14 | Schleicher | Texas | 48413 | 400 | 9 |
2111152 | 2111152 | 2022-01-13 | Golden Valley | North Dakota | 38033 | 400 | 4 |
2103196 | 2103196 | 2022-01-11 | Butte | Idaho | 16023 | 400 | 7 |
2099945 | 2099945 | 2022-01-10 | Butte | Idaho | 16023 | 400 | 7 |
2101887 | 2101887 | 2022-01-10 | Miner | South Dakota | 46097 | 400 | 12 |
2098636 | 2098636 | 2022-01-09 | Miner | South Dakota | 46097 | 400 | 12 |
2095384 | 2095384 | 2022-01-08 | Miner | South Dakota | 46097 | 400 | 12 |
2095636 | 2095636 | 2022-01-08 | Knox | Texas | 48275 | 400 | 22 |
2092132 | 2092132 | 2022-01-07 | Miner | South Dakota | 46097 | 400 | 12 |
2080260 | 2080260 | 2022-01-04 | Baker | Georgia | 13007 | 400 | 14 |
2075184 | 2075184 | 2022-01-02 | De Baca | New Mexico | 35011 | 400 | 3 |
2071933 | 2071933 | 2022-01-01 | De Baca | New Mexico | 35011 | 400 | 3 |
2068682 | 2068682 | 2021-12-31 | De Baca | New Mexico | 35011 | 400 | 3 |
2065431 | 2065431 | 2021-12-30 | De Baca | New Mexico | 35011 | 400 | 3 |
2059138 | 2059138 | 2021-12-28 | Kidder | North Dakota | 38043 | 400 | 13 |
2055889 | 2055889 | 2021-12-27 | Kidder | North Dakota | 38043 | 400 | 13 |
2052639 | 2052639 | 2021-12-26 | Kidder | North Dakota | 38043 | 400 | 13 |
2049389 | 2049389 | 2021-12-25 | Kidder | North Dakota | 38043 | 400 | 13 |
2046139 | 2046139 | 2021-12-24 | Kidder | North Dakota | 38043 | 400 | 13 |
2042889 | 2042889 | 2021-12-23 | Kidder | North Dakota | 38043 | 400 | 13 |
2039640 | 2039640 | 2021-12-22 | Kidder | North Dakota | 38043 | 400 | 13 |
2040418 | 2040418 | 2021-12-22 | Oldham | Texas | 48359 | 400 | 6 |
2037168 | 2037168 | 2021-12-21 | Oldham | Texas | 48359 | 400 | 6 |
1986704 | 1986704 | 2021-12-06 | Robertson | Kentucky | 21201 | 400 | 16 |
1984031 | 1984031 | 2021-12-05 | Brown | Nebraska | 31017 | 400 | 4 |
1980781 | 1980781 | 2021-12-04 | Brown | Nebraska | 31017 | 400 | 4 |
1977531 | 1977531 | 2021-12-03 | Brown | Nebraska | 31017 | 400 | 4 |
1964684 | 1964684 | 2021-11-29 | Mora | New Mexico | 35033 | 400 | 12 |
1960176 | 1960176 | 2021-11-28 | Custer | Idaho | 16037 | 400 | 6 |
1956925 | 1956925 | 2021-11-27 | Custer | Idaho | 16037 | 400 | 6 |
1943921 | 1943921 | 2021-11-23 | Custer | Idaho | 16037 | 400 | 6 |
1907025 | 1907025 | 2021-11-11 | Culberson | Texas | 48109 | 400 | 11 |
1903776 | 1903776 | 2021-11-10 | Culberson | Texas | 48109 | 400 | 11 |
1900526 | 1900526 | 2021-11-09 | Culberson | Texas | 48109 | 400 | 11 |
1892980 | 1892980 | 2021-11-07 | Granite | Montana | 30039 | 400 | 5 |
1889730 | 1889730 | 2021-11-06 | Granite | Montana | 30039 | 400 | 5 |
1886480 | 1886480 | 2021-11-05 | Granite | Montana | 30039 | 400 | 5 |
1884094 | 1884094 | 2021-11-04 | Jackson | South Dakota | 46071 | 400 | 16 |
1880845 | 1880845 | 2021-11-03 | Jackson | South Dakota | 46071 | 400 | 16 |
1853356 | 1853356 | 2021-10-26 | Woodson | Kansas | 20207 | 400 | 9 |
1850107 | 1850107 | 2021-10-25 | Woodson | Kansas | 20207 | 400 | 9 |
1803688 | 1803688 | 2021-10-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 400 | 0 |
1783395 | 1783395 | 2021-10-04 | Stanley | South Dakota | 46117 | 400 | 3 |
1780146 | 1780146 | 2021-10-03 | Stanley | South Dakota | 46117 | 400 | 3 |
1776896 | 1776896 | 2021-10-02 | Stanley | South Dakota | 46117 | 400 | 3 |
1777289 | 1777289 | 2021-10-02 | Essex | Vermont | 50009 | 400 | 2 |
1773646 | 1773646 | 2021-10-01 | Stanley | South Dakota | 46117 | 400 | 3 |
1770576 | 1770576 | 2021-09-30 | Fisher | Texas | 48151 | 400 | 16 |
1763551 | 1763551 | 2021-09-28 | Ellis | Oklahoma | 40045 | 400 | 6 |
1760302 | 1760302 | 2021-09-27 | Ellis | Oklahoma | 40045 | 400 | 6 |
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);