ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where county = "Putnam" and deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Putnam · 221 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930851 | 930851 | 2021-01-15 | Putnam | Illinois | 17155 | 345 | 1 |
927606 | 927606 | 2021-01-14 | Putnam | Illinois | 17155 | 345 | 1 |
924360 | 924360 | 2021-01-13 | Putnam | Illinois | 17155 | 343 | 1 |
921115 | 921115 | 2021-01-12 | Putnam | Illinois | 17155 | 342 | 1 |
917870 | 917870 | 2021-01-11 | Putnam | Illinois | 17155 | 342 | 1 |
914625 | 914625 | 2021-01-10 | Putnam | Illinois | 17155 | 340 | 1 |
911380 | 911380 | 2021-01-09 | Putnam | Illinois | 17155 | 339 | 1 |
908135 | 908135 | 2021-01-08 | Putnam | Illinois | 17155 | 335 | 1 |
904889 | 904889 | 2021-01-07 | Putnam | Illinois | 17155 | 333 | 1 |
901644 | 901644 | 2021-01-06 | Putnam | Illinois | 17155 | 329 | 1 |
898399 | 898399 | 2021-01-05 | Putnam | Illinois | 17155 | 327 | 1 |
895154 | 895154 | 2021-01-04 | Putnam | Illinois | 17155 | 326 | 1 |
896060 | 896060 | 2021-01-04 | Putnam | Missouri | 29171 | 201 | 1 |
892813 | 892813 | 2021-01-03 | Putnam | Missouri | 29171 | 201 | 1 |
889567 | 889567 | 2021-01-02 | Putnam | Missouri | 29171 | 201 | 1 |
886321 | 886321 | 2021-01-01 | Putnam | Missouri | 29171 | 200 | 1 |
883076 | 883076 | 2020-12-31 | Putnam | Missouri | 29171 | 199 | 1 |
879831 | 879831 | 2020-12-30 | Putnam | Missouri | 29171 | 198 | 1 |
876586 | 876586 | 2020-12-29 | Putnam | Missouri | 29171 | 198 | 1 |
873341 | 873341 | 2020-12-28 | Putnam | Missouri | 29171 | 197 | 1 |
870096 | 870096 | 2020-12-27 | Putnam | Missouri | 29171 | 196 | 1 |
866851 | 866851 | 2020-12-26 | Putnam | Missouri | 29171 | 195 | 1 |
863606 | 863606 | 2020-12-25 | Putnam | Missouri | 29171 | 195 | 1 |
860361 | 860361 | 2020-12-24 | Putnam | Missouri | 29171 | 194 | 1 |
857116 | 857116 | 2020-12-23 | Putnam | Missouri | 29171 | 191 | 1 |
853871 | 853871 | 2020-12-22 | Putnam | Missouri | 29171 | 191 | 1 |
850626 | 850626 | 2020-12-21 | Putnam | Missouri | 29171 | 190 | 1 |
847381 | 847381 | 2020-12-20 | Putnam | Missouri | 29171 | 188 | 1 |
844135 | 844135 | 2020-12-19 | Putnam | Missouri | 29171 | 187 | 1 |
840890 | 840890 | 2020-12-18 | Putnam | Missouri | 29171 | 187 | 1 |
837645 | 837645 | 2020-12-17 | Putnam | Missouri | 29171 | 183 | 1 |
834399 | 834399 | 2020-12-16 | Putnam | Missouri | 29171 | 183 | 1 |
831152 | 831152 | 2020-12-15 | Putnam | Missouri | 29171 | 177 | 1 |
827906 | 827906 | 2020-12-14 | Putnam | Missouri | 29171 | 177 | 1 |
824659 | 824659 | 2020-12-13 | Putnam | Missouri | 29171 | 177 | 1 |
821413 | 821413 | 2020-12-12 | Putnam | Missouri | 29171 | 176 | 1 |
818167 | 818167 | 2020-12-11 | Putnam | Missouri | 29171 | 177 | 1 |
814921 | 814921 | 2020-12-10 | Putnam | Missouri | 29171 | 177 | 1 |
811676 | 811676 | 2020-12-09 | Putnam | Missouri | 29171 | 175 | 1 |
808431 | 808431 | 2020-12-08 | Putnam | Missouri | 29171 | 175 | 1 |
805186 | 805186 | 2020-12-07 | Putnam | Missouri | 29171 | 175 | 1 |
801941 | 801941 | 2020-12-06 | Putnam | Missouri | 29171 | 175 | 1 |
798696 | 798696 | 2020-12-05 | Putnam | Missouri | 29171 | 173 | 1 |
795451 | 795451 | 2020-12-04 | Putnam | Missouri | 29171 | 167 | 1 |
792206 | 792206 | 2020-12-03 | Putnam | Missouri | 29171 | 168 | 1 |
788961 | 788961 | 2020-12-02 | Putnam | Missouri | 29171 | 167 | 1 |
785716 | 785716 | 2020-12-01 | Putnam | Missouri | 29171 | 163 | 1 |
782472 | 782472 | 2020-11-30 | Putnam | Missouri | 29171 | 162 | 1 |
779226 | 779226 | 2020-11-29 | Putnam | Missouri | 29171 | 157 | 1 |
775981 | 775981 | 2020-11-28 | Putnam | Missouri | 29171 | 148 | 1 |
772736 | 772736 | 2020-11-27 | Putnam | Missouri | 29171 | 148 | 1 |
769491 | 769491 | 2020-11-26 | Putnam | Missouri | 29171 | 143 | 1 |
766245 | 766245 | 2020-11-25 | Putnam | Missouri | 29171 | 137 | 1 |
763000 | 763000 | 2020-11-24 | Putnam | Missouri | 29171 | 126 | 1 |
759755 | 759755 | 2020-11-23 | Putnam | Missouri | 29171 | 125 | 1 |
756508 | 756508 | 2020-11-22 | Putnam | Missouri | 29171 | 116 | 1 |
753262 | 753262 | 2020-11-21 | Putnam | Missouri | 29171 | 110 | 1 |
750016 | 750016 | 2020-11-20 | Putnam | Missouri | 29171 | 109 | 1 |
746770 | 746770 | 2020-11-19 | Putnam | Missouri | 29171 | 106 | 1 |
743523 | 743523 | 2020-11-18 | Putnam | Missouri | 29171 | 103 | 1 |
740276 | 740276 | 2020-11-17 | Putnam | Missouri | 29171 | 101 | 1 |
737032 | 737032 | 2020-11-16 | Putnam | Missouri | 29171 | 96 | 1 |
733786 | 733786 | 2020-11-15 | Putnam | Missouri | 29171 | 96 | 1 |
730541 | 730541 | 2020-11-14 | Putnam | Missouri | 29171 | 96 | 1 |
727298 | 727298 | 2020-11-13 | Putnam | Missouri | 29171 | 88 | 1 |
724055 | 724055 | 2020-11-12 | Putnam | Missouri | 29171 | 83 | 1 |
720812 | 720812 | 2020-11-11 | Putnam | Missouri | 29171 | 78 | 1 |
717569 | 717569 | 2020-11-10 | Putnam | Missouri | 29171 | 74 | 1 |
714325 | 714325 | 2020-11-09 | Putnam | Missouri | 29171 | 67 | 1 |
711081 | 711081 | 2020-11-08 | Putnam | Missouri | 29171 | 67 | 1 |
707837 | 707837 | 2020-11-07 | Putnam | Missouri | 29171 | 67 | 1 |
704594 | 704594 | 2020-11-06 | Putnam | Missouri | 29171 | 66 | 1 |
701352 | 701352 | 2020-11-05 | Putnam | Missouri | 29171 | 65 | 1 |
698108 | 698108 | 2020-11-04 | Putnam | Missouri | 29171 | 65 | 1 |
694865 | 694865 | 2020-11-03 | Putnam | Missouri | 29171 | 61 | 1 |
691623 | 691623 | 2020-11-02 | Putnam | Missouri | 29171 | 61 | 1 |
688378 | 688378 | 2020-11-01 | Putnam | Missouri | 29171 | 61 | 1 |
685134 | 685134 | 2020-10-31 | Putnam | Missouri | 29171 | 60 | 1 |
681891 | 681891 | 2020-10-30 | Putnam | Missouri | 29171 | 60 | 1 |
678647 | 678647 | 2020-10-29 | Putnam | Missouri | 29171 | 59 | 1 |
675405 | 675405 | 2020-10-28 | Putnam | Missouri | 29171 | 57 | 1 |
672162 | 672162 | 2020-10-27 | Putnam | Missouri | 29171 | 57 | 1 |
668920 | 668920 | 2020-10-26 | Putnam | Missouri | 29171 | 56 | 1 |
665676 | 665676 | 2020-10-25 | Putnam | Missouri | 29171 | 56 | 1 |
662431 | 662431 | 2020-10-24 | Putnam | Missouri | 29171 | 53 | 1 |
659187 | 659187 | 2020-10-23 | Putnam | Missouri | 29171 | 52 | 1 |
655942 | 655942 | 2020-10-22 | Putnam | Missouri | 29171 | 49 | 1 |
652697 | 652697 | 2020-10-21 | Putnam | Missouri | 29171 | 48 | 1 |
649452 | 649452 | 2020-10-20 | Putnam | Missouri | 29171 | 48 | 1 |
646208 | 646208 | 2020-10-19 | Putnam | Missouri | 29171 | 48 | 1 |
642962 | 642962 | 2020-10-18 | Putnam | Missouri | 29171 | 48 | 1 |
639714 | 639714 | 2020-10-17 | Putnam | Missouri | 29171 | 48 | 1 |
636468 | 636468 | 2020-10-16 | Putnam | Missouri | 29171 | 47 | 1 |
633222 | 633222 | 2020-10-15 | Putnam | Missouri | 29171 | 46 | 1 |
629977 | 629977 | 2020-10-14 | Putnam | Missouri | 29171 | 45 | 1 |
626733 | 626733 | 2020-10-13 | Putnam | Missouri | 29171 | 41 | 1 |
623491 | 623491 | 2020-10-12 | Putnam | Missouri | 29171 | 41 | 1 |
620248 | 620248 | 2020-10-11 | Putnam | Missouri | 29171 | 41 | 1 |
617006 | 617006 | 2020-10-10 | Putnam | Missouri | 29171 | 41 | 1 |
613765 | 613765 | 2020-10-09 | Putnam | Missouri | 29171 | 35 | 1 |
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);