ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,502 rows where county = "Lee" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

  • Lee · 3,502 ✖
Link rowid date ▲ county state fips cases deaths
923803 923803 2021-01-13 Lee Alabama 1081 11983 97
923911 923911 2021-01-13 Lee Arkansas 5077 1530 28
924119 924119 2021-01-13 Lee Florida 12071 46550 720
924240 924240 2021-01-13 Lee Georgia 13177 1944 36
924414 924414 2021-01-13 Lee Illinois 17103 2942 71
924612 924612 2021-01-13 Lee Iowa 19111 3093 28
924827 924827 2021-01-13 Lee Kentucky 21129 1087 18
925217 925217 2021-01-13 Lee Mississippi 28081 8603 135
925719 925719 2021-01-13 Lee North Carolina 37105 4130 45
926207 926207 2021-01-13 Lee South Carolina 45061 1367 43
926528 926528 2021-01-13 Lee Texas 48287 1126 33
926755 926755 2021-01-13 Lee Virginia 51105 1825 32
920558 920558 2021-01-12 Lee Alabama 1081 11812 87
920666 920666 2021-01-12 Lee Arkansas 5077 1529 28
920874 920874 2021-01-12 Lee Florida 12071 46103 715
920995 920995 2021-01-12 Lee Georgia 13177 1914 36
921169 921169 2021-01-12 Lee Illinois 17103 2921 70
921367 921367 2021-01-12 Lee Iowa 19111 3076 28
921582 921582 2021-01-12 Lee Kentucky 21129 1084 18
921972 921972 2021-01-12 Lee Mississippi 28081 8526 135
922473 922473 2021-01-12 Lee North Carolina 37105 4122 44
922961 922961 2021-01-12 Lee South Carolina 45061 1343 43
923282 923282 2021-01-12 Lee Texas 48287 1103 33
923509 923509 2021-01-12 Lee Virginia 51105 1790 32
917313 917313 2021-01-11 Lee Alabama 1081 11626 79
917421 917421 2021-01-11 Lee Arkansas 5077 1520 28
917629 917629 2021-01-11 Lee Florida 12071 45649 715
917750 917750 2021-01-11 Lee Georgia 13177 1875 35
917924 917924 2021-01-11 Lee Illinois 17103 2909 69
918122 918122 2021-01-11 Lee Iowa 19111 3068 28
918337 918337 2021-01-11 Lee Kentucky 21129 1080 18
918727 918727 2021-01-11 Lee Mississippi 28081 8472 133
919228 919228 2021-01-11 Lee North Carolina 37105 4085 44
919716 919716 2021-01-11 Lee South Carolina 45061 1334 43
920037 920037 2021-01-11 Lee Texas 48287 1102 31
920264 920264 2021-01-11 Lee Virginia 51105 1763 32
914068 914068 2021-01-10 Lee Alabama 1081 11565 79
914176 914176 2021-01-10 Lee Arkansas 5077 1515 28
914384 914384 2021-01-10 Lee Florida 12071 45281 714
914505 914505 2021-01-10 Lee Georgia 13177 1834 35
914679 914679 2021-01-10 Lee Illinois 17103 2885 69
914877 914877 2021-01-10 Lee Iowa 19111 3058 28
915092 915092 2021-01-10 Lee Kentucky 21129 1077 18
915482 915482 2021-01-10 Lee Mississippi 28081 8448 133
915983 915983 2021-01-10 Lee North Carolina 37105 4059 44
916471 916471 2021-01-10 Lee South Carolina 45061 1320 43
916792 916792 2021-01-10 Lee Texas 48287 1102 31
917019 917019 2021-01-10 Lee Virginia 51105 1758 32
910823 910823 2021-01-09 Lee Alabama 1081 11498 79
910931 910931 2021-01-09 Lee Arkansas 5077 1511 28
911139 911139 2021-01-09 Lee Florida 12071 44818 710
911260 911260 2021-01-09 Lee Georgia 13177 1813 35
911434 911434 2021-01-09 Lee Illinois 17103 2869 69
911632 911632 2021-01-09 Lee Iowa 19111 3053 28
911847 911847 2021-01-09 Lee Kentucky 21129 1076 18
912237 912237 2021-01-09 Lee Mississippi 28081 8403 133
912738 912738 2021-01-09 Lee North Carolina 37105 3986 44
913226 913226 2021-01-09 Lee South Carolina 45061 1318 43
913547 913547 2021-01-09 Lee Texas 48287 1102 31
913774 913774 2021-01-09 Lee Virginia 51105 1746 32
907578 907578 2021-01-08 Lee Alabama 1081 11355 79
907686 907686 2021-01-08 Lee Arkansas 5077 1504 28
907894 907894 2021-01-08 Lee Florida 12071 44394 708
908015 908015 2021-01-08 Lee Georgia 13177 1767 33
908189 908189 2021-01-08 Lee Illinois 17103 2864 69
908387 908387 2021-01-08 Lee Iowa 19111 3042 28
908602 908602 2021-01-08 Lee Kentucky 21129 1075 18
908992 908992 2021-01-08 Lee Mississippi 28081 8305 131
909493 909493 2021-01-08 Lee North Carolina 37105 3919 44
909981 909981 2021-01-08 Lee South Carolina 45061 1295 43
910302 910302 2021-01-08 Lee Texas 48287 1053 31
910529 910529 2021-01-08 Lee Virginia 51105 1669 32
904332 904332 2021-01-07 Lee Alabama 1081 11179 79
904440 904440 2021-01-07 Lee Arkansas 5077 1496 27
904648 904648 2021-01-07 Lee Florida 12071 43870 695
904769 904769 2021-01-07 Lee Georgia 13177 1735 33
904943 904943 2021-01-07 Lee Illinois 17103 2843 69
905141 905141 2021-01-07 Lee Iowa 19111 3017 28
905356 905356 2021-01-07 Lee Kentucky 21129 1073 18
905746 905746 2021-01-07 Lee Mississippi 28081 8261 131
906248 906248 2021-01-07 Lee North Carolina 37105 3845 44
906736 906736 2021-01-07 Lee South Carolina 45061 1284 42
907057 907057 2021-01-07 Lee Texas 48287 1031 30
907284 907284 2021-01-07 Lee Virginia 51105 1632 32
901087 901087 2021-01-06 Lee Alabama 1081 10964 75
901195 901195 2021-01-06 Lee Arkansas 5077 1489 26
901403 901403 2021-01-06 Lee Florida 12071 43326 691
901524 901524 2021-01-06 Lee Georgia 13177 1694 33
901698 901698 2021-01-06 Lee Illinois 17103 2821 66
901896 901896 2021-01-06 Lee Iowa 19111 2990 28
902111 902111 2021-01-06 Lee Kentucky 21129 1070 18
902501 902501 2021-01-06 Lee Mississippi 28081 8161 125
903002 903002 2021-01-06 Lee North Carolina 37105 3780 44
903490 903490 2021-01-06 Lee South Carolina 45061 1267 42
903811 903811 2021-01-06 Lee Texas 48287 1019 28
904038 904038 2021-01-06 Lee Virginia 51105 1613 31
897842 897842 2021-01-05 Lee Alabama 1081 10765 75
897950 897950 2021-01-05 Lee Arkansas 5077 1482 26
898158 898158 2021-01-05 Lee Florida 12071 42844 682
898279 898279 2021-01-05 Lee Georgia 13177 1659 33

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);