ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 9646 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Texas 4
- Indiana 3
- Wyoming 3
- California 2
- Louisiana 2
- Mississippi 2
- Wisconsin 2
- Alabama 1
- Arkansas 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Kentucky 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- New Hampshire 1
- New York 1
- North Carolina 1
- South Carolina 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466611 | 2466611 | 2022-05-02 | Waller | Texas | 48473 | 9646 | 108 |
2463356 | 2463356 | 2022-05-01 | Waller | Texas | 48473 | 9646 | 108 |
2416772 | 2416772 | 2022-04-17 | Franklin | New York | 36033 | 9646 | 44 |
2360371 | 2360371 | 2022-03-31 | Whitley | Indiana | 18183 | 9646 | 83 |
2357117 | 2357117 | 2022-03-30 | Whitley | Indiana | 18183 | 9646 | 83 |
2334346 | 2334346 | 2022-03-23 | Whitley | Indiana | 18183 | 9646 | 83 |
2237013 | 2237013 | 2022-02-21 | Clark | Kentucky | 21049 | 9646 | 51 |
2172411 | 2172411 | 2022-02-01 | Panola | Mississippi | 28107 | 9646 | 144 |
2078398 | 2078398 | 2022-01-03 | Cheshire | New Hampshire | 33005 | 9646 | 72 |
1899316 | 1899316 | 2021-11-09 | Pearl River | Mississippi | 28109 | 9646 | 241 |
1800924 | 1800924 | 2021-10-10 | Maui | Hawaii | 15009 | 9646 | 92 |
1760058 | 1760058 | 2021-09-27 | Columbus | North Carolina | 37047 | 9646 | 209 |
1667157 | 1667157 | 2021-08-29 | Natrona | Wyoming | 56025 | 9646 | 147 |
1663909 | 1663909 | 2021-08-28 | Natrona | Wyoming | 56025 | 9646 | 147 |
1660661 | 1660661 | 2021-08-27 | Natrona | Wyoming | 56025 | 9646 | 147 |
1605226 | 1605226 | 2021-08-10 | Portsmouth city | Virginia | 51740 | 9646 | 206 |
1574170 | 1574170 | 2021-08-01 | Carroll | Maryland | 24013 | 9646 | 257 |
1536829 | 1536829 | 2021-07-20 | Starr | Texas | 48427 | 9646 | 304 |
1356061 | 1356061 | 2021-05-26 | Twin Falls | Idaho | 16083 | 9646 | 128 |
1326205 | 1326205 | 2021-05-16 | St. Croix | Wisconsin | 55109 | 9646 | 61 |
1322959 | 1322959 | 2021-05-15 | St. Croix | Wisconsin | 55109 | 9646 | 61 |
1314404 | 1314404 | 2021-05-13 | Lafourche | Louisiana | 22057 | 9646 | 204 |
1307911 | 1307911 | 2021-05-11 | Lafourche | Louisiana | 22057 | 9646 | 204 |
1222555 | 1222555 | 2021-04-15 | Napa | California | 6055 | 9646 | 79 |
1112585 | 1112585 | 2021-03-12 | Macon | Illinois | 17115 | 9646 | 196 |
1091649 | 1091649 | 2021-03-05 | Lancaster | South Carolina | 45057 | 9646 | 147 |
1066623 | 1066623 | 2021-02-26 | Garland | Arkansas | 5051 | 9646 | 232 |
994418 | 994418 | 2021-02-03 | Madison | Tennessee | 47113 | 9646 | 201 |
680542 | 680542 | 2020-10-30 | Sonoma | California | 6097 | 9646 | 136 |
506693 | 506693 | 2020-09-06 | Ramsey | Minnesota | 27123 | 9646 | 302 |
490376 | 490376 | 2020-09-01 | Plymouth | Massachusetts | 25023 | 9646 | 742 |
443531 | 443531 | 2020-08-17 | Webb | Texas | 48479 | 9646 | 202 |
408508 | 408508 | 2020-08-07 | Mobile | Alabama | 1097 | 9646 | 211 |
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);