ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where cases = 398 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 56
- Georgia 45
- Montana 45
- Kansas 43
- Nebraska 41
- Colorado 34
- Oklahoma 34
- Virginia 29
- Missouri 27
- South Dakota 27
- North Dakota 23
- Indiana 18
- Illinois 16
- North Carolina 16
- Ohio 16
- Puerto Rico 16
- Arkansas 14
- Idaho 14
- Louisiana 14
- Alaska 13
- Michigan 13
- Minnesota 13
- Mississippi 13
- Alabama 12
- Kentucky 12
- Tennessee 12
- Washington 12
- Iowa 11
- Florida 10
- West Virginia 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501218 | 2501218 | 2022-05-13 | Liberty | Montana | 30051 | 398 | 4 |
2497960 | 2497960 | 2022-05-12 | Liberty | Montana | 30051 | 398 | 4 |
2494702 | 2494702 | 2022-05-11 | Liberty | Montana | 30051 | 398 | 4 |
2491444 | 2491444 | 2022-05-10 | Liberty | Montana | 30051 | 398 | 4 |
2488186 | 2488186 | 2022-05-09 | Liberty | Montana | 30051 | 398 | 4 |
2484929 | 2484929 | 2022-05-08 | Liberty | Montana | 30051 | 398 | 4 |
2481671 | 2481671 | 2022-05-07 | Liberty | Montana | 30051 | 398 | 4 |
2478413 | 2478413 | 2022-05-06 | Liberty | Montana | 30051 | 398 | 4 |
2475155 | 2475155 | 2022-05-05 | Liberty | Montana | 30051 | 398 | 4 |
2471898 | 2471898 | 2022-05-04 | Liberty | Montana | 30051 | 398 | 4 |
2468642 | 2468642 | 2022-05-03 | Liberty | Montana | 30051 | 398 | 4 |
2465386 | 2465386 | 2022-05-02 | Liberty | Montana | 30051 | 398 | 4 |
2462131 | 2462131 | 2022-05-01 | Liberty | Montana | 30051 | 398 | 4 |
2458875 | 2458875 | 2022-04-30 | Liberty | Montana | 30051 | 398 | 4 |
2455619 | 2455619 | 2022-04-29 | Liberty | Montana | 30051 | 398 | 4 |
2452363 | 2452363 | 2022-04-28 | Liberty | Montana | 30051 | 398 | 4 |
2449107 | 2449107 | 2022-04-27 | Liberty | Montana | 30051 | 398 | 4 |
2445850 | 2445850 | 2022-04-26 | Liberty | Montana | 30051 | 398 | 4 |
2442595 | 2442595 | 2022-04-25 | Liberty | Montana | 30051 | 398 | 4 |
2439339 | 2439339 | 2022-04-24 | Liberty | Montana | 30051 | 398 | 4 |
2436083 | 2436083 | 2022-04-23 | Liberty | Montana | 30051 | 398 | 4 |
2432827 | 2432827 | 2022-04-22 | Liberty | Montana | 30051 | 398 | 4 |
2429571 | 2429571 | 2022-04-21 | Liberty | Montana | 30051 | 398 | 4 |
2426315 | 2426315 | 2022-04-20 | Liberty | Montana | 30051 | 398 | 4 |
2423059 | 2423059 | 2022-04-19 | Liberty | Montana | 30051 | 398 | 4 |
2419802 | 2419802 | 2022-04-18 | Liberty | Montana | 30051 | 398 | 4 |
2416547 | 2416547 | 2022-04-17 | Liberty | Montana | 30051 | 398 | 4 |
2413291 | 2413291 | 2022-04-16 | Liberty | Montana | 30051 | 398 | 4 |
2410035 | 2410035 | 2022-04-15 | Liberty | Montana | 30051 | 398 | 4 |
2406779 | 2406779 | 2022-04-14 | Liberty | Montana | 30051 | 398 | 4 |
2403523 | 2403523 | 2022-04-13 | Liberty | Montana | 30051 | 398 | 4 |
2400268 | 2400268 | 2022-04-12 | Liberty | Montana | 30051 | 398 | 4 |
2348270 | 2348270 | 2022-03-27 | Garfield | Nebraska | 31071 | 398 | 2 |
2345017 | 2345017 | 2022-03-26 | Garfield | Nebraska | 31071 | 398 | 2 |
2341764 | 2341764 | 2022-03-25 | Garfield | Nebraska | 31071 | 398 | 2 |
2338511 | 2338511 | 2022-03-24 | Garfield | Nebraska | 31071 | 398 | 2 |
2335257 | 2335257 | 2022-03-23 | Garfield | Nebraska | 31071 | 398 | 2 |
2332003 | 2332003 | 2022-03-22 | Garfield | Nebraska | 31071 | 398 | 2 |
2328750 | 2328750 | 2022-03-21 | Garfield | Nebraska | 31071 | 398 | 2 |
2325498 | 2325498 | 2022-03-20 | Garfield | Nebraska | 31071 | 398 | 2 |
2322244 | 2322244 | 2022-03-19 | Garfield | Nebraska | 31071 | 398 | 2 |
2318990 | 2318990 | 2022-03-18 | Garfield | Nebraska | 31071 | 398 | 2 |
2315737 | 2315737 | 2022-03-17 | Garfield | Nebraska | 31071 | 398 | 2 |
2312484 | 2312484 | 2022-03-16 | Garfield | Nebraska | 31071 | 398 | 2 |
2309231 | 2309231 | 2022-03-15 | Garfield | Nebraska | 31071 | 398 | 2 |
2305979 | 2305979 | 2022-03-14 | Garfield | Nebraska | 31071 | 398 | 2 |
2302728 | 2302728 | 2022-03-13 | Garfield | Nebraska | 31071 | 398 | 2 |
2299476 | 2299476 | 2022-03-12 | Garfield | Nebraska | 31071 | 398 | 2 |
2296224 | 2296224 | 2022-03-11 | Garfield | Nebraska | 31071 | 398 | 2 |
2292972 | 2292972 | 2022-03-10 | Garfield | Nebraska | 31071 | 398 | 2 |
2289720 | 2289720 | 2022-03-09 | Garfield | Nebraska | 31071 | 398 | 2 |
2286468 | 2286468 | 2022-03-08 | Garfield | Nebraska | 31071 | 398 | 2 |
2283216 | 2283216 | 2022-03-07 | Garfield | Nebraska | 31071 | 398 | 2 |
2279963 | 2279963 | 2022-03-06 | Garfield | Nebraska | 31071 | 398 | 2 |
2276710 | 2276710 | 2022-03-05 | Garfield | Nebraska | 31071 | 398 | 2 |
2273457 | 2273457 | 2022-03-04 | Garfield | Nebraska | 31071 | 398 | 2 |
2270205 | 2270205 | 2022-03-03 | Garfield | Nebraska | 31071 | 398 | 2 |
2266952 | 2266952 | 2022-03-02 | Garfield | Nebraska | 31071 | 398 | 2 |
2263608 | 2263608 | 2022-03-01 | Worth | Missouri | 29227 | 398 | 3 |
2263701 | 2263701 | 2022-03-01 | Garfield | Nebraska | 31071 | 398 | 2 |
2260357 | 2260357 | 2022-02-28 | Worth | Missouri | 29227 | 398 | 3 |
2260450 | 2260450 | 2022-02-28 | Garfield | Nebraska | 31071 | 398 | 2 |
2187712 | 2187712 | 2022-02-06 | Quitman | Georgia | 13239 | 398 | 4 |
2184459 | 2184459 | 2022-02-05 | Quitman | Georgia | 13239 | 398 | 4 |
2181207 | 2181207 | 2022-02-04 | Quitman | Georgia | 13239 | 398 | 4 |
2177956 | 2177956 | 2022-02-03 | Quitman | Georgia | 13239 | 398 | 4 |
2164526 | 2164526 | 2022-01-30 | Wrangell City and Borough | Alaska | 2275 | 398 | 1 |
2167180 | 2167180 | 2022-01-30 | Irion | Texas | 48235 | 398 | 3 |
2161271 | 2161271 | 2022-01-29 | Wrangell City and Borough | Alaska | 2275 | 398 | 1 |
2158015 | 2158015 | 2022-01-28 | Wrangell City and Borough | Alaska | 2275 | 398 | 1 |
2160615 | 2160615 | 2022-01-28 | Dickens | Texas | 48125 | 398 | 15 |
2145456 | 2145456 | 2022-01-24 | Webster | Georgia | 13307 | 398 | 7 |
2128945 | 2128945 | 2022-01-19 | Sedgwick | Colorado | 8115 | 398 | 7 |
2118422 | 2118422 | 2022-01-15 | Menard | Texas | 48327 | 398 | 12 |
2115171 | 2115171 | 2022-01-14 | Menard | Texas | 48327 | 398 | 12 |
2104649 | 2104649 | 2022-01-11 | Golden Valley | North Dakota | 38033 | 398 | 4 |
2101398 | 2101398 | 2022-01-10 | Golden Valley | North Dakota | 38033 | 398 | 4 |
2096694 | 2096694 | 2022-01-09 | Butte | Idaho | 16023 | 398 | 7 |
2097034 | 2097034 | 2022-01-09 | Clark | Kansas | 20025 | 398 | 7 |
2098147 | 2098147 | 2022-01-09 | Golden Valley | North Dakota | 38033 | 398 | 4 |
2093442 | 2093442 | 2022-01-08 | Butte | Idaho | 16023 | 398 | 7 |
2093782 | 2093782 | 2022-01-08 | Clark | Kansas | 20025 | 398 | 7 |
2090190 | 2090190 | 2022-01-07 | Butte | Idaho | 16023 | 398 | 7 |
2090530 | 2090530 | 2022-01-07 | Clark | Kansas | 20025 | 398 | 7 |
2086939 | 2086939 | 2022-01-06 | Butte | Idaho | 16023 | 398 | 7 |
2088394 | 2088394 | 2022-01-06 | Grant | North Dakota | 38037 | 398 | 11 |
2088879 | 2088879 | 2022-01-06 | Mellette | South Dakota | 46095 | 398 | 4 |
2085526 | 2085526 | 2022-01-05 | Vieques | Puerto Rico | 72147 | 398 | |
2080795 | 2080795 | 2022-01-04 | Graham | Kansas | 20065 | 398 | 13 |
2081151 | 2081151 | 2022-01-04 | Keweenaw | Michigan | 26083 | 398 | 11 |
2077543 | 2077543 | 2022-01-03 | Graham | Kansas | 20065 | 398 | 13 |
2077899 | 2077899 | 2022-01-03 | Keweenaw | Michigan | 26083 | 398 | 11 |
2062181 | 2062181 | 2021-12-29 | De Baca | New Mexico | 35011 | 398 | 3 |
2059290 | 2059290 | 2021-12-28 | Harmon | Oklahoma | 40057 | 398 | 9 |
2056041 | 2056041 | 2021-12-27 | Harmon | Oklahoma | 40057 | 398 | 9 |
2052792 | 2052792 | 2021-12-26 | Harmon | Oklahoma | 40057 | 398 | 9 |
2049542 | 2049542 | 2021-12-25 | Harmon | Oklahoma | 40057 | 398 | 9 |
2046292 | 2046292 | 2021-12-24 | Harmon | Oklahoma | 40057 | 398 | 9 |
2043042 | 2043042 | 2021-12-23 | Harmon | Oklahoma | 40057 | 398 | 9 |
2039793 | 2039793 | 2021-12-22 | Harmon | Oklahoma | 40057 | 398 | 9 |
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);