ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 288 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1120289 | 1120289 | 2021-03-14 | Hamilton | New York | 36041 | 288 | 2 |
1117042 | 1117042 | 2021-03-13 | Hamilton | New York | 36041 | 288 | 2 |
1113795 | 1113795 | 2021-03-12 | Hamilton | New York | 36041 | 288 | 2 |
795770 | 795770 | 2020-12-04 | Yates | New York | 36123 | 288 | 7 |
721094 | 721094 | 2020-11-11 | Jefferson | New York | 36045 | 288 | 1 |
701621 | 701621 | 2020-11-05 | Clinton | New York | 36019 | 288 | 5 |
558976 | 558976 | 2020-09-22 | Washington | New York | 36115 | 288 | 14 |
513646 | 513646 | 2020-09-08 | Otsego | New York | 36077 | 288 | 4 |
503966 | 503966 | 2020-09-05 | Wayne | New York | 36117 | 288 | 3 |
500732 | 500732 | 2020-09-04 | Wayne | New York | 36117 | 288 | 3 |
478078 | 478078 | 2020-08-28 | Oswego | New York | 36075 | 288 | 3 |
445764 | 445764 | 2020-08-18 | Genesee | New York | 36037 | 288 | 6 |
374941 | 374941 | 2020-07-27 | Steuben | New York | 36101 | 288 | 19 |
371729 | 371729 | 2020-07-26 | Steuben | New York | 36101 | 288 | 19 |
368517 | 368517 | 2020-07-25 | Steuben | New York | 36101 | 288 | 19 |
362090 | 362090 | 2020-07-23 | Orleans | New York | 36073 | 288 | 41 |
358884 | 358884 | 2020-07-22 | Orleans | New York | 36073 | 288 | 41 |
358902 | 358902 | 2020-07-22 | Warren | New York | 36113 | 288 | 31 |
355680 | 355680 | 2020-07-21 | Orleans | New York | 36073 | 288 | 41 |
355698 | 355698 | 2020-07-21 | Warren | New York | 36113 | 288 | 31 |
352477 | 352477 | 2020-07-20 | Orleans | New York | 36073 | 288 | 41 |
349274 | 349274 | 2020-07-19 | Orleans | New York | 36073 | 288 | 41 |
346073 | 346073 | 2020-07-18 | Orleans | New York | 36073 | 288 | 41 |
342874 | 342874 | 2020-07-17 | Orleans | New York | 36073 | 288 | 41 |
339676 | 339676 | 2020-07-16 | Orleans | New York | 36073 | 288 | 41 |
336480 | 336480 | 2020-07-15 | Orleans | New York | 36073 | 288 | 41 |
333286 | 333286 | 2020-07-14 | Orleans | New York | 36073 | 288 | 41 |
82920 | 82920 | 2020-04-23 | Schenectady | New York | 36093 | 288 | 20 |
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);