ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Greene" 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 |
---|---|---|---|---|---|---|---|
5914 | 5914 | 2020-03-20 | Greene | Tennessee | 47059 | 1 | 0 |
6927 | 6927 | 2020-03-21 | Greene | Tennessee | 47059 | 1 | 0 |
8052 | 8052 | 2020-03-22 | Greene | Tennessee | 47059 | 2 | 0 |
9270 | 9270 | 2020-03-23 | Greene | Tennessee | 47059 | 2 | 0 |
10599 | 10599 | 2020-03-24 | Greene | Tennessee | 47059 | 5 | 0 |
12076 | 12076 | 2020-03-25 | Greene | Tennessee | 47059 | 7 | 0 |
13700 | 13700 | 2020-03-26 | Greene | Tennessee | 47059 | 8 | 0 |
15452 | 15452 | 2020-03-27 | Greene | Tennessee | 47059 | 8 | 0 |
17313 | 17313 | 2020-03-28 | Greene | Tennessee | 47059 | 8 | 0 |
19259 | 19259 | 2020-03-29 | Greene | Tennessee | 47059 | 9 | 0 |
21314 | 21314 | 2020-03-30 | Greene | Tennessee | 47059 | 12 | 0 |
23452 | 23452 | 2020-03-31 | Greene | Tennessee | 47059 | 12 | 0 |
25652 | 25652 | 2020-04-01 | Greene | Tennessee | 47059 | 15 | 1 |
27930 | 27930 | 2020-04-02 | Greene | Tennessee | 47059 | 16 | 1 |
30265 | 30265 | 2020-04-03 | Greene | Tennessee | 47059 | 16 | 1 |
32656 | 32656 | 2020-04-04 | Greene | Tennessee | 47059 | 16 | 1 |
35092 | 35092 | 2020-04-05 | Greene | Tennessee | 47059 | 17 | 1 |
37568 | 37568 | 2020-04-06 | Greene | Tennessee | 47059 | 17 | 1 |
40091 | 40091 | 2020-04-07 | Greene | Tennessee | 47059 | 18 | 1 |
42653 | 42653 | 2020-04-08 | Greene | Tennessee | 47059 | 20 | 1 |
45240 | 45240 | 2020-04-09 | Greene | Tennessee | 47059 | 22 | 1 |
47858 | 47858 | 2020-04-10 | Greene | Tennessee | 47059 | 25 | 1 |
50516 | 50516 | 2020-04-11 | Greene | Tennessee | 47059 | 26 | 1 |
53191 | 53191 | 2020-04-12 | Greene | Tennessee | 47059 | 26 | 1 |
55877 | 55877 | 2020-04-13 | Greene | Tennessee | 47059 | 27 | 1 |
58580 | 58580 | 2020-04-14 | Greene | Tennessee | 47059 | 27 | 2 |
61295 | 61295 | 2020-04-15 | Greene | Tennessee | 47059 | 28 | 2 |
64022 | 64022 | 2020-04-16 | Greene | Tennessee | 47059 | 29 | 2 |
66768 | 66768 | 2020-04-17 | Greene | Tennessee | 47059 | 30 | 2 |
69527 | 69527 | 2020-04-18 | Greene | Tennessee | 47059 | 30 | 2 |
72294 | 72294 | 2020-04-19 | Greene | Tennessee | 47059 | 30 | 2 |
75069 | 75069 | 2020-04-20 | Greene | Tennessee | 47059 | 35 | 2 |
77851 | 77851 | 2020-04-21 | Greene | Tennessee | 47059 | 37 | 2 |
80641 | 80641 | 2020-04-22 | Greene | Tennessee | 47059 | 37 | 2 |
83440 | 83440 | 2020-04-23 | Greene | Tennessee | 47059 | 38 | 2 |
86245 | 86245 | 2020-04-24 | Greene | Tennessee | 47059 | 41 | 2 |
89060 | 89060 | 2020-04-25 | Greene | Tennessee | 47059 | 41 | 2 |
91877 | 91877 | 2020-04-26 | Greene | Tennessee | 47059 | 41 | 2 |
94705 | 94705 | 2020-04-27 | Greene | Tennessee | 47059 | 41 | 2 |
97545 | 97545 | 2020-04-28 | Greene | Tennessee | 47059 | 42 | 2 |
100395 | 100395 | 2020-04-29 | Greene | Tennessee | 47059 | 43 | 2 |
108978 | 108978 | 2020-05-02 | Greene | Tennessee | 47059 | 43 | 2 |
111852 | 111852 | 2020-05-03 | Greene | Tennessee | 47059 | 43 | 2 |
114734 | 114734 | 2020-05-04 | Greene | Tennessee | 47059 | 43 | 2 |
117690 | 117690 | 2020-05-05 | Greene | Tennessee | 47059 | 43 | 2 |
120654 | 120654 | 2020-05-06 | Greene | Tennessee | 47059 | 43 | 2 |
123632 | 123632 | 2020-05-07 | Greene | Tennessee | 47059 | 43 | 2 |
126615 | 126615 | 2020-05-08 | Greene | Tennessee | 47059 | 43 | 2 |
103248 | 103248 | 2020-04-30 | Greene | Tennessee | 47059 | 44 | 2 |
106111 | 106111 | 2020-05-01 | Greene | Tennessee | 47059 | 44 | 2 |
129604 | 129604 | 2020-05-09 | Greene | Tennessee | 47059 | 44 | 2 |
132593 | 132593 | 2020-05-10 | Greene | Tennessee | 47059 | 46 | 2 |
135584 | 135584 | 2020-05-11 | Greene | Tennessee | 47059 | 46 | 2 |
138574 | 138574 | 2020-05-12 | Greene | Tennessee | 47059 | 46 | 2 |
144567 | 144567 | 2020-05-14 | Greene | Tennessee | 47059 | 46 | 2 |
147568 | 147568 | 2020-05-15 | Greene | Tennessee | 47059 | 46 | 2 |
150576 | 150576 | 2020-05-16 | Greene | Tennessee | 47059 | 46 | 2 |
153587 | 153587 | 2020-05-17 | Greene | Tennessee | 47059 | 46 | 2 |
156604 | 156604 | 2020-05-18 | Greene | Tennessee | 47059 | 46 | 2 |
159625 | 159625 | 2020-05-19 | Greene | Tennessee | 47059 | 46 | 2 |
162652 | 162652 | 2020-05-20 | Greene | Tennessee | 47059 | 46 | 2 |
165681 | 165681 | 2020-05-21 | Greene | Tennessee | 47059 | 46 | 2 |
141570 | 141570 | 2020-05-13 | Greene | Tennessee | 47059 | 47 | 2 |
168717 | 168717 | 2020-05-22 | Greene | Tennessee | 47059 | 47 | 2 |
174799 | 174799 | 2020-05-24 | Greene | Tennessee | 47059 | 47 | 2 |
177843 | 177843 | 2020-05-25 | Greene | Tennessee | 47059 | 47 | 2 |
180886 | 180886 | 2020-05-26 | Greene | Tennessee | 47059 | 47 | 2 |
171756 | 171756 | 2020-05-23 | Greene | Tennessee | 47059 | 48 | 2 |
183936 | 183936 | 2020-05-27 | Greene | Tennessee | 47059 | 48 | 2 |
186993 | 186993 | 2020-05-28 | Greene | Tennessee | 47059 | 48 | 2 |
190057 | 190057 | 2020-05-29 | Greene | Tennessee | 47059 | 49 | 2 |
193122 | 193122 | 2020-05-30 | Greene | Tennessee | 47059 | 50 | 2 |
196192 | 196192 | 2020-05-31 | Greene | Tennessee | 47059 | 50 | 2 |
199265 | 199265 | 2020-06-01 | Greene | Tennessee | 47059 | 50 | 2 |
202340 | 202340 | 2020-06-02 | Greene | Tennessee | 47059 | 52 | 2 |
205419 | 205419 | 2020-06-03 | Greene | Tennessee | 47059 | 52 | 2 |
208501 | 208501 | 2020-06-04 | Greene | Tennessee | 47059 | 52 | 2 |
211583 | 211583 | 2020-06-05 | Greene | Tennessee | 47059 | 52 | 2 |
214670 | 214670 | 2020-06-06 | Greene | Tennessee | 47059 | 52 | 2 |
217760 | 217760 | 2020-06-07 | Greene | Tennessee | 47059 | 52 | 2 |
220852 | 220852 | 2020-06-08 | Greene | Tennessee | 47059 | 52 | 2 |
223947 | 223947 | 2020-06-09 | Greene | Tennessee | 47059 | 52 | 2 |
227047 | 227047 | 2020-06-10 | Greene | Tennessee | 47059 | 52 | 2 |
230151 | 230151 | 2020-06-11 | Greene | Tennessee | 47059 | 52 | 2 |
233256 | 233256 | 2020-06-12 | Greene | Tennessee | 47059 | 53 | 2 |
236362 | 236362 | 2020-06-13 | Greene | Tennessee | 47059 | 53 | 2 |
239470 | 239470 | 2020-06-14 | Greene | Tennessee | 47059 | 53 | 2 |
242580 | 242580 | 2020-06-15 | Greene | Tennessee | 47059 | 53 | 2 |
245692 | 245692 | 2020-06-16 | Greene | Tennessee | 47059 | 55 | 2 |
248805 | 248805 | 2020-06-17 | Greene | Tennessee | 47059 | 55 | 2 |
255035 | 255035 | 2020-06-19 | Greene | Tennessee | 47059 | 55 | 2 |
258161 | 258161 | 2020-06-20 | Greene | Tennessee | 47059 | 55 | 2 |
261288 | 261288 | 2020-06-21 | Greene | Tennessee | 47059 | 55 | 2 |
251920 | 251920 | 2020-06-18 | Greene | Tennessee | 47059 | 56 | 2 |
264416 | 264416 | 2020-06-22 | Greene | Tennessee | 47059 | 56 | 2 |
267544 | 267544 | 2020-06-23 | Greene | Tennessee | 47059 | 56 | 2 |
270678 | 270678 | 2020-06-24 | Greene | Tennessee | 47059 | 58 | 2 |
273817 | 273817 | 2020-06-25 | Greene | Tennessee | 47059 | 66 | 2 |
276964 | 276964 | 2020-06-26 | Greene | Tennessee | 47059 | 68 | 3 |
280112 | 280112 | 2020-06-27 | Greene | Tennessee | 47059 | 74 | 2 |
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);