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 |
---|---|---|---|---|---|---|---|
535863 | 535863 | 2020-09-15 | Jackson | Mississippi | 28059 | 3301 | 66 |
532628 | 532628 | 2020-09-14 | Jackson | Mississippi | 28059 | 3297 | 66 |
529392 | 529392 | 2020-09-13 | Jackson | Mississippi | 28059 | 3290 | 66 |
526156 | 526156 | 2020-09-12 | Jackson | Mississippi | 28059 | 3285 | 66 |
522920 | 522920 | 2020-09-11 | Jackson | Mississippi | 28059 | 3270 | 65 |
519683 | 519683 | 2020-09-10 | Jackson | Mississippi | 28059 | 3244 | 65 |
516448 | 516448 | 2020-09-09 | Jackson | Mississippi | 28059 | 3218 | 64 |
513214 | 513214 | 2020-09-08 | Jackson | Mississippi | 28059 | 3198 | 60 |
509982 | 509982 | 2020-09-07 | Jackson | Mississippi | 28059 | 3172 | 60 |
506749 | 506749 | 2020-09-06 | Jackson | Mississippi | 28059 | 3158 | 60 |
503516 | 503516 | 2020-09-05 | Jackson | Mississippi | 28059 | 3147 | 60 |
500282 | 500282 | 2020-09-04 | Jackson | Mississippi | 28059 | 3126 | 60 |
497048 | 497048 | 2020-09-03 | Jackson | Mississippi | 28059 | 3095 | 60 |
493815 | 493815 | 2020-09-02 | Jackson | Mississippi | 28059 | 3073 | 60 |
490581 | 490581 | 2020-09-01 | Jackson | Mississippi | 28059 | 3052 | 60 |
487348 | 487348 | 2020-08-31 | Jackson | Mississippi | 28059 | 3005 | 60 |
484114 | 484114 | 2020-08-30 | Jackson | Mississippi | 28059 | 2990 | 60 |
480879 | 480879 | 2020-08-29 | Jackson | Mississippi | 28059 | 2946 | 59 |
477647 | 477647 | 2020-08-28 | Jackson | Mississippi | 28059 | 2932 | 59 |
474414 | 474414 | 2020-08-27 | Jackson | Mississippi | 28059 | 2897 | 59 |
471182 | 471182 | 2020-08-26 | Jackson | Mississippi | 28059 | 2879 | 59 |
467952 | 467952 | 2020-08-25 | Jackson | Mississippi | 28059 | 2830 | 57 |
464723 | 464723 | 2020-08-24 | Jackson | Mississippi | 28059 | 2775 | 54 |
461492 | 461492 | 2020-08-23 | Jackson | Mississippi | 28059 | 2753 | 54 |
458265 | 458265 | 2020-08-22 | Jackson | Mississippi | 28059 | 2720 | 54 |
455037 | 455037 | 2020-08-21 | Jackson | Mississippi | 28059 | 2696 | 53 |
451809 | 451809 | 2020-08-20 | Jackson | Mississippi | 28059 | 2650 | 52 |
448581 | 448581 | 2020-08-19 | Jackson | Mississippi | 28059 | 2594 | 50 |
445355 | 445355 | 2020-08-18 | Jackson | Mississippi | 28059 | 2518 | 48 |
442129 | 442129 | 2020-08-17 | Jackson | Mississippi | 28059 | 2482 | 47 |
438902 | 438902 | 2020-08-16 | Jackson | Mississippi | 28059 | 2462 | 47 |
435677 | 435677 | 2020-08-15 | Jackson | Mississippi | 28059 | 2449 | 47 |
432451 | 432451 | 2020-08-14 | Jackson | Mississippi | 28059 | 2430 | 47 |
429224 | 429224 | 2020-08-13 | Jackson | Mississippi | 28059 | 2411 | 47 |
426000 | 426000 | 2020-08-12 | Jackson | Mississippi | 28059 | 2391 | 45 |
422778 | 422778 | 2020-08-11 | Jackson | Mississippi | 28059 | 2314 | 44 |
419556 | 419556 | 2020-08-10 | Jackson | Mississippi | 28059 | 2288 | 43 |
416335 | 416335 | 2020-08-09 | Jackson | Mississippi | 28059 | 2276 | 42 |
413115 | 413115 | 2020-08-08 | Jackson | Mississippi | 28059 | 2269 | 42 |
409895 | 409895 | 2020-08-07 | Jackson | Mississippi | 28059 | 2225 | 42 |
406675 | 406675 | 2020-08-06 | Jackson | Mississippi | 28059 | 2201 | 42 |
403457 | 403457 | 2020-08-05 | Jackson | Mississippi | 28059 | 2156 | 41 |
400240 | 400240 | 2020-08-04 | Jackson | Mississippi | 28059 | 2063 | 38 |
397026 | 397026 | 2020-08-03 | Jackson | Mississippi | 28059 | 1994 | 34 |
393810 | 393810 | 2020-08-02 | Jackson | Mississippi | 28059 | 1929 | 34 |
390593 | 390593 | 2020-08-01 | Jackson | Mississippi | 28059 | 1874 | 34 |
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 |
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);