ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 86 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 21
county 21
- Washington 4
- Monroe 3
- Dickson 2
- Unknown 2
- Claiborne 1
- Clay 1
- Cumberland 1
- Dyer 1
- Fayette 1
- Greene 1
- Hawkins 1
- Lauderdale 1
- Lincoln 1
- Madison 1
- Moore 1
- Overton 1
- Perry 1
- Rutherford 1
- Sequatchie 1
- Wayne 1
- White 1
state 1
- Tennessee · 28 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
472319 | 472319 | 2020-08-26 | Moore | Tennessee | 47127 | 86 | 0 |
433534 | 433534 | 2020-08-14 | Clay | Tennessee | 47027 | 86 | 0 |
433588 | 433588 | 2020-08-14 | Perry | Tennessee | 47135 | 86 | 0 |
420711 | 420711 | 2020-08-10 | Unknown | Tennessee | 86 | 0 | |
378864 | 378864 | 2020-07-28 | Sequatchie | Tennessee | 47153 | 86 | 0 |
337132 | 337132 | 2020-07-15 | Claiborne | Tennessee | 47025 | 86 | 0 |
337186 | 337186 | 2020-07-15 | Overton | Tennessee | 47133 | 86 | 1 |
327641 | 327641 | 2020-07-12 | White | Tennessee | 47185 | 86 | 3 |
324399 | 324399 | 2020-07-11 | Hawkins | Tennessee | 47073 | 86 | 2 |
324414 | 324414 | 2020-07-11 | Lincoln | Tennessee | 47103 | 86 | 0 |
305411 | 305411 | 2020-07-05 | Wayne | Tennessee | 47181 | 86 | 0 |
295862 | 295862 | 2020-07-02 | Greene | Tennessee | 47059 | 86 | 2 |
273836 | 273836 | 2020-06-25 | Lauderdale | Tennessee | 47097 | 86 | 2 |
242612 | 242612 | 2020-06-15 | Monroe | Tennessee | 47123 | 86 | 4 |
239502 | 239502 | 2020-06-14 | Monroe | Tennessee | 47123 | 86 | 4 |
236355 | 236355 | 2020-06-13 | Dyer | Tennessee | 47045 | 86 | 0 |
236394 | 236394 | 2020-06-13 | Monroe | Tennessee | 47123 | 86 | 4 |
224008 | 224008 | 2020-06-09 | Washington | Tennessee | 47179 | 86 | 0 |
220913 | 220913 | 2020-06-08 | Washington | Tennessee | 47179 | 86 | 0 |
217821 | 217821 | 2020-06-07 | Washington | Tennessee | 47179 | 86 | 0 |
214731 | 214731 | 2020-06-06 | Washington | Tennessee | 47179 | 86 | 0 |
150633 | 150633 | 2020-05-16 | Unknown | Tennessee | 86 | 0 | |
144561 | 144561 | 2020-05-14 | Fayette | Tennessee | 47047 | 86 | 2 |
138562 | 138562 | 2020-05-12 | Cumberland | Tennessee | 47035 | 86 | 1 |
135576 | 135576 | 2020-05-11 | Dickson | Tennessee | 47043 | 86 | 0 |
132585 | 132585 | 2020-05-10 | Dickson | Tennessee | 47043 | 86 | 0 |
72318 | 72318 | 2020-04-19 | Madison | Tennessee | 47113 | 86 | 1 |
25689 | 25689 | 2020-04-01 | Rutherford | Tennessee | 47149 | 86 | 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);