ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 2 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Hamilton 20
- Allegany 13
- Yates 9
- Greene 8
- Cayuga 7
- Putnam 5
- Saratoga 5
- Broome 4
- Cortland 4
- Lewis 4
- Warren 4
- Wyoming 4
- Jefferson 3
- Onondaga 3
- Orleans 3
- Rockland 3
- Schuyler 3
- Albany 2
- Chenango 2
- Livingston 2
- Monroe 2
- New York City 2
- Oswego 2
- Schoharie 2
- Seneca 2
- Tioga 2
- Clinton 1
- Columbia 1
- Essex 1
- Franklin 1
- …
state 1
- New York · 135 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
50030 | 50030 | 2020-04-11 | Yates | New York | 36123 | 2 | 0 |
47375 | 47375 | 2020-04-10 | Yates | New York | 36123 | 2 | 0 |
42141 | 42141 | 2020-04-08 | Hamilton | New York | 36041 | 2 | 0 |
42179 | 42179 | 2020-04-08 | Yates | New York | 36123 | 2 | 0 |
39584 | 39584 | 2020-04-07 | Hamilton | New York | 36041 | 2 | 0 |
39622 | 39622 | 2020-04-07 | Yates | New York | 36123 | 2 | 0 |
37069 | 37069 | 2020-04-06 | Hamilton | New York | 36041 | 2 | 0 |
37107 | 37107 | 2020-04-06 | Yates | New York | 36123 | 2 | 0 |
34599 | 34599 | 2020-04-05 | Hamilton | New York | 36041 | 2 | 0 |
34638 | 34638 | 2020-04-05 | Yates | New York | 36123 | 2 | 0 |
32168 | 32168 | 2020-04-04 | Hamilton | New York | 36041 | 2 | 0 |
32207 | 32207 | 2020-04-04 | Yates | New York | 36123 | 2 | 0 |
29782 | 29782 | 2020-04-03 | Hamilton | New York | 36041 | 2 | 0 |
29821 | 29821 | 2020-04-03 | Yates | New York | 36123 | 2 | 0 |
27458 | 27458 | 2020-04-02 | Hamilton | New York | 36041 | 2 | 0 |
27497 | 27497 | 2020-04-02 | Yates | New York | 36123 | 2 | 0 |
25195 | 25195 | 2020-04-01 | Fulton | New York | 36035 | 2 | 0 |
25198 | 25198 | 2020-04-01 | Hamilton | New York | 36041 | 2 | 0 |
25201 | 25201 | 2020-04-01 | Lewis | New York | 36049 | 2 | 0 |
25222 | 25222 | 2020-04-01 | Schuyler | New York | 36097 | 2 | 0 |
25223 | 25223 | 2020-04-01 | Seneca | New York | 36099 | 2 | 0 |
23004 | 23004 | 2020-03-31 | Hamilton | New York | 36041 | 2 | 0 |
23007 | 23007 | 2020-03-31 | Lewis | New York | 36049 | 2 | 0 |
23028 | 23028 | 2020-03-31 | Schuyler | New York | 36097 | 2 | 0 |
23029 | 23029 | 2020-03-31 | Seneca | New York | 36099 | 2 | 0 |
20881 | 20881 | 2020-03-30 | Hamilton | New York | 36041 | 2 | 0 |
20884 | 20884 | 2020-03-30 | Lewis | New York | 36049 | 2 | 0 |
20905 | 20905 | 2020-03-30 | Schuyler | New York | 36097 | 2 | 0 |
18827 | 18827 | 2020-03-29 | Cayuga | New York | 36011 | 2 | 0 |
18842 | 18842 | 2020-03-29 | Hamilton | New York | 36041 | 2 | 0 |
18845 | 18845 | 2020-03-29 | Lewis | New York | 36049 | 2 | 0 |
16900 | 16900 | 2020-03-28 | Allegany | New York | 36003 | 2 | 0 |
16903 | 16903 | 2020-03-28 | Cayuga | New York | 36011 | 2 | 0 |
16918 | 16918 | 2020-03-28 | Hamilton | New York | 36041 | 2 | 0 |
15071 | 15071 | 2020-03-27 | Allegany | New York | 36003 | 2 | 0 |
15073 | 15073 | 2020-03-27 | Cayuga | New York | 36011 | 2 | 0 |
15084 | 15084 | 2020-03-27 | Franklin | New York | 36033 | 2 | 0 |
15088 | 15088 | 2020-03-27 | Hamilton | New York | 36041 | 2 | 0 |
15115 | 15115 | 2020-03-27 | Tioga | New York | 36107 | 2 | 0 |
13337 | 13337 | 2020-03-26 | Allegany | New York | 36003 | 2 | 0 |
13339 | 13339 | 2020-03-26 | Cayuga | New York | 36011 | 2 | 0 |
13345 | 13345 | 2020-03-26 | Cortland | New York | 36023 | 2 | 0 |
13354 | 13354 | 2020-03-26 | Hamilton | New York | 36041 | 2 | 0 |
13368 | 13368 | 2020-03-26 | Orleans | New York | 36073 | 2 | 0 |
13376 | 13376 | 2020-03-26 | Schoharie | New York | 36095 | 2 | 0 |
13377 | 13377 | 2020-03-26 | St. Lawrence | New York | 36089 | 2 | 0 |
13381 | 13381 | 2020-03-26 | Tioga | New York | 36107 | 2 | 0 |
13384 | 13384 | 2020-03-26 | Warren | New York | 36113 | 2 | 0 |
11734 | 11734 | 2020-03-25 | Allegany | New York | 36003 | 2 | 0 |
11736 | 11736 | 2020-03-25 | Cayuga | New York | 36011 | 2 | 0 |
11742 | 11742 | 2020-03-25 | Cortland | New York | 36023 | 2 | 0 |
11749 | 11749 | 2020-03-25 | Genesee | New York | 36037 | 2 | 0 |
11751 | 11751 | 2020-03-25 | Hamilton | New York | 36041 | 2 | 0 |
11753 | 11753 | 2020-03-25 | Jefferson | New York | 36045 | 2 | 0 |
11765 | 11765 | 2020-03-25 | Orleans | New York | 36073 | 2 | 0 |
11766 | 11766 | 2020-03-25 | Oswego | New York | 36075 | 2 | 0 |
11767 | 11767 | 2020-03-25 | Otsego | New York | 36077 | 2 | 0 |
11773 | 11773 | 2020-03-25 | Schoharie | New York | 36095 | 2 | 0 |
11781 | 11781 | 2020-03-25 | Warren | New York | 36113 | 2 | 0 |
10300 | 10300 | 2020-03-24 | Allegany | New York | 36003 | 2 | 0 |
10302 | 10302 | 2020-03-24 | Cayuga | New York | 36011 | 2 | 0 |
10307 | 10307 | 2020-03-24 | Cortland | New York | 36023 | 2 | 0 |
10315 | 10315 | 2020-03-24 | Hamilton | New York | 36041 | 2 | 0 |
10317 | 10317 | 2020-03-24 | Jefferson | New York | 36045 | 2 | 0 |
10329 | 10329 | 2020-03-24 | Orleans | New York | 36073 | 2 | 0 |
10330 | 10330 | 2020-03-24 | Oswego | New York | 36075 | 2 | 0 |
10345 | 10345 | 2020-03-24 | Warren | New York | 36113 | 2 | 0 |
8994 | 8994 | 2020-03-23 | Allegany | New York | 36003 | 2 | 0 |
8996 | 8996 | 2020-03-23 | Cayuga | New York | 36011 | 2 | 0 |
9000 | 9000 | 2020-03-23 | Cortland | New York | 36023 | 2 | 0 |
9008 | 9008 | 2020-03-23 | Hamilton | New York | 36041 | 2 | 0 |
9010 | 9010 | 2020-03-23 | Jefferson | New York | 36045 | 2 | 0 |
9037 | 9037 | 2020-03-23 | Warren | New York | 36113 | 2 | 0 |
7797 | 7797 | 2020-03-22 | Allegany | New York | 36003 | 2 | 0 |
7809 | 7809 | 2020-03-22 | Greene | New York | 36039 | 2 | 0 |
7810 | 7810 | 2020-03-22 | Hamilton | New York | 36041 | 2 | 0 |
7813 | 7813 | 2020-03-22 | Livingston | New York | 36051 | 2 | 0 |
7841 | 7841 | 2020-03-22 | Wyoming | New York | 36121 | 2 | 0 |
6704 | 6704 | 2020-03-21 | Allegany | New York | 36003 | 2 | 0 |
6705 | 6705 | 2020-03-21 | Broome | New York | 36007 | 2 | 1 |
6706 | 6706 | 2020-03-21 | Chenango | New York | 36017 | 2 | 0 |
6708 | 6708 | 2020-03-21 | Columbia | New York | 36021 | 2 | 0 |
6712 | 6712 | 2020-03-21 | Essex | New York | 36031 | 2 | 0 |
6715 | 6715 | 2020-03-21 | Greene | New York | 36039 | 2 | 0 |
6716 | 6716 | 2020-03-21 | Hamilton | New York | 36041 | 2 | 0 |
6719 | 6719 | 2020-03-21 | Livingston | New York | 36051 | 2 | 0 |
6735 | 6735 | 2020-03-21 | Steuben | New York | 36101 | 2 | 0 |
6745 | 6745 | 2020-03-21 | Wyoming | New York | 36121 | 2 | 0 |
5710 | 5710 | 2020-03-20 | Allegany | New York | 36003 | 2 | 0 |
5711 | 5711 | 2020-03-20 | Broome | New York | 36007 | 2 | 0 |
5712 | 5712 | 2020-03-20 | Chenango | New York | 36017 | 2 | 0 |
5713 | 5713 | 2020-03-20 | Clinton | New York | 36019 | 2 | 0 |
5721 | 5721 | 2020-03-20 | Greene | New York | 36039 | 2 | 0 |
5722 | 5722 | 2020-03-20 | Hamilton | New York | 36041 | 2 | 0 |
5723 | 5723 | 2020-03-20 | Herkimer | New York | 36043 | 2 | 0 |
5727 | 5727 | 2020-03-20 | Montgomery | New York | 36057 | 2 | 0 |
5731 | 5731 | 2020-03-20 | Oneida | New York | 36065 | 2 | 0 |
5750 | 5750 | 2020-03-20 | Wyoming | New York | 36121 | 2 | 0 |
4864 | 4864 | 2020-03-19 | Allegany | New York | 36003 | 2 | 0 |
4865 | 4865 | 2020-03-19 | Broome | New York | 36007 | 2 | 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);