ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 124 and fips = 47089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1306086 | 1306086 | 2021-05-10 | Jefferson | Tennessee | 47089 | 6222 | 124 |
1302840 | 1302840 | 2021-05-09 | Jefferson | Tennessee | 47089 | 6211 | 124 |
1299593 | 1299593 | 2021-05-08 | Jefferson | Tennessee | 47089 | 6211 | 124 |
1296346 | 1296346 | 2021-05-07 | Jefferson | Tennessee | 47089 | 6211 | 124 |
1293100 | 1293100 | 2021-05-06 | Jefferson | Tennessee | 47089 | 6198 | 124 |
1289854 | 1289854 | 2021-05-05 | Jefferson | Tennessee | 47089 | 6186 | 124 |
1286608 | 1286608 | 2021-05-04 | Jefferson | Tennessee | 47089 | 6177 | 124 |
1283362 | 1283362 | 2021-05-03 | Jefferson | Tennessee | 47089 | 6167 | 124 |
1267127 | 1267127 | 2021-04-28 | Jefferson | Tennessee | 47089 | 6139 | 124 |
1263880 | 1263880 | 2021-04-27 | Jefferson | Tennessee | 47089 | 6129 | 124 |
1260633 | 1260633 | 2021-04-26 | Jefferson | Tennessee | 47089 | 6122 | 124 |
1257386 | 1257386 | 2021-04-25 | Jefferson | Tennessee | 47089 | 6106 | 124 |
1254139 | 1254139 | 2021-04-24 | Jefferson | Tennessee | 47089 | 6106 | 124 |
1250892 | 1250892 | 2021-04-23 | Jefferson | Tennessee | 47089 | 6106 | 124 |
1247645 | 1247645 | 2021-04-22 | Jefferson | Tennessee | 47089 | 6098 | 124 |
1244398 | 1244398 | 2021-04-21 | Jefferson | Tennessee | 47089 | 6089 | 124 |
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);