ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,988 rows where deaths = 155 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 234
- Georgia 134
- Ohio 132
- Tennessee 109
- Mississippi 91
- Virginia 89
- North Carolina 86
- Indiana 82
- Michigan 80
- Kentucky 78
- Wisconsin 71
- Pennsylvania 62
- West Virginia 57
- Alabama 53
- Florida 46
- Louisiana 46
- Oklahoma 45
- South Carolina 41
- California 40
- Illinois 40
- Missouri 40
- New York 34
- Arkansas 27
- Massachusetts 23
- New Mexico 23
- Nebraska 20
- New Jersey 20
- Colorado 19
- Oregon 19
- Washington 19
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501429 | 2501429 | 2022-05-13 | Allegany | New York | 36003 | 9275 | 155 |
2502707 | 2502707 | 2022-05-13 | Marshall | West Virginia | 54051 | 9085 | 155 |
2499449 | 2499449 | 2022-05-12 | Marshall | West Virginia | 54051 | 9075 | 155 |
2496191 | 2496191 | 2022-05-11 | Marshall | West Virginia | 54051 | 9070 | 155 |
2490187 | 2490187 | 2022-05-10 | Unknown | Florida | 20199 | 155 | |
2467407 | 2467407 | 2022-05-03 | Butts | Georgia | 13035 | 6484 | 155 |
2464152 | 2464152 | 2022-05-02 | Butts | Georgia | 13035 | 6484 | 155 |
2460896 | 2460896 | 2022-05-01 | Butts | Georgia | 13035 | 6484 | 155 |
2457640 | 2457640 | 2022-04-30 | Butts | Georgia | 13035 | 6484 | 155 |
2454384 | 2454384 | 2022-04-29 | Butts | Georgia | 13035 | 6484 | 155 |
2451128 | 2451128 | 2022-04-28 | Butts | Georgia | 13035 | 6484 | 155 |
2447872 | 2447872 | 2022-04-27 | Butts | Georgia | 13035 | 6484 | 155 |
2444742 | 2444742 | 2022-04-26 | Union | Georgia | 13291 | 4874 | 155 |
2441486 | 2441486 | 2022-04-25 | Union | Georgia | 13291 | 4874 | 155 |
2444010 | 2444010 | 2022-04-25 | Warren | Virginia | 51187 | 8586 | 155 |
2438230 | 2438230 | 2022-04-24 | Union | Georgia | 13291 | 4877 | 155 |
2440754 | 2440754 | 2022-04-24 | Warren | Virginia | 51187 | 8578 | 155 |
2434974 | 2434974 | 2022-04-23 | Union | Georgia | 13291 | 4877 | 155 |
2437498 | 2437498 | 2022-04-23 | Warren | Virginia | 51187 | 8578 | 155 |
2431718 | 2431718 | 2022-04-22 | Union | Georgia | 13291 | 4877 | 155 |
2434242 | 2434242 | 2022-04-22 | Warren | Virginia | 51187 | 8578 | 155 |
2428462 | 2428462 | 2022-04-21 | Union | Georgia | 13291 | 4877 | 155 |
2430986 | 2430986 | 2022-04-21 | Warren | Virginia | 51187 | 8574 | 155 |
2425206 | 2425206 | 2022-04-20 | Union | Georgia | 13291 | 4877 | 155 |
2427730 | 2427730 | 2022-04-20 | Warren | Virginia | 51187 | 8573 | 155 |
2421950 | 2421950 | 2022-04-19 | Union | Georgia | 13291 | 4873 | 155 |
2424474 | 2424474 | 2022-04-19 | Warren | Virginia | 51187 | 8572 | 155 |
2418694 | 2418694 | 2022-04-18 | Union | Georgia | 13291 | 4873 | 155 |
2415438 | 2415438 | 2022-04-17 | Union | Georgia | 13291 | 4874 | 155 |
2412182 | 2412182 | 2022-04-16 | Union | Georgia | 13291 | 4874 | 155 |
2408926 | 2408926 | 2022-04-15 | Union | Georgia | 13291 | 4874 | 155 |
2405581 | 2405581 | 2022-04-14 | Fannin | Georgia | 13111 | 5125 | 155 |
2405670 | 2405670 | 2022-04-14 | Union | Georgia | 13291 | 4873 | 155 |
2402326 | 2402326 | 2022-04-13 | Fannin | Georgia | 13111 | 5123 | 155 |
2402415 | 2402415 | 2022-04-13 | Union | Georgia | 13291 | 4872 | 155 |
2399071 | 2399071 | 2022-04-12 | Fannin | Georgia | 13111 | 5122 | 155 |
2399143 | 2399143 | 2022-04-12 | Stephens | Georgia | 13257 | 6313 | 155 |
2399160 | 2399160 | 2022-04-12 | Union | Georgia | 13291 | 4872 | 155 |
2399365 | 2399365 | 2022-04-12 | Huntington | Indiana | 18069 | 11492 | 155 |
2399816 | 2399816 | 2022-04-12 | Aroostook | Maine | 23003 | 12834 | 155 |
2401199 | 2401199 | 2022-04-12 | Henderson | Tennessee | 47077 | 9115 | 155 |
2401613 | 2401613 | 2022-04-12 | Halifax | Virginia | 51083 | 7041 | 155 |
2395410 | 2395410 | 2022-04-11 | Lawrence | Alabama | 1079 | 7660 | 155 |
2395816 | 2395816 | 2022-04-11 | Fannin | Georgia | 13111 | 5122 | 155 |
2395905 | 2395905 | 2022-04-11 | Union | Georgia | 13291 | 4872 | 155 |
2396110 | 2396110 | 2022-04-11 | Huntington | Indiana | 18069 | 11492 | 155 |
2397944 | 2397944 | 2022-04-11 | Henderson | Tennessee | 47077 | 9115 | 155 |
2398358 | 2398358 | 2022-04-11 | Halifax | Virginia | 51083 | 7033 | 155 |
2398488 | 2398488 | 2022-04-11 | Greenbrier | West Virginia | 54025 | 9503 | 155 |
2392154 | 2392154 | 2022-04-10 | Lawrence | Alabama | 1079 | 7656 | 155 |
2392649 | 2392649 | 2022-04-10 | Union | Georgia | 13291 | 4872 | 155 |
2392854 | 2392854 | 2022-04-10 | Huntington | Indiana | 18069 | 11490 | 155 |
2394689 | 2394689 | 2022-04-10 | Henderson | Tennessee | 47077 | 9115 | 155 |
2395103 | 2395103 | 2022-04-10 | Halifax | Virginia | 51083 | 7027 | 155 |
2395233 | 2395233 | 2022-04-10 | Greenbrier | West Virginia | 54025 | 9506 | 155 |
2388898 | 2388898 | 2022-04-09 | Lawrence | Alabama | 1079 | 7656 | 155 |
2389393 | 2389393 | 2022-04-09 | Union | Georgia | 13291 | 4872 | 155 |
2389598 | 2389598 | 2022-04-09 | Huntington | Indiana | 18069 | 11490 | 155 |
2391433 | 2391433 | 2022-04-09 | Henderson | Tennessee | 47077 | 9115 | 155 |
2391847 | 2391847 | 2022-04-09 | Halifax | Virginia | 51083 | 7027 | 155 |
2391977 | 2391977 | 2022-04-09 | Greenbrier | West Virginia | 54025 | 9506 | 155 |
2385643 | 2385643 | 2022-04-08 | Lawrence | Alabama | 1079 | 7656 | 155 |
2386138 | 2386138 | 2022-04-08 | Union | Georgia | 13291 | 4872 | 155 |
2386343 | 2386343 | 2022-04-08 | Huntington | Indiana | 18069 | 11490 | 155 |
2388177 | 2388177 | 2022-04-08 | Henderson | Tennessee | 47077 | 9115 | 155 |
2388591 | 2388591 | 2022-04-08 | Halifax | Virginia | 51083 | 7027 | 155 |
2388721 | 2388721 | 2022-04-08 | Greenbrier | West Virginia | 54025 | 9506 | 155 |
2382388 | 2382388 | 2022-04-07 | Lawrence | Alabama | 1079 | 7654 | 155 |
2382883 | 2382883 | 2022-04-07 | Union | Georgia | 13291 | 4872 | 155 |
2383088 | 2383088 | 2022-04-07 | Huntington | Indiana | 18069 | 11490 | 155 |
2383139 | 2383139 | 2022-04-07 | Wabash | Indiana | 18169 | 8717 | 155 |
2384922 | 2384922 | 2022-04-07 | Henderson | Tennessee | 47077 | 9115 | 155 |
2385336 | 2385336 | 2022-04-07 | Halifax | Virginia | 51083 | 7027 | 155 |
2379133 | 2379133 | 2022-04-06 | Lawrence | Alabama | 1079 | 7655 | 155 |
2379628 | 2379628 | 2022-04-06 | Union | Georgia | 13291 | 4872 | 155 |
2379833 | 2379833 | 2022-04-06 | Huntington | Indiana | 18069 | 11490 | 155 |
2379884 | 2379884 | 2022-04-06 | Wabash | Indiana | 18169 | 8717 | 155 |
2381667 | 2381667 | 2022-04-06 | Henderson | Tennessee | 47077 | 9115 | 155 |
2375879 | 2375879 | 2022-04-05 | Lawrence | Alabama | 1079 | 7654 | 155 |
2376374 | 2376374 | 2022-04-05 | Union | Georgia | 13291 | 4874 | 155 |
2376579 | 2376579 | 2022-04-05 | Huntington | Indiana | 18069 | 11490 | 155 |
2376629 | 2376629 | 2022-04-05 | Wabash | Indiana | 18169 | 8717 | 155 |
2377104 | 2377104 | 2022-04-05 | Delta | Michigan | 26041 | 9917 | 155 |
2377145 | 2377145 | 2022-04-05 | Newaygo | Michigan | 26123 | 11462 | 155 |
2372627 | 2372627 | 2022-04-04 | Lawrence | Alabama | 1079 | 7654 | 155 |
2373327 | 2373327 | 2022-04-04 | Huntington | Indiana | 18069 | 11490 | 155 |
2373377 | 2373377 | 2022-04-04 | Wabash | Indiana | 18169 | 8717 | 155 |
2373852 | 2373852 | 2022-04-04 | Delta | Michigan | 26041 | 9917 | 155 |
2373893 | 2373893 | 2022-04-04 | Newaygo | Michigan | 26123 | 11462 | 155 |
2375702 | 2375702 | 2022-04-04 | Greenbrier | West Virginia | 54025 | 9500 | 155 |
2370074 | 2370074 | 2022-04-03 | Huntington | Indiana | 18069 | 11486 | 155 |
2370124 | 2370124 | 2022-04-03 | Wabash | Indiana | 18169 | 8715 | 155 |
2370599 | 2370599 | 2022-04-03 | Delta | Michigan | 26041 | 9917 | 155 |
2370640 | 2370640 | 2022-04-03 | Newaygo | Michigan | 26123 | 11462 | 155 |
2371658 | 2371658 | 2022-04-03 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2372450 | 2372450 | 2022-04-03 | Greenbrier | West Virginia | 54025 | 9497 | 155 |
2366821 | 2366821 | 2022-04-02 | Huntington | Indiana | 18069 | 11486 | 155 |
2366871 | 2366871 | 2022-04-02 | Wabash | Indiana | 18169 | 8715 | 155 |
2367346 | 2367346 | 2022-04-02 | Delta | Michigan | 26041 | 9917 | 155 |
2367387 | 2367387 | 2022-04-02 | Newaygo | Michigan | 26123 | 11462 | 155 |
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);