ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Taylor", deaths = 6 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
576422 | 576422 | 2020-09-27 | Taylor | West Virginia | 54091 | 126 | 6 |
573178 | 573178 | 2020-09-26 | Taylor | West Virginia | 54091 | 124 | 6 |
569936 | 569936 | 2020-09-25 | Taylor | West Virginia | 54091 | 120 | 6 |
566695 | 566695 | 2020-09-24 | Taylor | West Virginia | 54091 | 120 | 6 |
563454 | 563454 | 2020-09-23 | Taylor | West Virginia | 54091 | 120 | 6 |
560215 | 560215 | 2020-09-22 | Taylor | West Virginia | 54091 | 119 | 6 |
556979 | 556979 | 2020-09-21 | Taylor | West Virginia | 54091 | 116 | 6 |
553742 | 553742 | 2020-09-20 | Taylor | West Virginia | 54091 | 117 | 6 |
550503 | 550503 | 2020-09-19 | Taylor | West Virginia | 54091 | 117 | 6 |
547264 | 547264 | 2020-09-18 | Taylor | West Virginia | 54091 | 117 | 6 |
544027 | 544027 | 2020-09-17 | Taylor | West Virginia | 54091 | 115 | 6 |
540791 | 540791 | 2020-09-16 | Taylor | West Virginia | 54091 | 115 | 6 |
537554 | 537554 | 2020-09-15 | Taylor | West Virginia | 54091 | 115 | 6 |
534318 | 534318 | 2020-09-14 | Taylor | West Virginia | 54091 | 114 | 6 |
531083 | 531083 | 2020-09-13 | Taylor | West Virginia | 54091 | 113 | 6 |
527846 | 527846 | 2020-09-12 | Taylor | West Virginia | 54091 | 113 | 6 |
524610 | 524610 | 2020-09-11 | Taylor | West Virginia | 54091 | 112 | 6 |
521374 | 521374 | 2020-09-10 | Taylor | West Virginia | 54091 | 112 | 6 |
518137 | 518137 | 2020-09-09 | Taylor | West Virginia | 54091 | 110 | 6 |
514902 | 514902 | 2020-09-08 | Taylor | West Virginia | 54091 | 110 | 6 |
511669 | 511669 | 2020-09-07 | Taylor | West Virginia | 54091 | 110 | 6 |
508436 | 508436 | 2020-09-06 | Taylor | West Virginia | 54091 | 110 | 6 |
505204 | 505204 | 2020-09-05 | Taylor | West Virginia | 54091 | 109 | 6 |
501970 | 501970 | 2020-09-04 | Taylor | West Virginia | 54091 | 108 | 6 |
498736 | 498736 | 2020-09-03 | Taylor | West Virginia | 54091 | 108 | 6 |
495503 | 495503 | 2020-09-02 | Taylor | West Virginia | 54091 | 106 | 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);