ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where deaths = 117 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501462 | 2501462 | 2022-05-13 | Orleans | New York | 36073 | 9116 | 117 |
2472131 | 2472131 | 2022-05-04 | Livingston | New York | 36051 | 12118 | 117 |
2468875 | 2468875 | 2022-05-03 | Livingston | New York | 36051 | 12098 | 117 |
2426535 | 2426535 | 2022-04-20 | Cortland | New York | 36023 | 10946 | 117 |
2283365 | 2283365 | 2022-03-07 | Chenango | New York | 36017 | 9169 | 117 |
2280113 | 2280113 | 2022-03-06 | Chenango | New York | 36017 | 9166 | 117 |
2276860 | 2276860 | 2022-03-05 | Chenango | New York | 36017 | 9162 | 117 |
2273607 | 2273607 | 2022-03-04 | Chenango | New York | 36017 | 9152 | 117 |
2270354 | 2270354 | 2022-03-03 | Chenango | New York | 36017 | 9152 | 117 |
2267102 | 2267102 | 2022-03-02 | Chenango | New York | 36017 | 9143 | 117 |
2263850 | 2263850 | 2022-03-01 | Chenango | New York | 36017 | 9138 | 117 |
2260599 | 2260599 | 2022-02-28 | Chenango | New York | 36017 | 9134 | 117 |
2257348 | 2257348 | 2022-02-27 | Chenango | New York | 36017 | 9131 | 117 |
2254097 | 2254097 | 2022-02-26 | Chenango | New York | 36017 | 9127 | 117 |
2250846 | 2250846 | 2022-02-25 | Chenango | New York | 36017 | 9115 | 117 |
2247595 | 2247595 | 2022-02-24 | Chenango | New York | 36017 | 9105 | 117 |
2244344 | 2244344 | 2022-02-23 | Chenango | New York | 36017 | 9090 | 117 |
2241093 | 2241093 | 2022-02-22 | Chenango | New York | 36017 | 9081 | 117 |
2237842 | 2237842 | 2022-02-21 | Chenango | New York | 36017 | 9076 | 117 |
2234591 | 2234591 | 2022-02-20 | Chenango | New York | 36017 | 9065 | 117 |
2231340 | 2231340 | 2022-02-19 | Chenango | New York | 36017 | 9057 | 117 |
2228089 | 2228089 | 2022-02-18 | Chenango | New York | 36017 | 9045 | 117 |
2224838 | 2224838 | 2022-02-17 | Chenango | New York | 36017 | 9027 | 117 |
2224849 | 2224849 | 2022-02-17 | Greene | New York | 36039 | 8370 | 117 |
2221587 | 2221587 | 2022-02-16 | Chenango | New York | 36017 | 9011 | 117 |
2221598 | 2221598 | 2022-02-16 | Greene | New York | 36039 | 8363 | 117 |
2218347 | 2218347 | 2022-02-15 | Greene | New York | 36039 | 8354 | 117 |
2215096 | 2215096 | 2022-02-14 | Greene | New York | 36039 | 8344 | 117 |
2215130 | 2215130 | 2022-02-14 | Warren | New York | 36113 | 13042 | 117 |
2211845 | 2211845 | 2022-02-13 | Greene | New York | 36039 | 8338 | 117 |
2211879 | 2211879 | 2022-02-13 | Warren | New York | 36113 | 13026 | 117 |
2208592 | 2208592 | 2022-02-12 | Greene | New York | 36039 | 8323 | 117 |
2208626 | 2208626 | 2022-02-12 | Warren | New York | 36113 | 13010 | 117 |
2205339 | 2205339 | 2022-02-11 | Greene | New York | 36039 | 8315 | 117 |
2205373 | 2205373 | 2022-02-11 | Warren | New York | 36113 | 12985 | 117 |
2202120 | 2202120 | 2022-02-10 | Warren | New York | 36113 | 12954 | 117 |
2198866 | 2198866 | 2022-02-09 | Warren | New York | 36113 | 12908 | 117 |
2195612 | 2195612 | 2022-02-08 | Warren | New York | 36113 | 12886 | 117 |
2192358 | 2192358 | 2022-02-07 | Warren | New York | 36113 | 12873 | 117 |
2189104 | 2189104 | 2022-02-06 | Warren | New York | 36113 | 12847 | 117 |
2185851 | 2185851 | 2022-02-05 | Warren | New York | 36113 | 12831 | 117 |
2182599 | 2182599 | 2022-02-04 | Warren | New York | 36113 | 12788 | 117 |
2172828 | 2172828 | 2022-02-01 | Putnam | New York | 36079 | 22846 | 117 |
2169575 | 2169575 | 2022-01-31 | Putnam | New York | 36079 | 22828 | 117 |
2166320 | 2166320 | 2022-01-30 | Putnam | New York | 36079 | 22817 | 117 |
2163065 | 2163065 | 2022-01-29 | Putnam | New York | 36079 | 22781 | 117 |
2159810 | 2159810 | 2022-01-28 | Putnam | New York | 36079 | 22726 | 117 |
2159821 | 2159821 | 2022-01-28 | Sullivan | New York | 36105 | 17494 | 117 |
2156555 | 2156555 | 2022-01-27 | Putnam | New York | 36079 | 22661 | 117 |
2081738 | 2081738 | 2022-01-04 | Madison | New York | 36053 | 9430 | 117 |
2078486 | 2078486 | 2022-01-03 | Madison | New York | 36053 | 9357 | 117 |
2075235 | 2075235 | 2022-01-02 | Madison | New York | 36053 | 9306 | 117 |
2071984 | 2071984 | 2022-01-01 | Madison | New York | 36053 | 9237 | 117 |
2019962 | 2019962 | 2021-12-16 | Cayuga | New York | 36011 | 10579 | 117 |
2010215 | 2010215 | 2021-12-13 | Columbia | New York | 36021 | 6203 | 117 |
2000469 | 2000469 | 2021-12-10 | Fulton | New York | 36035 | 8313 | 117 |
1997219 | 1997219 | 2021-12-09 | Fulton | New York | 36035 | 8258 | 117 |
1945225 | 1945225 | 2021-11-23 | Ontario | New York | 36069 | 11292 | 117 |
1938693 | 1938693 | 2021-11-21 | Allegany | New York | 36003 | 5729 | 117 |
1863986 | 1863986 | 2021-10-29 | Oswego | New York | 36075 | 12108 | 117 |
1753501 | 1753501 | 2021-09-25 | Herkimer | New York | 36043 | 6078 | 117 |
1750253 | 1750253 | 2021-09-24 | Herkimer | New York | 36043 | 6059 | 117 |
1747003 | 1747003 | 2021-09-23 | Herkimer | New York | 36043 | 6030 | 117 |
1743754 | 1743754 | 2021-09-22 | Herkimer | New York | 36043 | 6013 | 117 |
1740505 | 1740505 | 2021-09-21 | Herkimer | New York | 36043 | 5989 | 117 |
1250193 | 1250193 | 2021-04-23 | Montgomery | New York | 36057 | 3950 | 117 |
1246946 | 1246946 | 2021-04-22 | Montgomery | New York | 36057 | 3935 | 117 |
1243699 | 1243699 | 2021-04-21 | Montgomery | New York | 36057 | 3923 | 117 |
1240452 | 1240452 | 2021-04-20 | Montgomery | New York | 36057 | 3915 | 117 |
1026156 | 1026156 | 2021-02-13 | Genesee | New York | 36037 | 4182 | 117 |
1022911 | 1022911 | 2021-02-12 | Genesee | New York | 36037 | 4168 | 117 |
1019666 | 1019666 | 2021-02-11 | Genesee | New York | 36037 | 4159 | 117 |
987198 | 987198 | 2021-02-01 | Chemung | New York | 36015 | 6065 | 117 |
867159 | 867159 | 2020-12-26 | Steuben | New York | 36101 | 3139 | 117 |
863914 | 863914 | 2020-12-25 | Steuben | New York | 36101 | 3097 | 117 |
860669 | 860669 | 2020-12-24 | Steuben | New York | 36101 | 3022 | 117 |
857424 | 857424 | 2020-12-23 | Steuben | New York | 36101 | 2942 | 117 |
717832 | 717832 | 2020-11-10 | Broome | New York | 36007 | 4086 | 117 |
458689 | 458689 | 2020-08-22 | Oneida | New York | 36065 | 2242 | 117 |
455461 | 455461 | 2020-08-21 | Oneida | New York | 36065 | 2233 | 117 |
452233 | 452233 | 2020-08-20 | Oneida | New York | 36065 | 2222 | 117 |
449005 | 449005 | 2020-08-19 | Oneida | New York | 36065 | 2218 | 117 |
445777 | 445777 | 2020-08-18 | Oneida | New York | 36065 | 2213 | 117 |
442551 | 442551 | 2020-08-17 | Oneida | New York | 36065 | 2201 | 117 |
439324 | 439324 | 2020-08-16 | Oneida | New York | 36065 | 2198 | 117 |
436099 | 436099 | 2020-08-15 | Oneida | New York | 36065 | 2195 | 117 |
432873 | 432873 | 2020-08-14 | Oneida | New York | 36065 | 2189 | 117 |
426392 | 426392 | 2020-08-12 | Albany | New York | 36001 | 2624 | 117 |
423169 | 423169 | 2020-08-11 | Albany | New York | 36001 | 2614 | 117 |
44744 | 44744 | 2020-04-09 | Rockland | New York | 36087 | 6665 | 117 |
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);