ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Blount" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
135559 | 135559 | 2020-05-11 | Blount | Tennessee | 47009 | 72 | 3 |
136227 | 136227 | 2020-05-12 | Blount | Alabama | 1009 | 45 | 0 |
138549 | 138549 | 2020-05-12 | Blount | Tennessee | 47009 | 73 | 3 |
139218 | 139218 | 2020-05-13 | Blount | Alabama | 1009 | 45 | 0 |
141545 | 141545 | 2020-05-13 | Blount | Tennessee | 47009 | 74 | 3 |
142214 | 142214 | 2020-05-14 | Blount | Alabama | 1009 | 45 | 0 |
144542 | 144542 | 2020-05-14 | Blount | Tennessee | 47009 | 75 | 3 |
145213 | 145213 | 2020-05-15 | Blount | Alabama | 1009 | 45 | 0 |
147543 | 147543 | 2020-05-15 | Blount | Tennessee | 47009 | 75 | 3 |
148216 | 148216 | 2020-05-16 | Blount | Alabama | 1009 | 45 | 0 |
150551 | 150551 | 2020-05-16 | Blount | Tennessee | 47009 | 75 | 3 |
151225 | 151225 | 2020-05-17 | Blount | Alabama | 1009 | 46 | 1 |
153562 | 153562 | 2020-05-17 | Blount | Tennessee | 47009 | 75 | 3 |
154237 | 154237 | 2020-05-18 | Blount | Alabama | 1009 | 47 | 1 |
156579 | 156579 | 2020-05-18 | Blount | Tennessee | 47009 | 76 | 3 |
157253 | 157253 | 2020-05-19 | Blount | Alabama | 1009 | 47 | 1 |
159600 | 159600 | 2020-05-19 | Blount | Tennessee | 47009 | 76 | 3 |
160277 | 160277 | 2020-05-20 | Blount | Alabama | 1009 | 47 | 1 |
162627 | 162627 | 2020-05-20 | Blount | Tennessee | 47009 | 76 | 3 |
163305 | 163305 | 2020-05-21 | Blount | Alabama | 1009 | 48 | 1 |
165656 | 165656 | 2020-05-21 | Blount | Tennessee | 47009 | 77 | 3 |
166337 | 166337 | 2020-05-22 | Blount | Alabama | 1009 | 49 | 1 |
168692 | 168692 | 2020-05-22 | Blount | Tennessee | 47009 | 78 | 3 |
169373 | 169373 | 2020-05-23 | Blount | Alabama | 1009 | 49 | 1 |
171731 | 171731 | 2020-05-23 | Blount | Tennessee | 47009 | 81 | 3 |
172414 | 172414 | 2020-05-24 | Blount | Alabama | 1009 | 49 | 1 |
174774 | 174774 | 2020-05-24 | Blount | Tennessee | 47009 | 82 | 3 |
175457 | 175457 | 2020-05-25 | Blount | Alabama | 1009 | 49 | 1 |
177818 | 177818 | 2020-05-25 | Blount | Tennessee | 47009 | 82 | 3 |
178502 | 178502 | 2020-05-26 | Blount | Alabama | 1009 | 51 | 1 |
180861 | 180861 | 2020-05-26 | Blount | Tennessee | 47009 | 84 | 3 |
181546 | 181546 | 2020-05-27 | Blount | Alabama | 1009 | 53 | 1 |
183911 | 183911 | 2020-05-27 | Blount | Tennessee | 47009 | 89 | 3 |
184598 | 184598 | 2020-05-28 | Blount | Alabama | 1009 | 58 | 1 |
186968 | 186968 | 2020-05-28 | Blount | Tennessee | 47009 | 89 | 3 |
187655 | 187655 | 2020-05-29 | Blount | Alabama | 1009 | 60 | 1 |
190032 | 190032 | 2020-05-29 | Blount | Tennessee | 47009 | 89 | 3 |
190719 | 190719 | 2020-05-30 | Blount | Alabama | 1009 | 61 | 1 |
193097 | 193097 | 2020-05-30 | Blount | Tennessee | 47009 | 91 | 3 |
193785 | 193785 | 2020-05-31 | Blount | Alabama | 1009 | 62 | 1 |
196167 | 196167 | 2020-05-31 | Blount | Tennessee | 47009 | 91 | 3 |
196855 | 196855 | 2020-06-01 | Blount | Alabama | 1009 | 65 | 1 |
199240 | 199240 | 2020-06-01 | Blount | Tennessee | 47009 | 91 | 3 |
199928 | 199928 | 2020-06-02 | Blount | Alabama | 1009 | 65 | 1 |
202315 | 202315 | 2020-06-02 | Blount | Tennessee | 47009 | 93 | 3 |
203004 | 203004 | 2020-06-03 | Blount | Alabama | 1009 | 65 | 1 |
205394 | 205394 | 2020-06-03 | Blount | Tennessee | 47009 | 93 | 3 |
206083 | 206083 | 2020-06-04 | Blount | Alabama | 1009 | 65 | 1 |
208476 | 208476 | 2020-06-04 | Blount | Tennessee | 47009 | 93 | 3 |
209165 | 209165 | 2020-06-05 | Blount | Alabama | 1009 | 66 | 1 |
211558 | 211558 | 2020-06-05 | Blount | Tennessee | 47009 | 93 | 3 |
212250 | 212250 | 2020-06-06 | Blount | Alabama | 1009 | 72 | 1 |
214645 | 214645 | 2020-06-06 | Blount | Tennessee | 47009 | 93 | 3 |
215337 | 215337 | 2020-06-07 | Blount | Alabama | 1009 | 74 | 1 |
217735 | 217735 | 2020-06-07 | Blount | Tennessee | 47009 | 94 | 3 |
218427 | 218427 | 2020-06-08 | Blount | Alabama | 1009 | 75 | 1 |
220827 | 220827 | 2020-06-08 | Blount | Tennessee | 47009 | 94 | 3 |
221519 | 221519 | 2020-06-09 | Blount | Alabama | 1009 | 77 | 1 |
223922 | 223922 | 2020-06-09 | Blount | Tennessee | 47009 | 96 | 3 |
224615 | 224615 | 2020-06-10 | Blount | Alabama | 1009 | 81 | 1 |
227022 | 227022 | 2020-06-10 | Blount | Tennessee | 47009 | 96 | 3 |
227716 | 227716 | 2020-06-11 | Blount | Alabama | 1009 | 89 | 1 |
230126 | 230126 | 2020-06-11 | Blount | Tennessee | 47009 | 97 | 3 |
230820 | 230820 | 2020-06-12 | Blount | Alabama | 1009 | 97 | 1 |
233231 | 233231 | 2020-06-12 | Blount | Tennessee | 47009 | 104 | 3 |
233925 | 233925 | 2020-06-13 | Blount | Alabama | 1009 | 104 | 1 |
236337 | 236337 | 2020-06-13 | Blount | Tennessee | 47009 | 103 | 3 |
237032 | 237032 | 2020-06-14 | Blount | Alabama | 1009 | 112 | 1 |
239445 | 239445 | 2020-06-14 | Blount | Tennessee | 47009 | 104 | 3 |
240140 | 240140 | 2020-06-15 | Blount | Alabama | 1009 | 116 | 1 |
242555 | 242555 | 2020-06-15 | Blount | Tennessee | 47009 | 106 | 3 |
243251 | 243251 | 2020-06-16 | Blount | Alabama | 1009 | 121 | 1 |
245667 | 245667 | 2020-06-16 | Blount | Tennessee | 47009 | 110 | 3 |
246364 | 246364 | 2020-06-17 | Blount | Alabama | 1009 | 123 | 1 |
248780 | 248780 | 2020-06-17 | Blount | Tennessee | 47009 | 115 | 3 |
249476 | 249476 | 2020-06-18 | Blount | Alabama | 1009 | 130 | 1 |
251895 | 251895 | 2020-06-18 | Blount | Tennessee | 47009 | 118 | 3 |
252591 | 252591 | 2020-06-19 | Blount | Alabama | 1009 | 139 | 1 |
255010 | 255010 | 2020-06-19 | Blount | Tennessee | 47009 | 119 | 3 |
255710 | 255710 | 2020-06-20 | Blount | Alabama | 1009 | 143 | 1 |
258136 | 258136 | 2020-06-20 | Blount | Tennessee | 47009 | 127 | 3 |
258837 | 258837 | 2020-06-21 | Blount | Alabama | 1009 | 149 | 1 |
261263 | 261263 | 2020-06-21 | Blount | Tennessee | 47009 | 127 | 3 |
261964 | 261964 | 2020-06-22 | Blount | Alabama | 1009 | 153 | 1 |
264391 | 264391 | 2020-06-22 | Blount | Tennessee | 47009 | 130 | 3 |
265093 | 265093 | 2020-06-23 | Blount | Alabama | 1009 | 159 | 1 |
267519 | 267519 | 2020-06-23 | Blount | Tennessee | 47009 | 139 | 3 |
268222 | 268222 | 2020-06-24 | Blount | Alabama | 1009 | 168 | 1 |
270653 | 270653 | 2020-06-24 | Blount | Tennessee | 47009 | 142 | 3 |
271356 | 271356 | 2020-06-25 | Blount | Alabama | 1009 | 176 | 1 |
273792 | 273792 | 2020-06-25 | Blount | Tennessee | 47009 | 150 | 3 |
274496 | 274496 | 2020-06-26 | Blount | Alabama | 1009 | 184 | 1 |
276939 | 276939 | 2020-06-26 | Blount | Tennessee | 47009 | 152 | 3 |
277644 | 277644 | 2020-06-27 | Blount | Alabama | 1009 | 188 | 1 |
280087 | 280087 | 2020-06-27 | Blount | Tennessee | 47009 | 156 | 3 |
280792 | 280792 | 2020-06-28 | Blount | Alabama | 1009 | 189 | 1 |
283233 | 283233 | 2020-06-28 | Blount | Tennessee | 47009 | 156 | 3 |
283938 | 283938 | 2020-06-29 | Blount | Alabama | 1009 | 199 | 1 |
286378 | 286378 | 2020-06-29 | Blount | Tennessee | 47009 | 162 | 3 |
287084 | 287084 | 2020-06-30 | Blount | Alabama | 1009 | 208 | 1 |
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);