ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
399 rows where deaths = 384 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 34
- Indiana 30
- Pennsylvania 29
- Ohio 23
- North Carolina 22
- Georgia 21
- Louisiana 21
- Michigan 17
- Virginia 17
- California 15
- Alabama 13
- Florida 13
- Minnesota 11
- South Carolina 10
- Wisconsin 9
- Illinois 7
- Iowa 7
- Mississippi 7
- New Mexico 7
- Rhode Island 7
- Tennessee 7
- Arizona 6
- Arkansas 6
- Idaho 6
- Nebraska 6
- Utah 6
- Colorado 4
- Delaware 4
- Hawaii 4
- Missouri 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492806 | 2492806 | 2022-05-10 | Loudoun | Virginia | 51107 | 71271 | 384 |
2489548 | 2489548 | 2022-05-09 | Loudoun | Virginia | 51107 | 71059 | 384 |
2486291 | 2486291 | 2022-05-08 | Loudoun | Virginia | 51107 | 70633 | 384 |
2483033 | 2483033 | 2022-05-07 | Loudoun | Virginia | 51107 | 70633 | 384 |
2479775 | 2479775 | 2022-05-06 | Loudoun | Virginia | 51107 | 70633 | 384 |
2463492 | 2463492 | 2022-05-01 | Loudoun | Virginia | 51107 | 69736 | 384 |
2460236 | 2460236 | 2022-04-30 | Loudoun | Virginia | 51107 | 69736 | 384 |
2456980 | 2456980 | 2022-04-29 | Loudoun | Virginia | 51107 | 69736 | 384 |
2444634 | 2444634 | 2022-04-26 | Columbia | Georgia | 13073 | 36012 | 384 |
2441378 | 2441378 | 2022-04-25 | Columbia | Georgia | 13073 | 36012 | 384 |
2438122 | 2438122 | 2022-04-24 | Columbia | Georgia | 13073 | 36010 | 384 |
2434866 | 2434866 | 2022-04-23 | Columbia | Georgia | 13073 | 36010 | 384 |
2431610 | 2431610 | 2022-04-22 | Columbia | Georgia | 13073 | 36010 | 384 |
2428354 | 2428354 | 2022-04-21 | Columbia | Georgia | 13073 | 36010 | 384 |
2425098 | 2425098 | 2022-04-20 | Columbia | Georgia | 13073 | 36010 | 384 |
2394360 | 2394360 | 2022-04-10 | Douglas | Oregon | 41019 | 19747 | 384 |
2391104 | 2391104 | 2022-04-09 | Douglas | Oregon | 41019 | 19747 | 384 |
2387848 | 2387848 | 2022-04-08 | Douglas | Oregon | 41019 | 19747 | 384 |
2384593 | 2384593 | 2022-04-07 | Douglas | Oregon | 41019 | 19745 | 384 |
2376226 | 2376226 | 2022-04-05 | Unknown | Florida | 15311 | 384 | |
2353946 | 2353946 | 2022-03-29 | Scott | Iowa | 19163 | 40960 | 384 |
2350694 | 2350694 | 2022-03-28 | Scott | Iowa | 19163 | 40960 | 384 |
2351787 | 2351787 | 2022-03-28 | New Hanover | North Carolina | 37129 | 50193 | 384 |
2351818 | 2351818 | 2022-03-28 | Wayne | North Carolina | 37191 | 29847 | 384 |
2347441 | 2347441 | 2022-03-27 | Scott | Iowa | 19163 | 40960 | 384 |
2348535 | 2348535 | 2022-03-27 | New Hanover | North Carolina | 37129 | 50095 | 384 |
2348566 | 2348566 | 2022-03-27 | Wayne | North Carolina | 37191 | 29613 | 384 |
2344188 | 2344188 | 2022-03-26 | Scott | Iowa | 19163 | 40960 | 384 |
2345282 | 2345282 | 2022-03-26 | New Hanover | North Carolina | 37129 | 50095 | 384 |
2345313 | 2345313 | 2022-03-26 | Wayne | North Carolina | 37191 | 29613 | 384 |
2340935 | 2340935 | 2022-03-25 | Scott | Iowa | 19163 | 40960 | 384 |
2342029 | 2342029 | 2022-03-25 | New Hanover | North Carolina | 37129 | 50095 | 384 |
2342060 | 2342060 | 2022-03-25 | Wayne | North Carolina | 37191 | 29613 | 384 |
2337682 | 2337682 | 2022-03-24 | Scott | Iowa | 19163 | 40960 | 384 |
2334428 | 2334428 | 2022-03-23 | Scott | Iowa | 19163 | 40960 | 384 |
2332268 | 2332268 | 2022-03-22 | New Hanover | North Carolina | 37129 | 49933 | 384 |
2327082 | 2327082 | 2022-03-21 | Lauderdale | Alabama | 1077 | 24039 | 384 |
2323829 | 2323829 | 2022-03-20 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2326806 | 2326806 | 2022-03-20 | Newport News city | Virginia | 51700 | 36032 | 384 |
2320575 | 2320575 | 2022-03-19 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2323553 | 2323553 | 2022-03-19 | Newport News city | Virginia | 51700 | 36032 | 384 |
2317321 | 2317321 | 2022-03-18 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2320299 | 2320299 | 2022-03-18 | Newport News city | Virginia | 51700 | 36032 | 384 |
2317045 | 2317045 | 2022-03-17 | Newport News city | Virginia | 51700 | 36023 | 384 |
2313792 | 2313792 | 2022-03-16 | Newport News city | Virginia | 51700 | 36017 | 384 |
2308307 | 2308307 | 2022-03-15 | Tippecanoe | Indiana | 18157 | 49762 | 384 |
2304463 | 2304463 | 2022-03-14 | Butte | California | 6007 | 39428 | 384 |
2305056 | 2305056 | 2022-03-14 | Tippecanoe | Indiana | 18157 | 49752 | 384 |
2301804 | 2301804 | 2022-03-13 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2298552 | 2298552 | 2022-03-12 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2295300 | 2295300 | 2022-03-11 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2292048 | 2292048 | 2022-03-10 | Tippecanoe | Indiana | 18157 | 49731 | 384 |
2294361 | 2294361 | 2022-03-10 | Thurston | Washington | 53067 | 45941 | 384 |
2288796 | 2288796 | 2022-03-09 | Tippecanoe | Indiana | 18157 | 49712 | 384 |
2291109 | 2291109 | 2022-03-09 | Thurston | Washington | 53067 | 45941 | 384 |
2283350 | 2283350 | 2022-03-07 | Sandoval | New Mexico | 35043 | 33094 | 384 |
2280097 | 2280097 | 2022-03-06 | Sandoval | New Mexico | 35043 | 33049 | 384 |
2276844 | 2276844 | 2022-03-05 | Sandoval | New Mexico | 35043 | 33049 | 384 |
2273591 | 2273591 | 2022-03-04 | Sandoval | New Mexico | 35043 | 33049 | 384 |
2259458 | 2259458 | 2022-02-28 | Clark | Indiana | 18019 | 30823 | 384 |
2254962 | 2254962 | 2022-02-26 | Guadalupe | Texas | 48187 | 36643 | 384 |
2243005 | 2243005 | 2022-02-23 | Spalding | Georgia | 13255 | 15674 | 384 |
2241172 | 2241172 | 2022-02-22 | Davidson | North Carolina | 37057 | 42432 | 384 |
2237921 | 2237921 | 2022-02-21 | Davidson | North Carolina | 37057 | 42421 | 384 |
2233906 | 2233906 | 2022-02-20 | St. Landry | Louisiana | 22097 | 21972 | 384 |
2230655 | 2230655 | 2022-02-19 | St. Landry | Louisiana | 22097 | 21972 | 384 |
2227404 | 2227404 | 2022-02-18 | St. Landry | Louisiana | 22097 | 21972 | 384 |
2223041 | 2223041 | 2022-02-17 | St. Clair | Alabama | 1115 | 24800 | 384 |
2224153 | 2224153 | 2022-02-17 | St. Landry | Louisiana | 22097 | 21943 | 384 |
2224969 | 2224969 | 2022-02-17 | Rutherford | North Carolina | 37161 | 17055 | 384 |
2219790 | 2219790 | 2022-02-16 | St. Clair | Alabama | 1115 | 24782 | 384 |
2216540 | 2216540 | 2022-02-15 | St. Clair | Alabama | 1115 | 24751 | 384 |
2213289 | 2213289 | 2022-02-14 | St. Clair | Alabama | 1115 | 24696 | 384 |
2210036 | 2210036 | 2022-02-13 | St. Clair | Alabama | 1115 | 24676 | 384 |
2210524 | 2210524 | 2022-02-13 | Whitfield | Georgia | 13313 | 33023 | 384 |
2211960 | 2211960 | 2022-02-13 | Randolph | North Carolina | 37151 | 34441 | 384 |
2212889 | 2212889 | 2022-02-13 | Weber | Utah | 49057 | 69645 | 384 |
2206783 | 2206783 | 2022-02-12 | St. Clair | Alabama | 1115 | 24659 | 384 |
2207271 | 2207271 | 2022-02-12 | Whitfield | Georgia | 13313 | 33023 | 384 |
2208707 | 2208707 | 2022-02-12 | Randolph | North Carolina | 37151 | 34441 | 384 |
2209636 | 2209636 | 2022-02-12 | Weber | Utah | 49057 | 69645 | 384 |
2204018 | 2204018 | 2022-02-11 | Whitfield | Georgia | 13313 | 33023 | 384 |
2205454 | 2205454 | 2022-02-11 | Randolph | North Carolina | 37151 | 34441 | 384 |
2206245 | 2206245 | 2022-02-11 | Liberty | Texas | 48291 | 17114 | 384 |
2206383 | 2206383 | 2022-02-11 | Weber | Utah | 49057 | 69645 | 384 |
2202201 | 2202201 | 2022-02-10 | Randolph | North Carolina | 37151 | 34346 | 384 |
2202867 | 2202867 | 2022-02-10 | Brazos | Texas | 48041 | 58858 | 384 |
2203130 | 2203130 | 2022-02-10 | Weber | Utah | 49057 | 69327 | 384 |
2199269 | 2199269 | 2022-02-09 | Lawrence | Pennsylvania | 42073 | 18483 | 384 |
2199876 | 2199876 | 2022-02-09 | Weber | Utah | 49057 | 69327 | 384 |
2191633 | 2191633 | 2022-02-07 | Terrebonne | Louisiana | 22109 | 29990 | 384 |
2192544 | 2192544 | 2022-02-07 | Fairfield | Ohio | 39045 | 37547 | 384 |
2189160 | 2189160 | 2022-02-06 | Johnston | North Carolina | 37101 | 55086 | 384 |
2189290 | 2189290 | 2022-02-06 | Fairfield | Ohio | 39045 | 37512 | 384 |
2185907 | 2185907 | 2022-02-05 | Johnston | North Carolina | 37101 | 55086 | 384 |
2186037 | 2186037 | 2022-02-05 | Fairfield | Ohio | 39045 | 37488 | 384 |
2182655 | 2182655 | 2022-02-04 | Johnston | North Carolina | 37101 | 55086 | 384 |
2182785 | 2182785 | 2022-02-04 | Fairfield | Ohio | 39045 | 37454 | 384 |
2174733 | 2174733 | 2022-02-02 | Walton | Georgia | 13297 | 21424 | 384 |
2166192 | 2166192 | 2022-01-30 | Unknown | Nebraska | 2215 | 384 |
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);