ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
671 rows where cases = 454 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 70
- South Dakota 69
- Texas 59
- Missouri 39
- Nebraska 35
- Puerto Rico 29
- Kansas 25
- Georgia 24
- Iowa 23
- Illinois 21
- Virginia 21
- Kentucky 20
- Mississippi 19
- Michigan 17
- Minnesota 16
- West Virginia 15
- Arkansas 14
- California 14
- Indiana 13
- Colorado 11
- Tennessee 10
- Alabama 9
- North Carolina 9
- Wisconsin 9
- Louisiana 8
- Ohio 8
- Oregon 8
- Pennsylvania 8
- Idaho 7
- New York 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2384370 | 2384370 | 2022-04-07 | Divide | North Dakota | 38023 | 454 | 4 |
2381115 | 2381115 | 2022-04-06 | Divide | North Dakota | 38023 | 454 | 4 |
2377860 | 2377860 | 2022-04-05 | Divide | North Dakota | 38023 | 454 | 4 |
2374607 | 2374607 | 2022-04-04 | Divide | North Dakota | 38023 | 454 | 4 |
2371355 | 2371355 | 2022-04-03 | Divide | North Dakota | 38023 | 454 | 4 |
2368102 | 2368102 | 2022-04-02 | Divide | North Dakota | 38023 | 454 | 4 |
2364849 | 2364849 | 2022-04-01 | Divide | North Dakota | 38023 | 454 | 4 |
2361595 | 2361595 | 2022-03-31 | Divide | North Dakota | 38023 | 454 | 4 |
2358341 | 2358341 | 2022-03-30 | Divide | North Dakota | 38023 | 454 | 4 |
2355087 | 2355087 | 2022-03-29 | Divide | North Dakota | 38023 | 454 | 4 |
2351834 | 2351834 | 2022-03-28 | Divide | North Dakota | 38023 | 454 | 4 |
2348582 | 2348582 | 2022-03-27 | Divide | North Dakota | 38023 | 454 | 4 |
2345329 | 2345329 | 2022-03-26 | Divide | North Dakota | 38023 | 454 | 4 |
2342076 | 2342076 | 2022-03-25 | Divide | North Dakota | 38023 | 454 | 4 |
2338823 | 2338823 | 2022-03-24 | Divide | North Dakota | 38023 | 454 | 4 |
2335569 | 2335569 | 2022-03-23 | Divide | North Dakota | 38023 | 454 | 4 |
2336201 | 2336201 | 2022-03-23 | Briscoe | Texas | 48045 | 454 | 8 |
2332315 | 2332315 | 2022-03-22 | Divide | North Dakota | 38023 | 454 | 4 |
2332947 | 2332947 | 2022-03-22 | Briscoe | Texas | 48045 | 454 | 8 |
2329062 | 2329062 | 2022-03-21 | Divide | North Dakota | 38023 | 454 | 4 |
2325810 | 2325810 | 2022-03-20 | Divide | North Dakota | 38023 | 454 | 4 |
2322557 | 2322557 | 2022-03-19 | Divide | North Dakota | 38023 | 454 | 4 |
2319303 | 2319303 | 2022-03-18 | Divide | North Dakota | 38023 | 454 | 4 |
2310038 | 2310038 | 2022-03-15 | Miner | South Dakota | 46097 | 454 | 13 |
2306785 | 2306785 | 2022-03-14 | Miner | South Dakota | 46097 | 454 | 13 |
2303534 | 2303534 | 2022-03-13 | Miner | South Dakota | 46097 | 454 | 13 |
2300282 | 2300282 | 2022-03-12 | Miner | South Dakota | 46097 | 454 | 13 |
2296535 | 2296535 | 2022-03-11 | Divide | North Dakota | 38023 | 454 | 4 |
2297030 | 2297030 | 2022-03-11 | Miner | South Dakota | 46097 | 454 | 13 |
2293283 | 2293283 | 2022-03-10 | Divide | North Dakota | 38023 | 454 | 4 |
2293778 | 2293778 | 2022-03-10 | Miner | South Dakota | 46097 | 454 | 13 |
2290031 | 2290031 | 2022-03-09 | Divide | North Dakota | 38023 | 454 | 4 |
2290526 | 2290526 | 2022-03-09 | Miner | South Dakota | 46097 | 454 | 13 |
2286779 | 2286779 | 2022-03-08 | Divide | North Dakota | 38023 | 454 | 4 |
2287274 | 2287274 | 2022-03-08 | Miner | South Dakota | 46097 | 454 | 13 |
2283527 | 2283527 | 2022-03-07 | Divide | North Dakota | 38023 | 454 | 4 |
2284022 | 2284022 | 2022-03-07 | Miner | South Dakota | 46097 | 454 | 13 |
2280275 | 2280275 | 2022-03-06 | Divide | North Dakota | 38023 | 454 | 4 |
2277022 | 2277022 | 2022-03-05 | Divide | North Dakota | 38023 | 454 | 4 |
2273769 | 2273769 | 2022-03-04 | Divide | North Dakota | 38023 | 454 | 4 |
2270516 | 2270516 | 2022-03-03 | Divide | North Dakota | 38023 | 454 | 4 |
2267264 | 2267264 | 2022-03-02 | Divide | North Dakota | 38023 | 454 | 4 |
2264012 | 2264012 | 2022-03-01 | Divide | North Dakota | 38023 | 454 | 4 |
2260761 | 2260761 | 2022-02-28 | Divide | North Dakota | 38023 | 454 | 4 |
2257510 | 2257510 | 2022-02-27 | Divide | North Dakota | 38023 | 454 | 4 |
2254259 | 2254259 | 2022-02-26 | Divide | North Dakota | 38023 | 454 | 4 |
2251008 | 2251008 | 2022-02-25 | Divide | North Dakota | 38023 | 454 | 4 |
2247757 | 2247757 | 2022-02-24 | Divide | North Dakota | 38023 | 454 | 4 |
2244506 | 2244506 | 2022-02-23 | Divide | North Dakota | 38023 | 454 | 4 |
2241255 | 2241255 | 2022-02-22 | Divide | North Dakota | 38023 | 454 | 4 |
2238004 | 2238004 | 2022-02-21 | Divide | North Dakota | 38023 | 454 | 4 |
2238499 | 2238499 | 2022-02-21 | Miner | South Dakota | 46097 | 454 | 13 |
2234753 | 2234753 | 2022-02-20 | Divide | North Dakota | 38023 | 454 | 4 |
2235248 | 2235248 | 2022-02-20 | Miner | South Dakota | 46097 | 454 | 13 |
2231502 | 2231502 | 2022-02-19 | Divide | North Dakota | 38023 | 454 | 4 |
2231997 | 2231997 | 2022-02-19 | Miner | South Dakota | 46097 | 454 | 13 |
2228251 | 2228251 | 2022-02-18 | Divide | North Dakota | 38023 | 454 | 4 |
2228746 | 2228746 | 2022-02-18 | Miner | South Dakota | 46097 | 454 | 13 |
2225000 | 2225000 | 2022-02-17 | Divide | North Dakota | 38023 | 454 | 4 |
2221749 | 2221749 | 2022-02-16 | Divide | North Dakota | 38023 | 454 | 4 |
2218498 | 2218498 | 2022-02-15 | Divide | North Dakota | 38023 | 454 | 4 |
2193153 | 2193153 | 2022-02-07 | Edwards | Texas | 48137 | 454 | 10 |
2189899 | 2189899 | 2022-02-06 | Edwards | Texas | 48137 | 454 | 10 |
2186646 | 2186646 | 2022-02-05 | Edwards | Texas | 48137 | 454 | 10 |
2149163 | 2149163 | 2022-01-25 | Wichita | Kansas | 20203 | 454 | 8 |
2145911 | 2145911 | 2022-01-24 | Wichita | Kansas | 20203 | 454 | 8 |
2142943 | 2142943 | 2022-01-23 | Keweenaw | Michigan | 26083 | 454 | 11 |
2143001 | 2143001 | 2022-01-23 | Cook | Minnesota | 27031 | 454 | 1 |
2139688 | 2139688 | 2022-01-22 | Keweenaw | Michigan | 26083 | 454 | 11 |
2139746 | 2139746 | 2022-01-22 | Cook | Minnesota | 27031 | 454 | 1 |
2136432 | 2136432 | 2022-01-21 | Keweenaw | Michigan | 26083 | 454 | 11 |
2136490 | 2136490 | 2022-01-21 | Cook | Minnesota | 27031 | 454 | 1 |
2129218 | 2129218 | 2022-01-19 | Custer | Idaho | 16037 | 454 | 7 |
2122530 | 2122530 | 2022-01-17 | Baker | Georgia | 13007 | 454 | 14 |
2123874 | 2123874 | 2022-01-17 | Perkins | Nebraska | 31135 | 454 | 12 |
2120598 | 2120598 | 2022-01-16 | Hitchcock | Nebraska | 31087 | 454 | 6 |
2117346 | 2117346 | 2022-01-15 | Hitchcock | Nebraska | 31087 | 454 | 6 |
2114095 | 2114095 | 2022-01-14 | Hitchcock | Nebraska | 31087 | 454 | 6 |
2088072 | 2088072 | 2022-01-06 | Frontier | Nebraska | 31063 | 454 | 2 |
2084820 | 2084820 | 2022-01-05 | Frontier | Nebraska | 31063 | 454 | 2 |
2081568 | 2081568 | 2022-01-04 | Frontier | Nebraska | 31063 | 454 | 2 |
2081909 | 2081909 | 2022-01-04 | Renville | North Dakota | 38075 | 454 | 15 |
2078657 | 2078657 | 2022-01-03 | Renville | North Dakota | 38075 | 454 | 15 |
2075406 | 2075406 | 2022-01-02 | Renville | North Dakota | 38075 | 454 | 15 |
2072155 | 2072155 | 2022-01-01 | Renville | North Dakota | 38075 | 454 | 15 |
2068904 | 2068904 | 2021-12-31 | Renville | North Dakota | 38075 | 454 | 15 |
2065653 | 2065653 | 2021-12-30 | Renville | North Dakota | 38075 | 454 | 15 |
2055887 | 2055887 | 2021-12-27 | Griggs | North Dakota | 38039 | 454 | 2 |
2051517 | 2051517 | 2021-12-26 | Chase | Kansas | 20017 | 454 | 6 |
2052637 | 2052637 | 2021-12-26 | Griggs | North Dakota | 38039 | 454 | 2 |
2053313 | 2053313 | 2021-12-26 | Fisher | Texas | 48151 | 454 | 19 |
2048267 | 2048267 | 2021-12-25 | Chase | Kansas | 20017 | 454 | 6 |
2049387 | 2049387 | 2021-12-25 | Griggs | North Dakota | 38039 | 454 | 2 |
2050063 | 2050063 | 2021-12-25 | Fisher | Texas | 48151 | 454 | 19 |
2045017 | 2045017 | 2021-12-24 | Chase | Kansas | 20017 | 454 | 6 |
2046137 | 2046137 | 2021-12-24 | Griggs | North Dakota | 38039 | 454 | 2 |
2046813 | 2046813 | 2021-12-24 | Fisher | Texas | 48151 | 454 | 19 |
2041768 | 2041768 | 2021-12-23 | Chase | Kansas | 20017 | 454 | 6 |
2043563 | 2043563 | 2021-12-23 | Fisher | Texas | 48151 | 454 | 19 |
2038518 | 2038518 | 2021-12-22 | Chase | Kansas | 20017 | 454 | 6 |
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);