ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 15 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 |
---|---|---|---|---|---|---|---|
623772 | 623772 | 2020-10-12 | Hamilton | New York | 36041 | 15 | 1 |
620529 | 620529 | 2020-10-11 | Hamilton | New York | 36041 | 15 | 1 |
617287 | 617287 | 2020-10-10 | Hamilton | New York | 36041 | 15 | 1 |
614045 | 614045 | 2020-10-09 | Hamilton | New York | 36041 | 15 | 1 |
610804 | 610804 | 2020-10-08 | Hamilton | New York | 36041 | 15 | 1 |
607562 | 607562 | 2020-10-07 | Hamilton | New York | 36041 | 15 | 1 |
604319 | 604319 | 2020-10-06 | Hamilton | New York | 36041 | 15 | 1 |
601077 | 601077 | 2020-10-05 | Hamilton | New York | 36041 | 15 | 1 |
597834 | 597834 | 2020-10-04 | Hamilton | New York | 36041 | 15 | 1 |
594591 | 594591 | 2020-10-03 | Hamilton | New York | 36041 | 15 | 1 |
591350 | 591350 | 2020-10-02 | Hamilton | New York | 36041 | 15 | 1 |
588109 | 588109 | 2020-10-01 | Hamilton | New York | 36041 | 15 | 1 |
584869 | 584869 | 2020-09-30 | Hamilton | New York | 36041 | 15 | 1 |
581628 | 581628 | 2020-09-29 | Hamilton | New York | 36041 | 15 | 1 |
578388 | 578388 | 2020-09-28 | Hamilton | New York | 36041 | 15 | 1 |
575147 | 575147 | 2020-09-27 | Hamilton | New York | 36041 | 15 | 1 |
571903 | 571903 | 2020-09-26 | Hamilton | New York | 36041 | 15 | 1 |
568661 | 568661 | 2020-09-25 | Hamilton | New York | 36041 | 15 | 1 |
565420 | 565420 | 2020-09-24 | Hamilton | New York | 36041 | 15 | 1 |
562179 | 562179 | 2020-09-23 | Hamilton | New York | 36041 | 15 | 1 |
558942 | 558942 | 2020-09-22 | Hamilton | New York | 36041 | 15 | 1 |
555705 | 555705 | 2020-09-21 | Hamilton | New York | 36041 | 15 | 1 |
552468 | 552468 | 2020-09-20 | Hamilton | New York | 36041 | 15 | 1 |
549229 | 549229 | 2020-09-19 | Hamilton | New York | 36041 | 15 | 1 |
342883 | 342883 | 2020-07-17 | Schuyler | New York | 36097 | 15 | 0 |
339685 | 339685 | 2020-07-16 | Schuyler | New York | 36097 | 15 | 0 |
336489 | 336489 | 2020-07-15 | Schuyler | New York | 36097 | 15 | 0 |
333295 | 333295 | 2020-07-14 | Schuyler | New York | 36097 | 15 | 0 |
330105 | 330105 | 2020-07-13 | Schuyler | New York | 36097 | 15 | 0 |
326918 | 326918 | 2020-07-12 | Schuyler | New York | 36097 | 15 | 0 |
323734 | 323734 | 2020-07-11 | Schuyler | New York | 36097 | 15 | 0 |
111288 | 111288 | 2020-05-03 | Franklin | New York | 36033 | 15 | 0 |
108415 | 108415 | 2020-05-02 | Franklin | New York | 36033 | 15 | 0 |
105548 | 105548 | 2020-05-01 | Franklin | New York | 36033 | 15 | 0 |
102686 | 102686 | 2020-04-30 | Franklin | New York | 36033 | 15 | 0 |
99833 | 99833 | 2020-04-29 | Franklin | New York | 36033 | 15 | 0 |
66225 | 66225 | 2020-04-17 | Essex | New York | 36031 | 15 | 0 |
47362 | 47362 | 2020-04-10 | Seneca | New York | 36099 | 15 | 0 |
44721 | 44721 | 2020-04-09 | Fulton | New York | 36035 | 15 | 0 |
44749 | 44749 | 2020-04-09 | Seneca | New York | 36099 | 15 | 0 |
42125 | 42125 | 2020-04-08 | Cattaraugus | New York | 36009 | 15 | 0 |
42126 | 42126 | 2020-04-08 | Cayuga | New York | 36011 | 15 | 1 |
39599 | 39599 | 2020-04-07 | Orleans | New York | 36073 | 15 | 0 |
37053 | 37053 | 2020-04-06 | Cattaraugus | New York | 36009 | 15 | 0 |
37055 | 37055 | 2020-04-06 | Chautauqua | New York | 36013 | 15 | 0 |
37060 | 37060 | 2020-04-06 | Cortland | New York | 36023 | 15 | 0 |
37076 | 37076 | 2020-04-06 | Montgomery | New York | 36057 | 15 | 1 |
34606 | 34606 | 2020-04-05 | Montgomery | New York | 36057 | 15 | 1 |
29784 | 29784 | 2020-04-03 | Jefferson | New York | 36045 | 15 | 0 |
29820 | 29820 | 2020-04-03 | Wyoming | New York | 36121 | 15 | 1 |
27460 | 27460 | 2020-04-02 | Jefferson | New York | 36045 | 15 | 0 |
27496 | 27496 | 2020-04-02 | Wyoming | New York | 36121 | 15 | 1 |
23020 | 23020 | 2020-03-31 | Oswego | New York | 36075 | 15 | 0 |
20868 | 20868 | 2020-03-30 | Chemung | New York | 36015 | 15 | 0 |
20916 | 20916 | 2020-03-30 | Wayne | New York | 36117 | 15 | 0 |
18829 | 18829 | 2020-03-29 | Chemung | New York | 36015 | 15 | 0 |
18830 | 18830 | 2020-03-29 | Chenango | New York | 36017 | 15 | 0 |
9035 | 9035 | 2020-03-23 | Tompkins | New York | 36109 | 15 | 0 |
3553 | 3553 | 2020-03-17 | Orange | New York | 36071 | 15 | 0 |
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);