ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 9385 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Oklahoma 7
- Michigan 5
- Alabama 2
- California 2
- South Carolina 2
- Texas 2
- Illinois 1
- Kentucky 1
- Minnesota 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Ohio 1
- Pennsylvania 1
- Tennessee 1
- Vermont 1
- Virginia 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2307196 | 2307196 | 2022-03-14 | Washington | Vermont | 50023 | 9385 | 46 |
2239906 | 2239906 | 2022-02-22 | Monroe | Illinois | 17133 | 9385 | 130 |
2189831 | 2189831 | 2022-02-06 | Anderson | Texas | 48001 | 9385 | 220 |
2133792 | 2133792 | 2022-01-20 | Tioga | New York | 36107 | 9385 | 79 |
2126648 | 2126648 | 2022-01-18 | Chippewa | Michigan | 26033 | 9385 | 90 |
2123396 | 2123396 | 2022-01-17 | Chippewa | Michigan | 26033 | 9385 | 90 |
2120144 | 2120144 | 2022-01-16 | Chippewa | Michigan | 26033 | 9385 | 90 |
2116892 | 2116892 | 2022-01-15 | Chippewa | Michigan | 26033 | 9385 | 90 |
2117668 | 2117668 | 2022-01-15 | Morton | North Dakota | 38059 | 9385 | 134 |
2113641 | 2113641 | 2022-01-14 | Chippewa | Michigan | 26033 | 9385 | 90 |
2107291 | 2107291 | 2022-01-12 | Winona | Minnesota | 27169 | 9385 | 63 |
2086579 | 2086579 | 2022-01-06 | Mendocino | California | 6045 | 9385 | 105 |
2085185 | 2085185 | 2022-01-05 | Athens | Ohio | 39009 | 9385 | 104 |
2082024 | 2082024 | 2022-01-04 | Bryan | Oklahoma | 40013 | 9385 | 118 |
2078772 | 2078772 | 2022-01-03 | Bryan | Oklahoma | 40013 | 9385 | 118 |
2075521 | 2075521 | 2022-01-02 | Bryan | Oklahoma | 40013 | 9385 | 118 |
2072270 | 2072270 | 2022-01-01 | Bryan | Oklahoma | 40013 | 9385 | 118 |
2069019 | 2069019 | 2021-12-31 | Bryan | Oklahoma | 40013 | 9385 | 118 |
2065768 | 2065768 | 2021-12-30 | Bryan | Oklahoma | 40013 | 9385 | 118 |
2062518 | 2062518 | 2021-12-29 | Bryan | Oklahoma | 40013 | 9385 | 118 |
2011481 | 2011481 | 2021-12-13 | Marion | West Virginia | 54049 | 9385 | 136 |
1942676 | 1942676 | 2021-11-22 | Loudon | Tennessee | 47105 | 9385 | 101 |
1858641 | 1858641 | 2021-10-27 | Rockingham | Virginia | 51165 | 9385 | 153 |
1754917 | 1754917 | 2021-09-26 | Jackson | Alabama | 1071 | 9385 | 158 |
1717894 | 1717894 | 2021-09-14 | Wilkes | North Carolina | 37193 | 9385 | 148 |
1555290 | 1555290 | 2021-07-26 | Chaves | New Mexico | 35005 | 9385 | 172 |
1238512 | 1238512 | 2021-04-19 | Jefferson | Wisconsin | 55055 | 9385 | 131 |
1167342 | 1167342 | 2021-03-29 | Napa | California | 6055 | 9385 | 78 |
1076250 | 1076250 | 2021-03-01 | Elmore | Alabama | 1051 | 9385 | 185 |
864474 | 864474 | 2020-12-25 | Pickens | South Carolina | 45077 | 9385 | 134 |
861229 | 861229 | 2020-12-24 | Pickens | South Carolina | 45077 | 9385 | 134 |
622942 | 622942 | 2020-10-12 | Fayette | Kentucky | 21067 | 9385 | 82 |
365720 | 365720 | 2020-07-24 | Montgomery | Pennsylvania | 42091 | 9385 | 844 |
184055 | 184055 | 2020-05-27 | Dallas | Texas | 48113 | 9385 | 221 |
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);