ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2269997 | 2269997 | 2022-03-03 | Adair | Missouri | 29001 | 6024 | 61 |
2269998 | 2269998 | 2022-03-03 | Andrew | Missouri | 29003 | 4687 | 54 |
2269999 | 2269999 | 2022-03-03 | Atchison | Missouri | 29005 | 1376 | 19 |
2270000 | 2270000 | 2022-03-03 | Audrain | Missouri | 29007 | 5671 | 107 |
2270001 | 2270001 | 2022-03-03 | Barry | Missouri | 29009 | 6579 | 124 |
2270002 | 2270002 | 2022-03-03 | Barton | Missouri | 29011 | 2800 | 49 |
2270003 | 2270003 | 2022-03-03 | Bates | Missouri | 29013 | 3725 | 88 |
2270004 | 2270004 | 2022-03-03 | Benton | Missouri | 29015 | 4124 | 91 |
2270005 | 2270005 | 2022-03-03 | Bollinger | Missouri | 29017 | 2501 | 36 |
2270006 | 2270006 | 2022-03-03 | Boone | Missouri | 29019 | 43109 | 241 |
2270007 | 2270007 | 2022-03-03 | Buchanan | Missouri | 29021 | 24603 | 296 |
2270008 | 2270008 | 2022-03-03 | Butler | Missouri | 29023 | 9912 | 154 |
2270009 | 2270009 | 2022-03-03 | Caldwell | Missouri | 29025 | 1672 | 35 |
2270010 | 2270010 | 2022-03-03 | Callaway | Missouri | 29027 | 11930 | 119 |
2270011 | 2270011 | 2022-03-03 | Camden | Missouri | 29029 | 9220 | 171 |
2270012 | 2270012 | 2022-03-03 | Cape Girardeau | Missouri | 29031 | 18489 | 233 |
2270013 | 2270013 | 2022-03-03 | Carroll | Missouri | 29033 | 2219 | 42 |
2270014 | 2270014 | 2022-03-03 | Carter | Missouri | 29035 | 1489 | 21 |
2270015 | 2270015 | 2022-03-03 | Cass | Missouri | 29037 | 24581 | 298 |
2270016 | 2270016 | 2022-03-03 | Cedar | Missouri | 29039 | 2902 | 48 |
2270017 | 2270017 | 2022-03-03 | Chariton | Missouri | 29041 | 1686 | 34 |
2270018 | 2270018 | 2022-03-03 | Christian | Missouri | 29043 | 20728 | 245 |
2270019 | 2270019 | 2022-03-03 | Clark | Missouri | 29045 | 1575 | 32 |
2270020 | 2270020 | 2022-03-03 | Clay | Missouri | 29047 | 26879 | 354 |
2270021 | 2270021 | 2022-03-03 | Clinton | Missouri | 29049 | 4704 | 114 |
2270022 | 2270022 | 2022-03-03 | Cole | Missouri | 29051 | 20013 | 270 |
2270023 | 2270023 | 2022-03-03 | Cooper | Missouri | 29053 | 4128 | 74 |
2270024 | 2270024 | 2022-03-03 | Crawford | Missouri | 29055 | 5360 | 97 |
2270025 | 2270025 | 2022-03-03 | Dade | Missouri | 29057 | 1417 | 40 |
2270026 | 2270026 | 2022-03-03 | Dallas | Missouri | 29059 | 3774 | 70 |
2270027 | 2270027 | 2022-03-03 | Daviess | Missouri | 29061 | 1665 | 26 |
2270028 | 2270028 | 2022-03-03 | DeKalb | Missouri | 29063 | 2135 | 45 |
2270029 | 2270029 | 2022-03-03 | Dent | Missouri | 29065 | 3233 | 74 |
2270030 | 2270030 | 2022-03-03 | Douglas | Missouri | 29067 | 2535 | 77 |
2270031 | 2270031 | 2022-03-03 | Dunklin | Missouri | 29069 | 7103 | 110 |
2270032 | 2270032 | 2022-03-03 | Franklin | Missouri | 29071 | 22542 | 322 |
2270033 | 2270033 | 2022-03-03 | Gasconade | Missouri | 29073 | 3304 | 94 |
2270034 | 2270034 | 2022-03-03 | Gentry | Missouri | 29075 | 2126 | 30 |
2270035 | 2270035 | 2022-03-03 | Greene | Missouri | 29077 | 70658 | 967 |
2270036 | 2270036 | 2022-03-03 | Grundy | Missouri | 29079 | 2398 | 65 |
2270037 | 2270037 | 2022-03-03 | Harrison | Missouri | 29081 | 1799 | 30 |
2270038 | 2270038 | 2022-03-03 | Henry | Missouri | 29083 | 5715 | 78 |
2270039 | 2270039 | 2022-03-03 | Hickory | Missouri | 29085 | 1817 | 54 |
2270040 | 2270040 | 2022-03-03 | Holt | Missouri | 29087 | 1044 | 27 |
2270041 | 2270041 | 2022-03-03 | Howard | Missouri | 29089 | 2152 | 25 |
2270042 | 2270042 | 2022-03-03 | Howell | Missouri | 29091 | 8824 | 199 |
2270043 | 2270043 | 2022-03-03 | Iron | Missouri | 29093 | 2167 | 36 |
2270044 | 2270044 | 2022-03-03 | Jackson | Missouri | 29095 | 95879 | 1150 |
2270045 | 2270045 | 2022-03-03 | Jasper | Missouri | 29097 | 20747 | 297 |
2270046 | 2270046 | 2022-03-03 | Jefferson | Missouri | 29099 | 53684 | 601 |
2270047 | 2270047 | 2022-03-03 | Johnson | Missouri | 29101 | 12011 | 139 |
2270048 | 2270048 | 2022-03-03 | Joplin | Missouri | 13694 | 211 | |
2270049 | 2270049 | 2022-03-03 | Kansas City | Missouri | 111337 | 1203 | |
2270050 | 2270050 | 2022-03-03 | Knox | Missouri | 29103 | 954 | 12 |
2270051 | 2270051 | 2022-03-03 | Laclede | Missouri | 29105 | 8065 | 167 |
2270052 | 2270052 | 2022-03-03 | Lafayette | Missouri | 29107 | 7682 | 123 |
2270053 | 2270053 | 2022-03-03 | Lawrence | Missouri | 29109 | 7704 | 153 |
2270054 | 2270054 | 2022-03-03 | Lewis | Missouri | 29111 | 2698 | 34 |
2270055 | 2270055 | 2022-03-03 | Lincoln | Missouri | 29113 | 15071 | 129 |
2270056 | 2270056 | 2022-03-03 | Linn | Missouri | 29115 | 2510 | 62 |
2270057 | 2270057 | 2022-03-03 | Livingston | Missouri | 29117 | 3707 | 88 |
2270058 | 2270058 | 2022-03-03 | Macon | Missouri | 29121 | 3598 | 49 |
2270059 | 2270059 | 2022-03-03 | Madison | Missouri | 29123 | 3557 | 50 |
2270060 | 2270060 | 2022-03-03 | Maries | Missouri | 29125 | 1587 | 33 |
2270061 | 2270061 | 2022-03-03 | Marion | Missouri | 29127 | 7927 | 114 |
2270062 | 2270062 | 2022-03-03 | McDonald | Missouri | 29119 | 5770 | 66 |
2270063 | 2270063 | 2022-03-03 | Mercer | Missouri | 29129 | 691 | 12 |
2270064 | 2270064 | 2022-03-03 | Miller | Missouri | 29131 | 6059 | 114 |
2270065 | 2270065 | 2022-03-03 | Mississippi | Missouri | 29133 | 3291 | 56 |
2270066 | 2270066 | 2022-03-03 | Moniteau | Missouri | 29135 | 3797 | 55 |
2270067 | 2270067 | 2022-03-03 | Monroe | Missouri | 29137 | 2156 | 40 |
2270068 | 2270068 | 2022-03-03 | Montgomery | Missouri | 29139 | 2455 | 54 |
2270069 | 2270069 | 2022-03-03 | Morgan | Missouri | 29141 | 3989 | 101 |
2270070 | 2270070 | 2022-03-03 | New Madrid | Missouri | 29143 | 5004 | 81 |
2270071 | 2270071 | 2022-03-03 | Newton | Missouri | 29145 | 11656 | 192 |
2270072 | 2270072 | 2022-03-03 | Nodaway | Missouri | 29147 | 5988 | 43 |
2270073 | 2270073 | 2022-03-03 | Oregon | Missouri | 29149 | 2012 | 32 |
2270074 | 2270074 | 2022-03-03 | Osage | Missouri | 29151 | 3191 | 40 |
2270075 | 2270075 | 2022-03-03 | Ozark | Missouri | 29153 | 1690 | 55 |
2270076 | 2270076 | 2022-03-03 | Pemiscot | Missouri | 29155 | 2957 | 73 |
2270077 | 2270077 | 2022-03-03 | Perry | Missouri | 29157 | 4868 | 44 |
2270078 | 2270078 | 2022-03-03 | Pettis | Missouri | 29159 | 11842 | 154 |
2270079 | 2270079 | 2022-03-03 | Phelps | Missouri | 29161 | 9977 | 231 |
2270080 | 2270080 | 2022-03-03 | Pike | Missouri | 29163 | 4214 | 57 |
2270081 | 2270081 | 2022-03-03 | Platte | Missouri | 29165 | 10227 | 100 |
2270082 | 2270082 | 2022-03-03 | Polk | Missouri | 29167 | 7998 | 103 |
2270083 | 2270083 | 2022-03-03 | Pulaski | Missouri | 29169 | 8777 | 112 |
2270084 | 2270084 | 2022-03-03 | Putnam | Missouri | 29171 | 984 | 22 |
2270085 | 2270085 | 2022-03-03 | Ralls | Missouri | 29173 | 2425 | 24 |
2270086 | 2270086 | 2022-03-03 | Randolph | Missouri | 29175 | 5981 | 100 |
2270087 | 2270087 | 2022-03-03 | Ray | Missouri | 29177 | 5124 | 90 |
2270088 | 2270088 | 2022-03-03 | Reynolds | Missouri | 29179 | 1145 | 24 |
2270089 | 2270089 | 2022-03-03 | Ripley | Missouri | 29181 | 2670 | 58 |
2270090 | 2270090 | 2022-03-03 | Saline | Missouri | 29195 | 6245 | 99 |
2270091 | 2270091 | 2022-03-03 | Schuyler | Missouri | 29197 | 720 | 25 |
2270092 | 2270092 | 2022-03-03 | Scotland | Missouri | 29199 | 683 | 18 |
2270093 | 2270093 | 2022-03-03 | Scott | Missouri | 29201 | 11021 | 152 |
2270094 | 2270094 | 2022-03-03 | Shannon | Missouri | 29203 | 1586 | 35 |
2270095 | 2270095 | 2022-03-03 | Shelby | Missouri | 29205 | 1501 | 15 |
2270096 | 2270096 | 2022-03-03 | St. Charles | Missouri | 29183 | 101054 | 887 |
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);