ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47065 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388472 | 388472 | 2020-07-31 | Hamilton | Tennessee | 47065 | 5483 | 48 |
385255 | 385255 | 2020-07-30 | Hamilton | Tennessee | 47065 | 5395 | 47 |
382037 | 382037 | 2020-07-29 | Hamilton | Tennessee | 47065 | 5344 | 46 |
378820 | 378820 | 2020-07-28 | Hamilton | Tennessee | 47065 | 5253 | 46 |
375604 | 375604 | 2020-07-27 | Hamilton | Tennessee | 47065 | 5158 | 45 |
372391 | 372391 | 2020-07-26 | Hamilton | Tennessee | 47065 | 5055 | 45 |
369179 | 369179 | 2020-07-25 | Hamilton | Tennessee | 47065 | 4900 | 44 |
365970 | 365970 | 2020-07-24 | Hamilton | Tennessee | 47065 | 4721 | 42 |
362764 | 362764 | 2020-07-23 | Hamilton | Tennessee | 47065 | 4610 | 41 |
359557 | 359557 | 2020-07-22 | Hamilton | Tennessee | 47065 | 4523 | 41 |
356353 | 356353 | 2020-07-21 | Hamilton | Tennessee | 47065 | 4461 | 41 |
353150 | 353150 | 2020-07-20 | Hamilton | Tennessee | 47065 | 4360 | 40 |
349947 | 349947 | 2020-07-19 | Hamilton | Tennessee | 47065 | 4262 | 40 |
346747 | 346747 | 2020-07-18 | Hamilton | Tennessee | 47065 | 4160 | 40 |
343547 | 343547 | 2020-07-17 | Hamilton | Tennessee | 47065 | 4043 | 40 |
340349 | 340349 | 2020-07-16 | Hamilton | Tennessee | 47065 | 3939 | 39 |
337152 | 337152 | 2020-07-15 | Hamilton | Tennessee | 47065 | 3798 | 39 |
333958 | 333958 | 2020-07-14 | Hamilton | Tennessee | 47065 | 3684 | 38 |
330766 | 330766 | 2020-07-13 | Hamilton | Tennessee | 47065 | 3535 | 38 |
327580 | 327580 | 2020-07-12 | Hamilton | Tennessee | 47065 | 3457 | 38 |
324395 | 324395 | 2020-07-11 | Hamilton | Tennessee | 47065 | 3361 | 38 |
321214 | 321214 | 2020-07-10 | Hamilton | Tennessee | 47065 | 3255 | 37 |
318036 | 318036 | 2020-07-09 | Hamilton | Tennessee | 47065 | 3180 | 37 |
314863 | 314863 | 2020-07-08 | Hamilton | Tennessee | 47065 | 3076 | 36 |
311689 | 311689 | 2020-07-07 | Hamilton | Tennessee | 47065 | 2982 | 36 |
308520 | 308520 | 2020-07-06 | Hamilton | Tennessee | 47065 | 2909 | 35 |
305352 | 305352 | 2020-07-05 | Hamilton | Tennessee | 47065 | 2871 | 35 |
302189 | 302189 | 2020-07-04 | Hamilton | Tennessee | 47065 | 2818 | 35 |
299025 | 299025 | 2020-07-03 | Hamilton | Tennessee | 47065 | 2782 | 33 |
295865 | 295865 | 2020-07-02 | Hamilton | Tennessee | 47065 | 2704 | 30 |
292709 | 292709 | 2020-07-01 | Hamilton | Tennessee | 47065 | 2643 | 30 |
289557 | 289557 | 2020-06-30 | Hamilton | Tennessee | 47065 | 2525 | 30 |
286406 | 286406 | 2020-06-29 | Hamilton | Tennessee | 47065 | 2469 | 30 |
283261 | 283261 | 2020-06-28 | Hamilton | Tennessee | 47065 | 2423 | 29 |
280115 | 280115 | 2020-06-27 | Hamilton | Tennessee | 47065 | 2423 | 29 |
276967 | 276967 | 2020-06-26 | Hamilton | Tennessee | 47065 | 2356 | 29 |
273820 | 273820 | 2020-06-25 | Hamilton | Tennessee | 47065 | 2322 | 29 |
270681 | 270681 | 2020-06-24 | Hamilton | Tennessee | 47065 | 2277 | 29 |
267547 | 267547 | 2020-06-23 | Hamilton | Tennessee | 47065 | 2209 | 29 |
264419 | 264419 | 2020-06-22 | Hamilton | Tennessee | 47065 | 2174 | 28 |
261291 | 261291 | 2020-06-21 | Hamilton | Tennessee | 47065 | 2138 | 26 |
258164 | 258164 | 2020-06-20 | Hamilton | Tennessee | 47065 | 2121 | 25 |
255038 | 255038 | 2020-06-19 | Hamilton | Tennessee | 47065 | 2102 | 25 |
251923 | 251923 | 2020-06-18 | Hamilton | Tennessee | 47065 | 2065 | 25 |
248808 | 248808 | 2020-06-17 | Hamilton | Tennessee | 47065 | 1988 | 24 |
245695 | 245695 | 2020-06-16 | Hamilton | Tennessee | 47065 | 1941 | 22 |
242583 | 242583 | 2020-06-15 | Hamilton | Tennessee | 47065 | 1889 | 22 |
239473 | 239473 | 2020-06-14 | Hamilton | Tennessee | 47065 | 1842 | 20 |
236365 | 236365 | 2020-06-13 | Hamilton | Tennessee | 47065 | 1788 | 20 |
233259 | 233259 | 2020-06-12 | Hamilton | Tennessee | 47065 | 1751 | 20 |
230154 | 230154 | 2020-06-11 | Hamilton | Tennessee | 47065 | 1692 | 19 |
227050 | 227050 | 2020-06-10 | Hamilton | Tennessee | 47065 | 1645 | 19 |
223950 | 223950 | 2020-06-09 | Hamilton | Tennessee | 47065 | 1556 | 19 |
220855 | 220855 | 2020-06-08 | Hamilton | Tennessee | 47065 | 1486 | 19 |
217763 | 217763 | 2020-06-07 | Hamilton | Tennessee | 47065 | 1458 | 19 |
214673 | 214673 | 2020-06-06 | Hamilton | Tennessee | 47065 | 1423 | 19 |
211586 | 211586 | 2020-06-05 | Hamilton | Tennessee | 47065 | 1381 | 19 |
208504 | 208504 | 2020-06-04 | Hamilton | Tennessee | 47065 | 1275 | 19 |
205422 | 205422 | 2020-06-03 | Hamilton | Tennessee | 47065 | 1219 | 18 |
202343 | 202343 | 2020-06-02 | Hamilton | Tennessee | 47065 | 1178 | 17 |
199268 | 199268 | 2020-06-01 | Hamilton | Tennessee | 47065 | 1132 | 15 |
196195 | 196195 | 2020-05-31 | Hamilton | Tennessee | 47065 | 1083 | 15 |
193125 | 193125 | 2020-05-30 | Hamilton | Tennessee | 47065 | 999 | 15 |
190060 | 190060 | 2020-05-29 | Hamilton | Tennessee | 47065 | 939 | 15 |
186996 | 186996 | 2020-05-28 | Hamilton | Tennessee | 47065 | 843 | 15 |
183939 | 183939 | 2020-05-27 | Hamilton | Tennessee | 47065 | 772 | 15 |
180889 | 180889 | 2020-05-26 | Hamilton | Tennessee | 47065 | 717 | 15 |
177846 | 177846 | 2020-05-25 | Hamilton | Tennessee | 47065 | 694 | 14 |
174802 | 174802 | 2020-05-24 | Hamilton | Tennessee | 47065 | 640 | 14 |
171759 | 171759 | 2020-05-23 | Hamilton | Tennessee | 47065 | 566 | 14 |
168720 | 168720 | 2020-05-22 | Hamilton | Tennessee | 47065 | 531 | 13 |
165684 | 165684 | 2020-05-21 | Hamilton | Tennessee | 47065 | 487 | 13 |
162655 | 162655 | 2020-05-20 | Hamilton | Tennessee | 47065 | 447 | 13 |
159628 | 159628 | 2020-05-19 | Hamilton | Tennessee | 47065 | 404 | 13 |
156607 | 156607 | 2020-05-18 | Hamilton | Tennessee | 47065 | 376 | 13 |
153590 | 153590 | 2020-05-17 | Hamilton | Tennessee | 47065 | 368 | 13 |
150579 | 150579 | 2020-05-16 | Hamilton | Tennessee | 47065 | 354 | 13 |
147571 | 147571 | 2020-05-15 | Hamilton | Tennessee | 47065 | 332 | 13 |
144570 | 144570 | 2020-05-14 | Hamilton | Tennessee | 47065 | 319 | 13 |
141573 | 141573 | 2020-05-13 | Hamilton | Tennessee | 47065 | 286 | 13 |
138577 | 138577 | 2020-05-12 | Hamilton | Tennessee | 47065 | 258 | 14 |
135587 | 135587 | 2020-05-11 | Hamilton | Tennessee | 47065 | 240 | 13 |
132596 | 132596 | 2020-05-10 | Hamilton | Tennessee | 47065 | 233 | 13 |
129607 | 129607 | 2020-05-09 | Hamilton | Tennessee | 47065 | 232 | 13 |
126618 | 126618 | 2020-05-08 | Hamilton | Tennessee | 47065 | 229 | 13 |
123635 | 123635 | 2020-05-07 | Hamilton | Tennessee | 47065 | 211 | 14 |
120657 | 120657 | 2020-05-06 | Hamilton | Tennessee | 47065 | 196 | 14 |
117693 | 117693 | 2020-05-05 | Hamilton | Tennessee | 47065 | 184 | 14 |
114737 | 114737 | 2020-05-04 | Hamilton | Tennessee | 47065 | 180 | 14 |
111855 | 111855 | 2020-05-03 | Hamilton | Tennessee | 47065 | 172 | 14 |
108981 | 108981 | 2020-05-02 | Hamilton | Tennessee | 47065 | 168 | 14 |
106114 | 106114 | 2020-05-01 | Hamilton | Tennessee | 47065 | 160 | 14 |
103251 | 103251 | 2020-04-30 | Hamilton | Tennessee | 47065 | 156 | 14 |
100398 | 100398 | 2020-04-29 | Hamilton | Tennessee | 47065 | 152 | 14 |
97548 | 97548 | 2020-04-28 | Hamilton | Tennessee | 47065 | 149 | 14 |
94708 | 94708 | 2020-04-27 | Hamilton | Tennessee | 47065 | 146 | 14 |
91880 | 91880 | 2020-04-26 | Hamilton | Tennessee | 47065 | 141 | 14 |
89063 | 89063 | 2020-04-25 | Hamilton | Tennessee | 47065 | 140 | 14 |
86248 | 86248 | 2020-04-24 | Hamilton | Tennessee | 47065 | 133 | 14 |
83443 | 83443 | 2020-04-23 | Hamilton | Tennessee | 47065 | 129 | 14 |
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);