ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 9536 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Missouri 4
- Georgia 3
- Utah 3
- West Virginia 3
- Alabama 2
- Ohio 2
- Pennsylvania 2
- Texas 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Florida 1
- Indiana 1
- Maryland 1
- Michigan 1
- New Mexico 1
- North Carolina 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421811 | 2421811 | 2022-04-19 | Baldwin | Georgia | 13009 | 9536 | 234 |
2418555 | 2418555 | 2022-04-18 | Baldwin | Georgia | 13009 | 9536 | 234 |
2307396 | 2307396 | 2022-03-14 | Logan | West Virginia | 54045 | 9536 | 178 |
2259048 | 2259048 | 2022-02-28 | Summit | Colorado | 8117 | 9536 | 14 |
2226133 | 2226133 | 2022-02-17 | Wayne | West Virginia | 54099 | 9536 | 102 |
2202624 | 2202624 | 2022-02-10 | Trujillo Alto | Puerto Rico | 72139 | 9536 | |
2185460 | 2185460 | 2022-02-05 | Butler | Missouri | 29023 | 9536 | 143 |
2107946 | 2107946 | 2022-01-12 | Auglaize | Ohio | 39011 | 9536 | 139 |
2088291 | 2088291 | 2022-01-06 | Carteret | North Carolina | 37031 | 9536 | 83 |
2044128 | 2044128 | 2021-12-24 | Colbert | Alabama | 1033 | 9536 | 214 |
1992864 | 1992864 | 2021-12-08 | Noble | Indiana | 18113 | 9536 | 127 |
1970564 | 1970564 | 2021-12-01 | Cecil | Maryland | 24015 | 9536 | 191 |
1939725 | 1939725 | 2021-11-21 | Box Elder | Utah | 49003 | 9536 | 94 |
1936475 | 1936475 | 2021-11-20 | Box Elder | Utah | 49003 | 9536 | 94 |
1933225 | 1933225 | 2021-11-19 | Box Elder | Utah | 49003 | 9536 | 94 |
1900883 | 1900883 | 2021-11-09 | Rockingham | Virginia | 51165 | 9536 | 163 |
1883665 | 1883665 | 2021-11-04 | Belmont | Ohio | 39013 | 9536 | 219 |
1701477 | 1701477 | 2021-09-09 | Eddy | New Mexico | 35015 | 9536 | 168 |
1579338 | 1579338 | 2021-08-02 | Monongalia | West Virginia | 54061 | 9536 | 92 |
1419964 | 1419964 | 2021-06-14 | Starr | Texas | 48427 | 9536 | 302 |
1416719 | 1416719 | 2021-06-13 | Starr | Texas | 48427 | 9536 | 302 |
1371061 | 1371061 | 2021-05-30 | Unknown | Tennessee | 9536 | 124 | |
1366746 | 1366746 | 2021-05-29 | Jasper | Missouri | 29097 | 9536 | 129 |
1344788 | 1344788 | 2021-05-22 | Northumberland | Pennsylvania | 42097 | 9536 | 357 |
1341540 | 1341540 | 2021-05-21 | Northumberland | Pennsylvania | 42097 | 9536 | 356 |
1337492 | 1337492 | 2021-05-20 | Cape Girardeau | Missouri | 29031 | 9536 | 135 |
1334245 | 1334245 | 2021-05-19 | Cape Girardeau | Missouri | 29031 | 9536 | 135 |
1290462 | 1290462 | 2021-05-05 | Jefferson | Wisconsin | 55055 | 9536 | 132 |
1126235 | 1126235 | 2021-03-16 | St. Clair | Michigan | 26147 | 9536 | 263 |
1056887 | 1056887 | 2021-02-23 | Garland | Arkansas | 5051 | 9536 | 231 |
988626 | 988626 | 2021-02-02 | Houston | Alabama | 1069 | 9536 | 210 |
975970 | 975970 | 2021-01-29 | Martin | Florida | 12085 | 9536 | 236 |
893645 | 893645 | 2021-01-03 | Aiken | South Carolina | 45003 | 9536 | 138 |
852735 | 852735 | 2020-12-22 | Forsyth | Georgia | 13117 | 9536 | 76 |
839410 | 839410 | 2020-12-18 | Mohave | Arizona | 4015 | 9536 | 299 |
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);