ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
299 rows where cases = 1699 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 47
- Texas 21
- Arkansas 18
- Minnesota 16
- Puerto Rico 15
- Kentucky 11
- North Carolina 11
- Virginia 11
- Georgia 10
- Indiana 10
- Iowa 10
- Nebraska 10
- Tennessee 10
- Illinois 9
- Alabama 8
- Michigan 6
- Montana 6
- Idaho 5
- Ohio 5
- South Carolina 5
- Wisconsin 5
- Colorado 4
- Florida 4
- Kansas 4
- New Mexico 4
- Alaska 3
- Mississippi 3
- North Dakota 3
- Pennsylvania 3
- South Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471776 | 2471776 | 2022-05-04 | Chariton | Missouri | 29041 | 1699 | 36 |
2468520 | 2468520 | 2022-05-03 | Chariton | Missouri | 29041 | 1699 | 36 |
2465264 | 2465264 | 2022-05-02 | Chariton | Missouri | 29041 | 1699 | 36 |
2462009 | 2462009 | 2022-05-01 | Chariton | Missouri | 29041 | 1699 | 36 |
2458753 | 2458753 | 2022-04-30 | Chariton | Missouri | 29041 | 1699 | 36 |
2455497 | 2455497 | 2022-04-29 | Chariton | Missouri | 29041 | 1699 | 36 |
2452241 | 2452241 | 2022-04-28 | Chariton | Missouri | 29041 | 1699 | 36 |
2448985 | 2448985 | 2022-04-27 | Chariton | Missouri | 29041 | 1699 | 36 |
2445728 | 2445728 | 2022-04-26 | Chariton | Missouri | 29041 | 1699 | 36 |
2442473 | 2442473 | 2022-04-25 | Chariton | Missouri | 29041 | 1699 | 36 |
2439217 | 2439217 | 2022-04-24 | Chariton | Missouri | 29041 | 1699 | 36 |
2435961 | 2435961 | 2022-04-23 | Chariton | Missouri | 29041 | 1699 | 36 |
2432705 | 2432705 | 2022-04-22 | Chariton | Missouri | 29041 | 1699 | 36 |
2429449 | 2429449 | 2022-04-21 | Chariton | Missouri | 29041 | 1699 | 36 |
2426193 | 2426193 | 2022-04-20 | Chariton | Missouri | 29041 | 1699 | 36 |
2422937 | 2422937 | 2022-04-19 | Chariton | Missouri | 29041 | 1699 | 36 |
2419680 | 2419680 | 2022-04-18 | Chariton | Missouri | 29041 | 1699 | 36 |
2416425 | 2416425 | 2022-04-17 | Chariton | Missouri | 29041 | 1699 | 36 |
2413169 | 2413169 | 2022-04-16 | Chariton | Missouri | 29041 | 1699 | 36 |
2409913 | 2409913 | 2022-04-15 | Chariton | Missouri | 29041 | 1699 | 36 |
2406657 | 2406657 | 2022-04-14 | Chariton | Missouri | 29041 | 1699 | 36 |
2403401 | 2403401 | 2022-04-13 | Chariton | Missouri | 29041 | 1699 | 36 |
2400146 | 2400146 | 2022-04-12 | Chariton | Missouri | 29041 | 1699 | 36 |
2396891 | 2396891 | 2022-04-11 | Chariton | Missouri | 29041 | 1699 | 36 |
2393636 | 2393636 | 2022-04-10 | Chariton | Missouri | 29041 | 1699 | 36 |
2390380 | 2390380 | 2022-04-09 | Chariton | Missouri | 29041 | 1699 | 36 |
2387124 | 2387124 | 2022-04-08 | Chariton | Missouri | 29041 | 1699 | 36 |
2383869 | 2383869 | 2022-04-07 | Chariton | Missouri | 29041 | 1699 | 36 |
2380614 | 2380614 | 2022-04-06 | Chariton | Missouri | 29041 | 1699 | 36 |
2377359 | 2377359 | 2022-04-05 | Chariton | Missouri | 29041 | 1699 | 36 |
2374106 | 2374106 | 2022-04-04 | Chariton | Missouri | 29041 | 1699 | 36 |
2370854 | 2370854 | 2022-04-03 | Chariton | Missouri | 29041 | 1699 | 36 |
2367601 | 2367601 | 2022-04-02 | Chariton | Missouri | 29041 | 1699 | 36 |
2364348 | 2364348 | 2022-04-01 | Chariton | Missouri | 29041 | 1699 | 36 |
2361094 | 2361094 | 2022-03-31 | Chariton | Missouri | 29041 | 1699 | 36 |
2357840 | 2357840 | 2022-03-30 | Chariton | Missouri | 29041 | 1699 | 36 |
2348295 | 2348295 | 2022-03-27 | Merrick | Nebraska | 31121 | 1699 | 17 |
2345042 | 2345042 | 2022-03-26 | Merrick | Nebraska | 31121 | 1699 | 17 |
2341789 | 2341789 | 2022-03-25 | Merrick | Nebraska | 31121 | 1699 | 17 |
2279627 | 2279627 | 2022-03-06 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2279988 | 2279988 | 2022-03-06 | Merrick | Nebraska | 31121 | 1699 | 15 |
2276374 | 2276374 | 2022-03-05 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2276735 | 2276735 | 2022-03-05 | Merrick | Nebraska | 31121 | 1699 | 15 |
2273121 | 2273121 | 2022-03-04 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2273482 | 2273482 | 2022-03-04 | Merrick | Nebraska | 31121 | 1699 | 15 |
2269869 | 2269869 | 2022-03-03 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2270230 | 2270230 | 2022-03-03 | Merrick | Nebraska | 31121 | 1699 | 15 |
2266977 | 2266977 | 2022-03-02 | Merrick | Nebraska | 31121 | 1699 | 15 |
2262858 | 2262858 | 2022-03-01 | Monona | Iowa | 19133 | 1699 | 46 |
2263726 | 2263726 | 2022-03-01 | Merrick | Nebraska | 31121 | 1699 | 15 |
2259607 | 2259607 | 2022-02-28 | Monona | Iowa | 19133 | 1699 | 46 |
2260475 | 2260475 | 2022-02-28 | Merrick | Nebraska | 31121 | 1699 | 15 |
2256356 | 2256356 | 2022-02-27 | Monona | Iowa | 19133 | 1699 | 46 |
2256737 | 2256737 | 2022-02-27 | Alcona | Michigan | 26001 | 1699 | 67 |
2253105 | 2253105 | 2022-02-26 | Monona | Iowa | 19133 | 1699 | 46 |
2253486 | 2253486 | 2022-02-26 | Alcona | Michigan | 26001 | 1699 | 67 |
2249854 | 2249854 | 2022-02-25 | Monona | Iowa | 19133 | 1699 | 46 |
2250235 | 2250235 | 2022-02-25 | Alcona | Michigan | 26001 | 1699 | 67 |
2245901 | 2245901 | 2022-02-24 | Newton | Arkansas | 5101 | 1699 | 45 |
2246603 | 2246603 | 2022-02-24 | Monona | Iowa | 19133 | 1699 | 46 |
2246984 | 2246984 | 2022-02-24 | Alcona | Michigan | 26001 | 1699 | 67 |
2242650 | 2242650 | 2022-02-23 | Newton | Arkansas | 5101 | 1699 | 45 |
2243352 | 2243352 | 2022-02-23 | Monona | Iowa | 19133 | 1699 | 46 |
2243733 | 2243733 | 2022-02-23 | Alcona | Michigan | 26001 | 1699 | 67 |
2244094 | 2244094 | 2022-02-23 | Sullivan | Missouri | 29211 | 1699 | 20 |
2224347 | 2224347 | 2022-02-17 | Lac qui Parle | Minnesota | 27073 | 1699 | 28 |
2219080 | 2219080 | 2022-02-15 | Pickett | Tennessee | 47137 | 1699 | 30 |
2215829 | 2215829 | 2022-02-14 | Pickett | Tennessee | 47137 | 1699 | 30 |
2212578 | 2212578 | 2022-02-13 | Pickett | Tennessee | 47137 | 1699 | 30 |
2209325 | 2209325 | 2022-02-12 | Pickett | Tennessee | 47137 | 1699 | 30 |
2206072 | 2206072 | 2022-02-11 | Pickett | Tennessee | 47137 | 1699 | 30 |
2202819 | 2202819 | 2022-02-10 | Pickett | Tennessee | 47137 | 1699 | 30 |
2199565 | 2199565 | 2022-02-09 | Pickett | Tennessee | 47137 | 1699 | 30 |
2176883 | 2176883 | 2022-02-02 | Delta | Texas | 48119 | 1699 | 22 |
2177205 | 2177205 | 2022-02-02 | Middlesex | Virginia | 51119 | 1699 | 38 |
2166804 | 2166804 | 2022-01-30 | Hormigueros | Puerto Rico | 72067 | 1699 | |
2160801 | 2160801 | 2022-01-28 | Winkler | Texas | 48495 | 1699 | 33 |
2146278 | 2146278 | 2022-01-24 | Lake | Minnesota | 27075 | 1699 | 26 |
2133737 | 2133737 | 2022-01-20 | Sierra | New Mexico | 35051 | 1699 | 67 |
2129165 | 2129165 | 2022-01-19 | Taylor | Georgia | 13269 | 1699 | 43 |
2123751 | 2123751 | 2022-01-17 | Beaverhead | Montana | 30001 | 1699 | 24 |
2120499 | 2120499 | 2022-01-16 | Beaverhead | Montana | 30001 | 1699 | 24 |
2117247 | 2117247 | 2022-01-15 | Beaverhead | Montana | 30001 | 1699 | 24 |
2113996 | 2113996 | 2022-01-14 | Beaverhead | Montana | 30001 | 1699 | 24 |
2099860 | 2099860 | 2022-01-10 | Macon | Georgia | 13193 | 1699 | 46 |
2057547 | 2057547 | 2021-12-28 | Dooly | Georgia | 13093 | 1699 | 62 |
2060254 | 2060254 | 2021-12-28 | Summers | West Virginia | 54089 | 1699 | 37 |
2013177 | 2013177 | 2021-12-14 | Montgomery | Missouri | 29139 | 1699 | 34 |
2010876 | 2010876 | 2021-12-13 | Roberts | South Dakota | 46109 | 1699 | 45 |
2008079 | 2008079 | 2021-12-12 | Franklin city | Virginia | 51620 | 1699 | 43 |
2004828 | 2004828 | 2021-12-11 | Franklin city | Virginia | 51620 | 1699 | 43 |
2001402 | 2001402 | 2021-12-10 | Morris | Texas | 48343 | 1699 | 57 |
2001577 | 2001577 | 2021-12-10 | Franklin city | Virginia | 51620 | 1699 | 43 |
1989427 | 1989427 | 2021-12-07 | Clearwater | Idaho | 16035 | 1699 | 27 |
1984329 | 1984329 | 2021-12-05 | Perquimans | North Carolina | 37143 | 1699 | 16 |
1981079 | 1981079 | 2021-12-04 | Perquimans | North Carolina | 37143 | 1699 | 16 |
1977829 | 1977829 | 2021-12-03 | Perquimans | North Carolina | 37143 | 1699 | 16 |
1963445 | 1963445 | 2021-11-29 | Owyhee | Idaho | 16073 | 1699 | 41 |
1960311 | 1960311 | 2021-11-28 | Brown | Indiana | 18013 | 1699 | 51 |
1957060 | 1957060 | 2021-11-27 | Brown | Indiana | 18013 | 1699 | 51 |
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);