ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Choctaw", deaths = 16 and state = "Mississippi" 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 |
---|---|---|---|---|---|---|---|
1204278 | 1204278 | 2021-04-09 | Choctaw | Mississippi | 28019 | 728 | 16 |
1201030 | 1201030 | 2021-04-08 | Choctaw | Mississippi | 28019 | 726 | 16 |
1197781 | 1197781 | 2021-04-07 | Choctaw | Mississippi | 28019 | 726 | 16 |
1194532 | 1194532 | 2021-04-06 | Choctaw | Mississippi | 28019 | 726 | 16 |
1191283 | 1191283 | 2021-04-05 | Choctaw | Mississippi | 28019 | 725 | 16 |
1188035 | 1188035 | 2021-04-04 | Choctaw | Mississippi | 28019 | 725 | 16 |
1184788 | 1184788 | 2021-04-03 | Choctaw | Mississippi | 28019 | 725 | 16 |
1181542 | 1181542 | 2021-04-02 | Choctaw | Mississippi | 28019 | 725 | 16 |
1178295 | 1178295 | 2021-04-01 | Choctaw | Mississippi | 28019 | 723 | 16 |
1175048 | 1175048 | 2021-03-31 | Choctaw | Mississippi | 28019 | 723 | 16 |
1171801 | 1171801 | 2021-03-30 | Choctaw | Mississippi | 28019 | 723 | 16 |
1168553 | 1168553 | 2021-03-29 | Choctaw | Mississippi | 28019 | 723 | 16 |
1165305 | 1165305 | 2021-03-28 | Choctaw | Mississippi | 28019 | 723 | 16 |
1162057 | 1162057 | 2021-03-27 | Choctaw | Mississippi | 28019 | 723 | 16 |
1158809 | 1158809 | 2021-03-26 | Choctaw | Mississippi | 28019 | 723 | 16 |
1155562 | 1155562 | 2021-03-25 | Choctaw | Mississippi | 28019 | 723 | 16 |
1152315 | 1152315 | 2021-03-24 | Choctaw | Mississippi | 28019 | 722 | 16 |
1149068 | 1149068 | 2021-03-23 | Choctaw | Mississippi | 28019 | 721 | 16 |
1145821 | 1145821 | 2021-03-22 | Choctaw | Mississippi | 28019 | 721 | 16 |
1142574 | 1142574 | 2021-03-21 | Choctaw | Mississippi | 28019 | 719 | 16 |
1139327 | 1139327 | 2021-03-20 | Choctaw | Mississippi | 28019 | 718 | 16 |
1136081 | 1136081 | 2021-03-19 | Choctaw | Mississippi | 28019 | 718 | 16 |
1132835 | 1132835 | 2021-03-18 | Choctaw | Mississippi | 28019 | 718 | 16 |
1129587 | 1129587 | 2021-03-17 | Choctaw | Mississippi | 28019 | 717 | 16 |
1126340 | 1126340 | 2021-03-16 | Choctaw | Mississippi | 28019 | 717 | 16 |
1077648 | 1077648 | 2021-03-01 | Choctaw | Mississippi | 28019 | 695 | 16 |
1074402 | 1074402 | 2021-02-28 | Choctaw | Mississippi | 28019 | 695 | 16 |
1071156 | 1071156 | 2021-02-27 | Choctaw | Mississippi | 28019 | 695 | 16 |
1067911 | 1067911 | 2021-02-26 | Choctaw | Mississippi | 28019 | 695 | 16 |
1064666 | 1064666 | 2021-02-25 | Choctaw | Mississippi | 28019 | 695 | 16 |
1061422 | 1061422 | 2021-02-24 | Choctaw | Mississippi | 28019 | 694 | 16 |
1058176 | 1058176 | 2021-02-23 | Choctaw | Mississippi | 28019 | 693 | 16 |
1054930 | 1054930 | 2021-02-22 | Choctaw | Mississippi | 28019 | 693 | 16 |
1051683 | 1051683 | 2021-02-21 | Choctaw | Mississippi | 28019 | 693 | 16 |
1048436 | 1048436 | 2021-02-20 | Choctaw | Mississippi | 28019 | 693 | 16 |
1045190 | 1045190 | 2021-02-19 | Choctaw | Mississippi | 28019 | 693 | 16 |
1041945 | 1041945 | 2021-02-18 | Choctaw | Mississippi | 28019 | 693 | 16 |
1038700 | 1038700 | 2021-02-17 | Choctaw | Mississippi | 28019 | 693 | 16 |
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);