ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 80 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
514358 | 514358 | 2020-09-08 | Pickett | Tennessee | 47137 | 80 | 1 |
511125 | 511125 | 2020-09-07 | Pickett | Tennessee | 47137 | 80 | 1 |
491745 | 491745 | 2020-09-01 | Van Buren | Tennessee | 47175 | 80 | 0 |
449717 | 449717 | 2020-08-19 | Moore | Tennessee | 47127 | 80 | 0 |
430346 | 430346 | 2020-08-13 | Lewis | Tennessee | 47101 | 80 | 1 |
417436 | 417436 | 2020-08-09 | Hancock | Tennessee | 47067 | 80 | 2 |
388442 | 388442 | 2020-07-31 | Benton | Tennessee | 47005 | 80 | 1 |
385298 | 385298 | 2020-07-30 | Scott | Tennessee | 47151 | 80 | 0 |
353126 | 353126 | 2020-07-20 | Carroll | Tennessee | 47017 | 80 | 2 |
333938 | 333938 | 2020-07-14 | Claiborne | Tennessee | 47025 | 80 | 0 |
333992 | 333992 | 2020-07-14 | Overton | Tennessee | 47133 | 80 | 1 |
321254 | 321254 | 2020-07-10 | Roane | Tennessee | 47145 | 80 | 0 |
318031 | 318031 | 2020-07-09 | Giles | Tennessee | 47055 | 80 | 1 |
318055 | 318055 | 2020-07-09 | Lincoln | Tennessee | 47103 | 80 | 0 |
318097 | 318097 | 2020-07-09 | White | Tennessee | 47185 | 80 | 3 |
308528 | 308528 | 2020-07-06 | Hickman | Tennessee | 47081 | 80 | 0 |
305360 | 305360 | 2020-07-05 | Hickman | Tennessee | 47081 | 80 | 0 |
302197 | 302197 | 2020-07-04 | Hickman | Tennessee | 47081 | 80 | 0 |
299033 | 299033 | 2020-07-03 | Hickman | Tennessee | 47081 | 80 | 0 |
295923 | 295923 | 2020-07-02 | Wayne | Tennessee | 47181 | 80 | 0 |
292702 | 292702 | 2020-07-01 | Franklin | Tennessee | 47051 | 80 | 3 |
273823 | 273823 | 2020-06-25 | Hardin | Tennessee | 47071 | 80 | 5 |
273832 | 273832 | 2020-06-25 | Jefferson | Tennessee | 47089 | 80 | 0 |
270675 | 270675 | 2020-06-24 | Gibson | Tennessee | 47053 | 80 | 1 |
267541 | 267541 | 2020-06-23 | Gibson | Tennessee | 47053 | 80 | 1 |
190105 | 190105 | 2020-05-29 | Sevier | Tennessee | 47155 | 80 | 2 |
180914 | 180914 | 2020-05-26 | Maury | Tennessee | 47119 | 80 | 0 |
144543 | 144543 | 2020-05-14 | Bradley | Tennessee | 47011 | 80 | 1 |
138631 | 138631 | 2020-05-12 | Unknown | Tennessee | 80 | 0 | |
135578 | 135578 | 2020-05-11 | Fayette | Tennessee | 47047 | 80 | 1 |
111840 | 111840 | 2020-05-03 | Cumberland | Tennessee | 47035 | 80 | 1 |
111844 | 111844 | 2020-05-03 | Dickson | Tennessee | 47043 | 80 | 0 |
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);