ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 8, fips = 29003 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 |
---|---|---|---|---|---|---|---|
753176 | 753176 | 2020-11-21 | Andrew | Missouri | 29003 | 702 | 8 |
749930 | 749930 | 2020-11-20 | Andrew | Missouri | 29003 | 681 | 8 |
746684 | 746684 | 2020-11-19 | Andrew | Missouri | 29003 | 668 | 8 |
743437 | 743437 | 2020-11-18 | Andrew | Missouri | 29003 | 658 | 8 |
740190 | 740190 | 2020-11-17 | Andrew | Missouri | 29003 | 644 | 8 |
736946 | 736946 | 2020-11-16 | Andrew | Missouri | 29003 | 623 | 8 |
733700 | 733700 | 2020-11-15 | Andrew | Missouri | 29003 | 617 | 8 |
730455 | 730455 | 2020-11-14 | Andrew | Missouri | 29003 | 617 | 8 |
727212 | 727212 | 2020-11-13 | Andrew | Missouri | 29003 | 579 | 8 |
723969 | 723969 | 2020-11-12 | Andrew | Missouri | 29003 | 569 | 8 |
720726 | 720726 | 2020-11-11 | Andrew | Missouri | 29003 | 557 | 8 |
717483 | 717483 | 2020-11-10 | Andrew | Missouri | 29003 | 552 | 8 |
714239 | 714239 | 2020-11-09 | Andrew | Missouri | 29003 | 537 | 8 |
710995 | 710995 | 2020-11-08 | Andrew | Missouri | 29003 | 526 | 8 |
707751 | 707751 | 2020-11-07 | Andrew | Missouri | 29003 | 518 | 8 |
704508 | 704508 | 2020-11-06 | Andrew | Missouri | 29003 | 512 | 8 |
701266 | 701266 | 2020-11-05 | Andrew | Missouri | 29003 | 501 | 8 |
698022 | 698022 | 2020-11-04 | Andrew | Missouri | 29003 | 492 | 8 |
694779 | 694779 | 2020-11-03 | Andrew | Missouri | 29003 | 489 | 8 |
691537 | 691537 | 2020-11-02 | Andrew | Missouri | 29003 | 482 | 8 |
688292 | 688292 | 2020-11-01 | Andrew | Missouri | 29003 | 474 | 8 |
685048 | 685048 | 2020-10-31 | Andrew | Missouri | 29003 | 468 | 8 |
681805 | 681805 | 2020-10-30 | Andrew | Missouri | 29003 | 462 | 8 |
678561 | 678561 | 2020-10-29 | Andrew | Missouri | 29003 | 458 | 8 |
675319 | 675319 | 2020-10-28 | Andrew | Missouri | 29003 | 450 | 8 |
672076 | 672076 | 2020-10-27 | Andrew | Missouri | 29003 | 443 | 8 |
668834 | 668834 | 2020-10-26 | Andrew | Missouri | 29003 | 441 | 8 |
665590 | 665590 | 2020-10-25 | Andrew | Missouri | 29003 | 435 | 8 |
662345 | 662345 | 2020-10-24 | Andrew | Missouri | 29003 | 428 | 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);