ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where date = "2020-10-30" 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 |
---|---|---|---|---|---|---|---|
681804 | 681804 | 2020-10-30 | Adair | Missouri | 29001 | 604 | 0 |
681805 | 681805 | 2020-10-30 | Andrew | Missouri | 29003 | 462 | 8 |
681806 | 681806 | 2020-10-30 | Atchison | Missouri | 29005 | 82 | 1 |
681807 | 681807 | 2020-10-30 | Audrain | Missouri | 29007 | 922 | 10 |
681808 | 681808 | 2020-10-30 | Barry | Missouri | 29009 | 882 | 9 |
681809 | 681809 | 2020-10-30 | Barton | Missouri | 29011 | 444 | 4 |
681810 | 681810 | 2020-10-30 | Bates | Missouri | 29013 | 264 | 6 |
681811 | 681811 | 2020-10-30 | Benton | Missouri | 29015 | 491 | 5 |
681812 | 681812 | 2020-10-30 | Bollinger | Missouri | 29017 | 530 | 3 |
681813 | 681813 | 2020-10-30 | Boone | Missouri | 29019 | 6256 | 16 |
681814 | 681814 | 2020-10-30 | Buchanan | Missouri | 29021 | 4002 | 47 |
681815 | 681815 | 2020-10-30 | Butler | Missouri | 29023 | 1285 | 8 |
681816 | 681816 | 2020-10-30 | Caldwell | Missouri | 29025 | 182 | 1 |
681817 | 681817 | 2020-10-30 | Callaway | Missouri | 29027 | 1405 | 5 |
681818 | 681818 | 2020-10-30 | Camden | Missouri | 29029 | 1642 | 35 |
681819 | 681819 | 2020-10-30 | Cape Girardeau | Missouri | 29031 | 3041 | 53 |
681820 | 681820 | 2020-10-30 | Carroll | Missouri | 29033 | 211 | 4 |
681821 | 681821 | 2020-10-30 | Carter | Missouri | 29035 | 188 | 3 |
681822 | 681822 | 2020-10-30 | Cass | Missouri | 29037 | 2283 | 30 |
681823 | 681823 | 2020-10-30 | Cedar | Missouri | 29039 | 248 | 4 |
681824 | 681824 | 2020-10-30 | Chariton | Missouri | 29041 | 70 | 0 |
681825 | 681825 | 2020-10-30 | Christian | Missouri | 29043 | 2630 | 13 |
681826 | 681826 | 2020-10-30 | Clark | Missouri | 29045 | 120 | 1 |
681827 | 681827 | 2020-10-30 | Clay | Missouri | 29047 | 2726 | 61 |
681828 | 681828 | 2020-10-30 | Clinton | Missouri | 29049 | 532 | 23 |
681829 | 681829 | 2020-10-30 | Cole | Missouri | 29051 | 3216 | 24 |
681830 | 681830 | 2020-10-30 | Cooper | Missouri | 29053 | 650 | 3 |
681831 | 681831 | 2020-10-30 | Crawford | Missouri | 29055 | 675 | 8 |
681832 | 681832 | 2020-10-30 | Dade | Missouri | 29057 | 147 | 0 |
681833 | 681833 | 2020-10-30 | Dallas | Missouri | 29059 | 395 | 1 |
681834 | 681834 | 2020-10-30 | Daviess | Missouri | 29061 | 228 | 3 |
681835 | 681835 | 2020-10-30 | DeKalb | Missouri | 29063 | 311 | 2 |
681836 | 681836 | 2020-10-30 | Dent | Missouri | 29065 | 266 | 3 |
681837 | 681837 | 2020-10-30 | Douglas | Missouri | 29067 | 297 | 12 |
681838 | 681838 | 2020-10-30 | Dunklin | Missouri | 29069 | 1182 | 12 |
681839 | 681839 | 2020-10-30 | Franklin | Missouri | 29071 | 2815 | 46 |
681840 | 681840 | 2020-10-30 | Gasconade | Missouri | 29073 | 277 | 24 |
681841 | 681841 | 2020-10-30 | Gentry | Missouri | 29075 | 188 | 10 |
681842 | 681842 | 2020-10-30 | Greene | Missouri | 29077 | 9999 | 154 |
681843 | 681843 | 2020-10-30 | Grundy | Missouri | 29079 | 272 | 11 |
681844 | 681844 | 2020-10-30 | Harrison | Missouri | 29081 | 193 | 1 |
681845 | 681845 | 2020-10-30 | Henry | Missouri | 29083 | 418 | 7 |
681846 | 681846 | 2020-10-30 | Hickory | Missouri | 29085 | 251 | 3 |
681847 | 681847 | 2020-10-30 | Holt | Missouri | 29087 | 123 | 1 |
681848 | 681848 | 2020-10-30 | Howard | Missouri | 29089 | 257 | 2 |
681849 | 681849 | 2020-10-30 | Howell | Missouri | 29091 | 1246 | 10 |
681850 | 681850 | 2020-10-30 | Iron | Missouri | 29093 | 110 | 0 |
681851 | 681851 | 2020-10-30 | Jackson | Missouri | 29095 | 10365 | 136 |
681852 | 681852 | 2020-10-30 | Jasper | Missouri | 29097 | 3339 | 45 |
681853 | 681853 | 2020-10-30 | Jefferson | Missouri | 29099 | 6328 | 84 |
681854 | 681854 | 2020-10-30 | Johnson | Missouri | 29101 | 1557 | 10 |
681855 | 681855 | 2020-10-30 | Joplin | Missouri | 2113 | 31 | |
681856 | 681856 | 2020-10-30 | Kansas City | Missouri | 14986 | 208 | |
681857 | 681857 | 2020-10-30 | Knox | Missouri | 29103 | 65 | 1 |
681858 | 681858 | 2020-10-30 | Laclede | Missouri | 29105 | 1241 | 22 |
681859 | 681859 | 2020-10-30 | Lafayette | Missouri | 29107 | 896 | 24 |
681860 | 681860 | 2020-10-30 | Lawrence | Missouri | 29109 | 1156 | 21 |
681861 | 681861 | 2020-10-30 | Lewis | Missouri | 29111 | 218 | 2 |
681862 | 681862 | 2020-10-30 | Lincoln | Missouri | 29113 | 1269 | 5 |
681863 | 681863 | 2020-10-30 | Linn | Missouri | 29115 | 171 | 4 |
681864 | 681864 | 2020-10-30 | Livingston | Missouri | 29117 | 578 | 9 |
681865 | 681865 | 2020-10-30 | Macon | Missouri | 29121 | 240 | 1 |
681866 | 681866 | 2020-10-30 | Madison | Missouri | 29123 | 530 | 3 |
681867 | 681867 | 2020-10-30 | Maries | Missouri | 29125 | 213 | 0 |
681868 | 681868 | 2020-10-30 | Marion | Missouri | 29127 | 970 | 14 |
681869 | 681869 | 2020-10-30 | McDonald | Missouri | 29119 | 1328 | 15 |
681870 | 681870 | 2020-10-30 | Mercer | Missouri | 29129 | 33 | 0 |
681871 | 681871 | 2020-10-30 | Miller | Missouri | 29131 | 929 | 13 |
681872 | 681872 | 2020-10-30 | Mississippi | Missouri | 29133 | 459 | 6 |
681873 | 681873 | 2020-10-30 | Moniteau | Missouri | 29135 | 674 | 12 |
681874 | 681874 | 2020-10-30 | Monroe | Missouri | 29137 | 179 | 2 |
681875 | 681875 | 2020-10-30 | Montgomery | Missouri | 29139 | 176 | 1 |
681876 | 681876 | 2020-10-30 | Morgan | Missouri | 29141 | 704 | 7 |
681877 | 681877 | 2020-10-30 | New Madrid | Missouri | 29143 | 801 | 22 |
681878 | 681878 | 2020-10-30 | Newton | Missouri | 29145 | 2115 | 21 |
681879 | 681879 | 2020-10-30 | Nodaway | Missouri | 29147 | 1235 | 11 |
681880 | 681880 | 2020-10-30 | Oregon | Missouri | 29149 | 242 | 0 |
681881 | 681881 | 2020-10-30 | Osage | Missouri | 29151 | 537 | 3 |
681882 | 681882 | 2020-10-30 | Ozark | Missouri | 29153 | 223 | 1 |
681883 | 681883 | 2020-10-30 | Pemiscot | Missouri | 29155 | 748 | 13 |
681884 | 681884 | 2020-10-30 | Perry | Missouri | 29157 | 848 | 8 |
681885 | 681885 | 2020-10-30 | Pettis | Missouri | 29159 | 1860 | 26 |
681886 | 681886 | 2020-10-30 | Phelps | Missouri | 29161 | 902 | 27 |
681887 | 681887 | 2020-10-30 | Pike | Missouri | 29163 | 372 | 8 |
681888 | 681888 | 2020-10-30 | Platte | Missouri | 29165 | 1032 | 13 |
681889 | 681889 | 2020-10-30 | Polk | Missouri | 29167 | 1232 | 19 |
681890 | 681890 | 2020-10-30 | Pulaski | Missouri | 29169 | 1053 | 11 |
681891 | 681891 | 2020-10-30 | Putnam | Missouri | 29171 | 60 | 1 |
681892 | 681892 | 2020-10-30 | Ralls | Missouri | 29173 | 215 | 0 |
681893 | 681893 | 2020-10-30 | Randolph | Missouri | 29175 | 657 | 3 |
681894 | 681894 | 2020-10-30 | Ray | Missouri | 29177 | 299 | 2 |
681895 | 681895 | 2020-10-30 | Reynolds | Missouri | 29179 | 89 | 1 |
681896 | 681896 | 2020-10-30 | Ripley | Missouri | 29181 | 280 | 4 |
681897 | 681897 | 2020-10-30 | Saline | Missouri | 29195 | 988 | 10 |
681898 | 681898 | 2020-10-30 | Schuyler | Missouri | 29197 | 44 | 0 |
681899 | 681899 | 2020-10-30 | Scotland | Missouri | 29199 | 78 | 1 |
681900 | 681900 | 2020-10-30 | Scott | Missouri | 29201 | 1484 | 25 |
681901 | 681901 | 2020-10-30 | Shannon | Missouri | 29203 | 257 | 5 |
681902 | 681902 | 2020-10-30 | Shelby | Missouri | 29205 | 111 | 1 |
681903 | 681903 | 2020-10-30 | St. Charles | Missouri | 29183 | 11948 | 162 |
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);