ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
224 rows where deaths = 558 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 26
- California 17
- North Carolina 15
- Arizona 13
- Missouri 13
- Indiana 11
- Washington 11
- Illinois 10
- Ohio 10
- Pennsylvania 10
- Texas 10
- New Mexico 9
- Alabama 8
- South Carolina 8
- Maryland 7
- New Jersey 6
- Colorado 4
- Georgia 4
- Minnesota 4
- Mississippi 4
- New York 4
- Virginia 4
- Louisiana 3
- Idaho 2
- Oregon 2
- Tennessee 2
- Wisconsin 2
- Delaware 1
- Iowa 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375937 | 2375937 | 2022-04-05 | Cochise | Arizona | 4003 | 31305 | 558 |
2376220 | 2376220 | 2022-04-05 | St. Johns | Florida | 12109 | 62310 | 558 |
2376608 | 2376608 | 2022-04-05 | Porter | Indiana | 18127 | 37607 | 558 |
2372685 | 2372685 | 2022-04-04 | Cochise | Arizona | 4003 | 31305 | 558 |
2372968 | 2372968 | 2022-04-04 | St. Johns | Florida | 12109 | 62310 | 558 |
2373356 | 2373356 | 2022-04-04 | Porter | Indiana | 18127 | 37607 | 558 |
2369432 | 2369432 | 2022-04-03 | Cochise | Arizona | 4003 | 31305 | 558 |
2369715 | 2369715 | 2022-04-03 | St. Johns | Florida | 12109 | 62310 | 558 |
2370103 | 2370103 | 2022-04-03 | Porter | Indiana | 18127 | 37583 | 558 |
2366179 | 2366179 | 2022-04-02 | Cochise | Arizona | 4003 | 31305 | 558 |
2366462 | 2366462 | 2022-04-02 | St. Johns | Florida | 12109 | 62310 | 558 |
2366850 | 2366850 | 2022-04-02 | Porter | Indiana | 18127 | 37583 | 558 |
2362926 | 2362926 | 2022-04-01 | Cochise | Arizona | 4003 | 31305 | 558 |
2363209 | 2363209 | 2022-04-01 | St. Johns | Florida | 12109 | 62310 | 558 |
2363597 | 2363597 | 2022-04-01 | Porter | Indiana | 18127 | 37583 | 558 |
2359672 | 2359672 | 2022-03-31 | Cochise | Arizona | 4003 | 31305 | 558 |
2359955 | 2359955 | 2022-03-31 | St. Johns | Florida | 12109 | 62310 | 558 |
2360343 | 2360343 | 2022-03-31 | Porter | Indiana | 18127 | 37554 | 558 |
2356418 | 2356418 | 2022-03-30 | Cochise | Arizona | 4003 | 31305 | 558 |
2356701 | 2356701 | 2022-03-30 | St. Johns | Florida | 12109 | 62310 | 558 |
2357089 | 2357089 | 2022-03-30 | Porter | Indiana | 18127 | 37554 | 558 |
2353836 | 2353836 | 2022-03-29 | Porter | Indiana | 18127 | 37589 | 558 |
2348481 | 2348481 | 2022-03-27 | Buncombe | North Carolina | 37021 | 52110 | 558 |
2345228 | 2345228 | 2022-03-26 | Buncombe | North Carolina | 37021 | 52110 | 558 |
2341975 | 2341975 | 2022-03-25 | Buncombe | North Carolina | 37021 | 52110 | 558 |
2338722 | 2338722 | 2022-03-24 | Buncombe | North Carolina | 37021 | 52087 | 558 |
2309449 | 2309449 | 2022-03-15 | Catawba | North Carolina | 37035 | 47409 | 558 |
2302953 | 2302953 | 2022-03-13 | Cumberland | North Carolina | 37051 | 82477 | 558 |
2299701 | 2299701 | 2022-03-12 | Cumberland | North Carolina | 37051 | 82477 | 558 |
2296449 | 2296449 | 2022-03-11 | Cumberland | North Carolina | 37051 | 82477 | 558 |
2283657 | 2283657 | 2022-03-07 | Warren | Ohio | 39165 | 57326 | 558 |
2280405 | 2280405 | 2022-03-06 | Warren | Ohio | 39165 | 57320 | 558 |
2277152 | 2277152 | 2022-03-05 | Warren | Ohio | 39165 | 57312 | 558 |
2273899 | 2273899 | 2022-03-04 | Warren | Ohio | 39165 | 57293 | 558 |
2270646 | 2270646 | 2022-03-03 | Warren | Ohio | 39165 | 57270 | 558 |
2267394 | 2267394 | 2022-03-02 | Warren | Ohio | 39165 | 57245 | 558 |
2262226 | 2262226 | 2022-03-01 | Shasta | California | 6089 | 36306 | 558 |
2264141 | 2264141 | 2022-03-01 | Warren | Ohio | 39165 | 57221 | 558 |
2258975 | 2258975 | 2022-02-28 | Shasta | California | 6089 | 36299 | 558 |
2257478 | 2257478 | 2022-02-27 | Rowan | North Carolina | 37159 | 40692 | 558 |
2254227 | 2254227 | 2022-02-26 | Rowan | North Carolina | 37159 | 40692 | 558 |
2250976 | 2250976 | 2022-02-25 | Rowan | North Carolina | 37159 | 40692 | 558 |
2244366 | 2244366 | 2022-02-23 | Niagara | New York | 36063 | 47066 | 558 |
2214777 | 2214777 | 2022-02-14 | Jefferson | Missouri | 29099 | 53045 | 558 |
2211525 | 2211525 | 2022-02-13 | Jefferson | Missouri | 29099 | 52796 | 558 |
2208272 | 2208272 | 2022-02-12 | Jefferson | Missouri | 29099 | 52796 | 558 |
2205019 | 2205019 | 2022-02-11 | Jefferson | Missouri | 29099 | 52796 | 558 |
2201766 | 2201766 | 2022-02-10 | Jefferson | Missouri | 29099 | 52796 | 558 |
2198512 | 2198512 | 2022-02-09 | Jefferson | Missouri | 29099 | 52695 | 558 |
2195543 | 2195543 | 2022-02-08 | McKinley | New Mexico | 35031 | 24752 | 558 |
2192289 | 2192289 | 2022-02-07 | McKinley | New Mexico | 35031 | 24675 | 558 |
2189036 | 2189036 | 2022-02-06 | McKinley | New Mexico | 35031 | 24440 | 558 |
2185783 | 2185783 | 2022-02-05 | McKinley | New Mexico | 35031 | 24440 | 558 |
2182531 | 2182531 | 2022-02-04 | McKinley | New Mexico | 35031 | 24440 | 558 |
2177454 | 2177454 | 2022-02-03 | Calhoun | Alabama | 1015 | 30342 | 558 |
2174201 | 2174201 | 2022-02-02 | Calhoun | Alabama | 1015 | 30342 | 558 |
2171260 | 2171260 | 2022-02-01 | Kent | Delaware | 10001 | 47771 | 558 |
2170407 | 2170407 | 2022-01-31 | Grayson | Texas | 48181 | 25151 | 558 |
2167153 | 2167153 | 2022-01-30 | Grayson | Texas | 48181 | 24899 | 558 |
2156943 | 2156943 | 2022-01-27 | Blair | Pennsylvania | 42013 | 27309 | 558 |
2157387 | 2157387 | 2022-01-27 | Grayson | Texas | 48181 | 24596 | 558 |
2153215 | 2153215 | 2022-01-26 | Cumberland | New Jersey | 34011 | 36014 | 558 |
2122232 | 2122232 | 2022-01-17 | Apache | Arizona | 4001 | 18086 | 558 |
2122888 | 2122888 | 2022-01-17 | Madison | Indiana | 18095 | 28074 | 558 |
2118980 | 2118980 | 2022-01-16 | Apache | Arizona | 4001 | 17985 | 558 |
2114242 | 2114242 | 2022-01-14 | Dutchess | New York | 36027 | 56421 | 558 |
2111568 | 2111568 | 2022-01-13 | Florence | South Carolina | 45041 | 32409 | 558 |
2005413 | 2005413 | 2021-12-12 | Weld | Colorado | 8123 | 54527 | 558 |
2002162 | 2002162 | 2021-12-11 | Weld | Colorado | 8123 | 54527 | 558 |
1998912 | 1998912 | 2021-12-10 | Weld | Colorado | 8123 | 54527 | 558 |
1995582 | 1995582 | 2021-12-09 | Santa Barbara | California | 6083 | 48031 | 558 |
1987041 | 1987041 | 2021-12-06 | Harrison | Mississippi | 28047 | 35042 | 558 |
1983791 | 1983791 | 2021-12-05 | Harrison | Mississippi | 28047 | 34999 | 558 |
1980541 | 1980541 | 2021-12-04 | Harrison | Mississippi | 28047 | 34999 | 558 |
1977291 | 1977291 | 2021-12-03 | Harrison | Mississippi | 28047 | 34999 | 558 |
1971175 | 1971175 | 2021-12-01 | Doña Ana | New Mexico | 35013 | 36854 | 558 |
1967925 | 1967925 | 2021-11-30 | Doña Ana | New Mexico | 35013 | 36542 | 558 |
1964673 | 1964673 | 2021-11-29 | Doña Ana | New Mexico | 35013 | 36386 | 558 |
1930692 | 1930692 | 2021-11-19 | Highlands | Florida | 12055 | 16052 | 558 |
1927442 | 1927442 | 2021-11-18 | Highlands | Florida | 12055 | 16021 | 558 |
1924192 | 1924192 | 2021-11-17 | Highlands | Florida | 12055 | 16021 | 558 |
1924414 | 1924414 | 2021-11-17 | Canyon | Idaho | 16027 | 43021 | 558 |
1920943 | 1920943 | 2021-11-16 | Highlands | Florida | 12055 | 16021 | 558 |
1921165 | 1921165 | 2021-11-16 | Canyon | Idaho | 16027 | 43000 | 558 |
1917693 | 1917693 | 2021-11-15 | Highlands | Florida | 12055 | 16021 | 558 |
1918690 | 1918690 | 2021-11-15 | Dakota | Minnesota | 27037 | 62203 | 558 |
1920297 | 1920297 | 2021-11-15 | Chesterfield | Virginia | 51041 | 40531 | 558 |
1914443 | 1914443 | 2021-11-14 | Highlands | Florida | 12055 | 16021 | 558 |
1915440 | 1915440 | 2021-11-14 | Dakota | Minnesota | 27037 | 61869 | 558 |
1911193 | 1911193 | 2021-11-13 | Highlands | Florida | 12055 | 16021 | 558 |
1912190 | 1912190 | 2021-11-13 | Dakota | Minnesota | 27037 | 61869 | 558 |
1913595 | 1913595 | 2021-11-13 | Johnson | Texas | 48251 | 29111 | 558 |
1907944 | 1907944 | 2021-11-12 | Highlands | Florida | 12055 | 16021 | 558 |
1908940 | 1908940 | 2021-11-12 | Dakota | Minnesota | 27037 | 61869 | 558 |
1910345 | 1910345 | 2021-11-12 | Johnson | Texas | 48251 | 29061 | 558 |
1904695 | 1904695 | 2021-11-11 | Highlands | Florida | 12055 | 15971 | 558 |
1907062 | 1907062 | 2021-11-11 | Gregg | Texas | 48183 | 19343 | 558 |
1901445 | 1901445 | 2021-11-10 | Highlands | Florida | 12055 | 15971 | 558 |
1898195 | 1898195 | 2021-11-09 | Highlands | Florida | 12055 | 15971 | 558 |
1900897 | 1900897 | 2021-11-09 | Virginia Beach city | Virginia | 51810 | 50268 | 558 |
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);