ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Clay", fips = 46027 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 |
---|---|---|---|---|---|---|---|
19215 | 19215 | 2020-03-29 | Clay | South Dakota | 46027 | 2 | 0 |
21267 | 21267 | 2020-03-30 | Clay | South Dakota | 46027 | 3 | 0 |
23405 | 23405 | 2020-03-31 | Clay | South Dakota | 46027 | 3 | 0 |
25603 | 25603 | 2020-04-01 | Clay | South Dakota | 46027 | 3 | 0 |
27879 | 27879 | 2020-04-02 | Clay | South Dakota | 46027 | 3 | 0 |
30214 | 30214 | 2020-04-03 | Clay | South Dakota | 46027 | 3 | 0 |
32605 | 32605 | 2020-04-04 | Clay | South Dakota | 46027 | 3 | 0 |
35041 | 35041 | 2020-04-05 | Clay | South Dakota | 46027 | 3 | 0 |
37516 | 37516 | 2020-04-06 | Clay | South Dakota | 46027 | 3 | 0 |
40039 | 40039 | 2020-04-07 | Clay | South Dakota | 46027 | 6 | 0 |
42599 | 42599 | 2020-04-08 | Clay | South Dakota | 46027 | 6 | 0 |
45185 | 45185 | 2020-04-09 | Clay | South Dakota | 46027 | 6 | 0 |
47802 | 47802 | 2020-04-10 | Clay | South Dakota | 46027 | 6 | 0 |
50459 | 50459 | 2020-04-11 | Clay | South Dakota | 46027 | 6 | 0 |
53132 | 53132 | 2020-04-12 | Clay | South Dakota | 46027 | 6 | 0 |
55817 | 55817 | 2020-04-13 | Clay | South Dakota | 46027 | 5 | 0 |
58520 | 58520 | 2020-04-14 | Clay | South Dakota | 46027 | 5 | 0 |
61235 | 61235 | 2020-04-15 | Clay | South Dakota | 46027 | 5 | 0 |
63961 | 63961 | 2020-04-16 | Clay | South Dakota | 46027 | 5 | 0 |
66707 | 66707 | 2020-04-17 | Clay | South Dakota | 46027 | 5 | 0 |
69465 | 69465 | 2020-04-18 | Clay | South Dakota | 46027 | 5 | 0 |
72232 | 72232 | 2020-04-19 | Clay | South Dakota | 46027 | 5 | 0 |
75007 | 75007 | 2020-04-20 | Clay | South Dakota | 46027 | 5 | 0 |
77789 | 77789 | 2020-04-21 | Clay | South Dakota | 46027 | 5 | 0 |
80579 | 80579 | 2020-04-22 | Clay | South Dakota | 46027 | 5 | 0 |
83378 | 83378 | 2020-04-23 | Clay | South Dakota | 46027 | 5 | 0 |
86182 | 86182 | 2020-04-24 | Clay | South Dakota | 46027 | 5 | 0 |
88996 | 88996 | 2020-04-25 | Clay | South Dakota | 46027 | 5 | 0 |
91812 | 91812 | 2020-04-26 | Clay | South Dakota | 46027 | 5 | 0 |
94639 | 94639 | 2020-04-27 | Clay | South Dakota | 46027 | 5 | 0 |
97479 | 97479 | 2020-04-28 | Clay | South Dakota | 46027 | 5 | 0 |
100328 | 100328 | 2020-04-29 | Clay | South Dakota | 46027 | 6 | 0 |
103181 | 103181 | 2020-04-30 | Clay | South Dakota | 46027 | 6 | 0 |
106044 | 106044 | 2020-05-01 | Clay | South Dakota | 46027 | 6 | 0 |
108911 | 108911 | 2020-05-02 | Clay | South Dakota | 46027 | 6 | 0 |
111785 | 111785 | 2020-05-03 | Clay | South Dakota | 46027 | 7 | 0 |
114667 | 114667 | 2020-05-04 | Clay | South Dakota | 46027 | 7 | 0 |
117623 | 117623 | 2020-05-05 | Clay | South Dakota | 46027 | 7 | 0 |
120585 | 120585 | 2020-05-06 | Clay | South Dakota | 46027 | 7 | 0 |
123563 | 123563 | 2020-05-07 | Clay | South Dakota | 46027 | 7 | 0 |
126546 | 126546 | 2020-05-08 | Clay | South Dakota | 46027 | 9 | 0 |
129535 | 129535 | 2020-05-09 | Clay | South Dakota | 46027 | 9 | 0 |
132524 | 132524 | 2020-05-10 | Clay | South Dakota | 46027 | 9 | 0 |
135515 | 135515 | 2020-05-11 | Clay | South Dakota | 46027 | 9 | 0 |
138505 | 138505 | 2020-05-12 | Clay | South Dakota | 46027 | 10 | 0 |
141501 | 141501 | 2020-05-13 | Clay | South Dakota | 46027 | 11 | 0 |
144497 | 144497 | 2020-05-14 | Clay | South Dakota | 46027 | 11 | 0 |
147498 | 147498 | 2020-05-15 | Clay | South Dakota | 46027 | 12 | 0 |
150506 | 150506 | 2020-05-16 | Clay | South Dakota | 46027 | 14 | 0 |
153517 | 153517 | 2020-05-17 | Clay | South Dakota | 46027 | 15 | 0 |
156534 | 156534 | 2020-05-18 | Clay | South Dakota | 46027 | 15 | 0 |
159555 | 159555 | 2020-05-19 | Clay | South Dakota | 46027 | 15 | 0 |
162582 | 162582 | 2020-05-20 | Clay | South Dakota | 46027 | 15 | 0 |
165611 | 165611 | 2020-05-21 | Clay | South Dakota | 46027 | 15 | 0 |
168647 | 168647 | 2020-05-22 | Clay | South Dakota | 46027 | 15 | 0 |
171686 | 171686 | 2020-05-23 | Clay | South Dakota | 46027 | 15 | 0 |
174728 | 174728 | 2020-05-24 | Clay | South Dakota | 46027 | 15 | 0 |
177772 | 177772 | 2020-05-25 | Clay | South Dakota | 46027 | 15 | 0 |
180815 | 180815 | 2020-05-26 | Clay | South Dakota | 46027 | 15 | 0 |
183865 | 183865 | 2020-05-27 | Clay | South Dakota | 46027 | 15 | 0 |
186922 | 186922 | 2020-05-28 | Clay | South Dakota | 46027 | 15 | 0 |
189984 | 189984 | 2020-05-29 | Clay | South Dakota | 46027 | 15 | 0 |
193049 | 193049 | 2020-05-30 | Clay | South Dakota | 46027 | 15 | 0 |
196118 | 196118 | 2020-05-31 | Clay | South Dakota | 46027 | 15 | 0 |
199191 | 199191 | 2020-06-01 | Clay | South Dakota | 46027 | 15 | 0 |
202266 | 202266 | 2020-06-02 | Clay | South Dakota | 46027 | 15 | 0 |
205344 | 205344 | 2020-06-03 | Clay | South Dakota | 46027 | 15 | 0 |
208425 | 208425 | 2020-06-04 | Clay | South Dakota | 46027 | 18 | 0 |
211507 | 211507 | 2020-06-05 | Clay | South Dakota | 46027 | 19 | 0 |
214593 | 214593 | 2020-06-06 | Clay | South Dakota | 46027 | 27 | 0 |
217683 | 217683 | 2020-06-07 | Clay | South Dakota | 46027 | 32 | 0 |
220775 | 220775 | 2020-06-08 | Clay | South Dakota | 46027 | 35 | 0 |
223870 | 223870 | 2020-06-09 | Clay | South Dakota | 46027 | 39 | 0 |
226970 | 226970 | 2020-06-10 | Clay | South Dakota | 46027 | 43 | 0 |
230074 | 230074 | 2020-06-11 | Clay | South Dakota | 46027 | 50 | 0 |
233179 | 233179 | 2020-06-12 | Clay | South Dakota | 46027 | 56 | 0 |
236284 | 236284 | 2020-06-13 | Clay | South Dakota | 46027 | 65 | 0 |
239392 | 239392 | 2020-06-14 | Clay | South Dakota | 46027 | 65 | 0 |
242502 | 242502 | 2020-06-15 | Clay | South Dakota | 46027 | 66 | 0 |
245614 | 245614 | 2020-06-16 | Clay | South Dakota | 46027 | 67 | 0 |
248727 | 248727 | 2020-06-17 | Clay | South Dakota | 46027 | 69 | 0 |
251842 | 251842 | 2020-06-18 | Clay | South Dakota | 46027 | 70 | 0 |
254957 | 254957 | 2020-06-19 | Clay | South Dakota | 46027 | 70 | 0 |
258083 | 258083 | 2020-06-20 | Clay | South Dakota | 46027 | 73 | 0 |
261210 | 261210 | 2020-06-21 | Clay | South Dakota | 46027 | 73 | 0 |
264338 | 264338 | 2020-06-22 | Clay | South Dakota | 46027 | 73 | 0 |
267466 | 267466 | 2020-06-23 | Clay | South Dakota | 46027 | 77 | 0 |
270600 | 270600 | 2020-06-24 | Clay | South Dakota | 46027 | 76 | 0 |
273739 | 273739 | 2020-06-25 | Clay | South Dakota | 46027 | 79 | 0 |
276886 | 276886 | 2020-06-26 | Clay | South Dakota | 46027 | 79 | 0 |
280034 | 280034 | 2020-06-27 | Clay | South Dakota | 46027 | 80 | 0 |
283180 | 283180 | 2020-06-28 | Clay | South Dakota | 46027 | 80 | 0 |
286325 | 286325 | 2020-06-29 | Clay | South Dakota | 46027 | 80 | 0 |
289476 | 289476 | 2020-06-30 | Clay | South Dakota | 46027 | 82 | 0 |
292628 | 292628 | 2020-07-01 | Clay | South Dakota | 46027 | 83 | 0 |
295784 | 295784 | 2020-07-02 | Clay | South Dakota | 46027 | 85 | 0 |
298944 | 298944 | 2020-07-03 | Clay | South Dakota | 46027 | 87 | 0 |
302108 | 302108 | 2020-07-04 | Clay | South Dakota | 46027 | 87 | 0 |
305271 | 305271 | 2020-07-05 | Clay | South Dakota | 46027 | 87 | 0 |
308438 | 308438 | 2020-07-06 | Clay | South Dakota | 46027 | 89 | 0 |
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);