ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lawrence" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917340 | 917340 | 2021-01-11 | Lawrence | Arkansas | 5075 | 1729 | 39 |
914095 | 914095 | 2021-01-10 | Lawrence | Arkansas | 5075 | 1723 | 38 |
910850 | 910850 | 2021-01-09 | Lawrence | Arkansas | 5075 | 1717 | 37 |
907605 | 907605 | 2021-01-08 | Lawrence | Arkansas | 5075 | 1703 | 37 |
904359 | 904359 | 2021-01-07 | Lawrence | Arkansas | 5075 | 1683 | 36 |
901114 | 901114 | 2021-01-06 | Lawrence | Arkansas | 5075 | 1667 | 36 |
897869 | 897869 | 2021-01-05 | Lawrence | Arkansas | 5075 | 1651 | 36 |
894624 | 894624 | 2021-01-04 | Lawrence | Arkansas | 5075 | 1626 | 36 |
891377 | 891377 | 2021-01-03 | Lawrence | Arkansas | 5075 | 1621 | 36 |
888130 | 888130 | 2021-01-02 | Lawrence | Arkansas | 5075 | 1600 | 36 |
884885 | 884885 | 2021-01-01 | Lawrence | Arkansas | 5075 | 1587 | 35 |
881640 | 881640 | 2020-12-31 | Lawrence | Arkansas | 5075 | 1574 | 35 |
878395 | 878395 | 2020-12-30 | Lawrence | Arkansas | 5075 | 1568 | 35 |
875150 | 875150 | 2020-12-29 | Lawrence | Arkansas | 5075 | 1543 | 35 |
871905 | 871905 | 2020-12-28 | Lawrence | Arkansas | 5075 | 1526 | 34 |
868660 | 868660 | 2020-12-27 | Lawrence | Arkansas | 5075 | 1509 | 34 |
865415 | 865415 | 2020-12-26 | Lawrence | Arkansas | 5075 | 1502 | 34 |
862170 | 862170 | 2020-12-25 | Lawrence | Arkansas | 5075 | 1495 | 34 |
858925 | 858925 | 2020-12-24 | Lawrence | Arkansas | 5075 | 1472 | 34 |
855680 | 855680 | 2020-12-23 | Lawrence | Arkansas | 5075 | 1450 | 34 |
852435 | 852435 | 2020-12-22 | Lawrence | Arkansas | 5075 | 1435 | 34 |
849190 | 849190 | 2020-12-21 | Lawrence | Arkansas | 5075 | 1429 | 34 |
845945 | 845945 | 2020-12-20 | Lawrence | Arkansas | 5075 | 1419 | 34 |
842699 | 842699 | 2020-12-19 | Lawrence | Arkansas | 5075 | 1391 | 33 |
839454 | 839454 | 2020-12-18 | Lawrence | Arkansas | 5075 | 1386 | 33 |
836209 | 836209 | 2020-12-17 | Lawrence | Arkansas | 5075 | 1370 | 33 |
832963 | 832963 | 2020-12-16 | Lawrence | Arkansas | 5075 | 1356 | 33 |
829716 | 829716 | 2020-12-15 | Lawrence | Arkansas | 5075 | 1350 | 33 |
826470 | 826470 | 2020-12-14 | Lawrence | Arkansas | 5075 | 1338 | 33 |
823223 | 823223 | 2020-12-13 | Lawrence | Arkansas | 5075 | 1333 | 33 |
819977 | 819977 | 2020-12-12 | Lawrence | Arkansas | 5075 | 1318 | 33 |
816731 | 816731 | 2020-12-11 | Lawrence | Arkansas | 5075 | 1300 | 33 |
813485 | 813485 | 2020-12-10 | Lawrence | Arkansas | 5075 | 1282 | 32 |
810241 | 810241 | 2020-12-09 | Lawrence | Arkansas | 5075 | 1279 | 32 |
806996 | 806996 | 2020-12-08 | Lawrence | Arkansas | 5075 | 1277 | 32 |
803751 | 803751 | 2020-12-07 | Lawrence | Arkansas | 5075 | 1262 | 32 |
800506 | 800506 | 2020-12-06 | Lawrence | Arkansas | 5075 | 1259 | 32 |
797261 | 797261 | 2020-12-05 | Lawrence | Arkansas | 5075 | 1250 | 32 |
794016 | 794016 | 2020-12-04 | Lawrence | Arkansas | 5075 | 1235 | 31 |
790771 | 790771 | 2020-12-03 | Lawrence | Arkansas | 5075 | 1210 | 31 |
787526 | 787526 | 2020-12-02 | Lawrence | Arkansas | 5075 | 1207 | 30 |
784282 | 784282 | 2020-12-01 | Lawrence | Arkansas | 5075 | 1181 | 29 |
781037 | 781037 | 2020-11-30 | Lawrence | Arkansas | 5075 | 1171 | 29 |
777791 | 777791 | 2020-11-29 | Lawrence | Arkansas | 5075 | 1164 | 28 |
774546 | 774546 | 2020-11-28 | Lawrence | Arkansas | 5075 | 1161 | 28 |
771301 | 771301 | 2020-11-27 | Lawrence | Arkansas | 5075 | 1148 | 28 |
768056 | 768056 | 2020-11-26 | Lawrence | Arkansas | 5075 | 1140 | 28 |
764810 | 764810 | 2020-11-25 | Lawrence | Arkansas | 5075 | 1120 | 28 |
761565 | 761565 | 2020-11-24 | Lawrence | Arkansas | 5075 | 1108 | 28 |
758320 | 758320 | 2020-11-23 | Lawrence | Arkansas | 5075 | 1096 | 28 |
755073 | 755073 | 2020-11-22 | Lawrence | Arkansas | 5075 | 1090 | 28 |
751827 | 751827 | 2020-11-21 | Lawrence | Arkansas | 5075 | 1080 | 28 |
748581 | 748581 | 2020-11-20 | Lawrence | Arkansas | 5075 | 1070 | 28 |
745335 | 745335 | 2020-11-19 | Lawrence | Arkansas | 5075 | 1054 | 27 |
742088 | 742088 | 2020-11-18 | Lawrence | Arkansas | 5075 | 1041 | 27 |
738841 | 738841 | 2020-11-17 | Lawrence | Arkansas | 5075 | 1034 | 27 |
735597 | 735597 | 2020-11-16 | Lawrence | Arkansas | 5075 | 1025 | 27 |
732351 | 732351 | 2020-11-15 | Lawrence | Arkansas | 5075 | 1018 | 26 |
729106 | 729106 | 2020-11-14 | Lawrence | Arkansas | 5075 | 1015 | 25 |
725863 | 725863 | 2020-11-13 | Lawrence | Arkansas | 5075 | 998 | 25 |
722620 | 722620 | 2020-11-12 | Lawrence | Arkansas | 5075 | 986 | 25 |
719377 | 719377 | 2020-11-11 | Lawrence | Arkansas | 5075 | 976 | 25 |
716134 | 716134 | 2020-11-10 | Lawrence | Arkansas | 5075 | 965 | 24 |
712890 | 712890 | 2020-11-09 | Lawrence | Arkansas | 5075 | 955 | 24 |
709646 | 709646 | 2020-11-08 | Lawrence | Arkansas | 5075 | 955 | 23 |
706402 | 706402 | 2020-11-07 | Lawrence | Arkansas | 5075 | 943 | 22 |
703159 | 703159 | 2020-11-06 | Lawrence | Arkansas | 5075 | 938 | 22 |
699916 | 699916 | 2020-11-05 | Lawrence | Arkansas | 5075 | 926 | 22 |
696672 | 696672 | 2020-11-04 | Lawrence | Arkansas | 5075 | 917 | 22 |
693430 | 693430 | 2020-11-03 | Lawrence | Arkansas | 5075 | 902 | 22 |
690187 | 690187 | 2020-11-02 | Lawrence | Arkansas | 5075 | 893 | 22 |
686942 | 686942 | 2020-11-01 | Lawrence | Arkansas | 5075 | 884 | 21 |
683698 | 683698 | 2020-10-31 | Lawrence | Arkansas | 5075 | 873 | 20 |
680455 | 680455 | 2020-10-30 | Lawrence | Arkansas | 5075 | 859 | 19 |
677212 | 677212 | 2020-10-29 | Lawrence | Arkansas | 5075 | 848 | 19 |
673969 | 673969 | 2020-10-28 | Lawrence | Arkansas | 5075 | 833 | 18 |
670727 | 670727 | 2020-10-27 | Lawrence | Arkansas | 5075 | 823 | 17 |
667484 | 667484 | 2020-10-26 | Lawrence | Arkansas | 5075 | 808 | 17 |
664239 | 664239 | 2020-10-25 | Lawrence | Arkansas | 5075 | 804 | 17 |
660995 | 660995 | 2020-10-24 | Lawrence | Arkansas | 5075 | 795 | 17 |
657751 | 657751 | 2020-10-23 | Lawrence | Arkansas | 5075 | 782 | 17 |
654506 | 654506 | 2020-10-22 | Lawrence | Arkansas | 5075 | 766 | 17 |
651261 | 651261 | 2020-10-21 | Lawrence | Arkansas | 5075 | 758 | 17 |
648017 | 648017 | 2020-10-20 | Lawrence | Arkansas | 5075 | 747 | 15 |
644772 | 644772 | 2020-10-19 | Lawrence | Arkansas | 5075 | 731 | 14 |
641524 | 641524 | 2020-10-18 | Lawrence | Arkansas | 5075 | 722 | 14 |
638277 | 638277 | 2020-10-17 | Lawrence | Arkansas | 5075 | 718 | 14 |
635032 | 635032 | 2020-10-16 | Lawrence | Arkansas | 5075 | 700 | 14 |
631786 | 631786 | 2020-10-15 | Lawrence | Arkansas | 5075 | 693 | 14 |
628542 | 628542 | 2020-10-14 | Lawrence | Arkansas | 5075 | 640 | 13 |
625299 | 625299 | 2020-10-13 | Lawrence | Arkansas | 5075 | 613 | 13 |
622056 | 622056 | 2020-10-12 | Lawrence | Arkansas | 5075 | 604 | 13 |
618813 | 618813 | 2020-10-11 | Lawrence | Arkansas | 5075 | 592 | 13 |
615571 | 615571 | 2020-10-10 | Lawrence | Arkansas | 5075 | 583 | 13 |
612330 | 612330 | 2020-10-09 | Lawrence | Arkansas | 5075 | 567 | 13 |
609088 | 609088 | 2020-10-08 | Lawrence | Arkansas | 5075 | 546 | 13 |
605845 | 605845 | 2020-10-07 | Lawrence | Arkansas | 5075 | 508 | 13 |
602603 | 602603 | 2020-10-06 | Lawrence | Arkansas | 5075 | 501 | 13 |
599360 | 599360 | 2020-10-05 | Lawrence | Arkansas | 5075 | 495 | 13 |
596117 | 596117 | 2020-10-04 | Lawrence | Arkansas | 5075 | 492 | 13 |
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);