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-12-09 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1996852 | 1996852 | 2021-12-09 | Adair | Missouri | 29001 | 3953 | 44 |
1996853 | 1996853 | 2021-12-09 | Andrew | Missouri | 29003 | 3220 | 40 |
1996854 | 1996854 | 2021-12-09 | Atchison | Missouri | 29005 | 878 | 18 |
1996855 | 1996855 | 2021-12-09 | Audrain | Missouri | 29007 | 4234 | 79 |
1996856 | 1996856 | 2021-12-09 | Barry | Missouri | 29009 | 4704 | 92 |
1996857 | 1996857 | 2021-12-09 | Barton | Missouri | 29011 | 1902 | 40 |
1996858 | 1996858 | 2021-12-09 | Bates | Missouri | 29013 | 2561 | 59 |
1996859 | 1996859 | 2021-12-09 | Benton | Missouri | 29015 | 2818 | 70 |
1996860 | 1996860 | 2021-12-09 | Bollinger | Missouri | 29017 | 1948 | 31 |
1996861 | 1996861 | 2021-12-09 | Boone | Missouri | 29019 | 27260 | 191 |
1996862 | 1996862 | 2021-12-09 | Buchanan | Missouri | 29021 | 16925 | 245 |
1996863 | 1996863 | 2021-12-09 | Butler | Missouri | 29023 | 7175 | 127 |
1996864 | 1996864 | 2021-12-09 | Caldwell | Missouri | 29025 | 1277 | 26 |
1996865 | 1996865 | 2021-12-09 | Callaway | Missouri | 29027 | 8248 | 96 |
1996866 | 1996866 | 2021-12-09 | Camden | Missouri | 29029 | 6747 | 148 |
1996867 | 1996867 | 2021-12-09 | Cape Girardeau | Missouri | 29031 | 13899 | 201 |
1996868 | 1996868 | 2021-12-09 | Carroll | Missouri | 29033 | 1545 | 39 |
1996869 | 1996869 | 2021-12-09 | Carter | Missouri | 29035 | 1133 | 18 |
1996870 | 1996870 | 2021-12-09 | Cass | Missouri | 29037 | 16040 | 211 |
1996871 | 1996871 | 2021-12-09 | Cedar | Missouri | 29039 | 1932 | 42 |
1996872 | 1996872 | 2021-12-09 | Chariton | Missouri | 29041 | 1216 | 30 |
1996873 | 1996873 | 2021-12-09 | Christian | Missouri | 29043 | 14134 | 202 |
1996874 | 1996874 | 2021-12-09 | Clark | Missouri | 29045 | 1187 | 27 |
1996875 | 1996875 | 2021-12-09 | Clay | Missouri | 29047 | 17104 | 262 |
1996876 | 1996876 | 2021-12-09 | Clinton | Missouri | 29049 | 3300 | 95 |
1996877 | 1996877 | 2021-12-09 | Cole | Missouri | 29051 | 14080 | 233 |
1996878 | 1996878 | 2021-12-09 | Cooper | Missouri | 29053 | 3052 | 53 |
1996879 | 1996879 | 2021-12-09 | Crawford | Missouri | 29055 | 3890 | 76 |
1996880 | 1996880 | 2021-12-09 | Dade | Missouri | 29057 | 932 | 38 |
1996881 | 1996881 | 2021-12-09 | Dallas | Missouri | 29059 | 2486 | 57 |
1996882 | 1996882 | 2021-12-09 | Daviess | Missouri | 29061 | 1193 | 17 |
1996883 | 1996883 | 2021-12-09 | DeKalb | Missouri | 29063 | 1629 | 37 |
1996884 | 1996884 | 2021-12-09 | Dent | Missouri | 29065 | 2171 | 62 |
1996885 | 1996885 | 2021-12-09 | Douglas | Missouri | 29067 | 1808 | 63 |
1996886 | 1996886 | 2021-12-09 | Dunklin | Missouri | 29069 | 4730 | 93 |
1996887 | 1996887 | 2021-12-09 | Franklin | Missouri | 29071 | 16155 | 264 |
1996888 | 1996888 | 2021-12-09 | Gasconade | Missouri | 29073 | 2459 | 81 |
1996889 | 1996889 | 2021-12-09 | Gentry | Missouri | 29075 | 1576 | 28 |
1996890 | 1996890 | 2021-12-09 | Greene | Missouri | 29077 | 47343 | 832 |
1996891 | 1996891 | 2021-12-09 | Grundy | Missouri | 29079 | 1774 | 55 |
1996892 | 1996892 | 2021-12-09 | Harrison | Missouri | 29081 | 1359 | 21 |
1996893 | 1996893 | 2021-12-09 | Henry | Missouri | 29083 | 3710 | 64 |
1996894 | 1996894 | 2021-12-09 | Hickory | Missouri | 29085 | 1276 | 43 |
1996895 | 1996895 | 2021-12-09 | Holt | Missouri | 29087 | 730 | 23 |
1996896 | 1996896 | 2021-12-09 | Howard | Missouri | 29089 | 1564 | 19 |
1996897 | 1996897 | 2021-12-09 | Howell | Missouri | 29091 | 6309 | 170 |
1996898 | 1996898 | 2021-12-09 | Iron | Missouri | 29093 | 1519 | 28 |
1996899 | 1996899 | 2021-12-09 | Jackson | Missouri | 29095 | 61370 | 843 |
1996900 | 1996900 | 2021-12-09 | Jasper | Missouri | 29097 | 14577 | 259 |
1996901 | 1996901 | 2021-12-09 | Jefferson | Missouri | 29099 | 36102 | 435 |
1996902 | 1996902 | 2021-12-09 | Johnson | Missouri | 29101 | 8059 | 109 |
1996903 | 1996903 | 2021-12-09 | Joplin | Missouri | 9318 | 186 | |
1996904 | 1996904 | 2021-12-09 | Kansas City | Missouri | 70033 | 964 | |
1996905 | 1996905 | 2021-12-09 | Knox | Missouri | 29103 | 654 | 8 |
1996906 | 1996906 | 2021-12-09 | Laclede | Missouri | 29105 | 5692 | 149 |
1996907 | 1996907 | 2021-12-09 | Lafayette | Missouri | 29107 | 5192 | 87 |
1996908 | 1996908 | 2021-12-09 | Lawrence | Missouri | 29109 | 5509 | 137 |
1996909 | 1996909 | 2021-12-09 | Lewis | Missouri | 29111 | 1869 | 30 |
1996910 | 1996910 | 2021-12-09 | Lincoln | Missouri | 29113 | 10566 | 94 |
1996911 | 1996911 | 2021-12-09 | Linn | Missouri | 29115 | 1936 | 57 |
1996912 | 1996912 | 2021-12-09 | Livingston | Missouri | 29117 | 2713 | 79 |
1996913 | 1996913 | 2021-12-09 | Macon | Missouri | 29121 | 2495 | 34 |
1996914 | 1996914 | 2021-12-09 | Madison | Missouri | 29123 | 2513 | 40 |
1996915 | 1996915 | 2021-12-09 | Maries | Missouri | 29125 | 1116 | 21 |
1996916 | 1996916 | 2021-12-09 | Marion | Missouri | 29127 | 5701 | 100 |
1996917 | 1996917 | 2021-12-09 | McDonald | Missouri | 29119 | 4159 | 63 |
1996918 | 1996918 | 2021-12-09 | Mercer | Missouri | 29129 | 489 | 9 |
1996919 | 1996919 | 2021-12-09 | Miller | Missouri | 29131 | 4346 | 100 |
1996920 | 1996920 | 2021-12-09 | Mississippi | Missouri | 29133 | 2405 | 49 |
1996921 | 1996921 | 2021-12-09 | Moniteau | Missouri | 29135 | 2836 | 46 |
1996922 | 1996922 | 2021-12-09 | Monroe | Missouri | 29137 | 1502 | 32 |
1996923 | 1996923 | 2021-12-09 | Montgomery | Missouri | 29139 | 1673 | 34 |
1996924 | 1996924 | 2021-12-09 | Morgan | Missouri | 29141 | 2864 | 73 |
1996925 | 1996925 | 2021-12-09 | New Madrid | Missouri | 29143 | 3483 | 70 |
1996926 | 1996926 | 2021-12-09 | Newton | Missouri | 29145 | 8237 | 169 |
1996927 | 1996927 | 2021-12-09 | Nodaway | Missouri | 29147 | 4092 | 37 |
1996928 | 1996928 | 2021-12-09 | Oregon | Missouri | 29149 | 1474 | 25 |
1996929 | 1996929 | 2021-12-09 | Osage | Missouri | 29151 | 2355 | 35 |
1996930 | 1996930 | 2021-12-09 | Ozark | Missouri | 29153 | 1262 | 42 |
1996931 | 1996931 | 2021-12-09 | Pemiscot | Missouri | 29155 | 2138 | 59 |
1996932 | 1996932 | 2021-12-09 | Perry | Missouri | 29157 | 3544 | 39 |
1996933 | 1996933 | 2021-12-09 | Pettis | Missouri | 29159 | 7969 | 128 |
1996934 | 1996934 | 2021-12-09 | Phelps | Missouri | 29161 | 6944 | 195 |
1996935 | 1996935 | 2021-12-09 | Pike | Missouri | 29163 | 2985 | 51 |
1996936 | 1996936 | 2021-12-09 | Platte | Missouri | 29165 | 6777 | 71 |
1996937 | 1996937 | 2021-12-09 | Polk | Missouri | 29167 | 5487 | 80 |
1996938 | 1996938 | 2021-12-09 | Pulaski | Missouri | 29169 | 5694 | 97 |
1996939 | 1996939 | 2021-12-09 | Putnam | Missouri | 29171 | 718 | 19 |
1996940 | 1996940 | 2021-12-09 | Ralls | Missouri | 29173 | 1734 | 18 |
1996941 | 1996941 | 2021-12-09 | Randolph | Missouri | 29175 | 4031 | 80 |
1996942 | 1996942 | 2021-12-09 | Ray | Missouri | 29177 | 3387 | 61 |
1996943 | 1996943 | 2021-12-09 | Reynolds | Missouri | 29179 | 795 | 12 |
1996944 | 1996944 | 2021-12-09 | Ripley | Missouri | 29181 | 2090 | 51 |
1996945 | 1996945 | 2021-12-09 | Saline | Missouri | 29195 | 4456 | 84 |
1996946 | 1996946 | 2021-12-09 | Schuyler | Missouri | 29197 | 505 | 22 |
1996947 | 1996947 | 2021-12-09 | Scotland | Missouri | 29199 | 460 | 15 |
1996948 | 1996948 | 2021-12-09 | Scott | Missouri | 29201 | 7759 | 132 |
1996949 | 1996949 | 2021-12-09 | Shannon | Missouri | 29203 | 1153 | 29 |
1996950 | 1996950 | 2021-12-09 | Shelby | Missouri | 29205 | 1061 | 13 |
1996951 | 1996951 | 2021-12-09 | St. Charles | Missouri | 29183 | 66811 | 729 |
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);