ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 8318 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Mississippi 12
- Ohio 8
- Oklahoma 7
- Texas 7
- Georgia 5
- Indiana 5
- Wisconsin 4
- Tennessee 3
- Utah 3
- Virginia 3
- Illinois 2
- Alabama 1
- California 1
- Kentucky 1
- Maine 1
- Michigan 1
- Minnesota 1
- New Mexico 1
- North Carolina 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484746 | 2484746 | 2022-05-08 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2481488 | 2481488 | 2022-05-07 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2478230 | 2478230 | 2022-05-06 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2474972 | 2474972 | 2022-05-05 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2471715 | 2471715 | 2022-05-04 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2468459 | 2468459 | 2022-05-03 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2465204 | 2465204 | 2022-05-02 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2449596 | 2449596 | 2022-04-27 | Perry | Ohio | 39127 | 8318 | 125 |
2446339 | 2446339 | 2022-04-26 | Perry | Ohio | 39127 | 8318 | 125 |
2443084 | 2443084 | 2022-04-25 | Perry | Ohio | 39127 | 8318 | 125 |
2439828 | 2439828 | 2022-04-24 | Perry | Ohio | 39127 | 8318 | 125 |
2436572 | 2436572 | 2022-04-23 | Perry | Ohio | 39127 | 8318 | 125 |
2433316 | 2433316 | 2022-04-22 | Perry | Ohio | 39127 | 8318 | 125 |
2430060 | 2430060 | 2022-04-21 | Perry | Ohio | 39127 | 8318 | 125 |
2427316 | 2427316 | 2022-04-20 | Bee | Texas | 48025 | 8318 | 153 |
2314637 | 2314637 | 2022-03-17 | Bureau | Illinois | 17011 | 8318 | 140 |
2271716 | 2271716 | 2022-03-03 | Trempealeau | Wisconsin | 55121 | 8318 | 60 |
2203087 | 2203087 | 2022-02-10 | Wharton | Texas | 48481 | 8318 | 200 |
2200092 | 2200092 | 2022-02-09 | Marshall | West Virginia | 54051 | 8318 | 144 |
2159112 | 2159112 | 2022-01-28 | Aroostook | Maine | 23003 | 8318 | 112 |
2128252 | 2128252 | 2022-01-18 | Waller | Texas | 48473 | 8318 | 90 |
2104847 | 2104847 | 2022-01-11 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2101596 | 2101596 | 2022-01-10 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2098345 | 2098345 | 2022-01-09 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2095093 | 2095093 | 2022-01-08 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2091841 | 2091841 | 2022-01-07 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2088589 | 2088589 | 2022-01-06 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2085338 | 2085338 | 2022-01-05 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2081304 | 2081304 | 2022-01-04 | Hancock | Mississippi | 28045 | 8318 | 134 |
2077024 | 2077024 | 2022-01-03 | Camden | Georgia | 13039 | 8318 | 99 |
2073773 | 2073773 | 2022-01-02 | Camden | Georgia | 13039 | 8318 | 99 |
2070522 | 2070522 | 2022-01-01 | Camden | Georgia | 13039 | 8318 | 99 |
2067271 | 2067271 | 2021-12-31 | Camden | Georgia | 13039 | 8318 | 99 |
2030415 | 2030415 | 2021-12-19 | Dyer | Tennessee | 47045 | 8318 | 157 |
2027164 | 2027164 | 2021-12-18 | Dyer | Tennessee | 47045 | 8318 | 157 |
2023913 | 2023913 | 2021-12-17 | Dyer | Tennessee | 47045 | 8318 | 157 |
2011555 | 2011555 | 2021-12-13 | Oconto | Wisconsin | 55083 | 8318 | 80 |
1969306 | 1969306 | 2021-11-30 | Polk | Wisconsin | 55095 | 8318 | 93 |
1904081 | 1904081 | 2021-11-10 | Harrisonburg city | Virginia | 51660 | 8318 | 108 |
1898600 | 1898600 | 2021-11-09 | Marshall | Indiana | 18099 | 8318 | 144 |
1859577 | 1859577 | 2021-10-28 | Dubois | Indiana | 18037 | 8318 | 135 |
1799415 | 1799415 | 2021-10-09 | Indiana | Pennsylvania | 42063 | 8318 | 209 |
1779076 | 1779076 | 2021-10-03 | Lafayette | Mississippi | 28071 | 8318 | 137 |
1775826 | 1775826 | 2021-10-02 | Lafayette | Mississippi | 28071 | 8318 | 137 |
1772576 | 1772576 | 2021-10-01 | Lafayette | Mississippi | 28071 | 8318 | 137 |
1764267 | 1764267 | 2021-09-28 | Iron | Utah | 49021 | 8318 | 49 |
1719355 | 1719355 | 2021-09-15 | Nevada | California | 6057 | 8318 | 85 |
1714889 | 1714889 | 2021-09-13 | Josephine | Oregon | 41033 | 8318 | 156 |
1629279 | 1629279 | 2021-08-18 | Oldham | Kentucky | 21185 | 8318 | 85 |
1618508 | 1618508 | 2021-08-15 | Walker | Alabama | 1127 | 8318 | 291 |
1584047 | 1584047 | 2021-08-04 | Clay | Minnesota | 27027 | 8318 | 92 |
1573667 | 1573667 | 2021-08-01 | Bartholomew | Indiana | 18005 | 8318 | 162 |
1570419 | 1570419 | 2021-07-31 | Bartholomew | Indiana | 18005 | 8318 | 162 |
1567171 | 1567171 | 2021-07-30 | Bartholomew | Indiana | 18005 | 8318 | 162 |
1494221 | 1494221 | 2021-07-07 | Greenwood | South Carolina | 45047 | 8318 | 174 |
1387705 | 1387705 | 2021-06-04 | Roanoke | Virginia | 51161 | 8318 | 145 |
1233533 | 1233533 | 2021-04-18 | Jones | Mississippi | 28067 | 8318 | 161 |
1223627 | 1223627 | 2021-04-15 | Lapeer | Michigan | 26087 | 8318 | 160 |
1173398 | 1173398 | 2021-03-30 | Portsmouth city | Virginia | 51740 | 8318 | 170 |
1117296 | 1117296 | 2021-03-13 | Muskingum | Ohio | 39119 | 8318 | 119 |
1013139 | 1013139 | 2021-02-09 | Lea | New Mexico | 35025 | 8318 | 129 |
981687 | 981687 | 2021-01-30 | Starr | Texas | 48427 | 8318 | 232 |
916662 | 916662 | 2021-01-10 | Guadalupe | Texas | 48187 | 8318 | 116 |
913417 | 913417 | 2021-01-09 | Guadalupe | Texas | 48187 | 8318 | 115 |
803526 | 803526 | 2020-12-06 | Eau Claire | Wisconsin | 55035 | 8318 | 70 |
757829 | 757829 | 2020-11-22 | Washington | Utah | 49053 | 8318 | 67 |
754582 | 754582 | 2020-11-21 | Washington | Utah | 49053 | 8318 | 67 |
677575 | 677575 | 2020-10-29 | Richmond | Georgia | 13245 | 8318 | 185 |
623842 | 623842 | 2020-10-12 | Durham | North Carolina | 37063 | 8318 | 98 |
521099 | 521099 | 2020-09-10 | Williamson | Texas | 48491 | 8318 | 133 |
228313 | 228313 | 2020-06-11 | DuPage | Illinois | 17043 | 8318 | 425 |
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);