ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 659 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2172534 | 2172534 | 2022-02-01 | Schuyler | Missouri | 29197 | 659 | 24 |
1925428 | 1925428 | 2021-11-17 | Putnam | Missouri | 29171 | 659 | 11 |
1597219 | 1597219 | 2021-08-08 | Carter | Missouri | 29035 | 659 | 11 |
1493342 | 1493342 | 2021-07-07 | Maries | Missouri | 29125 | 659 | 8 |
1490095 | 1490095 | 2021-07-06 | Maries | Missouri | 29125 | 659 | 8 |
1486848 | 1486848 | 2021-07-05 | Maries | Missouri | 29125 | 659 | 8 |
1408967 | 1408967 | 2021-06-11 | Ozark | Missouri | 29153 | 659 | 21 |
1405686 | 1405686 | 2021-06-10 | Hickory | Missouri | 29085 | 659 | 15 |
1405722 | 1405722 | 2021-06-10 | Ozark | Missouri | 29153 | 659 | 21 |
1373287 | 1373287 | 2021-05-31 | Shelby | Missouri | 29205 | 659 | 7 |
1370042 | 1370042 | 2021-05-30 | Shelby | Missouri | 29205 | 659 | 7 |
1366796 | 1366796 | 2021-05-29 | Shelby | Missouri | 29205 | 659 | 7 |
1363550 | 1363550 | 2021-05-28 | Shelby | Missouri | 29205 | 659 | 7 |
1126433 | 1126433 | 2021-03-16 | Chariton | Missouri | 29041 | 659 | 6 |
1123187 | 1123187 | 2021-03-15 | Chariton | Missouri | 29041 | 659 | 6 |
1119940 | 1119940 | 2021-03-14 | Chariton | Missouri | 29041 | 659 | 6 |
1012829 | 1012829 | 2021-02-09 | Cedar | Missouri | 29039 | 659 | 11 |
990165 | 990165 | 2021-02-02 | Oregon | Missouri | 29149 | 659 | 3 |
983671 | 983671 | 2021-01-31 | Oregon | Missouri | 29149 | 659 | 3 |
980425 | 980425 | 2021-01-30 | Oregon | Missouri | 29149 | 659 | 3 |
977179 | 977179 | 2021-01-29 | Oregon | Missouri | 29149 | 659 | 3 |
973934 | 973934 | 2021-01-28 | Oregon | Missouri | 29149 | 659 | 3 |
921971 | 921971 | 2021-01-12 | Gentry | Missouri | 29075 | 659 | 16 |
857061 | 857061 | 2020-12-23 | Dent | Missouri | 29065 | 659 | 7 |
837587 | 837587 | 2020-12-17 | Dallas | Missouri | 29059 | 659 | 14 |
821332 | 821332 | 2020-12-12 | Bates | Missouri | 29013 | 659 | 9 |
811620 | 811620 | 2020-12-09 | DeKalb | Missouri | 29063 | 659 | 16 |
801859 | 801859 | 2020-12-06 | Barton | Missouri | 29011 | 659 | 5 |
772710 | 772710 | 2020-11-27 | Macon | Missouri | 29121 | 659 | 3 |
769494 | 769494 | 2020-11-26 | Ray | Missouri | 29177 | 659 | 4 |
665701 | 665701 | 2020-10-25 | Washington | Missouri | 29221 | 659 | 18 |
581273 | 581273 | 2020-09-29 | Butler | Missouri | 29023 | 659 | 7 |
578032 | 578032 | 2020-09-28 | Butler | Missouri | 29023 | 659 | 7 |
574866 | 574866 | 2020-09-27 | Pulaski | Missouri | 29169 | 659 | 5 |
352189 | 352189 | 2020-07-20 | Newton | Missouri | 29145 | 659 | 3 |
113927 | 113927 | 2020-05-04 | Kansas City | Missouri | 659 | 16 |
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);