ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 1178 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2074924 | 2074924 | 2022-01-02 | Maries | Missouri | 29125 | 1178 | 22 |
2071673 | 2071673 | 2022-01-01 | Maries | Missouri | 29125 | 1178 | 22 |
2068422 | 2068422 | 2021-12-31 | Maries | Missouri | 29125 | 1178 | 22 |
2065171 | 2065171 | 2021-12-30 | Maries | Missouri | 29125 | 1178 | 22 |
1977370 | 1977370 | 2021-12-03 | Chariton | Missouri | 29041 | 1178 | 30 |
1974120 | 1974120 | 2021-12-02 | Chariton | Missouri | 29041 | 1178 | 30 |
1740235 | 1740235 | 2021-09-21 | St. Clair | Missouri | 29185 | 1178 | 14 |
1655742 | 1655742 | 2021-08-26 | Monroe | Missouri | 29137 | 1178 | 12 |
1574515 | 1574515 | 2021-08-01 | Lewis | Missouri | 29111 | 1178 | 21 |
1558226 | 1558226 | 2021-07-27 | Bollinger | Missouri | 29017 | 1178 | 15 |
1554979 | 1554979 | 2021-07-26 | Bollinger | Missouri | 29017 | 1178 | 15 |
1548569 | 1548569 | 2021-07-24 | Ripley | Missouri | 29181 | 1178 | 17 |
1542021 | 1542021 | 2021-07-22 | Grundy | Missouri | 29079 | 1178 | 36 |
1532271 | 1532271 | 2021-07-19 | DeKalb | Missouri | 29063 | 1178 | 33 |
1529024 | 1529024 | 2021-07-18 | DeKalb | Missouri | 29063 | 1178 | 33 |
1340729 | 1340729 | 2021-05-21 | Barton | Missouri | 29011 | 1178 | 15 |
1337482 | 1337482 | 2021-05-20 | Barton | Missouri | 29011 | 1178 | 15 |
1334235 | 1334235 | 2021-05-19 | Barton | Missouri | 29011 | 1178 | 15 |
1330988 | 1330988 | 2021-05-18 | Barton | Missouri | 29011 | 1178 | 15 |
1327741 | 1327741 | 2021-05-17 | Barton | Missouri | 29011 | 1178 | 14 |
1324495 | 1324495 | 2021-05-16 | Barton | Missouri | 29011 | 1178 | 14 |
1321249 | 1321249 | 2021-05-15 | Barton | Missouri | 29011 | 1178 | 14 |
1103748 | 1103748 | 2021-03-09 | Linn | Missouri | 29115 | 1178 | 12 |
1100502 | 1100502 | 2021-03-08 | Linn | Missouri | 29115 | 1178 | 12 |
996642 | 996642 | 2021-02-04 | Macon | Missouri | 29121 | 1178 | 12 |
941473 | 941473 | 2021-01-18 | Mississippi | Missouri | 29133 | 1178 | 20 |
938228 | 938228 | 2021-01-17 | Mississippi | Missouri | 29133 | 1178 | 20 |
915445 | 915445 | 2021-01-10 | Andrew | Missouri | 29003 | 1178 | 15 |
879821 | 879821 | 2020-12-30 | Osage | Missouri | 29151 | 1178 | 8 |
847377 | 847377 | 2020-12-20 | Pike | Missouri | 29163 | 1178 | 11 |
711078 | 711078 | 2020-11-08 | Platte | Missouri | 29165 | 1178 | 13 |
668918 | 668918 | 2020-10-26 | Polk | Missouri | 29167 | 1178 | 19 |
665602 | 665602 | 2020-10-25 | Callaway | Missouri | 29027 | 1178 | 5 |
665643 | 665643 | 2020-10-25 | Laclede | Missouri | 29105 | 1178 | 22 |
513302 | 513302 | 2020-09-08 | Franklin | Missouri | 29071 | 1178 | 22 |
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);