ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Lincoln" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636341 | 636341 | 2020-10-16 | Lincoln | Mississippi | 28085 | 1321 | 54 |
633095 | 633095 | 2020-10-15 | Lincoln | Mississippi | 28085 | 1302 | 54 |
629850 | 629850 | 2020-10-14 | Lincoln | Mississippi | 28085 | 1278 | 54 |
626606 | 626606 | 2020-10-13 | Lincoln | Mississippi | 28085 | 1254 | 53 |
623364 | 623364 | 2020-10-12 | Lincoln | Mississippi | 28085 | 1247 | 53 |
620121 | 620121 | 2020-10-11 | Lincoln | Mississippi | 28085 | 1241 | 53 |
616879 | 616879 | 2020-10-10 | Lincoln | Mississippi | 28085 | 1236 | 53 |
613638 | 613638 | 2020-10-09 | Lincoln | Mississippi | 28085 | 1209 | 53 |
610396 | 610396 | 2020-10-08 | Lincoln | Mississippi | 28085 | 1182 | 53 |
607154 | 607154 | 2020-10-07 | Lincoln | Mississippi | 28085 | 1178 | 53 |
603911 | 603911 | 2020-10-06 | Lincoln | Mississippi | 28085 | 1172 | 53 |
600669 | 600669 | 2020-10-05 | Lincoln | Mississippi | 28085 | 1156 | 53 |
597426 | 597426 | 2020-10-04 | Lincoln | Mississippi | 28085 | 1150 | 53 |
594185 | 594185 | 2020-10-03 | Lincoln | Mississippi | 28085 | 1144 | 53 |
590944 | 590944 | 2020-10-02 | Lincoln | Mississippi | 28085 | 1136 | 53 |
587703 | 587703 | 2020-10-01 | Lincoln | Mississippi | 28085 | 1127 | 53 |
584463 | 584463 | 2020-09-30 | Lincoln | Mississippi | 28085 | 1123 | 53 |
581222 | 581222 | 2020-09-29 | Lincoln | Mississippi | 28085 | 1123 | 53 |
577981 | 577981 | 2020-09-28 | Lincoln | Mississippi | 28085 | 1114 | 53 |
574740 | 574740 | 2020-09-27 | Lincoln | Mississippi | 28085 | 1104 | 53 |
571497 | 571497 | 2020-09-26 | Lincoln | Mississippi | 28085 | 1102 | 53 |
568255 | 568255 | 2020-09-25 | Lincoln | Mississippi | 28085 | 1090 | 53 |
565015 | 565015 | 2020-09-24 | Lincoln | Mississippi | 28085 | 1083 | 53 |
561775 | 561775 | 2020-09-23 | Lincoln | Mississippi | 28085 | 1075 | 53 |
558538 | 558538 | 2020-09-22 | Lincoln | Mississippi | 28085 | 1073 | 53 |
555301 | 555301 | 2020-09-21 | Lincoln | Mississippi | 28085 | 1068 | 53 |
552063 | 552063 | 2020-09-20 | Lincoln | Mississippi | 28085 | 1067 | 53 |
548824 | 548824 | 2020-09-19 | Lincoln | Mississippi | 28085 | 1062 | 53 |
545586 | 545586 | 2020-09-18 | Lincoln | Mississippi | 28085 | 1049 | 53 |
542349 | 542349 | 2020-09-17 | Lincoln | Mississippi | 28085 | 1044 | 53 |
539113 | 539113 | 2020-09-16 | Lincoln | Mississippi | 28085 | 1026 | 52 |
535876 | 535876 | 2020-09-15 | Lincoln | Mississippi | 28085 | 1026 | 52 |
532641 | 532641 | 2020-09-14 | Lincoln | Mississippi | 28085 | 1025 | 52 |
529405 | 529405 | 2020-09-13 | Lincoln | Mississippi | 28085 | 1024 | 52 |
526169 | 526169 | 2020-09-12 | Lincoln | Mississippi | 28085 | 1019 | 52 |
522933 | 522933 | 2020-09-11 | Lincoln | Mississippi | 28085 | 1017 | 52 |
519696 | 519696 | 2020-09-10 | Lincoln | Mississippi | 28085 | 1014 | 52 |
516461 | 516461 | 2020-09-09 | Lincoln | Mississippi | 28085 | 1009 | 52 |
513227 | 513227 | 2020-09-08 | Lincoln | Mississippi | 28085 | 1007 | 52 |
509995 | 509995 | 2020-09-07 | Lincoln | Mississippi | 28085 | 1007 | 52 |
506762 | 506762 | 2020-09-06 | Lincoln | Mississippi | 28085 | 1005 | 52 |
503529 | 503529 | 2020-09-05 | Lincoln | Mississippi | 28085 | 1002 | 52 |
500295 | 500295 | 2020-09-04 | Lincoln | Mississippi | 28085 | 995 | 52 |
497061 | 497061 | 2020-09-03 | Lincoln | Mississippi | 28085 | 986 | 52 |
493828 | 493828 | 2020-09-02 | Lincoln | Mississippi | 28085 | 981 | 51 |
490594 | 490594 | 2020-09-01 | Lincoln | Mississippi | 28085 | 974 | 51 |
487361 | 487361 | 2020-08-31 | Lincoln | Mississippi | 28085 | 971 | 51 |
484127 | 484127 | 2020-08-30 | Lincoln | Mississippi | 28085 | 970 | 51 |
480892 | 480892 | 2020-08-29 | Lincoln | Mississippi | 28085 | 962 | 51 |
477660 | 477660 | 2020-08-28 | Lincoln | Mississippi | 28085 | 954 | 50 |
474427 | 474427 | 2020-08-27 | Lincoln | Mississippi | 28085 | 944 | 50 |
471195 | 471195 | 2020-08-26 | Lincoln | Mississippi | 28085 | 941 | 49 |
467965 | 467965 | 2020-08-25 | Lincoln | Mississippi | 28085 | 937 | 49 |
464736 | 464736 | 2020-08-24 | Lincoln | Mississippi | 28085 | 926 | 46 |
461505 | 461505 | 2020-08-23 | Lincoln | Mississippi | 28085 | 924 | 46 |
458278 | 458278 | 2020-08-22 | Lincoln | Mississippi | 28085 | 917 | 46 |
455050 | 455050 | 2020-08-21 | Lincoln | Mississippi | 28085 | 913 | 46 |
451822 | 451822 | 2020-08-20 | Lincoln | Mississippi | 28085 | 903 | 46 |
448594 | 448594 | 2020-08-19 | Lincoln | Mississippi | 28085 | 896 | 46 |
445368 | 445368 | 2020-08-18 | Lincoln | Mississippi | 28085 | 885 | 45 |
442142 | 442142 | 2020-08-17 | Lincoln | Mississippi | 28085 | 879 | 45 |
438915 | 438915 | 2020-08-16 | Lincoln | Mississippi | 28085 | 876 | 45 |
435690 | 435690 | 2020-08-15 | Lincoln | Mississippi | 28085 | 871 | 44 |
432464 | 432464 | 2020-08-14 | Lincoln | Mississippi | 28085 | 862 | 44 |
429237 | 429237 | 2020-08-13 | Lincoln | Mississippi | 28085 | 849 | 43 |
426013 | 426013 | 2020-08-12 | Lincoln | Mississippi | 28085 | 846 | 43 |
422791 | 422791 | 2020-08-11 | Lincoln | Mississippi | 28085 | 834 | 42 |
419569 | 419569 | 2020-08-10 | Lincoln | Mississippi | 28085 | 832 | 41 |
416348 | 416348 | 2020-08-09 | Lincoln | Mississippi | 28085 | 817 | 41 |
413128 | 413128 | 2020-08-08 | Lincoln | Mississippi | 28085 | 809 | 41 |
409908 | 409908 | 2020-08-07 | Lincoln | Mississippi | 28085 | 796 | 41 |
406688 | 406688 | 2020-08-06 | Lincoln | Mississippi | 28085 | 790 | 41 |
403470 | 403470 | 2020-08-05 | Lincoln | Mississippi | 28085 | 787 | 41 |
400253 | 400253 | 2020-08-04 | Lincoln | Mississippi | 28085 | 756 | 41 |
397039 | 397039 | 2020-08-03 | Lincoln | Mississippi | 28085 | 745 | 40 |
393823 | 393823 | 2020-08-02 | Lincoln | Mississippi | 28085 | 743 | 39 |
390606 | 390606 | 2020-08-01 | Lincoln | Mississippi | 28085 | 735 | 39 |
387389 | 387389 | 2020-07-31 | Lincoln | Mississippi | 28085 | 730 | 38 |
384171 | 384171 | 2020-07-30 | Lincoln | Mississippi | 28085 | 716 | 38 |
380954 | 380954 | 2020-07-29 | Lincoln | Mississippi | 28085 | 698 | 38 |
377737 | 377737 | 2020-07-28 | Lincoln | Mississippi | 28085 | 688 | 38 |
374522 | 374522 | 2020-07-27 | Lincoln | Mississippi | 28085 | 681 | 38 |
371310 | 371310 | 2020-07-26 | Lincoln | Mississippi | 28085 | 681 | 38 |
368100 | 368100 | 2020-07-25 | Lincoln | Mississippi | 28085 | 661 | 38 |
364892 | 364892 | 2020-07-24 | Lincoln | Mississippi | 28085 | 649 | 38 |
361685 | 361685 | 2020-07-23 | Lincoln | Mississippi | 28085 | 640 | 37 |
358480 | 358480 | 2020-07-22 | Lincoln | Mississippi | 28085 | 622 | 37 |
355277 | 355277 | 2020-07-21 | Lincoln | Mississippi | 28085 | 618 | 36 |
352075 | 352075 | 2020-07-20 | Lincoln | Mississippi | 28085 | 602 | 36 |
348875 | 348875 | 2020-07-19 | Lincoln | Mississippi | 28085 | 593 | 36 |
345674 | 345674 | 2020-07-18 | Lincoln | Mississippi | 28085 | 590 | 35 |
342474 | 342474 | 2020-07-17 | Lincoln | Mississippi | 28085 | 570 | 36 |
339278 | 339278 | 2020-07-16 | Lincoln | Mississippi | 28085 | 561 | 36 |
336082 | 336082 | 2020-07-15 | Lincoln | Mississippi | 28085 | 544 | 36 |
332889 | 332889 | 2020-07-14 | Lincoln | Mississippi | 28085 | 541 | 36 |
329702 | 329702 | 2020-07-13 | Lincoln | Mississippi | 28085 | 538 | 35 |
326516 | 326516 | 2020-07-12 | Lincoln | Mississippi | 28085 | 533 | 35 |
323333 | 323333 | 2020-07-11 | Lincoln | Mississippi | 28085 | 529 | 35 |
320154 | 320154 | 2020-07-10 | Lincoln | Mississippi | 28085 | 519 | 35 |
316979 | 316979 | 2020-07-09 | Lincoln | Mississippi | 28085 | 509 | 35 |
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);