ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 3678 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 11
- Virginia 10
- Pennsylvania 9
- Florida 8
- Georgia 7
- Arkansas 6
- Kentucky 6
- South Carolina 6
- Washington 6
- Alabama 5
- Idaho 5
- Puerto Rico 5
- Louisiana 4
- Minnesota 4
- Missouri 4
- South Dakota 4
- Tennessee 4
- New Mexico 3
- North Carolina 3
- Ohio 3
- West Virginia 3
- Indiana 2
- Iowa 2
- Michigan 2
- Mississippi 2
- Texas 2
- Wisconsin 2
- California 1
- Illinois 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472151 | 2472151 | 2022-05-04 | Schuyler | New York | 36097 | 3678 | 25 |
2470025 | 2470025 | 2022-05-03 | Patrick | Virginia | 51141 | 3678 | 98 |
2371712 | 2371712 | 2022-04-03 | Lares | Puerto Rico | 72081 | 3678 | |
2258808 | 2258808 | 2022-02-28 | Washington | Alabama | 1129 | 3678 | 55 |
2255557 | 2255557 | 2022-02-27 | Washington | Alabama | 1129 | 3678 | 55 |
2252306 | 2252306 | 2022-02-26 | Washington | Alabama | 1129 | 3678 | 55 |
2224332 | 2224332 | 2022-02-17 | Faribault | Minnesota | 27043 | 3678 | 49 |
2219593 | 2219593 | 2022-02-15 | Grant | West Virginia | 54023 | 3678 | 53 |
2200564 | 2200564 | 2022-02-10 | Hamilton | Florida | 12047 | 3678 | 49 |
2197310 | 2197310 | 2022-02-09 | Hamilton | Florida | 12047 | 3678 | 49 |
2194056 | 2194056 | 2022-02-08 | Hamilton | Florida | 12047 | 3678 | 49 |
2190802 | 2190802 | 2022-02-07 | Hamilton | Florida | 12047 | 3678 | 49 |
2187549 | 2187549 | 2022-02-06 | Hamilton | Florida | 12047 | 3678 | 49 |
2184085 | 2184085 | 2022-02-05 | Franklin | Arkansas | 5047 | 3678 | 66 |
2184296 | 2184296 | 2022-02-05 | Hamilton | Florida | 12047 | 3678 | 49 |
2181044 | 2181044 | 2022-02-04 | Hamilton | Florida | 12047 | 3678 | 49 |
2182313 | 2182313 | 2022-02-04 | Wright | Missouri | 29229 | 3678 | 72 |
2180428 | 2180428 | 2022-02-03 | Greene | Virginia | 51079 | 3678 | 50 |
2149230 | 2149230 | 2022-01-25 | Lawrence | Kentucky | 21127 | 3678 | 52 |
2151229 | 2151229 | 2022-01-25 | Asotin | Washington | 53003 | 3678 | 54 |
2147977 | 2147977 | 2022-01-24 | Asotin | Washington | 53003 | 3678 | 54 |
2131588 | 2131588 | 2022-01-19 | Buchanan | Virginia | 51027 | 3678 | 90 |
2121912 | 2121912 | 2022-01-16 | Prince Edward | Virginia | 51147 | 3678 | 54 |
2118660 | 2118660 | 2022-01-15 | Prince Edward | Virginia | 51147 | 3678 | 54 |
2115408 | 2115408 | 2022-01-14 | Prince Edward | Virginia | 51147 | 3678 | 54 |
2102739 | 2102739 | 2022-01-11 | Ashley | Arkansas | 5003 | 3678 | 56 |
2097964 | 2097964 | 2022-01-09 | San Miguel | New Mexico | 35047 | 3678 | 38 |
2094712 | 2094712 | 2022-01-08 | San Miguel | New Mexico | 35047 | 3678 | 38 |
2091460 | 2091460 | 2022-01-07 | San Miguel | New Mexico | 35047 | 3678 | 38 |
2088864 | 2088864 | 2022-01-06 | Hughes | South Dakota | 46065 | 3678 | 56 |
2085123 | 2085123 | 2022-01-05 | Yancey | North Carolina | 37199 | 3678 | 37 |
2079147 | 2079147 | 2022-01-03 | Bledsoe | Tennessee | 47007 | 3678 | 39 |
2057853 | 2057853 | 2021-12-28 | Jay | Indiana | 18075 | 3678 | 62 |
2054289 | 2054289 | 2021-12-27 | Cook | Georgia | 13075 | 3678 | 65 |
2041298 | 2041298 | 2021-12-23 | Dodge | Georgia | 13091 | 3678 | 135 |
1992725 | 1992725 | 2021-12-08 | Douglas | Illinois | 17041 | 3678 | 44 |
1990391 | 1990391 | 2021-12-07 | Henry | Missouri | 29083 | 3678 | 64 |
1925077 | 1925077 | 2021-11-17 | Franklin | Massachusetts | 25011 | 3678 | 123 |
1899809 | 1899809 | 2021-11-09 | Martin | North Carolina | 37117 | 3678 | 74 |
1871128 | 1871128 | 2021-10-31 | Yankton | South Dakota | 46135 | 3678 | 38 |
1867879 | 1867879 | 2021-10-30 | Yankton | South Dakota | 46135 | 3678 | 38 |
1864630 | 1864630 | 2021-10-29 | Yankton | South Dakota | 46135 | 3678 | 38 |
1852095 | 1852095 | 2021-10-25 | Hopewell city | Virginia | 51670 | 3678 | 86 |
1829732 | 1829732 | 2021-10-19 | Cleburne | Arkansas | 5023 | 3678 | 90 |
1779914 | 1779914 | 2021-10-03 | Elk | Pennsylvania | 42047 | 3678 | 49 |
1764803 | 1764803 | 2021-09-29 | Sevier | Arkansas | 5133 | 3678 | 33 |
1761839 | 1761839 | 2021-09-28 | Haralson | Georgia | 13143 | 3678 | 103 |
1738041 | 1738041 | 2021-09-20 | Calhoun | Texas | 48057 | 3678 | 32 |
1714029 | 1714029 | 2021-09-13 | Pine | Minnesota | 27115 | 3678 | 24 |
1688954 | 1688954 | 2021-09-05 | Greene | Pennsylvania | 42059 | 3678 | 44 |
1583243 | 1583243 | 2021-08-04 | Upson | Georgia | 13293 | 3678 | 133 |
1572051 | 1572051 | 2021-07-31 | Arecibo | Puerto Rico | 72013 | 3678 | |
1568562 | 1568562 | 2021-07-30 | Highland | Ohio | 39071 | 3678 | 68 |
1563719 | 1563719 | 2021-07-29 | Pickens | Georgia | 13227 | 3678 | 79 |
1565666 | 1565666 | 2021-07-29 | Marion | South Carolina | 45067 | 3678 | 108 |
1557758 | 1557758 | 2021-07-27 | Floyd | Kentucky | 21071 | 3678 | 74 |
1551246 | 1551246 | 2021-07-25 | Calloway | Kentucky | 21035 | 3678 | 50 |
1547999 | 1547999 | 2021-07-24 | Calloway | Kentucky | 21035 | 3678 | 50 |
1544752 | 1544752 | 2021-07-23 | Calloway | Kentucky | 21035 | 3678 | 50 |
1470618 | 1470618 | 2021-06-30 | Marion | Missouri | 29127 | 3678 | 53 |
1471457 | 1471457 | 2021-06-30 | Trujillo Alto | Puerto Rico | 72139 | 3678 | |
1468212 | 1468212 | 2021-06-29 | Trujillo Alto | Puerto Rico | 72139 | 3678 | |
1464884 | 1464884 | 2021-06-28 | Snyder | Pennsylvania | 42109 | 3678 | 86 |
1464967 | 1464967 | 2021-06-28 | Trujillo Alto | Puerto Rico | 72139 | 3678 | |
1461639 | 1461639 | 2021-06-27 | Snyder | Pennsylvania | 42109 | 3678 | 85 |
1458394 | 1458394 | 2021-06-26 | Snyder | Pennsylvania | 42109 | 3678 | 85 |
1455149 | 1455149 | 2021-06-25 | Snyder | Pennsylvania | 42109 | 3678 | 85 |
1418174 | 1418174 | 2021-06-14 | Greenup | Kentucky | 21089 | 3678 | 63 |
1380612 | 1380612 | 2021-06-02 | Colleton | South Carolina | 45029 | 3678 | 129 |
1375873 | 1375873 | 2021-06-01 | Harvey | Kansas | 20079 | 3678 | 70 |
1377367 | 1377367 | 2021-06-01 | Colleton | South Carolina | 45029 | 3678 | 129 |
1372284 | 1372284 | 2021-05-31 | Nez Perce | Idaho | 16069 | 3678 | 55 |
1372628 | 1372628 | 2021-05-31 | Harvey | Kansas | 20079 | 3678 | 70 |
1374121 | 1374121 | 2021-05-31 | Colleton | South Carolina | 45029 | 3678 | 129 |
1369039 | 1369039 | 2021-05-30 | Nez Perce | Idaho | 16069 | 3678 | 55 |
1369383 | 1369383 | 2021-05-30 | Harvey | Kansas | 20079 | 3678 | 70 |
1365793 | 1365793 | 2021-05-29 | Nez Perce | Idaho | 16069 | 3678 | 55 |
1366137 | 1366137 | 2021-05-29 | Harvey | Kansas | 20079 | 3678 | 70 |
1362547 | 1362547 | 2021-05-28 | Nez Perce | Idaho | 16069 | 3678 | 55 |
1362891 | 1362891 | 2021-05-28 | Harvey | Kansas | 20079 | 3678 | 70 |
1358898 | 1358898 | 2021-05-27 | Amador | California | 6005 | 3678 | 47 |
1359300 | 1359300 | 2021-05-27 | Nez Perce | Idaho | 16069 | 3678 | 55 |
1352018 | 1352018 | 2021-05-24 | Tazewell | Virginia | 51185 | 3678 | 70 |
1348791 | 1348791 | 2021-05-23 | Douglas | Washington | 53017 | 3678 | 22 |
1292782 | 1292782 | 2021-05-06 | Polk | Oregon | 41053 | 3678 | 52 |
1247921 | 1247921 | 2021-04-22 | Titus | Texas | 48449 | 3678 | 84 |
1244150 | 1244150 | 2021-04-21 | Venango | Pennsylvania | 42121 | 3678 | 91 |
1227370 | 1227370 | 2021-04-16 | Belknap | New Hampshire | 33001 | 3678 | 96 |
1202802 | 1202802 | 2021-04-08 | Oneida | Wisconsin | 55085 | 3678 | 74 |
1198923 | 1198923 | 2021-04-07 | Henderson | Tennessee | 47077 | 3678 | 75 |
1178143 | 1178143 | 2021-04-01 | Hillsdale | Michigan | 26059 | 3678 | 79 |
1095567 | 1095567 | 2021-03-06 | Jefferson | West Virginia | 54037 | 3678 | 39 |
1086831 | 1086831 | 2021-03-04 | Plymouth | Iowa | 19149 | 3678 | 78 |
1082857 | 1082857 | 2021-03-03 | Independence | Arkansas | 5063 | 3678 | 116 |
1068912 | 1068912 | 2021-02-26 | Chester | South Carolina | 45023 | 3678 | 65 |
1061162 | 1061162 | 2021-02-24 | St. Bernard | Louisiana | 22087 | 3678 | 46 |
1062065 | 1062065 | 2021-02-24 | Brown | Ohio | 39015 | 3678 | 42 |
1028734 | 1028734 | 2021-02-14 | Penobscot | Maine | 23019 | 3678 | 76 |
1025757 | 1025757 | 2021-02-13 | Neshoba | Mississippi | 28099 | 3678 | 165 |
1016069 | 1016069 | 2021-02-10 | Camden | Missouri | 29029 | 3678 | 75 |
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);