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 |
---|---|---|---|---|---|---|---|
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 |
314174 | 314174 | 2020-07-08 | Essex | New York | 36031 | 57 | 0 |
311003 | 311003 | 2020-07-07 | Essex | New York | 36031 | 57 | 0 |
307835 | 307835 | 2020-07-06 | Essex | New York | 36031 | 57 | 0 |
304668 | 304668 | 2020-07-05 | Essex | New York | 36031 | 56 | 0 |
301505 | 301505 | 2020-07-04 | Essex | New York | 36031 | 55 | 0 |
298342 | 298342 | 2020-07-03 | Essex | New York | 36031 | 54 | 0 |
295182 | 295182 | 2020-07-02 | Essex | New York | 36031 | 50 | 0 |
292027 | 292027 | 2020-07-01 | Essex | New York | 36031 | 50 | 0 |
288875 | 288875 | 2020-06-30 | Essex | New York | 36031 | 50 | 0 |
285725 | 285725 | 2020-06-29 | Essex | New York | 36031 | 50 | 0 |
282580 | 282580 | 2020-06-28 | Essex | New York | 36031 | 50 | 0 |
279434 | 279434 | 2020-06-27 | Essex | New York | 36031 | 50 | 0 |
276286 | 276286 | 2020-06-26 | Essex | New York | 36031 | 49 | 0 |
273140 | 273140 | 2020-06-25 | Essex | New York | 36031 | 49 | 0 |
270001 | 270001 | 2020-06-24 | Essex | New York | 36031 | 49 | 0 |
266867 | 266867 | 2020-06-23 | Essex | New York | 36031 | 49 | 0 |
263739 | 263739 | 2020-06-22 | Essex | New York | 36031 | 49 | 0 |
260611 | 260611 | 2020-06-21 | Essex | New York | 36031 | 49 | 0 |
257484 | 257484 | 2020-06-20 | Essex | New York | 36031 | 49 | 0 |
254361 | 254361 | 2020-06-19 | Essex | New York | 36031 | 48 | 0 |
251246 | 251246 | 2020-06-18 | Essex | New York | 36031 | 48 | 0 |
248131 | 248131 | 2020-06-17 | Essex | New York | 36031 | 48 | 0 |
245018 | 245018 | 2020-06-16 | Essex | New York | 36031 | 48 | 0 |
241906 | 241906 | 2020-06-15 | Essex | New York | 36031 | 48 | 0 |
238797 | 238797 | 2020-06-14 | Essex | New York | 36031 | 48 | 0 |
235689 | 235689 | 2020-06-13 | Essex | New York | 36031 | 48 | 0 |
232584 | 232584 | 2020-06-12 | Essex | New York | 36031 | 48 | 0 |
229479 | 229479 | 2020-06-11 | Essex | New York | 36031 | 48 | 0 |
226375 | 226375 | 2020-06-10 | Essex | New York | 36031 | 48 | 0 |
223275 | 223275 | 2020-06-09 | Essex | New York | 36031 | 48 | 0 |
220181 | 220181 | 2020-06-08 | Essex | New York | 36031 | 47 | 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);