ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
680 rows where cases = 464 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 68
- Kansas 55
- Missouri 52
- Texas 45
- Georgia 28
- Virginia 25
- Kentucky 21
- North Carolina 21
- Puerto Rico 20
- Illinois 19
- North Dakota 19
- Iowa 18
- Montana 16
- Alaska 14
- Minnesota 14
- Ohio 14
- Wisconsin 14
- Idaho 13
- Nebraska 13
- Oregon 13
- Alabama 12
- Indiana 12
- West Virginia 12
- Louisiana 11
- Michigan 11
- South Carolina 10
- Tennessee 10
- Colorado 9
- New York 9
- Oklahoma 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500510 | 2500510 | 2022-05-13 | Hamilton | Kansas | 20075 | 464 | 3 |
2497252 | 2497252 | 2022-05-12 | Hamilton | Kansas | 20075 | 464 | 3 |
2493994 | 2493994 | 2022-05-11 | Hamilton | Kansas | 20075 | 464 | 3 |
2490736 | 2490736 | 2022-05-10 | Hamilton | Kansas | 20075 | 464 | 3 |
2487479 | 2487479 | 2022-05-09 | Hamilton | Kansas | 20075 | 464 | 3 |
2484221 | 2484221 | 2022-05-08 | Hamilton | Kansas | 20075 | 464 | 3 |
2480963 | 2480963 | 2022-05-07 | Hamilton | Kansas | 20075 | 464 | 3 |
2477705 | 2477705 | 2022-05-06 | Hamilton | Kansas | 20075 | 464 | 3 |
2474447 | 2474447 | 2022-05-05 | Hamilton | Kansas | 20075 | 464 | 3 |
2471190 | 2471190 | 2022-05-04 | Hamilton | Kansas | 20075 | 464 | 3 |
2467934 | 2467934 | 2022-05-03 | Hamilton | Kansas | 20075 | 464 | 3 |
2464679 | 2464679 | 2022-05-02 | Hamilton | Kansas | 20075 | 464 | 3 |
2461423 | 2461423 | 2022-05-01 | Hamilton | Kansas | 20075 | 464 | 3 |
2458167 | 2458167 | 2022-04-30 | Hamilton | Kansas | 20075 | 464 | 3 |
2454911 | 2454911 | 2022-04-29 | Hamilton | Kansas | 20075 | 464 | 3 |
2451655 | 2451655 | 2022-04-28 | Hamilton | Kansas | 20075 | 464 | 3 |
2448399 | 2448399 | 2022-04-27 | Hamilton | Kansas | 20075 | 464 | 3 |
2445143 | 2445143 | 2022-04-26 | Hamilton | Kansas | 20075 | 464 | 3 |
2441887 | 2441887 | 2022-04-25 | Hamilton | Kansas | 20075 | 464 | 3 |
2438631 | 2438631 | 2022-04-24 | Hamilton | Kansas | 20075 | 464 | 3 |
2435375 | 2435375 | 2022-04-23 | Hamilton | Kansas | 20075 | 464 | 3 |
2432119 | 2432119 | 2022-04-22 | Hamilton | Kansas | 20075 | 464 | 3 |
2428863 | 2428863 | 2022-04-21 | Hamilton | Kansas | 20075 | 464 | 3 |
2425607 | 2425607 | 2022-04-20 | Hamilton | Kansas | 20075 | 464 | 3 |
2427326 | 2427326 | 2022-04-20 | Briscoe | Texas | 48045 | 464 | 8 |
2422351 | 2422351 | 2022-04-19 | Hamilton | Kansas | 20075 | 464 | 3 |
2419095 | 2419095 | 2022-04-18 | Hamilton | Kansas | 20075 | 464 | 3 |
2415839 | 2415839 | 2022-04-17 | Hamilton | Kansas | 20075 | 464 | 3 |
2412583 | 2412583 | 2022-04-16 | Hamilton | Kansas | 20075 | 464 | 3 |
2409327 | 2409327 | 2022-04-15 | Hamilton | Kansas | 20075 | 464 | 3 |
2262088 | 2262088 | 2022-03-01 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 464 | 5 |
2258837 | 2258837 | 2022-02-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 464 | 5 |
2255586 | 2255586 | 2022-02-27 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 464 | 5 |
2252335 | 2252335 | 2022-02-26 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 464 | 5 |
2249084 | 2249084 | 2022-02-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 464 | 5 |
2147545 | 2147545 | 2022-01-24 | Armstrong | Texas | 48011 | 464 | 8 |
2142234 | 2142234 | 2022-01-23 | Custer | Idaho | 16037 | 464 | 7 |
2142567 | 2142567 | 2022-01-23 | Clark | Kansas | 20025 | 464 | 7 |
2138979 | 2138979 | 2022-01-22 | Custer | Idaho | 16037 | 464 | 7 |
2139312 | 2139312 | 2022-01-22 | Clark | Kansas | 20025 | 464 | 7 |
2136056 | 2136056 | 2022-01-21 | Clark | Kansas | 20025 | 464 | 7 |
2134575 | 2134575 | 2022-01-20 | Culberson | Texas | 48109 | 464 | 13 |
2128458 | 2128458 | 2022-01-18 | Columbia | Washington | 53013 | 464 | 10 |
2089070 | 2089070 | 2022-01-06 | Fisher | Texas | 48151 | 464 | 20 |
2056348 | 2056348 | 2021-12-27 | Faulk | South Dakota | 46049 | 464 | 16 |
2053099 | 2053099 | 2021-12-26 | Faulk | South Dakota | 46049 | 464 | 15 |
2049849 | 2049849 | 2021-12-25 | Faulk | South Dakota | 46049 | 464 | 15 |
2046599 | 2046599 | 2021-12-24 | Faulk | South Dakota | 46049 | 464 | 15 |
2043349 | 2043349 | 2021-12-23 | Faulk | South Dakota | 46049 | 464 | 15 |
2040100 | 2040100 | 2021-12-22 | Faulk | South Dakota | 46049 | 464 | 15 |
2036369 | 2036369 | 2021-12-21 | Adams | North Dakota | 38001 | 464 | 8 |
2026665 | 2026665 | 2021-12-18 | Towner | North Dakota | 38095 | 464 | 11 |
2023414 | 2023414 | 2021-12-17 | Towner | North Dakota | 38095 | 464 | 11 |
2020163 | 2020163 | 2021-12-16 | Towner | North Dakota | 38095 | 464 | 11 |
2017330 | 2017330 | 2021-12-15 | Buffalo | South Dakota | 46017 | 464 | 16 |
2012569 | 2012569 | 2021-12-14 | Morton | Kansas | 20129 | 464 | 10 |
2009318 | 2009318 | 2021-12-13 | Morton | Kansas | 20129 | 464 | 10 |
2003448 | 2003448 | 2021-12-11 | Scotland | Missouri | 29199 | 464 | 15 |
2000198 | 2000198 | 2021-12-10 | Scotland | Missouri | 29199 | 464 | 15 |
1989852 | 1989852 | 2021-12-07 | Woodson | Kansas | 20207 | 464 | 10 |
1986602 | 1986602 | 2021-12-06 | Woodson | Kansas | 20207 | 464 | 10 |
1988131 | 1988131 | 2021-12-06 | Ziebach | South Dakota | 46137 | 464 | 10 |
1983352 | 1983352 | 2021-12-05 | Woodson | Kansas | 20207 | 464 | 10 |
1984881 | 1984881 | 2021-12-05 | Ziebach | South Dakota | 46137 | 464 | 10 |
1980102 | 1980102 | 2021-12-04 | Woodson | Kansas | 20207 | 464 | 10 |
1981631 | 1981631 | 2021-12-04 | Ziebach | South Dakota | 46137 | 464 | 10 |
1976852 | 1976852 | 2021-12-03 | Woodson | Kansas | 20207 | 464 | 10 |
1978381 | 1978381 | 2021-12-03 | Ziebach | South Dakota | 46137 | 464 | 10 |
1975131 | 1975131 | 2021-12-02 | Ziebach | South Dakota | 46137 | 464 | 10 |
1971882 | 1971882 | 2021-12-01 | Ziebach | South Dakota | 46137 | 464 | 10 |
1968574 | 1968574 | 2021-11-30 | Buffalo | South Dakota | 46017 | 464 | 15 |
1968632 | 1968632 | 2021-11-30 | Ziebach | South Dakota | 46137 | 464 | 10 |
1964415 | 1964415 | 2021-11-29 | Mercer | Missouri | 29129 | 464 | 9 |
1965323 | 1965323 | 2021-11-29 | Buffalo | South Dakota | 46017 | 464 | 15 |
1965369 | 1965369 | 2021-11-29 | Potter | South Dakota | 46107 | 464 | 5 |
1962071 | 1962071 | 2021-11-28 | Buffalo | South Dakota | 46017 | 464 | 15 |
1958820 | 1958820 | 2021-11-27 | Buffalo | South Dakota | 46017 | 464 | 15 |
1955569 | 1955569 | 2021-11-26 | Buffalo | South Dakota | 46017 | 464 | 15 |
1952318 | 1952318 | 2021-11-25 | Buffalo | South Dakota | 46017 | 464 | 15 |
1949067 | 1949067 | 2021-11-24 | Buffalo | South Dakota | 46017 | 464 | 15 |
1943430 | 1943430 | 2021-11-23 | Petersburg Borough | Alaska | 2195 | 464 | 2 |
1945816 | 1945816 | 2021-11-23 | Buffalo | South Dakota | 46017 | 464 | 15 |
1940180 | 1940180 | 2021-11-22 | Petersburg Borough | Alaska | 2195 | 464 | 2 |
1942565 | 1942565 | 2021-11-22 | Buffalo | South Dakota | 46017 | 464 | 15 |
1929614 | 1929614 | 2021-11-18 | Stanley | South Dakota | 46117 | 464 | 3 |
1903761 | 1903761 | 2021-11-10 | Cochran | Texas | 48079 | 464 | 18 |
1900511 | 1900511 | 2021-11-09 | Cochran | Texas | 48079 | 464 | 18 |
1884102 | 1884102 | 2021-11-04 | Marshall | South Dakota | 46091 | 464 | 8 |
1880853 | 1880853 | 2021-11-03 | Marshall | South Dakota | 46091 | 464 | 8 |
1870228 | 1870228 | 2021-10-31 | Fallon | Montana | 30025 | 464 | 5 |
1870360 | 1870360 | 2021-10-31 | Valley | Nebraska | 31175 | 464 | 4 |
1870632 | 1870632 | 2021-10-31 | McIntosh | North Dakota | 38051 | 464 | 8 |
1866979 | 1866979 | 2021-10-30 | Fallon | Montana | 30025 | 464 | 5 |
1867111 | 1867111 | 2021-10-30 | Valley | Nebraska | 31175 | 464 | 4 |
1863730 | 1863730 | 2021-10-29 | Fallon | Montana | 30025 | 464 | 5 |
1863862 | 1863862 | 2021-10-29 | Valley | Nebraska | 31175 | 464 | 4 |
1864936 | 1864936 | 2021-10-29 | Shackelford | Texas | 48417 | 464 | 5 |
1860613 | 1860613 | 2021-10-28 | Valley | Nebraska | 31175 | 464 | 4 |
1857364 | 1857364 | 2021-10-27 | Valley | Nebraska | 31175 | 464 | 4 |
1851572 | 1851572 | 2021-10-25 | Bennett | South Dakota | 46007 | 464 | 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);