ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,548 rows where county = "Walworth" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
53161 | 53161 | 2020-04-12 | Walworth | South Dakota | 46129 | 1 | 0 |
55847 | 55847 | 2020-04-13 | Walworth | South Dakota | 46129 | 2 | 0 |
58550 | 58550 | 2020-04-14 | Walworth | South Dakota | 46129 | 2 | 0 |
61265 | 61265 | 2020-04-15 | Walworth | South Dakota | 46129 | 5 | 0 |
63992 | 63992 | 2020-04-16 | Walworth | South Dakota | 46129 | 5 | 0 |
66738 | 66738 | 2020-04-17 | Walworth | South Dakota | 46129 | 5 | 0 |
69496 | 69496 | 2020-04-18 | Walworth | South Dakota | 46129 | 5 | 0 |
72263 | 72263 | 2020-04-19 | Walworth | South Dakota | 46129 | 5 | 0 |
75038 | 75038 | 2020-04-20 | Walworth | South Dakota | 46129 | 5 | 0 |
77820 | 77820 | 2020-04-21 | Walworth | South Dakota | 46129 | 5 | 0 |
80610 | 80610 | 2020-04-22 | Walworth | South Dakota | 46129 | 5 | 0 |
83409 | 83409 | 2020-04-23 | Walworth | South Dakota | 46129 | 5 | 0 |
86214 | 86214 | 2020-04-24 | Walworth | South Dakota | 46129 | 5 | 0 |
89029 | 89029 | 2020-04-25 | Walworth | South Dakota | 46129 | 5 | 0 |
91846 | 91846 | 2020-04-26 | Walworth | South Dakota | 46129 | 5 | 0 |
94674 | 94674 | 2020-04-27 | Walworth | South Dakota | 46129 | 5 | 0 |
97514 | 97514 | 2020-04-28 | Walworth | South Dakota | 46129 | 5 | 0 |
100364 | 100364 | 2020-04-29 | Walworth | South Dakota | 46129 | 5 | 0 |
103217 | 103217 | 2020-04-30 | Walworth | South Dakota | 46129 | 5 | 0 |
106080 | 106080 | 2020-05-01 | Walworth | South Dakota | 46129 | 5 | 0 |
108947 | 108947 | 2020-05-02 | Walworth | South Dakota | 46129 | 5 | 0 |
111821 | 111821 | 2020-05-03 | Walworth | South Dakota | 46129 | 5 | 0 |
114703 | 114703 | 2020-05-04 | Walworth | South Dakota | 46129 | 5 | 0 |
117659 | 117659 | 2020-05-05 | Walworth | South Dakota | 46129 | 5 | 0 |
120622 | 120622 | 2020-05-06 | Walworth | South Dakota | 46129 | 5 | 0 |
123600 | 123600 | 2020-05-07 | Walworth | South Dakota | 46129 | 5 | 0 |
126583 | 126583 | 2020-05-08 | Walworth | South Dakota | 46129 | 5 | 0 |
129572 | 129572 | 2020-05-09 | Walworth | South Dakota | 46129 | 5 | 0 |
132561 | 132561 | 2020-05-10 | Walworth | South Dakota | 46129 | 5 | 0 |
135552 | 135552 | 2020-05-11 | Walworth | South Dakota | 46129 | 5 | 0 |
138542 | 138542 | 2020-05-12 | Walworth | South Dakota | 46129 | 5 | 0 |
141538 | 141538 | 2020-05-13 | Walworth | South Dakota | 46129 | 5 | 0 |
144535 | 144535 | 2020-05-14 | Walworth | South Dakota | 46129 | 5 | 0 |
147536 | 147536 | 2020-05-15 | Walworth | South Dakota | 46129 | 5 | 0 |
150544 | 150544 | 2020-05-16 | Walworth | South Dakota | 46129 | 5 | 0 |
153555 | 153555 | 2020-05-17 | Walworth | South Dakota | 46129 | 5 | 0 |
156572 | 156572 | 2020-05-18 | Walworth | South Dakota | 46129 | 5 | 0 |
159593 | 159593 | 2020-05-19 | Walworth | South Dakota | 46129 | 5 | 0 |
162620 | 162620 | 2020-05-20 | Walworth | South Dakota | 46129 | 5 | 0 |
165649 | 165649 | 2020-05-21 | Walworth | South Dakota | 46129 | 5 | 0 |
168685 | 168685 | 2020-05-22 | Walworth | South Dakota | 46129 | 5 | 0 |
171724 | 171724 | 2020-05-23 | Walworth | South Dakota | 46129 | 5 | 0 |
174767 | 174767 | 2020-05-24 | Walworth | South Dakota | 46129 | 5 | 0 |
177811 | 177811 | 2020-05-25 | Walworth | South Dakota | 46129 | 5 | 0 |
180854 | 180854 | 2020-05-26 | Walworth | South Dakota | 46129 | 5 | 0 |
183904 | 183904 | 2020-05-27 | Walworth | South Dakota | 46129 | 5 | 0 |
186961 | 186961 | 2020-05-28 | Walworth | South Dakota | 46129 | 5 | 0 |
190025 | 190025 | 2020-05-29 | Walworth | South Dakota | 46129 | 5 | 0 |
193090 | 193090 | 2020-05-30 | Walworth | South Dakota | 46129 | 5 | 0 |
196160 | 196160 | 2020-05-31 | Walworth | South Dakota | 46129 | 5 | 0 |
199233 | 199233 | 2020-06-01 | Walworth | South Dakota | 46129 | 5 | 0 |
202308 | 202308 | 2020-06-02 | Walworth | South Dakota | 46129 | 5 | 0 |
205387 | 205387 | 2020-06-03 | Walworth | South Dakota | 46129 | 5 | 0 |
208469 | 208469 | 2020-06-04 | Walworth | South Dakota | 46129 | 5 | 0 |
211551 | 211551 | 2020-06-05 | Walworth | South Dakota | 46129 | 5 | 0 |
214638 | 214638 | 2020-06-06 | Walworth | South Dakota | 46129 | 5 | 0 |
217728 | 217728 | 2020-06-07 | Walworth | South Dakota | 46129 | 5 | 0 |
220820 | 220820 | 2020-06-08 | Walworth | South Dakota | 46129 | 5 | 0 |
223915 | 223915 | 2020-06-09 | Walworth | South Dakota | 46129 | 5 | 0 |
227015 | 227015 | 2020-06-10 | Walworth | South Dakota | 46129 | 5 | 0 |
230119 | 230119 | 2020-06-11 | Walworth | South Dakota | 46129 | 5 | 0 |
233224 | 233224 | 2020-06-12 | Walworth | South Dakota | 46129 | 5 | 0 |
236330 | 236330 | 2020-06-13 | Walworth | South Dakota | 46129 | 5 | 0 |
239438 | 239438 | 2020-06-14 | Walworth | South Dakota | 46129 | 5 | 0 |
242548 | 242548 | 2020-06-15 | Walworth | South Dakota | 46129 | 5 | 0 |
245660 | 245660 | 2020-06-16 | Walworth | South Dakota | 46129 | 6 | 0 |
248773 | 248773 | 2020-06-17 | Walworth | South Dakota | 46129 | 7 | 0 |
251888 | 251888 | 2020-06-18 | Walworth | South Dakota | 46129 | 7 | 0 |
255003 | 255003 | 2020-06-19 | Walworth | South Dakota | 46129 | 7 | 0 |
258129 | 258129 | 2020-06-20 | Walworth | South Dakota | 46129 | 7 | 0 |
261256 | 261256 | 2020-06-21 | Walworth | South Dakota | 46129 | 7 | 0 |
264384 | 264384 | 2020-06-22 | Walworth | South Dakota | 46129 | 7 | 0 |
267512 | 267512 | 2020-06-23 | Walworth | South Dakota | 46129 | 7 | 0 |
270646 | 270646 | 2020-06-24 | Walworth | South Dakota | 46129 | 8 | 0 |
273785 | 273785 | 2020-06-25 | Walworth | South Dakota | 46129 | 8 | 0 |
276932 | 276932 | 2020-06-26 | Walworth | South Dakota | 46129 | 9 | 0 |
280080 | 280080 | 2020-06-27 | Walworth | South Dakota | 46129 | 9 | 0 |
283226 | 283226 | 2020-06-28 | Walworth | South Dakota | 46129 | 9 | 0 |
286371 | 286371 | 2020-06-29 | Walworth | South Dakota | 46129 | 9 | 0 |
289522 | 289522 | 2020-06-30 | Walworth | South Dakota | 46129 | 12 | 0 |
292674 | 292674 | 2020-07-01 | Walworth | South Dakota | 46129 | 13 | 0 |
295830 | 295830 | 2020-07-02 | Walworth | South Dakota | 46129 | 14 | 0 |
298990 | 298990 | 2020-07-03 | Walworth | South Dakota | 46129 | 14 | 0 |
302154 | 302154 | 2020-07-04 | Walworth | South Dakota | 46129 | 15 | 0 |
305317 | 305317 | 2020-07-05 | Walworth | South Dakota | 46129 | 15 | 0 |
308485 | 308485 | 2020-07-06 | Walworth | South Dakota | 46129 | 15 | 0 |
311654 | 311654 | 2020-07-07 | Walworth | South Dakota | 46129 | 15 | 0 |
314828 | 314828 | 2020-07-08 | Walworth | South Dakota | 46129 | 16 | 0 |
318001 | 318001 | 2020-07-09 | Walworth | South Dakota | 46129 | 16 | 0 |
321179 | 321179 | 2020-07-10 | Walworth | South Dakota | 46129 | 16 | 0 |
324360 | 324360 | 2020-07-11 | Walworth | South Dakota | 46129 | 16 | 0 |
327545 | 327545 | 2020-07-12 | Walworth | South Dakota | 46129 | 16 | 0 |
330731 | 330731 | 2020-07-13 | Walworth | South Dakota | 46129 | 16 | 0 |
333923 | 333923 | 2020-07-14 | Walworth | South Dakota | 46129 | 16 | 0 |
337117 | 337117 | 2020-07-15 | Walworth | South Dakota | 46129 | 16 | 0 |
340314 | 340314 | 2020-07-16 | Walworth | South Dakota | 46129 | 17 | 0 |
343512 | 343512 | 2020-07-17 | Walworth | South Dakota | 46129 | 18 | 0 |
346712 | 346712 | 2020-07-18 | Walworth | South Dakota | 46129 | 18 | 0 |
349912 | 349912 | 2020-07-19 | Walworth | South Dakota | 46129 | 18 | 0 |
353115 | 353115 | 2020-07-20 | Walworth | South Dakota | 46129 | 18 | 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);