ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where cases = 3438 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 14
- Texas 13
- Missouri 10
- Florida 9
- Georgia 7
- Indiana 7
- Minnesota 7
- Alabama 6
- Tennessee 6
- Arkansas 5
- North Carolina 5
- Ohio 5
- Virginia 5
- West Virginia 5
- South Carolina 4
- Colorado 3
- Illinois 3
- Pennsylvania 3
- Wisconsin 3
- Alaska 2
- California 2
- Iowa 2
- Louisiana 2
- Mississippi 2
- New Mexico 2
- New York 2
- Oregon 2
- Washington 2
- Idaho 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444905 | 2444905 | 2022-04-26 | Washington | Illinois | 17189 | 3438 | 41 |
2360807 | 2360807 | 2022-03-31 | Dukes | Massachusetts | 25007 | 3438 | 0 |
2291535 | 2291535 | 2022-03-10 | Grand | Colorado | 8049 | 3438 | 23 |
2294136 | 2294136 | 2022-03-10 | Wilbarger | Texas | 48487 | 3438 | 86 |
2290884 | 2290884 | 2022-03-09 | Wilbarger | Texas | 48487 | 3438 | 86 |
2287632 | 2287632 | 2022-03-08 | Wilbarger | Texas | 48487 | 3438 | 86 |
2284380 | 2284380 | 2022-03-07 | Wilbarger | Texas | 48487 | 3438 | 86 |
2275186 | 2275186 | 2022-03-05 | Van Buren | Arkansas | 5141 | 3438 | 57 |
2256891 | 2256891 | 2022-02-27 | Sibley | Minnesota | 27143 | 3438 | 23 |
2253640 | 2253640 | 2022-02-26 | Sibley | Minnesota | 27143 | 3438 | 23 |
2250389 | 2250389 | 2022-02-25 | Sibley | Minnesota | 27143 | 3438 | 23 |
2233803 | 2233803 | 2022-02-20 | Leslie | Kentucky | 21131 | 3438 | 39 |
2230552 | 2230552 | 2022-02-19 | Leslie | Kentucky | 21131 | 3438 | 39 |
2227301 | 2227301 | 2022-02-18 | Leslie | Kentucky | 21131 | 3438 | 39 |
2226004 | 2226004 | 2022-02-17 | Patrick | Virginia | 51141 | 3438 | 83 |
2191532 | 2191532 | 2022-02-07 | Magoffin | Kentucky | 21153 | 3438 | 37 |
2191849 | 2191849 | 2022-02-07 | Renville | Minnesota | 27129 | 3438 | 54 |
2155302 | 2155302 | 2022-01-27 | Greene | Illinois | 17061 | 3438 | 55 |
2138445 | 2138445 | 2022-01-22 | Macon | Alabama | 1087 | 3438 | 69 |
2123215 | 2123215 | 2022-01-17 | Mason | Kentucky | 21161 | 3438 | 85 |
2119963 | 2119963 | 2022-01-16 | Mason | Kentucky | 21161 | 3438 | 85 |
2116711 | 2116711 | 2022-01-15 | Mason | Kentucky | 21161 | 3438 | 85 |
2113460 | 2113460 | 2022-01-14 | Mason | Kentucky | 21161 | 3438 | 85 |
2103668 | 2103668 | 2022-01-11 | Garrard | Kentucky | 21079 | 3438 | 61 |
2099151 | 2099151 | 2022-01-09 | Prince Edward | Virginia | 51147 | 3438 | 54 |
2095900 | 2095900 | 2022-01-08 | Prince Edward | Virginia | 51147 | 3438 | 54 |
2092648 | 2092648 | 2022-01-07 | Prince Edward | Virginia | 51147 | 3438 | 54 |
2085886 | 2085886 | 2022-01-05 | Lavaca | Texas | 48285 | 3438 | 100 |
2082618 | 2082618 | 2022-01-04 | Jones | Texas | 48253 | 3438 | 80 |
2078374 | 2078374 | 2022-01-03 | Washington | Nebraska | 31177 | 3438 | 30 |
2019716 | 2019716 | 2021-12-16 | Texas | Missouri | 29215 | 3438 | 68 |
1986093 | 1986093 | 2021-12-06 | Mitchell | Georgia | 13205 | 3438 | 101 |
1969022 | 1969022 | 2021-11-30 | Orleans | Vermont | 50019 | 3438 | 25 |
1924005 | 1924005 | 2021-11-17 | Ouachita | Arkansas | 5103 | 3438 | 85 |
1918751 | 1918751 | 2021-11-15 | Wabasha | Minnesota | 27157 | 3438 | 9 |
1920457 | 1920457 | 2021-11-15 | Hampshire | West Virginia | 54027 | 3438 | 49 |
1903247 | 1903247 | 2021-11-10 | Wyandot | Ohio | 39175 | 3438 | 64 |
1903781 | 1903781 | 2021-11-10 | Deaf Smith | Texas | 48117 | 3438 | 79 |
1900531 | 1900531 | 2021-11-09 | Deaf Smith | Texas | 48117 | 3438 | 79 |
1882374 | 1882374 | 2021-11-04 | Spencer | Indiana | 18147 | 3438 | 46 |
1878105 | 1878105 | 2021-11-02 | Mecklenburg | Virginia | 51117 | 3438 | 84 |
1837229 | 1837229 | 2021-10-21 | Woodford | Kentucky | 21239 | 3438 | 27 |
1812649 | 1812649 | 2021-10-13 | Bledsoe | Tennessee | 47007 | 3438 | 17 |
1803693 | 1803693 | 2021-10-11 | Juneau City and Borough | Alaska | 2110 | 3438 | 7 |
1786368 | 1786368 | 2021-10-05 | Jefferson | Oregon | 41031 | 3438 | 49 |
1780179 | 1780179 | 2021-10-03 | Fentress | Tennessee | 47049 | 3438 | 60 |
1776929 | 1776929 | 2021-10-02 | Fentress | Tennessee | 47049 | 3438 | 60 |
1773679 | 1773679 | 2021-10-01 | Fentress | Tennessee | 47049 | 3438 | 60 |
1758390 | 1758390 | 2021-09-27 | Delta | Colorado | 8029 | 3438 | 79 |
1756406 | 1756406 | 2021-09-26 | Crawford | Missouri | 29055 | 3438 | 51 |
1744174 | 1744174 | 2021-09-22 | Elk | Pennsylvania | 42047 | 3438 | 47 |
1719723 | 1719723 | 2021-09-15 | Jefferson | Idaho | 16051 | 3438 | 33 |
1689103 | 1689103 | 2021-09-05 | Jasper | South Carolina | 45053 | 3438 | 57 |
1685853 | 1685853 | 2021-09-04 | Jasper | South Carolina | 45053 | 3438 | 57 |
1682602 | 1682602 | 2021-09-03 | Jasper | South Carolina | 45053 | 3438 | 57 |
1656099 | 1656099 | 2021-08-26 | Cherokee | North Carolina | 37039 | 3438 | 39 |
1582851 | 1582851 | 2021-08-04 | Jackson | Arkansas | 5067 | 3438 | 38 |
1564339 | 1564339 | 2021-07-29 | Allen | Louisiana | 22003 | 3438 | 94 |
1565047 | 1565047 | 2021-07-29 | Luna | New Mexico | 35029 | 3438 | 92 |
1556343 | 1556343 | 2021-07-26 | Willacy | Texas | 48489 | 3438 | 93 |
1553096 | 1553096 | 2021-07-25 | Willacy | Texas | 48489 | 3438 | 93 |
1518100 | 1518100 | 2021-07-15 | Hardee | Florida | 12049 | 3438 | 45 |
1514853 | 1514853 | 2021-07-14 | Hardee | Florida | 12049 | 3438 | 45 |
1511607 | 1511607 | 2021-07-13 | Hardee | Florida | 12049 | 3438 | 45 |
1508360 | 1508360 | 2021-07-12 | Hardee | Florida | 12049 | 3438 | 45 |
1505114 | 1505114 | 2021-07-11 | Hardee | Florida | 12049 | 3438 | 45 |
1501868 | 1501868 | 2021-07-10 | Hardee | Florida | 12049 | 3438 | 45 |
1498622 | 1498622 | 2021-07-09 | Hardee | Florida | 12049 | 3438 | 45 |
1493265 | 1493265 | 2021-07-07 | Tate | Mississippi | 28137 | 3438 | 88 |
1420902 | 1420902 | 2021-06-15 | Toombs | Georgia | 13279 | 3438 | 115 |
1419198 | 1419198 | 2021-06-14 | Champaign | Ohio | 39021 | 3438 | 58 |
1415856 | 1415856 | 2021-06-13 | Pasquotank | North Carolina | 37139 | 3438 | 85 |
1412610 | 1412610 | 2021-06-12 | Pasquotank | North Carolina | 37139 | 3438 | 85 |
1409365 | 1409365 | 2021-06-11 | Pasquotank | North Carolina | 37139 | 3438 | 85 |
1373274 | 1373274 | 2021-05-31 | Polk | Missouri | 29167 | 3438 | 40 |
1370029 | 1370029 | 2021-05-30 | Polk | Missouri | 29167 | 3438 | 40 |
1366783 | 1366783 | 2021-05-29 | Polk | Missouri | 29167 | 3438 | 40 |
1363537 | 1363537 | 2021-05-28 | Polk | Missouri | 29167 | 3438 | 40 |
1360591 | 1360591 | 2021-05-27 | Otsego | New York | 36077 | 3438 | 47 |
1361157 | 1361157 | 2021-05-27 | Marlboro | South Carolina | 45069 | 3438 | 56 |
1332920 | 1332920 | 2021-05-19 | Yell | Arkansas | 5149 | 3438 | 65 |
1329673 | 1329673 | 2021-05-18 | Yell | Arkansas | 5149 | 3438 | 65 |
1331633 | 1331633 | 2021-05-18 | Williams | Ohio | 39171 | 3438 | 77 |
1317512 | 1317512 | 2021-05-14 | Boyle | Kentucky | 21021 | 3438 | 70 |
1313114 | 1313114 | 2021-05-12 | Fayette | West Virginia | 54019 | 3438 | 76 |
1304849 | 1304849 | 2021-05-10 | Carlton | Minnesota | 27017 | 3438 | 53 |
1271252 | 1271252 | 2021-04-30 | Lake | California | 6033 | 3438 | 43 |
1261844 | 1261844 | 2021-04-27 | Upson | Georgia | 13293 | 3438 | 126 |
1256397 | 1256397 | 2021-04-25 | Pulaski | Missouri | 29169 | 3438 | 51 |
1253150 | 1253150 | 2021-04-24 | Pulaski | Missouri | 29169 | 3438 | 51 |
1250219 | 1250219 | 2021-04-23 | Warren | New York | 36113 | 3438 | 57 |
1250570 | 1250570 | 2021-04-23 | Malheur | Oregon | 41045 | 3438 | 59 |
1223045 | 1223045 | 2021-04-15 | Adams | Indiana | 18001 | 3438 | 53 |
1219797 | 1219797 | 2021-04-14 | Adams | Indiana | 18001 | 3438 | 53 |
1197144 | 1197144 | 2021-04-07 | Wabash | Indiana | 18169 | 3438 | 77 |
1197584 | 1197584 | 2021-04-07 | Worcester | Maryland | 24047 | 3438 | 94 |
1191956 | 1191956 | 2021-04-05 | Highland | Ohio | 39071 | 3438 | 58 |
1192423 | 1192423 | 2021-04-05 | Hardin | Tennessee | 47071 | 3438 | 66 |
1164899 | 1164899 | 2021-03-28 | Calloway | Kentucky | 21035 | 3438 | 47 |
1161651 | 1161651 | 2021-03-27 | Calloway | Kentucky | 21035 | 3438 | 47 |
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);