ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where deaths = 3, fips = 55111 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
582967 | 582967 | 2020-09-29 | Sauk | Wisconsin | 55111 | 987 | 3 |
579728 | 579728 | 2020-09-28 | Sauk | Wisconsin | 55111 | 965 | 3 |
576487 | 576487 | 2020-09-27 | Sauk | Wisconsin | 55111 | 960 | 3 |
573243 | 573243 | 2020-09-26 | Sauk | Wisconsin | 55111 | 944 | 3 |
570001 | 570001 | 2020-09-25 | Sauk | Wisconsin | 55111 | 927 | 3 |
566760 | 566760 | 2020-09-24 | Sauk | Wisconsin | 55111 | 917 | 3 |
563519 | 563519 | 2020-09-23 | Sauk | Wisconsin | 55111 | 889 | 3 |
560280 | 560280 | 2020-09-22 | Sauk | Wisconsin | 55111 | 879 | 3 |
557044 | 557044 | 2020-09-21 | Sauk | Wisconsin | 55111 | 863 | 3 |
553807 | 553807 | 2020-09-20 | Sauk | Wisconsin | 55111 | 862 | 3 |
550568 | 550568 | 2020-09-19 | Sauk | Wisconsin | 55111 | 842 | 3 |
547329 | 547329 | 2020-09-18 | Sauk | Wisconsin | 55111 | 834 | 3 |
544092 | 544092 | 2020-09-17 | Sauk | Wisconsin | 55111 | 815 | 3 |
540856 | 540856 | 2020-09-16 | Sauk | Wisconsin | 55111 | 787 | 3 |
537619 | 537619 | 2020-09-15 | Sauk | Wisconsin | 55111 | 787 | 3 |
534383 | 534383 | 2020-09-14 | Sauk | Wisconsin | 55111 | 781 | 3 |
531148 | 531148 | 2020-09-13 | Sauk | Wisconsin | 55111 | 780 | 3 |
527911 | 527911 | 2020-09-12 | Sauk | Wisconsin | 55111 | 765 | 3 |
524675 | 524675 | 2020-09-11 | Sauk | Wisconsin | 55111 | 755 | 3 |
521439 | 521439 | 2020-09-10 | Sauk | Wisconsin | 55111 | 748 | 3 |
518202 | 518202 | 2020-09-09 | Sauk | Wisconsin | 55111 | 740 | 3 |
514967 | 514967 | 2020-09-08 | Sauk | Wisconsin | 55111 | 738 | 3 |
511734 | 511734 | 2020-09-07 | Sauk | Wisconsin | 55111 | 736 | 3 |
508501 | 508501 | 2020-09-06 | Sauk | Wisconsin | 55111 | 736 | 3 |
505269 | 505269 | 2020-09-05 | Sauk | Wisconsin | 55111 | 733 | 3 |
502035 | 502035 | 2020-09-04 | Sauk | Wisconsin | 55111 | 731 | 3 |
498801 | 498801 | 2020-09-03 | Sauk | Wisconsin | 55111 | 660 | 3 |
495568 | 495568 | 2020-09-02 | Sauk | Wisconsin | 55111 | 654 | 3 |
492334 | 492334 | 2020-09-01 | Sauk | Wisconsin | 55111 | 650 | 3 |
489101 | 489101 | 2020-08-31 | Sauk | Wisconsin | 55111 | 644 | 3 |
485868 | 485868 | 2020-08-30 | Sauk | Wisconsin | 55111 | 644 | 3 |
482633 | 482633 | 2020-08-29 | Sauk | Wisconsin | 55111 | 634 | 3 |
479399 | 479399 | 2020-08-28 | Sauk | Wisconsin | 55111 | 627 | 3 |
476166 | 476166 | 2020-08-27 | Sauk | Wisconsin | 55111 | 628 | 3 |
472933 | 472933 | 2020-08-26 | Sauk | Wisconsin | 55111 | 614 | 3 |
469701 | 469701 | 2020-08-25 | Sauk | Wisconsin | 55111 | 598 | 3 |
466472 | 466472 | 2020-08-24 | Sauk | Wisconsin | 55111 | 590 | 3 |
463243 | 463243 | 2020-08-23 | Sauk | Wisconsin | 55111 | 588 | 3 |
460014 | 460014 | 2020-08-22 | Sauk | Wisconsin | 55111 | 569 | 3 |
456787 | 456787 | 2020-08-21 | Sauk | Wisconsin | 55111 | 560 | 3 |
453559 | 453559 | 2020-08-20 | Sauk | Wisconsin | 55111 | 547 | 3 |
450331 | 450331 | 2020-08-19 | Sauk | Wisconsin | 55111 | 537 | 3 |
447103 | 447103 | 2020-08-18 | Sauk | Wisconsin | 55111 | 510 | 3 |
443876 | 443876 | 2020-08-17 | Sauk | Wisconsin | 55111 | 513 | 3 |
440650 | 440650 | 2020-08-16 | Sauk | Wisconsin | 55111 | 512 | 3 |
437424 | 437424 | 2020-08-15 | Sauk | Wisconsin | 55111 | 502 | 3 |
434198 | 434198 | 2020-08-14 | Sauk | Wisconsin | 55111 | 495 | 3 |
430973 | 430973 | 2020-08-13 | Sauk | Wisconsin | 55111 | 484 | 3 |
427745 | 427745 | 2020-08-12 | Sauk | Wisconsin | 55111 | 472 | 3 |
424521 | 424521 | 2020-08-11 | Sauk | Wisconsin | 55111 | 452 | 3 |
421300 | 421300 | 2020-08-10 | Sauk | Wisconsin | 55111 | 444 | 3 |
418079 | 418079 | 2020-08-09 | Sauk | Wisconsin | 55111 | 444 | 3 |
414858 | 414858 | 2020-08-08 | Sauk | Wisconsin | 55111 | 433 | 3 |
411638 | 411638 | 2020-08-07 | Sauk | Wisconsin | 55111 | 425 | 3 |
408419 | 408419 | 2020-08-06 | Sauk | Wisconsin | 55111 | 423 | 3 |
405199 | 405199 | 2020-08-05 | Sauk | Wisconsin | 55111 | 411 | 3 |
401981 | 401981 | 2020-08-04 | Sauk | Wisconsin | 55111 | 405 | 3 |
398765 | 398765 | 2020-08-03 | Sauk | Wisconsin | 55111 | 392 | 3 |
395549 | 395549 | 2020-08-02 | Sauk | Wisconsin | 55111 | 386 | 3 |
392333 | 392333 | 2020-08-01 | Sauk | Wisconsin | 55111 | 372 | 3 |
389116 | 389116 | 2020-07-31 | Sauk | Wisconsin | 55111 | 347 | 3 |
385899 | 385899 | 2020-07-30 | Sauk | Wisconsin | 55111 | 338 | 3 |
382681 | 382681 | 2020-07-29 | Sauk | Wisconsin | 55111 | 319 | 3 |
379464 | 379464 | 2020-07-28 | Sauk | Wisconsin | 55111 | 309 | 3 |
376248 | 376248 | 2020-07-27 | Sauk | Wisconsin | 55111 | 293 | 3 |
373034 | 373034 | 2020-07-26 | Sauk | Wisconsin | 55111 | 288 | 3 |
369822 | 369822 | 2020-07-25 | Sauk | Wisconsin | 55111 | 273 | 3 |
366612 | 366612 | 2020-07-24 | Sauk | Wisconsin | 55111 | 262 | 3 |
363405 | 363405 | 2020-07-23 | Sauk | Wisconsin | 55111 | 253 | 3 |
360199 | 360199 | 2020-07-22 | Sauk | Wisconsin | 55111 | 247 | 3 |
356994 | 356994 | 2020-07-21 | Sauk | Wisconsin | 55111 | 232 | 3 |
353791 | 353791 | 2020-07-20 | Sauk | Wisconsin | 55111 | 230 | 3 |
350589 | 350589 | 2020-07-19 | Sauk | Wisconsin | 55111 | 218 | 3 |
347388 | 347388 | 2020-07-18 | Sauk | Wisconsin | 55111 | 205 | 3 |
344188 | 344188 | 2020-07-17 | Sauk | Wisconsin | 55111 | 201 | 3 |
340989 | 340989 | 2020-07-16 | Sauk | Wisconsin | 55111 | 194 | 3 |
337793 | 337793 | 2020-07-15 | Sauk | Wisconsin | 55111 | 191 | 3 |
334598 | 334598 | 2020-07-14 | Sauk | Wisconsin | 55111 | 190 | 3 |
331405 | 331405 | 2020-07-13 | Sauk | Wisconsin | 55111 | 169 | 3 |
328219 | 328219 | 2020-07-12 | Sauk | Wisconsin | 55111 | 164 | 3 |
325033 | 325033 | 2020-07-11 | Sauk | Wisconsin | 55111 | 147 | 3 |
321852 | 321852 | 2020-07-10 | Sauk | Wisconsin | 55111 | 144 | 3 |
318673 | 318673 | 2020-07-09 | Sauk | Wisconsin | 55111 | 137 | 3 |
315500 | 315500 | 2020-07-08 | Sauk | Wisconsin | 55111 | 130 | 3 |
312325 | 312325 | 2020-07-07 | Sauk | Wisconsin | 55111 | 123 | 3 |
309156 | 309156 | 2020-07-06 | Sauk | Wisconsin | 55111 | 123 | 3 |
305987 | 305987 | 2020-07-05 | Sauk | Wisconsin | 55111 | 123 | 3 |
302823 | 302823 | 2020-07-04 | Sauk | Wisconsin | 55111 | 119 | 3 |
299659 | 299659 | 2020-07-03 | Sauk | Wisconsin | 55111 | 117 | 3 |
296497 | 296497 | 2020-07-02 | Sauk | Wisconsin | 55111 | 109 | 3 |
293342 | 293342 | 2020-07-01 | Sauk | Wisconsin | 55111 | 108 | 3 |
290189 | 290189 | 2020-06-30 | Sauk | Wisconsin | 55111 | 107 | 3 |
287039 | 287039 | 2020-06-29 | Sauk | Wisconsin | 55111 | 105 | 3 |
283893 | 283893 | 2020-06-28 | Sauk | Wisconsin | 55111 | 102 | 3 |
280747 | 280747 | 2020-06-27 | Sauk | Wisconsin | 55111 | 100 | 3 |
277599 | 277599 | 2020-06-26 | Sauk | Wisconsin | 55111 | 98 | 3 |
274451 | 274451 | 2020-06-25 | Sauk | Wisconsin | 55111 | 98 | 3 |
271311 | 271311 | 2020-06-24 | Sauk | Wisconsin | 55111 | 97 | 3 |
268177 | 268177 | 2020-06-23 | Sauk | Wisconsin | 55111 | 97 | 3 |
265048 | 265048 | 2020-06-22 | Sauk | Wisconsin | 55111 | 96 | 3 |
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);