ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where county = "Randolph", deaths = 8 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
648639 | 648639 | 2020-10-20 | Randolph | Indiana | 18135 | 378 | 8 |
645394 | 645394 | 2020-10-19 | Randolph | Indiana | 18135 | 376 | 8 |
642147 | 642147 | 2020-10-18 | Randolph | Indiana | 18135 | 370 | 8 |
638900 | 638900 | 2020-10-17 | Randolph | Indiana | 18135 | 362 | 8 |
635654 | 635654 | 2020-10-16 | Randolph | Indiana | 18135 | 351 | 8 |
632408 | 632408 | 2020-10-15 | Randolph | Indiana | 18135 | 337 | 8 |
629164 | 629164 | 2020-10-14 | Randolph | Indiana | 18135 | 330 | 8 |
625921 | 625921 | 2020-10-13 | Randolph | Indiana | 18135 | 327 | 8 |
622679 | 622679 | 2020-10-12 | Randolph | Indiana | 18135 | 321 | 8 |
619435 | 619435 | 2020-10-11 | Randolph | Indiana | 18135 | 320 | 8 |
616193 | 616193 | 2020-10-10 | Randolph | Indiana | 18135 | 313 | 8 |
612952 | 612952 | 2020-10-09 | Randolph | Indiana | 18135 | 304 | 8 |
609710 | 609710 | 2020-10-08 | Randolph | Indiana | 18135 | 301 | 8 |
606467 | 606467 | 2020-10-07 | Randolph | Indiana | 18135 | 300 | 8 |
603225 | 603225 | 2020-10-06 | Randolph | Indiana | 18135 | 293 | 8 |
599982 | 599982 | 2020-10-05 | Randolph | Indiana | 18135 | 285 | 8 |
596740 | 596740 | 2020-10-04 | Randolph | Indiana | 18135 | 285 | 8 |
593498 | 593498 | 2020-10-03 | Randolph | Indiana | 18135 | 282 | 8 |
590257 | 590257 | 2020-10-02 | Randolph | Indiana | 18135 | 276 | 8 |
587016 | 587016 | 2020-10-01 | Randolph | Indiana | 18135 | 268 | 8 |
583776 | 583776 | 2020-09-30 | Randolph | Indiana | 18135 | 267 | 8 |
580537 | 580537 | 2020-09-29 | Randolph | Indiana | 18135 | 260 | 8 |
577296 | 577296 | 2020-09-28 | Randolph | Indiana | 18135 | 260 | 8 |
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);