ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 5027 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953015 | 953015 | 2021-01-22 | Columbia | Arkansas | 5027 | 1843 | 48 |
949770 | 949770 | 2021-01-21 | Columbia | Arkansas | 5027 | 1825 | 48 |
946524 | 946524 | 2021-01-20 | Columbia | Arkansas | 5027 | 1813 | 47 |
943277 | 943277 | 2021-01-19 | Columbia | Arkansas | 5027 | 1803 | 47 |
940032 | 940032 | 2021-01-18 | Columbia | Arkansas | 5027 | 1798 | 47 |
936787 | 936787 | 2021-01-17 | Columbia | Arkansas | 5027 | 1791 | 47 |
933542 | 933542 | 2021-01-16 | Columbia | Arkansas | 5027 | 1787 | 46 |
930297 | 930297 | 2021-01-15 | Columbia | Arkansas | 5027 | 1773 | 46 |
927052 | 927052 | 2021-01-14 | Columbia | Arkansas | 5027 | 1756 | 46 |
923806 | 923806 | 2021-01-13 | Columbia | Arkansas | 5027 | 1736 | 46 |
920561 | 920561 | 2021-01-12 | Columbia | Arkansas | 5027 | 1724 | 45 |
917316 | 917316 | 2021-01-11 | Columbia | Arkansas | 5027 | 1707 | 45 |
914071 | 914071 | 2021-01-10 | Columbia | Arkansas | 5027 | 1702 | 45 |
910826 | 910826 | 2021-01-09 | Columbia | Arkansas | 5027 | 1698 | 44 |
907581 | 907581 | 2021-01-08 | Columbia | Arkansas | 5027 | 1685 | 44 |
904335 | 904335 | 2021-01-07 | Columbia | Arkansas | 5027 | 1669 | 43 |
901090 | 901090 | 2021-01-06 | Columbia | Arkansas | 5027 | 1660 | 43 |
897845 | 897845 | 2021-01-05 | Columbia | Arkansas | 5027 | 1624 | 43 |
894600 | 894600 | 2021-01-04 | Columbia | Arkansas | 5027 | 1599 | 44 |
891353 | 891353 | 2021-01-03 | Columbia | Arkansas | 5027 | 1597 | 43 |
888106 | 888106 | 2021-01-02 | Columbia | Arkansas | 5027 | 1595 | 43 |
884861 | 884861 | 2021-01-01 | Columbia | Arkansas | 5027 | 1591 | 43 |
881616 | 881616 | 2020-12-31 | Columbia | Arkansas | 5027 | 1567 | 41 |
878371 | 878371 | 2020-12-30 | Columbia | Arkansas | 5027 | 1552 | 41 |
875126 | 875126 | 2020-12-29 | Columbia | Arkansas | 5027 | 1527 | 41 |
871881 | 871881 | 2020-12-28 | Columbia | Arkansas | 5027 | 1511 | 40 |
868636 | 868636 | 2020-12-27 | Columbia | Arkansas | 5027 | 1493 | 40 |
865391 | 865391 | 2020-12-26 | Columbia | Arkansas | 5027 | 1490 | 39 |
862146 | 862146 | 2020-12-25 | Columbia | Arkansas | 5027 | 1489 | 39 |
858901 | 858901 | 2020-12-24 | Columbia | Arkansas | 5027 | 1481 | 39 |
855656 | 855656 | 2020-12-23 | Columbia | Arkansas | 5027 | 1453 | 39 |
852411 | 852411 | 2020-12-22 | Columbia | Arkansas | 5027 | 1436 | 39 |
849166 | 849166 | 2020-12-21 | Columbia | Arkansas | 5027 | 1413 | 38 |
845921 | 845921 | 2020-12-20 | Columbia | Arkansas | 5027 | 1409 | 38 |
842675 | 842675 | 2020-12-19 | Columbia | Arkansas | 5027 | 1404 | 38 |
839430 | 839430 | 2020-12-18 | Columbia | Arkansas | 5027 | 1393 | 38 |
836185 | 836185 | 2020-12-17 | Columbia | Arkansas | 5027 | 1377 | 37 |
832939 | 832939 | 2020-12-16 | Columbia | Arkansas | 5027 | 1359 | 35 |
829692 | 829692 | 2020-12-15 | Columbia | Arkansas | 5027 | 1348 | 35 |
826446 | 826446 | 2020-12-14 | Columbia | Arkansas | 5027 | 1334 | 33 |
823199 | 823199 | 2020-12-13 | Columbia | Arkansas | 5027 | 1322 | 32 |
819953 | 819953 | 2020-12-12 | Columbia | Arkansas | 5027 | 1321 | 29 |
816707 | 816707 | 2020-12-11 | Columbia | Arkansas | 5027 | 1303 | 29 |
813461 | 813461 | 2020-12-10 | Columbia | Arkansas | 5027 | 1265 | 28 |
810217 | 810217 | 2020-12-09 | Columbia | Arkansas | 5027 | 1253 | 27 |
806972 | 806972 | 2020-12-08 | Columbia | Arkansas | 5027 | 1222 | 27 |
803727 | 803727 | 2020-12-07 | Columbia | Arkansas | 5027 | 1203 | 27 |
800482 | 800482 | 2020-12-06 | Columbia | Arkansas | 5027 | 1192 | 27 |
797237 | 797237 | 2020-12-05 | Columbia | Arkansas | 5027 | 1188 | 27 |
793992 | 793992 | 2020-12-04 | Columbia | Arkansas | 5027 | 1174 | 26 |
790747 | 790747 | 2020-12-03 | Columbia | Arkansas | 5027 | 1159 | 25 |
787502 | 787502 | 2020-12-02 | Columbia | Arkansas | 5027 | 1141 | 24 |
784258 | 784258 | 2020-12-01 | Columbia | Arkansas | 5027 | 1127 | 24 |
781013 | 781013 | 2020-11-30 | Columbia | Arkansas | 5027 | 1100 | 24 |
777767 | 777767 | 2020-11-29 | Columbia | Arkansas | 5027 | 1093 | 24 |
774522 | 774522 | 2020-11-28 | Columbia | Arkansas | 5027 | 1083 | 24 |
771277 | 771277 | 2020-11-27 | Columbia | Arkansas | 5027 | 1066 | 24 |
768032 | 768032 | 2020-11-26 | Columbia | Arkansas | 5027 | 1063 | 24 |
764786 | 764786 | 2020-11-25 | Columbia | Arkansas | 5027 | 1054 | 24 |
761541 | 761541 | 2020-11-24 | Columbia | Arkansas | 5027 | 1017 | 24 |
758296 | 758296 | 2020-11-23 | Columbia | Arkansas | 5027 | 1000 | 24 |
755049 | 755049 | 2020-11-22 | Columbia | Arkansas | 5027 | 988 | 24 |
751803 | 751803 | 2020-11-21 | Columbia | Arkansas | 5027 | 979 | 24 |
748557 | 748557 | 2020-11-20 | Columbia | Arkansas | 5027 | 952 | 24 |
745311 | 745311 | 2020-11-19 | Columbia | Arkansas | 5027 | 929 | 23 |
742064 | 742064 | 2020-11-18 | Columbia | Arkansas | 5027 | 913 | 23 |
738817 | 738817 | 2020-11-17 | Columbia | Arkansas | 5027 | 890 | 22 |
735573 | 735573 | 2020-11-16 | Columbia | Arkansas | 5027 | 878 | 22 |
732327 | 732327 | 2020-11-15 | Columbia | Arkansas | 5027 | 870 | 22 |
729082 | 729082 | 2020-11-14 | Columbia | Arkansas | 5027 | 865 | 22 |
725839 | 725839 | 2020-11-13 | Columbia | Arkansas | 5027 | 852 | 22 |
722596 | 722596 | 2020-11-12 | Columbia | Arkansas | 5027 | 839 | 22 |
719353 | 719353 | 2020-11-11 | Columbia | Arkansas | 5027 | 832 | 22 |
716110 | 716110 | 2020-11-10 | Columbia | Arkansas | 5027 | 831 | 22 |
712866 | 712866 | 2020-11-09 | Columbia | Arkansas | 5027 | 807 | 22 |
709622 | 709622 | 2020-11-08 | Columbia | Arkansas | 5027 | 805 | 22 |
706378 | 706378 | 2020-11-07 | Columbia | Arkansas | 5027 | 798 | 22 |
703135 | 703135 | 2020-11-06 | Columbia | Arkansas | 5027 | 790 | 22 |
699892 | 699892 | 2020-11-05 | Columbia | Arkansas | 5027 | 777 | 22 |
696648 | 696648 | 2020-11-04 | Columbia | Arkansas | 5027 | 768 | 22 |
693406 | 693406 | 2020-11-03 | Columbia | Arkansas | 5027 | 764 | 22 |
690163 | 690163 | 2020-11-02 | Columbia | Arkansas | 5027 | 760 | 22 |
686918 | 686918 | 2020-11-01 | Columbia | Arkansas | 5027 | 757 | 21 |
683674 | 683674 | 2020-10-31 | Columbia | Arkansas | 5027 | 745 | 21 |
680431 | 680431 | 2020-10-30 | Columbia | Arkansas | 5027 | 731 | 21 |
677188 | 677188 | 2020-10-29 | Columbia | Arkansas | 5027 | 720 | 21 |
673945 | 673945 | 2020-10-28 | Columbia | Arkansas | 5027 | 711 | 21 |
670703 | 670703 | 2020-10-27 | Columbia | Arkansas | 5027 | 704 | 21 |
667460 | 667460 | 2020-10-26 | Columbia | Arkansas | 5027 | 696 | 20 |
664215 | 664215 | 2020-10-25 | Columbia | Arkansas | 5027 | 690 | 19 |
660971 | 660971 | 2020-10-24 | Columbia | Arkansas | 5027 | 687 | 19 |
657727 | 657727 | 2020-10-23 | Columbia | Arkansas | 5027 | 677 | 19 |
654482 | 654482 | 2020-10-22 | Columbia | Arkansas | 5027 | 667 | 19 |
651237 | 651237 | 2020-10-21 | Columbia | Arkansas | 5027 | 662 | 19 |
647993 | 647993 | 2020-10-20 | Columbia | Arkansas | 5027 | 660 | 19 |
644748 | 644748 | 2020-10-19 | Columbia | Arkansas | 5027 | 658 | 19 |
641500 | 641500 | 2020-10-18 | Columbia | Arkansas | 5027 | 654 | 19 |
638253 | 638253 | 2020-10-17 | Columbia | Arkansas | 5027 | 646 | 19 |
635008 | 635008 | 2020-10-16 | Columbia | Arkansas | 5027 | 639 | 19 |
631762 | 631762 | 2020-10-15 | Columbia | Arkansas | 5027 | 634 | 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);