ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 41 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
766526 | 766526 | 2020-11-25 | Hamilton | New York | 36041 | 41 | 1 |
578412 | 578412 | 2020-09-28 | Schuyler | New York | 36097 | 41 | 0 |
575171 | 575171 | 2020-09-27 | Schuyler | New York | 36097 | 41 | 0 |
571927 | 571927 | 2020-09-26 | Schuyler | New York | 36097 | 41 | 0 |
568685 | 568685 | 2020-09-25 | Schuyler | New York | 36097 | 41 | 0 |
419968 | 419968 | 2020-08-10 | Lewis | New York | 36049 | 41 | 5 |
416748 | 416748 | 2020-08-09 | Lewis | New York | 36049 | 41 | 5 |
413527 | 413527 | 2020-08-08 | Lewis | New York | 36049 | 41 | 5 |
260654 | 260654 | 2020-06-21 | Yates | New York | 36123 | 41 | 6 |
257527 | 257527 | 2020-06-20 | Yates | New York | 36123 | 41 | 6 |
217085 | 217085 | 2020-06-07 | Cortland | New York | 36023 | 41 | 0 |
213995 | 213995 | 2020-06-06 | Cortland | New York | 36023 | 41 | 0 |
210911 | 210911 | 2020-06-05 | Cortland | New York | 36023 | 41 | 0 |
207829 | 207829 | 2020-06-04 | Cortland | New York | 36023 | 41 | 0 |
204748 | 204748 | 2020-06-03 | Cortland | New York | 36023 | 41 | 0 |
201671 | 201671 | 2020-06-02 | Cortland | New York | 36023 | 41 | 0 |
198597 | 198597 | 2020-06-01 | Cortland | New York | 36023 | 41 | 0 |
195524 | 195524 | 2020-05-31 | Cortland | New York | 36023 | 41 | 0 |
192454 | 192454 | 2020-05-30 | Cortland | New York | 36023 | 41 | 0 |
155952 | 155952 | 2020-05-18 | Essex | New York | 36031 | 41 | 0 |
152935 | 152935 | 2020-05-17 | Essex | New York | 36031 | 41 | 0 |
134927 | 134927 | 2020-05-11 | Chautauqua | New York | 36013 | 41 | 2 |
131936 | 131936 | 2020-05-10 | Chautauqua | New York | 36013 | 41 | 2 |
105577 | 105577 | 2020-05-01 | Seneca | New York | 36099 | 41 | 1 |
82902 | 82902 | 2020-04-23 | Livingston | New York | 36051 | 41 | 2 |
82935 | 82935 | 2020-04-23 | Wyoming | New York | 36121 | 41 | 3 |
69002 | 69002 | 2020-04-18 | Orleans | New York | 36073 | 41 | 0 |
58064 | 58064 | 2020-04-14 | Oswego | New York | 36075 | 41 | 0 |
47354 | 47354 | 2020-04-10 | Otsego | New York | 36077 | 41 | 2 |
47372 | 47372 | 2020-04-10 | Wayne | New York | 36117 | 41 | 0 |
29772 | 29772 | 2020-04-03 | Columbia | New York | 36021 | 41 | 2 |
27448 | 27448 | 2020-04-02 | Columbia | New York | 36021 | 41 | 2 |
25188 | 25188 | 2020-04-01 | Columbia | New York | 36021 | 41 | 1 |
23009 | 23009 | 2020-03-31 | Madison | New York | 36053 | 41 | 0 |
20891 | 20891 | 2020-03-30 | Niagara | New York | 36063 | 41 | 0 |
7827 | 7827 | 2020-03-22 | Saratoga | New York | 36091 | 41 | 0 |
2169 | 2169 | 2020-03-14 | Suffolk | New York | 36103 | 41 | 0 |
1521 | 1521 | 2020-03-12 | Nassau | New York | 36059 | 41 | 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);