ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "McCook" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 343 ✖
- 1341 35
- 814 27
- 2 23
- 1340 22
- 4 19
- 5 18
- 809 14
- 816 14
- 8 13
- 811 13
- 810 12
- 6 11
- 1 10
- 3 8
- 24 8
- 799 8
- 807 8
- 10 7
- 804 7
- 819 7
- 1344 7
- 21 6
- 709 6
- 806 6
- 39 5
- 713 5
- 818 5
- 989 5
- 1074 5
- 1331 5
- 1339 5
- 23 4
- 37 4
- 683 4
- 738 4
- 796 4
- 797 4
- 821 4
- 835 4
- 842 4
- 887 4
- 1101 4
- 1211 4
- 1325 4
- 1335 4
- 13 3
- 17 3
- 26 3
- 53 3
- 718 3
- 739 3
- 765 3
- 766 3
- 770 3
- 803 3
- 820 3
- 851 3
- 870 3
- 881 3
- 895 3
- 902 3
- 911 3
- 923 3
- 944 3
- 971 3
- 1016 3
- 1046 3
- 1067 3
- 1160 3
- 1273 3
- 1296 3
- 1315 3
- 1348 3
- 7 2
- 14 2
- 15 2
- 19 2
- 29 2
- 30 2
- 36 2
- 61 2
- 78 2
- 83 2
- 127 2
- 574 2
- 597 2
- 614 2
- 634 2
- 650 2
- 665 2
- 688 2
- 704 2
- 714 2
- 716 2
- 723 2
- 730 2
- 731 2
- 732 2
- 740 2
- 745 2
- 747 2
- 750 2
- 771 2
- 780 2
- 795 2
- 805 2
- 808 2
- 841 2
- 900 2
- 942 2
- 1068 2
- 9 1
- 12 1
- 16 1
- 22 1
- 27 1
- 28 1
- 32 1
- 33 1
- 41 1
- 44 1
- 47 1
- 49 1
- 52 1
- 54 1
- 58 1
- 59 1
- 60 1
- 66 1
- 67 1
- 68 1
- 70 1
- 71 1
- 75 1
- 77 1
- 80 1
- 85 1
- 88 1
- 91 1
- 92 1
- 93 1
- 96 1
- 97 1
- 98 1
- 106 1
- 113 1
- 117 1
- 120 1
- 132 1
- 137 1
- 139 1
- 142 1
- 146 1
- 150 1
- 151 1
- 154 1
- 163 1
- 164 1
- 171 1
- 177 1
- 179 1
- 183 1
- 187 1
- 188 1
- 192 1
- 205 1
- 213 1
- 220 1
- 223 1
- 225 1
- 234 1
- 250 1
- 259 1
- 282 1
- 302 1
- 307 1
- 315 1
- 324 1
- 332 1
- 351 1
- 361 1
- 379 1
- 395 1
- 401 1
- 411 1
- 438 1
- 453 1
- 475 1
- 490 1
- 499 1
- 512 1
- 525 1
- 538 1
- 546 1
- 551 1
- 556 1
- 561 1
- 565 1
- 583 1
- 589 1
- 596 1
- 604 1
- 606 1
- 607 1
- 611 1
- 617 1
- 618 1
- 621 1
- 627 1
- 630 1
- 635 1
- 637 1
- 644 1
- 646 1
- 653 1
- 658 1
- 661 1
- 669 1
- 670 1
- 672 1
- 673 1
- 689 1
- 695 1
- 697 1
- 699 1
- 705 1
- 707 1
- 710 1
- 711 1
- 715 1
- 719 1
- 721 1
- 724 1
- 725 1
- 726 1
- 727 1
- 728 1
- 734 1
- 736 1
- 741 1
- 744 1
- 753 1
- 756 1
- 757 1
- 759 1
- 772 1
- 776 1
- 778 1
- 781 1
- 783 1
- 784 1
- 789 1
- 798 1
- 801 1
- 802 1
- 812 1
- 813 1
- 823 1
- 826 1
- 828 1
- 833 1
- 836 1
- 845 1
- 849 1
- 850 1
- 852 1
- 858 1
- 864 1
- 867 1
- 872 1
- 875 1
- 876 1
- 878 1
- 882 1
- 883 1
- 884 1
- 885 1
- 888 1
- 892 1
- 894 1
- 897 1
- 898 1
- 903 1
- 906 1
- 907 1
- 908 1
- 912 1
- 913 1
- 920 1
- 922 1
- 927 1
- 939 1
- 947 1
- 959 1
- 961 1
- 967 1
- 974 1
- 982 1
- 991 1
- 1000 1
- 1006 1
- 1012 1
- 1018 1
- 1032 1
- 1034 1
- 1037 1
- 1049 1
- 1055 1
- 1060 1
- 1066 1
- 1073 1
- 1088 1
- 1093 1
- 1104 1
- 1123 1
- 1139 1
- 1148 1
- 1166 1
- 1181 1
- 1190 1
- 1204 1
- 1218 1
- 1253 1
- 1262 1
- 1279 1
- 1289 1
- 1292 1
- 1295 1
- 1297 1
- 1305 1
- 1308 1
- 1313 1
- 1317 1
- 1318 1
- 1322 1
- 1326 1
- 1327 1
- 1328 1
- 1332 1
- 1334 1
- 1336 1
- 1337 1
- 1338 1
state 1
- South Dakota 792
fips 1
- 46087 792
county 1
- McCook · 792 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1869 | 1869 | 2020-03-13 | McCook | South Dakota | 46087 | 1 | 0 |
2233 | 2233 | 2020-03-14 | McCook | South Dakota | 46087 | 1 | 0 |
2658 | 2658 | 2020-03-15 | McCook | South Dakota | 46087 | 1 | 0 |
3124 | 3124 | 2020-03-16 | McCook | South Dakota | 46087 | 1 | 0 |
3657 | 3657 | 2020-03-17 | McCook | South Dakota | 46087 | 1 | 0 |
4277 | 4277 | 2020-03-18 | McCook | South Dakota | 46087 | 1 | 0 |
5022 | 5022 | 2020-03-19 | McCook | South Dakota | 46087 | 1 | 0 |
5903 | 5903 | 2020-03-20 | McCook | South Dakota | 46087 | 1 | 0 |
6913 | 6913 | 2020-03-21 | McCook | South Dakota | 46087 | 1 | 0 |
8035 | 8035 | 2020-03-22 | McCook | South Dakota | 46087 | 1 | 0 |
9252 | 9252 | 2020-03-23 | McCook | South Dakota | 46087 | 2 | 0 |
10579 | 10579 | 2020-03-24 | McCook | South Dakota | 46087 | 2 | 0 |
12054 | 12054 | 2020-03-25 | McCook | South Dakota | 46087 | 2 | 0 |
13676 | 13676 | 2020-03-26 | McCook | South Dakota | 46087 | 2 | 0 |
15426 | 15426 | 2020-03-27 | McCook | South Dakota | 46087 | 2 | 0 |
17284 | 17284 | 2020-03-28 | McCook | South Dakota | 46087 | 2 | 0 |
19227 | 19227 | 2020-03-29 | McCook | South Dakota | 46087 | 2 | 0 |
21280 | 21280 | 2020-03-30 | McCook | South Dakota | 46087 | 2 | 0 |
23418 | 23418 | 2020-03-31 | McCook | South Dakota | 46087 | 2 | 0 |
25616 | 25616 | 2020-04-01 | McCook | South Dakota | 46087 | 2 | 0 |
27893 | 27893 | 2020-04-02 | McCook | South Dakota | 46087 | 2 | 0 |
30228 | 30228 | 2020-04-03 | McCook | South Dakota | 46087 | 2 | 0 |
32619 | 32619 | 2020-04-04 | McCook | South Dakota | 46087 | 2 | 0 |
35055 | 35055 | 2020-04-05 | McCook | South Dakota | 46087 | 2 | 0 |
37530 | 37530 | 2020-04-06 | McCook | South Dakota | 46087 | 2 | 0 |
40053 | 40053 | 2020-04-07 | McCook | South Dakota | 46087 | 2 | 0 |
42613 | 42613 | 2020-04-08 | McCook | South Dakota | 46087 | 2 | 0 |
45201 | 45201 | 2020-04-09 | McCook | South Dakota | 46087 | 2 | 1 |
47818 | 47818 | 2020-04-10 | McCook | South Dakota | 46087 | 2 | 1 |
50475 | 50475 | 2020-04-11 | McCook | South Dakota | 46087 | 2 | 1 |
53148 | 53148 | 2020-04-12 | McCook | South Dakota | 46087 | 2 | 1 |
55834 | 55834 | 2020-04-13 | McCook | South Dakota | 46087 | 2 | 1 |
58537 | 58537 | 2020-04-14 | McCook | South Dakota | 46087 | 2 | 1 |
61252 | 61252 | 2020-04-15 | McCook | South Dakota | 46087 | 3 | 1 |
63978 | 63978 | 2020-04-16 | McCook | South Dakota | 46087 | 3 | 1 |
66724 | 66724 | 2020-04-17 | McCook | South Dakota | 46087 | 3 | 1 |
69482 | 69482 | 2020-04-18 | McCook | South Dakota | 46087 | 3 | 1 |
72249 | 72249 | 2020-04-19 | McCook | South Dakota | 46087 | 3 | 1 |
75024 | 75024 | 2020-04-20 | McCook | South Dakota | 46087 | 3 | 1 |
77806 | 77806 | 2020-04-21 | McCook | South Dakota | 46087 | 3 | 1 |
80596 | 80596 | 2020-04-22 | McCook | South Dakota | 46087 | 3 | 1 |
83395 | 83395 | 2020-04-23 | McCook | South Dakota | 46087 | 4 | 1 |
86199 | 86199 | 2020-04-24 | McCook | South Dakota | 46087 | 4 | 1 |
89013 | 89013 | 2020-04-25 | McCook | South Dakota | 46087 | 4 | 1 |
91830 | 91830 | 2020-04-26 | McCook | South Dakota | 46087 | 4 | 1 |
94658 | 94658 | 2020-04-27 | McCook | South Dakota | 46087 | 4 | 1 |
97498 | 97498 | 2020-04-28 | McCook | South Dakota | 46087 | 4 | 1 |
100348 | 100348 | 2020-04-29 | McCook | South Dakota | 46087 | 4 | 1 |
103201 | 103201 | 2020-04-30 | McCook | South Dakota | 46087 | 4 | 1 |
106064 | 106064 | 2020-05-01 | McCook | South Dakota | 46087 | 4 | 1 |
108931 | 108931 | 2020-05-02 | McCook | South Dakota | 46087 | 4 | 1 |
111805 | 111805 | 2020-05-03 | McCook | South Dakota | 46087 | 4 | 1 |
114687 | 114687 | 2020-05-04 | McCook | South Dakota | 46087 | 4 | 1 |
117643 | 117643 | 2020-05-05 | McCook | South Dakota | 46087 | 4 | 1 |
120606 | 120606 | 2020-05-06 | McCook | South Dakota | 46087 | 4 | 1 |
123584 | 123584 | 2020-05-07 | McCook | South Dakota | 46087 | 4 | 1 |
126567 | 126567 | 2020-05-08 | McCook | South Dakota | 46087 | 4 | 1 |
129556 | 129556 | 2020-05-09 | McCook | South Dakota | 46087 | 4 | 1 |
132545 | 132545 | 2020-05-10 | McCook | South Dakota | 46087 | 4 | 1 |
135536 | 135536 | 2020-05-11 | McCook | South Dakota | 46087 | 4 | 1 |
138526 | 138526 | 2020-05-12 | McCook | South Dakota | 46087 | 5 | 1 |
141522 | 141522 | 2020-05-13 | McCook | South Dakota | 46087 | 5 | 1 |
144518 | 144518 | 2020-05-14 | McCook | South Dakota | 46087 | 5 | 1 |
147519 | 147519 | 2020-05-15 | McCook | South Dakota | 46087 | 5 | 1 |
150527 | 150527 | 2020-05-16 | McCook | South Dakota | 46087 | 5 | 1 |
153538 | 153538 | 2020-05-17 | McCook | South Dakota | 46087 | 5 | 1 |
156555 | 156555 | 2020-05-18 | McCook | South Dakota | 46087 | 5 | 1 |
159576 | 159576 | 2020-05-19 | McCook | South Dakota | 46087 | 5 | 1 |
162603 | 162603 | 2020-05-20 | McCook | South Dakota | 46087 | 5 | 1 |
165632 | 165632 | 2020-05-21 | McCook | South Dakota | 46087 | 5 | 1 |
168668 | 168668 | 2020-05-22 | McCook | South Dakota | 46087 | 5 | 1 |
171707 | 171707 | 2020-05-23 | McCook | South Dakota | 46087 | 5 | 1 |
174750 | 174750 | 2020-05-24 | McCook | South Dakota | 46087 | 5 | 1 |
177794 | 177794 | 2020-05-25 | McCook | South Dakota | 46087 | 5 | 1 |
180837 | 180837 | 2020-05-26 | McCook | South Dakota | 46087 | 5 | 1 |
183887 | 183887 | 2020-05-27 | McCook | South Dakota | 46087 | 5 | 1 |
186944 | 186944 | 2020-05-28 | McCook | South Dakota | 46087 | 5 | 1 |
190008 | 190008 | 2020-05-29 | McCook | South Dakota | 46087 | 5 | 1 |
193073 | 193073 | 2020-05-30 | McCook | South Dakota | 46087 | 6 | 1 |
196143 | 196143 | 2020-05-31 | McCook | South Dakota | 46087 | 6 | 1 |
199216 | 199216 | 2020-06-01 | McCook | South Dakota | 46087 | 6 | 1 |
202291 | 202291 | 2020-06-02 | McCook | South Dakota | 46087 | 6 | 1 |
205370 | 205370 | 2020-06-03 | McCook | South Dakota | 46087 | 6 | 1 |
208452 | 208452 | 2020-06-04 | McCook | South Dakota | 46087 | 6 | 1 |
211534 | 211534 | 2020-06-05 | McCook | South Dakota | 46087 | 6 | 1 |
214621 | 214621 | 2020-06-06 | McCook | South Dakota | 46087 | 6 | 1 |
217711 | 217711 | 2020-06-07 | McCook | South Dakota | 46087 | 6 | 1 |
220803 | 220803 | 2020-06-08 | McCook | South Dakota | 46087 | 6 | 1 |
223898 | 223898 | 2020-06-09 | McCook | South Dakota | 46087 | 6 | 1 |
226998 | 226998 | 2020-06-10 | McCook | South Dakota | 46087 | 7 | 1 |
230102 | 230102 | 2020-06-11 | McCook | South Dakota | 46087 | 7 | 1 |
233207 | 233207 | 2020-06-12 | McCook | South Dakota | 46087 | 8 | 1 |
236312 | 236312 | 2020-06-13 | McCook | South Dakota | 46087 | 8 | 1 |
239420 | 239420 | 2020-06-14 | McCook | South Dakota | 46087 | 8 | 1 |
242530 | 242530 | 2020-06-15 | McCook | South Dakota | 46087 | 8 | 1 |
245642 | 245642 | 2020-06-16 | McCook | South Dakota | 46087 | 8 | 1 |
248755 | 248755 | 2020-06-17 | McCook | South Dakota | 46087 | 8 | 1 |
251870 | 251870 | 2020-06-18 | McCook | South Dakota | 46087 | 8 | 1 |
254985 | 254985 | 2020-06-19 | McCook | South Dakota | 46087 | 8 | 1 |
258111 | 258111 | 2020-06-20 | McCook | South Dakota | 46087 | 8 | 1 |
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);