ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55045 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638056 | 638056 | 2020-10-16 | Green | Wisconsin | 55045 | 796 | 3 |
634811 | 634811 | 2020-10-15 | Green | Wisconsin | 55045 | 780 | 3 |
631566 | 631566 | 2020-10-14 | Green | Wisconsin | 55045 | 762 | 3 |
628322 | 628322 | 2020-10-13 | Green | Wisconsin | 55045 | 737 | 3 |
625079 | 625079 | 2020-10-12 | Green | Wisconsin | 55045 | 721 | 3 |
621836 | 621836 | 2020-10-11 | Green | Wisconsin | 55045 | 702 | 3 |
618593 | 618593 | 2020-10-10 | Green | Wisconsin | 55045 | 683 | 3 |
615351 | 615351 | 2020-10-09 | Green | Wisconsin | 55045 | 679 | 3 |
612110 | 612110 | 2020-10-08 | Green | Wisconsin | 55045 | 670 | 3 |
608868 | 608868 | 2020-10-07 | Green | Wisconsin | 55045 | 655 | 3 |
605625 | 605625 | 2020-10-06 | Green | Wisconsin | 55045 | 642 | 3 |
602383 | 602383 | 2020-10-05 | Green | Wisconsin | 55045 | 637 | 3 |
599140 | 599140 | 2020-10-04 | Green | Wisconsin | 55045 | 622 | 3 |
595897 | 595897 | 2020-10-03 | Green | Wisconsin | 55045 | 606 | 3 |
592655 | 592655 | 2020-10-02 | Green | Wisconsin | 55045 | 595 | 3 |
589415 | 589415 | 2020-10-01 | Green | Wisconsin | 55045 | 587 | 3 |
586174 | 586174 | 2020-09-30 | Green | Wisconsin | 55045 | 580 | 3 |
582934 | 582934 | 2020-09-29 | Green | Wisconsin | 55045 | 558 | 3 |
579695 | 579695 | 2020-09-28 | Green | Wisconsin | 55045 | 548 | 3 |
576454 | 576454 | 2020-09-27 | Green | Wisconsin | 55045 | 535 | 3 |
573210 | 573210 | 2020-09-26 | Green | Wisconsin | 55045 | 505 | 3 |
569968 | 569968 | 2020-09-25 | Green | Wisconsin | 55045 | 495 | 2 |
566727 | 566727 | 2020-09-24 | Green | Wisconsin | 55045 | 486 | 2 |
563486 | 563486 | 2020-09-23 | Green | Wisconsin | 55045 | 478 | 2 |
560247 | 560247 | 2020-09-22 | Green | Wisconsin | 55045 | 469 | 2 |
557011 | 557011 | 2020-09-21 | Green | Wisconsin | 55045 | 463 | 2 |
553774 | 553774 | 2020-09-20 | Green | Wisconsin | 55045 | 456 | 2 |
550535 | 550535 | 2020-09-19 | Green | Wisconsin | 55045 | 449 | 2 |
547296 | 547296 | 2020-09-18 | Green | Wisconsin | 55045 | 415 | 2 |
544059 | 544059 | 2020-09-17 | Green | Wisconsin | 55045 | 404 | 2 |
540823 | 540823 | 2020-09-16 | Green | Wisconsin | 55045 | 391 | 2 |
537586 | 537586 | 2020-09-15 | Green | Wisconsin | 55045 | 382 | 2 |
534350 | 534350 | 2020-09-14 | Green | Wisconsin | 55045 | 378 | 2 |
531115 | 531115 | 2020-09-13 | Green | Wisconsin | 55045 | 377 | 2 |
527878 | 527878 | 2020-09-12 | Green | Wisconsin | 55045 | 360 | 2 |
524642 | 524642 | 2020-09-11 | Green | Wisconsin | 55045 | 352 | 2 |
521406 | 521406 | 2020-09-10 | Green | Wisconsin | 55045 | 342 | 2 |
518169 | 518169 | 2020-09-09 | Green | Wisconsin | 55045 | 336 | 2 |
514934 | 514934 | 2020-09-08 | Green | Wisconsin | 55045 | 330 | 2 |
511701 | 511701 | 2020-09-07 | Green | Wisconsin | 55045 | 324 | 2 |
508468 | 508468 | 2020-09-06 | Green | Wisconsin | 55045 | 310 | 2 |
505236 | 505236 | 2020-09-05 | Green | Wisconsin | 55045 | 302 | 2 |
502002 | 502002 | 2020-09-04 | Green | Wisconsin | 55045 | 298 | 2 |
498768 | 498768 | 2020-09-03 | Green | Wisconsin | 55045 | 272 | 1 |
495535 | 495535 | 2020-09-02 | Green | Wisconsin | 55045 | 269 | 1 |
492301 | 492301 | 2020-09-01 | Green | Wisconsin | 55045 | 270 | 1 |
489068 | 489068 | 2020-08-31 | Green | Wisconsin | 55045 | 270 | 1 |
485835 | 485835 | 2020-08-30 | Green | Wisconsin | 55045 | 268 | 1 |
482600 | 482600 | 2020-08-29 | Green | Wisconsin | 55045 | 265 | 1 |
479366 | 479366 | 2020-08-28 | Green | Wisconsin | 55045 | 262 | 1 |
476133 | 476133 | 2020-08-27 | Green | Wisconsin | 55045 | 261 | 1 |
472900 | 472900 | 2020-08-26 | Green | Wisconsin | 55045 | 256 | 1 |
469668 | 469668 | 2020-08-25 | Green | Wisconsin | 55045 | 255 | 1 |
466439 | 466439 | 2020-08-24 | Green | Wisconsin | 55045 | 250 | 1 |
463210 | 463210 | 2020-08-23 | Green | Wisconsin | 55045 | 249 | 1 |
459981 | 459981 | 2020-08-22 | Green | Wisconsin | 55045 | 247 | 1 |
456754 | 456754 | 2020-08-21 | Green | Wisconsin | 55045 | 235 | 1 |
453526 | 453526 | 2020-08-20 | Green | Wisconsin | 55045 | 229 | 1 |
450298 | 450298 | 2020-08-19 | Green | Wisconsin | 55045 | 225 | 1 |
447070 | 447070 | 2020-08-18 | Green | Wisconsin | 55045 | 221 | 1 |
443843 | 443843 | 2020-08-17 | Green | Wisconsin | 55045 | 220 | 1 |
440617 | 440617 | 2020-08-16 | Green | Wisconsin | 55045 | 214 | 1 |
437391 | 437391 | 2020-08-15 | Green | Wisconsin | 55045 | 210 | 1 |
434165 | 434165 | 2020-08-14 | Green | Wisconsin | 55045 | 194 | 1 |
430940 | 430940 | 2020-08-13 | Green | Wisconsin | 55045 | 186 | 1 |
427712 | 427712 | 2020-08-12 | Green | Wisconsin | 55045 | 179 | 1 |
424488 | 424488 | 2020-08-11 | Green | Wisconsin | 55045 | 169 | 1 |
421267 | 421267 | 2020-08-10 | Green | Wisconsin | 55045 | 167 | 1 |
418046 | 418046 | 2020-08-09 | Green | Wisconsin | 55045 | 162 | 1 |
414825 | 414825 | 2020-08-08 | Green | Wisconsin | 55045 | 158 | 1 |
411605 | 411605 | 2020-08-07 | Green | Wisconsin | 55045 | 149 | 1 |
408386 | 408386 | 2020-08-06 | Green | Wisconsin | 55045 | 137 | 1 |
405166 | 405166 | 2020-08-05 | Green | Wisconsin | 55045 | 135 | 1 |
401948 | 401948 | 2020-08-04 | Green | Wisconsin | 55045 | 131 | 1 |
398732 | 398732 | 2020-08-03 | Green | Wisconsin | 55045 | 131 | 1 |
395516 | 395516 | 2020-08-02 | Green | Wisconsin | 55045 | 130 | 1 |
392300 | 392300 | 2020-08-01 | Green | Wisconsin | 55045 | 125 | 1 |
389083 | 389083 | 2020-07-31 | Green | Wisconsin | 55045 | 123 | 1 |
385866 | 385866 | 2020-07-30 | Green | Wisconsin | 55045 | 121 | 1 |
382648 | 382648 | 2020-07-29 | Green | Wisconsin | 55045 | 121 | 1 |
379431 | 379431 | 2020-07-28 | Green | Wisconsin | 55045 | 121 | 1 |
376215 | 376215 | 2020-07-27 | Green | Wisconsin | 55045 | 120 | 1 |
373001 | 373001 | 2020-07-26 | Green | Wisconsin | 55045 | 120 | 1 |
369789 | 369789 | 2020-07-25 | Green | Wisconsin | 55045 | 119 | 1 |
366579 | 366579 | 2020-07-24 | Green | Wisconsin | 55045 | 119 | 1 |
363372 | 363372 | 2020-07-23 | Green | Wisconsin | 55045 | 119 | 1 |
360166 | 360166 | 2020-07-22 | Green | Wisconsin | 55045 | 118 | 1 |
356961 | 356961 | 2020-07-21 | Green | Wisconsin | 55045 | 118 | 1 |
353758 | 353758 | 2020-07-20 | Green | Wisconsin | 55045 | 117 | 1 |
350556 | 350556 | 2020-07-19 | Green | Wisconsin | 55045 | 116 | 1 |
347355 | 347355 | 2020-07-18 | Green | Wisconsin | 55045 | 114 | 1 |
344155 | 344155 | 2020-07-17 | Green | Wisconsin | 55045 | 114 | 1 |
340956 | 340956 | 2020-07-16 | Green | Wisconsin | 55045 | 113 | 1 |
337760 | 337760 | 2020-07-15 | Green | Wisconsin | 55045 | 110 | 1 |
334565 | 334565 | 2020-07-14 | Green | Wisconsin | 55045 | 110 | 1 |
331372 | 331372 | 2020-07-13 | Green | Wisconsin | 55045 | 110 | 1 |
328186 | 328186 | 2020-07-12 | Green | Wisconsin | 55045 | 110 | 1 |
325000 | 325000 | 2020-07-11 | Green | Wisconsin | 55045 | 106 | 1 |
321819 | 321819 | 2020-07-10 | Green | Wisconsin | 55045 | 105 | 1 |
318640 | 318640 | 2020-07-09 | Green | Wisconsin | 55045 | 103 | 1 |
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);