ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
637 rows where deaths = 364 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 79
- North Carolina 53
- Alabama 46
- Georgia 42
- Colorado 31
- Indiana 31
- Ohio 30
- Pennsylvania 30
- Tennessee 27
- Illinois 25
- Wisconsin 21
- California 18
- South Carolina 18
- Michigan 17
- Iowa 14
- Minnesota 14
- Virginia 12
- Arizona 11
- Oregon 11
- Florida 9
- Kansas 9
- Louisiana 9
- New Jersey 9
- Kentucky 8
- Mississippi 8
- Oklahoma 8
- New York 7
- Missouri 6
- Washington 6
- Connecticut 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501847 | 2501847 | 2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2498221 | 2498221 | 2022-05-12 | Ulster | New York | 36111 | 33856 | 364 |
2498589 | 2498589 | 2022-05-12 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2495331 | 2495331 | 2022-05-11 | Adams | Pennsylvania | 42001 | 25114 | 364 |
2490992 | 2490992 | 2022-05-10 | Cumberland | Maine | 23005 | 51910 | 364 |
2487735 | 2487735 | 2022-05-09 | Cumberland | Maine | 23005 | 51689 | 364 |
2484477 | 2484477 | 2022-05-08 | Cumberland | Maine | 23005 | 51574 | 364 |
2481219 | 2481219 | 2022-05-07 | Cumberland | Maine | 23005 | 51574 | 364 |
2468932 | 2468932 | 2022-05-03 | Cleveland | North Carolina | 37045 | 29608 | 364 |
2465676 | 2465676 | 2022-05-02 | Cleveland | North Carolina | 37045 | 29608 | 364 |
2462421 | 2462421 | 2022-05-01 | Cleveland | North Carolina | 37045 | 29608 | 364 |
2459165 | 2459165 | 2022-04-30 | Cleveland | North Carolina | 37045 | 29608 | 364 |
2455909 | 2455909 | 2022-04-29 | Cleveland | North Carolina | 37045 | 29608 | 364 |
2452653 | 2452653 | 2022-04-28 | Cleveland | North Carolina | 37045 | 29608 | 364 |
2449397 | 2449397 | 2022-04-27 | Cleveland | North Carolina | 37045 | 29608 | 364 |
2446140 | 2446140 | 2022-04-26 | Cleveland | North Carolina | 37045 | 29574 | 364 |
2442885 | 2442885 | 2022-04-25 | Cleveland | North Carolina | 37045 | 29574 | 364 |
2438813 | 2438813 | 2022-04-24 | Warren | Kentucky | 21227 | 42954 | 364 |
2439629 | 2439629 | 2022-04-24 | Cleveland | North Carolina | 37045 | 29574 | 364 |
2435557 | 2435557 | 2022-04-23 | Warren | Kentucky | 21227 | 42954 | 364 |
2436373 | 2436373 | 2022-04-23 | Cleveland | North Carolina | 37045 | 29574 | 364 |
2432301 | 2432301 | 2022-04-22 | Warren | Kentucky | 21227 | 42954 | 364 |
2433117 | 2433117 | 2022-04-22 | Cleveland | North Carolina | 37045 | 29574 | 364 |
2429045 | 2429045 | 2022-04-21 | Warren | Kentucky | 21227 | 42954 | 364 |
2429861 | 2429861 | 2022-04-21 | Cleveland | North Carolina | 37045 | 29574 | 364 |
2425789 | 2425789 | 2022-04-20 | Warren | Kentucky | 21227 | 42954 | 364 |
2426605 | 2426605 | 2022-04-20 | Cleveland | North Carolina | 37045 | 29574 | 364 |
2422533 | 2422533 | 2022-04-19 | Warren | Kentucky | 21227 | 42954 | 364 |
2423349 | 2423349 | 2022-04-19 | Cleveland | North Carolina | 37045 | 29544 | 364 |
2424261 | 2424261 | 2022-04-19 | Starr | Texas | 48427 | 19889 | 364 |
2419277 | 2419277 | 2022-04-18 | Warren | Kentucky | 21227 | 42954 | 364 |
2420092 | 2420092 | 2022-04-18 | Cleveland | North Carolina | 37045 | 29544 | 364 |
2421005 | 2421005 | 2022-04-18 | Starr | Texas | 48427 | 19879 | 364 |
2416837 | 2416837 | 2022-04-17 | Cleveland | North Carolina | 37045 | 29544 | 364 |
2417749 | 2417749 | 2022-04-17 | Starr | Texas | 48427 | 19861 | 364 |
2413581 | 2413581 | 2022-04-16 | Cleveland | North Carolina | 37045 | 29544 | 364 |
2414493 | 2414493 | 2022-04-16 | Starr | Texas | 48427 | 19861 | 364 |
2410325 | 2410325 | 2022-04-15 | Cleveland | North Carolina | 37045 | 29544 | 364 |
2411237 | 2411237 | 2022-04-15 | Starr | Texas | 48427 | 19861 | 364 |
2407069 | 2407069 | 2022-04-14 | Cleveland | North Carolina | 37045 | 29544 | 364 |
2407981 | 2407981 | 2022-04-14 | Starr | Texas | 48427 | 19861 | 364 |
2403813 | 2403813 | 2022-04-13 | Cleveland | North Carolina | 37045 | 29544 | 364 |
2404725 | 2404725 | 2022-04-13 | Starr | Texas | 48427 | 19859 | 364 |
2400558 | 2400558 | 2022-04-12 | Cleveland | North Carolina | 37045 | 29535 | 364 |
2401470 | 2401470 | 2022-04-12 | Starr | Texas | 48427 | 19856 | 364 |
2395392 | 2395392 | 2022-04-11 | Cullman | Alabama | 1043 | 24521 | 364 |
2397303 | 2397303 | 2022-04-11 | Cleveland | North Carolina | 37045 | 29535 | 364 |
2398215 | 2398215 | 2022-04-11 | Starr | Texas | 48427 | 19854 | 364 |
2392136 | 2392136 | 2022-04-10 | Cullman | Alabama | 1043 | 24508 | 364 |
2394048 | 2394048 | 2022-04-10 | Cleveland | North Carolina | 37045 | 29535 | 364 |
2394960 | 2394960 | 2022-04-10 | Starr | Texas | 48427 | 19854 | 364 |
2388880 | 2388880 | 2022-04-09 | Cullman | Alabama | 1043 | 24508 | 364 |
2390792 | 2390792 | 2022-04-09 | Cleveland | North Carolina | 37045 | 29535 | 364 |
2391704 | 2391704 | 2022-04-09 | Starr | Texas | 48427 | 19854 | 364 |
2385625 | 2385625 | 2022-04-08 | Cullman | Alabama | 1043 | 24508 | 364 |
2387536 | 2387536 | 2022-04-08 | Cleveland | North Carolina | 37045 | 29535 | 364 |
2388448 | 2388448 | 2022-04-08 | Starr | Texas | 48427 | 19853 | 364 |
2382370 | 2382370 | 2022-04-07 | Cullman | Alabama | 1043 | 24506 | 364 |
2384281 | 2384281 | 2022-04-07 | Cleveland | North Carolina | 37045 | 29535 | 364 |
2385193 | 2385193 | 2022-04-07 | Starr | Texas | 48427 | 19850 | 364 |
2385389 | 2385389 | 2022-04-07 | Roanoke city | Virginia | 51770 | 21223 | 364 |
2379115 | 2379115 | 2022-04-06 | Cullman | Alabama | 1043 | 24504 | 364 |
2381026 | 2381026 | 2022-04-06 | Cleveland | North Carolina | 37045 | 29535 | 364 |
2381938 | 2381938 | 2022-04-06 | Starr | Texas | 48427 | 19849 | 364 |
2375861 | 2375861 | 2022-04-05 | Cullman | Alabama | 1043 | 24501 | 364 |
2377771 | 2377771 | 2022-04-05 | Cleveland | North Carolina | 37045 | 29530 | 364 |
2378403 | 2378403 | 2022-04-05 | Greene | Tennessee | 47059 | 22045 | 364 |
2378683 | 2378683 | 2022-04-05 | Starr | Texas | 48427 | 19846 | 364 |
2372609 | 2372609 | 2022-04-04 | Cullman | Alabama | 1043 | 24501 | 364 |
2374518 | 2374518 | 2022-04-04 | Cleveland | North Carolina | 37045 | 29530 | 364 |
2375149 | 2375149 | 2022-04-04 | Greene | Tennessee | 47059 | 22045 | 364 |
2375429 | 2375429 | 2022-04-04 | Starr | Texas | 48427 | 19842 | 364 |
2369356 | 2369356 | 2022-04-03 | Cullman | Alabama | 1043 | 24499 | 364 |
2371266 | 2371266 | 2022-04-03 | Cleveland | North Carolina | 37045 | 29528 | 364 |
2371897 | 2371897 | 2022-04-03 | Greene | Tennessee | 47059 | 22045 | 364 |
2372177 | 2372177 | 2022-04-03 | Starr | Texas | 48427 | 19842 | 364 |
2366103 | 2366103 | 2022-04-02 | Cullman | Alabama | 1043 | 24499 | 364 |
2368013 | 2368013 | 2022-04-02 | Cleveland | North Carolina | 37045 | 29528 | 364 |
2368644 | 2368644 | 2022-04-02 | Greene | Tennessee | 47059 | 22045 | 364 |
2368924 | 2368924 | 2022-04-02 | Starr | Texas | 48427 | 19842 | 364 |
2362850 | 2362850 | 2022-04-01 | Cullman | Alabama | 1043 | 24499 | 364 |
2364760 | 2364760 | 2022-04-01 | Cleveland | North Carolina | 37045 | 29528 | 364 |
2365391 | 2365391 | 2022-04-01 | Greene | Tennessee | 47059 | 22045 | 364 |
2359596 | 2359596 | 2022-03-31 | Cullman | Alabama | 1043 | 24498 | 364 |
2360975 | 2360975 | 2022-03-31 | Stearns | Minnesota | 27145 | 50679 | 364 |
2361506 | 2361506 | 2022-03-31 | Cleveland | North Carolina | 37045 | 29524 | 364 |
2362138 | 2362138 | 2022-03-31 | Greene | Tennessee | 47059 | 22045 | 364 |
2356342 | 2356342 | 2022-03-30 | Cullman | Alabama | 1043 | 24498 | 364 |
2357721 | 2357721 | 2022-03-30 | Stearns | Minnesota | 27145 | 50671 | 364 |
2358252 | 2358252 | 2022-03-30 | Cleveland | North Carolina | 37045 | 29528 | 364 |
2358884 | 2358884 | 2022-03-30 | Greene | Tennessee | 47059 | 22045 | 364 |
2353089 | 2353089 | 2022-03-29 | Cullman | Alabama | 1043 | 24497 | 364 |
2354468 | 2354468 | 2022-03-29 | Stearns | Minnesota | 27145 | 50663 | 364 |
2354998 | 2354998 | 2022-03-29 | Cleveland | North Carolina | 37045 | 29526 | 364 |
2349837 | 2349837 | 2022-03-28 | Cullman | Alabama | 1043 | 24497 | 364 |
2351216 | 2351216 | 2022-03-28 | Stearns | Minnesota | 27145 | 50649 | 364 |
2351745 | 2351745 | 2022-03-28 | Cleveland | North Carolina | 37045 | 29524 | 364 |
2346584 | 2346584 | 2022-03-27 | Cullman | Alabama | 1043 | 24495 | 364 |
2347963 | 2347963 | 2022-03-27 | Stearns | Minnesota | 27145 | 50638 | 364 |
2348016 | 2348016 | 2022-03-27 | Lauderdale | Mississippi | 28075 | 18746 | 364 |
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);