ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
490 rows where cases = 931 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 57
- Puerto Rico 37
- Virginia 33
- Kentucky 27
- Montana 25
- Texas 23
- Kansas 16
- Mississippi 16
- Michigan 14
- Minnesota 14
- Missouri 14
- Nebraska 14
- South Dakota 13
- Arkansas 12
- Indiana 12
- Oklahoma 12
- Colorado 11
- Iowa 11
- Louisiana 10
- North Carolina 9
- Wisconsin 9
- Illinois 8
- Wyoming 8
- Alabama 7
- Idaho 7
- North Dakota 7
- Maryland 6
- South Carolina 6
- Tennessee 6
- West Virginia 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500136 | 2500136 | 2022-05-13 | Bear Lake | Idaho | 16007 | 931 | 16 |
2496878 | 2496878 | 2022-05-12 | Bear Lake | Idaho | 16007 | 931 | 16 |
2493620 | 2493620 | 2022-05-11 | Bear Lake | Idaho | 16007 | 931 | 16 |
2377230 | 2377230 | 2022-04-05 | Red Lake | Minnesota | 27125 | 931 | 13 |
2373978 | 2373978 | 2022-04-04 | Red Lake | Minnesota | 27125 | 931 | 13 |
2370725 | 2370725 | 2022-04-03 | Red Lake | Minnesota | 27125 | 931 | 13 |
2367472 | 2367472 | 2022-04-02 | Red Lake | Minnesota | 27125 | 931 | 13 |
2364219 | 2364219 | 2022-04-01 | Red Lake | Minnesota | 27125 | 931 | 13 |
2360965 | 2360965 | 2022-03-31 | Red Lake | Minnesota | 27125 | 931 | 13 |
2327484 | 2327484 | 2022-03-21 | Echols | Georgia | 13101 | 931 | 11 |
2324060 | 2324060 | 2022-03-20 | Gilpin | Colorado | 8047 | 931 | 4 |
2324231 | 2324231 | 2022-03-20 | Echols | Georgia | 13101 | 931 | 11 |
2320806 | 2320806 | 2022-03-19 | Gilpin | Colorado | 8047 | 931 | 4 |
2320977 | 2320977 | 2022-03-19 | Echols | Georgia | 13101 | 931 | 11 |
2317552 | 2317552 | 2022-03-18 | Gilpin | Colorado | 8047 | 931 | 4 |
2317723 | 2317723 | 2022-03-18 | Echols | Georgia | 13101 | 931 | 11 |
2314299 | 2314299 | 2022-03-17 | Gilpin | Colorado | 8047 | 931 | 4 |
2314470 | 2314470 | 2022-03-17 | Echols | Georgia | 13101 | 931 | 11 |
2311217 | 2311217 | 2022-03-16 | Echols | Georgia | 13101 | 931 | 11 |
2307964 | 2307964 | 2022-03-15 | Echols | Georgia | 13101 | 931 | 11 |
2304713 | 2304713 | 2022-03-14 | Echols | Georgia | 13101 | 931 | 11 |
2301461 | 2301461 | 2022-03-13 | Echols | Georgia | 13101 | 931 | 11 |
2298209 | 2298209 | 2022-03-12 | Echols | Georgia | 13101 | 931 | 11 |
2294957 | 2294957 | 2022-03-11 | Echols | Georgia | 13101 | 931 | 11 |
2291705 | 2291705 | 2022-03-10 | Echols | Georgia | 13101 | 931 | 11 |
2288453 | 2288453 | 2022-03-09 | Echols | Georgia | 13101 | 931 | 11 |
2285202 | 2285202 | 2022-03-08 | Echols | Georgia | 13101 | 931 | 11 |
2281950 | 2281950 | 2022-03-07 | Echols | Georgia | 13101 | 931 | 11 |
2282900 | 2282900 | 2022-03-07 | Red Lake | Minnesota | 27125 | 931 | 13 |
2278697 | 2278697 | 2022-03-06 | Echols | Georgia | 13101 | 931 | 11 |
2275444 | 2275444 | 2022-03-05 | Echols | Georgia | 13101 | 931 | 11 |
2272191 | 2272191 | 2022-03-04 | Echols | Georgia | 13101 | 931 | 11 |
2268939 | 2268939 | 2022-03-03 | Echols | Georgia | 13101 | 931 | 11 |
2265686 | 2265686 | 2022-03-02 | Echols | Georgia | 13101 | 931 | 11 |
2262435 | 2262435 | 2022-03-01 | Echols | Georgia | 13101 | 931 | 11 |
2259184 | 2259184 | 2022-02-28 | Echols | Georgia | 13101 | 931 | 11 |
2260134 | 2260134 | 2022-02-28 | Red Lake | Minnesota | 27125 | 931 | 12 |
2252359 | 2252359 | 2022-02-26 | Calhoun | Arkansas | 5013 | 931 | 9 |
2201697 | 2201697 | 2022-02-10 | Sharkey | Mississippi | 28125 | 931 | 22 |
2197642 | 2197642 | 2022-02-09 | Pope | Illinois | 17151 | 931 | 7 |
2195706 | 2195706 | 2022-02-08 | Tyrrell | North Carolina | 37177 | 931 | 7 |
2191478 | 2191478 | 2022-02-07 | Carlisle | Kentucky | 21039 | 931 | 17 |
2178756 | 2178756 | 2022-02-03 | Ontonagon | Michigan | 26131 | 931 | 34 |
2175504 | 2175504 | 2022-02-02 | Ontonagon | Michigan | 26131 | 931 | 34 |
2173121 | 2173121 | 2022-02-01 | Grant | Oklahoma | 40053 | 931 | 12 |
2169869 | 2169869 | 2022-01-31 | Grant | Oklahoma | 40053 | 931 | 12 |
2166463 | 2166463 | 2022-01-30 | LaMoure | North Dakota | 38045 | 931 | 19 |
2166614 | 2166614 | 2022-01-30 | Grant | Oklahoma | 40053 | 931 | 12 |
2163359 | 2163359 | 2022-01-29 | Grant | Oklahoma | 40053 | 931 | 12 |
2160104 | 2160104 | 2022-01-28 | Grant | Oklahoma | 40053 | 931 | 12 |
2156849 | 2156849 | 2022-01-27 | Grant | Oklahoma | 40053 | 931 | 12 |
2153596 | 2153596 | 2022-01-26 | Grant | Oklahoma | 40053 | 931 | 12 |
2149916 | 2149916 | 2022-01-25 | Sheridan | Nebraska | 31161 | 931 | 23 |
2146664 | 2146664 | 2022-01-24 | Sheridan | Nebraska | 31161 | 931 | 23 |
2144836 | 2144836 | 2022-01-23 | Florence | Wisconsin | 55037 | 931 | 15 |
2141581 | 2141581 | 2022-01-22 | Florence | Wisconsin | 55037 | 931 | 15 |
2138325 | 2138325 | 2022-01-21 | Florence | Wisconsin | 55037 | 931 | 15 |
2131125 | 2131125 | 2022-01-19 | Deuel | South Dakota | 46039 | 931 | 12 |
2128062 | 2128062 | 2022-01-18 | Concho | Texas | 48095 | 931 | 10 |
2122436 | 2122436 | 2022-01-17 | Saguache | Colorado | 8109 | 931 | 10 |
2122815 | 2122815 | 2022-01-17 | Putnam | Illinois | 17155 | 931 | 8 |
2123725 | 2123725 | 2022-01-17 | Reynolds | Missouri | 29179 | 931 | 18 |
2125373 | 2125373 | 2022-01-17 | Hot Springs | Wyoming | 56017 | 931 | 12 |
2119424 | 2119424 | 2022-01-16 | Warren | Georgia | 13301 | 931 | 26 |
2119563 | 2119563 | 2022-01-16 | Putnam | Illinois | 17155 | 931 | 8 |
2120473 | 2120473 | 2022-01-16 | Reynolds | Missouri | 29179 | 931 | 18 |
2122121 | 2122121 | 2022-01-16 | Hot Springs | Wyoming | 56017 | 931 | 12 |
2116172 | 2116172 | 2022-01-15 | Warren | Georgia | 13301 | 931 | 26 |
2116311 | 2116311 | 2022-01-15 | Putnam | Illinois | 17155 | 931 | 8 |
2117221 | 2117221 | 2022-01-15 | Reynolds | Missouri | 29179 | 931 | 18 |
2118869 | 2118869 | 2022-01-15 | Hot Springs | Wyoming | 56017 | 931 | 12 |
2112921 | 2112921 | 2022-01-14 | Warren | Georgia | 13301 | 931 | 26 |
2113060 | 2113060 | 2022-01-14 | Putnam | Illinois | 17155 | 931 | 8 |
2115617 | 2115617 | 2022-01-14 | Hot Springs | Wyoming | 56017 | 931 | 12 |
2074321 | 2074321 | 2022-01-02 | Mitchell | Kansas | 20123 | 931 | 17 |
2071070 | 2071070 | 2022-01-01 | Mitchell | Kansas | 20123 | 931 | 17 |
2067819 | 2067819 | 2021-12-31 | Mitchell | Kansas | 20123 | 931 | 17 |
2064568 | 2064568 | 2021-12-30 | Mitchell | Kansas | 20123 | 931 | 17 |
2061318 | 2061318 | 2021-12-29 | Mitchell | Kansas | 20123 | 931 | 17 |
2052276 | 2052276 | 2021-12-26 | Teton | Montana | 30099 | 931 | 19 |
2049026 | 2049026 | 2021-12-25 | Teton | Montana | 30099 | 931 | 19 |
2045776 | 2045776 | 2021-12-24 | Teton | Montana | 30099 | 931 | 19 |
2042526 | 2042526 | 2021-12-23 | Teton | Montana | 30099 | 931 | 19 |
2039277 | 2039277 | 2021-12-22 | Teton | Montana | 30099 | 931 | 19 |
2033891 | 2033891 | 2021-12-20 | Lynn | Texas | 48305 | 931 | 28 |
2030641 | 2030641 | 2021-12-19 | Lynn | Texas | 48305 | 931 | 28 |
2027390 | 2027390 | 2021-12-18 | Lynn | Texas | 48305 | 931 | 28 |
2024139 | 2024139 | 2021-12-17 | Lynn | Texas | 48305 | 931 | 28 |
1989936 | 1989936 | 2021-12-07 | Menifee | Kentucky | 21165 | 931 | 25 |
1988608 | 1988608 | 2021-12-06 | Mathews | Virginia | 51115 | 931 | 24 |
1984177 | 1984177 | 2021-12-05 | Guadalupe | New Mexico | 35019 | 931 | 15 |
1980927 | 1980927 | 2021-12-04 | Guadalupe | New Mexico | 35019 | 931 | 15 |
1977677 | 1977677 | 2021-12-03 | Guadalupe | New Mexico | 35019 | 931 | 15 |
1975126 | 1975126 | 2021-12-02 | Tripp | South Dakota | 46123 | 931 | 21 |
1971085 | 1971085 | 2021-12-01 | Morrill | Nebraska | 31123 | 931 | 16 |
1967821 | 1967821 | 2021-11-30 | Jefferson | Nebraska | 31095 | 931 | 3 |
1946607 | 1946607 | 2021-11-24 | Choctaw | Alabama | 1023 | 931 | 28 |
1943356 | 1943356 | 2021-11-23 | Choctaw | Alabama | 1023 | 931 | 28 |
1932736 | 1932736 | 2021-11-19 | Rincon | Puerto Rico | 72117 | 931 | |
1927166 | 1927166 | 2021-11-18 | Dillingham Census Area | Alaska | 2070 | 931 | 7 |
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);