ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Grant" and state = "Wisconsin" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
12335 | 12335 | 2020-03-25 | Grant | Wisconsin | 55043 | 1 | 0 |
13989 | 13989 | 2020-03-26 | Grant | Wisconsin | 55043 | 1 | 0 |
15761 | 15761 | 2020-03-27 | Grant | Wisconsin | 55043 | 1 | 0 |
17641 | 17641 | 2020-03-28 | Grant | Wisconsin | 55043 | 1 | 0 |
19610 | 19610 | 2020-03-29 | Grant | Wisconsin | 55043 | 1 | 0 |
21680 | 21680 | 2020-03-30 | Grant | Wisconsin | 55043 | 1 | 0 |
23832 | 23832 | 2020-03-31 | Grant | Wisconsin | 55043 | 2 | 0 |
26052 | 26052 | 2020-04-01 | Grant | Wisconsin | 55043 | 2 | 0 |
28345 | 28345 | 2020-04-02 | Grant | Wisconsin | 55043 | 2 | 0 |
30700 | 30700 | 2020-04-03 | Grant | Wisconsin | 55043 | 2 | 0 |
33101 | 33101 | 2020-04-04 | Grant | Wisconsin | 55043 | 2 | 0 |
35540 | 35540 | 2020-04-05 | Grant | Wisconsin | 55043 | 2 | 0 |
38026 | 38026 | 2020-04-06 | Grant | Wisconsin | 55043 | 3 | 0 |
40567 | 40567 | 2020-04-07 | Grant | Wisconsin | 55043 | 3 | 0 |
43139 | 43139 | 2020-04-08 | Grant | Wisconsin | 55043 | 3 | 0 |
45736 | 45736 | 2020-04-09 | Grant | Wisconsin | 55043 | 4 | 1 |
48364 | 48364 | 2020-04-10 | Grant | Wisconsin | 55043 | 4 | 1 |
51024 | 51024 | 2020-04-11 | Grant | Wisconsin | 55043 | 5 | 1 |
53701 | 53701 | 2020-04-12 | Grant | Wisconsin | 55043 | 6 | 1 |
56391 | 56391 | 2020-04-13 | Grant | Wisconsin | 55043 | 6 | 1 |
59098 | 59098 | 2020-04-14 | Grant | Wisconsin | 55043 | 8 | 1 |
61817 | 61817 | 2020-04-15 | Grant | Wisconsin | 55043 | 8 | 1 |
64550 | 64550 | 2020-04-16 | Grant | Wisconsin | 55043 | 10 | 1 |
67298 | 67298 | 2020-04-17 | Grant | Wisconsin | 55043 | 13 | 1 |
70060 | 70060 | 2020-04-18 | Grant | Wisconsin | 55043 | 15 | 2 |
72829 | 72829 | 2020-04-19 | Grant | Wisconsin | 55043 | 18 | 2 |
75605 | 75605 | 2020-04-20 | Grant | Wisconsin | 55043 | 23 | 3 |
78388 | 78388 | 2020-04-21 | Grant | Wisconsin | 55043 | 23 | 3 |
81181 | 81181 | 2020-04-22 | Grant | Wisconsin | 55043 | 25 | 3 |
83982 | 83982 | 2020-04-23 | Grant | Wisconsin | 55043 | 26 | 3 |
86789 | 86789 | 2020-04-24 | Grant | Wisconsin | 55043 | 27 | 3 |
89605 | 89605 | 2020-04-25 | Grant | Wisconsin | 55043 | 28 | 3 |
92423 | 92423 | 2020-04-26 | Grant | Wisconsin | 55043 | 30 | 3 |
95253 | 95253 | 2020-04-27 | Grant | Wisconsin | 55043 | 31 | 4 |
98098 | 98098 | 2020-04-28 | Grant | Wisconsin | 55043 | 32 | 5 |
100948 | 100948 | 2020-04-29 | Grant | Wisconsin | 55043 | 35 | 6 |
103803 | 103803 | 2020-04-30 | Grant | Wisconsin | 55043 | 37 | 6 |
106667 | 106667 | 2020-05-01 | Grant | Wisconsin | 55043 | 41 | 6 |
109536 | 109536 | 2020-05-02 | Grant | Wisconsin | 55043 | 43 | 6 |
112411 | 112411 | 2020-05-03 | Grant | Wisconsin | 55043 | 48 | 6 |
115294 | 115294 | 2020-05-04 | Grant | Wisconsin | 55043 | 48 | 6 |
118253 | 118253 | 2020-05-05 | Grant | Wisconsin | 55043 | 55 | 7 |
121219 | 121219 | 2020-05-06 | Grant | Wisconsin | 55043 | 60 | 7 |
124199 | 124199 | 2020-05-07 | Grant | Wisconsin | 55043 | 66 | 7 |
127184 | 127184 | 2020-05-08 | Grant | Wisconsin | 55043 | 66 | 7 |
130174 | 130174 | 2020-05-09 | Grant | Wisconsin | 55043 | 67 | 7 |
133164 | 133164 | 2020-05-10 | Grant | Wisconsin | 55043 | 68 | 7 |
136154 | 136154 | 2020-05-11 | Grant | Wisconsin | 55043 | 68 | 9 |
139145 | 139145 | 2020-05-12 | Grant | Wisconsin | 55043 | 69 | 9 |
142141 | 142141 | 2020-05-13 | Grant | Wisconsin | 55043 | 70 | 9 |
145139 | 145139 | 2020-05-14 | Grant | Wisconsin | 55043 | 71 | 10 |
148142 | 148142 | 2020-05-15 | Grant | Wisconsin | 55043 | 72 | 10 |
151151 | 151151 | 2020-05-16 | Grant | Wisconsin | 55043 | 72 | 10 |
154163 | 154163 | 2020-05-17 | Grant | Wisconsin | 55043 | 72 | 10 |
157179 | 157179 | 2020-05-18 | Grant | Wisconsin | 55043 | 74 | 10 |
160203 | 160203 | 2020-05-19 | Grant | Wisconsin | 55043 | 75 | 10 |
163231 | 163231 | 2020-05-20 | Grant | Wisconsin | 55043 | 78 | 10 |
166260 | 166260 | 2020-05-21 | Grant | Wisconsin | 55043 | 78 | 10 |
169296 | 169296 | 2020-05-22 | Grant | Wisconsin | 55043 | 81 | 10 |
172337 | 172337 | 2020-05-23 | Grant | Wisconsin | 55043 | 81 | 10 |
175380 | 175380 | 2020-05-24 | Grant | Wisconsin | 55043 | 82 | 11 |
178425 | 178425 | 2020-05-25 | Grant | Wisconsin | 55043 | 87 | 11 |
181469 | 181469 | 2020-05-26 | Grant | Wisconsin | 55043 | 87 | 12 |
184520 | 184520 | 2020-05-27 | Grant | Wisconsin | 55043 | 89 | 12 |
187577 | 187577 | 2020-05-28 | Grant | Wisconsin | 55043 | 93 | 12 |
190641 | 190641 | 2020-05-29 | Grant | Wisconsin | 55043 | 94 | 12 |
193707 | 193707 | 2020-05-30 | Grant | Wisconsin | 55043 | 95 | 12 |
196777 | 196777 | 2020-05-31 | Grant | Wisconsin | 55043 | 95 | 12 |
199850 | 199850 | 2020-06-01 | Grant | Wisconsin | 55043 | 96 | 12 |
202926 | 202926 | 2020-06-02 | Grant | Wisconsin | 55043 | 96 | 12 |
206005 | 206005 | 2020-06-03 | Grant | Wisconsin | 55043 | 98 | 12 |
209087 | 209087 | 2020-06-04 | Grant | Wisconsin | 55043 | 98 | 12 |
212172 | 212172 | 2020-06-05 | Grant | Wisconsin | 55043 | 98 | 12 |
215259 | 215259 | 2020-06-06 | Grant | Wisconsin | 55043 | 98 | 12 |
218349 | 218349 | 2020-06-07 | Grant | Wisconsin | 55043 | 98 | 12 |
221441 | 221441 | 2020-06-08 | Grant | Wisconsin | 55043 | 98 | 12 |
224537 | 224537 | 2020-06-09 | Grant | Wisconsin | 55043 | 99 | 12 |
227637 | 227637 | 2020-06-10 | Grant | Wisconsin | 55043 | 99 | 12 |
230741 | 230741 | 2020-06-11 | Grant | Wisconsin | 55043 | 101 | 12 |
233846 | 233846 | 2020-06-12 | Grant | Wisconsin | 55043 | 103 | 12 |
236953 | 236953 | 2020-06-13 | Grant | Wisconsin | 55043 | 106 | 12 |
240061 | 240061 | 2020-06-14 | Grant | Wisconsin | 55043 | 107 | 12 |
243172 | 243172 | 2020-06-15 | Grant | Wisconsin | 55043 | 107 | 12 |
246285 | 246285 | 2020-06-16 | Grant | Wisconsin | 55043 | 107 | 12 |
249397 | 249397 | 2020-06-17 | Grant | Wisconsin | 55043 | 113 | 12 |
252512 | 252512 | 2020-06-18 | Grant | Wisconsin | 55043 | 113 | 12 |
255631 | 255631 | 2020-06-19 | Grant | Wisconsin | 55043 | 114 | 12 |
258758 | 258758 | 2020-06-20 | Grant | Wisconsin | 55043 | 124 | 12 |
261885 | 261885 | 2020-06-21 | Grant | Wisconsin | 55043 | 125 | 12 |
265014 | 265014 | 2020-06-22 | Grant | Wisconsin | 55043 | 129 | 12 |
268143 | 268143 | 2020-06-23 | Grant | Wisconsin | 55043 | 130 | 12 |
271277 | 271277 | 2020-06-24 | Grant | Wisconsin | 55043 | 134 | 12 |
274417 | 274417 | 2020-06-25 | Grant | Wisconsin | 55043 | 136 | 12 |
277565 | 277565 | 2020-06-26 | Grant | Wisconsin | 55043 | 141 | 12 |
280713 | 280713 | 2020-06-27 | Grant | Wisconsin | 55043 | 145 | 13 |
283859 | 283859 | 2020-06-28 | Grant | Wisconsin | 55043 | 150 | 13 |
287005 | 287005 | 2020-06-29 | Grant | Wisconsin | 55043 | 152 | 13 |
290155 | 290155 | 2020-06-30 | Grant | Wisconsin | 55043 | 154 | 13 |
293308 | 293308 | 2020-07-01 | Grant | Wisconsin | 55043 | 161 | 13 |
296463 | 296463 | 2020-07-02 | Grant | Wisconsin | 55043 | 162 | 13 |
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);