ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" and fips = 36113 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
932071 | 932071 | 2021-01-15 | Warren | New York | 36113 | 1928 | 36 |
928826 | 928826 | 2021-01-14 | Warren | New York | 36113 | 1846 | 35 |
925581 | 925581 | 2021-01-13 | Warren | New York | 36113 | 1825 | 35 |
922335 | 922335 | 2021-01-12 | Warren | New York | 36113 | 1764 | 33 |
919090 | 919090 | 2021-01-11 | Warren | New York | 36113 | 1717 | 33 |
915845 | 915845 | 2021-01-10 | Warren | New York | 36113 | 1682 | 33 |
912600 | 912600 | 2021-01-09 | Warren | New York | 36113 | 1625 | 32 |
909355 | 909355 | 2021-01-08 | Warren | New York | 36113 | 1567 | 32 |
906110 | 906110 | 2021-01-07 | Warren | New York | 36113 | 1487 | 32 |
902864 | 902864 | 2021-01-06 | Warren | New York | 36113 | 1434 | 32 |
899619 | 899619 | 2021-01-05 | Warren | New York | 36113 | 1387 | 32 |
896374 | 896374 | 2021-01-04 | Warren | New York | 36113 | 1346 | 32 |
893128 | 893128 | 2021-01-03 | Warren | New York | 36113 | 1337 | 32 |
889882 | 889882 | 2021-01-02 | Warren | New York | 36113 | 1272 | 32 |
886635 | 886635 | 2021-01-01 | Warren | New York | 36113 | 1249 | 32 |
883390 | 883390 | 2020-12-31 | Warren | New York | 36113 | 1156 | 32 |
880145 | 880145 | 2020-12-30 | Warren | New York | 36113 | 1141 | 32 |
876900 | 876900 | 2020-12-29 | Warren | New York | 36113 | 1094 | 32 |
873655 | 873655 | 2020-12-28 | Warren | New York | 36113 | 1076 | 31 |
870410 | 870410 | 2020-12-27 | Warren | New York | 36113 | 1049 | 31 |
867165 | 867165 | 2020-12-26 | Warren | New York | 36113 | 1040 | 31 |
863920 | 863920 | 2020-12-25 | Warren | New York | 36113 | 979 | 30 |
860675 | 860675 | 2020-12-24 | Warren | New York | 36113 | 961 | 30 |
857430 | 857430 | 2020-12-23 | Warren | New York | 36113 | 897 | 30 |
854185 | 854185 | 2020-12-22 | Warren | New York | 36113 | 878 | 30 |
850940 | 850940 | 2020-12-21 | Warren | New York | 36113 | 843 | 30 |
847695 | 847695 | 2020-12-20 | Warren | New York | 36113 | 836 | 30 |
844450 | 844450 | 2020-12-19 | Warren | New York | 36113 | 833 | 30 |
841204 | 841204 | 2020-12-18 | Warren | New York | 36113 | 812 | 30 |
837959 | 837959 | 2020-12-17 | Warren | New York | 36113 | 804 | 30 |
834713 | 834713 | 2020-12-16 | Warren | New York | 36113 | 775 | 30 |
831467 | 831467 | 2020-12-15 | Warren | New York | 36113 | 764 | 30 |
828220 | 828220 | 2020-12-14 | Warren | New York | 36113 | 756 | 30 |
824974 | 824974 | 2020-12-13 | Warren | New York | 36113 | 754 | 30 |
821727 | 821727 | 2020-12-12 | Warren | New York | 36113 | 746 | 30 |
818481 | 818481 | 2020-12-11 | Warren | New York | 36113 | 724 | 30 |
815235 | 815235 | 2020-12-10 | Warren | New York | 36113 | 710 | 30 |
811990 | 811990 | 2020-12-09 | Warren | New York | 36113 | 686 | 30 |
808745 | 808745 | 2020-12-08 | Warren | New York | 36113 | 680 | 30 |
805500 | 805500 | 2020-12-07 | Warren | New York | 36113 | 662 | 30 |
802255 | 802255 | 2020-12-06 | Warren | New York | 36113 | 657 | 30 |
799010 | 799010 | 2020-12-05 | Warren | New York | 36113 | 646 | 30 |
795765 | 795765 | 2020-12-04 | Warren | New York | 36113 | 631 | 30 |
792520 | 792520 | 2020-12-03 | Warren | New York | 36113 | 614 | 30 |
789275 | 789275 | 2020-12-02 | Warren | New York | 36113 | 603 | 30 |
786030 | 786030 | 2020-12-01 | Warren | New York | 36113 | 595 | 30 |
782786 | 782786 | 2020-11-30 | Warren | New York | 36113 | 583 | 30 |
779540 | 779540 | 2020-11-29 | Warren | New York | 36113 | 577 | 30 |
776295 | 776295 | 2020-11-28 | Warren | New York | 36113 | 575 | 30 |
773050 | 773050 | 2020-11-27 | Warren | New York | 36113 | 571 | 30 |
769805 | 769805 | 2020-11-26 | Warren | New York | 36113 | 569 | 30 |
766559 | 766559 | 2020-11-25 | Warren | New York | 36113 | 560 | 30 |
763314 | 763314 | 2020-11-24 | Warren | New York | 36113 | 547 | 30 |
760069 | 760069 | 2020-11-23 | Warren | New York | 36113 | 543 | 30 |
756823 | 756823 | 2020-11-22 | Warren | New York | 36113 | 542 | 30 |
753576 | 753576 | 2020-11-21 | Warren | New York | 36113 | 537 | 30 |
750330 | 750330 | 2020-11-20 | Warren | New York | 36113 | 530 | 30 |
747084 | 747084 | 2020-11-19 | Warren | New York | 36113 | 525 | 30 |
743838 | 743838 | 2020-11-18 | Warren | New York | 36113 | 518 | 30 |
740591 | 740591 | 2020-11-17 | Warren | New York | 36113 | 515 | 30 |
737346 | 737346 | 2020-11-16 | Warren | New York | 36113 | 507 | 30 |
734102 | 734102 | 2020-11-15 | Warren | New York | 36113 | 507 | 30 |
730856 | 730856 | 2020-11-14 | Warren | New York | 36113 | 507 | 30 |
727612 | 727612 | 2020-11-13 | Warren | New York | 36113 | 503 | 30 |
724368 | 724368 | 2020-11-12 | Warren | New York | 36113 | 495 | 30 |
721125 | 721125 | 2020-11-11 | Warren | New York | 36113 | 493 | 30 |
717882 | 717882 | 2020-11-10 | Warren | New York | 36113 | 487 | 30 |
714639 | 714639 | 2020-11-09 | Warren | New York | 36113 | 485 | 30 |
711395 | 711395 | 2020-11-08 | Warren | New York | 36113 | 483 | 30 |
708151 | 708151 | 2020-11-07 | Warren | New York | 36113 | 480 | 30 |
704908 | 704908 | 2020-11-06 | Warren | New York | 36113 | 475 | 30 |
701665 | 701665 | 2020-11-05 | Warren | New York | 36113 | 474 | 30 |
698421 | 698421 | 2020-11-04 | Warren | New York | 36113 | 471 | 30 |
695178 | 695178 | 2020-11-03 | Warren | New York | 36113 | 470 | 30 |
691936 | 691936 | 2020-11-02 | Warren | New York | 36113 | 469 | 30 |
688692 | 688692 | 2020-11-01 | Warren | New York | 36113 | 468 | 30 |
685447 | 685447 | 2020-10-31 | Warren | New York | 36113 | 467 | 30 |
682204 | 682204 | 2020-10-30 | Warren | New York | 36113 | 461 | 30 |
678961 | 678961 | 2020-10-29 | Warren | New York | 36113 | 461 | 30 |
675718 | 675718 | 2020-10-28 | Warren | New York | 36113 | 459 | 30 |
672475 | 672475 | 2020-10-27 | Warren | New York | 36113 | 457 | 30 |
669233 | 669233 | 2020-10-26 | Warren | New York | 36113 | 452 | 30 |
665989 | 665989 | 2020-10-25 | Warren | New York | 36113 | 450 | 30 |
662744 | 662744 | 2020-10-24 | Warren | New York | 36113 | 448 | 30 |
659500 | 659500 | 2020-10-23 | Warren | New York | 36113 | 445 | 30 |
656256 | 656256 | 2020-10-22 | Warren | New York | 36113 | 444 | 30 |
653011 | 653011 | 2020-10-21 | Warren | New York | 36113 | 441 | 30 |
649766 | 649766 | 2020-10-20 | Warren | New York | 36113 | 439 | 30 |
646522 | 646522 | 2020-10-19 | Warren | New York | 36113 | 438 | 30 |
643276 | 643276 | 2020-10-18 | Warren | New York | 36113 | 438 | 30 |
640028 | 640028 | 2020-10-17 | Warren | New York | 36113 | 437 | 30 |
636782 | 636782 | 2020-10-16 | Warren | New York | 36113 | 437 | 30 |
633536 | 633536 | 2020-10-15 | Warren | New York | 36113 | 434 | 30 |
630291 | 630291 | 2020-10-14 | Warren | New York | 36113 | 432 | 30 |
627047 | 627047 | 2020-10-13 | Warren | New York | 36113 | 431 | 30 |
623805 | 623805 | 2020-10-12 | Warren | New York | 36113 | 430 | 30 |
620562 | 620562 | 2020-10-11 | Warren | New York | 36113 | 429 | 30 |
617320 | 617320 | 2020-10-10 | Warren | New York | 36113 | 429 | 30 |
614078 | 614078 | 2020-10-09 | Warren | New York | 36113 | 429 | 30 |
610837 | 610837 | 2020-10-08 | Warren | New York | 36113 | 427 | 30 |
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);