ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
838 rows where deaths = 6 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Yates 193
- Genesee 169
- Livingston 97
- Chenango 83
- Otsego 80
- Delaware 45
- Cattaraugus 40
- Madison 25
- Broome 11
- Jefferson 9
- St. Lawrence 9
- Chautauqua 7
- Oswego 7
- Cayuga 5
- Chemung 4
- Essex 4
- Orleans 4
- Warren 4
- Allegany 3
- Erie 3
- Herkimer 3
- Schoharie 3
- Tioga 3
- Franklin 2
- Fulton 2
- Monroe 2
- Niagara 2
- Oneida 2
- Rensselaer 2
- Wayne 2
- …
state 1
- New York · 838 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
961270 | 961270 | 2021-01-24 | Schoharie | New York | 36095 | 975 | 6 |
958025 | 958025 | 2021-01-23 | Schoharie | New York | 36095 | 960 | 6 |
954779 | 954779 | 2021-01-22 | Schoharie | New York | 36095 | 943 | 6 |
854154 | 854154 | 2020-12-22 | Jefferson | New York | 36045 | 1379 | 6 |
850909 | 850909 | 2020-12-21 | Jefferson | New York | 36045 | 1344 | 6 |
847664 | 847664 | 2020-12-20 | Jefferson | New York | 36045 | 1302 | 6 |
844419 | 844419 | 2020-12-19 | Jefferson | New York | 36045 | 1265 | 6 |
841173 | 841173 | 2020-12-18 | Jefferson | New York | 36045 | 1216 | 6 |
837928 | 837928 | 2020-12-17 | Jefferson | New York | 36045 | 1161 | 6 |
834682 | 834682 | 2020-12-16 | Jefferson | New York | 36045 | 1121 | 6 |
831436 | 831436 | 2020-12-15 | Jefferson | New York | 36045 | 1085 | 6 |
831451 | 831451 | 2020-12-15 | Otsego | New York | 36077 | 915 | 6 |
831458 | 831458 | 2020-12-15 | Schuyler | New York | 36097 | 395 | 6 |
828189 | 828189 | 2020-12-14 | Jefferson | New York | 36045 | 1047 | 6 |
828204 | 828204 | 2020-12-14 | Otsego | New York | 36077 | 904 | 6 |
824932 | 824932 | 2020-12-13 | Cortland | New York | 36023 | 1478 | 6 |
824972 | 824972 | 2020-12-13 | Tompkins | New York | 36109 | 1556 | 6 |
815194 | 815194 | 2020-12-10 | Delaware | New York | 36025 | 477 | 6 |
811949 | 811949 | 2020-12-09 | Delaware | New York | 36025 | 470 | 6 |
808704 | 808704 | 2020-12-08 | Delaware | New York | 36025 | 454 | 6 |
805459 | 805459 | 2020-12-07 | Delaware | New York | 36025 | 446 | 6 |
802214 | 802214 | 2020-12-06 | Delaware | New York | 36025 | 432 | 6 |
798969 | 798969 | 2020-12-05 | Delaware | New York | 36025 | 420 | 6 |
795724 | 795724 | 2020-12-04 | Delaware | New York | 36025 | 401 | 6 |
792479 | 792479 | 2020-12-03 | Delaware | New York | 36025 | 393 | 6 |
789234 | 789234 | 2020-12-02 | Delaware | New York | 36025 | 385 | 6 |
785989 | 785989 | 2020-12-01 | Delaware | New York | 36025 | 375 | 6 |
782745 | 782745 | 2020-11-30 | Delaware | New York | 36025 | 363 | 6 |
779499 | 779499 | 2020-11-29 | Delaware | New York | 36025 | 359 | 6 |
779544 | 779544 | 2020-11-29 | Wyoming | New York | 36121 | 533 | 6 |
779545 | 779545 | 2020-11-29 | Yates | New York | 36123 | 262 | 6 |
776254 | 776254 | 2020-11-28 | Delaware | New York | 36025 | 346 | 6 |
776300 | 776300 | 2020-11-28 | Yates | New York | 36123 | 253 | 6 |
773009 | 773009 | 2020-11-27 | Delaware | New York | 36025 | 342 | 6 |
773033 | 773033 | 2020-11-27 | Oswego | New York | 36075 | 1436 | 6 |
773055 | 773055 | 2020-11-27 | Yates | New York | 36123 | 252 | 6 |
769764 | 769764 | 2020-11-26 | Delaware | New York | 36025 | 336 | 6 |
769788 | 769788 | 2020-11-26 | Oswego | New York | 36075 | 1405 | 6 |
769810 | 769810 | 2020-11-26 | Yates | New York | 36123 | 247 | 6 |
766518 | 766518 | 2020-11-25 | Delaware | New York | 36025 | 326 | 6 |
766522 | 766522 | 2020-11-25 | Franklin | New York | 36033 | 245 | 6 |
766542 | 766542 | 2020-11-25 | Oswego | New York | 36075 | 1359 | 6 |
766564 | 766564 | 2020-11-25 | Yates | New York | 36123 | 242 | 6 |
763267 | 763267 | 2020-11-24 | Chautauqua | New York | 36013 | 1414 | 6 |
763273 | 763273 | 2020-11-24 | Delaware | New York | 36025 | 319 | 6 |
763277 | 763277 | 2020-11-24 | Franklin | New York | 36033 | 243 | 6 |
763297 | 763297 | 2020-11-24 | Oswego | New York | 36075 | 1302 | 6 |
763319 | 763319 | 2020-11-24 | Yates | New York | 36123 | 242 | 6 |
760022 | 760022 | 2020-11-23 | Chautauqua | New York | 36013 | 1403 | 6 |
760028 | 760028 | 2020-11-23 | Delaware | New York | 36025 | 314 | 6 |
760052 | 760052 | 2020-11-23 | Oswego | New York | 36075 | 1273 | 6 |
760062 | 760062 | 2020-11-23 | St. Lawrence | New York | 36089 | 678 | 6 |
760074 | 760074 | 2020-11-23 | Yates | New York | 36123 | 239 | 6 |
756776 | 756776 | 2020-11-22 | Chautauqua | New York | 36013 | 1392 | 6 |
756782 | 756782 | 2020-11-22 | Delaware | New York | 36025 | 309 | 6 |
756806 | 756806 | 2020-11-22 | Oswego | New York | 36075 | 1187 | 6 |
756816 | 756816 | 2020-11-22 | St. Lawrence | New York | 36089 | 667 | 6 |
756828 | 756828 | 2020-11-22 | Yates | New York | 36123 | 228 | 6 |
753528 | 753528 | 2020-11-21 | Cayuga | New York | 36011 | 698 | 6 |
753529 | 753529 | 2020-11-21 | Chautauqua | New York | 36013 | 1362 | 6 |
753535 | 753535 | 2020-11-21 | Delaware | New York | 36025 | 300 | 6 |
753559 | 753559 | 2020-11-21 | Oswego | New York | 36075 | 1164 | 6 |
753569 | 753569 | 2020-11-21 | St. Lawrence | New York | 36089 | 658 | 6 |
753581 | 753581 | 2020-11-21 | Yates | New York | 36123 | 224 | 6 |
750282 | 750282 | 2020-11-20 | Cayuga | New York | 36011 | 681 | 6 |
750283 | 750283 | 2020-11-20 | Chautauqua | New York | 36013 | 1351 | 6 |
750289 | 750289 | 2020-11-20 | Delaware | New York | 36025 | 297 | 6 |
750323 | 750323 | 2020-11-20 | St. Lawrence | New York | 36089 | 649 | 6 |
750335 | 750335 | 2020-11-20 | Yates | New York | 36123 | 220 | 6 |
747036 | 747036 | 2020-11-19 | Cayuga | New York | 36011 | 676 | 6 |
747037 | 747037 | 2020-11-19 | Chautauqua | New York | 36013 | 1316 | 6 |
747043 | 747043 | 2020-11-19 | Delaware | New York | 36025 | 291 | 6 |
747049 | 747049 | 2020-11-19 | Genesee | New York | 36037 | 674 | 6 |
747077 | 747077 | 2020-11-19 | St. Lawrence | New York | 36089 | 627 | 6 |
747089 | 747089 | 2020-11-19 | Yates | New York | 36123 | 220 | 6 |
743790 | 743790 | 2020-11-18 | Cayuga | New York | 36011 | 664 | 6 |
743791 | 743791 | 2020-11-18 | Chautauqua | New York | 36013 | 1304 | 6 |
743797 | 743797 | 2020-11-18 | Delaware | New York | 36025 | 289 | 6 |
743803 | 743803 | 2020-11-18 | Genesee | New York | 36037 | 655 | 6 |
743831 | 743831 | 2020-11-18 | St. Lawrence | New York | 36089 | 610 | 6 |
743843 | 743843 | 2020-11-18 | Yates | New York | 36123 | 218 | 6 |
740543 | 740543 | 2020-11-17 | Cayuga | New York | 36011 | 654 | 6 |
740550 | 740550 | 2020-11-17 | Delaware | New York | 36025 | 281 | 6 |
740556 | 740556 | 2020-11-17 | Genesee | New York | 36037 | 635 | 6 |
740561 | 740561 | 2020-11-17 | Lewis | New York | 36049 | 253 | 6 |
740584 | 740584 | 2020-11-17 | St. Lawrence | New York | 36089 | 603 | 6 |
740596 | 740596 | 2020-11-17 | Yates | New York | 36123 | 217 | 6 |
737305 | 737305 | 2020-11-16 | Delaware | New York | 36025 | 280 | 6 |
737311 | 737311 | 2020-11-16 | Genesee | New York | 36037 | 615 | 6 |
737339 | 737339 | 2020-11-16 | St. Lawrence | New York | 36089 | 573 | 6 |
737351 | 737351 | 2020-11-16 | Yates | New York | 36123 | 209 | 6 |
734061 | 734061 | 2020-11-15 | Delaware | New York | 36025 | 277 | 6 |
734067 | 734067 | 2020-11-15 | Genesee | New York | 36037 | 603 | 6 |
734095 | 734095 | 2020-11-15 | St. Lawrence | New York | 36089 | 568 | 6 |
734107 | 734107 | 2020-11-15 | Yates | New York | 36123 | 206 | 6 |
730815 | 730815 | 2020-11-14 | Delaware | New York | 36025 | 276 | 6 |
730821 | 730821 | 2020-11-14 | Genesee | New York | 36037 | 597 | 6 |
730861 | 730861 | 2020-11-14 | Yates | New York | 36123 | 201 | 6 |
727571 | 727571 | 2020-11-13 | Delaware | New York | 36025 | 271 | 6 |
727577 | 727577 | 2020-11-13 | Genesee | New York | 36037 | 584 | 6 |
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);