ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
336 rows where deaths = 419 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 47
- Georgia 38
- Texas 38
- California 23
- Arkansas 17
- Louisiana 15
- Alaska 14
- Indiana 13
- Ohio 11
- Alabama 10
- Virginia 10
- Michigan 9
- New York 9
- Wisconsin 9
- Florida 7
- South Carolina 7
- Mississippi 6
- Illinois 5
- New Jersey 5
- New Mexico 5
- Maryland 4
- Minnesota 4
- North Carolina 4
- Tennessee 4
- Arizona 3
- Connecticut 3
- Colorado 2
- Iowa 2
- South Dakota 2
- Utah 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500753 | 2500753 | 2022-05-13 | Terrebonne | Louisiana | 22109 | 31012 | 419 |
2497495 | 2497495 | 2022-05-12 | Terrebonne | Louisiana | 22109 | 30992 | 419 |
2494237 | 2494237 | 2022-05-11 | Terrebonne | Louisiana | 22109 | 30976 | 419 |
2490979 | 2490979 | 2022-05-10 | Terrebonne | Louisiana | 22109 | 30962 | 419 |
2487722 | 2487722 | 2022-05-09 | Terrebonne | Louisiana | 22109 | 30951 | 419 |
2484464 | 2484464 | 2022-05-08 | Terrebonne | Louisiana | 22109 | 30943 | 419 |
2481206 | 2481206 | 2022-05-07 | Terrebonne | Louisiana | 22109 | 30943 | 419 |
2477948 | 2477948 | 2022-05-06 | Terrebonne | Louisiana | 22109 | 30943 | 419 |
2467515 | 2467515 | 2022-05-03 | Spalding | Georgia | 13255 | 15888 | 419 |
2464260 | 2464260 | 2022-05-02 | Spalding | Georgia | 13255 | 15888 | 419 |
2461004 | 2461004 | 2022-05-01 | Spalding | Georgia | 13255 | 15887 | 419 |
2457748 | 2457748 | 2022-04-30 | Spalding | Georgia | 13255 | 15887 | 419 |
2454492 | 2454492 | 2022-04-29 | Spalding | Georgia | 13255 | 15887 | 419 |
2451236 | 2451236 | 2022-04-28 | Spalding | Georgia | 13255 | 15887 | 419 |
2447980 | 2447980 | 2022-04-27 | Spalding | Georgia | 13255 | 15887 | 419 |
2403724 | 2403724 | 2022-04-13 | Sandoval | New Mexico | 35043 | 33532 | 419 |
2400469 | 2400469 | 2022-04-12 | Sandoval | New Mexico | 35043 | 33519 | 419 |
2397214 | 2397214 | 2022-04-11 | Sandoval | New Mexico | 35043 | 33508 | 419 |
2327590 | 2327590 | 2022-03-21 | Whitfield | Georgia | 13313 | 34022 | 419 |
2326526 | 2326526 | 2022-03-20 | Henderson | Texas | 48213 | 15355 | 419 |
2323273 | 2323273 | 2022-03-19 | Henderson | Texas | 48213 | 15353 | 419 |
2320019 | 2320019 | 2022-03-18 | Henderson | Texas | 48213 | 15353 | 419 |
2314530 | 2314530 | 2022-03-17 | Paulding | Georgia | 13223 | 37867 | 419 |
2315317 | 2315317 | 2022-03-17 | Lapeer | Michigan | 26087 | 20719 | 419 |
2316765 | 2316765 | 2022-03-17 | Henderson | Texas | 48213 | 15352 | 419 |
2311277 | 2311277 | 2022-03-16 | Paulding | Georgia | 13223 | 37856 | 419 |
2312064 | 2312064 | 2022-03-16 | Lapeer | Michigan | 26087 | 20719 | 419 |
2313512 | 2313512 | 2022-03-16 | Henderson | Texas | 48213 | 15352 | 419 |
2308024 | 2308024 | 2022-03-15 | Paulding | Georgia | 13223 | 37850 | 419 |
2308062 | 2308062 | 2022-03-15 | Walton | Georgia | 13297 | 21972 | 419 |
2310259 | 2310259 | 2022-03-15 | Henderson | Texas | 48213 | 15351 | 419 |
2304773 | 2304773 | 2022-03-14 | Paulding | Georgia | 13223 | 37847 | 419 |
2304811 | 2304811 | 2022-03-14 | Walton | Georgia | 13297 | 21970 | 419 |
2301521 | 2301521 | 2022-03-13 | Paulding | Georgia | 13223 | 37838 | 419 |
2301559 | 2301559 | 2022-03-13 | Walton | Georgia | 13297 | 21963 | 419 |
2298269 | 2298269 | 2022-03-12 | Paulding | Georgia | 13223 | 37838 | 419 |
2298307 | 2298307 | 2022-03-12 | Walton | Georgia | 13297 | 21963 | 419 |
2300415 | 2300415 | 2022-03-12 | Bowie | Texas | 48037 | 19933 | 419 |
2295017 | 2295017 | 2022-03-11 | Paulding | Georgia | 13223 | 37838 | 419 |
2295055 | 2295055 | 2022-03-11 | Walton | Georgia | 13297 | 21963 | 419 |
2291765 | 2291765 | 2022-03-10 | Paulding | Georgia | 13223 | 37832 | 419 |
2278319 | 2278319 | 2022-03-06 | Walker | Alabama | 1127 | 18484 | 419 |
2275066 | 2275066 | 2022-03-05 | Walker | Alabama | 1127 | 18484 | 419 |
2271813 | 2271813 | 2022-03-04 | Walker | Alabama | 1127 | 18484 | 419 |
2268561 | 2268561 | 2022-03-03 | Walker | Alabama | 1127 | 18480 | 419 |
2261170 | 2261170 | 2022-02-28 | Berkeley | South Carolina | 45015 | 51425 | 419 |
2246152 | 2246152 | 2022-02-24 | Carroll | Georgia | 13045 | 23629 | 419 |
2248160 | 2248160 | 2022-02-24 | Aiken | South Carolina | 45003 | 40777 | 419 |
2240963 | 2240963 | 2022-02-22 | Lancaster | Nebraska | 31109 | 73246 | 419 |
2242048 | 2242048 | 2022-02-22 | Parker | Texas | 48367 | 33713 | 419 |
2219958 | 2219958 | 2022-02-16 | San Luis Obispo | California | 6079 | 54369 | 419 |
2222640 | 2222640 | 2022-02-16 | Washington | Utah | 49053 | 44119 | 419 |
2216683 | 2216683 | 2022-02-15 | Kings | California | 6031 | 52661 | 419 |
2212994 | 2212994 | 2022-02-13 | Norfolk city | Virginia | 51710 | 40662 | 419 |
2209741 | 2209741 | 2022-02-12 | Norfolk city | Virginia | 51710 | 40662 | 419 |
2206488 | 2206488 | 2022-02-11 | Norfolk city | Virginia | 51710 | 40662 | 419 |
2196747 | 2196747 | 2022-02-08 | Richmond city | Virginia | 51760 | 42618 | 419 |
2190691 | 2190691 | 2022-02-07 | Solano | California | 6095 | 78659 | 419 |
2172243 | 2172243 | 2022-02-01 | Monroe | Michigan | 26115 | 36243 | 419 |
2168990 | 2168990 | 2022-01-31 | Monroe | Michigan | 26115 | 36243 | 419 |
2165735 | 2165735 | 2022-01-30 | Monroe | Michigan | 26115 | 35968 | 419 |
2162480 | 2162480 | 2022-01-29 | Monroe | Michigan | 26115 | 35968 | 419 |
2159225 | 2159225 | 2022-01-28 | Monroe | Michigan | 26115 | 35968 | 419 |
2156778 | 2156778 | 2022-01-27 | Licking | Ohio | 39089 | 39390 | 419 |
2153525 | 2153525 | 2022-01-26 | Licking | Ohio | 39089 | 39155 | 419 |
2148593 | 2148593 | 2022-01-25 | Coweta | Georgia | 13077 | 30862 | 419 |
2150273 | 2150273 | 2022-01-25 | Licking | Ohio | 39089 | 38816 | 419 |
2132342 | 2132342 | 2022-01-20 | Floyd | Georgia | 13115 | 24364 | 419 |
2134009 | 2134009 | 2022-01-20 | Medina | Ohio | 39103 | 38036 | 419 |
2130118 | 2130118 | 2022-01-19 | Rankin | Mississippi | 28121 | 30112 | 419 |
2130757 | 2130757 | 2022-01-19 | Medina | Ohio | 39103 | 37850 | 419 |
2125563 | 2125563 | 2022-01-18 | Sebastian | Arkansas | 5131 | 27928 | 419 |
2126517 | 2126517 | 2022-01-18 | Bossier | Louisiana | 22015 | 30468 | 419 |
2126864 | 2126864 | 2022-01-18 | Rankin | Mississippi | 28121 | 29759 | 419 |
2127503 | 2127503 | 2022-01-18 | Medina | Ohio | 39103 | 37708 | 419 |
2122311 | 2122311 | 2022-01-17 | Sebastian | Arkansas | 5131 | 27845 | 419 |
2119059 | 2119059 | 2022-01-16 | Sebastian | Arkansas | 5131 | 27755 | 419 |
2115166 | 2115166 | 2022-01-14 | Maverick | Texas | 48323 | 15322 | 419 |
2111914 | 2111914 | 2022-01-13 | Maverick | Texas | 48323 | 16029 | 419 |
2107288 | 2107288 | 2022-01-12 | Washington | Minnesota | 27163 | 50725 | 419 |
2108662 | 2108662 | 2022-01-12 | Maverick | Texas | 48323 | 15868 | 419 |
2102695 | 2102695 | 2022-01-11 | Anchorage | Alaska | 2020 | 69886 | 419 |
2105411 | 2105411 | 2022-01-11 | Maverick | Texas | 48323 | 15544 | 419 |
2105443 | 2105443 | 2022-01-11 | Randall | Texas | 48381 | 30366 | 419 |
2099444 | 2099444 | 2022-01-10 | Anchorage | Alaska | 2020 | 69886 | 419 |
2096193 | 2096193 | 2022-01-09 | Anchorage | Alaska | 2020 | 68113 | 419 |
2096360 | 2096360 | 2022-01-09 | Sonoma | California | 6097 | 50878 | 419 |
2097275 | 2097275 | 2022-01-09 | Lafayette | Louisiana | 22055 | 45306 | 419 |
2092941 | 2092941 | 2022-01-08 | Anchorage | Alaska | 2020 | 68113 | 419 |
2093108 | 2093108 | 2022-01-08 | Sonoma | California | 6097 | 50878 | 419 |
2094023 | 2094023 | 2022-01-08 | Lafayette | Louisiana | 22055 | 45306 | 419 |
2089689 | 2089689 | 2022-01-07 | Anchorage | Alaska | 2020 | 68113 | 419 |
2089856 | 2089856 | 2022-01-07 | Sonoma | California | 6097 | 50878 | 419 |
2090771 | 2090771 | 2022-01-07 | Lafayette | Louisiana | 22055 | 45306 | 419 |
2086438 | 2086438 | 2022-01-06 | Anchorage | Alaska | 2020 | 65810 | 419 |
2087520 | 2087520 | 2022-01-06 | Lafayette | Louisiana | 22055 | 44647 | 419 |
2083186 | 2083186 | 2022-01-05 | Anchorage | Alaska | 2020 | 65105 | 419 |
2084268 | 2084268 | 2022-01-05 | Lafayette | Louisiana | 22055 | 43844 | 419 |
2079934 | 2079934 | 2022-01-04 | Anchorage | Alaska | 2020 | 65105 | 419 |
2082176 | 2082176 | 2022-01-04 | Monroe | Pennsylvania | 42089 | 27601 | 419 |
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);