ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
480 rows where deaths = 379 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 69
- Pennsylvania 38
- Georgia 34
- Florida 29
- Arizona 23
- New York 23
- Indiana 21
- Alabama 18
- Connecticut 18
- Ohio 18
- Illinois 16
- California 14
- North Carolina 13
- Arkansas 10
- Kansas 10
- South Carolina 10
- Michigan 9
- Iowa 8
- Oklahoma 8
- Virginia 8
- Kentucky 7
- Oregon 7
- West Virginia 7
- Mississippi 6
- New Mexico 6
- Tennessee 6
- Wisconsin 6
- Maryland 5
- Utah 5
- Minnesota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500106 | 2500106 | 2022-05-13 | Troup | Georgia | 13285 | 15503 | 379 |
2496848 | 2496848 | 2022-05-12 | Troup | Georgia | 13285 | 15503 | 379 |
2493590 | 2493590 | 2022-05-11 | Troup | Georgia | 13285 | 15503 | 379 |
2467098 | 2467098 | 2022-05-03 | Gila | Arizona | 4007 | 17295 | 379 |
2463843 | 2463843 | 2022-05-02 | Gila | Arizona | 4007 | 17295 | 379 |
2460587 | 2460587 | 2022-05-01 | Gila | Arizona | 4007 | 17295 | 379 |
2457331 | 2457331 | 2022-04-30 | Gila | Arizona | 4007 | 17295 | 379 |
2454075 | 2454075 | 2022-04-29 | Gila | Arizona | 4007 | 17295 | 379 |
2450819 | 2450819 | 2022-04-28 | Gila | Arizona | 4007 | 17295 | 379 |
2447563 | 2447563 | 2022-04-27 | Gila | Arizona | 4007 | 17295 | 379 |
2444307 | 2444307 | 2022-04-26 | Gila | Arizona | 4007 | 17200 | 379 |
2441051 | 2441051 | 2022-04-25 | Gila | Arizona | 4007 | 17200 | 379 |
2437795 | 2437795 | 2022-04-24 | Gila | Arizona | 4007 | 17200 | 379 |
2434539 | 2434539 | 2022-04-23 | Gila | Arizona | 4007 | 17200 | 379 |
2431283 | 2431283 | 2022-04-22 | Gila | Arizona | 4007 | 17200 | 379 |
2428027 | 2428027 | 2022-04-21 | Gila | Arizona | 4007 | 17200 | 379 |
2424771 | 2424771 | 2022-04-20 | Gila | Arizona | 4007 | 17200 | 379 |
2421515 | 2421515 | 2022-04-19 | Gila | Arizona | 4007 | 17190 | 379 |
2418259 | 2418259 | 2022-04-18 | Gila | Arizona | 4007 | 17190 | 379 |
2421164 | 2421164 | 2022-04-18 | Loudoun | Virginia | 51107 | 68782 | 379 |
2415003 | 2415003 | 2022-04-17 | Gila | Arizona | 4007 | 17190 | 379 |
2417908 | 2417908 | 2022-04-17 | Loudoun | Virginia | 51107 | 68599 | 379 |
2411747 | 2411747 | 2022-04-16 | Gila | Arizona | 4007 | 17190 | 379 |
2414652 | 2414652 | 2022-04-16 | Loudoun | Virginia | 51107 | 68599 | 379 |
2408491 | 2408491 | 2022-04-15 | Gila | Arizona | 4007 | 17190 | 379 |
2411396 | 2411396 | 2022-04-15 | Loudoun | Virginia | 51107 | 68599 | 379 |
2405235 | 2405235 | 2022-04-14 | Gila | Arizona | 4007 | 17190 | 379 |
2408140 | 2408140 | 2022-04-14 | Loudoun | Virginia | 51107 | 68519 | 379 |
2401980 | 2401980 | 2022-04-13 | Gila | Arizona | 4007 | 17190 | 379 |
2381316 | 2381316 | 2022-04-06 | Rogers | Oklahoma | 40131 | 25363 | 379 |
2378061 | 2378061 | 2022-04-05 | Rogers | Oklahoma | 40131 | 25363 | 379 |
2374807 | 2374807 | 2022-04-04 | Rogers | Oklahoma | 40131 | 25363 | 379 |
2375695 | 2375695 | 2022-04-04 | Cabell | West Virginia | 54011 | 27381 | 379 |
2371555 | 2371555 | 2022-04-03 | Rogers | Oklahoma | 40131 | 25363 | 379 |
2372443 | 2372443 | 2022-04-03 | Cabell | West Virginia | 54011 | 27368 | 379 |
2368302 | 2368302 | 2022-04-02 | Rogers | Oklahoma | 40131 | 25363 | 379 |
2369190 | 2369190 | 2022-04-02 | Cabell | West Virginia | 54011 | 27368 | 379 |
2365049 | 2365049 | 2022-04-01 | Rogers | Oklahoma | 40131 | 25363 | 379 |
2365937 | 2365937 | 2022-04-01 | Cabell | West Virginia | 54011 | 27368 | 379 |
2361796 | 2361796 | 2022-03-31 | Rogers | Oklahoma | 40131 | 25363 | 379 |
2362684 | 2362684 | 2022-03-31 | Cabell | West Virginia | 54011 | 27364 | 379 |
2359430 | 2359430 | 2022-03-30 | Cabell | West Virginia | 54011 | 27353 | 379 |
2356176 | 2356176 | 2022-03-29 | Cabell | West Virginia | 54011 | 27347 | 379 |
2347011 | 2347011 | 2022-03-27 | Forsyth | Georgia | 13117 | 55217 | 379 |
2348805 | 2348805 | 2022-03-27 | Douglas | Oregon | 41019 | 19692 | 379 |
2343758 | 2343758 | 2022-03-26 | Forsyth | Georgia | 13117 | 55217 | 379 |
2345552 | 2345552 | 2022-03-26 | Douglas | Oregon | 41019 | 19692 | 379 |
2340505 | 2340505 | 2022-03-25 | Forsyth | Georgia | 13117 | 55217 | 379 |
2342299 | 2342299 | 2022-03-25 | Douglas | Oregon | 41019 | 19692 | 379 |
2337252 | 2337252 | 2022-03-24 | Forsyth | Georgia | 13117 | 55219 | 379 |
2339046 | 2339046 | 2022-03-24 | Douglas | Oregon | 41019 | 19682 | 379 |
2333884 | 2333884 | 2022-03-23 | Columbia | Florida | 12023 | 21123 | 379 |
2335792 | 2335792 | 2022-03-23 | Douglas | Oregon | 41019 | 19672 | 379 |
2330630 | 2330630 | 2022-03-22 | Columbia | Florida | 12023 | 21123 | 379 |
2332538 | 2332538 | 2022-03-22 | Douglas | Oregon | 41019 | 19665 | 379 |
2333508 | 2333508 | 2022-03-22 | Rock | Wisconsin | 55105 | 42583 | 379 |
2327378 | 2327378 | 2022-03-21 | Columbia | Florida | 12023 | 21123 | 379 |
2327526 | 2327526 | 2022-03-21 | Lowndes | Georgia | 13185 | 30894 | 379 |
2324125 | 2324125 | 2022-03-20 | Columbia | Florida | 12023 | 21123 | 379 |
2324273 | 2324273 | 2022-03-20 | Lowndes | Georgia | 13185 | 30875 | 379 |
2324851 | 2324851 | 2022-03-20 | Kenton | Kentucky | 21117 | 45306 | 379 |
2320871 | 2320871 | 2022-03-19 | Columbia | Florida | 12023 | 21123 | 379 |
2321019 | 2321019 | 2022-03-19 | Lowndes | Georgia | 13185 | 30875 | 379 |
2321597 | 2321597 | 2022-03-19 | Kenton | Kentucky | 21117 | 45306 | 379 |
2317617 | 2317617 | 2022-03-18 | Columbia | Florida | 12023 | 21123 | 379 |
2317765 | 2317765 | 2022-03-18 | Lowndes | Georgia | 13185 | 30875 | 379 |
2318343 | 2318343 | 2022-03-18 | Kenton | Kentucky | 21117 | 45306 | 379 |
2314364 | 2314364 | 2022-03-17 | Columbia | Florida | 12023 | 21123 | 379 |
2314512 | 2314512 | 2022-03-17 | Lowndes | Georgia | 13185 | 30856 | 379 |
2315090 | 2315090 | 2022-03-17 | Kenton | Kentucky | 21117 | 45148 | 379 |
2310815 | 2310815 | 2022-03-16 | Lauderdale | Alabama | 1077 | 24009 | 379 |
2311111 | 2311111 | 2022-03-16 | Columbia | Florida | 12023 | 21123 | 379 |
2311259 | 2311259 | 2022-03-16 | Lowndes | Georgia | 13185 | 30847 | 379 |
2311837 | 2311837 | 2022-03-16 | Kenton | Kentucky | 21117 | 45148 | 379 |
2307562 | 2307562 | 2022-03-15 | Lauderdale | Alabama | 1077 | 24004 | 379 |
2308584 | 2308584 | 2022-03-15 | Kenton | Kentucky | 21117 | 45148 | 379 |
2305333 | 2305333 | 2022-03-14 | Kenton | Kentucky | 21117 | 45148 | 379 |
2307473 | 2307473 | 2022-03-14 | Outagamie | Wisconsin | 55087 | 54038 | 379 |
2302992 | 2302992 | 2022-03-13 | New Hanover | North Carolina | 37129 | 49514 | 379 |
2299740 | 2299740 | 2022-03-12 | New Hanover | North Carolina | 37129 | 49514 | 379 |
2296488 | 2296488 | 2022-03-11 | New Hanover | North Carolina | 37129 | 49514 | 379 |
2293236 | 2293236 | 2022-03-10 | New Hanover | North Carolina | 37129 | 49438 | 379 |
2288451 | 2288451 | 2022-03-09 | Douglas | Georgia | 13097 | 34669 | 379 |
2287223 | 2287223 | 2022-03-08 | Sumter | South Carolina | 45085 | 27705 | 379 |
2284396 | 2284396 | 2022-03-07 | Davis | Utah | 49011 | 99804 | 379 |
2281144 | 2281144 | 2022-03-06 | Davis | Utah | 49011 | 99748 | 379 |
2277891 | 2277891 | 2022-03-05 | Davis | Utah | 49011 | 99748 | 379 |
2274638 | 2274638 | 2022-03-04 | Davis | Utah | 49011 | 99748 | 379 |
2269282 | 2269282 | 2022-03-03 | Tippecanoe | Indiana | 18157 | 49650 | 379 |
2257333 | 2257333 | 2022-02-27 | Sandoval | New Mexico | 35043 | 32856 | 379 |
2254082 | 2254082 | 2022-02-26 | Sandoval | New Mexico | 35043 | 32856 | 379 |
2250831 | 2250831 | 2022-02-25 | Sandoval | New Mexico | 35043 | 32856 | 379 |
2241958 | 2241958 | 2022-02-22 | Guadalupe | Texas | 48187 | 36446 | 379 |
2223436 | 2223436 | 2022-02-17 | Glynn | Georgia | 13127 | 22470 | 379 |
2220185 | 2220185 | 2022-02-16 | Glynn | Georgia | 13127 | 22427 | 379 |
2218467 | 2218467 | 2022-02-15 | Rutherford | North Carolina | 37161 | 16956 | 379 |
2218937 | 2218937 | 2022-02-15 | Orangeburg | South Carolina | 45075 | 22989 | 379 |
2215216 | 2215216 | 2022-02-14 | Rutherford | North Carolina | 37161 | 16947 | 379 |
2215686 | 2215686 | 2022-02-14 | Orangeburg | South Carolina | 45075 | 22973 | 379 |
2210766 | 2210766 | 2022-02-13 | Vigo | Indiana | 18167 | 28398 | 379 |
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);