ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
519 rows where cases = 825 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 44
- Georgia 41
- Kentucky 28
- Puerto Rico 25
- Colorado 23
- North Carolina 23
- Kansas 22
- North Dakota 22
- Missouri 20
- Wisconsin 18
- Arkansas 14
- Minnesota 14
- Virginia 14
- Montana 13
- Illinois 12
- Michigan 12
- Louisiana 11
- Nebraska 11
- Alabama 10
- Indiana 10
- Mississippi 10
- New Jersey 10
- South Dakota 10
- West Virginia 10
- Iowa 8
- Vermont 8
- Idaho 7
- Oregon 7
- South Carolina 7
- Tennessee 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324845 | 2324845 | 2022-03-20 | Hickman | Kentucky | 21105 | 825 | 24 |
2321591 | 2321591 | 2022-03-19 | Hickman | Kentucky | 21105 | 825 | 24 |
2318337 | 2318337 | 2022-03-18 | Hickman | Kentucky | 21105 | 825 | 24 |
2315084 | 2315084 | 2022-03-17 | Hickman | Kentucky | 21105 | 825 | 24 |
2311831 | 2311831 | 2022-03-16 | Hickman | Kentucky | 21105 | 825 | 24 |
2307773 | 2307773 | 2022-03-15 | Baca | Colorado | 8009 | 825 | 8 |
2308578 | 2308578 | 2022-03-15 | Hickman | Kentucky | 21105 | 825 | 24 |
2304522 | 2304522 | 2022-03-14 | Baca | Colorado | 8009 | 825 | 8 |
2305327 | 2305327 | 2022-03-14 | Hickman | Kentucky | 21105 | 825 | 24 |
2301270 | 2301270 | 2022-03-13 | Baca | Colorado | 8009 | 825 | 8 |
2298018 | 2298018 | 2022-03-12 | Baca | Colorado | 8009 | 825 | 8 |
2294766 | 2294766 | 2022-03-11 | Baca | Colorado | 8009 | 825 | 8 |
2291514 | 2291514 | 2022-03-10 | Baca | Colorado | 8009 | 825 | 8 |
2266651 | 2266651 | 2022-03-02 | Traverse | Minnesota | 27155 | 825 | 10 |
2261601 | 2261601 | 2022-02-28 | Upton | Texas | 48461 | 825 | 17 |
2258350 | 2258350 | 2022-02-27 | Upton | Texas | 48461 | 825 | 17 |
2255099 | 2255099 | 2022-02-26 | Upton | Texas | 48461 | 825 | 17 |
2239328 | 2239328 | 2022-02-22 | Unknown | Alaska | 825 | 1 | |
2236077 | 2236077 | 2022-02-21 | Unknown | Alaska | 825 | 1 | |
2237998 | 2237998 | 2022-02-21 | Bowman | North Dakota | 38011 | 825 | 9 |
2232826 | 2232826 | 2022-02-20 | Unknown | Alaska | 825 | 1 | |
2234747 | 2234747 | 2022-02-20 | Bowman | North Dakota | 38011 | 825 | 9 |
2229575 | 2229575 | 2022-02-19 | Unknown | Alaska | 825 | 1 | |
2231352 | 2231352 | 2022-02-19 | Hamilton | New York | 36041 | 825 | 5 |
2231496 | 2231496 | 2022-02-19 | Bowman | North Dakota | 38011 | 825 | 9 |
2226324 | 2226324 | 2022-02-18 | Unknown | Alaska | 825 | 1 | |
2228245 | 2228245 | 2022-02-18 | Bowman | North Dakota | 38011 | 825 | 9 |
2210269 | 2210269 | 2022-02-13 | Ouray | Colorado | 8091 | 825 | 6 |
2210929 | 2210929 | 2022-02-13 | Logan | Kansas | 20109 | 825 | 12 |
2212646 | 2212646 | 2022-02-13 | Coke | Texas | 48081 | 825 | 19 |
2207016 | 2207016 | 2022-02-12 | Ouray | Colorado | 8091 | 825 | 6 |
2207676 | 2207676 | 2022-02-12 | Logan | Kansas | 20109 | 825 | 12 |
2209393 | 2209393 | 2022-02-12 | Coke | Texas | 48081 | 825 | 19 |
2203763 | 2203763 | 2022-02-11 | Ouray | Colorado | 8091 | 825 | 6 |
2204423 | 2204423 | 2022-02-11 | Logan | Kansas | 20109 | 825 | 12 |
2201170 | 2201170 | 2022-02-10 | Logan | Kansas | 20109 | 825 | 12 |
2197916 | 2197916 | 2022-02-09 | Logan | Kansas | 20109 | 825 | 12 |
2133614 | 2133614 | 2022-01-20 | Johnson | Nebraska | 31097 | 825 | 10 |
2126409 | 2126409 | 2022-01-18 | Carlisle | Kentucky | 21039 | 825 | 15 |
2102049 | 2102049 | 2022-01-10 | Concho | Texas | 48095 | 825 | 10 |
2102392 | 2102392 | 2022-01-10 | Norton city | Virginia | 51720 | 825 | 20 |
2080545 | 2080545 | 2022-01-04 | Putnam | Illinois | 17155 | 825 | 8 |
2072463 | 2072463 | 2022-01-01 | Ceiba | Puerto Rico | 72037 | 825 | |
2069212 | 2069212 | 2021-12-31 | Ceiba | Puerto Rico | 72037 | 825 | |
1977870 | 1977870 | 2021-12-03 | Dunn | North Dakota | 38025 | 825 | 7 |
1973234 | 1973234 | 2021-12-02 | Gallatin | Illinois | 17059 | 825 | 10 |
1960560 | 1960560 | 2021-11-28 | Morris | Kansas | 20127 | 825 | 22 |
1957309 | 1957309 | 2021-11-27 | Morris | Kansas | 20127 | 825 | 22 |
1954058 | 1954058 | 2021-11-26 | Morris | Kansas | 20127 | 825 | 22 |
1950435 | 1950435 | 2021-11-25 | Lewis | Idaho | 16061 | 825 | 23 |
1950807 | 1950807 | 2021-11-25 | Morris | Kansas | 20127 | 825 | 22 |
1947184 | 1947184 | 2021-11-24 | Lewis | Idaho | 16061 | 825 | 23 |
1947556 | 1947556 | 2021-11-24 | Morris | Kansas | 20127 | 825 | 22 |
1899586 | 1899586 | 2021-11-09 | Pierce | Nebraska | 31139 | 825 | 21 |
1896246 | 1896246 | 2021-11-08 | Phillips | Montana | 30071 | 825 | 24 |
1892996 | 1892996 | 2021-11-07 | Phillips | Montana | 30071 | 825 | 24 |
1889746 | 1889746 | 2021-11-06 | Phillips | Montana | 30071 | 825 | 24 |
1890469 | 1890469 | 2021-11-06 | Lajas | Puerto Rico | 72079 | 825 | |
1886496 | 1886496 | 2021-11-05 | Phillips | Montana | 30071 | 825 | 24 |
1887219 | 1887219 | 2021-11-05 | Lajas | Puerto Rico | 72079 | 825 | |
1884077 | 1884077 | 2021-11-04 | Day | South Dakota | 46037 | 825 | 30 |
1880817 | 1880817 | 2021-11-03 | Brule | South Dakota | 46015 | 825 | 11 |
1870319 | 1870319 | 2021-10-31 | Jefferson | Nebraska | 31095 | 825 | 3 |
1860207 | 1860207 | 2021-10-28 | Grant | Minnesota | 27051 | 825 | 9 |
1860807 | 1860807 | 2021-10-28 | Hyde | North Carolina | 37095 | 825 | 12 |
1857558 | 1857558 | 2021-10-27 | Hyde | North Carolina | 37095 | 825 | 12 |
1858674 | 1858674 | 2021-10-27 | Ferry | Washington | 53019 | 825 | 15 |
1854309 | 1854309 | 2021-10-26 | Hyde | North Carolina | 37095 | 825 | 12 |
1851060 | 1851060 | 2021-10-25 | Hyde | North Carolina | 37095 | 825 | 12 |
1847810 | 1847810 | 2021-10-24 | Hyde | North Carolina | 37095 | 825 | 12 |
1844560 | 1844560 | 2021-10-23 | Hyde | North Carolina | 37095 | 825 | 12 |
1841310 | 1841310 | 2021-10-22 | Hyde | North Carolina | 37095 | 825 | 12 |
1838061 | 1838061 | 2021-10-21 | Hyde | North Carolina | 37095 | 825 | 12 |
1834812 | 1834812 | 2021-10-20 | Hyde | North Carolina | 37095 | 825 | 12 |
1824043 | 1824043 | 2021-10-17 | Gray | Kansas | 20069 | 825 | 16 |
1820794 | 1820794 | 2021-10-16 | Gray | Kansas | 20069 | 825 | 16 |
1817545 | 1817545 | 2021-10-15 | Gray | Kansas | 20069 | 825 | 16 |
1787520 | 1787520 | 2021-10-06 | Lafayette | Arkansas | 5073 | 825 | 13 |
1783551 | 1783551 | 2021-10-04 | Crane | Texas | 48103 | 825 | 16 |
1784109 | 1784109 | 2021-10-04 | Hot Springs | Wyoming | 56017 | 825 | 7 |
1770399 | 1770399 | 2021-09-30 | Tripp | South Dakota | 46123 | 825 | 18 |
1738914 | 1738914 | 2021-09-21 | Kit Carson | Colorado | 8063 | 825 | 14 |
1735140 | 1735140 | 2021-09-19 | Madison | Virginia | 51113 | 825 | 17 |
1731890 | 1731890 | 2021-09-18 | Madison | Virginia | 51113 | 825 | 17 |
1728640 | 1728640 | 2021-09-17 | Madison | Virginia | 51113 | 825 | 17 |
1718684 | 1718684 | 2021-09-14 | Mitchell | Texas | 48335 | 825 | 33 |
1701180 | 1701180 | 2021-09-09 | Dade | Missouri | 29057 | 825 | 17 |
1697931 | 1697931 | 2021-09-08 | Dade | Missouri | 29057 | 825 | 17 |
1698064 | 1698064 | 2021-09-08 | Sanders | Montana | 30089 | 825 | 16 |
1694249 | 1694249 | 2021-09-07 | Nicholas | Kentucky | 21181 | 825 | 10 |
1691721 | 1691721 | 2021-09-06 | Unknown | New Jersey | 825 | 0 | |
1677842 | 1677842 | 2021-09-02 | Greenwood | Kansas | 20073 | 825 | 11 |
1673870 | 1673870 | 2021-09-01 | Mariposa | California | 6043 | 825 | 10 |
1674595 | 1674595 | 2021-09-01 | Greenwood | Kansas | 20073 | 825 | 11 |
1671657 | 1671657 | 2021-08-31 | Alcona | Michigan | 26001 | 825 | 36 |
1672075 | 1672075 | 2021-08-31 | Stillwater | Montana | 30095 | 825 | 16 |
1668410 | 1668410 | 2021-08-30 | Alcona | Michigan | 26001 | 825 | 36 |
1668613 | 1668613 | 2021-08-30 | Jefferson | Mississippi | 28063 | 825 | 31 |
1669945 | 1669945 | 2021-08-30 | Marion | Texas | 48315 | 825 | 35 |
1664914 | 1664914 | 2021-08-29 | Wabaunsee | Kansas | 20197 | 825 | 16 |
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);