ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
188 rows where cases = 3230 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 16
- Tennessee 16
- Iowa 15
- Georgia 14
- Kansas 9
- Louisiana 9
- North Carolina 8
- Illinois 7
- Oklahoma 7
- Virginia 7
- Alabama 6
- Kentucky 5
- Mississippi 5
- Missouri 5
- South Dakota 5
- Texas 5
- Indiana 4
- New Mexico 4
- Utah 4
- Wisconsin 4
- Idaho 3
- Minnesota 3
- Montana 3
- Oregon 3
- Puerto Rico 3
- South Carolina 3
- Wyoming 3
- California 2
- New York 2
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501153 | 2501153 | 2022-05-13 | Osage | Missouri | 29151 | 3230 | 46 |
2498553 | 2498553 | 2022-05-12 | Baker | Oregon | 41001 | 3230 | 48 |
2475905 | 2475905 | 2022-05-05 | Orocovis | Puerto Rico | 72107 | 3230 | |
2461834 | 2461834 | 2022-05-01 | Cottonwood | Minnesota | 27033 | 3230 | 41 |
2458578 | 2458578 | 2022-04-30 | Cottonwood | Minnesota | 27033 | 3230 | 41 |
2455322 | 2455322 | 2022-04-29 | Cottonwood | Minnesota | 27033 | 3230 | 41 |
2444707 | 2444707 | 2022-04-26 | Oglethorpe | Georgia | 13221 | 3230 | 56 |
2441451 | 2441451 | 2022-04-25 | Oglethorpe | Georgia | 13221 | 3230 | 56 |
2438195 | 2438195 | 2022-04-24 | Oglethorpe | Georgia | 13221 | 3230 | 56 |
2434939 | 2434939 | 2022-04-23 | Oglethorpe | Georgia | 13221 | 3230 | 56 |
2431683 | 2431683 | 2022-04-22 | Oglethorpe | Georgia | 13221 | 3230 | 56 |
2428427 | 2428427 | 2022-04-21 | Oglethorpe | Georgia | 13221 | 3230 | 56 |
2428891 | 2428891 | 2022-04-21 | Nemaha | Kansas | 20131 | 3230 | 60 |
2425171 | 2425171 | 2022-04-20 | Oglethorpe | Georgia | 13221 | 3230 | 56 |
2425635 | 2425635 | 2022-04-20 | Nemaha | Kansas | 20131 | 3230 | 60 |
2422379 | 2422379 | 2022-04-19 | Nemaha | Kansas | 20131 | 3230 | 60 |
2424364 | 2424364 | 2022-04-19 | Brunswick | Virginia | 51025 | 3230 | 47 |
2419123 | 2419123 | 2022-04-18 | Nemaha | Kansas | 20131 | 3230 | 60 |
2415867 | 2415867 | 2022-04-17 | Nemaha | Kansas | 20131 | 3230 | 60 |
2412611 | 2412611 | 2022-04-16 | Nemaha | Kansas | 20131 | 3230 | 60 |
2409355 | 2409355 | 2022-04-15 | Nemaha | Kansas | 20131 | 3230 | 60 |
2317088 | 2317088 | 2022-03-17 | Westmoreland | Virginia | 51193 | 3230 | 50 |
2292227 | 2292227 | 2022-03-10 | Nemaha | Kansas | 20131 | 3230 | 60 |
2288975 | 2288975 | 2022-03-09 | Nemaha | Kansas | 20131 | 3230 | 60 |
2271902 | 2271902 | 2022-03-04 | Little River | Arkansas | 5081 | 3230 | 88 |
2268650 | 2268650 | 2022-03-03 | Little River | Arkansas | 5081 | 3230 | 88 |
2266776 | 2266776 | 2022-03-02 | Dent | Missouri | 29065 | 3230 | 74 |
2247706 | 2247706 | 2022-02-24 | Mitchell | North Carolina | 37121 | 3230 | 33 |
2238881 | 2238881 | 2022-02-21 | Millard | Utah | 49027 | 3230 | 34 |
2235630 | 2235630 | 2022-02-20 | Millard | Utah | 49027 | 3230 | 34 |
2232379 | 2232379 | 2022-02-19 | Millard | Utah | 49027 | 3230 | 34 |
2229128 | 2229128 | 2022-02-18 | Millard | Utah | 49027 | 3230 | 34 |
2217616 | 2217616 | 2022-02-15 | Claiborne | Louisiana | 22027 | 3230 | 71 |
2217635 | 2217635 | 2022-02-15 | Madison | Louisiana | 22065 | 3230 | 58 |
2205378 | 2205378 | 2022-02-11 | Yates | New York | 36123 | 3230 | 37 |
2196695 | 2196695 | 2022-02-08 | Greensville | Virginia | 51081 | 3230 | 32 |
2178560 | 2178560 | 2022-02-03 | Trigg | Kentucky | 21221 | 3230 | 37 |
2164616 | 2164616 | 2022-01-30 | Van Buren | Arkansas | 5141 | 3230 | 48 |
2161361 | 2161361 | 2022-01-29 | Van Buren | Arkansas | 5141 | 3230 | 48 |
2158105 | 2158105 | 2022-01-28 | Van Buren | Arkansas | 5141 | 3230 | 48 |
2142776 | 2142776 | 2022-01-23 | Webster | Kentucky | 21233 | 3230 | 46 |
2139521 | 2139521 | 2022-01-22 | Webster | Kentucky | 21233 | 3230 | 46 |
2141275 | 2141275 | 2022-01-22 | Wilbarger | Texas | 48487 | 3230 | 77 |
2136265 | 2136265 | 2022-01-21 | Webster | Kentucky | 21233 | 3230 | 46 |
2134524 | 2134524 | 2022-01-20 | Aransas | Texas | 48007 | 3230 | 69 |
2126284 | 2126284 | 2022-01-18 | Wright | Iowa | 19197 | 3230 | 54 |
2128371 | 2128371 | 2022-01-18 | Greene | Virginia | 51079 | 3230 | 47 |
2123032 | 2123032 | 2022-01-17 | Wright | Iowa | 19197 | 3230 | 54 |
2119780 | 2119780 | 2022-01-16 | Wright | Iowa | 19197 | 3230 | 54 |
2116528 | 2116528 | 2022-01-15 | Wright | Iowa | 19197 | 3230 | 54 |
2113277 | 2113277 | 2022-01-14 | Wright | Iowa | 19197 | 3230 | 54 |
2110025 | 2110025 | 2022-01-13 | Wright | Iowa | 19197 | 3230 | 54 |
2111541 | 2111541 | 2022-01-13 | Yauco | Puerto Rico | 72153 | 3230 | |
2106774 | 2106774 | 2022-01-12 | Wright | Iowa | 19197 | 3230 | 54 |
2092429 | 2092429 | 2022-01-07 | Panola | Texas | 48365 | 3230 | 111 |
2027894 | 2027894 | 2021-12-19 | Hale | Alabama | 1065 | 3230 | 89 |
2024643 | 2024643 | 2021-12-18 | Hale | Alabama | 1065 | 3230 | 89 |
2018744 | 2018744 | 2021-12-16 | Hancock | Illinois | 17067 | 3230 | 45 |
2018014 | 2018014 | 2021-12-15 | Adams | Wisconsin | 55001 | 3230 | 37 |
2012434 | 2012434 | 2021-12-14 | Dickinson | Iowa | 19059 | 3230 | 56 |
2009183 | 2009183 | 2021-12-13 | Dickinson | Iowa | 19059 | 3230 | 56 |
2010620 | 2010620 | 2021-12-13 | Wasco | Oregon | 41065 | 3230 | 47 |
2005932 | 2005932 | 2021-12-12 | Dickinson | Iowa | 19059 | 3230 | 56 |
2001864 | 2001864 | 2021-12-11 | Cherokee | Alabama | 1019 | 3230 | 64 |
2002681 | 2002681 | 2021-12-11 | Dickinson | Iowa | 19059 | 3230 | 56 |
1999431 | 1999431 | 2021-12-10 | Dickinson | Iowa | 19059 | 3230 | 56 |
1996180 | 1996180 | 2021-12-09 | Dickinson | Iowa | 19059 | 3230 | 56 |
1992929 | 1992929 | 2021-12-08 | Dickinson | Iowa | 19059 | 3230 | 56 |
1940259 | 1940259 | 2021-11-22 | Phillips | Arkansas | 5107 | 3230 | 77 |
1937009 | 1937009 | 2021-11-21 | Phillips | Arkansas | 5107 | 3230 | 77 |
1937436 | 1937436 | 2021-11-21 | Minidoka | Idaho | 16067 | 3230 | 49 |
1933759 | 1933759 | 2021-11-20 | Phillips | Arkansas | 5107 | 3230 | 77 |
1934186 | 1934186 | 2021-11-20 | Minidoka | Idaho | 16067 | 3230 | 49 |
1930507 | 1930507 | 2021-11-19 | Phillips | Arkansas | 5107 | 3230 | 77 |
1915923 | 1915923 | 2021-11-14 | Lincoln | New Mexico | 35027 | 3230 | 37 |
1912673 | 1912673 | 2021-11-13 | Lincoln | New Mexico | 35027 | 3230 | 37 |
1909423 | 1909423 | 2021-11-12 | Lincoln | New Mexico | 35027 | 3230 | 37 |
1907560 | 1907560 | 2021-11-11 | Taylor | Wisconsin | 55119 | 3230 | 47 |
1897636 | 1897636 | 2021-11-08 | Scott | Virginia | 51169 | 3230 | 79 |
1878286 | 1878286 | 2021-11-02 | Langlade | Wisconsin | 55067 | 3230 | 56 |
1859253 | 1859253 | 2021-10-28 | Ben Hill | Georgia | 13017 | 3230 | 101 |
1849227 | 1849227 | 2021-10-25 | Clark | Arkansas | 5019 | 3230 | 55 |
1845977 | 1845977 | 2021-10-24 | Clark | Arkansas | 5019 | 3230 | 55 |
1806874 | 1806874 | 2021-10-12 | Butler | Alabama | 1013 | 3230 | 94 |
1806054 | 1806054 | 2021-10-11 | Fairfield | South Carolina | 45039 | 3230 | 94 |
1800423 | 1800423 | 2021-10-10 | Randolph | Alabama | 1111 | 3230 | 60 |
1801149 | 1801149 | 2021-10-10 | Sullivan | Indiana | 18153 | 3230 | 53 |
1797900 | 1797900 | 2021-10-09 | Sullivan | Indiana | 18153 | 3230 | 53 |
1794651 | 1794651 | 2021-10-08 | Sullivan | Indiana | 18153 | 3230 | 53 |
1779263 | 1779263 | 2021-10-03 | Lake | Montana | 30047 | 3230 | 53 |
1776013 | 1776013 | 2021-10-02 | Lake | Montana | 30047 | 3230 | 53 |
1772763 | 1772763 | 2021-10-01 | Lake | Montana | 30047 | 3230 | 53 |
1715354 | 1715354 | 2021-09-13 | Gillespie | Texas | 48171 | 3230 | 65 |
1711261 | 1711261 | 2021-09-12 | Franklin | New York | 36033 | 3230 | 13 |
1711686 | 1711686 | 2021-09-12 | Elk | Pennsylvania | 42047 | 3230 | 44 |
1698314 | 1698314 | 2021-09-08 | Anson | North Carolina | 37007 | 3230 | 62 |
1692436 | 1692436 | 2021-09-06 | Yankton | South Dakota | 46135 | 3230 | 33 |
1689187 | 1689187 | 2021-09-05 | Yankton | South Dakota | 46135 | 3230 | 33 |
1685937 | 1685937 | 2021-09-04 | Yankton | South Dakota | 46135 | 3230 | 33 |
1682516 | 1682516 | 2021-09-03 | Dorado | Puerto Rico | 72051 | 3230 |
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);