ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Pope" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418515 | 1418515 | 2021-06-14 | Pope | Minnesota | 27121 | 1129 | 6 |
1415270 | 1415270 | 2021-06-13 | Pope | Minnesota | 27121 | 1129 | 6 |
1412024 | 1412024 | 2021-06-12 | Pope | Minnesota | 27121 | 1129 | 6 |
1408779 | 1408779 | 2021-06-11 | Pope | Minnesota | 27121 | 1129 | 6 |
1405534 | 1405534 | 2021-06-10 | Pope | Minnesota | 27121 | 1128 | 6 |
1402288 | 1402288 | 2021-06-09 | Pope | Minnesota | 27121 | 1129 | 6 |
1399043 | 1399043 | 2021-06-08 | Pope | Minnesota | 27121 | 1129 | 6 |
1395797 | 1395797 | 2021-06-07 | Pope | Minnesota | 27121 | 1129 | 6 |
1392551 | 1392551 | 2021-06-06 | Pope | Minnesota | 27121 | 1129 | 6 |
1389306 | 1389306 | 2021-06-05 | Pope | Minnesota | 27121 | 1129 | 6 |
1386061 | 1386061 | 2021-06-04 | Pope | Minnesota | 27121 | 1128 | 6 |
1382816 | 1382816 | 2021-06-03 | Pope | Minnesota | 27121 | 1126 | 6 |
1379570 | 1379570 | 2021-06-02 | Pope | Minnesota | 27121 | 1126 | 6 |
1376325 | 1376325 | 2021-06-01 | Pope | Minnesota | 27121 | 1126 | 6 |
1373079 | 1373079 | 2021-05-31 | Pope | Minnesota | 27121 | 1126 | 6 |
1369834 | 1369834 | 2021-05-30 | Pope | Minnesota | 27121 | 1126 | 6 |
1366588 | 1366588 | 2021-05-29 | Pope | Minnesota | 27121 | 1125 | 6 |
1363342 | 1363342 | 2021-05-28 | Pope | Minnesota | 27121 | 1124 | 6 |
1360095 | 1360095 | 2021-05-27 | Pope | Minnesota | 27121 | 1125 | 6 |
1356849 | 1356849 | 2021-05-26 | Pope | Minnesota | 27121 | 1122 | 6 |
1353603 | 1353603 | 2021-05-25 | Pope | Minnesota | 27121 | 1120 | 6 |
1350357 | 1350357 | 2021-05-24 | Pope | Minnesota | 27121 | 1120 | 6 |
1347111 | 1347111 | 2021-05-23 | Pope | Minnesota | 27121 | 1120 | 6 |
1343863 | 1343863 | 2021-05-22 | Pope | Minnesota | 27121 | 1120 | 6 |
1340614 | 1340614 | 2021-05-21 | Pope | Minnesota | 27121 | 1116 | 6 |
1337367 | 1337367 | 2021-05-20 | Pope | Minnesota | 27121 | 1115 | 6 |
1334120 | 1334120 | 2021-05-19 | Pope | Minnesota | 27121 | 1111 | 6 |
1330873 | 1330873 | 2021-05-18 | Pope | Minnesota | 27121 | 1110 | 6 |
1327626 | 1327626 | 2021-05-17 | Pope | Minnesota | 27121 | 1110 | 6 |
1324380 | 1324380 | 2021-05-16 | Pope | Minnesota | 27121 | 1109 | 6 |
1321134 | 1321134 | 2021-05-15 | Pope | Minnesota | 27121 | 1105 | 6 |
1317888 | 1317888 | 2021-05-14 | Pope | Minnesota | 27121 | 1102 | 6 |
1314640 | 1314640 | 2021-05-13 | Pope | Minnesota | 27121 | 1100 | 6 |
1311394 | 1311394 | 2021-05-12 | Pope | Minnesota | 27121 | 1097 | 6 |
1308147 | 1308147 | 2021-05-11 | Pope | Minnesota | 27121 | 1095 | 6 |
1304901 | 1304901 | 2021-05-10 | Pope | Minnesota | 27121 | 1094 | 6 |
1301655 | 1301655 | 2021-05-09 | Pope | Minnesota | 27121 | 1091 | 6 |
1298407 | 1298407 | 2021-05-08 | Pope | Minnesota | 27121 | 1091 | 6 |
1295161 | 1295161 | 2021-05-07 | Pope | Minnesota | 27121 | 1087 | 6 |
1291915 | 1291915 | 2021-05-06 | Pope | Minnesota | 27121 | 1084 | 6 |
1288669 | 1288669 | 2021-05-05 | Pope | Minnesota | 27121 | 1080 | 6 |
1285423 | 1285423 | 2021-05-04 | Pope | Minnesota | 27121 | 1076 | 6 |
1282177 | 1282177 | 2021-05-03 | Pope | Minnesota | 27121 | 1076 | 6 |
1278930 | 1278930 | 2021-05-02 | Pope | Minnesota | 27121 | 1064 | 6 |
1275683 | 1275683 | 2021-05-01 | Pope | Minnesota | 27121 | 1062 | 6 |
1272436 | 1272436 | 2021-04-30 | Pope | Minnesota | 27121 | 1061 | 6 |
1269189 | 1269189 | 2021-04-29 | Pope | Minnesota | 27121 | 1059 | 6 |
1265942 | 1265942 | 2021-04-28 | Pope | Minnesota | 27121 | 1057 | 6 |
1262695 | 1262695 | 2021-04-27 | Pope | Minnesota | 27121 | 1056 | 6 |
1259448 | 1259448 | 2021-04-26 | Pope | Minnesota | 27121 | 1053 | 6 |
1256201 | 1256201 | 2021-04-25 | Pope | Minnesota | 27121 | 1053 | 6 |
1252954 | 1252954 | 2021-04-24 | Pope | Minnesota | 27121 | 1048 | 6 |
1249707 | 1249707 | 2021-04-23 | Pope | Minnesota | 27121 | 1043 | 6 |
1246460 | 1246460 | 2021-04-22 | Pope | Minnesota | 27121 | 1042 | 6 |
1243213 | 1243213 | 2021-04-21 | Pope | Minnesota | 27121 | 1038 | 6 |
1239966 | 1239966 | 2021-04-20 | Pope | Minnesota | 27121 | 1033 | 6 |
1236719 | 1236719 | 2021-04-19 | Pope | Minnesota | 27121 | 1031 | 6 |
1233472 | 1233472 | 2021-04-18 | Pope | Minnesota | 27121 | 1030 | 6 |
1230224 | 1230224 | 2021-04-17 | Pope | Minnesota | 27121 | 1022 | 6 |
1226976 | 1226976 | 2021-04-16 | Pope | Minnesota | 27121 | 1015 | 6 |
1223728 | 1223728 | 2021-04-15 | Pope | Minnesota | 27121 | 1014 | 6 |
1220481 | 1220481 | 2021-04-14 | Pope | Minnesota | 27121 | 994 | 6 |
1217233 | 1217233 | 2021-04-13 | Pope | Minnesota | 27121 | 993 | 6 |
1213986 | 1213986 | 2021-04-12 | Pope | Minnesota | 27121 | 993 | 6 |
1210738 | 1210738 | 2021-04-11 | Pope | Minnesota | 27121 | 992 | 6 |
1207489 | 1207489 | 2021-04-10 | Pope | Minnesota | 27121 | 990 | 6 |
1204241 | 1204241 | 2021-04-09 | Pope | Minnesota | 27121 | 981 | 6 |
1200993 | 1200993 | 2021-04-08 | Pope | Minnesota | 27121 | 977 | 6 |
1197744 | 1197744 | 2021-04-07 | Pope | Minnesota | 27121 | 973 | 6 |
1194495 | 1194495 | 2021-04-06 | Pope | Minnesota | 27121 | 964 | 6 |
1191246 | 1191246 | 2021-04-05 | Pope | Minnesota | 27121 | 960 | 6 |
1187998 | 1187998 | 2021-04-04 | Pope | Minnesota | 27121 | 953 | 6 |
1184751 | 1184751 | 2021-04-03 | Pope | Minnesota | 27121 | 953 | 6 |
1181505 | 1181505 | 2021-04-02 | Pope | Minnesota | 27121 | 946 | 6 |
1178258 | 1178258 | 2021-04-01 | Pope | Minnesota | 27121 | 945 | 6 |
1175011 | 1175011 | 2021-03-31 | Pope | Minnesota | 27121 | 924 | 6 |
1171764 | 1171764 | 2021-03-30 | Pope | Minnesota | 27121 | 924 | 6 |
1168516 | 1168516 | 2021-03-29 | Pope | Minnesota | 27121 | 922 | 6 |
1165268 | 1165268 | 2021-03-28 | Pope | Minnesota | 27121 | 922 | 6 |
1162020 | 1162020 | 2021-03-27 | Pope | Minnesota | 27121 | 903 | 6 |
1158772 | 1158772 | 2021-03-26 | Pope | Minnesota | 27121 | 902 | 6 |
1155525 | 1155525 | 2021-03-25 | Pope | Minnesota | 27121 | 900 | 6 |
1152278 | 1152278 | 2021-03-24 | Pope | Minnesota | 27121 | 892 | 6 |
1149031 | 1149031 | 2021-03-23 | Pope | Minnesota | 27121 | 880 | 6 |
1145784 | 1145784 | 2021-03-22 | Pope | Minnesota | 27121 | 879 | 6 |
1142537 | 1142537 | 2021-03-21 | Pope | Minnesota | 27121 | 876 | 6 |
1139290 | 1139290 | 2021-03-20 | Pope | Minnesota | 27121 | 873 | 6 |
1136044 | 1136044 | 2021-03-19 | Pope | Minnesota | 27121 | 868 | 6 |
1132798 | 1132798 | 2021-03-18 | Pope | Minnesota | 27121 | 861 | 6 |
1129550 | 1129550 | 2021-03-17 | Pope | Minnesota | 27121 | 858 | 6 |
1126303 | 1126303 | 2021-03-16 | Pope | Minnesota | 27121 | 847 | 6 |
1123057 | 1123057 | 2021-03-15 | Pope | Minnesota | 27121 | 846 | 6 |
1119810 | 1119810 | 2021-03-14 | Pope | Minnesota | 27121 | 845 | 6 |
1116563 | 1116563 | 2021-03-13 | Pope | Minnesota | 27121 | 840 | 6 |
1113317 | 1113317 | 2021-03-12 | Pope | Minnesota | 27121 | 834 | 6 |
1110071 | 1110071 | 2021-03-11 | Pope | Minnesota | 27121 | 832 | 6 |
1106825 | 1106825 | 2021-03-10 | Pope | Minnesota | 27121 | 824 | 5 |
1103579 | 1103579 | 2021-03-09 | Pope | Minnesota | 27121 | 820 | 5 |
1100333 | 1100333 | 2021-03-08 | Pope | Minnesota | 27121 | 818 | 5 |
1097086 | 1097086 | 2021-03-07 | Pope | Minnesota | 27121 | 818 | 5 |
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);