ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6872 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 |
---|---|---|---|---|---|---|---|
2492546 | 2492546 | 2022-05-10 | Howard | Texas | 48227 | 6872 | 184 |
2476668 | 2476668 | 2022-05-05 | Upshur | West Virginia | 54097 | 6872 | 95 |
2290885 | 2290885 | 2022-03-09 | Willacy | Texas | 48489 | 6872 | 125 |
2287633 | 2287633 | 2022-03-08 | Willacy | Texas | 48489 | 6872 | 125 |
2247804 | 2247804 | 2022-02-24 | Adams | Ohio | 39001 | 6872 | 137 |
2193266 | 2193266 | 2022-02-07 | Palo Pinto | Texas | 48363 | 6872 | 138 |
2172386 | 2172386 | 2022-02-01 | Itawamba | Mississippi | 28057 | 6872 | 120 |
2135193 | 2135193 | 2022-01-21 | Marion | Alabama | 1093 | 6872 | 134 |
2127049 | 2127049 | 2022-01-18 | Silver Bow | Montana | 30093 | 6872 | 118 |
2127946 | 2127946 | 2022-01-18 | Giles | Tennessee | 47055 | 6872 | 152 |
2124694 | 2124694 | 2022-01-17 | Giles | Tennessee | 47055 | 6872 | 152 |
2121442 | 2121442 | 2022-01-16 | Giles | Tennessee | 47055 | 6872 | 152 |
2118190 | 2118190 | 2022-01-15 | Giles | Tennessee | 47055 | 6872 | 152 |
2114939 | 2114939 | 2022-01-14 | Giles | Tennessee | 47055 | 6872 | 152 |
2111687 | 2111687 | 2022-01-13 | Giles | Tennessee | 47055 | 6872 | 152 |
2112254 | 2112254 | 2022-01-13 | Marshall | West Virginia | 54051 | 6872 | 137 |
2108435 | 2108435 | 2022-01-12 | Giles | Tennessee | 47055 | 6872 | 152 |
2041258 | 2041258 | 2021-12-23 | Baldwin | Georgia | 13009 | 6872 | 199 |
2035250 | 2035250 | 2021-12-21 | Wapello | Iowa | 19179 | 6872 | 153 |
2032000 | 2032000 | 2021-12-20 | Wapello | Iowa | 19179 | 6872 | 153 |
2028749 | 2028749 | 2021-12-19 | Wapello | Iowa | 19179 | 6872 | 153 |
2025498 | 2025498 | 2021-12-18 | Wapello | Iowa | 19179 | 6872 | 153 |
2022247 | 2022247 | 2021-12-17 | Wapello | Iowa | 19179 | 6872 | 153 |
2018996 | 2018996 | 2021-12-16 | Wapello | Iowa | 19179 | 6872 | 153 |
2015746 | 2015746 | 2021-12-15 | Wapello | Iowa | 19179 | 6872 | 153 |
1988829 | 1988829 | 2021-12-06 | Albany | Wyoming | 56001 | 6872 | 39 |
1967593 | 1967593 | 2021-11-30 | Warren | Mississippi | 28149 | 6872 | 178 |
1959878 | 1959878 | 2021-11-28 | La Plata | Colorado | 8067 | 6872 | 59 |
1930362 | 1930362 | 2021-11-19 | Covington | Alabama | 1039 | 6872 | 191 |
1925352 | 1925352 | 2021-11-17 | Butler | Missouri | 29023 | 6872 | 72 |
1898671 | 1898671 | 2021-11-09 | Des Moines | Iowa | 19057 | 6872 | 100 |
1895421 | 1895421 | 2021-11-08 | Des Moines | Iowa | 19057 | 6872 | 100 |
1892171 | 1892171 | 2021-11-07 | Des Moines | Iowa | 19057 | 6872 | 100 |
1888921 | 1888921 | 2021-11-06 | Des Moines | Iowa | 19057 | 6872 | 100 |
1885671 | 1885671 | 2021-11-05 | Des Moines | Iowa | 19057 | 6872 | 100 |
1882422 | 1882422 | 2021-11-04 | Des Moines | Iowa | 19057 | 6872 | 100 |
1879173 | 1879173 | 2021-11-03 | Des Moines | Iowa | 19057 | 6872 | 100 |
1837273 | 1837273 | 2021-10-21 | St. Bernard | Louisiana | 22087 | 6872 | 98 |
1764127 | 1764127 | 2021-09-28 | Jim Wells | Texas | 48249 | 6872 | 158 |
1745235 | 1745235 | 2021-09-23 | Graham | Arizona | 4009 | 6872 | 99 |
1736514 | 1736514 | 2021-09-20 | Avoyelles | Louisiana | 22009 | 6872 | 167 |
1695026 | 1695026 | 2021-09-07 | Jefferson | New York | 36045 | 6872 | 70 |
1541829 | 1541829 | 2021-07-22 | Crow Wing | Minnesota | 27035 | 6872 | 98 |
1490623 | 1490623 | 2021-07-06 | Geauga | Ohio | 39055 | 6872 | 153 |
1472710 | 1472710 | 2021-07-01 | Bulloch | Georgia | 13031 | 6872 | 121 |
1459111 | 1459111 | 2021-06-26 | Rockingham | Virginia | 51165 | 6872 | 112 |
1378220 | 1378220 | 2021-06-02 | Jackson | Alabama | 1071 | 6872 | 112 |
1357355 | 1357355 | 2021-05-26 | Steuben | New York | 36101 | 6872 | 143 |
1321878 | 1321878 | 2021-05-15 | Ross | Ohio | 39141 | 6872 | 156 |
1291731 | 1291731 | 2021-05-06 | Allegany | Maryland | 24001 | 6872 | 207 |
1231479 | 1231479 | 2021-04-17 | Bowie | Texas | 48037 | 6872 | 210 |
1211651 | 1211651 | 2021-04-11 | Lawrence | Pennsylvania | 42073 | 6872 | 198 |
1207117 | 1207117 | 2021-04-10 | Bullitt | Kentucky | 21029 | 6872 | 71 |
1160284 | 1160284 | 2021-03-26 | Tooele | Utah | 49045 | 6872 | 39 |
1093904 | 1093904 | 2021-03-06 | Lauderdale | Mississippi | 28075 | 6872 | 228 |
1078305 | 1078305 | 2021-03-01 | Erie | Ohio | 39043 | 6872 | 184 |
1069484 | 1069484 | 2021-02-26 | Lynchburg city | Virginia | 51680 | 6872 | 112 |
1061091 | 1061091 | 2021-02-24 | Oldham | Kentucky | 21185 | 6872 | 69 |
896586 | 896586 | 2021-01-04 | Marion | Ohio | 39101 | 6872 | 106 |
881433 | 881433 | 2020-12-30 | Manitowoc | Wisconsin | 55071 | 6872 | 57 |
815448 | 815448 | 2020-12-10 | Medina | Ohio | 39103 | 6872 | 67 |
592841 | 592841 | 2020-10-03 | Benton | Arkansas | 5007 | 6872 | 93 |
334966 | 334966 | 2020-07-15 | Collier | Florida | 12021 | 6872 | 99 |
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);