ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Essex" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636744 | 636744 | 2020-10-16 | Essex | New York | 36031 | 192 | 14 |
633498 | 633498 | 2020-10-15 | Essex | New York | 36031 | 190 | 14 |
630253 | 630253 | 2020-10-14 | Essex | New York | 36031 | 189 | 14 |
627009 | 627009 | 2020-10-13 | Essex | New York | 36031 | 189 | 14 |
623767 | 623767 | 2020-10-12 | Essex | New York | 36031 | 187 | 14 |
620524 | 620524 | 2020-10-11 | Essex | New York | 36031 | 186 | 14 |
617282 | 617282 | 2020-10-10 | Essex | New York | 36031 | 186 | 14 |
614040 | 614040 | 2020-10-09 | Essex | New York | 36031 | 185 | 14 |
610799 | 610799 | 2020-10-08 | Essex | New York | 36031 | 184 | 14 |
607557 | 607557 | 2020-10-07 | Essex | New York | 36031 | 182 | 14 |
604314 | 604314 | 2020-10-06 | Essex | New York | 36031 | 180 | 14 |
601072 | 601072 | 2020-10-05 | Essex | New York | 36031 | 179 | 14 |
597829 | 597829 | 2020-10-04 | Essex | New York | 36031 | 178 | 14 |
594586 | 594586 | 2020-10-03 | Essex | New York | 36031 | 178 | 14 |
591345 | 591345 | 2020-10-02 | Essex | New York | 36031 | 177 | 14 |
588104 | 588104 | 2020-10-01 | Essex | New York | 36031 | 177 | 14 |
584864 | 584864 | 2020-09-30 | Essex | New York | 36031 | 177 | 14 |
581623 | 581623 | 2020-09-29 | Essex | New York | 36031 | 176 | 13 |
578383 | 578383 | 2020-09-28 | Essex | New York | 36031 | 176 | 13 |
575142 | 575142 | 2020-09-27 | Essex | New York | 36031 | 175 | 13 |
571898 | 571898 | 2020-09-26 | Essex | New York | 36031 | 175 | 13 |
568656 | 568656 | 2020-09-25 | Essex | New York | 36031 | 172 | 13 |
565415 | 565415 | 2020-09-24 | Essex | New York | 36031 | 172 | 13 |
562174 | 562174 | 2020-09-23 | Essex | New York | 36031 | 169 | 13 |
558937 | 558937 | 2020-09-22 | Essex | New York | 36031 | 169 | 13 |
555700 | 555700 | 2020-09-21 | Essex | New York | 36031 | 168 | 13 |
552463 | 552463 | 2020-09-20 | Essex | New York | 36031 | 168 | 13 |
549224 | 549224 | 2020-09-19 | Essex | New York | 36031 | 166 | 13 |
545985 | 545985 | 2020-09-18 | Essex | New York | 36031 | 165 | 13 |
542748 | 542748 | 2020-09-17 | Essex | New York | 36031 | 162 | 12 |
539512 | 539512 | 2020-09-16 | Essex | New York | 36031 | 162 | 12 |
536275 | 536275 | 2020-09-15 | Essex | New York | 36031 | 161 | 12 |
533039 | 533039 | 2020-09-14 | Essex | New York | 36031 | 159 | 11 |
529804 | 529804 | 2020-09-13 | Essex | New York | 36031 | 159 | 11 |
526567 | 526567 | 2020-09-12 | Essex | New York | 36031 | 159 | 10 |
523331 | 523331 | 2020-09-11 | Essex | New York | 36031 | 158 | 10 |
520095 | 520095 | 2020-09-10 | Essex | New York | 36031 | 158 | 10 |
516859 | 516859 | 2020-09-09 | Essex | New York | 36031 | 157 | 9 |
513624 | 513624 | 2020-09-08 | Essex | New York | 36031 | 157 | 9 |
510391 | 510391 | 2020-09-07 | Essex | New York | 36031 | 157 | 9 |
507158 | 507158 | 2020-09-06 | Essex | New York | 36031 | 156 | 9 |
503926 | 503926 | 2020-09-05 | Essex | New York | 36031 | 155 | 7 |
500692 | 500692 | 2020-09-04 | Essex | New York | 36031 | 153 | 7 |
497458 | 497458 | 2020-09-03 | Essex | New York | 36031 | 149 | 7 |
494225 | 494225 | 2020-09-02 | Essex | New York | 36031 | 143 | 6 |
490991 | 490991 | 2020-09-01 | Essex | New York | 36031 | 139 | 6 |
487758 | 487758 | 2020-08-31 | Essex | New York | 36031 | 137 | 6 |
484525 | 484525 | 2020-08-30 | Essex | New York | 36031 | 136 | 6 |
481290 | 481290 | 2020-08-29 | Essex | New York | 36031 | 134 | 5 |
478057 | 478057 | 2020-08-28 | Essex | New York | 36031 | 134 | 3 |
474824 | 474824 | 2020-08-27 | Essex | New York | 36031 | 127 | 3 |
471590 | 471590 | 2020-08-26 | Essex | New York | 36031 | 113 | 3 |
468358 | 468358 | 2020-08-25 | Essex | New York | 36031 | 109 | 2 |
465130 | 465130 | 2020-08-24 | Essex | New York | 36031 | 108 | 2 |
461901 | 461901 | 2020-08-23 | Essex | New York | 36031 | 108 | 2 |
458673 | 458673 | 2020-08-22 | Essex | New York | 36031 | 106 | 1 |
455445 | 455445 | 2020-08-21 | Essex | New York | 36031 | 93 | 1 |
452217 | 452217 | 2020-08-20 | Essex | New York | 36031 | 93 | 1 |
448989 | 448989 | 2020-08-19 | Essex | New York | 36031 | 71 | 0 |
445761 | 445761 | 2020-08-18 | Essex | New York | 36031 | 71 | 0 |
442535 | 442535 | 2020-08-17 | Essex | New York | 36031 | 67 | 0 |
439308 | 439308 | 2020-08-16 | Essex | New York | 36031 | 67 | 0 |
436083 | 436083 | 2020-08-15 | Essex | New York | 36031 | 67 | 0 |
432857 | 432857 | 2020-08-14 | Essex | New York | 36031 | 65 | 0 |
429631 | 429631 | 2020-08-13 | Essex | New York | 36031 | 64 | 0 |
426406 | 426406 | 2020-08-12 | Essex | New York | 36031 | 64 | 0 |
423183 | 423183 | 2020-08-11 | Essex | New York | 36031 | 64 | 0 |
419960 | 419960 | 2020-08-10 | Essex | New York | 36031 | 63 | 0 |
416740 | 416740 | 2020-08-09 | Essex | New York | 36031 | 63 | 0 |
413519 | 413519 | 2020-08-08 | Essex | New York | 36031 | 63 | 0 |
410299 | 410299 | 2020-08-07 | Essex | New York | 36031 | 63 | 0 |
407079 | 407079 | 2020-08-06 | Essex | New York | 36031 | 55 | 0 |
403860 | 403860 | 2020-08-05 | Essex | New York | 36031 | 63 | 0 |
400642 | 400642 | 2020-08-04 | Essex | New York | 36031 | 63 | 0 |
397427 | 397427 | 2020-08-03 | Essex | New York | 36031 | 63 | 0 |
394210 | 394210 | 2020-08-02 | Essex | New York | 36031 | 63 | 0 |
390994 | 390994 | 2020-08-01 | Essex | New York | 36031 | 63 | 0 |
387777 | 387777 | 2020-07-31 | Essex | New York | 36031 | 63 | 0 |
384560 | 384560 | 2020-07-30 | Essex | New York | 36031 | 63 | 0 |
381342 | 381342 | 2020-07-29 | Essex | New York | 36031 | 63 | 0 |
378125 | 378125 | 2020-07-28 | Essex | New York | 36031 | 63 | 0 |
374909 | 374909 | 2020-07-27 | Essex | New York | 36031 | 63 | 0 |
371697 | 371697 | 2020-07-26 | Essex | New York | 36031 | 62 | 0 |
368485 | 368485 | 2020-07-25 | Essex | New York | 36031 | 62 | 0 |
365276 | 365276 | 2020-07-24 | Essex | New York | 36031 | 62 | 0 |
362070 | 362070 | 2020-07-23 | Essex | New York | 36031 | 62 | 0 |
358864 | 358864 | 2020-07-22 | Essex | New York | 36031 | 62 | 0 |
355660 | 355660 | 2020-07-21 | Essex | New York | 36031 | 59 | 0 |
352457 | 352457 | 2020-07-20 | Essex | New York | 36031 | 59 | 0 |
349254 | 349254 | 2020-07-19 | Essex | New York | 36031 | 59 | 0 |
346053 | 346053 | 2020-07-18 | Essex | New York | 36031 | 59 | 0 |
342854 | 342854 | 2020-07-17 | Essex | New York | 36031 | 59 | 0 |
339656 | 339656 | 2020-07-16 | Essex | New York | 36031 | 59 | 0 |
336460 | 336460 | 2020-07-15 | Essex | New York | 36031 | 59 | 0 |
333266 | 333266 | 2020-07-14 | Essex | New York | 36031 | 59 | 0 |
330076 | 330076 | 2020-07-13 | Essex | New York | 36031 | 59 | 0 |
326889 | 326889 | 2020-07-12 | Essex | New York | 36031 | 59 | 0 |
323705 | 323705 | 2020-07-11 | Essex | New York | 36031 | 59 | 0 |
320525 | 320525 | 2020-07-10 | Essex | New York | 36031 | 59 | 0 |
317348 | 317348 | 2020-07-09 | Essex | New York | 36031 | 59 | 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);