ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where cases = 2367 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 13
- Georgia 12
- Indiana 11
- Mississippi 10
- Ohio 10
- Texas 10
- Minnesota 8
- Missouri 8
- Virginia 8
- Louisiana 7
- Wisconsin 7
- Alabama 6
- Nebraska 6
- Vermont 6
- Arkansas 5
- Illinois 5
- Oregon 5
- Idaho 4
- Michigan 4
- Montana 4
- Pennsylvania 4
- South Carolina 4
- Tennessee 4
- Colorado 3
- Florida 3
- Kansas 3
- New York 3
- Puerto Rico 3
- Utah 3
- West Virginia 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465489 | 2465489 | 2022-05-02 | Red Willow | Nebraska | 31145 | 2367 | 20 |
2462234 | 2462234 | 2022-05-01 | Red Willow | Nebraska | 31145 | 2367 | 20 |
2458978 | 2458978 | 2022-04-30 | Red Willow | Nebraska | 31145 | 2367 | 20 |
2455722 | 2455722 | 2022-04-29 | Red Willow | Nebraska | 31145 | 2367 | 20 |
2356765 | 2356765 | 2022-03-30 | Evans | Georgia | 13109 | 2367 | 65 |
2353512 | 2353512 | 2022-03-29 | Evans | Georgia | 13109 | 2367 | 65 |
2350260 | 2350260 | 2022-03-28 | Evans | Georgia | 13109 | 2367 | 65 |
2330897 | 2330897 | 2022-03-22 | Washington | Idaho | 16087 | 2367 | 57 |
2302633 | 2302633 | 2022-03-13 | Wayne | Missouri | 29223 | 2367 | 47 |
2299381 | 2299381 | 2022-03-12 | Wayne | Missouri | 29223 | 2367 | 47 |
2296129 | 2296129 | 2022-03-11 | Wayne | Missouri | 29223 | 2367 | 47 |
2256486 | 2256486 | 2022-02-27 | Thomas | Kansas | 20193 | 2367 | 27 |
2253235 | 2253235 | 2022-02-26 | Thomas | Kansas | 20193 | 2367 | 27 |
2249984 | 2249984 | 2022-02-25 | Thomas | Kansas | 20193 | 2367 | 27 |
2246176 | 2246176 | 2022-02-24 | Dooly | Georgia | 13093 | 2367 | 66 |
2244026 | 2244026 | 2022-02-23 | Grundy | Missouri | 29079 | 2367 | 63 |
2239844 | 2239844 | 2022-02-22 | Brown | Illinois | 17009 | 2367 | 21 |
2188790 | 2188790 | 2022-02-06 | Ralls | Missouri | 29173 | 2367 | 19 |
2165921 | 2165921 | 2022-01-30 | Tunica | Mississippi | 28143 | 2367 | 41 |
2162666 | 2162666 | 2022-01-29 | Tunica | Mississippi | 28143 | 2367 | 41 |
2159411 | 2159411 | 2022-01-28 | Tunica | Mississippi | 28143 | 2367 | 41 |
2112021 | 2112021 | 2022-01-13 | Juab | Utah | 49023 | 2367 | 21 |
2108535 | 2108535 | 2022-01-12 | Camp | Texas | 48063 | 2367 | 69 |
2101033 | 2101033 | 2022-01-10 | Roosevelt | Montana | 30085 | 2367 | 70 |
2097782 | 2097782 | 2022-01-09 | Roosevelt | Montana | 30085 | 2367 | 70 |
2094530 | 2094530 | 2022-01-08 | Roosevelt | Montana | 30085 | 2367 | 70 |
2091278 | 2091278 | 2022-01-07 | Roosevelt | Montana | 30085 | 2367 | 70 |
2062618 | 2062618 | 2021-12-29 | Tillamook | Oregon | 41057 | 2367 | 48 |
2058208 | 2058208 | 2021-12-28 | Pendleton | Kentucky | 21191 | 2367 | 29 |
2038310 | 2038310 | 2021-12-22 | Washington | Illinois | 17189 | 2367 | 36 |
2018189 | 2018189 | 2021-12-16 | Kusilvak Census Area | Alaska | 2158 | 2367 | 9 |
2018379 | 2018379 | 2021-12-16 | Grand | Colorado | 8049 | 2367 | 18 |
2018511 | 2018511 | 2021-12-16 | Bleckley | Georgia | 13023 | 2367 | 84 |
2014939 | 2014939 | 2021-12-15 | Kusilvak Census Area | Alaska | 2158 | 2367 | 9 |
2015261 | 2015261 | 2021-12-15 | Bleckley | Georgia | 13023 | 2367 | 84 |
1982933 | 1982933 | 2021-12-05 | Gooding | Idaho | 16047 | 2367 | 42 |
1979683 | 1979683 | 2021-12-04 | Gooding | Idaho | 16047 | 2367 | 42 |
1973278 | 1973278 | 2021-12-02 | Piatt | Illinois | 17147 | 2367 | 20 |
1962512 | 1962512 | 2021-11-28 | Caledonia | Vermont | 50005 | 2367 | 21 |
1959261 | 1959261 | 2021-11-27 | Caledonia | Vermont | 50005 | 2367 | 21 |
1956010 | 1956010 | 2021-11-26 | Caledonia | Vermont | 50005 | 2367 | 21 |
1952759 | 1952759 | 2021-11-25 | Caledonia | Vermont | 50005 | 2367 | 21 |
1949508 | 1949508 | 2021-11-24 | Caledonia | Vermont | 50005 | 2367 | 21 |
1946533 | 1946533 | 2021-11-23 | Lafayette | Wisconsin | 55065 | 2367 | 12 |
1931878 | 1931878 | 2021-11-19 | Gasconade | Missouri | 29073 | 2367 | 77 |
1924930 | 1924930 | 2021-11-17 | Monroe | Kentucky | 21171 | 2367 | 62 |
1913223 | 1913223 | 2021-11-13 | Manati | Puerto Rico | 72091 | 2367 | |
1882362 | 1882362 | 2021-11-04 | Parke | Indiana | 18121 | 2367 | 30 |
1880380 | 1880380 | 2021-11-03 | McKenzie | North Dakota | 38053 | 2367 | 21 |
1875015 | 1875015 | 2021-11-01 | Crawford | Wisconsin | 55023 | 2367 | 22 |
1856623 | 1856623 | 2021-10-27 | Caldwell | Kentucky | 21033 | 2367 | 47 |
1850355 | 1850355 | 2021-10-25 | Antrim | Michigan | 26009 | 2367 | 38 |
1848799 | 1848799 | 2021-10-24 | Buchanan | Virginia | 51027 | 2367 | 59 |
1845549 | 1845549 | 2021-10-23 | Buchanan | Virginia | 51027 | 2367 | 59 |
1842299 | 1842299 | 2021-10-22 | Buchanan | Virginia | 51027 | 2367 | 59 |
1833922 | 1833922 | 2021-10-20 | Larue | Kentucky | 21123 | 2367 | 45 |
1814623 | 1814623 | 2021-10-14 | Charlevoix | Michigan | 26029 | 2367 | 31 |
1793883 | 1793883 | 2021-10-08 | Clay | Alabama | 1027 | 2367 | 67 |
1790522 | 1790522 | 2021-10-06 | Wetzel | West Virginia | 54103 | 2367 | 46 |
1765255 | 1765255 | 2021-09-29 | Ford | Illinois | 17053 | 2367 | 66 |
1758144 | 1758144 | 2021-09-27 | Cleburne | Alabama | 1029 | 2367 | 51 |
1755961 | 1755961 | 2021-09-26 | Mason | Kentucky | 21161 | 2367 | 51 |
1752713 | 1752713 | 2021-09-25 | Mason | Kentucky | 21161 | 2367 | 51 |
1749464 | 1749464 | 2021-09-24 | Mason | Kentucky | 21161 | 2367 | 51 |
1745155 | 1745155 | 2021-09-23 | Crenshaw | Alabama | 1041 | 2367 | 68 |
1745011 | 1745011 | 2021-09-22 | McDowell | West Virginia | 54047 | 2367 | 33 |
1735781 | 1735781 | 2021-09-20 | Bacon | Georgia | 13005 | 2367 | 50 |
1734399 | 1734399 | 2021-09-19 | Wasco | Oregon | 41065 | 2367 | 39 |
1731149 | 1731149 | 2021-09-18 | Wasco | Oregon | 41065 | 2367 | 39 |
1727899 | 1727899 | 2021-09-17 | Wasco | Oregon | 41065 | 2367 | 39 |
1717784 | 1717784 | 2021-09-14 | Seneca | New York | 36099 | 2367 | 58 |
1713358 | 1713358 | 2021-09-13 | Carroll | Indiana | 18015 | 2367 | 28 |
1710878 | 1710878 | 2021-09-12 | Smith | Mississippi | 28129 | 2367 | 46 |
1707631 | 1707631 | 2021-09-11 | Smith | Mississippi | 28129 | 2367 | 46 |
1709263 | 1709263 | 2021-09-11 | Hampshire | West Virginia | 54027 | 2367 | 37 |
1704384 | 1704384 | 2021-09-10 | Smith | Mississippi | 28129 | 2367 | 46 |
1650556 | 1650556 | 2021-08-24 | Young | Texas | 48503 | 2367 | 46 |
1628315 | 1628315 | 2021-08-18 | Cross | Arkansas | 5037 | 2367 | 55 |
1626055 | 1626055 | 2021-08-17 | Wayne | Kentucky | 21231 | 2367 | 51 |
1622808 | 1622808 | 2021-08-16 | Wayne | Kentucky | 21231 | 2367 | 51 |
1612085 | 1612085 | 2021-08-13 | Grant | Arkansas | 5053 | 2367 | 39 |
1613446 | 1613446 | 2021-08-13 | Andrew | Missouri | 29003 | 2367 | 22 |
1605121 | 1605121 | 2021-08-10 | Rutland | Vermont | 50021 | 2367 | 20 |
1579490 | 1579490 | 2021-08-03 | Hale | Alabama | 1065 | 2367 | 78 |
1577312 | 1577312 | 2021-08-02 | Rowan | Kentucky | 21205 | 2367 | 22 |
1579108 | 1579108 | 2021-08-02 | Sevier | Utah | 49041 | 2367 | 15 |
1574455 | 1574455 | 2021-08-01 | Winston | Mississippi | 28159 | 2367 | 84 |
1571207 | 1571207 | 2021-07-31 | Winston | Mississippi | 28159 | 2367 | 84 |
1567959 | 1567959 | 2021-07-30 | Winston | Mississippi | 28159 | 2367 | 84 |
1563943 | 1563943 | 2021-07-29 | Fountain | Indiana | 18045 | 2367 | 51 |
1561177 | 1561177 | 2021-07-28 | Caroline | Maryland | 24011 | 2367 | 30 |
1534734 | 1534734 | 2021-07-20 | Jennings | Indiana | 18079 | 2367 | 51 |
1511264 | 1511264 | 2021-07-13 | Barbour | Alabama | 1005 | 2367 | 60 |
1514265 | 1514265 | 2021-07-13 | Mecklenburg | Virginia | 51117 | 2367 | 68 |
1508017 | 1508017 | 2021-07-12 | Barbour | Alabama | 1005 | 2367 | 60 |
1466317 | 1466317 | 2021-06-29 | Pike | Georgia | 13231 | 2367 | 43 |
1463072 | 1463072 | 2021-06-28 | Pike | Georgia | 13231 | 2367 | 43 |
1435601 | 1435601 | 2021-06-19 | Jefferson | Oregon | 41031 | 2367 | 39 |
1391289 | 1391289 | 2021-06-06 | Columbia | Arkansas | 5027 | 2367 | 56 |
1353482 | 1353482 | 2021-05-25 | Emmet | Michigan | 26047 | 2367 | 42 |
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);