ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 191 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1509625 | 1509625 | 2021-07-12 | Worth | Missouri | 29227 | 191 | 2 |
1506379 | 1506379 | 2021-07-11 | Worth | Missouri | 29227 | 191 | 2 |
1503133 | 1503133 | 2021-07-10 | Worth | Missouri | 29227 | 191 | 2 |
1499887 | 1499887 | 2021-07-09 | Worth | Missouri | 29227 | 191 | 2 |
866858 | 866858 | 2020-12-26 | Schuyler | Missouri | 29197 | 191 | 1 |
863613 | 863613 | 2020-12-25 | Schuyler | Missouri | 29197 | 191 | 1 |
857116 | 857116 | 2020-12-23 | Putnam | Missouri | 29171 | 191 | 1 |
853871 | 853871 | 2020-12-22 | Putnam | Missouri | 29171 | 191 | 1 |
782480 | 782480 | 2020-11-30 | Scotland | Missouri | 29199 | 191 | 1 |
688308 | 688308 | 2020-11-01 | Carter | Missouri | 29035 | 191 | 3 |
688362 | 688362 | 2020-11-01 | Montgomery | Missouri | 29139 | 191 | 1 |
639688 | 639688 | 2020-10-17 | Macon | Missouri | 29121 | 191 | 1 |
597543 | 597543 | 2020-10-04 | Osage | Missouri | 29151 | 191 | 1 |
571576 | 571576 | 2020-09-26 | Grundy | Missouri | 29079 | 191 | 4 |
568336 | 568336 | 2020-09-25 | Henry | Missouri | 29083 | 191 | 4 |
490703 | 490703 | 2020-09-01 | Moniteau | Missouri | 29135 | 191 | 3 |
461657 | 461657 | 2020-08-23 | Washington | Missouri | 29221 | 191 | 1 |
451930 | 451930 | 2020-08-20 | Mississippi | Missouri | 29133 | 191 | 0 |
439061 | 439061 | 2020-08-16 | Stone | Missouri | 29209 | 191 | 1 |
410059 | 410059 | 2020-08-07 | Warren | Missouri | 29219 | 191 | 0 |
406782 | 406782 | 2020-08-06 | Laclede | Missouri | 29105 | 191 | 1 |
393948 | 393948 | 2020-08-02 | Polk | Missouri | 29167 | 191 | 0 |
381075 | 381075 | 2020-07-29 | Perry | Missouri | 29157 | 191 | 3 |
374668 | 374668 | 2020-07-27 | Stoddard | Missouri | 29207 | 191 | 9 |
333030 | 333030 | 2020-07-14 | St. Francois | Missouri | 29187 | 191 | 2 |
313941 | 313941 | 2020-07-08 | Scott | Missouri | 29201 | 191 | 11 |
310693 | 310693 | 2020-07-07 | Cass | Missouri | 29037 | 191 | 9 |
263454 | 263454 | 2020-06-22 | Franklin | Missouri | 29071 | 191 | 18 |
250977 | 250977 | 2020-06-18 | Jasper | Missouri | 29097 | 191 | 0 |
210644 | 210644 | 2020-06-05 | Greene | Missouri | 29077 | 191 | 8 |
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);