ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 16 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 |
---|---|---|---|---|---|---|---|
519851 | 519851 | 2020-09-10 | Worth | Missouri | 29227 | 16 | 0 |
516616 | 516616 | 2020-09-09 | Worth | Missouri | 29227 | 16 | 0 |
513382 | 513382 | 2020-09-08 | Worth | Missouri | 29227 | 16 | 0 |
510150 | 510150 | 2020-09-07 | Worth | Missouri | 29227 | 16 | 0 |
477766 | 477766 | 2020-08-28 | Mercer | Missouri | 29129 | 16 | 0 |
477794 | 477794 | 2020-08-28 | Schuyler | Missouri | 29197 | 16 | 0 |
474533 | 474533 | 2020-08-27 | Mercer | Missouri | 29129 | 16 | 0 |
451949 | 451949 | 2020-08-20 | Putnam | Missouri | 29171 | 16 | 1 |
448721 | 448721 | 2020-08-19 | Putnam | Missouri | 29171 | 16 | 1 |
448725 | 448725 | 2020-08-19 | Reynolds | Missouri | 29179 | 16 | 0 |
445486 | 445486 | 2020-08-18 | Ozark | Missouri | 29153 | 16 | 0 |
445499 | 445499 | 2020-08-18 | Reynolds | Missouri | 29179 | 16 | 0 |
442260 | 442260 | 2020-08-17 | Ozark | Missouri | 29153 | 16 | 0 |
442273 | 442273 | 2020-08-17 | Reynolds | Missouri | 29179 | 16 | 0 |
439033 | 439033 | 2020-08-16 | Ozark | Missouri | 29153 | 16 | 0 |
439046 | 439046 | 2020-08-16 | Reynolds | Missouri | 29179 | 16 | 0 |
435808 | 435808 | 2020-08-15 | Ozark | Missouri | 29153 | 16 | 0 |
435821 | 435821 | 2020-08-15 | Reynolds | Missouri | 29179 | 16 | 0 |
432582 | 432582 | 2020-08-14 | Ozark | Missouri | 29153 | 16 | 0 |
432595 | 432595 | 2020-08-14 | Reynolds | Missouri | 29179 | 16 | 0 |
432599 | 432599 | 2020-08-14 | Scotland | Missouri | 29199 | 16 | 1 |
429309 | 429309 | 2020-08-13 | Dent | Missouri | 29065 | 16 | 0 |
429355 | 429355 | 2020-08-13 | Ozark | Missouri | 29153 | 16 | 0 |
429368 | 429368 | 2020-08-13 | Reynolds | Missouri | 29179 | 16 | 0 |
429372 | 429372 | 2020-08-13 | Scotland | Missouri | 29199 | 16 | 1 |
426129 | 426129 | 2020-08-12 | Oregon | Missouri | 29149 | 16 | 0 |
426144 | 426144 | 2020-08-12 | Reynolds | Missouri | 29179 | 16 | 0 |
422907 | 422907 | 2020-08-11 | Oregon | Missouri | 29149 | 16 | 0 |
422922 | 422922 | 2020-08-11 | Reynolds | Missouri | 29179 | 16 | 0 |
419685 | 419685 | 2020-08-10 | Oregon | Missouri | 29149 | 16 | 0 |
419700 | 419700 | 2020-08-10 | Reynolds | Missouri | 29179 | 16 | 0 |
419704 | 419704 | 2020-08-10 | Scotland | Missouri | 29199 | 16 | 1 |
416464 | 416464 | 2020-08-09 | Oregon | Missouri | 29149 | 16 | 0 |
416479 | 416479 | 2020-08-09 | Reynolds | Missouri | 29179 | 16 | 0 |
413259 | 413259 | 2020-08-08 | Reynolds | Missouri | 29179 | 16 | 0 |
410039 | 410039 | 2020-08-07 | Reynolds | Missouri | 29179 | 16 | 0 |
406748 | 406748 | 2020-08-06 | Chariton | Missouri | 29041 | 16 | 0 |
406819 | 406819 | 2020-08-06 | Reynolds | Missouri | 29179 | 16 | 0 |
403530 | 403530 | 2020-08-05 | Chariton | Missouri | 29041 | 16 | 0 |
403601 | 403601 | 2020-08-05 | Reynolds | Missouri | 29179 | 16 | 0 |
400384 | 400384 | 2020-08-04 | Reynolds | Missouri | 29179 | 16 | 0 |
397099 | 397099 | 2020-08-03 | Chariton | Missouri | 29041 | 16 | 0 |
397170 | 397170 | 2020-08-03 | Reynolds | Missouri | 29179 | 16 | 0 |
393909 | 393909 | 2020-08-02 | Iron | Missouri | 29093 | 16 | 0 |
393954 | 393954 | 2020-08-02 | Reynolds | Missouri | 29179 | 16 | 0 |
390688 | 390688 | 2020-08-01 | Hickory | Missouri | 29085 | 16 | 0 |
390737 | 390737 | 2020-08-01 | Reynolds | Missouri | 29179 | 16 | 0 |
387471 | 387471 | 2020-07-31 | Hickory | Missouri | 29085 | 16 | 0 |
384253 | 384253 | 2020-07-30 | Hickory | Missouri | 29085 | 16 | 0 |
384273 | 384273 | 2020-07-30 | Madison | Missouri | 29123 | 16 | 0 |
384302 | 384302 | 2020-07-30 | Reynolds | Missouri | 29179 | 16 | 0 |
381057 | 381057 | 2020-07-29 | Madison | Missouri | 29123 | 16 | 0 |
374625 | 374625 | 2020-07-27 | Madison | Missouri | 29123 | 16 | 0 |
371439 | 371439 | 2020-07-26 | Ralls | Missouri | 29173 | 16 | 0 |
368228 | 368228 | 2020-07-25 | Ralls | Missouri | 29173 | 16 | 0 |
364962 | 364962 | 2020-07-24 | Daviess | Missouri | 29061 | 16 | 0 |
365020 | 365020 | 2020-07-24 | Ralls | Missouri | 29173 | 16 | 0 |
361755 | 361755 | 2020-07-23 | Daviess | Missouri | 29061 | 16 | 0 |
361813 | 361813 | 2020-07-23 | Ralls | Missouri | 29173 | 16 | 0 |
358629 | 358629 | 2020-07-22 | Texas | Missouri | 29215 | 16 | 0 |
355426 | 355426 | 2020-07-21 | Texas | Missouri | 29215 | 16 | 0 |
352224 | 352224 | 2020-07-20 | Texas | Missouri | 29215 | 16 | 0 |
349024 | 349024 | 2020-07-19 | Texas | Missouri | 29215 | 16 | 0 |
345823 | 345823 | 2020-07-18 | Texas | Missouri | 29215 | 16 | 0 |
342623 | 342623 | 2020-07-17 | Texas | Missouri | 29215 | 16 | 0 |
339337 | 339337 | 2020-07-16 | Cedar | Missouri | 29039 | 16 | 0 |
336128 | 336128 | 2020-07-15 | Bates | Missouri | 29013 | 16 | 1 |
332935 | 332935 | 2020-07-14 | Bates | Missouri | 29013 | 16 | 1 |
332962 | 332962 | 2020-07-14 | Douglas | Missouri | 29067 | 16 | 0 |
329773 | 329773 | 2020-07-13 | DeKalb | Missouri | 29063 | 16 | 0 |
326587 | 326587 | 2020-07-12 | DeKalb | Missouri | 29063 | 16 | 0 |
323404 | 323404 | 2020-07-11 | DeKalb | Missouri | 29063 | 16 | 0 |
320225 | 320225 | 2020-07-10 | DeKalb | Missouri | 29063 | 16 | 0 |
313874 | 313874 | 2020-07-08 | Dallas | Missouri | 29059 | 16 | 1 |
310683 | 310683 | 2020-07-07 | Bollinger | Missouri | 29017 | 16 | 0 |
310759 | 310759 | 2020-07-07 | Polk | Missouri | 29167 | 16 | 0 |
304356 | 304356 | 2020-07-05 | Carroll | Missouri | 29033 | 16 | 0 |
304399 | 304399 | 2020-07-05 | Livingston | Missouri | 29117 | 16 | 0 |
301192 | 301192 | 2020-07-04 | Carroll | Missouri | 29033 | 16 | 0 |
301203 | 301203 | 2020-07-04 | Crawford | Missouri | 29055 | 16 | 0 |
301235 | 301235 | 2020-07-04 | Livingston | Missouri | 29117 | 16 | 0 |
294881 | 294881 | 2020-07-02 | Cooper | Missouri | 29053 | 16 | 0 |
294913 | 294913 | 2020-07-02 | Linn | Missouri | 29115 | 16 | 1 |
294939 | 294939 | 2020-07-02 | Polk | Missouri | 29167 | 16 | 0 |
294960 | 294960 | 2020-07-02 | Stone | Missouri | 29209 | 16 | 0 |
291759 | 291759 | 2020-07-01 | Linn | Missouri | 29115 | 16 | 1 |
291785 | 291785 | 2020-07-01 | Polk | Missouri | 29167 | 16 | 0 |
288608 | 288608 | 2020-06-30 | Linn | Missouri | 29115 | 16 | 1 |
285458 | 285458 | 2020-06-29 | Linn | Missouri | 29115 | 16 | 1 |
285463 | 285463 | 2020-06-29 | Marion | Missouri | 29127 | 16 | 0 |
285470 | 285470 | 2020-06-29 | Montgomery | Missouri | 29139 | 16 | 0 |
285509 | 285509 | 2020-06-29 | Vernon | Missouri | 29217 | 16 | 0 |
282313 | 282313 | 2020-06-28 | Linn | Missouri | 29115 | 16 | 1 |
282318 | 282318 | 2020-06-28 | Marion | Missouri | 29127 | 16 | 0 |
282325 | 282325 | 2020-06-28 | Montgomery | Missouri | 29139 | 16 | 0 |
282364 | 282364 | 2020-06-28 | Vernon | Missouri | 29217 | 16 | 0 |
279177 | 279177 | 2020-06-27 | Montgomery | Missouri | 29139 | 16 | 0 |
279216 | 279216 | 2020-06-27 | Vernon | Missouri | 29217 | 16 | 0 |
276029 | 276029 | 2020-06-26 | Montgomery | Missouri | 29139 | 16 | 0 |
276068 | 276068 | 2020-06-26 | Vernon | Missouri | 29217 | 16 | 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);