ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 36029 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 |
---|---|---|---|---|---|---|---|
636743 | 636743 | 2020-10-16 | Erie | New York | 36029 | 12324 | 640 |
633497 | 633497 | 2020-10-15 | Erie | New York | 36029 | 12269 | 640 |
630252 | 630252 | 2020-10-14 | Erie | New York | 36029 | 12216 | 639 |
627008 | 627008 | 2020-10-13 | Erie | New York | 36029 | 12182 | 639 |
623766 | 623766 | 2020-10-12 | Erie | New York | 36029 | 12154 | 639 |
620523 | 620523 | 2020-10-11 | Erie | New York | 36029 | 12107 | 638 |
617281 | 617281 | 2020-10-10 | Erie | New York | 36029 | 12055 | 637 |
614039 | 614039 | 2020-10-09 | Erie | New York | 36029 | 11998 | 636 |
610798 | 610798 | 2020-10-08 | Erie | New York | 36029 | 11953 | 636 |
607556 | 607556 | 2020-10-07 | Erie | New York | 36029 | 11898 | 635 |
604313 | 604313 | 2020-10-06 | Erie | New York | 36029 | 11864 | 634 |
601071 | 601071 | 2020-10-05 | Erie | New York | 36029 | 11798 | 633 |
597828 | 597828 | 2020-10-04 | Erie | New York | 36029 | 11767 | 632 |
594585 | 594585 | 2020-10-03 | Erie | New York | 36029 | 11697 | 629 |
591344 | 591344 | 2020-10-02 | Erie | New York | 36029 | 11637 | 627 |
588103 | 588103 | 2020-10-01 | Erie | New York | 36029 | 11574 | 627 |
584863 | 584863 | 2020-09-30 | Erie | New York | 36029 | 11500 | 625 |
581622 | 581622 | 2020-09-29 | Erie | New York | 36029 | 11445 | 625 |
578382 | 578382 | 2020-09-28 | Erie | New York | 36029 | 11359 | 625 |
575141 | 575141 | 2020-09-27 | Erie | New York | 36029 | 11342 | 624 |
571897 | 571897 | 2020-09-26 | Erie | New York | 36029 | 11308 | 624 |
568655 | 568655 | 2020-09-25 | Erie | New York | 36029 | 11251 | 623 |
565414 | 565414 | 2020-09-24 | Erie | New York | 36029 | 11201 | 623 |
562173 | 562173 | 2020-09-23 | Erie | New York | 36029 | 11112 | 623 |
558936 | 558936 | 2020-09-22 | Erie | New York | 36029 | 11082 | 623 |
555699 | 555699 | 2020-09-21 | Erie | New York | 36029 | 11042 | 622 |
552462 | 552462 | 2020-09-20 | Erie | New York | 36029 | 10999 | 622 |
549223 | 549223 | 2020-09-19 | Erie | New York | 36029 | 10917 | 622 |
545984 | 545984 | 2020-09-18 | Erie | New York | 36029 | 10873 | 621 |
542747 | 542747 | 2020-09-17 | Erie | New York | 36029 | 10833 | 619 |
539511 | 539511 | 2020-09-16 | Erie | New York | 36029 | 10752 | 619 |
536274 | 536274 | 2020-09-15 | Erie | New York | 36029 | 10716 | 619 |
533038 | 533038 | 2020-09-14 | Erie | New York | 36029 | 10668 | 616 |
529803 | 529803 | 2020-09-13 | Erie | New York | 36029 | 10637 | 615 |
526566 | 526566 | 2020-09-12 | Erie | New York | 36029 | 10567 | 615 |
523330 | 523330 | 2020-09-11 | Erie | New York | 36029 | 10503 | 615 |
520094 | 520094 | 2020-09-10 | Erie | New York | 36029 | 10444 | 614 |
516858 | 516858 | 2020-09-09 | Erie | New York | 36029 | 10394 | 611 |
513623 | 513623 | 2020-09-08 | Erie | New York | 36029 | 10346 | 610 |
510390 | 510390 | 2020-09-07 | Erie | New York | 36029 | 10320 | 609 |
507157 | 507157 | 2020-09-06 | Erie | New York | 36029 | 10266 | 609 |
503925 | 503925 | 2020-09-05 | Erie | New York | 36029 | 10212 | 607 |
500691 | 500691 | 2020-09-04 | Erie | New York | 36029 | 10156 | 607 |
497457 | 497457 | 2020-09-03 | Erie | New York | 36029 | 10086 | 607 |
494224 | 494224 | 2020-09-02 | Erie | New York | 36029 | 10017 | 607 |
490990 | 490990 | 2020-09-01 | Erie | New York | 36029 | 9947 | 607 |
487757 | 487757 | 2020-08-31 | Erie | New York | 36029 | 9872 | 606 |
484524 | 484524 | 2020-08-30 | Erie | New York | 36029 | 9807 | 606 |
481289 | 481289 | 2020-08-29 | Erie | New York | 36029 | 9741 | 605 |
478056 | 478056 | 2020-08-28 | Erie | New York | 36029 | 9713 | 605 |
474823 | 474823 | 2020-08-27 | Erie | New York | 36029 | 9668 | 605 |
471589 | 471589 | 2020-08-26 | Erie | New York | 36029 | 9589 | 605 |
468357 | 468357 | 2020-08-25 | Erie | New York | 36029 | 9546 | 605 |
465129 | 465129 | 2020-08-24 | Erie | New York | 36029 | 9491 | 605 |
461900 | 461900 | 2020-08-23 | Erie | New York | 36029 | 9465 | 605 |
458672 | 458672 | 2020-08-22 | Erie | New York | 36029 | 9413 | 604 |
455444 | 455444 | 2020-08-21 | Erie | New York | 36029 | 9364 | 604 |
452216 | 452216 | 2020-08-20 | Erie | New York | 36029 | 9283 | 604 |
448988 | 448988 | 2020-08-19 | Erie | New York | 36029 | 9241 | 604 |
445760 | 445760 | 2020-08-18 | Erie | New York | 36029 | 9187 | 603 |
442534 | 442534 | 2020-08-17 | Erie | New York | 36029 | 9157 | 603 |
439307 | 439307 | 2020-08-16 | Erie | New York | 36029 | 9147 | 602 |
436082 | 436082 | 2020-08-15 | Erie | New York | 36029 | 9114 | 601 |
432856 | 432856 | 2020-08-14 | Erie | New York | 36029 | 9064 | 601 |
429630 | 429630 | 2020-08-13 | Erie | New York | 36029 | 9033 | 601 |
426405 | 426405 | 2020-08-12 | Erie | New York | 36029 | 9013 | 601 |
423182 | 423182 | 2020-08-11 | Erie | New York | 36029 | 8987 | 599 |
419959 | 419959 | 2020-08-10 | Erie | New York | 36029 | 8918 | 598 |
416739 | 416739 | 2020-08-09 | Erie | New York | 36029 | 8904 | 598 |
413518 | 413518 | 2020-08-08 | Erie | New York | 36029 | 8850 | 597 |
410298 | 410298 | 2020-08-07 | Erie | New York | 36029 | 8791 | 597 |
407078 | 407078 | 2020-08-06 | Erie | New York | 36029 | 8737 | 596 |
403859 | 403859 | 2020-08-05 | Erie | New York | 36029 | 8702 | 623 |
400641 | 400641 | 2020-08-04 | Erie | New York | 36029 | 8667 | 623 |
397426 | 397426 | 2020-08-03 | Erie | New York | 36029 | 8626 | 622 |
394209 | 394209 | 2020-08-02 | Erie | New York | 36029 | 8572 | 621 |
390993 | 390993 | 2020-08-01 | Erie | New York | 36029 | 8548 | 621 |
387776 | 387776 | 2020-07-31 | Erie | New York | 36029 | 8492 | 621 |
384559 | 384559 | 2020-07-30 | Erie | New York | 36029 | 8434 | 621 |
381341 | 381341 | 2020-07-29 | Erie | New York | 36029 | 8410 | 620 |
378124 | 378124 | 2020-07-28 | Erie | New York | 36029 | 8364 | 619 |
374908 | 374908 | 2020-07-27 | Erie | New York | 36029 | 8327 | 619 |
371696 | 371696 | 2020-07-26 | Erie | New York | 36029 | 8301 | 619 |
368484 | 368484 | 2020-07-25 | Erie | New York | 36029 | 8282 | 619 |
365275 | 365275 | 2020-07-24 | Erie | New York | 36029 | 8234 | 616 |
362069 | 362069 | 2020-07-23 | Erie | New York | 36029 | 8187 | 614 |
358863 | 358863 | 2020-07-22 | Erie | New York | 36029 | 8135 | 614 |
355659 | 355659 | 2020-07-21 | Erie | New York | 36029 | 8106 | 613 |
352456 | 352456 | 2020-07-20 | Erie | New York | 36029 | 8046 | 613 |
349253 | 349253 | 2020-07-19 | Erie | New York | 36029 | 8035 | 610 |
346052 | 346052 | 2020-07-18 | Erie | New York | 36029 | 8016 | 610 |
342853 | 342853 | 2020-07-17 | Erie | New York | 36029 | 7982 | 608 |
339655 | 339655 | 2020-07-16 | Erie | New York | 36029 | 7927 | 607 |
336459 | 336459 | 2020-07-15 | Erie | New York | 36029 | 7891 | 606 |
333265 | 333265 | 2020-07-14 | Erie | New York | 36029 | 7833 | 604 |
330075 | 330075 | 2020-07-13 | Erie | New York | 36029 | 7766 | 603 |
326888 | 326888 | 2020-07-12 | Erie | New York | 36029 | 7742 | 602 |
323704 | 323704 | 2020-07-11 | Erie | New York | 36029 | 7711 | 602 |
320524 | 320524 | 2020-07-10 | Erie | New York | 36029 | 7660 | 601 |
317347 | 317347 | 2020-07-09 | Erie | New York | 36029 | 7624 | 601 |
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);