ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
179 rows where cases = 2236 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 23
- Tennessee 12
- Florida 10
- South Carolina 9
- Wisconsin 8
- Texas 7
- Illinois 6
- Indiana 6
- Kentucky 6
- North Carolina 6
- Virginia 6
- West Virginia 6
- Arkansas 5
- Missouri 5
- Alaska 4
- Mississippi 4
- Ohio 4
- Pennsylvania 4
- Puerto Rico 4
- Washington 4
- Louisiana 3
- Oklahoma 3
- South Dakota 3
- California 2
- Colorado 2
- Hawaii 2
- Idaho 2
- Iowa 2
- Kansas 2
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490350 | 2490350 | 2022-05-10 | Wilkinson | Georgia | 13319 | 2236 | 56 |
2487093 | 2487093 | 2022-05-09 | Wilkinson | Georgia | 13319 | 2236 | 56 |
2483835 | 2483835 | 2022-05-08 | Wilkinson | Georgia | 13319 | 2236 | 56 |
2480577 | 2480577 | 2022-05-07 | Wilkinson | Georgia | 13319 | 2236 | 56 |
2477319 | 2477319 | 2022-05-06 | Wilkinson | Georgia | 13319 | 2236 | 56 |
2474061 | 2474061 | 2022-05-05 | Wilkinson | Georgia | 13319 | 2236 | 56 |
2470804 | 2470804 | 2022-05-04 | Wilkinson | Georgia | 13319 | 2236 | 56 |
2466201 | 2466201 | 2022-05-02 | McCormick | South Carolina | 45065 | 2236 | 40 |
2462946 | 2462946 | 2022-05-01 | McCormick | South Carolina | 45065 | 2236 | 40 |
2459690 | 2459690 | 2022-04-30 | McCormick | South Carolina | 45065 | 2236 | 40 |
2456434 | 2456434 | 2022-04-29 | McCormick | South Carolina | 45065 | 2236 | 40 |
2453178 | 2453178 | 2022-04-28 | McCormick | South Carolina | 45065 | 2236 | 40 |
2400964 | 2400964 | 2022-04-12 | Adjuntas | Puerto Rico | 72001 | 2236 | |
2384743 | 2384743 | 2022-04-07 | Penuelas | Puerto Rico | 72111 | 2236 | |
2332892 | 2332892 | 2022-03-22 | Moore | Tennessee | 47127 | 2236 | 40 |
2329639 | 2329639 | 2022-03-21 | Moore | Tennessee | 47127 | 2236 | 40 |
2326387 | 2326387 | 2022-03-20 | Moore | Tennessee | 47127 | 2236 | 40 |
2323134 | 2323134 | 2022-03-19 | Moore | Tennessee | 47127 | 2236 | 40 |
2319880 | 2319880 | 2022-03-18 | Moore | Tennessee | 47127 | 2236 | 40 |
2316626 | 2316626 | 2022-03-17 | Moore | Tennessee | 47127 | 2236 | 40 |
2313373 | 2313373 | 2022-03-16 | Moore | Tennessee | 47127 | 2236 | 40 |
2309819 | 2309819 | 2022-03-15 | Forest | Pennsylvania | 42053 | 2236 | 35 |
2304821 | 2304821 | 2022-03-14 | Wilkes | Georgia | 13317 | 2236 | 49 |
2261709 | 2261709 | 2022-02-28 | Essex | Virginia | 51057 | 2236 | 30 |
2242128 | 2242128 | 2022-02-22 | Grand | Utah | 49019 | 2236 | 6 |
2220205 | 2220205 | 2022-02-16 | Johnson | Georgia | 13167 | 2236 | 69 |
2213706 | 2213706 | 2022-02-14 | Lanier | Georgia | 13173 | 2236 | 19 |
2210454 | 2210454 | 2022-02-13 | Lanier | Georgia | 13173 | 2236 | 19 |
2207201 | 2207201 | 2022-02-12 | Lanier | Georgia | 13173 | 2236 | 19 |
2203948 | 2203948 | 2022-02-11 | Lanier | Georgia | 13173 | 2236 | 19 |
2172139 | 2172139 | 2022-02-01 | Piscataquis | Maine | 23021 | 2236 | 25 |
2162736 | 2162736 | 2022-01-29 | Linn | Missouri | 29115 | 2236 | 59 |
2155030 | 2155030 | 2022-01-27 | Liberty | Florida | 12077 | 2236 | 25 |
2151777 | 2151777 | 2022-01-26 | Liberty | Florida | 12077 | 2236 | 25 |
2148525 | 2148525 | 2022-01-25 | Liberty | Florida | 12077 | 2236 | 25 |
2145273 | 2145273 | 2022-01-24 | Liberty | Florida | 12077 | 2236 | 25 |
2142018 | 2142018 | 2022-01-23 | Liberty | Florida | 12077 | 2236 | 25 |
2138763 | 2138763 | 2022-01-22 | Liberty | Florida | 12077 | 2236 | 25 |
2135507 | 2135507 | 2022-01-21 | Liberty | Florida | 12077 | 2236 | 25 |
2119323 | 2119323 | 2022-01-16 | Early | Georgia | 13099 | 2236 | 58 |
2116071 | 2116071 | 2022-01-15 | Early | Georgia | 13099 | 2236 | 58 |
2112820 | 2112820 | 2022-01-14 | Early | Georgia | 13099 | 2236 | 58 |
2098599 | 2098599 | 2022-01-09 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2095347 | 2095347 | 2022-01-08 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2092095 | 2092095 | 2022-01-07 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2077700 | 2077700 | 2022-01-03 | Metcalfe | Kentucky | 21169 | 2236 | 51 |
2061544 | 2061544 | 2021-12-29 | West Carroll | Louisiana | 22123 | 2236 | 53 |
2060268 | 2060268 | 2021-12-28 | Bayfield | Wisconsin | 55007 | 2236 | 31 |
2036355 | 2036355 | 2021-12-21 | Swain | North Carolina | 37173 | 2236 | 28 |
2032602 | 2032602 | 2021-12-20 | Walthall | Mississippi | 28147 | 2236 | 66 |
2023266 | 2023266 | 2021-12-17 | Yates | New York | 36123 | 2236 | 35 |
1997585 | 1997585 | 2021-12-09 | Baker | Oregon | 41001 | 2236 | 35 |
1982434 | 1982434 | 2021-12-05 | Nome Census Area | Alaska | 2180 | 2236 | 2 |
1979184 | 1979184 | 2021-12-04 | Nome Census Area | Alaska | 2180 | 2236 | 2 |
1975934 | 1975934 | 2021-12-03 | Nome Census Area | Alaska | 2180 | 2236 | 2 |
1969433 | 1969433 | 2021-12-01 | Kusilvak Census Area | Alaska | 2158 | 2236 | 9 |
1971943 | 1971943 | 2021-12-01 | Meigs | Tennessee | 47121 | 2236 | 31 |
1963548 | 1963548 | 2021-11-29 | Washington | Illinois | 17189 | 2236 | 36 |
1952779 | 1952779 | 2021-11-25 | Alleghany | Virginia | 51005 | 2236 | 83 |
1946506 | 1946506 | 2021-11-23 | Buffalo | Wisconsin | 55011 | 2236 | 8 |
1927592 | 1927592 | 2021-11-18 | Oglethorpe | Georgia | 13221 | 2236 | 43 |
1921792 | 1921792 | 2021-11-16 | Sagadahoc | Maine | 23023 | 2236 | 14 |
1904199 | 1904199 | 2021-11-10 | Braxton | West Virginia | 54007 | 2236 | 22 |
1884827 | 1884827 | 2021-11-04 | Converse | Wyoming | 56009 | 2236 | 38 |
1804031 | 1804031 | 2021-10-11 | Charlton | Georgia | 13049 | 2236 | 53 |
1800782 | 1800782 | 2021-10-10 | Charlton | Georgia | 13049 | 2236 | 53 |
1797533 | 1797533 | 2021-10-09 | Charlton | Georgia | 13049 | 2236 | 53 |
1794284 | 1794284 | 2021-10-08 | Charlton | Georgia | 13049 | 2236 | 53 |
1769640 | 1769640 | 2021-09-30 | York | Nebraska | 31185 | 2236 | 19 |
1765182 | 1765182 | 2021-09-29 | Kauai | Hawaii | 15007 | 2236 | 8 |
1750429 | 1750429 | 2021-09-24 | Richland | North Dakota | 38077 | 2236 | 19 |
1736441 | 1736441 | 2021-09-20 | Henry | Kentucky | 21103 | 2236 | 23 |
1719749 | 1719749 | 2021-09-15 | Carroll | Illinois | 17015 | 2236 | 38 |
1709540 | 1709540 | 2021-09-12 | Howard | Arkansas | 5061 | 2236 | 28 |
1696548 | 1696548 | 2021-09-08 | Izard | Arkansas | 5065 | 2236 | 53 |
1690166 | 1690166 | 2021-09-06 | Crowley | Colorado | 8025 | 2236 | 18 |
1685301 | 1685301 | 2021-09-04 | Seneca | New York | 36099 | 2236 | 57 |
1682987 | 1682987 | 2021-09-03 | San Jacinto | Texas | 48407 | 2236 | 43 |
1663056 | 1663056 | 2021-08-28 | Naranjito | Puerto Rico | 72105 | 2236 | |
1656433 | 1656433 | 2021-08-26 | Union | Oregon | 41061 | 2236 | 30 |
1652972 | 1652972 | 2021-08-25 | Rolette | North Dakota | 38079 | 2236 | 28 |
1620057 | 1620057 | 2021-08-15 | Wright | Missouri | 29229 | 2236 | 40 |
1607088 | 1607088 | 2021-08-11 | Lake | Montana | 30047 | 2236 | 39 |
1589335 | 1589335 | 2021-08-06 | Cross | Arkansas | 5037 | 2236 | 53 |
1589343 | 1589343 | 2021-08-06 | Grant | Arkansas | 5053 | 2236 | 39 |
1582646 | 1582646 | 2021-08-03 | Langlade | Wisconsin | 55067 | 2236 | 51 |
1576989 | 1576989 | 2021-08-02 | Sullivan | Indiana | 18153 | 2236 | 43 |
1579396 | 1579396 | 2021-08-02 | Langlade | Wisconsin | 55067 | 2236 | 51 |
1545290 | 1545290 | 2021-07-23 | Livingston | Missouri | 29117 | 2236 | 48 |
1530892 | 1530892 | 2021-07-19 | Lawrence | Arkansas | 5075 | 2236 | 43 |
1520412 | 1520412 | 2021-07-15 | Cass | Texas | 48067 | 2236 | 84 |
1478179 | 1478179 | 2021-07-02 | Austin | Texas | 48015 | 2236 | 37 |
1478369 | 1478369 | 2021-07-02 | Robertson | Texas | 48395 | 2236 | 47 |
1473295 | 1473295 | 2021-07-01 | Sumner | Kansas | 20191 | 2236 | 53 |
1470049 | 1470049 | 2021-06-30 | Sumner | Kansas | 20191 | 2236 | 53 |
1465333 | 1465333 | 2021-06-28 | Lee | Texas | 48287 | 2236 | 39 |
1397512 | 1397512 | 2021-06-07 | Brooke | West Virginia | 54009 | 2236 | 60 |
1346568 | 1346568 | 2021-05-23 | Jackson | Iowa | 19097 | 2236 | 42 |
1343320 | 1343320 | 2021-05-22 | Jackson | Iowa | 19097 | 2236 | 42 |
1329679 | 1329679 | 2021-05-18 | Colusa | California | 6011 | 2236 | 16 |
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);