ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36083 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 |
---|---|---|---|---|---|---|---|
636768 | 636768 | 2020-10-16 | Rensselaer | New York | 36083 | 1020 | 42 |
633522 | 633522 | 2020-10-15 | Rensselaer | New York | 36083 | 1007 | 42 |
630277 | 630277 | 2020-10-14 | Rensselaer | New York | 36083 | 1002 | 42 |
627033 | 627033 | 2020-10-13 | Rensselaer | New York | 36083 | 994 | 42 |
623791 | 623791 | 2020-10-12 | Rensselaer | New York | 36083 | 985 | 42 |
620548 | 620548 | 2020-10-11 | Rensselaer | New York | 36083 | 980 | 42 |
617306 | 617306 | 2020-10-10 | Rensselaer | New York | 36083 | 970 | 42 |
614064 | 614064 | 2020-10-09 | Rensselaer | New York | 36083 | 964 | 42 |
610823 | 610823 | 2020-10-08 | Rensselaer | New York | 36083 | 958 | 42 |
607581 | 607581 | 2020-10-07 | Rensselaer | New York | 36083 | 957 | 42 |
604338 | 604338 | 2020-10-06 | Rensselaer | New York | 36083 | 952 | 42 |
601096 | 601096 | 2020-10-05 | Rensselaer | New York | 36083 | 945 | 42 |
597853 | 597853 | 2020-10-04 | Rensselaer | New York | 36083 | 944 | 42 |
594610 | 594610 | 2020-10-03 | Rensselaer | New York | 36083 | 937 | 42 |
591369 | 591369 | 2020-10-02 | Rensselaer | New York | 36083 | 931 | 42 |
588128 | 588128 | 2020-10-01 | Rensselaer | New York | 36083 | 923 | 42 |
584888 | 584888 | 2020-09-30 | Rensselaer | New York | 36083 | 919 | 42 |
581647 | 581647 | 2020-09-29 | Rensselaer | New York | 36083 | 916 | 42 |
578407 | 578407 | 2020-09-28 | Rensselaer | New York | 36083 | 913 | 42 |
575166 | 575166 | 2020-09-27 | Rensselaer | New York | 36083 | 911 | 42 |
571922 | 571922 | 2020-09-26 | Rensselaer | New York | 36083 | 908 | 42 |
568680 | 568680 | 2020-09-25 | Rensselaer | New York | 36083 | 905 | 42 |
565439 | 565439 | 2020-09-24 | Rensselaer | New York | 36083 | 903 | 42 |
562198 | 562198 | 2020-09-23 | Rensselaer | New York | 36083 | 902 | 42 |
558961 | 558961 | 2020-09-22 | Rensselaer | New York | 36083 | 901 | 42 |
555724 | 555724 | 2020-09-21 | Rensselaer | New York | 36083 | 901 | 42 |
552487 | 552487 | 2020-09-20 | Rensselaer | New York | 36083 | 899 | 42 |
549248 | 549248 | 2020-09-19 | Rensselaer | New York | 36083 | 896 | 42 |
546009 | 546009 | 2020-09-18 | Rensselaer | New York | 36083 | 895 | 42 |
542772 | 542772 | 2020-09-17 | Rensselaer | New York | 36083 | 892 | 42 |
539536 | 539536 | 2020-09-16 | Rensselaer | New York | 36083 | 887 | 42 |
536299 | 536299 | 2020-09-15 | Rensselaer | New York | 36083 | 884 | 42 |
533063 | 533063 | 2020-09-14 | Rensselaer | New York | 36083 | 879 | 42 |
529828 | 529828 | 2020-09-13 | Rensselaer | New York | 36083 | 879 | 42 |
526591 | 526591 | 2020-09-12 | Rensselaer | New York | 36083 | 876 | 42 |
523355 | 523355 | 2020-09-11 | Rensselaer | New York | 36083 | 870 | 42 |
520119 | 520119 | 2020-09-10 | Rensselaer | New York | 36083 | 867 | 42 |
516883 | 516883 | 2020-09-09 | Rensselaer | New York | 36083 | 866 | 42 |
513648 | 513648 | 2020-09-08 | Rensselaer | New York | 36083 | 865 | 42 |
510415 | 510415 | 2020-09-07 | Rensselaer | New York | 36083 | 860 | 42 |
507182 | 507182 | 2020-09-06 | Rensselaer | New York | 36083 | 859 | 42 |
503950 | 503950 | 2020-09-05 | Rensselaer | New York | 36083 | 858 | 42 |
500716 | 500716 | 2020-09-04 | Rensselaer | New York | 36083 | 854 | 42 |
497482 | 497482 | 2020-09-03 | Rensselaer | New York | 36083 | 848 | 42 |
494249 | 494249 | 2020-09-02 | Rensselaer | New York | 36083 | 844 | 42 |
491015 | 491015 | 2020-09-01 | Rensselaer | New York | 36083 | 841 | 41 |
487782 | 487782 | 2020-08-31 | Rensselaer | New York | 36083 | 838 | 41 |
484549 | 484549 | 2020-08-30 | Rensselaer | New York | 36083 | 833 | 41 |
481314 | 481314 | 2020-08-29 | Rensselaer | New York | 36083 | 830 | 41 |
478081 | 478081 | 2020-08-28 | Rensselaer | New York | 36083 | 826 | 41 |
474848 | 474848 | 2020-08-27 | Rensselaer | New York | 36083 | 823 | 41 |
471614 | 471614 | 2020-08-26 | Rensselaer | New York | 36083 | 822 | 41 |
468382 | 468382 | 2020-08-25 | Rensselaer | New York | 36083 | 819 | 41 |
465154 | 465154 | 2020-08-24 | Rensselaer | New York | 36083 | 818 | 41 |
461925 | 461925 | 2020-08-23 | Rensselaer | New York | 36083 | 817 | 41 |
458697 | 458697 | 2020-08-22 | Rensselaer | New York | 36083 | 813 | 41 |
455469 | 455469 | 2020-08-21 | Rensselaer | New York | 36083 | 810 | 41 |
452241 | 452241 | 2020-08-20 | Rensselaer | New York | 36083 | 809 | 41 |
449013 | 449013 | 2020-08-19 | Rensselaer | New York | 36083 | 804 | 41 |
445785 | 445785 | 2020-08-18 | Rensselaer | New York | 36083 | 801 | 41 |
442559 | 442559 | 2020-08-17 | Rensselaer | New York | 36083 | 795 | 41 |
439332 | 439332 | 2020-08-16 | Rensselaer | New York | 36083 | 795 | 40 |
436107 | 436107 | 2020-08-15 | Rensselaer | New York | 36083 | 789 | 39 |
432881 | 432881 | 2020-08-14 | Rensselaer | New York | 36083 | 785 | 39 |
429655 | 429655 | 2020-08-13 | Rensselaer | New York | 36083 | 782 | 39 |
426430 | 426430 | 2020-08-12 | Rensselaer | New York | 36083 | 780 | 38 |
423207 | 423207 | 2020-08-11 | Rensselaer | New York | 36083 | 770 | 38 |
419984 | 419984 | 2020-08-10 | Rensselaer | New York | 36083 | 766 | 38 |
416764 | 416764 | 2020-08-09 | Rensselaer | New York | 36083 | 765 | 37 |
413543 | 413543 | 2020-08-08 | Rensselaer | New York | 36083 | 761 | 36 |
410323 | 410323 | 2020-08-07 | Rensselaer | New York | 36083 | 759 | 35 |
407103 | 407103 | 2020-08-06 | Rensselaer | New York | 36083 | 758 | 35 |
403884 | 403884 | 2020-08-05 | Rensselaer | New York | 36083 | 755 | 39 |
400666 | 400666 | 2020-08-04 | Rensselaer | New York | 36083 | 748 | 39 |
397451 | 397451 | 2020-08-03 | Rensselaer | New York | 36083 | 740 | 39 |
394234 | 394234 | 2020-08-02 | Rensselaer | New York | 36083 | 736 | 39 |
391018 | 391018 | 2020-08-01 | Rensselaer | New York | 36083 | 734 | 39 |
387801 | 387801 | 2020-07-31 | Rensselaer | New York | 36083 | 724 | 39 |
384584 | 384584 | 2020-07-30 | Rensselaer | New York | 36083 | 718 | 39 |
381366 | 381366 | 2020-07-29 | Rensselaer | New York | 36083 | 694 | 39 |
378149 | 378149 | 2020-07-28 | Rensselaer | New York | 36083 | 690 | 39 |
374933 | 374933 | 2020-07-27 | Rensselaer | New York | 36083 | 687 | 39 |
371721 | 371721 | 2020-07-26 | Rensselaer | New York | 36083 | 684 | 39 |
368509 | 368509 | 2020-07-25 | Rensselaer | New York | 36083 | 681 | 39 |
365300 | 365300 | 2020-07-24 | Rensselaer | New York | 36083 | 676 | 39 |
362094 | 362094 | 2020-07-23 | Rensselaer | New York | 36083 | 669 | 39 |
358888 | 358888 | 2020-07-22 | Rensselaer | New York | 36083 | 668 | 39 |
355684 | 355684 | 2020-07-21 | Rensselaer | New York | 36083 | 658 | 39 |
352481 | 352481 | 2020-07-20 | Rensselaer | New York | 36083 | 653 | 39 |
349278 | 349278 | 2020-07-19 | Rensselaer | New York | 36083 | 651 | 39 |
346077 | 346077 | 2020-07-18 | Rensselaer | New York | 36083 | 650 | 39 |
342878 | 342878 | 2020-07-17 | Rensselaer | New York | 36083 | 643 | 38 |
339680 | 339680 | 2020-07-16 | Rensselaer | New York | 36083 | 639 | 38 |
336484 | 336484 | 2020-07-15 | Rensselaer | New York | 36083 | 632 | 38 |
333290 | 333290 | 2020-07-14 | Rensselaer | New York | 36083 | 625 | 38 |
330100 | 330100 | 2020-07-13 | Rensselaer | New York | 36083 | 617 | 38 |
326913 | 326913 | 2020-07-12 | Rensselaer | New York | 36083 | 616 | 38 |
323729 | 323729 | 2020-07-11 | Rensselaer | New York | 36083 | 593 | 38 |
320549 | 320549 | 2020-07-10 | Rensselaer | New York | 36083 | 588 | 38 |
317372 | 317372 | 2020-07-09 | Rensselaer | New York | 36083 | 586 | 38 |
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);