ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Greene" and fips = 47059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388469 | 388469 | 2020-07-31 | Greene | Tennessee | 47059 | 344 | 5 |
385252 | 385252 | 2020-07-30 | Greene | Tennessee | 47059 | 324 | 5 |
382034 | 382034 | 2020-07-29 | Greene | Tennessee | 47059 | 316 | 5 |
378817 | 378817 | 2020-07-28 | Greene | Tennessee | 47059 | 300 | 5 |
375601 | 375601 | 2020-07-27 | Greene | Tennessee | 47059 | 295 | 5 |
372388 | 372388 | 2020-07-26 | Greene | Tennessee | 47059 | 284 | 5 |
369176 | 369176 | 2020-07-25 | Greene | Tennessee | 47059 | 261 | 5 |
365967 | 365967 | 2020-07-24 | Greene | Tennessee | 47059 | 248 | 5 |
362761 | 362761 | 2020-07-23 | Greene | Tennessee | 47059 | 243 | 4 |
359554 | 359554 | 2020-07-22 | Greene | Tennessee | 47059 | 237 | 4 |
356350 | 356350 | 2020-07-21 | Greene | Tennessee | 47059 | 238 | 4 |
353147 | 353147 | 2020-07-20 | Greene | Tennessee | 47059 | 223 | 3 |
349944 | 349944 | 2020-07-19 | Greene | Tennessee | 47059 | 209 | 3 |
346744 | 346744 | 2020-07-18 | Greene | Tennessee | 47059 | 196 | 3 |
343544 | 343544 | 2020-07-17 | Greene | Tennessee | 47059 | 193 | 2 |
340346 | 340346 | 2020-07-16 | Greene | Tennessee | 47059 | 187 | 2 |
337149 | 337149 | 2020-07-15 | Greene | Tennessee | 47059 | 173 | 2 |
333955 | 333955 | 2020-07-14 | Greene | Tennessee | 47059 | 163 | 2 |
330763 | 330763 | 2020-07-13 | Greene | Tennessee | 47059 | 157 | 2 |
327577 | 327577 | 2020-07-12 | Greene | Tennessee | 47059 | 151 | 2 |
324392 | 324392 | 2020-07-11 | Greene | Tennessee | 47059 | 151 | 2 |
321211 | 321211 | 2020-07-10 | Greene | Tennessee | 47059 | 138 | 2 |
318033 | 318033 | 2020-07-09 | Greene | Tennessee | 47059 | 123 | 2 |
314860 | 314860 | 2020-07-08 | Greene | Tennessee | 47059 | 122 | 2 |
311686 | 311686 | 2020-07-07 | Greene | Tennessee | 47059 | 117 | 2 |
308517 | 308517 | 2020-07-06 | Greene | Tennessee | 47059 | 114 | 2 |
305349 | 305349 | 2020-07-05 | Greene | Tennessee | 47059 | 103 | 2 |
302186 | 302186 | 2020-07-04 | Greene | Tennessee | 47059 | 101 | 2 |
299022 | 299022 | 2020-07-03 | Greene | Tennessee | 47059 | 95 | 2 |
295862 | 295862 | 2020-07-02 | Greene | Tennessee | 47059 | 86 | 2 |
292706 | 292706 | 2020-07-01 | Greene | Tennessee | 47059 | 85 | 2 |
289554 | 289554 | 2020-06-30 | Greene | Tennessee | 47059 | 85 | 2 |
286403 | 286403 | 2020-06-29 | Greene | Tennessee | 47059 | 81 | 2 |
283258 | 283258 | 2020-06-28 | Greene | Tennessee | 47059 | 74 | 2 |
280112 | 280112 | 2020-06-27 | Greene | Tennessee | 47059 | 74 | 2 |
276964 | 276964 | 2020-06-26 | Greene | Tennessee | 47059 | 68 | 3 |
273817 | 273817 | 2020-06-25 | Greene | Tennessee | 47059 | 66 | 2 |
270678 | 270678 | 2020-06-24 | Greene | Tennessee | 47059 | 58 | 2 |
267544 | 267544 | 2020-06-23 | Greene | Tennessee | 47059 | 56 | 2 |
264416 | 264416 | 2020-06-22 | Greene | Tennessee | 47059 | 56 | 2 |
261288 | 261288 | 2020-06-21 | Greene | Tennessee | 47059 | 55 | 2 |
258161 | 258161 | 2020-06-20 | Greene | Tennessee | 47059 | 55 | 2 |
255035 | 255035 | 2020-06-19 | Greene | Tennessee | 47059 | 55 | 2 |
251920 | 251920 | 2020-06-18 | Greene | Tennessee | 47059 | 56 | 2 |
248805 | 248805 | 2020-06-17 | Greene | Tennessee | 47059 | 55 | 2 |
245692 | 245692 | 2020-06-16 | Greene | Tennessee | 47059 | 55 | 2 |
242580 | 242580 | 2020-06-15 | Greene | Tennessee | 47059 | 53 | 2 |
239470 | 239470 | 2020-06-14 | Greene | Tennessee | 47059 | 53 | 2 |
236362 | 236362 | 2020-06-13 | Greene | Tennessee | 47059 | 53 | 2 |
233256 | 233256 | 2020-06-12 | Greene | Tennessee | 47059 | 53 | 2 |
230151 | 230151 | 2020-06-11 | Greene | Tennessee | 47059 | 52 | 2 |
227047 | 227047 | 2020-06-10 | Greene | Tennessee | 47059 | 52 | 2 |
223947 | 223947 | 2020-06-09 | Greene | Tennessee | 47059 | 52 | 2 |
220852 | 220852 | 2020-06-08 | Greene | Tennessee | 47059 | 52 | 2 |
217760 | 217760 | 2020-06-07 | Greene | Tennessee | 47059 | 52 | 2 |
214670 | 214670 | 2020-06-06 | Greene | Tennessee | 47059 | 52 | 2 |
211583 | 211583 | 2020-06-05 | Greene | Tennessee | 47059 | 52 | 2 |
208501 | 208501 | 2020-06-04 | Greene | Tennessee | 47059 | 52 | 2 |
205419 | 205419 | 2020-06-03 | Greene | Tennessee | 47059 | 52 | 2 |
202340 | 202340 | 2020-06-02 | Greene | Tennessee | 47059 | 52 | 2 |
199265 | 199265 | 2020-06-01 | Greene | Tennessee | 47059 | 50 | 2 |
196192 | 196192 | 2020-05-31 | Greene | Tennessee | 47059 | 50 | 2 |
193122 | 193122 | 2020-05-30 | Greene | Tennessee | 47059 | 50 | 2 |
190057 | 190057 | 2020-05-29 | Greene | Tennessee | 47059 | 49 | 2 |
186993 | 186993 | 2020-05-28 | Greene | Tennessee | 47059 | 48 | 2 |
183936 | 183936 | 2020-05-27 | Greene | Tennessee | 47059 | 48 | 2 |
180886 | 180886 | 2020-05-26 | Greene | Tennessee | 47059 | 47 | 2 |
177843 | 177843 | 2020-05-25 | Greene | Tennessee | 47059 | 47 | 2 |
174799 | 174799 | 2020-05-24 | Greene | Tennessee | 47059 | 47 | 2 |
171756 | 171756 | 2020-05-23 | Greene | Tennessee | 47059 | 48 | 2 |
168717 | 168717 | 2020-05-22 | Greene | Tennessee | 47059 | 47 | 2 |
165681 | 165681 | 2020-05-21 | Greene | Tennessee | 47059 | 46 | 2 |
162652 | 162652 | 2020-05-20 | Greene | Tennessee | 47059 | 46 | 2 |
159625 | 159625 | 2020-05-19 | Greene | Tennessee | 47059 | 46 | 2 |
156604 | 156604 | 2020-05-18 | Greene | Tennessee | 47059 | 46 | 2 |
153587 | 153587 | 2020-05-17 | Greene | Tennessee | 47059 | 46 | 2 |
150576 | 150576 | 2020-05-16 | Greene | Tennessee | 47059 | 46 | 2 |
147568 | 147568 | 2020-05-15 | Greene | Tennessee | 47059 | 46 | 2 |
144567 | 144567 | 2020-05-14 | Greene | Tennessee | 47059 | 46 | 2 |
141570 | 141570 | 2020-05-13 | Greene | Tennessee | 47059 | 47 | 2 |
138574 | 138574 | 2020-05-12 | Greene | Tennessee | 47059 | 46 | 2 |
135584 | 135584 | 2020-05-11 | Greene | Tennessee | 47059 | 46 | 2 |
132593 | 132593 | 2020-05-10 | Greene | Tennessee | 47059 | 46 | 2 |
129604 | 129604 | 2020-05-09 | Greene | Tennessee | 47059 | 44 | 2 |
126615 | 126615 | 2020-05-08 | Greene | Tennessee | 47059 | 43 | 2 |
123632 | 123632 | 2020-05-07 | Greene | Tennessee | 47059 | 43 | 2 |
120654 | 120654 | 2020-05-06 | Greene | Tennessee | 47059 | 43 | 2 |
117690 | 117690 | 2020-05-05 | Greene | Tennessee | 47059 | 43 | 2 |
114734 | 114734 | 2020-05-04 | Greene | Tennessee | 47059 | 43 | 2 |
111852 | 111852 | 2020-05-03 | Greene | Tennessee | 47059 | 43 | 2 |
108978 | 108978 | 2020-05-02 | Greene | Tennessee | 47059 | 43 | 2 |
106111 | 106111 | 2020-05-01 | Greene | Tennessee | 47059 | 44 | 2 |
103248 | 103248 | 2020-04-30 | Greene | Tennessee | 47059 | 44 | 2 |
100395 | 100395 | 2020-04-29 | Greene | Tennessee | 47059 | 43 | 2 |
97545 | 97545 | 2020-04-28 | Greene | Tennessee | 47059 | 42 | 2 |
94705 | 94705 | 2020-04-27 | Greene | Tennessee | 47059 | 41 | 2 |
91877 | 91877 | 2020-04-26 | Greene | Tennessee | 47059 | 41 | 2 |
89060 | 89060 | 2020-04-25 | Greene | Tennessee | 47059 | 41 | 2 |
86245 | 86245 | 2020-04-24 | Greene | Tennessee | 47059 | 41 | 2 |
83440 | 83440 | 2020-04-23 | Greene | Tennessee | 47059 | 38 | 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);