ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 7721 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Kansas 5
- Virginia 5
- Kentucky 3
- Louisiana 3
- Mississippi 3
- Missouri 3
- New York 3
- Ohio 3
- Florida 2
- Idaho 2
- Michigan 2
- Arkansas 1
- Colorado 1
- Georgia 1
- Illinois 1
- Minnesota 1
- North Carolina 1
- Pennsylvania 1
- South Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2361539 | 2361539 | 2022-03-31 | Macon | North Carolina | 37113 | 7721 | 113 |
2347520 | 2347520 | 2022-03-27 | Miami | Kansas | 20121 | 7721 | 91 |
2344267 | 2344267 | 2022-03-26 | Miami | Kansas | 20121 | 7721 | 91 |
2341014 | 2341014 | 2022-03-25 | Miami | Kansas | 20121 | 7721 | 91 |
2290136 | 2290136 | 2022-03-09 | Morrow | Ohio | 39117 | 7721 | 99 |
2285298 | 2285298 | 2022-03-08 | Upson | Georgia | 13293 | 7721 | 227 |
2283064 | 2283064 | 2022-03-07 | Lawrence | Missouri | 29109 | 7721 | 153 |
2188766 | 2188766 | 2022-02-06 | Marion | Missouri | 29127 | 7721 | 111 |
2103190 | 2103190 | 2022-01-11 | Bingham | Idaho | 16011 | 7721 | 138 |
2100885 | 2100885 | 2022-01-10 | Butler | Missouri | 29023 | 7721 | 134 |
1990725 | 1990725 | 2021-12-07 | Madison | New York | 36053 | 7721 | 110 |
1988548 | 1988548 | 2021-12-06 | Campbell | Virginia | 51031 | 7721 | 150 |
1923983 | 1923983 | 2021-11-17 | Hot Spring | Arkansas | 5059 | 7721 | 107 |
1831048 | 1831048 | 2021-10-19 | Hancock | Mississippi | 28045 | 7721 | 126 |
1801374 | 1801374 | 2021-10-10 | Barren | Kentucky | 21009 | 7721 | 127 |
1798125 | 1798125 | 2021-10-09 | Barren | Kentucky | 21009 | 7721 | 127 |
1794876 | 1794876 | 2021-10-08 | Barren | Kentucky | 21009 | 7721 | 127 |
1769195 | 1769195 | 2021-09-30 | Shiawassee | Michigan | 26155 | 7721 | 120 |
1769976 | 1769976 | 2021-09-30 | Huron | Ohio | 39077 | 7721 | 131 |
1765946 | 1765946 | 2021-09-29 | Shiawassee | Michigan | 26155 | 7721 | 120 |
1691359 | 1691359 | 2021-09-06 | Lafayette | Mississippi | 28071 | 7721 | 131 |
1691803 | 1691803 | 2021-09-06 | Steuben | New York | 36101 | 7721 | 151 |
1689696 | 1689696 | 2021-09-05 | Rockingham | Virginia | 51165 | 7721 | 116 |
1686446 | 1686446 | 2021-09-04 | Rockingham | Virginia | 51165 | 7721 | 116 |
1683195 | 1683195 | 2021-09-03 | Rockingham | Virginia | 51165 | 7721 | 116 |
1640066 | 1640066 | 2021-08-21 | Scioto | Ohio | 39145 | 7721 | 109 |
1604486 | 1604486 | 2021-08-10 | Crawford | Pennsylvania | 42039 | 7721 | 157 |
1588404 | 1588404 | 2021-08-05 | Laurens | South Carolina | 45059 | 7721 | 172 |
1561302 | 1561302 | 2021-07-28 | Blue Earth | Minnesota | 27013 | 7721 | 44 |
1523618 | 1523618 | 2021-07-16 | Unknown | Tennessee | 7721 | 95 | |
1334165 | 1334165 | 2021-05-19 | Forrest | Mississippi | 28035 | 7721 | 152 |
1163665 | 1163665 | 2021-03-27 | Roanoke | Virginia | 51161 | 7721 | 125 |
1092786 | 1092786 | 2021-03-06 | Columbia | Florida | 12023 | 7721 | 161 |
1073345 | 1073345 | 2021-02-28 | Nassau | Florida | 12089 | 7721 | 112 |
866427 | 866427 | 2020-12-26 | Rapides | Louisiana | 22079 | 7721 | 208 |
863182 | 863182 | 2020-12-25 | Rapides | Louisiana | 22079 | 7721 | 208 |
859937 | 859937 | 2020-12-24 | Rapides | Louisiana | 22079 | 7721 | 208 |
657878 | 657878 | 2020-10-23 | Jefferson | Colorado | 8059 | 7721 | 305 |
626150 | 626150 | 2020-10-13 | Wyandotte | Kansas | 20209 | 7721 | 134 |
622908 | 622908 | 2020-10-12 | Wyandotte | Kansas | 20209 | 7721 | 134 |
599898 | 599898 | 2020-10-05 | St. Clair | Illinois | 17163 | 7721 | 196 |
531755 | 531755 | 2020-09-14 | Canyon | Idaho | 16027 | 7721 | 93 |
52685 | 52685 | 2020-04-12 | Rockland | New York | 36087 | 7721 | 166 |
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);