ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 275 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1084307 | 1084307 | 2021-03-03 | Schuyler | Missouri | 29197 | 275 | 5 |
844146 | 844146 | 2020-12-19 | Shelby | Missouri | 29205 | 275 | 1 |
756499 | 756499 | 2020-11-22 | Ozark | Missouri | 29153 | 275 | 2 |
743507 | 743507 | 2020-11-18 | Montgomery | Missouri | 29139 | 275 | 5 |
724031 | 724031 | 2020-11-12 | Maries | Missouri | 29125 | 275 | 1 |
704583 | 704583 | 2020-11-06 | Oregon | Missouri | 29149 | 275 | 0 |
691633 | 691633 | 2020-11-02 | Shannon | Missouri | 29203 | 275 | 5 |
642982 | 642982 | 2020-10-18 | Sullivan | Missouri | 29211 | 275 | 1 |
639656 | 639656 | 2020-10-17 | Dallas | Missouri | 29059 | 275 | 1 |
626729 | 626729 | 2020-10-13 | Pike | Missouri | 29163 | 275 | 4 |
623487 | 623487 | 2020-10-12 | Pike | Missouri | 29163 | 275 | 4 |
620244 | 620244 | 2020-10-11 | Pike | Missouri | 29163 | 275 | 4 |
617002 | 617002 | 2020-10-10 | Pike | Missouri | 29163 | 275 | 4 |
561822 | 561822 | 2020-09-23 | Benton | Missouri | 29015 | 275 | 3 |
548933 | 548933 | 2020-09-19 | Moniteau | Missouri | 29135 | 275 | 4 |
503683 | 503683 | 2020-09-05 | Webster | Missouri | 29225 | 275 | 1 |
474521 | 474521 | 2020-08-27 | Laclede | Missouri | 29105 | 275 | 1 |
448714 | 448714 | 2020-08-19 | Perry | Missouri | 29157 | 275 | 4 |
448719 | 448719 | 2020-08-19 | Polk | Missouri | 29167 | 275 | 1 |
445464 | 445464 | 2020-08-18 | Lawrence | Missouri | 29109 | 275 | 2 |
445494 | 445494 | 2020-08-18 | Pulaski | Missouri | 29169 | 275 | 1 |
445519 | 445519 | 2020-08-18 | Warren | Missouri | 29219 | 275 | 0 |
442268 | 442268 | 2020-08-17 | Pulaski | Missouri | 29169 | 275 | 1 |
413179 | 413179 | 2020-08-08 | Butler | Missouri | 29023 | 275 | 2 |
409959 | 409959 | 2020-08-07 | Butler | Missouri | 29023 | 275 | 2 |
374647 | 374647 | 2020-07-27 | Platte | Missouri | 29165 | 275 | 7 |
29641 | 29641 | 2020-04-03 | St. Louis city | Missouri | 29510 | 275 | 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);