ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 8009 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 |
---|---|---|---|---|---|---|---|
2456857 | 2456857 | 2022-04-29 | Wood | Texas | 48499 | 8009 | 288 |
2453601 | 2453601 | 2022-04-28 | Wood | Texas | 48499 | 8009 | 288 |
2336456 | 2336456 | 2022-03-23 | Uintah | Utah | 49047 | 8009 | 69 |
2326697 | 2326697 | 2022-03-20 | Uintah | Utah | 49047 | 8009 | 66 |
2323444 | 2323444 | 2022-03-19 | Uintah | Utah | 49047 | 8009 | 66 |
2320190 | 2320190 | 2022-03-18 | Uintah | Utah | 49047 | 8009 | 66 |
2316936 | 2316936 | 2022-03-17 | Uintah | Utah | 49047 | 8009 | 66 |
2305856 | 2305856 | 2022-03-14 | Polk | Missouri | 29167 | 8009 | 103 |
2183550 | 2183550 | 2022-02-04 | Titus | Texas | 48449 | 8009 | 116 |
2180370 | 2180370 | 2022-02-03 | Washington | Vermont | 50023 | 8009 | 43 |
2150363 | 2150363 | 2022-01-25 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2147111 | 2147111 | 2022-01-24 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2143857 | 2143857 | 2022-01-23 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2140602 | 2140602 | 2022-01-22 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2137346 | 2137346 | 2022-01-21 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2134092 | 2134092 | 2022-01-20 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2130840 | 2130840 | 2022-01-19 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2126104 | 2126104 | 2022-01-18 | Clinton | Indiana | 18023 | 8009 | 101 |
2062312 | 2062312 | 2021-12-29 | Hoke | North Carolina | 37093 | 8009 | 91 |
2057637 | 2057637 | 2021-12-28 | Thomas | Georgia | 13275 | 8009 | 184 |
2058705 | 2058705 | 2021-12-28 | Scott | Missouri | 29201 | 8009 | 133 |
2056405 | 2056405 | 2021-12-27 | Cocke | Tennessee | 47029 | 8009 | 163 |
2053782 | 2053782 | 2021-12-26 | Douglas | Wisconsin | 55031 | 8009 | 71 |
2050532 | 2050532 | 2021-12-25 | Douglas | Wisconsin | 55031 | 8009 | 71 |
2047282 | 2047282 | 2021-12-24 | Douglas | Wisconsin | 55031 | 8009 | 71 |
1943298 | 1943298 | 2021-11-22 | Polk | Wisconsin | 55095 | 8009 | 89 |
1880292 | 1880292 | 2021-11-03 | Granville | North Carolina | 37077 | 8009 | 101 |
1822009 | 1822009 | 2021-10-16 | Washington | Ohio | 39167 | 8009 | 137 |
1791342 | 1791342 | 2021-10-07 | Dearborn | Indiana | 18029 | 8009 | 96 |
1693867 | 1693867 | 2021-09-07 | Boone | Indiana | 18011 | 8009 | 114 |
1673617 | 1673617 | 2021-08-31 | Portage | Wisconsin | 55097 | 8009 | 81 |
1515019 | 1515019 | 2021-07-14 | Rockdale | Georgia | 13247 | 8009 | 179 |
1495104 | 1495104 | 2021-07-08 | Fairbanks North Star Borough | Alaska | 2090 | 8009 | 44 |
1491857 | 1491857 | 2021-07-07 | Fairbanks North Star Borough | Alaska | 2090 | 8009 | 44 |
1478593 | 1478593 | 2021-07-02 | Suffolk city | Virginia | 51800 | 8009 | 192 |
1380168 | 1380168 | 2021-06-02 | Sampson | North Carolina | 37163 | 8009 | 113 |
1345447 | 1345447 | 2021-05-22 | Frederick | Virginia | 51069 | 8009 | 101 |
1183818 | 1183818 | 2021-04-03 | Gordon | Georgia | 13129 | 8009 | 110 |
1076825 | 1076825 | 2021-03-01 | Adams | Illinois | 17001 | 8009 | 143 |
1070333 | 1070333 | 2021-02-27 | Adams | Illinois | 17001 | 8009 | 143 |
1029541 | 1029541 | 2021-02-14 | Wilson | North Carolina | 37195 | 8009 | 141 |
828198 | 828198 | 2020-12-14 | Oneida | New York | 36065 | 8009 | 191 |
576907 | 576907 | 2020-09-28 | St. Lucie | Florida | 12111 | 8009 | 276 |
563937 | 563937 | 2020-09-24 | Sarasota | Florida | 12115 | 8009 | 253 |
378066 | 378066 | 2020-07-28 | Mercer | New Jersey | 34021 | 8009 | 612 |
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);