ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where county = "Bryan" and deaths = 3 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 |
---|---|---|---|---|---|---|---|
523626 | 523626 | 2020-09-11 | Bryan | Oklahoma | 40013 | 696 | 3 |
520390 | 520390 | 2020-09-10 | Bryan | Oklahoma | 40013 | 685 | 3 |
517154 | 517154 | 2020-09-09 | Bryan | Oklahoma | 40013 | 678 | 3 |
513919 | 513919 | 2020-09-08 | Bryan | Oklahoma | 40013 | 669 | 3 |
510686 | 510686 | 2020-09-07 | Bryan | Oklahoma | 40013 | 656 | 3 |
507453 | 507453 | 2020-09-06 | Bryan | Oklahoma | 40013 | 650 | 3 |
504221 | 504221 | 2020-09-05 | Bryan | Oklahoma | 40013 | 649 | 3 |
500987 | 500987 | 2020-09-04 | Bryan | Oklahoma | 40013 | 644 | 3 |
497753 | 497753 | 2020-09-03 | Bryan | Oklahoma | 40013 | 624 | 3 |
494520 | 494520 | 2020-09-02 | Bryan | Oklahoma | 40013 | 613 | 3 |
491286 | 491286 | 2020-09-01 | Bryan | Oklahoma | 40013 | 609 | 3 |
488053 | 488053 | 2020-08-31 | Bryan | Oklahoma | 40013 | 599 | 3 |
484820 | 484820 | 2020-08-30 | Bryan | Oklahoma | 40013 | 595 | 3 |
481585 | 481585 | 2020-08-29 | Bryan | Oklahoma | 40013 | 592 | 3 |
478351 | 478351 | 2020-08-28 | Bryan | Oklahoma | 40013 | 587 | 3 |
475118 | 475118 | 2020-08-27 | Bryan | Oklahoma | 40013 | 572 | 3 |
471884 | 471884 | 2020-08-26 | Bryan | Oklahoma | 40013 | 563 | 3 |
468652 | 468652 | 2020-08-25 | Bryan | Oklahoma | 40013 | 559 | 3 |
465424 | 465424 | 2020-08-24 | Bryan | Oklahoma | 40013 | 551 | 3 |
462195 | 462195 | 2020-08-23 | Bryan | Oklahoma | 40013 | 545 | 3 |
458967 | 458967 | 2020-08-22 | Bryan | Oklahoma | 40013 | 543 | 3 |
455739 | 455739 | 2020-08-21 | Bryan | Oklahoma | 40013 | 538 | 3 |
452511 | 452511 | 2020-08-20 | Bryan | Oklahoma | 40013 | 532 | 3 |
449283 | 449283 | 2020-08-19 | Bryan | Oklahoma | 40013 | 522 | 3 |
109982 | 109982 | 2020-05-03 | Bryan | Georgia | 13029 | 54 | 3 |
107113 | 107113 | 2020-05-02 | Bryan | Georgia | 13029 | 54 | 3 |
104248 | 104248 | 2020-05-01 | Bryan | Georgia | 13029 | 54 | 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);