ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where cases = 14 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 |
---|---|---|---|---|---|---|---|
503684 | 503684 | 2020-09-05 | Worth | Missouri | 29227 | 14 | 0 |
471329 | 471329 | 2020-08-26 | Schuyler | Missouri | 29197 | 14 | 0 |
442269 | 442269 | 2020-08-17 | Putnam | Missouri | 29171 | 14 | 1 |
439042 | 439042 | 2020-08-16 | Putnam | Missouri | 29171 | 14 | 1 |
419687 | 419687 | 2020-08-10 | Ozark | Missouri | 29153 | 14 | 0 |
413170 | 413170 | 2020-08-08 | Atchison | Missouri | 29005 | 14 | 0 |
413244 | 413244 | 2020-08-08 | Oregon | Missouri | 29149 | 14 | 0 |
413263 | 413263 | 2020-08-08 | Scotland | Missouri | 29199 | 14 | 1 |
409950 | 409950 | 2020-08-07 | Atchison | Missouri | 29005 | 14 | 0 |
410024 | 410024 | 2020-08-07 | Oregon | Missouri | 29149 | 14 | 0 |
410043 | 410043 | 2020-08-07 | Scotland | Missouri | 29199 | 14 | 1 |
406730 | 406730 | 2020-08-06 | Atchison | Missouri | 29005 | 14 | 0 |
406756 | 406756 | 2020-08-06 | Dade | Missouri | 29057 | 14 | 0 |
406804 | 406804 | 2020-08-06 | Oregon | Missouri | 29149 | 14 | 0 |
406823 | 406823 | 2020-08-06 | Scotland | Missouri | 29199 | 14 | 1 |
403512 | 403512 | 2020-08-05 | Atchison | Missouri | 29005 | 14 | 0 |
403586 | 403586 | 2020-08-05 | Oregon | Missouri | 29149 | 14 | 0 |
403605 | 403605 | 2020-08-05 | Scotland | Missouri | 29199 | 14 | 1 |
400315 | 400315 | 2020-08-04 | Clark | Missouri | 29045 | 14 | 0 |
400369 | 400369 | 2020-08-04 | Oregon | Missouri | 29149 | 14 | 0 |
397101 | 397101 | 2020-08-03 | Clark | Missouri | 29045 | 14 | 0 |
397155 | 397155 | 2020-08-03 | Oregon | Missouri | 29149 | 14 | 0 |
393883 | 393883 | 2020-08-02 | Chariton | Missouri | 29041 | 14 | 0 |
393885 | 393885 | 2020-08-02 | Clark | Missouri | 29045 | 14 | 0 |
393926 | 393926 | 2020-08-02 | Maries | Missouri | 29125 | 14 | 0 |
393939 | 393939 | 2020-08-02 | Oregon | Missouri | 29149 | 14 | 0 |
390666 | 390666 | 2020-08-01 | Chariton | Missouri | 29041 | 14 | 0 |
390674 | 390674 | 2020-08-01 | Dade | Missouri | 29057 | 14 | 0 |
390692 | 390692 | 2020-08-01 | Iron | Missouri | 29093 | 14 | 0 |
390709 | 390709 | 2020-08-01 | Maries | Missouri | 29125 | 14 | 0 |
387449 | 387449 | 2020-07-31 | Chariton | Missouri | 29041 | 14 | 0 |
387457 | 387457 | 2020-07-31 | Dade | Missouri | 29057 | 14 | 0 |
387499 | 387499 | 2020-07-31 | Monroe | Missouri | 29137 | 14 | 0 |
387527 | 387527 | 2020-07-31 | Shelby | Missouri | 29205 | 14 | 0 |
384228 | 384228 | 2020-07-30 | Carter | Missouri | 29035 | 14 | 1 |
384231 | 384231 | 2020-07-30 | Chariton | Missouri | 29041 | 14 | 0 |
384239 | 384239 | 2020-07-30 | Dade | Missouri | 29057 | 14 | 0 |
381015 | 381015 | 2020-07-29 | Chariton | Missouri | 29041 | 14 | 0 |
381023 | 381023 | 2020-07-29 | Dade | Missouri | 29057 | 14 | 0 |
381031 | 381031 | 2020-07-29 | Gasconade | Missouri | 29073 | 14 | 0 |
377798 | 377798 | 2020-07-28 | Chariton | Missouri | 29041 | 14 | 0 |
377814 | 377814 | 2020-07-28 | Gasconade | Missouri | 29073 | 14 | 0 |
377820 | 377820 | 2020-07-28 | Hickory | Missouri | 29085 | 14 | 0 |
377869 | 377869 | 2020-07-28 | Reynolds | Missouri | 29179 | 14 | 0 |
374583 | 374583 | 2020-07-27 | Chariton | Missouri | 29041 | 14 | 0 |
361761 | 361761 | 2020-07-23 | Gasconade | Missouri | 29073 | 14 | 0 |
358556 | 358556 | 2020-07-22 | Gasconade | Missouri | 29073 | 14 | 0 |
355347 | 355347 | 2020-07-21 | Daviess | Missouri | 29061 | 14 | 0 |
355353 | 355353 | 2020-07-21 | Gasconade | Missouri | 29073 | 14 | 0 |
355405 | 355405 | 2020-07-21 | Ralls | Missouri | 29173 | 14 | 0 |
336231 | 336231 | 2020-07-15 | Texas | Missouri | 29215 | 14 | 0 |
329748 | 329748 | 2020-07-13 | Bates | Missouri | 29013 | 14 | 1 |
320230 | 320230 | 2020-07-10 | Gasconade | Missouri | 29073 | 14 | 0 |
317031 | 317031 | 2020-07-09 | Caldwell | Missouri | 29025 | 14 | 0 |
317108 | 317108 | 2020-07-09 | Randolph | Missouri | 29175 | 14 | 0 |
313934 | 313934 | 2020-07-08 | Randolph | Missouri | 29175 | 14 | 0 |
307515 | 307515 | 2020-07-06 | Bollinger | Missouri | 29017 | 14 | 0 |
307538 | 307538 | 2020-07-06 | DeKalb | Missouri | 29063 | 14 | 0 |
304348 | 304348 | 2020-07-05 | Bollinger | Missouri | 29017 | 14 | 0 |
304369 | 304369 | 2020-07-05 | Dallas | Missouri | 29059 | 14 | 1 |
304371 | 304371 | 2020-07-05 | DeKalb | Missouri | 29063 | 14 | 0 |
301184 | 301184 | 2020-07-04 | Bollinger | Missouri | 29017 | 14 | 0 |
301205 | 301205 | 2020-07-04 | Dallas | Missouri | 29059 | 14 | 1 |
301207 | 301207 | 2020-07-04 | DeKalb | Missouri | 29063 | 14 | 0 |
298021 | 298021 | 2020-07-03 | Bollinger | Missouri | 29017 | 14 | 0 |
298029 | 298029 | 2020-07-03 | Carroll | Missouri | 29033 | 14 | 0 |
298042 | 298042 | 2020-07-03 | Dallas | Missouri | 29059 | 14 | 1 |
298044 | 298044 | 2020-07-03 | DeKalb | Missouri | 29063 | 14 | 0 |
294884 | 294884 | 2020-07-02 | Dallas | Missouri | 29059 | 14 | 1 |
294895 | 294895 | 2020-07-02 | Harrison | Missouri | 29081 | 14 | 0 |
294926 | 294926 | 2020-07-02 | Morgan | Missouri | 29141 | 14 | 0 |
291727 | 291727 | 2020-07-01 | Cooper | Missouri | 29053 | 14 | 0 |
291741 | 291741 | 2020-07-01 | Harrison | Missouri | 29081 | 14 | 0 |
291772 | 291772 | 2020-07-01 | Morgan | Missouri | 29141 | 14 | 0 |
291806 | 291806 | 2020-07-01 | Stone | Missouri | 29209 | 14 | 0 |
288576 | 288576 | 2020-06-30 | Cooper | Missouri | 29053 | 14 | 0 |
288590 | 288590 | 2020-06-30 | Harrison | Missouri | 29081 | 14 | 0 |
288621 | 288621 | 2020-06-30 | Morgan | Missouri | 29141 | 14 | 0 |
288655 | 288655 | 2020-06-30 | Stone | Missouri | 29209 | 14 | 0 |
285426 | 285426 | 2020-06-29 | Cooper | Missouri | 29053 | 14 | 0 |
285466 | 285466 | 2020-06-29 | Miller | Missouri | 29131 | 14 | 0 |
285505 | 285505 | 2020-06-29 | Stone | Missouri | 29209 | 14 | 0 |
282281 | 282281 | 2020-06-28 | Cooper | Missouri | 29053 | 14 | 0 |
282370 | 282370 | 2020-06-28 | Wright | Missouri | 29229 | 14 | 0 |
279133 | 279133 | 2020-06-27 | Cooper | Missouri | 29053 | 14 | 0 |
279222 | 279222 | 2020-06-27 | Wright | Missouri | 29229 | 14 | 0 |
275985 | 275985 | 2020-06-26 | Cooper | Missouri | 29053 | 14 | 0 |
276017 | 276017 | 2020-06-26 | Linn | Missouri | 29115 | 14 | 1 |
276022 | 276022 | 2020-06-26 | Marion | Missouri | 29127 | 14 | 0 |
276074 | 276074 | 2020-06-26 | Wright | Missouri | 29229 | 14 | 0 |
272842 | 272842 | 2020-06-25 | Cooper | Missouri | 29053 | 14 | 0 |
272874 | 272874 | 2020-06-25 | Linn | Missouri | 29115 | 14 | 1 |
272879 | 272879 | 2020-06-25 | Marion | Missouri | 29127 | 14 | 0 |
272931 | 272931 | 2020-06-25 | Wright | Missouri | 29229 | 14 | 0 |
269735 | 269735 | 2020-06-24 | Linn | Missouri | 29115 | 14 | 1 |
269793 | 269793 | 2020-06-24 | Wright | Missouri | 29229 | 14 | 0 |
266602 | 266602 | 2020-06-23 | Linn | Missouri | 29115 | 14 | 1 |
266635 | 266635 | 2020-06-23 | Ripley | Missouri | 29181 | 14 | 0 |
266660 | 266660 | 2020-06-23 | Wright | Missouri | 29229 | 14 | 0 |
263509 | 263509 | 2020-06-22 | Ripley | Missouri | 29181 | 14 | 0 |
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);