ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
312 rows where deaths = 454 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Michigan 25
- California 21
- Georgia 19
- Louisiana 19
- Pennsylvania 19
- Ohio 13
- Illinois 12
- North Carolina 12
- Arizona 11
- Connecticut 11
- Indiana 10
- Florida 8
- New Mexico 8
- Oklahoma 8
- South Carolina 8
- Iowa 7
- Mississippi 7
- Colorado 6
- New York 6
- Alabama 5
- Minnesota 5
- Delaware 4
- Missouri 4
- Nebraska 4
- Virginia 4
- Kansas 3
- Washington 3
- Alaska 2
- Arkansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421913 | 2421913 | 2022-04-19 | Newton | Georgia | 13217 | 24620 | 454 |
2418657 | 2418657 | 2022-04-18 | Newton | Georgia | 13217 | 24620 | 454 |
2415401 | 2415401 | 2022-04-17 | Newton | Georgia | 13217 | 24619 | 454 |
2412145 | 2412145 | 2022-04-16 | Newton | Georgia | 13217 | 24619 | 454 |
2408889 | 2408889 | 2022-04-15 | Newton | Georgia | 13217 | 24619 | 454 |
2372899 | 2372899 | 2022-04-04 | Litchfield | Connecticut | 9005 | 31731 | 454 |
2369646 | 2369646 | 2022-04-03 | Litchfield | Connecticut | 9005 | 31641 | 454 |
2366393 | 2366393 | 2022-04-02 | Litchfield | Connecticut | 9005 | 31641 | 454 |
2363140 | 2363140 | 2022-04-01 | Litchfield | Connecticut | 9005 | 31641 | 454 |
2359886 | 2359886 | 2022-03-31 | Litchfield | Connecticut | 9005 | 31625 | 454 |
2361484 | 2361484 | 2022-03-31 | Alamance | North Carolina | 37001 | 46705 | 454 |
2356632 | 2356632 | 2022-03-30 | Litchfield | Connecticut | 9005 | 31612 | 454 |
2358230 | 2358230 | 2022-03-30 | Alamance | North Carolina | 37001 | 46699 | 454 |
2353379 | 2353379 | 2022-03-29 | Litchfield | Connecticut | 9005 | 31589 | 454 |
2350127 | 2350127 | 2022-03-28 | Litchfield | Connecticut | 9005 | 31579 | 454 |
2346874 | 2346874 | 2022-03-27 | Litchfield | Connecticut | 9005 | 31521 | 454 |
2343621 | 2343621 | 2022-03-26 | Litchfield | Connecticut | 9005 | 31521 | 454 |
2340368 | 2340368 | 2022-03-25 | Litchfield | Connecticut | 9005 | 31521 | 454 |
2325236 | 2325236 | 2022-03-20 | Jackson | Mississippi | 28059 | 36803 | 454 |
2321982 | 2321982 | 2022-03-19 | Jackson | Mississippi | 28059 | 36803 | 454 |
2318728 | 2318728 | 2022-03-18 | Jackson | Mississippi | 28059 | 36803 | 454 |
2315475 | 2315475 | 2022-03-17 | Jackson | Mississippi | 28059 | 36803 | 454 |
2312222 | 2312222 | 2022-03-16 | Jackson | Mississippi | 28059 | 36803 | 454 |
2308969 | 2308969 | 2022-03-15 | Jackson | Mississippi | 28059 | 36803 | 454 |
2305718 | 2305718 | 2022-03-14 | Jackson | Mississippi | 28059 | 36803 | 454 |
2284859 | 2284859 | 2022-03-08 | Coconino | Arizona | 4005 | 43086 | 454 |
2281607 | 2281607 | 2022-03-07 | Coconino | Arizona | 4005 | 43086 | 454 |
2278354 | 2278354 | 2022-03-06 | Coconino | Arizona | 4005 | 43086 | 454 |
2275101 | 2275101 | 2022-03-05 | Coconino | Arizona | 4005 | 43086 | 454 |
2271848 | 2271848 | 2022-03-04 | Coconino | Arizona | 4005 | 43086 | 454 |
2268596 | 2268596 | 2022-03-03 | Coconino | Arizona | 4005 | 43086 | 454 |
2271284 | 2271284 | 2022-03-03 | Maverick | Texas | 48323 | 20648 | 454 |
2265343 | 2265343 | 2022-03-02 | Coconino | Arizona | 4005 | 43086 | 454 |
2262798 | 2262798 | 2022-03-01 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2263753 | 2263753 | 2022-03-01 | Unknown | Nebraska | 4356 | 454 | |
2259547 | 2259547 | 2022-02-28 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2256296 | 2256296 | 2022-02-27 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2253045 | 2253045 | 2022-02-26 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2249794 | 2249794 | 2022-02-25 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2246543 | 2246543 | 2022-02-24 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2243292 | 2243292 | 2022-02-23 | Black Hawk | Iowa | 19013 | 32381 | 454 |
2244407 | 2244407 | 2022-02-23 | Cabarrus | North Carolina | 37025 | 54756 | 454 |
2233164 | 2233164 | 2022-02-20 | Coweta | Georgia | 13077 | 32627 | 454 |
2233865 | 2233865 | 2022-02-20 | Bossier | Louisiana | 22015 | 37141 | 454 |
2229913 | 2229913 | 2022-02-19 | Coweta | Georgia | 13077 | 32627 | 454 |
2230614 | 2230614 | 2022-02-19 | Bossier | Louisiana | 22015 | 37141 | 454 |
2226662 | 2226662 | 2022-02-18 | Coweta | Georgia | 13077 | 32627 | 454 |
2227363 | 2227363 | 2022-02-18 | Bossier | Louisiana | 22015 | 37141 | 454 |
2210258 | 2210258 | 2022-02-13 | Larimer | Colorado | 8069 | 71780 | 454 |
2212796 | 2212796 | 2022-02-13 | Randall | Texas | 48381 | 37226 | 454 |
2207005 | 2207005 | 2022-02-12 | Larimer | Colorado | 8069 | 71780 | 454 |
2209543 | 2209543 | 2022-02-12 | Randall | Texas | 48381 | 37226 | 454 |
2203752 | 2203752 | 2022-02-11 | Larimer | Colorado | 8069 | 71780 | 454 |
2206290 | 2206290 | 2022-02-11 | Randall | Texas | 48381 | 37226 | 454 |
2200499 | 2200499 | 2022-02-10 | Larimer | Colorado | 8069 | 71579 | 454 |
2202312 | 2202312 | 2022-02-10 | Greene | Ohio | 39057 | 36519 | 454 |
2197140 | 2197140 | 2022-02-09 | Sebastian | Arkansas | 5131 | 31911 | 454 |
2199058 | 2199058 | 2022-02-09 | Greene | Ohio | 39057 | 36463 | 454 |
2195804 | 2195804 | 2022-02-08 | Greene | Ohio | 39057 | 36390 | 454 |
2189935 | 2189935 | 2022-02-06 | Hays | Texas | 48209 | 55312 | 454 |
2186682 | 2186682 | 2022-02-05 | Hays | Texas | 48209 | 55196 | 454 |
2183430 | 2183430 | 2022-02-04 | Hays | Texas | 48209 | 54852 | 454 |
2178112 | 2178112 | 2022-02-03 | McHenry | Illinois | 17111 | 70588 | 454 |
2180178 | 2180178 | 2022-02-03 | Hays | Texas | 48209 | 54668 | 454 |
2174859 | 2174859 | 2022-02-02 | McHenry | Illinois | 17111 | 70588 | 454 |
2176927 | 2176927 | 2022-02-02 | Hays | Texas | 48209 | 54454 | 454 |
2154739 | 2154739 | 2022-01-27 | Anchorage | Alaska | 2020 | 88435 | 454 |
2156746 | 2156746 | 2022-01-27 | Clermont | Ohio | 39025 | 48129 | 454 |
2151486 | 2151486 | 2022-01-26 | Anchorage | Alaska | 2020 | 88435 | 454 |
2153493 | 2153493 | 2022-01-26 | Clermont | Ohio | 39025 | 47765 | 454 |
2150241 | 2150241 | 2022-01-25 | Clermont | Ohio | 39025 | 47044 | 454 |
2142349 | 2142349 | 2022-01-23 | Tazewell | Illinois | 17179 | 33202 | 454 |
2139094 | 2139094 | 2022-01-22 | Tazewell | Illinois | 17179 | 33202 | 454 |
2135838 | 2135838 | 2022-01-21 | Tazewell | Illinois | 17179 | 33202 | 454 |
2091927 | 2091927 | 2022-01-07 | Lycoming | Pennsylvania | 42081 | 22651 | 454 |
2087052 | 2087052 | 2022-01-06 | Rock Island | Illinois | 17161 | 25541 | 454 |
2083800 | 2083800 | 2022-01-05 | Rock Island | Illinois | 17161 | 25366 | 454 |
2080548 | 2080548 | 2022-01-04 | Rock Island | Illinois | 17161 | 24998 | 454 |
2077296 | 2077296 | 2022-01-03 | Rock Island | Illinois | 17161 | 24773 | 454 |
2078013 | 2078013 | 2022-01-03 | St. Louis | Minnesota | 27137 | 33042 | 454 |
2054146 | 2054146 | 2021-12-27 | Mesa | Colorado | 8077 | 29998 | 454 |
2040960 | 2040960 | 2021-12-23 | Cochise | Arizona | 4003 | 19676 | 454 |
2037710 | 2037710 | 2021-12-22 | Cochise | Arizona | 4003 | 19644 | 454 |
2036213 | 2036213 | 2021-12-21 | Broome | New York | 36007 | 31494 | 454 |
2036240 | 2036240 | 2021-12-21 | Niagara | New York | 36063 | 32224 | 454 |
2036286 | 2036286 | 2021-12-21 | Catawba | North Carolina | 37035 | 30641 | 454 |
2032963 | 2032963 | 2021-12-20 | Broome | New York | 36007 | 31380 | 454 |
2033036 | 2033036 | 2021-12-20 | Catawba | North Carolina | 37035 | 30596 | 454 |
2029786 | 2029786 | 2021-12-19 | Catawba | North Carolina | 37035 | 30433 | 454 |
2026535 | 2026535 | 2021-12-18 | Catawba | North Carolina | 37035 | 30433 | 454 |
2023284 | 2023284 | 2021-12-17 | Catawba | North Carolina | 37035 | 30433 | 454 |
2012860 | 2012860 | 2021-12-14 | Bay | Michigan | 26017 | 18373 | 454 |
2009609 | 2009609 | 2021-12-13 | Bay | Michigan | 26017 | 18373 | 454 |
2010970 | 2010970 | 2021-12-13 | Sumner | Tennessee | 47165 | 35847 | 454 |
1991181 | 1991181 | 2021-12-07 | Washington | Pennsylvania | 42125 | 31198 | 454 |
1987272 | 1987272 | 2021-12-06 | Yellowstone | Montana | 30111 | 31438 | 454 |
1960904 | 1960904 | 2021-11-28 | Muskegon | Michigan | 26121 | 27473 | 454 |
1957653 | 1957653 | 2021-11-27 | Muskegon | Michigan | 26121 | 27473 | 454 |
1954402 | 1954402 | 2021-11-26 | Muskegon | Michigan | 26121 | 27473 | 454 |
1951151 | 1951151 | 2021-11-25 | Muskegon | Michigan | 26121 | 27473 | 454 |
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);