ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 185 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1447953 | 1447953 | 2021-06-23 | Worth | Missouri | 29227 | 185 | 2 |
857123 | 857123 | 2020-12-23 | Schuyler | Missouri | 29197 | 185 | 1 |
701324 | 701324 | 2020-11-05 | Linn | Missouri | 29115 | 185 | 7 |
678577 | 678577 | 2020-10-29 | Carter | Missouri | 29035 | 185 | 3 |
668896 | 668896 | 2020-10-26 | Maries | Missouri | 29125 | 185 | 0 |
639724 | 639724 | 2020-10-17 | Shannon | Missouri | 29203 | 185 | 3 |
594269 | 594269 | 2020-10-03 | Howard | Missouri | 29089 | 185 | 2 |
574785 | 574785 | 2020-09-27 | Barton | Missouri | 29011 | 185 | 0 |
574890 | 574890 | 2020-09-27 | Vernon | Missouri | 29217 | 185 | 1 |
565084 | 565084 | 2020-09-24 | Dallas | Missouri | 29059 | 185 | 1 |
565162 | 565162 | 2020-09-24 | Sullivan | Missouri | 29211 | 185 | 0 |
561922 | 561922 | 2020-09-23 | Sullivan | Missouri | 29211 | 185 | 0 |
558685 | 558685 | 2020-09-22 | Sullivan | Missouri | 29211 | 185 | 0 |
555448 | 555448 | 2020-09-21 | Sullivan | Missouri | 29211 | 185 | 0 |
552210 | 552210 | 2020-09-20 | Sullivan | Missouri | 29211 | 185 | 0 |
548971 | 548971 | 2020-09-19 | Sullivan | Missouri | 29211 | 185 | 0 |
535940 | 535940 | 2020-09-15 | Clinton | Missouri | 29049 | 185 | 0 |
536023 | 536023 | 2020-09-15 | Sullivan | Missouri | 29211 | 185 | 0 |
532770 | 532770 | 2020-09-14 | Randolph | Missouri | 29175 | 185 | 1 |
532788 | 532788 | 2020-09-14 | Sullivan | Missouri | 29211 | 185 | 0 |
526318 | 526318 | 2020-09-12 | Texas | Missouri | 29215 | 185 | 2 |
468119 | 468119 | 2020-08-25 | Webster | Missouri | 29225 | 185 | 1 |
403621 | 403621 | 2020-08-05 | Warren | Missouri | 29219 | 185 | 0 |
361746 | 361746 | 2020-07-23 | Christian | Missouri | 29043 | 185 | 1 |
361783 | 361783 | 2020-07-23 | Lincoln | Missouri | 29113 | 185 | 1 |
361805 | 361805 | 2020-07-23 | Perry | Missouri | 29157 | 185 | 3 |
361830 | 361830 | 2020-07-23 | Stoddard | Missouri | 29207 | 185 | 9 |
358541 | 358541 | 2020-07-22 | Christian | Missouri | 29043 | 185 | 1 |
333010 | 333010 | 2020-07-14 | Pettis | Missouri | 29159 | 185 | 2 |
307525 | 307525 | 2020-07-06 | Cass | Missouri | 29037 | 185 | 9 |
307556 | 307556 | 2020-07-06 | Johnson | Missouri | 29101 | 185 | 0 |
307602 | 307602 | 2020-07-06 | Scott | Missouri | 29201 | 185 | 11 |
108141 | 108141 | 2020-05-02 | Buchanan | Missouri | 29021 | 185 | 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);