ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Harrison" and state = "Mississippi" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3487 | 3487 | 2020-03-17 | Harrison | Mississippi | 28047 | 1 | 0 |
4074 | 4074 | 2020-03-18 | Harrison | Mississippi | 28047 | 4 | 0 |
4786 | 4786 | 2020-03-19 | Harrison | Mississippi | 28047 | 7 | 0 |
5610 | 5610 | 2020-03-20 | Harrison | Mississippi | 28047 | 8 | 0 |
6588 | 6588 | 2020-03-21 | Harrison | Mississippi | 28047 | 10 | 0 |
7671 | 7671 | 2020-03-22 | Harrison | Mississippi | 28047 | 15 | 0 |
8851 | 8851 | 2020-03-23 | Harrison | Mississippi | 28047 | 21 | 0 |
10147 | 10147 | 2020-03-24 | Harrison | Mississippi | 28047 | 24 | 0 |
11567 | 11567 | 2020-03-25 | Harrison | Mississippi | 28047 | 25 | 0 |
13159 | 13159 | 2020-03-26 | Harrison | Mississippi | 28047 | 31 | 0 |
14875 | 14875 | 2020-03-27 | Harrison | Mississippi | 28047 | 34 | 1 |
16699 | 16699 | 2020-03-28 | Harrison | Mississippi | 28047 | 38 | 1 |
18621 | 18621 | 2020-03-29 | Harrison | Mississippi | 28047 | 43 | 1 |
20645 | 20645 | 2020-03-30 | Harrison | Mississippi | 28047 | 44 | 1 |
22762 | 22762 | 2020-03-31 | Harrison | Mississippi | 28047 | 45 | 1 |
24945 | 24945 | 2020-04-01 | Harrison | Mississippi | 28047 | 49 | 1 |
27199 | 27199 | 2020-04-02 | Harrison | Mississippi | 28047 | 53 | 1 |
29518 | 29518 | 2020-04-03 | Harrison | Mississippi | 28047 | 69 | 1 |
31898 | 31898 | 2020-04-04 | Harrison | Mississippi | 28047 | 70 | 3 |
34325 | 34325 | 2020-04-05 | Harrison | Mississippi | 28047 | 73 | 3 |
36788 | 36788 | 2020-04-06 | Harrison | Mississippi | 28047 | 79 | 3 |
39299 | 39299 | 2020-04-07 | Harrison | Mississippi | 28047 | 89 | 3 |
41853 | 41853 | 2020-04-08 | Harrison | Mississippi | 28047 | 88 | 3 |
44429 | 44429 | 2020-04-09 | Harrison | Mississippi | 28047 | 96 | 3 |
47038 | 47038 | 2020-04-10 | Harrison | Mississippi | 28047 | 99 | 4 |
49684 | 49684 | 2020-04-11 | Harrison | Mississippi | 28047 | 107 | 5 |
52357 | 52357 | 2020-04-12 | Harrison | Mississippi | 28047 | 110 | 5 |
55039 | 55039 | 2020-04-13 | Harrison | Mississippi | 28047 | 112 | 5 |
57737 | 57737 | 2020-04-14 | Harrison | Mississippi | 28047 | 121 | 5 |
60448 | 60448 | 2020-04-15 | Harrison | Mississippi | 28047 | 129 | 5 |
63170 | 63170 | 2020-04-16 | Harrison | Mississippi | 28047 | 134 | 5 |
65910 | 65910 | 2020-04-17 | Harrison | Mississippi | 28047 | 137 | 5 |
68662 | 68662 | 2020-04-18 | Harrison | Mississippi | 28047 | 144 | 5 |
71428 | 71428 | 2020-04-19 | Harrison | Mississippi | 28047 | 144 | 5 |
74201 | 74201 | 2020-04-20 | Harrison | Mississippi | 28047 | 145 | 5 |
76982 | 76982 | 2020-04-21 | Harrison | Mississippi | 28047 | 151 | 5 |
79767 | 79767 | 2020-04-22 | Harrison | Mississippi | 28047 | 150 | 6 |
82563 | 82563 | 2020-04-23 | Harrison | Mississippi | 28047 | 152 | 6 |
85367 | 85367 | 2020-04-24 | Harrison | Mississippi | 28047 | 157 | 6 |
88177 | 88177 | 2020-04-25 | Harrison | Mississippi | 28047 | 158 | 6 |
90993 | 90993 | 2020-04-26 | Harrison | Mississippi | 28047 | 158 | 6 |
93814 | 93814 | 2020-04-27 | Harrison | Mississippi | 28047 | 159 | 6 |
96650 | 96650 | 2020-04-28 | Harrison | Mississippi | 28047 | 166 | 6 |
99496 | 99496 | 2020-04-29 | Harrison | Mississippi | 28047 | 171 | 6 |
102348 | 102348 | 2020-04-30 | Harrison | Mississippi | 28047 | 174 | 6 |
105209 | 105209 | 2020-05-01 | Harrison | Mississippi | 28047 | 177 | 6 |
108074 | 108074 | 2020-05-02 | Harrison | Mississippi | 28047 | 181 | 6 |
110945 | 110945 | 2020-05-03 | Harrison | Mississippi | 28047 | 181 | 6 |
113824 | 113824 | 2020-05-04 | Harrison | Mississippi | 28047 | 184 | 6 |
116706 | 116706 | 2020-05-05 | Harrison | Mississippi | 28047 | 186 | 6 |
119666 | 119666 | 2020-05-06 | Harrison | Mississippi | 28047 | 187 | 6 |
122640 | 122640 | 2020-05-07 | Harrison | Mississippi | 28047 | 188 | 6 |
125622 | 125622 | 2020-05-08 | Harrison | Mississippi | 28047 | 193 | 6 |
128609 | 128609 | 2020-05-09 | Harrison | Mississippi | 28047 | 198 | 6 |
131599 | 131599 | 2020-05-10 | Harrison | Mississippi | 28047 | 198 | 6 |
134590 | 134590 | 2020-05-11 | Harrison | Mississippi | 28047 | 198 | 6 |
137580 | 137580 | 2020-05-12 | Harrison | Mississippi | 28047 | 201 | 6 |
140574 | 140574 | 2020-05-13 | Harrison | Mississippi | 28047 | 210 | 6 |
143569 | 143569 | 2020-05-14 | Harrison | Mississippi | 28047 | 223 | 6 |
146569 | 146569 | 2020-05-15 | Harrison | Mississippi | 28047 | 214 | 6 |
149574 | 149574 | 2020-05-16 | Harrison | Mississippi | 28047 | 215 | 6 |
152585 | 152585 | 2020-05-17 | Harrison | Mississippi | 28047 | 215 | 6 |
155599 | 155599 | 2020-05-18 | Harrison | Mississippi | 28047 | 216 | 6 |
158617 | 158617 | 2020-05-19 | Harrison | Mississippi | 28047 | 218 | 6 |
161643 | 161643 | 2020-05-20 | Harrison | Mississippi | 28047 | 220 | 6 |
164672 | 164672 | 2020-05-21 | Harrison | Mississippi | 28047 | 224 | 6 |
167708 | 167708 | 2020-05-22 | Harrison | Mississippi | 28047 | 230 | 6 |
170746 | 170746 | 2020-05-23 | Harrison | Mississippi | 28047 | 231 | 6 |
173788 | 173788 | 2020-05-24 | Harrison | Mississippi | 28047 | 234 | 6 |
176831 | 176831 | 2020-05-25 | Harrison | Mississippi | 28047 | 237 | 6 |
179875 | 179875 | 2020-05-26 | Harrison | Mississippi | 28047 | 237 | 6 |
182921 | 182921 | 2020-05-27 | Harrison | Mississippi | 28047 | 245 | 7 |
185977 | 185977 | 2020-05-28 | Harrison | Mississippi | 28047 | 247 | 7 |
189035 | 189035 | 2020-05-29 | Harrison | Mississippi | 28047 | 251 | 7 |
192099 | 192099 | 2020-05-30 | Harrison | Mississippi | 28047 | 257 | 7 |
195167 | 195167 | 2020-05-31 | Harrison | Mississippi | 28047 | 258 | 7 |
198238 | 198238 | 2020-06-01 | Harrison | Mississippi | 28047 | 261 | 7 |
201311 | 201311 | 2020-06-02 | Harrison | Mississippi | 28047 | 263 | 7 |
204388 | 204388 | 2020-06-03 | Harrison | Mississippi | 28047 | 265 | 7 |
207469 | 207469 | 2020-06-04 | Harrison | Mississippi | 28047 | 269 | 7 |
210550 | 210550 | 2020-06-05 | Harrison | Mississippi | 28047 | 268 | 7 |
213634 | 213634 | 2020-06-06 | Harrison | Mississippi | 28047 | 274 | 7 |
216722 | 216722 | 2020-06-07 | Harrison | Mississippi | 28047 | 281 | 7 |
219814 | 219814 | 2020-06-08 | Harrison | Mississippi | 28047 | 288 | 7 |
222909 | 222909 | 2020-06-09 | Harrison | Mississippi | 28047 | 299 | 7 |
226007 | 226007 | 2020-06-10 | Harrison | Mississippi | 28047 | 311 | 7 |
229109 | 229109 | 2020-06-11 | Harrison | Mississippi | 28047 | 311 | 7 |
232213 | 232213 | 2020-06-12 | Harrison | Mississippi | 28047 | 319 | 7 |
235319 | 235319 | 2020-06-13 | Harrison | Mississippi | 28047 | 335 | 7 |
238426 | 238426 | 2020-06-14 | Harrison | Mississippi | 28047 | 344 | 7 |
241535 | 241535 | 2020-06-15 | Harrison | Mississippi | 28047 | 367 | 7 |
244646 | 244646 | 2020-06-16 | Harrison | Mississippi | 28047 | 377 | 7 |
247759 | 247759 | 2020-06-17 | Harrison | Mississippi | 28047 | 393 | 7 |
250871 | 250871 | 2020-06-18 | Harrison | Mississippi | 28047 | 393 | 7 |
253986 | 253986 | 2020-06-19 | Harrison | Mississippi | 28047 | 393 | 7 |
257106 | 257106 | 2020-06-20 | Harrison | Mississippi | 28047 | 393 | 7 |
260232 | 260232 | 2020-06-21 | Harrison | Mississippi | 28047 | 393 | 7 |
263361 | 263361 | 2020-06-22 | Harrison | Mississippi | 28047 | 464 | 7 |
266487 | 266487 | 2020-06-23 | Harrison | Mississippi | 28047 | 499 | 7 |
269620 | 269620 | 2020-06-24 | Harrison | Mississippi | 28047 | 514 | 7 |
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);