ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 260 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 9
- Monroe 25
- Ulster 5
- Albany 1
- Broome 1
- Chautauqua 1
- Dutchess 1
- Oneida 1
- Saratoga 1
- Schenectady 1
state 1
- New York · 37 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2185804 | 2185804 | 2022-02-05 | Chautauqua | New York | 36013 | 22764 | 260 |
2052500 | 2052500 | 2021-12-26 | Saratoga | New York | 36091 | 29297 | 260 |
2039502 | 2039502 | 2021-12-22 | Schenectady | New York | 36093 | 21305 | 260 |
1649578 | 1649578 | 2021-08-24 | Ulster | New York | 36111 | 14980 | 260 |
1646329 | 1646329 | 2021-08-23 | Ulster | New York | 36111 | 14948 | 260 |
1643080 | 1643080 | 2021-08-22 | Ulster | New York | 36111 | 14910 | 260 |
1639830 | 1639830 | 2021-08-21 | Ulster | New York | 36111 | 14853 | 260 |
1636580 | 1636580 | 2021-08-20 | Ulster | New York | 36111 | 14789 | 260 |
948247 | 948247 | 2021-01-20 | Albany | New York | 36001 | 16521 | 260 |
948249 | 948249 | 2021-01-20 | Broome | New York | 36007 | 11255 | 260 |
906070 | 906070 | 2021-01-07 | Dutchess | New York | 36027 | 13642 | 260 |
893106 | 893106 | 2021-01-03 | Oneida | New York | 36065 | 12999 | 260 |
652984 | 652984 | 2020-10-21 | Monroe | New York | 36055 | 6851 | 260 |
649739 | 649739 | 2020-10-20 | Monroe | New York | 36055 | 6799 | 260 |
646495 | 646495 | 2020-10-19 | Monroe | New York | 36055 | 6745 | 260 |
643249 | 643249 | 2020-10-18 | Monroe | New York | 36055 | 6708 | 260 |
640001 | 640001 | 2020-10-17 | Monroe | New York | 36055 | 6672 | 260 |
636755 | 636755 | 2020-10-16 | Monroe | New York | 36055 | 6629 | 260 |
633509 | 633509 | 2020-10-15 | Monroe | New York | 36055 | 6573 | 260 |
630264 | 630264 | 2020-10-14 | Monroe | New York | 36055 | 6517 | 260 |
627020 | 627020 | 2020-10-13 | Monroe | New York | 36055 | 6491 | 260 |
623778 | 623778 | 2020-10-12 | Monroe | New York | 36055 | 6454 | 260 |
620535 | 620535 | 2020-10-11 | Monroe | New York | 36055 | 6422 | 260 |
617293 | 617293 | 2020-10-10 | Monroe | New York | 36055 | 6388 | 260 |
614051 | 614051 | 2020-10-09 | Monroe | New York | 36055 | 6350 | 260 |
610810 | 610810 | 2020-10-08 | Monroe | New York | 36055 | 6317 | 260 |
607568 | 607568 | 2020-10-07 | Monroe | New York | 36055 | 6267 | 260 |
604325 | 604325 | 2020-10-06 | Monroe | New York | 36055 | 6249 | 260 |
601083 | 601083 | 2020-10-05 | Monroe | New York | 36055 | 6221 | 260 |
597840 | 597840 | 2020-10-04 | Monroe | New York | 36055 | 6207 | 260 |
594597 | 594597 | 2020-10-03 | Monroe | New York | 36055 | 6187 | 260 |
591356 | 591356 | 2020-10-02 | Monroe | New York | 36055 | 6161 | 260 |
588115 | 588115 | 2020-10-01 | Monroe | New York | 36055 | 6122 | 260 |
584875 | 584875 | 2020-09-30 | Monroe | New York | 36055 | 6086 | 260 |
581634 | 581634 | 2020-09-29 | Monroe | New York | 36055 | 6075 | 260 |
578394 | 578394 | 2020-09-28 | Monroe | New York | 36055 | 6046 | 260 |
279445 | 279445 | 2020-06-27 | Monroe | New York | 36055 | 3677 | 260 |
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);