ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
431 rows where cases = 917 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 32
- Georgia 30
- Virginia 22
- Texas 20
- Illinois 18
- Iowa 18
- Kansas 18
- Kentucky 17
- Nebraska 17
- Wisconsin 15
- Tennessee 14
- South Dakota 13
- Alaska 12
- Colorado 12
- Utah 12
- Minnesota 11
- Mississippi 11
- North Carolina 11
- Arkansas 10
- Montana 10
- Alabama 9
- Louisiana 9
- Missouri 9
- North Dakota 8
- Indiana 7
- South Carolina 7
- New York 6
- Ohio 6
- Wyoming 6
- Idaho 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501225 | 2501225 | 2022-05-13 | Musselshell | Montana | 30065 | 917 | 31 |
2467089 | 2467089 | 2022-05-03 | Unknown | Alaska | 917 | 1 | |
2463834 | 2463834 | 2022-05-02 | Unknown | Alaska | 917 | 1 | |
2460578 | 2460578 | 2022-05-01 | Unknown | Alaska | 917 | 1 | |
2457322 | 2457322 | 2022-04-30 | Unknown | Alaska | 917 | 1 | |
2454066 | 2454066 | 2022-04-29 | Unknown | Alaska | 917 | 1 | |
2450810 | 2450810 | 2022-04-28 | Unknown | Alaska | 917 | 1 | |
2447554 | 2447554 | 2022-04-27 | Unknown | Alaska | 917 | 1 | |
2287651 | 2287651 | 2022-03-08 | Garfield | Utah | 49017 | 917 | 14 |
2284399 | 2284399 | 2022-03-07 | Garfield | Utah | 49017 | 917 | 14 |
2281147 | 2281147 | 2022-03-06 | Garfield | Utah | 49017 | 917 | 14 |
2277894 | 2277894 | 2022-03-05 | Garfield | Utah | 49017 | 917 | 14 |
2274641 | 2274641 | 2022-03-04 | Garfield | Utah | 49017 | 917 | 14 |
2249108 | 2249108 | 2022-02-25 | Calhoun | Arkansas | 5013 | 917 | 9 |
2240628 | 2240628 | 2022-02-22 | Red Lake | Minnesota | 27125 | 917 | 12 |
2237377 | 2237377 | 2022-02-21 | Red Lake | Minnesota | 27125 | 917 | 12 |
2234126 | 2234126 | 2022-02-20 | Red Lake | Minnesota | 27125 | 917 | 12 |
2230875 | 2230875 | 2022-02-19 | Red Lake | Minnesota | 27125 | 917 | 12 |
2227624 | 2227624 | 2022-02-18 | Red Lake | Minnesota | 27125 | 917 | 12 |
2224373 | 2224373 | 2022-02-17 | Red Lake | Minnesota | 27125 | 917 | 12 |
2217871 | 2217871 | 2022-02-15 | Red Lake | Minnesota | 27125 | 917 | 11 |
2195487 | 2195487 | 2022-02-08 | Mineral | Nevada | 32021 | 917 | 15 |
2172117 | 2172117 | 2022-02-01 | Tensas | Louisiana | 22107 | 917 | 10 |
2168710 | 2168710 | 2022-01-31 | Carlisle | Kentucky | 21039 | 917 | 16 |
2170648 | 2170648 | 2022-01-31 | Covington city | Virginia | 51580 | 917 | 21 |
2146275 | 2146275 | 2022-01-24 | Kittson | Minnesota | 27069 | 917 | 26 |
2147728 | 2147728 | 2022-01-24 | Presidio | Texas | 48377 | 917 | 32 |
2125976 | 2125976 | 2022-01-18 | Lewis | Idaho | 16061 | 917 | 23 |
2114422 | 2114422 | 2022-01-14 | Pierce | North Dakota | 38069 | 917 | 29 |
2110134 | 2110134 | 2022-01-13 | Ballard | Kentucky | 21007 | 917 | 26 |
2088112 | 2088112 | 2022-01-06 | Polk | Nebraska | 31143 | 917 | 18 |
2073994 | 2073994 | 2022-01-02 | Gallatin | Illinois | 17059 | 917 | 11 |
2070743 | 2070743 | 2022-01-01 | Gallatin | Illinois | 17059 | 917 | 11 |
2067492 | 2067492 | 2021-12-31 | Gallatin | Illinois | 17059 | 917 | 11 |
2064241 | 2064241 | 2021-12-30 | Gallatin | Illinois | 17059 | 917 | 11 |
2053093 | 2053093 | 2021-12-26 | Day | South Dakota | 46037 | 917 | 30 |
2049843 | 2049843 | 2021-12-25 | Day | South Dakota | 46037 | 917 | 30 |
2046593 | 2046593 | 2021-12-24 | Day | South Dakota | 46037 | 917 | 30 |
2043343 | 2043343 | 2021-12-23 | Day | South Dakota | 46037 | 917 | 30 |
2035321 | 2035321 | 2021-12-21 | Mitchell | Kansas | 20123 | 917 | 17 |
2032071 | 2032071 | 2021-12-20 | Mitchell | Kansas | 20123 | 917 | 17 |
2005361 | 2005361 | 2021-12-12 | Clear Creek | Colorado | 8019 | 917 | 7 |
2002110 | 2002110 | 2021-12-11 | Clear Creek | Colorado | 8019 | 917 | 7 |
1998860 | 1998860 | 2021-12-10 | Clear Creek | Colorado | 8019 | 917 | 7 |
1990533 | 1990533 | 2021-12-07 | Burt | Nebraska | 31021 | 917 | 13 |
1987283 | 1987283 | 2021-12-06 | Burt | Nebraska | 31021 | 917 | 13 |
1983436 | 1983436 | 2021-12-05 | Menifee | Kentucky | 21165 | 917 | 23 |
1980186 | 1980186 | 2021-12-04 | Menifee | Kentucky | 21165 | 917 | 23 |
1976936 | 1976936 | 2021-12-03 | Menifee | Kentucky | 21165 | 917 | 23 |
1973546 | 1973546 | 2021-12-02 | Kearny | Kansas | 20093 | 917 | 17 |
1970296 | 1970296 | 2021-12-01 | Kearny | Kansas | 20093 | 917 | 17 |
1971183 | 1971183 | 2021-12-01 | Los Alamos | New Mexico | 35028 | 917 | 10 |
1968627 | 1968627 | 2021-11-30 | Tripp | South Dakota | 46123 | 917 | 20 |
1964591 | 1964591 | 2021-11-29 | Pierce | Nebraska | 31139 | 917 | 21 |
1964676 | 1964676 | 2021-11-29 | Guadalupe | New Mexico | 35019 | 917 | 15 |
1930930 | 1930930 | 2021-11-19 | Lemhi | Idaho | 16059 | 917 | 20 |
1927680 | 1927680 | 2021-11-18 | Lemhi | Idaho | 16059 | 917 | 20 |
1926313 | 1926313 | 2021-11-17 | Brule | South Dakota | 46015 | 917 | 11 |
1894526 | 1894526 | 2021-11-07 | Iron | Wisconsin | 55051 | 917 | 42 |
1890144 | 1890144 | 2021-11-06 | Sioux | North Dakota | 38085 | 917 | 16 |
1891276 | 1891276 | 2021-11-06 | Iron | Wisconsin | 55051 | 917 | 42 |
1888026 | 1888026 | 2021-11-05 | Iron | Wisconsin | 55051 | 917 | 42 |
1878587 | 1878587 | 2021-11-03 | Trinity | California | 6105 | 917 | 11 |
1870631 | 1870631 | 2021-10-31 | McHenry | North Dakota | 38049 | 917 | 23 |
1867086 | 1867086 | 2021-10-30 | Nemaha | Nebraska | 31127 | 917 | 15 |
1863837 | 1863837 | 2021-10-29 | Nemaha | Nebraska | 31127 | 917 | 15 |
1860588 | 1860588 | 2021-10-28 | Nemaha | Nebraska | 31127 | 917 | 15 |
1857339 | 1857339 | 2021-10-27 | Nemaha | Nebraska | 31127 | 917 | 15 |
1838900 | 1838900 | 2021-10-21 | Mitchell | Texas | 48335 | 917 | 39 |
1822254 | 1822254 | 2021-10-16 | Rincon | Puerto Rico | 72117 | 917 | |
1819005 | 1819005 | 2021-10-15 | Rincon | Puerto Rico | 72117 | 917 | |
1815756 | 1815756 | 2021-10-14 | Rincon | Puerto Rico | 72117 | 917 | |
1810185 | 1810185 | 2021-10-13 | Aleutians West Census Area | Alaska | 2016 | 917 | 0 |
1812508 | 1812508 | 2021-10-13 | Rincon | Puerto Rico | 72117 | 917 | |
1806936 | 1806936 | 2021-10-12 | Aleutians West Census Area | Alaska | 2016 | 917 | 0 |
1809259 | 1809259 | 2021-10-12 | Rincon | Puerto Rico | 72117 | 917 | |
1806009 | 1806009 | 2021-10-11 | Rincon | Puerto Rico | 72117 | 917 | |
1802759 | 1802759 | 2021-10-10 | Rincon | Puerto Rico | 72117 | 917 | |
1799510 | 1799510 | 2021-10-09 | Rincon | Puerto Rico | 72117 | 917 | |
1796261 | 1796261 | 2021-10-08 | Rincon | Puerto Rico | 72117 | 917 | |
1793012 | 1793012 | 2021-10-07 | Rincon | Puerto Rico | 72117 | 917 | |
1789763 | 1789763 | 2021-10-06 | Rincon | Puerto Rico | 72117 | 917 | |
1790565 | 1790565 | 2021-10-06 | Menominee | Wisconsin | 55078 | 917 | 11 |
1785789 | 1785789 | 2021-10-05 | Toole | Montana | 30101 | 917 | 11 |
1786515 | 1786515 | 2021-10-05 | Rincon | Puerto Rico | 72117 | 917 | |
1783266 | 1783266 | 2021-10-04 | Rincon | Puerto Rico | 72117 | 917 | |
1780017 | 1780017 | 2021-10-03 | Rincon | Puerto Rico | 72117 | 917 | |
1767453 | 1767453 | 2021-09-29 | Sabine | Texas | 48403 | 917 | 67 |
1760929 | 1760929 | 2021-09-27 | Newton | Texas | 48351 | 917 | 46 |
1745035 | 1745035 | 2021-09-22 | Webster | West Virginia | 54101 | 917 | 13 |
1737050 | 1737050 | 2021-09-20 | Stillwater | Montana | 30095 | 917 | 17 |
1715750 | 1715750 | 2021-09-13 | Clay | West Virginia | 54015 | 917 | 12 |
1710024 | 1710024 | 2021-09-12 | Edwards | Illinois | 17047 | 917 | 14 |
1710959 | 1710959 | 2021-09-12 | Maries | Missouri | 29125 | 917 | 15 |
1706777 | 1706777 | 2021-09-11 | Edwards | Illinois | 17047 | 917 | 14 |
1703529 | 1703529 | 2021-09-10 | Edwards | Illinois | 17047 | 917 | 14 |
1699737 | 1699737 | 2021-09-09 | Nome Census Area | Alaska | 2180 | 917 | 0 |
1696488 | 1696488 | 2021-09-08 | Nome Census Area | Alaska | 2180 | 917 | 0 |
1696151 | 1696151 | 2021-09-07 | Lancaster | Virginia | 51103 | 917 | 19 |
1690593 | 1690593 | 2021-09-06 | Schuyler | Illinois | 17169 | 917 | 19 |
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);