ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Washington" and state = "Tennessee" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5040 | 5040 | 2020-03-19 | Washington | Tennessee | 47179 | 2 | 0 |
5929 | 5929 | 2020-03-20 | Washington | Tennessee | 47179 | 2 | 0 |
6946 | 6946 | 2020-03-21 | Washington | Tennessee | 47179 | 2 | 0 |
8076 | 8076 | 2020-03-22 | Washington | Tennessee | 47179 | 2 | 0 |
9294 | 9294 | 2020-03-23 | Washington | Tennessee | 47179 | 2 | 0 |
10628 | 10628 | 2020-03-24 | Washington | Tennessee | 47179 | 7 | 0 |
12107 | 12107 | 2020-03-25 | Washington | Tennessee | 47179 | 7 | 0 |
13734 | 13734 | 2020-03-26 | Washington | Tennessee | 47179 | 9 | 0 |
15487 | 15487 | 2020-03-27 | Washington | Tennessee | 47179 | 10 | 0 |
17353 | 17353 | 2020-03-28 | Washington | Tennessee | 47179 | 14 | 0 |
19303 | 19303 | 2020-03-29 | Washington | Tennessee | 47179 | 14 | 0 |
21361 | 21361 | 2020-03-30 | Washington | Tennessee | 47179 | 14 | 0 |
23500 | 23500 | 2020-03-31 | Washington | Tennessee | 47179 | 14 | 0 |
30318 | 30318 | 2020-04-03 | Washington | Tennessee | 47179 | 20 | 0 |
25703 | 25703 | 2020-04-01 | Washington | Tennessee | 47179 | 21 | 0 |
27983 | 27983 | 2020-04-02 | Washington | Tennessee | 47179 | 21 | 0 |
32710 | 32710 | 2020-04-04 | Washington | Tennessee | 47179 | 22 | 0 |
35147 | 35147 | 2020-04-05 | Washington | Tennessee | 47179 | 23 | 0 |
37623 | 37623 | 2020-04-06 | Washington | Tennessee | 47179 | 24 | 0 |
40145 | 40145 | 2020-04-07 | Washington | Tennessee | 47179 | 27 | 0 |
42707 | 42707 | 2020-04-08 | Washington | Tennessee | 47179 | 30 | 0 |
45295 | 45295 | 2020-04-09 | Washington | Tennessee | 47179 | 32 | 0 |
47913 | 47913 | 2020-04-10 | Washington | Tennessee | 47179 | 37 | 0 |
50570 | 50570 | 2020-04-11 | Washington | Tennessee | 47179 | 37 | 0 |
53245 | 53245 | 2020-04-12 | Washington | Tennessee | 47179 | 37 | 0 |
55933 | 55933 | 2020-04-13 | Washington | Tennessee | 47179 | 42 | 0 |
58636 | 58636 | 2020-04-14 | Washington | Tennessee | 47179 | 44 | 0 |
61352 | 61352 | 2020-04-15 | Washington | Tennessee | 47179 | 45 | 0 |
64079 | 64079 | 2020-04-16 | Washington | Tennessee | 47179 | 46 | 0 |
66826 | 66826 | 2020-04-17 | Washington | Tennessee | 47179 | 46 | 0 |
69585 | 69585 | 2020-04-18 | Washington | Tennessee | 47179 | 46 | 0 |
72352 | 72352 | 2020-04-19 | Washington | Tennessee | 47179 | 46 | 0 |
75127 | 75127 | 2020-04-20 | Washington | Tennessee | 47179 | 46 | 0 |
77909 | 77909 | 2020-04-21 | Washington | Tennessee | 47179 | 46 | 0 |
80699 | 80699 | 2020-04-22 | Washington | Tennessee | 47179 | 46 | 0 |
83498 | 83498 | 2020-04-23 | Washington | Tennessee | 47179 | 46 | 0 |
86303 | 86303 | 2020-04-24 | Washington | Tennessee | 47179 | 46 | 0 |
89118 | 89118 | 2020-04-25 | Washington | Tennessee | 47179 | 49 | 0 |
91935 | 91935 | 2020-04-26 | Washington | Tennessee | 47179 | 52 | 0 |
94763 | 94763 | 2020-04-27 | Washington | Tennessee | 47179 | 54 | 0 |
97603 | 97603 | 2020-04-28 | Washington | Tennessee | 47179 | 54 | 0 |
100453 | 100453 | 2020-04-29 | Washington | Tennessee | 47179 | 54 | 0 |
103306 | 103306 | 2020-04-30 | Washington | Tennessee | 47179 | 54 | 0 |
106169 | 106169 | 2020-05-01 | Washington | Tennessee | 47179 | 55 | 0 |
109036 | 109036 | 2020-05-02 | Washington | Tennessee | 47179 | 57 | 0 |
111910 | 111910 | 2020-05-03 | Washington | Tennessee | 47179 | 57 | 0 |
114792 | 114792 | 2020-05-04 | Washington | Tennessee | 47179 | 57 | 0 |
117748 | 117748 | 2020-05-05 | Washington | Tennessee | 47179 | 58 | 0 |
120712 | 120712 | 2020-05-06 | Washington | Tennessee | 47179 | 59 | 0 |
123691 | 123691 | 2020-05-07 | Washington | Tennessee | 47179 | 59 | 0 |
126674 | 126674 | 2020-05-08 | Washington | Tennessee | 47179 | 60 | 0 |
129663 | 129663 | 2020-05-09 | Washington | Tennessee | 47179 | 61 | 0 |
132653 | 132653 | 2020-05-10 | Washington | Tennessee | 47179 | 61 | 0 |
141630 | 141630 | 2020-05-13 | Washington | Tennessee | 47179 | 64 | 0 |
135644 | 135644 | 2020-05-11 | Washington | Tennessee | 47179 | 65 | 0 |
138634 | 138634 | 2020-05-12 | Washington | Tennessee | 47179 | 65 | 0 |
144627 | 144627 | 2020-05-14 | Washington | Tennessee | 47179 | 66 | 0 |
147628 | 147628 | 2020-05-15 | Washington | Tennessee | 47179 | 66 | 0 |
150636 | 150636 | 2020-05-16 | Washington | Tennessee | 47179 | 66 | 0 |
153647 | 153647 | 2020-05-17 | Washington | Tennessee | 47179 | 66 | 0 |
156664 | 156664 | 2020-05-18 | Washington | Tennessee | 47179 | 66 | 0 |
165742 | 165742 | 2020-05-21 | Washington | Tennessee | 47179 | 68 | 0 |
168778 | 168778 | 2020-05-22 | Washington | Tennessee | 47179 | 68 | 0 |
159686 | 159686 | 2020-05-19 | Washington | Tennessee | 47179 | 70 | 0 |
162713 | 162713 | 2020-05-20 | Washington | Tennessee | 47179 | 70 | 0 |
171817 | 171817 | 2020-05-23 | Washington | Tennessee | 47179 | 72 | 0 |
174860 | 174860 | 2020-05-24 | Washington | Tennessee | 47179 | 73 | 0 |
177904 | 177904 | 2020-05-25 | Washington | Tennessee | 47179 | 73 | 0 |
180947 | 180947 | 2020-05-26 | Washington | Tennessee | 47179 | 75 | 0 |
183997 | 183997 | 2020-05-27 | Washington | Tennessee | 47179 | 75 | 0 |
187054 | 187054 | 2020-05-28 | Washington | Tennessee | 47179 | 75 | 0 |
190118 | 190118 | 2020-05-29 | Washington | Tennessee | 47179 | 75 | 0 |
193183 | 193183 | 2020-05-30 | Washington | Tennessee | 47179 | 75 | 0 |
196253 | 196253 | 2020-05-31 | Washington | Tennessee | 47179 | 75 | 0 |
199326 | 199326 | 2020-06-01 | Washington | Tennessee | 47179 | 75 | 0 |
202401 | 202401 | 2020-06-02 | Washington | Tennessee | 47179 | 75 | 0 |
205480 | 205480 | 2020-06-03 | Washington | Tennessee | 47179 | 75 | 0 |
208562 | 208562 | 2020-06-04 | Washington | Tennessee | 47179 | 75 | 0 |
211644 | 211644 | 2020-06-05 | Washington | Tennessee | 47179 | 76 | 0 |
214731 | 214731 | 2020-06-06 | Washington | Tennessee | 47179 | 86 | 0 |
217821 | 217821 | 2020-06-07 | Washington | Tennessee | 47179 | 86 | 0 |
220913 | 220913 | 2020-06-08 | Washington | Tennessee | 47179 | 86 | 0 |
224008 | 224008 | 2020-06-09 | Washington | Tennessee | 47179 | 86 | 0 |
227108 | 227108 | 2020-06-10 | Washington | Tennessee | 47179 | 87 | 0 |
230212 | 230212 | 2020-06-11 | Washington | Tennessee | 47179 | 88 | 0 |
233316 | 233316 | 2020-06-12 | Washington | Tennessee | 47179 | 88 | 0 |
236422 | 236422 | 2020-06-13 | Washington | Tennessee | 47179 | 90 | 0 |
239530 | 239530 | 2020-06-14 | Washington | Tennessee | 47179 | 90 | 0 |
242640 | 242640 | 2020-06-15 | Washington | Tennessee | 47179 | 90 | 0 |
245752 | 245752 | 2020-06-16 | Washington | Tennessee | 47179 | 91 | 0 |
248865 | 248865 | 2020-06-17 | Washington | Tennessee | 47179 | 93 | 0 |
251980 | 251980 | 2020-06-18 | Washington | Tennessee | 47179 | 99 | 0 |
255095 | 255095 | 2020-06-19 | Washington | Tennessee | 47179 | 101 | 0 |
258221 | 258221 | 2020-06-20 | Washington | Tennessee | 47179 | 101 | 0 |
261348 | 261348 | 2020-06-21 | Washington | Tennessee | 47179 | 102 | 0 |
264476 | 264476 | 2020-06-22 | Washington | Tennessee | 47179 | 103 | 0 |
267604 | 267604 | 2020-06-23 | Washington | Tennessee | 47179 | 107 | 0 |
270738 | 270738 | 2020-06-24 | Washington | Tennessee | 47179 | 109 | 0 |
273877 | 273877 | 2020-06-25 | Washington | Tennessee | 47179 | 112 | 0 |
277024 | 277024 | 2020-06-26 | Washington | Tennessee | 47179 | 118 | 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);