ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 7136 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Kentucky 8
- Mississippi 8
- Tennessee 7
- Kansas 6
- Georgia 4
- Illinois 4
- Indiana 4
- Oregon 4
- Michigan 3
- Minnesota 3
- Ohio 3
- Texas 3
- Maine 2
- New York 2
- Pennsylvania 2
- South Carolina 2
- Virginia 2
- Alabama 1
- Arkansas 1
- California 1
- Florida 1
- Iowa 1
- Nebraska 1
- New Hampshire 1
- North Carolina 1
- Puerto Rico 1
- Utah 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498106 | 2498106 | 2022-05-12 | Coos | New Hampshire | 33007 | 7136 | 113 |
2433479 | 2433479 | 2022-04-22 | Elk | Pennsylvania | 42047 | 7136 | 101 |
2401227 | 2401227 | 2022-04-12 | Overton | Tennessee | 47133 | 7136 | 122 |
2396788 | 2396788 | 2022-04-11 | Adams | Mississippi | 28001 | 7136 | 142 |
2397972 | 2397972 | 2022-04-11 | Overton | Tennessee | 47133 | 7136 | 122 |
2393533 | 2393533 | 2022-04-10 | Adams | Mississippi | 28001 | 7136 | 142 |
2394717 | 2394717 | 2022-04-10 | Overton | Tennessee | 47133 | 7136 | 122 |
2390277 | 2390277 | 2022-04-09 | Adams | Mississippi | 28001 | 7136 | 142 |
2391461 | 2391461 | 2022-04-09 | Overton | Tennessee | 47133 | 7136 | 122 |
2387021 | 2387021 | 2022-04-08 | Adams | Mississippi | 28001 | 7136 | 142 |
2388205 | 2388205 | 2022-04-08 | Overton | Tennessee | 47133 | 7136 | 122 |
2383766 | 2383766 | 2022-04-07 | Adams | Mississippi | 28001 | 7136 | 142 |
2384950 | 2384950 | 2022-04-07 | Overton | Tennessee | 47133 | 7136 | 122 |
2380511 | 2380511 | 2022-04-06 | Adams | Mississippi | 28001 | 7136 | 142 |
2381695 | 2381695 | 2022-04-06 | Overton | Tennessee | 47133 | 7136 | 122 |
2377256 | 2377256 | 2022-04-05 | Adams | Mississippi | 28001 | 7136 | 142 |
2374004 | 2374004 | 2022-04-04 | Adams | Mississippi | 28001 | 7136 | 142 |
2368450 | 2368450 | 2022-04-02 | Gurabo | Puerto Rico | 72063 | 7136 | |
2359753 | 2359753 | 2022-03-31 | St. Francis | Arkansas | 5123 | 7136 | 94 |
2285425 | 2285425 | 2022-03-08 | McDonough | Illinois | 17109 | 7136 | 99 |
2269874 | 2269874 | 2022-03-03 | Mille Lacs | Minnesota | 27095 | 7136 | 110 |
2260990 | 2260990 | 2022-02-28 | Jefferson | Oregon | 41031 | 7136 | 81 |
2257739 | 2257739 | 2022-02-27 | Jefferson | Oregon | 41031 | 7136 | 80 |
2254488 | 2254488 | 2022-02-26 | Jefferson | Oregon | 41031 | 7136 | 80 |
2251237 | 2251237 | 2022-02-25 | Jefferson | Oregon | 41031 | 7136 | 80 |
2242972 | 2242972 | 2022-02-23 | Lumpkin | Georgia | 13187 | 7136 | 124 |
2188469 | 2188469 | 2022-02-06 | Dickinson | Michigan | 26043 | 7136 | 100 |
2185216 | 2185216 | 2022-02-05 | Dickinson | Michigan | 26043 | 7136 | 100 |
2181964 | 2181964 | 2022-02-04 | Dickinson | Michigan | 26043 | 7136 | 100 |
2165457 | 2165457 | 2022-01-30 | Carter | Kentucky | 21043 | 7136 | 91 |
2162202 | 2162202 | 2022-01-29 | Carter | Kentucky | 21043 | 7136 | 91 |
2158947 | 2158947 | 2022-01-28 | Carter | Kentucky | 21043 | 7136 | 91 |
2159784 | 2159784 | 2022-01-28 | Delaware | New York | 36025 | 7136 | 65 |
2152372 | 2152372 | 2022-01-26 | McPherson | Kansas | 20113 | 7136 | 113 |
2152489 | 2152489 | 2022-01-26 | Logan | Kentucky | 21141 | 7136 | 103 |
2149120 | 2149120 | 2022-01-25 | McPherson | Kansas | 20113 | 7136 | 113 |
2142857 | 2142857 | 2022-01-23 | Somerset | Maine | 23025 | 7136 | 79 |
2139602 | 2139602 | 2022-01-22 | Somerset | Maine | 23025 | 7136 | 79 |
2106283 | 2106283 | 2022-01-12 | Bryan | Georgia | 13029 | 7136 | 77 |
2033901 | 2033901 | 2021-12-20 | Medina | Texas | 48325 | 7136 | 171 |
2018312 | 2018312 | 2021-12-16 | Lake | California | 6033 | 7136 | 115 |
2013609 | 2013609 | 2021-12-14 | Watauga | North Carolina | 37189 | 7136 | 42 |
2010106 | 2010106 | 2021-12-13 | Scotts Bluff | Nebraska | 31157 | 7136 | 102 |
1996089 | 1996089 | 2021-12-09 | Harrison | Indiana | 18061 | 7136 | 103 |
1882337 | 1882337 | 2021-11-04 | Jackson | Indiana | 18071 | 7136 | 96 |
1882928 | 1882928 | 2021-11-04 | Beltrami | Minnesota | 27007 | 7136 | 84 |
1879386 | 1879386 | 2021-11-03 | Franklin | Kentucky | 21073 | 7136 | 80 |
1873914 | 1873914 | 2021-11-01 | Ashland | Ohio | 39005 | 7136 | 138 |
1846472 | 1846472 | 2021-10-24 | Clinton | Illinois | 17027 | 7136 | 111 |
1843222 | 1843222 | 2021-10-23 | Clinton | Illinois | 17027 | 7136 | 111 |
1839972 | 1839972 | 2021-10-22 | Clinton | Illinois | 17027 | 7136 | 111 |
1791546 | 1791546 | 2021-10-07 | Finney | Kansas | 20055 | 7136 | 80 |
1765378 | 1765378 | 2021-09-29 | Lawrence | Indiana | 18093 | 7136 | 164 |
1748358 | 1748358 | 2021-09-23 | Waupaca | Wisconsin | 55135 | 7136 | 178 |
1739176 | 1739176 | 2021-09-21 | Ware | Georgia | 13299 | 7136 | 218 |
1639824 | 1639824 | 2021-08-21 | St. Lawrence | New York | 36089 | 7136 | 97 |
1585146 | 1585146 | 2021-08-04 | Georgetown | South Carolina | 45043 | 7136 | 144 |
1543625 | 1543625 | 2021-07-22 | Raleigh | West Virginia | 54081 | 7136 | 101 |
1528521 | 1528521 | 2021-07-18 | Christian | Kentucky | 21047 | 7136 | 107 |
1525274 | 1525274 | 2021-07-17 | Christian | Kentucky | 21047 | 7136 | 107 |
1522026 | 1522026 | 2021-07-16 | Christian | Kentucky | 21047 | 7136 | 107 |
1517790 | 1517790 | 2021-07-15 | Jackson | Alabama | 1071 | 7136 | 117 |
1412700 | 1412700 | 2021-06-12 | Ashtabula | Ohio | 39007 | 7136 | 179 |
1254467 | 1254467 | 2021-04-24 | Tooele | Utah | 49045 | 7136 | 41 |
1233032 | 1233032 | 2021-04-18 | Leavenworth | Kansas | 20103 | 7136 | 90 |
1229783 | 1229783 | 2021-04-17 | Leavenworth | Kansas | 20103 | 7136 | 55 |
1226535 | 1226535 | 2021-04-16 | Leavenworth | Kansas | 20103 | 7136 | 55 |
1203583 | 1203583 | 2021-04-09 | Grant | Indiana | 18053 | 7136 | 174 |
1202049 | 1202049 | 2021-04-08 | Kershaw | South Carolina | 45055 | 7136 | 134 |
1160256 | 1160256 | 2021-03-26 | Wise | Texas | 48497 | 7136 | 115 |
1153872 | 1153872 | 2021-03-24 | Hanover | Virginia | 51085 | 7136 | 147 |
1146478 | 1146478 | 2021-03-22 | Erie | Ohio | 39043 | 7136 | 151 |
1104960 | 1104960 | 2021-03-09 | Liberty | Texas | 48291 | 7136 | 165 |
1063087 | 1063087 | 2021-02-24 | Thurston | Washington | 53067 | 7136 | 79 |
1055768 | 1055768 | 2021-02-22 | Adams | Pennsylvania | 42001 | 7136 | 148 |
980188 | 980188 | 2021-01-30 | Carver | Minnesota | 27019 | 7136 | 39 |
981831 | 981831 | 2021-01-30 | Hampton city | Virginia | 51650 | 7136 | 65 |
823894 | 823894 | 2020-12-13 | Dallas | Iowa | 19049 | 7136 | 60 |
580278 | 580278 | 2020-09-29 | Richmond | Georgia | 13245 | 7136 | 162 |
476582 | 476582 | 2020-08-28 | Sarasota | Florida | 12115 | 7136 | 201 |
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);