ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Clay" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1047132 | 1047132 | 2021-02-20 | Clay | Arkansas | 5021 | 1661 | 46 |
1043887 | 1043887 | 2021-02-19 | Clay | Arkansas | 5021 | 1660 | 46 |
1040642 | 1040642 | 2021-02-18 | Clay | Arkansas | 5021 | 1659 | 46 |
1037397 | 1037397 | 2021-02-17 | Clay | Arkansas | 5021 | 1658 | 45 |
1034152 | 1034152 | 2021-02-16 | Clay | Arkansas | 5021 | 1656 | 45 |
1030906 | 1030906 | 2021-02-15 | Clay | Arkansas | 5021 | 1656 | 44 |
1027659 | 1027659 | 2021-02-14 | Clay | Arkansas | 5021 | 1654 | 44 |
1024414 | 1024414 | 2021-02-13 | Clay | Arkansas | 5021 | 1654 | 44 |
1021169 | 1021169 | 2021-02-12 | Clay | Arkansas | 5021 | 1652 | 44 |
1017924 | 1017924 | 2021-02-11 | Clay | Arkansas | 5021 | 1651 | 44 |
1014679 | 1014679 | 2021-02-10 | Clay | Arkansas | 5021 | 1646 | 43 |
1011434 | 1011434 | 2021-02-09 | Clay | Arkansas | 5021 | 1644 | 42 |
1008188 | 1008188 | 2021-02-08 | Clay | Arkansas | 5021 | 1643 | 42 |
1004942 | 1004942 | 2021-02-07 | Clay | Arkansas | 5021 | 1638 | 42 |
1001696 | 1001696 | 2021-02-06 | Clay | Arkansas | 5021 | 1637 | 42 |
998450 | 998450 | 2021-02-05 | Clay | Arkansas | 5021 | 1633 | 42 |
995204 | 995204 | 2021-02-04 | Clay | Arkansas | 5021 | 1623 | 42 |
991958 | 991958 | 2021-02-03 | Clay | Arkansas | 5021 | 1600 | 42 |
988712 | 988712 | 2021-02-02 | Clay | Arkansas | 5021 | 1581 | 42 |
985465 | 985465 | 2021-02-01 | Clay | Arkansas | 5021 | 1573 | 42 |
982218 | 982218 | 2021-01-31 | Clay | Arkansas | 5021 | 1564 | 42 |
978972 | 978972 | 2021-01-30 | Clay | Arkansas | 5021 | 1562 | 41 |
975727 | 975727 | 2021-01-29 | Clay | Arkansas | 5021 | 1559 | 41 |
972482 | 972482 | 2021-01-28 | Clay | Arkansas | 5021 | 1552 | 41 |
969237 | 969237 | 2021-01-27 | Clay | Arkansas | 5021 | 1545 | 41 |
965993 | 965993 | 2021-01-26 | Clay | Arkansas | 5021 | 1540 | 41 |
962748 | 962748 | 2021-01-25 | Clay | Arkansas | 5021 | 1534 | 41 |
959503 | 959503 | 2021-01-24 | Clay | Arkansas | 5021 | 1529 | 40 |
956257 | 956257 | 2021-01-23 | Clay | Arkansas | 5021 | 1530 | 40 |
953012 | 953012 | 2021-01-22 | Clay | Arkansas | 5021 | 1525 | 40 |
949767 | 949767 | 2021-01-21 | Clay | Arkansas | 5021 | 1513 | 39 |
946521 | 946521 | 2021-01-20 | Clay | Arkansas | 5021 | 1502 | 39 |
943274 | 943274 | 2021-01-19 | Clay | Arkansas | 5021 | 1486 | 39 |
940029 | 940029 | 2021-01-18 | Clay | Arkansas | 5021 | 1479 | 39 |
936784 | 936784 | 2021-01-17 | Clay | Arkansas | 5021 | 1477 | 39 |
933539 | 933539 | 2021-01-16 | Clay | Arkansas | 5021 | 1476 | 39 |
930294 | 930294 | 2021-01-15 | Clay | Arkansas | 5021 | 1467 | 38 |
927049 | 927049 | 2021-01-14 | Clay | Arkansas | 5021 | 1457 | 38 |
923803 | 923803 | 2021-01-13 | Clay | Arkansas | 5021 | 1447 | 36 |
920558 | 920558 | 2021-01-12 | Clay | Arkansas | 5021 | 1437 | 36 |
917313 | 917313 | 2021-01-11 | Clay | Arkansas | 5021 | 1425 | 36 |
914068 | 914068 | 2021-01-10 | Clay | Arkansas | 5021 | 1422 | 35 |
910823 | 910823 | 2021-01-09 | Clay | Arkansas | 5021 | 1411 | 35 |
907578 | 907578 | 2021-01-08 | Clay | Arkansas | 5021 | 1401 | 35 |
904332 | 904332 | 2021-01-07 | Clay | Arkansas | 5021 | 1396 | 35 |
901087 | 901087 | 2021-01-06 | Clay | Arkansas | 5021 | 1383 | 35 |
897842 | 897842 | 2021-01-05 | Clay | Arkansas | 5021 | 1369 | 32 |
894597 | 894597 | 2021-01-04 | Clay | Arkansas | 5021 | 1350 | 32 |
891350 | 891350 | 2021-01-03 | Clay | Arkansas | 5021 | 1343 | 31 |
888103 | 888103 | 2021-01-02 | Clay | Arkansas | 5021 | 1337 | 31 |
884858 | 884858 | 2021-01-01 | Clay | Arkansas | 5021 | 1332 | 31 |
881613 | 881613 | 2020-12-31 | Clay | Arkansas | 5021 | 1317 | 30 |
878368 | 878368 | 2020-12-30 | Clay | Arkansas | 5021 | 1306 | 30 |
875123 | 875123 | 2020-12-29 | Clay | Arkansas | 5021 | 1291 | 30 |
871878 | 871878 | 2020-12-28 | Clay | Arkansas | 5021 | 1276 | 30 |
868633 | 868633 | 2020-12-27 | Clay | Arkansas | 5021 | 1273 | 30 |
865388 | 865388 | 2020-12-26 | Clay | Arkansas | 5021 | 1268 | 30 |
862143 | 862143 | 2020-12-25 | Clay | Arkansas | 5021 | 1263 | 30 |
858898 | 858898 | 2020-12-24 | Clay | Arkansas | 5021 | 1255 | 30 |
855653 | 855653 | 2020-12-23 | Clay | Arkansas | 5021 | 1241 | 30 |
852408 | 852408 | 2020-12-22 | Clay | Arkansas | 5021 | 1224 | 28 |
849163 | 849163 | 2020-12-21 | Clay | Arkansas | 5021 | 1206 | 26 |
845918 | 845918 | 2020-12-20 | Clay | Arkansas | 5021 | 1202 | 26 |
842672 | 842672 | 2020-12-19 | Clay | Arkansas | 5021 | 1197 | 26 |
839427 | 839427 | 2020-12-18 | Clay | Arkansas | 5021 | 1189 | 26 |
836182 | 836182 | 2020-12-17 | Clay | Arkansas | 5021 | 1178 | 26 |
832936 | 832936 | 2020-12-16 | Clay | Arkansas | 5021 | 1162 | 25 |
829689 | 829689 | 2020-12-15 | Clay | Arkansas | 5021 | 1146 | 25 |
826443 | 826443 | 2020-12-14 | Clay | Arkansas | 5021 | 1132 | 25 |
823196 | 823196 | 2020-12-13 | Clay | Arkansas | 5021 | 1125 | 25 |
819950 | 819950 | 2020-12-12 | Clay | Arkansas | 5021 | 1117 | 24 |
816704 | 816704 | 2020-12-11 | Clay | Arkansas | 5021 | 1100 | 24 |
813458 | 813458 | 2020-12-10 | Clay | Arkansas | 5021 | 1085 | 24 |
810214 | 810214 | 2020-12-09 | Clay | Arkansas | 5021 | 1071 | 24 |
806969 | 806969 | 2020-12-08 | Clay | Arkansas | 5021 | 1055 | 24 |
803724 | 803724 | 2020-12-07 | Clay | Arkansas | 5021 | 1040 | 24 |
800479 | 800479 | 2020-12-06 | Clay | Arkansas | 5021 | 1034 | 23 |
797234 | 797234 | 2020-12-05 | Clay | Arkansas | 5021 | 1017 | 23 |
793989 | 793989 | 2020-12-04 | Clay | Arkansas | 5021 | 1000 | 22 |
790744 | 790744 | 2020-12-03 | Clay | Arkansas | 5021 | 966 | 22 |
787499 | 787499 | 2020-12-02 | Clay | Arkansas | 5021 | 943 | 21 |
784255 | 784255 | 2020-12-01 | Clay | Arkansas | 5021 | 914 | 21 |
781010 | 781010 | 2020-11-30 | Clay | Arkansas | 5021 | 890 | 21 |
777764 | 777764 | 2020-11-29 | Clay | Arkansas | 5021 | 874 | 21 |
774519 | 774519 | 2020-11-28 | Clay | Arkansas | 5021 | 859 | 19 |
771274 | 771274 | 2020-11-27 | Clay | Arkansas | 5021 | 851 | 19 |
768029 | 768029 | 2020-11-26 | Clay | Arkansas | 5021 | 839 | 19 |
764783 | 764783 | 2020-11-25 | Clay | Arkansas | 5021 | 820 | 19 |
761538 | 761538 | 2020-11-24 | Clay | Arkansas | 5021 | 799 | 19 |
758293 | 758293 | 2020-11-23 | Clay | Arkansas | 5021 | 786 | 19 |
755046 | 755046 | 2020-11-22 | Clay | Arkansas | 5021 | 775 | 19 |
751800 | 751800 | 2020-11-21 | Clay | Arkansas | 5021 | 761 | 18 |
748554 | 748554 | 2020-11-20 | Clay | Arkansas | 5021 | 755 | 18 |
745308 | 745308 | 2020-11-19 | Clay | Arkansas | 5021 | 742 | 18 |
742061 | 742061 | 2020-11-18 | Clay | Arkansas | 5021 | 728 | 18 |
738814 | 738814 | 2020-11-17 | Clay | Arkansas | 5021 | 713 | 18 |
735570 | 735570 | 2020-11-16 | Clay | Arkansas | 5021 | 691 | 18 |
732324 | 732324 | 2020-11-15 | Clay | Arkansas | 5021 | 680 | 18 |
729079 | 729079 | 2020-11-14 | Clay | Arkansas | 5021 | 670 | 18 |
725836 | 725836 | 2020-11-13 | Clay | Arkansas | 5021 | 652 | 17 |
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);