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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- New York City 790
- Orange 790
- Putnam 790
- Rockland 790
- Saratoga 790
- Schenectady 790
- Suffolk 790
- Tioga 790
- Tompkins 790
- Ulster 790
- Westchester 790
- Albany 789
- Allegany 789
- Broome 789
- Delaware 789
- Dutchess 789
- Erie 789
- Greene 789
- Herkimer 789
- Monroe 789
- Montgomery 789
- Nassau 789
- Onondaga 789
- Ontario 789
- Clinton 788
- Rensselaer 788
- Sullivan 788
- Wyoming 788
- Chenango 787
- Essex 787
- …
state 1
- New York · 45,592 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2575 | 2575 | 2020-03-15 | New York City | New York | 330 | 5 | |
2576 | 2576 | 2020-03-15 | Orange | New York | 36071 | 6 | 0 |
2577 | 2577 | 2020-03-15 | Putnam | New York | 36079 | 2 | 0 |
2578 | 2578 | 2020-03-15 | Rockland | New York | 36087 | 13 | 1 |
2579 | 2579 | 2020-03-15 | Saratoga | New York | 36091 | 3 | 0 |
2580 | 2580 | 2020-03-15 | Schenectady | New York | 36093 | 2 | 0 |
2581 | 2581 | 2020-03-15 | Suffolk | New York | 36103 | 47 | 0 |
2582 | 2582 | 2020-03-15 | Tioga | New York | 36107 | 1 | 0 |
2583 | 2583 | 2020-03-15 | Tompkins | New York | 36109 | 1 | 0 |
2584 | 2584 | 2020-03-15 | Ulster | New York | 36111 | 5 | 0 |
2585 | 2585 | 2020-03-15 | Westchester | New York | 36119 | 195 | 0 |
3023 | 3023 | 2020-03-16 | Albany | New York | 36001 | 12 | 0 |
3024 | 3024 | 2020-03-16 | Allegany | New York | 36003 | 2 | 0 |
3025 | 3025 | 2020-03-16 | Broome | New York | 36007 | 1 | 0 |
3026 | 3026 | 2020-03-16 | Delaware | New York | 36025 | 1 | 0 |
3027 | 3027 | 2020-03-16 | Dutchess | New York | 36027 | 10 | 0 |
3028 | 3028 | 2020-03-16 | Erie | New York | 36029 | 6 | 0 |
3029 | 3029 | 2020-03-16 | Greene | New York | 36039 | 2 | 0 |
3030 | 3030 | 2020-03-16 | Herkimer | New York | 36043 | 1 | 0 |
3031 | 3031 | 2020-03-16 | Monroe | New York | 36055 | 10 | 0 |
3032 | 3032 | 2020-03-16 | Montgomery | New York | 36057 | 1 | 0 |
3033 | 3033 | 2020-03-16 | Nassau | New York | 36059 | 109 | 0 |
3034 | 3034 | 2020-03-16 | New York City | New York | 464 | 7 | |
3035 | 3035 | 2020-03-16 | Onondaga | New York | 36067 | 1 | 0 |
3036 | 3036 | 2020-03-16 | Ontario | New York | 36069 | 1 | 0 |
3037 | 3037 | 2020-03-16 | Orange | New York | 36071 | 11 | 0 |
3038 | 3038 | 2020-03-16 | Putnam | New York | 36079 | 2 | 0 |
3039 | 3039 | 2020-03-16 | Rockland | New York | 36087 | 16 | 1 |
3040 | 3040 | 2020-03-16 | Saratoga | New York | 36091 | 5 | 0 |
3041 | 3041 | 2020-03-16 | Schenectady | New York | 36093 | 4 | 0 |
3042 | 3042 | 2020-03-16 | Suffolk | New York | 36103 | 63 | 2 |
3043 | 3043 | 2020-03-16 | Tioga | New York | 36107 | 1 | 0 |
3044 | 3044 | 2020-03-16 | Tompkins | New York | 36109 | 1 | 0 |
3045 | 3045 | 2020-03-16 | Ulster | New York | 36111 | 7 | 0 |
3046 | 3046 | 2020-03-16 | Westchester | New York | 36119 | 219 | 0 |
3538 | 3538 | 2020-03-17 | Albany | New York | 36001 | 23 | 0 |
3539 | 3539 | 2020-03-17 | Allegany | New York | 36003 | 2 | 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 |
3543 | 3543 | 2020-03-17 | Dutchess | New York | 36027 | 16 | 0 |
3544 | 3544 | 2020-03-17 | Erie | New York | 36029 | 7 | 0 |
3545 | 3545 | 2020-03-17 | Greene | New York | 36039 | 2 | 0 |
3546 | 3546 | 2020-03-17 | Herkimer | New York | 36043 | 1 | 0 |
3547 | 3547 | 2020-03-17 | Monroe | New York | 36055 | 11 | 0 |
3548 | 3548 | 2020-03-17 | Montgomery | New York | 36057 | 1 | 0 |
3549 | 3549 | 2020-03-17 | Nassau | New York | 36059 | 131 | 2 |
3550 | 3550 | 2020-03-17 | New York City | New York | 646 | 11 | |
3551 | 3551 | 2020-03-17 | Onondaga | New York | 36067 | 2 | 0 |
3552 | 3552 | 2020-03-17 | Ontario | New York | 36069 | 1 | 0 |
3553 | 3553 | 2020-03-17 | Orange | New York | 36071 | 15 | 0 |
3554 | 3554 | 2020-03-17 | Putnam | New York | 36079 | 2 | 0 |
3555 | 3555 | 2020-03-17 | Rensselaer | New York | 36083 | 1 | 0 |
3556 | 3556 | 2020-03-17 | Rockland | New York | 36087 | 22 | 2 |
3557 | 3557 | 2020-03-17 | Saratoga | New York | 36091 | 9 | 0 |
3558 | 3558 | 2020-03-17 | Schenectady | New York | 36093 | 5 | 0 |
3559 | 3559 | 2020-03-17 | Suffolk | New York | 36103 | 84 | 3 |
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 |
3563 | 3563 | 2020-03-17 | Ulster | New York | 36111 | 8 | 0 |
3564 | 3564 | 2020-03-17 | Westchester | New York | 36119 | 379 | 0 |
3565 | 3565 | 2020-03-17 | Wyoming | New York | 36121 | 1 | 0 |
4134 | 4134 | 2020-03-18 | Albany | New York | 36001 | 36 | 0 |
4135 | 4135 | 2020-03-18 | Allegany | New York | 36003 | 2 | 0 |
4136 | 4136 | 2020-03-18 | Broome | New York | 36007 | 2 | 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 |
4140 | 4140 | 2020-03-18 | Dutchess | New York | 36027 | 20 | 0 |
4141 | 4141 | 2020-03-18 | Erie | New York | 36029 | 7 | 0 |
4142 | 4142 | 2020-03-18 | Essex | New York | 36031 | 1 | 0 |
4143 | 4143 | 2020-03-18 | Greene | New York | 36039 | 2 | 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 |
4148 | 4148 | 2020-03-18 | Monroe | New York | 36055 | 14 | 0 |
4149 | 4149 | 2020-03-18 | Montgomery | New York | 36057 | 1 | 0 |
4150 | 4150 | 2020-03-18 | Nassau | New York | 36059 | 183 | 2 |
4151 | 4151 | 2020-03-18 | New York City | New York | 1344 | 25 | |
4152 | 4152 | 2020-03-18 | Onondaga | New York | 36067 | 2 | 0 |
4153 | 4153 | 2020-03-18 | Ontario | New York | 36069 | 1 | 0 |
4154 | 4154 | 2020-03-18 | Orange | New York | 36071 | 32 | 0 |
4155 | 4155 | 2020-03-18 | Putnam | New York | 36079 | 2 | 0 |
4156 | 4156 | 2020-03-18 | Rensselaer | New York | 36083 | 4 | 0 |
4157 | 4157 | 2020-03-18 | Rockland | New York | 36087 | 30 | 2 |
4158 | 4158 | 2020-03-18 | Saratoga | New York | 36091 | 14 | 0 |
4159 | 4159 | 2020-03-18 | Schenectady | New York | 36093 | 14 | 0 |
4160 | 4160 | 2020-03-18 | Suffolk | New York | 36103 | 116 | 3 |
4161 | 4161 | 2020-03-18 | Sullivan | New York | 36105 | 1 | 0 |
4162 | 4162 | 2020-03-18 | Tioga | New York | 36107 | 1 | 0 |
4163 | 4163 | 2020-03-18 | Tompkins | New York | 36109 | 2 | 0 |
4164 | 4164 | 2020-03-18 | Ulster | New York | 36111 | 9 | 0 |
4165 | 4165 | 2020-03-18 | Warren | New York | 36113 | 1 | 0 |
4166 | 4166 | 2020-03-18 | Washington | New York | 36115 | 1 | 0 |
4167 | 4167 | 2020-03-18 | Westchester | New York | 36119 | 537 | 0 |
4168 | 4168 | 2020-03-18 | Wyoming | New York | 36121 | 1 | 0 |
4863 | 4863 | 2020-03-19 | Albany | New York | 36001 | 43 | 0 |
4864 | 4864 | 2020-03-19 | Allegany | New York | 36003 | 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);