ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,900 rows where county = "Putnam" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
county 1
- Putnam · 1,734 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635260 | 635260 | 2020-10-16 | Putnam | Florida | 12107 | 2253 | 47 |
635391 | 635391 | 2020-10-16 | Putnam | Georgia | 13237 | 809 | 27 |
635561 | 635561 | 2020-10-16 | Putnam | Illinois | 17155 | 81 | 0 |
635653 | 635653 | 2020-10-16 | Putnam | Indiana | 18133 | 685 | 15 |
636468 | 636468 | 2020-10-16 | Putnam | Missouri | 29171 | 47 | 1 |
636767 | 636767 | 2020-10-16 | Putnam | New York | 36079 | 1716 | 63 |
637012 | 637012 | 2020-10-16 | Putnam | Ohio | 39137 | 821 | 27 |
637480 | 637480 | 2020-10-16 | Putnam | Tennessee | 47141 | 3948 | 51 |
638018 | 638018 | 2020-10-16 | Putnam | West Virginia | 54079 | 767 | 10 |
632014 | 632014 | 2020-10-15 | Putnam | Florida | 12107 | 2240 | 46 |
632145 | 632145 | 2020-10-15 | Putnam | Georgia | 13237 | 803 | 27 |
632315 | 632315 | 2020-10-15 | Putnam | Illinois | 17155 | 75 | 0 |
632407 | 632407 | 2020-10-15 | Putnam | Indiana | 18133 | 681 | 15 |
633222 | 633222 | 2020-10-15 | Putnam | Missouri | 29171 | 46 | 1 |
633521 | 633521 | 2020-10-15 | Putnam | New York | 36079 | 1710 | 63 |
633766 | 633766 | 2020-10-15 | Putnam | Ohio | 39137 | 809 | 27 |
634234 | 634234 | 2020-10-15 | Putnam | Tennessee | 47141 | 3948 | 51 |
634773 | 634773 | 2020-10-15 | Putnam | West Virginia | 54079 | 739 | 10 |
628770 | 628770 | 2020-10-14 | Putnam | Florida | 12107 | 2229 | 46 |
628901 | 628901 | 2020-10-14 | Putnam | Georgia | 13237 | 801 | 27 |
629071 | 629071 | 2020-10-14 | Putnam | Illinois | 17155 | 75 | 0 |
629163 | 629163 | 2020-10-14 | Putnam | Indiana | 18133 | 678 | 15 |
629977 | 629977 | 2020-10-14 | Putnam | Missouri | 29171 | 45 | 1 |
630276 | 630276 | 2020-10-14 | Putnam | New York | 36079 | 1705 | 63 |
630521 | 630521 | 2020-10-14 | Putnam | Ohio | 39137 | 784 | 27 |
630989 | 630989 | 2020-10-14 | Putnam | Tennessee | 47141 | 3899 | 51 |
631528 | 631528 | 2020-10-14 | Putnam | West Virginia | 54079 | 732 | 10 |
625527 | 625527 | 2020-10-13 | Putnam | Florida | 12107 | 2214 | 46 |
625658 | 625658 | 2020-10-13 | Putnam | Georgia | 13237 | 800 | 27 |
625828 | 625828 | 2020-10-13 | Putnam | Illinois | 17155 | 75 | 0 |
625920 | 625920 | 2020-10-13 | Putnam | Indiana | 18133 | 675 | 15 |
626733 | 626733 | 2020-10-13 | Putnam | Missouri | 29171 | 41 | 1 |
627032 | 627032 | 2020-10-13 | Putnam | New York | 36079 | 1698 | 63 |
627277 | 627277 | 2020-10-13 | Putnam | Ohio | 39137 | 770 | 27 |
627745 | 627745 | 2020-10-13 | Putnam | Tennessee | 47141 | 3833 | 51 |
628284 | 628284 | 2020-10-13 | Putnam | West Virginia | 54079 | 719 | 10 |
622284 | 622284 | 2020-10-12 | Putnam | Florida | 12107 | 2211 | 45 |
622415 | 622415 | 2020-10-12 | Putnam | Georgia | 13237 | 796 | 27 |
622586 | 622586 | 2020-10-12 | Putnam | Illinois | 17155 | 74 | 0 |
622678 | 622678 | 2020-10-12 | Putnam | Indiana | 18133 | 671 | 15 |
623491 | 623491 | 2020-10-12 | Putnam | Missouri | 29171 | 41 | 1 |
623790 | 623790 | 2020-10-12 | Putnam | New York | 36079 | 1689 | 63 |
624035 | 624035 | 2020-10-12 | Putnam | Ohio | 39137 | 756 | 27 |
624503 | 624503 | 2020-10-12 | Putnam | Tennessee | 47141 | 3815 | 50 |
625041 | 625041 | 2020-10-12 | Putnam | West Virginia | 54079 | 710 | 10 |
619041 | 619041 | 2020-10-11 | Putnam | Florida | 12107 | 2209 | 44 |
619172 | 619172 | 2020-10-11 | Putnam | Georgia | 13237 | 792 | 27 |
619342 | 619342 | 2020-10-11 | Putnam | Illinois | 17155 | 74 | 0 |
619434 | 619434 | 2020-10-11 | Putnam | Indiana | 18133 | 664 | 15 |
620248 | 620248 | 2020-10-11 | Putnam | Missouri | 29171 | 41 | 1 |
620547 | 620547 | 2020-10-11 | Putnam | New York | 36079 | 1683 | 63 |
620792 | 620792 | 2020-10-11 | Putnam | Ohio | 39137 | 744 | 27 |
621260 | 621260 | 2020-10-11 | Putnam | Tennessee | 47141 | 3761 | 50 |
621798 | 621798 | 2020-10-11 | Putnam | West Virginia | 54079 | 707 | 10 |
615799 | 615799 | 2020-10-10 | Putnam | Florida | 12107 | 2190 | 43 |
615930 | 615930 | 2020-10-10 | Putnam | Georgia | 13237 | 790 | 26 |
616100 | 616100 | 2020-10-10 | Putnam | Illinois | 17155 | 73 | 0 |
616192 | 616192 | 2020-10-10 | Putnam | Indiana | 18133 | 662 | 15 |
617006 | 617006 | 2020-10-10 | Putnam | Missouri | 29171 | 41 | 1 |
617305 | 617305 | 2020-10-10 | Putnam | New York | 36079 | 1675 | 63 |
617550 | 617550 | 2020-10-10 | Putnam | Ohio | 39137 | 737 | 27 |
618017 | 618017 | 2020-10-10 | Putnam | Tennessee | 47141 | 3725 | 50 |
618555 | 618555 | 2020-10-10 | Putnam | West Virginia | 54079 | 694 | 10 |
612558 | 612558 | 2020-10-09 | Putnam | Florida | 12107 | 2190 | 43 |
612689 | 612689 | 2020-10-09 | Putnam | Georgia | 13237 | 787 | 25 |
612859 | 612859 | 2020-10-09 | Putnam | Illinois | 17155 | 71 | 0 |
612951 | 612951 | 2020-10-09 | Putnam | Indiana | 18133 | 643 | 14 |
613765 | 613765 | 2020-10-09 | Putnam | Missouri | 29171 | 35 | 1 |
614063 | 614063 | 2020-10-09 | Putnam | New York | 36079 | 1673 | 63 |
614308 | 614308 | 2020-10-09 | Putnam | Ohio | 39137 | 721 | 27 |
614775 | 614775 | 2020-10-09 | Putnam | Tennessee | 47141 | 3714 | 50 |
615313 | 615313 | 2020-10-09 | Putnam | West Virginia | 54079 | 675 | 10 |
609316 | 609316 | 2020-10-08 | Putnam | Florida | 12107 | 2177 | 43 |
609447 | 609447 | 2020-10-08 | Putnam | Georgia | 13237 | 779 | 24 |
609617 | 609617 | 2020-10-08 | Putnam | Illinois | 17155 | 69 | 0 |
609709 | 609709 | 2020-10-08 | Putnam | Indiana | 18133 | 641 | 14 |
610523 | 610523 | 2020-10-08 | Putnam | Missouri | 29171 | 34 | 1 |
610822 | 610822 | 2020-10-08 | Putnam | New York | 36079 | 1669 | 63 |
611067 | 611067 | 2020-10-08 | Putnam | Ohio | 39137 | 709 | 27 |
611534 | 611534 | 2020-10-08 | Putnam | Tennessee | 47141 | 3686 | 50 |
612072 | 612072 | 2020-10-08 | Putnam | West Virginia | 54079 | 658 | 10 |
606073 | 606073 | 2020-10-07 | Putnam | Florida | 12107 | 2165 | 42 |
606204 | 606204 | 2020-10-07 | Putnam | Georgia | 13237 | 777 | 24 |
606374 | 606374 | 2020-10-07 | Putnam | Illinois | 17155 | 69 | 0 |
606466 | 606466 | 2020-10-07 | Putnam | Indiana | 18133 | 639 | 13 |
607281 | 607281 | 2020-10-07 | Putnam | Missouri | 29171 | 32 | 1 |
607580 | 607580 | 2020-10-07 | Putnam | New York | 36079 | 1661 | 63 |
607825 | 607825 | 2020-10-07 | Putnam | Ohio | 39137 | 694 | 27 |
608292 | 608292 | 2020-10-07 | Putnam | Tennessee | 47141 | 3639 | 49 |
608830 | 608830 | 2020-10-07 | Putnam | West Virginia | 54079 | 647 | 10 |
602831 | 602831 | 2020-10-06 | Putnam | Florida | 12107 | 2160 | 42 |
602962 | 602962 | 2020-10-06 | Putnam | Georgia | 13237 | 767 | 25 |
603132 | 603132 | 2020-10-06 | Putnam | Illinois | 17155 | 70 | 0 |
603224 | 603224 | 2020-10-06 | Putnam | Indiana | 18133 | 638 | 13 |
604038 | 604038 | 2020-10-06 | Putnam | Missouri | 29171 | 32 | 1 |
604337 | 604337 | 2020-10-06 | Putnam | New York | 36079 | 1656 | 63 |
604582 | 604582 | 2020-10-06 | Putnam | Ohio | 39137 | 682 | 27 |
605049 | 605049 | 2020-10-06 | Putnam | Tennessee | 47141 | 3588 | 49 |
605587 | 605587 | 2020-10-06 | Putnam | West Virginia | 54079 | 641 | 10 |
599588 | 599588 | 2020-10-05 | Putnam | Florida | 12107 | 2165 | 41 |
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);