ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "McCook" and state = "South Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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);