ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 8063 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 |
---|---|---|---|---|---|---|---|
2489453 | 2489453 | 2022-05-09 | Uintah | Utah | 49047 | 8063 | 72 |
2266798 | 2266798 | 2022-03-02 | Laclede | Missouri | 29105 | 8063 | 167 |
2196008 | 2196008 | 2022-02-08 | Greene | Pennsylvania | 42059 | 8063 | 94 |
2188212 | 2188212 | 2022-02-06 | Bell | Kentucky | 21013 | 8063 | 123 |
2184959 | 2184959 | 2022-02-05 | Bell | Kentucky | 21013 | 8063 | 123 |
2181707 | 2181707 | 2022-02-04 | Bell | Kentucky | 21013 | 8063 | 123 |
2109909 | 2109909 | 2022-01-13 | Steuben | Indiana | 18151 | 8063 | 104 |
2078538 | 2078538 | 2022-01-03 | Chatham | North Carolina | 37037 | 8063 | 99 |
1966816 | 1966816 | 2021-11-30 | Cass | Indiana | 18017 | 8063 | 129 |
1964708 | 1964708 | 2021-11-29 | Clinton | New York | 36019 | 8063 | 48 |
1928958 | 1928958 | 2021-11-18 | Genesee | New York | 36037 | 8063 | 142 |
1838659 | 1838659 | 2021-10-21 | Dyer | Tennessee | 47045 | 8063 | 145 |
1704108 | 1704108 | 2021-09-10 | Allegany | Maryland | 24001 | 8063 | 219 |
1701547 | 1701547 | 2021-09-09 | St. Lawrence | New York | 36089 | 8063 | 108 |
1665181 | 1665181 | 2021-08-29 | Clinton | Michigan | 26037 | 8063 | 97 |
1661933 | 1661933 | 2021-08-28 | Clinton | Michigan | 26037 | 8063 | 97 |
1658685 | 1658685 | 2021-08-27 | Clinton | Michigan | 26037 | 8063 | 97 |
1513817 | 1513817 | 2021-07-13 | Greene | Tennessee | 47059 | 8063 | 159 |
1445414 | 1445414 | 2021-06-22 | Somerset | Pennsylvania | 42111 | 8063 | 218 |
1442169 | 1442169 | 2021-06-21 | Somerset | Pennsylvania | 42111 | 8063 | 218 |
1423729 | 1423729 | 2021-06-16 | Santa Cruz | Arizona | 4023 | 8063 | 180 |
1420482 | 1420482 | 2021-06-15 | Santa Cruz | Arizona | 4023 | 8063 | 180 |
1371417 | 1371417 | 2021-05-30 | Frederick | Virginia | 51069 | 8063 | 102 |
1321139 | 1321139 | 2021-05-15 | Rice | Minnesota | 27131 | 8063 | 107 |
1291235 | 1291235 | 2021-05-06 | Bartholomew | Indiana | 18005 | 8063 | 160 |
1261642 | 1261642 | 2021-04-27 | Columbia | Florida | 12023 | 8063 | 168 |
1249053 | 1249053 | 2021-04-23 | Hancock | Indiana | 18059 | 8063 | 143 |
1248105 | 1248105 | 2021-04-22 | Roanoke | Virginia | 51161 | 8063 | 134 |
1092417 | 1092417 | 2021-03-05 | St. Croix | Wisconsin | 55109 | 8063 | 47 |
1088099 | 1088099 | 2021-03-04 | Tuscarawas | Ohio | 39157 | 8063 | 227 |
1088518 | 1088518 | 2021-03-04 | Hamblen | Tennessee | 47063 | 8063 | 165 |
1009141 | 1009141 | 2021-02-08 | Madison | Kentucky | 21151 | 8063 | 65 |
990124 | 990124 | 2021-02-02 | Franklin | Missouri | 29071 | 8063 | 138 |
975196 | 975196 | 2021-01-28 | Starr | Texas | 48427 | 8063 | 230 |
625852 | 625852 | 2020-10-13 | Winnebago | Illinois | 17201 | 8063 | 160 |
524959 | 524959 | 2020-09-12 | Adams | Colorado | 8001 | 8063 | 211 |
323552 | 323552 | 2020-07-11 | Douglas | Nebraska | 31055 | 8063 | 105 |
188274 | 188274 | 2020-05-29 | Lake | Illinois | 17097 | 8063 | 287 |
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);