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 |
---|---|---|---|---|---|---|---|
1194361 | 1194361 | 2021-04-06 | Berrien | Michigan | 26021 | 13198 | 253 |
1191112 | 1191112 | 2021-04-05 | Berrien | Michigan | 26021 | 13149 | 252 |
1187864 | 1187864 | 2021-04-04 | Berrien | Michigan | 26021 | 13081 | 252 |
1184617 | 1184617 | 2021-04-03 | Berrien | Michigan | 26021 | 13043 | 252 |
1181371 | 1181371 | 2021-04-02 | Berrien | Michigan | 26021 | 12930 | 251 |
1178124 | 1178124 | 2021-04-01 | Berrien | Michigan | 26021 | 12930 | 251 |
1174877 | 1174877 | 2021-03-31 | Berrien | Michigan | 26021 | 12856 | 251 |
1171630 | 1171630 | 2021-03-30 | Berrien | Michigan | 26021 | 12780 | 250 |
1168382 | 1168382 | 2021-03-29 | Berrien | Michigan | 26021 | 12691 | 250 |
1165134 | 1165134 | 2021-03-28 | Berrien | Michigan | 26021 | 12603 | 250 |
1161886 | 1161886 | 2021-03-27 | Berrien | Michigan | 26021 | 12603 | 250 |
1158638 | 1158638 | 2021-03-26 | Berrien | Michigan | 26021 | 12553 | 250 |
1155391 | 1155391 | 2021-03-25 | Berrien | Michigan | 26021 | 12502 | 250 |
1152144 | 1152144 | 2021-03-24 | Berrien | Michigan | 26021 | 12418 | 249 |
1148897 | 1148897 | 2021-03-23 | Berrien | Michigan | 26021 | 12378 | 249 |
1145650 | 1145650 | 2021-03-22 | Berrien | Michigan | 26021 | 12300 | 248 |
1142403 | 1142403 | 2021-03-21 | Berrien | Michigan | 26021 | 12257 | 248 |
1139156 | 1139156 | 2021-03-20 | Berrien | Michigan | 26021 | 12233 | 248 |
1135910 | 1135910 | 2021-03-19 | Berrien | Michigan | 26021 | 12194 | 247 |
1132664 | 1132664 | 2021-03-18 | Berrien | Michigan | 26021 | 12113 | 247 |
1129416 | 1129416 | 2021-03-17 | Berrien | Michigan | 26021 | 12089 | 248 |
1126169 | 1126169 | 2021-03-16 | Berrien | Michigan | 26021 | 12004 | 248 |
1122923 | 1122923 | 2021-03-15 | Berrien | Michigan | 26021 | 11981 | 247 |
1119676 | 1119676 | 2021-03-14 | Berrien | Michigan | 26021 | 11959 | 247 |
1116429 | 1116429 | 2021-03-13 | Berrien | Michigan | 26021 | 11935 | 247 |
1113183 | 1113183 | 2021-03-12 | Berrien | Michigan | 26021 | 11897 | 246 |
1109937 | 1109937 | 2021-03-11 | Berrien | Michigan | 26021 | 11870 | 245 |
1106691 | 1106691 | 2021-03-10 | Berrien | Michigan | 26021 | 11831 | 245 |
1103445 | 1103445 | 2021-03-09 | Berrien | Michigan | 26021 | 11782 | 245 |
1100199 | 1100199 | 2021-03-08 | Berrien | Michigan | 26021 | 11755 | 245 |
1096952 | 1096952 | 2021-03-07 | Berrien | Michigan | 26021 | 11732 | 245 |
1093705 | 1093705 | 2021-03-06 | Berrien | Michigan | 26021 | 11722 | 245 |
1090459 | 1090459 | 2021-03-05 | Berrien | Michigan | 26021 | 11690 | 245 |
1087214 | 1087214 | 2021-03-04 | Berrien | Michigan | 26021 | 11648 | 245 |
1083969 | 1083969 | 2021-03-03 | Berrien | Michigan | 26021 | 11612 | 242 |
1080723 | 1080723 | 2021-03-02 | Berrien | Michigan | 26021 | 11583 | 242 |
1077477 | 1077477 | 2021-03-01 | Berrien | Michigan | 26021 | 11551 | 242 |
1074231 | 1074231 | 2021-02-28 | Berrien | Michigan | 26021 | 11525 | 242 |
1070985 | 1070985 | 2021-02-27 | Berrien | Michigan | 26021 | 11522 | 242 |
1067740 | 1067740 | 2021-02-26 | Berrien | Michigan | 26021 | 11503 | 239 |
1064495 | 1064495 | 2021-02-25 | Berrien | Michigan | 26021 | 11458 | 239 |
1061251 | 1061251 | 2021-02-24 | Berrien | Michigan | 26021 | 11463 | 238 |
1058005 | 1058005 | 2021-02-23 | Berrien | Michigan | 26021 | 11414 | 238 |
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 |
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);