ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where cases = 2541 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 21
- Texas 20
- Puerto Rico 16
- Iowa 13
- Virginia 13
- Missouri 11
- Mississippi 10
- Indiana 8
- Kentucky 8
- North Carolina 8
- Nebraska 6
- Ohio 6
- Alabama 5
- Arkansas 5
- Idaho 5
- Illinois 4
- Kansas 4
- Michigan 4
- Tennessee 4
- Colorado 3
- Florida 3
- Louisiana 3
- Minnesota 3
- Montana 3
- New Hampshire 3
- Pennsylvania 3
- South Carolina 3
- Washington 3
- Wyoming 3
- California 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461977 | 2461977 | 2022-05-01 | Tunica | Mississippi | 28143 | 2541 | 47 |
2458721 | 2458721 | 2022-04-30 | Tunica | Mississippi | 28143 | 2541 | 47 |
2455465 | 2455465 | 2022-04-29 | Tunica | Mississippi | 28143 | 2541 | 47 |
2452209 | 2452209 | 2022-04-28 | Tunica | Mississippi | 28143 | 2541 | 47 |
2448953 | 2448953 | 2022-04-27 | Tunica | Mississippi | 28143 | 2541 | 47 |
2445697 | 2445697 | 2022-04-26 | Tunica | Mississippi | 28143 | 2541 | 47 |
2428178 | 2428178 | 2022-04-21 | Bent | Colorado | 8011 | 2541 | 47 |
2385386 | 2385386 | 2022-04-07 | Richmond | Virginia | 51159 | 2541 | 25 |
2327576 | 2327576 | 2022-03-21 | Turner | Georgia | 13287 | 2541 | 58 |
2324323 | 2324323 | 2022-03-20 | Turner | Georgia | 13287 | 2541 | 58 |
2321069 | 2321069 | 2022-03-19 | Turner | Georgia | 13287 | 2541 | 58 |
2317815 | 2317815 | 2022-03-18 | Turner | Georgia | 13287 | 2541 | 58 |
2314562 | 2314562 | 2022-03-17 | Turner | Georgia | 13287 | 2541 | 57 |
2314747 | 2314747 | 2022-03-17 | Crawford | Indiana | 18025 | 2541 | 37 |
2317002 | 2317002 | 2022-03-17 | Floyd | Virginia | 51063 | 2541 | 46 |
2311309 | 2311309 | 2022-03-16 | Turner | Georgia | 13287 | 2541 | 57 |
2311494 | 2311494 | 2022-03-16 | Crawford | Indiana | 18025 | 2541 | 37 |
2308056 | 2308056 | 2022-03-15 | Turner | Georgia | 13287 | 2541 | 57 |
2304805 | 2304805 | 2022-03-14 | Turner | Georgia | 13287 | 2541 | 57 |
2307249 | 2307249 | 2022-03-14 | Galax city | Virginia | 51640 | 2541 | 76 |
2301553 | 2301553 | 2022-03-13 | Turner | Georgia | 13287 | 2541 | 55 |
2298301 | 2298301 | 2022-03-12 | Turner | Georgia | 13287 | 2541 | 55 |
2295049 | 2295049 | 2022-03-11 | Turner | Georgia | 13287 | 2541 | 55 |
2291797 | 2291797 | 2022-03-10 | Turner | Georgia | 13287 | 2541 | 55 |
2292528 | 2292528 | 2022-03-10 | Crawford | Michigan | 26039 | 2541 | 30 |
2288545 | 2288545 | 2022-03-09 | Turner | Georgia | 13287 | 2541 | 55 |
2289276 | 2289276 | 2022-03-09 | Crawford | Michigan | 26039 | 2541 | 30 |
2290990 | 2290990 | 2022-03-09 | Galax city | Virginia | 51640 | 2541 | 76 |
2285716 | 2285716 | 2022-03-08 | Marshall | Kansas | 20117 | 2541 | 41 |
2287738 | 2287738 | 2022-03-08 | Galax city | Virginia | 51640 | 2541 | 76 |
2282464 | 2282464 | 2022-03-07 | Marshall | Kansas | 20117 | 2541 | 41 |
2270533 | 2270533 | 2022-03-03 | Mercer | North Dakota | 38057 | 2541 | 24 |
2266006 | 2266006 | 2022-03-02 | Newton | Indiana | 18111 | 2541 | 68 |
2218455 | 2218455 | 2022-02-15 | Pamlico | North Carolina | 37137 | 2541 | 27 |
2219414 | 2219414 | 2022-02-15 | Amelia | Virginia | 51007 | 2541 | 52 |
2180480 | 2180480 | 2022-02-03 | Richmond | Virginia | 51159 | 2541 | 18 |
2174709 | 2174709 | 2022-02-02 | Screven | Georgia | 13251 | 2541 | 62 |
2151625 | 2151625 | 2022-01-26 | Mariposa | California | 6043 | 2541 | 19 |
2143315 | 2143315 | 2022-01-23 | Roosevelt | Montana | 30085 | 2541 | 70 |
2140060 | 2140060 | 2022-01-22 | Roosevelt | Montana | 30085 | 2541 | 70 |
2136804 | 2136804 | 2022-01-21 | Roosevelt | Montana | 30085 | 2541 | 70 |
2131335 | 2131335 | 2022-01-19 | Eastland | Texas | 48133 | 2541 | 92 |
2104157 | 2104157 | 2022-01-11 | Dent | Missouri | 29065 | 2541 | 64 |
2053382 | 2053382 | 2021-12-26 | Leon | Texas | 48289 | 2541 | 74 |
2050132 | 2050132 | 2021-12-25 | Leon | Texas | 48289 | 2541 | 74 |
2046882 | 2046882 | 2021-12-24 | Leon | Texas | 48289 | 2541 | 74 |
2043632 | 2043632 | 2021-12-23 | Leon | Texas | 48289 | 2541 | 74 |
2040589 | 2040589 | 2021-12-22 | Giles | Virginia | 51071 | 2541 | 36 |
2030506 | 2030506 | 2021-12-19 | Bosque | Texas | 48035 | 2541 | 57 |
2016386 | 2016386 | 2021-12-15 | Dallas | Missouri | 29059 | 2541 | 57 |
2006181 | 2006181 | 2021-12-12 | Magoffin | Kentucky | 21153 | 2541 | 31 |
2002930 | 2002930 | 2021-12-11 | Magoffin | Kentucky | 21153 | 2541 | 31 |
1999680 | 1999680 | 2021-12-10 | Magoffin | Kentucky | 21153 | 2541 | 31 |
1977454 | 1977454 | 2021-12-03 | Ste. Genevieve | Missouri | 29186 | 2541 | 34 |
1974204 | 1974204 | 2021-12-02 | Ste. Genevieve | Missouri | 29186 | 2541 | 34 |
1952246 | 1952246 | 2021-11-25 | San Sebastian | Puerto Rico | 72131 | 2541 | |
1948995 | 1948995 | 2021-11-24 | San Sebastian | Puerto Rico | 72131 | 2541 | |
1943240 | 1943240 | 2021-11-22 | Taylor | West Virginia | 54091 | 2541 | 42 |
1929972 | 1929972 | 2021-11-18 | Zavala | Texas | 48507 | 2541 | 55 |
1926722 | 1926722 | 2021-11-17 | Zavala | Texas | 48507 | 2541 | 55 |
1926854 | 1926854 | 2021-11-17 | New Kent | Virginia | 51127 | 2541 | 26 |
1899094 | 1899094 | 2021-11-09 | Antrim | Michigan | 26009 | 2541 | 38 |
1901080 | 1901080 | 2021-11-09 | Goshen | Wyoming | 56015 | 2541 | 40 |
1851475 | 1851475 | 2021-10-25 | Isabela | Puerto Rico | 72071 | 2541 | |
1847471 | 1847471 | 2021-10-24 | Wright | Missouri | 29229 | 2541 | 49 |
1848225 | 1848225 | 2021-10-24 | Isabela | Puerto Rico | 72071 | 2541 | |
1844975 | 1844975 | 2021-10-23 | Isabela | Puerto Rico | 72071 | 2541 | |
1814932 | 1814932 | 2021-10-14 | Moniteau | Missouri | 29135 | 2541 | 38 |
1811684 | 1811684 | 2021-10-13 | Moniteau | Missouri | 29135 | 2541 | 38 |
1810097 | 1810097 | 2021-10-12 | Carbon | Wyoming | 56007 | 2541 | 36 |
1806392 | 1806392 | 2021-10-11 | Llano | Texas | 48299 | 2541 | 70 |
1801080 | 1801080 | 2021-10-10 | Carroll | Indiana | 18015 | 2541 | 34 |
1801926 | 1801926 | 2021-10-10 | Livingston | Missouri | 29117 | 2541 | 62 |
1797831 | 1797831 | 2021-10-09 | Carroll | Indiana | 18015 | 2541 | 34 |
1794582 | 1794582 | 2021-10-08 | Carroll | Indiana | 18015 | 2541 | 34 |
1766672 | 1766672 | 2021-09-29 | Rolette | North Dakota | 38079 | 2541 | 30 |
1762223 | 1762223 | 2021-09-28 | Jackson | Iowa | 19097 | 2541 | 44 |
1758975 | 1758975 | 2021-09-27 | Jackson | Iowa | 19097 | 2541 | 44 |
1755727 | 1755727 | 2021-09-26 | Jackson | Iowa | 19097 | 2541 | 44 |
1756666 | 1756666 | 2021-09-26 | Coos | New Hampshire | 33007 | 2541 | 47 |
1752479 | 1752479 | 2021-09-25 | Jackson | Iowa | 19097 | 2541 | 44 |
1753418 | 1753418 | 2021-09-25 | Coos | New Hampshire | 33007 | 2541 | 47 |
1749230 | 1749230 | 2021-09-24 | Jackson | Iowa | 19097 | 2541 | 44 |
1750170 | 1750170 | 2021-09-24 | Coos | New Hampshire | 33007 | 2541 | 47 |
1745980 | 1745980 | 2021-09-23 | Jackson | Iowa | 19097 | 2541 | 44 |
1742173 | 1742173 | 2021-09-22 | Montezuma | Colorado | 8083 | 2541 | 33 |
1742731 | 1742731 | 2021-09-22 | Jackson | Iowa | 19097 | 2541 | 44 |
1741196 | 1741196 | 2021-09-21 | Grundy | Tennessee | 47061 | 2541 | 36 |
1737217 | 1737217 | 2021-09-20 | Lincoln | New Mexico | 35027 | 2541 | 28 |
1737947 | 1737947 | 2021-09-20 | Grundy | Tennessee | 47061 | 2541 | 36 |
1724340 | 1724340 | 2021-09-16 | Hertford | North Carolina | 37091 | 2541 | 65 |
1713345 | 1713345 | 2021-09-13 | White | Illinois | 17193 | 2541 | 39 |
1697904 | 1697904 | 2021-09-08 | Andrew | Missouri | 29003 | 2541 | 23 |
1674770 | 1674770 | 2021-09-01 | Simpson | Kentucky | 21213 | 2541 | 45 |
1664483 | 1664483 | 2021-08-29 | Blaine | Idaho | 16013 | 2541 | 19 |
1661235 | 1661235 | 2021-08-28 | Blaine | Idaho | 16013 | 2541 | 19 |
1657987 | 1657987 | 2021-08-27 | Blaine | Idaho | 16013 | 2541 | 19 |
1644544 | 1644544 | 2021-08-23 | Ashley | Arkansas | 5003 | 2541 | 38 |
1625473 | 1625473 | 2021-08-17 | Union | Georgia | 13291 | 2541 | 84 |
1627343 | 1627343 | 2021-08-17 | Vega Alta | Puerto Rico | 72143 | 2541 |
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);