ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 1039 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1928688 | 1928688 | 2021-11-18 | Shannon | Missouri | 29203 | 1039 | 27 |
1876627 | 1876627 | 2021-11-02 | Daviess | Missouri | 29061 | 1039 | 14 |
1490065 | 1490065 | 2021-07-06 | Douglas | Missouri | 29067 | 1039 | 29 |
1421983 | 1421983 | 2021-06-15 | Wayne | Missouri | 29223 | 1039 | 14 |
1366769 | 1366769 | 2021-05-29 | Montgomery | Missouri | 29139 | 1039 | 11 |
1340740 | 1340740 | 2021-05-21 | Carroll | Missouri | 29033 | 1039 | 23 |
1337493 | 1337493 | 2021-05-20 | Carroll | Missouri | 29033 | 1039 | 23 |
1217414 | 1217414 | 2021-04-13 | Montgomery | Missouri | 29139 | 1039 | 11 |
1214167 | 1214167 | 2021-04-12 | Montgomery | Missouri | 29139 | 1039 | 10 |
1210919 | 1210919 | 2021-04-11 | Montgomery | Missouri | 29139 | 1039 | 10 |
1201216 | 1201216 | 2021-04-08 | Wayne | Missouri | 29223 | 1039 | 11 |
1197967 | 1197967 | 2021-04-07 | Wayne | Missouri | 29223 | 1039 | 11 |
1136246 | 1136246 | 2021-03-19 | Ripley | Missouri | 29181 | 1039 | 15 |
996589 | 996589 | 2021-02-04 | Bollinger | Missouri | 29017 | 1039 | 12 |
824640 | 824640 | 2020-12-13 | Mississippi | Missouri | 29133 | 1039 | 8 |
818157 | 818157 | 2020-12-11 | Osage | Missouri | 29151 | 1039 | 6 |
814911 | 814911 | 2020-12-10 | Osage | Missouri | 29151 | 1039 | 6 |
743525 | 743525 | 2020-11-18 | Randolph | Missouri | 29175 | 1039 | 5 |
642960 | 642960 | 2020-10-18 | Polk | Missouri | 29167 | 1039 | 19 |
642989 | 642989 | 2020-10-18 | Webster | Missouri | 29225 | 1039 | 8 |
639712 | 639712 | 2020-10-17 | Polk | Missouri | 29167 | 1039 | 19 |
636466 | 636466 | 2020-10-16 | Polk | Missouri | 29167 | 1039 | 19 |
381005 | 381005 | 2020-07-29 | Buchanan | Missouri | 29021 | 1039 | 10 |
368149 | 368149 | 2020-07-25 | Boone | Missouri | 29019 | 1039 | 3 |
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);