ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 13682 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Kentucky 3
- Georgia 2
- New Jersey 2
- Ohio 2
- Alabama 1
- Colorado 1
- Hawaii 1
- Mississippi 1
- New York 1
- North Dakota 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2387508 | 2387508 | 2022-04-08 | Warren | New York | 36113 | 13682 | 127 |
2336607 | 2336607 | 2022-03-23 | Washington | Virginia | 51191 | 13682 | 211 |
2169140 | 2169140 | 2022-01-31 | Lafayette | Mississippi | 28071 | 13682 | 162 |
2133996 | 2133996 | 2022-01-20 | Huron | Ohio | 39077 | 13682 | 182 |
2060273 | 2060273 | 2021-12-28 | Chippewa | Wisconsin | 55017 | 13682 | 140 |
1995800 | 1995800 | 2021-12-09 | Fayette | Georgia | 13113 | 13682 | 247 |
1993900 | 1993900 | 2021-12-08 | Cape May | New Jersey | 34009 | 13682 | 245 |
1937865 | 1937865 | 2021-11-21 | Campbell | Kentucky | 21037 | 13682 | 115 |
1934615 | 1934615 | 2021-11-20 | Campbell | Kentucky | 21037 | 13682 | 115 |
1931364 | 1931364 | 2021-11-19 | Campbell | Kentucky | 21037 | 13682 | 115 |
1929116 | 1929116 | 2021-11-18 | Grand Forks | North Dakota | 38035 | 13682 | 94 |
1722857 | 1722857 | 2021-09-16 | Jackson | Georgia | 13157 | 13682 | 175 |
1712688 | 1712688 | 2021-09-13 | Limestone | Alabama | 1083 | 13682 | 176 |
1240651 | 1240651 | 2021-04-20 | Clark | Ohio | 39023 | 13682 | 293 |
1164164 | 1164164 | 2021-03-28 | Mesa | Colorado | 8077 | 13682 | 209 |
703564 | 703564 | 2020-11-06 | Honolulu | Hawaii | 15003 | 13682 | 170 |
102625 | 102625 | 2020-04-30 | Essex | New Jersey | 34013 | 13682 | 1186 |
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);