ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where county = "Barry", deaths = 6 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
610440 | 610440 | 2020-10-08 | Barry | Missouri | 29009 | 550 | 6 |
607198 | 607198 | 2020-10-07 | Barry | Missouri | 29009 | 546 | 6 |
603955 | 603955 | 2020-10-06 | Barry | Missouri | 29009 | 540 | 6 |
600713 | 600713 | 2020-10-05 | Barry | Missouri | 29009 | 535 | 6 |
597470 | 597470 | 2020-10-04 | Barry | Missouri | 29009 | 530 | 6 |
594229 | 594229 | 2020-10-03 | Barry | Missouri | 29009 | 527 | 6 |
590988 | 590988 | 2020-10-02 | Barry | Missouri | 29009 | 519 | 6 |
587747 | 587747 | 2020-10-01 | Barry | Missouri | 29009 | 508 | 6 |
584507 | 584507 | 2020-09-30 | Barry | Missouri | 29009 | 502 | 6 |
581266 | 581266 | 2020-09-29 | Barry | Missouri | 29009 | 494 | 6 |
578025 | 578025 | 2020-09-28 | Barry | Missouri | 29009 | 494 | 6 |
574784 | 574784 | 2020-09-27 | Barry | Missouri | 29009 | 490 | 6 |
571541 | 571541 | 2020-09-26 | Barry | Missouri | 29009 | 478 | 6 |
568299 | 568299 | 2020-09-25 | Barry | Missouri | 29009 | 473 | 6 |
565059 | 565059 | 2020-09-24 | Barry | Missouri | 29009 | 461 | 6 |
561819 | 561819 | 2020-09-23 | Barry | Missouri | 29009 | 460 | 6 |
558582 | 558582 | 2020-09-22 | Barry | Missouri | 29009 | 452 | 6 |
555345 | 555345 | 2020-09-21 | Barry | Missouri | 29009 | 433 | 6 |
552107 | 552107 | 2020-09-20 | Barry | Missouri | 29009 | 434 | 6 |
548868 | 548868 | 2020-09-19 | Barry | Missouri | 29009 | 431 | 6 |
545630 | 545630 | 2020-09-18 | Barry | Missouri | 29009 | 429 | 6 |
542393 | 542393 | 2020-09-17 | Barry | Missouri | 29009 | 420 | 6 |
539157 | 539157 | 2020-09-16 | Barry | Missouri | 29009 | 416 | 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);