ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 114 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 |
---|---|---|---|---|---|---|---|
704871 | 704871 | 2020-11-06 | Franklin | New York | 36033 | 114 | 1 |
685437 | 685437 | 2020-10-31 | Schoharie | New York | 36095 | 114 | 2 |
614070 | 614070 | 2020-10-09 | Seneca | New York | 36099 | 114 | 1 |
610829 | 610829 | 2020-10-08 | Seneca | New York | 36099 | 114 | 1 |
584851 | 584851 | 2020-09-30 | Allegany | New York | 36003 | 114 | 4 |
403902 | 403902 | 2020-08-05 | Wyoming | New York | 36121 | 114 | 3 |
397449 | 397449 | 2020-08-03 | Otsego | New York | 36077 | 114 | 6 |
362064 | 362064 | 2020-07-23 | Clinton | New York | 36019 | 114 | 4 |
358858 | 358858 | 2020-07-22 | Clinton | New York | 36019 | 114 | 4 |
355654 | 355654 | 2020-07-21 | Clinton | New York | 36019 | 114 | 4 |
285715 | 285715 | 2020-06-29 | Cayuga | New York | 36011 | 114 | 1 |
214020 | 214020 | 2020-06-06 | Oswego | New York | 36075 | 114 | 0 |
174151 | 174151 | 2020-05-24 | Livingston | New York | 36051 | 114 | 4 |
171109 | 171109 | 2020-05-23 | Livingston | New York | 36051 | 114 | 4 |
168070 | 168070 | 2020-05-22 | Livingston | New York | 36051 | 114 | 4 |
165035 | 165035 | 2020-05-21 | Livingston | New York | 36051 | 114 | 4 |
162032 | 162032 | 2020-05-20 | Tioga | New York | 36107 | 114 | 16 |
99836 | 99836 | 2020-04-29 | Greene | New York | 36039 | 114 | 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);