ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 4914 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 14
- Kentucky 13
- South Carolina 6
- Maine 5
- New York 5
- Georgia 4
- Indiana 4
- Missouri 4
- Virginia 4
- Alabama 3
- Illinois 3
- Minnesota 3
- North Carolina 3
- Ohio 3
- Washington 3
- Kansas 2
- Massachusetts 2
- Michigan 2
- Puerto Rico 2
- South Dakota 2
- Texas 2
- Utah 2
- Arkansas 1
- California 1
- Louisiana 1
- Mississippi 1
- Nebraska 1
- New Mexico 1
- Pennsylvania 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461569 | 2461569 | 2022-05-01 | Mason | Kentucky | 21161 | 4914 | 104 |
2463449 | 2463449 | 2022-05-01 | Colonial Heights city | Virginia | 51570 | 4914 | 97 |
2458313 | 2458313 | 2022-04-30 | Mason | Kentucky | 21161 | 4914 | 104 |
2460193 | 2460193 | 2022-04-30 | Colonial Heights city | Virginia | 51570 | 4914 | 97 |
2455057 | 2455057 | 2022-04-29 | Mason | Kentucky | 21161 | 4914 | 104 |
2456937 | 2456937 | 2022-04-29 | Colonial Heights city | Virginia | 51570 | 4914 | 97 |
2451801 | 2451801 | 2022-04-28 | Mason | Kentucky | 21161 | 4914 | 104 |
2448545 | 2448545 | 2022-04-27 | Mason | Kentucky | 21161 | 4914 | 104 |
2445289 | 2445289 | 2022-04-26 | Mason | Kentucky | 21161 | 4914 | 104 |
2442033 | 2442033 | 2022-04-25 | Mason | Kentucky | 21161 | 4914 | 104 |
2440763 | 2440763 | 2022-04-24 | Adams | Washington | 53001 | 4914 | 38 |
2437507 | 2437507 | 2022-04-23 | Adams | Washington | 53001 | 4914 | 38 |
2434251 | 2434251 | 2022-04-22 | Adams | Washington | 53001 | 4914 | 38 |
2399355 | 2399355 | 2022-04-12 | Fulton | Indiana | 18049 | 4914 | 102 |
2396100 | 2396100 | 2022-04-11 | Fulton | Indiana | 18049 | 4914 | 102 |
2353797 | 2353797 | 2022-03-29 | Fulton | Indiana | 18049 | 4914 | 102 |
2331652 | 2331652 | 2022-03-22 | Hubbard | Minnesota | 27057 | 4914 | 59 |
2328400 | 2328400 | 2022-03-21 | Hubbard | Minnesota | 27057 | 4914 | 59 |
2311177 | 2311177 | 2022-03-16 | Berrien | Georgia | 13019 | 4914 | 81 |
2307924 | 2307924 | 2022-03-15 | Berrien | Georgia | 13019 | 4914 | 80 |
2305471 | 2305471 | 2022-03-14 | Sagadahoc | Maine | 23023 | 4914 | 28 |
2302219 | 2302219 | 2022-03-13 | Sagadahoc | Maine | 23023 | 4914 | 28 |
2298967 | 2298967 | 2022-03-12 | Sagadahoc | Maine | 23023 | 4914 | 28 |
2289211 | 2289211 | 2022-03-09 | Sagadahoc | Maine | 23023 | 4914 | 28 |
2285960 | 2285960 | 2022-03-08 | Sagadahoc | Maine | 23023 | 4914 | 28 |
2276895 | 2276895 | 2022-03-05 | Schoharie | New York | 36095 | 4914 | 34 |
2223998 | 2223998 | 2022-02-17 | Breckinridge | Kentucky | 21027 | 4914 | 65 |
2221569 | 2221569 | 2022-02-16 | Roosevelt | New Mexico | 35041 | 4914 | 91 |
2200094 | 2200094 | 2022-02-09 | McDowell | West Virginia | 54047 | 4914 | 60 |
2148290 | 2148290 | 2022-01-25 | Conway | Arkansas | 5029 | 4914 | 50 |
2149273 | 2149273 | 2022-01-25 | Simpson | Kentucky | 21213 | 4914 | 76 |
2111536 | 2111536 | 2022-01-13 | Vega Alta | Puerto Rico | 72143 | 4914 | |
2096127 | 2096127 | 2022-01-09 | Bibb | Alabama | 1007 | 4914 | 95 |
2060372 | 2060372 | 2021-12-29 | Clarke | Alabama | 1025 | 4914 | 88 |
2035597 | 2035597 | 2021-12-21 | Franklin | Massachusetts | 25011 | 4914 | 128 |
2007568 | 2007568 | 2021-12-12 | Union | South Carolina | 45087 | 4914 | 112 |
2004317 | 2004317 | 2021-12-11 | Union | South Carolina | 45087 | 4914 | 112 |
2001066 | 2001066 | 2021-12-10 | Union | South Carolina | 45087 | 4914 | 112 |
1968612 | 1968612 | 2021-11-30 | Meade | South Dakota | 46093 | 4914 | 52 |
1964336 | 1964336 | 2021-11-29 | Tippah | Mississippi | 28139 | 4914 | 82 |
1895249 | 1895249 | 2021-11-08 | Lee | Illinois | 17103 | 4914 | 103 |
1876374 | 1876374 | 2021-11-02 | Huron | Michigan | 26063 | 4914 | 96 |
1873125 | 1873125 | 2021-11-01 | Huron | Michigan | 26063 | 4914 | 96 |
1832512 | 1832512 | 2021-10-19 | Uintah | Utah | 49047 | 4914 | 43 |
1814021 | 1814021 | 2021-10-14 | Logan | Illinois | 17107 | 4914 | 87 |
1805690 | 1805690 | 2021-10-11 | Champaign | Ohio | 39021 | 4914 | 66 |
1800414 | 1800414 | 2021-10-10 | Marion | Alabama | 1093 | 4914 | 126 |
1739649 | 1739649 | 2021-09-21 | Boyle | Kentucky | 21021 | 4914 | 80 |
1698319 | 1698319 | 2021-09-08 | Bladen | North Carolina | 37017 | 4914 | 84 |
1695071 | 1695071 | 2021-09-07 | Bladen | North Carolina | 37017 | 4914 | 82 |
1688530 | 1688530 | 2021-09-05 | Livingston | New York | 36051 | 4914 | 61 |
1565140 | 1565140 | 2021-07-29 | Chatham | North Carolina | 37037 | 4914 | 89 |
1557581 | 1557581 | 2021-07-27 | Marshall | Iowa | 19127 | 4914 | 79 |
1554334 | 1554334 | 2021-07-26 | Marshall | Iowa | 19127 | 4914 | 79 |
1551087 | 1551087 | 2021-07-25 | Marshall | Iowa | 19127 | 4914 | 79 |
1547840 | 1547840 | 2021-07-24 | Marshall | Iowa | 19127 | 4914 | 79 |
1544593 | 1544593 | 2021-07-23 | Marshall | Iowa | 19127 | 4914 | 79 |
1541345 | 1541345 | 2021-07-22 | Marshall | Iowa | 19127 | 4914 | 79 |
1538098 | 1538098 | 2021-07-21 | Marshall | Iowa | 19127 | 4914 | 79 |
1523403 | 1523403 | 2021-07-16 | Toa Baja | Puerto Rico | 72137 | 4914 | |
1474952 | 1474952 | 2021-07-01 | Burnet | Texas | 48053 | 4914 | 67 |
1445523 | 1445523 | 2021-06-22 | Chesterfield | South Carolina | 45025 | 4914 | 107 |
1442278 | 1442278 | 2021-06-21 | Chesterfield | South Carolina | 45025 | 4914 | 107 |
1332713 | 1332713 | 2021-05-18 | Campbell | Wyoming | 56005 | 4914 | 60 |
1307851 | 1307851 | 2021-05-11 | Nelson | Kentucky | 21179 | 4914 | 55 |
1300795 | 1300795 | 2021-05-09 | Tift | Georgia | 13277 | 4914 | 126 |
1298139 | 1298139 | 2021-05-08 | Whitley | Kentucky | 21235 | 4914 | 55 |
1278553 | 1278553 | 2021-05-02 | Boyd | Kentucky | 21019 | 4914 | 73 |
1273500 | 1273500 | 2021-04-30 | Newberry | South Carolina | 45071 | 4914 | 101 |
1266251 | 1266251 | 2021-04-28 | Dodge | Nebraska | 31053 | 4914 | 60 |
1263967 | 1263967 | 2021-04-27 | Chambers | Texas | 48071 | 4914 | 49 |
1259571 | 1259571 | 2021-04-26 | Callaway | Missouri | 29027 | 4914 | 47 |
1256324 | 1256324 | 2021-04-25 | Callaway | Missouri | 29027 | 4914 | 47 |
1252062 | 1252062 | 2021-04-24 | Murray | Georgia | 13213 | 4914 | 83 |
1249830 | 1249830 | 2021-04-23 | Callaway | Missouri | 29027 | 4914 | 47 |
1204364 | 1204364 | 2021-04-09 | Callaway | Missouri | 29027 | 4914 | 47 |
1162767 | 1162767 | 2021-03-27 | Seneca | Ohio | 39147 | 4914 | 113 |
1148522 | 1148522 | 2021-03-23 | Sioux | Iowa | 19167 | 4914 | 69 |
1114808 | 1114808 | 2021-03-12 | Box Elder | Utah | 49003 | 4914 | 47 |
1096877 | 1096877 | 2021-03-07 | Vermilion | Louisiana | 22113 | 4914 | 107 |
1081734 | 1081734 | 2021-03-02 | Armstrong | Pennsylvania | 42005 | 4914 | 116 |
1060815 | 1060815 | 2021-02-24 | Clinton | Iowa | 19045 | 4914 | 83 |
1057569 | 1057569 | 2021-02-23 | Clinton | Iowa | 19045 | 4914 | 83 |
1054323 | 1054323 | 2021-02-22 | Clinton | Iowa | 19045 | 4914 | 83 |
1051076 | 1051076 | 2021-02-21 | Clinton | Iowa | 19045 | 4914 | 82 |
1047829 | 1047829 | 2021-02-20 | Clinton | Iowa | 19045 | 4914 | 82 |
1044584 | 1044584 | 2021-02-19 | Clinton | Iowa | 19045 | 4914 | 82 |
997147 | 997147 | 2021-02-04 | Ashtabula | Ohio | 39007 | 4914 | 80 |
989206 | 989206 | 2021-02-02 | Coles | Illinois | 17029 | 4914 | 88 |
974253 | 974253 | 2021-01-28 | Steuben | New York | 36101 | 4914 | 133 |
969834 | 969834 | 2021-01-27 | Dearborn | Indiana | 18029 | 4914 | 47 |
970460 | 970460 | 2021-01-27 | Crow Wing | Minnesota | 27035 | 4914 | 78 |
945035 | 945035 | 2021-01-19 | Oswego | New York | 36075 | 4914 | 69 |
830491 | 830491 | 2020-12-15 | Ford | Kansas | 20057 | 4914 | 10 |
827245 | 827245 | 2020-12-14 | Ford | Kansas | 20057 | 4914 | 10 |
689305 | 689305 | 2020-11-01 | Pennington | South Dakota | 46103 | 4914 | 48 |
503924 | 503924 | 2020-09-05 | Dutchess | New York | 36027 | 4914 | 153 |
376035 | 376035 | 2020-07-27 | Loudoun | Virginia | 51107 | 4914 | 106 |
184804 | 184804 | 2020-05-28 | San Bernardino | California | 6071 | 4914 | 190 |
68473 | 68473 | 2020-04-18 | Essex | Massachusetts | 25009 | 4914 | 194 |
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);