ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rock" and state = "Wisconsin" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
6067 | 6067 | 2020-03-20 | Rock | Wisconsin | 55105 | 1 | 0 |
7100 | 7100 | 2020-03-21 | Rock | Wisconsin | 55105 | 3 | 0 |
8238 | 8238 | 2020-03-22 | Rock | Wisconsin | 55105 | 3 | 0 |
9464 | 9464 | 2020-03-23 | Rock | Wisconsin | 55105 | 3 | 0 |
10818 | 10818 | 2020-03-24 | Rock | Wisconsin | 55105 | 3 | 0 |
12349 | 12349 | 2020-03-25 | Rock | Wisconsin | 55105 | 4 | 0 |
14004 | 14004 | 2020-03-26 | Rock | Wisconsin | 55105 | 8 | 0 |
15779 | 15779 | 2020-03-27 | Rock | Wisconsin | 55105 | 12 | 0 |
17660 | 17660 | 2020-03-28 | Rock | Wisconsin | 55105 | 12 | 0 |
19629 | 19629 | 2020-03-29 | Rock | Wisconsin | 55105 | 14 | 0 |
21701 | 21701 | 2020-03-30 | Rock | Wisconsin | 55105 | 15 | 0 |
23854 | 23854 | 2020-03-31 | Rock | Wisconsin | 55105 | 16 | 0 |
26075 | 26075 | 2020-04-01 | Rock | Wisconsin | 55105 | 17 | 1 |
28368 | 28368 | 2020-04-02 | Rock | Wisconsin | 55105 | 19 | 1 |
30723 | 30723 | 2020-04-03 | Rock | Wisconsin | 55105 | 20 | 1 |
33125 | 33125 | 2020-04-04 | Rock | Wisconsin | 55105 | 26 | 1 |
35564 | 35564 | 2020-04-05 | Rock | Wisconsin | 55105 | 28 | 2 |
38051 | 38051 | 2020-04-06 | Rock | Wisconsin | 55105 | 34 | 2 |
40593 | 40593 | 2020-04-07 | Rock | Wisconsin | 55105 | 37 | 2 |
43165 | 43165 | 2020-04-08 | Rock | Wisconsin | 55105 | 42 | 2 |
45762 | 45762 | 2020-04-09 | Rock | Wisconsin | 55105 | 47 | 2 |
48391 | 48391 | 2020-04-10 | Rock | Wisconsin | 55105 | 51 | 2 |
51052 | 51052 | 2020-04-11 | Rock | Wisconsin | 55105 | 53 | 3 |
53729 | 53729 | 2020-04-12 | Rock | Wisconsin | 55105 | 56 | 3 |
59127 | 59127 | 2020-04-14 | Rock | Wisconsin | 55105 | 59 | 4 |
56420 | 56420 | 2020-04-13 | Rock | Wisconsin | 55105 | 60 | 3 |
61846 | 61846 | 2020-04-15 | Rock | Wisconsin | 55105 | 62 | 4 |
64579 | 64579 | 2020-04-16 | Rock | Wisconsin | 55105 | 63 | 4 |
67327 | 67327 | 2020-04-17 | Rock | Wisconsin | 55105 | 63 | 4 |
70089 | 70089 | 2020-04-18 | Rock | Wisconsin | 55105 | 68 | 4 |
72858 | 72858 | 2020-04-19 | Rock | Wisconsin | 55105 | 74 | 4 |
75634 | 75634 | 2020-04-20 | Rock | Wisconsin | 55105 | 80 | 4 |
78417 | 78417 | 2020-04-21 | Rock | Wisconsin | 55105 | 83 | 4 |
81210 | 81210 | 2020-04-22 | Rock | Wisconsin | 55105 | 86 | 4 |
84011 | 84011 | 2020-04-23 | Rock | Wisconsin | 55105 | 99 | 4 |
86818 | 86818 | 2020-04-24 | Rock | Wisconsin | 55105 | 120 | 4 |
89634 | 89634 | 2020-04-25 | Rock | Wisconsin | 55105 | 151 | 4 |
92452 | 92452 | 2020-04-26 | Rock | Wisconsin | 55105 | 151 | 5 |
95282 | 95282 | 2020-04-27 | Rock | Wisconsin | 55105 | 164 | 5 |
98127 | 98127 | 2020-04-28 | Rock | Wisconsin | 55105 | 178 | 6 |
100977 | 100977 | 2020-04-29 | Rock | Wisconsin | 55105 | 183 | 6 |
103832 | 103832 | 2020-04-30 | Rock | Wisconsin | 55105 | 198 | 6 |
106697 | 106697 | 2020-05-01 | Rock | Wisconsin | 55105 | 222 | 6 |
109566 | 109566 | 2020-05-02 | Rock | Wisconsin | 55105 | 243 | 7 |
112441 | 112441 | 2020-05-03 | Rock | Wisconsin | 55105 | 262 | 7 |
115324 | 115324 | 2020-05-04 | Rock | Wisconsin | 55105 | 289 | 7 |
118283 | 118283 | 2020-05-05 | Rock | Wisconsin | 55105 | 301 | 9 |
121249 | 121249 | 2020-05-06 | Rock | Wisconsin | 55105 | 311 | 10 |
124229 | 124229 | 2020-05-07 | Rock | Wisconsin | 55105 | 324 | 12 |
127214 | 127214 | 2020-05-08 | Rock | Wisconsin | 55105 | 343 | 12 |
130204 | 130204 | 2020-05-09 | Rock | Wisconsin | 55105 | 347 | 13 |
133194 | 133194 | 2020-05-10 | Rock | Wisconsin | 55105 | 354 | 13 |
136184 | 136184 | 2020-05-11 | Rock | Wisconsin | 55105 | 361 | 13 |
139175 | 139175 | 2020-05-12 | Rock | Wisconsin | 55105 | 369 | 13 |
142171 | 142171 | 2020-05-13 | Rock | Wisconsin | 55105 | 380 | 13 |
145170 | 145170 | 2020-05-14 | Rock | Wisconsin | 55105 | 393 | 14 |
148173 | 148173 | 2020-05-15 | Rock | Wisconsin | 55105 | 406 | 14 |
151182 | 151182 | 2020-05-16 | Rock | Wisconsin | 55105 | 422 | 14 |
154194 | 154194 | 2020-05-17 | Rock | Wisconsin | 55105 | 429 | 14 |
157210 | 157210 | 2020-05-18 | Rock | Wisconsin | 55105 | 432 | 14 |
160234 | 160234 | 2020-05-19 | Rock | Wisconsin | 55105 | 438 | 14 |
163262 | 163262 | 2020-05-20 | Rock | Wisconsin | 55105 | 452 | 14 |
166292 | 166292 | 2020-05-21 | Rock | Wisconsin | 55105 | 493 | 14 |
169328 | 169328 | 2020-05-22 | Rock | Wisconsin | 55105 | 520 | 15 |
172369 | 172369 | 2020-05-23 | Rock | Wisconsin | 55105 | 529 | 16 |
175412 | 175412 | 2020-05-24 | Rock | Wisconsin | 55105 | 545 | 16 |
178457 | 178457 | 2020-05-25 | Rock | Wisconsin | 55105 | 569 | 16 |
181501 | 181501 | 2020-05-26 | Rock | Wisconsin | 55105 | 583 | 16 |
184552 | 184552 | 2020-05-27 | Rock | Wisconsin | 55105 | 588 | 18 |
187609 | 187609 | 2020-05-28 | Rock | Wisconsin | 55105 | 607 | 18 |
190673 | 190673 | 2020-05-29 | Rock | Wisconsin | 55105 | 620 | 18 |
193739 | 193739 | 2020-05-30 | Rock | Wisconsin | 55105 | 632 | 19 |
196809 | 196809 | 2020-05-31 | Rock | Wisconsin | 55105 | 636 | 19 |
199882 | 199882 | 2020-06-01 | Rock | Wisconsin | 55105 | 639 | 19 |
202958 | 202958 | 2020-06-02 | Rock | Wisconsin | 55105 | 646 | 19 |
206037 | 206037 | 2020-06-03 | Rock | Wisconsin | 55105 | 744 | 19 |
209119 | 209119 | 2020-06-04 | Rock | Wisconsin | 55105 | 757 | 20 |
212204 | 212204 | 2020-06-05 | Rock | Wisconsin | 55105 | 767 | 20 |
215291 | 215291 | 2020-06-06 | Rock | Wisconsin | 55105 | 770 | 21 |
218381 | 218381 | 2020-06-07 | Rock | Wisconsin | 55105 | 770 | 21 |
221473 | 221473 | 2020-06-08 | Rock | Wisconsin | 55105 | 792 | 21 |
224569 | 224569 | 2020-06-09 | Rock | Wisconsin | 55105 | 799 | 21 |
227669 | 227669 | 2020-06-10 | Rock | Wisconsin | 55105 | 812 | 21 |
230773 | 230773 | 2020-06-11 | Rock | Wisconsin | 55105 | 817 | 21 |
233878 | 233878 | 2020-06-12 | Rock | Wisconsin | 55105 | 832 | 21 |
236985 | 236985 | 2020-06-13 | Rock | Wisconsin | 55105 | 840 | 21 |
240093 | 240093 | 2020-06-14 | Rock | Wisconsin | 55105 | 842 | 21 |
243204 | 243204 | 2020-06-15 | Rock | Wisconsin | 55105 | 844 | 21 |
246317 | 246317 | 2020-06-16 | Rock | Wisconsin | 55105 | 851 | 22 |
249429 | 249429 | 2020-06-17 | Rock | Wisconsin | 55105 | 857 | 22 |
252544 | 252544 | 2020-06-18 | Rock | Wisconsin | 55105 | 871 | 22 |
255663 | 255663 | 2020-06-19 | Rock | Wisconsin | 55105 | 875 | 23 |
258790 | 258790 | 2020-06-20 | Rock | Wisconsin | 55105 | 881 | 23 |
261917 | 261917 | 2020-06-21 | Rock | Wisconsin | 55105 | 881 | 23 |
265046 | 265046 | 2020-06-22 | Rock | Wisconsin | 55105 | 893 | 23 |
268175 | 268175 | 2020-06-23 | Rock | Wisconsin | 55105 | 905 | 23 |
271309 | 271309 | 2020-06-24 | Rock | Wisconsin | 55105 | 916 | 23 |
274449 | 274449 | 2020-06-25 | Rock | Wisconsin | 55105 | 924 | 23 |
277597 | 277597 | 2020-06-26 | Rock | Wisconsin | 55105 | 932 | 23 |
280745 | 280745 | 2020-06-27 | Rock | Wisconsin | 55105 | 932 | 23 |
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);