ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 330 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1720733 | 1720733 | 2021-09-15 | Scotland | Missouri | 29199 | 330 | 4 |
1594019 | 1594019 | 2021-08-07 | Mercer | Missouri | 29129 | 330 | 2 |
1590770 | 1590770 | 2021-08-06 | Mercer | Missouri | 29129 | 330 | 2 |
1194699 | 1194699 | 2021-04-06 | Schuyler | Missouri | 29197 | 330 | 5 |
1191450 | 1191450 | 2021-04-05 | Schuyler | Missouri | 29197 | 330 | 5 |
1188202 | 1188202 | 2021-04-04 | Schuyler | Missouri | 29197 | 330 | 5 |
1184955 | 1184955 | 2021-04-03 | Schuyler | Missouri | 29197 | 330 | 5 |
1181709 | 1181709 | 2021-04-02 | Schuyler | Missouri | 29197 | 330 | 5 |
1178462 | 1178462 | 2021-04-01 | Schuyler | Missouri | 29197 | 330 | 5 |
1175215 | 1175215 | 2021-03-31 | Schuyler | Missouri | 29197 | 330 | 5 |
1171968 | 1171968 | 2021-03-30 | Schuyler | Missouri | 29197 | 330 | 5 |
1168720 | 1168720 | 2021-03-29 | Schuyler | Missouri | 29197 | 330 | 5 |
1165472 | 1165472 | 2021-03-28 | Schuyler | Missouri | 29197 | 330 | 5 |
1162224 | 1162224 | 2021-03-27 | Schuyler | Missouri | 29197 | 330 | 5 |
1158976 | 1158976 | 2021-03-26 | Schuyler | Missouri | 29197 | 330 | 5 |
944748 | 944748 | 2021-01-19 | Shelby | Missouri | 29205 | 330 | 4 |
902506 | 902506 | 2021-01-06 | Holt | Missouri | 29087 | 330 | 9 |
899261 | 899261 | 2021-01-05 | Holt | Missouri | 29087 | 330 | 9 |
896016 | 896016 | 2021-01-04 | Holt | Missouri | 29087 | 330 | 9 |
892769 | 892769 | 2021-01-03 | Holt | Missouri | 29087 | 330 | 9 |
763010 | 763010 | 2020-11-24 | Shannon | Missouri | 29203 | 330 | 10 |
753238 | 753238 | 2020-11-21 | Maries | Missouri | 29125 | 330 | 2 |
613740 | 613740 | 2020-10-09 | Madison | Missouri | 29123 | 330 | 1 |
552103 | 552103 | 2020-09-20 | Adair | Missouri | 29001 | 330 | 0 |
548864 | 548864 | 2020-09-19 | Adair | Missouri | 29001 | 330 | 0 |
542416 | 542416 | 2020-09-17 | Crawford | Missouri | 29055 | 330 | 2 |
519850 | 519850 | 2020-09-10 | Webster | Missouri | 29225 | 330 | 1 |
513270 | 513270 | 2020-09-08 | Audrain | Missouri | 29007 | 330 | 2 |
464862 | 464862 | 2020-08-24 | Pulaski | Missouri | 29169 | 330 | 1 |
384307 | 384307 | 2020-07-30 | Scott | Missouri | 29201 | 330 | 13 |
329757 | 329757 | 2020-07-13 | Cape Girardeau | Missouri | 29031 | 330 | 3 |
155701 | 155701 | 2020-05-18 | Jefferson | Missouri | 29099 | 330 | 14 |
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);