ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 10438 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Texas 5
- Minnesota 3
- California 2
- Florida 2
- Illinois 2
- Michigan 2
- Missouri 2
- Ohio 2
- Tennessee 2
- Alabama 1
- Montana 1
- New York 1
- North Carolina 1
- North Dakota 1
- Pennsylvania 1
- South Carolina 1
- South Dakota 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2439099 | 2439099 | 2022-04-24 | Steele | Minnesota | 27147 | 10438 | 62 |
2435843 | 2435843 | 2022-04-23 | Steele | Minnesota | 27147 | 10438 | 62 |
2432587 | 2432587 | 2022-04-22 | Steele | Minnesota | 27147 | 10438 | 62 |
2357001 | 2357001 | 2022-03-30 | Randolph | Illinois | 17157 | 10438 | 130 |
2150245 | 2150245 | 2022-01-25 | Crawford | Ohio | 39033 | 10438 | 179 |
1995552 | 1995552 | 2021-12-09 | Humboldt | California | 6023 | 10438 | 120 |
1897100 | 1897100 | 2021-11-08 | Lincoln | South Dakota | 46083 | 10438 | 78 |
1828905 | 1828905 | 2021-10-18 | Coffee | Tennessee | 47031 | 10438 | 151 |
1813232 | 1813232 | 2021-10-13 | Harrison | West Virginia | 54033 | 10438 | 130 |
1796151 | 1796151 | 2021-10-08 | Clearfield | Pennsylvania | 42033 | 10438 | 184 |
1782758 | 1782758 | 2021-10-04 | Oswego | New York | 36075 | 10438 | 107 |
1700941 | 1700941 | 2021-09-09 | Lapeer | Michigan | 26087 | 10438 | 225 |
1697692 | 1697692 | 2021-09-08 | Lapeer | Michigan | 26087 | 10438 | 225 |
1633052 | 1633052 | 2021-08-19 | Cascade | Montana | 30013 | 10438 | 194 |
1543776 | 1543776 | 2021-07-23 | Limestone | Alabama | 1083 | 10438 | 158 |
1496574 | 1496574 | 2021-07-08 | Jasper | Missouri | 29097 | 10438 | 136 |
1460842 | 1460842 | 2021-06-27 | Clay | Missouri | 29047 | 10438 | 172 |
1312465 | 1312465 | 2021-05-12 | Sumter | South Carolina | 45085 | 10438 | 205 |
1306296 | 1306296 | 2021-05-10 | Maverick | Texas | 48323 | 10438 | 356 |
1303050 | 1303050 | 2021-05-09 | Maverick | Texas | 48323 | 10438 | 356 |
1299803 | 1299803 | 2021-05-08 | Maverick | Texas | 48323 | 10438 | 356 |
1296556 | 1296556 | 2021-05-07 | Maverick | Texas | 48323 | 10438 | 356 |
1293310 | 1293310 | 2021-05-06 | Maverick | Texas | 48323 | 10438 | 356 |
1253589 | 1253589 | 2021-04-24 | Grand Forks | North Dakota | 38035 | 10438 | 77 |
1193439 | 1193439 | 2021-04-06 | Citrus | Florida | 12017 | 10438 | 435 |
1172958 | 1172958 | 2021-03-30 | Madison | Tennessee | 47113 | 10438 | 238 |
1024645 | 1024645 | 2021-02-13 | Indian River | Florida | 12061 | 10438 | 251 |
985575 | 985575 | 2021-02-01 | Shasta | California | 6089 | 10438 | 145 |
985991 | 985991 | 2021-02-01 | Kendall | Illinois | 17093 | 10438 | 85 |
643322 | 643322 | 2020-10-18 | Guilford | North Carolina | 37081 | 10438 | 193 |
346269 | 346269 | 2020-07-18 | Cuyahoga | Ohio | 39035 | 10438 | 414 |
268162 | 268162 | 2020-06-23 | Milwaukee | Wisconsin | 55079 | 10438 | 373 |
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);