ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "McKinley" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 631 ✖
- 12354 5
- 16517 5
- 12140 4
- 12155 4
- 12339 4
- 12388 4
- 13272 4
- 14178 4
- 17383 4
- 17533 4
- 19773 4
- 3 3
- 12091 3
- 12141 3
- 12186 3
- 12208 3
- 12231 3
- 12259 3
- 12297 3
- 12326 3
- 12349 3
- 12367 3
- 12375 3
- 12422 3
- 12457 3
- 12488 3
- 12543 3
- 12648 3
- 12797 3
- 12935 3
- 13129 3
- 13418 3
- 13541 3
- 13655 3
- 13876 3
- 14432 3
- 14736 3
- 15089 3
- 15476 3
- 15895 3
- 16285 3
- 16914 3
- 17149 3
- 17272 3
- 18340 3
- 21569 3
- 23428 3
- 24440 3
- 24966 3
- 25233 3
- 25396 3
- 25553 3
- 25642 3
- 25680 3
- 25741 3
- 25769 3
- 25811 3
- 25868 3
- 25903 3
- 25917 3
- 25940 3
- 25965 3
- 1 2
- 2 2
- 5 2
- 32 2
- 4244 2
- 4266 2
- 4292 2
- 4355 2
- 12067 2
- 12099 2
- 12244 2
- 12334 2
- 12335 2
- 12371 2
- 12376 2
- 15743 2
- 25954 2
- 9 1
- 12 1
- 16 1
- 20 1
- 24 1
- 40 1
- 44 1
- 55 1
- 70 1
- 84 1
- 113 1
- 140 1
- 144 1
- 191 1
- 204 1
- 242 1
- 265 1
- 316 1
- 356 1
- 363 1
- 416 1
- 460 1
- 519 1
- 573 1
- 639 1
- 708 1
- 720 1
- 778 1
- 820 1
- 953 1
- 1027 1
- 1064 1
- 1116 1
- 1144 1
- 1233 1
- 1274 1
- 1337 1
- 1402 1
- 1460 1
- 1508 1
- 1522 1
- 1585 1
- 1628 1
- 1681 1
- 1730 1
- 1787 1
- 1864 1
- 1888 1
- 1953 1
- 1987 1
- 2009 1
- 2044 1
- 2086 1
- 2128 1
- 2192 1
- 2215 1
- 2236 1
- 2270 1
- 2291 1
- 2348 1
- 2406 1
- 2415 1
- 2451 1
- 2480 1
- 2515 1
- 2542 1
- 2617 1
- 2657 1
- 2694 1
- 2746 1
- 2757 1
- 2807 1
- 2822 1
- 2870 1
- 2896 1
- 2912 1
- 2936 1
- 2949 1
- 2968 1
- 2987 1
- 3009 1
- 3041 1
- 3073 1
- 3105 1
- 3155 1
- 3179 1
- 3215 1
- 3287 1
- 3309 1
- 3336 1
- 3347 1
- 3375 1
- 3395 1
- 3408 1
- 3450 1
- 3483 1
- 3502 1
- 3514 1
- 3525 1
- 3548 1
- 3567 1
- 3600 1
- 3614 1
- 3634 1
- 3657 1
- 3679 1
- 3689 1
- 3709 1
- 3724 1
- 3743 1
- 3754 1
- 3767 1
- 3783 1
- 3818 1
- 3844 1
- 3868 1
- 3896 1
- 3909 1
- 3921 1
- 3934 1
- 3942 1
- 3977 1
- 3988 1
- 3999 1
- 4002 1
- 4004 1
- 4009 1
- 4025 1
- 4033 1
- 4037 1
- 4043 1
- 4046 1
- 4057 1
- 4067 1
- 4077 1
- 4087 1
- 4104 1
- 4119 1
- 4120 1
- 4121 1
- 4125 1
- 4131 1
- 4134 1
- 4141 1
- 4148 1
- 4157 1
- 4159 1
- 4164 1
- 4167 1
- 4170 1
- 4178 1
- 4193 1
- 4195 1
- 4203 1
- 4213 1
- 4223 1
- 4229 1
- 4230 1
- 4239 1
- 4240 1
- 4250 1
- 4252 1
- 4259 1
- 4264 1
- 4278 1
- 4280 1
- 4285 1
- 4290 1
- 4295 1
- 4300 1
- 4304 1
- 4311 1
- 4316 1
- 4317 1
- 4322 1
- 4335 1
- 4338 1
- 4343 1
- 4346 1
- 4353 1
- 4356 1
- 4367 1
- 4375 1
- 4384 1
- 4396 1
- 4405 1
- 4409 1
- 4420 1
- 4429 1
- 4435 1
- 4449 1
- 4454 1
- 4461 1
- 4467 1
- 4476 1
- 4492 1
- 4502 1
- 4509 1
- 4539 1
- 4571 1
- 4596 1
- 4616 1
- 4627 1
- 4649 1
- 4674 1
- 4707 1
- 4729 1
- 4752 1
- 4799 1
- 4822 1
- 4860 1
- 4886 1
- 4911 1
- 4988 1
- 5008 1
- 5044 1
- 5079 1
- 5148 1
- 5166 1
- 5179 1
- 5232 1
- 5276 1
- 5328 1
- 5364 1
- 5438 1
- 5647 1
- 5778 1
- 5990 1
- 6180 1
- 6348 1
- 6532 1
- 6648 1
- 6748 1
- 6846 1
- 6955 1
- 7043 1
- 7128 1
- 7225 1
- 7294 1
- 7382 1
- 7457 1
- 7581 1
- 7630 1
- 7751 1
- 7876 1
- 7987 1
- 8128 1
- 8217 1
- 8313 1
- 8399 1
- 8468 1
- 8541 1
- 8650 1
- 8745 1
- 8856 1
- 8964 1
- 9044 1
- 9085 1
- 9187 1
- 9249 1
- 9321 1
- 9387 1
- 9421 1
- 9449 1
- 9496 1
- 9613 1
- 9713 1
- 9807 1
- 9881 1
- 9955 1
- 9997 1
- 10031 1
- 10124 1
- 10206 1
- 10275 1
- 10374 1
- 10467 1
- 10528 1
- 10569 1
- 10631 1
- 10700 1
- 10762 1
- 10811 1
- 10881 1
- 10917 1
- 10962 1
- 10993 1
- 11009 1
- 11101 1
- 11161 1
- 11213 1
- 11237 1
- 11282 1
- 11315 1
- 11347 1
- 11404 1
- 11446 1
- 11500 1
- 11528 1
- 11559 1
- 11586 1
- 11638 1
- 11662 1
- 11688 1
- 11714 1
- 11736 1
- 11747 1
- 11763 1
- 11776 1
- 11794 1
- 11813 1
- 11844 1
- 11866 1
- 11881 1
- 11887 1
- 11893 1
- 11911 1
- 11930 1
- 11967 1
- 11977 1
- 11981 1
- 11985 1
- 11989 1
- 11999 1
- 12013 1
- 12031 1
- 12034 1
- 12036 1
- 12044 1
- 12050 1
- 12056 1
- 12062 1
- 12073 1
- 12079 1
- 12083 1
- 12089 1
- 12093 1
- 12096 1
- 12101 1
- 12107 1
- 12109 1
- 12110 1
- 12113 1
- 12117 1
- 12124 1
- 12130 1
- 12136 1
- 12138 1
- 12144 1
- 12146 1
- 12153 1
- 12163 1
- 12171 1
- 12173 1
- 12178 1
- 12193 1
- 12196 1
- 12201 1
- 12203 1
- 12216 1
- 12218 1
- 12226 1
- 12227 1
- 12238 1
- 12251 1
- 12273 1
- 12276 1
- 12285 1
- 12289 1
- 12312 1
- 12319 1
- 12323 1
- 12325 1
- 12346 1
- 12348 1
- 12350 1
- 12351 1
- 12353 1
- 12358 1
- 12359 1
- 12360 1
- 12363 1
- 12370 1
- 12374 1
- 12382 1
- 12385 1
- 12403 1
- 12404 1
- 12415 1
- 12433 1
- 12437 1
- 12444 1
- 12455 1
- 12471 1
- 12477 1
- 12481 1
- 12485 1
- 12500 1
- 12504 1
- 12514 1
- 12526 1
- 12583 1
- 12586 1
- 12620 1
- 12636 1
- 12711 1
- 12720 1
- 12747 1
- 12775 1
- 12848 1
- 12853 1
- 12883 1
- 12908 1
- 13023 1
- 13035 1
- 13067 1
- 13098 1
- 13160 1
- 13188 1
- 13214 1
- 13240 1
- 13358 1
- 13390 1
- 13413 1
- 13476 1
- 13485 1
- 13494 1
- 13518 1
- 13594 1
- 13606 1
- 13629 1
- 13638 1
- 13698 1
- 13780 1
- 13786 1
- 13841 1
- 14021 1
- 14055 1
- 14107 1
- 14146 1
- 14294 1
- 14339 1
- 14394 1
- 14530 1
- 14565 1
- 14628 1
- 14685 1
- 14802 1
- 14851 1
- 14938 1
- 15025 1
- 15224 1
- 15268 1
- 15345 1
- 15424 1
- 15614 1
- 15674 1
- 16012 1
- 16052 1
- 16154 1
- 16226 1
- 16414 1
- 16436 1
- 16693 1
- 16723 1
- 16791 1
- 16858 1
- 17014 1
- 17034 1
- 17076 1
- 17113 1
- 17194 1
- 17211 1
- 17233 1
- 17255 1
- 17321 1
- 17331 1
- 17362 1
- 17439 1
- 17449 1
- 17490 1
- 17732 1
- 17778 1
- 17952 1
- 18136 1
- 18854 1
- 18996 1
- 19250 1
- 19496 1
- 20761 1
- 21027 1
- 21260 1
- 22461 1
- 22633 1
- 22904 1
- 23201 1
- 23876 1
- 24007 1
- 24145 1
- 24304 1
- 24675 1
- 24752 1
- 24827 1
- 24874 1
- 25089 1
- 25118 1
- 25168 1
- 25203 1
- 25291 1
- 25319 1
- 25332 1
- 25362 1
- 25426 1
- 25455 1
- 25494 1
- 25521 1
- 25590 1
- 25596 1
- 25613 1
- 25633 1
- 25649 1
- 25657 1
- 25669 1
- 25692 1
- 25705 1
- 25708 1
- 25714 1
- 25729 1
- 25753 1
- 25754 1
- 25761 1
- 25765 1
- 25790 1
- 25793 1
- 25800 1
- 25805 1
- 25831 1
- 25839 1
- 25851 1
- 25861 1
- 25882 1
- 25886 1
- 25896 1
- 25900 1
- 25933 1
- 25946 1
- 25948 1
- 25980 1
- 25983 1
- 25986 1
- 26001 1
- 26007 1
state 1
- New Mexico 785
fips 1
- 35031 785
county 1
- McKinley · 785 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5703 | 5703 | 2020-03-20 | McKinley | New Mexico | 35031 | 1 | 0 |
6697 | 6697 | 2020-03-21 | McKinley | New Mexico | 35031 | 1 | 0 |
7789 | 7789 | 2020-03-22 | McKinley | New Mexico | 35031 | 2 | 0 |
8986 | 8986 | 2020-03-23 | McKinley | New Mexico | 35031 | 2 | 0 |
10292 | 10292 | 2020-03-24 | McKinley | New Mexico | 35031 | 3 | 0 |
11725 | 11725 | 2020-03-25 | McKinley | New Mexico | 35031 | 3 | 0 |
13328 | 13328 | 2020-03-26 | McKinley | New Mexico | 35031 | 3 | 0 |
15060 | 15060 | 2020-03-27 | McKinley | New Mexico | 35031 | 5 | 0 |
16889 | 16889 | 2020-03-28 | McKinley | New Mexico | 35031 | 5 | 0 |
18813 | 18813 | 2020-03-29 | McKinley | New Mexico | 35031 | 9 | 0 |
20851 | 20851 | 2020-03-30 | McKinley | New Mexico | 35031 | 12 | 0 |
22974 | 22974 | 2020-03-31 | McKinley | New Mexico | 35031 | 16 | 0 |
25167 | 25167 | 2020-04-01 | McKinley | New Mexico | 35031 | 20 | 0 |
27427 | 27427 | 2020-04-02 | McKinley | New Mexico | 35031 | 24 | 0 |
29750 | 29750 | 2020-04-03 | McKinley | New Mexico | 35031 | 32 | 0 |
32137 | 32137 | 2020-04-04 | McKinley | New Mexico | 35031 | 32 | 1 |
34568 | 34568 | 2020-04-05 | McKinley | New Mexico | 35031 | 40 | 2 |
37038 | 37038 | 2020-04-06 | McKinley | New Mexico | 35031 | 44 | 2 |
39553 | 39553 | 2020-04-07 | McKinley | New Mexico | 35031 | 55 | 2 |
42110 | 42110 | 2020-04-08 | McKinley | New Mexico | 35031 | 70 | 2 |
44693 | 44693 | 2020-04-09 | McKinley | New Mexico | 35031 | 84 | 2 |
47306 | 47306 | 2020-04-10 | McKinley | New Mexico | 35031 | 113 | 2 |
49960 | 49960 | 2020-04-11 | McKinley | New Mexico | 35031 | 140 | 2 |
52633 | 52633 | 2020-04-12 | McKinley | New Mexico | 35031 | 144 | 2 |
55316 | 55316 | 2020-04-13 | McKinley | New Mexico | 35031 | 191 | 2 |
58016 | 58016 | 2020-04-14 | McKinley | New Mexico | 35031 | 204 | 2 |
60730 | 60730 | 2020-04-15 | McKinley | New Mexico | 35031 | 242 | 2 |
63456 | 63456 | 2020-04-16 | McKinley | New Mexico | 35031 | 265 | 4 |
66198 | 66198 | 2020-04-17 | McKinley | New Mexico | 35031 | 316 | 4 |
68955 | 68955 | 2020-04-18 | McKinley | New Mexico | 35031 | 356 | 5 |
71722 | 71722 | 2020-04-19 | McKinley | New Mexico | 35031 | 363 | 5 |
74497 | 74497 | 2020-04-20 | McKinley | New Mexico | 35031 | 416 | 5 |
77278 | 77278 | 2020-04-21 | McKinley | New Mexico | 35031 | 460 | 6 |
80067 | 80067 | 2020-04-22 | McKinley | New Mexico | 35031 | 519 | 7 |
82866 | 82866 | 2020-04-23 | McKinley | New Mexico | 35031 | 573 | 8 |
85670 | 85670 | 2020-04-24 | McKinley | New Mexico | 35031 | 639 | 9 |
88481 | 88481 | 2020-04-25 | McKinley | New Mexico | 35031 | 708 | 9 |
91296 | 91296 | 2020-04-26 | McKinley | New Mexico | 35031 | 720 | 12 |
94120 | 94120 | 2020-04-27 | McKinley | New Mexico | 35031 | 778 | 12 |
96956 | 96956 | 2020-04-28 | McKinley | New Mexico | 35031 | 820 | 15 |
99803 | 99803 | 2020-04-29 | McKinley | New Mexico | 35031 | 953 | 16 |
102656 | 102656 | 2020-04-30 | McKinley | New Mexico | 35031 | 1027 | 19 |
105518 | 105518 | 2020-05-01 | McKinley | New Mexico | 35031 | 1064 | 20 |
108384 | 108384 | 2020-05-02 | McKinley | New Mexico | 35031 | 1116 | 20 |
111257 | 111257 | 2020-05-03 | McKinley | New Mexico | 35031 | 1144 | 21 |
114138 | 114138 | 2020-05-04 | McKinley | New Mexico | 35031 | 1233 | 21 |
117019 | 117019 | 2020-05-05 | McKinley | New Mexico | 35031 | 1274 | 25 |
119980 | 119980 | 2020-05-06 | McKinley | New Mexico | 35031 | 1337 | 29 |
122955 | 122955 | 2020-05-07 | McKinley | New Mexico | 35031 | 1402 | 31 |
125938 | 125938 | 2020-05-08 | McKinley | New Mexico | 35031 | 1460 | 36 |
128927 | 128927 | 2020-05-09 | McKinley | New Mexico | 35031 | 1508 | 40 |
131916 | 131916 | 2020-05-10 | McKinley | New Mexico | 35031 | 1522 | 46 |
134907 | 134907 | 2020-05-11 | McKinley | New Mexico | 35031 | 1585 | 50 |
137897 | 137897 | 2020-05-12 | McKinley | New Mexico | 35031 | 1628 | 55 |
140893 | 140893 | 2020-05-13 | McKinley | New Mexico | 35031 | 1681 | 57 |
143888 | 143888 | 2020-05-14 | McKinley | New Mexico | 35031 | 1730 | 63 |
146889 | 146889 | 2020-05-15 | McKinley | New Mexico | 35031 | 1787 | 69 |
149896 | 149896 | 2020-05-16 | McKinley | New Mexico | 35031 | 1864 | 73 |
152906 | 152906 | 2020-05-17 | McKinley | New Mexico | 35031 | 1888 | 76 |
155923 | 155923 | 2020-05-18 | McKinley | New Mexico | 35031 | 1953 | 78 |
158941 | 158941 | 2020-05-19 | McKinley | New Mexico | 35031 | 1987 | 79 |
161967 | 161967 | 2020-05-20 | McKinley | New Mexico | 35031 | 2009 | 82 |
164996 | 164996 | 2020-05-21 | McKinley | New Mexico | 35031 | 2044 | 86 |
168032 | 168032 | 2020-05-22 | McKinley | New Mexico | 35031 | 2086 | 87 |
171071 | 171071 | 2020-05-23 | McKinley | New Mexico | 35031 | 2128 | 87 |
174113 | 174113 | 2020-05-24 | McKinley | New Mexico | 35031 | 2192 | 93 |
177156 | 177156 | 2020-05-25 | McKinley | New Mexico | 35031 | 2215 | 94 |
180200 | 180200 | 2020-05-26 | McKinley | New Mexico | 35031 | 2236 | 95 |
183248 | 183248 | 2020-05-27 | McKinley | New Mexico | 35031 | 2270 | 97 |
186305 | 186305 | 2020-05-28 | McKinley | New Mexico | 35031 | 2291 | 100 |
189365 | 189365 | 2020-05-29 | McKinley | New Mexico | 35031 | 2348 | 104 |
192429 | 192429 | 2020-05-30 | McKinley | New Mexico | 35031 | 2406 | 109 |
195499 | 195499 | 2020-05-31 | McKinley | New Mexico | 35031 | 2415 | 110 |
198572 | 198572 | 2020-06-01 | McKinley | New Mexico | 35031 | 2451 | 112 |
201646 | 201646 | 2020-06-02 | McKinley | New Mexico | 35031 | 2480 | 114 |
204723 | 204723 | 2020-06-03 | McKinley | New Mexico | 35031 | 2515 | 119 |
207804 | 207804 | 2020-06-04 | McKinley | New Mexico | 35031 | 2542 | 124 |
210886 | 210886 | 2020-06-05 | McKinley | New Mexico | 35031 | 2617 | 125 |
213970 | 213970 | 2020-06-06 | McKinley | New Mexico | 35031 | 2657 | 129 |
217059 | 217059 | 2020-06-07 | McKinley | New Mexico | 35031 | 2694 | 130 |
220151 | 220151 | 2020-06-08 | McKinley | New Mexico | 35031 | 2746 | 133 |
223246 | 223246 | 2020-06-09 | McKinley | New Mexico | 35031 | 2757 | 134 |
226346 | 226346 | 2020-06-10 | McKinley | New Mexico | 35031 | 2807 | 137 |
229450 | 229450 | 2020-06-11 | McKinley | New Mexico | 35031 | 2822 | 139 |
232555 | 232555 | 2020-06-12 | McKinley | New Mexico | 35031 | 2870 | 141 |
235660 | 235660 | 2020-06-13 | McKinley | New Mexico | 35031 | 2896 | 143 |
238767 | 238767 | 2020-06-14 | McKinley | New Mexico | 35031 | 2912 | 145 |
241877 | 241877 | 2020-06-15 | McKinley | New Mexico | 35031 | 2936 | 148 |
244989 | 244989 | 2020-06-16 | McKinley | New Mexico | 35031 | 2949 | 151 |
248102 | 248102 | 2020-06-17 | McKinley | New Mexico | 35031 | 2968 | 152 |
251217 | 251217 | 2020-06-18 | McKinley | New Mexico | 35031 | 2987 | 153 |
254332 | 254332 | 2020-06-19 | McKinley | New Mexico | 35031 | 3009 | 157 |
257455 | 257455 | 2020-06-20 | McKinley | New Mexico | 35031 | 3041 | 159 |
260581 | 260581 | 2020-06-21 | McKinley | New Mexico | 35031 | 3073 | 161 |
263710 | 263710 | 2020-06-22 | McKinley | New Mexico | 35031 | 3105 | 161 |
266837 | 266837 | 2020-06-23 | McKinley | New Mexico | 35031 | 3155 | 161 |
269972 | 269972 | 2020-06-24 | McKinley | New Mexico | 35031 | 3179 | 161 |
273111 | 273111 | 2020-06-25 | McKinley | New Mexico | 35031 | 3215 | 162 |
276256 | 276256 | 2020-06-26 | McKinley | New Mexico | 35031 | 3287 | 166 |
279404 | 279404 | 2020-06-27 | McKinley | New Mexico | 35031 | 3309 | 166 |
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);