ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
5,503 rows where deaths = 1 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Ste. Genevieve 211
- Linn 186
- Scotland 185
- Carter 179
- Bates 163
- Putnam 157
- Lincoln 154
- Pulaski 151
- Washington 145
- Caldwell 139
- Callaway 137
- Harrison 130
- Dallas 129
- Lewis 126
- Pike 112
- Knox 107
- Shelby 103
- Camden 102
- Worth 95
- Audrain 89
- Boone 86
- New Madrid 82
- Cole 81
- Webster 80
- Schuyler 79
- Montgomery 78
- Andrew 75
- Shannon 71
- Grundy 70
- Bollinger 69
- …
state 1
- Missouri · 5,503 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1149256 | 1149256 | 2021-03-23 | Worth | Missouri | 29227 | 163 | 1 |
1146009 | 1146009 | 2021-03-22 | Worth | Missouri | 29227 | 163 | 1 |
1142762 | 1142762 | 2021-03-21 | Worth | Missouri | 29227 | 163 | 1 |
1139515 | 1139515 | 2021-03-20 | Worth | Missouri | 29227 | 163 | 1 |
1136269 | 1136269 | 2021-03-19 | Worth | Missouri | 29227 | 163 | 1 |
1133023 | 1133023 | 2021-03-18 | Worth | Missouri | 29227 | 163 | 1 |
1129775 | 1129775 | 2021-03-17 | Worth | Missouri | 29227 | 163 | 1 |
1126528 | 1126528 | 2021-03-16 | Worth | Missouri | 29227 | 163 | 1 |
1123282 | 1123282 | 2021-03-15 | Worth | Missouri | 29227 | 163 | 1 |
1120035 | 1120035 | 2021-03-14 | Worth | Missouri | 29227 | 163 | 1 |
1116788 | 1116788 | 2021-03-13 | Worth | Missouri | 29227 | 163 | 1 |
1113542 | 1113542 | 2021-03-12 | Worth | Missouri | 29227 | 163 | 1 |
1110296 | 1110296 | 2021-03-11 | Worth | Missouri | 29227 | 163 | 1 |
1107050 | 1107050 | 2021-03-10 | Worth | Missouri | 29227 | 163 | 1 |
1103804 | 1103804 | 2021-03-09 | Worth | Missouri | 29227 | 163 | 1 |
1100558 | 1100558 | 2021-03-08 | Worth | Missouri | 29227 | 163 | 1 |
1097311 | 1097311 | 2021-03-07 | Worth | Missouri | 29227 | 143 | 1 |
1094064 | 1094064 | 2021-03-06 | Worth | Missouri | 29227 | 143 | 1 |
1090818 | 1090818 | 2021-03-05 | Worth | Missouri | 29227 | 143 | 1 |
1087573 | 1087573 | 2021-03-04 | Worth | Missouri | 29227 | 143 | 1 |
1084328 | 1084328 | 2021-03-03 | Worth | Missouri | 29227 | 143 | 1 |
1081082 | 1081082 | 2021-03-02 | Worth | Missouri | 29227 | 142 | 1 |
1077836 | 1077836 | 2021-03-01 | Worth | Missouri | 29227 | 142 | 1 |
1074590 | 1074590 | 2021-02-28 | Worth | Missouri | 29227 | 142 | 1 |
1071344 | 1071344 | 2021-02-27 | Worth | Missouri | 29227 | 142 | 1 |
1068099 | 1068099 | 2021-02-26 | Worth | Missouri | 29227 | 142 | 1 |
1064854 | 1064854 | 2021-02-25 | Worth | Missouri | 29227 | 142 | 1 |
1061610 | 1061610 | 2021-02-24 | Worth | Missouri | 29227 | 142 | 1 |
1058364 | 1058364 | 2021-02-23 | Worth | Missouri | 29227 | 141 | 1 |
1055118 | 1055118 | 2021-02-22 | Worth | Missouri | 29227 | 141 | 1 |
1051871 | 1051871 | 2021-02-21 | Worth | Missouri | 29227 | 141 | 1 |
1048624 | 1048624 | 2021-02-20 | Worth | Missouri | 29227 | 141 | 1 |
1045378 | 1045378 | 2021-02-19 | Worth | Missouri | 29227 | 140 | 1 |
1042133 | 1042133 | 2021-02-18 | Worth | Missouri | 29227 | 140 | 1 |
1038888 | 1038888 | 2021-02-17 | Worth | Missouri | 29227 | 140 | 1 |
1035643 | 1035643 | 2021-02-16 | Worth | Missouri | 29227 | 140 | 1 |
1032398 | 1032398 | 2021-02-15 | Worth | Missouri | 29227 | 140 | 1 |
1029151 | 1029151 | 2021-02-14 | Worth | Missouri | 29227 | 139 | 1 |
1025905 | 1025905 | 2021-02-13 | Worth | Missouri | 29227 | 139 | 1 |
1022660 | 1022660 | 2021-02-12 | Worth | Missouri | 29227 | 139 | 1 |
1019415 | 1019415 | 2021-02-11 | Worth | Missouri | 29227 | 139 | 1 |
1016149 | 1016149 | 2021-02-10 | Schuyler | Missouri | 29197 | 263 | 1 |
1016170 | 1016170 | 2021-02-10 | Worth | Missouri | 29227 | 139 | 1 |
1012904 | 1012904 | 2021-02-09 | Schuyler | Missouri | 29197 | 263 | 1 |
1012925 | 1012925 | 2021-02-09 | Worth | Missouri | 29227 | 139 | 1 |
1009659 | 1009659 | 2021-02-08 | Schuyler | Missouri | 29197 | 263 | 1 |
1009680 | 1009680 | 2021-02-08 | Worth | Missouri | 29227 | 139 | 1 |
1006412 | 1006412 | 2021-02-07 | Schuyler | Missouri | 29197 | 263 | 1 |
1006433 | 1006433 | 2021-02-07 | Worth | Missouri | 29227 | 138 | 1 |
1003166 | 1003166 | 2021-02-06 | Schuyler | Missouri | 29197 | 263 | 1 |
1003187 | 1003187 | 2021-02-06 | Worth | Missouri | 29227 | 137 | 1 |
999921 | 999921 | 2021-02-05 | Schuyler | Missouri | 29197 | 263 | 1 |
999942 | 999942 | 2021-02-05 | Worth | Missouri | 29227 | 137 | 1 |
996675 | 996675 | 2021-02-04 | Schuyler | Missouri | 29197 | 263 | 1 |
996696 | 996696 | 2021-02-04 | Worth | Missouri | 29227 | 137 | 1 |
993429 | 993429 | 2021-02-03 | Schuyler | Missouri | 29197 | 263 | 1 |
993450 | 993450 | 2021-02-03 | Worth | Missouri | 29227 | 137 | 1 |
990183 | 990183 | 2021-02-02 | Schuyler | Missouri | 29197 | 262 | 1 |
990204 | 990204 | 2021-02-02 | Worth | Missouri | 29227 | 137 | 1 |
986888 | 986888 | 2021-02-01 | Iron | Missouri | 29093 | 461 | 1 |
986936 | 986936 | 2021-02-01 | Schuyler | Missouri | 29197 | 262 | 1 |
986957 | 986957 | 2021-02-01 | Worth | Missouri | 29227 | 137 | 1 |
983641 | 983641 | 2021-01-31 | Iron | Missouri | 29093 | 461 | 1 |
983689 | 983689 | 2021-01-31 | Schuyler | Missouri | 29197 | 262 | 1 |
983710 | 983710 | 2021-01-31 | Worth | Missouri | 29227 | 137 | 1 |
980395 | 980395 | 2021-01-30 | Iron | Missouri | 29093 | 461 | 1 |
980443 | 980443 | 2021-01-30 | Schuyler | Missouri | 29197 | 260 | 1 |
980464 | 980464 | 2021-01-30 | Worth | Missouri | 29227 | 137 | 1 |
977149 | 977149 | 2021-01-29 | Iron | Missouri | 29093 | 461 | 1 |
977197 | 977197 | 2021-01-29 | Schuyler | Missouri | 29197 | 260 | 1 |
977218 | 977218 | 2021-01-29 | Worth | Missouri | 29227 | 136 | 1 |
973904 | 973904 | 2021-01-28 | Iron | Missouri | 29093 | 458 | 1 |
973952 | 973952 | 2021-01-28 | Schuyler | Missouri | 29197 | 258 | 1 |
973973 | 973973 | 2021-01-28 | Worth | Missouri | 29227 | 136 | 1 |
970659 | 970659 | 2021-01-27 | Iron | Missouri | 29093 | 459 | 1 |
970707 | 970707 | 2021-01-27 | Schuyler | Missouri | 29197 | 256 | 1 |
970728 | 970728 | 2021-01-27 | Worth | Missouri | 29227 | 136 | 1 |
967414 | 967414 | 2021-01-26 | Iron | Missouri | 29093 | 457 | 1 |
967462 | 967462 | 2021-01-26 | Schuyler | Missouri | 29197 | 255 | 1 |
967483 | 967483 | 2021-01-26 | Worth | Missouri | 29227 | 136 | 1 |
964170 | 964170 | 2021-01-25 | Iron | Missouri | 29093 | 455 | 1 |
964218 | 964218 | 2021-01-25 | Schuyler | Missouri | 29197 | 251 | 1 |
964239 | 964239 | 2021-01-25 | Worth | Missouri | 29227 | 136 | 1 |
960925 | 960925 | 2021-01-24 | Iron | Missouri | 29093 | 454 | 1 |
960973 | 960973 | 2021-01-24 | Schuyler | Missouri | 29197 | 250 | 1 |
960994 | 960994 | 2021-01-24 | Worth | Missouri | 29227 | 135 | 1 |
957679 | 957679 | 2021-01-23 | Iron | Missouri | 29093 | 454 | 1 |
957727 | 957727 | 2021-01-23 | Schuyler | Missouri | 29197 | 251 | 1 |
957748 | 957748 | 2021-01-23 | Worth | Missouri | 29227 | 135 | 1 |
954434 | 954434 | 2021-01-22 | Iron | Missouri | 29093 | 453 | 1 |
954482 | 954482 | 2021-01-22 | Schuyler | Missouri | 29197 | 251 | 1 |
954503 | 954503 | 2021-01-22 | Worth | Missouri | 29227 | 132 | 1 |
951189 | 951189 | 2021-01-21 | Iron | Missouri | 29093 | 453 | 1 |
951237 | 951237 | 2021-01-21 | Schuyler | Missouri | 29197 | 250 | 1 |
951258 | 951258 | 2021-01-21 | Worth | Missouri | 29227 | 132 | 1 |
947943 | 947943 | 2021-01-20 | Iron | Missouri | 29093 | 452 | 1 |
947991 | 947991 | 2021-01-20 | Schuyler | Missouri | 29197 | 243 | 1 |
948012 | 948012 | 2021-01-20 | Worth | Missouri | 29227 | 132 | 1 |
944696 | 944696 | 2021-01-19 | Iron | Missouri | 29093 | 453 | 1 |
944744 | 944744 | 2021-01-19 | Schuyler | Missouri | 29197 | 239 | 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);