ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
286 rows where cases = 2716 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 50
- Tennessee 21
- Georgia 18
- Virginia 12
- Florida 11
- Louisiana 10
- Minnesota 10
- Mississippi 10
- Wisconsin 10
- Illinois 9
- Texas 9
- Indiana 8
- Missouri 8
- Washington 8
- Idaho 7
- Kentucky 6
- Michigan 6
- New York 6
- North Dakota 6
- West Virginia 6
- Alaska 5
- North Carolina 5
- Alabama 4
- Kansas 4
- Ohio 4
- Utah 4
- Arkansas 3
- Montana 3
- Nebraska 3
- Pennsylvania 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467879 | 2467879 | 2022-05-03 | Shelby | Iowa | 19165 | 2716 | 50 |
2467884 | 2467884 | 2022-05-03 | Union | Iowa | 19175 | 2716 | 51 |
2464624 | 2464624 | 2022-05-02 | Shelby | Iowa | 19165 | 2716 | 50 |
2464629 | 2464629 | 2022-05-02 | Union | Iowa | 19175 | 2716 | 51 |
2461368 | 2461368 | 2022-05-01 | Shelby | Iowa | 19165 | 2716 | 50 |
2461373 | 2461373 | 2022-05-01 | Union | Iowa | 19175 | 2716 | 51 |
2458112 | 2458112 | 2022-04-30 | Shelby | Iowa | 19165 | 2716 | 50 |
2458117 | 2458117 | 2022-04-30 | Union | Iowa | 19175 | 2716 | 51 |
2454856 | 2454856 | 2022-04-29 | Shelby | Iowa | 19165 | 2716 | 50 |
2454861 | 2454861 | 2022-04-29 | Union | Iowa | 19175 | 2716 | 51 |
2451600 | 2451600 | 2022-04-28 | Shelby | Iowa | 19165 | 2716 | 50 |
2451605 | 2451605 | 2022-04-28 | Union | Iowa | 19175 | 2716 | 51 |
2448344 | 2448344 | 2022-04-27 | Shelby | Iowa | 19165 | 2716 | 50 |
2448349 | 2448349 | 2022-04-27 | Union | Iowa | 19175 | 2716 | 51 |
2444806 | 2444806 | 2022-04-26 | Teton | Idaho | 16081 | 2716 | 9 |
2445088 | 2445088 | 2022-04-26 | Shelby | Iowa | 19165 | 2716 | 50 |
2441550 | 2441550 | 2022-04-25 | Teton | Idaho | 16081 | 2716 | 9 |
2441832 | 2441832 | 2022-04-25 | Shelby | Iowa | 19165 | 2716 | 50 |
2438294 | 2438294 | 2022-04-24 | Teton | Idaho | 16081 | 2716 | 9 |
2438576 | 2438576 | 2022-04-24 | Shelby | Iowa | 19165 | 2716 | 50 |
2435038 | 2435038 | 2022-04-23 | Teton | Idaho | 16081 | 2716 | 9 |
2435320 | 2435320 | 2022-04-23 | Shelby | Iowa | 19165 | 2716 | 50 |
2436846 | 2436846 | 2022-04-23 | Santa Isabel | Puerto Rico | 72133 | 2716 | |
2431782 | 2431782 | 2022-04-22 | Teton | Idaho | 16081 | 2716 | 9 |
2432064 | 2432064 | 2022-04-22 | Shelby | Iowa | 19165 | 2716 | 50 |
2428526 | 2428526 | 2022-04-21 | Teton | Idaho | 16081 | 2716 | 9 |
2428808 | 2428808 | 2022-04-21 | Shelby | Iowa | 19165 | 2716 | 50 |
2425270 | 2425270 | 2022-04-20 | Teton | Idaho | 16081 | 2716 | 9 |
2425552 | 2425552 | 2022-04-20 | Shelby | Iowa | 19165 | 2716 | 50 |
2422296 | 2422296 | 2022-04-19 | Shelby | Iowa | 19165 | 2716 | 50 |
2422301 | 2422301 | 2022-04-19 | Union | Iowa | 19175 | 2716 | 50 |
2419040 | 2419040 | 2022-04-18 | Shelby | Iowa | 19165 | 2716 | 50 |
2419045 | 2419045 | 2022-04-18 | Union | Iowa | 19175 | 2716 | 50 |
2415784 | 2415784 | 2022-04-17 | Shelby | Iowa | 19165 | 2716 | 50 |
2415789 | 2415789 | 2022-04-17 | Union | Iowa | 19175 | 2716 | 50 |
2412528 | 2412528 | 2022-04-16 | Shelby | Iowa | 19165 | 2716 | 50 |
2412533 | 2412533 | 2022-04-16 | Union | Iowa | 19175 | 2716 | 50 |
2409272 | 2409272 | 2022-04-15 | Shelby | Iowa | 19165 | 2716 | 50 |
2409277 | 2409277 | 2022-04-15 | Union | Iowa | 19175 | 2716 | 50 |
2406016 | 2406016 | 2022-04-14 | Shelby | Iowa | 19165 | 2716 | 50 |
2406021 | 2406021 | 2022-04-14 | Union | Iowa | 19175 | 2716 | 50 |
2402760 | 2402760 | 2022-04-13 | Shelby | Iowa | 19165 | 2716 | 50 |
2402765 | 2402765 | 2022-04-13 | Union | Iowa | 19175 | 2716 | 50 |
2376724 | 2376724 | 2022-04-05 | Union | Iowa | 19175 | 2716 | 49 |
2373472 | 2373472 | 2022-04-04 | Union | Iowa | 19175 | 2716 | 49 |
2370219 | 2370219 | 2022-04-03 | Union | Iowa | 19175 | 2716 | 49 |
2366966 | 2366966 | 2022-04-02 | Union | Iowa | 19175 | 2716 | 49 |
2363713 | 2363713 | 2022-04-01 | Union | Iowa | 19175 | 2716 | 49 |
2360459 | 2360459 | 2022-03-31 | Union | Iowa | 19175 | 2716 | 49 |
2357205 | 2357205 | 2022-03-30 | Union | Iowa | 19175 | 2716 | 49 |
2316844 | 2316844 | 2022-03-17 | Pecos | Texas | 48371 | 2716 | 71 |
2312812 | 2312812 | 2022-03-16 | McLean | North Dakota | 38055 | 2716 | 49 |
2309559 | 2309559 | 2022-03-15 | McLean | North Dakota | 38055 | 2716 | 49 |
2306306 | 2306306 | 2022-03-14 | McLean | North Dakota | 38055 | 2716 | 49 |
2303055 | 2303055 | 2022-03-13 | McLean | North Dakota | 38055 | 2716 | 49 |
2299803 | 2299803 | 2022-03-12 | McLean | North Dakota | 38055 | 2716 | 49 |
2286317 | 2286317 | 2022-03-08 | Lewis | Missouri | 29111 | 2716 | 34 |
2286451 | 2286451 | 2022-03-08 | Colfax | Nebraska | 31037 | 2716 | 26 |
2283199 | 2283199 | 2022-03-07 | Colfax | Nebraska | 31037 | 2716 | 26 |
2262851 | 2262851 | 2022-03-01 | Lyon | Iowa | 19119 | 2716 | 48 |
2259600 | 2259600 | 2022-02-28 | Lyon | Iowa | 19119 | 2716 | 48 |
2256349 | 2256349 | 2022-02-27 | Lyon | Iowa | 19119 | 2716 | 48 |
2253098 | 2253098 | 2022-02-26 | Lyon | Iowa | 19119 | 2716 | 48 |
2249847 | 2249847 | 2022-02-25 | Lyon | Iowa | 19119 | 2716 | 48 |
2251024 | 2251024 | 2022-02-25 | McLean | North Dakota | 38055 | 2716 | 49 |
2246596 | 2246596 | 2022-02-24 | Lyon | Iowa | 19119 | 2716 | 48 |
2243345 | 2243345 | 2022-02-23 | Lyon | Iowa | 19119 | 2716 | 48 |
2239329 | 2239329 | 2022-02-22 | Valdez-Cordova Census Area | Alaska | 2261 | 2716 | 16 |
2236078 | 2236078 | 2022-02-21 | Valdez-Cordova Census Area | Alaska | 2261 | 2716 | 16 |
2232827 | 2232827 | 2022-02-20 | Valdez-Cordova Census Area | Alaska | 2261 | 2716 | 16 |
2229576 | 2229576 | 2022-02-19 | Valdez-Cordova Census Area | Alaska | 2261 | 2716 | 16 |
2226325 | 2226325 | 2022-02-18 | Valdez-Cordova Census Area | Alaska | 2261 | 2716 | 16 |
2214316 | 2214316 | 2022-02-14 | Metcalfe | Kentucky | 21169 | 2716 | 57 |
2210417 | 2210417 | 2022-02-13 | Early | Georgia | 13099 | 2716 | 60 |
2207164 | 2207164 | 2022-02-12 | Early | Georgia | 13099 | 2716 | 60 |
2203911 | 2203911 | 2022-02-11 | Early | Georgia | 13099 | 2716 | 60 |
2189860 | 2189860 | 2022-02-06 | Callahan | Texas | 48059 | 2716 | 66 |
2167329 | 2167329 | 2022-01-30 | Juab | Utah | 49023 | 2716 | 21 |
2164074 | 2164074 | 2022-01-29 | Juab | Utah | 49023 | 2716 | 21 |
2160819 | 2160819 | 2022-01-28 | Juab | Utah | 49023 | 2716 | 21 |
2152881 | 2152881 | 2022-01-26 | Montgomery | Mississippi | 28097 | 2716 | 62 |
2114505 | 2114505 | 2022-01-14 | Noble | Ohio | 39121 | 2716 | 51 |
2060319 | 2060319 | 2021-12-28 | Rusk | Wisconsin | 55107 | 2716 | 41 |
2053744 | 2053744 | 2021-12-26 | Morgan | West Virginia | 54065 | 2716 | 53 |
2050494 | 2050494 | 2021-12-25 | Morgan | West Virginia | 54065 | 2716 | 53 |
2047244 | 2047244 | 2021-12-24 | Morgan | West Virginia | 54065 | 2716 | 53 |
2043994 | 2043994 | 2021-12-23 | Morgan | West Virginia | 54065 | 2716 | 53 |
2034872 | 2034872 | 2021-12-21 | Rabun | Georgia | 13241 | 2716 | 76 |
2019507 | 2019507 | 2021-12-16 | Sibley | Minnesota | 27143 | 2716 | 20 |
2020558 | 2020558 | 2021-12-16 | Lee | South Carolina | 45061 | 2716 | 79 |
2005802 | 2005802 | 2021-12-12 | Warren | Illinois | 17187 | 2716 | 72 |
2002551 | 2002551 | 2021-12-11 | Warren | Illinois | 17187 | 2716 | 72 |
1999301 | 1999301 | 2021-12-10 | Warren | Illinois | 17187 | 2716 | 72 |
1993583 | 1993583 | 2021-12-08 | Smith | Mississippi | 28129 | 2716 | 52 |
1983744 | 1983744 | 2021-12-05 | Renville | Minnesota | 27129 | 2716 | 51 |
1980494 | 1980494 | 2021-12-04 | Renville | Minnesota | 27129 | 2716 | 51 |
1977244 | 1977244 | 2021-12-03 | Renville | Minnesota | 27129 | 2716 | 51 |
1946268 | 1946268 | 2021-11-23 | Windham | Vermont | 50025 | 2716 | 26 |
1927564 | 1927564 | 2021-11-18 | Jefferson | Georgia | 13163 | 2716 | 87 |
1928387 | 1928387 | 2021-11-18 | Manistee | Michigan | 26101 | 2716 | 44 |
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);