ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36031 and state = "New York" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4142 | 4142 | 2020-03-18 | Essex | New York | 36031 | 1 | 0 |
4871 | 4871 | 2020-03-19 | Essex | New York | 36031 | 1 | 0 |
5718 | 5718 | 2020-03-20 | Essex | New York | 36031 | 1 | 0 |
6712 | 6712 | 2020-03-21 | Essex | New York | 36031 | 2 | 0 |
7806 | 7806 | 2020-03-22 | Essex | New York | 36031 | 3 | 0 |
9004 | 9004 | 2020-03-23 | Essex | New York | 36031 | 3 | 0 |
10311 | 10311 | 2020-03-24 | Essex | New York | 36031 | 3 | 0 |
11746 | 11746 | 2020-03-25 | Essex | New York | 36031 | 4 | 0 |
13349 | 13349 | 2020-03-26 | Essex | New York | 36031 | 4 | 0 |
15083 | 15083 | 2020-03-27 | Essex | New York | 36031 | 4 | 0 |
16913 | 16913 | 2020-03-28 | Essex | New York | 36031 | 4 | 0 |
18837 | 18837 | 2020-03-29 | Essex | New York | 36031 | 4 | 0 |
20876 | 20876 | 2020-03-30 | Essex | New York | 36031 | 5 | 0 |
22999 | 22999 | 2020-03-31 | Essex | New York | 36031 | 5 | 0 |
25193 | 25193 | 2020-04-01 | Essex | New York | 36031 | 6 | 0 |
27453 | 27453 | 2020-04-02 | Essex | New York | 36031 | 6 | 0 |
29777 | 29777 | 2020-04-03 | Essex | New York | 36031 | 6 | 0 |
32163 | 32163 | 2020-04-04 | Essex | New York | 36031 | 7 | 0 |
34594 | 34594 | 2020-04-05 | Essex | New York | 36031 | 7 | 0 |
37064 | 37064 | 2020-04-06 | Essex | New York | 36031 | 7 | 0 |
39579 | 39579 | 2020-04-07 | Essex | New York | 36031 | 7 | 0 |
42136 | 42136 | 2020-04-08 | Essex | New York | 36031 | 7 | 0 |
44719 | 44719 | 2020-04-09 | Essex | New York | 36031 | 8 | 0 |
47332 | 47332 | 2020-04-10 | Essex | New York | 36031 | 10 | 0 |
49987 | 49987 | 2020-04-11 | Essex | New York | 36031 | 12 | 0 |
52660 | 52660 | 2020-04-12 | Essex | New York | 36031 | 12 | 0 |
55343 | 55343 | 2020-04-13 | Essex | New York | 36031 | 12 | 0 |
58043 | 58043 | 2020-04-14 | Essex | New York | 36031 | 12 | 0 |
60757 | 60757 | 2020-04-15 | Essex | New York | 36031 | 12 | 0 |
63483 | 63483 | 2020-04-16 | Essex | New York | 36031 | 12 | 0 |
66225 | 66225 | 2020-04-17 | Essex | New York | 36031 | 15 | 0 |
68982 | 68982 | 2020-04-18 | Essex | New York | 36031 | 22 | 0 |
82893 | 82893 | 2020-04-23 | Essex | New York | 36031 | 22 | 0 |
71749 | 71749 | 2020-04-19 | Essex | New York | 36031 | 24 | 0 |
74524 | 74524 | 2020-04-20 | Essex | New York | 36031 | 26 | 0 |
77305 | 77305 | 2020-04-21 | Essex | New York | 36031 | 27 | 0 |
80094 | 80094 | 2020-04-22 | Essex | New York | 36031 | 28 | 0 |
85697 | 85697 | 2020-04-24 | Essex | New York | 36031 | 28 | 0 |
88509 | 88509 | 2020-04-25 | Essex | New York | 36031 | 30 | 0 |
91324 | 91324 | 2020-04-26 | Essex | New York | 36031 | 30 | 0 |
94149 | 94149 | 2020-04-27 | Essex | New York | 36031 | 30 | 0 |
96985 | 96985 | 2020-04-28 | Essex | New York | 36031 | 32 | 0 |
99832 | 99832 | 2020-04-29 | Essex | New York | 36031 | 33 | 0 |
102685 | 102685 | 2020-04-30 | Essex | New York | 36031 | 34 | 0 |
105547 | 105547 | 2020-05-01 | Essex | New York | 36031 | 34 | 0 |
108414 | 108414 | 2020-05-02 | Essex | New York | 36031 | 34 | 0 |
111287 | 111287 | 2020-05-03 | Essex | New York | 36031 | 35 | 0 |
114168 | 114168 | 2020-05-04 | Essex | New York | 36031 | 35 | 0 |
117048 | 117048 | 2020-05-05 | Essex | New York | 36031 | 38 | 0 |
120009 | 120009 | 2020-05-06 | Essex | New York | 36031 | 38 | 0 |
122984 | 122984 | 2020-05-07 | Essex | New York | 36031 | 38 | 0 |
125967 | 125967 | 2020-05-08 | Essex | New York | 36031 | 39 | 0 |
128956 | 128956 | 2020-05-09 | Essex | New York | 36031 | 39 | 0 |
131945 | 131945 | 2020-05-10 | Essex | New York | 36031 | 40 | 0 |
134936 | 134936 | 2020-05-11 | Essex | New York | 36031 | 40 | 0 |
137926 | 137926 | 2020-05-12 | Essex | New York | 36031 | 40 | 0 |
140922 | 140922 | 2020-05-13 | Essex | New York | 36031 | 40 | 0 |
143917 | 143917 | 2020-05-14 | Essex | New York | 36031 | 40 | 0 |
146918 | 146918 | 2020-05-15 | Essex | New York | 36031 | 40 | 0 |
149925 | 149925 | 2020-05-16 | Essex | New York | 36031 | 40 | 0 |
152935 | 152935 | 2020-05-17 | Essex | New York | 36031 | 41 | 0 |
155952 | 155952 | 2020-05-18 | Essex | New York | 36031 | 41 | 0 |
158970 | 158970 | 2020-05-19 | Essex | New York | 36031 | 42 | 0 |
161997 | 161997 | 2020-05-20 | Essex | New York | 36031 | 42 | 0 |
165026 | 165026 | 2020-05-21 | Essex | New York | 36031 | 44 | 0 |
168061 | 168061 | 2020-05-22 | Essex | New York | 36031 | 44 | 0 |
171100 | 171100 | 2020-05-23 | Essex | New York | 36031 | 44 | 0 |
174142 | 174142 | 2020-05-24 | Essex | New York | 36031 | 44 | 0 |
177186 | 177186 | 2020-05-25 | Essex | New York | 36031 | 44 | 0 |
180229 | 180229 | 2020-05-26 | Essex | New York | 36031 | 44 | 0 |
183277 | 183277 | 2020-05-27 | Essex | New York | 36031 | 44 | 0 |
186334 | 186334 | 2020-05-28 | Essex | New York | 36031 | 44 | 0 |
189394 | 189394 | 2020-05-29 | Essex | New York | 36031 | 44 | 0 |
192458 | 192458 | 2020-05-30 | Essex | New York | 36031 | 44 | 0 |
195528 | 195528 | 2020-05-31 | Essex | New York | 36031 | 45 | 0 |
198601 | 198601 | 2020-06-01 | Essex | New York | 36031 | 45 | 0 |
201675 | 201675 | 2020-06-02 | Essex | New York | 36031 | 46 | 0 |
204752 | 204752 | 2020-06-03 | Essex | New York | 36031 | 46 | 0 |
207833 | 207833 | 2020-06-04 | Essex | New York | 36031 | 46 | 0 |
210915 | 210915 | 2020-06-05 | Essex | New York | 36031 | 46 | 0 |
213999 | 213999 | 2020-06-06 | Essex | New York | 36031 | 46 | 0 |
217089 | 217089 | 2020-06-07 | Essex | New York | 36031 | 46 | 0 |
220181 | 220181 | 2020-06-08 | Essex | New York | 36031 | 47 | 0 |
223275 | 223275 | 2020-06-09 | Essex | New York | 36031 | 48 | 0 |
226375 | 226375 | 2020-06-10 | Essex | New York | 36031 | 48 | 0 |
229479 | 229479 | 2020-06-11 | Essex | New York | 36031 | 48 | 0 |
232584 | 232584 | 2020-06-12 | Essex | New York | 36031 | 48 | 0 |
235689 | 235689 | 2020-06-13 | Essex | New York | 36031 | 48 | 0 |
238797 | 238797 | 2020-06-14 | Essex | New York | 36031 | 48 | 0 |
241906 | 241906 | 2020-06-15 | Essex | New York | 36031 | 48 | 0 |
245018 | 245018 | 2020-06-16 | Essex | New York | 36031 | 48 | 0 |
248131 | 248131 | 2020-06-17 | Essex | New York | 36031 | 48 | 0 |
251246 | 251246 | 2020-06-18 | Essex | New York | 36031 | 48 | 0 |
254361 | 254361 | 2020-06-19 | Essex | New York | 36031 | 48 | 0 |
257484 | 257484 | 2020-06-20 | Essex | New York | 36031 | 49 | 0 |
260611 | 260611 | 2020-06-21 | Essex | New York | 36031 | 49 | 0 |
263739 | 263739 | 2020-06-22 | Essex | New York | 36031 | 49 | 0 |
266867 | 266867 | 2020-06-23 | Essex | New York | 36031 | 49 | 0 |
270001 | 270001 | 2020-06-24 | Essex | New York | 36031 | 49 | 0 |
273140 | 273140 | 2020-06-25 | Essex | New York | 36031 | 49 | 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);