ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 9460 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Mississippi 8
- North Carolina 5
- Pennsylvania 3
- Tennessee 3
- Indiana 2
- Texas 2
- Alabama 1
- Idaho 1
- Illinois 1
- Iowa 1
- Michigan 1
- Minnesota 1
- Montana 1
- New Hampshire 1
- New York 1
- Ohio 1
- Virginia 1
- Washington 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370823 | 2370823 | 2022-04-03 | Union | Mississippi | 28145 | 9460 | 121 |
2367570 | 2367570 | 2022-04-02 | Union | Mississippi | 28145 | 9460 | 121 |
2364317 | 2364317 | 2022-04-01 | Union | Mississippi | 28145 | 9460 | 121 |
2361063 | 2361063 | 2022-03-31 | Union | Mississippi | 28145 | 9460 | 121 |
2356976 | 2356976 | 2022-03-30 | Logan | Illinois | 17107 | 9460 | 99 |
2357809 | 2357809 | 2022-03-30 | Union | Mississippi | 28145 | 9460 | 121 |
2354556 | 2354556 | 2022-03-29 | Union | Mississippi | 28145 | 9460 | 121 |
2351304 | 2351304 | 2022-03-28 | Union | Mississippi | 28145 | 9460 | 121 |
2174991 | 2174991 | 2022-02-02 | Whitley | Indiana | 18183 | 9460 | 77 |
2172800 | 2172800 | 2022-02-01 | Columbia | New York | 36021 | 9460 | 132 |
2104953 | 2104953 | 2022-01-11 | Venango | Pennsylvania | 42121 | 9460 | 207 |
2063536 | 2063536 | 2021-12-29 | Grant | Wisconsin | 55043 | 9460 | 127 |
2029839 | 2029839 | 2021-12-19 | Pender | North Carolina | 37141 | 9460 | 102 |
2026588 | 2026588 | 2021-12-18 | Pender | North Carolina | 37141 | 9460 | 102 |
2023337 | 2023337 | 2021-12-17 | Pender | North Carolina | 37141 | 9460 | 102 |
1986378 | 1986378 | 2021-12-06 | Shelby | Indiana | 18145 | 9460 | 142 |
1975219 | 1975219 | 2021-12-02 | Unknown | Tennessee | 9460 | 134 | |
1942625 | 1942625 | 2021-11-22 | Bedford | Tennessee | 47003 | 9460 | 158 |
1828939 | 1828939 | 2021-10-18 | Lawrence | Tennessee | 47099 | 9460 | 115 |
1825177 | 1825177 | 2021-10-17 | Ashtabula | Ohio | 39007 | 9460 | 197 |
1585717 | 1585717 | 2021-08-04 | Montgomery | Virginia | 51121 | 9460 | 81 |
1516420 | 1516420 | 2021-07-14 | Brunswick | North Carolina | 37019 | 9460 | 156 |
1447961 | 1447961 | 2021-06-23 | Cascade | Montana | 30013 | 9460 | 187 |
1351807 | 1351807 | 2021-05-24 | Starr | Texas | 48427 | 9460 | 298 |
1352205 | 1352205 | 2021-05-24 | Laramie | Wyoming | 56021 | 9460 | 114 |
1348561 | 1348561 | 2021-05-23 | Starr | Texas | 48427 | 9460 | 298 |
1323033 | 1323033 | 2021-05-16 | Lauderdale | Alabama | 1077 | 9460 | 243 |
1315040 | 1315040 | 2021-05-13 | Merrimack | New Hampshire | 33013 | 9460 | 114 |
1220382 | 1220382 | 2021-04-14 | Lenawee | Michigan | 26091 | 9460 | 144 |
1207438 | 1207438 | 2021-04-10 | Carver | Minnesota | 27019 | 9460 | 43 |
1199429 | 1199429 | 2021-04-07 | Grant | Washington | 53025 | 9460 | 114 |
1002448 | 1002448 | 2021-02-06 | Pottawattamie | Iowa | 19155 | 9460 | 134 |
993764 | 993764 | 2021-02-03 | Cleveland | North Carolina | 37045 | 9460 | 192 |
909729 | 909729 | 2021-01-08 | Cambria | Pennsylvania | 42021 | 9460 | 277 |
786458 | 786458 | 2020-12-01 | Westmoreland | Pennsylvania | 42129 | 9460 | 204 |
753117 | 753117 | 2020-11-21 | Hinds | Mississippi | 28049 | 9460 | 193 |
651682 | 651682 | 2020-10-21 | Canyon | Idaho | 16027 | 9460 | 108 |
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);