ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,559 rows where county = "Berrien" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277943 | 1277943 | 2021-05-02 | Berrien | Georgia | 13019 | 1828 | 44 |
1278796 | 1278796 | 2021-05-02 | Berrien | Michigan | 26021 | 14689 | 270 |
1274696 | 1274696 | 2021-05-01 | Berrien | Georgia | 13019 | 1828 | 44 |
1275549 | 1275549 | 2021-05-01 | Berrien | Michigan | 26021 | 14676 | 270 |
1271449 | 1271449 | 2021-04-30 | Berrien | Georgia | 13019 | 1828 | 44 |
1272302 | 1272302 | 2021-04-30 | Berrien | Michigan | 26021 | 14663 | 268 |
1268202 | 1268202 | 2021-04-29 | Berrien | Georgia | 13019 | 1825 | 44 |
1269055 | 1269055 | 2021-04-29 | Berrien | Michigan | 26021 | 14640 | 268 |
1264955 | 1264955 | 2021-04-28 | Berrien | Georgia | 13019 | 1823 | 43 |
1265808 | 1265808 | 2021-04-28 | Berrien | Michigan | 26021 | 14569 | 267 |
1261708 | 1261708 | 2021-04-27 | Berrien | Georgia | 13019 | 1823 | 43 |
1262561 | 1262561 | 2021-04-27 | Berrien | Michigan | 26021 | 14516 | 267 |
1258461 | 1258461 | 2021-04-26 | Berrien | Georgia | 13019 | 1821 | 43 |
1259314 | 1259314 | 2021-04-26 | Berrien | Michigan | 26021 | 14465 | 265 |
1255214 | 1255214 | 2021-04-25 | Berrien | Georgia | 13019 | 1821 | 43 |
1256067 | 1256067 | 2021-04-25 | Berrien | Michigan | 26021 | 14420 | 265 |
1251967 | 1251967 | 2021-04-24 | Berrien | Georgia | 13019 | 1820 | 43 |
1252820 | 1252820 | 2021-04-24 | Berrien | Michigan | 26021 | 14384 | 265 |
1248720 | 1248720 | 2021-04-23 | Berrien | Georgia | 13019 | 1821 | 43 |
1249573 | 1249573 | 2021-04-23 | Berrien | Michigan | 26021 | 14334 | 264 |
1245473 | 1245473 | 2021-04-22 | Berrien | Georgia | 13019 | 1820 | 43 |
1246326 | 1246326 | 2021-04-22 | Berrien | Michigan | 26021 | 14283 | 264 |
1242226 | 1242226 | 2021-04-21 | Berrien | Georgia | 13019 | 1820 | 43 |
1243079 | 1243079 | 2021-04-21 | Berrien | Michigan | 26021 | 14227 | 261 |
1238979 | 1238979 | 2021-04-20 | Berrien | Georgia | 13019 | 1819 | 43 |
1239832 | 1239832 | 2021-04-20 | Berrien | Michigan | 26021 | 14160 | 259 |
1235732 | 1235732 | 2021-04-19 | Berrien | Georgia | 13019 | 1819 | 43 |
1236585 | 1236585 | 2021-04-19 | Berrien | Michigan | 26021 | 14104 | 260 |
1232485 | 1232485 | 2021-04-18 | Berrien | Georgia | 13019 | 1818 | 42 |
1233338 | 1233338 | 2021-04-18 | Berrien | Michigan | 26021 | 14044 | 259 |
1229236 | 1229236 | 2021-04-17 | Berrien | Georgia | 13019 | 1817 | 42 |
1230090 | 1230090 | 2021-04-17 | Berrien | Michigan | 26021 | 14012 | 259 |
1225988 | 1225988 | 2021-04-16 | Berrien | Georgia | 13019 | 1814 | 42 |
1226842 | 1226842 | 2021-04-16 | Berrien | Michigan | 26021 | 13943 | 259 |
1222741 | 1222741 | 2021-04-15 | Berrien | Georgia | 13019 | 1812 | 42 |
1223594 | 1223594 | 2021-04-15 | Berrien | Michigan | 26021 | 13847 | 259 |
1219493 | 1219493 | 2021-04-14 | Berrien | Georgia | 13019 | 1813 | 42 |
1220347 | 1220347 | 2021-04-14 | Berrien | Michigan | 26021 | 13795 | 259 |
1216245 | 1216245 | 2021-04-13 | Berrien | Georgia | 13019 | 1810 | 42 |
1217099 | 1217099 | 2021-04-13 | Berrien | Michigan | 26021 | 13681 | 258 |
1212998 | 1212998 | 2021-04-12 | Berrien | Georgia | 13019 | 1805 | 42 |
1213852 | 1213852 | 2021-04-12 | Berrien | Michigan | 26021 | 13576 | 256 |
1209750 | 1209750 | 2021-04-11 | Berrien | Georgia | 13019 | 1804 | 42 |
1210604 | 1210604 | 2021-04-11 | Berrien | Michigan | 26021 | 13523 | 255 |
1206501 | 1206501 | 2021-04-10 | Berrien | Georgia | 13019 | 1804 | 42 |
1207355 | 1207355 | 2021-04-10 | Berrien | Michigan | 26021 | 13472 | 255 |
1203253 | 1203253 | 2021-04-09 | Berrien | Georgia | 13019 | 1803 | 42 |
1204107 | 1204107 | 2021-04-09 | Berrien | Michigan | 26021 | 13420 | 255 |
1200005 | 1200005 | 2021-04-08 | Berrien | Georgia | 13019 | 1802 | 42 |
1200859 | 1200859 | 2021-04-08 | Berrien | Michigan | 26021 | 13323 | 254 |
1196756 | 1196756 | 2021-04-07 | Berrien | Georgia | 13019 | 1800 | 42 |
1197610 | 1197610 | 2021-04-07 | Berrien | Michigan | 26021 | 13285 | 253 |
1193508 | 1193508 | 2021-04-06 | Berrien | Georgia | 13019 | 1799 | 41 |
1194361 | 1194361 | 2021-04-06 | Berrien | Michigan | 26021 | 13198 | 253 |
1190258 | 1190258 | 2021-04-05 | Berrien | Georgia | 13019 | 1798 | 41 |
1191112 | 1191112 | 2021-04-05 | Berrien | Michigan | 26021 | 13149 | 252 |
1187011 | 1187011 | 2021-04-04 | Berrien | Georgia | 13019 | 1798 | 41 |
1187864 | 1187864 | 2021-04-04 | Berrien | Michigan | 26021 | 13081 | 252 |
1183764 | 1183764 | 2021-04-03 | Berrien | Georgia | 13019 | 1796 | 41 |
1184617 | 1184617 | 2021-04-03 | Berrien | Michigan | 26021 | 13043 | 252 |
1180517 | 1180517 | 2021-04-02 | Berrien | Georgia | 13019 | 1796 | 41 |
1181371 | 1181371 | 2021-04-02 | Berrien | Michigan | 26021 | 12930 | 251 |
1177270 | 1177270 | 2021-04-01 | Berrien | Georgia | 13019 | 1795 | 41 |
1178124 | 1178124 | 2021-04-01 | Berrien | Michigan | 26021 | 12930 | 251 |
1174023 | 1174023 | 2021-03-31 | Berrien | Georgia | 13019 | 1792 | 41 |
1174877 | 1174877 | 2021-03-31 | Berrien | Michigan | 26021 | 12856 | 251 |
1170776 | 1170776 | 2021-03-30 | Berrien | Georgia | 13019 | 1790 | 41 |
1171630 | 1171630 | 2021-03-30 | Berrien | Michigan | 26021 | 12780 | 250 |
1167528 | 1167528 | 2021-03-29 | Berrien | Georgia | 13019 | 1787 | 41 |
1168382 | 1168382 | 2021-03-29 | Berrien | Michigan | 26021 | 12691 | 250 |
1164280 | 1164280 | 2021-03-28 | Berrien | Georgia | 13019 | 1786 | 41 |
1165134 | 1165134 | 2021-03-28 | Berrien | Michigan | 26021 | 12603 | 250 |
1161032 | 1161032 | 2021-03-27 | Berrien | Georgia | 13019 | 1784 | 41 |
1161886 | 1161886 | 2021-03-27 | Berrien | Michigan | 26021 | 12603 | 250 |
1157784 | 1157784 | 2021-03-26 | Berrien | Georgia | 13019 | 1784 | 41 |
1158638 | 1158638 | 2021-03-26 | Berrien | Michigan | 26021 | 12553 | 250 |
1154537 | 1154537 | 2021-03-25 | Berrien | Georgia | 13019 | 1780 | 41 |
1155391 | 1155391 | 2021-03-25 | Berrien | Michigan | 26021 | 12502 | 250 |
1151290 | 1151290 | 2021-03-24 | Berrien | Georgia | 13019 | 1777 | 41 |
1152144 | 1152144 | 2021-03-24 | Berrien | Michigan | 26021 | 12418 | 249 |
1148043 | 1148043 | 2021-03-23 | Berrien | Georgia | 13019 | 1776 | 41 |
1148897 | 1148897 | 2021-03-23 | Berrien | Michigan | 26021 | 12378 | 249 |
1144796 | 1144796 | 2021-03-22 | Berrien | Georgia | 13019 | 1775 | 41 |
1145650 | 1145650 | 2021-03-22 | Berrien | Michigan | 26021 | 12300 | 248 |
1141549 | 1141549 | 2021-03-21 | Berrien | Georgia | 13019 | 1774 | 41 |
1142403 | 1142403 | 2021-03-21 | Berrien | Michigan | 26021 | 12257 | 248 |
1138303 | 1138303 | 2021-03-20 | Berrien | Georgia | 13019 | 1774 | 41 |
1139156 | 1139156 | 2021-03-20 | Berrien | Michigan | 26021 | 12233 | 248 |
1135057 | 1135057 | 2021-03-19 | Berrien | Georgia | 13019 | 1774 | 41 |
1135910 | 1135910 | 2021-03-19 | Berrien | Michigan | 26021 | 12194 | 247 |
1131810 | 1131810 | 2021-03-18 | Berrien | Georgia | 13019 | 1773 | 41 |
1132664 | 1132664 | 2021-03-18 | Berrien | Michigan | 26021 | 12113 | 247 |
1128562 | 1128562 | 2021-03-17 | Berrien | Georgia | 13019 | 1774 | 41 |
1129416 | 1129416 | 2021-03-17 | Berrien | Michigan | 26021 | 12089 | 248 |
1125316 | 1125316 | 2021-03-16 | Berrien | Georgia | 13019 | 1773 | 41 |
1126169 | 1126169 | 2021-03-16 | Berrien | Michigan | 26021 | 12004 | 248 |
1122070 | 1122070 | 2021-03-15 | Berrien | Georgia | 13019 | 1772 | 41 |
1122923 | 1122923 | 2021-03-15 | Berrien | Michigan | 26021 | 11981 | 247 |
1118823 | 1118823 | 2021-03-14 | Berrien | Georgia | 13019 | 1771 | 41 |
1119676 | 1119676 | 2021-03-14 | Berrien | Michigan | 26021 | 11959 | 247 |
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);