ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where county = "Walla Walla", deaths = 7 and state = "Washington" 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 |
---|---|---|---|---|---|---|---|
689885 | 689885 | 2020-11-01 | Walla Walla | Washington | 53071 | 1312 | 7 |
686640 | 686640 | 2020-10-31 | Walla Walla | Washington | 53071 | 1252 | 7 |
683397 | 683397 | 2020-10-30 | Walla Walla | Washington | 53071 | 1232 | 7 |
680154 | 680154 | 2020-10-29 | Walla Walla | Washington | 53071 | 1204 | 7 |
676911 | 676911 | 2020-10-28 | Walla Walla | Washington | 53071 | 1170 | 7 |
673668 | 673668 | 2020-10-27 | Walla Walla | Washington | 53071 | 1165 | 7 |
670426 | 670426 | 2020-10-26 | Walla Walla | Washington | 53071 | 1151 | 7 |
667183 | 667183 | 2020-10-25 | Walla Walla | Washington | 53071 | 1137 | 7 |
663938 | 663938 | 2020-10-24 | Walla Walla | Washington | 53071 | 1119 | 7 |
660694 | 660694 | 2020-10-23 | Walla Walla | Washington | 53071 | 1090 | 7 |
657450 | 657450 | 2020-10-22 | Walla Walla | Washington | 53071 | 1065 | 7 |
654205 | 654205 | 2020-10-21 | Walla Walla | Washington | 53071 | 1045 | 7 |
650960 | 650960 | 2020-10-20 | Walla Walla | Washington | 53071 | 1030 | 7 |
647716 | 647716 | 2020-10-19 | Walla Walla | Washington | 53071 | 1018 | 7 |
644470 | 644470 | 2020-10-18 | Walla Walla | Washington | 53071 | 1011 | 7 |
641222 | 641222 | 2020-10-17 | Walla Walla | Washington | 53071 | 1003 | 7 |
637975 | 637975 | 2020-10-16 | Walla Walla | Washington | 53071 | 996 | 7 |
634730 | 634730 | 2020-10-15 | Walla Walla | Washington | 53071 | 983 | 7 |
631485 | 631485 | 2020-10-14 | Walla Walla | Washington | 53071 | 978 | 7 |
628241 | 628241 | 2020-10-13 | Walla Walla | Washington | 53071 | 967 | 7 |
624998 | 624998 | 2020-10-12 | Walla Walla | Washington | 53071 | 963 | 7 |
621755 | 621755 | 2020-10-11 | Walla Walla | Washington | 53071 | 962 | 7 |
618512 | 618512 | 2020-10-10 | Walla Walla | Washington | 53071 | 958 | 7 |
615270 | 615270 | 2020-10-09 | Walla Walla | Washington | 53071 | 953 | 7 |
612029 | 612029 | 2020-10-08 | Walla Walla | Washington | 53071 | 951 | 7 |
608787 | 608787 | 2020-10-07 | Walla Walla | Washington | 53071 | 948 | 7 |
605544 | 605544 | 2020-10-06 | Walla Walla | Washington | 53071 | 942 | 7 |
579614 | 579614 | 2020-09-28 | Walla Walla | Washington | 53071 | 907 | 7 |
576373 | 576373 | 2020-09-27 | Walla Walla | Washington | 53071 | 905 | 7 |
573129 | 573129 | 2020-09-26 | Walla Walla | Washington | 53071 | 898 | 7 |
569887 | 569887 | 2020-09-25 | Walla Walla | Washington | 53071 | 897 | 7 |
485754 | 485754 | 2020-08-30 | Walla Walla | Washington | 53071 | 758 | 7 |
482519 | 482519 | 2020-08-29 | Walla Walla | Washington | 53071 | 750 | 7 |
479285 | 479285 | 2020-08-28 | Walla Walla | Washington | 53071 | 750 | 7 |
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);