ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lawrence" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
730410 | 730410 | 2020-11-14 | Lawrence | Mississippi | 28077 | 633 | 14 |
727167 | 727167 | 2020-11-13 | Lawrence | Mississippi | 28077 | 617 | 14 |
723924 | 723924 | 2020-11-12 | Lawrence | Mississippi | 28077 | 608 | 14 |
720681 | 720681 | 2020-11-11 | Lawrence | Mississippi | 28077 | 604 | 14 |
717438 | 717438 | 2020-11-10 | Lawrence | Mississippi | 28077 | 600 | 14 |
714194 | 714194 | 2020-11-09 | Lawrence | Mississippi | 28077 | 598 | 14 |
710950 | 710950 | 2020-11-08 | Lawrence | Mississippi | 28077 | 596 | 14 |
707706 | 707706 | 2020-11-07 | Lawrence | Mississippi | 28077 | 595 | 14 |
704463 | 704463 | 2020-11-06 | Lawrence | Mississippi | 28077 | 593 | 14 |
701221 | 701221 | 2020-11-05 | Lawrence | Mississippi | 28077 | 589 | 14 |
697977 | 697977 | 2020-11-04 | Lawrence | Mississippi | 28077 | 581 | 14 |
694734 | 694734 | 2020-11-03 | Lawrence | Mississippi | 28077 | 578 | 14 |
691492 | 691492 | 2020-11-02 | Lawrence | Mississippi | 28077 | 574 | 14 |
688247 | 688247 | 2020-11-01 | Lawrence | Mississippi | 28077 | 571 | 14 |
685003 | 685003 | 2020-10-31 | Lawrence | Mississippi | 28077 | 570 | 14 |
681760 | 681760 | 2020-10-30 | Lawrence | Mississippi | 28077 | 562 | 14 |
678516 | 678516 | 2020-10-29 | Lawrence | Mississippi | 28077 | 553 | 14 |
675274 | 675274 | 2020-10-28 | Lawrence | Mississippi | 28077 | 544 | 14 |
672031 | 672031 | 2020-10-27 | Lawrence | Mississippi | 28077 | 534 | 14 |
668789 | 668789 | 2020-10-26 | Lawrence | Mississippi | 28077 | 525 | 14 |
665545 | 665545 | 2020-10-25 | Lawrence | Mississippi | 28077 | 518 | 14 |
662300 | 662300 | 2020-10-24 | Lawrence | Mississippi | 28077 | 518 | 14 |
659056 | 659056 | 2020-10-23 | Lawrence | Mississippi | 28077 | 512 | 14 |
655811 | 655811 | 2020-10-22 | Lawrence | Mississippi | 28077 | 507 | 14 |
652566 | 652566 | 2020-10-21 | Lawrence | Mississippi | 28077 | 504 | 14 |
649321 | 649321 | 2020-10-20 | Lawrence | Mississippi | 28077 | 499 | 14 |
646077 | 646077 | 2020-10-19 | Lawrence | Mississippi | 28077 | 495 | 14 |
642830 | 642830 | 2020-10-18 | Lawrence | Mississippi | 28077 | 489 | 14 |
639583 | 639583 | 2020-10-17 | Lawrence | Mississippi | 28077 | 489 | 14 |
636337 | 636337 | 2020-10-16 | Lawrence | Mississippi | 28077 | 489 | 14 |
633091 | 633091 | 2020-10-15 | Lawrence | Mississippi | 28077 | 483 | 14 |
629846 | 629846 | 2020-10-14 | Lawrence | Mississippi | 28077 | 479 | 14 |
626602 | 626602 | 2020-10-13 | Lawrence | Mississippi | 28077 | 474 | 14 |
623360 | 623360 | 2020-10-12 | Lawrence | Mississippi | 28077 | 469 | 14 |
620117 | 620117 | 2020-10-11 | Lawrence | Mississippi | 28077 | 465 | 14 |
616875 | 616875 | 2020-10-10 | Lawrence | Mississippi | 28077 | 465 | 14 |
613634 | 613634 | 2020-10-09 | Lawrence | Mississippi | 28077 | 463 | 14 |
610392 | 610392 | 2020-10-08 | Lawrence | Mississippi | 28077 | 459 | 14 |
607150 | 607150 | 2020-10-07 | Lawrence | Mississippi | 28077 | 453 | 14 |
603907 | 603907 | 2020-10-06 | Lawrence | Mississippi | 28077 | 449 | 14 |
600665 | 600665 | 2020-10-05 | Lawrence | Mississippi | 28077 | 444 | 14 |
597422 | 597422 | 2020-10-04 | Lawrence | Mississippi | 28077 | 443 | 14 |
594181 | 594181 | 2020-10-03 | Lawrence | Mississippi | 28077 | 441 | 14 |
590940 | 590940 | 2020-10-02 | Lawrence | Mississippi | 28077 | 440 | 14 |
587699 | 587699 | 2020-10-01 | Lawrence | Mississippi | 28077 | 439 | 14 |
584459 | 584459 | 2020-09-30 | Lawrence | Mississippi | 28077 | 439 | 14 |
581218 | 581218 | 2020-09-29 | Lawrence | Mississippi | 28077 | 437 | 14 |
577977 | 577977 | 2020-09-28 | Lawrence | Mississippi | 28077 | 433 | 13 |
574736 | 574736 | 2020-09-27 | Lawrence | Mississippi | 28077 | 433 | 13 |
571493 | 571493 | 2020-09-26 | Lawrence | Mississippi | 28077 | 433 | 13 |
568251 | 568251 | 2020-09-25 | Lawrence | Mississippi | 28077 | 433 | 13 |
565011 | 565011 | 2020-09-24 | Lawrence | Mississippi | 28077 | 431 | 12 |
561771 | 561771 | 2020-09-23 | Lawrence | Mississippi | 28077 | 429 | 12 |
558534 | 558534 | 2020-09-22 | Lawrence | Mississippi | 28077 | 427 | 12 |
555297 | 555297 | 2020-09-21 | Lawrence | Mississippi | 28077 | 425 | 12 |
552059 | 552059 | 2020-09-20 | Lawrence | Mississippi | 28077 | 425 | 12 |
548820 | 548820 | 2020-09-19 | Lawrence | Mississippi | 28077 | 425 | 12 |
545582 | 545582 | 2020-09-18 | Lawrence | Mississippi | 28077 | 423 | 12 |
542345 | 542345 | 2020-09-17 | Lawrence | Mississippi | 28077 | 422 | 12 |
539109 | 539109 | 2020-09-16 | Lawrence | Mississippi | 28077 | 421 | 12 |
535872 | 535872 | 2020-09-15 | Lawrence | Mississippi | 28077 | 421 | 12 |
532637 | 532637 | 2020-09-14 | Lawrence | Mississippi | 28077 | 421 | 12 |
529401 | 529401 | 2020-09-13 | Lawrence | Mississippi | 28077 | 420 | 12 |
526165 | 526165 | 2020-09-12 | Lawrence | Mississippi | 28077 | 420 | 12 |
522929 | 522929 | 2020-09-11 | Lawrence | Mississippi | 28077 | 420 | 12 |
519692 | 519692 | 2020-09-10 | Lawrence | Mississippi | 28077 | 417 | 11 |
516457 | 516457 | 2020-09-09 | Lawrence | Mississippi | 28077 | 414 | 11 |
513223 | 513223 | 2020-09-08 | Lawrence | Mississippi | 28077 | 414 | 11 |
509991 | 509991 | 2020-09-07 | Lawrence | Mississippi | 28077 | 413 | 11 |
506758 | 506758 | 2020-09-06 | Lawrence | Mississippi | 28077 | 413 | 11 |
503525 | 503525 | 2020-09-05 | Lawrence | Mississippi | 28077 | 413 | 11 |
500291 | 500291 | 2020-09-04 | Lawrence | Mississippi | 28077 | 412 | 11 |
497057 | 497057 | 2020-09-03 | Lawrence | Mississippi | 28077 | 412 | 11 |
493824 | 493824 | 2020-09-02 | Lawrence | Mississippi | 28077 | 406 | 11 |
490590 | 490590 | 2020-09-01 | Lawrence | Mississippi | 28077 | 404 | 10 |
487357 | 487357 | 2020-08-31 | Lawrence | Mississippi | 28077 | 402 | 10 |
484123 | 484123 | 2020-08-30 | Lawrence | Mississippi | 28077 | 402 | 10 |
480888 | 480888 | 2020-08-29 | Lawrence | Mississippi | 28077 | 402 | 10 |
477656 | 477656 | 2020-08-28 | Lawrence | Mississippi | 28077 | 400 | 10 |
474423 | 474423 | 2020-08-27 | Lawrence | Mississippi | 28077 | 401 | 10 |
471191 | 471191 | 2020-08-26 | Lawrence | Mississippi | 28077 | 397 | 10 |
467961 | 467961 | 2020-08-25 | Lawrence | Mississippi | 28077 | 391 | 10 |
464732 | 464732 | 2020-08-24 | Lawrence | Mississippi | 28077 | 377 | 9 |
461501 | 461501 | 2020-08-23 | Lawrence | Mississippi | 28077 | 377 | 9 |
458274 | 458274 | 2020-08-22 | Lawrence | Mississippi | 28077 | 373 | 9 |
455046 | 455046 | 2020-08-21 | Lawrence | Mississippi | 28077 | 372 | 9 |
451818 | 451818 | 2020-08-20 | Lawrence | Mississippi | 28077 | 369 | 9 |
448590 | 448590 | 2020-08-19 | Lawrence | Mississippi | 28077 | 367 | 8 |
445364 | 445364 | 2020-08-18 | Lawrence | Mississippi | 28077 | 347 | 8 |
442138 | 442138 | 2020-08-17 | Lawrence | Mississippi | 28077 | 342 | 8 |
438911 | 438911 | 2020-08-16 | Lawrence | Mississippi | 28077 | 342 | 8 |
435686 | 435686 | 2020-08-15 | Lawrence | Mississippi | 28077 | 341 | 8 |
432460 | 432460 | 2020-08-14 | Lawrence | Mississippi | 28077 | 340 | 8 |
429233 | 429233 | 2020-08-13 | Lawrence | Mississippi | 28077 | 332 | 8 |
426009 | 426009 | 2020-08-12 | Lawrence | Mississippi | 28077 | 329 | 8 |
422787 | 422787 | 2020-08-11 | Lawrence | Mississippi | 28077 | 323 | 8 |
419565 | 419565 | 2020-08-10 | Lawrence | Mississippi | 28077 | 322 | 8 |
416344 | 416344 | 2020-08-09 | Lawrence | Mississippi | 28077 | 323 | 8 |
413124 | 413124 | 2020-08-08 | Lawrence | Mississippi | 28077 | 319 | 7 |
409904 | 409904 | 2020-08-07 | Lawrence | Mississippi | 28077 | 312 | 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);