ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Barry" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1486538 | 1486538 | 2021-07-05 | Barry | Michigan | 26015 | 5965 | 69 |
1483292 | 1483292 | 2021-07-04 | Barry | Michigan | 26015 | 5965 | 69 |
1480046 | 1480046 | 2021-07-03 | Barry | Michigan | 26015 | 5965 | 69 |
1476799 | 1476799 | 2021-07-02 | Barry | Michigan | 26015 | 5965 | 69 |
1473553 | 1473553 | 2021-07-01 | Barry | Michigan | 26015 | 5965 | 69 |
1470307 | 1470307 | 2021-06-30 | Barry | Michigan | 26015 | 5964 | 69 |
1467062 | 1467062 | 2021-06-29 | Barry | Michigan | 26015 | 5962 | 69 |
1463817 | 1463817 | 2021-06-28 | Barry | Michigan | 26015 | 5962 | 69 |
1460572 | 1460572 | 2021-06-27 | Barry | Michigan | 26015 | 5962 | 69 |
1457327 | 1457327 | 2021-06-26 | Barry | Michigan | 26015 | 5962 | 69 |
1454082 | 1454082 | 2021-06-25 | Barry | Michigan | 26015 | 5962 | 69 |
1450837 | 1450837 | 2021-06-24 | Barry | Michigan | 26015 | 5961 | 69 |
1447591 | 1447591 | 2021-06-23 | Barry | Michigan | 26015 | 5958 | 69 |
1444346 | 1444346 | 2021-06-22 | Barry | Michigan | 26015 | 5954 | 69 |
1441101 | 1441101 | 2021-06-21 | Barry | Michigan | 26015 | 5953 | 69 |
1437855 | 1437855 | 2021-06-20 | Barry | Michigan | 26015 | 5952 | 69 |
1434608 | 1434608 | 2021-06-19 | Barry | Michigan | 26015 | 5952 | 69 |
1431361 | 1431361 | 2021-06-18 | Barry | Michigan | 26015 | 5952 | 69 |
1428116 | 1428116 | 2021-06-17 | Barry | Michigan | 26015 | 5952 | 69 |
1424871 | 1424871 | 2021-06-16 | Barry | Michigan | 26015 | 5950 | 68 |
1421623 | 1421623 | 2021-06-15 | Barry | Michigan | 26015 | 5950 | 68 |
1418378 | 1418378 | 2021-06-14 | Barry | Michigan | 26015 | 5949 | 68 |
1415133 | 1415133 | 2021-06-13 | Barry | Michigan | 26015 | 5948 | 68 |
1411887 | 1411887 | 2021-06-12 | Barry | Michigan | 26015 | 5948 | 68 |
1408642 | 1408642 | 2021-06-11 | Barry | Michigan | 26015 | 5948 | 68 |
1405397 | 1405397 | 2021-06-10 | Barry | Michigan | 26015 | 5949 | 68 |
1402151 | 1402151 | 2021-06-09 | Barry | Michigan | 26015 | 5948 | 68 |
1398906 | 1398906 | 2021-06-08 | Barry | Michigan | 26015 | 5941 | 68 |
1395660 | 1395660 | 2021-06-07 | Barry | Michigan | 26015 | 5939 | 68 |
1392414 | 1392414 | 2021-06-06 | Barry | Michigan | 26015 | 5938 | 68 |
1389169 | 1389169 | 2021-06-05 | Barry | Michigan | 26015 | 5938 | 68 |
1385924 | 1385924 | 2021-06-04 | Barry | Michigan | 26015 | 5935 | 67 |
1382679 | 1382679 | 2021-06-03 | Barry | Michigan | 26015 | 5934 | 67 |
1379433 | 1379433 | 2021-06-02 | Barry | Michigan | 26015 | 5932 | 67 |
1376188 | 1376188 | 2021-06-01 | Barry | Michigan | 26015 | 5926 | 67 |
1372942 | 1372942 | 2021-05-31 | Barry | Michigan | 26015 | 5917 | 67 |
1369697 | 1369697 | 2021-05-30 | Barry | Michigan | 26015 | 5917 | 67 |
1366451 | 1366451 | 2021-05-29 | Barry | Michigan | 26015 | 5917 | 67 |
1363205 | 1363205 | 2021-05-28 | Barry | Michigan | 26015 | 5916 | 67 |
1359958 | 1359958 | 2021-05-27 | Barry | Michigan | 26015 | 5904 | 67 |
1356712 | 1356712 | 2021-05-26 | Barry | Michigan | 26015 | 5901 | 67 |
1353466 | 1353466 | 2021-05-25 | Barry | Michigan | 26015 | 5884 | 67 |
1350220 | 1350220 | 2021-05-24 | Barry | Michigan | 26015 | 5879 | 67 |
1346974 | 1346974 | 2021-05-23 | Barry | Michigan | 26015 | 5871 | 66 |
1343726 | 1343726 | 2021-05-22 | Barry | Michigan | 26015 | 5871 | 66 |
1340477 | 1340477 | 2021-05-21 | Barry | Michigan | 26015 | 5866 | 66 |
1337230 | 1337230 | 2021-05-20 | Barry | Michigan | 26015 | 5861 | 65 |
1333983 | 1333983 | 2021-05-19 | Barry | Michigan | 26015 | 5850 | 65 |
1330736 | 1330736 | 2021-05-18 | Barry | Michigan | 26015 | 5840 | 65 |
1327489 | 1327489 | 2021-05-17 | Barry | Michigan | 26015 | 5823 | 65 |
1324243 | 1324243 | 2021-05-16 | Barry | Michigan | 26015 | 5808 | 65 |
1320997 | 1320997 | 2021-05-15 | Barry | Michigan | 26015 | 5808 | 65 |
1317751 | 1317751 | 2021-05-14 | Barry | Michigan | 26015 | 5790 | 65 |
1314503 | 1314503 | 2021-05-13 | Barry | Michigan | 26015 | 5769 | 65 |
1311257 | 1311257 | 2021-05-12 | Barry | Michigan | 26015 | 5753 | 64 |
1308010 | 1308010 | 2021-05-11 | Barry | Michigan | 26015 | 5727 | 64 |
1304764 | 1304764 | 2021-05-10 | Barry | Michigan | 26015 | 5715 | 64 |
1301518 | 1301518 | 2021-05-09 | Barry | Michigan | 26015 | 5683 | 64 |
1298270 | 1298270 | 2021-05-08 | Barry | Michigan | 26015 | 5683 | 64 |
1295024 | 1295024 | 2021-05-07 | Barry | Michigan | 26015 | 5666 | 64 |
1291778 | 1291778 | 2021-05-06 | Barry | Michigan | 26015 | 5643 | 64 |
1288532 | 1288532 | 2021-05-05 | Barry | Michigan | 26015 | 5618 | 64 |
1285286 | 1285286 | 2021-05-04 | Barry | Michigan | 26015 | 5592 | 64 |
1282040 | 1282040 | 2021-05-03 | Barry | Michigan | 26015 | 5567 | 63 |
1278793 | 1278793 | 2021-05-02 | Barry | Michigan | 26015 | 5512 | 63 |
1275546 | 1275546 | 2021-05-01 | Barry | Michigan | 26015 | 5512 | 63 |
1272299 | 1272299 | 2021-04-30 | Barry | Michigan | 26015 | 5487 | 62 |
1269052 | 1269052 | 2021-04-29 | Barry | Michigan | 26015 | 5457 | 61 |
1265805 | 1265805 | 2021-04-28 | Barry | Michigan | 26015 | 5414 | 61 |
1262558 | 1262558 | 2021-04-27 | Barry | Michigan | 26015 | 5372 | 61 |
1259311 | 1259311 | 2021-04-26 | Barry | Michigan | 26015 | 5326 | 60 |
1256064 | 1256064 | 2021-04-25 | Barry | Michigan | 26015 | 5262 | 60 |
1252817 | 1252817 | 2021-04-24 | Barry | Michigan | 26015 | 5262 | 60 |
1249570 | 1249570 | 2021-04-23 | Barry | Michigan | 26015 | 5224 | 58 |
1246323 | 1246323 | 2021-04-22 | Barry | Michigan | 26015 | 5184 | 58 |
1243076 | 1243076 | 2021-04-21 | Barry | Michigan | 26015 | 5124 | 58 |
1239829 | 1239829 | 2021-04-20 | Barry | Michigan | 26015 | 5071 | 57 |
1236582 | 1236582 | 2021-04-19 | Barry | Michigan | 26015 | 5006 | 57 |
1233335 | 1233335 | 2021-04-18 | Barry | Michigan | 26015 | 4950 | 57 |
1230087 | 1230087 | 2021-04-17 | Barry | Michigan | 26015 | 4950 | 57 |
1226839 | 1226839 | 2021-04-16 | Barry | Michigan | 26015 | 4906 | 57 |
1223591 | 1223591 | 2021-04-15 | Barry | Michigan | 26015 | 4825 | 54 |
1220344 | 1220344 | 2021-04-14 | Barry | Michigan | 26015 | 4767 | 53 |
1217096 | 1217096 | 2021-04-13 | Barry | Michigan | 26015 | 4698 | 53 |
1213849 | 1213849 | 2021-04-12 | Barry | Michigan | 26015 | 4639 | 53 |
1210601 | 1210601 | 2021-04-11 | Barry | Michigan | 26015 | 4581 | 53 |
1207352 | 1207352 | 2021-04-10 | Barry | Michigan | 26015 | 4581 | 53 |
1204104 | 1204104 | 2021-04-09 | Barry | Michigan | 26015 | 4545 | 53 |
1200856 | 1200856 | 2021-04-08 | Barry | Michigan | 26015 | 4498 | 53 |
1197607 | 1197607 | 2021-04-07 | Barry | Michigan | 26015 | 4465 | 53 |
1194358 | 1194358 | 2021-04-06 | Barry | Michigan | 26015 | 4430 | 53 |
1191109 | 1191109 | 2021-04-05 | Barry | Michigan | 26015 | 4395 | 52 |
1187861 | 1187861 | 2021-04-04 | Barry | Michigan | 26015 | 4344 | 52 |
1184614 | 1184614 | 2021-04-03 | Barry | Michigan | 26015 | 4344 | 52 |
1181368 | 1181368 | 2021-04-02 | Barry | Michigan | 26015 | 4301 | 52 |
1178121 | 1178121 | 2021-04-01 | Barry | Michigan | 26015 | 4266 | 52 |
1174874 | 1174874 | 2021-03-31 | Barry | Michigan | 26015 | 4236 | 52 |
1171627 | 1171627 | 2021-03-30 | Barry | Michigan | 26015 | 4196 | 52 |
1168379 | 1168379 | 2021-03-29 | Barry | Michigan | 26015 | 4170 | 50 |
1165131 | 1165131 | 2021-03-28 | Barry | Michigan | 26015 | 4117 | 50 |
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);