ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where county = "Osage", deaths = 3 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
782462 | 782462 | 2020-11-30 | Osage | Missouri | 29151 | 947 | 3 |
779216 | 779216 | 2020-11-29 | Osage | Missouri | 29151 | 936 | 3 |
775971 | 775971 | 2020-11-28 | Osage | Missouri | 29151 | 927 | 3 |
772726 | 772726 | 2020-11-27 | Osage | Missouri | 29151 | 924 | 3 |
769481 | 769481 | 2020-11-26 | Osage | Missouri | 29151 | 912 | 3 |
766235 | 766235 | 2020-11-25 | Osage | Missouri | 29151 | 904 | 3 |
762990 | 762990 | 2020-11-24 | Osage | Missouri | 29151 | 896 | 3 |
759745 | 759745 | 2020-11-23 | Osage | Missouri | 29151 | 876 | 3 |
756498 | 756498 | 2020-11-22 | Osage | Missouri | 29151 | 867 | 3 |
753252 | 753252 | 2020-11-21 | Osage | Missouri | 29151 | 848 | 3 |
750006 | 750006 | 2020-11-20 | Osage | Missouri | 29151 | 840 | 3 |
746760 | 746760 | 2020-11-19 | Osage | Missouri | 29151 | 821 | 3 |
743513 | 743513 | 2020-11-18 | Osage | Missouri | 29151 | 810 | 3 |
740266 | 740266 | 2020-11-17 | Osage | Missouri | 29151 | 803 | 3 |
737022 | 737022 | 2020-11-16 | Osage | Missouri | 29151 | 777 | 3 |
733776 | 733776 | 2020-11-15 | Osage | Missouri | 29151 | 764 | 3 |
730531 | 730531 | 2020-11-14 | Osage | Missouri | 29151 | 764 | 3 |
727288 | 727288 | 2020-11-13 | Osage | Missouri | 29151 | 734 | 3 |
724045 | 724045 | 2020-11-12 | Osage | Missouri | 29151 | 724 | 3 |
720802 | 720802 | 2020-11-11 | Osage | Missouri | 29151 | 693 | 3 |
717559 | 717559 | 2020-11-10 | Osage | Missouri | 29151 | 685 | 3 |
714315 | 714315 | 2020-11-09 | Osage | Missouri | 29151 | 672 | 3 |
711071 | 711071 | 2020-11-08 | Osage | Missouri | 29151 | 666 | 3 |
707827 | 707827 | 2020-11-07 | Osage | Missouri | 29151 | 650 | 3 |
704584 | 704584 | 2020-11-06 | Osage | Missouri | 29151 | 629 | 3 |
701342 | 701342 | 2020-11-05 | Osage | Missouri | 29151 | 615 | 3 |
698098 | 698098 | 2020-11-04 | Osage | Missouri | 29151 | 594 | 3 |
694855 | 694855 | 2020-11-03 | Osage | Missouri | 29151 | 582 | 3 |
691613 | 691613 | 2020-11-02 | Osage | Missouri | 29151 | 571 | 3 |
688368 | 688368 | 2020-11-01 | Osage | Missouri | 29151 | 559 | 3 |
685124 | 685124 | 2020-10-31 | Osage | Missouri | 29151 | 548 | 3 |
681881 | 681881 | 2020-10-30 | Osage | Missouri | 29151 | 537 | 3 |
678637 | 678637 | 2020-10-29 | Osage | Missouri | 29151 | 517 | 3 |
675395 | 675395 | 2020-10-28 | Osage | Missouri | 29151 | 494 | 3 |
672152 | 672152 | 2020-10-27 | Osage | Missouri | 29151 | 488 | 3 |
668910 | 668910 | 2020-10-26 | Osage | Missouri | 29151 | 484 | 3 |
665666 | 665666 | 2020-10-25 | Osage | Missouri | 29151 | 474 | 3 |
662421 | 662421 | 2020-10-24 | Osage | Missouri | 29151 | 462 | 3 |
659177 | 659177 | 2020-10-23 | Osage | Missouri | 29151 | 449 | 3 |
655932 | 655932 | 2020-10-22 | Osage | Missouri | 29151 | 438 | 3 |
652687 | 652687 | 2020-10-21 | Osage | Missouri | 29151 | 431 | 3 |
649442 | 649442 | 2020-10-20 | Osage | Missouri | 29151 | 413 | 3 |
646198 | 646198 | 2020-10-19 | Osage | Missouri | 29151 | 413 | 3 |
642952 | 642952 | 2020-10-18 | Osage | Missouri | 29151 | 397 | 3 |
639704 | 639704 | 2020-10-17 | Osage | Missouri | 29151 | 386 | 3 |
636458 | 636458 | 2020-10-16 | Osage | Missouri | 29151 | 351 | 3 |
633212 | 633212 | 2020-10-15 | Osage | Missouri | 29151 | 324 | 3 |
629967 | 629967 | 2020-10-14 | Osage | Missouri | 29151 | 293 | 3 |
626723 | 626723 | 2020-10-13 | Osage | Missouri | 29151 | 250 | 3 |
623481 | 623481 | 2020-10-12 | Osage | Missouri | 29151 | 250 | 3 |
620238 | 620238 | 2020-10-11 | Osage | Missouri | 29151 | 250 | 3 |
616996 | 616996 | 2020-10-10 | Osage | Missouri | 29151 | 250 | 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);