ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Franklin" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387464 | 387464 | 2020-07-31 | Franklin | Missouri | 29071 | 509 | 18 |
384246 | 384246 | 2020-07-30 | Franklin | Missouri | 29071 | 490 | 18 |
381030 | 381030 | 2020-07-29 | Franklin | Missouri | 29071 | 484 | 18 |
377813 | 377813 | 2020-07-28 | Franklin | Missouri | 29071 | 469 | 18 |
374598 | 374598 | 2020-07-27 | Franklin | Missouri | 29071 | 451 | 18 |
371386 | 371386 | 2020-07-26 | Franklin | Missouri | 29071 | 447 | 18 |
368175 | 368175 | 2020-07-25 | Franklin | Missouri | 29071 | 443 | 18 |
364967 | 364967 | 2020-07-24 | Franklin | Missouri | 29071 | 424 | 18 |
361760 | 361760 | 2020-07-23 | Franklin | Missouri | 29071 | 408 | 18 |
358555 | 358555 | 2020-07-22 | Franklin | Missouri | 29071 | 394 | 18 |
355352 | 355352 | 2020-07-21 | Franklin | Missouri | 29071 | 382 | 18 |
352150 | 352150 | 2020-07-20 | Franklin | Missouri | 29071 | 360 | 18 |
348950 | 348950 | 2020-07-19 | Franklin | Missouri | 29071 | 354 | 18 |
345749 | 345749 | 2020-07-18 | Franklin | Missouri | 29071 | 348 | 18 |
342549 | 342549 | 2020-07-17 | Franklin | Missouri | 29071 | 337 | 18 |
339353 | 339353 | 2020-07-16 | Franklin | Missouri | 29071 | 324 | 18 |
336157 | 336157 | 2020-07-15 | Franklin | Missouri | 29071 | 317 | 18 |
332964 | 332964 | 2020-07-14 | Franklin | Missouri | 29071 | 305 | 18 |
329777 | 329777 | 2020-07-13 | Franklin | Missouri | 29071 | 283 | 18 |
326591 | 326591 | 2020-07-12 | Franklin | Missouri | 29071 | 279 | 18 |
323408 | 323408 | 2020-07-11 | Franklin | Missouri | 29071 | 273 | 18 |
320229 | 320229 | 2020-07-10 | Franklin | Missouri | 29071 | 264 | 18 |
317054 | 317054 | 2020-07-09 | Franklin | Missouri | 29071 | 248 | 18 |
313880 | 313880 | 2020-07-08 | Franklin | Missouri | 29071 | 235 | 18 |
310710 | 310710 | 2020-07-07 | Franklin | Missouri | 29071 | 231 | 18 |
307542 | 307542 | 2020-07-06 | Franklin | Missouri | 29071 | 227 | 18 |
304375 | 304375 | 2020-07-05 | Franklin | Missouri | 29071 | 217 | 18 |
301211 | 301211 | 2020-07-04 | Franklin | Missouri | 29071 | 217 | 18 |
298048 | 298048 | 2020-07-03 | Franklin | Missouri | 29071 | 217 | 18 |
294890 | 294890 | 2020-07-02 | Franklin | Missouri | 29071 | 213 | 18 |
291736 | 291736 | 2020-07-01 | Franklin | Missouri | 29071 | 208 | 18 |
288585 | 288585 | 2020-06-30 | Franklin | Missouri | 29071 | 206 | 18 |
285435 | 285435 | 2020-06-29 | Franklin | Missouri | 29071 | 207 | 18 |
282290 | 282290 | 2020-06-28 | Franklin | Missouri | 29071 | 206 | 18 |
279142 | 279142 | 2020-06-27 | Franklin | Missouri | 29071 | 204 | 18 |
275994 | 275994 | 2020-06-26 | Franklin | Missouri | 29071 | 202 | 18 |
272851 | 272851 | 2020-06-25 | Franklin | Missouri | 29071 | 201 | 18 |
269713 | 269713 | 2020-06-24 | Franklin | Missouri | 29071 | 192 | 18 |
266580 | 266580 | 2020-06-23 | Franklin | Missouri | 29071 | 193 | 18 |
263454 | 263454 | 2020-06-22 | Franklin | Missouri | 29071 | 191 | 18 |
260326 | 260326 | 2020-06-21 | Franklin | Missouri | 29071 | 188 | 18 |
257200 | 257200 | 2020-06-20 | Franklin | Missouri | 29071 | 188 | 18 |
254080 | 254080 | 2020-06-19 | Franklin | Missouri | 29071 | 180 | 18 |
250965 | 250965 | 2020-06-18 | Franklin | Missouri | 29071 | 178 | 18 |
247852 | 247852 | 2020-06-17 | Franklin | Missouri | 29071 | 173 | 18 |
244739 | 244739 | 2020-06-16 | Franklin | Missouri | 29071 | 172 | 18 |
241628 | 241628 | 2020-06-15 | Franklin | Missouri | 29071 | 168 | 18 |
238518 | 238518 | 2020-06-14 | Franklin | Missouri | 29071 | 166 | 18 |
235411 | 235411 | 2020-06-13 | Franklin | Missouri | 29071 | 166 | 18 |
232305 | 232305 | 2020-06-12 | Franklin | Missouri | 29071 | 166 | 18 |
229201 | 229201 | 2020-06-11 | Franklin | Missouri | 29071 | 164 | 18 |
226098 | 226098 | 2020-06-10 | Franklin | Missouri | 29071 | 155 | 18 |
223000 | 223000 | 2020-06-09 | Franklin | Missouri | 29071 | 156 | 18 |
219905 | 219905 | 2020-06-08 | Franklin | Missouri | 29071 | 153 | 18 |
216813 | 216813 | 2020-06-07 | Franklin | Missouri | 29071 | 150 | 17 |
213725 | 213725 | 2020-06-06 | Franklin | Missouri | 29071 | 150 | 17 |
210641 | 210641 | 2020-06-05 | Franklin | Missouri | 29071 | 149 | 17 |
207560 | 207560 | 2020-06-04 | Franklin | Missouri | 29071 | 149 | 17 |
204479 | 204479 | 2020-06-03 | Franklin | Missouri | 29071 | 143 | 17 |
201402 | 201402 | 2020-06-02 | Franklin | Missouri | 29071 | 142 | 17 |
198329 | 198329 | 2020-06-01 | Franklin | Missouri | 29071 | 141 | 16 |
195258 | 195258 | 2020-05-31 | Franklin | Missouri | 29071 | 139 | 16 |
192189 | 192189 | 2020-05-30 | Franklin | Missouri | 29071 | 139 | 16 |
189125 | 189125 | 2020-05-29 | Franklin | Missouri | 29071 | 139 | 16 |
186067 | 186067 | 2020-05-28 | Franklin | Missouri | 29071 | 140 | 16 |
183011 | 183011 | 2020-05-27 | Franklin | Missouri | 29071 | 140 | 16 |
179965 | 179965 | 2020-05-26 | Franklin | Missouri | 29071 | 139 | 16 |
176921 | 176921 | 2020-05-25 | Franklin | Missouri | 29071 | 140 | 16 |
173878 | 173878 | 2020-05-24 | Franklin | Missouri | 29071 | 138 | 16 |
170836 | 170836 | 2020-05-23 | Franklin | Missouri | 29071 | 137 | 16 |
167798 | 167798 | 2020-05-22 | Franklin | Missouri | 29071 | 137 | 16 |
164762 | 164762 | 2020-05-21 | Franklin | Missouri | 29071 | 137 | 15 |
161733 | 161733 | 2020-05-20 | Franklin | Missouri | 29071 | 136 | 15 |
158707 | 158707 | 2020-05-19 | Franklin | Missouri | 29071 | 135 | 14 |
155689 | 155689 | 2020-05-18 | Franklin | Missouri | 29071 | 135 | 14 |
152675 | 152675 | 2020-05-17 | Franklin | Missouri | 29071 | 134 | 14 |
149664 | 149664 | 2020-05-16 | Franklin | Missouri | 29071 | 134 | 14 |
146659 | 146659 | 2020-05-15 | Franklin | Missouri | 29071 | 134 | 14 |
143658 | 143658 | 2020-05-14 | Franklin | Missouri | 29071 | 134 | 14 |
140663 | 140663 | 2020-05-13 | Franklin | Missouri | 29071 | 133 | 14 |
137669 | 137669 | 2020-05-12 | Franklin | Missouri | 29071 | 131 | 14 |
134679 | 134679 | 2020-05-11 | Franklin | Missouri | 29071 | 130 | 13 |
131688 | 131688 | 2020-05-10 | Franklin | Missouri | 29071 | 128 | 13 |
128698 | 128698 | 2020-05-09 | Franklin | Missouri | 29071 | 128 | 13 |
125711 | 125711 | 2020-05-08 | Franklin | Missouri | 29071 | 129 | 13 |
122729 | 122729 | 2020-05-07 | Franklin | Missouri | 29071 | 137 | 13 |
119755 | 119755 | 2020-05-06 | Franklin | Missouri | 29071 | 132 | 13 |
116795 | 116795 | 2020-05-05 | Franklin | Missouri | 29071 | 127 | 13 |
113913 | 113913 | 2020-05-04 | Franklin | Missouri | 29071 | 125 | 13 |
111034 | 111034 | 2020-05-03 | Franklin | Missouri | 29071 | 122 | 12 |
108163 | 108163 | 2020-05-02 | Franklin | Missouri | 29071 | 119 | 12 |
105298 | 105298 | 2020-05-01 | Franklin | Missouri | 29071 | 114 | 10 |
102437 | 102437 | 2020-04-30 | Franklin | Missouri | 29071 | 114 | 8 |
99585 | 99585 | 2020-04-29 | Franklin | Missouri | 29071 | 110 | 6 |
96739 | 96739 | 2020-04-28 | Franklin | Missouri | 29071 | 110 | 6 |
93903 | 93903 | 2020-04-27 | Franklin | Missouri | 29071 | 106 | 6 |
91082 | 91082 | 2020-04-26 | Franklin | Missouri | 29071 | 106 | 6 |
88266 | 88266 | 2020-04-25 | Franklin | Missouri | 29071 | 106 | 6 |
85456 | 85456 | 2020-04-24 | Franklin | Missouri | 29071 | 106 | 5 |
82652 | 82652 | 2020-04-23 | Franklin | Missouri | 29071 | 103 | 5 |
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);