ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
378 rows where cases = 1394 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 35
- Kansas 32
- Puerto Rico 27
- Tennessee 24
- Texas 20
- Arkansas 18
- Virginia 15
- Mississippi 14
- Georgia 13
- North Dakota 13
- Kentucky 11
- North Carolina 11
- Oklahoma 10
- South Dakota 10
- Indiana 9
- Washington 9
- Illinois 8
- Missouri 8
- Pennsylvania 7
- Louisiana 6
- Montana 6
- West Virginia 6
- Alabama 5
- California 5
- Michigan 5
- Ohio 5
- Wisconsin 5
- Florida 4
- Minnesota 4
- Oregon 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500444 | 2500444 | 2022-05-13 | Osceola | Iowa | 19143 | 1394 | 22 |
2497186 | 2497186 | 2022-05-12 | Osceola | Iowa | 19143 | 1394 | 22 |
2493928 | 2493928 | 2022-05-11 | Osceola | Iowa | 19143 | 1394 | 22 |
2490670 | 2490670 | 2022-05-10 | Osceola | Iowa | 19143 | 1394 | 22 |
2487413 | 2487413 | 2022-05-09 | Osceola | Iowa | 19143 | 1394 | 22 |
2484155 | 2484155 | 2022-05-08 | Osceola | Iowa | 19143 | 1394 | 22 |
2480897 | 2480897 | 2022-05-07 | Osceola | Iowa | 19143 | 1394 | 22 |
2477639 | 2477639 | 2022-05-06 | Osceola | Iowa | 19143 | 1394 | 22 |
2474381 | 2474381 | 2022-05-05 | Osceola | Iowa | 19143 | 1394 | 22 |
2471124 | 2471124 | 2022-05-04 | Osceola | Iowa | 19143 | 1394 | 22 |
2427029 | 2427029 | 2022-04-20 | Ceiba | Puerto Rico | 72037 | 1394 | |
2422285 | 2422285 | 2022-04-19 | Osceola | Iowa | 19143 | 1394 | 22 |
2423803 | 2423803 | 2022-04-19 | Maunabo | Puerto Rico | 72095 | 1394 | |
2419029 | 2419029 | 2022-04-18 | Osceola | Iowa | 19143 | 1394 | 22 |
2420547 | 2420547 | 2022-04-18 | Maunabo | Puerto Rico | 72095 | 1394 | |
2415773 | 2415773 | 2022-04-17 | Osceola | Iowa | 19143 | 1394 | 22 |
2412517 | 2412517 | 2022-04-16 | Osceola | Iowa | 19143 | 1394 | 22 |
2409261 | 2409261 | 2022-04-15 | Osceola | Iowa | 19143 | 1394 | 22 |
2406005 | 2406005 | 2022-04-14 | Osceola | Iowa | 19143 | 1394 | 22 |
2402749 | 2402749 | 2022-04-13 | Osceola | Iowa | 19143 | 1394 | 22 |
2399495 | 2399495 | 2022-04-12 | Osceola | Iowa | 19143 | 1394 | 22 |
2396239 | 2396239 | 2022-04-11 | Osceola | Iowa | 19143 | 1394 | 22 |
2392984 | 2392984 | 2022-04-10 | Osceola | Iowa | 19143 | 1394 | 22 |
2389728 | 2389728 | 2022-04-09 | Osceola | Iowa | 19143 | 1394 | 22 |
2386472 | 2386472 | 2022-04-08 | Osceola | Iowa | 19143 | 1394 | 22 |
2383218 | 2383218 | 2022-04-07 | Osceola | Iowa | 19143 | 1394 | 22 |
2383347 | 2383347 | 2022-04-07 | Washington | Kansas | 20201 | 1394 | 22 |
2379963 | 2379963 | 2022-04-06 | Osceola | Iowa | 19143 | 1394 | 22 |
2380092 | 2380092 | 2022-04-06 | Washington | Kansas | 20201 | 1394 | 22 |
2376837 | 2376837 | 2022-04-05 | Washington | Kansas | 20201 | 1394 | 22 |
2373585 | 2373585 | 2022-04-04 | Washington | Kansas | 20201 | 1394 | 22 |
2370332 | 2370332 | 2022-04-03 | Washington | Kansas | 20201 | 1394 | 22 |
2367079 | 2367079 | 2022-04-02 | Washington | Kansas | 20201 | 1394 | 22 |
2363826 | 2363826 | 2022-04-01 | Washington | Kansas | 20201 | 1394 | 22 |
2360572 | 2360572 | 2022-03-31 | Washington | Kansas | 20201 | 1394 | 21 |
2357318 | 2357318 | 2022-03-30 | Washington | Kansas | 20201 | 1394 | 21 |
2331293 | 2331293 | 2022-03-22 | Washington | Kansas | 20201 | 1394 | 20 |
2328041 | 2328041 | 2022-03-21 | Washington | Kansas | 20201 | 1394 | 20 |
2324788 | 2324788 | 2022-03-20 | Washington | Kansas | 20201 | 1394 | 20 |
2321534 | 2321534 | 2022-03-19 | Washington | Kansas | 20201 | 1394 | 20 |
2318280 | 2318280 | 2022-03-18 | Washington | Kansas | 20201 | 1394 | 20 |
2315027 | 2315027 | 2022-03-17 | Washington | Kansas | 20201 | 1394 | 20 |
2316281 | 2316281 | 2022-03-17 | Lake | Oregon | 41037 | 1394 | 25 |
2317103 | 2317103 | 2022-03-17 | Ferry | Washington | 53019 | 1394 | 29 |
2311774 | 2311774 | 2022-03-16 | Washington | Kansas | 20201 | 1394 | 20 |
2313850 | 2313850 | 2022-03-16 | Ferry | Washington | 53019 | 1394 | 29 |
2308521 | 2308521 | 2022-03-15 | Washington | Kansas | 20201 | 1394 | 20 |
2305270 | 2305270 | 2022-03-14 | Washington | Kansas | 20201 | 1394 | 20 |
2302018 | 2302018 | 2022-03-13 | Washington | Kansas | 20201 | 1394 | 20 |
2298766 | 2298766 | 2022-03-12 | Washington | Kansas | 20201 | 1394 | 20 |
2295514 | 2295514 | 2022-03-11 | Washington | Kansas | 20201 | 1394 | 20 |
2291896 | 2291896 | 2022-03-10 | Gallatin | Illinois | 17059 | 1394 | 17 |
2292262 | 2292262 | 2022-03-10 | Washington | Kansas | 20201 | 1394 | 20 |
2288644 | 2288644 | 2022-03-09 | Gallatin | Illinois | 17059 | 1394 | 17 |
2289010 | 2289010 | 2022-03-09 | Washington | Kansas | 20201 | 1394 | 20 |
2285393 | 2285393 | 2022-03-08 | Gallatin | Illinois | 17059 | 1394 | 17 |
2264163 | 2264163 | 2022-03-01 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2260913 | 2260913 | 2022-02-28 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2257662 | 2257662 | 2022-02-27 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2254411 | 2254411 | 2022-02-26 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2251160 | 2251160 | 2022-02-25 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2247909 | 2247909 | 2022-02-24 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2244658 | 2244658 | 2022-02-23 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2238508 | 2238508 | 2022-02-21 | Spink | South Dakota | 46115 | 1394 | 34 |
2235257 | 2235257 | 2022-02-20 | Spink | South Dakota | 46115 | 1394 | 34 |
2232006 | 2232006 | 2022-02-19 | Spink | South Dakota | 46115 | 1394 | 34 |
2228755 | 2228755 | 2022-02-18 | Spink | South Dakota | 46115 | 1394 | 34 |
2223527 | 2223527 | 2022-02-17 | Wheeler | Georgia | 13309 | 1394 | 38 |
2213469 | 2213469 | 2022-02-14 | Trinity | California | 6105 | 1394 | 20 |
2203374 | 2203374 | 2022-02-10 | Wirt | West Virginia | 54105 | 1394 | 20 |
2165425 | 2165425 | 2022-01-30 | Stevens | Kansas | 20189 | 1394 | 17 |
2162170 | 2162170 | 2022-01-29 | Stevens | Kansas | 20189 | 1394 | 17 |
2158915 | 2158915 | 2022-01-28 | Stevens | Kansas | 20189 | 1394 | 17 |
2145168 | 2145168 | 2022-01-24 | Clear Creek | Colorado | 8019 | 1394 | 10 |
2132192 | 2132192 | 2022-01-20 | Rio Blanco | Colorado | 8103 | 1394 | 13 |
2133370 | 2133370 | 2022-01-20 | Quitman | Mississippi | 28119 | 1394 | 28 |
2128007 | 2128007 | 2022-01-18 | Van Buren | Tennessee | 47175 | 1394 | 44 |
2124755 | 2124755 | 2022-01-17 | Van Buren | Tennessee | 47175 | 1394 | 44 |
2121503 | 2121503 | 2022-01-16 | Van Buren | Tennessee | 47175 | 1394 | 44 |
2118251 | 2118251 | 2022-01-15 | Van Buren | Tennessee | 47175 | 1394 | 44 |
2115000 | 2115000 | 2022-01-14 | Van Buren | Tennessee | 47175 | 1394 | 44 |
2109609 | 2109609 | 2022-01-13 | Lincoln | Georgia | 13181 | 1394 | 33 |
2109754 | 2109754 | 2022-01-13 | Edwards | Illinois | 17047 | 1394 | 24 |
2111748 | 2111748 | 2022-01-13 | Van Buren | Tennessee | 47175 | 1394 | 44 |
2108496 | 2108496 | 2022-01-12 | Van Buren | Tennessee | 47175 | 1394 | 44 |
2079006 | 2079006 | 2022-01-03 | Rincon | Puerto Rico | 72117 | 1394 | |
2052037 | 2052037 | 2021-12-26 | Choctaw | Mississippi | 28019 | 1394 | 27 |
2048787 | 2048787 | 2021-12-25 | Choctaw | Mississippi | 28019 | 1394 | 27 |
2045537 | 2045537 | 2021-12-24 | Choctaw | Mississippi | 28019 | 1394 | 27 |
2042287 | 2042287 | 2021-12-23 | Choctaw | Mississippi | 28019 | 1394 | 27 |
2037787 | 2037787 | 2021-12-22 | Searcy | Arkansas | 5129 | 1394 | 27 |
2039038 | 2039038 | 2021-12-22 | Choctaw | Mississippi | 28019 | 1394 | 27 |
2019053 | 2019053 | 2021-12-16 | Kingman | Kansas | 20095 | 1394 | 24 |
2015803 | 2015803 | 2021-12-15 | Kingman | Kansas | 20095 | 1394 | 24 |
1985703 | 1985703 | 2021-12-06 | Greenlee | Arizona | 4011 | 1394 | 22 |
1958357 | 1958357 | 2021-11-27 | Benson | North Dakota | 38005 | 1394 | 21 |
1955106 | 1955106 | 2021-11-26 | Benson | North Dakota | 38005 | 1394 | 21 |
1955460 | 1955460 | 2021-11-26 | Guayama | Puerto Rico | 72057 | 1394 | |
1944962 | 1944962 | 2021-11-23 | Blaine | Montana | 30005 | 1394 | 27 |
1928780 | 1928780 | 2021-11-18 | Cheyenne | Nebraska | 31033 | 1394 | 19 |
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);