ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where cases = 4920 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Florida 8
- Iowa 8
- Indiana 6
- Kentucky 6
- Louisiana 6
- Georgia 5
- New York 5
- Virginia 5
- Washington 5
- Texas 4
- Alabama 3
- Arkansas 3
- California 3
- Ohio 3
- Wisconsin 3
- Missouri 2
- Puerto Rico 2
- Illinois 1
- Maryland 1
- Michigan 1
- Mississippi 1
- New Mexico 1
- North Carolina 1
- North Dakota 1
- Oklahoma 1
- South Dakota 1
- Tennessee 1
- Utah 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499725 | 2499725 | 2022-05-13 | Lincoln | Arkansas | 5079 | 4920 | 68 |
2486354 | 2486354 | 2022-05-08 | Adams | Washington | 53001 | 4920 | 38 |
2483096 | 2483096 | 2022-05-07 | Adams | Washington | 53001 | 4920 | 38 |
2479838 | 2479838 | 2022-05-06 | Adams | Washington | 53001 | 4920 | 38 |
2476580 | 2476580 | 2022-05-05 | Adams | Washington | 53001 | 4920 | 38 |
2473322 | 2473322 | 2022-05-04 | Adams | Washington | 53001 | 4920 | 38 |
2388400 | 2388400 | 2022-04-08 | Milam | Texas | 48331 | 4920 | 101 |
2385145 | 2385145 | 2022-04-07 | Milam | Texas | 48331 | 4920 | 101 |
2333950 | 2333950 | 2022-03-23 | Berrien | Georgia | 13019 | 4920 | 81 |
2330696 | 2330696 | 2022-03-22 | Berrien | Georgia | 13019 | 4920 | 81 |
2268526 | 2268526 | 2022-03-03 | Fayette | Alabama | 1057 | 4920 | 93 |
2187212 | 2187212 | 2022-02-06 | Cherokee | Alabama | 1019 | 4920 | 69 |
2183959 | 2183959 | 2022-02-05 | Cherokee | Alabama | 1019 | 4920 | 69 |
2172051 | 2172051 | 2022-02-01 | Spencer | Kentucky | 21215 | 4920 | 48 |
2173906 | 2173906 | 2022-02-01 | Dinwiddie | Virginia | 51053 | 4920 | 64 |
2111658 | 2111658 | 2022-01-13 | Yankton | South Dakota | 46135 | 4920 | 46 |
2099242 | 2099242 | 2022-01-09 | Jackson | West Virginia | 54035 | 4920 | 111 |
2074486 | 2074486 | 2022-01-02 | Allen | Louisiana | 22003 | 4920 | 119 |
2071235 | 2071235 | 2022-01-01 | Allen | Louisiana | 22003 | 4920 | 119 |
2067984 | 2067984 | 2021-12-31 | Allen | Louisiana | 22003 | 4920 | 119 |
2064733 | 2064733 | 2021-12-30 | Allen | Louisiana | 22003 | 4920 | 119 |
2035078 | 2035078 | 2021-12-21 | Clay | Indiana | 18021 | 4920 | 66 |
1996149 | 1996149 | 2021-12-09 | White | Indiana | 18181 | 4920 | 72 |
1992620 | 1992620 | 2021-12-08 | Stephens | Georgia | 13257 | 4920 | 121 |
1985222 | 1985222 | 2021-12-05 | Willacy | Texas | 48489 | 4920 | 114 |
1973626 | 1973626 | 2021-12-02 | Carter | Kentucky | 21043 | 4920 | 70 |
1966336 | 1966336 | 2021-11-30 | Siskiyou | California | 6093 | 4920 | 70 |
1966036 | 1966036 | 2021-11-29 | Juneau | Wisconsin | 55057 | 4920 | 39 |
1873751 | 1873751 | 2021-11-01 | Washington | New York | 36115 | 4920 | 69 |
1857682 | 1857682 | 2021-10-27 | Coshocton | Ohio | 39031 | 4920 | 85 |
1811726 | 1811726 | 2021-10-13 | Warren | Missouri | 29219 | 4920 | 44 |
1811974 | 1811974 | 2021-10-13 | Columbia | New York | 36021 | 4920 | 111 |
1784867 | 1784867 | 2021-10-05 | Jefferson | Indiana | 18077 | 4920 | 97 |
1748034 | 1748034 | 2021-09-23 | Sanpete | Utah | 49039 | 4920 | 30 |
1717766 | 1717766 | 2021-09-14 | Montgomery | New York | 36057 | 4920 | 133 |
1701741 | 1701741 | 2021-09-09 | Fulton | Ohio | 39051 | 4920 | 81 |
1689700 | 1689700 | 2021-09-05 | Shenandoah | Virginia | 51171 | 4920 | 137 |
1686450 | 1686450 | 2021-09-04 | Shenandoah | Virginia | 51171 | 4920 | 137 |
1683199 | 1683199 | 2021-09-03 | Shenandoah | Virginia | 51171 | 4920 | 137 |
1653792 | 1653792 | 2021-08-25 | Wharton | Texas | 48481 | 4920 | 126 |
1641940 | 1641940 | 2021-08-22 | Montgomery | Indiana | 18107 | 4920 | 96 |
1638690 | 1638690 | 2021-08-21 | Montgomery | Indiana | 18107 | 4920 | 96 |
1635440 | 1635440 | 2021-08-20 | Montgomery | Indiana | 18107 | 4920 | 96 |
1626094 | 1626094 | 2021-08-17 | Natchitoches | Louisiana | 22069 | 4920 | 103 |
1605564 | 1605564 | 2021-08-11 | Baxter | Arkansas | 5005 | 4920 | 130 |
1600808 | 1600808 | 2021-08-09 | Clinton | New York | 36019 | 4920 | 33 |
1557587 | 1557587 | 2021-07-27 | Muscatine | Iowa | 19139 | 4920 | 106 |
1554340 | 1554340 | 2021-07-26 | Muscatine | Iowa | 19139 | 4920 | 106 |
1551093 | 1551093 | 2021-07-25 | Muscatine | Iowa | 19139 | 4920 | 106 |
1547846 | 1547846 | 2021-07-24 | Muscatine | Iowa | 19139 | 4920 | 106 |
1544599 | 1544599 | 2021-07-23 | Muscatine | Iowa | 19139 | 4920 | 106 |
1541351 | 1541351 | 2021-07-22 | Muscatine | Iowa | 19139 | 4920 | 106 |
1538104 | 1538104 | 2021-07-21 | Muscatine | Iowa | 19139 | 4920 | 106 |
1529897 | 1529897 | 2021-07-18 | Toa Baja | Puerto Rico | 72137 | 4920 | |
1526650 | 1526650 | 2021-07-17 | Toa Baja | Puerto Rico | 72137 | 4920 | |
1472651 | 1472651 | 2021-07-01 | Hendry | Florida | 12051 | 4920 | 87 |
1469405 | 1469405 | 2021-06-30 | Hendry | Florida | 12051 | 4920 | 87 |
1466160 | 1466160 | 2021-06-29 | Hendry | Florida | 12051 | 4920 | 87 |
1462915 | 1462915 | 2021-06-28 | Hendry | Florida | 12051 | 4920 | 87 |
1459670 | 1459670 | 2021-06-27 | Hendry | Florida | 12051 | 4920 | 87 |
1456425 | 1456425 | 2021-06-26 | Hendry | Florida | 12051 | 4920 | 87 |
1453180 | 1453180 | 2021-06-25 | Hendry | Florida | 12051 | 4920 | 87 |
1372744 | 1372744 | 2021-05-31 | Henderson | Kentucky | 21101 | 4920 | 76 |
1369499 | 1369499 | 2021-05-30 | Henderson | Kentucky | 21101 | 4920 | 76 |
1366253 | 1366253 | 2021-05-29 | Henderson | Kentucky | 21101 | 4920 | 76 |
1313781 | 1313781 | 2021-05-13 | Tift | Georgia | 13277 | 4920 | 126 |
1316304 | 1316304 | 2021-05-13 | Washington | Virginia | 51191 | 4920 | 109 |
1297658 | 1297658 | 2021-05-08 | Henry | Illinois | 17073 | 4920 | 92 |
1261546 | 1261546 | 2021-04-27 | Tehama | California | 6103 | 4920 | 53 |
1264503 | 1264503 | 2021-04-27 | Oconto | Wisconsin | 55083 | 4920 | 59 |
1220604 | 1220604 | 2021-04-14 | Callaway | Missouri | 29027 | 4920 | 47 |
1136757 | 1136757 | 2021-03-19 | Jefferson | Ohio | 39081 | 4920 | 141 |
1122990 | 1122990 | 2021-03-15 | St. Joseph | Michigan | 26149 | 4920 | 87 |
1100813 | 1100813 | 2021-03-08 | Jefferson | New York | 36045 | 4920 | 63 |
1077114 | 1077114 | 2021-03-01 | Webster | Iowa | 19187 | 4920 | 87 |
1074796 | 1074796 | 2021-02-28 | Curry | New Mexico | 35009 | 4920 | 67 |
1049046 | 1049046 | 2021-02-20 | Morton | North Dakota | 38059 | 4920 | 94 |
1022258 | 1022258 | 2021-02-12 | Cecil | Maryland | 24015 | 4920 | 114 |
951819 | 951819 | 2021-01-21 | Grady | Oklahoma | 40051 | 4920 | 49 |
930081 | 930081 | 2021-01-14 | Barron | Wisconsin | 55005 | 4920 | 61 |
895619 | 895619 | 2021-01-04 | Iberia | Louisiana | 22045 | 4920 | 122 |
863470 | 863470 | 2020-12-25 | Jones | Mississippi | 28067 | 4920 | 95 |
837091 | 837091 | 2020-12-17 | Daviess | Kentucky | 21059 | 4920 | 74 |
760103 | 760103 | 2020-11-23 | Davidson | North Carolina | 37057 | 4920 | 49 |
755323 | 755323 | 2020-11-22 | Bartow | Georgia | 13015 | 4920 | 105 |
677239 | 677239 | 2020-10-29 | Sebastian | Arkansas | 5131 | 4920 | 94 |
679683 | 679683 | 2020-10-29 | Wilson | Tennessee | 47189 | 4920 | 63 |
648075 | 648075 | 2020-10-20 | Madera | California | 6039 | 4920 | 73 |
563891 | 563891 | 2020-09-24 | Clay | Florida | 12019 | 4920 | 96 |
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);