ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where deaths = 127 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 21
county 21
- Warren 21
- Madison 20
- Montgomery 20
- Sullivan 6
- Genesee 3
- Oneida 3
- St. Lawrence 3
- Steuben 3
- Albany 2
- Columbia 2
- Oswego 2
- Saratoga 2
- Wayne 2
- Cattaraugus 1
- Cayuga 1
- Chautauqua 1
- Chemung 1
- Dutchess 1
- Niagara 1
- Rensselaer 1
- Schenectady 1
state 1
- New York · 97 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501452 | 2501452 | 2022-05-13 | Madison | New York | 36053 | 14319 | 127 |
2498194 | 2498194 | 2022-05-12 | Madison | New York | 36053 | 14319 | 127 |
2494936 | 2494936 | 2022-05-11 | Madison | New York | 36053 | 14290 | 127 |
2491678 | 2491678 | 2022-05-10 | Madison | New York | 36053 | 14264 | 127 |
2488420 | 2488420 | 2022-05-09 | Madison | New York | 36053 | 14245 | 127 |
2485163 | 2485163 | 2022-05-08 | Madison | New York | 36053 | 14234 | 127 |
2481905 | 2481905 | 2022-05-07 | Madison | New York | 36053 | 14213 | 127 |
2478647 | 2478647 | 2022-05-06 | Madison | New York | 36053 | 14175 | 127 |
2475389 | 2475389 | 2022-05-05 | Madison | New York | 36053 | 14148 | 127 |
2472132 | 2472132 | 2022-05-04 | Madison | New York | 36053 | 14103 | 127 |
2468876 | 2468876 | 2022-05-03 | Madison | New York | 36053 | 14067 | 127 |
2465620 | 2465620 | 2022-05-02 | Madison | New York | 36053 | 14039 | 127 |
2462365 | 2462365 | 2022-05-01 | Madison | New York | 36053 | 14033 | 127 |
2459109 | 2459109 | 2022-04-30 | Madison | New York | 36053 | 14008 | 127 |
2455853 | 2455853 | 2022-04-29 | Madison | New York | 36053 | 13978 | 127 |
2452597 | 2452597 | 2022-04-28 | Madison | New York | 36053 | 13950 | 127 |
2452625 | 2452625 | 2022-04-28 | Warren | New York | 36113 | 14138 | 127 |
2449341 | 2449341 | 2022-04-27 | Madison | New York | 36053 | 13908 | 127 |
2449369 | 2449369 | 2022-04-27 | Warren | New York | 36113 | 14094 | 127 |
2446084 | 2446084 | 2022-04-26 | Madison | New York | 36053 | 13876 | 127 |
2446112 | 2446112 | 2022-04-26 | Warren | New York | 36113 | 14052 | 127 |
2442829 | 2442829 | 2022-04-25 | Madison | New York | 36053 | 13844 | 127 |
2442857 | 2442857 | 2022-04-25 | Warren | New York | 36113 | 14034 | 127 |
2439573 | 2439573 | 2022-04-24 | Madison | New York | 36053 | 13822 | 127 |
2439601 | 2439601 | 2022-04-24 | Warren | New York | 36113 | 14010 | 127 |
2436345 | 2436345 | 2022-04-23 | Warren | New York | 36113 | 13980 | 127 |
2433089 | 2433089 | 2022-04-22 | Warren | New York | 36113 | 13956 | 127 |
2429833 | 2429833 | 2022-04-21 | Warren | New York | 36113 | 13928 | 127 |
2426577 | 2426577 | 2022-04-20 | Warren | New York | 36113 | 13915 | 127 |
2423321 | 2423321 | 2022-04-19 | Warren | New York | 36113 | 13896 | 127 |
2420064 | 2420064 | 2022-04-18 | Warren | New York | 36113 | 13884 | 127 |
2416809 | 2416809 | 2022-04-17 | Warren | New York | 36113 | 13875 | 127 |
2413553 | 2413553 | 2022-04-16 | Warren | New York | 36113 | 13849 | 127 |
2410297 | 2410297 | 2022-04-15 | Warren | New York | 36113 | 13835 | 127 |
2407041 | 2407041 | 2022-04-14 | Warren | New York | 36113 | 13805 | 127 |
2403785 | 2403785 | 2022-04-13 | Warren | New York | 36113 | 13762 | 127 |
2400530 | 2400530 | 2022-04-12 | Warren | New York | 36113 | 13736 | 127 |
2397275 | 2397275 | 2022-04-11 | Warren | New York | 36113 | 13722 | 127 |
2394020 | 2394020 | 2022-04-10 | Warren | New York | 36113 | 13715 | 127 |
2390764 | 2390764 | 2022-04-09 | Warren | New York | 36113 | 13705 | 127 |
2387508 | 2387508 | 2022-04-08 | Warren | New York | 36113 | 13682 | 127 |
2286658 | 2286658 | 2022-03-08 | Sullivan | New York | 36105 | 18218 | 127 |
2283406 | 2283406 | 2022-03-07 | Sullivan | New York | 36105 | 18216 | 127 |
2280154 | 2280154 | 2022-03-06 | Sullivan | New York | 36105 | 18213 | 127 |
2276901 | 2276901 | 2022-03-05 | Sullivan | New York | 36105 | 18210 | 127 |
2273648 | 2273648 | 2022-03-04 | Sullivan | New York | 36105 | 18194 | 127 |
2270395 | 2270395 | 2022-03-03 | Sullivan | New York | 36105 | 18194 | 127 |
2130495 | 2130495 | 2022-01-19 | Cayuga | New York | 36011 | 14029 | 127 |
2117490 | 2117490 | 2022-01-15 | Columbia | New York | 36021 | 8464 | 127 |
2114239 | 2114239 | 2022-01-14 | Columbia | New York | 36021 | 8392 | 127 |
2075265 | 2075265 | 2022-01-02 | Wayne | New York | 36117 | 12530 | 127 |
2072014 | 2072014 | 2022-01-01 | Wayne | New York | 36117 | 12466 | 127 |
1925726 | 1925726 | 2021-11-17 | Oswego | New York | 36075 | 13247 | 127 |
1922477 | 1922477 | 2021-11-16 | Oswego | New York | 36075 | 13149 | 127 |
1876950 | 1876950 | 2021-11-02 | Cattaraugus | New York | 36009 | 8268 | 127 |
1844500 | 1844500 | 2021-10-23 | St. Lawrence | New York | 36089 | 10664 | 127 |
1841250 | 1841250 | 2021-10-22 | St. Lawrence | New York | 36089 | 10598 | 127 |
1838001 | 1838001 | 2021-10-21 | St. Lawrence | New York | 36089 | 10524 | 127 |
1737253 | 1737253 | 2021-09-20 | Genesee | New York | 36037 | 6028 | 127 |
1734003 | 1734003 | 2021-09-19 | Genesee | New York | 36037 | 6017 | 127 |
1730753 | 1730753 | 2021-09-18 | Genesee | New York | 36037 | 5983 | 127 |
1487160 | 1487160 | 2021-07-05 | Montgomery | New York | 36057 | 4259 | 127 |
1483914 | 1483914 | 2021-07-04 | Montgomery | New York | 36057 | 4259 | 127 |
1480668 | 1480668 | 2021-07-03 | Montgomery | New York | 36057 | 4258 | 127 |
1477421 | 1477421 | 2021-07-02 | Montgomery | New York | 36057 | 4257 | 127 |
1474175 | 1474175 | 2021-07-01 | Montgomery | New York | 36057 | 4257 | 127 |
1470929 | 1470929 | 2021-06-30 | Montgomery | New York | 36057 | 4257 | 127 |
1467684 | 1467684 | 2021-06-29 | Montgomery | New York | 36057 | 4256 | 127 |
1464439 | 1464439 | 2021-06-28 | Montgomery | New York | 36057 | 4256 | 127 |
1461194 | 1461194 | 2021-06-27 | Montgomery | New York | 36057 | 4255 | 127 |
1457949 | 1457949 | 2021-06-26 | Montgomery | New York | 36057 | 4254 | 127 |
1454704 | 1454704 | 2021-06-25 | Montgomery | New York | 36057 | 4254 | 127 |
1451459 | 1451459 | 2021-06-24 | Montgomery | New York | 36057 | 4254 | 127 |
1448213 | 1448213 | 2021-06-23 | Montgomery | New York | 36057 | 4254 | 127 |
1444968 | 1444968 | 2021-06-22 | Montgomery | New York | 36057 | 4254 | 127 |
1441723 | 1441723 | 2021-06-21 | Montgomery | New York | 36057 | 4254 | 127 |
1438478 | 1438478 | 2021-06-20 | Montgomery | New York | 36057 | 4254 | 127 |
1435231 | 1435231 | 2021-06-19 | Montgomery | New York | 36057 | 4254 | 127 |
1431984 | 1431984 | 2021-06-18 | Montgomery | New York | 36057 | 4254 | 127 |
1428738 | 1428738 | 2021-06-17 | Montgomery | New York | 36057 | 4254 | 127 |
1425493 | 1425493 | 2021-06-16 | Montgomery | New York | 36057 | 4254 | 127 |
1104043 | 1104043 | 2021-03-09 | Chautauqua | New York | 36013 | 7476 | 127 |
1045650 | 1045650 | 2021-02-19 | Rensselaer | New York | 36083 | 8733 | 127 |
1032638 | 1032638 | 2021-02-15 | Chemung | New York | 36015 | 6296 | 127 |
1003462 | 1003462 | 2021-02-06 | Saratoga | New York | 36091 | 10942 | 127 |
1000216 | 1000216 | 2021-02-05 | Saratoga | New York | 36091 | 10869 | 127 |
945041 | 945041 | 2021-01-19 | Schenectady | New York | 36093 | 8660 | 127 |
919084 | 919084 | 2021-01-11 | Steuben | New York | 36101 | 4206 | 127 |
915839 | 915839 | 2021-01-10 | Steuben | New York | 36101 | 4150 | 127 |
912594 | 912594 | 2021-01-09 | Steuben | New York | 36101 | 4079 | 127 |
815212 | 815212 | 2020-12-10 | Niagara | New York | 36063 | 5378 | 127 |
669211 | 669211 | 2020-10-26 | Oneida | New York | 36065 | 2686 | 127 |
665967 | 665967 | 2020-10-25 | Oneida | New York | 36065 | 2681 | 127 |
662722 | 662722 | 2020-10-24 | Oneida | New York | 36065 | 2670 | 127 |
659448 | 659448 | 2020-10-23 | Albany | New York | 36001 | 3516 | 127 |
152933 | 152933 | 2020-05-17 | Dutchess | New York | 36027 | 3543 | 127 |
149911 | 149911 | 2020-05-16 | Albany | New York | 36001 | 1572 | 127 |
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);