ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
282 rows where cases = 11 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 |
---|---|---|---|---|---|---|---|
481047 | 481047 | 2020-08-29 | Worth | Missouri | 29227 | 11 | 0 |
477815 | 477815 | 2020-08-28 | Worth | Missouri | 29227 | 11 | 0 |
422897 | 422897 | 2020-08-11 | Mercer | Missouri | 29129 | 11 | 0 |
422925 | 422925 | 2020-08-11 | Schuyler | Missouri | 29197 | 11 | 0 |
419675 | 419675 | 2020-08-10 | Mercer | Missouri | 29129 | 11 | 0 |
419703 | 419703 | 2020-08-10 | Schuyler | Missouri | 29197 | 11 | 0 |
416420 | 416420 | 2020-08-09 | Dent | Missouri | 29065 | 11 | 0 |
416454 | 416454 | 2020-08-09 | Mercer | Missouri | 29129 | 11 | 0 |
416482 | 416482 | 2020-08-09 | Schuyler | Missouri | 29197 | 11 | 0 |
403576 | 403576 | 2020-08-05 | Mercer | Missouri | 29129 | 11 | 0 |
390648 | 390648 | 2020-08-01 | Atchison | Missouri | 29005 | 11 | 0 |
390699 | 390699 | 2020-08-01 | Knox | Missouri | 29103 | 11 | 0 |
387431 | 387431 | 2020-07-31 | Atchison | Missouri | 29005 | 11 | 0 |
387451 | 387451 | 2020-07-31 | Clark | Missouri | 29045 | 11 | 0 |
387492 | 387492 | 2020-07-31 | Maries | Missouri | 29125 | 11 | 0 |
384213 | 384213 | 2020-07-30 | Atchison | Missouri | 29005 | 11 | 0 |
384274 | 384274 | 2020-07-30 | Maries | Missouri | 29125 | 11 | 0 |
384309 | 384309 | 2020-07-30 | Shelby | Missouri | 29205 | 11 | 0 |
380997 | 380997 | 2020-07-29 | Atchison | Missouri | 29005 | 11 | 0 |
381093 | 381093 | 2020-07-29 | Shelby | Missouri | 29205 | 11 | 0 |
377780 | 377780 | 2020-07-28 | Atchison | Missouri | 29005 | 11 | 0 |
377806 | 377806 | 2020-07-28 | Dade | Missouri | 29057 | 11 | 0 |
377841 | 377841 | 2020-07-28 | Maries | Missouri | 29125 | 11 | 0 |
377848 | 377848 | 2020-07-28 | Monroe | Missouri | 29137 | 11 | 0 |
377873 | 377873 | 2020-07-28 | Scotland | Missouri | 29199 | 11 | 1 |
377876 | 377876 | 2020-07-28 | Shelby | Missouri | 29205 | 11 | 0 |
374626 | 374626 | 2020-07-27 | Maries | Missouri | 29125 | 11 | 0 |
374658 | 374658 | 2020-07-27 | Scotland | Missouri | 29199 | 11 | 1 |
374661 | 374661 | 2020-07-27 | Shelby | Missouri | 29205 | 11 | 0 |
371446 | 371446 | 2020-07-26 | Scotland | Missouri | 29199 | 11 | 1 |
368235 | 368235 | 2020-07-25 | Scotland | Missouri | 29199 | 11 | 1 |
364934 | 364934 | 2020-07-24 | Atchison | Missouri | 29005 | 11 | 0 |
365027 | 365027 | 2020-07-24 | Scotland | Missouri | 29199 | 11 | 1 |
361801 | 361801 | 2020-07-23 | Oregon | Missouri | 29149 | 11 | 0 |
361820 | 361820 | 2020-07-23 | Scotland | Missouri | 29199 | 11 | 1 |
358596 | 358596 | 2020-07-22 | Oregon | Missouri | 29149 | 11 | 0 |
358615 | 358615 | 2020-07-22 | Scotland | Missouri | 29199 | 11 | 1 |
358620 | 358620 | 2020-07-22 | St. Clair | Missouri | 29185 | 11 | 0 |
355393 | 355393 | 2020-07-21 | Oregon | Missouri | 29149 | 11 | 0 |
355412 | 355412 | 2020-07-21 | Scotland | Missouri | 29199 | 11 | 1 |
352177 | 352177 | 2020-07-20 | Madison | Missouri | 29123 | 11 | 0 |
352203 | 352203 | 2020-07-20 | Ralls | Missouri | 29173 | 11 | 0 |
352210 | 352210 | 2020-07-20 | Scotland | Missouri | 29199 | 11 | 1 |
352215 | 352215 | 2020-07-20 | St. Clair | Missouri | 29185 | 11 | 0 |
349003 | 349003 | 2020-07-19 | Ralls | Missouri | 29173 | 11 | 0 |
349010 | 349010 | 2020-07-19 | Scotland | Missouri | 29199 | 11 | 1 |
345809 | 345809 | 2020-07-18 | Scotland | Missouri | 29199 | 11 | 1 |
342534 | 342534 | 2020-07-17 | Chariton | Missouri | 29041 | 11 | 0 |
342558 | 342558 | 2020-07-17 | Howard | Missouri | 29089 | 11 | 0 |
342605 | 342605 | 2020-07-17 | Reynolds | Missouri | 29179 | 11 | 0 |
342609 | 342609 | 2020-07-17 | Scotland | Missouri | 29199 | 11 | 1 |
339409 | 339409 | 2020-07-16 | Reynolds | Missouri | 29179 | 11 | 0 |
339413 | 339413 | 2020-07-16 | Scotland | Missouri | 29199 | 11 | 1 |
336152 | 336152 | 2020-07-15 | Daviess | Missouri | 29061 | 11 | 0 |
336217 | 336217 | 2020-07-15 | Scotland | Missouri | 29199 | 11 | 1 |
332959 | 332959 | 2020-07-14 | Daviess | Missouri | 29061 | 11 | 0 |
333024 | 333024 | 2020-07-14 | Scotland | Missouri | 29199 | 11 | 1 |
329772 | 329772 | 2020-07-13 | Daviess | Missouri | 29061 | 11 | 0 |
329837 | 329837 | 2020-07-13 | Scotland | Missouri | 29199 | 11 | 1 |
329851 | 329851 | 2020-07-13 | Texas | Missouri | 29215 | 11 | 0 |
326586 | 326586 | 2020-07-12 | Daviess | Missouri | 29061 | 11 | 0 |
326651 | 326651 | 2020-07-12 | Scotland | Missouri | 29199 | 11 | 1 |
326665 | 326665 | 2020-07-12 | Texas | Missouri | 29215 | 11 | 0 |
323403 | 323403 | 2020-07-11 | Daviess | Missouri | 29061 | 11 | 0 |
323468 | 323468 | 2020-07-11 | Scotland | Missouri | 29199 | 11 | 1 |
323482 | 323482 | 2020-07-11 | Texas | Missouri | 29215 | 11 | 0 |
320224 | 320224 | 2020-07-10 | Daviess | Missouri | 29061 | 11 | 0 |
320227 | 320227 | 2020-07-10 | Douglas | Missouri | 29067 | 11 | 0 |
320289 | 320289 | 2020-07-10 | Scotland | Missouri | 29199 | 11 | 1 |
320303 | 320303 | 2020-07-10 | Texas | Missouri | 29215 | 11 | 0 |
317049 | 317049 | 2020-07-09 | Daviess | Missouri | 29061 | 11 | 0 |
317096 | 317096 | 2020-07-09 | Osage | Missouri | 29151 | 11 | 0 |
317114 | 317114 | 2020-07-09 | Scotland | Missouri | 29199 | 11 | 1 |
313922 | 313922 | 2020-07-08 | Osage | Missouri | 29151 | 11 | 0 |
313940 | 313940 | 2020-07-08 | Scotland | Missouri | 29199 | 11 | 1 |
310769 | 310769 | 2020-07-07 | Scotland | Missouri | 29199 | 11 | 1 |
307526 | 307526 | 2020-07-06 | Cedar | Missouri | 29039 | 11 | 0 |
307601 | 307601 | 2020-07-06 | Scotland | Missouri | 29199 | 11 | 1 |
304359 | 304359 | 2020-07-05 | Cedar | Missouri | 29039 | 11 | 0 |
304434 | 304434 | 2020-07-05 | Scotland | Missouri | 29199 | 11 | 1 |
301195 | 301195 | 2020-07-04 | Cedar | Missouri | 29039 | 11 | 0 |
301270 | 301270 | 2020-07-04 | Scotland | Missouri | 29199 | 11 | 1 |
298032 | 298032 | 2020-07-03 | Cedar | Missouri | 29039 | 11 | 0 |
298107 | 298107 | 2020-07-03 | Scotland | Missouri | 29199 | 11 | 1 |
294867 | 294867 | 2020-07-02 | Caldwell | Missouri | 29025 | 11 | 0 |
294949 | 294949 | 2020-07-02 | Scotland | Missouri | 29199 | 11 | 1 |
294951 | 294951 | 2020-07-02 | Shannon | Missouri | 29203 | 11 | 0 |
291795 | 291795 | 2020-07-01 | Scotland | Missouri | 29199 | 11 | 1 |
288566 | 288566 | 2020-06-30 | Carroll | Missouri | 29033 | 11 | 0 |
288644 | 288644 | 2020-06-30 | Scotland | Missouri | 29199 | 11 | 1 |
285416 | 285416 | 2020-06-29 | Carroll | Missouri | 29033 | 11 | 0 |
285494 | 285494 | 2020-06-29 | Scotland | Missouri | 29199 | 11 | 1 |
282271 | 282271 | 2020-06-28 | Carroll | Missouri | 29033 | 11 | 0 |
282282 | 282282 | 2020-06-28 | Crawford | Missouri | 29055 | 11 | 0 |
282291 | 282291 | 2020-06-28 | Gasconade | Missouri | 29073 | 11 | 0 |
282314 | 282314 | 2020-06-28 | Livingston | Missouri | 29117 | 11 | 0 |
282349 | 282349 | 2020-06-28 | Scotland | Missouri | 29199 | 11 | 1 |
279123 | 279123 | 2020-06-27 | Carroll | Missouri | 29033 | 11 | 0 |
279134 | 279134 | 2020-06-27 | Crawford | Missouri | 29055 | 11 | 0 |
279138 | 279138 | 2020-06-27 | DeKalb | Missouri | 29063 | 11 | 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);