ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Johnson" and state = "Tennessee" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17322 | 17322 | 2020-03-28 | Johnson | Tennessee | 47091 | 1 | 0 |
19270 | 19270 | 2020-03-29 | Johnson | Tennessee | 47091 | 2 | 0 |
21325 | 21325 | 2020-03-30 | Johnson | Tennessee | 47091 | 2 | 0 |
23464 | 23464 | 2020-03-31 | Johnson | Tennessee | 47091 | 2 | 0 |
25665 | 25665 | 2020-04-01 | Johnson | Tennessee | 47091 | 2 | 0 |
27944 | 27944 | 2020-04-02 | Johnson | Tennessee | 47091 | 2 | 0 |
30279 | 30279 | 2020-04-03 | Johnson | Tennessee | 47091 | 2 | 0 |
32670 | 32670 | 2020-04-04 | Johnson | Tennessee | 47091 | 2 | 0 |
35107 | 35107 | 2020-04-05 | Johnson | Tennessee | 47091 | 2 | 0 |
37583 | 37583 | 2020-04-06 | Johnson | Tennessee | 47091 | 2 | 0 |
40106 | 40106 | 2020-04-07 | Johnson | Tennessee | 47091 | 2 | 0 |
42668 | 42668 | 2020-04-08 | Johnson | Tennessee | 47091 | 2 | 0 |
45255 | 45255 | 2020-04-09 | Johnson | Tennessee | 47091 | 2 | 0 |
47873 | 47873 | 2020-04-10 | Johnson | Tennessee | 47091 | 2 | 0 |
50531 | 50531 | 2020-04-11 | Johnson | Tennessee | 47091 | 2 | 0 |
53206 | 53206 | 2020-04-12 | Johnson | Tennessee | 47091 | 2 | 0 |
55892 | 55892 | 2020-04-13 | Johnson | Tennessee | 47091 | 2 | 0 |
58595 | 58595 | 2020-04-14 | Johnson | Tennessee | 47091 | 2 | 0 |
61310 | 61310 | 2020-04-15 | Johnson | Tennessee | 47091 | 2 | 0 |
64037 | 64037 | 2020-04-16 | Johnson | Tennessee | 47091 | 2 | 0 |
66783 | 66783 | 2020-04-17 | Johnson | Tennessee | 47091 | 2 | 0 |
69542 | 69542 | 2020-04-18 | Johnson | Tennessee | 47091 | 2 | 0 |
72309 | 72309 | 2020-04-19 | Johnson | Tennessee | 47091 | 2 | 0 |
75084 | 75084 | 2020-04-20 | Johnson | Tennessee | 47091 | 2 | 0 |
77866 | 77866 | 2020-04-21 | Johnson | Tennessee | 47091 | 2 | 0 |
80656 | 80656 | 2020-04-22 | Johnson | Tennessee | 47091 | 2 | 0 |
83455 | 83455 | 2020-04-23 | Johnson | Tennessee | 47091 | 2 | 0 |
86260 | 86260 | 2020-04-24 | Johnson | Tennessee | 47091 | 2 | 0 |
89075 | 89075 | 2020-04-25 | Johnson | Tennessee | 47091 | 2 | 0 |
91892 | 91892 | 2020-04-26 | Johnson | Tennessee | 47091 | 2 | 0 |
94720 | 94720 | 2020-04-27 | Johnson | Tennessee | 47091 | 3 | 0 |
97560 | 97560 | 2020-04-28 | Johnson | Tennessee | 47091 | 3 | 0 |
100410 | 100410 | 2020-04-29 | Johnson | Tennessee | 47091 | 3 | 0 |
103263 | 103263 | 2020-04-30 | Johnson | Tennessee | 47091 | 3 | 0 |
106126 | 106126 | 2020-05-01 | Johnson | Tennessee | 47091 | 3 | 0 |
108993 | 108993 | 2020-05-02 | Johnson | Tennessee | 47091 | 3 | 0 |
111867 | 111867 | 2020-05-03 | Johnson | Tennessee | 47091 | 3 | 0 |
114749 | 114749 | 2020-05-04 | Johnson | Tennessee | 47091 | 5 | 0 |
117705 | 117705 | 2020-05-05 | Johnson | Tennessee | 47091 | 5 | 0 |
120669 | 120669 | 2020-05-06 | Johnson | Tennessee | 47091 | 7 | 0 |
123647 | 123647 | 2020-05-07 | Johnson | Tennessee | 47091 | 5 | 0 |
126630 | 126630 | 2020-05-08 | Johnson | Tennessee | 47091 | 5 | 0 |
129619 | 129619 | 2020-05-09 | Johnson | Tennessee | 47091 | 5 | 0 |
132608 | 132608 | 2020-05-10 | Johnson | Tennessee | 47091 | 5 | 0 |
135599 | 135599 | 2020-05-11 | Johnson | Tennessee | 47091 | 5 | 0 |
138589 | 138589 | 2020-05-12 | Johnson | Tennessee | 47091 | 11 | 0 |
141585 | 141585 | 2020-05-13 | Johnson | Tennessee | 47091 | 15 | 0 |
144582 | 144582 | 2020-05-14 | Johnson | Tennessee | 47091 | 15 | 0 |
147583 | 147583 | 2020-05-15 | Johnson | Tennessee | 47091 | 15 | 0 |
150591 | 150591 | 2020-05-16 | Johnson | Tennessee | 47091 | 15 | 0 |
153602 | 153602 | 2020-05-17 | Johnson | Tennessee | 47091 | 15 | 0 |
156619 | 156619 | 2020-05-18 | Johnson | Tennessee | 47091 | 15 | 0 |
159641 | 159641 | 2020-05-19 | Johnson | Tennessee | 47091 | 15 | 0 |
162668 | 162668 | 2020-05-20 | Johnson | Tennessee | 47091 | 15 | 0 |
165697 | 165697 | 2020-05-21 | Johnson | Tennessee | 47091 | 15 | 0 |
168733 | 168733 | 2020-05-22 | Johnson | Tennessee | 47091 | 15 | 0 |
171772 | 171772 | 2020-05-23 | Johnson | Tennessee | 47091 | 15 | 0 |
174815 | 174815 | 2020-05-24 | Johnson | Tennessee | 47091 | 15 | 0 |
177859 | 177859 | 2020-05-25 | Johnson | Tennessee | 47091 | 15 | 0 |
180902 | 180902 | 2020-05-26 | Johnson | Tennessee | 47091 | 15 | 0 |
183952 | 183952 | 2020-05-27 | Johnson | Tennessee | 47091 | 15 | 0 |
187009 | 187009 | 2020-05-28 | Johnson | Tennessee | 47091 | 16 | 0 |
190073 | 190073 | 2020-05-29 | Johnson | Tennessee | 47091 | 16 | 0 |
193138 | 193138 | 2020-05-30 | Johnson | Tennessee | 47091 | 16 | 0 |
196208 | 196208 | 2020-05-31 | Johnson | Tennessee | 47091 | 16 | 0 |
199281 | 199281 | 2020-06-01 | Johnson | Tennessee | 47091 | 16 | 0 |
202356 | 202356 | 2020-06-02 | Johnson | Tennessee | 47091 | 16 | 0 |
205435 | 205435 | 2020-06-03 | Johnson | Tennessee | 47091 | 19 | 0 |
208517 | 208517 | 2020-06-04 | Johnson | Tennessee | 47091 | 19 | 0 |
211599 | 211599 | 2020-06-05 | Johnson | Tennessee | 47091 | 18 | 0 |
214686 | 214686 | 2020-06-06 | Johnson | Tennessee | 47091 | 20 | 0 |
217776 | 217776 | 2020-06-07 | Johnson | Tennessee | 47091 | 21 | 0 |
220868 | 220868 | 2020-06-08 | Johnson | Tennessee | 47091 | 22 | 0 |
223963 | 223963 | 2020-06-09 | Johnson | Tennessee | 47091 | 22 | 0 |
227063 | 227063 | 2020-06-10 | Johnson | Tennessee | 47091 | 23 | 0 |
230167 | 230167 | 2020-06-11 | Johnson | Tennessee | 47091 | 24 | 0 |
233272 | 233272 | 2020-06-12 | Johnson | Tennessee | 47091 | 24 | 0 |
236378 | 236378 | 2020-06-13 | Johnson | Tennessee | 47091 | 24 | 0 |
239486 | 239486 | 2020-06-14 | Johnson | Tennessee | 47091 | 24 | 0 |
242596 | 242596 | 2020-06-15 | Johnson | Tennessee | 47091 | 25 | 0 |
245708 | 245708 | 2020-06-16 | Johnson | Tennessee | 47091 | 25 | 0 |
248821 | 248821 | 2020-06-17 | Johnson | Tennessee | 47091 | 25 | 0 |
251936 | 251936 | 2020-06-18 | Johnson | Tennessee | 47091 | 26 | 0 |
255051 | 255051 | 2020-06-19 | Johnson | Tennessee | 47091 | 26 | 0 |
258177 | 258177 | 2020-06-20 | Johnson | Tennessee | 47091 | 26 | 0 |
261304 | 261304 | 2020-06-21 | Johnson | Tennessee | 47091 | 26 | 0 |
264432 | 264432 | 2020-06-22 | Johnson | Tennessee | 47091 | 26 | 0 |
267560 | 267560 | 2020-06-23 | Johnson | Tennessee | 47091 | 26 | 0 |
270694 | 270694 | 2020-06-24 | Johnson | Tennessee | 47091 | 27 | 0 |
273833 | 273833 | 2020-06-25 | Johnson | Tennessee | 47091 | 28 | 0 |
276980 | 276980 | 2020-06-26 | Johnson | Tennessee | 47091 | 30 | 0 |
280128 | 280128 | 2020-06-27 | Johnson | Tennessee | 47091 | 34 | 0 |
283274 | 283274 | 2020-06-28 | Johnson | Tennessee | 47091 | 34 | 0 |
286419 | 286419 | 2020-06-29 | Johnson | Tennessee | 47091 | 35 | 0 |
289570 | 289570 | 2020-06-30 | Johnson | Tennessee | 47091 | 36 | 0 |
292722 | 292722 | 2020-07-01 | Johnson | Tennessee | 47091 | 37 | 0 |
295878 | 295878 | 2020-07-02 | Johnson | Tennessee | 47091 | 38 | 0 |
299038 | 299038 | 2020-07-03 | Johnson | Tennessee | 47091 | 39 | 0 |
302202 | 302202 | 2020-07-04 | Johnson | Tennessee | 47091 | 44 | 0 |
305365 | 305365 | 2020-07-05 | Johnson | Tennessee | 47091 | 44 | 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);