ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where "date" is on date 2020-09-27 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
574780 | 574780 | 2020-09-27 | Adair | Missouri | 29001 | 350 | 0 |
574781 | 574781 | 2020-09-27 | Andrew | Missouri | 29003 | 258 | 2 |
574782 | 574782 | 2020-09-27 | Atchison | Missouri | 29005 | 53 | 0 |
574783 | 574783 | 2020-09-27 | Audrain | Missouri | 29007 | 431 | 4 |
574784 | 574784 | 2020-09-27 | Barry | Missouri | 29009 | 490 | 6 |
574785 | 574785 | 2020-09-27 | Barton | Missouri | 29011 | 185 | 0 |
574786 | 574786 | 2020-09-27 | Bates | Missouri | 29013 | 123 | 2 |
574787 | 574787 | 2020-09-27 | Benton | Missouri | 29015 | 333 | 3 |
574788 | 574788 | 2020-09-27 | Bollinger | Missouri | 29017 | 351 | 1 |
574789 | 574789 | 2020-09-27 | Boone | Missouri | 29019 | 4686 | 10 |
574790 | 574790 | 2020-09-27 | Buchanan | Missouri | 29021 | 2295 | 21 |
574791 | 574791 | 2020-09-27 | Butler | Missouri | 29023 | 650 | 7 |
574792 | 574792 | 2020-09-27 | Caldwell | Missouri | 29025 | 95 | 1 |
574793 | 574793 | 2020-09-27 | Callaway | Missouri | 29027 | 662 | 3 |
574794 | 574794 | 2020-09-27 | Camden | Missouri | 29029 | 1008 | 11 |
574795 | 574795 | 2020-09-27 | Cape Girardeau | Missouri | 29031 | 1867 | 26 |
574796 | 574796 | 2020-09-27 | Carroll | Missouri | 29033 | 132 | 2 |
574797 | 574797 | 2020-09-27 | Carter | Missouri | 29035 | 109 | 1 |
574798 | 574798 | 2020-09-27 | Cass | Missouri | 29037 | 1571 | 24 |
574799 | 574799 | 2020-09-27 | Cedar | Missouri | 29039 | 113 | 0 |
574800 | 574800 | 2020-09-27 | Chariton | Missouri | 29041 | 47 | 0 |
574801 | 574801 | 2020-09-27 | Christian | Missouri | 29043 | 1490 | 6 |
574802 | 574802 | 2020-09-27 | Clark | Missouri | 29045 | 65 | 0 |
574803 | 574803 | 2020-09-27 | Clay | Missouri | 29047 | 1809 | 41 |
574804 | 574804 | 2020-09-27 | Clinton | Missouri | 29049 | 241 | 0 |
574805 | 574805 | 2020-09-27 | Cole | Missouri | 29051 | 1559 | 14 |
574806 | 574806 | 2020-09-27 | Cooper | Missouri | 29053 | 431 | 2 |
574807 | 574807 | 2020-09-27 | Crawford | Missouri | 29055 | 402 | 4 |
574808 | 574808 | 2020-09-27 | Dade | Missouri | 29057 | 68 | 0 |
574809 | 574809 | 2020-09-27 | Dallas | Missouri | 29059 | 190 | 1 |
574810 | 574810 | 2020-09-27 | Daviess | Missouri | 29061 | 117 | 1 |
574811 | 574811 | 2020-09-27 | DeKalb | Missouri | 29063 | 134 | 2 |
574812 | 574812 | 2020-09-27 | Dent | Missouri | 29065 | 149 | 2 |
574813 | 574813 | 2020-09-27 | Douglas | Missouri | 29067 | 205 | 3 |
574814 | 574814 | 2020-09-27 | Dunklin | Missouri | 29069 | 789 | 8 |
574815 | 574815 | 2020-09-27 | Franklin | Missouri | 29071 | 1736 | 29 |
574816 | 574816 | 2020-09-27 | Gasconade | Missouri | 29073 | 166 | 20 |
574817 | 574817 | 2020-09-27 | Gentry | Missouri | 29075 | 122 | 9 |
574818 | 574818 | 2020-09-27 | Greene | Missouri | 29077 | 6721 | 71 |
574819 | 574819 | 2020-09-27 | Grundy | Missouri | 29079 | 193 | 4 |
574820 | 574820 | 2020-09-27 | Harrison | Missouri | 29081 | 109 | 1 |
574821 | 574821 | 2020-09-27 | Henry | Missouri | 29083 | 203 | 5 |
574822 | 574822 | 2020-09-27 | Hickory | Missouri | 29085 | 108 | 3 |
574823 | 574823 | 2020-09-27 | Holt | Missouri | 29087 | 79 | 1 |
574824 | 574824 | 2020-09-27 | Howard | Missouri | 29089 | 175 | 2 |
574825 | 574825 | 2020-09-27 | Howell | Missouri | 29091 | 622 | 3 |
574826 | 574826 | 2020-09-27 | Iron | Missouri | 29093 | 56 | 0 |
574827 | 574827 | 2020-09-27 | Jackson | Missouri | 29095 | 7512 | 99 |
574828 | 574828 | 2020-09-27 | Jasper | Missouri | 29097 | 2345 | 29 |
574829 | 574829 | 2020-09-27 | Jefferson | Missouri | 29099 | 4302 | 61 |
574830 | 574830 | 2020-09-27 | Johnson | Missouri | 29101 | 1117 | 4 |
574831 | 574831 | 2020-09-27 | Joplin | Missouri | 1466 | 24 | |
574832 | 574832 | 2020-09-27 | Kansas City | Missouri | 11147 | 125 | |
574833 | 574833 | 2020-09-27 | Knox | Missouri | 29103 | 50 | 1 |
574834 | 574834 | 2020-09-27 | Laclede | Missouri | 29105 | 641 | 4 |
574835 | 574835 | 2020-09-27 | Lafayette | Missouri | 29107 | 529 | 2 |
574836 | 574836 | 2020-09-27 | Lawrence | Missouri | 29109 | 624 | 4 |
574837 | 574837 | 2020-09-27 | Lewis | Missouri | 29111 | 91 | 2 |
574838 | 574838 | 2020-09-27 | Lincoln | Missouri | 29113 | 776 | 3 |
574839 | 574839 | 2020-09-27 | Linn | Missouri | 29115 | 83 | 1 |
574840 | 574840 | 2020-09-27 | Livingston | Missouri | 29117 | 406 | 1 |
574841 | 574841 | 2020-09-27 | Macon | Missouri | 29121 | 150 | 0 |
574842 | 574842 | 2020-09-27 | Madison | Missouri | 29123 | 306 | 1 |
574843 | 574843 | 2020-09-27 | Maries | Missouri | 29125 | 82 | 0 |
574844 | 574844 | 2020-09-27 | Marion | Missouri | 29127 | 663 | 14 |
574845 | 574845 | 2020-09-27 | McDonald | Missouri | 29119 | 1147 | 12 |
574846 | 574846 | 2020-09-27 | Mercer | Missouri | 29129 | 28 | 0 |
574847 | 574847 | 2020-09-27 | Miller | Missouri | 29131 | 508 | 1 |
574848 | 574848 | 2020-09-27 | Mississippi | Missouri | 29133 | 300 | 3 |
574849 | 574849 | 2020-09-27 | Moniteau | Missouri | 29135 | 321 | 4 |
574850 | 574850 | 2020-09-27 | Monroe | Missouri | 29137 | 90 | 1 |
574851 | 574851 | 2020-09-27 | Montgomery | Missouri | 29139 | 84 | 1 |
574852 | 574852 | 2020-09-27 | Morgan | Missouri | 29141 | 359 | 1 |
574853 | 574853 | 2020-09-27 | New Madrid | Missouri | 29143 | 534 | 16 |
574854 | 574854 | 2020-09-27 | Newton | Missouri | 29145 | 1481 | 15 |
574855 | 574855 | 2020-09-27 | Nodaway | Missouri | 29147 | 647 | 7 |
574856 | 574856 | 2020-09-27 | Oregon | Missouri | 29149 | 123 | 0 |
574857 | 574857 | 2020-09-27 | Osage | Missouri | 29151 | 156 | 2 |
574858 | 574858 | 2020-09-27 | Ozark | Missouri | 29153 | 125 | 0 |
574859 | 574859 | 2020-09-27 | Pemiscot | Missouri | 29155 | 531 | 10 |
574860 | 574860 | 2020-09-27 | Perry | Missouri | 29157 | 625 | 7 |
574861 | 574861 | 2020-09-27 | Pettis | Missouri | 29159 | 1149 | 18 |
574862 | 574862 | 2020-09-27 | Phelps | Missouri | 29161 | 488 | 8 |
574863 | 574863 | 2020-09-27 | Pike | Missouri | 29163 | 239 | 4 |
574864 | 574864 | 2020-09-27 | Platte | Missouri | 29165 | 728 | 12 |
574865 | 574865 | 2020-09-27 | Polk | Missouri | 29167 | 688 | 4 |
574866 | 574866 | 2020-09-27 | Pulaski | Missouri | 29169 | 659 | 5 |
574867 | 574867 | 2020-09-27 | Putnam | Missouri | 29171 | 33 | 1 |
574868 | 574868 | 2020-09-27 | Ralls | Missouri | 29173 | 150 | 0 |
574869 | 574869 | 2020-09-27 | Randolph | Missouri | 29175 | 258 | 2 |
574870 | 574870 | 2020-09-27 | Ray | Missouri | 29177 | 166 | 0 |
574871 | 574871 | 2020-09-27 | Reynolds | Missouri | 29179 | 39 | 0 |
574872 | 574872 | 2020-09-27 | Ripley | Missouri | 29181 | 165 | 0 |
574873 | 574873 | 2020-09-27 | Saline | Missouri | 29195 | 726 | 9 |
574874 | 574874 | 2020-09-27 | Schuyler | Missouri | 29197 | 25 | 0 |
574875 | 574875 | 2020-09-27 | Scotland | Missouri | 29199 | 31 | 1 |
574876 | 574876 | 2020-09-27 | Scott | Missouri | 29201 | 878 | 17 |
574877 | 574877 | 2020-09-27 | Shannon | Missouri | 29203 | 109 | 1 |
574878 | 574878 | 2020-09-27 | Shelby | Missouri | 29205 | 67 | 1 |
574879 | 574879 | 2020-09-27 | St. Charles | Missouri | 29183 | 7733 | 128 |
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);