ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where cases = 22 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Schuyler 13
- Jasper 11
- Grundy 9
- Christian 7
- Chariton 6
- Worth 6
- Iron 5
- Scotland 5
- Linn 4
- McDonald 4
- Stone 4
- Warren 4
- Atchison 3
- Benton 3
- Montgomery 3
- Reynolds 3
- Buchanan 2
- Callaway 2
- Carter 2
- Crawford 2
- Dade 2
- Daviess 2
- Douglas 2
- Mercer 2
- Miller 2
- Pike 2
- Polk 2
- Saline 2
- St. Francois 2
- Ste. Genevieve 2
- …
state 1
- Missouri · 145 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
626761 | 626761 | 2020-10-13 | Worth | Missouri | 29227 | 22 | 0 |
623519 | 623519 | 2020-10-12 | Worth | Missouri | 29227 | 22 | 0 |
620276 | 620276 | 2020-10-11 | Worth | Missouri | 29227 | 22 | 0 |
617034 | 617034 | 2020-10-10 | Worth | Missouri | 29227 | 22 | 0 |
613793 | 613793 | 2020-10-09 | Worth | Missouri | 29227 | 22 | 0 |
610551 | 610551 | 2020-10-08 | Worth | Missouri | 29227 | 22 | 0 |
571631 | 571631 | 2020-09-26 | Schuyler | Missouri | 29197 | 22 | 0 |
568389 | 568389 | 2020-09-25 | Schuyler | Missouri | 29197 | 22 | 0 |
565149 | 565149 | 2020-09-24 | Schuyler | Missouri | 29197 | 22 | 0 |
561909 | 561909 | 2020-09-23 | Schuyler | Missouri | 29197 | 22 | 0 |
558672 | 558672 | 2020-09-22 | Schuyler | Missouri | 29197 | 22 | 0 |
555435 | 555435 | 2020-09-21 | Schuyler | Missouri | 29197 | 22 | 0 |
552197 | 552197 | 2020-09-20 | Schuyler | Missouri | 29197 | 22 | 0 |
548958 | 548958 | 2020-09-19 | Schuyler | Missouri | 29197 | 22 | 0 |
542483 | 542483 | 2020-09-17 | Schuyler | Missouri | 29197 | 22 | 0 |
539247 | 539247 | 2020-09-16 | Schuyler | Missouri | 29197 | 22 | 0 |
536010 | 536010 | 2020-09-15 | Schuyler | Missouri | 29197 | 22 | 0 |
532775 | 532775 | 2020-09-14 | Schuyler | Missouri | 29197 | 22 | 0 |
529539 | 529539 | 2020-09-13 | Schuyler | Missouri | 29197 | 22 | 0 |
523068 | 523068 | 2020-09-11 | Scotland | Missouri | 29199 | 22 | 1 |
519831 | 519831 | 2020-09-10 | Scotland | Missouri | 29199 | 22 | 1 |
516596 | 516596 | 2020-09-09 | Scotland | Missouri | 29199 | 22 | 1 |
513362 | 513362 | 2020-09-08 | Scotland | Missouri | 29199 | 22 | 1 |
510130 | 510130 | 2020-09-07 | Scotland | Missouri | 29199 | 22 | 1 |
500401 | 500401 | 2020-09-04 | Mercer | Missouri | 29129 | 22 | 0 |
497167 | 497167 | 2020-09-03 | Mercer | Missouri | 29129 | 22 | 0 |
490725 | 490725 | 2020-09-01 | Reynolds | Missouri | 29179 | 22 | 0 |
487492 | 487492 | 2020-08-31 | Reynolds | Missouri | 29179 | 22 | 0 |
484258 | 484258 | 2020-08-30 | Reynolds | Missouri | 29179 | 22 | 0 |
480962 | 480962 | 2020-08-29 | Daviess | Missouri | 29061 | 22 | 0 |
477730 | 477730 | 2020-08-28 | Daviess | Missouri | 29061 | 22 | 0 |
477787 | 477787 | 2020-08-28 | Putnam | Missouri | 29171 | 22 | 1 |
474495 | 474495 | 2020-08-27 | Dade | Missouri | 29057 | 22 | 0 |
471237 | 471237 | 2020-08-26 | Atchison | Missouri | 29005 | 22 | 0 |
471263 | 471263 | 2020-08-26 | Dade | Missouri | 29057 | 22 | 0 |
464796 | 464796 | 2020-08-24 | Chariton | Missouri | 29041 | 22 | 0 |
461547 | 461547 | 2020-08-23 | Atchison | Missouri | 29005 | 22 | 0 |
461565 | 461565 | 2020-08-23 | Chariton | Missouri | 29041 | 22 | 0 |
458320 | 458320 | 2020-08-22 | Atchison | Missouri | 29005 | 22 | 0 |
458338 | 458338 | 2020-08-22 | Chariton | Missouri | 29041 | 22 | 0 |
455110 | 455110 | 2020-08-21 | Chariton | Missouri | 29041 | 22 | 0 |
451882 | 451882 | 2020-08-20 | Chariton | Missouri | 29041 | 22 | 0 |
448654 | 448654 | 2020-08-19 | Chariton | Missouri | 29041 | 22 | 0 |
445440 | 445440 | 2020-08-18 | Dent | Missouri | 29065 | 22 | 0 |
435747 | 435747 | 2020-08-15 | Carter | Missouri | 29035 | 22 | 1 |
426099 | 426099 | 2020-08-12 | Iron | Missouri | 29093 | 22 | 0 |
422848 | 422848 | 2020-08-11 | Carter | Missouri | 29035 | 22 | 1 |
422877 | 422877 | 2020-08-11 | Iron | Missouri | 29093 | 22 | 0 |
419655 | 419655 | 2020-08-10 | Iron | Missouri | 29093 | 22 | 0 |
416434 | 416434 | 2020-08-09 | Iron | Missouri | 29093 | 22 | 0 |
403556 | 403556 | 2020-08-05 | Iron | Missouri | 29093 | 22 | 0 |
400363 | 400363 | 2020-08-04 | Monroe | Missouri | 29137 | 22 | 0 |
358551 | 358551 | 2020-07-22 | DeKalb | Missouri | 29063 | 22 | 1 |
355356 | 355356 | 2020-07-21 | Grundy | Missouri | 29079 | 22 | 1 |
352154 | 352154 | 2020-07-20 | Grundy | Missouri | 29079 | 22 | 1 |
352192 | 352192 | 2020-07-20 | Osage | Missouri | 29151 | 22 | 0 |
348954 | 348954 | 2020-07-19 | Grundy | Missouri | 29079 | 22 | 1 |
348974 | 348974 | 2020-07-19 | Linn | Missouri | 29115 | 22 | 1 |
345747 | 345747 | 2020-07-18 | Douglas | Missouri | 29067 | 22 | 1 |
345753 | 345753 | 2020-07-18 | Grundy | Missouri | 29079 | 22 | 1 |
342547 | 342547 | 2020-07-17 | Douglas | Missouri | 29067 | 22 | 0 |
342553 | 342553 | 2020-07-17 | Grundy | Missouri | 29079 | 22 | 1 |
339357 | 339357 | 2020-07-16 | Grundy | Missouri | 29079 | 22 | 1 |
339377 | 339377 | 2020-07-16 | Linn | Missouri | 29115 | 22 | 1 |
336151 | 336151 | 2020-07-15 | Dallas | Missouri | 29059 | 22 | 1 |
336161 | 336161 | 2020-07-15 | Grundy | Missouri | 29079 | 22 | 1 |
336181 | 336181 | 2020-07-15 | Linn | Missouri | 29115 | 22 | 1 |
336214 | 336214 | 2020-07-15 | Ripley | Missouri | 29181 | 22 | 0 |
332968 | 332968 | 2020-07-14 | Grundy | Missouri | 29079 | 22 | 1 |
332988 | 332988 | 2020-07-14 | Linn | Missouri | 29115 | 22 | 1 |
333000 | 333000 | 2020-07-14 | Montgomery | Missouri | 29139 | 22 | 0 |
333014 | 333014 | 2020-07-14 | Polk | Missouri | 29167 | 22 | 0 |
329769 | 329769 | 2020-07-13 | Crawford | Missouri | 29055 | 22 | 0 |
329781 | 329781 | 2020-07-13 | Grundy | Missouri | 29079 | 22 | 1 |
329827 | 329827 | 2020-07-13 | Polk | Missouri | 29167 | 22 | 0 |
329848 | 329848 | 2020-07-13 | Stone | Missouri | 29209 | 22 | 0 |
326563 | 326563 | 2020-07-12 | Benton | Missouri | 29015 | 22 | 0 |
326564 | 326564 | 2020-07-12 | Bollinger | Missouri | 29017 | 22 | 0 |
326583 | 326583 | 2020-07-12 | Crawford | Missouri | 29055 | 22 | 0 |
326627 | 326627 | 2020-07-12 | Montgomery | Missouri | 29139 | 22 | 0 |
326662 | 326662 | 2020-07-12 | Stone | Missouri | 29209 | 22 | 0 |
323380 | 323380 | 2020-07-11 | Benton | Missouri | 29015 | 22 | 0 |
323444 | 323444 | 2020-07-11 | Montgomery | Missouri | 29139 | 22 | 0 |
323479 | 323479 | 2020-07-11 | Stone | Missouri | 29209 | 22 | 0 |
320201 | 320201 | 2020-07-10 | Benton | Missouri | 29015 | 22 | 0 |
320235 | 320235 | 2020-07-10 | Henry | Missouri | 29083 | 22 | 3 |
320300 | 320300 | 2020-07-10 | Stone | Missouri | 29209 | 22 | 0 |
317086 | 317086 | 2020-07-09 | Miller | Missouri | 29131 | 22 | 0 |
313912 | 313912 | 2020-07-08 | Miller | Missouri | 29131 | 22 | 0 |
313949 | 313949 | 2020-07-08 | Ste. Genevieve | Missouri | 29186 | 22 | 1 |
310746 | 310746 | 2020-07-07 | Morgan | Missouri | 29141 | 22 | 0 |
310771 | 310771 | 2020-07-07 | Shannon | Missouri | 29203 | 22 | 0 |
310778 | 310778 | 2020-07-07 | Ste. Genevieve | Missouri | 29186 | 22 | 1 |
301291 | 301291 | 2020-07-04 | Wright | Missouri | 29229 | 22 | 0 |
298087 | 298087 | 2020-07-03 | Nodaway | Missouri | 29147 | 22 | 0 |
282260 | 282260 | 2020-06-28 | Barton | Missouri | 29011 | 22 | 0 |
276040 | 276040 | 2020-06-26 | Phelps | Missouri | 29161 | 22 | 0 |
266658 | 266658 | 2020-06-23 | Webster | Missouri | 29225 | 22 | 1 |
254069 | 254069 | 2020-06-19 | Clinton | Missouri | 29049 | 22 | 0 |
219940 | 219940 | 2020-06-08 | New Madrid | Missouri | 29143 | 22 | 1 |
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);