ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
368 rows where cases = 1481 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 36
- Kentucky 27
- Illinois 22
- Texas 19
- Nebraska 18
- Colorado 16
- Iowa 15
- North Dakota 15
- Minnesota 12
- Oklahoma 12
- Virginia 11
- Indiana 10
- Mississippi 10
- Missouri 10
- Kansas 9
- Puerto Rico 9
- Alabama 7
- Michigan 7
- New Mexico 7
- Washington 7
- Wisconsin 7
- Florida 6
- Idaho 6
- Ohio 6
- South Dakota 6
- Montana 5
- North Carolina 5
- Oregon 5
- Tennessee 5
- West Virginia 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498146 | 2498146 | 2022-05-12 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2499505 | 2499505 | 2022-05-12 | Iron | Wisconsin | 55051 | 1481 | 47 |
2494888 | 2494888 | 2022-05-11 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2491630 | 2491630 | 2022-05-10 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2492989 | 2492989 | 2022-05-10 | Iron | Wisconsin | 55051 | 1481 | 47 |
2488372 | 2488372 | 2022-05-09 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2461843 | 2461843 | 2022-05-01 | Grant | Minnesota | 27051 | 1481 | 12 |
2458587 | 2458587 | 2022-04-30 | Grant | Minnesota | 27051 | 1481 | 12 |
2455331 | 2455331 | 2022-04-29 | Grant | Minnesota | 27051 | 1481 | 12 |
2443964 | 2443964 | 2022-04-25 | Mathews | Virginia | 51115 | 1481 | 27 |
2369845 | 2369845 | 2022-04-03 | Randolph | Georgia | 13243 | 1481 | 48 |
2366592 | 2366592 | 2022-04-02 | Randolph | Georgia | 13243 | 1481 | 48 |
2363339 | 2363339 | 2022-04-01 | Randolph | Georgia | 13243 | 1481 | 48 |
2360085 | 2360085 | 2022-03-31 | Randolph | Georgia | 13243 | 1481 | 48 |
2353578 | 2353578 | 2022-03-29 | Randolph | Georgia | 13243 | 1481 | 48 |
2350326 | 2350326 | 2022-03-28 | Randolph | Georgia | 13243 | 1481 | 48 |
2314602 | 2314602 | 2022-03-17 | Caribou | Idaho | 16029 | 1481 | 26 |
2316048 | 2316048 | 2022-03-17 | Dickey | North Dakota | 38021 | 1481 | 39 |
2312795 | 2312795 | 2022-03-16 | Dickey | North Dakota | 38021 | 1481 | 39 |
2309542 | 2309542 | 2022-03-15 | Dickey | North Dakota | 38021 | 1481 | 39 |
2302756 | 2302756 | 2022-03-13 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2299504 | 2299504 | 2022-03-12 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2296252 | 2296252 | 2022-03-11 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2296534 | 2296534 | 2022-03-11 | Dickey | North Dakota | 38021 | 1481 | 39 |
2290030 | 2290030 | 2022-03-09 | Dickey | North Dakota | 38021 | 1481 | 39 |
2286778 | 2286778 | 2022-03-08 | Dickey | North Dakota | 38021 | 1481 | 39 |
2283244 | 2283244 | 2022-03-07 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2283526 | 2283526 | 2022-03-07 | Dickey | North Dakota | 38021 | 1481 | 39 |
2279991 | 2279991 | 2022-03-06 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2280274 | 2280274 | 2022-03-06 | Dickey | North Dakota | 38021 | 1481 | 39 |
2276738 | 2276738 | 2022-03-05 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2277021 | 2277021 | 2022-03-05 | Dickey | North Dakota | 38021 | 1481 | 39 |
2273485 | 2273485 | 2022-03-04 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2270233 | 2270233 | 2022-03-03 | Nemaha | Nebraska | 31127 | 1481 | 19 |
2258238 | 2258238 | 2022-02-27 | Jack | Texas | 48237 | 1481 | 27 |
2254987 | 2254987 | 2022-02-26 | Jack | Texas | 48237 | 1481 | 27 |
2246336 | 2246336 | 2022-02-24 | Power | Idaho | 16077 | 1481 | 20 |
2247782 | 2247782 | 2022-02-24 | Ransom | North Dakota | 38073 | 1481 | 28 |
2241280 | 2241280 | 2022-02-22 | Ransom | North Dakota | 38073 | 1481 | 27 |
2225475 | 2225475 | 2022-02-17 | Hamlin | South Dakota | 46057 | 1481 | 41 |
2217170 | 2217170 | 2022-02-15 | Stark | Illinois | 17175 | 1481 | 32 |
2210233 | 2210233 | 2022-02-13 | Clear Creek | Colorado | 8019 | 1481 | 10 |
2210450 | 2210450 | 2022-02-13 | Jenkins | Georgia | 13165 | 1481 | 64 |
2206980 | 2206980 | 2022-02-12 | Clear Creek | Colorado | 8019 | 1481 | 10 |
2207197 | 2207197 | 2022-02-12 | Jenkins | Georgia | 13165 | 1481 | 64 |
2203727 | 2203727 | 2022-02-11 | Clear Creek | Colorado | 8019 | 1481 | 10 |
2203944 | 2203944 | 2022-02-11 | Jenkins | Georgia | 13165 | 1481 | 64 |
2170340 | 2170340 | 2022-01-31 | Brooks | Texas | 48047 | 1481 | 49 |
2146431 | 2146431 | 2022-01-24 | Chariton | Missouri | 29041 | 1481 | 32 |
2146637 | 2146637 | 2022-01-24 | Knox | Nebraska | 31107 | 1481 | 13 |
2139931 | 2139931 | 2022-01-22 | Daviess | Missouri | 29061 | 1481 | 24 |
2134562 | 2134562 | 2022-01-20 | Coleman | Texas | 48083 | 1481 | 62 |
2107560 | 2107560 | 2022-01-12 | Butler | Nebraska | 31023 | 1481 | 12 |
2105863 | 2105863 | 2022-01-11 | Johnson | Wyoming | 56019 | 1481 | 18 |
2082496 | 2082496 | 2022-01-04 | Archer | Texas | 48009 | 1481 | 24 |
2073671 | 2073671 | 2022-01-02 | Yuma | Colorado | 8125 | 1481 | 22 |
2070420 | 2070420 | 2022-01-01 | Yuma | Colorado | 8125 | 1481 | 22 |
2067169 | 2067169 | 2021-12-31 | Yuma | Colorado | 8125 | 1481 | 22 |
2060827 | 2060827 | 2021-12-29 | Irwin | Georgia | 13155 | 1481 | 42 |
2063020 | 2063020 | 2021-12-29 | Castro | Texas | 48069 | 1481 | 41 |
2051725 | 2051725 | 2021-12-26 | Trimble | Kentucky | 21223 | 1481 | 28 |
2048475 | 2048475 | 2021-12-25 | Trimble | Kentucky | 21223 | 1481 | 28 |
2045225 | 2045225 | 2021-12-24 | Trimble | Kentucky | 21223 | 1481 | 28 |
2046503 | 2046503 | 2021-12-24 | Quebradillas | Puerto Rico | 72115 | 1481 | |
2041976 | 2041976 | 2021-12-23 | Trimble | Kentucky | 21223 | 1481 | 28 |
2043253 | 2043253 | 2021-12-23 | Quebradillas | Puerto Rico | 72115 | 1481 | |
2037736 | 2037736 | 2021-12-22 | Cleveland | Arkansas | 5025 | 1481 | 33 |
2038726 | 2038726 | 2021-12-22 | Trimble | Kentucky | 21223 | 1481 | 28 |
2033152 | 2033152 | 2021-12-20 | Pembina | North Dakota | 38067 | 1481 | 15 |
2028892 | 2028892 | 2021-12-19 | Cumberland | Kentucky | 21057 | 1481 | 22 |
2029902 | 2029902 | 2021-12-19 | Pembina | North Dakota | 38067 | 1481 | 15 |
2025641 | 2025641 | 2021-12-18 | Cumberland | Kentucky | 21057 | 1481 | 22 |
2022390 | 2022390 | 2021-12-17 | Cumberland | Kentucky | 21057 | 1481 | 22 |
2013295 | 2013295 | 2021-12-14 | Cheyenne | Nebraska | 31033 | 1481 | 19 |
2014134 | 2014134 | 2021-12-14 | Turner | South Dakota | 46125 | 1481 | 62 |
2011466 | 2011466 | 2021-12-13 | Doddridge | West Virginia | 54017 | 1481 | 12 |
2008215 | 2008215 | 2021-12-12 | Doddridge | West Virginia | 54017 | 1481 | 12 |
1990420 | 1990420 | 2021-12-07 | Monroe | Missouri | 29137 | 1481 | 32 |
1966097 | 1966097 | 2021-11-29 | Sublette | Wyoming | 56035 | 1481 | 22 |
1961291 | 1961291 | 2021-11-28 | Custer | Nebraska | 31041 | 1481 | 23 |
1958040 | 1958040 | 2021-11-27 | Custer | Nebraska | 31041 | 1481 | 23 |
1954789 | 1954789 | 2021-11-26 | Custer | Nebraska | 31041 | 1481 | 23 |
1951538 | 1951538 | 2021-11-25 | Custer | Nebraska | 31041 | 1481 | 23 |
1948287 | 1948287 | 2021-11-24 | Custer | Nebraska | 31041 | 1481 | 23 |
1927085 | 1927085 | 2021-11-17 | Platte | Wyoming | 56031 | 1481 | 26 |
1904810 | 1904810 | 2021-11-11 | Heard | Georgia | 13149 | 1481 | 41 |
1905608 | 1905608 | 2021-11-11 | Crawford | Michigan | 26039 | 1481 | 17 |
1901560 | 1901560 | 2021-11-10 | Heard | Georgia | 13149 | 1481 | 41 |
1902359 | 1902359 | 2021-11-10 | Crawford | Michigan | 26039 | 1481 | 17 |
1898310 | 1898310 | 2021-11-09 | Heard | Georgia | 13149 | 1481 | 41 |
1891732 | 1891732 | 2021-11-07 | Unknown | Florida | 1481 | 686 | |
1888482 | 1888482 | 2021-11-06 | Unknown | Florida | 1481 | 686 | |
1882573 | 1882573 | 2021-11-04 | Rice | Kansas | 20159 | 1481 | 15 |
1879324 | 1879324 | 2021-11-03 | Rice | Kansas | 20159 | 1481 | 15 |
1864946 | 1864946 | 2021-10-29 | Swisher | Texas | 48437 | 1481 | 22 |
1859823 | 1859823 | 2021-10-28 | Pawnee | Kansas | 20145 | 1481 | 15 |
1861697 | 1861697 | 2021-10-28 | Swisher | Texas | 48437 | 1481 | 22 |
1856574 | 1856574 | 2021-10-27 | Pawnee | Kansas | 20145 | 1481 | 15 |
1858448 | 1858448 | 2021-10-27 | Swisher | Texas | 48437 | 1481 | 22 |
1855199 | 1855199 | 2021-10-26 | Swisher | Texas | 48437 | 1481 | 22 |
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);