ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where cases = 12 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 |
---|---|---|---|---|---|---|---|
465135 | 465135 | 2020-08-24 | Hamilton | New York | 36041 | 12 | 1 |
461906 | 461906 | 2020-08-23 | Hamilton | New York | 36041 | 12 | 1 |
458678 | 458678 | 2020-08-22 | Hamilton | New York | 36041 | 12 | 1 |
455450 | 455450 | 2020-08-21 | Hamilton | New York | 36041 | 12 | 1 |
452222 | 452222 | 2020-08-20 | Hamilton | New York | 36041 | 12 | 1 |
288904 | 288904 | 2020-06-30 | Schuyler | New York | 36097 | 12 | 0 |
285754 | 285754 | 2020-06-29 | Schuyler | New York | 36097 | 12 | 0 |
282609 | 282609 | 2020-06-28 | Schuyler | New York | 36097 | 12 | 0 |
279463 | 279463 | 2020-06-27 | Schuyler | New York | 36097 | 12 | 0 |
276315 | 276315 | 2020-06-26 | Schuyler | New York | 36097 | 12 | 0 |
273169 | 273169 | 2020-06-25 | Schuyler | New York | 36097 | 12 | 0 |
270030 | 270030 | 2020-06-24 | Schuyler | New York | 36097 | 12 | 0 |
266896 | 266896 | 2020-06-23 | Schuyler | New York | 36097 | 12 | 0 |
263768 | 263768 | 2020-06-22 | Schuyler | New York | 36097 | 12 | 0 |
260640 | 260640 | 2020-06-21 | Schuyler | New York | 36097 | 12 | 0 |
257513 | 257513 | 2020-06-20 | Schuyler | New York | 36097 | 12 | 0 |
254390 | 254390 | 2020-06-19 | Schuyler | New York | 36097 | 12 | 0 |
251275 | 251275 | 2020-06-18 | Schuyler | New York | 36097 | 12 | 0 |
248160 | 248160 | 2020-06-17 | Schuyler | New York | 36097 | 12 | 0 |
245047 | 245047 | 2020-06-16 | Schuyler | New York | 36097 | 12 | 0 |
241935 | 241935 | 2020-06-15 | Schuyler | New York | 36097 | 12 | 0 |
238826 | 238826 | 2020-06-14 | Schuyler | New York | 36097 | 12 | 0 |
235718 | 235718 | 2020-06-13 | Schuyler | New York | 36097 | 12 | 0 |
232613 | 232613 | 2020-06-12 | Schuyler | New York | 36097 | 12 | 0 |
229508 | 229508 | 2020-06-11 | Schuyler | New York | 36097 | 12 | 0 |
226404 | 226404 | 2020-06-10 | Schuyler | New York | 36097 | 12 | 0 |
223304 | 223304 | 2020-06-09 | Schuyler | New York | 36097 | 12 | 0 |
220210 | 220210 | 2020-06-08 | Schuyler | New York | 36097 | 12 | 0 |
217118 | 217118 | 2020-06-07 | Schuyler | New York | 36097 | 12 | 0 |
214028 | 214028 | 2020-06-06 | Schuyler | New York | 36097 | 12 | 0 |
210944 | 210944 | 2020-06-05 | Schuyler | New York | 36097 | 12 | 0 |
207862 | 207862 | 2020-06-04 | Schuyler | New York | 36097 | 12 | 0 |
204781 | 204781 | 2020-06-03 | Schuyler | New York | 36097 | 12 | 0 |
201704 | 201704 | 2020-06-02 | Schuyler | New York | 36097 | 12 | 0 |
146926 | 146926 | 2020-05-15 | Lewis | New York | 36049 | 12 | 0 |
143925 | 143925 | 2020-05-14 | Lewis | New York | 36049 | 12 | 0 |
63483 | 63483 | 2020-04-16 | Essex | New York | 36031 | 12 | 0 |
60757 | 60757 | 2020-04-15 | Essex | New York | 36031 | 12 | 0 |
58043 | 58043 | 2020-04-14 | Essex | New York | 36031 | 12 | 0 |
55343 | 55343 | 2020-04-13 | Essex | New York | 36031 | 12 | 0 |
55344 | 55344 | 2020-04-13 | Franklin | New York | 36033 | 12 | 0 |
55371 | 55371 | 2020-04-13 | Schoharie | New York | 36095 | 12 | 0 |
52660 | 52660 | 2020-04-12 | Essex | New York | 36031 | 12 | 0 |
52661 | 52661 | 2020-04-12 | Franklin | New York | 36033 | 12 | 0 |
52688 | 52688 | 2020-04-12 | Schoharie | New York | 36095 | 12 | 0 |
49987 | 49987 | 2020-04-11 | Essex | New York | 36031 | 12 | 0 |
50015 | 50015 | 2020-04-11 | Schoharie | New York | 36095 | 12 | 0 |
47360 | 47360 | 2020-04-10 | Schoharie | New York | 36095 | 12 | 0 |
44747 | 44747 | 2020-04-09 | Schoharie | New York | 36095 | 12 | 0 |
42164 | 42164 | 2020-04-08 | Schoharie | New York | 36095 | 12 | 0 |
42166 | 42166 | 2020-04-08 | Seneca | New York | 36099 | 12 | 0 |
42171 | 42171 | 2020-04-08 | Tioga | New York | 36107 | 12 | 0 |
39607 | 39607 | 2020-04-07 | Schoharie | New York | 36095 | 12 | 0 |
34585 | 34585 | 2020-04-05 | Chautauqua | New York | 36013 | 12 | 0 |
32154 | 32154 | 2020-04-04 | Chautauqua | New York | 36013 | 12 | 0 |
29764 | 29764 | 2020-04-03 | Allegany | New York | 36003 | 12 | 1 |
27440 | 27440 | 2020-04-02 | Allegany | New York | 36003 | 12 | 1 |
25200 | 25200 | 2020-04-01 | Jefferson | New York | 36045 | 12 | 0 |
23005 | 23005 | 2020-03-31 | Herkimer | New York | 36043 | 12 | 2 |
23006 | 23006 | 2020-03-31 | Jefferson | New York | 36045 | 12 | 0 |
20882 | 20882 | 2020-03-30 | Herkimer | New York | 36043 | 12 | 2 |
20885 | 20885 | 2020-03-30 | Livingston | New York | 36051 | 12 | 0 |
18867 | 18867 | 2020-03-29 | St. Lawrence | New York | 36089 | 12 | 0 |
18877 | 18877 | 2020-03-29 | Wayne | New York | 36117 | 12 | 0 |
16905 | 16905 | 2020-03-28 | Chemung | New York | 36015 | 12 | 0 |
16907 | 16907 | 2020-03-28 | Clinton | New York | 36019 | 12 | 0 |
16951 | 16951 | 2020-03-28 | Wayne | New York | 36117 | 12 | 0 |
15112 | 15112 | 2020-03-27 | Steuben | New York | 36101 | 12 | 0 |
11741 | 11741 | 2020-03-25 | Columbia | New York | 36021 | 12 | 0 |
11760 | 11760 | 2020-03-25 | Niagara | New York | 36063 | 12 | 0 |
6737 | 6737 | 2020-03-21 | Sullivan | New York | 36105 | 12 | 0 |
5745 | 5745 | 2020-03-20 | Ulster | New York | 36111 | 12 | 0 |
4894 | 4894 | 2020-03-19 | Ulster | New York | 36111 | 12 | 0 |
3023 | 3023 | 2020-03-16 | Albany | New York | 36001 | 12 | 0 |
2166 | 2166 | 2020-03-14 | Rockland | New York | 36087 | 12 | 1 |
716 | 716 | 2020-03-07 | New York City | New York | 12 | 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);