ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where county = "Cape Girardeau", deaths = 132 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1103704 | 1103704 | 2021-03-09 | Cape Girardeau | Missouri | 29031 | 9318 | 132 |
1100458 | 1100458 | 2021-03-08 | Cape Girardeau | Missouri | 29031 | 9318 | 132 |
1097211 | 1097211 | 2021-03-07 | Cape Girardeau | Missouri | 29031 | 9315 | 132 |
1093964 | 1093964 | 2021-03-06 | Cape Girardeau | Missouri | 29031 | 9315 | 132 |
1090718 | 1090718 | 2021-03-05 | Cape Girardeau | Missouri | 29031 | 9315 | 132 |
1087473 | 1087473 | 2021-03-04 | Cape Girardeau | Missouri | 29031 | 9312 | 132 |
1084228 | 1084228 | 2021-03-03 | Cape Girardeau | Missouri | 29031 | 9312 | 132 |
1080982 | 1080982 | 2021-03-02 | Cape Girardeau | Missouri | 29031 | 9308 | 132 |
1077736 | 1077736 | 2021-03-01 | Cape Girardeau | Missouri | 29031 | 9308 | 132 |
1074490 | 1074490 | 2021-02-28 | Cape Girardeau | Missouri | 29031 | 9293 | 132 |
1071244 | 1071244 | 2021-02-27 | Cape Girardeau | Missouri | 29031 | 9293 | 132 |
1067999 | 1067999 | 2021-02-26 | Cape Girardeau | Missouri | 29031 | 9293 | 132 |
1064754 | 1064754 | 2021-02-25 | Cape Girardeau | Missouri | 29031 | 9281 | 132 |
1061510 | 1061510 | 2021-02-24 | Cape Girardeau | Missouri | 29031 | 9261 | 132 |
1058264 | 1058264 | 2021-02-23 | Cape Girardeau | Missouri | 29031 | 9261 | 132 |
1055018 | 1055018 | 2021-02-22 | Cape Girardeau | Missouri | 29031 | 9261 | 132 |
1051771 | 1051771 | 2021-02-21 | Cape Girardeau | Missouri | 29031 | 9250 | 132 |
1048524 | 1048524 | 2021-02-20 | Cape Girardeau | Missouri | 29031 | 9250 | 132 |
1045278 | 1045278 | 2021-02-19 | Cape Girardeau | Missouri | 29031 | 9250 | 132 |
1042033 | 1042033 | 2021-02-18 | Cape Girardeau | Missouri | 29031 | 9233 | 132 |
1038788 | 1038788 | 2021-02-17 | Cape Girardeau | Missouri | 29031 | 9233 | 132 |
1035543 | 1035543 | 2021-02-16 | Cape Girardeau | Missouri | 29031 | 9181 | 132 |
1032298 | 1032298 | 2021-02-15 | Cape Girardeau | Missouri | 29031 | 9181 | 132 |
1029051 | 1029051 | 2021-02-14 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1025805 | 1025805 | 2021-02-13 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1022560 | 1022560 | 2021-02-12 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1019315 | 1019315 | 2021-02-11 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1016070 | 1016070 | 2021-02-10 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1012825 | 1012825 | 2021-02-09 | Cape Girardeau | Missouri | 29031 | 9118 | 132 |
1009580 | 1009580 | 2021-02-08 | Cape Girardeau | Missouri | 29031 | 9118 | 132 |
1006333 | 1006333 | 2021-02-07 | Cape Girardeau | Missouri | 29031 | 9005 | 132 |
1003087 | 1003087 | 2021-02-06 | Cape Girardeau | Missouri | 29031 | 9005 | 132 |
999842 | 999842 | 2021-02-05 | Cape Girardeau | Missouri | 29031 | 9005 | 132 |
996596 | 996596 | 2021-02-04 | Cape Girardeau | Missouri | 29031 | 8944 | 132 |
993350 | 993350 | 2021-02-03 | Cape Girardeau | Missouri | 29031 | 8944 | 132 |
990104 | 990104 | 2021-02-02 | Cape Girardeau | Missouri | 29031 | 8899 | 132 |
986857 | 986857 | 2021-02-01 | Cape Girardeau | Missouri | 29031 | 8899 | 132 |
983610 | 983610 | 2021-01-31 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
980364 | 980364 | 2021-01-30 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
977118 | 977118 | 2021-01-29 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
973873 | 973873 | 2021-01-28 | Cape Girardeau | Missouri | 29031 | 8834 | 132 |
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);