ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 5085 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092605 | 1092605 | 2021-03-06 | Lonoke | Arkansas | 5085 | 6897 | 106 |
1089359 | 1089359 | 2021-03-05 | Lonoke | Arkansas | 5085 | 6886 | 105 |
1086114 | 1086114 | 2021-03-04 | Lonoke | Arkansas | 5085 | 6866 | 105 |
1082868 | 1082868 | 2021-03-03 | Lonoke | Arkansas | 5085 | 6849 | 105 |
1079622 | 1079622 | 2021-03-02 | Lonoke | Arkansas | 5085 | 6838 | 105 |
1076377 | 1076377 | 2021-03-01 | Lonoke | Arkansas | 5085 | 6811 | 105 |
1073131 | 1073131 | 2021-02-28 | Lonoke | Arkansas | 5085 | 6802 | 105 |
1069885 | 1069885 | 2021-02-27 | Lonoke | Arkansas | 5085 | 6783 | 111 |
1066640 | 1066640 | 2021-02-26 | Lonoke | Arkansas | 5085 | 6769 | 110 |
1063395 | 1063395 | 2021-02-25 | Lonoke | Arkansas | 5085 | 6751 | 110 |
1060150 | 1060150 | 2021-02-24 | Lonoke | Arkansas | 5085 | 6732 | 109 |
1056904 | 1056904 | 2021-02-23 | Lonoke | Arkansas | 5085 | 6706 | 108 |
1053658 | 1053658 | 2021-02-22 | Lonoke | Arkansas | 5085 | 6672 | 108 |
1050411 | 1050411 | 2021-02-21 | Lonoke | Arkansas | 5085 | 6663 | 108 |
1047164 | 1047164 | 2021-02-20 | Lonoke | Arkansas | 5085 | 6652 | 108 |
1043919 | 1043919 | 2021-02-19 | Lonoke | Arkansas | 5085 | 6643 | 108 |
1040674 | 1040674 | 2021-02-18 | Lonoke | Arkansas | 5085 | 6634 | 108 |
1037429 | 1037429 | 2021-02-17 | Lonoke | Arkansas | 5085 | 6626 | 108 |
1034184 | 1034184 | 2021-02-16 | Lonoke | Arkansas | 5085 | 6613 | 108 |
1030938 | 1030938 | 2021-02-15 | Lonoke | Arkansas | 5085 | 6598 | 108 |
1027691 | 1027691 | 2021-02-14 | Lonoke | Arkansas | 5085 | 6581 | 108 |
1024446 | 1024446 | 2021-02-13 | Lonoke | Arkansas | 5085 | 6568 | 107 |
1021201 | 1021201 | 2021-02-12 | Lonoke | Arkansas | 5085 | 6533 | 107 |
1017956 | 1017956 | 2021-02-11 | Lonoke | Arkansas | 5085 | 6512 | 107 |
1014711 | 1014711 | 2021-02-10 | Lonoke | Arkansas | 5085 | 6466 | 106 |
1011466 | 1011466 | 2021-02-09 | Lonoke | Arkansas | 5085 | 6415 | 106 |
1008220 | 1008220 | 2021-02-08 | Lonoke | Arkansas | 5085 | 6339 | 106 |
1004974 | 1004974 | 2021-02-07 | Lonoke | Arkansas | 5085 | 6304 | 106 |
1001728 | 1001728 | 2021-02-06 | Lonoke | Arkansas | 5085 | 6275 | 106 |
998482 | 998482 | 2021-02-05 | Lonoke | Arkansas | 5085 | 6220 | 106 |
995236 | 995236 | 2021-02-04 | Lonoke | Arkansas | 5085 | 6153 | 103 |
991990 | 991990 | 2021-02-03 | Lonoke | Arkansas | 5085 | 6103 | 103 |
988744 | 988744 | 2021-02-02 | Lonoke | Arkansas | 5085 | 6044 | 103 |
985497 | 985497 | 2021-02-01 | Lonoke | Arkansas | 5085 | 5993 | 103 |
982250 | 982250 | 2021-01-31 | Lonoke | Arkansas | 5085 | 5963 | 103 |
979004 | 979004 | 2021-01-30 | Lonoke | Arkansas | 5085 | 5939 | 103 |
975759 | 975759 | 2021-01-29 | Lonoke | Arkansas | 5085 | 5883 | 102 |
972514 | 972514 | 2021-01-28 | Lonoke | Arkansas | 5085 | 5836 | 101 |
969269 | 969269 | 2021-01-27 | Lonoke | Arkansas | 5085 | 5780 | 101 |
966025 | 966025 | 2021-01-26 | Lonoke | Arkansas | 5085 | 5710 | 101 |
962780 | 962780 | 2021-01-25 | Lonoke | Arkansas | 5085 | 5641 | 100 |
959535 | 959535 | 2021-01-24 | Lonoke | Arkansas | 5085 | 5630 | 99 |
956289 | 956289 | 2021-01-23 | Lonoke | Arkansas | 5085 | 5599 | 98 |
953044 | 953044 | 2021-01-22 | Lonoke | Arkansas | 5085 | 5544 | 98 |
949799 | 949799 | 2021-01-21 | Lonoke | Arkansas | 5085 | 5493 | 98 |
946553 | 946553 | 2021-01-20 | Lonoke | Arkansas | 5085 | 5393 | 98 |
943306 | 943306 | 2021-01-19 | Lonoke | Arkansas | 5085 | 5330 | 97 |
940061 | 940061 | 2021-01-18 | Lonoke | Arkansas | 5085 | 5295 | 96 |
936816 | 936816 | 2021-01-17 | Lonoke | Arkansas | 5085 | 5268 | 96 |
933571 | 933571 | 2021-01-16 | Lonoke | Arkansas | 5085 | 5239 | 96 |
930326 | 930326 | 2021-01-15 | Lonoke | Arkansas | 5085 | 5163 | 95 |
927081 | 927081 | 2021-01-14 | Lonoke | Arkansas | 5085 | 5086 | 95 |
923835 | 923835 | 2021-01-13 | Lonoke | Arkansas | 5085 | 5026 | 93 |
920590 | 920590 | 2021-01-12 | Lonoke | Arkansas | 5085 | 4971 | 90 |
917345 | 917345 | 2021-01-11 | Lonoke | Arkansas | 5085 | 4896 | 89 |
914100 | 914100 | 2021-01-10 | Lonoke | Arkansas | 5085 | 4878 | 89 |
910855 | 910855 | 2021-01-09 | Lonoke | Arkansas | 5085 | 4845 | 88 |
907610 | 907610 | 2021-01-08 | Lonoke | Arkansas | 5085 | 4764 | 88 |
904364 | 904364 | 2021-01-07 | Lonoke | Arkansas | 5085 | 4710 | 87 |
901119 | 901119 | 2021-01-06 | Lonoke | Arkansas | 5085 | 4600 | 87 |
897874 | 897874 | 2021-01-05 | Lonoke | Arkansas | 5085 | 4513 | 84 |
894629 | 894629 | 2021-01-04 | Lonoke | Arkansas | 5085 | 4371 | 84 |
891382 | 891382 | 2021-01-03 | Lonoke | Arkansas | 5085 | 4342 | 83 |
888135 | 888135 | 2021-01-02 | Lonoke | Arkansas | 5085 | 4285 | 81 |
884890 | 884890 | 2021-01-01 | Lonoke | Arkansas | 5085 | 4235 | 81 |
881645 | 881645 | 2020-12-31 | Lonoke | Arkansas | 5085 | 4133 | 79 |
878400 | 878400 | 2020-12-30 | Lonoke | Arkansas | 5085 | 4093 | 78 |
875155 | 875155 | 2020-12-29 | Lonoke | Arkansas | 5085 | 4023 | 77 |
871910 | 871910 | 2020-12-28 | Lonoke | Arkansas | 5085 | 3953 | 77 |
868665 | 868665 | 2020-12-27 | Lonoke | Arkansas | 5085 | 3915 | 77 |
865420 | 865420 | 2020-12-26 | Lonoke | Arkansas | 5085 | 3883 | 77 |
862175 | 862175 | 2020-12-25 | Lonoke | Arkansas | 5085 | 3870 | 77 |
858930 | 858930 | 2020-12-24 | Lonoke | Arkansas | 5085 | 3836 | 77 |
855685 | 855685 | 2020-12-23 | Lonoke | Arkansas | 5085 | 3775 | 78 |
852440 | 852440 | 2020-12-22 | Lonoke | Arkansas | 5085 | 3708 | 77 |
849195 | 849195 | 2020-12-21 | Lonoke | Arkansas | 5085 | 3660 | 77 |
845950 | 845950 | 2020-12-20 | Lonoke | Arkansas | 5085 | 3619 | 74 |
842704 | 842704 | 2020-12-19 | Lonoke | Arkansas | 5085 | 3584 | 71 |
839459 | 839459 | 2020-12-18 | Lonoke | Arkansas | 5085 | 3531 | 71 |
836214 | 836214 | 2020-12-17 | Lonoke | Arkansas | 5085 | 3472 | 69 |
832968 | 832968 | 2020-12-16 | Lonoke | Arkansas | 5085 | 3412 | 69 |
829721 | 829721 | 2020-12-15 | Lonoke | Arkansas | 5085 | 3355 | 66 |
826475 | 826475 | 2020-12-14 | Lonoke | Arkansas | 5085 | 3286 | 66 |
823228 | 823228 | 2020-12-13 | Lonoke | Arkansas | 5085 | 3256 | 65 |
819982 | 819982 | 2020-12-12 | Lonoke | Arkansas | 5085 | 3236 | 64 |
816736 | 816736 | 2020-12-11 | Lonoke | Arkansas | 5085 | 3179 | 64 |
813490 | 813490 | 2020-12-10 | Lonoke | Arkansas | 5085 | 3124 | 63 |
810246 | 810246 | 2020-12-09 | Lonoke | Arkansas | 5085 | 3085 | 60 |
807001 | 807001 | 2020-12-08 | Lonoke | Arkansas | 5085 | 3050 | 59 |
803756 | 803756 | 2020-12-07 | Lonoke | Arkansas | 5085 | 3000 | 59 |
800511 | 800511 | 2020-12-06 | Lonoke | Arkansas | 5085 | 2981 | 59 |
797266 | 797266 | 2020-12-05 | Lonoke | Arkansas | 5085 | 2966 | 59 |
794021 | 794021 | 2020-12-04 | Lonoke | Arkansas | 5085 | 2910 | 58 |
790776 | 790776 | 2020-12-03 | Lonoke | Arkansas | 5085 | 2852 | 56 |
787531 | 787531 | 2020-12-02 | Lonoke | Arkansas | 5085 | 2800 | 56 |
784287 | 784287 | 2020-12-01 | Lonoke | Arkansas | 5085 | 2778 | 56 |
781042 | 781042 | 2020-11-30 | Lonoke | Arkansas | 5085 | 2735 | 55 |
777796 | 777796 | 2020-11-29 | Lonoke | Arkansas | 5085 | 2699 | 54 |
774551 | 774551 | 2020-11-28 | Lonoke | Arkansas | 5085 | 2671 | 53 |
771306 | 771306 | 2020-11-27 | Lonoke | Arkansas | 5085 | 2648 | 53 |
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);