ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 7737 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Tennessee 8
- Oklahoma 7
- Texas 5
- Michigan 4
- Wisconsin 4
- Indiana 3
- Mississippi 3
- Oregon 3
- California 2
- Florida 2
- Pennsylvania 2
- Utah 2
- Arkansas 1
- Delaware 1
- Guam 1
- Illinois 1
- Louisiana 1
- Maine 1
- Maryland 1
- Missouri 1
- Ohio 1
- Virgin Islands 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401209 | 2401209 | 2022-04-12 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2397954 | 2397954 | 2022-04-11 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2394699 | 2394699 | 2022-04-10 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2391443 | 2391443 | 2022-04-09 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2388187 | 2388187 | 2022-04-08 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2384932 | 2384932 | 2022-04-07 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2381677 | 2381677 | 2022-04-06 | Lauderdale | Tennessee | 47097 | 7737 | 103 |
2378769 | 2378769 | 2022-04-05 | St. Croix | Virgin Islands | 78010 | 7737 | 47 |
2292820 | 2292820 | 2022-03-10 | Lawrence | Missouri | 29109 | 7737 | 157 |
2097615 | 2097615 | 2022-01-09 | Warren | Mississippi | 28149 | 7737 | 181 |
2094363 | 2094363 | 2022-01-08 | Warren | Mississippi | 28149 | 7737 | 181 |
2091111 | 2091111 | 2022-01-07 | Warren | Mississippi | 28149 | 7737 | 181 |
2062468 | 2062468 | 2021-12-29 | Logan | Ohio | 39091 | 7737 | 124 |
2013781 | 2013781 | 2021-12-14 | Delaware | Oklahoma | 40041 | 7737 | 166 |
2010530 | 2010530 | 2021-12-13 | Delaware | Oklahoma | 40041 | 7737 | 166 |
2007279 | 2007279 | 2021-12-12 | Delaware | Oklahoma | 40041 | 7737 | 166 |
2004028 | 2004028 | 2021-12-11 | Delaware | Oklahoma | 40041 | 7737 | 166 |
2000777 | 2000777 | 2021-12-10 | Delaware | Oklahoma | 40041 | 7737 | 166 |
1997527 | 1997527 | 2021-12-09 | Delaware | Oklahoma | 40041 | 7737 | 166 |
1994276 | 1994276 | 2021-12-08 | Delaware | Oklahoma | 40041 | 7737 | 166 |
1938101 | 1938101 | 2021-11-21 | Cass | Michigan | 26027 | 7737 | 97 |
1934851 | 1934851 | 2021-11-20 | Cass | Michigan | 26027 | 7737 | 97 |
1931601 | 1931601 | 2021-11-19 | Cass | Michigan | 26027 | 7737 | 97 |
1930285 | 1930285 | 2021-11-18 | Marinette | Wisconsin | 55075 | 7737 | 81 |
1921345 | 1921345 | 2021-11-16 | Lawrence | Indiana | 18093 | 7737 | 183 |
1893602 | 1893602 | 2021-11-07 | Polk | Oregon | 41053 | 7737 | 87 |
1890352 | 1890352 | 2021-11-06 | Polk | Oregon | 41053 | 7737 | 87 |
1887102 | 1887102 | 2021-11-05 | Polk | Oregon | 41053 | 7737 | 87 |
1725278 | 1725278 | 2021-09-16 | Iron | Utah | 49021 | 7737 | 41 |
1722029 | 1722029 | 2021-09-15 | Iron | Utah | 49021 | 7737 | 41 |
1718552 | 1718552 | 2021-09-14 | Chambers | Texas | 48071 | 7737 | 82 |
1715304 | 1715304 | 2021-09-13 | Chambers | Texas | 48071 | 7737 | 82 |
1712058 | 1712058 | 2021-09-12 | Chambers | Texas | 48071 | 7737 | 82 |
1708811 | 1708811 | 2021-09-11 | Chambers | Texas | 48071 | 7737 | 82 |
1705564 | 1705564 | 2021-09-10 | Chambers | Texas | 48071 | 7737 | 82 |
1625183 | 1625183 | 2021-08-17 | Yuba | California | 6115 | 7737 | 51 |
1540463 | 1540463 | 2021-07-21 | Wood | Wisconsin | 55141 | 7737 | 110 |
1534721 | 1534721 | 2021-07-20 | Grant | Indiana | 18053 | 7737 | 188 |
1537153 | 1537153 | 2021-07-20 | Chippewa | Wisconsin | 55017 | 7737 | 97 |
1533044 | 1533044 | 2021-07-19 | Lawrence | Pennsylvania | 42073 | 7737 | 216 |
1486514 | 1486514 | 2021-07-05 | Wicomico | Maryland | 24045 | 7737 | 174 |
1304701 | 1304701 | 2021-05-10 | Androscoggin | Maine | 23001 | 7737 | 72 |
1300172 | 1300172 | 2021-05-08 | Wood | West Virginia | 54107 | 7737 | 168 |
1262098 | 1262098 | 2021-04-27 | Warrick | Indiana | 18173 | 7737 | 158 |
1109018 | 1109018 | 2021-03-11 | Columbia | Florida | 12023 | 7737 | 160 |
1073146 | 1073146 | 2021-02-28 | Pope | Arkansas | 5115 | 7737 | 98 |
904563 | 904563 | 2021-01-07 | Indian River | Florida | 12061 | 7737 | 166 |
869672 | 869672 | 2020-12-27 | Rapides | Louisiana | 22079 | 7737 | 209 |
859432 | 859432 | 2020-12-24 | Macon | Illinois | 17115 | 7737 | 162 |
828597 | 828597 | 2020-12-14 | Centre | Pennsylvania | 42027 | 7737 | 106 |
771704 | 771704 | 2020-11-27 | Unknown | Guam | 7737 | 113 | |
762719 | 762719 | 2020-11-24 | Muskegon | Michigan | 26121 | 7737 | 166 |
748352 | 748352 | 2020-11-19 | Dodge | Wisconsin | 55027 | 7737 | 69 |
453916 | 453916 | 2020-08-21 | New Castle | Delaware | 10003 | 7737 | 297 |
258210 | 258210 | 2020-06-20 | Shelby | Tennessee | 47157 | 7737 | 163 |
200136 | 200136 | 2020-06-02 | San Diego | California | 6073 | 7737 | 312 |
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);