ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where county = "Lake", deaths = 19 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1317865 | 1317865 | 2021-05-14 | Lake | Minnesota | 27075 | 811 | 19 |
1314617 | 1314617 | 2021-05-13 | Lake | Minnesota | 27075 | 809 | 19 |
1311371 | 1311371 | 2021-05-12 | Lake | Minnesota | 27075 | 809 | 19 |
1308124 | 1308124 | 2021-05-11 | Lake | Minnesota | 27075 | 808 | 19 |
1304878 | 1304878 | 2021-05-10 | Lake | Minnesota | 27075 | 808 | 19 |
1301632 | 1301632 | 2021-05-09 | Lake | Minnesota | 27075 | 808 | 19 |
1298384 | 1298384 | 2021-05-08 | Lake | Minnesota | 27075 | 808 | 19 |
1295138 | 1295138 | 2021-05-07 | Lake | Minnesota | 27075 | 806 | 19 |
1291892 | 1291892 | 2021-05-06 | Lake | Minnesota | 27075 | 806 | 19 |
1288646 | 1288646 | 2021-05-05 | Lake | Minnesota | 27075 | 806 | 19 |
1285400 | 1285400 | 2021-05-04 | Lake | Minnesota | 27075 | 805 | 19 |
1282154 | 1282154 | 2021-05-03 | Lake | Minnesota | 27075 | 803 | 19 |
1278907 | 1278907 | 2021-05-02 | Lake | Minnesota | 27075 | 803 | 19 |
1275660 | 1275660 | 2021-05-01 | Lake | Minnesota | 27075 | 802 | 19 |
1272413 | 1272413 | 2021-04-30 | Lake | Minnesota | 27075 | 800 | 19 |
1269166 | 1269166 | 2021-04-29 | Lake | Minnesota | 27075 | 798 | 19 |
1265919 | 1265919 | 2021-04-28 | Lake | Minnesota | 27075 | 798 | 19 |
1262672 | 1262672 | 2021-04-27 | Lake | Minnesota | 27075 | 797 | 19 |
1259425 | 1259425 | 2021-04-26 | Lake | Minnesota | 27075 | 797 | 19 |
1256178 | 1256178 | 2021-04-25 | Lake | Minnesota | 27075 | 796 | 19 |
1252931 | 1252931 | 2021-04-24 | Lake | Minnesota | 27075 | 795 | 19 |
1249684 | 1249684 | 2021-04-23 | Lake | Minnesota | 27075 | 792 | 19 |
1246437 | 1246437 | 2021-04-22 | Lake | Minnesota | 27075 | 792 | 19 |
1243190 | 1243190 | 2021-04-21 | Lake | Minnesota | 27075 | 788 | 19 |
1239943 | 1239943 | 2021-04-20 | Lake | Minnesota | 27075 | 784 | 19 |
1236696 | 1236696 | 2021-04-19 | Lake | Minnesota | 27075 | 784 | 19 |
1233449 | 1233449 | 2021-04-18 | Lake | Minnesota | 27075 | 784 | 19 |
1230201 | 1230201 | 2021-04-17 | Lake | Minnesota | 27075 | 784 | 19 |
1226953 | 1226953 | 2021-04-16 | Lake | Minnesota | 27075 | 782 | 19 |
1223705 | 1223705 | 2021-04-15 | Lake | Minnesota | 27075 | 780 | 19 |
1220458 | 1220458 | 2021-04-14 | Lake | Minnesota | 27075 | 779 | 19 |
1217210 | 1217210 | 2021-04-13 | Lake | Minnesota | 27075 | 778 | 19 |
1213963 | 1213963 | 2021-04-12 | Lake | Minnesota | 27075 | 778 | 19 |
1210715 | 1210715 | 2021-04-11 | Lake | Minnesota | 27075 | 778 | 19 |
1207466 | 1207466 | 2021-04-10 | Lake | Minnesota | 27075 | 778 | 19 |
1204218 | 1204218 | 2021-04-09 | Lake | Minnesota | 27075 | 777 | 19 |
1200970 | 1200970 | 2021-04-08 | Lake | Minnesota | 27075 | 774 | 19 |
1197721 | 1197721 | 2021-04-07 | Lake | Minnesota | 27075 | 774 | 19 |
1194472 | 1194472 | 2021-04-06 | Lake | Minnesota | 27075 | 772 | 19 |
1191223 | 1191223 | 2021-04-05 | Lake | Minnesota | 27075 | 772 | 19 |
1187975 | 1187975 | 2021-04-04 | Lake | Minnesota | 27075 | 772 | 19 |
1184728 | 1184728 | 2021-04-03 | Lake | Minnesota | 27075 | 772 | 19 |
1181482 | 1181482 | 2021-04-02 | Lake | Minnesota | 27075 | 770 | 19 |
1178235 | 1178235 | 2021-04-01 | Lake | Minnesota | 27075 | 770 | 19 |
1174988 | 1174988 | 2021-03-31 | Lake | Minnesota | 27075 | 769 | 19 |
1171741 | 1171741 | 2021-03-30 | Lake | Minnesota | 27075 | 766 | 19 |
1168493 | 1168493 | 2021-03-29 | Lake | Minnesota | 27075 | 762 | 19 |
1165245 | 1165245 | 2021-03-28 | Lake | Minnesota | 27075 | 762 | 19 |
1161997 | 1161997 | 2021-03-27 | Lake | Minnesota | 27075 | 761 | 19 |
1158749 | 1158749 | 2021-03-26 | Lake | Minnesota | 27075 | 761 | 19 |
1155502 | 1155502 | 2021-03-25 | Lake | Minnesota | 27075 | 760 | 19 |
1152255 | 1152255 | 2021-03-24 | Lake | Minnesota | 27075 | 759 | 19 |
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);