ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389114 | 389114 | 2020-07-31 | Rock | Wisconsin | 55105 | 1477 | 26 |
385897 | 385897 | 2020-07-30 | Rock | Wisconsin | 55105 | 1460 | 26 |
382679 | 382679 | 2020-07-29 | Rock | Wisconsin | 55105 | 1458 | 26 |
379462 | 379462 | 2020-07-28 | Rock | Wisconsin | 55105 | 1435 | 25 |
376246 | 376246 | 2020-07-27 | Rock | Wisconsin | 55105 | 1430 | 25 |
373032 | 373032 | 2020-07-26 | Rock | Wisconsin | 55105 | 1421 | 25 |
369820 | 369820 | 2020-07-25 | Rock | Wisconsin | 55105 | 1412 | 25 |
366610 | 366610 | 2020-07-24 | Rock | Wisconsin | 55105 | 1381 | 25 |
363403 | 363403 | 2020-07-23 | Rock | Wisconsin | 55105 | 1368 | 25 |
360197 | 360197 | 2020-07-22 | Rock | Wisconsin | 55105 | 1354 | 25 |
356992 | 356992 | 2020-07-21 | Rock | Wisconsin | 55105 | 1324 | 25 |
353789 | 353789 | 2020-07-20 | Rock | Wisconsin | 55105 | 1295 | 24 |
350587 | 350587 | 2020-07-19 | Rock | Wisconsin | 55105 | 1295 | 24 |
347386 | 347386 | 2020-07-18 | Rock | Wisconsin | 55105 | 1267 | 24 |
344186 | 344186 | 2020-07-17 | Rock | Wisconsin | 55105 | 1248 | 24 |
340987 | 340987 | 2020-07-16 | Rock | Wisconsin | 55105 | 1219 | 24 |
337791 | 337791 | 2020-07-15 | Rock | Wisconsin | 55105 | 1200 | 24 |
334596 | 334596 | 2020-07-14 | Rock | Wisconsin | 55105 | 1187 | 24 |
331403 | 331403 | 2020-07-13 | Rock | Wisconsin | 55105 | 1156 | 24 |
328217 | 328217 | 2020-07-12 | Rock | Wisconsin | 55105 | 1153 | 24 |
325031 | 325031 | 2020-07-11 | Rock | Wisconsin | 55105 | 1135 | 24 |
321850 | 321850 | 2020-07-10 | Rock | Wisconsin | 55105 | 1114 | 24 |
318671 | 318671 | 2020-07-09 | Rock | Wisconsin | 55105 | 1088 | 24 |
315498 | 315498 | 2020-07-08 | Rock | Wisconsin | 55105 | 1070 | 24 |
312323 | 312323 | 2020-07-07 | Rock | Wisconsin | 55105 | 1053 | 24 |
309154 | 309154 | 2020-07-06 | Rock | Wisconsin | 55105 | 1046 | 24 |
305985 | 305985 | 2020-07-05 | Rock | Wisconsin | 55105 | 1005 | 24 |
302821 | 302821 | 2020-07-04 | Rock | Wisconsin | 55105 | 1003 | 24 |
299657 | 299657 | 2020-07-03 | Rock | Wisconsin | 55105 | 1002 | 24 |
296495 | 296495 | 2020-07-02 | Rock | Wisconsin | 55105 | 987 | 24 |
293340 | 293340 | 2020-07-01 | Rock | Wisconsin | 55105 | 978 | 24 |
290187 | 290187 | 2020-06-30 | Rock | Wisconsin | 55105 | 968 | 24 |
287037 | 287037 | 2020-06-29 | Rock | Wisconsin | 55105 | 957 | 23 |
283891 | 283891 | 2020-06-28 | Rock | Wisconsin | 55105 | 953 | 23 |
280745 | 280745 | 2020-06-27 | Rock | Wisconsin | 55105 | 932 | 23 |
277597 | 277597 | 2020-06-26 | Rock | Wisconsin | 55105 | 932 | 23 |
274449 | 274449 | 2020-06-25 | Rock | Wisconsin | 55105 | 924 | 23 |
271309 | 271309 | 2020-06-24 | Rock | Wisconsin | 55105 | 916 | 23 |
268175 | 268175 | 2020-06-23 | Rock | Wisconsin | 55105 | 905 | 23 |
265046 | 265046 | 2020-06-22 | Rock | Wisconsin | 55105 | 893 | 23 |
261917 | 261917 | 2020-06-21 | Rock | Wisconsin | 55105 | 881 | 23 |
258790 | 258790 | 2020-06-20 | Rock | Wisconsin | 55105 | 881 | 23 |
255663 | 255663 | 2020-06-19 | Rock | Wisconsin | 55105 | 875 | 23 |
252544 | 252544 | 2020-06-18 | Rock | Wisconsin | 55105 | 871 | 22 |
249429 | 249429 | 2020-06-17 | Rock | Wisconsin | 55105 | 857 | 22 |
246317 | 246317 | 2020-06-16 | Rock | Wisconsin | 55105 | 851 | 22 |
243204 | 243204 | 2020-06-15 | Rock | Wisconsin | 55105 | 844 | 21 |
240093 | 240093 | 2020-06-14 | Rock | Wisconsin | 55105 | 842 | 21 |
236985 | 236985 | 2020-06-13 | Rock | Wisconsin | 55105 | 840 | 21 |
233878 | 233878 | 2020-06-12 | Rock | Wisconsin | 55105 | 832 | 21 |
230773 | 230773 | 2020-06-11 | Rock | Wisconsin | 55105 | 817 | 21 |
227669 | 227669 | 2020-06-10 | Rock | Wisconsin | 55105 | 812 | 21 |
224569 | 224569 | 2020-06-09 | Rock | Wisconsin | 55105 | 799 | 21 |
221473 | 221473 | 2020-06-08 | Rock | Wisconsin | 55105 | 792 | 21 |
218381 | 218381 | 2020-06-07 | Rock | Wisconsin | 55105 | 770 | 21 |
215291 | 215291 | 2020-06-06 | Rock | Wisconsin | 55105 | 770 | 21 |
212204 | 212204 | 2020-06-05 | Rock | Wisconsin | 55105 | 767 | 20 |
209119 | 209119 | 2020-06-04 | Rock | Wisconsin | 55105 | 757 | 20 |
206037 | 206037 | 2020-06-03 | Rock | Wisconsin | 55105 | 744 | 19 |
202958 | 202958 | 2020-06-02 | Rock | Wisconsin | 55105 | 646 | 19 |
199882 | 199882 | 2020-06-01 | Rock | Wisconsin | 55105 | 639 | 19 |
196809 | 196809 | 2020-05-31 | Rock | Wisconsin | 55105 | 636 | 19 |
193739 | 193739 | 2020-05-30 | Rock | Wisconsin | 55105 | 632 | 19 |
190673 | 190673 | 2020-05-29 | Rock | Wisconsin | 55105 | 620 | 18 |
187609 | 187609 | 2020-05-28 | Rock | Wisconsin | 55105 | 607 | 18 |
184552 | 184552 | 2020-05-27 | Rock | Wisconsin | 55105 | 588 | 18 |
181501 | 181501 | 2020-05-26 | Rock | Wisconsin | 55105 | 583 | 16 |
178457 | 178457 | 2020-05-25 | Rock | Wisconsin | 55105 | 569 | 16 |
175412 | 175412 | 2020-05-24 | Rock | Wisconsin | 55105 | 545 | 16 |
172369 | 172369 | 2020-05-23 | Rock | Wisconsin | 55105 | 529 | 16 |
169328 | 169328 | 2020-05-22 | Rock | Wisconsin | 55105 | 520 | 15 |
166292 | 166292 | 2020-05-21 | Rock | Wisconsin | 55105 | 493 | 14 |
163262 | 163262 | 2020-05-20 | Rock | Wisconsin | 55105 | 452 | 14 |
160234 | 160234 | 2020-05-19 | Rock | Wisconsin | 55105 | 438 | 14 |
157210 | 157210 | 2020-05-18 | Rock | Wisconsin | 55105 | 432 | 14 |
154194 | 154194 | 2020-05-17 | Rock | Wisconsin | 55105 | 429 | 14 |
151182 | 151182 | 2020-05-16 | Rock | Wisconsin | 55105 | 422 | 14 |
148173 | 148173 | 2020-05-15 | Rock | Wisconsin | 55105 | 406 | 14 |
145170 | 145170 | 2020-05-14 | Rock | Wisconsin | 55105 | 393 | 14 |
142171 | 142171 | 2020-05-13 | Rock | Wisconsin | 55105 | 380 | 13 |
139175 | 139175 | 2020-05-12 | Rock | Wisconsin | 55105 | 369 | 13 |
136184 | 136184 | 2020-05-11 | Rock | Wisconsin | 55105 | 361 | 13 |
133194 | 133194 | 2020-05-10 | Rock | Wisconsin | 55105 | 354 | 13 |
130204 | 130204 | 2020-05-09 | Rock | Wisconsin | 55105 | 347 | 13 |
127214 | 127214 | 2020-05-08 | Rock | Wisconsin | 55105 | 343 | 12 |
124229 | 124229 | 2020-05-07 | Rock | Wisconsin | 55105 | 324 | 12 |
121249 | 121249 | 2020-05-06 | Rock | Wisconsin | 55105 | 311 | 10 |
118283 | 118283 | 2020-05-05 | Rock | Wisconsin | 55105 | 301 | 9 |
115324 | 115324 | 2020-05-04 | Rock | Wisconsin | 55105 | 289 | 7 |
112441 | 112441 | 2020-05-03 | Rock | Wisconsin | 55105 | 262 | 7 |
109566 | 109566 | 2020-05-02 | Rock | Wisconsin | 55105 | 243 | 7 |
106697 | 106697 | 2020-05-01 | Rock | Wisconsin | 55105 | 222 | 6 |
103832 | 103832 | 2020-04-30 | Rock | Wisconsin | 55105 | 198 | 6 |
100977 | 100977 | 2020-04-29 | Rock | Wisconsin | 55105 | 183 | 6 |
98127 | 98127 | 2020-04-28 | Rock | Wisconsin | 55105 | 178 | 6 |
95282 | 95282 | 2020-04-27 | Rock | Wisconsin | 55105 | 164 | 5 |
92452 | 92452 | 2020-04-26 | Rock | Wisconsin | 55105 | 151 | 5 |
89634 | 89634 | 2020-04-25 | Rock | Wisconsin | 55105 | 151 | 4 |
86818 | 86818 | 2020-04-24 | Rock | Wisconsin | 55105 | 120 | 4 |
84011 | 84011 | 2020-04-23 | Rock | Wisconsin | 55105 | 99 | 4 |
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);