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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5157 | 5157 | 2020-03-19 | Walworth | Wisconsin | 55127 | 2 | 0 |
6071 | 6071 | 2020-03-20 | Walworth | Wisconsin | 55127 | 3 | 0 |
7104 | 7104 | 2020-03-21 | Walworth | Wisconsin | 55127 | 3 | 0 |
8242 | 8242 | 2020-03-22 | Walworth | Wisconsin | 55127 | 3 | 0 |
9468 | 9468 | 2020-03-23 | Walworth | Wisconsin | 55127 | 3 | 0 |
10822 | 10822 | 2020-03-24 | Walworth | Wisconsin | 55127 | 4 | 0 |
12353 | 12353 | 2020-03-25 | Walworth | Wisconsin | 55127 | 5 | 0 |
14009 | 14009 | 2020-03-26 | Walworth | Wisconsin | 55127 | 5 | 0 |
15784 | 15784 | 2020-03-27 | Walworth | Wisconsin | 55127 | 5 | 0 |
17665 | 17665 | 2020-03-28 | Walworth | Wisconsin | 55127 | 6 | 0 |
19634 | 19634 | 2020-03-29 | Walworth | Wisconsin | 55127 | 6 | 0 |
21706 | 21706 | 2020-03-30 | Walworth | Wisconsin | 55127 | 6 | 0 |
23859 | 23859 | 2020-03-31 | Walworth | Wisconsin | 55127 | 6 | 0 |
26080 | 26080 | 2020-04-01 | Walworth | Wisconsin | 55127 | 12 | 0 |
28374 | 28374 | 2020-04-02 | Walworth | Wisconsin | 55127 | 15 | 0 |
30730 | 30730 | 2020-04-03 | Walworth | Wisconsin | 55127 | 15 | 0 |
33133 | 33133 | 2020-04-04 | Walworth | Wisconsin | 55127 | 16 | 0 |
35572 | 35572 | 2020-04-05 | Walworth | Wisconsin | 55127 | 20 | 0 |
38059 | 38059 | 2020-04-06 | Walworth | Wisconsin | 55127 | 20 | 0 |
40601 | 40601 | 2020-04-07 | Walworth | Wisconsin | 55127 | 21 | 0 |
43173 | 43173 | 2020-04-08 | Walworth | Wisconsin | 55127 | 23 | 0 |
45771 | 45771 | 2020-04-09 | Walworth | Wisconsin | 55127 | 28 | 0 |
48400 | 48400 | 2020-04-10 | Walworth | Wisconsin | 55127 | 35 | 0 |
51061 | 51061 | 2020-04-11 | Walworth | Wisconsin | 55127 | 35 | 0 |
53161 | 53161 | 2020-04-12 | Walworth | South Dakota | 46129 | 1 | 0 |
53738 | 53738 | 2020-04-12 | Walworth | Wisconsin | 55127 | 37 | 0 |
55847 | 55847 | 2020-04-13 | Walworth | South Dakota | 46129 | 2 | 0 |
56429 | 56429 | 2020-04-13 | Walworth | Wisconsin | 55127 | 38 | 0 |
58550 | 58550 | 2020-04-14 | Walworth | South Dakota | 46129 | 2 | 0 |
59136 | 59136 | 2020-04-14 | Walworth | Wisconsin | 55127 | 45 | 1 |
61265 | 61265 | 2020-04-15 | Walworth | South Dakota | 46129 | 5 | 0 |
61855 | 61855 | 2020-04-15 | Walworth | Wisconsin | 55127 | 49 | 2 |
63992 | 63992 | 2020-04-16 | Walworth | South Dakota | 46129 | 5 | 0 |
64588 | 64588 | 2020-04-16 | Walworth | Wisconsin | 55127 | 71 | 3 |
66738 | 66738 | 2020-04-17 | Walworth | South Dakota | 46129 | 5 | 0 |
67336 | 67336 | 2020-04-17 | Walworth | Wisconsin | 55127 | 75 | 3 |
69496 | 69496 | 2020-04-18 | Walworth | South Dakota | 46129 | 5 | 0 |
70098 | 70098 | 2020-04-18 | Walworth | Wisconsin | 55127 | 89 | 4 |
72263 | 72263 | 2020-04-19 | Walworth | South Dakota | 46129 | 5 | 0 |
72867 | 72867 | 2020-04-19 | Walworth | Wisconsin | 55127 | 89 | 6 |
75038 | 75038 | 2020-04-20 | Walworth | South Dakota | 46129 | 5 | 0 |
75643 | 75643 | 2020-04-20 | Walworth | Wisconsin | 55127 | 86 | 6 |
77820 | 77820 | 2020-04-21 | Walworth | South Dakota | 46129 | 5 | 0 |
78426 | 78426 | 2020-04-21 | Walworth | Wisconsin | 55127 | 90 | 7 |
80610 | 80610 | 2020-04-22 | Walworth | South Dakota | 46129 | 5 | 0 |
81219 | 81219 | 2020-04-22 | Walworth | Wisconsin | 55127 | 94 | 7 |
83409 | 83409 | 2020-04-23 | Walworth | South Dakota | 46129 | 5 | 0 |
84020 | 84020 | 2020-04-23 | Walworth | Wisconsin | 55127 | 100 | 7 |
86214 | 86214 | 2020-04-24 | Walworth | South Dakota | 46129 | 5 | 0 |
86828 | 86828 | 2020-04-24 | Walworth | Wisconsin | 55127 | 113 | 7 |
89029 | 89029 | 2020-04-25 | Walworth | South Dakota | 46129 | 5 | 0 |
89644 | 89644 | 2020-04-25 | Walworth | Wisconsin | 55127 | 132 | 8 |
91846 | 91846 | 2020-04-26 | Walworth | South Dakota | 46129 | 5 | 0 |
92462 | 92462 | 2020-04-26 | Walworth | Wisconsin | 55127 | 135 | 8 |
94674 | 94674 | 2020-04-27 | Walworth | South Dakota | 46129 | 5 | 0 |
95292 | 95292 | 2020-04-27 | Walworth | Wisconsin | 55127 | 138 | 8 |
97514 | 97514 | 2020-04-28 | Walworth | South Dakota | 46129 | 5 | 0 |
98137 | 98137 | 2020-04-28 | Walworth | Wisconsin | 55127 | 139 | 8 |
100364 | 100364 | 2020-04-29 | Walworth | South Dakota | 46129 | 5 | 0 |
100987 | 100987 | 2020-04-29 | Walworth | Wisconsin | 55127 | 156 | 8 |
103217 | 103217 | 2020-04-30 | Walworth | South Dakota | 46129 | 5 | 0 |
103842 | 103842 | 2020-04-30 | Walworth | Wisconsin | 55127 | 161 | 8 |
106080 | 106080 | 2020-05-01 | Walworth | South Dakota | 46129 | 5 | 0 |
106707 | 106707 | 2020-05-01 | Walworth | Wisconsin | 55127 | 171 | 8 |
108947 | 108947 | 2020-05-02 | Walworth | South Dakota | 46129 | 5 | 0 |
109576 | 109576 | 2020-05-02 | Walworth | Wisconsin | 55127 | 183 | 8 |
111821 | 111821 | 2020-05-03 | Walworth | South Dakota | 46129 | 5 | 0 |
112451 | 112451 | 2020-05-03 | Walworth | Wisconsin | 55127 | 197 | 8 |
114703 | 114703 | 2020-05-04 | Walworth | South Dakota | 46129 | 5 | 0 |
115334 | 115334 | 2020-05-04 | Walworth | Wisconsin | 55127 | 211 | 8 |
117659 | 117659 | 2020-05-05 | Walworth | South Dakota | 46129 | 5 | 0 |
118293 | 118293 | 2020-05-05 | Walworth | Wisconsin | 55127 | 212 | 8 |
120622 | 120622 | 2020-05-06 | Walworth | South Dakota | 46129 | 5 | 0 |
121259 | 121259 | 2020-05-06 | Walworth | Wisconsin | 55127 | 215 | 9 |
123600 | 123600 | 2020-05-07 | Walworth | South Dakota | 46129 | 5 | 0 |
124239 | 124239 | 2020-05-07 | Walworth | Wisconsin | 55127 | 226 | 9 |
126583 | 126583 | 2020-05-08 | Walworth | South Dakota | 46129 | 5 | 0 |
127224 | 127224 | 2020-05-08 | Walworth | Wisconsin | 55127 | 226 | 10 |
129572 | 129572 | 2020-05-09 | Walworth | South Dakota | 46129 | 5 | 0 |
130214 | 130214 | 2020-05-09 | Walworth | Wisconsin | 55127 | 229 | 10 |
132561 | 132561 | 2020-05-10 | Walworth | South Dakota | 46129 | 5 | 0 |
133204 | 133204 | 2020-05-10 | Walworth | Wisconsin | 55127 | 235 | 10 |
135552 | 135552 | 2020-05-11 | Walworth | South Dakota | 46129 | 5 | 0 |
136194 | 136194 | 2020-05-11 | Walworth | Wisconsin | 55127 | 240 | 10 |
138542 | 138542 | 2020-05-12 | Walworth | South Dakota | 46129 | 5 | 0 |
139185 | 139185 | 2020-05-12 | Walworth | Wisconsin | 55127 | 244 | 11 |
141538 | 141538 | 2020-05-13 | Walworth | South Dakota | 46129 | 5 | 0 |
142181 | 142181 | 2020-05-13 | Walworth | Wisconsin | 55127 | 243 | 11 |
144535 | 144535 | 2020-05-14 | Walworth | South Dakota | 46129 | 5 | 0 |
145180 | 145180 | 2020-05-14 | Walworth | Wisconsin | 55127 | 251 | 11 |
147536 | 147536 | 2020-05-15 | Walworth | South Dakota | 46129 | 5 | 0 |
148183 | 148183 | 2020-05-15 | Walworth | Wisconsin | 55127 | 269 | 11 |
150544 | 150544 | 2020-05-16 | Walworth | South Dakota | 46129 | 5 | 0 |
151192 | 151192 | 2020-05-16 | Walworth | Wisconsin | 55127 | 277 | 12 |
153555 | 153555 | 2020-05-17 | Walworth | South Dakota | 46129 | 5 | 0 |
154204 | 154204 | 2020-05-17 | Walworth | Wisconsin | 55127 | 280 | 12 |
156572 | 156572 | 2020-05-18 | Walworth | South Dakota | 46129 | 5 | 0 |
157220 | 157220 | 2020-05-18 | Walworth | Wisconsin | 55127 | 284 | 12 |
159593 | 159593 | 2020-05-19 | Walworth | South Dakota | 46129 | 5 | 0 |
160244 | 160244 | 2020-05-19 | Walworth | Wisconsin | 55127 | 287 | 11 |
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);