ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
709 rows where county = "Custer" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419604 | 1419604 | 2021-06-14 | Custer | South Dakota | 46033 | 876 | 13 |
1416359 | 1416359 | 2021-06-13 | Custer | South Dakota | 46033 | 876 | 13 |
1413113 | 1413113 | 2021-06-12 | Custer | South Dakota | 46033 | 876 | 13 |
1409868 | 1409868 | 2021-06-11 | Custer | South Dakota | 46033 | 876 | 13 |
1406623 | 1406623 | 2021-06-10 | Custer | South Dakota | 46033 | 876 | 13 |
1403377 | 1403377 | 2021-06-09 | Custer | South Dakota | 46033 | 876 | 12 |
1400132 | 1400132 | 2021-06-08 | Custer | South Dakota | 46033 | 876 | 12 |
1396887 | 1396887 | 2021-06-07 | Custer | South Dakota | 46033 | 875 | 12 |
1393640 | 1393640 | 2021-06-06 | Custer | South Dakota | 46033 | 875 | 12 |
1390395 | 1390395 | 2021-06-05 | Custer | South Dakota | 46033 | 875 | 12 |
1387150 | 1387150 | 2021-06-04 | Custer | South Dakota | 46033 | 875 | 12 |
1383905 | 1383905 | 2021-06-03 | Custer | South Dakota | 46033 | 875 | 12 |
1380659 | 1380659 | 2021-06-02 | Custer | South Dakota | 46033 | 874 | 12 |
1377414 | 1377414 | 2021-06-01 | Custer | South Dakota | 46033 | 873 | 12 |
1374168 | 1374168 | 2021-05-31 | Custer | South Dakota | 46033 | 873 | 12 |
1370923 | 1370923 | 2021-05-30 | Custer | South Dakota | 46033 | 873 | 12 |
1367677 | 1367677 | 2021-05-29 | Custer | South Dakota | 46033 | 873 | 12 |
1364431 | 1364431 | 2021-05-28 | Custer | South Dakota | 46033 | 873 | 12 |
1361185 | 1361185 | 2021-05-27 | Custer | South Dakota | 46033 | 873 | 12 |
1357939 | 1357939 | 2021-05-26 | Custer | South Dakota | 46033 | 873 | 12 |
1354693 | 1354693 | 2021-05-25 | Custer | South Dakota | 46033 | 872 | 12 |
1351447 | 1351447 | 2021-05-24 | Custer | South Dakota | 46033 | 871 | 12 |
1348201 | 1348201 | 2021-05-23 | Custer | South Dakota | 46033 | 871 | 12 |
1344953 | 1344953 | 2021-05-22 | Custer | South Dakota | 46033 | 871 | 12 |
1341705 | 1341705 | 2021-05-21 | Custer | South Dakota | 46033 | 871 | 12 |
1338457 | 1338457 | 2021-05-20 | Custer | South Dakota | 46033 | 870 | 12 |
1335210 | 1335210 | 2021-05-19 | Custer | South Dakota | 46033 | 869 | 12 |
1331963 | 1331963 | 2021-05-18 | Custer | South Dakota | 46033 | 866 | 12 |
1328716 | 1328716 | 2021-05-17 | Custer | South Dakota | 46033 | 861 | 12 |
1325470 | 1325470 | 2021-05-16 | Custer | South Dakota | 46033 | 860 | 12 |
1322224 | 1322224 | 2021-05-15 | Custer | South Dakota | 46033 | 860 | 12 |
1318978 | 1318978 | 2021-05-14 | Custer | South Dakota | 46033 | 860 | 12 |
1315730 | 1315730 | 2021-05-13 | Custer | South Dakota | 46033 | 859 | 12 |
1312484 | 1312484 | 2021-05-12 | Custer | South Dakota | 46033 | 856 | 12 |
1309237 | 1309237 | 2021-05-11 | Custer | South Dakota | 46033 | 853 | 12 |
1305991 | 1305991 | 2021-05-10 | Custer | South Dakota | 46033 | 846 | 12 |
1302745 | 1302745 | 2021-05-09 | Custer | South Dakota | 46033 | 845 | 12 |
1299498 | 1299498 | 2021-05-08 | Custer | South Dakota | 46033 | 845 | 12 |
1296251 | 1296251 | 2021-05-07 | Custer | South Dakota | 46033 | 845 | 12 |
1293005 | 1293005 | 2021-05-06 | Custer | South Dakota | 46033 | 841 | 12 |
1289759 | 1289759 | 2021-05-05 | Custer | South Dakota | 46033 | 840 | 12 |
1286513 | 1286513 | 2021-05-04 | Custer | South Dakota | 46033 | 838 | 12 |
1283267 | 1283267 | 2021-05-03 | Custer | South Dakota | 46033 | 834 | 12 |
1280020 | 1280020 | 2021-05-02 | Custer | South Dakota | 46033 | 830 | 12 |
1276773 | 1276773 | 2021-05-01 | Custer | South Dakota | 46033 | 830 | 12 |
1273526 | 1273526 | 2021-04-30 | Custer | South Dakota | 46033 | 830 | 12 |
1270279 | 1270279 | 2021-04-29 | Custer | South Dakota | 46033 | 829 | 12 |
1267032 | 1267032 | 2021-04-28 | Custer | South Dakota | 46033 | 828 | 12 |
1263785 | 1263785 | 2021-04-27 | Custer | South Dakota | 46033 | 828 | 12 |
1260538 | 1260538 | 2021-04-26 | Custer | South Dakota | 46033 | 826 | 12 |
1257291 | 1257291 | 2021-04-25 | Custer | South Dakota | 46033 | 826 | 12 |
1254044 | 1254044 | 2021-04-24 | Custer | South Dakota | 46033 | 826 | 12 |
1250797 | 1250797 | 2021-04-23 | Custer | South Dakota | 46033 | 824 | 12 |
1247550 | 1247550 | 2021-04-22 | Custer | South Dakota | 46033 | 824 | 12 |
1244303 | 1244303 | 2021-04-21 | Custer | South Dakota | 46033 | 821 | 12 |
1241056 | 1241056 | 2021-04-20 | Custer | South Dakota | 46033 | 821 | 12 |
1237809 | 1237809 | 2021-04-19 | Custer | South Dakota | 46033 | 821 | 12 |
1234562 | 1234562 | 2021-04-18 | Custer | South Dakota | 46033 | 817 | 12 |
1231314 | 1231314 | 2021-04-17 | Custer | South Dakota | 46033 | 817 | 12 |
1228066 | 1228066 | 2021-04-16 | Custer | South Dakota | 46033 | 814 | 12 |
1224818 | 1224818 | 2021-04-15 | Custer | South Dakota | 46033 | 813 | 12 |
1221571 | 1221571 | 2021-04-14 | Custer | South Dakota | 46033 | 812 | 12 |
1218323 | 1218323 | 2021-04-13 | Custer | South Dakota | 46033 | 811 | 12 |
1215075 | 1215075 | 2021-04-12 | Custer | South Dakota | 46033 | 808 | 12 |
1211828 | 1211828 | 2021-04-11 | Custer | South Dakota | 46033 | 808 | 12 |
1208579 | 1208579 | 2021-04-10 | Custer | South Dakota | 46033 | 808 | 12 |
1205331 | 1205331 | 2021-04-09 | Custer | South Dakota | 46033 | 803 | 12 |
1202083 | 1202083 | 2021-04-08 | Custer | South Dakota | 46033 | 800 | 12 |
1198834 | 1198834 | 2021-04-07 | Custer | South Dakota | 46033 | 798 | 12 |
1195585 | 1195585 | 2021-04-06 | Custer | South Dakota | 46033 | 792 | 12 |
1192337 | 1192337 | 2021-04-05 | Custer | South Dakota | 46033 | 789 | 12 |
1189088 | 1189088 | 2021-04-04 | Custer | South Dakota | 46033 | 789 | 12 |
1185841 | 1185841 | 2021-04-03 | Custer | South Dakota | 46033 | 789 | 12 |
1182594 | 1182594 | 2021-04-02 | Custer | South Dakota | 46033 | 787 | 12 |
1179347 | 1179347 | 2021-04-01 | Custer | South Dakota | 46033 | 781 | 12 |
1176100 | 1176100 | 2021-03-31 | Custer | South Dakota | 46033 | 781 | 12 |
1172853 | 1172853 | 2021-03-30 | Custer | South Dakota | 46033 | 780 | 12 |
1169606 | 1169606 | 2021-03-29 | Custer | South Dakota | 46033 | 779 | 12 |
1166358 | 1166358 | 2021-03-28 | Custer | South Dakota | 46033 | 779 | 12 |
1163110 | 1163110 | 2021-03-27 | Custer | South Dakota | 46033 | 779 | 12 |
1159861 | 1159861 | 2021-03-26 | Custer | South Dakota | 46033 | 779 | 12 |
1156614 | 1156614 | 2021-03-25 | Custer | South Dakota | 46033 | 776 | 12 |
1153367 | 1153367 | 2021-03-24 | Custer | South Dakota | 46033 | 777 | 12 |
1150120 | 1150120 | 2021-03-23 | Custer | South Dakota | 46033 | 776 | 12 |
1146873 | 1146873 | 2021-03-22 | Custer | South Dakota | 46033 | 775 | 12 |
1143626 | 1143626 | 2021-03-21 | Custer | South Dakota | 46033 | 775 | 12 |
1140379 | 1140379 | 2021-03-20 | Custer | South Dakota | 46033 | 775 | 12 |
1137133 | 1137133 | 2021-03-19 | Custer | South Dakota | 46033 | 773 | 12 |
1133887 | 1133887 | 2021-03-18 | Custer | South Dakota | 46033 | 770 | 12 |
1130639 | 1130639 | 2021-03-17 | Custer | South Dakota | 46033 | 769 | 12 |
1127392 | 1127392 | 2021-03-16 | Custer | South Dakota | 46033 | 768 | 12 |
1124146 | 1124146 | 2021-03-15 | Custer | South Dakota | 46033 | 768 | 12 |
1120900 | 1120900 | 2021-03-14 | Custer | South Dakota | 46033 | 768 | 12 |
1117653 | 1117653 | 2021-03-13 | Custer | South Dakota | 46033 | 767 | 12 |
1114406 | 1114406 | 2021-03-12 | Custer | South Dakota | 46033 | 767 | 12 |
1111160 | 1111160 | 2021-03-11 | Custer | South Dakota | 46033 | 767 | 12 |
1107914 | 1107914 | 2021-03-10 | Custer | South Dakota | 46033 | 766 | 12 |
1104668 | 1104668 | 2021-03-09 | Custer | South Dakota | 46033 | 764 | 12 |
1101422 | 1101422 | 2021-03-08 | Custer | South Dakota | 46033 | 764 | 12 |
1098176 | 1098176 | 2021-03-07 | Custer | South Dakota | 46033 | 763 | 12 |
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);