ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
888 rows where cases = 221 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 118
- Georgia 54
- Kentucky 42
- Kansas 41
- Virginia 36
- Puerto Rico 32
- Missouri 26
- North Carolina 26
- Nebraska 25
- Tennessee 24
- Montana 23
- Alaska 22
- Indiana 22
- Ohio 21
- Washington 21
- Colorado 20
- Mississippi 20
- Oregon 20
- Iowa 19
- Louisiana 19
- West Virginia 18
- Minnesota 17
- South Dakota 16
- New York 15
- North Dakota 15
- California 14
- Florida 14
- Illinois 14
- Michigan 13
- Pennsylvania 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403520 | 2403520 | 2022-04-13 | Judith Basin | Montana | 30045 | 221 | 1 |
2400265 | 2400265 | 2022-04-12 | Judith Basin | Montana | 30045 | 221 | 1 |
2397010 | 2397010 | 2022-04-11 | Judith Basin | Montana | 30045 | 221 | 1 |
2393755 | 2393755 | 2022-04-10 | Judith Basin | Montana | 30045 | 221 | 1 |
2390499 | 2390499 | 2022-04-09 | Judith Basin | Montana | 30045 | 221 | 1 |
2387243 | 2387243 | 2022-04-08 | Judith Basin | Montana | 30045 | 221 | 1 |
2383988 | 2383988 | 2022-04-07 | Judith Basin | Montana | 30045 | 221 | 1 |
2380733 | 2380733 | 2022-04-06 | Judith Basin | Montana | 30045 | 221 | 1 |
2377478 | 2377478 | 2022-04-05 | Judith Basin | Montana | 30045 | 221 | 1 |
2374225 | 2374225 | 2022-04-04 | Judith Basin | Montana | 30045 | 221 | 1 |
2370973 | 2370973 | 2022-04-03 | Judith Basin | Montana | 30045 | 221 | 1 |
2367720 | 2367720 | 2022-04-02 | Judith Basin | Montana | 30045 | 221 | 1 |
2364467 | 2364467 | 2022-04-01 | Judith Basin | Montana | 30045 | 221 | 1 |
2361213 | 2361213 | 2022-03-31 | Judith Basin | Montana | 30045 | 221 | 1 |
2357959 | 2357959 | 2022-03-30 | Judith Basin | Montana | 30045 | 221 | 1 |
2336300 | 2336300 | 2022-03-23 | Jeff Davis | Texas | 48243 | 221 | 9 |
2333046 | 2333046 | 2022-03-22 | Jeff Davis | Texas | 48243 | 221 | 9 |
2329793 | 2329793 | 2022-03-21 | Jeff Davis | Texas | 48243 | 221 | 9 |
2326541 | 2326541 | 2022-03-20 | Jeff Davis | Texas | 48243 | 221 | 9 |
2323288 | 2323288 | 2022-03-19 | Jeff Davis | Texas | 48243 | 221 | 9 |
2320034 | 2320034 | 2022-03-18 | Jeff Davis | Texas | 48243 | 221 | 9 |
2316780 | 2316780 | 2022-03-17 | Jeff Davis | Texas | 48243 | 221 | 9 |
2313527 | 2313527 | 2022-03-16 | Jeff Davis | Texas | 48243 | 221 | 9 |
2310274 | 2310274 | 2022-03-15 | Jeff Davis | Texas | 48243 | 221 | 9 |
2307021 | 2307021 | 2022-03-14 | Jeff Davis | Texas | 48243 | 221 | 9 |
2303770 | 2303770 | 2022-03-13 | Jeff Davis | Texas | 48243 | 221 | 9 |
2300518 | 2300518 | 2022-03-12 | Jeff Davis | Texas | 48243 | 221 | 9 |
2297266 | 2297266 | 2022-03-11 | Jeff Davis | Texas | 48243 | 221 | 9 |
2294014 | 2294014 | 2022-03-10 | Jeff Davis | Texas | 48243 | 221 | 9 |
2290762 | 2290762 | 2022-03-09 | Jeff Davis | Texas | 48243 | 221 | 9 |
2287510 | 2287510 | 2022-03-08 | Jeff Davis | Texas | 48243 | 221 | 9 |
2284258 | 2284258 | 2022-03-07 | Jeff Davis | Texas | 48243 | 221 | 9 |
2281006 | 2281006 | 2022-03-06 | Jeff Davis | Texas | 48243 | 221 | 9 |
2277753 | 2277753 | 2022-03-05 | Jeff Davis | Texas | 48243 | 221 | 9 |
2274500 | 2274500 | 2022-03-04 | Jeff Davis | Texas | 48243 | 221 | 9 |
2271247 | 2271247 | 2022-03-03 | Jeff Davis | Texas | 48243 | 221 | 9 |
2267995 | 2267995 | 2022-03-02 | Jeff Davis | Texas | 48243 | 221 | 9 |
2264742 | 2264742 | 2022-03-01 | Jeff Davis | Texas | 48243 | 221 | 9 |
2261492 | 2261492 | 2022-02-28 | Jeff Davis | Texas | 48243 | 221 | 9 |
2258241 | 2258241 | 2022-02-27 | Jeff Davis | Texas | 48243 | 221 | 9 |
2254990 | 2254990 | 2022-02-26 | Jeff Davis | Texas | 48243 | 221 | 9 |
2251739 | 2251739 | 2022-02-25 | Jeff Davis | Texas | 48243 | 221 | 9 |
2248488 | 2248488 | 2022-02-24 | Jeff Davis | Texas | 48243 | 221 | 9 |
2245237 | 2245237 | 2022-02-23 | Jeff Davis | Texas | 48243 | 221 | 9 |
2241986 | 2241986 | 2022-02-22 | Jeff Davis | Texas | 48243 | 221 | 9 |
2238735 | 2238735 | 2022-02-21 | Jeff Davis | Texas | 48243 | 221 | 9 |
2235484 | 2235484 | 2022-02-20 | Jeff Davis | Texas | 48243 | 221 | 9 |
2232233 | 2232233 | 2022-02-19 | Jeff Davis | Texas | 48243 | 221 | 9 |
2218112 | 2218112 | 2022-02-15 | Garfield | Montana | 30033 | 221 | 3 |
2133338 | 2133338 | 2022-01-20 | Issaquena | Mississippi | 28055 | 221 | 7 |
2111370 | 2111370 | 2022-01-13 | Gilliam | Oregon | 41021 | 221 | 4 |
2111652 | 2111652 | 2022-01-13 | Sully | South Dakota | 46119 | 221 | 3 |
2111877 | 2111877 | 2022-01-13 | Jeff Davis | Texas | 48243 | 221 | 6 |
2108625 | 2108625 | 2022-01-12 | Jeff Davis | Texas | 48243 | 221 | 6 |
2105100 | 2105100 | 2022-01-11 | Campbell | South Dakota | 46021 | 221 | 6 |
2105468 | 2105468 | 2022-01-11 | Sterling | Texas | 48431 | 221 | 5 |
2073454 | 2073454 | 2022-01-02 | Wrangell City and Borough | Alaska | 2275 | 221 | 1 |
2070203 | 2070203 | 2022-01-01 | Wrangell City and Borough | Alaska | 2275 | 221 | 1 |
2066952 | 2066952 | 2021-12-31 | Wrangell City and Borough | Alaska | 2275 | 221 | 1 |
2063702 | 2063702 | 2021-12-30 | Wrangell City and Borough | Alaska | 2275 | 221 | 1 |
2060452 | 2060452 | 2021-12-29 | Wrangell City and Borough | Alaska | 2275 | 221 | 1 |
2051559 | 2051559 | 2021-12-26 | Lane | Kansas | 20101 | 221 | 10 |
2048309 | 2048309 | 2021-12-25 | Lane | Kansas | 20101 | 221 | 10 |
2045059 | 2045059 | 2021-12-24 | Lane | Kansas | 20101 | 221 | 10 |
2041810 | 2041810 | 2021-12-23 | Lane | Kansas | 20101 | 221 | 10 |
2038560 | 2038560 | 2021-12-22 | Lane | Kansas | 20101 | 221 | 10 |
2035310 | 2035310 | 2021-12-21 | Lane | Kansas | 20101 | 221 | 10 |
2032060 | 2032060 | 2021-12-20 | Lane | Kansas | 20101 | 221 | 10 |
2028809 | 2028809 | 2021-12-19 | Lane | Kansas | 20101 | 221 | 9 |
2025558 | 2025558 | 2021-12-18 | Lane | Kansas | 20101 | 221 | 9 |
2027533 | 2027533 | 2021-12-18 | Unknown | Vermont | 221 | 0 | |
2022307 | 2022307 | 2021-12-17 | Lane | Kansas | 20101 | 221 | 9 |
1989084 | 1989084 | 2021-12-07 | Sierra | California | 6091 | 221 | 0 |
1985834 | 1985834 | 2021-12-06 | Sierra | California | 6091 | 221 | 0 |
1915789 | 1915789 | 2021-11-14 | Deuel | Nebraska | 31049 | 221 | 2 |
1912539 | 1912539 | 2021-11-13 | Deuel | Nebraska | 31049 | 221 | 2 |
1909289 | 1909289 | 2021-11-12 | Deuel | Nebraska | 31049 | 221 | 2 |
1836183 | 1836183 | 2021-10-21 | Haines Borough | Alaska | 2100 | 221 | 0 |
1839003 | 1839003 | 2021-10-21 | Rich | Utah | 49033 | 221 | 0 |
1832934 | 1832934 | 2021-10-20 | Haines Borough | Alaska | 2100 | 221 | 0 |
1834472 | 1834472 | 2021-10-20 | Worth | Missouri | 29227 | 221 | 2 |
1835700 | 1835700 | 2021-10-20 | Stonewall | Texas | 48433 | 221 | 6 |
1835754 | 1835754 | 2021-10-20 | Rich | Utah | 49033 | 221 | 0 |
1829685 | 1829685 | 2021-10-19 | Haines Borough | Alaska | 2100 | 221 | 0 |
1826436 | 1826436 | 2021-10-18 | Haines Borough | Alaska | 2100 | 221 | 0 |
1823187 | 1823187 | 2021-10-17 | Haines Borough | Alaska | 2100 | 221 | 0 |
1819938 | 1819938 | 2021-10-16 | Haines Borough | Alaska | 2100 | 221 | 0 |
1816689 | 1816689 | 2021-10-15 | Haines Borough | Alaska | 2100 | 221 | 0 |
1813441 | 1813441 | 2021-10-14 | Haines Borough | Alaska | 2100 | 221 | 0 |
1810192 | 1810192 | 2021-10-13 | Haines Borough | Alaska | 2100 | 221 | 0 |
1806961 | 1806961 | 2021-10-12 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 221 | 2 |
1807130 | 1807130 | 2021-10-12 | Dolores | Colorado | 8033 | 221 | 2 |
1807781 | 1807781 | 2021-10-12 | Comanche | Kansas | 20033 | 221 | 11 |
1803879 | 1803879 | 2021-10-11 | Dolores | Colorado | 8033 | 221 | 2 |
1804530 | 1804530 | 2021-10-11 | Comanche | Kansas | 20033 | 221 | 11 |
1806293 | 1806293 | 2021-10-11 | Cottle | Texas | 48101 | 221 | 9 |
1803043 | 1803043 | 2021-10-10 | Cottle | Texas | 48101 | 221 | 9 |
1799794 | 1799794 | 2021-10-09 | Cottle | Texas | 48101 | 221 | 9 |
1796545 | 1796545 | 2021-10-08 | Cottle | Texas | 48101 | 221 | 9 |
1793296 | 1793296 | 2021-10-07 | Cottle | Texas | 48101 | 221 | 9 |
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);