ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 7717 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Tennessee 9
- Texas 6
- Kansas 5
- North Carolina 4
- California 3
- Maryland 3
- New York 3
- Pennsylvania 3
- Florida 2
- Kentucky 2
- Louisiana 2
- Minnesota 2
- Ohio 2
- Alabama 1
- Georgia 1
- Guam 1
- Illinois 1
- Indiana 1
- New Jersey 1
- South Carolina 1
- Utah 1
- Vermont 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420901 | 2420901 | 2022-04-18 | Hockley | Texas | 48219 | 7717 | 161 |
2393330 | 2393330 | 2022-04-10 | Dorchester | Maryland | 24019 | 7717 | 107 |
2390074 | 2390074 | 2022-04-09 | Dorchester | Maryland | 24019 | 7717 | 107 |
2386818 | 2386818 | 2022-04-08 | Dorchester | Maryland | 24019 | 7717 | 107 |
2358285 | 2358285 | 2022-03-30 | Macon | North Carolina | 37113 | 7717 | 113 |
2331253 | 2331253 | 2022-03-22 | Miami | Kansas | 20121 | 7717 | 90 |
2328001 | 2328001 | 2022-03-21 | Miami | Kansas | 20121 | 7717 | 90 |
2266273 | 2266273 | 2022-03-02 | Clay | Kentucky | 21051 | 7717 | 82 |
2157587 | 2157587 | 2022-01-27 | Franklin | Vermont | 50011 | 7717 | 58 |
2150788 | 2150788 | 2022-01-25 | Weakley | Tennessee | 47183 | 7717 | 108 |
2151291 | 2151291 | 2022-01-25 | Marshall | West Virginia | 54051 | 7717 | 143 |
2147536 | 2147536 | 2022-01-24 | Weakley | Tennessee | 47183 | 7717 | 108 |
2144282 | 2144282 | 2022-01-23 | Weakley | Tennessee | 47183 | 7717 | 108 |
2140308 | 2140308 | 2022-01-22 | Wyoming | New York | 36121 | 7717 | 78 |
2141027 | 2141027 | 2022-01-22 | Weakley | Tennessee | 47183 | 7717 | 108 |
2137771 | 2137771 | 2022-01-21 | Weakley | Tennessee | 47183 | 7717 | 108 |
2134517 | 2134517 | 2022-01-20 | Weakley | Tennessee | 47183 | 7717 | 108 |
2129140 | 2129140 | 2022-01-19 | Oconee | Georgia | 13219 | 7717 | 84 |
2131265 | 2131265 | 2022-01-19 | Weakley | Tennessee | 47183 | 7717 | 108 |
2114237 | 2114237 | 2022-01-14 | Chenango | New York | 36017 | 7717 | 104 |
2029815 | 2029815 | 2021-12-19 | Hoke | North Carolina | 37093 | 7717 | 91 |
2026564 | 2026564 | 2021-12-18 | Hoke | North Carolina | 37093 | 7717 | 91 |
2023313 | 2023313 | 2021-12-17 | Hoke | North Carolina | 37093 | 7717 | 91 |
1937066 | 1937066 | 2021-11-21 | San Benito | California | 6069 | 7717 | 77 |
1933816 | 1933816 | 2021-11-20 | San Benito | California | 6069 | 7717 | 77 |
1930564 | 1930564 | 2021-11-19 | San Benito | California | 6069 | 7717 | 77 |
1785464 | 1785464 | 2021-10-05 | Chisago | Minnesota | 27025 | 7717 | 59 |
1727534 | 1727534 | 2021-09-17 | Sullivan | New York | 36105 | 7717 | 80 |
1695246 | 1695246 | 2021-09-07 | Geauga | Ohio | 39055 | 7717 | 155 |
1669731 | 1669731 | 2021-08-30 | Hawkins | Tennessee | 47073 | 7717 | 130 |
1654934 | 1654934 | 2021-08-26 | Morgan | Indiana | 18109 | 7717 | 155 |
1528400 | 1528400 | 2021-07-18 | Butler | Kansas | 20015 | 7717 | 92 |
1525153 | 1525153 | 2021-07-17 | Butler | Kansas | 20015 | 7717 | 92 |
1521905 | 1521905 | 2021-07-16 | Butler | Kansas | 20015 | 7717 | 92 |
1513560 | 1513560 | 2021-07-13 | Lawrence | Pennsylvania | 42073 | 7717 | 216 |
1509107 | 1509107 | 2021-07-12 | Oldham | Kentucky | 21185 | 7717 | 84 |
1498190 | 1498190 | 2021-07-08 | Chippewa | Wisconsin | 55017 | 7717 | 97 |
1299340 | 1299340 | 2021-05-08 | Somerset | Pennsylvania | 42111 | 7717 | 205 |
1264944 | 1264944 | 2021-04-28 | Walton | Florida | 12131 | 7717 | 87 |
1180466 | 1180466 | 2021-04-02 | Highlands | Florida | 12055 | 7717 | 322 |
1139703 | 1139703 | 2021-03-20 | Hunterdon | New Jersey | 34019 | 7717 | 167 |
1101801 | 1101801 | 2021-03-08 | Val Verde | Texas | 48465 | 7717 | 198 |
1098555 | 1098555 | 2021-03-07 | Val Verde | Texas | 48465 | 7717 | 198 |
1095307 | 1095307 | 2021-03-06 | Val Verde | Texas | 48465 | 7717 | 198 |
1092061 | 1092061 | 2021-03-05 | Val Verde | Texas | 48465 | 7717 | 198 |
1088815 | 1088815 | 2021-03-04 | Val Verde | Texas | 48465 | 7717 | 198 |
1052689 | 1052689 | 2021-02-21 | Darlington | South Carolina | 45031 | 7717 | 162 |
1036175 | 1036175 | 2021-02-16 | Wayne | Ohio | 39169 | 7717 | 206 |
880562 | 880562 | 2020-12-30 | Schuylkill | Pennsylvania | 42107 | 7717 | 243 |
845148 | 845148 | 2020-12-19 | Putnam | Tennessee | 47141 | 7717 | 106 |
821002 | 821002 | 2020-12-12 | Tangipahoa | Louisiana | 22105 | 7717 | 153 |
817756 | 817756 | 2020-12-11 | Tangipahoa | Louisiana | 22105 | 7717 | 153 |
768459 | 768459 | 2020-11-26 | Unknown | Guam | 7717 | 112 | |
702670 | 702670 | 2020-11-05 | Weber | Utah | 49057 | 7717 | 36 |
422722 | 422722 | 2020-08-11 | Ramsey | Minnesota | 27123 | 7717 | 268 |
379553 | 379553 | 2020-07-29 | Mobile | Alabama | 1097 | 7717 | 185 |
194378 | 194378 | 2020-05-31 | DuPage | Illinois | 17043 | 7717 | 373 |
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);