ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 1704 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305878 | 2305878 | 2022-03-14 | Sullivan | Missouri | 29211 | 1704 | 21 |
2091189 | 2091189 | 2022-01-07 | Monroe | Missouri | 29137 | 1704 | 35 |
2087912 | 2087912 | 2022-01-06 | Howard | Missouri | 29089 | 1704 | 19 |
2039142 | 2039142 | 2021-12-22 | DeKalb | Missouri | 29063 | 1704 | 37 |
1961211 | 1961211 | 2021-11-28 | Wayne | Missouri | 29223 | 1704 | 34 |
1957960 | 1957960 | 2021-11-27 | Wayne | Missouri | 29223 | 1704 | 34 |
1954709 | 1954709 | 2021-11-26 | Wayne | Missouri | 29223 | 1704 | 34 |
1951458 | 1951458 | 2021-11-25 | Wayne | Missouri | 29223 | 1704 | 34 |
1948207 | 1948207 | 2021-11-24 | Wayne | Missouri | 29223 | 1704 | 34 |
1808374 | 1808374 | 2021-10-12 | Bollinger | Missouri | 29017 | 1704 | 19 |
1756384 | 1756384 | 2021-09-26 | Barton | Missouri | 29011 | 1704 | 24 |
1753136 | 1753136 | 2021-09-25 | Barton | Missouri | 29011 | 1704 | 24 |
1642747 | 1642747 | 2021-08-22 | Mississippi | Missouri | 29133 | 1704 | 28 |
1522561 | 1522561 | 2021-07-16 | Madison | Missouri | 29123 | 1704 | 16 |
1441464 | 1441464 | 2021-06-21 | Wright | Missouri | 29229 | 1704 | 34 |
1399160 | 1399160 | 2021-06-08 | Benton | Missouri | 29015 | 1704 | 34 |
1262877 | 1262877 | 2021-04-27 | Morgan | Missouri | 29141 | 1704 | 43 |
1259630 | 1259630 | 2021-04-26 | Morgan | Missouri | 29141 | 1704 | 43 |
1256383 | 1256383 | 2021-04-25 | Morgan | Missouri | 29141 | 1704 | 43 |
1253136 | 1253136 | 2021-04-24 | Morgan | Missouri | 29141 | 1704 | 43 |
1152460 | 1152460 | 2021-03-24 | Morgan | Missouri | 29141 | 1704 | 42 |
938233 | 938233 | 2021-01-17 | New Madrid | Missouri | 29143 | 1704 | 39 |
811644 | 811644 | 2020-12-09 | Lafayette | Missouri | 29107 | 1704 | 31 |
756535 | 756535 | 2020-11-22 | Webster | Missouri | 29225 | 1704 | 23 |
448643 | 448643 | 2020-08-19 | Boone | Missouri | 29019 | 1704 | 5 |
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);