ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where deaths = 48 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
- Schenectady 21
- Wyoming 19
- Columbia 12
- Delaware 12
- Essex 9
- Sullivan 9
- Clinton 8
- Lewis 7
- Tompkins 7
- Warren 6
- Otsego 4
- Saratoga 4
- Tioga 4
- St. Lawrence 3
- Washington 3
- Livingston 2
- Seneca 2
- Allegany 1
- Broome 1
- Chenango 1
- Cortland 1
- Fulton 1
- Genesee 1
- Herkimer 1
- Jefferson 1
- Monroe 1
- Nassau 1
- Niagara 1
- Rensselaer 1
- Wayne 1
state 1
- New York · 145 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2315902 | 2315902 | 2022-03-17 | Lewis | New York | 36049 | 6118 | 48 |
2312649 | 2312649 | 2022-03-16 | Lewis | New York | 36049 | 6115 | 48 |
2309396 | 2309396 | 2022-03-15 | Lewis | New York | 36049 | 6114 | 48 |
2306143 | 2306143 | 2022-03-14 | Lewis | New York | 36049 | 6113 | 48 |
2302892 | 2302892 | 2022-03-13 | Lewis | New York | 36049 | 6113 | 48 |
2299640 | 2299640 | 2022-03-12 | Lewis | New York | 36049 | 6113 | 48 |
2296388 | 2296388 | 2022-03-11 | Lewis | New York | 36049 | 6112 | 48 |
2091483 | 2091483 | 2022-01-07 | Essex | New York | 36031 | 4070 | 48 |
2088232 | 2088232 | 2022-01-06 | Essex | New York | 36031 | 3995 | 48 |
2084980 | 2084980 | 2022-01-05 | Essex | New York | 36031 | 3943 | 48 |
2081728 | 2081728 | 2022-01-04 | Essex | New York | 36031 | 3887 | 48 |
2078476 | 2078476 | 2022-01-03 | Essex | New York | 36031 | 3857 | 48 |
2075225 | 2075225 | 2022-01-02 | Essex | New York | 36031 | 3833 | 48 |
2071974 | 2071974 | 2022-01-01 | Essex | New York | 36031 | 3767 | 48 |
2068723 | 2068723 | 2021-12-31 | Essex | New York | 36031 | 3702 | 48 |
2065472 | 2065472 | 2021-12-30 | Essex | New York | 36031 | 3632 | 48 |
1987458 | 1987458 | 2021-12-06 | Clinton | New York | 36019 | 8441 | 48 |
1984208 | 1984208 | 2021-12-05 | Clinton | New York | 36019 | 8408 | 48 |
1980958 | 1980958 | 2021-12-04 | Clinton | New York | 36019 | 8349 | 48 |
1977708 | 1977708 | 2021-12-03 | Clinton | New York | 36019 | 8279 | 48 |
1974458 | 1974458 | 2021-12-02 | Clinton | New York | 36019 | 8218 | 48 |
1971209 | 1971209 | 2021-12-01 | Clinton | New York | 36019 | 8146 | 48 |
1967959 | 1967959 | 2021-11-30 | Clinton | New York | 36019 | 8099 | 48 |
1964708 | 1964708 | 2021-11-29 | Clinton | New York | 36019 | 8063 | 48 |
1876958 | 1876958 | 2021-11-02 | Delaware | New York | 36025 | 3709 | 48 |
1873709 | 1873709 | 2021-11-01 | Delaware | New York | 36025 | 3701 | 48 |
1870460 | 1870460 | 2021-10-31 | Delaware | New York | 36025 | 3696 | 48 |
1867211 | 1867211 | 2021-10-30 | Delaware | New York | 36025 | 3671 | 48 |
1863962 | 1863962 | 2021-10-29 | Delaware | New York | 36025 | 3662 | 48 |
1860713 | 1860713 | 2021-10-28 | Delaware | New York | 36025 | 3641 | 48 |
1857464 | 1857464 | 2021-10-27 | Delaware | New York | 36025 | 3623 | 48 |
1854215 | 1854215 | 2021-10-26 | Delaware | New York | 36025 | 3604 | 48 |
1850966 | 1850966 | 2021-10-25 | Delaware | New York | 36025 | 3603 | 48 |
1847716 | 1847716 | 2021-10-24 | Delaware | New York | 36025 | 3591 | 48 |
1844466 | 1844466 | 2021-10-23 | Delaware | New York | 36025 | 3585 | 48 |
1841216 | 1841216 | 2021-10-22 | Delaware | New York | 36025 | 3574 | 48 |
1659307 | 1659307 | 2021-08-27 | Otsego | New York | 36077 | 3778 | 48 |
1656058 | 1656058 | 2021-08-26 | Otsego | New York | 36077 | 3744 | 48 |
1652811 | 1652811 | 2021-08-25 | Otsego | New York | 36077 | 3738 | 48 |
1649563 | 1649563 | 2021-08-24 | Otsego | New York | 36077 | 3731 | 48 |
1159281 | 1159281 | 2021-03-26 | Tompkins | New York | 36109 | 3807 | 48 |
1156034 | 1156034 | 2021-03-25 | Tompkins | New York | 36109 | 3777 | 48 |
1152787 | 1152787 | 2021-03-24 | Tompkins | New York | 36109 | 3757 | 48 |
1149540 | 1149540 | 2021-03-23 | Tompkins | New York | 36109 | 3742 | 48 |
1146293 | 1146293 | 2021-03-22 | Tompkins | New York | 36109 | 3736 | 48 |
1143046 | 1143046 | 2021-03-21 | Tompkins | New York | 36109 | 3730 | 48 |
1139799 | 1139799 | 2021-03-20 | Tompkins | New York | 36109 | 3718 | 48 |
1061900 | 1061900 | 2021-02-24 | Wyoming | New York | 36121 | 2778 | 48 |
1058654 | 1058654 | 2021-02-23 | Wyoming | New York | 36121 | 2770 | 48 |
1055408 | 1055408 | 2021-02-22 | Wyoming | New York | 36121 | 2765 | 48 |
1052162 | 1052162 | 2021-02-21 | Wyoming | New York | 36121 | 2756 | 48 |
1048915 | 1048915 | 2021-02-20 | Wyoming | New York | 36121 | 2748 | 48 |
1045668 | 1045668 | 2021-02-19 | Wyoming | New York | 36121 | 2732 | 48 |
1042423 | 1042423 | 2021-02-18 | Wyoming | New York | 36121 | 2719 | 48 |
1039178 | 1039178 | 2021-02-17 | Wyoming | New York | 36121 | 2716 | 48 |
1035933 | 1035933 | 2021-02-16 | Wyoming | New York | 36121 | 2712 | 48 |
1032688 | 1032688 | 2021-02-15 | Wyoming | New York | 36121 | 2700 | 48 |
1029442 | 1029442 | 2021-02-14 | Wyoming | New York | 36121 | 2689 | 48 |
1026192 | 1026192 | 2021-02-13 | Washington | New York | 36115 | 2147 | 48 |
1026195 | 1026195 | 2021-02-13 | Wyoming | New York | 36121 | 2681 | 48 |
1022947 | 1022947 | 2021-02-12 | Washington | New York | 36115 | 2131 | 48 |
1022950 | 1022950 | 2021-02-12 | Wyoming | New York | 36121 | 2662 | 48 |
1019702 | 1019702 | 2021-02-11 | Washington | New York | 36115 | 2110 | 48 |
1019705 | 1019705 | 2021-02-11 | Wyoming | New York | 36121 | 2643 | 48 |
1016460 | 1016460 | 2021-02-10 | Wyoming | New York | 36121 | 2626 | 48 |
1013215 | 1013215 | 2021-02-09 | Wyoming | New York | 36121 | 2610 | 48 |
1009970 | 1009970 | 2021-02-08 | Wyoming | New York | 36121 | 2599 | 48 |
1006724 | 1006724 | 2021-02-07 | Wyoming | New York | 36121 | 2583 | 48 |
1003474 | 1003474 | 2021-02-06 | Warren | New York | 36113 | 2582 | 48 |
1003478 | 1003478 | 2021-02-06 | Wyoming | New York | 36121 | 2574 | 48 |
1000228 | 1000228 | 2021-02-05 | Warren | New York | 36113 | 2554 | 48 |
996982 | 996982 | 2021-02-04 | Warren | New York | 36113 | 2534 | 48 |
993736 | 993736 | 2021-02-03 | Warren | New York | 36113 | 2494 | 48 |
990459 | 990459 | 2021-02-02 | Jefferson | New York | 36045 | 4021 | 48 |
990461 | 990461 | 2021-02-02 | Livingston | New York | 36051 | 3042 | 48 |
990490 | 990490 | 2021-02-02 | Warren | New York | 36113 | 2466 | 48 |
987215 | 987215 | 2021-02-01 | Livingston | New York | 36051 | 3031 | 48 |
987244 | 987244 | 2021-02-01 | Warren | New York | 36113 | 2461 | 48 |
971006 | 971006 | 2021-01-27 | Seneca | New York | 36099 | 1346 | 48 |
967761 | 967761 | 2021-01-26 | Seneca | New York | 36099 | 1338 | 48 |
964480 | 964480 | 2021-01-25 | Chenango | New York | 36017 | 1943 | 48 |
938525 | 938525 | 2021-01-17 | Fulton | New York | 36035 | 2039 | 48 |
938557 | 938557 | 2021-01-17 | Sullivan | New York | 36105 | 3765 | 48 |
935284 | 935284 | 2021-01-16 | Herkimer | New York | 36043 | 3485 | 48 |
935312 | 935312 | 2021-01-16 | Sullivan | New York | 36105 | 3751 | 48 |
932067 | 932067 | 2021-01-15 | Sullivan | New York | 36105 | 3713 | 48 |
928822 | 928822 | 2021-01-14 | Sullivan | New York | 36105 | 3654 | 48 |
925577 | 925577 | 2021-01-13 | Sullivan | New York | 36105 | 3614 | 48 |
925583 | 925583 | 2021-01-13 | Wayne | New York | 36117 | 3395 | 48 |
922331 | 922331 | 2021-01-12 | Sullivan | New York | 36105 | 3570 | 48 |
919048 | 919048 | 2021-01-11 | Cortland | New York | 36023 | 2455 | 48 |
919086 | 919086 | 2021-01-11 | Sullivan | New York | 36105 | 3519 | 48 |
915841 | 915841 | 2021-01-10 | Sullivan | New York | 36105 | 3488 | 48 |
912596 | 912596 | 2021-01-09 | Sullivan | New York | 36105 | 3454 | 48 |
909348 | 909348 | 2021-01-08 | St. Lawrence | New York | 36089 | 2803 | 48 |
906103 | 906103 | 2021-01-07 | St. Lawrence | New York | 36089 | 2699 | 48 |
902852 | 902852 | 2021-01-06 | Saratoga | New York | 36091 | 6753 | 48 |
902857 | 902857 | 2021-01-06 | St. Lawrence | New York | 36089 | 2594 | 48 |
899607 | 899607 | 2021-01-05 | Saratoga | New York | 36091 | 6543 | 48 |
896362 | 896362 | 2021-01-04 | Saratoga | New York | 36091 | 6360 | 48 |
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);