ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 36073 and state = "New York" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
10329 | 10329 | 2020-03-24 | Orleans | New York | 36073 | 2 | 0 |
11765 | 11765 | 2020-03-25 | Orleans | New York | 36073 | 2 | 0 |
13368 | 13368 | 2020-03-26 | Orleans | New York | 36073 | 2 | 0 |
15102 | 15102 | 2020-03-27 | Orleans | New York | 36073 | 3 | 0 |
16932 | 16932 | 2020-03-28 | Orleans | New York | 36073 | 3 | 0 |
18857 | 18857 | 2020-03-29 | Orleans | New York | 36073 | 3 | 0 |
20896 | 20896 | 2020-03-30 | Orleans | New York | 36073 | 4 | 0 |
23019 | 23019 | 2020-03-31 | Orleans | New York | 36073 | 6 | 0 |
25213 | 25213 | 2020-04-01 | Orleans | New York | 36073 | 6 | 0 |
27473 | 27473 | 2020-04-02 | Orleans | New York | 36073 | 6 | 0 |
29797 | 29797 | 2020-04-03 | Orleans | New York | 36073 | 6 | 0 |
32183 | 32183 | 2020-04-04 | Orleans | New York | 36073 | 10 | 0 |
34614 | 34614 | 2020-04-05 | Orleans | New York | 36073 | 11 | 0 |
37084 | 37084 | 2020-04-06 | Orleans | New York | 36073 | 13 | 0 |
39599 | 39599 | 2020-04-07 | Orleans | New York | 36073 | 15 | 0 |
42156 | 42156 | 2020-04-08 | Orleans | New York | 36073 | 16 | 0 |
44739 | 44739 | 2020-04-09 | Orleans | New York | 36073 | 22 | 0 |
47352 | 47352 | 2020-04-10 | Orleans | New York | 36073 | 24 | 0 |
50007 | 50007 | 2020-04-11 | Orleans | New York | 36073 | 24 | 0 |
52680 | 52680 | 2020-04-12 | Orleans | New York | 36073 | 25 | 0 |
55363 | 55363 | 2020-04-13 | Orleans | New York | 36073 | 26 | 0 |
58063 | 58063 | 2020-04-14 | Orleans | New York | 36073 | 31 | 0 |
60777 | 60777 | 2020-04-15 | Orleans | New York | 36073 | 33 | 0 |
63503 | 63503 | 2020-04-16 | Orleans | New York | 36073 | 34 | 0 |
66245 | 66245 | 2020-04-17 | Orleans | New York | 36073 | 34 | 0 |
69002 | 69002 | 2020-04-18 | Orleans | New York | 36073 | 41 | 0 |
71769 | 71769 | 2020-04-19 | Orleans | New York | 36073 | 46 | 1 |
74544 | 74544 | 2020-04-20 | Orleans | New York | 36073 | 46 | 1 |
77325 | 77325 | 2020-04-21 | Orleans | New York | 36073 | 53 | 1 |
80114 | 80114 | 2020-04-22 | Orleans | New York | 36073 | 56 | 1 |
82913 | 82913 | 2020-04-23 | Orleans | New York | 36073 | 59 | 2 |
85717 | 85717 | 2020-04-24 | Orleans | New York | 36073 | 60 | 2 |
88529 | 88529 | 2020-04-25 | Orleans | New York | 36073 | 75 | 3 |
91344 | 91344 | 2020-04-26 | Orleans | New York | 36073 | 80 | 4 |
94169 | 94169 | 2020-04-27 | Orleans | New York | 36073 | 80 | 4 |
97005 | 97005 | 2020-04-28 | Orleans | New York | 36073 | 80 | 5 |
99852 | 99852 | 2020-04-29 | Orleans | New York | 36073 | 85 | 5 |
102705 | 102705 | 2020-04-30 | Orleans | New York | 36073 | 89 | 5 |
105567 | 105567 | 2020-05-01 | Orleans | New York | 36073 | 92 | 5 |
108434 | 108434 | 2020-05-02 | Orleans | New York | 36073 | 93 | 6 |
111307 | 111307 | 2020-05-03 | Orleans | New York | 36073 | 97 | 6 |
114188 | 114188 | 2020-05-04 | Orleans | New York | 36073 | 97 | 6 |
117068 | 117068 | 2020-05-05 | Orleans | New York | 36073 | 99 | 6 |
120029 | 120029 | 2020-05-06 | Orleans | New York | 36073 | 103 | 12 |
123004 | 123004 | 2020-05-07 | Orleans | New York | 36073 | 108 | 13 |
125987 | 125987 | 2020-05-08 | Orleans | New York | 36073 | 121 | 14 |
128976 | 128976 | 2020-05-09 | Orleans | New York | 36073 | 122 | 14 |
131965 | 131965 | 2020-05-10 | Orleans | New York | 36073 | 126 | 15 |
134956 | 134956 | 2020-05-11 | Orleans | New York | 36073 | 130 | 15 |
137946 | 137946 | 2020-05-12 | Orleans | New York | 36073 | 133 | 15 |
140942 | 140942 | 2020-05-13 | Orleans | New York | 36073 | 142 | 16 |
143937 | 143937 | 2020-05-14 | Orleans | New York | 36073 | 145 | 17 |
146938 | 146938 | 2020-05-15 | Orleans | New York | 36073 | 147 | 17 |
149945 | 149945 | 2020-05-16 | Orleans | New York | 36073 | 163 | 17 |
152955 | 152955 | 2020-05-17 | Orleans | New York | 36073 | 167 | 18 |
155972 | 155972 | 2020-05-18 | Orleans | New York | 36073 | 167 | 18 |
158990 | 158990 | 2020-05-19 | Orleans | New York | 36073 | 168 | 18 |
162017 | 162017 | 2020-05-20 | Orleans | New York | 36073 | 171 | 18 |
165046 | 165046 | 2020-05-21 | Orleans | New York | 36073 | 174 | 19 |
168081 | 168081 | 2020-05-22 | Orleans | New York | 36073 | 175 | 19 |
171120 | 171120 | 2020-05-23 | Orleans | New York | 36073 | 196 | 20 |
174162 | 174162 | 2020-05-24 | Orleans | New York | 36073 | 202 | 23 |
177206 | 177206 | 2020-05-25 | Orleans | New York | 36073 | 205 | 23 |
180249 | 180249 | 2020-05-26 | Orleans | New York | 36073 | 208 | 24 |
183297 | 183297 | 2020-05-27 | Orleans | New York | 36073 | 210 | 24 |
186354 | 186354 | 2020-05-28 | Orleans | New York | 36073 | 212 | 24 |
189414 | 189414 | 2020-05-29 | Orleans | New York | 36073 | 216 | 24 |
192478 | 192478 | 2020-05-30 | Orleans | New York | 36073 | 228 | 26 |
195548 | 195548 | 2020-05-31 | Orleans | New York | 36073 | 229 | 26 |
198621 | 198621 | 2020-06-01 | Orleans | New York | 36073 | 236 | 26 |
201695 | 201695 | 2020-06-02 | Orleans | New York | 36073 | 241 | 26 |
204772 | 204772 | 2020-06-03 | Orleans | New York | 36073 | 246 | 27 |
207853 | 207853 | 2020-06-04 | Orleans | New York | 36073 | 247 | 29 |
210935 | 210935 | 2020-06-05 | Orleans | New York | 36073 | 247 | 29 |
214019 | 214019 | 2020-06-06 | Orleans | New York | 36073 | 254 | 29 |
217109 | 217109 | 2020-06-07 | Orleans | New York | 36073 | 255 | 29 |
220201 | 220201 | 2020-06-08 | Orleans | New York | 36073 | 256 | 30 |
223295 | 223295 | 2020-06-09 | Orleans | New York | 36073 | 257 | 33 |
226395 | 226395 | 2020-06-10 | Orleans | New York | 36073 | 259 | 35 |
229499 | 229499 | 2020-06-11 | Orleans | New York | 36073 | 260 | 35 |
232604 | 232604 | 2020-06-12 | Orleans | New York | 36073 | 260 | 36 |
235709 | 235709 | 2020-06-13 | Orleans | New York | 36073 | 261 | 36 |
238817 | 238817 | 2020-06-14 | Orleans | New York | 36073 | 267 | 36 |
241926 | 241926 | 2020-06-15 | Orleans | New York | 36073 | 268 | 36 |
245038 | 245038 | 2020-06-16 | Orleans | New York | 36073 | 268 | 36 |
248151 | 248151 | 2020-06-17 | Orleans | New York | 36073 | 270 | 36 |
251266 | 251266 | 2020-06-18 | Orleans | New York | 36073 | 271 | 37 |
254381 | 254381 | 2020-06-19 | Orleans | New York | 36073 | 274 | 37 |
257504 | 257504 | 2020-06-20 | Orleans | New York | 36073 | 275 | 37 |
260631 | 260631 | 2020-06-21 | Orleans | New York | 36073 | 276 | 37 |
263759 | 263759 | 2020-06-22 | Orleans | New York | 36073 | 276 | 37 |
266887 | 266887 | 2020-06-23 | Orleans | New York | 36073 | 277 | 38 |
270021 | 270021 | 2020-06-24 | Orleans | New York | 36073 | 277 | 38 |
273160 | 273160 | 2020-06-25 | Orleans | New York | 36073 | 279 | 38 |
276306 | 276306 | 2020-06-26 | Orleans | New York | 36073 | 279 | 39 |
279454 | 279454 | 2020-06-27 | Orleans | New York | 36073 | 280 | 40 |
282600 | 282600 | 2020-06-28 | Orleans | New York | 36073 | 281 | 40 |
285745 | 285745 | 2020-06-29 | Orleans | New York | 36073 | 281 | 41 |
288895 | 288895 | 2020-06-30 | Orleans | New York | 36073 | 281 | 41 |
292047 | 292047 | 2020-07-01 | Orleans | New York | 36073 | 281 | 41 |
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);