ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 2000 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2143172 | 2143172 | 2022-01-23 | Carroll | Missouri | 29033 | 2000 | 41 |
2123705 | 2123705 | 2022-01-17 | Montgomery | Missouri | 29139 | 2000 | 35 |
2120453 | 2120453 | 2022-01-16 | Montgomery | Missouri | 29139 | 2000 | 35 |
2117201 | 2117201 | 2022-01-15 | Montgomery | Missouri | 29139 | 2000 | 35 |
2074918 | 2074918 | 2022-01-02 | Lewis | Missouri | 29111 | 2000 | 30 |
2071667 | 2071667 | 2022-01-01 | Lewis | Missouri | 29111 | 2000 | 30 |
2068416 | 2068416 | 2021-12-31 | Lewis | Missouri | 29111 | 2000 | 30 |
2065165 | 2065165 | 2021-12-30 | Lewis | Missouri | 29111 | 2000 | 30 |
1772702 | 1772702 | 2021-10-01 | Pemiscot | Missouri | 29155 | 2000 | 41 |
1623217 | 1623217 | 2021-08-16 | Dallas | Missouri | 29059 | 2000 | 37 |
1619970 | 1619970 | 2021-08-15 | Dallas | Missouri | 29059 | 2000 | 37 |
1580962 | 1580962 | 2021-08-03 | Benton | Missouri | 29015 | 2000 | 36 |
1447947 | 1447947 | 2021-06-23 | Texas | Missouri | 29215 | 2000 | 23 |
1438126 | 1438126 | 2021-06-20 | Clinton | Missouri | 29049 | 2000 | 65 |
1262846 | 1262846 | 2021-04-27 | Henry | Missouri | 29083 | 2000 | 38 |
1038879 | 1038879 | 2021-02-17 | Stone | Missouri | 29209 | 2000 | 35 |
944762 | 944762 | 2021-01-19 | Washington | Missouri | 29221 | 2000 | 41 |
646139 | 646139 | 2020-10-19 | Cass | Missouri | 29037 | 2000 | 28 |
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);