ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where cases = 3853 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 7
- Oklahoma 7
- Michigan 6
- Pennsylvania 6
- Tennessee 6
- Virginia 6
- Missouri 5
- Washington 5
- Wisconsin 5
- Arkansas 4
- California 4
- Colorado 4
- Georgia 4
- Minnesota 4
- Alaska 3
- Illinois 3
- Kansas 3
- North Carolina 3
- Oregon 3
- Puerto Rico 3
- Texas 3
- Wyoming 3
- Alabama 2
- Idaho 2
- Ohio 2
- Utah 2
- Connecticut 1
- Iowa 1
- Louisiana 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489744 | 2489744 | 2022-05-09 | Marquette | Wisconsin | 55077 | 3853 | 61 |
2395328 | 2395328 | 2022-04-10 | Richland | Wisconsin | 55103 | 3853 | 47 |
2392072 | 2392072 | 2022-04-09 | Richland | Wisconsin | 55103 | 3853 | 47 |
2388816 | 2388816 | 2022-04-08 | Richland | Wisconsin | 55103 | 3853 | 47 |
2359269 | 2359269 | 2022-03-30 | Buckingham | Virginia | 51029 | 3853 | 56 |
2330339 | 2330339 | 2022-03-22 | Macon | Alabama | 1087 | 3853 | 82 |
2281034 | 2281034 | 2022-03-06 | Llano | Texas | 48299 | 3853 | 96 |
2233675 | 2233675 | 2022-02-20 | Jackson | Kansas | 20085 | 3853 | 27 |
2230424 | 2230424 | 2022-02-19 | Jackson | Kansas | 20085 | 3853 | 27 |
2227173 | 2227173 | 2022-02-18 | Jackson | Kansas | 20085 | 3853 | 27 |
2220202 | 2220202 | 2022-02-16 | Jeff Davis | Georgia | 13161 | 3853 | 66 |
2216249 | 2216249 | 2022-02-14 | Nottoway | Virginia | 51135 | 3853 | 78 |
2180327 | 2180327 | 2022-02-03 | Zavala | Texas | 48507 | 3853 | 59 |
2127701 | 2127701 | 2022-01-18 | Montour | Pennsylvania | 42093 | 3853 | 83 |
2127884 | 2127884 | 2022-01-18 | Hughes | South Dakota | 46065 | 3853 | 58 |
2124521 | 2124521 | 2022-01-17 | Morovis | Puerto Rico | 72101 | 3853 | |
2103885 | 2103885 | 2022-01-11 | Charlevoix | Michigan | 26029 | 3853 | 53 |
2100634 | 2100634 | 2022-01-10 | Charlevoix | Michigan | 26029 | 3853 | 53 |
2088719 | 2088719 | 2022-01-06 | Cayey | Puerto Rico | 72035 | 3853 | |
2082907 | 2082907 | 2022-01-04 | Scott | Virginia | 51169 | 3853 | 92 |
1987127 | 1987127 | 2021-12-06 | Crawford | Missouri | 29055 | 3853 | 74 |
1956636 | 1956636 | 2021-11-27 | Montezuma | Colorado | 8083 | 3853 | 47 |
1953385 | 1953385 | 2021-11-26 | Montezuma | Colorado | 8083 | 3853 | 47 |
1950134 | 1950134 | 2021-11-25 | Montezuma | Colorado | 8083 | 3853 | 47 |
1939419 | 1939419 | 2021-11-21 | Johnson | Tennessee | 47091 | 3853 | 52 |
1936169 | 1936169 | 2021-11-20 | Johnson | Tennessee | 47091 | 3853 | 52 |
1932919 | 1932919 | 2021-11-19 | Johnson | Tennessee | 47091 | 3853 | 52 |
1878345 | 1878345 | 2021-11-02 | Uinta | Wyoming | 56041 | 3853 | 27 |
1859427 | 1859427 | 2021-10-28 | Cassia | Idaho | 16031 | 3853 | 36 |
1858544 | 1858544 | 2021-10-27 | Botetourt | Virginia | 51023 | 3853 | 46 |
1837475 | 1837475 | 2021-10-21 | Le Sueur | Minnesota | 27079 | 3853 | 32 |
1832757 | 1832757 | 2021-10-19 | Upshur | West Virginia | 54097 | 3853 | 58 |
1716478 | 1716478 | 2021-09-14 | Latah | Idaho | 16057 | 3853 | 20 |
1703048 | 1703048 | 2021-09-10 | Jackson | Arkansas | 5067 | 3853 | 41 |
1699307 | 1699307 | 2021-09-08 | Uintah | Utah | 49047 | 3853 | 32 |
1667313 | 1667313 | 2021-08-30 | Johnson | Arkansas | 5071 | 3853 | 48 |
1666997 | 1666997 | 2021-08-29 | Kittitas | Washington | 53037 | 3853 | 40 |
1663749 | 1663749 | 2021-08-28 | Kittitas | Washington | 53037 | 3853 | 40 |
1660501 | 1660501 | 2021-08-27 | Kittitas | Washington | 53037 | 3853 | 40 |
1655370 | 1655370 | 2021-08-26 | Oxford | Maine | 23017 | 3853 | 71 |
1642597 | 1642597 | 2021-08-22 | Adams | Mississippi | 28001 | 3853 | 98 |
1639347 | 1639347 | 2021-08-21 | Adams | Mississippi | 28001 | 3853 | 98 |
1636097 | 1636097 | 2021-08-20 | Adams | Mississippi | 28001 | 3853 | 98 |
1598242 | 1598242 | 2021-08-08 | Carroll | Tennessee | 47017 | 3853 | 84 |
1594993 | 1594993 | 2021-08-07 | Carroll | Tennessee | 47017 | 3853 | 84 |
1591744 | 1591744 | 2021-08-06 | Carroll | Tennessee | 47017 | 3853 | 84 |
1588360 | 1588360 | 2021-08-05 | Trujillo Alto | Puerto Rico | 72139 | 3853 | |
1565523 | 1565523 | 2021-07-29 | McKean | Pennsylvania | 42083 | 3853 | 75 |
1540790 | 1540790 | 2021-07-22 | Summit | Colorado | 8117 | 3853 | 8 |
1540483 | 1540483 | 2021-07-21 | Teton | Wyoming | 56039 | 3853 | 11 |
1537059 | 1537059 | 2021-07-20 | Douglas | Washington | 53017 | 3853 | 23 |
1495640 | 1495640 | 2021-07-08 | Christian | Illinois | 17021 | 3853 | 93 |
1477861 | 1477861 | 2021-07-02 | Perry | Pennsylvania | 42099 | 3853 | 101 |
1474615 | 1474615 | 2021-07-01 | Perry | Pennsylvania | 42099 | 3853 | 101 |
1445300 | 1445300 | 2021-06-22 | Okmulgee | Oklahoma | 40111 | 3853 | 83 |
1442055 | 1442055 | 2021-06-21 | Okmulgee | Oklahoma | 40111 | 3853 | 83 |
1438810 | 1438810 | 2021-06-20 | Okmulgee | Oklahoma | 40111 | 3853 | 83 |
1435563 | 1435563 | 2021-06-19 | Okmulgee | Oklahoma | 40111 | 3853 | 83 |
1432316 | 1432316 | 2021-06-18 | Okmulgee | Oklahoma | 40111 | 3853 | 83 |
1429070 | 1429070 | 2021-06-17 | Okmulgee | Oklahoma | 40111 | 3853 | 83 |
1425825 | 1425825 | 2021-06-16 | Okmulgee | Oklahoma | 40111 | 3853 | 83 |
1382758 | 1382758 | 2021-06-03 | Becker | Minnesota | 27005 | 3853 | 55 |
1360962 | 1360962 | 2021-05-27 | Polk | Oregon | 41053 | 3853 | 53 |
1339343 | 1339343 | 2021-05-21 | Boone | Arkansas | 5009 | 3853 | 80 |
1318080 | 1318080 | 2021-05-14 | Phelps | Missouri | 29161 | 3853 | 130 |
1308339 | 1308339 | 2021-05-11 | Phelps | Missouri | 29161 | 3853 | 130 |
1304169 | 1304169 | 2021-05-10 | Logan | Illinois | 17107 | 3853 | 70 |
1302592 | 1302592 | 2021-05-09 | Venango | Pennsylvania | 42121 | 3853 | 93 |
1299336 | 1299336 | 2021-05-08 | Pike | Pennsylvania | 42103 | 3853 | 54 |
1238650 | 1238650 | 2021-04-20 | Bethel Census Area | Alaska | 2050 | 3853 | 20 |
1235403 | 1235403 | 2021-04-19 | Bethel Census Area | Alaska | 2050 | 3853 | 20 |
1180527 | 1180527 | 2021-04-02 | Camden | Georgia | 13039 | 3853 | 31 |
1178328 | 1178328 | 2021-04-01 | Lincoln | Mississippi | 28085 | 3853 | 107 |
1174493 | 1174493 | 2021-03-31 | Plymouth | Iowa | 19149 | 3853 | 79 |
1176483 | 1176483 | 2021-03-31 | Waller | Texas | 48473 | 3853 | 45 |
1173472 | 1173472 | 2021-03-30 | Whitman | Washington | 53075 | 3853 | 46 |
1144894 | 1144894 | 2021-03-22 | Oconee | Georgia | 13219 | 3853 | 65 |
1147435 | 1147435 | 2021-03-22 | Shenandoah | Virginia | 51171 | 3853 | 127 |
1127178 | 1127178 | 2021-03-16 | Yamhill | Oregon | 41071 | 3853 | 69 |
1123932 | 1123932 | 2021-03-15 | Yamhill | Oregon | 41071 | 3853 | 69 |
1102188 | 1102188 | 2021-03-08 | Sweetwater | Wyoming | 56037 | 3853 | 36 |
1068227 | 1068227 | 2021-02-26 | Platte | Nebraska | 31141 | 3853 | 47 |
1061377 | 1061377 | 2021-02-24 | Nobles | Minnesota | 27105 | 3853 | 47 |
1055504 | 1055504 | 2021-02-22 | Watauga | North Carolina | 37189 | 3853 | 29 |
1034272 | 1034272 | 2021-02-16 | Tuolumne | California | 6109 | 3853 | 55 |
1037230 | 1037230 | 2021-02-16 | Polk | Wisconsin | 55095 | 3853 | 45 |
1000324 | 1000324 | 2021-02-05 | Vance | North Carolina | 37181 | 3853 | 75 |
1001284 | 1001284 | 2021-02-05 | Culpeper | Virginia | 51047 | 3853 | 36 |
988621 | 988621 | 2021-02-02 | Franklin | Alabama | 1059 | 3853 | 60 |
983269 | 983269 | 2021-01-31 | St. Mary | Louisiana | 22101 | 3853 | 113 |
973833 | 973833 | 2021-01-28 | Pontotoc | Mississippi | 28115 | 3853 | 62 |
959460 | 959460 | 2021-01-24 | Kenai Peninsula Borough | Alaska | 2122 | 3853 | 18 |
957707 | 957707 | 2021-01-23 | Newton | Missouri | 29145 | 3853 | 60 |
952548 | 952548 | 2021-01-21 | Wasatch | Utah | 49051 | 3853 | 16 |
928483 | 928483 | 2021-01-14 | Lincoln | Missouri | 29113 | 3853 | 24 |
891450 | 891450 | 2021-01-03 | San Benito | California | 6069 | 3853 | 29 |
886537 | 886537 | 2021-01-01 | Hunterdon | New Jersey | 34019 | 3853 | 139 |
876333 | 876333 | 2020-12-29 | Benton | Minnesota | 27009 | 3853 | 76 |
873011 | 873011 | 2020-12-28 | Branch | Michigan | 26023 | 3853 | 89 |
850492 | 850492 | 2020-12-21 | Lafayette | Mississippi | 28071 | 3853 | 70 |
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);