ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "DeSoto" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79760 | 79760 | 2020-04-22 | DeSoto | Mississippi | 28033 | 244 | 3 |
76975 | 76975 | 2020-04-21 | DeSoto | Mississippi | 28033 | 239 | 3 |
74194 | 74194 | 2020-04-20 | DeSoto | Mississippi | 28033 | 238 | 3 |
71421 | 71421 | 2020-04-19 | DeSoto | Mississippi | 28033 | 234 | 3 |
68655 | 68655 | 2020-04-18 | DeSoto | Mississippi | 28033 | 220 | 3 |
65903 | 65903 | 2020-04-17 | DeSoto | Mississippi | 28033 | 213 | 3 |
63163 | 63163 | 2020-04-16 | DeSoto | Mississippi | 28033 | 211 | 3 |
60441 | 60441 | 2020-04-15 | DeSoto | Mississippi | 28033 | 199 | 3 |
57730 | 57730 | 2020-04-14 | DeSoto | Mississippi | 28033 | 188 | 2 |
55032 | 55032 | 2020-04-13 | DeSoto | Mississippi | 28033 | 178 | 2 |
52350 | 52350 | 2020-04-12 | DeSoto | Mississippi | 28033 | 171 | 2 |
49677 | 49677 | 2020-04-11 | DeSoto | Mississippi | 28033 | 163 | 2 |
47031 | 47031 | 2020-04-10 | DeSoto | Mississippi | 28033 | 158 | 1 |
44422 | 44422 | 2020-04-09 | DeSoto | Mississippi | 28033 | 150 | 1 |
41846 | 41846 | 2020-04-08 | DeSoto | Mississippi | 28033 | 144 | 1 |
39292 | 39292 | 2020-04-07 | DeSoto | Mississippi | 28033 | 140 | 1 |
36781 | 36781 | 2020-04-06 | DeSoto | Mississippi | 28033 | 136 | 1 |
34319 | 34319 | 2020-04-05 | DeSoto | Mississippi | 28033 | 132 | 1 |
31892 | 31892 | 2020-04-04 | DeSoto | Mississippi | 28033 | 118 | 1 |
29512 | 29512 | 2020-04-03 | DeSoto | Mississippi | 28033 | 111 | 1 |
27193 | 27193 | 2020-04-02 | DeSoto | Mississippi | 28033 | 103 | 1 |
24939 | 24939 | 2020-04-01 | DeSoto | Mississippi | 28033 | 94 | 1 |
22756 | 22756 | 2020-03-31 | DeSoto | Mississippi | 28033 | 84 | 1 |
20639 | 20639 | 2020-03-30 | DeSoto | Mississippi | 28033 | 77 | 1 |
18615 | 18615 | 2020-03-29 | DeSoto | Mississippi | 28033 | 71 | 1 |
16693 | 16693 | 2020-03-28 | DeSoto | Mississippi | 28033 | 65 | 1 |
14869 | 14869 | 2020-03-27 | DeSoto | Mississippi | 28033 | 63 | 0 |
13153 | 13153 | 2020-03-26 | DeSoto | Mississippi | 28033 | 49 | 0 |
11561 | 11561 | 2020-03-25 | DeSoto | Mississippi | 28033 | 36 | 0 |
10141 | 10141 | 2020-03-24 | DeSoto | Mississippi | 28033 | 29 | 0 |
8845 | 8845 | 2020-03-23 | DeSoto | Mississippi | 28033 | 23 | 0 |
7665 | 7665 | 2020-03-22 | DeSoto | Mississippi | 28033 | 18 | 0 |
6582 | 6582 | 2020-03-21 | DeSoto | Mississippi | 28033 | 13 | 0 |
5606 | 5606 | 2020-03-20 | DeSoto | Mississippi | 28033 | 4 | 0 |
4783 | 4783 | 2020-03-19 | DeSoto | Mississippi | 28033 | 2 | 0 |
4071 | 4071 | 2020-03-18 | DeSoto | Mississippi | 28033 | 1 | 0 |
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);