ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 9332 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Oklahoma 7
- North Carolina 5
- West Virginia 4
- Arizona 3
- Colorado 3
- Indiana 3
- California 2
- Florida 2
- Ohio 2
- Alabama 1
- Arkansas 1
- District of Columbia 1
- Georgia 1
- Iowa 1
- New Jersey 1
- New Mexico 1
- New York 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486432 | 2486432 | 2022-05-08 | Preston | West Virginia | 54077 | 9332 | 137 |
2483174 | 2483174 | 2022-05-07 | Preston | West Virginia | 54077 | 9332 | 137 |
2479916 | 2479916 | 2022-05-06 | Preston | West Virginia | 54077 | 9332 | 137 |
2437984 | 2437984 | 2022-04-24 | Montrose | Colorado | 8085 | 9332 | 158 |
2434728 | 2434728 | 2022-04-23 | Montrose | Colorado | 8085 | 9332 | 158 |
2431472 | 2431472 | 2022-04-22 | Montrose | Colorado | 8085 | 9332 | 158 |
2324177 | 2324177 | 2022-03-20 | Unknown | Florida | 9332 | 844 | |
2320923 | 2320923 | 2022-03-19 | Unknown | Florida | 9332 | 844 | |
2322403 | 2322403 | 2022-03-19 | Franklin | New York | 36033 | 9332 | 44 |
2279000 | 2279000 | 2022-03-06 | Jefferson | Indiana | 18077 | 9332 | 151 |
2275747 | 2275747 | 2022-03-05 | Jefferson | Indiana | 18077 | 9332 | 151 |
2272494 | 2272494 | 2022-03-04 | Jefferson | Indiana | 18077 | 9332 | 151 |
2268110 | 2268110 | 2022-03-02 | Waller | Texas | 48473 | 9332 | 100 |
2063767 | 2063767 | 2021-12-30 | Mississippi | Arkansas | 5093 | 9332 | 157 |
1945448 | 1945448 | 2021-11-23 | Jefferson | Ohio | 39081 | 9332 | 225 |
1946442 | 1946442 | 2021-11-23 | Walla Walla | Washington | 53071 | 9332 | 113 |
1826460 | 1826460 | 2021-10-18 | Gila | Arizona | 4007 | 9332 | 248 |
1828319 | 1828319 | 2021-10-18 | Lee | North Carolina | 37105 | 9332 | 105 |
1823211 | 1823211 | 2021-10-17 | Gila | Arizona | 4007 | 9332 | 248 |
1819962 | 1819962 | 2021-10-16 | Gila | Arizona | 4007 | 9332 | 248 |
1594532 | 1594532 | 2021-08-07 | Columbiana | Ohio | 39029 | 9332 | 236 |
1542281 | 1542281 | 2021-07-22 | Cape May | New Jersey | 34009 | 9332 | 208 |
1519569 | 1519569 | 2021-07-15 | Chaves | New Mexico | 35005 | 9332 | 172 |
1461235 | 1461235 | 2021-06-27 | Brunswick | North Carolina | 37019 | 9332 | 155 |
1457990 | 1457990 | 2021-06-26 | Brunswick | North Carolina | 37019 | 9332 | 155 |
1454745 | 1454745 | 2021-06-25 | Brunswick | North Carolina | 37019 | 9332 | 155 |
1354416 | 1354416 | 2021-05-25 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1351170 | 1351170 | 2021-05-24 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1347924 | 1347924 | 2021-05-23 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1344676 | 1344676 | 2021-05-22 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1341428 | 1341428 | 2021-05-21 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1338180 | 1338180 | 2021-05-20 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1334933 | 1334933 | 2021-05-19 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1150912 | 1150912 | 2021-03-24 | Cullman | Alabama | 1043 | 9332 | 186 |
1039243 | 1039243 | 2021-02-17 | Nash | North Carolina | 37127 | 9332 | 161 |
1020900 | 1020900 | 2021-02-11 | Berkeley | West Virginia | 54003 | 9332 | 92 |
982970 | 982970 | 2021-01-31 | Pottawattamie | Iowa | 19155 | 9332 | 126 |
966284 | 966284 | 2021-01-26 | Carroll | Georgia | 13045 | 9332 | 162 |
544358 | 544358 | 2020-09-18 | San Mateo | California | 6081 | 9332 | 142 |
541122 | 541122 | 2020-09-17 | San Mateo | California | 6081 | 9332 | 142 |
215640 | 215640 | 2020-06-07 | District of Columbia | District of Columbia | 11001 | 9332 | 489 |
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);