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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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);