ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28159 and state = "Mississippi" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
279104 | 279104 | 2020-06-27 | Winston | Mississippi | 28159 | 228 | 4 |
282252 | 282252 | 2020-06-28 | Winston | Mississippi | 28159 | 230 | 4 |
285397 | 285397 | 2020-06-29 | Winston | Mississippi | 28159 | 230 | 5 |
288547 | 288547 | 2020-06-30 | Winston | Mississippi | 28159 | 240 | 5 |
291698 | 291698 | 2020-07-01 | Winston | Mississippi | 28159 | 243 | 5 |
294852 | 294852 | 2020-07-02 | Winston | Mississippi | 28159 | 244 | 6 |
298010 | 298010 | 2020-07-03 | Winston | Mississippi | 28159 | 254 | 6 |
301173 | 301173 | 2020-07-04 | Winston | Mississippi | 28159 | 259 | 6 |
304337 | 304337 | 2020-07-05 | Winston | Mississippi | 28159 | 261 | 6 |
307504 | 307504 | 2020-07-06 | Winston | Mississippi | 28159 | 266 | 6 |
310672 | 310672 | 2020-07-07 | Winston | Mississippi | 28159 | 280 | 8 |
313842 | 313842 | 2020-07-08 | Winston | Mississippi | 28159 | 282 | 10 |
317016 | 317016 | 2020-07-09 | Winston | Mississippi | 28159 | 287 | 11 |
320191 | 320191 | 2020-07-10 | Winston | Mississippi | 28159 | 296 | 11 |
323370 | 323370 | 2020-07-11 | Winston | Mississippi | 28159 | 295 | 11 |
326553 | 326553 | 2020-07-12 | Winston | Mississippi | 28159 | 301 | 11 |
329739 | 329739 | 2020-07-13 | Winston | Mississippi | 28159 | 302 | 11 |
332926 | 332926 | 2020-07-14 | Winston | Mississippi | 28159 | 305 | 13 |
336119 | 336119 | 2020-07-15 | Winston | Mississippi | 28159 | 314 | 13 |
339315 | 339315 | 2020-07-16 | Winston | Mississippi | 28159 | 323 | 13 |
342511 | 342511 | 2020-07-17 | Winston | Mississippi | 28159 | 336 | 13 |
345711 | 345711 | 2020-07-18 | Winston | Mississippi | 28159 | 340 | 13 |
348912 | 348912 | 2020-07-19 | Winston | Mississippi | 28159 | 348 | 13 |
352112 | 352112 | 2020-07-20 | Winston | Mississippi | 28159 | 348 | 13 |
355314 | 355314 | 2020-07-21 | Winston | Mississippi | 28159 | 411 | 13 |
358517 | 358517 | 2020-07-22 | Winston | Mississippi | 28159 | 458 | 14 |
361722 | 361722 | 2020-07-23 | Winston | Mississippi | 28159 | 461 | 14 |
364929 | 364929 | 2020-07-24 | Winston | Mississippi | 28159 | 471 | 14 |
368137 | 368137 | 2020-07-25 | Winston | Mississippi | 28159 | 475 | 14 |
371348 | 371348 | 2020-07-26 | Winston | Mississippi | 28159 | 479 | 14 |
374560 | 374560 | 2020-07-27 | Winston | Mississippi | 28159 | 483 | 14 |
377775 | 377775 | 2020-07-28 | Winston | Mississippi | 28159 | 505 | 14 |
380992 | 380992 | 2020-07-29 | Winston | Mississippi | 28159 | 527 | 14 |
384208 | 384208 | 2020-07-30 | Winston | Mississippi | 28159 | 544 | 14 |
387426 | 387426 | 2020-07-31 | Winston | Mississippi | 28159 | 560 | 14 |
390643 | 390643 | 2020-08-01 | Winston | Mississippi | 28159 | 566 | 15 |
393860 | 393860 | 2020-08-02 | Winston | Mississippi | 28159 | 571 | 15 |
397076 | 397076 | 2020-08-03 | Winston | Mississippi | 28159 | 571 | 15 |
400290 | 400290 | 2020-08-04 | Winston | Mississippi | 28159 | 584 | 15 |
403507 | 403507 | 2020-08-05 | Winston | Mississippi | 28159 | 593 | 15 |
406725 | 406725 | 2020-08-06 | Winston | Mississippi | 28159 | 604 | 15 |
409945 | 409945 | 2020-08-07 | Winston | Mississippi | 28159 | 611 | 16 |
413165 | 413165 | 2020-08-08 | Winston | Mississippi | 28159 | 620 | 16 |
416385 | 416385 | 2020-08-09 | Winston | Mississippi | 28159 | 620 | 16 |
419606 | 419606 | 2020-08-10 | Winston | Mississippi | 28159 | 623 | 16 |
422828 | 422828 | 2020-08-11 | Winston | Mississippi | 28159 | 629 | 16 |
426050 | 426050 | 2020-08-12 | Winston | Mississippi | 28159 | 635 | 16 |
429274 | 429274 | 2020-08-13 | Winston | Mississippi | 28159 | 637 | 16 |
432501 | 432501 | 2020-08-14 | Winston | Mississippi | 28159 | 644 | 17 |
435727 | 435727 | 2020-08-15 | Winston | Mississippi | 28159 | 652 | 18 |
438952 | 438952 | 2020-08-16 | Winston | Mississippi | 28159 | 652 | 18 |
442179 | 442179 | 2020-08-17 | Winston | Mississippi | 28159 | 653 | 18 |
445405 | 445405 | 2020-08-18 | Winston | Mississippi | 28159 | 653 | 18 |
448631 | 448631 | 2020-08-19 | Winston | Mississippi | 28159 | 658 | 18 |
451859 | 451859 | 2020-08-20 | Winston | Mississippi | 28159 | 667 | 18 |
455087 | 455087 | 2020-08-21 | Winston | Mississippi | 28159 | 674 | 18 |
458315 | 458315 | 2020-08-22 | Winston | Mississippi | 28159 | 678 | 18 |
461542 | 461542 | 2020-08-23 | Winston | Mississippi | 28159 | 681 | 18 |
464773 | 464773 | 2020-08-24 | Winston | Mississippi | 28159 | 682 | 18 |
468002 | 468002 | 2020-08-25 | Winston | Mississippi | 28159 | 688 | 18 |
471232 | 471232 | 2020-08-26 | Winston | Mississippi | 28159 | 691 | 19 |
474464 | 474464 | 2020-08-27 | Winston | Mississippi | 28159 | 688 | 19 |
477697 | 477697 | 2020-08-28 | Winston | Mississippi | 28159 | 690 | 19 |
480929 | 480929 | 2020-08-29 | Winston | Mississippi | 28159 | 691 | 19 |
484164 | 484164 | 2020-08-30 | Winston | Mississippi | 28159 | 694 | 19 |
487398 | 487398 | 2020-08-31 | Winston | Mississippi | 28159 | 695 | 19 |
490631 | 490631 | 2020-09-01 | Winston | Mississippi | 28159 | 696 | 19 |
493865 | 493865 | 2020-09-02 | Winston | Mississippi | 28159 | 701 | 19 |
497098 | 497098 | 2020-09-03 | Winston | Mississippi | 28159 | 704 | 19 |
500332 | 500332 | 2020-09-04 | Winston | Mississippi | 28159 | 708 | 19 |
503566 | 503566 | 2020-09-05 | Winston | Mississippi | 28159 | 709 | 19 |
506799 | 506799 | 2020-09-06 | Winston | Mississippi | 28159 | 709 | 19 |
510032 | 510032 | 2020-09-07 | Winston | Mississippi | 28159 | 709 | 19 |
513264 | 513264 | 2020-09-08 | Winston | Mississippi | 28159 | 710 | 19 |
516498 | 516498 | 2020-09-09 | Winston | Mississippi | 28159 | 710 | 19 |
519733 | 519733 | 2020-09-10 | Winston | Mississippi | 28159 | 710 | 19 |
522970 | 522970 | 2020-09-11 | Winston | Mississippi | 28159 | 712 | 19 |
526206 | 526206 | 2020-09-12 | Winston | Mississippi | 28159 | 715 | 19 |
529442 | 529442 | 2020-09-13 | Winston | Mississippi | 28159 | 717 | 19 |
532678 | 532678 | 2020-09-14 | Winston | Mississippi | 28159 | 717 | 19 |
535913 | 535913 | 2020-09-15 | Winston | Mississippi | 28159 | 718 | 19 |
539150 | 539150 | 2020-09-16 | Winston | Mississippi | 28159 | 718 | 19 |
542386 | 542386 | 2020-09-17 | Winston | Mississippi | 28159 | 719 | 19 |
545623 | 545623 | 2020-09-18 | Winston | Mississippi | 28159 | 720 | 19 |
548861 | 548861 | 2020-09-19 | Winston | Mississippi | 28159 | 723 | 19 |
552100 | 552100 | 2020-09-20 | Winston | Mississippi | 28159 | 724 | 19 |
555338 | 555338 | 2020-09-21 | Winston | Mississippi | 28159 | 725 | 19 |
558575 | 558575 | 2020-09-22 | Winston | Mississippi | 28159 | 731 | 19 |
561812 | 561812 | 2020-09-23 | Winston | Mississippi | 28159 | 735 | 19 |
565052 | 565052 | 2020-09-24 | Winston | Mississippi | 28159 | 737 | 19 |
568292 | 568292 | 2020-09-25 | Winston | Mississippi | 28159 | 738 | 19 |
571534 | 571534 | 2020-09-26 | Winston | Mississippi | 28159 | 742 | 19 |
574777 | 574777 | 2020-09-27 | Winston | Mississippi | 28159 | 742 | 19 |
578018 | 578018 | 2020-09-28 | Winston | Mississippi | 28159 | 742 | 19 |
581259 | 581259 | 2020-09-29 | Winston | Mississippi | 28159 | 746 | 19 |
584500 | 584500 | 2020-09-30 | Winston | Mississippi | 28159 | 746 | 19 |
587740 | 587740 | 2020-10-01 | Winston | Mississippi | 28159 | 749 | 19 |
590981 | 590981 | 2020-10-02 | Winston | Mississippi | 28159 | 752 | 19 |
594222 | 594222 | 2020-10-03 | Winston | Mississippi | 28159 | 760 | 19 |
597463 | 597463 | 2020-10-04 | Winston | Mississippi | 28159 | 763 | 19 |
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);