ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where cases = 27 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 |
---|---|---|---|---|---|---|---|
411049 | 411049 | 2020-08-07 | Unknown | Tennessee | 27 | 3 | |
404591 | 404591 | 2020-08-05 | Pickett | Tennessee | 47137 | 27 | 1 |
362782 | 362782 | 2020-07-23 | Lewis | Tennessee | 47101 | 27 | 0 |
343556 | 343556 | 2020-07-17 | Houston | Tennessee | 47083 | 27 | 0 |
333939 | 333939 | 2020-07-14 | Clay | Tennessee | 47027 | 27 | 0 |
330814 | 330814 | 2020-07-13 | Stewart | Tennessee | 47161 | 27 | 0 |
327572 | 327572 | 2020-07-12 | Fentress | Tennessee | 47049 | 27 | 0 |
324383 | 324383 | 2020-07-11 | Decatur | Tennessee | 47039 | 27 | 0 |
321206 | 321206 | 2020-07-10 | Fentress | Tennessee | 47049 | 27 | 0 |
321262 | 321262 | 2020-07-10 | Stewart | Tennessee | 47161 | 27 | 0 |
308552 | 308552 | 2020-07-06 | Morgan | Tennessee | 47129 | 27 | 1 |
305363 | 305363 | 2020-07-05 | Jackson | Tennessee | 47087 | 27 | 0 |
305384 | 305384 | 2020-07-05 | Morgan | Tennessee | 47129 | 27 | 1 |
302199 | 302199 | 2020-07-04 | Humphreys | Tennessee | 47085 | 27 | 1 |
299035 | 299035 | 2020-07-03 | Humphreys | Tennessee | 47085 | 27 | 1 |
289532 | 289532 | 2020-06-30 | Cannon | Tennessee | 47015 | 27 | 0 |
276951 | 276951 | 2020-06-26 | Crockett | Tennessee | 47033 | 27 | 3 |
276963 | 276963 | 2020-06-26 | Grainger | Tennessee | 47057 | 27 | 0 |
273826 | 273826 | 2020-06-25 | Henderson | Tennessee | 47077 | 27 | 0 |
270655 | 270655 | 2020-06-24 | Campbell | Tennessee | 47013 | 27 | 1 |
270694 | 270694 | 2020-06-24 | Johnson | Tennessee | 47091 | 27 | 0 |
267521 | 267521 | 2020-06-23 | Campbell | Tennessee | 47013 | 27 | 1 |
255015 | 255015 | 2020-06-19 | Carter | Tennessee | 47019 | 27 | 1 |
255020 | 255020 | 2020-06-19 | Cocke | Tennessee | 47029 | 27 | 0 |
251905 | 251905 | 2020-06-18 | Cocke | Tennessee | 47029 | 27 | 0 |
248790 | 248790 | 2020-06-17 | Cocke | Tennessee | 47029 | 27 | 0 |
245677 | 245677 | 2020-06-16 | Cocke | Tennessee | 47029 | 27 | 0 |
242618 | 242618 | 2020-06-15 | Perry | Tennessee | 47135 | 27 | 0 |
239500 | 239500 | 2020-06-14 | McNairy | Tennessee | 47109 | 27 | 0 |
239508 | 239508 | 2020-06-14 | Perry | Tennessee | 47135 | 27 | 0 |
236392 | 236392 | 2020-06-13 | McNairy | Tennessee | 47109 | 27 | 0 |
236400 | 236400 | 2020-06-13 | Perry | Tennessee | 47135 | 27 | 0 |
230214 | 230214 | 2020-06-11 | Weakley | Tennessee | 47183 | 27 | 0 |
227078 | 227078 | 2020-06-10 | Meigs | Tennessee | 47121 | 27 | 0 |
223978 | 223978 | 2020-06-09 | Meigs | Tennessee | 47121 | 27 | 0 |
220883 | 220883 | 2020-06-08 | Meigs | Tennessee | 47121 | 27 | 0 |
217791 | 217791 | 2020-06-07 | Meigs | Tennessee | 47121 | 27 | 0 |
214701 | 214701 | 2020-06-06 | Meigs | Tennessee | 47121 | 27 | 0 |
211614 | 211614 | 2020-06-05 | Meigs | Tennessee | 47121 | 27 | 0 |
211643 | 211643 | 2020-06-05 | Warren | Tennessee | 47177 | 27 | 0 |
208532 | 208532 | 2020-06-04 | Meigs | Tennessee | 47121 | 27 | 0 |
205450 | 205450 | 2020-06-03 | Meigs | Tennessee | 47121 | 27 | 0 |
202371 | 202371 | 2020-06-02 | Meigs | Tennessee | 47121 | 27 | 0 |
199244 | 199244 | 2020-06-01 | Carroll | Tennessee | 47017 | 27 | 1 |
196171 | 196171 | 2020-05-31 | Carroll | Tennessee | 47017 | 27 | 1 |
193101 | 193101 | 2020-05-30 | Carroll | Tennessee | 47017 | 27 | 1 |
190036 | 190036 | 2020-05-29 | Carroll | Tennessee | 47017 | 27 | 1 |
186972 | 186972 | 2020-05-28 | Carroll | Tennessee | 47017 | 27 | 1 |
183915 | 183915 | 2020-05-27 | Carroll | Tennessee | 47017 | 27 | 1 |
180865 | 180865 | 2020-05-26 | Carroll | Tennessee | 47017 | 27 | 1 |
180922 | 180922 | 2020-05-26 | Obion | Tennessee | 47131 | 27 | 1 |
180950 | 180950 | 2020-05-26 | White | Tennessee | 47185 | 27 | 0 |
177822 | 177822 | 2020-05-25 | Carroll | Tennessee | 47017 | 27 | 1 |
177858 | 177858 | 2020-05-25 | Jefferson | Tennessee | 47089 | 27 | 0 |
177907 | 177907 | 2020-05-25 | White | Tennessee | 47185 | 27 | 0 |
174778 | 174778 | 2020-05-24 | Carroll | Tennessee | 47017 | 27 | 1 |
174814 | 174814 | 2020-05-24 | Jefferson | Tennessee | 47089 | 27 | 0 |
174826 | 174826 | 2020-05-24 | Marshall | Tennessee | 47117 | 27 | 1 |
174863 | 174863 | 2020-05-24 | White | Tennessee | 47185 | 27 | 0 |
171735 | 171735 | 2020-05-23 | Carroll | Tennessee | 47017 | 27 | 1 |
171771 | 171771 | 2020-05-23 | Jefferson | Tennessee | 47089 | 27 | 0 |
171783 | 171783 | 2020-05-23 | Marshall | Tennessee | 47117 | 27 | 1 |
168732 | 168732 | 2020-05-22 | Jefferson | Tennessee | 47089 | 27 | 0 |
165696 | 165696 | 2020-05-21 | Jefferson | Tennessee | 47089 | 27 | 0 |
165708 | 165708 | 2020-05-21 | Marshall | Tennessee | 47117 | 27 | 1 |
162715 | 162715 | 2020-05-20 | Weakley | Tennessee | 47183 | 27 | 0 |
159688 | 159688 | 2020-05-19 | Weakley | Tennessee | 47183 | 27 | 0 |
156630 | 156630 | 2020-05-18 | Marshall | Tennessee | 47117 | 27 | 1 |
132583 | 132583 | 2020-05-10 | DeKalb | Tennessee | 47041 | 27 | 0 |
129594 | 129594 | 2020-05-09 | DeKalb | Tennessee | 47041 | 27 | 0 |
117697 | 117697 | 2020-05-05 | Haywood | Tennessee | 47075 | 27 | 1 |
117704 | 117704 | 2020-05-05 | Jefferson | Tennessee | 47089 | 27 | 0 |
114741 | 114741 | 2020-05-04 | Haywood | Tennessee | 47075 | 27 | 1 |
100366 | 100366 | 2020-04-29 | Anderson | Tennessee | 47001 | 27 | 1 |
94727 | 94727 | 2020-04-27 | Loudon | Tennessee | 47105 | 27 | 0 |
91899 | 91899 | 2020-04-26 | Loudon | Tennessee | 47105 | 27 | 0 |
86231 | 86231 | 2020-04-24 | Coffee | Tennessee | 47031 | 27 | 0 |
83441 | 83441 | 2020-04-23 | Grundy | Tennessee | 47061 | 27 | 1 |
83493 | 83493 | 2020-04-23 | Trousdale | Tennessee | 47169 | 27 | 1 |
80694 | 80694 | 2020-04-22 | Trousdale | Tennessee | 47169 | 27 | 1 |
77847 | 77847 | 2020-04-21 | Franklin | Tennessee | 47051 | 27 | 1 |
75065 | 75065 | 2020-04-20 | Franklin | Tennessee | 47051 | 27 | 1 |
75075 | 75075 | 2020-04-20 | Hawkins | Tennessee | 47073 | 27 | 2 |
72300 | 72300 | 2020-04-19 | Hawkins | Tennessee | 47073 | 27 | 2 |
69533 | 69533 | 2020-04-18 | Hawkins | Tennessee | 47073 | 27 | 2 |
66765 | 66765 | 2020-04-17 | Gibson | Tennessee | 47053 | 27 | 0 |
66774 | 66774 | 2020-04-17 | Hawkins | Tennessee | 47073 | 27 | 2 |
64047 | 64047 | 2020-04-16 | Marion | Tennessee | 47115 | 27 | 1 |
61320 | 61320 | 2020-04-15 | Marion | Tennessee | 47115 | 27 | 1 |
58580 | 58580 | 2020-04-14 | Greene | Tennessee | 47059 | 27 | 2 |
58603 | 58603 | 2020-04-14 | Macon | Tennessee | 47111 | 27 | 2 |
55877 | 55877 | 2020-04-13 | Greene | Tennessee | 47059 | 27 | 1 |
42645 | 42645 | 2020-04-08 | Dickson | Tennessee | 47043 | 27 | 0 |
42700 | 42700 | 2020-04-08 | Sullivan | Tennessee | 47163 | 27 | 1 |
40083 | 40083 | 2020-04-07 | Dickson | Tennessee | 47043 | 27 | 0 |
40145 | 40145 | 2020-04-07 | Washington | Tennessee | 47179 | 27 | 0 |
25681 | 25681 | 2020-04-01 | Montgomery | Tennessee | 47125 | 27 | 0 |
23486 | 23486 | 2020-03-31 | Robertson | Tennessee | 47147 | 27 | 0 |
21347 | 21347 | 2020-03-30 | Robertson | Tennessee | 47147 | 27 | 0 |
19307 | 19307 | 2020-03-29 | Wilson | Tennessee | 47189 | 27 | 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);