ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Henderson" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387865 | 387865 | 2020-07-31 | Henderson | North Carolina | 37089 | 1365 | 54 |
384648 | 384648 | 2020-07-30 | Henderson | North Carolina | 37089 | 1325 | 54 |
381430 | 381430 | 2020-07-29 | Henderson | North Carolina | 37089 | 1321 | 54 |
378213 | 378213 | 2020-07-28 | Henderson | North Carolina | 37089 | 1321 | 54 |
374997 | 374997 | 2020-07-27 | Henderson | North Carolina | 37089 | 1288 | 53 |
371785 | 371785 | 2020-07-26 | Henderson | North Carolina | 37089 | 1279 | 53 |
368573 | 368573 | 2020-07-25 | Henderson | North Carolina | 37089 | 1265 | 53 |
365364 | 365364 | 2020-07-24 | Henderson | North Carolina | 37089 | 1234 | 52 |
362158 | 362158 | 2020-07-23 | Henderson | North Carolina | 37089 | 1210 | 52 |
358952 | 358952 | 2020-07-22 | Henderson | North Carolina | 37089 | 1191 | 52 |
355748 | 355748 | 2020-07-21 | Henderson | North Carolina | 37089 | 1137 | 52 |
352545 | 352545 | 2020-07-20 | Henderson | North Carolina | 37089 | 1126 | 52 |
349342 | 349342 | 2020-07-19 | Henderson | North Carolina | 37089 | 1098 | 52 |
346141 | 346141 | 2020-07-18 | Henderson | North Carolina | 37089 | 1056 | 52 |
342942 | 342942 | 2020-07-17 | Henderson | North Carolina | 37089 | 1034 | 51 |
339744 | 339744 | 2020-07-16 | Henderson | North Carolina | 37089 | 1016 | 51 |
336548 | 336548 | 2020-07-15 | Henderson | North Carolina | 37089 | 982 | 51 |
333354 | 333354 | 2020-07-14 | Henderson | North Carolina | 37089 | 973 | 51 |
330164 | 330164 | 2020-07-13 | Henderson | North Carolina | 37089 | 951 | 51 |
326977 | 326977 | 2020-07-12 | Henderson | North Carolina | 37089 | 885 | 51 |
323793 | 323793 | 2020-07-11 | Henderson | North Carolina | 37089 | 883 | 51 |
320613 | 320613 | 2020-07-10 | Henderson | North Carolina | 37089 | 883 | 51 |
317436 | 317436 | 2020-07-09 | Henderson | North Carolina | 37089 | 820 | 51 |
314262 | 314262 | 2020-07-08 | Henderson | North Carolina | 37089 | 789 | 51 |
311091 | 311091 | 2020-07-07 | Henderson | North Carolina | 37089 | 738 | 51 |
307923 | 307923 | 2020-07-06 | Henderson | North Carolina | 37089 | 720 | 51 |
304756 | 304756 | 2020-07-05 | Henderson | North Carolina | 37089 | 703 | 50 |
301593 | 301593 | 2020-07-04 | Henderson | North Carolina | 37089 | 687 | 50 |
298430 | 298430 | 2020-07-03 | Henderson | North Carolina | 37089 | 675 | 50 |
295270 | 295270 | 2020-07-02 | Henderson | North Carolina | 37089 | 667 | 50 |
292115 | 292115 | 2020-07-01 | Henderson | North Carolina | 37089 | 655 | 50 |
288963 | 288963 | 2020-06-30 | Henderson | North Carolina | 37089 | 610 | 50 |
285813 | 285813 | 2020-06-29 | Henderson | North Carolina | 37089 | 606 | 50 |
282668 | 282668 | 2020-06-28 | Henderson | North Carolina | 37089 | 569 | 50 |
279522 | 279522 | 2020-06-27 | Henderson | North Carolina | 37089 | 558 | 50 |
276374 | 276374 | 2020-06-26 | Henderson | North Carolina | 37089 | 558 | 50 |
273228 | 273228 | 2020-06-25 | Henderson | North Carolina | 37089 | 540 | 50 |
270089 | 270089 | 2020-06-24 | Henderson | North Carolina | 37089 | 540 | 50 |
266955 | 266955 | 2020-06-23 | Henderson | North Carolina | 37089 | 514 | 49 |
263827 | 263827 | 2020-06-22 | Henderson | North Carolina | 37089 | 514 | 49 |
260699 | 260699 | 2020-06-21 | Henderson | North Carolina | 37089 | 497 | 49 |
257572 | 257572 | 2020-06-20 | Henderson | North Carolina | 37089 | 491 | 49 |
254449 | 254449 | 2020-06-19 | Henderson | North Carolina | 37089 | 480 | 49 |
251334 | 251334 | 2020-06-18 | Henderson | North Carolina | 37089 | 471 | 49 |
248219 | 248219 | 2020-06-17 | Henderson | North Carolina | 37089 | 463 | 49 |
245106 | 245106 | 2020-06-16 | Henderson | North Carolina | 37089 | 458 | 49 |
241994 | 241994 | 2020-06-15 | Henderson | North Carolina | 37089 | 455 | 49 |
238885 | 238885 | 2020-06-14 | Henderson | North Carolina | 37089 | 441 | 49 |
235777 | 235777 | 2020-06-13 | Henderson | North Carolina | 37089 | 433 | 49 |
232672 | 232672 | 2020-06-12 | Henderson | North Carolina | 37089 | 433 | 49 |
229567 | 229567 | 2020-06-11 | Henderson | North Carolina | 37089 | 403 | 49 |
226463 | 226463 | 2020-06-10 | Henderson | North Carolina | 37089 | 403 | 49 |
223363 | 223363 | 2020-06-09 | Henderson | North Carolina | 37089 | 388 | 48 |
220269 | 220269 | 2020-06-08 | Henderson | North Carolina | 37089 | 388 | 48 |
217177 | 217177 | 2020-06-07 | Henderson | North Carolina | 37089 | 372 | 48 |
214087 | 214087 | 2020-06-06 | Henderson | North Carolina | 37089 | 368 | 48 |
211003 | 211003 | 2020-06-05 | Henderson | North Carolina | 37089 | 365 | 48 |
207921 | 207921 | 2020-06-04 | Henderson | North Carolina | 37089 | 353 | 47 |
204840 | 204840 | 2020-06-03 | Henderson | North Carolina | 37089 | 351 | 47 |
201763 | 201763 | 2020-06-02 | Henderson | North Carolina | 37089 | 351 | 45 |
198689 | 198689 | 2020-06-01 | Henderson | North Carolina | 37089 | 346 | 45 |
195616 | 195616 | 2020-05-31 | Henderson | North Carolina | 37089 | 344 | 45 |
192546 | 192546 | 2020-05-30 | Henderson | North Carolina | 37089 | 338 | 45 |
189482 | 189482 | 2020-05-29 | Henderson | North Carolina | 37089 | 333 | 45 |
186422 | 186422 | 2020-05-28 | Henderson | North Carolina | 37089 | 326 | 46 |
183365 | 183365 | 2020-05-27 | Henderson | North Carolina | 37089 | 324 | 46 |
180317 | 180317 | 2020-05-26 | Henderson | North Carolina | 37089 | 318 | 43 |
177274 | 177274 | 2020-05-25 | Henderson | North Carolina | 37089 | 318 | 42 |
174230 | 174230 | 2020-05-24 | Henderson | North Carolina | 37089 | 315 | 42 |
171188 | 171188 | 2020-05-23 | Henderson | North Carolina | 37089 | 312 | 42 |
168149 | 168149 | 2020-05-22 | Henderson | North Carolina | 37089 | 305 | 41 |
165114 | 165114 | 2020-05-21 | Henderson | North Carolina | 37089 | 302 | 41 |
162085 | 162085 | 2020-05-20 | Henderson | North Carolina | 37089 | 298 | 41 |
159058 | 159058 | 2020-05-19 | Henderson | North Carolina | 37089 | 295 | 41 |
156039 | 156039 | 2020-05-18 | Henderson | North Carolina | 37089 | 287 | 39 |
153022 | 153022 | 2020-05-17 | Henderson | North Carolina | 37089 | 282 | 38 |
150012 | 150012 | 2020-05-16 | Henderson | North Carolina | 37089 | 279 | 38 |
147005 | 147005 | 2020-05-15 | Henderson | North Carolina | 37089 | 273 | 36 |
144004 | 144004 | 2020-05-14 | Henderson | North Carolina | 37089 | 261 | 35 |
141009 | 141009 | 2020-05-13 | Henderson | North Carolina | 37089 | 250 | 30 |
138013 | 138013 | 2020-05-12 | Henderson | North Carolina | 37089 | 237 | 28 |
135023 | 135023 | 2020-05-11 | Henderson | North Carolina | 37089 | 227 | 28 |
132032 | 132032 | 2020-05-10 | Henderson | North Carolina | 37089 | 226 | 27 |
129043 | 129043 | 2020-05-09 | Henderson | North Carolina | 37089 | 224 | 27 |
126054 | 126054 | 2020-05-08 | Henderson | North Carolina | 37089 | 218 | 24 |
123071 | 123071 | 2020-05-07 | Henderson | North Carolina | 37089 | 216 | 23 |
120096 | 120096 | 2020-05-06 | Henderson | North Carolina | 37089 | 213 | 22 |
117135 | 117135 | 2020-05-05 | Henderson | North Carolina | 37089 | 210 | 21 |
114255 | 114255 | 2020-05-04 | Henderson | North Carolina | 37089 | 203 | 21 |
111374 | 111374 | 2020-05-03 | Henderson | North Carolina | 37089 | 201 | 21 |
108501 | 108501 | 2020-05-02 | Henderson | North Carolina | 37089 | 201 | 21 |
105634 | 105634 | 2020-05-01 | Henderson | North Carolina | 37089 | 195 | 21 |
102772 | 102772 | 2020-04-30 | Henderson | North Carolina | 37089 | 177 | 20 |
99919 | 99919 | 2020-04-29 | Henderson | North Carolina | 37089 | 159 | 18 |
97072 | 97072 | 2020-04-28 | Henderson | North Carolina | 37089 | 155 | 16 |
94235 | 94235 | 2020-04-27 | Henderson | North Carolina | 37089 | 156 | 14 |
91409 | 91409 | 2020-04-26 | Henderson | North Carolina | 37089 | 156 | 14 |
88594 | 88594 | 2020-04-25 | Henderson | North Carolina | 37089 | 152 | 14 |
85782 | 85782 | 2020-04-24 | Henderson | North Carolina | 37089 | 147 | 14 |
82978 | 82978 | 2020-04-23 | Henderson | North Carolina | 37089 | 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);