ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
275 rows where cases = 1986 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- Virginia 22
- Kentucky 20
- Iowa 19
- Minnesota 17
- Florida 16
- Georgia 14
- North Carolina 12
- Arkansas 10
- Mississippi 9
- Illinois 8
- Puerto Rico 8
- Missouri 7
- West Virginia 7
- Alabama 6
- New York 6
- Pennsylvania 6
- Wisconsin 6
- Ohio 5
- South Carolina 5
- Tennessee 5
- Montana 4
- Nebraska 4
- Oregon 4
- Idaho 3
- Louisiana 3
- Massachusetts 3
- Oklahoma 3
- Vermont 3
- Indiana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473463 | 2473463 | 2022-05-04 | Pepin | Wisconsin | 55091 | 1986 | 18 |
2444731 | 2444731 | 2022-04-26 | Taylor | Georgia | 13269 | 1986 | 53 |
2441475 | 2441475 | 2022-04-25 | Taylor | Georgia | 13269 | 1986 | 53 |
2438219 | 2438219 | 2022-04-24 | Taylor | Georgia | 13269 | 1986 | 53 |
2434963 | 2434963 | 2022-04-23 | Taylor | Georgia | 13269 | 1986 | 53 |
2431707 | 2431707 | 2022-04-22 | Taylor | Georgia | 13269 | 1986 | 53 |
2428271 | 2428271 | 2022-04-21 | Glades | Florida | 12043 | 1986 | 36 |
2428451 | 2428451 | 2022-04-21 | Taylor | Georgia | 13269 | 1986 | 53 |
2425015 | 2425015 | 2022-04-20 | Glades | Florida | 12043 | 1986 | 36 |
2425195 | 2425195 | 2022-04-20 | Taylor | Georgia | 13269 | 1986 | 53 |
2421759 | 2421759 | 2022-04-19 | Glades | Florida | 12043 | 1986 | 36 |
2418503 | 2418503 | 2022-04-18 | Glades | Florida | 12043 | 1986 | 36 |
2415247 | 2415247 | 2022-04-17 | Glades | Florida | 12043 | 1986 | 36 |
2411991 | 2411991 | 2022-04-16 | Glades | Florida | 12043 | 1986 | 36 |
2408735 | 2408735 | 2022-04-15 | Glades | Florida | 12043 | 1986 | 36 |
2405479 | 2405479 | 2022-04-14 | Glades | Florida | 12043 | 1986 | 36 |
2402224 | 2402224 | 2022-04-13 | Glades | Florida | 12043 | 1986 | 36 |
2398969 | 2398969 | 2022-04-12 | Glades | Florida | 12043 | 1986 | 36 |
2395714 | 2395714 | 2022-04-11 | Glades | Florida | 12043 | 1986 | 36 |
2392458 | 2392458 | 2022-04-10 | Glades | Florida | 12043 | 1986 | 36 |
2393503 | 2393503 | 2022-04-10 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2389202 | 2389202 | 2022-04-09 | Glades | Florida | 12043 | 1986 | 36 |
2390247 | 2390247 | 2022-04-09 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2385947 | 2385947 | 2022-04-08 | Glades | Florida | 12043 | 1986 | 36 |
2386991 | 2386991 | 2022-04-08 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2383736 | 2383736 | 2022-04-07 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2380481 | 2380481 | 2022-04-06 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2377226 | 2377226 | 2022-04-05 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2373974 | 2373974 | 2022-04-04 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2370721 | 2370721 | 2022-04-03 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2372305 | 2372305 | 2022-04-03 | Falls Church city | Virginia | 51610 | 1986 | 16 |
2367468 | 2367468 | 2022-04-02 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2369052 | 2369052 | 2022-04-02 | Falls Church city | Virginia | 51610 | 1986 | 16 |
2364215 | 2364215 | 2022-04-01 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2365799 | 2365799 | 2022-04-01 | Falls Church city | Virginia | 51610 | 1986 | 16 |
2360961 | 2360961 | 2022-03-31 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2361967 | 2361967 | 2022-03-31 | Patillas | Puerto Rico | 72109 | 1986 | |
2358713 | 2358713 | 2022-03-30 | Patillas | Puerto Rico | 72109 | 1986 | |
2254606 | 2254606 | 2022-02-26 | Guayanilla | Puerto Rico | 72059 | 1986 | |
2224361 | 2224361 | 2022-02-17 | Murray | Minnesota | 27101 | 1986 | 15 |
2220300 | 2220300 | 2022-02-16 | Boundary | Idaho | 16021 | 1986 | 56 |
2196824 | 2196824 | 2022-02-08 | Gilmer | West Virginia | 54021 | 1986 | 17 |
2193140 | 2193140 | 2022-02-07 | Dallam | Texas | 48111 | 1986 | 36 |
2188234 | 2188234 | 2022-02-06 | Cumberland | Kentucky | 21057 | 1986 | 24 |
2189886 | 2189886 | 2022-02-06 | Dallam | Texas | 48111 | 1986 | 36 |
2184981 | 2184981 | 2022-02-05 | Cumberland | Kentucky | 21057 | 1986 | 24 |
2186322 | 2186322 | 2022-02-05 | Jayuya | Puerto Rico | 72073 | 1986 | |
2186633 | 2186633 | 2022-02-05 | Dallam | Texas | 48111 | 1986 | 36 |
2181729 | 2181729 | 2022-02-04 | Cumberland | Kentucky | 21057 | 1986 | 24 |
2166378 | 2166378 | 2022-01-30 | Graham | North Carolina | 37075 | 1986 | 30 |
2163123 | 2163123 | 2022-01-29 | Graham | North Carolina | 37075 | 1986 | 30 |
2159868 | 2159868 | 2022-01-28 | Graham | North Carolina | 37075 | 1986 | 30 |
2146652 | 2146652 | 2022-01-24 | Phelps | Nebraska | 31137 | 1986 | 11 |
2142233 | 2142233 | 2022-01-23 | Clearwater | Idaho | 16035 | 1986 | 29 |
2144626 | 2144626 | 2022-01-23 | Essex | Virginia | 51057 | 1986 | 22 |
2138978 | 2138978 | 2022-01-22 | Clearwater | Idaho | 16035 | 1986 | 29 |
2141371 | 2141371 | 2022-01-22 | Essex | Virginia | 51057 | 1986 | 22 |
2138115 | 2138115 | 2022-01-21 | Essex | Virginia | 51057 | 1986 | 22 |
2132501 | 2132501 | 2022-01-20 | Brown | Illinois | 17009 | 1986 | 19 |
2103455 | 2103455 | 2022-01-11 | Emmet | Iowa | 19063 | 1986 | 49 |
2100204 | 2100204 | 2022-01-10 | Emmet | Iowa | 19063 | 1986 | 49 |
2096953 | 2096953 | 2022-01-09 | Emmet | Iowa | 19063 | 1986 | 49 |
2097612 | 2097612 | 2022-01-09 | Tunica | Mississippi | 28143 | 1986 | 40 |
2093701 | 2093701 | 2022-01-08 | Emmet | Iowa | 19063 | 1986 | 49 |
2094360 | 2094360 | 2022-01-08 | Tunica | Mississippi | 28143 | 1986 | 40 |
2090449 | 2090449 | 2022-01-07 | Emmet | Iowa | 19063 | 1986 | 49 |
2091108 | 2091108 | 2022-01-07 | Tunica | Mississippi | 28143 | 1986 | 40 |
2087198 | 2087198 | 2022-01-06 | Emmet | Iowa | 19063 | 1986 | 49 |
2083946 | 2083946 | 2022-01-05 | Emmet | Iowa | 19063 | 1986 | 49 |
2080728 | 2080728 | 2022-01-04 | Mitchell | Iowa | 19131 | 1986 | 47 |
2081397 | 2081397 | 2022-01-04 | Douglas | Missouri | 29067 | 1986 | 67 |
2082809 | 2082809 | 2022-01-04 | Brunswick | Virginia | 51025 | 1986 | 36 |
2077476 | 2077476 | 2022-01-03 | Mitchell | Iowa | 19131 | 1986 | 47 |
2074225 | 2074225 | 2022-01-02 | Mitchell | Iowa | 19131 | 1986 | 47 |
2070974 | 2070974 | 2022-01-01 | Mitchell | Iowa | 19131 | 1986 | 47 |
2067723 | 2067723 | 2021-12-31 | Mitchell | Iowa | 19131 | 1986 | 47 |
2064472 | 2064472 | 2021-12-30 | Mitchell | Iowa | 19131 | 1986 | 47 |
2061222 | 2061222 | 2021-12-29 | Mitchell | Iowa | 19131 | 1986 | 47 |
2056432 | 2056432 | 2021-12-27 | Houston | Tennessee | 47083 | 1986 | 51 |
2034494 | 2034494 | 2021-12-21 | Desha | Arkansas | 5041 | 1986 | 35 |
2035474 | 2035474 | 2021-12-21 | Todd | Kentucky | 21219 | 1986 | 37 |
2037506 | 2037506 | 2021-12-21 | Roane | West Virginia | 54087 | 1986 | 27 |
2031244 | 2031244 | 2021-12-20 | Desha | Arkansas | 5041 | 1986 | 35 |
2023710 | 2023710 | 2021-12-17 | Catano | Puerto Rico | 72033 | 1986 | |
2013264 | 2013264 | 2021-12-14 | Richland | Montana | 30083 | 1986 | 24 |
2010013 | 2010013 | 2021-12-13 | Richland | Montana | 30083 | 1986 | 24 |
2011339 | 2011339 | 2021-12-13 | Greensville | Virginia | 51081 | 1986 | 27 |
1996020 | 1996020 | 2021-12-09 | Menard | Illinois | 17129 | 1986 | 19 |
1983590 | 1983590 | 2021-12-05 | Nantucket | Massachusetts | 25019 | 1986 | 0 |
1980340 | 1980340 | 2021-12-04 | Nantucket | Massachusetts | 25019 | 1986 | 0 |
1977090 | 1977090 | 2021-12-03 | Nantucket | Massachusetts | 25019 | 1986 | 0 |
1966374 | 1966374 | 2021-11-30 | Gunnison | Colorado | 8051 | 1986 | 12 |
1944733 | 1944733 | 2021-11-23 | Pope | Minnesota | 27121 | 1986 | 10 |
1924462 | 1924462 | 2021-11-17 | Cumberland | Illinois | 17035 | 1986 | 39 |
1918417 | 1918417 | 2021-11-15 | Lyon | Kentucky | 21143 | 1986 | 26 |
1903216 | 1903216 | 2021-11-10 | Morgan | Ohio | 39115 | 1986 | 37 |
1873842 | 1873842 | 2021-11-01 | Swain | North Carolina | 37173 | 1986 | 24 |
1860038 | 1860038 | 2021-10-28 | West Carroll | Louisiana | 22123 | 1986 | 48 |
1856803 | 1856803 | 2021-10-27 | Sagadahoc | Maine | 23023 | 1986 | 13 |
1858764 | 1858764 | 2021-10-27 | Buffalo | Wisconsin | 55011 | 1986 | 8 |
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);