ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Tompkins" 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 |
---|---|---|---|---|---|---|---|
1055402 | 1055402 | 2021-02-22 | Tompkins | New York | 36109 | 3398 | 42 |
1052156 | 1052156 | 2021-02-21 | Tompkins | New York | 36109 | 3389 | 42 |
1048909 | 1048909 | 2021-02-20 | Tompkins | New York | 36109 | 3376 | 42 |
1045662 | 1045662 | 2021-02-19 | Tompkins | New York | 36109 | 3367 | 42 |
1042417 | 1042417 | 2021-02-18 | Tompkins | New York | 36109 | 3350 | 42 |
1039172 | 1039172 | 2021-02-17 | Tompkins | New York | 36109 | 3345 | 41 |
1035927 | 1035927 | 2021-02-16 | Tompkins | New York | 36109 | 3340 | 41 |
1032682 | 1032682 | 2021-02-15 | Tompkins | New York | 36109 | 3335 | 41 |
1029436 | 1029436 | 2021-02-14 | Tompkins | New York | 36109 | 3325 | 41 |
1026189 | 1026189 | 2021-02-13 | Tompkins | New York | 36109 | 3316 | 40 |
1022944 | 1022944 | 2021-02-12 | Tompkins | New York | 36109 | 3300 | 40 |
1019699 | 1019699 | 2021-02-11 | Tompkins | New York | 36109 | 3274 | 39 |
1016454 | 1016454 | 2021-02-10 | Tompkins | New York | 36109 | 3247 | 39 |
1013209 | 1013209 | 2021-02-09 | Tompkins | New York | 36109 | 3232 | 39 |
1009964 | 1009964 | 2021-02-08 | Tompkins | New York | 36109 | 3226 | 39 |
1006718 | 1006718 | 2021-02-07 | Tompkins | New York | 36109 | 3201 | 39 |
1003472 | 1003472 | 2021-02-06 | Tompkins | New York | 36109 | 3165 | 39 |
1000226 | 1000226 | 2021-02-05 | Tompkins | New York | 36109 | 3137 | 38 |
996980 | 996980 | 2021-02-04 | Tompkins | New York | 36109 | 3100 | 37 |
993734 | 993734 | 2021-02-03 | Tompkins | New York | 36109 | 3057 | 34 |
990488 | 990488 | 2021-02-02 | Tompkins | New York | 36109 | 3044 | 34 |
987242 | 987242 | 2021-02-01 | Tompkins | New York | 36109 | 3015 | 31 |
983995 | 983995 | 2021-01-31 | Tompkins | New York | 36109 | 2987 | 31 |
980748 | 980748 | 2021-01-30 | Tompkins | New York | 36109 | 2962 | 31 |
977502 | 977502 | 2021-01-29 | Tompkins | New York | 36109 | 2944 | 29 |
974257 | 974257 | 2021-01-28 | Tompkins | New York | 36109 | 2917 | 28 |
971012 | 971012 | 2021-01-27 | Tompkins | New York | 36109 | 2890 | 28 |
967767 | 967767 | 2021-01-26 | Tompkins | New York | 36109 | 2864 | 28 |
964523 | 964523 | 2021-01-25 | Tompkins | New York | 36109 | 2845 | 25 |
961278 | 961278 | 2021-01-24 | Tompkins | New York | 36109 | 2831 | 25 |
958033 | 958033 | 2021-01-23 | Tompkins | New York | 36109 | 2811 | 25 |
954787 | 954787 | 2021-01-22 | Tompkins | New York | 36109 | 2779 | 25 |
951542 | 951542 | 2021-01-21 | Tompkins | New York | 36109 | 2752 | 25 |
948297 | 948297 | 2021-01-20 | Tompkins | New York | 36109 | 2707 | 24 |
945050 | 945050 | 2021-01-19 | Tompkins | New York | 36109 | 2657 | 23 |
941804 | 941804 | 2021-01-18 | Tompkins | New York | 36109 | 2641 | 23 |
938559 | 938559 | 2021-01-17 | Tompkins | New York | 36109 | 2613 | 22 |
935314 | 935314 | 2021-01-16 | Tompkins | New York | 36109 | 2572 | 22 |
932069 | 932069 | 2021-01-15 | Tompkins | New York | 36109 | 2528 | 22 |
928824 | 928824 | 2021-01-14 | Tompkins | New York | 36109 | 2484 | 22 |
925579 | 925579 | 2021-01-13 | Tompkins | New York | 36109 | 2463 | 20 |
922333 | 922333 | 2021-01-12 | Tompkins | New York | 36109 | 2424 | 18 |
919088 | 919088 | 2021-01-11 | Tompkins | New York | 36109 | 2414 | 18 |
915843 | 915843 | 2021-01-10 | Tompkins | New York | 36109 | 2396 | 18 |
912598 | 912598 | 2021-01-09 | Tompkins | New York | 36109 | 2374 | 18 |
909353 | 909353 | 2021-01-08 | Tompkins | New York | 36109 | 2318 | 18 |
906108 | 906108 | 2021-01-07 | Tompkins | New York | 36109 | 2278 | 18 |
902862 | 902862 | 2021-01-06 | Tompkins | New York | 36109 | 2225 | 16 |
899617 | 899617 | 2021-01-05 | Tompkins | New York | 36109 | 2166 | 16 |
896372 | 896372 | 2021-01-04 | Tompkins | New York | 36109 | 2152 | 15 |
893126 | 893126 | 2021-01-03 | Tompkins | New York | 36109 | 2138 | 15 |
889880 | 889880 | 2021-01-02 | Tompkins | New York | 36109 | 2133 | 15 |
886633 | 886633 | 2021-01-01 | Tompkins | New York | 36109 | 2114 | 14 |
883388 | 883388 | 2020-12-31 | Tompkins | New York | 36109 | 2079 | 14 |
880143 | 880143 | 2020-12-30 | Tompkins | New York | 36109 | 2033 | 14 |
876898 | 876898 | 2020-12-29 | Tompkins | New York | 36109 | 1993 | 13 |
873653 | 873653 | 2020-12-28 | Tompkins | New York | 36109 | 1981 | 13 |
870408 | 870408 | 2020-12-27 | Tompkins | New York | 36109 | 1961 | 13 |
867163 | 867163 | 2020-12-26 | Tompkins | New York | 36109 | 1953 | 13 |
863918 | 863918 | 2020-12-25 | Tompkins | New York | 36109 | 1921 | 13 |
860673 | 860673 | 2020-12-24 | Tompkins | New York | 36109 | 1878 | 12 |
857428 | 857428 | 2020-12-23 | Tompkins | New York | 36109 | 1846 | 11 |
854183 | 854183 | 2020-12-22 | Tompkins | New York | 36109 | 1816 | 10 |
850938 | 850938 | 2020-12-21 | Tompkins | New York | 36109 | 1798 | 10 |
847693 | 847693 | 2020-12-20 | Tompkins | New York | 36109 | 1781 | 10 |
844448 | 844448 | 2020-12-19 | Tompkins | New York | 36109 | 1728 | 10 |
841202 | 841202 | 2020-12-18 | Tompkins | New York | 36109 | 1710 | 9 |
837957 | 837957 | 2020-12-17 | Tompkins | New York | 36109 | 1671 | 9 |
834711 | 834711 | 2020-12-16 | Tompkins | New York | 36109 | 1637 | 9 |
831465 | 831465 | 2020-12-15 | Tompkins | New York | 36109 | 1613 | 9 |
828218 | 828218 | 2020-12-14 | Tompkins | New York | 36109 | 1593 | 8 |
824972 | 824972 | 2020-12-13 | Tompkins | New York | 36109 | 1556 | 6 |
821725 | 821725 | 2020-12-12 | Tompkins | New York | 36109 | 1529 | 5 |
818479 | 818479 | 2020-12-11 | Tompkins | New York | 36109 | 1477 | 5 |
815233 | 815233 | 2020-12-10 | Tompkins | New York | 36109 | 1451 | 5 |
811988 | 811988 | 2020-12-09 | Tompkins | New York | 36109 | 1424 | 5 |
808743 | 808743 | 2020-12-08 | Tompkins | New York | 36109 | 1398 | 4 |
805498 | 805498 | 2020-12-07 | Tompkins | New York | 36109 | 1336 | 4 |
802253 | 802253 | 2020-12-06 | Tompkins | New York | 36109 | 1306 | 4 |
799008 | 799008 | 2020-12-05 | Tompkins | New York | 36109 | 1279 | 4 |
795763 | 795763 | 2020-12-04 | Tompkins | New York | 36109 | 1241 | 4 |
792518 | 792518 | 2020-12-03 | Tompkins | New York | 36109 | 1209 | 4 |
789273 | 789273 | 2020-12-02 | Tompkins | New York | 36109 | 1154 | 4 |
786028 | 786028 | 2020-12-01 | Tompkins | New York | 36109 | 1139 | 3 |
782784 | 782784 | 2020-11-30 | Tompkins | New York | 36109 | 1118 | 2 |
779538 | 779538 | 2020-11-29 | Tompkins | New York | 36109 | 1105 | 2 |
776293 | 776293 | 2020-11-28 | Tompkins | New York | 36109 | 1076 | 2 |
773048 | 773048 | 2020-11-27 | Tompkins | New York | 36109 | 1043 | 0 |
769803 | 769803 | 2020-11-26 | Tompkins | New York | 36109 | 1000 | 0 |
766557 | 766557 | 2020-11-25 | Tompkins | New York | 36109 | 971 | 0 |
763312 | 763312 | 2020-11-24 | Tompkins | New York | 36109 | 953 | 0 |
760067 | 760067 | 2020-11-23 | Tompkins | New York | 36109 | 936 | 0 |
756821 | 756821 | 2020-11-22 | Tompkins | New York | 36109 | 904 | 0 |
753574 | 753574 | 2020-11-21 | Tompkins | New York | 36109 | 876 | 0 |
750328 | 750328 | 2020-11-20 | Tompkins | New York | 36109 | 848 | 0 |
747082 | 747082 | 2020-11-19 | Tompkins | New York | 36109 | 840 | 0 |
743836 | 743836 | 2020-11-18 | Tompkins | New York | 36109 | 828 | 0 |
740589 | 740589 | 2020-11-17 | Tompkins | New York | 36109 | 820 | 0 |
737344 | 737344 | 2020-11-16 | Tompkins | New York | 36109 | 811 | 0 |
734100 | 734100 | 2020-11-15 | Tompkins | New York | 36109 | 806 | 0 |
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);