ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and fips = 28059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387376 | 387376 | 2020-07-31 | Jackson | Mississippi | 28059 | 1837 | 34 |
384158 | 384158 | 2020-07-30 | Jackson | Mississippi | 28059 | 1820 | 34 |
380941 | 380941 | 2020-07-29 | Jackson | Mississippi | 28059 | 1772 | 30 |
377724 | 377724 | 2020-07-28 | Jackson | Mississippi | 28059 | 1638 | 29 |
374509 | 374509 | 2020-07-27 | Jackson | Mississippi | 28059 | 1596 | 27 |
371297 | 371297 | 2020-07-26 | Jackson | Mississippi | 28059 | 1582 | 27 |
368087 | 368087 | 2020-07-25 | Jackson | Mississippi | 28059 | 1552 | 26 |
364879 | 364879 | 2020-07-24 | Jackson | Mississippi | 28059 | 1481 | 24 |
361672 | 361672 | 2020-07-23 | Jackson | Mississippi | 28059 | 1384 | 24 |
358467 | 358467 | 2020-07-22 | Jackson | Mississippi | 28059 | 1368 | 23 |
355264 | 355264 | 2020-07-21 | Jackson | Mississippi | 28059 | 1183 | 23 |
352062 | 352062 | 2020-07-20 | Jackson | Mississippi | 28059 | 1115 | 22 |
348862 | 348862 | 2020-07-19 | Jackson | Mississippi | 28059 | 1081 | 21 |
345661 | 345661 | 2020-07-18 | Jackson | Mississippi | 28059 | 1018 | 20 |
342461 | 342461 | 2020-07-17 | Jackson | Mississippi | 28059 | 900 | 20 |
339265 | 339265 | 2020-07-16 | Jackson | Mississippi | 28059 | 874 | 20 |
336069 | 336069 | 2020-07-15 | Jackson | Mississippi | 28059 | 828 | 20 |
332876 | 332876 | 2020-07-14 | Jackson | Mississippi | 28059 | 809 | 19 |
329689 | 329689 | 2020-07-13 | Jackson | Mississippi | 28059 | 804 | 19 |
326503 | 326503 | 2020-07-12 | Jackson | Mississippi | 28059 | 798 | 19 |
323320 | 323320 | 2020-07-11 | Jackson | Mississippi | 28059 | 775 | 19 |
320141 | 320141 | 2020-07-10 | Jackson | Mississippi | 28059 | 744 | 18 |
316966 | 316966 | 2020-07-09 | Jackson | Mississippi | 28059 | 727 | 17 |
313792 | 313792 | 2020-07-08 | Jackson | Mississippi | 28059 | 704 | 17 |
310622 | 310622 | 2020-07-07 | Jackson | Mississippi | 28059 | 689 | 17 |
307454 | 307454 | 2020-07-06 | Jackson | Mississippi | 28059 | 638 | 16 |
304287 | 304287 | 2020-07-05 | Jackson | Mississippi | 28059 | 622 | 16 |
301123 | 301123 | 2020-07-04 | Jackson | Mississippi | 28059 | 616 | 16 |
297960 | 297960 | 2020-07-03 | Jackson | Mississippi | 28059 | 584 | 16 |
294802 | 294802 | 2020-07-02 | Jackson | Mississippi | 28059 | 557 | 16 |
291648 | 291648 | 2020-07-01 | Jackson | Mississippi | 28059 | 533 | 16 |
288497 | 288497 | 2020-06-30 | Jackson | Mississippi | 28059 | 505 | 16 |
285347 | 285347 | 2020-06-29 | Jackson | Mississippi | 28059 | 493 | 16 |
282202 | 282202 | 2020-06-28 | Jackson | Mississippi | 28059 | 475 | 16 |
279054 | 279054 | 2020-06-27 | Jackson | Mississippi | 28059 | 473 | 16 |
275906 | 275906 | 2020-06-26 | Jackson | Mississippi | 28059 | 471 | 16 |
272763 | 272763 | 2020-06-25 | Jackson | Mississippi | 28059 | 458 | 16 |
269625 | 269625 | 2020-06-24 | Jackson | Mississippi | 28059 | 439 | 16 |
266492 | 266492 | 2020-06-23 | Jackson | Mississippi | 28059 | 425 | 16 |
263366 | 263366 | 2020-06-22 | Jackson | Mississippi | 28059 | 402 | 16 |
260237 | 260237 | 2020-06-21 | Jackson | Mississippi | 28059 | 385 | 16 |
257111 | 257111 | 2020-06-20 | Jackson | Mississippi | 28059 | 385 | 16 |
253991 | 253991 | 2020-06-19 | Jackson | Mississippi | 28059 | 385 | 16 |
250876 | 250876 | 2020-06-18 | Jackson | Mississippi | 28059 | 385 | 16 |
247764 | 247764 | 2020-06-17 | Jackson | Mississippi | 28059 | 385 | 16 |
244651 | 244651 | 2020-06-16 | Jackson | Mississippi | 28059 | 378 | 16 |
241540 | 241540 | 2020-06-15 | Jackson | Mississippi | 28059 | 367 | 16 |
238431 | 238431 | 2020-06-14 | Jackson | Mississippi | 28059 | 356 | 16 |
235324 | 235324 | 2020-06-13 | Jackson | Mississippi | 28059 | 350 | 16 |
232218 | 232218 | 2020-06-12 | Jackson | Mississippi | 28059 | 344 | 16 |
229114 | 229114 | 2020-06-11 | Jackson | Mississippi | 28059 | 339 | 16 |
226012 | 226012 | 2020-06-10 | Jackson | Mississippi | 28059 | 339 | 16 |
222914 | 222914 | 2020-06-09 | Jackson | Mississippi | 28059 | 338 | 16 |
219819 | 219819 | 2020-06-08 | Jackson | Mississippi | 28059 | 329 | 16 |
216727 | 216727 | 2020-06-07 | Jackson | Mississippi | 28059 | 321 | 15 |
213639 | 213639 | 2020-06-06 | Jackson | Mississippi | 28059 | 317 | 15 |
210555 | 210555 | 2020-06-05 | Jackson | Mississippi | 28059 | 314 | 15 |
207474 | 207474 | 2020-06-04 | Jackson | Mississippi | 28059 | 314 | 15 |
204393 | 204393 | 2020-06-03 | Jackson | Mississippi | 28059 | 309 | 14 |
201316 | 201316 | 2020-06-02 | Jackson | Mississippi | 28059 | 308 | 13 |
198243 | 198243 | 2020-06-01 | Jackson | Mississippi | 28059 | 307 | 13 |
195172 | 195172 | 2020-05-31 | Jackson | Mississippi | 28059 | 308 | 13 |
192104 | 192104 | 2020-05-30 | Jackson | Mississippi | 28059 | 305 | 13 |
189040 | 189040 | 2020-05-29 | Jackson | Mississippi | 28059 | 302 | 13 |
185982 | 185982 | 2020-05-28 | Jackson | Mississippi | 28059 | 303 | 13 |
182926 | 182926 | 2020-05-27 | Jackson | Mississippi | 28059 | 300 | 13 |
179880 | 179880 | 2020-05-26 | Jackson | Mississippi | 28059 | 296 | 13 |
176836 | 176836 | 2020-05-25 | Jackson | Mississippi | 28059 | 296 | 13 |
173793 | 173793 | 2020-05-24 | Jackson | Mississippi | 28059 | 296 | 13 |
170751 | 170751 | 2020-05-23 | Jackson | Mississippi | 28059 | 296 | 13 |
167713 | 167713 | 2020-05-22 | Jackson | Mississippi | 28059 | 291 | 13 |
164677 | 164677 | 2020-05-21 | Jackson | Mississippi | 28059 | 291 | 13 |
161648 | 161648 | 2020-05-20 | Jackson | Mississippi | 28059 | 288 | 13 |
158622 | 158622 | 2020-05-19 | Jackson | Mississippi | 28059 | 287 | 13 |
155604 | 155604 | 2020-05-18 | Jackson | Mississippi | 28059 | 287 | 13 |
152590 | 152590 | 2020-05-17 | Jackson | Mississippi | 28059 | 286 | 13 |
149579 | 149579 | 2020-05-16 | Jackson | Mississippi | 28059 | 284 | 13 |
146574 | 146574 | 2020-05-15 | Jackson | Mississippi | 28059 | 283 | 13 |
143574 | 143574 | 2020-05-14 | Jackson | Mississippi | 28059 | 280 | 13 |
140579 | 140579 | 2020-05-13 | Jackson | Mississippi | 28059 | 278 | 13 |
137585 | 137585 | 2020-05-12 | Jackson | Mississippi | 28059 | 276 | 13 |
134595 | 134595 | 2020-05-11 | Jackson | Mississippi | 28059 | 276 | 11 |
131604 | 131604 | 2020-05-10 | Jackson | Mississippi | 28059 | 275 | 11 |
128614 | 128614 | 2020-05-09 | Jackson | Mississippi | 28059 | 275 | 11 |
125627 | 125627 | 2020-05-08 | Jackson | Mississippi | 28059 | 273 | 11 |
122645 | 122645 | 2020-05-07 | Jackson | Mississippi | 28059 | 272 | 11 |
119671 | 119671 | 2020-05-06 | Jackson | Mississippi | 28059 | 271 | 10 |
116711 | 116711 | 2020-05-05 | Jackson | Mississippi | 28059 | 270 | 9 |
113829 | 113829 | 2020-05-04 | Jackson | Mississippi | 28059 | 267 | 7 |
110950 | 110950 | 2020-05-03 | Jackson | Mississippi | 28059 | 267 | 7 |
108079 | 108079 | 2020-05-02 | Jackson | Mississippi | 28059 | 267 | 7 |
105214 | 105214 | 2020-05-01 | Jackson | Mississippi | 28059 | 267 | 6 |
102353 | 102353 | 2020-04-30 | Jackson | Mississippi | 28059 | 259 | 6 |
99501 | 99501 | 2020-04-29 | Jackson | Mississippi | 28059 | 255 | 6 |
96655 | 96655 | 2020-04-28 | Jackson | Mississippi | 28059 | 252 | 6 |
93819 | 93819 | 2020-04-27 | Jackson | Mississippi | 28059 | 240 | 6 |
90998 | 90998 | 2020-04-26 | Jackson | Mississippi | 28059 | 238 | 6 |
88182 | 88182 | 2020-04-25 | Jackson | Mississippi | 28059 | 237 | 6 |
85372 | 85372 | 2020-04-24 | Jackson | Mississippi | 28059 | 235 | 6 |
82568 | 82568 | 2020-04-23 | Jackson | Mississippi | 28059 | 228 | 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);