ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 332 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1762971 | 1762971 | 2021-09-28 | Scotland | Missouri | 29199 | 332 | 4 |
1759722 | 1759722 | 2021-09-27 | Scotland | Missouri | 29199 | 332 | 4 |
1607014 | 1607014 | 2021-08-11 | Mercer | Missouri | 29129 | 332 | 2 |
1249911 | 1249911 | 2021-04-23 | Schuyler | Missouri | 29197 | 332 | 6 |
1246664 | 1246664 | 2021-04-22 | Schuyler | Missouri | 29197 | 332 | 6 |
1243417 | 1243417 | 2021-04-21 | Schuyler | Missouri | 29197 | 332 | 6 |
1240170 | 1240170 | 2021-04-20 | Schuyler | Missouri | 29197 | 332 | 6 |
1236923 | 1236923 | 2021-04-19 | Schuyler | Missouri | 29197 | 332 | 6 |
1233676 | 1233676 | 2021-04-18 | Schuyler | Missouri | 29197 | 332 | 6 |
1230428 | 1230428 | 2021-04-17 | Schuyler | Missouri | 29197 | 332 | 6 |
951241 | 951241 | 2021-01-21 | Shelby | Missouri | 29205 | 332 | 5 |
883009 | 883009 | 2020-12-31 | Chariton | Missouri | 29041 | 332 | 3 |
775924 | 775924 | 2020-11-28 | Daviess | Missouri | 29061 | 332 | 8 |
769475 | 769475 | 2020-11-26 | Montgomery | Missouri | 29139 | 332 | 5 |
743478 | 743478 | 2020-11-18 | Hickory | Missouri | 29085 | 332 | 4 |
740226 | 740226 | 2020-11-17 | Gentry | Missouri | 29075 | 332 | 11 |
740231 | 740231 | 2020-11-17 | Hickory | Missouri | 29085 | 332 | 4 |
714277 | 714277 | 2020-11-09 | Grundy | Missouri | 29079 | 332 | 11 |
568367 | 568367 | 2020-09-25 | Morgan | Missouri | 29141 | 332 | 1 |
558578 | 558578 | 2020-09-22 | Adair | Missouri | 29001 | 332 | 0 |
523079 | 523079 | 2020-09-11 | Stone | Missouri | 29209 | 332 | 2 |
516504 | 516504 | 2020-09-09 | Audrain | Missouri | 29007 | 332 | 2 |
487414 | 487414 | 2020-08-31 | Callaway | Missouri | 29027 | 332 | 2 |
276032 | 276032 | 2020-06-26 | Newton | Missouri | 29145 | 332 | 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);