ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 10512 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Oklahoma 7
- Texas 5
- Alabama 2
- Louisiana 2
- Maryland 2
- Minnesota 2
- Alaska 1
- Arkansas 1
- Florida 1
- Georgia 1
- Hawaii 1
- Indiana 1
- Missouri 1
- New Jersey 1
- New York 1
- North Carolina 1
- Ohio 1
- South Carolina 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2396541 | 2396541 | 2022-04-11 | St. John the Baptist | Louisiana | 22095 | 10512 | 184 |
2252384 | 2252384 | 2022-02-26 | Independence | Arkansas | 5063 | 10512 | 194 |
2221831 | 2221831 | 2022-02-16 | Highland | Ohio | 39071 | 10512 | 168 |
2178655 | 2178655 | 2022-02-03 | Calvert | Maryland | 24009 | 10512 | 131 |
2058322 | 2058322 | 2021-12-28 | Cecil | Maryland | 24015 | 10512 | 205 |
2020039 | 2020039 | 2021-12-16 | Columbus | North Carolina | 37047 | 10512 | 233 |
1995910 | 1995910 | 2021-12-09 | Maui | Hawaii | 15009 | 10512 | 102 |
1988327 | 1988327 | 2021-12-06 | Hardin | Texas | 48199 | 10512 | 212 |
1985077 | 1985077 | 2021-12-05 | Hardin | Texas | 48199 | 10512 | 212 |
1981827 | 1981827 | 2021-12-04 | Hardin | Texas | 48199 | 10512 | 212 |
1978577 | 1978577 | 2021-12-03 | Hardin | Texas | 48199 | 10512 | 212 |
1975327 | 1975327 | 2021-12-02 | Hardin | Texas | 48199 | 10512 | 212 |
1968278 | 1968278 | 2021-11-30 | Garfield | Oklahoma | 40047 | 10512 | 212 |
1965027 | 1965027 | 2021-11-29 | Garfield | Oklahoma | 40047 | 10512 | 212 |
1961775 | 1961775 | 2021-11-28 | Garfield | Oklahoma | 40047 | 10512 | 212 |
1958524 | 1958524 | 2021-11-27 | Garfield | Oklahoma | 40047 | 10512 | 212 |
1953098 | 1953098 | 2021-11-26 | Autauga | Alabama | 1001 | 10512 | 157 |
1955273 | 1955273 | 2021-11-26 | Garfield | Oklahoma | 40047 | 10512 | 212 |
1949847 | 1949847 | 2021-11-25 | Autauga | Alabama | 1001 | 10512 | 157 |
1952022 | 1952022 | 2021-11-25 | Garfield | Oklahoma | 40047 | 10512 | 212 |
1948771 | 1948771 | 2021-11-24 | Garfield | Oklahoma | 40047 | 10512 | 212 |
1882719 | 1882719 | 2021-11-04 | Acadia | Louisiana | 22001 | 10512 | 250 |
1858192 | 1858192 | 2021-10-27 | McMinn | Tennessee | 47107 | 10512 | 132 |
1790435 | 1790435 | 2021-10-06 | Chelan | Washington | 53007 | 10512 | 100 |
1719215 | 1719215 | 2021-09-15 | Fairbanks North Star Borough | Alaska | 2090 | 10512 | 51 |
1642983 | 1642983 | 2021-08-22 | Hunterdon | New Jersey | 34019 | 10512 | 178 |
1390376 | 1390376 | 2021-06-05 | Sumter | South Carolina | 45085 | 10512 | 209 |
1324329 | 1324329 | 2021-05-16 | Carver | Minnesota | 27019 | 10512 | 45 |
1302152 | 1302152 | 2021-05-09 | Putnam | New York | 36079 | 10512 | 91 |
1268523 | 1268523 | 2021-04-29 | Delaware | Indiana | 18035 | 10512 | 192 |
1269334 | 1269334 | 2021-04-29 | Franklin | Missouri | 29071 | 10512 | 180 |
748848 | 748848 | 2020-11-20 | Chatham | Georgia | 13051 | 10512 | 206 |
690418 | 690418 | 2020-11-02 | Seminole | Florida | 12117 | 10512 | 243 |
250787 | 250787 | 2020-06-18 | Hennepin | Minnesota | 27053 | 10512 | 732 |
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);