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 county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
date (date) >30 ✖
- 2020-04-02 59
- 2020-04-03 59
- 2020-04-04 59
- 2020-04-05 59
- 2020-04-17 59
- 2020-04-18 59
- 2020-03-31 58
- 2020-04-01 58
- 2020-04-06 58
- 2020-04-07 58
- 2020-04-08 58
- 2020-04-09 58
- 2020-04-10 58
- 2020-04-11 58
- 2020-04-12 58
- 2020-04-13 58
- 2020-04-14 58
- 2020-04-15 58
- 2020-04-16 58
- 2020-04-19 58
- 2020-04-20 58
- 2020-04-21 58
- 2020-04-22 58
- 2020-04-23 58
- 2020-04-24 58
- 2020-04-25 58
- 2020-04-26 58
- 2020-04-27 58
- 2020-04-28 58
- 2020-04-29 58
- …
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 |
---|---|---|---|---|---|---|---|
27497 | 27497 | 2020-04-02 | Yates | New York | 36123 | 2 | 0 |
29821 | 29821 | 2020-04-03 | Yates | New York | 36123 | 2 | 0 |
32207 | 32207 | 2020-04-04 | Yates | New York | 36123 | 2 | 0 |
34638 | 34638 | 2020-04-05 | Yates | New York | 36123 | 2 | 0 |
37107 | 37107 | 2020-04-06 | Yates | New York | 36123 | 2 | 0 |
39622 | 39622 | 2020-04-07 | Yates | New York | 36123 | 2 | 0 |
42179 | 42179 | 2020-04-08 | Yates | New York | 36123 | 2 | 0 |
44762 | 44762 | 2020-04-09 | Yates | New York | 36123 | 1 | 0 |
47375 | 47375 | 2020-04-10 | Yates | New York | 36123 | 2 | 0 |
50030 | 50030 | 2020-04-11 | Yates | New York | 36123 | 2 | 0 |
52703 | 52703 | 2020-04-12 | Yates | New York | 36123 | 3 | 0 |
55386 | 55386 | 2020-04-13 | Yates | New York | 36123 | 4 | 0 |
58086 | 58086 | 2020-04-14 | Yates | New York | 36123 | 6 | 0 |
60800 | 60800 | 2020-04-15 | Yates | New York | 36123 | 6 | 0 |
63526 | 63526 | 2020-04-16 | Yates | New York | 36123 | 7 | 0 |
66269 | 66269 | 2020-04-17 | Yates | New York | 36123 | 8 | 0 |
69026 | 69026 | 2020-04-18 | Yates | New York | 36123 | 9 | 0 |
71792 | 71792 | 2020-04-19 | Yates | New York | 36123 | 9 | 0 |
74567 | 74567 | 2020-04-20 | Yates | New York | 36123 | 10 | 0 |
77348 | 77348 | 2020-04-21 | Yates | New York | 36123 | 10 | 0 |
80137 | 80137 | 2020-04-22 | Yates | New York | 36123 | 11 | 1 |
82936 | 82936 | 2020-04-23 | Yates | New York | 36123 | 11 | 1 |
85740 | 85740 | 2020-04-24 | Yates | New York | 36123 | 11 | 1 |
88552 | 88552 | 2020-04-25 | Yates | New York | 36123 | 16 | 1 |
91367 | 91367 | 2020-04-26 | Yates | New York | 36123 | 17 | 1 |
94192 | 94192 | 2020-04-27 | Yates | New York | 36123 | 17 | 1 |
97028 | 97028 | 2020-04-28 | Yates | New York | 36123 | 17 | 1 |
99875 | 99875 | 2020-04-29 | Yates | New York | 36123 | 17 | 1 |
102728 | 102728 | 2020-04-30 | Yates | New York | 36123 | 18 | 1 |
105590 | 105590 | 2020-05-01 | Yates | New York | 36123 | 18 | 1 |
108457 | 108457 | 2020-05-02 | Yates | New York | 36123 | 18 | 1 |
111330 | 111330 | 2020-05-03 | Yates | New York | 36123 | 19 | 1 |
114211 | 114211 | 2020-05-04 | Yates | New York | 36123 | 19 | 1 |
117091 | 117091 | 2020-05-05 | Yates | New York | 36123 | 19 | 2 |
120052 | 120052 | 2020-05-06 | Yates | New York | 36123 | 19 | 3 |
123027 | 123027 | 2020-05-07 | Yates | New York | 36123 | 19 | 3 |
126010 | 126010 | 2020-05-08 | Yates | New York | 36123 | 20 | 3 |
128999 | 128999 | 2020-05-09 | Yates | New York | 36123 | 20 | 3 |
131988 | 131988 | 2020-05-10 | Yates | New York | 36123 | 21 | 3 |
134979 | 134979 | 2020-05-11 | Yates | New York | 36123 | 21 | 4 |
137969 | 137969 | 2020-05-12 | Yates | New York | 36123 | 21 | 4 |
140965 | 140965 | 2020-05-13 | Yates | New York | 36123 | 22 | 4 |
143960 | 143960 | 2020-05-14 | Yates | New York | 36123 | 22 | 4 |
146961 | 146961 | 2020-05-15 | Yates | New York | 36123 | 22 | 4 |
149968 | 149968 | 2020-05-16 | Yates | New York | 36123 | 22 | 5 |
152978 | 152978 | 2020-05-17 | Yates | New York | 36123 | 23 | 5 |
155995 | 155995 | 2020-05-18 | Yates | New York | 36123 | 25 | 5 |
159013 | 159013 | 2020-05-19 | Yates | New York | 36123 | 26 | 5 |
162040 | 162040 | 2020-05-20 | Yates | New York | 36123 | 34 | 5 |
165069 | 165069 | 2020-05-21 | Yates | New York | 36123 | 34 | 6 |
168104 | 168104 | 2020-05-22 | Yates | New York | 36123 | 34 | 6 |
171143 | 171143 | 2020-05-23 | Yates | New York | 36123 | 37 | 6 |
174185 | 174185 | 2020-05-24 | Yates | New York | 36123 | 37 | 6 |
177229 | 177229 | 2020-05-25 | Yates | New York | 36123 | 37 | 6 |
180272 | 180272 | 2020-05-26 | Yates | New York | 36123 | 37 | 6 |
183320 | 183320 | 2020-05-27 | Yates | New York | 36123 | 39 | 6 |
186377 | 186377 | 2020-05-28 | Yates | New York | 36123 | 39 | 6 |
189437 | 189437 | 2020-05-29 | Yates | New York | 36123 | 39 | 6 |
192501 | 192501 | 2020-05-30 | Yates | New York | 36123 | 39 | 6 |
195571 | 195571 | 2020-05-31 | Yates | New York | 36123 | 39 | 6 |
198644 | 198644 | 2020-06-01 | Yates | New York | 36123 | 39 | 6 |
201718 | 201718 | 2020-06-02 | Yates | New York | 36123 | 39 | 6 |
204795 | 204795 | 2020-06-03 | Yates | New York | 36123 | 39 | 6 |
207876 | 207876 | 2020-06-04 | Yates | New York | 36123 | 39 | 6 |
210958 | 210958 | 2020-06-05 | Yates | New York | 36123 | 39 | 6 |
214042 | 214042 | 2020-06-06 | Yates | New York | 36123 | 39 | 6 |
217132 | 217132 | 2020-06-07 | Yates | New York | 36123 | 39 | 6 |
220224 | 220224 | 2020-06-08 | Yates | New York | 36123 | 39 | 6 |
223318 | 223318 | 2020-06-09 | Yates | New York | 36123 | 39 | 6 |
226418 | 226418 | 2020-06-10 | Yates | New York | 36123 | 39 | 6 |
229522 | 229522 | 2020-06-11 | Yates | New York | 36123 | 39 | 6 |
232627 | 232627 | 2020-06-12 | Yates | New York | 36123 | 39 | 6 |
235732 | 235732 | 2020-06-13 | Yates | New York | 36123 | 39 | 6 |
238840 | 238840 | 2020-06-14 | Yates | New York | 36123 | 40 | 6 |
241949 | 241949 | 2020-06-15 | Yates | New York | 36123 | 40 | 6 |
245061 | 245061 | 2020-06-16 | Yates | New York | 36123 | 40 | 6 |
248174 | 248174 | 2020-06-17 | Yates | New York | 36123 | 40 | 6 |
251289 | 251289 | 2020-06-18 | Yates | New York | 36123 | 40 | 6 |
254404 | 254404 | 2020-06-19 | Yates | New York | 36123 | 40 | 6 |
257527 | 257527 | 2020-06-20 | Yates | New York | 36123 | 41 | 6 |
260654 | 260654 | 2020-06-21 | Yates | New York | 36123 | 41 | 6 |
263782 | 263782 | 2020-06-22 | Yates | New York | 36123 | 42 | 6 |
266910 | 266910 | 2020-06-23 | Yates | New York | 36123 | 43 | 6 |
270044 | 270044 | 2020-06-24 | Yates | New York | 36123 | 44 | 6 |
273183 | 273183 | 2020-06-25 | Yates | New York | 36123 | 44 | 6 |
276329 | 276329 | 2020-06-26 | Yates | New York | 36123 | 45 | 6 |
279477 | 279477 | 2020-06-27 | Yates | New York | 36123 | 45 | 6 |
282623 | 282623 | 2020-06-28 | Yates | New York | 36123 | 45 | 6 |
285768 | 285768 | 2020-06-29 | Yates | New York | 36123 | 46 | 6 |
288918 | 288918 | 2020-06-30 | Yates | New York | 36123 | 46 | 6 |
292070 | 292070 | 2020-07-01 | Yates | New York | 36123 | 46 | 6 |
295225 | 295225 | 2020-07-02 | Yates | New York | 36123 | 46 | 6 |
298385 | 298385 | 2020-07-03 | Yates | New York | 36123 | 46 | 6 |
301548 | 301548 | 2020-07-04 | Yates | New York | 36123 | 48 | 6 |
304711 | 304711 | 2020-07-05 | Yates | New York | 36123 | 48 | 6 |
307878 | 307878 | 2020-07-06 | Yates | New York | 36123 | 48 | 6 |
311046 | 311046 | 2020-07-07 | Yates | New York | 36123 | 48 | 6 |
314217 | 314217 | 2020-07-08 | Yates | New York | 36123 | 48 | 6 |
317391 | 317391 | 2020-07-09 | Yates | New York | 36123 | 48 | 6 |
320568 | 320568 | 2020-07-10 | Yates | New York | 36123 | 48 | 6 |
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);