ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Allegany" 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 |
---|---|---|---|---|---|---|---|
636731 | 636731 | 2020-10-16 | Allegany | New York | 36003 | 188 | 6 |
633485 | 633485 | 2020-10-15 | Allegany | New York | 36003 | 176 | 5 |
630240 | 630240 | 2020-10-14 | Allegany | New York | 36003 | 161 | 4 |
626996 | 626996 | 2020-10-13 | Allegany | New York | 36003 | 156 | 4 |
623754 | 623754 | 2020-10-12 | Allegany | New York | 36003 | 151 | 4 |
620511 | 620511 | 2020-10-11 | Allegany | New York | 36003 | 150 | 4 |
617269 | 617269 | 2020-10-10 | Allegany | New York | 36003 | 144 | 4 |
614027 | 614027 | 2020-10-09 | Allegany | New York | 36003 | 141 | 4 |
610786 | 610786 | 2020-10-08 | Allegany | New York | 36003 | 131 | 4 |
607544 | 607544 | 2020-10-07 | Allegany | New York | 36003 | 130 | 4 |
604301 | 604301 | 2020-10-06 | Allegany | New York | 36003 | 128 | 4 |
601059 | 601059 | 2020-10-05 | Allegany | New York | 36003 | 125 | 4 |
597816 | 597816 | 2020-10-04 | Allegany | New York | 36003 | 124 | 4 |
594573 | 594573 | 2020-10-03 | Allegany | New York | 36003 | 124 | 4 |
591332 | 591332 | 2020-10-02 | Allegany | New York | 36003 | 122 | 4 |
588091 | 588091 | 2020-10-01 | Allegany | New York | 36003 | 119 | 4 |
584851 | 584851 | 2020-09-30 | Allegany | New York | 36003 | 114 | 4 |
581610 | 581610 | 2020-09-29 | Allegany | New York | 36003 | 108 | 2 |
578370 | 578370 | 2020-09-28 | Allegany | New York | 36003 | 106 | 2 |
575129 | 575129 | 2020-09-27 | Allegany | New York | 36003 | 106 | 2 |
571885 | 571885 | 2020-09-26 | Allegany | New York | 36003 | 106 | 2 |
568643 | 568643 | 2020-09-25 | Allegany | New York | 36003 | 103 | 2 |
565402 | 565402 | 2020-09-24 | Allegany | New York | 36003 | 101 | 2 |
562161 | 562161 | 2020-09-23 | Allegany | New York | 36003 | 99 | 2 |
558924 | 558924 | 2020-09-22 | Allegany | New York | 36003 | 99 | 2 |
555687 | 555687 | 2020-09-21 | Allegany | New York | 36003 | 99 | 2 |
552450 | 552450 | 2020-09-20 | Allegany | New York | 36003 | 98 | 2 |
549211 | 549211 | 2020-09-19 | Allegany | New York | 36003 | 96 | 2 |
545972 | 545972 | 2020-09-18 | Allegany | New York | 36003 | 95 | 2 |
542735 | 542735 | 2020-09-17 | Allegany | New York | 36003 | 94 | 2 |
539499 | 539499 | 2020-09-16 | Allegany | New York | 36003 | 94 | 2 |
536262 | 536262 | 2020-09-15 | Allegany | New York | 36003 | 94 | 2 |
533026 | 533026 | 2020-09-14 | Allegany | New York | 36003 | 94 | 2 |
529791 | 529791 | 2020-09-13 | Allegany | New York | 36003 | 94 | 2 |
526554 | 526554 | 2020-09-12 | Allegany | New York | 36003 | 94 | 2 |
523318 | 523318 | 2020-09-11 | Allegany | New York | 36003 | 93 | 2 |
520082 | 520082 | 2020-09-10 | Allegany | New York | 36003 | 93 | 2 |
516846 | 516846 | 2020-09-09 | Allegany | New York | 36003 | 92 | 2 |
513611 | 513611 | 2020-09-08 | Allegany | New York | 36003 | 92 | 2 |
510378 | 510378 | 2020-09-07 | Allegany | New York | 36003 | 92 | 2 |
507145 | 507145 | 2020-09-06 | Allegany | New York | 36003 | 92 | 2 |
503913 | 503913 | 2020-09-05 | Allegany | New York | 36003 | 92 | 2 |
500679 | 500679 | 2020-09-04 | Allegany | New York | 36003 | 90 | 2 |
497445 | 497445 | 2020-09-03 | Allegany | New York | 36003 | 90 | 2 |
494212 | 494212 | 2020-09-02 | Allegany | New York | 36003 | 89 | 2 |
490978 | 490978 | 2020-09-01 | Allegany | New York | 36003 | 89 | 2 |
487745 | 487745 | 2020-08-31 | Allegany | New York | 36003 | 89 | 2 |
484512 | 484512 | 2020-08-30 | Allegany | New York | 36003 | 89 | 2 |
481277 | 481277 | 2020-08-29 | Allegany | New York | 36003 | 88 | 2 |
478044 | 478044 | 2020-08-28 | Allegany | New York | 36003 | 87 | 2 |
474811 | 474811 | 2020-08-27 | Allegany | New York | 36003 | 87 | 2 |
471577 | 471577 | 2020-08-26 | Allegany | New York | 36003 | 86 | 2 |
468345 | 468345 | 2020-08-25 | Allegany | New York | 36003 | 86 | 2 |
465117 | 465117 | 2020-08-24 | Allegany | New York | 36003 | 85 | 2 |
461888 | 461888 | 2020-08-23 | Allegany | New York | 36003 | 85 | 2 |
458660 | 458660 | 2020-08-22 | Allegany | New York | 36003 | 84 | 2 |
455432 | 455432 | 2020-08-21 | Allegany | New York | 36003 | 84 | 2 |
452204 | 452204 | 2020-08-20 | Allegany | New York | 36003 | 81 | 2 |
448976 | 448976 | 2020-08-19 | Allegany | New York | 36003 | 80 | 2 |
445748 | 445748 | 2020-08-18 | Allegany | New York | 36003 | 80 | 2 |
442522 | 442522 | 2020-08-17 | Allegany | New York | 36003 | 80 | 2 |
439295 | 439295 | 2020-08-16 | Allegany | New York | 36003 | 80 | 2 |
436070 | 436070 | 2020-08-15 | Allegany | New York | 36003 | 80 | 2 |
432844 | 432844 | 2020-08-14 | Allegany | New York | 36003 | 80 | 2 |
429618 | 429618 | 2020-08-13 | Allegany | New York | 36003 | 80 | 2 |
426393 | 426393 | 2020-08-12 | Allegany | New York | 36003 | 80 | 2 |
423170 | 423170 | 2020-08-11 | Allegany | New York | 36003 | 80 | 2 |
419947 | 419947 | 2020-08-10 | Allegany | New York | 36003 | 80 | 2 |
416727 | 416727 | 2020-08-09 | Allegany | New York | 36003 | 79 | 2 |
413506 | 413506 | 2020-08-08 | Allegany | New York | 36003 | 79 | 2 |
410286 | 410286 | 2020-08-07 | Allegany | New York | 36003 | 79 | 2 |
407066 | 407066 | 2020-08-06 | Allegany | New York | 36003 | 78 | 2 |
403847 | 403847 | 2020-08-05 | Allegany | New York | 36003 | 76 | 0 |
400629 | 400629 | 2020-08-04 | Allegany | New York | 36003 | 75 | 0 |
397414 | 397414 | 2020-08-03 | Allegany | New York | 36003 | 75 | 0 |
394197 | 394197 | 2020-08-02 | Allegany | New York | 36003 | 74 | 0 |
390981 | 390981 | 2020-08-01 | Allegany | New York | 36003 | 74 | 0 |
387764 | 387764 | 2020-07-31 | Allegany | New York | 36003 | 74 | 0 |
384547 | 384547 | 2020-07-30 | Allegany | New York | 36003 | 74 | 0 |
381329 | 381329 | 2020-07-29 | Allegany | New York | 36003 | 74 | 0 |
378112 | 378112 | 2020-07-28 | Allegany | New York | 36003 | 74 | 0 |
374896 | 374896 | 2020-07-27 | Allegany | New York | 36003 | 74 | 0 |
371684 | 371684 | 2020-07-26 | Allegany | New York | 36003 | 74 | 0 |
368472 | 368472 | 2020-07-25 | Allegany | New York | 36003 | 74 | 0 |
365263 | 365263 | 2020-07-24 | Allegany | New York | 36003 | 74 | 0 |
362057 | 362057 | 2020-07-23 | Allegany | New York | 36003 | 72 | 0 |
358851 | 358851 | 2020-07-22 | Allegany | New York | 36003 | 72 | 0 |
355647 | 355647 | 2020-07-21 | Allegany | New York | 36003 | 72 | 0 |
352444 | 352444 | 2020-07-20 | Allegany | New York | 36003 | 71 | 0 |
349241 | 349241 | 2020-07-19 | Allegany | New York | 36003 | 71 | 0 |
346040 | 346040 | 2020-07-18 | Allegany | New York | 36003 | 71 | 0 |
342841 | 342841 | 2020-07-17 | Allegany | New York | 36003 | 71 | 0 |
339643 | 339643 | 2020-07-16 | Allegany | New York | 36003 | 70 | 0 |
336447 | 336447 | 2020-07-15 | Allegany | New York | 36003 | 69 | 0 |
333253 | 333253 | 2020-07-14 | Allegany | New York | 36003 | 68 | 0 |
330063 | 330063 | 2020-07-13 | Allegany | New York | 36003 | 66 | 0 |
326876 | 326876 | 2020-07-12 | Allegany | New York | 36003 | 66 | 0 |
323692 | 323692 | 2020-07-11 | Allegany | New York | 36003 | 66 | 0 |
320512 | 320512 | 2020-07-10 | Allegany | New York | 36003 | 64 | 0 |
317335 | 317335 | 2020-07-09 | Allegany | New York | 36003 | 64 | 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);