ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 3462 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 11
- Arkansas 9
- Illinois 9
- Iowa 9
- Kentucky 9
- New York 9
- Georgia 8
- Texas 8
- Alabama 6
- Michigan 6
- Minnesota 6
- Colorado 5
- Indiana 5
- Ohio 5
- Virginia 5
- New Mexico 4
- Wisconsin 4
- California 3
- Florida 2
- Kansas 2
- Louisiana 2
- Maine 2
- Missouri 2
- Pennsylvania 2
- South Carolina 2
- West Virginia 2
- Arizona 1
- Delaware 1
- Idaho 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2434059 | 2434059 | 2022-04-22 | Wilbarger | Texas | 48487 | 3462 | 87 |
2343492 | 2343492 | 2022-03-26 | Van Buren | Arkansas | 5141 | 3462 | 62 |
2340239 | 2340239 | 2022-03-25 | Van Buren | Arkansas | 5141 | 3462 | 62 |
2336986 | 2336986 | 2022-03-24 | Van Buren | Arkansas | 5141 | 3462 | 62 |
2327226 | 2327226 | 2022-03-21 | Van Buren | Arkansas | 5141 | 3462 | 61 |
2309865 | 2309865 | 2022-03-15 | Anasco | Puerto Rico | 72011 | 3462 | |
2306612 | 2306612 | 2022-03-14 | Anasco | Puerto Rico | 72011 | 3462 | |
2303361 | 2303361 | 2022-03-13 | Anasco | Puerto Rico | 72011 | 3462 | |
2300109 | 2300109 | 2022-03-12 | Anasco | Puerto Rico | 72011 | 3462 | |
2296856 | 2296856 | 2022-03-11 | Aibonito | Puerto Rico | 72009 | 3462 | |
2296857 | 2296857 | 2022-03-11 | Anasco | Puerto Rico | 72011 | 3462 | |
2293604 | 2293604 | 2022-03-10 | Aibonito | Puerto Rico | 72009 | 3462 | |
2293605 | 2293605 | 2022-03-10 | Anasco | Puerto Rico | 72011 | 3462 | |
2285598 | 2285598 | 2022-03-08 | Hamilton | Iowa | 19079 | 3462 | 70 |
2282346 | 2282346 | 2022-03-07 | Hamilton | Iowa | 19079 | 3462 | 70 |
2279093 | 2279093 | 2022-03-06 | Hamilton | Iowa | 19079 | 3462 | 70 |
2275840 | 2275840 | 2022-03-05 | Hamilton | Iowa | 19079 | 3462 | 70 |
2272587 | 2272587 | 2022-03-04 | Hamilton | Iowa | 19079 | 3462 | 70 |
2269335 | 2269335 | 2022-03-03 | Hamilton | Iowa | 19079 | 3462 | 70 |
2266082 | 2266082 | 2022-03-02 | Hamilton | Iowa | 19079 | 3462 | 70 |
2243155 | 2243155 | 2022-02-23 | Menard | Illinois | 17129 | 3462 | 23 |
2211266 | 2211266 | 2022-02-13 | Leelanau | Michigan | 26089 | 3462 | 47 |
2208013 | 2208013 | 2022-02-12 | Leelanau | Michigan | 26089 | 3462 | 47 |
2204760 | 2204760 | 2022-02-11 | Leelanau | Michigan | 26089 | 3462 | 47 |
2191241 | 2191241 | 2022-02-07 | Tipton | Indiana | 18159 | 3462 | 82 |
2190185 | 2190185 | 2022-02-06 | Grayson | Virginia | 51077 | 3462 | 70 |
2186932 | 2186932 | 2022-02-05 | Grayson | Virginia | 51077 | 3462 | 70 |
2183679 | 2183679 | 2022-02-04 | Grayson | Virginia | 51077 | 3462 | 70 |
2177511 | 2177511 | 2022-02-03 | Washington | Alabama | 1129 | 3462 | 53 |
2174258 | 2174258 | 2022-02-02 | Washington | Alabama | 1129 | 3462 | 53 |
2122832 | 2122832 | 2022-01-17 | Warren | Illinois | 17187 | 3462 | 76 |
2119580 | 2119580 | 2022-01-16 | Warren | Illinois | 17187 | 3462 | 76 |
2116328 | 2116328 | 2022-01-15 | Warren | Illinois | 17187 | 3462 | 76 |
2113077 | 2113077 | 2022-01-14 | Warren | Illinois | 17187 | 3462 | 76 |
2103680 | 2103680 | 2022-01-11 | Henry | Kentucky | 21103 | 3462 | 39 |
2105857 | 2105857 | 2022-01-11 | Carbon | Wyoming | 56007 | 3462 | 50 |
2092905 | 2092905 | 2022-01-08 | Henry | Alabama | 1067 | 3462 | 67 |
2060924 | 2060924 | 2021-12-29 | Blaine | Idaho | 16013 | 3462 | 27 |
2056987 | 2056987 | 2021-12-27 | McDowell | West Virginia | 54047 | 3462 | 56 |
2024735 | 2024735 | 2021-12-18 | Columbia | Arkansas | 5027 | 3462 | 75 |
1973711 | 1973711 | 2021-12-02 | Simpson | Kentucky | 21213 | 3462 | 62 |
1969524 | 1969524 | 2021-12-01 | Randolph | Arkansas | 5121 | 3462 | 64 |
1946744 | 1946744 | 2021-11-24 | Lawrence | Arkansas | 5075 | 3462 | 60 |
1943997 | 1943997 | 2021-11-23 | Lawrence | Illinois | 17101 | 3462 | 45 |
1944692 | 1944692 | 2021-11-23 | Dodge | Minnesota | 27039 | 3462 | 11 |
1928917 | 1928917 | 2021-11-18 | Grant | New Mexico | 35017 | 3462 | 54 |
1924461 | 1924461 | 2021-11-17 | Crawford | Illinois | 17033 | 3462 | 47 |
1899115 | 1899115 | 2021-11-09 | Gladwin | Michigan | 26051 | 3462 | 77 |
1895865 | 1895865 | 2021-11-08 | Gladwin | Michigan | 26051 | 3462 | 77 |
1823512 | 1823512 | 2021-10-17 | Berrien | Georgia | 13019 | 3462 | 61 |
1820263 | 1820263 | 2021-10-16 | Berrien | Georgia | 13019 | 3462 | 61 |
1817014 | 1817014 | 2021-10-15 | Berrien | Georgia | 13019 | 3462 | 61 |
1770109 | 1770109 | 2021-09-30 | Columbia | Oregon | 41009 | 3462 | 39 |
1755885 | 1755885 | 2021-09-26 | Allen | Kentucky | 21003 | 3462 | 61 |
1752637 | 1752637 | 2021-09-25 | Allen | Kentucky | 21003 | 3462 | 61 |
1749388 | 1749388 | 2021-09-24 | Allen | Kentucky | 21003 | 3462 | 61 |
1723465 | 1723465 | 2021-09-16 | Marion | Kentucky | 21155 | 3462 | 40 |
1714081 | 1714081 | 2021-09-13 | Grenada | Mississippi | 28043 | 3462 | 98 |
1715123 | 1715123 | 2021-09-13 | Davison | South Dakota | 46035 | 3462 | 69 |
1708236 | 1708236 | 2021-09-11 | Fayette | Ohio | 39047 | 3462 | 51 |
1697780 | 1697780 | 2021-09-08 | Mille Lacs | Minnesota | 27095 | 3462 | 59 |
1679517 | 1679517 | 2021-09-02 | Smith | Tennessee | 47159 | 3462 | 41 |
1674839 | 1674839 | 2021-09-01 | Union | Louisiana | 22111 | 3462 | 91 |
1672315 | 1672315 | 2021-08-31 | Washington | New York | 36115 | 3462 | 58 |
1609108 | 1609108 | 2021-08-12 | Butts | Georgia | 13035 | 3462 | 91 |
1432516 | 1432516 | 2021-06-18 | Vega Baja | Puerto Rico | 72145 | 3462 | |
1425503 | 1425503 | 2021-06-16 | Otsego | New York | 36077 | 3462 | 47 |
1422256 | 1422256 | 2021-06-15 | Otsego | New York | 36077 | 3462 | 47 |
1402251 | 1402251 | 2021-06-09 | Freeborn | Minnesota | 27047 | 3462 | 31 |
1398429 | 1398429 | 2021-06-08 | Ripley | Indiana | 18137 | 3462 | 70 |
1390347 | 1390347 | 2021-06-05 | Clarendon | South Carolina | 45027 | 3462 | 114 |
1382355 | 1382355 | 2021-06-03 | Geary | Kansas | 20061 | 3462 | 40 |
1379110 | 1379110 | 2021-06-02 | Geary | Kansas | 20061 | 3462 | 40 |
1380329 | 1380329 | 2021-06-02 | Williams | Ohio | 39171 | 3462 | 77 |
1381055 | 1381055 | 2021-06-02 | Wood | Texas | 48499 | 3462 | 129 |
1377810 | 1377810 | 2021-06-01 | Wood | Texas | 48499 | 3462 | 129 |
1374564 | 1374564 | 2021-05-31 | Wood | Texas | 48499 | 3462 | 129 |
1371319 | 1371319 | 2021-05-30 | Wood | Texas | 48499 | 3462 | 129 |
1368073 | 1368073 | 2021-05-29 | Wood | Texas | 48499 | 3462 | 129 |
1363808 | 1363808 | 2021-05-28 | Chenango | New York | 36017 | 3462 | 76 |
1364827 | 1364827 | 2021-05-28 | Wood | Texas | 48499 | 3462 | 129 |
1360562 | 1360562 | 2021-05-27 | Chenango | New York | 36017 | 3462 | 76 |
1327574 | 1327574 | 2021-05-17 | Carlton | Minnesota | 27017 | 3462 | 54 |
1300556 | 1300556 | 2021-05-09 | Montrose | Colorado | 8085 | 3462 | 58 |
1300656 | 1300656 | 2021-05-09 | Wakulla | Florida | 12129 | 3462 | 56 |
1297309 | 1297309 | 2021-05-08 | Montrose | Colorado | 8085 | 3462 | 58 |
1263359 | 1263359 | 2021-04-27 | Stutsman | North Dakota | 38093 | 3462 | 81 |
1253968 | 1253968 | 2021-04-24 | Trujillo Alto | Puerto Rico | 72139 | 3462 | |
1246969 | 1246969 | 2021-04-22 | Tioga | New York | 36107 | 3462 | 59 |
1220677 | 1220677 | 2021-04-14 | Pulaski | Missouri | 29169 | 3462 | 51 |
1221524 | 1221524 | 2021-04-14 | Colleton | South Carolina | 45029 | 3462 | 124 |
1216633 | 1216633 | 2021-04-13 | Wabash | Indiana | 18169 | 3462 | 77 |
1217429 | 1217429 | 2021-04-13 | Pulaski | Missouri | 29169 | 3462 | 51 |
1213617 | 1213617 | 2021-04-12 | Calloway | Kentucky | 21035 | 3462 | 49 |
1203872 | 1203872 | 2021-04-09 | Calloway | Kentucky | 21035 | 3462 | 49 |
1177275 | 1177275 | 2021-04-01 | Bryan | Georgia | 13029 | 3462 | 36 |
1175440 | 1175440 | 2021-03-31 | Cibola | New Mexico | 35006 | 3462 | 106 |
1172193 | 1172193 | 2021-03-30 | Cibola | New Mexico | 35006 | 3462 | 106 |
1167141 | 1167141 | 2021-03-29 | Clarke | Alabama | 1025 | 3462 | 58 |
1163893 | 1163893 | 2021-03-28 | Clarke | Alabama | 1025 | 3462 | 58 |
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);