ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 17067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Minnesota 6
- Mississippi 5
- Georgia 3
- Michigan 3
- New Jersey 1
- New York 1
- Pennsylvania 1
- Utah 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2302323 | 2302323 | 2022-03-13 | Montcalm | Michigan | 26117 | 17067 | 211 |
2299071 | 2299071 | 2022-03-12 | Montcalm | Michigan | 26117 | 17067 | 211 |
2295819 | 2295819 | 2022-03-11 | Montcalm | Michigan | 26117 | 17067 | 211 |
2052068 | 2052068 | 2021-12-26 | Lee | Mississippi | 28081 | 17067 | 248 |
2048818 | 2048818 | 2021-12-25 | Lee | Mississippi | 28081 | 17067 | 248 |
2045568 | 2045568 | 2021-12-24 | Lee | Mississippi | 28081 | 17067 | 248 |
2042318 | 2042318 | 2021-12-23 | Lee | Mississippi | 28081 | 17067 | 248 |
2039069 | 2039069 | 2021-12-22 | Lee | Mississippi | 28081 | 17067 | 248 |
1951733 | 1951733 | 2021-11-25 | Rensselaer | New York | 36083 | 17067 | 192 |
1915491 | 1915491 | 2021-11-14 | Sherburne | Minnesota | 27141 | 17067 | 118 |
1912241 | 1912241 | 2021-11-13 | Sherburne | Minnesota | 27141 | 17067 | 118 |
1908991 | 1908991 | 2021-11-12 | Sherburne | Minnesota | 27141 | 17067 | 118 |
1642595 | 1642595 | 2021-08-22 | Wright | Minnesota | 27171 | 17067 | 156 |
1639345 | 1639345 | 2021-08-21 | Wright | Minnesota | 27171 | 17067 | 156 |
1636095 | 1636095 | 2021-08-20 | Wright | Minnesota | 27171 | 17067 | 156 |
1508510 | 1508510 | 2021-07-12 | Muscogee | Georgia | 13215 | 17067 | 500 |
1391591 | 1391591 | 2021-06-06 | Columbia | Georgia | 13073 | 17067 | 210 |
1364985 | 1364985 | 2021-05-28 | Richmond city | Virginia | 51760 | 17067 | 267 |
1240877 | 1240877 | 2021-04-20 | Lackawanna | Pennsylvania | 42069 | 17067 | 448 |
972809 | 972809 | 2021-01-28 | Forsyth | Georgia | 13117 | 17067 | 105 |
845457 | 845457 | 2020-12-19 | Weber | Utah | 49057 | 17067 | 84 |
295130 | 295130 | 2020-07-02 | Passaic | New Jersey | 34031 | 17067 | 1187 |
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);