ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Sullivan" 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 |
---|---|---|---|---|---|---|---|
1055400 | 1055400 | 2021-02-22 | Sullivan | New York | 36105 | 4629 | 59 |
1052154 | 1052154 | 2021-02-21 | Sullivan | New York | 36105 | 4616 | 59 |
1048907 | 1048907 | 2021-02-20 | Sullivan | New York | 36105 | 4594 | 58 |
1045660 | 1045660 | 2021-02-19 | Sullivan | New York | 36105 | 4576 | 58 |
1042415 | 1042415 | 2021-02-18 | Sullivan | New York | 36105 | 4553 | 58 |
1039170 | 1039170 | 2021-02-17 | Sullivan | New York | 36105 | 4533 | 58 |
1035925 | 1035925 | 2021-02-16 | Sullivan | New York | 36105 | 4506 | 58 |
1032680 | 1032680 | 2021-02-15 | Sullivan | New York | 36105 | 4497 | 58 |
1029434 | 1029434 | 2021-02-14 | Sullivan | New York | 36105 | 4482 | 58 |
1026187 | 1026187 | 2021-02-13 | Sullivan | New York | 36105 | 4468 | 58 |
1022942 | 1022942 | 2021-02-12 | Sullivan | New York | 36105 | 4456 | 58 |
1019697 | 1019697 | 2021-02-11 | Sullivan | New York | 36105 | 4444 | 58 |
1016452 | 1016452 | 2021-02-10 | Sullivan | New York | 36105 | 4424 | 58 |
1013207 | 1013207 | 2021-02-09 | Sullivan | New York | 36105 | 4401 | 58 |
1009962 | 1009962 | 2021-02-08 | Sullivan | New York | 36105 | 4389 | 58 |
1006716 | 1006716 | 2021-02-07 | Sullivan | New York | 36105 | 4375 | 58 |
1003470 | 1003470 | 2021-02-06 | Sullivan | New York | 36105 | 4346 | 57 |
1000224 | 1000224 | 2021-02-05 | Sullivan | New York | 36105 | 4313 | 57 |
996978 | 996978 | 2021-02-04 | Sullivan | New York | 36105 | 4278 | 57 |
993732 | 993732 | 2021-02-03 | Sullivan | New York | 36105 | 4258 | 57 |
990486 | 990486 | 2021-02-02 | Sullivan | New York | 36105 | 4250 | 56 |
987240 | 987240 | 2021-02-01 | Sullivan | New York | 36105 | 4221 | 55 |
983993 | 983993 | 2021-01-31 | Sullivan | New York | 36105 | 4205 | 55 |
980746 | 980746 | 2021-01-30 | Sullivan | New York | 36105 | 4195 | 55 |
977500 | 977500 | 2021-01-29 | Sullivan | New York | 36105 | 4154 | 55 |
974255 | 974255 | 2021-01-28 | Sullivan | New York | 36105 | 4122 | 55 |
971010 | 971010 | 2021-01-27 | Sullivan | New York | 36105 | 4094 | 53 |
967765 | 967765 | 2021-01-26 | Sullivan | New York | 36105 | 4068 | 53 |
964521 | 964521 | 2021-01-25 | Sullivan | New York | 36105 | 4038 | 53 |
961276 | 961276 | 2021-01-24 | Sullivan | New York | 36105 | 4015 | 52 |
958031 | 958031 | 2021-01-23 | Sullivan | New York | 36105 | 3994 | 51 |
954785 | 954785 | 2021-01-22 | Sullivan | New York | 36105 | 3954 | 49 |
951540 | 951540 | 2021-01-21 | Sullivan | New York | 36105 | 3923 | 49 |
948295 | 948295 | 2021-01-20 | Sullivan | New York | 36105 | 3887 | 49 |
945048 | 945048 | 2021-01-19 | Sullivan | New York | 36105 | 3841 | 49 |
941802 | 941802 | 2021-01-18 | Sullivan | New York | 36105 | 3798 | 49 |
938557 | 938557 | 2021-01-17 | Sullivan | New York | 36105 | 3765 | 48 |
935312 | 935312 | 2021-01-16 | Sullivan | New York | 36105 | 3751 | 48 |
932067 | 932067 | 2021-01-15 | Sullivan | New York | 36105 | 3713 | 48 |
928822 | 928822 | 2021-01-14 | Sullivan | New York | 36105 | 3654 | 48 |
925577 | 925577 | 2021-01-13 | Sullivan | New York | 36105 | 3614 | 48 |
922331 | 922331 | 2021-01-12 | Sullivan | New York | 36105 | 3570 | 48 |
919086 | 919086 | 2021-01-11 | Sullivan | New York | 36105 | 3519 | 48 |
915841 | 915841 | 2021-01-10 | Sullivan | New York | 36105 | 3488 | 48 |
912596 | 912596 | 2021-01-09 | Sullivan | New York | 36105 | 3454 | 48 |
909351 | 909351 | 2021-01-08 | Sullivan | New York | 36105 | 3418 | 47 |
906106 | 906106 | 2021-01-07 | Sullivan | New York | 36105 | 3370 | 46 |
902860 | 902860 | 2021-01-06 | Sullivan | New York | 36105 | 3328 | 46 |
899615 | 899615 | 2021-01-05 | Sullivan | New York | 36105 | 3276 | 46 |
896370 | 896370 | 2021-01-04 | Sullivan | New York | 36105 | 3249 | 42 |
893124 | 893124 | 2021-01-03 | Sullivan | New York | 36105 | 3227 | 41 |
889878 | 889878 | 2021-01-02 | Sullivan | New York | 36105 | 3218 | 40 |
886631 | 886631 | 2021-01-01 | Sullivan | New York | 36105 | 3169 | 40 |
883386 | 883386 | 2020-12-31 | Sullivan | New York | 36105 | 3106 | 40 |
880141 | 880141 | 2020-12-30 | Sullivan | New York | 36105 | 3073 | 40 |
876896 | 876896 | 2020-12-29 | Sullivan | New York | 36105 | 3014 | 40 |
873651 | 873651 | 2020-12-28 | Sullivan | New York | 36105 | 2980 | 40 |
870406 | 870406 | 2020-12-27 | Sullivan | New York | 36105 | 2932 | 40 |
867161 | 867161 | 2020-12-26 | Sullivan | New York | 36105 | 2911 | 40 |
863916 | 863916 | 2020-12-25 | Sullivan | New York | 36105 | 2883 | 40 |
860671 | 860671 | 2020-12-24 | Sullivan | New York | 36105 | 2849 | 40 |
857426 | 857426 | 2020-12-23 | Sullivan | New York | 36105 | 2797 | 40 |
854181 | 854181 | 2020-12-22 | Sullivan | New York | 36105 | 2741 | 40 |
850936 | 850936 | 2020-12-21 | Sullivan | New York | 36105 | 2714 | 40 |
847691 | 847691 | 2020-12-20 | Sullivan | New York | 36105 | 2697 | 40 |
844446 | 844446 | 2020-12-19 | Sullivan | New York | 36105 | 2639 | 40 |
841200 | 841200 | 2020-12-18 | Sullivan | New York | 36105 | 2601 | 40 |
837955 | 837955 | 2020-12-17 | Sullivan | New York | 36105 | 2551 | 40 |
834709 | 834709 | 2020-12-16 | Sullivan | New York | 36105 | 2510 | 40 |
831463 | 831463 | 2020-12-15 | Sullivan | New York | 36105 | 2483 | 40 |
828216 | 828216 | 2020-12-14 | Sullivan | New York | 36105 | 2469 | 40 |
824970 | 824970 | 2020-12-13 | Sullivan | New York | 36105 | 2455 | 40 |
821723 | 821723 | 2020-12-12 | Sullivan | New York | 36105 | 2435 | 40 |
818477 | 818477 | 2020-12-11 | Sullivan | New York | 36105 | 2407 | 40 |
815231 | 815231 | 2020-12-10 | Sullivan | New York | 36105 | 2376 | 39 |
811986 | 811986 | 2020-12-09 | Sullivan | New York | 36105 | 2347 | 39 |
808741 | 808741 | 2020-12-08 | Sullivan | New York | 36105 | 2326 | 39 |
805496 | 805496 | 2020-12-07 | Sullivan | New York | 36105 | 2315 | 39 |
802251 | 802251 | 2020-12-06 | Sullivan | New York | 36105 | 2302 | 38 |
799006 | 799006 | 2020-12-05 | Sullivan | New York | 36105 | 2288 | 38 |
795761 | 795761 | 2020-12-04 | Sullivan | New York | 36105 | 2261 | 38 |
792516 | 792516 | 2020-12-03 | Sullivan | New York | 36105 | 2238 | 38 |
789271 | 789271 | 2020-12-02 | Sullivan | New York | 36105 | 2220 | 38 |
786026 | 786026 | 2020-12-01 | Sullivan | New York | 36105 | 2210 | 38 |
782782 | 782782 | 2020-11-30 | Sullivan | New York | 36105 | 2202 | 38 |
779536 | 779536 | 2020-11-29 | Sullivan | New York | 36105 | 2191 | 38 |
776291 | 776291 | 2020-11-28 | Sullivan | New York | 36105 | 2166 | 38 |
773046 | 773046 | 2020-11-27 | Sullivan | New York | 36105 | 2156 | 38 |
769801 | 769801 | 2020-11-26 | Sullivan | New York | 36105 | 2137 | 38 |
766555 | 766555 | 2020-11-25 | Sullivan | New York | 36105 | 2123 | 38 |
763310 | 763310 | 2020-11-24 | Sullivan | New York | 36105 | 2108 | 38 |
760065 | 760065 | 2020-11-23 | Sullivan | New York | 36105 | 2093 | 38 |
756819 | 756819 | 2020-11-22 | Sullivan | New York | 36105 | 2078 | 38 |
753572 | 753572 | 2020-11-21 | Sullivan | New York | 36105 | 2065 | 38 |
750326 | 750326 | 2020-11-20 | Sullivan | New York | 36105 | 2044 | 38 |
747080 | 747080 | 2020-11-19 | Sullivan | New York | 36105 | 2031 | 38 |
743834 | 743834 | 2020-11-18 | Sullivan | New York | 36105 | 2008 | 38 |
740587 | 740587 | 2020-11-17 | Sullivan | New York | 36105 | 1993 | 38 |
737342 | 737342 | 2020-11-16 | Sullivan | New York | 36105 | 1981 | 38 |
734098 | 734098 | 2020-11-15 | Sullivan | New York | 36105 | 1979 | 38 |
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);