ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36067 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 |
---|---|---|---|---|---|---|---|
636761 | 636761 | 2020-10-16 | Onondaga | New York | 36067 | 4946 | 182 |
633515 | 633515 | 2020-10-15 | Onondaga | New York | 36067 | 4908 | 182 |
630270 | 630270 | 2020-10-14 | Onondaga | New York | 36067 | 4880 | 182 |
627026 | 627026 | 2020-10-13 | Onondaga | New York | 36067 | 4843 | 182 |
623784 | 623784 | 2020-10-12 | Onondaga | New York | 36067 | 4807 | 182 |
620541 | 620541 | 2020-10-11 | Onondaga | New York | 36067 | 4779 | 182 |
617299 | 617299 | 2020-10-10 | Onondaga | New York | 36067 | 4747 | 182 |
614057 | 614057 | 2020-10-09 | Onondaga | New York | 36067 | 4693 | 182 |
610816 | 610816 | 2020-10-08 | Onondaga | New York | 36067 | 4669 | 182 |
607574 | 607574 | 2020-10-07 | Onondaga | New York | 36067 | 4636 | 182 |
604331 | 604331 | 2020-10-06 | Onondaga | New York | 36067 | 4593 | 182 |
601089 | 601089 | 2020-10-05 | Onondaga | New York | 36067 | 4556 | 182 |
597846 | 597846 | 2020-10-04 | Onondaga | New York | 36067 | 4537 | 182 |
594603 | 594603 | 2020-10-03 | Onondaga | New York | 36067 | 4528 | 182 |
591362 | 591362 | 2020-10-02 | Onondaga | New York | 36067 | 4494 | 182 |
588121 | 588121 | 2020-10-01 | Onondaga | New York | 36067 | 4456 | 182 |
584881 | 584881 | 2020-09-30 | Onondaga | New York | 36067 | 4424 | 182 |
581640 | 581640 | 2020-09-29 | Onondaga | New York | 36067 | 4409 | 182 |
578400 | 578400 | 2020-09-28 | Onondaga | New York | 36067 | 4379 | 182 |
575159 | 575159 | 2020-09-27 | Onondaga | New York | 36067 | 4365 | 181 |
571915 | 571915 | 2020-09-26 | Onondaga | New York | 36067 | 4342 | 180 |
568673 | 568673 | 2020-09-25 | Onondaga | New York | 36067 | 4321 | 180 |
565432 | 565432 | 2020-09-24 | Onondaga | New York | 36067 | 4300 | 180 |
562191 | 562191 | 2020-09-23 | Onondaga | New York | 36067 | 4270 | 180 |
558954 | 558954 | 2020-09-22 | Onondaga | New York | 36067 | 4253 | 180 |
555717 | 555717 | 2020-09-21 | Onondaga | New York | 36067 | 4231 | 180 |
552480 | 552480 | 2020-09-20 | Onondaga | New York | 36067 | 4220 | 180 |
549241 | 549241 | 2020-09-19 | Onondaga | New York | 36067 | 4201 | 180 |
546002 | 546002 | 2020-09-18 | Onondaga | New York | 36067 | 4185 | 180 |
542765 | 542765 | 2020-09-17 | Onondaga | New York | 36067 | 4158 | 180 |
539529 | 539529 | 2020-09-16 | Onondaga | New York | 36067 | 4133 | 180 |
536292 | 536292 | 2020-09-15 | Onondaga | New York | 36067 | 4114 | 180 |
533056 | 533056 | 2020-09-14 | Onondaga | New York | 36067 | 4096 | 180 |
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 |
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);