ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,137 rows where cases = 148 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 91
- Nebraska 89
- South Dakota 61
- Georgia 53
- Virginia 52
- Colorado 51
- Kentucky 44
- Minnesota 44
- Kansas 42
- Michigan 33
- Indiana 28
- Ohio 28
- North Dakota 27
- West Virginia 27
- Iowa 25
- Missouri 25
- New York 24
- Oklahoma 24
- Mississippi 23
- Puerto Rico 23
- Montana 22
- North Carolina 22
- New Mexico 20
- Illinois 19
- Tennessee 19
- Pennsylvania 18
- Wisconsin 18
- Arkansas 17
- Utah 17
- Louisiana 16
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442682 | 2442682 | 2022-04-25 | Logan | Nebraska | 31113 | 148 | 0 |
2439426 | 2439426 | 2022-04-24 | Logan | Nebraska | 31113 | 148 | 0 |
2436170 | 2436170 | 2022-04-23 | Logan | Nebraska | 31113 | 148 | 0 |
2432914 | 2432914 | 2022-04-22 | Logan | Nebraska | 31113 | 148 | 0 |
2429658 | 2429658 | 2022-04-21 | Logan | Nebraska | 31113 | 148 | 0 |
2426402 | 2426402 | 2022-04-20 | Logan | Nebraska | 31113 | 148 | 0 |
2423146 | 2423146 | 2022-04-19 | Logan | Nebraska | 31113 | 148 | 0 |
2419889 | 2419889 | 2022-04-18 | Logan | Nebraska | 31113 | 148 | 0 |
2416634 | 2416634 | 2022-04-17 | Logan | Nebraska | 31113 | 148 | 0 |
2413378 | 2413378 | 2022-04-16 | Logan | Nebraska | 31113 | 148 | 0 |
2410122 | 2410122 | 2022-04-15 | Logan | Nebraska | 31113 | 148 | 0 |
2406866 | 2406866 | 2022-04-14 | Logan | Nebraska | 31113 | 148 | 0 |
2403610 | 2403610 | 2022-04-13 | Logan | Nebraska | 31113 | 148 | 0 |
2400355 | 2400355 | 2022-04-12 | Logan | Nebraska | 31113 | 148 | 0 |
2397100 | 2397100 | 2022-04-11 | Logan | Nebraska | 31113 | 148 | 0 |
2393845 | 2393845 | 2022-04-10 | Logan | Nebraska | 31113 | 148 | 0 |
2390589 | 2390589 | 2022-04-09 | Logan | Nebraska | 31113 | 148 | 0 |
2387333 | 2387333 | 2022-04-08 | Logan | Nebraska | 31113 | 148 | 0 |
2384078 | 2384078 | 2022-04-07 | Logan | Nebraska | 31113 | 148 | 0 |
2380823 | 2380823 | 2022-04-06 | Logan | Nebraska | 31113 | 148 | 0 |
2377568 | 2377568 | 2022-04-05 | Logan | Nebraska | 31113 | 148 | 0 |
2374315 | 2374315 | 2022-04-04 | Logan | Nebraska | 31113 | 148 | 0 |
2371063 | 2371063 | 2022-04-03 | Logan | Nebraska | 31113 | 148 | 0 |
2367810 | 2367810 | 2022-04-02 | Logan | Nebraska | 31113 | 148 | 0 |
2364557 | 2364557 | 2022-04-01 | Logan | Nebraska | 31113 | 148 | 0 |
2361303 | 2361303 | 2022-03-31 | Logan | Nebraska | 31113 | 148 | 0 |
2358049 | 2358049 | 2022-03-30 | Logan | Nebraska | 31113 | 148 | 0 |
2354796 | 2354796 | 2022-03-29 | Logan | Nebraska | 31113 | 148 | 0 |
2351543 | 2351543 | 2022-03-28 | Logan | Nebraska | 31113 | 148 | 0 |
2348291 | 2348291 | 2022-03-27 | Logan | Nebraska | 31113 | 148 | 0 |
2345038 | 2345038 | 2022-03-26 | Logan | Nebraska | 31113 | 148 | 0 |
2341785 | 2341785 | 2022-03-25 | Logan | Nebraska | 31113 | 148 | 0 |
2338532 | 2338532 | 2022-03-24 | Logan | Nebraska | 31113 | 148 | 0 |
2335278 | 2335278 | 2022-03-23 | Logan | Nebraska | 31113 | 148 | 0 |
2332024 | 2332024 | 2022-03-22 | Logan | Nebraska | 31113 | 148 | 0 |
2328771 | 2328771 | 2022-03-21 | Logan | Nebraska | 31113 | 148 | 0 |
2325519 | 2325519 | 2022-03-20 | Logan | Nebraska | 31113 | 148 | 0 |
2322265 | 2322265 | 2022-03-19 | Logan | Nebraska | 31113 | 148 | 0 |
2319011 | 2319011 | 2022-03-18 | Logan | Nebraska | 31113 | 148 | 0 |
2315758 | 2315758 | 2022-03-17 | Logan | Nebraska | 31113 | 148 | 0 |
2312505 | 2312505 | 2022-03-16 | Logan | Nebraska | 31113 | 148 | 0 |
2309252 | 2309252 | 2022-03-15 | Logan | Nebraska | 31113 | 148 | 0 |
2306000 | 2306000 | 2022-03-14 | Logan | Nebraska | 31113 | 148 | 0 |
2302749 | 2302749 | 2022-03-13 | Logan | Nebraska | 31113 | 148 | 0 |
2299497 | 2299497 | 2022-03-12 | Logan | Nebraska | 31113 | 148 | 0 |
2296245 | 2296245 | 2022-03-11 | Logan | Nebraska | 31113 | 148 | 0 |
2292993 | 2292993 | 2022-03-10 | Logan | Nebraska | 31113 | 148 | 0 |
2289741 | 2289741 | 2022-03-09 | Logan | Nebraska | 31113 | 148 | 0 |
2285332 | 2285332 | 2022-03-08 | Camas | Idaho | 16025 | 148 | 2 |
2286489 | 2286489 | 2022-03-08 | Logan | Nebraska | 31113 | 148 | 0 |
2282080 | 2282080 | 2022-03-07 | Camas | Idaho | 16025 | 148 | 2 |
2283237 | 2283237 | 2022-03-07 | Logan | Nebraska | 31113 | 148 | 0 |
2279984 | 2279984 | 2022-03-06 | Logan | Nebraska | 31113 | 148 | 0 |
2276731 | 2276731 | 2022-03-05 | Logan | Nebraska | 31113 | 148 | 0 |
2273478 | 2273478 | 2022-03-04 | Logan | Nebraska | 31113 | 148 | 0 |
2270226 | 2270226 | 2022-03-03 | Logan | Nebraska | 31113 | 148 | 0 |
2266973 | 2266973 | 2022-03-02 | Logan | Nebraska | 31113 | 148 | 0 |
2263722 | 2263722 | 2022-03-01 | Logan | Nebraska | 31113 | 148 | 0 |
2260471 | 2260471 | 2022-02-28 | Logan | Nebraska | 31113 | 148 | 0 |
2196597 | 2196597 | 2022-02-08 | Daggett | Utah | 49009 | 148 | 0 |
2193343 | 2193343 | 2022-02-07 | Daggett | Utah | 49009 | 148 | 0 |
2099677 | 2099677 | 2022-01-10 | San Juan | Colorado | 8111 | 148 | 0 |
2096426 | 2096426 | 2022-01-09 | San Juan | Colorado | 8111 | 148 | 0 |
2093174 | 2093174 | 2022-01-08 | San Juan | Colorado | 8111 | 148 | 0 |
2089922 | 2089922 | 2022-01-07 | San Juan | Colorado | 8111 | 148 | 0 |
2024118 | 2024118 | 2021-12-17 | Kent | Texas | 48263 | 148 | 3 |
2020867 | 2020867 | 2021-12-16 | Kent | Texas | 48263 | 148 | 3 |
2017616 | 2017616 | 2021-12-15 | Kent | Texas | 48263 | 148 | 3 |
2014109 | 2014109 | 2021-12-14 | Jones | South Dakota | 46075 | 148 | 1 |
2014366 | 2014366 | 2021-12-14 | Kent | Texas | 48263 | 148 | 3 |
2010858 | 2010858 | 2021-12-13 | Jones | South Dakota | 46075 | 148 | 1 |
2007607 | 2007607 | 2021-12-12 | Jones | South Dakota | 46075 | 148 | 1 |
2004356 | 2004356 | 2021-12-11 | Jones | South Dakota | 46075 | 148 | 1 |
2001105 | 2001105 | 2021-12-10 | Jones | South Dakota | 46075 | 148 | 1 |
1997855 | 1997855 | 2021-12-09 | Jones | South Dakota | 46075 | 148 | 1 |
1994604 | 1994604 | 2021-12-08 | Jones | South Dakota | 46075 | 148 | 1 |
1989137 | 1989137 | 2021-12-07 | Mineral | Colorado | 8079 | 148 | 1 |
1991353 | 1991353 | 2021-12-07 | Jones | South Dakota | 46075 | 148 | 1 |
1985887 | 1985887 | 2021-12-06 | Mineral | Colorado | 8079 | 148 | 1 |
1988102 | 1988102 | 2021-12-06 | Jones | South Dakota | 46075 | 148 | 1 |
1982637 | 1982637 | 2021-12-05 | Mineral | Colorado | 8079 | 148 | 1 |
1979387 | 1979387 | 2021-12-04 | Mineral | Colorado | 8079 | 148 | 1 |
1976137 | 1976137 | 2021-12-03 | Mineral | Colorado | 8079 | 148 | 1 |
1972888 | 1972888 | 2021-12-02 | Mineral | Colorado | 8079 | 148 | 1 |
1969638 | 1969638 | 2021-12-01 | Mineral | Colorado | 8079 | 148 | 1 |
1966388 | 1966388 | 2021-11-30 | Mineral | Colorado | 8079 | 148 | 1 |
1963136 | 1963136 | 2021-11-29 | Mineral | Colorado | 8079 | 148 | 1 |
1959885 | 1959885 | 2021-11-28 | Mineral | Colorado | 8079 | 148 | 1 |
1956634 | 1956634 | 2021-11-27 | Mineral | Colorado | 8079 | 148 | 1 |
1953383 | 1953383 | 2021-11-26 | Mineral | Colorado | 8079 | 148 | 1 |
1950132 | 1950132 | 2021-11-25 | Mineral | Colorado | 8079 | 148 | 1 |
1946881 | 1946881 | 2021-11-24 | Mineral | Colorado | 8079 | 148 | 1 |
1943630 | 1943630 | 2021-11-23 | Mineral | Colorado | 8079 | 148 | 1 |
1940380 | 1940380 | 2021-11-22 | Mineral | Colorado | 8079 | 148 | 1 |
1937130 | 1937130 | 2021-11-21 | Mineral | Colorado | 8079 | 148 | 1 |
1933880 | 1933880 | 2021-11-20 | Mineral | Colorado | 8079 | 148 | 1 |
1930628 | 1930628 | 2021-11-19 | Mineral | Colorado | 8079 | 148 | 1 |
1899477 | 1899477 | 2021-11-09 | Garfield | Montana | 30033 | 148 | 3 |
1858946 | 1858946 | 2021-10-28 | Wrangell City and Borough | Alaska | 2275 | 148 | 0 |
1855697 | 1855697 | 2021-10-27 | Wrangell City and Borough | Alaska | 2275 | 148 | 0 |
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);