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 |
---|---|---|---|---|---|---|---|
529821 | 529821 | 2020-09-13 | Onondaga | New York | 36067 | 4081 | 180 |
526584 | 526584 | 2020-09-12 | Onondaga | New York | 36067 | 4060 | 179 |
523348 | 523348 | 2020-09-11 | Onondaga | New York | 36067 | 4043 | 179 |
520112 | 520112 | 2020-09-10 | Onondaga | New York | 36067 | 4023 | 179 |
516876 | 516876 | 2020-09-09 | Onondaga | New York | 36067 | 4012 | 179 |
513641 | 513641 | 2020-09-08 | Onondaga | New York | 36067 | 4002 | 179 |
510408 | 510408 | 2020-09-07 | Onondaga | New York | 36067 | 3993 | 179 |
507175 | 507175 | 2020-09-06 | Onondaga | New York | 36067 | 3983 | 179 |
503943 | 503943 | 2020-09-05 | Onondaga | New York | 36067 | 3964 | 179 |
500709 | 500709 | 2020-09-04 | Onondaga | New York | 36067 | 3947 | 179 |
497475 | 497475 | 2020-09-03 | Onondaga | New York | 36067 | 3937 | 179 |
494242 | 494242 | 2020-09-02 | Onondaga | New York | 36067 | 3922 | 179 |
491008 | 491008 | 2020-09-01 | Onondaga | New York | 36067 | 3912 | 179 |
487775 | 487775 | 2020-08-31 | Onondaga | New York | 36067 | 3892 | 179 |
484542 | 484542 | 2020-08-30 | Onondaga | New York | 36067 | 3883 | 179 |
481307 | 481307 | 2020-08-29 | Onondaga | New York | 36067 | 3866 | 179 |
478074 | 478074 | 2020-08-28 | Onondaga | New York | 36067 | 3847 | 179 |
474841 | 474841 | 2020-08-27 | Onondaga | New York | 36067 | 3832 | 179 |
471607 | 471607 | 2020-08-26 | Onondaga | New York | 36067 | 3801 | 179 |
468375 | 468375 | 2020-08-25 | Onondaga | New York | 36067 | 3792 | 179 |
465147 | 465147 | 2020-08-24 | Onondaga | New York | 36067 | 3768 | 179 |
461918 | 461918 | 2020-08-23 | Onondaga | New York | 36067 | 3758 | 179 |
458690 | 458690 | 2020-08-22 | Onondaga | New York | 36067 | 3756 | 179 |
455462 | 455462 | 2020-08-21 | Onondaga | New York | 36067 | 3743 | 179 |
452234 | 452234 | 2020-08-20 | Onondaga | New York | 36067 | 3719 | 179 |
449006 | 449006 | 2020-08-19 | Onondaga | New York | 36067 | 3712 | 179 |
445778 | 445778 | 2020-08-18 | Onondaga | New York | 36067 | 3696 | 178 |
442552 | 442552 | 2020-08-17 | Onondaga | New York | 36067 | 3680 | 178 |
439325 | 439325 | 2020-08-16 | Onondaga | New York | 36067 | 3674 | 178 |
436100 | 436100 | 2020-08-15 | Onondaga | New York | 36067 | 3663 | 178 |
432874 | 432874 | 2020-08-14 | Onondaga | New York | 36067 | 3646 | 178 |
429648 | 429648 | 2020-08-13 | Onondaga | New York | 36067 | 3627 | 177 |
426423 | 426423 | 2020-08-12 | Onondaga | New York | 36067 | 3613 | 176 |
423200 | 423200 | 2020-08-11 | Onondaga | New York | 36067 | 3602 | 176 |
419977 | 419977 | 2020-08-10 | Onondaga | New York | 36067 | 3585 | 176 |
416757 | 416757 | 2020-08-09 | Onondaga | New York | 36067 | 3576 | 176 |
413536 | 413536 | 2020-08-08 | Onondaga | New York | 36067 | 3565 | 176 |
410316 | 410316 | 2020-08-07 | Onondaga | New York | 36067 | 3556 | 176 |
407096 | 407096 | 2020-08-06 | Onondaga | New York | 36067 | 3535 | 175 |
403877 | 403877 | 2020-08-05 | Onondaga | New York | 36067 | 3525 | 191 |
400659 | 400659 | 2020-08-04 | Onondaga | New York | 36067 | 3515 | 190 |
397444 | 397444 | 2020-08-03 | Onondaga | New York | 36067 | 3490 | 190 |
394227 | 394227 | 2020-08-02 | Onondaga | New York | 36067 | 3485 | 189 |
391011 | 391011 | 2020-08-01 | Onondaga | New York | 36067 | 3477 | 189 |
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 |
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);