ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lee" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1169575 | 1169575 | 2021-03-29 | Lee | South Carolina | 45061 | 1826 | 59 |
1166327 | 1166327 | 2021-03-28 | Lee | South Carolina | 45061 | 1825 | 59 |
1163079 | 1163079 | 2021-03-27 | Lee | South Carolina | 45061 | 1828 | 59 |
1159830 | 1159830 | 2021-03-26 | Lee | South Carolina | 45061 | 1826 | 59 |
1156583 | 1156583 | 2021-03-25 | Lee | South Carolina | 45061 | 1824 | 59 |
1153336 | 1153336 | 2021-03-24 | Lee | South Carolina | 45061 | 1823 | 58 |
1150089 | 1150089 | 2021-03-23 | Lee | South Carolina | 45061 | 1822 | 58 |
1146842 | 1146842 | 2021-03-22 | Lee | South Carolina | 45061 | 1821 | 58 |
1143595 | 1143595 | 2021-03-21 | Lee | South Carolina | 45061 | 1820 | 58 |
1140348 | 1140348 | 2021-03-20 | Lee | South Carolina | 45061 | 1818 | 58 |
1137102 | 1137102 | 2021-03-19 | Lee | South Carolina | 45061 | 1816 | 58 |
1133856 | 1133856 | 2021-03-18 | Lee | South Carolina | 45061 | 1813 | 58 |
1130608 | 1130608 | 2021-03-17 | Lee | South Carolina | 45061 | 1814 | 58 |
1127361 | 1127361 | 2021-03-16 | Lee | South Carolina | 45061 | 1811 | 58 |
1124115 | 1124115 | 2021-03-15 | Lee | South Carolina | 45061 | 1811 | 58 |
1120869 | 1120869 | 2021-03-14 | Lee | South Carolina | 45061 | 1810 | 58 |
1117622 | 1117622 | 2021-03-13 | Lee | South Carolina | 45061 | 1809 | 58 |
1114375 | 1114375 | 2021-03-12 | Lee | South Carolina | 45061 | 1802 | 58 |
1111129 | 1111129 | 2021-03-11 | Lee | South Carolina | 45061 | 1797 | 58 |
1107883 | 1107883 | 2021-03-10 | Lee | South Carolina | 45061 | 1797 | 57 |
1104637 | 1104637 | 2021-03-09 | Lee | South Carolina | 45061 | 1788 | 57 |
1101391 | 1101391 | 2021-03-08 | Lee | South Carolina | 45061 | 1785 | 57 |
1098145 | 1098145 | 2021-03-07 | Lee | South Carolina | 45061 | 1783 | 57 |
1094897 | 1094897 | 2021-03-06 | Lee | South Carolina | 45061 | 1780 | 57 |
1091651 | 1091651 | 2021-03-05 | Lee | South Carolina | 45061 | 1779 | 57 |
1088405 | 1088405 | 2021-03-04 | Lee | South Carolina | 45061 | 1778 | 57 |
1085160 | 1085160 | 2021-03-03 | Lee | South Carolina | 45061 | 1776 | 57 |
1081914 | 1081914 | 2021-03-02 | Lee | South Carolina | 45061 | 1771 | 57 |
1078668 | 1078668 | 2021-03-01 | Lee | South Carolina | 45061 | 1769 | 57 |
1075423 | 1075423 | 2021-02-28 | Lee | South Carolina | 45061 | 1766 | 57 |
1072177 | 1072177 | 2021-02-27 | Lee | South Carolina | 45061 | 1763 | 56 |
1068931 | 1068931 | 2021-02-26 | Lee | South Carolina | 45061 | 1761 | 56 |
1065686 | 1065686 | 2021-02-25 | Lee | South Carolina | 45061 | 1760 | 56 |
1062441 | 1062441 | 2021-02-24 | Lee | South Carolina | 45061 | 1757 | 56 |
1059196 | 1059196 | 2021-02-23 | Lee | South Carolina | 45061 | 1756 | 56 |
1055950 | 1055950 | 2021-02-22 | Lee | South Carolina | 45061 | 1754 | 56 |
1052704 | 1052704 | 2021-02-21 | Lee | South Carolina | 45061 | 1752 | 56 |
1049457 | 1049457 | 2021-02-20 | Lee | South Carolina | 45061 | 1745 | 56 |
1046210 | 1046210 | 2021-02-19 | Lee | South Carolina | 45061 | 1738 | 54 |
1042965 | 1042965 | 2021-02-18 | Lee | South Carolina | 45061 | 1734 | 53 |
1039720 | 1039720 | 2021-02-17 | Lee | South Carolina | 45061 | 1733 | 53 |
1036475 | 1036475 | 2021-02-16 | Lee | South Carolina | 45061 | 1729 | 53 |
1033230 | 1033230 | 2021-02-15 | Lee | South Carolina | 45061 | 1727 | 52 |
1029984 | 1029984 | 2021-02-14 | Lee | South Carolina | 45061 | 1726 | 52 |
1026737 | 1026737 | 2021-02-13 | Lee | South Carolina | 45061 | 1718 | 52 |
1023492 | 1023492 | 2021-02-12 | Lee | South Carolina | 45061 | 1709 | 52 |
1020247 | 1020247 | 2021-02-11 | Lee | South Carolina | 45061 | 1691 | 52 |
1017002 | 1017002 | 2021-02-10 | Lee | South Carolina | 45061 | 1679 | 52 |
1013757 | 1013757 | 2021-02-09 | Lee | South Carolina | 45061 | 1674 | 52 |
1010512 | 1010512 | 2021-02-08 | Lee | South Carolina | 45061 | 1669 | 52 |
1007266 | 1007266 | 2021-02-07 | Lee | South Carolina | 45061 | 1664 | 52 |
1004020 | 1004020 | 2021-02-06 | Lee | South Carolina | 45061 | 1653 | 52 |
1000774 | 1000774 | 2021-02-05 | Lee | South Carolina | 45061 | 1646 | 51 |
997528 | 997528 | 2021-02-04 | Lee | South Carolina | 45061 | 1639 | 51 |
994282 | 994282 | 2021-02-03 | Lee | South Carolina | 45061 | 1636 | 51 |
991036 | 991036 | 2021-02-02 | Lee | South Carolina | 45061 | 1632 | 51 |
987790 | 987790 | 2021-02-01 | Lee | South Carolina | 45061 | 1629 | 51 |
984543 | 984543 | 2021-01-31 | Lee | South Carolina | 45061 | 1621 | 50 |
981296 | 981296 | 2021-01-30 | Lee | South Carolina | 45061 | 1611 | 50 |
978050 | 978050 | 2021-01-29 | Lee | South Carolina | 45061 | 1592 | 50 |
974805 | 974805 | 2021-01-28 | Lee | South Carolina | 45061 | 1576 | 50 |
971560 | 971560 | 2021-01-27 | Lee | South Carolina | 45061 | 1564 | 47 |
968315 | 968315 | 2021-01-26 | Lee | South Carolina | 45061 | 1547 | 47 |
965071 | 965071 | 2021-01-25 | Lee | South Carolina | 45061 | 1544 | 47 |
961826 | 961826 | 2021-01-24 | Lee | South Carolina | 45061 | 1538 | 47 |
958581 | 958581 | 2021-01-23 | Lee | South Carolina | 45061 | 1512 | 47 |
955335 | 955335 | 2021-01-22 | Lee | South Carolina | 45061 | 1503 | 47 |
952090 | 952090 | 2021-01-21 | Lee | South Carolina | 45061 | 1491 | 47 |
948845 | 948845 | 2021-01-20 | Lee | South Carolina | 45061 | 1482 | 47 |
945599 | 945599 | 2021-01-19 | Lee | South Carolina | 45061 | 1469 | 44 |
942352 | 942352 | 2021-01-18 | Lee | South Carolina | 45061 | 1462 | 44 |
939107 | 939107 | 2021-01-17 | Lee | South Carolina | 45061 | 1442 | 44 |
935862 | 935862 | 2021-01-16 | Lee | South Carolina | 45061 | 1415 | 43 |
932617 | 932617 | 2021-01-15 | Lee | South Carolina | 45061 | 1395 | 43 |
929372 | 929372 | 2021-01-14 | Lee | South Carolina | 45061 | 1387 | 43 |
926127 | 926127 | 2021-01-13 | Lee | South Carolina | 45061 | 1367 | 43 |
922881 | 922881 | 2021-01-12 | Lee | South Carolina | 45061 | 1343 | 43 |
919636 | 919636 | 2021-01-11 | Lee | South Carolina | 45061 | 1334 | 43 |
916391 | 916391 | 2021-01-10 | Lee | South Carolina | 45061 | 1320 | 43 |
913146 | 913146 | 2021-01-09 | Lee | South Carolina | 45061 | 1318 | 43 |
909901 | 909901 | 2021-01-08 | Lee | South Carolina | 45061 | 1295 | 43 |
906656 | 906656 | 2021-01-07 | Lee | South Carolina | 45061 | 1284 | 42 |
903410 | 903410 | 2021-01-06 | Lee | South Carolina | 45061 | 1267 | 42 |
900165 | 900165 | 2021-01-05 | Lee | South Carolina | 45061 | 1251 | 42 |
896920 | 896920 | 2021-01-04 | Lee | South Carolina | 45061 | 1240 | 42 |
893674 | 893674 | 2021-01-03 | Lee | South Carolina | 45061 | 1229 | 42 |
890428 | 890428 | 2021-01-02 | Lee | South Carolina | 45061 | 1206 | 42 |
887181 | 887181 | 2021-01-01 | Lee | South Carolina | 45061 | 1194 | 42 |
883936 | 883936 | 2020-12-31 | Lee | South Carolina | 45061 | 1194 | 42 |
880691 | 880691 | 2020-12-30 | Lee | South Carolina | 45061 | 1185 | 41 |
877446 | 877446 | 2020-12-29 | Lee | South Carolina | 45061 | 1175 | 41 |
874201 | 874201 | 2020-12-28 | Lee | South Carolina | 45061 | 1162 | 41 |
870956 | 870956 | 2020-12-27 | Lee | South Carolina | 45061 | 1161 | 41 |
867711 | 867711 | 2020-12-26 | Lee | South Carolina | 45061 | 1135 | 41 |
864466 | 864466 | 2020-12-25 | Lee | South Carolina | 45061 | 1125 | 41 |
861221 | 861221 | 2020-12-24 | Lee | South Carolina | 45061 | 1125 | 41 |
857976 | 857976 | 2020-12-23 | Lee | South Carolina | 45061 | 1111 | 41 |
854731 | 854731 | 2020-12-22 | Lee | South Carolina | 45061 | 1095 | 41 |
851486 | 851486 | 2020-12-21 | Lee | South Carolina | 45061 | 1081 | 41 |
848241 | 848241 | 2020-12-20 | Lee | South Carolina | 45061 | 1065 | 41 |
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);