ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Dunklin" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1486819 | 1486819 | 2021-07-05 | Dunklin | Missouri | 29069 | 3111 | 50 |
1483573 | 1483573 | 2021-07-04 | Dunklin | Missouri | 29069 | 3110 | 50 |
1480327 | 1480327 | 2021-07-03 | Dunklin | Missouri | 29069 | 3108 | 50 |
1477080 | 1477080 | 2021-07-02 | Dunklin | Missouri | 29069 | 3108 | 50 |
1473834 | 1473834 | 2021-07-01 | Dunklin | Missouri | 29069 | 3103 | 50 |
1470588 | 1470588 | 2021-06-30 | Dunklin | Missouri | 29069 | 3096 | 50 |
1467343 | 1467343 | 2021-06-29 | Dunklin | Missouri | 29069 | 3086 | 50 |
1464098 | 1464098 | 2021-06-28 | Dunklin | Missouri | 29069 | 3080 | 50 |
1460853 | 1460853 | 2021-06-27 | Dunklin | Missouri | 29069 | 3077 | 50 |
1457608 | 1457608 | 2021-06-26 | Dunklin | Missouri | 29069 | 3077 | 50 |
1454363 | 1454363 | 2021-06-25 | Dunklin | Missouri | 29069 | 3074 | 50 |
1451118 | 1451118 | 2021-06-24 | Dunklin | Missouri | 29069 | 3069 | 50 |
1447872 | 1447872 | 2021-06-23 | Dunklin | Missouri | 29069 | 3061 | 50 |
1444627 | 1444627 | 2021-06-22 | Dunklin | Missouri | 29069 | 3026 | 50 |
1441382 | 1441382 | 2021-06-21 | Dunklin | Missouri | 29069 | 3017 | 50 |
1438136 | 1438136 | 2021-06-20 | Dunklin | Missouri | 29069 | 3016 | 50 |
1434889 | 1434889 | 2021-06-19 | Dunklin | Missouri | 29069 | 3015 | 50 |
1431642 | 1431642 | 2021-06-18 | Dunklin | Missouri | 29069 | 3008 | 50 |
1428397 | 1428397 | 2021-06-17 | Dunklin | Missouri | 29069 | 3004 | 50 |
1425152 | 1425152 | 2021-06-16 | Dunklin | Missouri | 29069 | 2998 | 50 |
1421904 | 1421904 | 2021-06-15 | Dunklin | Missouri | 29069 | 2988 | 50 |
1418659 | 1418659 | 2021-06-14 | Dunklin | Missouri | 29069 | 2983 | 50 |
1415414 | 1415414 | 2021-06-13 | Dunklin | Missouri | 29069 | 2982 | 50 |
1412168 | 1412168 | 2021-06-12 | Dunklin | Missouri | 29069 | 2968 | 50 |
1408923 | 1408923 | 2021-06-11 | Dunklin | Missouri | 29069 | 2962 | 50 |
1405678 | 1405678 | 2021-06-10 | Dunklin | Missouri | 29069 | 2959 | 50 |
1402432 | 1402432 | 2021-06-09 | Dunklin | Missouri | 29069 | 2951 | 50 |
1399187 | 1399187 | 2021-06-08 | Dunklin | Missouri | 29069 | 2936 | 50 |
1395941 | 1395941 | 2021-06-07 | Dunklin | Missouri | 29069 | 2931 | 50 |
1392695 | 1392695 | 2021-06-06 | Dunklin | Missouri | 29069 | 2925 | 50 |
1389450 | 1389450 | 2021-06-05 | Dunklin | Missouri | 29069 | 2925 | 50 |
1386205 | 1386205 | 2021-06-04 | Dunklin | Missouri | 29069 | 2915 | 50 |
1382960 | 1382960 | 2021-06-03 | Dunklin | Missouri | 29069 | 2910 | 50 |
1379714 | 1379714 | 2021-06-02 | Dunklin | Missouri | 29069 | 2908 | 50 |
1376469 | 1376469 | 2021-06-01 | Dunklin | Missouri | 29069 | 2904 | 50 |
1373223 | 1373223 | 2021-05-31 | Dunklin | Missouri | 29069 | 2903 | 50 |
1369978 | 1369978 | 2021-05-30 | Dunklin | Missouri | 29069 | 2903 | 50 |
1366732 | 1366732 | 2021-05-29 | Dunklin | Missouri | 29069 | 2903 | 50 |
1363486 | 1363486 | 2021-05-28 | Dunklin | Missouri | 29069 | 2898 | 50 |
1360239 | 1360239 | 2021-05-27 | Dunklin | Missouri | 29069 | 2885 | 50 |
1356993 | 1356993 | 2021-05-26 | Dunklin | Missouri | 29069 | 2878 | 50 |
1353747 | 1353747 | 2021-05-25 | Dunklin | Missouri | 29069 | 2878 | 50 |
1350501 | 1350501 | 2021-05-24 | Dunklin | Missouri | 29069 | 2877 | 50 |
1347255 | 1347255 | 2021-05-23 | Dunklin | Missouri | 29069 | 2877 | 50 |
1344007 | 1344007 | 2021-05-22 | Dunklin | Missouri | 29069 | 2870 | 50 |
1340758 | 1340758 | 2021-05-21 | Dunklin | Missouri | 29069 | 2864 | 50 |
1337511 | 1337511 | 2021-05-20 | Dunklin | Missouri | 29069 | 2861 | 50 |
1334264 | 1334264 | 2021-05-19 | Dunklin | Missouri | 29069 | 2855 | 50 |
1331017 | 1331017 | 2021-05-18 | Dunklin | Missouri | 29069 | 2854 | 50 |
1327770 | 1327770 | 2021-05-17 | Dunklin | Missouri | 29069 | 2841 | 22 |
1324524 | 1324524 | 2021-05-16 | Dunklin | Missouri | 29069 | 2840 | 22 |
1321278 | 1321278 | 2021-05-15 | Dunklin | Missouri | 29069 | 2840 | 22 |
1318032 | 1318032 | 2021-05-14 | Dunklin | Missouri | 29069 | 2839 | 22 |
1314784 | 1314784 | 2021-05-13 | Dunklin | Missouri | 29069 | 2835 | 22 |
1311538 | 1311538 | 2021-05-12 | Dunklin | Missouri | 29069 | 2833 | 22 |
1308291 | 1308291 | 2021-05-11 | Dunklin | Missouri | 29069 | 2831 | 22 |
1305045 | 1305045 | 2021-05-10 | Dunklin | Missouri | 29069 | 2829 | 22 |
1301799 | 1301799 | 2021-05-09 | Dunklin | Missouri | 29069 | 2828 | 22 |
1298551 | 1298551 | 2021-05-08 | Dunklin | Missouri | 29069 | 2828 | 22 |
1295305 | 1295305 | 2021-05-07 | Dunklin | Missouri | 29069 | 2827 | 22 |
1292059 | 1292059 | 2021-05-06 | Dunklin | Missouri | 29069 | 2824 | 22 |
1288813 | 1288813 | 2021-05-05 | Dunklin | Missouri | 29069 | 2821 | 22 |
1285567 | 1285567 | 2021-05-04 | Dunklin | Missouri | 29069 | 2814 | 22 |
1282321 | 1282321 | 2021-05-03 | Dunklin | Missouri | 29069 | 2810 | 22 |
1279074 | 1279074 | 2021-05-02 | Dunklin | Missouri | 29069 | 2808 | 22 |
1275827 | 1275827 | 2021-05-01 | Dunklin | Missouri | 29069 | 2805 | 22 |
1272580 | 1272580 | 2021-04-30 | Dunklin | Missouri | 29069 | 2801 | 22 |
1269333 | 1269333 | 2021-04-29 | Dunklin | Missouri | 29069 | 2800 | 22 |
1266086 | 1266086 | 2021-04-28 | Dunklin | Missouri | 29069 | 2792 | 22 |
1262839 | 1262839 | 2021-04-27 | Dunklin | Missouri | 29069 | 2790 | 22 |
1259592 | 1259592 | 2021-04-26 | Dunklin | Missouri | 29069 | 2788 | 22 |
1256345 | 1256345 | 2021-04-25 | Dunklin | Missouri | 29069 | 2785 | 22 |
1253098 | 1253098 | 2021-04-24 | Dunklin | Missouri | 29069 | 2785 | 22 |
1249851 | 1249851 | 2021-04-23 | Dunklin | Missouri | 29069 | 2785 | 22 |
1246604 | 1246604 | 2021-04-22 | Dunklin | Missouri | 29069 | 2782 | 22 |
1243357 | 1243357 | 2021-04-21 | Dunklin | Missouri | 29069 | 2776 | 22 |
1240110 | 1240110 | 2021-04-20 | Dunklin | Missouri | 29069 | 2773 | 22 |
1236863 | 1236863 | 2021-04-19 | Dunklin | Missouri | 29069 | 2769 | 21 |
1233616 | 1233616 | 2021-04-18 | Dunklin | Missouri | 29069 | 2768 | 21 |
1230368 | 1230368 | 2021-04-17 | Dunklin | Missouri | 29069 | 2763 | 21 |
1227120 | 1227120 | 2021-04-16 | Dunklin | Missouri | 29069 | 2801 | 21 |
1223872 | 1223872 | 2021-04-15 | Dunklin | Missouri | 29069 | 2798 | 21 |
1220625 | 1220625 | 2021-04-14 | Dunklin | Missouri | 29069 | 2798 | 21 |
1217377 | 1217377 | 2021-04-13 | Dunklin | Missouri | 29069 | 2798 | 21 |
1214130 | 1214130 | 2021-04-12 | Dunklin | Missouri | 29069 | 2798 | 20 |
1210882 | 1210882 | 2021-04-11 | Dunklin | Missouri | 29069 | 2797 | 20 |
1207633 | 1207633 | 2021-04-10 | Dunklin | Missouri | 29069 | 2796 | 20 |
1204385 | 1204385 | 2021-04-09 | Dunklin | Missouri | 29069 | 2791 | 20 |
1201137 | 1201137 | 2021-04-08 | Dunklin | Missouri | 29069 | 2776 | 20 |
1197888 | 1197888 | 2021-04-07 | Dunklin | Missouri | 29069 | 2771 | 20 |
1194639 | 1194639 | 2021-04-06 | Dunklin | Missouri | 29069 | 2767 | 20 |
1191390 | 1191390 | 2021-04-05 | Dunklin | Missouri | 29069 | 2765 | 19 |
1188142 | 1188142 | 2021-04-04 | Dunklin | Missouri | 29069 | 2765 | 19 |
1184895 | 1184895 | 2021-04-03 | Dunklin | Missouri | 29069 | 2761 | 19 |
1181649 | 1181649 | 2021-04-02 | Dunklin | Missouri | 29069 | 2760 | 19 |
1178402 | 1178402 | 2021-04-01 | Dunklin | Missouri | 29069 | 2758 | 19 |
1175155 | 1175155 | 2021-03-31 | Dunklin | Missouri | 29069 | 2751 | 19 |
1171908 | 1171908 | 2021-03-30 | Dunklin | Missouri | 29069 | 2743 | 19 |
1168660 | 1168660 | 2021-03-29 | Dunklin | Missouri | 29069 | 2741 | 19 |
1165412 | 1165412 | 2021-03-28 | Dunklin | Missouri | 29069 | 2741 | 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);