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 2021-01-28 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 |
---|---|---|---|---|---|---|---|
973858 | 973858 | 2021-01-28 | Adair | Missouri | 29001 | 2108 | 15 |
973859 | 973859 | 2021-01-28 | Andrew | Missouri | 29003 | 1242 | 16 |
973860 | 973860 | 2021-01-28 | Atchison | Missouri | 29005 | 288 | 6 |
973861 | 973861 | 2021-01-28 | Audrain | Missouri | 29007 | 2013 | 50 |
973862 | 973862 | 2021-01-28 | Barry | Missouri | 29009 | 2094 | 41 |
973863 | 973863 | 2021-01-28 | Barton | Missouri | 29011 | 907 | 9 |
973864 | 973864 | 2021-01-28 | Bates | Missouri | 29013 | 1020 | 16 |
973865 | 973865 | 2021-01-28 | Benton | Missouri | 29015 | 1379 | 20 |
973866 | 973866 | 2021-01-28 | Bollinger | Missouri | 29017 | 1024 | 12 |
973867 | 973867 | 2021-01-28 | Boone | Missouri | 29019 | 16475 | 69 |
973868 | 973868 | 2021-01-28 | Buchanan | Missouri | 29021 | 9653 | 153 |
973869 | 973869 | 2021-01-28 | Butler | Missouri | 29023 | 3203 | 24 |
973870 | 973870 | 2021-01-28 | Caldwell | Missouri | 29025 | 615 | 8 |
973871 | 973871 | 2021-01-28 | Callaway | Missouri | 29027 | 4237 | 34 |
973872 | 973872 | 2021-01-28 | Camden | Missouri | 29029 | 3592 | 74 |
973873 | 973873 | 2021-01-28 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
973874 | 973874 | 2021-01-28 | Carroll | Missouri | 29033 | 781 | 18 |
973875 | 973875 | 2021-01-28 | Carter | Missouri | 29035 | 409 | 8 |
973876 | 973876 | 2021-01-28 | Cass | Missouri | 29037 | 6791 | 69 |
973877 | 973877 | 2021-01-28 | Cedar | Missouri | 29039 | 636 | 9 |
973878 | 973878 | 2021-01-28 | Chariton | Missouri | 29041 | 402 | 3 |
973879 | 973879 | 2021-01-28 | Christian | Missouri | 29043 | 7739 | 63 |
973880 | 973880 | 2021-01-28 | Clark | Missouri | 29045 | 437 | 6 |
973881 | 973881 | 2021-01-28 | Clay | Missouri | 29047 | 8721 | 124 |
973882 | 973882 | 2021-01-28 | Clinton | Missouri | 29049 | 1460 | 60 |
973883 | 973883 | 2021-01-28 | Cole | Missouri | 29051 | 8302 | 104 |
973884 | 973884 | 2021-01-28 | Cooper | Missouri | 29053 | 1631 | 21 |
973885 | 973885 | 2021-01-28 | Crawford | Missouri | 29055 | 1972 | 24 |
973886 | 973886 | 2021-01-28 | Dade | Missouri | 29057 | 682 | 30 |
973887 | 973887 | 2021-01-28 | Dallas | Missouri | 29059 | 787 | 20 |
973888 | 973888 | 2021-01-28 | Daviess | Missouri | 29061 | 556 | 10 |
973889 | 973889 | 2021-01-28 | DeKalb | Missouri | 29063 | 889 | 24 |
973890 | 973890 | 2021-01-28 | Dent | Missouri | 29065 | 793 | 11 |
973891 | 973891 | 2021-01-28 | Douglas | Missouri | 29067 | 740 | 23 |
973892 | 973892 | 2021-01-28 | Dunklin | Missouri | 29069 | 2335 | 16 |
973893 | 973893 | 2021-01-28 | Franklin | Missouri | 29071 | 7967 | 131 |
973894 | 973894 | 2021-01-28 | Gasconade | Missouri | 29073 | 834 | 33 |
973895 | 973895 | 2021-01-28 | Gentry | Missouri | 29075 | 711 | 19 |
973896 | 973896 | 2021-01-28 | Greene | Missouri | 29077 | 25862 | 381 |
973897 | 973897 | 2021-01-28 | Grundy | Missouri | 29079 | 792 | 30 |
973898 | 973898 | 2021-01-28 | Harrison | Missouri | 29081 | 784 | 11 |
973899 | 973899 | 2021-01-28 | Henry | Missouri | 29083 | 1641 | 28 |
973900 | 973900 | 2021-01-28 | Hickory | Missouri | 29085 | 456 | 10 |
973901 | 973901 | 2021-01-28 | Holt | Missouri | 29087 | 355 | 10 |
973902 | 973902 | 2021-01-28 | Howard | Missouri | 29089 | 689 | 4 |
973903 | 973903 | 2021-01-28 | Howell | Missouri | 29091 | 2724 | 41 |
973904 | 973904 | 2021-01-28 | Iron | Missouri | 29093 | 458 | 1 |
973905 | 973905 | 2021-01-28 | Jackson | Missouri | 29095 | 28001 | 307 |
973906 | 973906 | 2021-01-28 | Jasper | Missouri | 29097 | 6983 | 101 |
973907 | 973907 | 2021-01-28 | Jefferson | Missouri | 29099 | 20415 | 169 |
973908 | 973908 | 2021-01-28 | Johnson | Missouri | 29101 | 3640 | 35 |
973909 | 973909 | 2021-01-28 | Joplin | Missouri | 4535 | 92 | |
973910 | 973910 | 2021-01-28 | Kansas City | Missouri | 35059 | 439 | |
973911 | 973911 | 2021-01-28 | Knox | Missouri | 29103 | 171 | 2 |
973912 | 973912 | 2021-01-28 | Laclede | Missouri | 29105 | 2807 | 57 |
973913 | 973913 | 2021-01-28 | Lafayette | Missouri | 29107 | 2376 | 46 |
973914 | 973914 | 2021-01-28 | Lawrence | Missouri | 29109 | 2624 | 61 |
973915 | 973915 | 2021-01-28 | Lewis | Missouri | 29111 | 616 | 3 |
973916 | 973916 | 2021-01-28 | Lincoln | Missouri | 29113 | 4052 | 24 |
973917 | 973917 | 2021-01-28 | Linn | Missouri | 29115 | 519 | 11 |
973918 | 973918 | 2021-01-28 | Livingston | Missouri | 29117 | 1254 | 32 |
973919 | 973919 | 2021-01-28 | Macon | Missouri | 29121 | 1151 | 10 |
973920 | 973920 | 2021-01-28 | Madison | Missouri | 29123 | 1323 | 13 |
973921 | 973921 | 2021-01-28 | Maries | Missouri | 29125 | 515 | 7 |
973922 | 973922 | 2021-01-28 | Marion | Missouri | 29127 | 2564 | 36 |
973923 | 973923 | 2021-01-28 | McDonald | Missouri | 29119 | 2362 | 30 |
973924 | 973924 | 2021-01-28 | Mercer | Missouri | 29129 | 161 | 2 |
973925 | 973925 | 2021-01-28 | Miller | Missouri | 29131 | 2272 | 45 |
973926 | 973926 | 2021-01-28 | Mississippi | Missouri | 29133 | 1210 | 21 |
973927 | 973927 | 2021-01-28 | Moniteau | Missouri | 29135 | 1646 | 27 |
973928 | 973928 | 2021-01-28 | Monroe | Missouri | 29137 | 577 | 7 |
973929 | 973929 | 2021-01-28 | Montgomery | Missouri | 29139 | 549 | 10 |
973930 | 973930 | 2021-01-28 | Morgan | Missouri | 29141 | 1584 | 34 |
973931 | 973931 | 2021-01-28 | New Madrid | Missouri | 29143 | 1732 | 41 |
973932 | 973932 | 2021-01-28 | Newton | Missouri | 29145 | 3900 | 60 |
973933 | 973933 | 2021-01-28 | Nodaway | Missouri | 29147 | 2501 | 22 |
973934 | 973934 | 2021-01-28 | Oregon | Missouri | 29149 | 659 | 3 |
973935 | 973935 | 2021-01-28 | Osage | Missouri | 29151 | 1346 | 10 |
973936 | 973936 | 2021-01-28 | Ozark | Missouri | 29153 | 515 | 10 |
973937 | 973937 | 2021-01-28 | Pemiscot | Missouri | 29155 | 1378 | 23 |
973938 | 973938 | 2021-01-28 | Perry | Missouri | 29157 | 1990 | 22 |
973939 | 973939 | 2021-01-28 | Pettis | Missouri | 29159 | 4732 | 69 |
973940 | 973940 | 2021-01-28 | Phelps | Missouri | 29161 | 2872 | 107 |
973941 | 973941 | 2021-01-28 | Pike | Missouri | 29163 | 1439 | 17 |
973942 | 973942 | 2021-01-28 | Platte | Missouri | 29165 | 2877 | 36 |
973943 | 973943 | 2021-01-28 | Polk | Missouri | 29167 | 3084 | 36 |
973944 | 973944 | 2021-01-28 | Pulaski | Missouri | 29169 | 2896 | 34 |
973945 | 973945 | 2021-01-28 | Putnam | Missouri | 29171 | 216 | 2 |
973946 | 973946 | 2021-01-28 | Ralls | Missouri | 29173 | 732 | 10 |
973947 | 973947 | 2021-01-28 | Randolph | Missouri | 29175 | 1782 | 24 |
973948 | 973948 | 2021-01-28 | Ray | Missouri | 29177 | 1397 | 17 |
973949 | 973949 | 2021-01-28 | Reynolds | Missouri | 29179 | 458 | 4 |
973950 | 973950 | 2021-01-28 | Ripley | Missouri | 29181 | 777 | 10 |
973951 | 973951 | 2021-01-28 | Saline | Missouri | 29195 | 2319 | 30 |
973952 | 973952 | 2021-01-28 | Schuyler | Missouri | 29197 | 258 | 1 |
973953 | 973953 | 2021-01-28 | Scotland | Missouri | 29199 | 236 | 3 |
973954 | 973954 | 2021-01-28 | Scott | Missouri | 29201 | 3656 | 71 |
973955 | 973955 | 2021-01-28 | Shannon | Missouri | 29203 | 456 | 10 |
973956 | 973956 | 2021-01-28 | Shelby | Missouri | 29205 | 342 | 5 |
973957 | 973957 | 2021-01-28 | St. Charles | Missouri | 29183 | 40047 | 356 |
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);