ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where county = "Harrison", deaths = 6 and state = "Mississippi" 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 |
---|---|---|---|---|---|---|---|
179875 | 179875 | 2020-05-26 | Harrison | Mississippi | 28047 | 237 | 6 |
176831 | 176831 | 2020-05-25 | Harrison | Mississippi | 28047 | 237 | 6 |
173788 | 173788 | 2020-05-24 | Harrison | Mississippi | 28047 | 234 | 6 |
170746 | 170746 | 2020-05-23 | Harrison | Mississippi | 28047 | 231 | 6 |
167708 | 167708 | 2020-05-22 | Harrison | Mississippi | 28047 | 230 | 6 |
164672 | 164672 | 2020-05-21 | Harrison | Mississippi | 28047 | 224 | 6 |
161643 | 161643 | 2020-05-20 | Harrison | Mississippi | 28047 | 220 | 6 |
158617 | 158617 | 2020-05-19 | Harrison | Mississippi | 28047 | 218 | 6 |
155599 | 155599 | 2020-05-18 | Harrison | Mississippi | 28047 | 216 | 6 |
152585 | 152585 | 2020-05-17 | Harrison | Mississippi | 28047 | 215 | 6 |
149574 | 149574 | 2020-05-16 | Harrison | Mississippi | 28047 | 215 | 6 |
146569 | 146569 | 2020-05-15 | Harrison | Mississippi | 28047 | 214 | 6 |
143569 | 143569 | 2020-05-14 | Harrison | Mississippi | 28047 | 223 | 6 |
140574 | 140574 | 2020-05-13 | Harrison | Mississippi | 28047 | 210 | 6 |
137580 | 137580 | 2020-05-12 | Harrison | Mississippi | 28047 | 201 | 6 |
134590 | 134590 | 2020-05-11 | Harrison | Mississippi | 28047 | 198 | 6 |
131599 | 131599 | 2020-05-10 | Harrison | Mississippi | 28047 | 198 | 6 |
128609 | 128609 | 2020-05-09 | Harrison | Mississippi | 28047 | 198 | 6 |
125622 | 125622 | 2020-05-08 | Harrison | Mississippi | 28047 | 193 | 6 |
122640 | 122640 | 2020-05-07 | Harrison | Mississippi | 28047 | 188 | 6 |
119666 | 119666 | 2020-05-06 | Harrison | Mississippi | 28047 | 187 | 6 |
116706 | 116706 | 2020-05-05 | Harrison | Mississippi | 28047 | 186 | 6 |
113824 | 113824 | 2020-05-04 | Harrison | Mississippi | 28047 | 184 | 6 |
110945 | 110945 | 2020-05-03 | Harrison | Mississippi | 28047 | 181 | 6 |
108074 | 108074 | 2020-05-02 | Harrison | Mississippi | 28047 | 181 | 6 |
105209 | 105209 | 2020-05-01 | Harrison | Mississippi | 28047 | 177 | 6 |
102348 | 102348 | 2020-04-30 | Harrison | Mississippi | 28047 | 174 | 6 |
99496 | 99496 | 2020-04-29 | Harrison | Mississippi | 28047 | 171 | 6 |
96650 | 96650 | 2020-04-28 | Harrison | Mississippi | 28047 | 166 | 6 |
93814 | 93814 | 2020-04-27 | Harrison | Mississippi | 28047 | 159 | 6 |
90993 | 90993 | 2020-04-26 | Harrison | Mississippi | 28047 | 158 | 6 |
88177 | 88177 | 2020-04-25 | Harrison | Mississippi | 28047 | 158 | 6 |
85367 | 85367 | 2020-04-24 | Harrison | Mississippi | 28047 | 157 | 6 |
82563 | 82563 | 2020-04-23 | Harrison | Mississippi | 28047 | 152 | 6 |
79767 | 79767 | 2020-04-22 | Harrison | Mississippi | 28047 | 150 | 6 |
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);