ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
177 rows where deaths = 661 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 26
- Florida 12
- New York 12
- Missouri 11
- Tennessee 10
- Arkansas 7
- California 7
- Mississippi 7
- Ohio 7
- South Carolina 7
- Nevada 6
- New Jersey 6
- Pennsylvania 6
- Texas 6
- Washington 6
- Wisconsin 6
- Georgia 5
- Maryland 5
- Colorado 4
- New Mexico 4
- Louisiana 3
- Massachusetts 3
- Alabama 2
- Michigan 2
- Arizona 1
- Delaware 1
- Idaho 1
- Minnesota 1
- Oklahoma 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500308 | 2500308 | 2022-05-13 | Hamilton | Indiana | 18057 | 83430 | 661 |
2497050 | 2497050 | 2022-05-12 | Hamilton | Indiana | 18057 | 83231 | 661 |
2493792 | 2493792 | 2022-05-11 | Hamilton | Indiana | 18057 | 83231 | 661 |
2490534 | 2490534 | 2022-05-10 | Hamilton | Indiana | 18057 | 83088 | 661 |
2487277 | 2487277 | 2022-05-09 | Hamilton | Indiana | 18057 | 83088 | 661 |
2484019 | 2484019 | 2022-05-08 | Hamilton | Indiana | 18057 | 82726 | 661 |
2480761 | 2480761 | 2022-05-07 | Hamilton | Indiana | 18057 | 82726 | 661 |
2477503 | 2477503 | 2022-05-06 | Hamilton | Indiana | 18057 | 82726 | 661 |
2474245 | 2474245 | 2022-05-05 | Hamilton | Indiana | 18057 | 82726 | 661 |
2470988 | 2470988 | 2022-05-04 | Hamilton | Indiana | 18057 | 82726 | 661 |
2467732 | 2467732 | 2022-05-03 | Hamilton | Indiana | 18057 | 82605 | 661 |
2464477 | 2464477 | 2022-05-02 | Hamilton | Indiana | 18057 | 82605 | 661 |
2461221 | 2461221 | 2022-05-01 | Hamilton | Indiana | 18057 | 82492 | 661 |
2457965 | 2457965 | 2022-04-30 | Hamilton | Indiana | 18057 | 82492 | 661 |
2454709 | 2454709 | 2022-04-29 | Hamilton | Indiana | 18057 | 82492 | 661 |
2451453 | 2451453 | 2022-04-28 | Hamilton | Indiana | 18057 | 82373 | 661 |
2448197 | 2448197 | 2022-04-27 | Hamilton | Indiana | 18057 | 82373 | 661 |
2444941 | 2444941 | 2022-04-26 | Hamilton | Indiana | 18057 | 82271 | 661 |
2441685 | 2441685 | 2022-04-25 | Hamilton | Indiana | 18057 | 82271 | 661 |
2438429 | 2438429 | 2022-04-24 | Hamilton | Indiana | 18057 | 82116 | 661 |
2435173 | 2435173 | 2022-04-23 | Hamilton | Indiana | 18057 | 82116 | 661 |
2431917 | 2431917 | 2022-04-22 | Hamilton | Indiana | 18057 | 82116 | 661 |
2428661 | 2428661 | 2022-04-21 | Hamilton | Indiana | 18057 | 82039 | 661 |
2425405 | 2425405 | 2022-04-20 | Hamilton | Indiana | 18057 | 82039 | 661 |
2397839 | 2397839 | 2022-04-11 | York | South Carolina | 45091 | 77487 | 661 |
2394584 | 2394584 | 2022-04-10 | York | South Carolina | 45091 | 77487 | 661 |
2391328 | 2391328 | 2022-04-09 | York | South Carolina | 45091 | 77487 | 661 |
2388072 | 2388072 | 2022-04-08 | York | South Carolina | 45091 | 77487 | 661 |
2384817 | 2384817 | 2022-04-07 | York | South Carolina | 45091 | 77487 | 661 |
2381562 | 2381562 | 2022-04-06 | York | South Carolina | 45091 | 77487 | 661 |
2378307 | 2378307 | 2022-04-05 | York | South Carolina | 45091 | 77487 | 661 |
2370774 | 2370774 | 2022-04-03 | Harrison | Mississippi | 28047 | 53512 | 661 |
2367521 | 2367521 | 2022-04-02 | Harrison | Mississippi | 28047 | 53512 | 661 |
2364268 | 2364268 | 2022-04-01 | Harrison | Mississippi | 28047 | 53512 | 661 |
2361014 | 2361014 | 2022-03-31 | Harrison | Mississippi | 28047 | 53512 | 661 |
2357760 | 2357760 | 2022-03-30 | Harrison | Mississippi | 28047 | 53512 | 661 |
2354507 | 2354507 | 2022-03-29 | Harrison | Mississippi | 28047 | 53512 | 661 |
2351255 | 2351255 | 2022-03-28 | Harrison | Mississippi | 28047 | 53512 | 661 |
2333899 | 2333899 | 2022-03-23 | Highlands | Florida | 12055 | 23936 | 661 |
2334015 | 2334015 | 2022-03-23 | Henry | Georgia | 13151 | 57600 | 661 |
2330645 | 2330645 | 2022-03-22 | Highlands | Florida | 12055 | 23936 | 661 |
2330761 | 2330761 | 2022-03-22 | Henry | Georgia | 13151 | 57597 | 661 |
2327393 | 2327393 | 2022-03-21 | Highlands | Florida | 12055 | 23936 | 661 |
2327509 | 2327509 | 2022-03-21 | Henry | Georgia | 13151 | 57587 | 661 |
2324140 | 2324140 | 2022-03-20 | Highlands | Florida | 12055 | 23936 | 661 |
2320886 | 2320886 | 2022-03-19 | Highlands | Florida | 12055 | 23936 | 661 |
2317632 | 2317632 | 2022-03-18 | Highlands | Florida | 12055 | 23936 | 661 |
2314379 | 2314379 | 2022-03-17 | Highlands | Florida | 12055 | 23936 | 661 |
2315312 | 2315312 | 2022-03-17 | Kalamazoo | Michigan | 26077 | 58690 | 661 |
2316324 | 2316324 | 2022-03-17 | Fayette | Pennsylvania | 42051 | 30888 | 661 |
2311126 | 2311126 | 2022-03-16 | Highlands | Florida | 12055 | 23936 | 661 |
2312059 | 2312059 | 2022-03-16 | Kalamazoo | Michigan | 26077 | 58690 | 661 |
2297236 | 2297236 | 2022-03-11 | Gregg | Texas | 48183 | 23069 | 661 |
2291493 | 2291493 | 2022-03-10 | Santa Barbara | California | 6083 | 90196 | 661 |
2293984 | 2293984 | 2022-03-10 | Gregg | Texas | 48183 | 23068 | 661 |
2287082 | 2287082 | 2022-03-08 | Schuylkill | Pennsylvania | 42107 | 34242 | 661 |
2287374 | 2287374 | 2022-03-08 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2284122 | 2284122 | 2022-03-07 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2284717 | 2284717 | 2022-03-07 | Racine | Wisconsin | 55101 | 55931 | 661 |
2280870 | 2280870 | 2022-03-06 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2277617 | 2277617 | 2022-03-05 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2274364 | 2274364 | 2022-03-04 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2271111 | 2271111 | 2022-03-03 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2267859 | 2267859 | 2022-03-02 | Sullivan | Tennessee | 47163 | 45327 | 661 |
2239809 | 2239809 | 2022-02-22 | Canyon | Idaho | 16027 | 59165 | 661 |
2242358 | 2242358 | 2022-02-22 | Kanawha | West Virginia | 54039 | 46258 | 661 |
2236294 | 2236294 | 2022-02-21 | Weld | Colorado | 8123 | 79956 | 661 |
2238605 | 2238605 | 2022-02-21 | Unknown | Tennessee | 30553 | 661 | |
2223290 | 2223290 | 2022-02-17 | Weld | Colorado | 8123 | 79825 | 661 |
2179553 | 2179553 | 2022-02-03 | Lake | Ohio | 39085 | 48091 | 661 |
2176302 | 2176302 | 2022-02-02 | Lake | Ohio | 39085 | 48056 | 661 |
2173048 | 2173048 | 2022-02-01 | Lake | Ohio | 39085 | 48010 | 661 |
2104228 | 2104228 | 2022-01-11 | St. Louis city | Missouri | 29510 | 46853 | 661 |
2105726 | 2105726 | 2022-01-11 | Yakima | Washington | 53077 | 52302 | 661 |
2100977 | 2100977 | 2022-01-10 | St. Louis city | Missouri | 29510 | 46161 | 661 |
2102475 | 2102475 | 2022-01-10 | Yakima | Washington | 53077 | 51722 | 661 |
2097963 | 2097963 | 2022-01-09 | San Juan | New Mexico | 35045 | 29391 | 661 |
2094711 | 2094711 | 2022-01-08 | San Juan | New Mexico | 35045 | 29391 | 661 |
2091459 | 2091459 | 2022-01-07 | San Juan | New Mexico | 35045 | 29391 | 661 |
2088208 | 2088208 | 2022-01-06 | San Juan | New Mexico | 35045 | 29146 | 661 |
2033253 | 2033253 | 2021-12-20 | Trumbull | Ohio | 39155 | 29628 | 661 |
2030003 | 2030003 | 2021-12-19 | Trumbull | Ohio | 39155 | 29446 | 661 |
2026752 | 2026752 | 2021-12-18 | Trumbull | Ohio | 39155 | 29357 | 661 |
2023501 | 2023501 | 2021-12-17 | Trumbull | Ohio | 39155 | 29247 | 661 |
1993982 | 1993982 | 2021-12-08 | Oneida | New York | 36065 | 34638 | 661 |
1986003 | 1986003 | 2021-12-06 | Bibb | Georgia | 13021 | 26168 | 661 |
1974888 | 1974888 | 2021-12-02 | Cumberland | Pennsylvania | 42041 | 31912 | 661 |
1940591 | 1940591 | 2021-11-22 | Muscogee | Georgia | 13215 | 24538 | 661 |
1875323 | 1875323 | 2021-11-02 | San Francisco | California | 6075 | 55072 | 661 |
1872074 | 1872074 | 2021-11-01 | San Francisco | California | 6075 | 55024 | 661 |
1868825 | 1868825 | 2021-10-31 | San Francisco | California | 6075 | 54815 | 661 |
1865576 | 1865576 | 2021-10-30 | San Francisco | California | 6075 | 54815 | 661 |
1862327 | 1862327 | 2021-10-29 | San Francisco | California | 6075 | 54815 | 661 |
1827897 | 1827897 | 2021-10-18 | Greene | Missouri | 29077 | 44431 | 661 |
1824648 | 1824648 | 2021-10-17 | Greene | Missouri | 29077 | 44335 | 661 |
1821399 | 1821399 | 2021-10-16 | Greene | Missouri | 29077 | 44335 | 661 |
1818150 | 1818150 | 2021-10-15 | Greene | Missouri | 29077 | 44335 | 661 |
1814901 | 1814901 | 2021-10-14 | Greene | Missouri | 29077 | 44275 | 661 |
1811653 | 1811653 | 2021-10-13 | Greene | Missouri | 29077 | 44242 | 661 |
1805162 | 1805162 | 2021-10-11 | Jackson | Missouri | 29095 | 54758 | 661 |
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);