ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
458 rows where deaths = 386 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 51
- Florida 37
- Texas 36
- Georgia 34
- Mississippi 31
- Pennsylvania 30
- Alabama 22
- California 18
- Indiana 18
- South Carolina 18
- North Carolina 16
- Oklahoma 14
- Tennessee 14
- Wisconsin 12
- Colorado 11
- Ohio 11
- Illinois 9
- Maryland 9
- Arkansas 8
- Louisiana 8
- Utah 8
- Virginia 7
- New York 6
- Nebraska 5
- Kansas 4
- Kentucky 3
- Minnesota 3
- New Hampshire 3
- New Jersey 3
- Arizona 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491734 | 2491734 | 2022-05-10 | Cleveland | North Carolina | 37045 | 29670 | 386 |
2488476 | 2488476 | 2022-05-09 | Cleveland | North Carolina | 37045 | 29670 | 386 |
2485219 | 2485219 | 2022-05-08 | Cleveland | North Carolina | 37045 | 29670 | 386 |
2481961 | 2481961 | 2022-05-07 | Cleveland | North Carolina | 37045 | 29670 | 386 |
2478703 | 2478703 | 2022-05-06 | Cleveland | North Carolina | 37045 | 29670 | 386 |
2475445 | 2475445 | 2022-05-05 | Cleveland | North Carolina | 37045 | 29670 | 386 |
2472188 | 2472188 | 2022-05-04 | Cleveland | North Carolina | 37045 | 29670 | 386 |
2467425 | 2467425 | 2022-05-03 | Columbia | Georgia | 13073 | 36177 | 386 |
2464170 | 2464170 | 2022-05-02 | Columbia | Georgia | 13073 | 36177 | 386 |
2460914 | 2460914 | 2022-05-01 | Columbia | Georgia | 13073 | 36176 | 386 |
2457658 | 2457658 | 2022-04-30 | Columbia | Georgia | 13073 | 36176 | 386 |
2454402 | 2454402 | 2022-04-29 | Columbia | Georgia | 13073 | 36176 | 386 |
2451146 | 2451146 | 2022-04-28 | Columbia | Georgia | 13073 | 36176 | 386 |
2447890 | 2447890 | 2022-04-27 | Columbia | Georgia | 13073 | 36176 | 386 |
2449630 | 2449630 | 2022-04-27 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2446373 | 2446373 | 2022-04-26 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2443118 | 2443118 | 2022-04-25 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2439862 | 2439862 | 2022-04-24 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2436606 | 2436606 | 2022-04-23 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2433350 | 2433350 | 2022-04-22 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2430094 | 2430094 | 2022-04-21 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2426838 | 2426838 | 2022-04-20 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2423582 | 2423582 | 2022-04-19 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2420325 | 2420325 | 2022-04-18 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2417070 | 2417070 | 2022-04-17 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2413814 | 2413814 | 2022-04-16 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2410558 | 2410558 | 2022-04-15 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2407302 | 2407302 | 2022-04-14 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2373070 | 2373070 | 2022-04-04 | Lowndes | Georgia | 13185 | 30961 | 386 |
2375798 | 2375798 | 2022-04-04 | Rock | Wisconsin | 55105 | 42821 | 386 |
2369783 | 2369783 | 2022-04-03 | Forsyth | Georgia | 13117 | 55351 | 386 |
2369817 | 2369817 | 2022-04-03 | Lowndes | Georgia | 13185 | 30953 | 386 |
2372546 | 2372546 | 2022-04-03 | Rock | Wisconsin | 55105 | 42790 | 386 |
2366530 | 2366530 | 2022-04-02 | Forsyth | Georgia | 13117 | 55351 | 386 |
2366564 | 2366564 | 2022-04-02 | Lowndes | Georgia | 13185 | 30953 | 386 |
2369293 | 2369293 | 2022-04-02 | Rock | Wisconsin | 55105 | 42790 | 386 |
2363277 | 2363277 | 2022-04-01 | Forsyth | Georgia | 13117 | 55351 | 386 |
2363311 | 2363311 | 2022-04-01 | Lowndes | Georgia | 13185 | 30953 | 386 |
2366040 | 2366040 | 2022-04-01 | Rock | Wisconsin | 55105 | 42790 | 386 |
2360057 | 2360057 | 2022-03-31 | Lowndes | Georgia | 13185 | 30947 | 386 |
2361579 | 2361579 | 2022-03-31 | Wayne | North Carolina | 37191 | 30164 | 386 |
2362787 | 2362787 | 2022-03-31 | Rock | Wisconsin | 55105 | 42774 | 386 |
2356803 | 2356803 | 2022-03-30 | Lowndes | Georgia | 13185 | 30942 | 386 |
2358325 | 2358325 | 2022-03-30 | Wayne | North Carolina | 37191 | 30045 | 386 |
2353550 | 2353550 | 2022-03-29 | Lowndes | Georgia | 13185 | 30929 | 386 |
2352278 | 2352278 | 2022-03-28 | Sumter | South Carolina | 45085 | 27761 | 386 |
2346601 | 2346601 | 2022-03-27 | Lauderdale | Alabama | 1077 | 24054 | 386 |
2349026 | 2349026 | 2022-03-27 | Sumter | South Carolina | 45085 | 27761 | 386 |
2343348 | 2343348 | 2022-03-26 | Lauderdale | Alabama | 1077 | 24054 | 386 |
2345773 | 2345773 | 2022-03-26 | Sumter | South Carolina | 45085 | 27761 | 386 |
2340095 | 2340095 | 2022-03-25 | Lauderdale | Alabama | 1077 | 24054 | 386 |
2342520 | 2342520 | 2022-03-25 | Sumter | South Carolina | 45085 | 27761 | 386 |
2336842 | 2336842 | 2022-03-24 | Lauderdale | Alabama | 1077 | 24050 | 386 |
2339267 | 2339267 | 2022-03-24 | Sumter | South Carolina | 45085 | 27761 | 386 |
2333588 | 2333588 | 2022-03-23 | Lauderdale | Alabama | 1077 | 24046 | 386 |
2336013 | 2336013 | 2022-03-23 | Sumter | South Carolina | 45085 | 27761 | 386 |
2330734 | 2330734 | 2022-03-22 | Douglas | Georgia | 13097 | 34712 | 386 |
2332759 | 2332759 | 2022-03-22 | Sumter | South Carolina | 45085 | 27761 | 386 |
2311163 | 2311163 | 2022-03-16 | Unknown | Florida | 5091 | 386 | |
2313397 | 2313397 | 2022-03-16 | Unknown | Tennessee | 18567 | 386 | |
2313665 | 2313665 | 2022-03-16 | Davis | Utah | 49011 | 99966 | 386 |
2310151 | 2310151 | 2022-03-15 | Williamson | Tennessee | 47187 | 61684 | 386 |
2310412 | 2310412 | 2022-03-15 | Davis | Utah | 49011 | 99956 | 386 |
2306898 | 2306898 | 2022-03-14 | Williamson | Tennessee | 47187 | 61684 | 386 |
2307159 | 2307159 | 2022-03-14 | Davis | Utah | 49011 | 99971 | 386 |
2303647 | 2303647 | 2022-03-13 | Williamson | Tennessee | 47187 | 61684 | 386 |
2303908 | 2303908 | 2022-03-13 | Davis | Utah | 49011 | 99904 | 386 |
2300395 | 2300395 | 2022-03-12 | Williamson | Tennessee | 47187 | 61684 | 386 |
2300656 | 2300656 | 2022-03-12 | Davis | Utah | 49011 | 99904 | 386 |
2297143 | 2297143 | 2022-03-11 | Williamson | Tennessee | 47187 | 61684 | 386 |
2297404 | 2297404 | 2022-03-11 | Davis | Utah | 49011 | 99904 | 386 |
2291979 | 2291979 | 2022-03-10 | Clark | Indiana | 18019 | 30949 | 386 |
2293891 | 2293891 | 2022-03-10 | Williamson | Tennessee | 47187 | 61684 | 386 |
2288727 | 2288727 | 2022-03-09 | Clark | Indiana | 18019 | 30943 | 386 |
2290639 | 2290639 | 2022-03-09 | Williamson | Tennessee | 47187 | 61684 | 386 |
2285476 | 2285476 | 2022-03-08 | Clark | Indiana | 18019 | 30931 | 386 |
2282224 | 2282224 | 2022-03-07 | Clark | Indiana | 18019 | 30919 | 386 |
2278971 | 2278971 | 2022-03-06 | Clark | Indiana | 18019 | 30896 | 386 |
2275718 | 2275718 | 2022-03-05 | Clark | Indiana | 18019 | 30896 | 386 |
2272465 | 2272465 | 2022-03-04 | Clark | Indiana | 18019 | 30896 | 386 |
2269213 | 2269213 | 2022-03-03 | Clark | Indiana | 18019 | 30860 | 386 |
2265960 | 2265960 | 2022-03-02 | Clark | Indiana | 18019 | 30837 | 386 |
2262709 | 2262709 | 2022-03-01 | Clark | Indiana | 18019 | 30831 | 386 |
2264714 | 2264714 | 2022-03-01 | Guadalupe | Texas | 48187 | 36748 | 386 |
2257427 | 2257427 | 2022-02-27 | Davidson | North Carolina | 37057 | 42562 | 386 |
2254176 | 2254176 | 2022-02-26 | Davidson | North Carolina | 37057 | 42562 | 386 |
2250925 | 2250925 | 2022-02-25 | Davidson | North Carolina | 37057 | 42562 | 386 |
2246256 | 2246256 | 2022-02-24 | Spalding | Georgia | 13255 | 15679 | 386 |
2239296 | 2239296 | 2022-02-22 | St. Clair | Alabama | 1115 | 24867 | 386 |
2240448 | 2240448 | 2022-02-22 | Carroll | Maryland | 24013 | 20937 | 386 |
2241224 | 2241224 | 2022-02-22 | Rutherford | North Carolina | 37161 | 17160 | 386 |
2236045 | 2236045 | 2022-02-21 | St. Clair | Alabama | 1115 | 24860 | 386 |
2237197 | 2237197 | 2022-02-21 | Carroll | Maryland | 24013 | 20918 | 386 |
2237973 | 2237973 | 2022-02-21 | Rutherford | North Carolina | 37161 | 17145 | 386 |
2238443 | 2238443 | 2022-02-21 | Orangeburg | South Carolina | 45075 | 23064 | 386 |
2232794 | 2232794 | 2022-02-20 | St. Clair | Alabama | 1115 | 24850 | 386 |
2233946 | 2233946 | 2022-02-20 | Carroll | Maryland | 24013 | 20918 | 386 |
2235192 | 2235192 | 2022-02-20 | Orangeburg | South Carolina | 45075 | 23064 | 386 |
2229543 | 2229543 | 2022-02-19 | St. Clair | Alabama | 1115 | 24843 | 386 |
2231941 | 2231941 | 2022-02-19 | Orangeburg | South Carolina | 45075 | 23064 | 386 |
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);