ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Hamilton" and state = "Tennessee" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1872 | 1872 | 2020-03-13 | Hamilton | Tennessee | 47065 | 1 | 0 |
2237 | 2237 | 2020-03-14 | Hamilton | Tennessee | 47065 | 1 | 0 |
2662 | 2662 | 2020-03-15 | Hamilton | Tennessee | 47065 | 1 | 0 |
3128 | 3128 | 2020-03-16 | Hamilton | Tennessee | 47065 | 1 | 0 |
3661 | 3661 | 2020-03-17 | Hamilton | Tennessee | 47065 | 1 | 0 |
4282 | 4282 | 2020-03-18 | Hamilton | Tennessee | 47065 | 1 | 0 |
5029 | 5029 | 2020-03-19 | Hamilton | Tennessee | 47065 | 1 | 0 |
5916 | 5916 | 2020-03-20 | Hamilton | Tennessee | 47065 | 5 | 0 |
6929 | 6929 | 2020-03-21 | Hamilton | Tennessee | 47065 | 7 | 0 |
8054 | 8054 | 2020-03-22 | Hamilton | Tennessee | 47065 | 8 | 0 |
9272 | 9272 | 2020-03-23 | Hamilton | Tennessee | 47065 | 8 | 0 |
10602 | 10602 | 2020-03-24 | Hamilton | Tennessee | 47065 | 8 | 0 |
12079 | 12079 | 2020-03-25 | Hamilton | Tennessee | 47065 | 15 | 0 |
13703 | 13703 | 2020-03-26 | Hamilton | Tennessee | 47065 | 28 | 0 |
15455 | 15455 | 2020-03-27 | Hamilton | Tennessee | 47065 | 30 | 0 |
17316 | 17316 | 2020-03-28 | Hamilton | Tennessee | 47065 | 35 | 0 |
19262 | 19262 | 2020-03-29 | Hamilton | Tennessee | 47065 | 35 | 0 |
21317 | 21317 | 2020-03-30 | Hamilton | Tennessee | 47065 | 40 | 0 |
23455 | 23455 | 2020-03-31 | Hamilton | Tennessee | 47065 | 48 | 0 |
25655 | 25655 | 2020-04-01 | Hamilton | Tennessee | 47065 | 50 | 2 |
27933 | 27933 | 2020-04-02 | Hamilton | Tennessee | 47065 | 61 | 3 |
30268 | 30268 | 2020-04-03 | Hamilton | Tennessee | 47065 | 67 | 3 |
32659 | 32659 | 2020-04-04 | Hamilton | Tennessee | 47065 | 71 | 8 |
35095 | 35095 | 2020-04-05 | Hamilton | Tennessee | 47065 | 79 | 8 |
37571 | 37571 | 2020-04-06 | Hamilton | Tennessee | 47065 | 83 | 9 |
40094 | 40094 | 2020-04-07 | Hamilton | Tennessee | 47065 | 95 | 9 |
42656 | 42656 | 2020-04-08 | Hamilton | Tennessee | 47065 | 95 | 9 |
45243 | 45243 | 2020-04-09 | Hamilton | Tennessee | 47065 | 98 | 9 |
47861 | 47861 | 2020-04-10 | Hamilton | Tennessee | 47065 | 102 | 10 |
50519 | 50519 | 2020-04-11 | Hamilton | Tennessee | 47065 | 105 | 10 |
53194 | 53194 | 2020-04-12 | Hamilton | Tennessee | 47065 | 105 | 10 |
55880 | 55880 | 2020-04-13 | Hamilton | Tennessee | 47065 | 109 | 10 |
58583 | 58583 | 2020-04-14 | Hamilton | Tennessee | 47065 | 110 | 11 |
61298 | 61298 | 2020-04-15 | Hamilton | Tennessee | 47065 | 110 | 12 |
64025 | 64025 | 2020-04-16 | Hamilton | Tennessee | 47065 | 110 | 12 |
66771 | 66771 | 2020-04-17 | Hamilton | Tennessee | 47065 | 115 | 12 |
69530 | 69530 | 2020-04-18 | Hamilton | Tennessee | 47065 | 116 | 12 |
72297 | 72297 | 2020-04-19 | Hamilton | Tennessee | 47065 | 116 | 12 |
75072 | 75072 | 2020-04-20 | Hamilton | Tennessee | 47065 | 118 | 12 |
77854 | 77854 | 2020-04-21 | Hamilton | Tennessee | 47065 | 124 | 12 |
126618 | 126618 | 2020-05-08 | Hamilton | Tennessee | 47065 | 229 | 13 |
129607 | 129607 | 2020-05-09 | Hamilton | Tennessee | 47065 | 232 | 13 |
132596 | 132596 | 2020-05-10 | Hamilton | Tennessee | 47065 | 233 | 13 |
135587 | 135587 | 2020-05-11 | Hamilton | Tennessee | 47065 | 240 | 13 |
141573 | 141573 | 2020-05-13 | Hamilton | Tennessee | 47065 | 286 | 13 |
144570 | 144570 | 2020-05-14 | Hamilton | Tennessee | 47065 | 319 | 13 |
147571 | 147571 | 2020-05-15 | Hamilton | Tennessee | 47065 | 332 | 13 |
150579 | 150579 | 2020-05-16 | Hamilton | Tennessee | 47065 | 354 | 13 |
153590 | 153590 | 2020-05-17 | Hamilton | Tennessee | 47065 | 368 | 13 |
156607 | 156607 | 2020-05-18 | Hamilton | Tennessee | 47065 | 376 | 13 |
159628 | 159628 | 2020-05-19 | Hamilton | Tennessee | 47065 | 404 | 13 |
162655 | 162655 | 2020-05-20 | Hamilton | Tennessee | 47065 | 447 | 13 |
165684 | 165684 | 2020-05-21 | Hamilton | Tennessee | 47065 | 487 | 13 |
168720 | 168720 | 2020-05-22 | Hamilton | Tennessee | 47065 | 531 | 13 |
80644 | 80644 | 2020-04-22 | Hamilton | Tennessee | 47065 | 127 | 14 |
83443 | 83443 | 2020-04-23 | Hamilton | Tennessee | 47065 | 129 | 14 |
86248 | 86248 | 2020-04-24 | Hamilton | Tennessee | 47065 | 133 | 14 |
89063 | 89063 | 2020-04-25 | Hamilton | Tennessee | 47065 | 140 | 14 |
91880 | 91880 | 2020-04-26 | Hamilton | Tennessee | 47065 | 141 | 14 |
94708 | 94708 | 2020-04-27 | Hamilton | Tennessee | 47065 | 146 | 14 |
97548 | 97548 | 2020-04-28 | Hamilton | Tennessee | 47065 | 149 | 14 |
100398 | 100398 | 2020-04-29 | Hamilton | Tennessee | 47065 | 152 | 14 |
103251 | 103251 | 2020-04-30 | Hamilton | Tennessee | 47065 | 156 | 14 |
106114 | 106114 | 2020-05-01 | Hamilton | Tennessee | 47065 | 160 | 14 |
108981 | 108981 | 2020-05-02 | Hamilton | Tennessee | 47065 | 168 | 14 |
111855 | 111855 | 2020-05-03 | Hamilton | Tennessee | 47065 | 172 | 14 |
114737 | 114737 | 2020-05-04 | Hamilton | Tennessee | 47065 | 180 | 14 |
117693 | 117693 | 2020-05-05 | Hamilton | Tennessee | 47065 | 184 | 14 |
120657 | 120657 | 2020-05-06 | Hamilton | Tennessee | 47065 | 196 | 14 |
123635 | 123635 | 2020-05-07 | Hamilton | Tennessee | 47065 | 211 | 14 |
138577 | 138577 | 2020-05-12 | Hamilton | Tennessee | 47065 | 258 | 14 |
171759 | 171759 | 2020-05-23 | Hamilton | Tennessee | 47065 | 566 | 14 |
174802 | 174802 | 2020-05-24 | Hamilton | Tennessee | 47065 | 640 | 14 |
177846 | 177846 | 2020-05-25 | Hamilton | Tennessee | 47065 | 694 | 14 |
180889 | 180889 | 2020-05-26 | Hamilton | Tennessee | 47065 | 717 | 15 |
183939 | 183939 | 2020-05-27 | Hamilton | Tennessee | 47065 | 772 | 15 |
186996 | 186996 | 2020-05-28 | Hamilton | Tennessee | 47065 | 843 | 15 |
190060 | 190060 | 2020-05-29 | Hamilton | Tennessee | 47065 | 939 | 15 |
193125 | 193125 | 2020-05-30 | Hamilton | Tennessee | 47065 | 999 | 15 |
196195 | 196195 | 2020-05-31 | Hamilton | Tennessee | 47065 | 1083 | 15 |
199268 | 199268 | 2020-06-01 | Hamilton | Tennessee | 47065 | 1132 | 15 |
202343 | 202343 | 2020-06-02 | Hamilton | Tennessee | 47065 | 1178 | 17 |
205422 | 205422 | 2020-06-03 | Hamilton | Tennessee | 47065 | 1219 | 18 |
208504 | 208504 | 2020-06-04 | Hamilton | Tennessee | 47065 | 1275 | 19 |
211586 | 211586 | 2020-06-05 | Hamilton | Tennessee | 47065 | 1381 | 19 |
214673 | 214673 | 2020-06-06 | Hamilton | Tennessee | 47065 | 1423 | 19 |
217763 | 217763 | 2020-06-07 | Hamilton | Tennessee | 47065 | 1458 | 19 |
220855 | 220855 | 2020-06-08 | Hamilton | Tennessee | 47065 | 1486 | 19 |
223950 | 223950 | 2020-06-09 | Hamilton | Tennessee | 47065 | 1556 | 19 |
227050 | 227050 | 2020-06-10 | Hamilton | Tennessee | 47065 | 1645 | 19 |
230154 | 230154 | 2020-06-11 | Hamilton | Tennessee | 47065 | 1692 | 19 |
233259 | 233259 | 2020-06-12 | Hamilton | Tennessee | 47065 | 1751 | 20 |
236365 | 236365 | 2020-06-13 | Hamilton | Tennessee | 47065 | 1788 | 20 |
239473 | 239473 | 2020-06-14 | Hamilton | Tennessee | 47065 | 1842 | 20 |
242583 | 242583 | 2020-06-15 | Hamilton | Tennessee | 47065 | 1889 | 22 |
245695 | 245695 | 2020-06-16 | Hamilton | Tennessee | 47065 | 1941 | 22 |
248808 | 248808 | 2020-06-17 | Hamilton | Tennessee | 47065 | 1988 | 24 |
251923 | 251923 | 2020-06-18 | Hamilton | Tennessee | 47065 | 2065 | 25 |
255038 | 255038 | 2020-06-19 | Hamilton | Tennessee | 47065 | 2102 | 25 |
258164 | 258164 | 2020-06-20 | Hamilton | Tennessee | 47065 | 2121 | 25 |
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);