ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 7057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Mississippi 12
- Indiana 11
- Illinois 7
- Oklahoma 7
- Washington 6
- Alabama 5
- California 5
- Texas 5
- Minnesota 3
- Wisconsin 3
- Georgia 2
- Iowa 2
- Maryland 2
- Puerto Rico 2
- Tennessee 2
- Alaska 1
- Arkansas 1
- Florida 1
- Louisiana 1
- Michigan 1
- Missouri 1
- New Jersey 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461875 | 2461875 | 2022-05-01 | Pine | Minnesota | 27115 | 7057 | 67 |
2463364 | 2463364 | 2022-05-01 | Willacy | Texas | 48489 | 7057 | 130 |
2458619 | 2458619 | 2022-04-30 | Pine | Minnesota | 27115 | 7057 | 67 |
2455363 | 2455363 | 2022-04-29 | Pine | Minnesota | 27115 | 7057 | 67 |
2450659 | 2450659 | 2022-04-27 | Lincoln | Wisconsin | 55069 | 7057 | 148 |
2430184 | 2430184 | 2022-04-21 | Lincoln | Oregon | 41041 | 7057 | 86 |
2337525 | 2337525 | 2022-03-24 | Decatur | Indiana | 18031 | 7057 | 145 |
2334271 | 2334271 | 2022-03-23 | Decatur | Indiana | 18031 | 7057 | 145 |
2331017 | 2331017 | 2022-03-22 | Decatur | Indiana | 18031 | 7057 | 145 |
2327765 | 2327765 | 2022-03-21 | Decatur | Indiana | 18031 | 7057 | 145 |
2324512 | 2324512 | 2022-03-20 | Decatur | Indiana | 18031 | 7057 | 145 |
2325222 | 2325222 | 2022-03-20 | Covington | Mississippi | 28031 | 7057 | 110 |
2321258 | 2321258 | 2022-03-19 | Decatur | Indiana | 18031 | 7057 | 145 |
2321968 | 2321968 | 2022-03-19 | Covington | Mississippi | 28031 | 7057 | 110 |
2318004 | 2318004 | 2022-03-18 | Decatur | Indiana | 18031 | 7057 | 145 |
2318714 | 2318714 | 2022-03-18 | Covington | Mississippi | 28031 | 7057 | 110 |
2314751 | 2314751 | 2022-03-17 | Decatur | Indiana | 18031 | 7057 | 145 |
2315461 | 2315461 | 2022-03-17 | Covington | Mississippi | 28031 | 7057 | 110 |
2312208 | 2312208 | 2022-03-16 | Covington | Mississippi | 28031 | 7057 | 110 |
2313145 | 2313145 | 2022-03-16 | Gurabo | Puerto Rico | 72063 | 7057 | |
2308955 | 2308955 | 2022-03-15 | Covington | Mississippi | 28031 | 7057 | 110 |
2305704 | 2305704 | 2022-03-14 | Covington | Mississippi | 28031 | 7057 | 110 |
2288640 | 2288640 | 2022-03-09 | Fayette | Illinois | 17051 | 7057 | 101 |
2258256 | 2258256 | 2022-02-27 | Kleberg | Texas | 48273 | 7057 | 140 |
2237417 | 2237417 | 2022-02-21 | Copiah | Mississippi | 28029 | 7057 | 109 |
2234166 | 2234166 | 2022-02-20 | Copiah | Mississippi | 28029 | 7057 | 109 |
2230915 | 2230915 | 2022-02-19 | Copiah | Mississippi | 28029 | 7057 | 109 |
2227664 | 2227664 | 2022-02-18 | Copiah | Mississippi | 28029 | 7057 | 109 |
2177513 | 2177513 | 2022-02-03 | Winston | Alabama | 1133 | 7057 | 115 |
2174260 | 2174260 | 2022-02-02 | Winston | Alabama | 1133 | 7057 | 115 |
2167743 | 2167743 | 2022-01-31 | Pike | Alabama | 1109 | 7057 | 118 |
2111411 | 2111411 | 2022-01-13 | Clarion | Pennsylvania | 42031 | 7057 | 181 |
1988643 | 1988643 | 2021-12-06 | Shenandoah | Virginia | 51171 | 7057 | 177 |
1982555 | 1982555 | 2021-12-05 | Lake | California | 6033 | 7057 | 113 |
1979305 | 1979305 | 2021-12-04 | Lake | California | 6033 | 7057 | 113 |
1976055 | 1976055 | 2021-12-03 | Lake | California | 6033 | 7057 | 113 |
1972141 | 1972141 | 2021-12-01 | Medina | Texas | 48325 | 7057 | 170 |
1968316 | 1968316 | 2021-11-30 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1965065 | 1965065 | 2021-11-29 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1961813 | 1961813 | 2021-11-28 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1958562 | 1958562 | 2021-11-27 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1955311 | 1955311 | 2021-11-26 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1952060 | 1952060 | 2021-11-25 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1948809 | 1948809 | 2021-11-24 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1930399 | 1930399 | 2021-11-19 | Russell | Alabama | 1113 | 7057 | 65 |
1882256 | 1882256 | 2021-11-04 | Marion | Illinois | 17121 | 7057 | 154 |
1856757 | 1856757 | 2021-10-27 | Lincoln | Louisiana | 22061 | 7057 | 115 |
1855567 | 1855567 | 2021-10-26 | Shawano | Wisconsin | 55115 | 7057 | 91 |
1804266 | 1804266 | 2021-10-11 | Knox | Illinois | 17095 | 7057 | 200 |
1801017 | 1801017 | 2021-10-10 | Knox | Illinois | 17095 | 7057 | 200 |
1797768 | 1797768 | 2021-10-09 | Knox | Illinois | 17095 | 7057 | 200 |
1794519 | 1794519 | 2021-10-08 | Knox | Illinois | 17095 | 7057 | 200 |
1761857 | 1761857 | 2021-09-28 | Liberty | Georgia | 13179 | 7057 | 88 |
1667014 | 1667014 | 2021-08-29 | Walla Walla | Washington | 53071 | 7057 | 77 |
1663766 | 1663766 | 2021-08-28 | Walla Walla | Washington | 53071 | 7057 | 77 |
1660518 | 1660518 | 2021-08-27 | Walla Walla | Washington | 53071 | 7057 | 77 |
1653517 | 1653517 | 2021-08-25 | Monroe | Tennessee | 47123 | 7057 | 99 |
1650270 | 1650270 | 2021-08-24 | Monroe | Tennessee | 47123 | 7057 | 99 |
1631273 | 1631273 | 2021-08-18 | Skagit | Washington | 53057 | 7057 | 82 |
1563036 | 1563036 | 2021-07-28 | Cowlitz | Washington | 53015 | 7057 | 100 |
1473506 | 1473506 | 2021-07-01 | Allegany | Maryland | 24001 | 7057 | 212 |
1470260 | 1470260 | 2021-06-30 | Allegany | Maryland | 24001 | 7057 | 212 |
1426758 | 1426758 | 2021-06-16 | Raleigh | West Virginia | 54081 | 7057 | 94 |
1199030 | 1199030 | 2021-04-07 | Coryell | Texas | 48099 | 7057 | 84 |
1180270 | 1180270 | 2021-04-02 | Lonoke | Arkansas | 5085 | 7057 | 116 |
1174353 | 1174353 | 2021-03-31 | Grant | Indiana | 18053 | 7057 | 173 |
1171829 | 1171829 | 2021-03-30 | Lauderdale | Mississippi | 28075 | 7057 | 234 |
1137858 | 1137858 | 2021-03-19 | Portage | Wisconsin | 55097 | 7057 | 69 |
1058547 | 1058547 | 2021-02-23 | Cape May | New Jersey | 34009 | 7057 | 180 |
1031510 | 1031510 | 2021-02-15 | Floyd | Indiana | 18043 | 7057 | 165 |
942032 | 942032 | 2021-01-18 | Pickaway | Ohio | 39129 | 7057 | 50 |
930255 | 930255 | 2021-01-15 | Matanuska-Susitna Borough | Alaska | 2170 | 7057 | 18 |
926027 | 926027 | 2021-01-13 | Carolina | Puerto Rico | 72031 | 7057 | |
849762 | 849762 | 2020-12-21 | Delaware | Indiana | 18035 | 7057 | 126 |
840606 | 840606 | 2020-12-18 | Monroe | Michigan | 26115 | 7057 | 123 |
840818 | 840818 | 2020-12-18 | Cape Girardeau | Missouri | 29031 | 7057 | 105 |
817402 | 817402 | 2020-12-11 | Dallas | Iowa | 19049 | 7057 | 60 |
816084 | 816084 | 2020-12-10 | Johnson | Texas | 48251 | 7057 | 124 |
804474 | 804474 | 2020-12-07 | Pottawattamie | Iowa | 19155 | 7057 | 82 |
739373 | 739373 | 2020-11-17 | Rock Island | Illinois | 17161 | 7057 | 117 |
716387 | 716387 | 2020-11-10 | Bibb | Georgia | 13021 | 7057 | 222 |
657810 | 657810 | 2020-10-23 | Marin | California | 6041 | 7057 | 128 |
582848 | 582848 | 2020-09-29 | Spokane | Washington | 53063 | 7057 | 172 |
524916 | 524916 | 2020-09-12 | Kings | California | 6031 | 7057 | 77 |
521524 | 521524 | 2020-09-11 | Madison | Alabama | 1089 | 7057 | 71 |
51418 | 51418 | 2020-04-12 | Miami-Dade | Florida | 12086 | 7057 | 97 |
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);