ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
392 rows where deaths = 444 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 57
- Michigan 43
- Texas 28
- New York 25
- Indiana 24
- Pennsylvania 22
- Alabama 18
- California 18
- Ohio 15
- Tennessee 14
- Georgia 13
- Mississippi 13
- Florida 12
- Louisiana 12
- South Carolina 10
- Washington 8
- Wisconsin 7
- Illinois 6
- Alaska 5
- Connecticut 5
- Kansas 4
- Maryland 4
- Oregon 4
- Arizona 3
- Massachusetts 3
- Minnesota 3
- New Jersey 3
- Delaware 2
- Missouri 2
- Oklahoma 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500297 | 2500297 | 2022-05-13 | Delaware | Indiana | 18035 | 25113 | 444 |
2501561 | 2501561 | 2022-05-13 | Randolph | North Carolina | 37151 | 35874 | 444 |
2497039 | 2497039 | 2022-05-12 | Delaware | Indiana | 18035 | 25067 | 444 |
2498303 | 2498303 | 2022-05-12 | Randolph | North Carolina | 37151 | 35874 | 444 |
2493781 | 2493781 | 2022-05-11 | Delaware | Indiana | 18035 | 25067 | 444 |
2495045 | 2495045 | 2022-05-11 | Randolph | North Carolina | 37151 | 35874 | 444 |
2491787 | 2491787 | 2022-05-10 | Randolph | North Carolina | 37151 | 35737 | 444 |
2488529 | 2488529 | 2022-05-09 | Randolph | North Carolina | 37151 | 35737 | 444 |
2485272 | 2485272 | 2022-05-08 | Randolph | North Carolina | 37151 | 35737 | 444 |
2482014 | 2482014 | 2022-05-07 | Randolph | North Carolina | 37151 | 35737 | 444 |
2478756 | 2478756 | 2022-05-06 | Randolph | North Carolina | 37151 | 35737 | 444 |
2475498 | 2475498 | 2022-05-05 | Randolph | North Carolina | 37151 | 35737 | 444 |
2472241 | 2472241 | 2022-05-04 | Randolph | North Carolina | 37151 | 35737 | 444 |
2467062 | 2467062 | 2022-05-03 | Walker | Alabama | 1127 | 18741 | 444 |
2467397 | 2467397 | 2022-05-03 | Bartow | Georgia | 13015 | 29463 | 444 |
2464142 | 2464142 | 2022-05-02 | Bartow | Georgia | 13015 | 29463 | 444 |
2460886 | 2460886 | 2022-05-01 | Bartow | Georgia | 13015 | 29465 | 444 |
2457630 | 2457630 | 2022-04-30 | Bartow | Georgia | 13015 | 29465 | 444 |
2454374 | 2454374 | 2022-04-29 | Bartow | Georgia | 13015 | 29465 | 444 |
2451118 | 2451118 | 2022-04-28 | Bartow | Georgia | 13015 | 29465 | 444 |
2447862 | 2447862 | 2022-04-27 | Bartow | Georgia | 13015 | 29465 | 444 |
2441154 | 2441154 | 2022-04-25 | Kings | California | 6031 | 55220 | 444 |
2437898 | 2437898 | 2022-04-24 | Kings | California | 6031 | 55220 | 444 |
2434642 | 2434642 | 2022-04-23 | Kings | California | 6031 | 55220 | 444 |
2431386 | 2431386 | 2022-04-22 | Kings | California | 6031 | 55220 | 444 |
2422708 | 2422708 | 2022-04-19 | Livingston | Michigan | 26093 | 46243 | 444 |
2419452 | 2419452 | 2022-04-18 | Livingston | Michigan | 26093 | 46243 | 444 |
2416196 | 2416196 | 2022-04-17 | Livingston | Michigan | 26093 | 46243 | 444 |
2412940 | 2412940 | 2022-04-16 | Livingston | Michigan | 26093 | 46243 | 444 |
2409684 | 2409684 | 2022-04-15 | Livingston | Michigan | 26093 | 46243 | 444 |
2405338 | 2405338 | 2022-04-14 | Kings | California | 6031 | 55162 | 444 |
2406428 | 2406428 | 2022-04-14 | Livingston | Michigan | 26093 | 46243 | 444 |
2402083 | 2402083 | 2022-04-13 | Kings | California | 6031 | 55143 | 444 |
2403172 | 2403172 | 2022-04-13 | Livingston | Michigan | 26093 | 46243 | 444 |
2397801 | 2397801 | 2022-04-11 | Berkeley | South Carolina | 45015 | 51716 | 444 |
2394546 | 2394546 | 2022-04-10 | Berkeley | South Carolina | 45015 | 51716 | 444 |
2391290 | 2391290 | 2022-04-09 | Berkeley | South Carolina | 45015 | 51716 | 444 |
2388034 | 2388034 | 2022-04-08 | Berkeley | South Carolina | 45015 | 51716 | 444 |
2384779 | 2384779 | 2022-04-07 | Berkeley | South Carolina | 45015 | 51716 | 444 |
2379506 | 2379506 | 2022-04-06 | Carroll | Georgia | 13045 | 23747 | 444 |
2381228 | 2381228 | 2022-04-06 | Portage | Ohio | 39133 | 34094 | 444 |
2381524 | 2381524 | 2022-04-06 | Berkeley | South Carolina | 45015 | 51716 | 444 |
2377973 | 2377973 | 2022-04-05 | Portage | Ohio | 39133 | 34094 | 444 |
2378269 | 2378269 | 2022-04-05 | Berkeley | South Carolina | 45015 | 51716 | 444 |
2374719 | 2374719 | 2022-04-04 | Portage | Ohio | 39133 | 34094 | 444 |
2371292 | 2371292 | 2022-04-03 | Iredell | North Carolina | 37097 | 48298 | 444 |
2371467 | 2371467 | 2022-04-03 | Portage | Ohio | 39133 | 34094 | 444 |
2368039 | 2368039 | 2022-04-02 | Iredell | North Carolina | 37097 | 48298 | 444 |
2368214 | 2368214 | 2022-04-02 | Portage | Ohio | 39133 | 34094 | 444 |
2364786 | 2364786 | 2022-04-01 | Iredell | North Carolina | 37097 | 48298 | 444 |
2364961 | 2364961 | 2022-04-01 | Portage | Ohio | 39133 | 34094 | 444 |
2361532 | 2361532 | 2022-03-31 | Iredell | North Carolina | 37097 | 48293 | 444 |
2361708 | 2361708 | 2022-03-31 | Portage | Ohio | 39133 | 34094 | 444 |
2356818 | 2356818 | 2022-03-30 | Newton | Georgia | 13217 | 24557 | 444 |
2358278 | 2358278 | 2022-03-30 | Iredell | North Carolina | 37097 | 48286 | 444 |
2353565 | 2353565 | 2022-03-29 | Newton | Georgia | 13217 | 24480 | 444 |
2355024 | 2355024 | 2022-03-29 | Iredell | North Carolina | 37097 | 48276 | 444 |
2350554 | 2350554 | 2022-03-28 | Howard | Indiana | 18067 | 25396 | 444 |
2346765 | 2346765 | 2022-03-27 | Kings | California | 6031 | 55018 | 444 |
2347301 | 2347301 | 2022-03-27 | Howard | Indiana | 18067 | 25391 | 444 |
2343512 | 2343512 | 2022-03-26 | Kings | California | 6031 | 55018 | 444 |
2344048 | 2344048 | 2022-03-26 | Howard | Indiana | 18067 | 25391 | 444 |
2340259 | 2340259 | 2022-03-25 | Kings | California | 6031 | 55018 | 444 |
2340795 | 2340795 | 2022-03-25 | Howard | Indiana | 18067 | 25391 | 444 |
2337542 | 2337542 | 2022-03-24 | Howard | Indiana | 18067 | 25384 | 444 |
2334288 | 2334288 | 2022-03-23 | Howard | Indiana | 18067 | 25385 | 444 |
2331034 | 2331034 | 2022-03-22 | Howard | Indiana | 18067 | 25380 | 444 |
2329855 | 2329855 | 2022-03-21 | Parker | Texas | 48367 | 34133 | 444 |
2279702 | 2279702 | 2022-03-06 | Jackson | Mississippi | 28059 | 36743 | 444 |
2276449 | 2276449 | 2022-03-05 | Jackson | Mississippi | 28059 | 36743 | 444 |
2273196 | 2273196 | 2022-03-04 | Jackson | Mississippi | 28059 | 36743 | 444 |
2240539 | 2240539 | 2022-02-22 | Monroe | Michigan | 26115 | 37373 | 444 |
2242191 | 2242191 | 2022-02-22 | Chesapeake city | Virginia | 51550 | 49023 | 444 |
2237288 | 2237288 | 2022-02-21 | Monroe | Michigan | 26115 | 37373 | 444 |
2233889 | 2233889 | 2022-02-20 | Livingston | Louisiana | 22063 | 36759 | 444 |
2234037 | 2234037 | 2022-02-20 | Monroe | Michigan | 26115 | 37373 | 444 |
2230638 | 2230638 | 2022-02-19 | Livingston | Louisiana | 22063 | 36759 | 444 |
2227387 | 2227387 | 2022-02-18 | Livingston | Louisiana | 22063 | 36759 | 444 |
2221982 | 2221982 | 2022-02-16 | Lane | Oregon | 41039 | 55088 | 444 |
2211974 | 2211974 | 2022-02-13 | Union | North Carolina | 37179 | 59707 | 444 |
2208721 | 2208721 | 2022-02-12 | Union | North Carolina | 37179 | 59707 | 444 |
2205468 | 2205468 | 2022-02-11 | Union | North Carolina | 37179 | 59707 | 444 |
2201348 | 2201348 | 2022-02-10 | Bossier | Louisiana | 22015 | 36835 | 444 |
2199402 | 2199402 | 2022-02-09 | Dorchester | South Carolina | 45035 | 54614 | 444 |
2196148 | 2196148 | 2022-02-08 | Dorchester | South Carolina | 45035 | 54472 | 444 |
2196338 | 2196338 | 2022-02-08 | Wilson | Tennessee | 47189 | 39029 | 444 |
2196873 | 2196873 | 2022-02-08 | Brown | Wisconsin | 55009 | 82300 | 444 |
2190554 | 2190554 | 2022-02-07 | Coconino | Arizona | 4005 | 41531 | 444 |
2192894 | 2192894 | 2022-02-07 | Dorchester | South Carolina | 45035 | 54399 | 444 |
2193084 | 2193084 | 2022-02-07 | Wilson | Tennessee | 47189 | 39029 | 444 |
2187301 | 2187301 | 2022-02-06 | Coconino | Arizona | 4005 | 41461 | 444 |
2189830 | 2189830 | 2022-02-06 | Wilson | Tennessee | 47189 | 39029 | 444 |
2184048 | 2184048 | 2022-02-05 | Coconino | Arizona | 4005 | 41343 | 444 |
2186577 | 2186577 | 2022-02-05 | Wilson | Tennessee | 47189 | 39029 | 444 |
2183325 | 2183325 | 2022-02-04 | Wilson | Tennessee | 47189 | 39029 | 444 |
2183516 | 2183516 | 2022-02-04 | Randall | Texas | 48381 | 36539 | 444 |
2180073 | 2180073 | 2022-02-03 | Wilson | Tennessee | 47189 | 39029 | 444 |
2175345 | 2175345 | 2022-02-02 | Lafayette | Louisiana | 22055 | 59248 | 444 |
2175605 | 2175605 | 2022-02-02 | Washington | Minnesota | 27163 | 62787 | 444 |
2176822 | 2176822 | 2022-02-02 | Wilson | Tennessee | 47189 | 39029 | 444 |
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);