ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2020-05-20 and state = "Missouri" 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 |
---|---|---|---|---|---|---|---|
161701 | 161701 | 2020-05-20 | Adair | Missouri | 29001 | 34 | 0 |
161702 | 161702 | 2020-05-20 | Andrew | Missouri | 29003 | 20 | 0 |
161703 | 161703 | 2020-05-20 | Atchison | Missouri | 29005 | 3 | 0 |
161704 | 161704 | 2020-05-20 | Audrain | Missouri | 29007 | 18 | 0 |
161705 | 161705 | 2020-05-20 | Barry | Missouri | 29009 | 6 | 0 |
161706 | 161706 | 2020-05-20 | Bates | Missouri | 29013 | 7 | 1 |
161707 | 161707 | 2020-05-20 | Benton | Missouri | 29015 | 9 | 0 |
161708 | 161708 | 2020-05-20 | Bollinger | Missouri | 29017 | 4 | 0 |
161709 | 161709 | 2020-05-20 | Boone | Missouri | 29019 | 106 | 1 |
161710 | 161710 | 2020-05-20 | Buchanan | Missouri | 29021 | 562 | 2 |
161711 | 161711 | 2020-05-20 | Butler | Missouri | 29023 | 34 | 0 |
161712 | 161712 | 2020-05-20 | Caldwell | Missouri | 29025 | 5 | 0 |
161713 | 161713 | 2020-05-20 | Callaway | Missouri | 29027 | 23 | 1 |
161714 | 161714 | 2020-05-20 | Camden | Missouri | 29029 | 36 | 1 |
161715 | 161715 | 2020-05-20 | Cape Girardeau | Missouri | 29031 | 55 | 2 |
161716 | 161716 | 2020-05-20 | Carroll | Missouri | 29033 | 7 | 0 |
161717 | 161717 | 2020-05-20 | Carter | Missouri | 29035 | 4 | 1 |
161718 | 161718 | 2020-05-20 | Cass | Missouri | 29037 | 77 | 8 |
161719 | 161719 | 2020-05-20 | Cedar | Missouri | 29039 | 9 | 0 |
161720 | 161720 | 2020-05-20 | Chariton | Missouri | 29041 | 6 | 0 |
161721 | 161721 | 2020-05-20 | Christian | Missouri | 29043 | 21 | 0 |
161722 | 161722 | 2020-05-20 | Clark | Missouri | 29045 | 1 | 0 |
161723 | 161723 | 2020-05-20 | Clay | Missouri | 29047 | 125 | 1 |
161724 | 161724 | 2020-05-20 | Clinton | Missouri | 29049 | 18 | 0 |
161725 | 161725 | 2020-05-20 | Cole | Missouri | 29051 | 55 | 1 |
161726 | 161726 | 2020-05-20 | Cooper | Missouri | 29053 | 9 | 0 |
161727 | 161727 | 2020-05-20 | Crawford | Missouri | 29055 | 8 | 0 |
161728 | 161728 | 2020-05-20 | Dallas | Missouri | 29059 | 2 | 0 |
161729 | 161729 | 2020-05-20 | Daviess | Missouri | 29061 | 3 | 0 |
161730 | 161730 | 2020-05-20 | DeKalb | Missouri | 29063 | 5 | 0 |
161731 | 161731 | 2020-05-20 | Dent | Missouri | 29065 | 1 | 0 |
161732 | 161732 | 2020-05-20 | Dunklin | Missouri | 29069 | 26 | 2 |
161733 | 161733 | 2020-05-20 | Franklin | Missouri | 29071 | 136 | 15 |
161734 | 161734 | 2020-05-20 | Gasconade | Missouri | 29073 | 2 | 0 |
161735 | 161735 | 2020-05-20 | Gentry | Missouri | 29075 | 4 | 0 |
161736 | 161736 | 2020-05-20 | Greene | Missouri | 29077 | 111 | 8 |
161737 | 161737 | 2020-05-20 | Harrison | Missouri | 29081 | 8 | 0 |
161738 | 161738 | 2020-05-20 | Henry | Missouri | 29083 | 9 | 1 |
161739 | 161739 | 2020-05-20 | Holt | Missouri | 29087 | 1 | 0 |
161740 | 161740 | 2020-05-20 | Howard | Missouri | 29089 | 3 | 0 |
161741 | 161741 | 2020-05-20 | Howell | Missouri | 29091 | 5 | 0 |
161742 | 161742 | 2020-05-20 | Iron | Missouri | 29093 | 2 | 0 |
161743 | 161743 | 2020-05-20 | Jackson | Missouri | 29095 | 465 | 16 |
161744 | 161744 | 2020-05-20 | Jasper | Missouri | 29097 | 27 | 0 |
161745 | 161745 | 2020-05-20 | Jefferson | Missouri | 29099 | 331 | 14 |
161746 | 161746 | 2020-05-20 | Johnson | Missouri | 29101 | 72 | 0 |
161747 | 161747 | 2020-05-20 | Kansas City | Missouri | 924 | 23 | |
161748 | 161748 | 2020-05-20 | Laclede | Missouri | 29105 | 3 | 0 |
161749 | 161749 | 2020-05-20 | Lafayette | Missouri | 29107 | 69 | 1 |
161750 | 161750 | 2020-05-20 | Lawrence | Missouri | 29109 | 7 | 0 |
161751 | 161751 | 2020-05-20 | Lewis | Missouri | 29111 | 7 | 1 |
161752 | 161752 | 2020-05-20 | Lincoln | Missouri | 29113 | 78 | 1 |
161753 | 161753 | 2020-05-20 | Linn | Missouri | 29115 | 5 | 1 |
161754 | 161754 | 2020-05-20 | Livingston | Missouri | 29117 | 3 | 0 |
161755 | 161755 | 2020-05-20 | Macon | Missouri | 29121 | 2 | 0 |
161756 | 161756 | 2020-05-20 | Madison | Missouri | 29123 | 3 | 0 |
161757 | 161757 | 2020-05-20 | Maries | Missouri | 29125 | 2 | 0 |
161758 | 161758 | 2020-05-20 | Marion | Missouri | 29127 | 5 | 0 |
161759 | 161759 | 2020-05-20 | McDonald | Missouri | 29119 | 14 | 0 |
161760 | 161760 | 2020-05-20 | Miller | Missouri | 29131 | 4 | 0 |
161761 | 161761 | 2020-05-20 | Mississippi | Missouri | 29133 | 49 | 0 |
161762 | 161762 | 2020-05-20 | Moniteau | Missouri | 29135 | 44 | 1 |
161763 | 161763 | 2020-05-20 | Montgomery | Missouri | 29139 | 7 | 0 |
161764 | 161764 | 2020-05-20 | Morgan | Missouri | 29141 | 7 | 0 |
161765 | 161765 | 2020-05-20 | New Madrid | Missouri | 29143 | 14 | 1 |
161766 | 161766 | 2020-05-20 | Newton | Missouri | 29145 | 18 | 1 |
161767 | 161767 | 2020-05-20 | Nodaway | Missouri | 29147 | 8 | 0 |
161768 | 161768 | 2020-05-20 | Oregon | Missouri | 29149 | 2 | 0 |
161769 | 161769 | 2020-05-20 | Osage | Missouri | 29151 | 5 | 0 |
161770 | 161770 | 2020-05-20 | Pemiscot | Missouri | 29155 | 70 | 3 |
161771 | 161771 | 2020-05-20 | Perry | Missouri | 29157 | 47 | 0 |
161772 | 161772 | 2020-05-20 | Pettis | Missouri | 29159 | 69 | 1 |
161773 | 161773 | 2020-05-20 | Phelps | Missouri | 29161 | 3 | 0 |
161774 | 161774 | 2020-05-20 | Pike | Missouri | 29163 | 14 | 1 |
161775 | 161775 | 2020-05-20 | Platte | Missouri | 29165 | 64 | 0 |
161776 | 161776 | 2020-05-20 | Polk | Missouri | 29167 | 2 | 0 |
161777 | 161777 | 2020-05-20 | Pulaski | Missouri | 29169 | 36 | 1 |
161778 | 161778 | 2020-05-20 | Ralls | Missouri | 29173 | 2 | 0 |
161779 | 161779 | 2020-05-20 | Randolph | Missouri | 29175 | 8 | 0 |
161780 | 161780 | 2020-05-20 | Ray | Missouri | 29177 | 14 | 0 |
161781 | 161781 | 2020-05-20 | Reynolds | Missouri | 29179 | 2 | 0 |
161782 | 161782 | 2020-05-20 | Ripley | Missouri | 29181 | 7 | 0 |
161783 | 161783 | 2020-05-20 | Saline | Missouri | 29195 | 256 | 0 |
161784 | 161784 | 2020-05-20 | Schuyler | Missouri | 29197 | 1 | 0 |
161785 | 161785 | 2020-05-20 | Scotland | Missouri | 29199 | 4 | 0 |
161786 | 161786 | 2020-05-20 | Scott | Missouri | 29201 | 88 | 8 |
161787 | 161787 | 2020-05-20 | Shelby | Missouri | 29205 | 1 | 0 |
161788 | 161788 | 2020-05-20 | St. Charles | Missouri | 29183 | 715 | 55 |
161789 | 161789 | 2020-05-20 | St. Clair | Missouri | 29185 | 2 | 0 |
161790 | 161790 | 2020-05-20 | St. Francois | Missouri | 29187 | 30 | 2 |
161791 | 161791 | 2020-05-20 | St. Louis | Missouri | 29189 | 4410 | 352 |
161792 | 161792 | 2020-05-20 | St. Louis city | Missouri | 29510 | 1717 | 109 |
161793 | 161793 | 2020-05-20 | Ste. Genevieve | Missouri | 29186 | 8 | 1 |
161794 | 161794 | 2020-05-20 | Stoddard | Missouri | 29207 | 61 | 2 |
161795 | 161795 | 2020-05-20 | Stone | Missouri | 29209 | 4 | 0 |
161796 | 161796 | 2020-05-20 | Sullivan | Missouri | 29211 | 37 | 0 |
161797 | 161797 | 2020-05-20 | Taney | Missouri | 29213 | 12 | 2 |
161798 | 161798 | 2020-05-20 | Vernon | Missouri | 29217 | 6 | 0 |
161799 | 161799 | 2020-05-20 | Warren | Missouri | 29219 | 25 | 0 |
161800 | 161800 | 2020-05-20 | Washington | Missouri | 29221 | 9 | 1 |
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);