ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "McMinn" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
8061 | 8061 | 2020-03-22 | McMinn | Tennessee | 47107 | 1 | 0 |
9279 | 9279 | 2020-03-23 | McMinn | Tennessee | 47107 | 1 | 0 |
10612 | 10612 | 2020-03-24 | McMinn | Tennessee | 47107 | 2 | 0 |
12091 | 12091 | 2020-03-25 | McMinn | Tennessee | 47107 | 2 | 0 |
13716 | 13716 | 2020-03-26 | McMinn | Tennessee | 47107 | 3 | 0 |
15468 | 15468 | 2020-03-27 | McMinn | Tennessee | 47107 | 3 | 0 |
17331 | 17331 | 2020-03-28 | McMinn | Tennessee | 47107 | 3 | 0 |
19279 | 19279 | 2020-03-29 | McMinn | Tennessee | 47107 | 3 | 0 |
21336 | 21336 | 2020-03-30 | McMinn | Tennessee | 47107 | 3 | 0 |
23475 | 23475 | 2020-03-31 | McMinn | Tennessee | 47107 | 3 | 0 |
25677 | 25677 | 2020-04-01 | McMinn | Tennessee | 47107 | 3 | 0 |
27956 | 27956 | 2020-04-02 | McMinn | Tennessee | 47107 | 3 | 0 |
30291 | 30291 | 2020-04-03 | McMinn | Tennessee | 47107 | 3 | 0 |
32682 | 32682 | 2020-04-04 | McMinn | Tennessee | 47107 | 3 | 0 |
35119 | 35119 | 2020-04-05 | McMinn | Tennessee | 47107 | 3 | 0 |
37595 | 37595 | 2020-04-06 | McMinn | Tennessee | 47107 | 3 | 0 |
40118 | 40118 | 2020-04-07 | McMinn | Tennessee | 47107 | 3 | 0 |
42680 | 42680 | 2020-04-08 | McMinn | Tennessee | 47107 | 3 | 0 |
45267 | 45267 | 2020-04-09 | McMinn | Tennessee | 47107 | 3 | 0 |
47885 | 47885 | 2020-04-10 | McMinn | Tennessee | 47107 | 4 | 0 |
50543 | 50543 | 2020-04-11 | McMinn | Tennessee | 47107 | 4 | 0 |
53218 | 53218 | 2020-04-12 | McMinn | Tennessee | 47107 | 4 | 0 |
55905 | 55905 | 2020-04-13 | McMinn | Tennessee | 47107 | 5 | 0 |
58608 | 58608 | 2020-04-14 | McMinn | Tennessee | 47107 | 5 | 0 |
61323 | 61323 | 2020-04-15 | McMinn | Tennessee | 47107 | 5 | 0 |
64050 | 64050 | 2020-04-16 | McMinn | Tennessee | 47107 | 6 | 0 |
66796 | 66796 | 2020-04-17 | McMinn | Tennessee | 47107 | 6 | 0 |
69555 | 69555 | 2020-04-18 | McMinn | Tennessee | 47107 | 6 | 0 |
72322 | 72322 | 2020-04-19 | McMinn | Tennessee | 47107 | 6 | 0 |
75097 | 75097 | 2020-04-20 | McMinn | Tennessee | 47107 | 6 | 0 |
77879 | 77879 | 2020-04-21 | McMinn | Tennessee | 47107 | 6 | 0 |
80669 | 80669 | 2020-04-22 | McMinn | Tennessee | 47107 | 6 | 0 |
83468 | 83468 | 2020-04-23 | McMinn | Tennessee | 47107 | 6 | 0 |
86273 | 86273 | 2020-04-24 | McMinn | Tennessee | 47107 | 7 | 0 |
89088 | 89088 | 2020-04-25 | McMinn | Tennessee | 47107 | 10 | 0 |
91905 | 91905 | 2020-04-26 | McMinn | Tennessee | 47107 | 14 | 0 |
94733 | 94733 | 2020-04-27 | McMinn | Tennessee | 47107 | 65 | 0 |
97573 | 97573 | 2020-04-28 | McMinn | Tennessee | 47107 | 70 | 0 |
100423 | 100423 | 2020-04-29 | McMinn | Tennessee | 47107 | 89 | 1 |
103276 | 103276 | 2020-04-30 | McMinn | Tennessee | 47107 | 92 | 1 |
106139 | 106139 | 2020-05-01 | McMinn | Tennessee | 47107 | 94 | 1 |
109006 | 109006 | 2020-05-02 | McMinn | Tennessee | 47107 | 97 | 1 |
111880 | 111880 | 2020-05-03 | McMinn | Tennessee | 47107 | 100 | 1 |
114762 | 114762 | 2020-05-04 | McMinn | Tennessee | 47107 | 103 | 1 |
117718 | 117718 | 2020-05-05 | McMinn | Tennessee | 47107 | 106 | 2 |
120682 | 120682 | 2020-05-06 | McMinn | Tennessee | 47107 | 107 | 3 |
123660 | 123660 | 2020-05-07 | McMinn | Tennessee | 47107 | 108 | 3 |
126643 | 126643 | 2020-05-08 | McMinn | Tennessee | 47107 | 113 | 4 |
129632 | 129632 | 2020-05-09 | McMinn | Tennessee | 47107 | 116 | 4 |
132621 | 132621 | 2020-05-10 | McMinn | Tennessee | 47107 | 117 | 5 |
135612 | 135612 | 2020-05-11 | McMinn | Tennessee | 47107 | 122 | 8 |
138602 | 138602 | 2020-05-12 | McMinn | Tennessee | 47107 | 122 | 9 |
141598 | 141598 | 2020-05-13 | McMinn | Tennessee | 47107 | 123 | 9 |
144595 | 144595 | 2020-05-14 | McMinn | Tennessee | 47107 | 123 | 10 |
147596 | 147596 | 2020-05-15 | McMinn | Tennessee | 47107 | 123 | 11 |
150604 | 150604 | 2020-05-16 | McMinn | Tennessee | 47107 | 123 | 12 |
153615 | 153615 | 2020-05-17 | McMinn | Tennessee | 47107 | 123 | 12 |
156632 | 156632 | 2020-05-18 | McMinn | Tennessee | 47107 | 123 | 12 |
159654 | 159654 | 2020-05-19 | McMinn | Tennessee | 47107 | 125 | 12 |
162681 | 162681 | 2020-05-20 | McMinn | Tennessee | 47107 | 125 | 12 |
165710 | 165710 | 2020-05-21 | McMinn | Tennessee | 47107 | 124 | 12 |
168746 | 168746 | 2020-05-22 | McMinn | Tennessee | 47107 | 124 | 12 |
171785 | 171785 | 2020-05-23 | McMinn | Tennessee | 47107 | 133 | 13 |
174828 | 174828 | 2020-05-24 | McMinn | Tennessee | 47107 | 134 | 13 |
177872 | 177872 | 2020-05-25 | McMinn | Tennessee | 47107 | 135 | 14 |
180915 | 180915 | 2020-05-26 | McMinn | Tennessee | 47107 | 135 | 14 |
183965 | 183965 | 2020-05-27 | McMinn | Tennessee | 47107 | 136 | 14 |
187022 | 187022 | 2020-05-28 | McMinn | Tennessee | 47107 | 136 | 14 |
190086 | 190086 | 2020-05-29 | McMinn | Tennessee | 47107 | 136 | 14 |
193151 | 193151 | 2020-05-30 | McMinn | Tennessee | 47107 | 141 | 14 |
196221 | 196221 | 2020-05-31 | McMinn | Tennessee | 47107 | 141 | 14 |
199294 | 199294 | 2020-06-01 | McMinn | Tennessee | 47107 | 141 | 14 |
202369 | 202369 | 2020-06-02 | McMinn | Tennessee | 47107 | 143 | 14 |
205448 | 205448 | 2020-06-03 | McMinn | Tennessee | 47107 | 144 | 14 |
208530 | 208530 | 2020-06-04 | McMinn | Tennessee | 47107 | 146 | 14 |
211612 | 211612 | 2020-06-05 | McMinn | Tennessee | 47107 | 146 | 14 |
214699 | 214699 | 2020-06-06 | McMinn | Tennessee | 47107 | 150 | 14 |
217789 | 217789 | 2020-06-07 | McMinn | Tennessee | 47107 | 150 | 14 |
220881 | 220881 | 2020-06-08 | McMinn | Tennessee | 47107 | 153 | 14 |
223976 | 223976 | 2020-06-09 | McMinn | Tennessee | 47107 | 159 | 14 |
227076 | 227076 | 2020-06-10 | McMinn | Tennessee | 47107 | 159 | 14 |
230180 | 230180 | 2020-06-11 | McMinn | Tennessee | 47107 | 161 | 14 |
233285 | 233285 | 2020-06-12 | McMinn | Tennessee | 47107 | 162 | 14 |
236391 | 236391 | 2020-06-13 | McMinn | Tennessee | 47107 | 165 | 14 |
239499 | 239499 | 2020-06-14 | McMinn | Tennessee | 47107 | 165 | 14 |
242609 | 242609 | 2020-06-15 | McMinn | Tennessee | 47107 | 168 | 14 |
245721 | 245721 | 2020-06-16 | McMinn | Tennessee | 47107 | 169 | 15 |
248834 | 248834 | 2020-06-17 | McMinn | Tennessee | 47107 | 170 | 15 |
251949 | 251949 | 2020-06-18 | McMinn | Tennessee | 47107 | 171 | 15 |
255064 | 255064 | 2020-06-19 | McMinn | Tennessee | 47107 | 172 | 15 |
258190 | 258190 | 2020-06-20 | McMinn | Tennessee | 47107 | 172 | 15 |
261317 | 261317 | 2020-06-21 | McMinn | Tennessee | 47107 | 173 | 15 |
264445 | 264445 | 2020-06-22 | McMinn | Tennessee | 47107 | 175 | 15 |
267573 | 267573 | 2020-06-23 | McMinn | Tennessee | 47107 | 183 | 16 |
270707 | 270707 | 2020-06-24 | McMinn | Tennessee | 47107 | 192 | 17 |
273846 | 273846 | 2020-06-25 | McMinn | Tennessee | 47107 | 194 | 17 |
276993 | 276993 | 2020-06-26 | McMinn | Tennessee | 47107 | 201 | 17 |
280141 | 280141 | 2020-06-27 | McMinn | Tennessee | 47107 | 203 | 17 |
283287 | 283287 | 2020-06-28 | McMinn | Tennessee | 47107 | 203 | 17 |
286432 | 286432 | 2020-06-29 | McMinn | Tennessee | 47107 | 212 | 17 |
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);