ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 8088 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Texas 5
- Virginia 5
- Georgia 4
- Illinois 3
- Indiana 3
- Missouri 3
- Michigan 2
- Ohio 2
- Pennsylvania 2
- Tennessee 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Maryland 1
- New Mexico 1
- North Carolina 1
- South Carolina 1
- Vermont 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2335873 | 2335873 | 2022-03-23 | Snyder | Pennsylvania | 42109 | 8088 | 155 |
2289623 | 2289623 | 2022-03-09 | Warren | Missouri | 29219 | 8088 | 101 |
2193381 | 2193381 | 2022-02-07 | Washington | Vermont | 50023 | 8088 | 44 |
2176628 | 2176628 | 2022-02-02 | Clarendon | South Carolina | 45027 | 8088 | 145 |
2138014 | 2138014 | 2022-01-21 | Washington | Texas | 48477 | 8088 | 135 |
2080345 | 2080345 | 2022-01-04 | Liberty | Georgia | 13179 | 8088 | 135 |
2064035 | 2064035 | 2021-12-30 | Colquitt | Georgia | 13071 | 8088 | 204 |
2018533 | 2018533 | 2021-12-16 | Coffee | Georgia | 13069 | 8088 | 244 |
1923148 | 1923148 | 2021-11-16 | Franklin | Tennessee | 47051 | 8088 | 102 |
1897455 | 1897455 | 2021-11-08 | Van Zandt | Texas | 48467 | 8088 | 216 |
1894205 | 1894205 | 2021-11-07 | Van Zandt | Texas | 48467 | 8088 | 216 |
1890955 | 1890955 | 2021-11-06 | Van Zandt | Texas | 48467 | 8088 | 216 |
1887705 | 1887705 | 2021-11-05 | Van Zandt | Texas | 48467 | 8088 | 216 |
1852128 | 1852128 | 2021-10-25 | Pittsylvania | Virginia | 51143 | 8088 | 112 |
1816349 | 1816349 | 2021-10-14 | Harrisonburg city | Virginia | 51660 | 8088 | 105 |
1806692 | 1806692 | 2021-10-11 | Grays Harbor | Washington | 53027 | 8088 | 117 |
1667058 | 1667058 | 2021-08-29 | Raleigh | West Virginia | 54081 | 8088 | 111 |
1649228 | 1649228 | 2021-08-24 | Joplin | Missouri | 8088 | 136 | |
1534503 | 1534503 | 2021-07-20 | Rockdale | Georgia | 13247 | 8088 | 180 |
1532826 | 1532826 | 2021-07-19 | Erie | Ohio | 39043 | 8088 | 166 |
1529579 | 1529579 | 2021-07-18 | Erie | Ohio | 39043 | 8088 | 166 |
1510333 | 1510333 | 2021-07-12 | Somerset | Pennsylvania | 42111 | 8088 | 218 |
1472411 | 1472411 | 2021-07-01 | Santa Cruz | Arizona | 4023 | 8088 | 180 |
1439576 | 1439576 | 2021-06-20 | Frederick | Virginia | 51069 | 8088 | 102 |
1428848 | 1428848 | 2021-06-17 | Rockingham | North Carolina | 37157 | 8088 | 143 |
1413607 | 1413607 | 2021-06-12 | Frederick | Virginia | 51069 | 8088 | 102 |
1400626 | 1400626 | 2021-06-08 | Frederick | Virginia | 51069 | 8088 | 102 |
1365370 | 1365370 | 2021-05-29 | Pope | Arkansas | 5115 | 8088 | 109 |
1356763 | 1356763 | 2021-05-26 | Montcalm | Michigan | 26117 | 8088 | 116 |
1304221 | 1304221 | 2021-05-10 | Bartholomew | Indiana | 18005 | 8088 | 160 |
1190459 | 1190459 | 2021-04-05 | Adams | Illinois | 17001 | 8088 | 144 |
1187212 | 1187212 | 2021-04-04 | Adams | Illinois | 17001 | 8088 | 144 |
1183965 | 1183965 | 2021-04-03 | Adams | Illinois | 17001 | 8088 | 144 |
1105403 | 1105403 | 2021-03-09 | St. Croix | Wisconsin | 55109 | 8088 | 48 |
1095010 | 1095010 | 2021-03-06 | Hamblen | Tennessee | 47063 | 8088 | 166 |
989803 | 989803 | 2021-02-02 | Charles | Maryland | 24017 | 8088 | 145 |
972400 | 972400 | 2021-01-28 | Lauderdale | Alabama | 1077 | 8088 | 127 |
969067 | 969067 | 2021-01-26 | Ozaukee | Wisconsin | 55089 | 8088 | 76 |
956881 | 956881 | 2021-01-23 | Kosciusko | Indiana | 18085 | 8088 | 86 |
957455 | 957455 | 2021-01-23 | St. Clair | Michigan | 26147 | 8088 | 224 |
941723 | 941723 | 2021-01-18 | Chaves | New Mexico | 35005 | 8088 | 120 |
925202 | 925202 | 2021-01-13 | Clay | Missouri | 29047 | 8088 | 118 |
804336 | 804336 | 2020-12-07 | Hendricks | Indiana | 18063 | 8088 | 186 |
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);