ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walthall" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387420 | 387420 | 2020-07-31 | Walthall | Mississippi | 28147 | 425 | 18 |
384202 | 384202 | 2020-07-30 | Walthall | Mississippi | 28147 | 420 | 17 |
380986 | 380986 | 2020-07-29 | Walthall | Mississippi | 28147 | 416 | 16 |
377769 | 377769 | 2020-07-28 | Walthall | Mississippi | 28147 | 404 | 15 |
374554 | 374554 | 2020-07-27 | Walthall | Mississippi | 28147 | 397 | 15 |
371342 | 371342 | 2020-07-26 | Walthall | Mississippi | 28147 | 396 | 15 |
368131 | 368131 | 2020-07-25 | Walthall | Mississippi | 28147 | 386 | 15 |
364923 | 364923 | 2020-07-24 | Walthall | Mississippi | 28147 | 382 | 15 |
361716 | 361716 | 2020-07-23 | Walthall | Mississippi | 28147 | 378 | 14 |
358511 | 358511 | 2020-07-22 | Walthall | Mississippi | 28147 | 372 | 14 |
355308 | 355308 | 2020-07-21 | Walthall | Mississippi | 28147 | 358 | 13 |
352106 | 352106 | 2020-07-20 | Walthall | Mississippi | 28147 | 353 | 12 |
348906 | 348906 | 2020-07-19 | Walthall | Mississippi | 28147 | 345 | 12 |
345705 | 345705 | 2020-07-18 | Walthall | Mississippi | 28147 | 342 | 12 |
342505 | 342505 | 2020-07-17 | Walthall | Mississippi | 28147 | 310 | 10 |
339309 | 339309 | 2020-07-16 | Walthall | Mississippi | 28147 | 304 | 10 |
336113 | 336113 | 2020-07-15 | Walthall | Mississippi | 28147 | 292 | 10 |
332920 | 332920 | 2020-07-14 | Walthall | Mississippi | 28147 | 289 | 9 |
329733 | 329733 | 2020-07-13 | Walthall | Mississippi | 28147 | 274 | 8 |
326547 | 326547 | 2020-07-12 | Walthall | Mississippi | 28147 | 270 | 8 |
323364 | 323364 | 2020-07-11 | Walthall | Mississippi | 28147 | 262 | 7 |
320185 | 320185 | 2020-07-10 | Walthall | Mississippi | 28147 | 249 | 7 |
317010 | 317010 | 2020-07-09 | Walthall | Mississippi | 28147 | 226 | 7 |
313836 | 313836 | 2020-07-08 | Walthall | Mississippi | 28147 | 208 | 7 |
310666 | 310666 | 2020-07-07 | Walthall | Mississippi | 28147 | 205 | 6 |
307498 | 307498 | 2020-07-06 | Walthall | Mississippi | 28147 | 204 | 5 |
304331 | 304331 | 2020-07-05 | Walthall | Mississippi | 28147 | 199 | 5 |
301167 | 301167 | 2020-07-04 | Walthall | Mississippi | 28147 | 200 | 4 |
298004 | 298004 | 2020-07-03 | Walthall | Mississippi | 28147 | 180 | 4 |
294846 | 294846 | 2020-07-02 | Walthall | Mississippi | 28147 | 179 | 4 |
291692 | 291692 | 2020-07-01 | Walthall | Mississippi | 28147 | 172 | 4 |
288541 | 288541 | 2020-06-30 | Walthall | Mississippi | 28147 | 169 | 4 |
285391 | 285391 | 2020-06-29 | Walthall | Mississippi | 28147 | 168 | 3 |
282246 | 282246 | 2020-06-28 | Walthall | Mississippi | 28147 | 166 | 3 |
279098 | 279098 | 2020-06-27 | Walthall | Mississippi | 28147 | 165 | 3 |
275950 | 275950 | 2020-06-26 | Walthall | Mississippi | 28147 | 165 | 3 |
272807 | 272807 | 2020-06-25 | Walthall | Mississippi | 28147 | 163 | 3 |
269669 | 269669 | 2020-06-24 | Walthall | Mississippi | 28147 | 147 | 3 |
266536 | 266536 | 2020-06-23 | Walthall | Mississippi | 28147 | 140 | 1 |
263410 | 263410 | 2020-06-22 | Walthall | Mississippi | 28147 | 133 | 2 |
260282 | 260282 | 2020-06-21 | Walthall | Mississippi | 28147 | 111 | 1 |
257156 | 257156 | 2020-06-20 | Walthall | Mississippi | 28147 | 111 | 1 |
254036 | 254036 | 2020-06-19 | Walthall | Mississippi | 28147 | 111 | 1 |
250921 | 250921 | 2020-06-18 | Walthall | Mississippi | 28147 | 111 | 1 |
247808 | 247808 | 2020-06-17 | Walthall | Mississippi | 28147 | 111 | 1 |
244695 | 244695 | 2020-06-16 | Walthall | Mississippi | 28147 | 107 | 1 |
241584 | 241584 | 2020-06-15 | Walthall | Mississippi | 28147 | 105 | 1 |
238475 | 238475 | 2020-06-14 | Walthall | Mississippi | 28147 | 103 | 1 |
235368 | 235368 | 2020-06-13 | Walthall | Mississippi | 28147 | 100 | 1 |
232262 | 232262 | 2020-06-12 | Walthall | Mississippi | 28147 | 97 | 1 |
229158 | 229158 | 2020-06-11 | Walthall | Mississippi | 28147 | 85 | 0 |
226056 | 226056 | 2020-06-10 | Walthall | Mississippi | 28147 | 85 | 0 |
222958 | 222958 | 2020-06-09 | Walthall | Mississippi | 28147 | 82 | 0 |
219863 | 219863 | 2020-06-08 | Walthall | Mississippi | 28147 | 76 | 0 |
216771 | 216771 | 2020-06-07 | Walthall | Mississippi | 28147 | 74 | 0 |
213683 | 213683 | 2020-06-06 | Walthall | Mississippi | 28147 | 70 | 0 |
210599 | 210599 | 2020-06-05 | Walthall | Mississippi | 28147 | 67 | 0 |
207518 | 207518 | 2020-06-04 | Walthall | Mississippi | 28147 | 64 | 0 |
204437 | 204437 | 2020-06-03 | Walthall | Mississippi | 28147 | 63 | 0 |
201360 | 201360 | 2020-06-02 | Walthall | Mississippi | 28147 | 61 | 0 |
198287 | 198287 | 2020-06-01 | Walthall | Mississippi | 28147 | 57 | 0 |
195216 | 195216 | 2020-05-31 | Walthall | Mississippi | 28147 | 56 | 0 |
192148 | 192148 | 2020-05-30 | Walthall | Mississippi | 28147 | 55 | 0 |
189084 | 189084 | 2020-05-29 | Walthall | Mississippi | 28147 | 54 | 0 |
186026 | 186026 | 2020-05-28 | Walthall | Mississippi | 28147 | 52 | 0 |
182970 | 182970 | 2020-05-27 | Walthall | Mississippi | 28147 | 51 | 0 |
179924 | 179924 | 2020-05-26 | Walthall | Mississippi | 28147 | 50 | 0 |
176880 | 176880 | 2020-05-25 | Walthall | Mississippi | 28147 | 49 | 0 |
173837 | 173837 | 2020-05-24 | Walthall | Mississippi | 28147 | 49 | 0 |
170795 | 170795 | 2020-05-23 | Walthall | Mississippi | 28147 | 51 | 0 |
167757 | 167757 | 2020-05-22 | Walthall | Mississippi | 28147 | 50 | 0 |
164721 | 164721 | 2020-05-21 | Walthall | Mississippi | 28147 | 48 | 0 |
161692 | 161692 | 2020-05-20 | Walthall | Mississippi | 28147 | 46 | 0 |
158666 | 158666 | 2020-05-19 | Walthall | Mississippi | 28147 | 44 | 0 |
155648 | 155648 | 2020-05-18 | Walthall | Mississippi | 28147 | 46 | 0 |
152634 | 152634 | 2020-05-17 | Walthall | Mississippi | 28147 | 46 | 0 |
149623 | 149623 | 2020-05-16 | Walthall | Mississippi | 28147 | 46 | 0 |
146618 | 146618 | 2020-05-15 | Walthall | Mississippi | 28147 | 44 | 0 |
143618 | 143618 | 2020-05-14 | Walthall | Mississippi | 28147 | 42 | 0 |
140623 | 140623 | 2020-05-13 | Walthall | Mississippi | 28147 | 42 | 0 |
137629 | 137629 | 2020-05-12 | Walthall | Mississippi | 28147 | 42 | 0 |
134639 | 134639 | 2020-05-11 | Walthall | Mississippi | 28147 | 41 | 0 |
131648 | 131648 | 2020-05-10 | Walthall | Mississippi | 28147 | 39 | 0 |
128658 | 128658 | 2020-05-09 | Walthall | Mississippi | 28147 | 37 | 0 |
125671 | 125671 | 2020-05-08 | Walthall | Mississippi | 28147 | 37 | 0 |
122689 | 122689 | 2020-05-07 | Walthall | Mississippi | 28147 | 36 | 0 |
119715 | 119715 | 2020-05-06 | Walthall | Mississippi | 28147 | 36 | 0 |
116755 | 116755 | 2020-05-05 | Walthall | Mississippi | 28147 | 35 | 0 |
113873 | 113873 | 2020-05-04 | Walthall | Mississippi | 28147 | 33 | 0 |
110994 | 110994 | 2020-05-03 | Walthall | Mississippi | 28147 | 33 | 0 |
108123 | 108123 | 2020-05-02 | Walthall | Mississippi | 28147 | 32 | 0 |
105258 | 105258 | 2020-05-01 | Walthall | Mississippi | 28147 | 32 | 0 |
102397 | 102397 | 2020-04-30 | Walthall | Mississippi | 28147 | 31 | 0 |
99545 | 99545 | 2020-04-29 | Walthall | Mississippi | 28147 | 30 | 0 |
96699 | 96699 | 2020-04-28 | Walthall | Mississippi | 28147 | 30 | 0 |
93863 | 93863 | 2020-04-27 | Walthall | Mississippi | 28147 | 29 | 0 |
91042 | 91042 | 2020-04-26 | Walthall | Mississippi | 28147 | 28 | 0 |
88226 | 88226 | 2020-04-25 | Walthall | Mississippi | 28147 | 27 | 0 |
85416 | 85416 | 2020-04-24 | Walthall | Mississippi | 28147 | 27 | 0 |
82612 | 82612 | 2020-04-23 | Walthall | Mississippi | 28147 | 27 | 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);