ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where cases = 3989 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 12
- Ohio 10
- Alabama 8
- Missouri 8
- Utah 7
- Kansas 6
- Virginia 6
- Pennsylvania 5
- Washington 5
- Georgia 4
- Indiana 4
- North Carolina 4
- Oregon 4
- Texas 4
- Kentucky 3
- Puerto Rico 3
- Tennessee 3
- West Virginia 3
- Alaska 2
- Arkansas 2
- Michigan 2
- Minnesota 2
- Mississippi 2
- South Carolina 2
- California 1
- Colorado 1
- Connecticut 1
- Florida 1
- Idaho 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500473 | 2500473 | 2022-05-13 | Allen | Kansas | 20001 | 3989 | 53 |
2495964 | 2495964 | 2022-05-11 | San Juan | Utah | 49037 | 3989 | 49 |
2496010 | 2496010 | 2022-05-11 | Buckingham | Virginia | 51029 | 3989 | 56 |
2492706 | 2492706 | 2022-05-10 | San Juan | Utah | 49037 | 3989 | 49 |
2489448 | 2489448 | 2022-05-09 | San Juan | Utah | 49037 | 3989 | 49 |
2486190 | 2486190 | 2022-05-08 | San Juan | Utah | 49037 | 3989 | 49 |
2482932 | 2482932 | 2022-05-07 | San Juan | Utah | 49037 | 3989 | 49 |
2479674 | 2479674 | 2022-05-06 | San Juan | Utah | 49037 | 3989 | 49 |
2476416 | 2476416 | 2022-05-05 | San Juan | Utah | 49037 | 3989 | 49 |
2468129 | 2468129 | 2022-05-03 | Bienville | Louisiana | 22013 | 3989 | 110 |
2450450 | 2450450 | 2022-04-27 | Greene | Virginia | 51079 | 3989 | 61 |
2401609 | 2401609 | 2022-04-12 | Goochland | Virginia | 51075 | 3989 | 51 |
2398354 | 2398354 | 2022-04-11 | Goochland | Virginia | 51075 | 3989 | 51 |
2350512 | 2350512 | 2022-03-28 | Warren | Illinois | 17187 | 3989 | 85 |
2336884 | 2336884 | 2022-03-24 | Kusilvak Census Area | Alaska | 2158 | 3989 | 12 |
2337500 | 2337500 | 2022-03-24 | Warren | Illinois | 17187 | 3989 | 85 |
2333630 | 2333630 | 2022-03-23 | Kusilvak Census Area | Alaska | 2158 | 3989 | 12 |
2334217 | 2334217 | 2022-03-23 | Mercer | Illinois | 17131 | 3989 | 47 |
2285406 | 2285406 | 2022-03-08 | Jo Daviess | Illinois | 17085 | 3989 | 38 |
2282154 | 2282154 | 2022-03-07 | Jo Daviess | Illinois | 17085 | 3989 | 38 |
2270069 | 2270069 | 2022-03-03 | Morgan | Missouri | 29141 | 3989 | 101 |
2237021 | 2237021 | 2022-02-21 | Estill | Kentucky | 21065 | 3989 | 41 |
2206892 | 2206892 | 2022-02-12 | Polk | Arkansas | 5113 | 3989 | 133 |
2201006 | 2201006 | 2022-02-10 | Vermillion | Indiana | 18165 | 3989 | 69 |
2197636 | 2197636 | 2022-02-09 | Moultrie | Illinois | 17139 | 3989 | 50 |
2193722 | 2193722 | 2022-02-08 | Clay | Alabama | 1027 | 3989 | 72 |
2171232 | 2171232 | 2022-02-01 | Otero | Colorado | 8089 | 3989 | 123 |
2170824 | 2170824 | 2022-01-31 | Morgan | West Virginia | 54065 | 3989 | 58 |
2166669 | 2166669 | 2022-01-30 | Clatsop | Oregon | 41007 | 3989 | 37 |
2163414 | 2163414 | 2022-01-29 | Clatsop | Oregon | 41007 | 3989 | 37 |
2160159 | 2160159 | 2022-01-28 | Clatsop | Oregon | 41007 | 3989 | 37 |
2148893 | 2148893 | 2022-01-25 | Franklin | Indiana | 18047 | 3989 | 57 |
2102480 | 2102480 | 2022-01-10 | Brooke | West Virginia | 54009 | 3989 | 87 |
2098478 | 2098478 | 2022-01-09 | Cidra | Puerto Rico | 72041 | 3989 | |
2095706 | 2095706 | 2022-01-08 | Scurry | Texas | 48415 | 3989 | 94 |
2087022 | 2087022 | 2022-01-06 | Lawrence | Illinois | 17101 | 3989 | 47 |
2078577 | 2078577 | 2022-01-03 | Martin | North Carolina | 37117 | 3989 | 75 |
2054324 | 2054324 | 2021-12-27 | Harris | Georgia | 13145 | 3989 | 96 |
2056219 | 2056219 | 2021-12-27 | Dorado | Puerto Rico | 72051 | 3989 | |
2043881 | 2043881 | 2021-12-23 | Page | Virginia | 51139 | 3989 | 91 |
2019516 | 2019516 | 2021-12-16 | Wabasha | Minnesota | 27157 | 3989 | 11 |
1974702 | 1974702 | 2021-12-02 | Holmes | Ohio | 39075 | 3989 | 140 |
1952229 | 1952229 | 2021-11-25 | Mayaguez | Puerto Rico | 72097 | 3989 | |
1937771 | 1937771 | 2021-11-21 | Franklin | Kansas | 20059 | 3989 | 60 |
1934521 | 1934521 | 2021-11-20 | Franklin | Kansas | 20059 | 3989 | 60 |
1931270 | 1931270 | 2021-11-19 | Franklin | Kansas | 20059 | 3989 | 60 |
1929002 | 1929002 | 2021-11-18 | Anson | North Carolina | 37007 | 3989 | 82 |
1878046 | 1878046 | 2021-11-02 | Carroll | Virginia | 51035 | 3989 | 95 |
1833436 | 1833436 | 2021-10-20 | Elmore | Idaho | 16039 | 3989 | 43 |
1816478 | 1816478 | 2021-10-14 | Hancock | West Virginia | 54029 | 3989 | 108 |
1806238 | 1806238 | 2021-10-11 | Wayne | Tennessee | 47181 | 3989 | 39 |
1799181 | 1799181 | 2021-10-09 | Adams | Ohio | 39001 | 3989 | 82 |
1782466 | 1782466 | 2021-10-04 | Saline | Missouri | 29195 | 3989 | 46 |
1779216 | 1779216 | 2021-10-03 | Saline | Missouri | 29195 | 3989 | 46 |
1766907 | 1766907 | 2021-09-29 | Clarion | Pennsylvania | 42031 | 3989 | 102 |
1760863 | 1760863 | 2021-09-27 | Hockley | Texas | 48219 | 3989 | 127 |
1757615 | 1757615 | 2021-09-26 | Hockley | Texas | 48219 | 3989 | 127 |
1754367 | 1754367 | 2021-09-25 | Hockley | Texas | 48219 | 3989 | 126 |
1742513 | 1742513 | 2021-09-22 | Fayette | Illinois | 17051 | 3989 | 59 |
1704788 | 1704788 | 2021-09-10 | Otsego | New York | 36077 | 3989 | 49 |
1692987 | 1692987 | 2021-09-06 | Kittitas | Washington | 53037 | 3989 | 41 |
1689738 | 1689738 | 2021-09-05 | Kittitas | Washington | 53037 | 3989 | 41 |
1686488 | 1686488 | 2021-09-04 | Kittitas | Washington | 53037 | 3989 | 41 |
1683237 | 1683237 | 2021-09-03 | Kittitas | Washington | 53037 | 3989 | 41 |
1670469 | 1670469 | 2021-08-31 | Pike | Alabama | 1109 | 3989 | 84 |
1669289 | 1669289 | 2021-08-30 | Ottawa | Ohio | 39123 | 3989 | 83 |
1649232 | 1649232 | 2021-08-24 | Lafayette | Missouri | 29107 | 3989 | 62 |
1606469 | 1606469 | 2021-08-11 | Calloway | Kentucky | 21035 | 3989 | 51 |
1601060 | 1601060 | 2021-08-09 | Logan | Ohio | 39091 | 3989 | 79 |
1496611 | 1496611 | 2021-07-08 | Polk | Missouri | 29167 | 3989 | 42 |
1492766 | 1492766 | 2021-07-07 | Seward | Kansas | 20175 | 3989 | 42 |
1489519 | 1489519 | 2021-07-06 | Seward | Kansas | 20175 | 3989 | 42 |
1459977 | 1459977 | 2021-06-27 | Logan | Illinois | 17107 | 3989 | 77 |
1456732 | 1456732 | 2021-06-26 | Logan | Illinois | 17107 | 3989 | 77 |
1457656 | 1457656 | 2021-06-26 | Phelps | Missouri | 29161 | 3989 | 131 |
1453487 | 1453487 | 2021-06-25 | Logan | Illinois | 17107 | 3989 | 77 |
1435612 | 1435612 | 2021-06-19 | Polk | Oregon | 41053 | 3989 | 56 |
1391192 | 1391192 | 2021-06-06 | Escambia | Alabama | 1053 | 3989 | 79 |
1387947 | 1387947 | 2021-06-05 | Escambia | Alabama | 1053 | 3989 | 79 |
1384702 | 1384702 | 2021-06-04 | Escambia | Alabama | 1053 | 3989 | 79 |
1374006 | 1374006 | 2021-05-31 | Pike | Pennsylvania | 42103 | 3989 | 54 |
1370761 | 1370761 | 2021-05-30 | Pike | Pennsylvania | 42103 | 3989 | 54 |
1357530 | 1357530 | 2021-05-26 | Brown | Ohio | 39015 | 3989 | 59 |
1354284 | 1354284 | 2021-05-25 | Brown | Ohio | 39015 | 3989 | 59 |
1350427 | 1350427 | 2021-05-24 | Lincoln | Mississippi | 28085 | 3989 | 111 |
1351038 | 1351038 | 2021-05-24 | Brown | Ohio | 39015 | 3989 | 58 |
1330282 | 1330282 | 2021-05-18 | Whitley | Indiana | 18183 | 3989 | 39 |
1318578 | 1318578 | 2021-05-14 | Crawford | Ohio | 39033 | 3989 | 107 |
1282779 | 1282779 | 2021-05-03 | Stokes | North Carolina | 37169 | 3989 | 80 |
1238759 | 1238759 | 2021-04-20 | Union | Arkansas | 5139 | 3989 | 112 |
1195194 | 1195194 | 2021-04-06 | Fulton | Ohio | 39051 | 3989 | 64 |
1195535 | 1195535 | 2021-04-06 | Chester | South Carolina | 45023 | 3989 | 71 |
1136168 | 1136168 | 2021-03-19 | Camden | Missouri | 29029 | 3989 | 83 |
1108925 | 1108925 | 2021-03-11 | Tuolumne | California | 6109 | 3989 | 59 |
1082735 | 1082735 | 2021-03-03 | Covington | Alabama | 1039 | 3989 | 106 |
1081598 | 1081598 | 2021-03-02 | Putnam | Ohio | 39137 | 3989 | 90 |
1077686 | 1077686 | 2021-03-01 | Monroe | Mississippi | 28095 | 3989 | 126 |
1078697 | 1078697 | 2021-03-01 | Codington | South Dakota | 46029 | 3989 | 77 |
1078764 | 1078764 | 2021-03-01 | Cocke | Tennessee | 47029 | 3989 | 93 |
1069762 | 1069762 | 2021-02-27 | Franklin | Alabama | 1059 | 3989 | 77 |
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);