ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where deaths = 6, fips = 55093 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 |
---|---|---|---|---|---|---|---|
566752 | 566752 | 2020-09-24 | Pierce | Wisconsin | 55093 | 658 | 6 |
563511 | 563511 | 2020-09-23 | Pierce | Wisconsin | 55093 | 654 | 6 |
560272 | 560272 | 2020-09-22 | Pierce | Wisconsin | 55093 | 628 | 6 |
557036 | 557036 | 2020-09-21 | Pierce | Wisconsin | 55093 | 609 | 6 |
553799 | 553799 | 2020-09-20 | Pierce | Wisconsin | 55093 | 601 | 6 |
550560 | 550560 | 2020-09-19 | Pierce | Wisconsin | 55093 | 553 | 6 |
547321 | 547321 | 2020-09-18 | Pierce | Wisconsin | 55093 | 508 | 6 |
544084 | 544084 | 2020-09-17 | Pierce | Wisconsin | 55093 | 481 | 6 |
540848 | 540848 | 2020-09-16 | Pierce | Wisconsin | 55093 | 457 | 6 |
537611 | 537611 | 2020-09-15 | Pierce | Wisconsin | 55093 | 439 | 6 |
534375 | 534375 | 2020-09-14 | Pierce | Wisconsin | 55093 | 416 | 6 |
531140 | 531140 | 2020-09-13 | Pierce | Wisconsin | 55093 | 409 | 6 |
527903 | 527903 | 2020-09-12 | Pierce | Wisconsin | 55093 | 407 | 6 |
524667 | 524667 | 2020-09-11 | Pierce | Wisconsin | 55093 | 401 | 6 |
521431 | 521431 | 2020-09-10 | Pierce | Wisconsin | 55093 | 395 | 6 |
518194 | 518194 | 2020-09-09 | Pierce | Wisconsin | 55093 | 392 | 6 |
514959 | 514959 | 2020-09-08 | Pierce | Wisconsin | 55093 | 390 | 6 |
511726 | 511726 | 2020-09-07 | Pierce | Wisconsin | 55093 | 387 | 6 |
508493 | 508493 | 2020-09-06 | Pierce | Wisconsin | 55093 | 386 | 6 |
505261 | 505261 | 2020-09-05 | Pierce | Wisconsin | 55093 | 377 | 6 |
502027 | 502027 | 2020-09-04 | Pierce | Wisconsin | 55093 | 371 | 6 |
498793 | 498793 | 2020-09-03 | Pierce | Wisconsin | 55093 | 295 | 6 |
495560 | 495560 | 2020-09-02 | Pierce | Wisconsin | 55093 | 294 | 6 |
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);