ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Berrien" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054759 | 1054759 | 2021-02-22 | Berrien | Michigan | 26021 | 11421 | 237 |
1051512 | 1051512 | 2021-02-21 | Berrien | Michigan | 26021 | 11383 | 236 |
1048265 | 1048265 | 2021-02-20 | Berrien | Michigan | 26021 | 11383 | 236 |
1045019 | 1045019 | 2021-02-19 | Berrien | Michigan | 26021 | 11376 | 235 |
1041774 | 1041774 | 2021-02-18 | Berrien | Michigan | 26021 | 11356 | 235 |
1038529 | 1038529 | 2021-02-17 | Berrien | Michigan | 26021 | 11340 | 235 |
1035284 | 1035284 | 2021-02-16 | Berrien | Michigan | 26021 | 11309 | 235 |
1032039 | 1032039 | 2021-02-15 | Berrien | Michigan | 26021 | 11285 | 234 |
1028792 | 1028792 | 2021-02-14 | Berrien | Michigan | 26021 | 11265 | 234 |
1025546 | 1025546 | 2021-02-13 | Berrien | Michigan | 26021 | 11256 | 234 |
1022301 | 1022301 | 2021-02-12 | Berrien | Michigan | 26021 | 11213 | 233 |
1019056 | 1019056 | 2021-02-11 | Berrien | Michigan | 26021 | 11213 | 232 |
1015811 | 1015811 | 2021-02-10 | Berrien | Michigan | 26021 | 11194 | 228 |
1012566 | 1012566 | 2021-02-09 | Berrien | Michigan | 26021 | 11172 | 228 |
1009321 | 1009321 | 2021-02-08 | Berrien | Michigan | 26021 | 11151 | 227 |
1006074 | 1006074 | 2021-02-07 | Berrien | Michigan | 26021 | 11121 | 227 |
1002828 | 1002828 | 2021-02-06 | Berrien | Michigan | 26021 | 11108 | 227 |
999583 | 999583 | 2021-02-05 | Berrien | Michigan | 26021 | 11074 | 225 |
996337 | 996337 | 2021-02-04 | Berrien | Michigan | 26021 | 11016 | 225 |
993091 | 993091 | 2021-02-03 | Berrien | Michigan | 26021 | 11016 | 224 |
989845 | 989845 | 2021-02-02 | Berrien | Michigan | 26021 | 10967 | 224 |
986598 | 986598 | 2021-02-01 | Berrien | Michigan | 26021 | 10936 | 224 |
983351 | 983351 | 2021-01-31 | Berrien | Michigan | 26021 | 10898 | 224 |
980105 | 980105 | 2021-01-30 | Berrien | Michigan | 26021 | 10878 | 224 |
976859 | 976859 | 2021-01-29 | Berrien | Michigan | 26021 | 10837 | 222 |
973614 | 973614 | 2021-01-28 | Berrien | Michigan | 26021 | 10792 | 222 |
970369 | 970369 | 2021-01-27 | Berrien | Michigan | 26021 | 10739 | 222 |
967124 | 967124 | 2021-01-26 | Berrien | Michigan | 26021 | 10711 | 222 |
963880 | 963880 | 2021-01-25 | Berrien | Michigan | 26021 | 10651 | 222 |
960635 | 960635 | 2021-01-24 | Berrien | Michigan | 26021 | 10603 | 222 |
957389 | 957389 | 2021-01-23 | Berrien | Michigan | 26021 | 10576 | 222 |
954144 | 954144 | 2021-01-22 | Berrien | Michigan | 26021 | 10539 | 217 |
950899 | 950899 | 2021-01-21 | Berrien | Michigan | 26021 | 10501 | 217 |
947653 | 947653 | 2021-01-20 | Berrien | Michigan | 26021 | 10447 | 213 |
944406 | 944406 | 2021-01-19 | Berrien | Michigan | 26021 | 10397 | 212 |
941161 | 941161 | 2021-01-18 | Berrien | Michigan | 26021 | 10350 | 212 |
937916 | 937916 | 2021-01-17 | Berrien | Michigan | 26021 | 10316 | 212 |
934671 | 934671 | 2021-01-16 | Berrien | Michigan | 26021 | 10271 | 212 |
931426 | 931426 | 2021-01-15 | Berrien | Michigan | 26021 | 10225 | 211 |
928181 | 928181 | 2021-01-14 | Berrien | Michigan | 26021 | 10165 | 210 |
924935 | 924935 | 2021-01-13 | Berrien | Michigan | 26021 | 10112 | 209 |
921690 | 921690 | 2021-01-12 | Berrien | Michigan | 26021 | 10056 | 209 |
918445 | 918445 | 2021-01-11 | Berrien | Michigan | 26021 | 9994 | 205 |
915200 | 915200 | 2021-01-10 | Berrien | Michigan | 26021 | 9929 | 205 |
911955 | 911955 | 2021-01-09 | Berrien | Michigan | 26021 | 9903 | 205 |
908710 | 908710 | 2021-01-08 | Berrien | Michigan | 26021 | 9850 | 205 |
905464 | 905464 | 2021-01-07 | Berrien | Michigan | 26021 | 9790 | 205 |
902219 | 902219 | 2021-01-06 | Berrien | Michigan | 26021 | 9678 | 204 |
898974 | 898974 | 2021-01-05 | Berrien | Michigan | 26021 | 9621 | 203 |
895729 | 895729 | 2021-01-04 | Berrien | Michigan | 26021 | 9572 | 193 |
892482 | 892482 | 2021-01-03 | Berrien | Michigan | 26021 | 9520 | 193 |
889236 | 889236 | 2021-01-02 | Berrien | Michigan | 26021 | 9470 | 193 |
885990 | 885990 | 2021-01-01 | Berrien | Michigan | 26021 | 9411 | 189 |
882745 | 882745 | 2020-12-31 | Berrien | Michigan | 26021 | 9371 | 189 |
879500 | 879500 | 2020-12-30 | Berrien | Michigan | 26021 | 9290 | 189 |
876255 | 876255 | 2020-12-29 | Berrien | Michigan | 26021 | 9191 | 189 |
873010 | 873010 | 2020-12-28 | Berrien | Michigan | 26021 | 9191 | 178 |
869765 | 869765 | 2020-12-27 | Berrien | Michigan | 26021 | 9158 | 178 |
866520 | 866520 | 2020-12-26 | Berrien | Michigan | 26021 | 9125 | 178 |
863275 | 863275 | 2020-12-25 | Berrien | Michigan | 26021 | 9100 | 177 |
860030 | 860030 | 2020-12-24 | Berrien | Michigan | 26021 | 9058 | 177 |
856785 | 856785 | 2020-12-23 | Berrien | Michigan | 26021 | 8982 | 177 |
853540 | 853540 | 2020-12-22 | Berrien | Michigan | 26021 | 8939 | 174 |
850295 | 850295 | 2020-12-21 | Berrien | Michigan | 26021 | 8840 | 169 |
847050 | 847050 | 2020-12-20 | Berrien | Michigan | 26021 | 8840 | 166 |
843804 | 843804 | 2020-12-19 | Berrien | Michigan | 26021 | 8788 | 166 |
840559 | 840559 | 2020-12-18 | Berrien | Michigan | 26021 | 8730 | 162 |
837314 | 837314 | 2020-12-17 | Berrien | Michigan | 26021 | 8657 | 162 |
834068 | 834068 | 2020-12-16 | Berrien | Michigan | 26021 | 8612 | 156 |
830821 | 830821 | 2020-12-15 | Berrien | Michigan | 26021 | 8530 | 154 |
827575 | 827575 | 2020-12-14 | Berrien | Michigan | 26021 | 8471 | 150 |
824328 | 824328 | 2020-12-13 | Berrien | Michigan | 26021 | 8358 | 149 |
821082 | 821082 | 2020-12-12 | Berrien | Michigan | 26021 | 8288 | 149 |
817836 | 817836 | 2020-12-11 | Berrien | Michigan | 26021 | 8203 | 142 |
814590 | 814590 | 2020-12-10 | Berrien | Michigan | 26021 | 8095 | 135 |
811345 | 811345 | 2020-12-09 | Berrien | Michigan | 26021 | 8010 | 132 |
808100 | 808100 | 2020-12-08 | Berrien | Michigan | 26021 | 7893 | 132 |
804855 | 804855 | 2020-12-07 | Berrien | Michigan | 26021 | 7758 | 127 |
801610 | 801610 | 2020-12-06 | Berrien | Michigan | 26021 | 7664 | 127 |
798365 | 798365 | 2020-12-05 | Berrien | Michigan | 26021 | 7553 | 127 |
795120 | 795120 | 2020-12-04 | Berrien | Michigan | 26021 | 7432 | 123 |
791875 | 791875 | 2020-12-03 | Berrien | Michigan | 26021 | 7216 | 121 |
788630 | 788630 | 2020-12-02 | Berrien | Michigan | 26021 | 7095 | 117 |
785385 | 785385 | 2020-12-01 | Berrien | Michigan | 26021 | 6964 | 116 |
782141 | 782141 | 2020-11-30 | Berrien | Michigan | 26021 | 6897 | 115 |
778895 | 778895 | 2020-11-29 | Berrien | Michigan | 26021 | 6825 | 115 |
775650 | 775650 | 2020-11-28 | Berrien | Michigan | 26021 | 6702 | 115 |
772405 | 772405 | 2020-11-27 | Berrien | Michigan | 26021 | 6571 | 114 |
769160 | 769160 | 2020-11-26 | Berrien | Michigan | 26021 | 6332 | 113 |
765914 | 765914 | 2020-11-25 | Berrien | Michigan | 26021 | 6152 | 113 |
762669 | 762669 | 2020-11-24 | Berrien | Michigan | 26021 | 6004 | 108 |
759424 | 759424 | 2020-11-23 | Berrien | Michigan | 26021 | 5954 | 106 |
756177 | 756177 | 2020-11-22 | Berrien | Michigan | 26021 | 5862 | 106 |
752931 | 752931 | 2020-11-21 | Berrien | Michigan | 26021 | 5619 | 106 |
749685 | 749685 | 2020-11-20 | Berrien | Michigan | 26021 | 5405 | 106 |
746439 | 746439 | 2020-11-19 | Berrien | Michigan | 26021 | 5254 | 106 |
743192 | 743192 | 2020-11-18 | Berrien | Michigan | 26021 | 5113 | 103 |
739945 | 739945 | 2020-11-17 | Berrien | Michigan | 26021 | 4979 | 103 |
736701 | 736701 | 2020-11-16 | Berrien | Michigan | 26021 | 4800 | 102 |
733455 | 733455 | 2020-11-15 | Berrien | Michigan | 26021 | 4598 | 102 |
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);