ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
218 rows where deaths = 652 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 43
- Pennsylvania 34
- Indiana 17
- Tennessee 12
- Mississippi 11
- New Hampshire 10
- New Jersey 10
- Michigan 9
- Wisconsin 6
- Alabama 5
- California 5
- Colorado 5
- New York 5
- Washington 5
- Idaho 4
- North Carolina 4
- Oregon 4
- Texas 4
- Arizona 3
- Arkansas 3
- South Carolina 3
- Georgia 2
- Illinois 2
- Louisiana 2
- Maryland 2
- Massachusetts 2
- Missouri 2
- District of Columbia 1
- Nebraska 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490153 | 2490153 | 2022-05-10 | Indian River | Florida | 12061 | 33156 | 652 |
2492135 | 2492135 | 2022-05-10 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2486896 | 2486896 | 2022-05-09 | Indian River | Florida | 12061 | 33156 | 652 |
2488877 | 2488877 | 2022-05-09 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2483638 | 2483638 | 2022-05-08 | Indian River | Florida | 12061 | 33156 | 652 |
2484038 | 2484038 | 2022-05-08 | Madison | Indiana | 18095 | 32790 | 652 |
2485620 | 2485620 | 2022-05-08 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2480380 | 2480380 | 2022-05-07 | Indian River | Florida | 12061 | 33156 | 652 |
2480780 | 2480780 | 2022-05-07 | Madison | Indiana | 18095 | 32790 | 652 |
2482362 | 2482362 | 2022-05-07 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2477122 | 2477122 | 2022-05-06 | Indian River | Florida | 12061 | 33156 | 652 |
2477522 | 2477522 | 2022-05-06 | Madison | Indiana | 18095 | 32790 | 652 |
2479104 | 2479104 | 2022-05-06 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2473864 | 2473864 | 2022-05-05 | Indian River | Florida | 12061 | 32772 | 652 |
2474264 | 2474264 | 2022-05-05 | Madison | Indiana | 18095 | 32790 | 652 |
2475846 | 2475846 | 2022-05-05 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2470607 | 2470607 | 2022-05-04 | Indian River | Florida | 12061 | 32772 | 652 |
2471007 | 2471007 | 2022-05-04 | Madison | Indiana | 18095 | 32790 | 652 |
2472589 | 2472589 | 2022-05-04 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2467351 | 2467351 | 2022-05-03 | Indian River | Florida | 12061 | 32772 | 652 |
2467751 | 2467751 | 2022-05-03 | Madison | Indiana | 18095 | 32777 | 652 |
2469333 | 2469333 | 2022-05-03 | Washington | Pennsylvania | 42125 | 51369 | 652 |
2464096 | 2464096 | 2022-05-02 | Indian River | Florida | 12061 | 32772 | 652 |
2464496 | 2464496 | 2022-05-02 | Madison | Indiana | 18095 | 32777 | 652 |
2466077 | 2466077 | 2022-05-02 | Washington | Pennsylvania | 42125 | 51342 | 652 |
2460840 | 2460840 | 2022-05-01 | Indian River | Florida | 12061 | 32772 | 652 |
2461240 | 2461240 | 2022-05-01 | Madison | Indiana | 18095 | 32763 | 652 |
2462822 | 2462822 | 2022-05-01 | Washington | Pennsylvania | 42125 | 51333 | 652 |
2457584 | 2457584 | 2022-04-30 | Indian River | Florida | 12061 | 32772 | 652 |
2457984 | 2457984 | 2022-04-30 | Madison | Indiana | 18095 | 32763 | 652 |
2459566 | 2459566 | 2022-04-30 | Washington | Pennsylvania | 42125 | 51295 | 652 |
2454328 | 2454328 | 2022-04-29 | Indian River | Florida | 12061 | 32772 | 652 |
2454728 | 2454728 | 2022-04-29 | Madison | Indiana | 18095 | 32763 | 652 |
2456310 | 2456310 | 2022-04-29 | Washington | Pennsylvania | 42125 | 51270 | 652 |
2451072 | 2451072 | 2022-04-28 | Indian River | Florida | 12061 | 32772 | 652 |
2451472 | 2451472 | 2022-04-28 | Madison | Indiana | 18095 | 32749 | 652 |
2453054 | 2453054 | 2022-04-28 | Washington | Pennsylvania | 42125 | 51229 | 652 |
2447816 | 2447816 | 2022-04-27 | Indian River | Florida | 12061 | 32772 | 652 |
2448216 | 2448216 | 2022-04-27 | Madison | Indiana | 18095 | 32749 | 652 |
2449798 | 2449798 | 2022-04-27 | Washington | Pennsylvania | 42125 | 51185 | 652 |
2444560 | 2444560 | 2022-04-26 | Indian River | Florida | 12061 | 32772 | 652 |
2446541 | 2446541 | 2022-04-26 | Washington | Pennsylvania | 42125 | 51141 | 652 |
2441304 | 2441304 | 2022-04-25 | Indian River | Florida | 12061 | 32772 | 652 |
2443286 | 2443286 | 2022-04-25 | Washington | Pennsylvania | 42125 | 51105 | 652 |
2438048 | 2438048 | 2022-04-24 | Indian River | Florida | 12061 | 32772 | 652 |
2440030 | 2440030 | 2022-04-24 | Washington | Pennsylvania | 42125 | 51087 | 652 |
2434792 | 2434792 | 2022-04-23 | Indian River | Florida | 12061 | 32772 | 652 |
2436774 | 2436774 | 2022-04-23 | Washington | Pennsylvania | 42125 | 51069 | 652 |
2431536 | 2431536 | 2022-04-22 | Indian River | Florida | 12061 | 32772 | 652 |
2428280 | 2428280 | 2022-04-21 | Indian River | Florida | 12061 | 32490 | 652 |
2425024 | 2425024 | 2022-04-20 | Indian River | Florida | 12061 | 32490 | 652 |
2421768 | 2421768 | 2022-04-19 | Indian River | Florida | 12061 | 32490 | 652 |
2418512 | 2418512 | 2022-04-18 | Indian River | Florida | 12061 | 32490 | 652 |
2415256 | 2415256 | 2022-04-17 | Indian River | Florida | 12061 | 32490 | 652 |
2412000 | 2412000 | 2022-04-16 | Indian River | Florida | 12061 | 32490 | 652 |
2408744 | 2408744 | 2022-04-15 | Indian River | Florida | 12061 | 32490 | 652 |
2405488 | 2405488 | 2022-04-14 | Indian River | Florida | 12061 | 32490 | 652 |
2402233 | 2402233 | 2022-04-13 | Indian River | Florida | 12061 | 32490 | 652 |
2398978 | 2398978 | 2022-04-12 | Indian River | Florida | 12061 | 32490 | 652 |
2395723 | 2395723 | 2022-04-11 | Indian River | Florida | 12061 | 32490 | 652 |
2392467 | 2392467 | 2022-04-10 | Indian River | Florida | 12061 | 32490 | 652 |
2389211 | 2389211 | 2022-04-09 | Indian River | Florida | 12061 | 32490 | 652 |
2385956 | 2385956 | 2022-04-08 | Indian River | Florida | 12061 | 32490 | 652 |
2382701 | 2382701 | 2022-04-07 | Indian River | Florida | 12061 | 32366 | 652 |
2379446 | 2379446 | 2022-04-06 | Indian River | Florida | 12061 | 32366 | 652 |
2314763 | 2314763 | 2022-03-17 | Hamilton | Indiana | 18057 | 81601 | 652 |
2311510 | 2311510 | 2022-03-16 | Hamilton | Indiana | 18057 | 81588 | 652 |
2308257 | 2308257 | 2022-03-15 | Hamilton | Indiana | 18057 | 81573 | 652 |
2302460 | 2302460 | 2022-03-13 | Harrison | Mississippi | 28047 | 53345 | 652 |
2299208 | 2299208 | 2022-03-12 | Harrison | Mississippi | 28047 | 53345 | 652 |
2295956 | 2295956 | 2022-03-11 | Harrison | Mississippi | 28047 | 53345 | 652 |
2292704 | 2292704 | 2022-03-10 | Harrison | Mississippi | 28047 | 53345 | 652 |
2289452 | 2289452 | 2022-03-09 | Harrison | Mississippi | 28047 | 53345 | 652 |
2285227 | 2285227 | 2022-03-08 | Henry | Georgia | 13151 | 57428 | 652 |
2286201 | 2286201 | 2022-03-08 | Harrison | Mississippi | 28047 | 53345 | 652 |
2269781 | 2269781 | 2022-03-03 | Kalamazoo | Michigan | 26077 | 58377 | 652 |
2266528 | 2266528 | 2022-03-02 | Kalamazoo | Michigan | 26077 | 58377 | 652 |
2255721 | 2255721 | 2022-02-27 | Santa Barbara | California | 6083 | 89561 | 652 |
2252470 | 2252470 | 2022-02-26 | Santa Barbara | California | 6083 | 89561 | 652 |
2249219 | 2249219 | 2022-02-25 | Santa Barbara | California | 6083 | 89561 | 652 |
2225277 | 2225277 | 2022-02-17 | Franklin | Pennsylvania | 42055 | 39747 | 652 |
2220303 | 2220303 | 2022-02-16 | Canyon | Idaho | 16027 | 57995 | 652 |
2222026 | 2222026 | 2022-02-16 | Franklin | Pennsylvania | 42055 | 39680 | 652 |
2218775 | 2218775 | 2022-02-15 | Franklin | Pennsylvania | 42055 | 39655 | 652 |
2218801 | 2218801 | 2022-02-15 | Schuylkill | Pennsylvania | 42107 | 33784 | 652 |
2219094 | 2219094 | 2022-02-15 | Sumner | Tennessee | 47165 | 51397 | 652 |
2215843 | 2215843 | 2022-02-14 | Sumner | Tennessee | 47165 | 51397 | 652 |
2212592 | 2212592 | 2022-02-13 | Sumner | Tennessee | 47165 | 51397 | 652 |
2209339 | 2209339 | 2022-02-12 | Sumner | Tennessee | 47165 | 51397 | 652 |
2206086 | 2206086 | 2022-02-11 | Sumner | Tennessee | 47165 | 51397 | 652 |
2202833 | 2202833 | 2022-02-10 | Sumner | Tennessee | 47165 | 51397 | 652 |
2203034 | 2203034 | 2022-02-10 | Potter | Texas | 48375 | 34820 | 652 |
2199579 | 2199579 | 2022-02-09 | Sumner | Tennessee | 47165 | 51397 | 652 |
2190764 | 2190764 | 2022-02-07 | Weld | Colorado | 8123 | 78430 | 652 |
2168847 | 2168847 | 2022-01-31 | Ouachita | Louisiana | 22073 | 47826 | 652 |
2146735 | 2146735 | 2022-01-24 | Doña Ana | New Mexico | 35013 | 54495 | 652 |
2134170 | 2134170 | 2022-01-20 | Butler | Pennsylvania | 42019 | 40035 | 652 |
2127679 | 2127679 | 2022-01-18 | Erie | Pennsylvania | 42049 | 51127 | 652 |
2124427 | 2124427 | 2022-01-17 | Erie | Pennsylvania | 42049 | 50903 | 652 |
2121175 | 2121175 | 2022-01-16 | Erie | Pennsylvania | 42049 | 50547 | 652 |
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);