ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where county = "Unknown", deaths = 1 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
799725 | 799725 | 2020-12-05 | Unknown | Tennessee | 315 | 1 | |
793235 | 793235 | 2020-12-03 | Unknown | Tennessee | 285 | 1 | |
754292 | 754292 | 2020-11-21 | Unknown | Tennessee | 438 | 1 | |
751046 | 751046 | 2020-11-20 | Unknown | Tennessee | 147 | 1 | |
747800 | 747800 | 2020-11-19 | Unknown | Tennessee | 227 | 1 | |
618034 | 618034 | 2020-10-10 | Unknown | Tennessee | 153 | 1 | |
588856 | 588856 | 2020-10-01 | Unknown | Tennessee | 0 | 1 | |
569409 | 569409 | 2020-09-25 | Unknown | Tennessee | 0 | 1 | |
469111 | 469111 | 2020-08-25 | Unknown | Tennessee | 20 | 1 | |
456197 | 456197 | 2020-08-21 | Unknown | Tennessee | 217 | 1 | |
404610 | 404610 | 2020-08-05 | Unknown | Tennessee | 96 | 1 | |
401392 | 401392 | 2020-08-04 | Unknown | Tennessee | 60 | 1 | |
378875 | 378875 | 2020-07-28 | Unknown | Tennessee | 171 | 1 | |
372446 | 372446 | 2020-07-26 | Unknown | Tennessee | 402 | 1 | |
366025 | 366025 | 2020-07-24 | Unknown | Tennessee | 293 | 1 | |
359612 | 359612 | 2020-07-22 | Unknown | Tennessee | 659 | 1 | |
350002 | 350002 | 2020-07-19 | Unknown | Tennessee | 0 | 1 | |
346802 | 346802 | 2020-07-18 | Unknown | Tennessee | 0 | 1 | |
343602 | 343602 | 2020-07-17 | Unknown | Tennessee | 0 | 1 | |
337207 | 337207 | 2020-07-15 | Unknown | Tennessee | 0 | 1 | |
327635 | 327635 | 2020-07-12 | Unknown | Tennessee | 0 | 1 | |
324450 | 324450 | 2020-07-11 | Unknown | Tennessee | 0 | 1 | |
321269 | 321269 | 2020-07-10 | Unknown | Tennessee | 0 | 1 | |
318091 | 318091 | 2020-07-09 | Unknown | Tennessee | 0 | 1 | |
314918 | 314918 | 2020-07-08 | Unknown | Tennessee | 185 | 1 | |
311744 | 311744 | 2020-07-07 | Unknown | Tennessee | 0 | 1 | |
308575 | 308575 | 2020-07-06 | Unknown | Tennessee | 0 | 1 | |
305407 | 305407 | 2020-07-05 | Unknown | Tennessee | 0 | 1 | |
292764 | 292764 | 2020-07-01 | Unknown | Tennessee | 0 | 1 | |
165739 | 165739 | 2020-05-21 | Unknown | Tennessee | 107 | 1 | |
13733 | 13733 | 2020-03-26 | Unknown | Tennessee | 110 | 1 | |
12106 | 12106 | 2020-03-25 | Unknown | Tennessee | 78 | 1 |
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);