ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 51 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
575895 | 575895 | 2020-09-27 | Unknown | Tennessee | 51 | 3 | |
459425 | 459425 | 2020-08-22 | Van Buren | Tennessee | 47175 | 51 | 0 |
391707 | 391707 | 2020-08-01 | Lewis | Tennessee | 47101 | 51 | 1 |
369211 | 369211 | 2020-07-25 | Morgan | Tennessee | 47129 | 51 | 1 |
349975 | 349975 | 2020-07-19 | Meigs | Tennessee | 47121 | 51 | 0 |
346760 | 346760 | 2020-07-18 | Johnson | Tennessee | 47091 | 51 | 0 |
343560 | 343560 | 2020-07-17 | Johnson | Tennessee | 47091 | 51 | 0 |
340362 | 340362 | 2020-07-16 | Johnson | Tennessee | 47091 | 51 | 0 |
324402 | 324402 | 2020-07-11 | Henry | Tennessee | 47079 | 51 | 0 |
318012 | 318012 | 2020-07-09 | Carroll | Tennessee | 47017 | 51 | 1 |
318073 | 318073 | 2020-07-09 | Polk | Tennessee | 47139 | 51 | 0 |
308494 | 308494 | 2020-07-06 | Campbell | Tennessee | 47013 | 51 | 1 |
292713 | 292713 | 2020-07-01 | Hawkins | Tennessee | 47073 | 51 | 2 |
289561 | 289561 | 2020-06-30 | Hawkins | Tennessee | 47073 | 51 | 2 |
286388 | 286388 | 2020-06-29 | Cocke | Tennessee | 47029 | 51 | 0 |
283295 | 283295 | 2020-06-28 | Overton | Tennessee | 47133 | 51 | 0 |
280149 | 280149 | 2020-06-27 | Overton | Tennessee | 47133 | 51 | 0 |
273839 | 273839 | 2020-06-25 | Lincoln | Tennessee | 47103 | 51 | 0 |
270700 | 270700 | 2020-06-24 | Lincoln | Tennessee | 47103 | 51 | 0 |
267545 | 267545 | 2020-06-23 | Grundy | Tennessee | 47061 | 51 | 1 |
267594 | 267594 | 2020-06-23 | Smith | Tennessee | 47159 | 51 | 1 |
255041 | 255041 | 2020-06-19 | Hardin | Tennessee | 47071 | 51 | 5 |
251935 | 251935 | 2020-06-18 | Jefferson | Tennessee | 47089 | 51 | 0 |
251983 | 251983 | 2020-06-18 | White | Tennessee | 47185 | 51 | 2 |
190053 | 190053 | 2020-05-29 | Franklin | Tennessee | 47051 | 51 | 1 |
174818 | 174818 | 2020-05-24 | Lauderdale | Tennessee | 47097 | 51 | 1 |
171775 | 171775 | 2020-05-23 | Lauderdale | Tennessee | 47097 | 51 | 1 |
168736 | 168736 | 2020-05-22 | Lauderdale | Tennessee | 47097 | 51 | 1 |
165700 | 165700 | 2020-05-21 | Lauderdale | Tennessee | 47097 | 51 | 1 |
162684 | 162684 | 2020-05-20 | Monroe | Tennessee | 47123 | 51 | 2 |
159657 | 159657 | 2020-05-19 | Monroe | Tennessee | 47123 | 51 | 2 |
120681 | 120681 | 2020-05-06 | Maury | Tennessee | 47119 | 51 | 1 |
111898 | 111898 | 2020-05-03 | Sevier | Tennessee | 47155 | 51 | 1 |
111902 | 111902 | 2020-05-03 | Sullivan | Tennessee | 47163 | 51 | 1 |
89054 | 89054 | 2020-04-25 | Fayette | Tennessee | 47047 | 51 | 1 |
58568 | 58568 | 2020-04-14 | Cumberland | Tennessee | 47035 | 51 | 0 |
35123 | 35123 | 2020-04-05 | Montgomery | Tennessee | 47125 | 51 | 1 |
32694 | 32694 | 2020-04-04 | Robertson | Tennessee | 47147 | 51 | 0 |
30303 | 30303 | 2020-04-03 | Robertson | Tennessee | 47147 | 51 | 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);