ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 653 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1909179 | 1909179 | 2021-11-12 | Putnam | Missouri | 29171 | 653 | 10 |
1464127 | 1464127 | 2021-06-28 | Maries | Missouri | 29125 | 653 | 8 |
1460882 | 1460882 | 2021-06-27 | Maries | Missouri | 29125 | 653 | 8 |
1457637 | 1457637 | 2021-06-26 | Maries | Missouri | 29125 | 653 | 8 |
1454392 | 1454392 | 2021-06-25 | Maries | Missouri | 29125 | 653 | 8 |
1451147 | 1451147 | 2021-06-24 | Maries | Missouri | 29125 | 653 | 8 |
1383004 | 1383004 | 2021-06-03 | Ozark | Missouri | 29153 | 653 | 21 |
1379758 | 1379758 | 2021-06-02 | Ozark | Missouri | 29153 | 653 | 21 |
1376513 | 1376513 | 2021-06-01 | Ozark | Missouri | 29153 | 653 | 21 |
1373267 | 1373267 | 2021-05-31 | Ozark | Missouri | 29153 | 653 | 21 |
1370022 | 1370022 | 2021-05-30 | Ozark | Missouri | 29153 | 653 | 21 |
1366776 | 1366776 | 2021-05-29 | Ozark | Missouri | 29153 | 653 | 21 |
1363530 | 1363530 | 2021-05-28 | Ozark | Missouri | 29153 | 653 | 21 |
1337555 | 1337555 | 2021-05-20 | Ozark | Missouri | 29153 | 653 | 21 |
1334308 | 1334308 | 2021-05-19 | Ozark | Missouri | 29153 | 653 | 21 |
1331061 | 1331061 | 2021-05-18 | Ozark | Missouri | 29153 | 653 | 21 |
1327814 | 1327814 | 2021-05-17 | Ozark | Missouri | 29153 | 653 | 18 |
1324568 | 1324568 | 2021-05-16 | Ozark | Missouri | 29153 | 653 | 18 |
1321322 | 1321322 | 2021-05-15 | Ozark | Missouri | 29153 | 653 | 18 |
915481 | 915481 | 2021-01-10 | Gentry | Missouri | 29075 | 653 | 16 |
899258 | 899258 | 2021-01-05 | Harrison | Missouri | 29081 | 653 | 10 |
879832 | 879832 | 2020-12-30 | Ralls | Missouri | 29173 | 653 | 7 |
876606 | 876606 | 2020-12-29 | Sullivan | Missouri | 29211 | 653 | 9 |
870122 | 870122 | 2020-12-27 | Wayne | Missouri | 29223 | 653 | 6 |
853816 | 853816 | 2020-12-22 | Dent | Missouri | 29065 | 653 | 6 |
834341 | 834341 | 2020-12-16 | Dallas | Missouri | 29059 | 653 | 14 |
727218 | 727218 | 2020-11-13 | Benton | Missouri | 29015 | 653 | 7 |
717506 | 717506 | 2020-11-10 | Clinton | Missouri | 29049 | 653 | 33 |
626719 | 626719 | 2020-10-13 | New Madrid | Missouri | 29143 | 653 | 17 |
623477 | 623477 | 2020-10-12 | New Madrid | Missouri | 29143 | 653 | 17 |
620234 | 620234 | 2020-10-11 | New Madrid | Missouri | 29143 | 653 | 17 |
616992 | 616992 | 2020-10-10 | New Madrid | Missouri | 29143 | 653 | 17 |
461596 | 461596 | 2020-08-23 | Joplin | Missouri | 653 | 21 | |
451887 | 451887 | 2020-08-20 | Cole | Missouri | 29051 | 653 | 3 |
279171 | 279171 | 2020-06-27 | McDonald | Missouri | 29119 | 653 | 1 |
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);