ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 55093 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389108 | 389108 | 2020-07-31 | Pierce | Wisconsin | 55093 | 164 | 0 |
385891 | 385891 | 2020-07-30 | Pierce | Wisconsin | 55093 | 160 | 0 |
382673 | 382673 | 2020-07-29 | Pierce | Wisconsin | 55093 | 159 | 0 |
379456 | 379456 | 2020-07-28 | Pierce | Wisconsin | 55093 | 152 | 0 |
376240 | 376240 | 2020-07-27 | Pierce | Wisconsin | 55093 | 148 | 0 |
373026 | 373026 | 2020-07-26 | Pierce | Wisconsin | 55093 | 148 | 0 |
369814 | 369814 | 2020-07-25 | Pierce | Wisconsin | 55093 | 146 | 0 |
366604 | 366604 | 2020-07-24 | Pierce | Wisconsin | 55093 | 140 | 0 |
363397 | 363397 | 2020-07-23 | Pierce | Wisconsin | 55093 | 140 | 0 |
360191 | 360191 | 2020-07-22 | Pierce | Wisconsin | 55093 | 136 | 0 |
356986 | 356986 | 2020-07-21 | Pierce | Wisconsin | 55093 | 133 | 0 |
353783 | 353783 | 2020-07-20 | Pierce | Wisconsin | 55093 | 128 | 0 |
350581 | 350581 | 2020-07-19 | Pierce | Wisconsin | 55093 | 128 | 0 |
347380 | 347380 | 2020-07-18 | Pierce | Wisconsin | 55093 | 125 | 0 |
344180 | 344180 | 2020-07-17 | Pierce | Wisconsin | 55093 | 123 | 0 |
340981 | 340981 | 2020-07-16 | Pierce | Wisconsin | 55093 | 119 | 0 |
337785 | 337785 | 2020-07-15 | Pierce | Wisconsin | 55093 | 113 | 0 |
334590 | 334590 | 2020-07-14 | Pierce | Wisconsin | 55093 | 110 | 0 |
331397 | 331397 | 2020-07-13 | Pierce | Wisconsin | 55093 | 103 | 0 |
328211 | 328211 | 2020-07-12 | Pierce | Wisconsin | 55093 | 100 | 0 |
325025 | 325025 | 2020-07-11 | Pierce | Wisconsin | 55093 | 99 | 0 |
321844 | 321844 | 2020-07-10 | Pierce | Wisconsin | 55093 | 92 | 0 |
318665 | 318665 | 2020-07-09 | Pierce | Wisconsin | 55093 | 83 | 0 |
315492 | 315492 | 2020-07-08 | Pierce | Wisconsin | 55093 | 80 | 0 |
312317 | 312317 | 2020-07-07 | Pierce | Wisconsin | 55093 | 77 | 0 |
309148 | 309148 | 2020-07-06 | Pierce | Wisconsin | 55093 | 76 | 0 |
305979 | 305979 | 2020-07-05 | Pierce | Wisconsin | 55093 | 75 | 0 |
302815 | 302815 | 2020-07-04 | Pierce | Wisconsin | 55093 | 73 | 0 |
299651 | 299651 | 2020-07-03 | Pierce | Wisconsin | 55093 | 72 | 0 |
296489 | 296489 | 2020-07-02 | Pierce | Wisconsin | 55093 | 68 | 0 |
293334 | 293334 | 2020-07-01 | Pierce | Wisconsin | 55093 | 68 | 0 |
290181 | 290181 | 2020-06-30 | Pierce | Wisconsin | 55093 | 68 | 0 |
287031 | 287031 | 2020-06-29 | Pierce | Wisconsin | 55093 | 68 | 0 |
283885 | 283885 | 2020-06-28 | Pierce | Wisconsin | 55093 | 66 | 0 |
280739 | 280739 | 2020-06-27 | Pierce | Wisconsin | 55093 | 65 | 0 |
277591 | 277591 | 2020-06-26 | Pierce | Wisconsin | 55093 | 64 | 0 |
274443 | 274443 | 2020-06-25 | Pierce | Wisconsin | 55093 | 60 | 0 |
271303 | 271303 | 2020-06-24 | Pierce | Wisconsin | 55093 | 57 | 0 |
268169 | 268169 | 2020-06-23 | Pierce | Wisconsin | 55093 | 57 | 0 |
265040 | 265040 | 2020-06-22 | Pierce | Wisconsin | 55093 | 57 | 0 |
261911 | 261911 | 2020-06-21 | Pierce | Wisconsin | 55093 | 57 | 0 |
258784 | 258784 | 2020-06-20 | Pierce | Wisconsin | 55093 | 57 | 0 |
255657 | 255657 | 2020-06-19 | Pierce | Wisconsin | 55093 | 57 | 0 |
252538 | 252538 | 2020-06-18 | Pierce | Wisconsin | 55093 | 57 | 0 |
249423 | 249423 | 2020-06-17 | Pierce | Wisconsin | 55093 | 57 | 0 |
246311 | 246311 | 2020-06-16 | Pierce | Wisconsin | 55093 | 57 | 0 |
243198 | 243198 | 2020-06-15 | Pierce | Wisconsin | 55093 | 57 | 0 |
240087 | 240087 | 2020-06-14 | Pierce | Wisconsin | 55093 | 54 | 0 |
236979 | 236979 | 2020-06-13 | Pierce | Wisconsin | 55093 | 52 | 0 |
233872 | 233872 | 2020-06-12 | Pierce | Wisconsin | 55093 | 51 | 0 |
230767 | 230767 | 2020-06-11 | Pierce | Wisconsin | 55093 | 51 | 0 |
227663 | 227663 | 2020-06-10 | Pierce | Wisconsin | 55093 | 51 | 0 |
224563 | 224563 | 2020-06-09 | Pierce | Wisconsin | 55093 | 51 | 0 |
221467 | 221467 | 2020-06-08 | Pierce | Wisconsin | 55093 | 50 | 0 |
218375 | 218375 | 2020-06-07 | Pierce | Wisconsin | 55093 | 50 | 0 |
215285 | 215285 | 2020-06-06 | Pierce | Wisconsin | 55093 | 50 | 0 |
212198 | 212198 | 2020-06-05 | Pierce | Wisconsin | 55093 | 50 | 0 |
209113 | 209113 | 2020-06-04 | Pierce | Wisconsin | 55093 | 49 | 0 |
206031 | 206031 | 2020-06-03 | Pierce | Wisconsin | 55093 | 47 | 0 |
202952 | 202952 | 2020-06-02 | Pierce | Wisconsin | 55093 | 47 | 0 |
199876 | 199876 | 2020-06-01 | Pierce | Wisconsin | 55093 | 45 | 0 |
196803 | 196803 | 2020-05-31 | Pierce | Wisconsin | 55093 | 45 | 0 |
193733 | 193733 | 2020-05-30 | Pierce | Wisconsin | 55093 | 45 | 0 |
190667 | 190667 | 2020-05-29 | Pierce | Wisconsin | 55093 | 45 | 0 |
187603 | 187603 | 2020-05-28 | Pierce | Wisconsin | 55093 | 44 | 0 |
184546 | 184546 | 2020-05-27 | Pierce | Wisconsin | 55093 | 43 | 0 |
181495 | 181495 | 2020-05-26 | Pierce | Wisconsin | 55093 | 43 | 0 |
178451 | 178451 | 2020-05-25 | Pierce | Wisconsin | 55093 | 42 | 0 |
175406 | 175406 | 2020-05-24 | Pierce | Wisconsin | 55093 | 42 | 0 |
172363 | 172363 | 2020-05-23 | Pierce | Wisconsin | 55093 | 36 | 0 |
169322 | 169322 | 2020-05-22 | Pierce | Wisconsin | 55093 | 34 | 0 |
166286 | 166286 | 2020-05-21 | Pierce | Wisconsin | 55093 | 30 | 0 |
163256 | 163256 | 2020-05-20 | Pierce | Wisconsin | 55093 | 26 | 0 |
160228 | 160228 | 2020-05-19 | Pierce | Wisconsin | 55093 | 22 | 0 |
157204 | 157204 | 2020-05-18 | Pierce | Wisconsin | 55093 | 21 | 0 |
154188 | 154188 | 2020-05-17 | Pierce | Wisconsin | 55093 | 20 | 0 |
151176 | 151176 | 2020-05-16 | Pierce | Wisconsin | 55093 | 17 | 0 |
148167 | 148167 | 2020-05-15 | Pierce | Wisconsin | 55093 | 16 | 0 |
145164 | 145164 | 2020-05-14 | Pierce | Wisconsin | 55093 | 15 | 0 |
142165 | 142165 | 2020-05-13 | Pierce | Wisconsin | 55093 | 14 | 0 |
139169 | 139169 | 2020-05-12 | Pierce | Wisconsin | 55093 | 14 | 0 |
136178 | 136178 | 2020-05-11 | Pierce | Wisconsin | 55093 | 13 | 0 |
133188 | 133188 | 2020-05-10 | Pierce | Wisconsin | 55093 | 12 | 0 |
130198 | 130198 | 2020-05-09 | Pierce | Wisconsin | 55093 | 12 | 0 |
127208 | 127208 | 2020-05-08 | Pierce | Wisconsin | 55093 | 12 | 0 |
124223 | 124223 | 2020-05-07 | Pierce | Wisconsin | 55093 | 12 | 0 |
121243 | 121243 | 2020-05-06 | Pierce | Wisconsin | 55093 | 11 | 0 |
118277 | 118277 | 2020-05-05 | Pierce | Wisconsin | 55093 | 11 | 0 |
115318 | 115318 | 2020-05-04 | Pierce | Wisconsin | 55093 | 10 | 0 |
112435 | 112435 | 2020-05-03 | Pierce | Wisconsin | 55093 | 10 | 0 |
109560 | 109560 | 2020-05-02 | Pierce | Wisconsin | 55093 | 10 | 0 |
106691 | 106691 | 2020-05-01 | Pierce | Wisconsin | 55093 | 10 | 0 |
103826 | 103826 | 2020-04-30 | Pierce | Wisconsin | 55093 | 10 | 0 |
100971 | 100971 | 2020-04-29 | Pierce | Wisconsin | 55093 | 10 | 0 |
98121 | 98121 | 2020-04-28 | Pierce | Wisconsin | 55093 | 9 | 0 |
95276 | 95276 | 2020-04-27 | Pierce | Wisconsin | 55093 | 9 | 0 |
92446 | 92446 | 2020-04-26 | Pierce | Wisconsin | 55093 | 9 | 0 |
89628 | 89628 | 2020-04-25 | Pierce | Wisconsin | 55093 | 8 | 0 |
86812 | 86812 | 2020-04-24 | Pierce | Wisconsin | 55093 | 8 | 0 |
84005 | 84005 | 2020-04-23 | Pierce | Wisconsin | 55093 | 8 | 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);