ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,702 rows where county = "Carter" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Carter · 3,203 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179987 | 2179987 | 2022-02-03 | Carter | Tennessee | 47019 | 14517 | 292 |
2175218 | 2175218 | 2022-02-02 | Carter | Kentucky | 21043 | 7446 | 91 |
2175710 | 2175710 | 2022-02-02 | Carter | Missouri | 29035 | 1437 | 19 |
2175815 | 2175815 | 2022-02-02 | Carter | Montana | 30011 | 230 | 5 |
2176358 | 2176358 | 2022-02-02 | Carter | Oklahoma | 40019 | 13021 | 208 |
2176736 | 2176736 | 2022-02-02 | Carter | Tennessee | 47019 | 14517 | 292 |
2171965 | 2171965 | 2022-02-01 | Carter | Kentucky | 21043 | 7382 | 91 |
2172457 | 2172457 | 2022-02-01 | Carter | Missouri | 29035 | 1425 | 19 |
2172562 | 2172562 | 2022-02-01 | Carter | Montana | 30011 | 229 | 5 |
2173104 | 2173104 | 2022-02-01 | Carter | Oklahoma | 40019 | 12342 | 204 |
2173482 | 2173482 | 2022-02-01 | Carter | Tennessee | 47019 | 13618 | 283 |
2168712 | 2168712 | 2022-01-31 | Carter | Kentucky | 21043 | 7317 | 91 |
2169204 | 2169204 | 2022-01-31 | Carter | Missouri | 29035 | 1424 | 19 |
2169309 | 2169309 | 2022-01-31 | Carter | Montana | 30011 | 229 | 5 |
2169852 | 2169852 | 2022-01-31 | Carter | Oklahoma | 40019 | 12342 | 204 |
2170230 | 2170230 | 2022-01-31 | Carter | Tennessee | 47019 | 13618 | 283 |
2165457 | 2165457 | 2022-01-30 | Carter | Kentucky | 21043 | 7136 | 91 |
2165949 | 2165949 | 2022-01-30 | Carter | Missouri | 29035 | 1424 | 19 |
2166054 | 2166054 | 2022-01-30 | Carter | Montana | 30011 | 225 | 5 |
2166597 | 2166597 | 2022-01-30 | Carter | Oklahoma | 40019 | 12342 | 204 |
2166976 | 2166976 | 2022-01-30 | Carter | Tennessee | 47019 | 13618 | 283 |
2162202 | 2162202 | 2022-01-29 | Carter | Kentucky | 21043 | 7136 | 91 |
2162694 | 2162694 | 2022-01-29 | Carter | Missouri | 29035 | 1423 | 19 |
2162799 | 2162799 | 2022-01-29 | Carter | Montana | 30011 | 225 | 5 |
2163342 | 2163342 | 2022-01-29 | Carter | Oklahoma | 40019 | 12342 | 204 |
2163721 | 2163721 | 2022-01-29 | Carter | Tennessee | 47019 | 13618 | 283 |
2158947 | 2158947 | 2022-01-28 | Carter | Kentucky | 21043 | 7136 | 91 |
2159439 | 2159439 | 2022-01-28 | Carter | Missouri | 29035 | 1408 | 19 |
2159544 | 2159544 | 2022-01-28 | Carter | Montana | 30011 | 225 | 5 |
2160087 | 2160087 | 2022-01-28 | Carter | Oklahoma | 40019 | 12342 | 204 |
2160466 | 2160466 | 2022-01-28 | Carter | Tennessee | 47019 | 13618 | 283 |
2155693 | 2155693 | 2022-01-27 | Carter | Kentucky | 21043 | 7026 | 91 |
2156185 | 2156185 | 2022-01-27 | Carter | Missouri | 29035 | 1401 | 19 |
2156290 | 2156290 | 2022-01-27 | Carter | Montana | 30011 | 225 | 5 |
2156832 | 2156832 | 2022-01-27 | Carter | Oklahoma | 40019 | 12342 | 204 |
2157210 | 2157210 | 2022-01-27 | Carter | Tennessee | 47019 | 13618 | 283 |
2152440 | 2152440 | 2022-01-26 | Carter | Kentucky | 21043 | 6939 | 91 |
2152932 | 2152932 | 2022-01-26 | Carter | Missouri | 29035 | 1389 | 19 |
2153037 | 2153037 | 2022-01-26 | Carter | Montana | 30011 | 225 | 5 |
2153579 | 2153579 | 2022-01-26 | Carter | Oklahoma | 40019 | 12342 | 204 |
2153957 | 2153957 | 2022-01-26 | Carter | Tennessee | 47019 | 13618 | 283 |
2149188 | 2149188 | 2022-01-25 | Carter | Kentucky | 21043 | 6816 | 89 |
2149680 | 2149680 | 2022-01-25 | Carter | Missouri | 29035 | 1352 | 19 |
2149785 | 2149785 | 2022-01-25 | Carter | Montana | 30011 | 225 | 5 |
2150327 | 2150327 | 2022-01-25 | Carter | Oklahoma | 40019 | 11162 | 203 |
2150705 | 2150705 | 2022-01-25 | Carter | Tennessee | 47019 | 12827 | 279 |
2145936 | 2145936 | 2022-01-24 | Carter | Kentucky | 21043 | 6744 | 89 |
2146428 | 2146428 | 2022-01-24 | Carter | Missouri | 29035 | 1336 | 19 |
2146533 | 2146533 | 2022-01-24 | Carter | Montana | 30011 | 219 | 5 |
2147075 | 2147075 | 2022-01-24 | Carter | Oklahoma | 40019 | 11162 | 203 |
2147453 | 2147453 | 2022-01-24 | Carter | Tennessee | 47019 | 12827 | 279 |
2142681 | 2142681 | 2022-01-23 | Carter | Kentucky | 21043 | 6535 | 87 |
2143173 | 2143173 | 2022-01-23 | Carter | Missouri | 29035 | 1330 | 19 |
2143278 | 2143278 | 2022-01-23 | Carter | Montana | 30011 | 219 | 5 |
2143821 | 2143821 | 2022-01-23 | Carter | Oklahoma | 40019 | 11162 | 203 |
2144199 | 2144199 | 2022-01-23 | Carter | Tennessee | 47019 | 12827 | 279 |
2139426 | 2139426 | 2022-01-22 | Carter | Kentucky | 21043 | 6535 | 87 |
2139918 | 2139918 | 2022-01-22 | Carter | Missouri | 29035 | 1323 | 19 |
2140023 | 2140023 | 2022-01-22 | Carter | Montana | 30011 | 219 | 5 |
2140566 | 2140566 | 2022-01-22 | Carter | Oklahoma | 40019 | 11162 | 203 |
2140944 | 2140944 | 2022-01-22 | Carter | Tennessee | 47019 | 12827 | 279 |
2136170 | 2136170 | 2022-01-21 | Carter | Kentucky | 21043 | 6535 | 87 |
2136662 | 2136662 | 2022-01-21 | Carter | Missouri | 29035 | 1305 | 19 |
2136767 | 2136767 | 2022-01-21 | Carter | Montana | 30011 | 219 | 5 |
2137310 | 2137310 | 2022-01-21 | Carter | Oklahoma | 40019 | 11162 | 203 |
2137688 | 2137688 | 2022-01-21 | Carter | Tennessee | 47019 | 12827 | 279 |
2132918 | 2132918 | 2022-01-20 | Carter | Kentucky | 21043 | 6421 | 87 |
2133410 | 2133410 | 2022-01-20 | Carter | Missouri | 29035 | 1295 | 19 |
2133515 | 2133515 | 2022-01-20 | Carter | Montana | 30011 | 219 | 5 |
2134056 | 2134056 | 2022-01-20 | Carter | Oklahoma | 40019 | 11162 | 203 |
2134434 | 2134434 | 2022-01-20 | Carter | Tennessee | 47019 | 12827 | 279 |
2129665 | 2129665 | 2022-01-19 | Carter | Kentucky | 21043 | 6331 | 87 |
2130157 | 2130157 | 2022-01-19 | Carter | Missouri | 29035 | 1286 | 19 |
2130262 | 2130262 | 2022-01-19 | Carter | Montana | 30011 | 218 | 5 |
2130804 | 2130804 | 2022-01-19 | Carter | Oklahoma | 40019 | 11162 | 203 |
2131182 | 2131182 | 2022-01-19 | Carter | Tennessee | 47019 | 12827 | 279 |
2126411 | 2126411 | 2022-01-18 | Carter | Kentucky | 21043 | 6272 | 87 |
2126903 | 2126903 | 2022-01-18 | Carter | Missouri | 29035 | 1264 | 19 |
2127008 | 2127008 | 2022-01-18 | Carter | Montana | 30011 | 218 | 5 |
2127550 | 2127550 | 2022-01-18 | Carter | Oklahoma | 40019 | 10350 | 202 |
2127928 | 2127928 | 2022-01-18 | Carter | Tennessee | 47019 | 12228 | 272 |
2123159 | 2123159 | 2022-01-17 | Carter | Kentucky | 21043 | 6083 | 86 |
2123651 | 2123651 | 2022-01-17 | Carter | Missouri | 29035 | 1247 | 19 |
2123756 | 2123756 | 2022-01-17 | Carter | Montana | 30011 | 218 | 5 |
2124298 | 2124298 | 2022-01-17 | Carter | Oklahoma | 40019 | 10350 | 202 |
2124676 | 2124676 | 2022-01-17 | Carter | Tennessee | 47019 | 12228 | 272 |
2119907 | 2119907 | 2022-01-16 | Carter | Kentucky | 21043 | 6083 | 86 |
2120399 | 2120399 | 2022-01-16 | Carter | Missouri | 29035 | 1247 | 19 |
2120504 | 2120504 | 2022-01-16 | Carter | Montana | 30011 | 218 | 5 |
2121046 | 2121046 | 2022-01-16 | Carter | Oklahoma | 40019 | 10350 | 202 |
2121424 | 2121424 | 2022-01-16 | Carter | Tennessee | 47019 | 12228 | 272 |
2116655 | 2116655 | 2022-01-15 | Carter | Kentucky | 21043 | 6083 | 86 |
2117147 | 2117147 | 2022-01-15 | Carter | Missouri | 29035 | 1247 | 19 |
2117252 | 2117252 | 2022-01-15 | Carter | Montana | 30011 | 218 | 5 |
2117794 | 2117794 | 2022-01-15 | Carter | Oklahoma | 40019 | 10350 | 202 |
2118172 | 2118172 | 2022-01-15 | Carter | Tennessee | 47019 | 12228 | 272 |
2113404 | 2113404 | 2022-01-14 | Carter | Kentucky | 21043 | 6083 | 86 |
2113896 | 2113896 | 2022-01-14 | Carter | Missouri | 29035 | 1233 | 19 |
2114001 | 2114001 | 2022-01-14 | Carter | Montana | 30011 | 218 | 5 |
2114543 | 2114543 | 2022-01-14 | Carter | Oklahoma | 40019 | 10350 | 202 |
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);