ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where county = "Green", deaths = 3 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
644551 | 644551 | 2020-10-18 | Green | Wisconsin | 55045 | 796 | 3 |
641303 | 641303 | 2020-10-17 | Green | Wisconsin | 55045 | 796 | 3 |
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 |
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);