ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 8594 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Florida 8
- Kansas 5
- Minnesota 4
- Michigan 3
- Ohio 3
- Pennsylvania 3
- Washington 3
- Alabama 2
- Indiana 2
- South Carolina 2
- Tennessee 2
- West Virginia 2
- Wisconsin 2
- California 1
- Colorado 1
- Georgia 1
- Illinois 1
- Louisiana 1
- Maryland 1
- Missouri 1
- New York 1
- North Carolina 1
- North Dakota 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2354936 | 2354936 | 2022-03-29 | Greene | New York | 36039 | 8594 | 124 |
2292652 | 2292652 | 2022-03-10 | Polk | Minnesota | 27119 | 8594 | 103 |
2279554 | 2279554 | 2022-03-06 | Mecosta | Michigan | 26107 | 8594 | 105 |
2276301 | 2276301 | 2022-03-05 | Mecosta | Michigan | 26107 | 8594 | 105 |
2273048 | 2273048 | 2022-03-04 | Mecosta | Michigan | 26107 | 8594 | 105 |
2259972 | 2259972 | 2022-02-28 | Worcester | Maryland | 24047 | 8594 | 154 |
2247070 | 2247070 | 2022-02-24 | Becker | Minnesota | 27005 | 8594 | 88 |
2239112 | 2239112 | 2022-02-21 | Marshall | West Virginia | 54051 | 8594 | 148 |
2196011 | 2196011 | 2022-02-08 | Jefferson | Pennsylvania | 42065 | 8594 | 209 |
2168834 | 2168834 | 2022-01-31 | Iberville | Louisiana | 22047 | 8594 | 137 |
2167514 | 2167514 | 2022-01-30 | Island | Washington | 53029 | 8594 | 58 |
2164259 | 2164259 | 2022-01-29 | Island | Washington | 53029 | 8594 | 58 |
2161004 | 2161004 | 2022-01-28 | Island | Washington | 53029 | 8594 | 58 |
2148936 | 2148936 | 2022-01-25 | Putnam | Indiana | 18133 | 8594 | 104 |
2111459 | 2111459 | 2022-01-13 | Wayne | Pennsylvania | 42127 | 8594 | 145 |
2075398 | 2075398 | 2022-01-02 | Morton | North Dakota | 38059 | 8594 | 131 |
1878308 | 1878308 | 2021-11-02 | Sauk | Wisconsin | 55111 | 8594 | 70 |
1854974 | 1854974 | 2021-10-26 | Warren | Tennessee | 47177 | 8594 | 120 |
1836449 | 1836449 | 2021-10-21 | Gadsden | Florida | 12039 | 8594 | 116 |
1833200 | 1833200 | 2021-10-20 | Gadsden | Florida | 12039 | 8594 | 116 |
1829951 | 1829951 | 2021-10-19 | Gadsden | Florida | 12039 | 8594 | 116 |
1826702 | 1826702 | 2021-10-18 | Gadsden | Florida | 12039 | 8594 | 116 |
1823453 | 1823453 | 2021-10-17 | Gadsden | Florida | 12039 | 8594 | 115 |
1820204 | 1820204 | 2021-10-16 | Gadsden | Florida | 12039 | 8594 | 115 |
1816955 | 1816955 | 2021-10-15 | Gadsden | Florida | 12039 | 8594 | 115 |
1798668 | 1798668 | 2021-10-09 | Joplin | Missouri | 8594 | 149 | |
1685711 | 1685711 | 2021-09-04 | Lawrence | Pennsylvania | 42073 | 8594 | 231 |
1655515 | 1655515 | 2021-08-26 | Clay | Minnesota | 27027 | 8594 | 92 |
1460296 | 1460296 | 2021-06-27 | Reno | Kansas | 20155 | 8594 | 141 |
1457051 | 1457051 | 2021-06-26 | Reno | Kansas | 20155 | 8594 | 141 |
1453806 | 1453806 | 2021-06-25 | Reno | Kansas | 20155 | 8594 | 141 |
1455864 | 1455864 | 2021-06-25 | Roanoke city | Virginia | 51770 | 8594 | 197 |
1450560 | 1450560 | 2021-06-24 | Reno | Kansas | 20155 | 8594 | 140 |
1447315 | 1447315 | 2021-06-23 | Reno | Kansas | 20155 | 8594 | 140 |
1380321 | 1380321 | 2021-06-02 | Tuscarawas | Ohio | 39157 | 8594 | 247 |
1300617 | 1300617 | 2021-05-09 | Highlands | Florida | 12055 | 8594 | 357 |
1237478 | 1237478 | 2021-04-19 | Wayne | Ohio | 39169 | 8594 | 209 |
1228692 | 1228692 | 2021-04-16 | Cabell | West Virginia | 54011 | 8594 | 180 |
1219034 | 1219034 | 2021-04-13 | Manitowoc | Wisconsin | 55071 | 8594 | 87 |
1176482 | 1176482 | 2021-03-31 | Walker | Texas | 48471 | 8594 | 123 |
1104643 | 1104643 | 2021-03-09 | Oconee | South Carolina | 45073 | 8594 | 126 |
1083408 | 1083408 | 2021-03-03 | Vermilion | Illinois | 17183 | 8594 | 135 |
1083461 | 1083461 | 2021-03-03 | Kosciusko | Indiana | 18085 | 8594 | 115 |
1069771 | 1069771 | 2021-02-27 | Lauderdale | Alabama | 1077 | 8594 | 211 |
1068404 | 1068404 | 2021-02-26 | Caldwell | North Carolina | 37027 | 8594 | 67 |
1011550 | 1011550 | 2021-02-09 | Sutter | California | 6101 | 8594 | 92 |
849468 | 849468 | 2020-12-21 | Columbia | Georgia | 13073 | 8594 | 94 |
842559 | 842559 | 2020-12-19 | Calhoun | Alabama | 1015 | 8594 | 140 |
841388 | 841388 | 2020-12-18 | Fairfield | Ohio | 39045 | 8594 | 70 |
781185 | 781185 | 2020-11-30 | Pueblo | Colorado | 8101 | 8594 | 121 |
514322 | 514322 | 2020-09-08 | Hamilton | Tennessee | 47065 | 8594 | 79 |
461436 | 461436 | 2020-08-23 | Ramsey | Minnesota | 27123 | 8594 | 285 |
417317 | 417317 | 2020-08-09 | Horry | South Carolina | 45051 | 8594 | 153 |
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);