ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 78 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
756487 | 756487 | 2020-11-22 | Mercer | Missouri | 29129 | 78 | 0 |
720812 | 720812 | 2020-11-11 | Putnam | Missouri | 29171 | 78 | 1 |
681899 | 681899 | 2020-10-30 | Scotland | Missouri | 29199 | 78 | 1 |
678655 | 678655 | 2020-10-29 | Scotland | Missouri | 29199 | 78 | 1 |
629936 | 629936 | 2020-10-14 | Iron | Missouri | 29093 | 78 | 1 |
571580 | 571580 | 2020-09-26 | Holt | Missouri | 29087 | 78 | 1 |
558590 | 558590 | 2020-09-22 | Caldwell | Missouri | 29025 | 78 | 1 |
555353 | 555353 | 2020-09-21 | Caldwell | Missouri | 29025 | 78 | 1 |
552115 | 552115 | 2020-09-20 | Caldwell | Missouri | 29025 | 78 | 1 |
548935 | 548935 | 2020-09-19 | Montgomery | Missouri | 29139 | 78 | 1 |
542431 | 542431 | 2020-09-17 | Hickory | Missouri | 29085 | 78 | 2 |
539195 | 539195 | 2020-09-16 | Hickory | Missouri | 29085 | 78 | 2 |
523043 | 523043 | 2020-09-11 | Monroe | Missouri | 29137 | 78 | 0 |
519806 | 519806 | 2020-09-10 | Monroe | Missouri | 29137 | 78 | 0 |
516571 | 516571 | 2020-09-09 | Monroe | Missouri | 29137 | 78 | 0 |
510041 | 510041 | 2020-09-07 | Bates | Missouri | 29013 | 78 | 1 |
506808 | 506808 | 2020-09-06 | Bates | Missouri | 29013 | 78 | 1 |
503575 | 503575 | 2020-09-05 | Bates | Missouri | 29013 | 78 | 1 |
497107 | 497107 | 2020-09-03 | Bates | Missouri | 29013 | 78 | 1 |
497141 | 497141 | 2020-09-03 | Harrison | Missouri | 29081 | 78 | 1 |
493908 | 493908 | 2020-09-02 | Harrison | Missouri | 29081 | 78 | 1 |
484244 | 484244 | 2020-08-30 | Osage | Missouri | 29151 | 78 | 1 |
481009 | 481009 | 2020-08-29 | Osage | Missouri | 29151 | 78 | 1 |
474580 | 474580 | 2020-08-27 | Wayne | Missouri | 29223 | 78 | 0 |
464885 | 464885 | 2020-08-24 | Texas | Missouri | 29215 | 78 | 1 |
464892 | 464892 | 2020-08-24 | Wright | Missouri | 29229 | 78 | 0 |
461654 | 461654 | 2020-08-23 | Texas | Missouri | 29215 | 78 | 1 |
461661 | 461661 | 2020-08-23 | Wright | Missouri | 29229 | 78 | 0 |
458323 | 458323 | 2020-08-22 | Barton | Missouri | 29011 | 78 | 0 |
458427 | 458427 | 2020-08-22 | Texas | Missouri | 29215 | 78 | 1 |
455182 | 455182 | 2020-08-21 | Ripley | Missouri | 29181 | 78 | 0 |
442211 | 442211 | 2020-08-17 | Dallas | Missouri | 29059 | 78 | 1 |
419636 | 419636 | 2020-08-10 | Crawford | Missouri | 29055 | 78 | 0 |
413240 | 413240 | 2020-08-08 | Morgan | Missouri | 29141 | 78 | 0 |
410020 | 410020 | 2020-08-07 | Morgan | Missouri | 29141 | 78 | 0 |
403517 | 403517 | 2020-08-05 | Benton | Missouri | 29015 | 78 | 1 |
400376 | 400376 | 2020-08-04 | Pike | Missouri | 29163 | 78 | 1 |
377779 | 377779 | 2020-07-28 | Andrew | Missouri | 29003 | 78 | 1 |
377845 | 377845 | 2020-07-28 | Miller | Missouri | 29131 | 78 | 0 |
364977 | 364977 | 2020-07-24 | Howell | Missouri | 29091 | 78 | 0 |
352229 | 352229 | 2020-07-20 | Webster | Missouri | 29225 | 78 | 1 |
345727 | 345727 | 2020-07-18 | Callaway | Missouri | 29027 | 78 | 1 |
342527 | 342527 | 2020-07-17 | Callaway | Missouri | 29027 | 78 | 1 |
320208 | 320208 | 2020-07-10 | Camden | Missouri | 29029 | 78 | 2 |
291726 | 291726 | 2020-07-01 | Cole | Missouri | 29051 | 78 | 2 |
244808 | 244808 | 2020-06-16 | Sullivan | Missouri | 29211 | 78 | 0 |
241656 | 241656 | 2020-06-15 | McDonald | Missouri | 29119 | 78 | 0 |
226112 | 226112 | 2020-06-10 | Johnson | Missouri | 29101 | 78 | 0 |
223014 | 223014 | 2020-06-09 | Johnson | Missouri | 29101 | 78 | 0 |
219919 | 219919 | 2020-06-08 | Johnson | Missouri | 29101 | 78 | 0 |
216858 | 216858 | 2020-06-07 | Platte | Missouri | 29165 | 78 | 2 |
213770 | 213770 | 2020-06-06 | Platte | Missouri | 29165 | 78 | 2 |
210683 | 210683 | 2020-06-05 | Pettis | Missouri | 29159 | 78 | 1 |
210686 | 210686 | 2020-06-05 | Platte | Missouri | 29165 | 78 | 2 |
207602 | 207602 | 2020-06-04 | Pettis | Missouri | 29159 | 78 | 1 |
204521 | 204521 | 2020-06-03 | Pettis | Missouri | 29159 | 78 | 1 |
192228 | 192228 | 2020-05-30 | Pemiscot | Missouri | 29155 | 78 | 4 |
189189 | 189189 | 2020-05-29 | Stoddard | Missouri | 29207 | 78 | 5 |
167817 | 167817 | 2020-05-22 | Lincoln | Missouri | 29113 | 78 | 1 |
164781 | 164781 | 2020-05-21 | Lincoln | Missouri | 29113 | 78 | 1 |
161752 | 161752 | 2020-05-20 | Lincoln | Missouri | 29113 | 78 | 1 |
158726 | 158726 | 2020-05-19 | Lincoln | Missouri | 29113 | 78 | 1 |
155708 | 155708 | 2020-05-18 | Lincoln | Missouri | 29113 | 78 | 1 |
152694 | 152694 | 2020-05-17 | Lincoln | Missouri | 29113 | 78 | 1 |
149683 | 149683 | 2020-05-16 | Lincoln | Missouri | 29113 | 78 | 1 |
125762 | 125762 | 2020-05-08 | Scott | Missouri | 29201 | 78 | 5 |
60538 | 60538 | 2020-04-15 | Greene | Missouri | 29077 | 78 | 8 |
44493 | 44493 | 2020-04-09 | Boone | Missouri | 29019 | 78 | 1 |
41916 | 41916 | 2020-04-08 | Boone | Missouri | 29019 | 78 | 1 |
14955 | 14955 | 2020-03-27 | Kansas City | Missouri | 78 | 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);