ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 9382 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Tennessee 8
- Missouri 4
- Kansas 3
- Kentucky 3
- Vermont 3
- New Mexico 2
- Virginia 2
- Alabama 1
- Colorado 1
- Idaho 1
- Indiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Montana 1
- New Jersey 1
- New York 1
- North Carolina 1
- North Dakota 1
- Ohio 1
- Texas 1
- Utah 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375731 | 2375731 | 2022-04-04 | Randolph | West Virginia | 54083 | 9382 | 84 |
2326705 | 2326705 | 2022-03-20 | Bennington | Vermont | 50003 | 9382 | 65 |
2323452 | 2323452 | 2022-03-19 | Bennington | Vermont | 50003 | 9382 | 65 |
2320198 | 2320198 | 2022-03-18 | Bennington | Vermont | 50003 | 9382 | 65 |
2310084 | 2310084 | 2022-03-15 | Giles | Tennessee | 47055 | 9382 | 172 |
2306831 | 2306831 | 2022-03-14 | Giles | Tennessee | 47055 | 9382 | 172 |
2303580 | 2303580 | 2022-03-13 | Giles | Tennessee | 47055 | 9382 | 172 |
2300328 | 2300328 | 2022-03-12 | Giles | Tennessee | 47055 | 9382 | 172 |
2300633 | 2300633 | 2022-03-12 | Waller | Texas | 48473 | 9382 | 103 |
2297076 | 2297076 | 2022-03-11 | Giles | Tennessee | 47055 | 9382 | 172 |
2293824 | 2293824 | 2022-03-10 | Giles | Tennessee | 47055 | 9382 | 172 |
2290572 | 2290572 | 2022-03-09 | Giles | Tennessee | 47055 | 9382 | 172 |
2196774 | 2196774 | 2022-02-08 | York | Virginia | 51199 | 9382 | 95 |
2168923 | 2168923 | 2022-01-31 | Franklin | Massachusetts | 25011 | 9382 | 150 |
2169046 | 2169046 | 2022-01-31 | Isanti | Minnesota | 27059 | 9382 | 107 |
2104677 | 2104677 | 2022-01-11 | Stark | North Dakota | 38089 | 9382 | 80 |
2009368 | 2009368 | 2021-12-13 | Boyd | Kentucky | 21019 | 9382 | 123 |
1989971 | 1989971 | 2021-12-07 | Whitley | Kentucky | 21235 | 9382 | 129 |
1884486 | 1884486 | 2021-11-04 | Iron | Utah | 49021 | 9382 | 59 |
1808072 | 1808072 | 2021-10-12 | Allegany | Maryland | 24001 | 9382 | 239 |
1782514 | 1782514 | 2021-10-04 | Lewis and Clark | Montana | 30049 | 9382 | 102 |
1604762 | 1604762 | 2021-08-10 | Hamblen | Tennessee | 47063 | 9382 | 176 |
1565044 | 1565044 | 2021-07-29 | Lea | New Mexico | 35025 | 9382 | 204 |
1566240 | 1566240 | 2021-07-29 | Portsmouth city | Virginia | 51740 | 9382 | 205 |
1559994 | 1559994 | 2021-07-28 | DeKalb | Alabama | 1049 | 9382 | 191 |
1493695 | 1493695 | 2021-07-07 | Brunswick | North Carolina | 37019 | 9382 | 156 |
1460241 | 1460241 | 2021-06-27 | Douglas | Kansas | 20045 | 9382 | 85 |
1456996 | 1456996 | 2021-06-26 | Douglas | Kansas | 20045 | 9382 | 85 |
1453751 | 1453751 | 2021-06-25 | Douglas | Kansas | 20045 | 9382 | 85 |
1421888 | 1421888 | 2021-06-15 | Cass | Missouri | 29037 | 9382 | 116 |
1258659 | 1258659 | 2021-04-26 | Twin Falls | Idaho | 16083 | 9382 | 127 |
1207149 | 1207149 | 2021-04-10 | Hardin | Kentucky | 21093 | 9382 | 147 |
1201118 | 1201118 | 2021-04-08 | Cape Girardeau | Missouri | 29031 | 9382 | 133 |
1197869 | 1197869 | 2021-04-07 | Cape Girardeau | Missouri | 29031 | 9382 | 133 |
1188156 | 1188156 | 2021-04-04 | Jasper | Missouri | 29097 | 9382 | 126 |
1161369 | 1161369 | 2021-03-27 | Howard | Indiana | 18067 | 9382 | 213 |
1022945 | 1022945 | 2021-02-12 | Ulster | New York | 36111 | 9382 | 220 |
987184 | 987184 | 2021-02-01 | Santa Fe | New Mexico | 35049 | 9382 | 119 |
961508 | 961508 | 2021-01-24 | Portage | Ohio | 39133 | 9382 | 109 |
758435 | 758435 | 2020-11-23 | Douglas | Colorado | 8035 | 9382 | 98 |
670421 | 670421 | 2020-10-26 | Spokane | Washington | 53063 | 9382 | 202 |
254308 | 254308 | 2020-06-19 | Ocean | New Jersey | 34029 | 9382 | 842 |
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);