ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,692 rows where state = "New York" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- New York City 804
- Westchester 801
- Nassau 800
- Rockland 799
- Saratoga 798
- Suffolk 797
- Ulster 797
- Monroe 794
- Albany 793
- Delaware 793
- Dutchess 793
- Herkimer 793
- Orange 793
- Schenectady 792
- Broome 791
- Tioga 791
- Tompkins 791
- Erie 790
- Greene 790
- Montgomery 790
- Putnam 790
- Allegany 789
- Onondaga 789
- Ontario 789
- Clinton 788
- Rensselaer 788
- Sullivan 788
- Wyoming 788
- Chenango 787
- Essex 787
- …
state 1
- New York · 45,692 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
18874 | 18874 | 2020-03-29 | Unknown | New York | 0 | 68 | |
20913 | 20913 | 2020-03-30 | Unknown | New York | 0 | 162 | |
23037 | 23037 | 2020-03-31 | Unknown | New York | 0 | 268 | |
25231 | 25231 | 2020-04-01 | Unknown | New York | 0 | 289 | |
27491 | 27491 | 2020-04-02 | Unknown | New York | 0 | 415 | |
29815 | 29815 | 2020-04-03 | Unknown | New York | 0 | 608 | |
32201 | 32201 | 2020-04-04 | Unknown | New York | 0 | 309 | |
34632 | 34632 | 2020-04-05 | Unknown | New York | 0 | 678 | |
66263 | 66263 | 2020-04-17 | Unknown | New York | 0 | 630 | |
69020 | 69020 | 2020-04-18 | Unknown | New York | 0 | 1170 | |
417 | 417 | 2020-03-01 | New York City | New York | 1 | 0 | |
449 | 449 | 2020-03-02 | New York City | New York | 1 | 0 | |
565 | 565 | 2020-03-05 | Nassau | New York | 36059 | 1 | 0 |
824 | 824 | 2020-03-08 | Suffolk | New York | 36103 | 1 | 0 |
825 | 825 | 2020-03-08 | Ulster | New York | 36111 | 1 | 0 |
951 | 951 | 2020-03-09 | Suffolk | New York | 36103 | 1 | 0 |
952 | 952 | 2020-03-09 | Ulster | New York | 36111 | 1 | 0 |
1102 | 1102 | 2020-03-10 | Suffolk | New York | 36103 | 1 | 0 |
1103 | 1103 | 2020-03-10 | Ulster | New York | 36111 | 1 | 0 |
1284 | 1284 | 2020-03-11 | Monroe | New York | 36055 | 1 | 0 |
1517 | 1517 | 2020-03-12 | Delaware | New York | 36025 | 1 | 0 |
1518 | 1518 | 2020-03-12 | Dutchess | New York | 36027 | 1 | 0 |
1519 | 1519 | 2020-03-12 | Herkimer | New York | 36043 | 1 | 0 |
1520 | 1520 | 2020-03-12 | Monroe | New York | 36055 | 1 | 0 |
1523 | 1523 | 2020-03-12 | Orange | New York | 36071 | 1 | 0 |
1810 | 1810 | 2020-03-13 | Delaware | New York | 36025 | 1 | 0 |
1812 | 1812 | 2020-03-13 | Herkimer | New York | 36043 | 1 | 0 |
1813 | 1813 | 2020-03-13 | Monroe | New York | 36055 | 1 | 0 |
1819 | 1819 | 2020-03-13 | Schenectady | New York | 36093 | 1 | 0 |
2158 | 2158 | 2020-03-14 | Broome | New York | 36007 | 1 | 0 |
2159 | 2159 | 2020-03-14 | Delaware | New York | 36025 | 1 | 0 |
2161 | 2161 | 2020-03-14 | Herkimer | New York | 36043 | 1 | 0 |
2168 | 2168 | 2020-03-14 | Schenectady | New York | 36093 | 1 | 0 |
2170 | 2170 | 2020-03-14 | Tioga | New York | 36107 | 1 | 0 |
2171 | 2171 | 2020-03-14 | Tompkins | New York | 36109 | 1 | 0 |
2566 | 2566 | 2020-03-15 | Broome | New York | 36007 | 1 | 0 |
2567 | 2567 | 2020-03-15 | Delaware | New York | 36025 | 1 | 0 |
2571 | 2571 | 2020-03-15 | Herkimer | New York | 36043 | 1 | 0 |
2573 | 2573 | 2020-03-15 | Montgomery | New York | 36057 | 1 | 0 |
2582 | 2582 | 2020-03-15 | Tioga | New York | 36107 | 1 | 0 |
2583 | 2583 | 2020-03-15 | Tompkins | New York | 36109 | 1 | 0 |
3025 | 3025 | 2020-03-16 | Broome | New York | 36007 | 1 | 0 |
3026 | 3026 | 2020-03-16 | Delaware | New York | 36025 | 1 | 0 |
3030 | 3030 | 2020-03-16 | Herkimer | New York | 36043 | 1 | 0 |
3032 | 3032 | 2020-03-16 | Montgomery | New York | 36057 | 1 | 0 |
3035 | 3035 | 2020-03-16 | Onondaga | New York | 36067 | 1 | 0 |
3036 | 3036 | 2020-03-16 | Ontario | New York | 36069 | 1 | 0 |
3043 | 3043 | 2020-03-16 | Tioga | New York | 36107 | 1 | 0 |
3044 | 3044 | 2020-03-16 | Tompkins | New York | 36109 | 1 | 0 |
3540 | 3540 | 2020-03-17 | Broome | New York | 36007 | 1 | 0 |
3541 | 3541 | 2020-03-17 | Clinton | New York | 36019 | 1 | 0 |
3542 | 3542 | 2020-03-17 | Delaware | New York | 36025 | 1 | 0 |
3546 | 3546 | 2020-03-17 | Herkimer | New York | 36043 | 1 | 0 |
3548 | 3548 | 2020-03-17 | Montgomery | New York | 36057 | 1 | 0 |
3552 | 3552 | 2020-03-17 | Ontario | New York | 36069 | 1 | 0 |
3555 | 3555 | 2020-03-17 | Rensselaer | New York | 36083 | 1 | 0 |
3560 | 3560 | 2020-03-17 | Sullivan | New York | 36105 | 1 | 0 |
3561 | 3561 | 2020-03-17 | Tioga | New York | 36107 | 1 | 0 |
3562 | 3562 | 2020-03-17 | Tompkins | New York | 36109 | 1 | 0 |
3565 | 3565 | 2020-03-17 | Wyoming | New York | 36121 | 1 | 0 |
4137 | 4137 | 2020-03-18 | Chenango | New York | 36017 | 1 | 0 |
4138 | 4138 | 2020-03-18 | Clinton | New York | 36019 | 1 | 0 |
4139 | 4139 | 2020-03-18 | Delaware | New York | 36025 | 1 | 0 |
4142 | 4142 | 2020-03-18 | Essex | New York | 36031 | 1 | 0 |
4144 | 4144 | 2020-03-18 | Hamilton | New York | 36041 | 1 | 0 |
4145 | 4145 | 2020-03-18 | Herkimer | New York | 36043 | 1 | 0 |
4146 | 4146 | 2020-03-18 | Jefferson | New York | 36045 | 1 | 0 |
4147 | 4147 | 2020-03-18 | Livingston | New York | 36051 | 1 | 0 |
4149 | 4149 | 2020-03-18 | Montgomery | New York | 36057 | 1 | 0 |
4153 | 4153 | 2020-03-18 | Ontario | New York | 36069 | 1 | 0 |
4161 | 4161 | 2020-03-18 | Sullivan | New York | 36105 | 1 | 0 |
4162 | 4162 | 2020-03-18 | Tioga | New York | 36107 | 1 | 0 |
4165 | 4165 | 2020-03-18 | Warren | New York | 36113 | 1 | 0 |
4166 | 4166 | 2020-03-18 | Washington | New York | 36115 | 1 | 0 |
4168 | 4168 | 2020-03-18 | Wyoming | New York | 36121 | 1 | 0 |
4866 | 4866 | 2020-03-19 | Chenango | New York | 36017 | 1 | 0 |
4867 | 4867 | 2020-03-19 | Clinton | New York | 36019 | 1 | 0 |
4868 | 4868 | 2020-03-19 | Delaware | New York | 36025 | 1 | 0 |
4871 | 4871 | 2020-03-19 | Essex | New York | 36031 | 1 | 0 |
4873 | 4873 | 2020-03-19 | Hamilton | New York | 36041 | 1 | 0 |
4874 | 4874 | 2020-03-19 | Herkimer | New York | 36043 | 1 | 0 |
4875 | 4875 | 2020-03-19 | Jefferson | New York | 36045 | 1 | 0 |
4876 | 4876 | 2020-03-19 | Livingston | New York | 36051 | 1 | 0 |
4878 | 4878 | 2020-03-19 | Montgomery | New York | 36057 | 1 | 0 |
4882 | 4882 | 2020-03-19 | Ontario | New York | 36069 | 1 | 0 |
4889 | 4889 | 2020-03-19 | Schoharie | New York | 36095 | 1 | 0 |
4892 | 4892 | 2020-03-19 | Tioga | New York | 36107 | 1 | 0 |
4895 | 4895 | 2020-03-19 | Warren | New York | 36113 | 1 | 0 |
4896 | 4896 | 2020-03-19 | Washington | New York | 36115 | 1 | 0 |
4897 | 4897 | 2020-03-19 | Wayne | New York | 36117 | 1 | 0 |
5714 | 5714 | 2020-03-20 | Columbia | New York | 36021 | 1 | 0 |
5715 | 5715 | 2020-03-20 | Delaware | New York | 36025 | 1 | 0 |
5718 | 5718 | 2020-03-20 | Essex | New York | 36031 | 1 | 0 |
5719 | 5719 | 2020-03-20 | Fulton | New York | 36035 | 1 | 0 |
5720 | 5720 | 2020-03-20 | Genesee | New York | 36037 | 1 | 0 |
5724 | 5724 | 2020-03-20 | Jefferson | New York | 36045 | 1 | 0 |
5725 | 5725 | 2020-03-20 | Livingston | New York | 36051 | 1 | 0 |
5740 | 5740 | 2020-03-20 | Schoharie | New York | 36095 | 1 | 0 |
5743 | 5743 | 2020-03-20 | Tioga | New York | 36107 | 1 | 0 |
5746 | 5746 | 2020-03-20 | Warren | New York | 36113 | 1 | 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);