ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where county = "Choctaw", deaths = 1 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
116692 | 116692 | 2020-05-05 | Choctaw | Mississippi | 28019 | 14 | 1 |
113810 | 113810 | 2020-05-04 | Choctaw | Mississippi | 28019 | 14 | 1 |
110931 | 110931 | 2020-05-03 | Choctaw | Mississippi | 28019 | 13 | 1 |
108060 | 108060 | 2020-05-02 | Choctaw | Mississippi | 28019 | 13 | 1 |
105195 | 105195 | 2020-05-01 | Choctaw | Mississippi | 28019 | 13 | 1 |
102334 | 102334 | 2020-04-30 | Choctaw | Mississippi | 28019 | 13 | 1 |
99482 | 99482 | 2020-04-29 | Choctaw | Mississippi | 28019 | 13 | 1 |
96636 | 96636 | 2020-04-28 | Choctaw | Mississippi | 28019 | 13 | 1 |
93800 | 93800 | 2020-04-27 | Choctaw | Mississippi | 28019 | 13 | 1 |
90979 | 90979 | 2020-04-26 | Choctaw | Mississippi | 28019 | 13 | 1 |
88163 | 88163 | 2020-04-25 | Choctaw | Mississippi | 28019 | 13 | 1 |
85353 | 85353 | 2020-04-24 | Choctaw | Mississippi | 28019 | 13 | 1 |
82549 | 82549 | 2020-04-23 | Choctaw | Mississippi | 28019 | 13 | 1 |
79753 | 79753 | 2020-04-22 | Choctaw | Mississippi | 28019 | 13 | 1 |
76968 | 76968 | 2020-04-21 | Choctaw | Mississippi | 28019 | 13 | 1 |
74187 | 74187 | 2020-04-20 | Choctaw | Mississippi | 28019 | 13 | 1 |
71414 | 71414 | 2020-04-19 | Choctaw | Mississippi | 28019 | 12 | 1 |
68648 | 68648 | 2020-04-18 | Choctaw | Mississippi | 28019 | 11 | 1 |
65896 | 65896 | 2020-04-17 | Choctaw | Mississippi | 28019 | 11 | 1 |
63156 | 63156 | 2020-04-16 | Choctaw | Mississippi | 28019 | 11 | 1 |
60434 | 60434 | 2020-04-15 | Choctaw | Mississippi | 28019 | 11 | 1 |
57723 | 57723 | 2020-04-14 | Choctaw | Mississippi | 28019 | 11 | 1 |
55025 | 55025 | 2020-04-13 | Choctaw | Mississippi | 28019 | 11 | 1 |
52343 | 52343 | 2020-04-12 | Choctaw | Mississippi | 28019 | 10 | 1 |
49670 | 49670 | 2020-04-11 | Choctaw | Mississippi | 28019 | 10 | 1 |
47024 | 47024 | 2020-04-10 | Choctaw | Mississippi | 28019 | 9 | 1 |
44415 | 44415 | 2020-04-09 | Choctaw | Mississippi | 28019 | 9 | 1 |
41839 | 41839 | 2020-04-08 | Choctaw | Mississippi | 28019 | 9 | 1 |
39285 | 39285 | 2020-04-07 | Choctaw | Mississippi | 28019 | 9 | 1 |
36774 | 36774 | 2020-04-06 | Choctaw | Mississippi | 28019 | 8 | 1 |
34312 | 34312 | 2020-04-05 | Choctaw | Mississippi | 28019 | 8 | 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);