ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 6362 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- North Carolina 8
- New York 6
- Texas 6
- Indiana 5
- New Mexico 5
- Tennessee 5
- Pennsylvania 3
- Wisconsin 3
- Kansas 2
- Louisiana 2
- Massachusetts 2
- Minnesota 2
- Mississippi 2
- Ohio 2
- Puerto Rico 2
- California 1
- Colorado 1
- Idaho 1
- Maryland 1
- Michigan 1
- Missouri 1
- Montana 1
- South Carolina 1
- Virginia 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2349790 | 2349790 | 2022-03-27 | Waushara | Wisconsin | 55137 | 6362 | 87 |
2346537 | 2346537 | 2022-03-26 | Waushara | Wisconsin | 55137 | 6362 | 87 |
2343284 | 2343284 | 2022-03-25 | Waushara | Wisconsin | 55137 | 6362 | 87 |
2247107 | 2247107 | 2022-02-24 | Le Sueur | Minnesota | 27079 | 6362 | 49 |
2237146 | 2237146 | 2022-02-21 | Plaquemines | Louisiana | 22075 | 6362 | 44 |
2225353 | 2225353 | 2022-02-17 | Isabela | Puerto Rico | 72071 | 6362 | |
2218305 | 2218305 | 2022-02-15 | Grant | New Mexico | 35017 | 6362 | 74 |
2209411 | 2209411 | 2022-02-12 | DeWitt | Texas | 48123 | 6362 | 92 |
2156202 | 2156202 | 2022-01-27 | Dunklin | Missouri | 29069 | 6362 | 93 |
2146348 | 2146348 | 2022-01-24 | George | Mississippi | 28039 | 6362 | 81 |
2137438 | 2137438 | 2022-01-21 | Elk | Pennsylvania | 42047 | 6362 | 83 |
2106583 | 2106583 | 2022-01-12 | Adams | Indiana | 18001 | 6362 | 101 |
2109121 | 2109121 | 2022-01-12 | Sheridan | Wyoming | 56033 | 6362 | 63 |
2098039 | 2098039 | 2022-01-09 | Bladen | North Carolina | 37017 | 6362 | 99 |
2094787 | 2094787 | 2022-01-08 | Bladen | North Carolina | 37017 | 6362 | 99 |
2091535 | 2091535 | 2022-01-07 | Bladen | North Carolina | 37017 | 6362 | 99 |
2077387 | 2077387 | 2022-01-03 | Ripley | Indiana | 18137 | 6362 | 103 |
2062021 | 2062021 | 2021-12-29 | Silver Bow | Montana | 30093 | 6362 | 118 |
2032968 | 2032968 | 2021-12-20 | Chenango | New York | 36017 | 6362 | 98 |
1990983 | 1990983 | 2021-12-07 | Preble | Ohio | 39135 | 6362 | 141 |
1929950 | 1929950 | 2021-11-18 | Uvalde | Texas | 48463 | 6362 | 117 |
1926700 | 1926700 | 2021-11-17 | Uvalde | Texas | 48463 | 6362 | 116 |
1912744 | 1912744 | 2021-11-13 | Warren | New York | 36113 | 6362 | 89 |
1904624 | 1904624 | 2021-11-11 | La Plata | Colorado | 8067 | 6362 | 55 |
1816239 | 1816239 | 2021-10-14 | Wood | Texas | 48499 | 6362 | 213 |
1812991 | 1812991 | 2021-10-13 | Wood | Texas | 48499 | 6362 | 212 |
1809742 | 1809742 | 2021-10-12 | Wood | Texas | 48499 | 6362 | 210 |
1782939 | 1782939 | 2021-10-04 | Ashland | Ohio | 39005 | 6362 | 117 |
1761096 | 1761096 | 2021-09-27 | Fauquier | Virginia | 51061 | 6362 | 80 |
1691742 | 1691742 | 2021-09-06 | Otero | New Mexico | 35035 | 6362 | 92 |
1688492 | 1688492 | 2021-09-05 | Otero | New Mexico | 35035 | 6362 | 92 |
1685242 | 1685242 | 2021-09-04 | Otero | New Mexico | 35035 | 6362 | 92 |
1681991 | 1681991 | 2021-09-03 | Otero | New Mexico | 35035 | 6362 | 92 |
1643585 | 1643585 | 2021-08-22 | Unknown | Puerto Rico | 6362 | 2738 | |
1626881 | 1626881 | 2021-08-17 | Granville | North Carolina | 37077 | 6362 | 85 |
1585286 | 1585286 | 2021-08-04 | Lawrence | Tennessee | 47099 | 6362 | 98 |
1573714 | 1573714 | 2021-08-01 | Marshall | Indiana | 18099 | 6362 | 119 |
1570466 | 1570466 | 2021-07-31 | Marshall | Indiana | 18099 | 6362 | 119 |
1567218 | 1567218 | 2021-07-30 | Marshall | Indiana | 18099 | 6362 | 119 |
1509864 | 1509864 | 2021-07-12 | Cayuga | New York | 36011 | 6362 | 92 |
1506617 | 1506617 | 2021-07-11 | Cayuga | New York | 36011 | 6362 | 92 |
1503371 | 1503371 | 2021-07-10 | Cayuga | New York | 36011 | 6362 | 92 |
1489745 | 1489745 | 2021-07-06 | Cecil | Maryland | 24015 | 6362 | 152 |
1473284 | 1473284 | 2021-07-01 | Saline | Kansas | 20169 | 6362 | 143 |
1470038 | 1470038 | 2021-06-30 | Saline | Kansas | 20169 | 6362 | 143 |
1461256 | 1461256 | 2021-06-27 | Duplin | North Carolina | 37061 | 6362 | 139 |
1458011 | 1458011 | 2021-06-26 | Duplin | North Carolina | 37061 | 6362 | 139 |
1454766 | 1454766 | 2021-06-25 | Duplin | North Carolina | 37061 | 6362 | 139 |
1444547 | 1444547 | 2021-06-22 | Lamar | Mississippi | 28073 | 6362 | 88 |
1419727 | 1419727 | 2021-06-14 | Roane | Tennessee | 47145 | 6362 | 105 |
1416482 | 1416482 | 2021-06-13 | Roane | Tennessee | 47145 | 6362 | 105 |
1413236 | 1413236 | 2021-06-12 | Roane | Tennessee | 47145 | 6362 | 105 |
1409991 | 1409991 | 2021-06-11 | Roane | Tennessee | 47145 | 6362 | 105 |
1403966 | 1403966 | 2021-06-09 | Cowlitz | Washington | 53015 | 6362 | 84 |
1377213 | 1377213 | 2021-06-01 | Carbon | Pennsylvania | 42025 | 6362 | 171 |
1330756 | 1330756 | 2021-05-18 | Grand Traverse | Michigan | 26055 | 6362 | 96 |
1088239 | 1088239 | 2021-03-04 | Clearfield | Pennsylvania | 42033 | 6362 | 114 |
1052112 | 1052112 | 2021-02-21 | Chemung | New York | 36015 | 6362 | 129 |
1012548 | 1012548 | 2021-02-09 | Hampshire | Massachusetts | 25015 | 6362 | 241 |
747154 | 747154 | 2020-11-19 | New Hanover | North Carolina | 37129 | 6362 | 49 |
708673 | 708673 | 2020-11-07 | Beaufort | South Carolina | 45013 | 6362 | 93 |
678472 | 678472 | 2020-10-29 | Washington | Minnesota | 27163 | 6362 | 73 |
489342 | 489342 | 2020-09-01 | Kings | California | 6031 | 6362 | 74 |
438031 | 438031 | 2020-08-16 | Canyon | Idaho | 16027 | 6362 | 56 |
167508 | 167508 | 2020-05-22 | Bristol | Massachusetts | 25005 | 6362 | 353 |
107793 | 107793 | 2020-05-02 | Jefferson | Louisiana | 22051 | 6362 | 369 |
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);