ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Chenango" 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 |
---|---|---|---|---|---|---|---|
1055359 | 1055359 | 2021-02-22 | Chenango | New York | 36017 | 2383 | 68 |
1052113 | 1052113 | 2021-02-21 | Chenango | New York | 36017 | 2376 | 68 |
1048866 | 1048866 | 2021-02-20 | Chenango | New York | 36017 | 2359 | 68 |
1045619 | 1045619 | 2021-02-19 | Chenango | New York | 36017 | 2344 | 68 |
1042374 | 1042374 | 2021-02-18 | Chenango | New York | 36017 | 2338 | 67 |
1039129 | 1039129 | 2021-02-17 | Chenango | New York | 36017 | 2329 | 67 |
1035884 | 1035884 | 2021-02-16 | Chenango | New York | 36017 | 2328 | 66 |
1032639 | 1032639 | 2021-02-15 | Chenango | New York | 36017 | 2327 | 64 |
1029393 | 1029393 | 2021-02-14 | Chenango | New York | 36017 | 2319 | 63 |
1026146 | 1026146 | 2021-02-13 | Chenango | New York | 36017 | 2307 | 63 |
1022901 | 1022901 | 2021-02-12 | Chenango | New York | 36017 | 2298 | 62 |
1019656 | 1019656 | 2021-02-11 | Chenango | New York | 36017 | 2285 | 61 |
1016411 | 1016411 | 2021-02-10 | Chenango | New York | 36017 | 2266 | 61 |
1013166 | 1013166 | 2021-02-09 | Chenango | New York | 36017 | 2256 | 61 |
1009921 | 1009921 | 2021-02-08 | Chenango | New York | 36017 | 2249 | 61 |
1006675 | 1006675 | 2021-02-07 | Chenango | New York | 36017 | 2237 | 59 |
1003429 | 1003429 | 2021-02-06 | Chenango | New York | 36017 | 2214 | 59 |
1000183 | 1000183 | 2021-02-05 | Chenango | New York | 36017 | 2195 | 58 |
996937 | 996937 | 2021-02-04 | Chenango | New York | 36017 | 2175 | 57 |
993691 | 993691 | 2021-02-03 | Chenango | New York | 36017 | 2146 | 57 |
990445 | 990445 | 2021-02-02 | Chenango | New York | 36017 | 2133 | 57 |
987199 | 987199 | 2021-02-01 | Chenango | New York | 36017 | 2119 | 56 |
983952 | 983952 | 2021-01-31 | Chenango | New York | 36017 | 2110 | 55 |
980705 | 980705 | 2021-01-30 | Chenango | New York | 36017 | 2078 | 54 |
977459 | 977459 | 2021-01-29 | Chenango | New York | 36017 | 2049 | 53 |
974214 | 974214 | 2021-01-28 | Chenango | New York | 36017 | 2001 | 51 |
970969 | 970969 | 2021-01-27 | Chenango | New York | 36017 | 1977 | 51 |
967724 | 967724 | 2021-01-26 | Chenango | New York | 36017 | 1959 | 50 |
964480 | 964480 | 2021-01-25 | Chenango | New York | 36017 | 1943 | 48 |
961235 | 961235 | 2021-01-24 | Chenango | New York | 36017 | 1926 | 46 |
957990 | 957990 | 2021-01-23 | Chenango | New York | 36017 | 1888 | 45 |
954744 | 954744 | 2021-01-22 | Chenango | New York | 36017 | 1850 | 44 |
951499 | 951499 | 2021-01-21 | Chenango | New York | 36017 | 1821 | 44 |
948254 | 948254 | 2021-01-20 | Chenango | New York | 36017 | 1795 | 44 |
945007 | 945007 | 2021-01-19 | Chenango | New York | 36017 | 1758 | 42 |
941761 | 941761 | 2021-01-18 | Chenango | New York | 36017 | 1750 | 40 |
938516 | 938516 | 2021-01-17 | Chenango | New York | 36017 | 1704 | 39 |
935271 | 935271 | 2021-01-16 | Chenango | New York | 36017 | 1680 | 39 |
932026 | 932026 | 2021-01-15 | Chenango | New York | 36017 | 1654 | 38 |
928781 | 928781 | 2021-01-14 | Chenango | New York | 36017 | 1612 | 37 |
925536 | 925536 | 2021-01-13 | Chenango | New York | 36017 | 1581 | 35 |
922290 | 922290 | 2021-01-12 | Chenango | New York | 36017 | 1558 | 33 |
919045 | 919045 | 2021-01-11 | Chenango | New York | 36017 | 1529 | 33 |
915800 | 915800 | 2021-01-10 | Chenango | New York | 36017 | 1502 | 31 |
912555 | 912555 | 2021-01-09 | Chenango | New York | 36017 | 1471 | 28 |
909310 | 909310 | 2021-01-08 | Chenango | New York | 36017 | 1430 | 28 |
906065 | 906065 | 2021-01-07 | Chenango | New York | 36017 | 1393 | 26 |
902819 | 902819 | 2021-01-06 | Chenango | New York | 36017 | 1357 | 26 |
899574 | 899574 | 2021-01-05 | Chenango | New York | 36017 | 1337 | 24 |
896329 | 896329 | 2021-01-04 | Chenango | New York | 36017 | 1326 | 24 |
893083 | 893083 | 2021-01-03 | Chenango | New York | 36017 | 1296 | 23 |
889837 | 889837 | 2021-01-02 | Chenango | New York | 36017 | 1275 | 21 |
886590 | 886590 | 2021-01-01 | Chenango | New York | 36017 | 1250 | 21 |
883345 | 883345 | 2020-12-31 | Chenango | New York | 36017 | 1214 | 21 |
880100 | 880100 | 2020-12-30 | Chenango | New York | 36017 | 1179 | 20 |
876855 | 876855 | 2020-12-29 | Chenango | New York | 36017 | 1160 | 18 |
873610 | 873610 | 2020-12-28 | Chenango | New York | 36017 | 1129 | 18 |
870365 | 870365 | 2020-12-27 | Chenango | New York | 36017 | 1108 | 17 |
867120 | 867120 | 2020-12-26 | Chenango | New York | 36017 | 1102 | 16 |
863875 | 863875 | 2020-12-25 | Chenango | New York | 36017 | 1074 | 16 |
860630 | 860630 | 2020-12-24 | Chenango | New York | 36017 | 1036 | 16 |
857385 | 857385 | 2020-12-23 | Chenango | New York | 36017 | 1020 | 16 |
854140 | 854140 | 2020-12-22 | Chenango | New York | 36017 | 996 | 15 |
850895 | 850895 | 2020-12-21 | Chenango | New York | 36017 | 988 | 15 |
847650 | 847650 | 2020-12-20 | Chenango | New York | 36017 | 972 | 15 |
844405 | 844405 | 2020-12-19 | Chenango | New York | 36017 | 962 | 15 |
841159 | 841159 | 2020-12-18 | Chenango | New York | 36017 | 945 | 14 |
837914 | 837914 | 2020-12-17 | Chenango | New York | 36017 | 928 | 14 |
834668 | 834668 | 2020-12-16 | Chenango | New York | 36017 | 917 | 13 |
831422 | 831422 | 2020-12-15 | Chenango | New York | 36017 | 892 | 13 |
828175 | 828175 | 2020-12-14 | Chenango | New York | 36017 | 880 | 13 |
824929 | 824929 | 2020-12-13 | Chenango | New York | 36017 | 868 | 13 |
821682 | 821682 | 2020-12-12 | Chenango | New York | 36017 | 835 | 11 |
818436 | 818436 | 2020-12-11 | Chenango | New York | 36017 | 815 | 10 |
815190 | 815190 | 2020-12-10 | Chenango | New York | 36017 | 781 | 10 |
811945 | 811945 | 2020-12-09 | Chenango | New York | 36017 | 767 | 10 |
808700 | 808700 | 2020-12-08 | Chenango | New York | 36017 | 754 | 10 |
805455 | 805455 | 2020-12-07 | Chenango | New York | 36017 | 739 | 10 |
802210 | 802210 | 2020-12-06 | Chenango | New York | 36017 | 724 | 10 |
798965 | 798965 | 2020-12-05 | Chenango | New York | 36017 | 710 | 10 |
795720 | 795720 | 2020-12-04 | Chenango | New York | 36017 | 682 | 8 |
792475 | 792475 | 2020-12-03 | Chenango | New York | 36017 | 665 | 8 |
789230 | 789230 | 2020-12-02 | Chenango | New York | 36017 | 652 | 7 |
785985 | 785985 | 2020-12-01 | Chenango | New York | 36017 | 649 | 7 |
782741 | 782741 | 2020-11-30 | Chenango | New York | 36017 | 643 | 7 |
779495 | 779495 | 2020-11-29 | Chenango | New York | 36017 | 639 | 7 |
776250 | 776250 | 2020-11-28 | Chenango | New York | 36017 | 629 | 7 |
773005 | 773005 | 2020-11-27 | Chenango | New York | 36017 | 623 | 7 |
769760 | 769760 | 2020-11-26 | Chenango | New York | 36017 | 605 | 7 |
766514 | 766514 | 2020-11-25 | Chenango | New York | 36017 | 602 | 7 |
763269 | 763269 | 2020-11-24 | Chenango | New York | 36017 | 583 | 7 |
760024 | 760024 | 2020-11-23 | Chenango | New York | 36017 | 578 | 7 |
756778 | 756778 | 2020-11-22 | Chenango | New York | 36017 | 563 | 7 |
753531 | 753531 | 2020-11-21 | Chenango | New York | 36017 | 551 | 7 |
750285 | 750285 | 2020-11-20 | Chenango | New York | 36017 | 542 | 7 |
747039 | 747039 | 2020-11-19 | Chenango | New York | 36017 | 531 | 7 |
743793 | 743793 | 2020-11-18 | Chenango | New York | 36017 | 518 | 7 |
740546 | 740546 | 2020-11-17 | Chenango | New York | 36017 | 512 | 7 |
737301 | 737301 | 2020-11-16 | Chenango | New York | 36017 | 506 | 7 |
734057 | 734057 | 2020-11-15 | Chenango | New York | 36017 | 501 | 7 |
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);