ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
206 rows where cases = 2967 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 21
- Virginia 14
- Arkansas 13
- Mississippi 13
- North Carolina 11
- Florida 9
- Oregon 9
- Tennessee 9
- Georgia 8
- Michigan 7
- Missouri 7
- Texas 7
- Utah 7
- California 5
- Maine 5
- Alabama 4
- Illinois 4
- Indiana 4
- Kentucky 4
- Maryland 4
- Oklahoma 4
- Pennsylvania 4
- Washington 4
- Kansas 3
- Minnesota 3
- West Virginia 3
- Wisconsin 3
- Arizona 2
- Iowa 2
- Louisiana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462748 | 2462748 | 2022-05-01 | Morrow | Oregon | 41049 | 2967 | 34 |
2459492 | 2459492 | 2022-04-30 | Morrow | Oregon | 41049 | 2967 | 34 |
2456236 | 2456236 | 2022-04-29 | Morrow | Oregon | 41049 | 2967 | 34 |
2444226 | 2444226 | 2022-04-26 | Coosa | Alabama | 1037 | 2967 | 58 |
2427065 | 2427065 | 2022-04-20 | Orocovis | Puerto Rico | 72107 | 2967 | |
2373785 | 2373785 | 2022-04-04 | Piscataquis | Maine | 23021 | 2967 | 31 |
2370532 | 2370532 | 2022-04-03 | Piscataquis | Maine | 23021 | 2967 | 31 |
2367279 | 2367279 | 2022-04-02 | Piscataquis | Maine | 23021 | 2967 | 31 |
2364026 | 2364026 | 2022-04-01 | Piscataquis | Maine | 23021 | 2967 | 31 |
2332822 | 2332822 | 2022-03-22 | Todd | South Dakota | 46121 | 2967 | 51 |
2329569 | 2329569 | 2022-03-21 | Todd | South Dakota | 46121 | 2967 | 51 |
2326317 | 2326317 | 2022-03-20 | Todd | South Dakota | 46121 | 2967 | 51 |
2323064 | 2323064 | 2022-03-19 | Todd | South Dakota | 46121 | 2967 | 51 |
2319810 | 2319810 | 2022-03-18 | Todd | South Dakota | 46121 | 2967 | 51 |
2259158 | 2259158 | 2022-02-28 | Charlton | Georgia | 13049 | 2967 | 61 |
2242605 | 2242605 | 2022-02-23 | Bradley | Arkansas | 5011 | 2967 | 44 |
2239354 | 2239354 | 2022-02-22 | Bradley | Arkansas | 5011 | 2967 | 44 |
2213361 | 2213361 | 2022-02-14 | Desha | Arkansas | 5041 | 2967 | 37 |
2212923 | 2212923 | 2022-02-13 | Brunswick | Virginia | 51025 | 2967 | 38 |
2209670 | 2209670 | 2022-02-12 | Brunswick | Virginia | 51025 | 2967 | 38 |
2206417 | 2206417 | 2022-02-11 | Brunswick | Virginia | 51025 | 2967 | 38 |
2189442 | 2189442 | 2022-02-06 | Curry | Oregon | 41015 | 2967 | 43 |
2186189 | 2186189 | 2022-02-05 | Curry | Oregon | 41015 | 2967 | 43 |
2182937 | 2182937 | 2022-02-04 | Curry | Oregon | 41015 | 2967 | 43 |
2174626 | 2174626 | 2022-02-02 | Dade | Georgia | 13083 | 2967 | 26 |
2170009 | 2170009 | 2022-01-31 | Potter | Pennsylvania | 42105 | 2967 | 86 |
2165683 | 2165683 | 2022-01-30 | Arenac | Michigan | 26011 | 2967 | 60 |
2162428 | 2162428 | 2022-01-29 | Arenac | Michigan | 26011 | 2967 | 60 |
2159173 | 2159173 | 2022-01-28 | Arenac | Michigan | 26011 | 2967 | 60 |
2154882 | 2154882 | 2022-01-27 | Mono | California | 6051 | 2967 | 4 |
2107526 | 2107526 | 2022-01-12 | Park | Montana | 30067 | 2967 | 32 |
2104275 | 2104275 | 2022-01-11 | Park | Montana | 30067 | 2967 | 32 |
2099023 | 2099023 | 2022-01-09 | San Juan | Utah | 49037 | 2967 | 46 |
2092892 | 2092892 | 2022-01-08 | Crenshaw | Alabama | 1041 | 2967 | 80 |
2095771 | 2095771 | 2022-01-08 | San Juan | Utah | 49037 | 2967 | 46 |
2092519 | 2092519 | 2022-01-07 | San Juan | Utah | 49037 | 2967 | 46 |
2089075 | 2089075 | 2022-01-06 | Freestone | Texas | 48161 | 2967 | 74 |
2084267 | 2084267 | 2022-01-05 | LaSalle | Louisiana | 22059 | 2967 | 46 |
2036407 | 2036407 | 2021-12-21 | Richland | North Dakota | 38077 | 2967 | 21 |
2020021 | 2020021 | 2021-12-16 | Avery | North Carolina | 37011 | 2967 | 39 |
2020334 | 2020334 | 2021-12-16 | Unknown | Oklahoma | 2967 | 2 | |
2017083 | 2017083 | 2021-12-15 | Unknown | Oklahoma | 2967 | 2 | |
2017419 | 2017419 | 2021-12-15 | Grundy | Tennessee | 47061 | 2967 | 45 |
2011745 | 2011745 | 2021-12-14 | Grant | Arkansas | 5053 | 2967 | 51 |
2006206 | 2006206 | 2021-12-12 | Powell | Kentucky | 21197 | 2967 | 25 |
2002955 | 2002955 | 2021-12-11 | Powell | Kentucky | 21197 | 2967 | 25 |
1999705 | 1999705 | 2021-12-10 | Powell | Kentucky | 21197 | 2967 | 25 |
1979234 | 1979234 | 2021-12-04 | Drew | Arkansas | 5043 | 2967 | 55 |
1973896 | 1973896 | 2021-12-02 | Manistee | Michigan | 26101 | 2967 | 49 |
1970647 | 1970647 | 2021-12-01 | Manistee | Michigan | 26101 | 2967 | 49 |
1967293 | 1967293 | 2021-11-30 | Franklin | Maine | 23007 | 2967 | 35 |
1968635 | 1968635 | 2021-11-30 | Benton | Tennessee | 47005 | 2967 | 56 |
1930155 | 1930155 | 2021-11-18 | Asotin | Washington | 53003 | 2967 | 50 |
1921064 | 1921064 | 2021-11-16 | Jeff Davis | Georgia | 13161 | 2967 | 60 |
1901273 | 1901273 | 2021-11-10 | Sharp | Arkansas | 5135 | 2967 | 69 |
1904122 | 1904122 | 2021-11-10 | Prince Edward | Virginia | 51147 | 2967 | 52 |
1895338 | 1895338 | 2021-11-08 | Jay | Indiana | 18075 | 2967 | 52 |
1897365 | 1897365 | 2021-11-08 | Lee | Texas | 48287 | 2967 | 52 |
1884985 | 1884985 | 2021-11-05 | Hempstead | Arkansas | 5057 | 2967 | 40 |
1881736 | 1881736 | 2021-11-04 | Hempstead | Arkansas | 5057 | 2967 | 39 |
1881224 | 1881224 | 2021-11-03 | Young | Texas | 48503 | 2967 | 68 |
1874735 | 1874735 | 2021-11-01 | Duchesne | Utah | 49013 | 2967 | 16 |
1870862 | 1870862 | 2021-10-31 | Wasco | Oregon | 41065 | 2967 | 41 |
1871486 | 1871486 | 2021-10-31 | Duchesne | Utah | 49013 | 2967 | 16 |
1867613 | 1867613 | 2021-10-30 | Wasco | Oregon | 41065 | 2967 | 41 |
1868237 | 1868237 | 2021-10-30 | Duchesne | Utah | 49013 | 2967 | 16 |
1864364 | 1864364 | 2021-10-29 | Wasco | Oregon | 41065 | 2967 | 41 |
1864988 | 1864988 | 2021-10-29 | Duchesne | Utah | 49013 | 2967 | 16 |
1859198 | 1859198 | 2021-10-28 | Gulf | Florida | 12045 | 2967 | 63 |
1855734 | 1855734 | 2021-10-27 | Cross | Arkansas | 5037 | 2967 | 64 |
1855949 | 1855949 | 2021-10-27 | Gulf | Florida | 12045 | 2967 | 63 |
1856094 | 1856094 | 2021-10-27 | Meriwether | Georgia | 13199 | 2967 | 111 |
1856368 | 1856368 | 2021-10-27 | Orange | Indiana | 18117 | 2967 | 69 |
1857212 | 1857212 | 2021-10-27 | Texas | Missouri | 29215 | 2967 | 42 |
1852700 | 1852700 | 2021-10-26 | Gulf | Florida | 12045 | 2967 | 63 |
1849451 | 1849451 | 2021-10-25 | Gulf | Florida | 12045 | 2967 | 63 |
1846201 | 1846201 | 2021-10-24 | Gulf | Florida | 12045 | 2967 | 64 |
1842951 | 1842951 | 2021-10-23 | Gulf | Florida | 12045 | 2967 | 64 |
1839701 | 1839701 | 2021-10-22 | Gulf | Florida | 12045 | 2967 | 64 |
1838713 | 1838713 | 2021-10-21 | Sequatchie | Tennessee | 47153 | 2967 | 32 |
1824536 | 1824536 | 2021-10-17 | Chickasaw | Mississippi | 28017 | 2967 | 67 |
1820030 | 1820030 | 2021-10-16 | Polk | Arkansas | 5113 | 2967 | 108 |
1821287 | 1821287 | 2021-10-16 | Chickasaw | Mississippi | 28017 | 2967 | 67 |
1822777 | 1822777 | 2021-10-16 | Franklin | Vermont | 50011 | 2967 | 47 |
1818038 | 1818038 | 2021-10-15 | Chickasaw | Mississippi | 28017 | 2967 | 67 |
1790333 | 1790333 | 2021-10-06 | Dinwiddie | Virginia | 51053 | 2967 | 51 |
1754984 | 1754984 | 2021-09-26 | La Paz | Arizona | 4012 | 2967 | 86 |
1742578 | 1742578 | 2021-09-22 | Union | Illinois | 17181 | 2967 | 51 |
1744109 | 1744109 | 2021-09-22 | Unknown | Oklahoma | 2967 | 0 | |
1744484 | 1744484 | 2021-09-22 | Polk | Tennessee | 47139 | 2967 | 25 |
1723928 | 1723928 | 2021-09-16 | Henry | Missouri | 29083 | 2967 | 46 |
1717387 | 1717387 | 2021-09-14 | Winston | Mississippi | 28159 | 2967 | 91 |
1714554 | 1714554 | 2021-09-13 | Ashe | North Carolina | 37009 | 2967 | 45 |
1711343 | 1711343 | 2021-09-12 | Greene | North Carolina | 37079 | 2967 | 50 |
1708096 | 1708096 | 2021-09-11 | Greene | North Carolina | 37079 | 2967 | 50 |
1704849 | 1704849 | 2021-09-10 | Greene | North Carolina | 37079 | 2967 | 50 |
1699704 | 1699704 | 2021-09-09 | Monroe | Alabama | 1099 | 2967 | 44 |
1677308 | 1677308 | 2021-09-02 | Ben Hill | Georgia | 13017 | 2967 | 87 |
1672284 | 1672284 | 2021-08-31 | Lewis | New York | 36049 | 2967 | 36 |
1667291 | 1667291 | 2021-08-30 | Columbia | Arkansas | 5027 | 2967 | 61 |
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);