ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" 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 |
---|---|---|---|---|---|---|---|
1055404 | 1055404 | 2021-02-22 | Warren | New York | 36113 | 2776 | 53 |
1052158 | 1052158 | 2021-02-21 | Warren | New York | 36113 | 2769 | 53 |
1048911 | 1048911 | 2021-02-20 | Warren | New York | 36113 | 2763 | 53 |
1045664 | 1045664 | 2021-02-19 | Warren | New York | 36113 | 2754 | 53 |
1042419 | 1042419 | 2021-02-18 | Warren | New York | 36113 | 2734 | 53 |
1039174 | 1039174 | 2021-02-17 | Warren | New York | 36113 | 2726 | 53 |
1035929 | 1035929 | 2021-02-16 | Warren | New York | 36113 | 2720 | 53 |
1032684 | 1032684 | 2021-02-15 | Warren | New York | 36113 | 2710 | 53 |
1029438 | 1029438 | 2021-02-14 | Warren | New York | 36113 | 2704 | 53 |
1026191 | 1026191 | 2021-02-13 | Warren | New York | 36113 | 2680 | 53 |
1022946 | 1022946 | 2021-02-12 | Warren | New York | 36113 | 2667 | 53 |
1019701 | 1019701 | 2021-02-11 | Warren | New York | 36113 | 2654 | 53 |
1016456 | 1016456 | 2021-02-10 | Warren | New York | 36113 | 2630 | 53 |
1013211 | 1013211 | 2021-02-09 | Warren | New York | 36113 | 2620 | 53 |
1009966 | 1009966 | 2021-02-08 | Warren | New York | 36113 | 2606 | 53 |
1006720 | 1006720 | 2021-02-07 | Warren | New York | 36113 | 2596 | 51 |
1003474 | 1003474 | 2021-02-06 | Warren | New York | 36113 | 2582 | 48 |
1000228 | 1000228 | 2021-02-05 | Warren | New York | 36113 | 2554 | 48 |
996982 | 996982 | 2021-02-04 | Warren | New York | 36113 | 2534 | 48 |
993736 | 993736 | 2021-02-03 | Warren | New York | 36113 | 2494 | 48 |
990490 | 990490 | 2021-02-02 | Warren | New York | 36113 | 2466 | 48 |
987244 | 987244 | 2021-02-01 | Warren | New York | 36113 | 2461 | 48 |
983997 | 983997 | 2021-01-31 | Warren | New York | 36113 | 2452 | 47 |
980750 | 980750 | 2021-01-30 | Warren | New York | 36113 | 2431 | 47 |
977504 | 977504 | 2021-01-29 | Warren | New York | 36113 | 2417 | 47 |
974259 | 974259 | 2021-01-28 | Warren | New York | 36113 | 2385 | 47 |
971014 | 971014 | 2021-01-27 | Warren | New York | 36113 | 2350 | 47 |
967769 | 967769 | 2021-01-26 | Warren | New York | 36113 | 2321 | 44 |
964525 | 964525 | 2021-01-25 | Warren | New York | 36113 | 2270 | 44 |
961280 | 961280 | 2021-01-24 | Warren | New York | 36113 | 2259 | 43 |
958035 | 958035 | 2021-01-23 | Warren | New York | 36113 | 2245 | 42 |
954789 | 954789 | 2021-01-22 | Warren | New York | 36113 | 2201 | 42 |
951544 | 951544 | 2021-01-21 | Warren | New York | 36113 | 2163 | 42 |
948299 | 948299 | 2021-01-20 | Warren | New York | 36113 | 2119 | 42 |
945052 | 945052 | 2021-01-19 | Warren | New York | 36113 | 2062 | 40 |
941806 | 941806 | 2021-01-18 | Warren | New York | 36113 | 2045 | 38 |
938561 | 938561 | 2021-01-17 | Warren | New York | 36113 | 2004 | 37 |
935316 | 935316 | 2021-01-16 | Warren | New York | 36113 | 1982 | 37 |
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 |
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);