ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 372 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1671977 | 1671977 | 2021-08-31 | Mercer | Missouri | 29129 | 372 | 2 |
1243376 | 1243376 | 2021-04-21 | Knox | Missouri | 29103 | 372 | 2 |
1240129 | 1240129 | 2021-04-20 | Knox | Missouri | 29103 | 372 | 2 |
1236882 | 1236882 | 2021-04-19 | Knox | Missouri | 29103 | 372 | 2 |
1233635 | 1233635 | 2021-04-18 | Knox | Missouri | 29103 | 372 | 2 |
1230387 | 1230387 | 2021-04-17 | Knox | Missouri | 29103 | 372 | 2 |
876577 | 876577 | 2020-12-29 | Ozark | Missouri | 29153 | 372 | 4 |
769474 | 769474 | 2020-11-26 | Monroe | Missouri | 29137 | 372 | 3 |
681887 | 681887 | 2020-10-30 | Pike | Missouri | 29163 | 372 | 8 |
636382 | 636382 | 2020-10-16 | Andrew | Missouri | 29003 | 372 | 4 |
636449 | 636449 | 2020-10-16 | Mississippi | Missouri | 29133 | 372 | 5 |
594225 | 594225 | 2020-10-03 | Adair | Missouri | 29001 | 372 | 0 |
535919 | 535919 | 2020-09-15 | Audrain | Missouri | 29007 | 372 | 2 |
510146 | 510146 | 2020-09-07 | Warren | Missouri | 29219 | 372 | 0 |
506913 | 506913 | 2020-09-06 | Warren | Missouri | 29219 | 372 | 0 |
432538 | 432538 | 2020-08-14 | Dunklin | Missouri | 29069 | 372 | 4 |
352165 | 352165 | 2020-07-20 | Johnson | Missouri | 29101 | 372 | 2 |
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);