ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Onondaga" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387794 | 387794 | 2020-07-31 | Onondaga | New York | 36067 | 3464 | 188 |
384577 | 384577 | 2020-07-30 | Onondaga | New York | 36067 | 3459 | 187 |
381359 | 381359 | 2020-07-29 | Onondaga | New York | 36067 | 3437 | 187 |
378142 | 378142 | 2020-07-28 | Onondaga | New York | 36067 | 3419 | 187 |
374926 | 374926 | 2020-07-27 | Onondaga | New York | 36067 | 3398 | 186 |
371714 | 371714 | 2020-07-26 | Onondaga | New York | 36067 | 3389 | 185 |
368502 | 368502 | 2020-07-25 | Onondaga | New York | 36067 | 3378 | 185 |
365293 | 365293 | 2020-07-24 | Onondaga | New York | 36067 | 3360 | 185 |
362087 | 362087 | 2020-07-23 | Onondaga | New York | 36067 | 3344 | 185 |
358881 | 358881 | 2020-07-22 | Onondaga | New York | 36067 | 3326 | 183 |
355677 | 355677 | 2020-07-21 | Onondaga | New York | 36067 | 3312 | 183 |
352474 | 352474 | 2020-07-20 | Onondaga | New York | 36067 | 3290 | 183 |
349271 | 349271 | 2020-07-19 | Onondaga | New York | 36067 | 3278 | 182 |
346070 | 346070 | 2020-07-18 | Onondaga | New York | 36067 | 3262 | 182 |
342871 | 342871 | 2020-07-17 | Onondaga | New York | 36067 | 3240 | 181 |
339673 | 339673 | 2020-07-16 | Onondaga | New York | 36067 | 3225 | 180 |
336477 | 336477 | 2020-07-15 | Onondaga | New York | 36067 | 3203 | 183 |
333283 | 333283 | 2020-07-14 | Onondaga | New York | 36067 | 3179 | 183 |
330093 | 330093 | 2020-07-13 | Onondaga | New York | 36067 | 3142 | 183 |
326906 | 326906 | 2020-07-12 | Onondaga | New York | 36067 | 3124 | 182 |
323722 | 323722 | 2020-07-11 | Onondaga | New York | 36067 | 3100 | 182 |
320542 | 320542 | 2020-07-10 | Onondaga | New York | 36067 | 3078 | 180 |
317365 | 317365 | 2020-07-09 | Onondaga | New York | 36067 | 3050 | 180 |
314191 | 314191 | 2020-07-08 | Onondaga | New York | 36067 | 3029 | 180 |
311020 | 311020 | 2020-07-07 | Onondaga | New York | 36067 | 2997 | 180 |
307852 | 307852 | 2020-07-06 | Onondaga | New York | 36067 | 2963 | 180 |
304685 | 304685 | 2020-07-05 | Onondaga | New York | 36067 | 2949 | 180 |
301522 | 301522 | 2020-07-04 | Onondaga | New York | 36067 | 2928 | 180 |
298359 | 298359 | 2020-07-03 | Onondaga | New York | 36067 | 2909 | 178 |
295199 | 295199 | 2020-07-02 | Onondaga | New York | 36067 | 2897 | 178 |
292044 | 292044 | 2020-07-01 | Onondaga | New York | 36067 | 2863 | 178 |
288892 | 288892 | 2020-06-30 | Onondaga | New York | 36067 | 2842 | 178 |
285742 | 285742 | 2020-06-29 | Onondaga | New York | 36067 | 2822 | 176 |
282597 | 282597 | 2020-06-28 | Onondaga | New York | 36067 | 2816 | 175 |
279451 | 279451 | 2020-06-27 | Onondaga | New York | 36067 | 2791 | 175 |
276303 | 276303 | 2020-06-26 | Onondaga | New York | 36067 | 2782 | 175 |
273157 | 273157 | 2020-06-25 | Onondaga | New York | 36067 | 2751 | 174 |
270018 | 270018 | 2020-06-24 | Onondaga | New York | 36067 | 2734 | 174 |
266884 | 266884 | 2020-06-23 | Onondaga | New York | 36067 | 2702 | 171 |
263756 | 263756 | 2020-06-22 | Onondaga | New York | 36067 | 2675 | 170 |
260628 | 260628 | 2020-06-21 | Onondaga | New York | 36067 | 2666 | 170 |
257501 | 257501 | 2020-06-20 | Onondaga | New York | 36067 | 2644 | 170 |
254378 | 254378 | 2020-06-19 | Onondaga | New York | 36067 | 2634 | 168 |
251263 | 251263 | 2020-06-18 | Onondaga | New York | 36067 | 2615 | 168 |
248148 | 248148 | 2020-06-17 | Onondaga | New York | 36067 | 2558 | 166 |
245035 | 245035 | 2020-06-16 | Onondaga | New York | 36067 | 2545 | 166 |
241923 | 241923 | 2020-06-15 | Onondaga | New York | 36067 | 2531 | 165 |
238814 | 238814 | 2020-06-14 | Onondaga | New York | 36067 | 2519 | 161 |
235706 | 235706 | 2020-06-13 | Onondaga | New York | 36067 | 2498 | 159 |
232601 | 232601 | 2020-06-12 | Onondaga | New York | 36067 | 2474 | 158 |
229496 | 229496 | 2020-06-11 | Onondaga | New York | 36067 | 2454 | 156 |
226392 | 226392 | 2020-06-10 | Onondaga | New York | 36067 | 2433 | 153 |
223292 | 223292 | 2020-06-09 | Onondaga | New York | 36067 | 2427 | 151 |
220198 | 220198 | 2020-06-08 | Onondaga | New York | 36067 | 2408 | 149 |
217106 | 217106 | 2020-06-07 | Onondaga | New York | 36067 | 2392 | 148 |
214016 | 214016 | 2020-06-06 | Onondaga | New York | 36067 | 2375 | 147 |
210932 | 210932 | 2020-06-05 | Onondaga | New York | 36067 | 2329 | 143 |
207850 | 207850 | 2020-06-04 | Onondaga | New York | 36067 | 2295 | 142 |
204769 | 204769 | 2020-06-03 | Onondaga | New York | 36067 | 2256 | 141 |
201692 | 201692 | 2020-06-02 | Onondaga | New York | 36067 | 2228 | 138 |
198618 | 198618 | 2020-06-01 | Onondaga | New York | 36067 | 2197 | 132 |
195545 | 195545 | 2020-05-31 | Onondaga | New York | 36067 | 2170 | 130 |
192475 | 192475 | 2020-05-30 | Onondaga | New York | 36067 | 2133 | 128 |
189411 | 189411 | 2020-05-29 | Onondaga | New York | 36067 | 2092 | 126 |
186351 | 186351 | 2020-05-28 | Onondaga | New York | 36067 | 2054 | 123 |
183294 | 183294 | 2020-05-27 | Onondaga | New York | 36067 | 2033 | 121 |
180246 | 180246 | 2020-05-26 | Onondaga | New York | 36067 | 2012 | 118 |
177203 | 177203 | 2020-05-25 | Onondaga | New York | 36067 | 1981 | 113 |
174159 | 174159 | 2020-05-24 | Onondaga | New York | 36067 | 1953 | 112 |
171117 | 171117 | 2020-05-23 | Onondaga | New York | 36067 | 1904 | 106 |
168078 | 168078 | 2020-05-22 | Onondaga | New York | 36067 | 1828 | 105 |
165043 | 165043 | 2020-05-21 | Onondaga | New York | 36067 | 1771 | 102 |
162014 | 162014 | 2020-05-20 | Onondaga | New York | 36067 | 1718 | 99 |
158987 | 158987 | 2020-05-19 | Onondaga | New York | 36067 | 1665 | 99 |
155969 | 155969 | 2020-05-18 | Onondaga | New York | 36067 | 1520 | 97 |
152952 | 152952 | 2020-05-17 | Onondaga | New York | 36067 | 1501 | 95 |
149942 | 149942 | 2020-05-16 | Onondaga | New York | 36067 | 1469 | 91 |
146935 | 146935 | 2020-05-15 | Onondaga | New York | 36067 | 1440 | 82 |
143934 | 143934 | 2020-05-14 | Onondaga | New York | 36067 | 1423 | 77 |
140939 | 140939 | 2020-05-13 | Onondaga | New York | 36067 | 1395 | 73 |
137943 | 137943 | 2020-05-12 | Onondaga | New York | 36067 | 1308 | 69 |
134953 | 134953 | 2020-05-11 | Onondaga | New York | 36067 | 1287 | 65 |
131962 | 131962 | 2020-05-10 | Onondaga | New York | 36067 | 1265 | 64 |
128973 | 128973 | 2020-05-09 | Onondaga | New York | 36067 | 1218 | 61 |
125984 | 125984 | 2020-05-08 | Onondaga | New York | 36067 | 1169 | 57 |
123001 | 123001 | 2020-05-07 | Onondaga | New York | 36067 | 1115 | 54 |
120026 | 120026 | 2020-05-06 | Onondaga | New York | 36067 | 1056 | 53 |
117065 | 117065 | 2020-05-05 | Onondaga | New York | 36067 | 1002 | 44 |
114185 | 114185 | 2020-05-04 | Onondaga | New York | 36067 | 971 | 43 |
111304 | 111304 | 2020-05-03 | Onondaga | New York | 36067 | 952 | 42 |
108431 | 108431 | 2020-05-02 | Onondaga | New York | 36067 | 903 | 38 |
105564 | 105564 | 2020-05-01 | Onondaga | New York | 36067 | 860 | 37 |
102702 | 102702 | 2020-04-30 | Onondaga | New York | 36067 | 832 | 35 |
99849 | 99849 | 2020-04-29 | Onondaga | New York | 36067 | 782 | 33 |
97002 | 97002 | 2020-04-28 | Onondaga | New York | 36067 | 742 | 31 |
94166 | 94166 | 2020-04-27 | Onondaga | New York | 36067 | 726 | 30 |
91341 | 91341 | 2020-04-26 | Onondaga | New York | 36067 | 692 | 30 |
88526 | 88526 | 2020-04-25 | Onondaga | New York | 36067 | 664 | 30 |
85714 | 85714 | 2020-04-24 | Onondaga | New York | 36067 | 639 | 29 |
82910 | 82910 | 2020-04-23 | Onondaga | New York | 36067 | 600 | 28 |
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);