ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 924 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 14
county 14
- Harrison 18
- Chariton 3
- Douglas 2
- McDonald 2
- Atchison 1
- DeKalb 1
- Iron 1
- Kansas City 1
- Mississippi 1
- Morgan 1
- Osage 1
- St. Charles 1
- St. Clair 1
- Stoddard 1
state 1
- Missouri · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2019609 | 2019609 | 2021-12-16 | Atchison | Missouri | 29005 | 924 | 18 |
1668684 | 1668684 | 2021-08-30 | Chariton | Missouri | 29041 | 924 | 8 |
1665437 | 1665437 | 2021-08-29 | Chariton | Missouri | 29041 | 924 | 8 |
1662189 | 1662189 | 2021-08-28 | Chariton | Missouri | 29041 | 924 | 8 |
1558318 | 1558318 | 2021-07-27 | St. Clair | Missouri | 29185 | 924 | 8 |
1454375 | 1454375 | 2021-06-25 | Iron | Missouri | 29093 | 924 | 7 |
1314783 | 1314783 | 2021-05-13 | Douglas | Missouri | 29067 | 924 | 28 |
1311537 | 1311537 | 2021-05-12 | Douglas | Missouri | 29067 | 924 | 28 |
1204391 | 1204391 | 2021-04-09 | Harrison | Missouri | 29081 | 924 | 14 |
1201143 | 1201143 | 2021-04-08 | Harrison | Missouri | 29081 | 924 | 14 |
1197894 | 1197894 | 2021-04-07 | Harrison | Missouri | 29081 | 924 | 14 |
1194645 | 1194645 | 2021-04-06 | Harrison | Missouri | 29081 | 924 | 14 |
1191396 | 1191396 | 2021-04-05 | Harrison | Missouri | 29081 | 924 | 14 |
1188148 | 1188148 | 2021-04-04 | Harrison | Missouri | 29081 | 924 | 14 |
1184901 | 1184901 | 2021-04-03 | Harrison | Missouri | 29081 | 924 | 14 |
1181655 | 1181655 | 2021-04-02 | Harrison | Missouri | 29081 | 924 | 14 |
1178408 | 1178408 | 2021-04-01 | Harrison | Missouri | 29081 | 924 | 14 |
1175161 | 1175161 | 2021-03-31 | Harrison | Missouri | 29081 | 924 | 14 |
1149181 | 1149181 | 2021-03-23 | Harrison | Missouri | 29081 | 924 | 14 |
1145934 | 1145934 | 2021-03-22 | Harrison | Missouri | 29081 | 924 | 14 |
1142687 | 1142687 | 2021-03-21 | Harrison | Missouri | 29081 | 924 | 14 |
1139440 | 1139440 | 2021-03-20 | Harrison | Missouri | 29081 | 924 | 14 |
1136194 | 1136194 | 2021-03-19 | Harrison | Missouri | 29081 | 924 | 14 |
1132948 | 1132948 | 2021-03-18 | Harrison | Missouri | 29081 | 924 | 14 |
1129700 | 1129700 | 2021-03-17 | Harrison | Missouri | 29081 | 924 | 14 |
1126453 | 1126453 | 2021-03-16 | Harrison | Missouri | 29081 | 924 | 14 |
1090734 | 1090734 | 2021-03-05 | DeKalb | Missouri | 29063 | 924 | 27 |
795432 | 795432 | 2020-12-04 | Mississippi | Missouri | 29133 | 924 | 7 |
772726 | 772726 | 2020-11-27 | Osage | Missouri | 29151 | 924 | 3 |
737017 | 737017 | 2020-11-16 | Morgan | Missouri | 29141 | 924 | 8 |
681909 | 681909 | 2020-10-30 | Stoddard | Missouri | 29207 | 924 | 15 |
348980 | 348980 | 2020-07-19 | McDonald | Missouri | 29119 | 924 | 3 |
345779 | 345779 | 2020-07-18 | McDonald | Missouri | 29119 | 924 | 3 |
244800 | 244800 | 2020-06-16 | St. Charles | Missouri | 29183 | 924 | 67 |
161747 | 161747 | 2020-05-20 | Kansas City | Missouri | 924 | 23 |
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);