ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,370 rows where cases = 112 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 118
- Texas 118
- Georgia 70
- Virginia 60
- Indiana 56
- Iowa 54
- Michigan 50
- Kentucky 43
- Kansas 40
- Missouri 38
- Illinois 37
- Minnesota 36
- Colorado 33
- North Carolina 31
- Puerto Rico 31
- Arkansas 30
- Oklahoma 30
- Washington 30
- West Virginia 29
- Mississippi 28
- South Dakota 28
- Montana 26
- New York 26
- North Dakota 24
- Ohio 24
- Louisiana 23
- Tennessee 23
- Idaho 22
- Oregon 22
- Pennsylvania 21
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452436 | 2452436 | 2022-04-28 | Hayes | Nebraska | 31085 | 112 | 0 |
2449180 | 2449180 | 2022-04-27 | Hayes | Nebraska | 31085 | 112 | 0 |
2445923 | 2445923 | 2022-04-26 | Hayes | Nebraska | 31085 | 112 | 0 |
2442668 | 2442668 | 2022-04-25 | Hayes | Nebraska | 31085 | 112 | 0 |
2419878 | 2419878 | 2022-04-18 | Hooker | Nebraska | 31091 | 112 | 5 |
2416623 | 2416623 | 2022-04-17 | Hooker | Nebraska | 31091 | 112 | 5 |
2413367 | 2413367 | 2022-04-16 | Hooker | Nebraska | 31091 | 112 | 5 |
2410111 | 2410111 | 2022-04-15 | Hooker | Nebraska | 31091 | 112 | 5 |
2406855 | 2406855 | 2022-04-14 | Hooker | Nebraska | 31091 | 112 | 5 |
2403599 | 2403599 | 2022-04-13 | Hooker | Nebraska | 31091 | 112 | 5 |
2400344 | 2400344 | 2022-04-12 | Hooker | Nebraska | 31091 | 112 | 5 |
2397089 | 2397089 | 2022-04-11 | Hooker | Nebraska | 31091 | 112 | 5 |
2393834 | 2393834 | 2022-04-10 | Hooker | Nebraska | 31091 | 112 | 5 |
2390578 | 2390578 | 2022-04-09 | Hooker | Nebraska | 31091 | 112 | 5 |
2387322 | 2387322 | 2022-04-08 | Hooker | Nebraska | 31091 | 112 | 5 |
2384067 | 2384067 | 2022-04-07 | Hooker | Nebraska | 31091 | 112 | 5 |
2380812 | 2380812 | 2022-04-06 | Hooker | Nebraska | 31091 | 112 | 5 |
2377557 | 2377557 | 2022-04-05 | Hooker | Nebraska | 31091 | 112 | 5 |
2374304 | 2374304 | 2022-04-04 | Hooker | Nebraska | 31091 | 112 | 5 |
2371052 | 2371052 | 2022-04-03 | Hooker | Nebraska | 31091 | 112 | 5 |
2367799 | 2367799 | 2022-04-02 | Hooker | Nebraska | 31091 | 112 | 5 |
2364546 | 2364546 | 2022-04-01 | Hooker | Nebraska | 31091 | 112 | 5 |
2361292 | 2361292 | 2022-03-31 | Hooker | Nebraska | 31091 | 112 | 5 |
2358038 | 2358038 | 2022-03-30 | Hooker | Nebraska | 31091 | 112 | 5 |
2354785 | 2354785 | 2022-03-29 | Hooker | Nebraska | 31091 | 112 | 5 |
2351532 | 2351532 | 2022-03-28 | Hooker | Nebraska | 31091 | 112 | 5 |
2348280 | 2348280 | 2022-03-27 | Hooker | Nebraska | 31091 | 112 | 5 |
2345027 | 2345027 | 2022-03-26 | Hooker | Nebraska | 31091 | 112 | 5 |
2341774 | 2341774 | 2022-03-25 | Hooker | Nebraska | 31091 | 112 | 5 |
2338521 | 2338521 | 2022-03-24 | Hooker | Nebraska | 31091 | 112 | 5 |
2335267 | 2335267 | 2022-03-23 | Hooker | Nebraska | 31091 | 112 | 5 |
2332013 | 2332013 | 2022-03-22 | Hooker | Nebraska | 31091 | 112 | 5 |
2328760 | 2328760 | 2022-03-21 | Hooker | Nebraska | 31091 | 112 | 5 |
2325508 | 2325508 | 2022-03-20 | Hooker | Nebraska | 31091 | 112 | 5 |
2322254 | 2322254 | 2022-03-19 | Hooker | Nebraska | 31091 | 112 | 5 |
2319000 | 2319000 | 2022-03-18 | Hooker | Nebraska | 31091 | 112 | 5 |
2315747 | 2315747 | 2022-03-17 | Hooker | Nebraska | 31091 | 112 | 5 |
2312494 | 2312494 | 2022-03-16 | Hooker | Nebraska | 31091 | 112 | 5 |
2309241 | 2309241 | 2022-03-15 | Hooker | Nebraska | 31091 | 112 | 5 |
2305989 | 2305989 | 2022-03-14 | Hooker | Nebraska | 31091 | 112 | 5 |
2302738 | 2302738 | 2022-03-13 | Hooker | Nebraska | 31091 | 112 | 5 |
2299486 | 2299486 | 2022-03-12 | Hooker | Nebraska | 31091 | 112 | 5 |
2296234 | 2296234 | 2022-03-11 | Hooker | Nebraska | 31091 | 112 | 5 |
2292982 | 2292982 | 2022-03-10 | Hooker | Nebraska | 31091 | 112 | 5 |
2289730 | 2289730 | 2022-03-09 | Hooker | Nebraska | 31091 | 112 | 5 |
2286478 | 2286478 | 2022-03-08 | Hooker | Nebraska | 31091 | 112 | 5 |
2193797 | 2193797 | 2022-02-08 | Skagway Municipality | Alaska | 2230 | 112 | 0 |
2190544 | 2190544 | 2022-02-07 | Skagway Municipality | Alaska | 2230 | 112 | 0 |
2175917 | 2175917 | 2022-02-02 | Keya Paha | Nebraska | 31103 | 112 | 0 |
2122706 | 2122706 | 2022-01-17 | Camas | Idaho | 16025 | 112 | 1 |
2119454 | 2119454 | 2022-01-16 | Camas | Idaho | 16025 | 112 | 1 |
2116202 | 2116202 | 2022-01-15 | Camas | Idaho | 16025 | 112 | 1 |
2112951 | 2112951 | 2022-01-14 | Camas | Idaho | 16025 | 112 | 1 |
2109699 | 2109699 | 2022-01-13 | Camas | Idaho | 16025 | 112 | 1 |
2106448 | 2106448 | 2022-01-12 | Camas | Idaho | 16025 | 112 | 1 |
2103197 | 2103197 | 2022-01-11 | Camas | Idaho | 16025 | 112 | 1 |
2099946 | 2099946 | 2022-01-10 | Camas | Idaho | 16025 | 112 | 1 |
2079461 | 2079461 | 2022-01-03 | Terrell | Texas | 48443 | 112 | 3 |
2041051 | 2041051 | 2021-12-23 | Alpine | California | 6003 | 112 | 0 |
2037801 | 2037801 | 2021-12-22 | Alpine | California | 6003 | 112 | 0 |
2034551 | 2034551 | 2021-12-21 | Alpine | California | 6003 | 112 | 0 |
2031301 | 2031301 | 2021-12-20 | Alpine | California | 6003 | 112 | 0 |
2014431 | 2014431 | 2021-12-14 | Roberts | Texas | 48393 | 112 | 1 |
1994988 | 1994988 | 2021-12-08 | Daggett | Utah | 49009 | 112 | 0 |
1991737 | 1991737 | 2021-12-07 | Daggett | Utah | 49009 | 112 | 0 |
1987329 | 1987329 | 2021-12-06 | Logan | Nebraska | 31113 | 112 | 0 |
1988486 | 1988486 | 2021-12-06 | Daggett | Utah | 49009 | 112 | 0 |
1985236 | 1985236 | 2021-12-05 | Daggett | Utah | 49009 | 112 | 0 |
1981986 | 1981986 | 2021-12-04 | Daggett | Utah | 49009 | 112 | 0 |
1978736 | 1978736 | 2021-12-03 | Daggett | Utah | 49009 | 112 | 0 |
1975486 | 1975486 | 2021-12-02 | Daggett | Utah | 49009 | 112 | 0 |
1929357 | 1929357 | 2021-11-18 | Wheeler | Oregon | 41069 | 112 | 1 |
1926107 | 1926107 | 2021-11-17 | Wheeler | Oregon | 41069 | 112 | 1 |
1848120 | 1848120 | 2021-10-24 | Wheeler | Oregon | 41069 | 112 | 1 |
1844870 | 1844870 | 2021-10-23 | Wheeler | Oregon | 41069 | 112 | 1 |
1841620 | 1841620 | 2021-10-22 | Wheeler | Oregon | 41069 | 112 | 1 |
1838371 | 1838371 | 2021-10-21 | Wheeler | Oregon | 41069 | 112 | 1 |
1835122 | 1835122 | 2021-10-20 | Wheeler | Oregon | 41069 | 112 | 1 |
1831873 | 1831873 | 2021-10-19 | Wheeler | Oregon | 41069 | 112 | 1 |
1773912 | 1773912 | 2021-10-01 | McMullen | Texas | 48311 | 112 | 7 |
1770662 | 1770662 | 2021-09-30 | McMullen | Texas | 48311 | 112 | 7 |
1712922 | 1712922 | 2021-09-13 | Kiowa | Colorado | 8061 | 112 | 3 |
1672907 | 1672907 | 2021-08-31 | Harding | South Dakota | 46063 | 112 | 1 |
1644507 | 1644507 | 2021-08-23 | Haines Borough | Alaska | 2100 | 112 | 0 |
1627649 | 1627649 | 2021-08-17 | Glasscock | Texas | 48173 | 112 | 2 |
1627694 | 1627694 | 2021-08-17 | Kent | Texas | 48263 | 112 | 2 |
1624447 | 1624447 | 2021-08-16 | Kent | Texas | 48263 | 112 | 2 |
1621200 | 1621200 | 2021-08-15 | Kent | Texas | 48263 | 112 | 2 |
1617952 | 1617952 | 2021-08-14 | Kent | Texas | 48263 | 112 | 2 |
1614704 | 1614704 | 2021-08-13 | Kent | Texas | 48263 | 112 | 2 |
1609631 | 1609631 | 2021-08-12 | Greeley | Kansas | 20071 | 112 | 1 |
1611455 | 1611455 | 2021-08-12 | Kent | Texas | 48263 | 112 | 2 |
1606382 | 1606382 | 2021-08-11 | Greeley | Kansas | 20071 | 112 | 1 |
1608207 | 1608207 | 2021-08-11 | Kent | Texas | 48263 | 112 | 2 |
1604958 | 1604958 | 2021-08-10 | Kent | Texas | 48263 | 112 | 2 |
1575948 | 1575948 | 2021-08-01 | Highland | Virginia | 51091 | 112 | 1 |
1572700 | 1572700 | 2021-07-31 | Highland | Virginia | 51091 | 112 | 1 |
1569452 | 1569452 | 2021-07-30 | Highland | Virginia | 51091 | 112 | 1 |
1566204 | 1566204 | 2021-07-29 | Highland | Virginia | 51091 | 112 | 1 |
1562956 | 1562956 | 2021-07-28 | Highland | Virginia | 51091 | 112 | 1 |
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);