ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 7515 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453666 | 2453666 | 2022-04-28 | Botetourt | Virginia | 51023 | 7515 | 99 |
2242528 | 2242528 | 2022-02-23 | Lawrence | Alabama | 1079 | 7515 | 148 |
2215966 | 2215966 | 2022-02-14 | Hockley | Texas | 48219 | 7515 | 154 |
2144443 | 2144443 | 2022-01-23 | Matagorda | Texas | 48321 | 7515 | 168 |
2058886 | 2058886 | 2021-12-28 | Lyon | Nevada | 32019 | 7515 | 137 |
2033221 | 2033221 | 2021-12-20 | Logan | Ohio | 39091 | 7515 | 119 |
1969071 | 1969071 | 2021-11-30 | Fauquier | Virginia | 51061 | 7515 | 88 |
1765243 | 1765243 | 2021-09-29 | Coles | Illinois | 17029 | 7515 | 117 |
1765679 | 1765679 | 2021-09-29 | Henderson | Kentucky | 21101 | 7515 | 94 |
1715970 | 1715970 | 2021-09-14 | Kenai Peninsula Borough | Alaska | 2122 | 7515 | 28 |
1571592 | 1571592 | 2021-07-31 | Ontario | New York | 36069 | 7515 | 93 |
1515522 | 1515522 | 2021-07-14 | Bullitt | Kentucky | 21029 | 7515 | 83 |
1517506 | 1517506 | 2021-07-14 | Lynchburg city | Virginia | 51680 | 7515 | 147 |
1455703 | 1455703 | 2021-06-25 | Wise | Texas | 48497 | 7515 | 124 |
1420038 | 1420038 | 2021-06-14 | Chittenden | Vermont | 50007 | 7515 | 104 |
1365903 | 1365903 | 2021-05-29 | Williamson | Illinois | 17199 | 7515 | 146 |
1337241 | 1337241 | 2021-05-20 | Clinton | Michigan | 26037 | 7515 | 86 |
1321080 | 1321080 | 2021-05-15 | Blue Earth | Minnesota | 27013 | 7515 | 41 |
1258573 | 1258573 | 2021-04-26 | Rockdale | Georgia | 13247 | 7515 | 171 |
1218817 | 1218817 | 2021-04-13 | Frederick | Virginia | 51069 | 7515 | 95 |
1128952 | 1128952 | 2021-03-17 | Warrick | Indiana | 18173 | 7515 | 157 |
1042492 | 1042492 | 2021-02-18 | Orange | North Carolina | 37135 | 7515 | 92 |
980976 | 980976 | 2021-01-30 | Pickaway | Ohio | 39129 | 7515 | 50 |
909702 | 909702 | 2021-01-08 | Lane | Oregon | 41039 | 7515 | 96 |
875449 | 875449 | 2020-12-29 | Floyd | Georgia | 13115 | 7515 | 121 |
826606 | 826606 | 2020-12-14 | Mesa | Colorado | 8077 | 7515 | 96 |
823359 | 823359 | 2020-12-13 | Mesa | Colorado | 8077 | 7515 | 96 |
380058 | 380058 | 2020-07-29 | Ada | Idaho | 16001 | 7515 | 53 |
240351 | 240351 | 2020-06-15 | San Bernardino | California | 6071 | 7515 | 229 |
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);