ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,322 rows where county = "Lee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Florida 388
- Georgia 383
- Alabama 379
- South Carolina 377
- Mississippi 375
- North Carolina 373
- Virginia 373
- Arkansas 362
- Texas 362
- Illinois 360
- Iowa 360
- Kentucky 306
fips 12
county 1
- Lee · 4,398 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1167780 | 1167780 | 2021-03-29 | Lee | Illinois | 17103 | 3690 | 86 |
1167979 | 1167979 | 2021-03-29 | Lee | Iowa | 19111 | 3633 | 55 |
1168194 | 1168194 | 2021-03-29 | Lee | Kentucky | 21129 | 1240 | 22 |
1168584 | 1168584 | 2021-03-29 | Lee | Mississippi | 28081 | 9804 | 168 |
1169086 | 1169086 | 2021-03-29 | Lee | North Carolina | 37105 | 5664 | 73 |
1169575 | 1169575 | 2021-03-29 | Lee | South Carolina | 45061 | 1826 | 59 |
1169896 | 1169896 | 2021-03-29 | Lee | Texas | 48287 | 2110 | 37 |
1170123 | 1170123 | 2021-03-29 | Lee | Virginia | 51105 | 2358 | 45 |
1163921 | 1163921 | 2021-03-28 | Lee | Alabama | 1081 | 15389 | 166 |
1164029 | 1164029 | 2021-03-28 | Lee | Arkansas | 5077 | 1655 | 34 |
1164237 | 1164237 | 2021-03-28 | Lee | Florida | 12071 | 62142 | 910 |
1164358 | 1164358 | 2021-03-28 | Lee | Georgia | 13177 | 2688 | 55 |
1164532 | 1164532 | 2021-03-28 | Lee | Illinois | 17103 | 3677 | 86 |
1164731 | 1164731 | 2021-03-28 | Lee | Iowa | 19111 | 3632 | 55 |
1164946 | 1164946 | 2021-03-28 | Lee | Kentucky | 21129 | 1240 | 22 |
1165336 | 1165336 | 2021-03-28 | Lee | Mississippi | 28081 | 9802 | 168 |
1165838 | 1165838 | 2021-03-28 | Lee | North Carolina | 37105 | 5629 | 73 |
1166327 | 1166327 | 2021-03-28 | Lee | South Carolina | 45061 | 1825 | 59 |
1166648 | 1166648 | 2021-03-28 | Lee | Texas | 48287 | 2104 | 37 |
1166875 | 1166875 | 2021-03-28 | Lee | Virginia | 51105 | 2357 | 45 |
1160673 | 1160673 | 2021-03-27 | Lee | Alabama | 1081 | 15381 | 166 |
1160781 | 1160781 | 2021-03-27 | Lee | Arkansas | 5077 | 1655 | 34 |
1160989 | 1160989 | 2021-03-27 | Lee | Florida | 12071 | 61967 | 910 |
1161110 | 1161110 | 2021-03-27 | Lee | Georgia | 13177 | 2688 | 55 |
1161284 | 1161284 | 2021-03-27 | Lee | Illinois | 17103 | 3669 | 86 |
1161483 | 1161483 | 2021-03-27 | Lee | Iowa | 19111 | 3632 | 55 |
1161698 | 1161698 | 2021-03-27 | Lee | Kentucky | 21129 | 1241 | 22 |
1162088 | 1162088 | 2021-03-27 | Lee | Mississippi | 28081 | 9800 | 168 |
1162590 | 1162590 | 2021-03-27 | Lee | North Carolina | 37105 | 5629 | 73 |
1163079 | 1163079 | 2021-03-27 | Lee | South Carolina | 45061 | 1828 | 59 |
1163400 | 1163400 | 2021-03-27 | Lee | Texas | 48287 | 2104 | 37 |
1163627 | 1163627 | 2021-03-27 | Lee | Virginia | 51105 | 2354 | 45 |
1157425 | 1157425 | 2021-03-26 | Lee | Alabama | 1081 | 15371 | 166 |
1157533 | 1157533 | 2021-03-26 | Lee | Arkansas | 5077 | 1655 | 34 |
1157741 | 1157741 | 2021-03-26 | Lee | Florida | 12071 | 61775 | 910 |
1157862 | 1157862 | 2021-03-26 | Lee | Georgia | 13177 | 2686 | 55 |
1158036 | 1158036 | 2021-03-26 | Lee | Illinois | 17103 | 3650 | 85 |
1158235 | 1158235 | 2021-03-26 | Lee | Iowa | 19111 | 3632 | 55 |
1158450 | 1158450 | 2021-03-26 | Lee | Kentucky | 21129 | 1225 | 22 |
1158840 | 1158840 | 2021-03-26 | Lee | Mississippi | 28081 | 9797 | 168 |
1159341 | 1159341 | 2021-03-26 | Lee | North Carolina | 37105 | 5629 | 73 |
1159830 | 1159830 | 2021-03-26 | Lee | South Carolina | 45061 | 1826 | 59 |
1160151 | 1160151 | 2021-03-26 | Lee | Texas | 48287 | 2099 | 37 |
1160379 | 1160379 | 2021-03-26 | Lee | Virginia | 51105 | 2354 | 45 |
1154178 | 1154178 | 2021-03-25 | Lee | Alabama | 1081 | 15355 | 166 |
1154286 | 1154286 | 2021-03-25 | Lee | Arkansas | 5077 | 1655 | 34 |
1154494 | 1154494 | 2021-03-25 | Lee | Florida | 12071 | 61571 | 910 |
1154615 | 1154615 | 2021-03-25 | Lee | Georgia | 13177 | 2678 | 55 |
1154789 | 1154789 | 2021-03-25 | Lee | Illinois | 17103 | 3631 | 84 |
1154988 | 1154988 | 2021-03-25 | Lee | Iowa | 19111 | 3631 | 55 |
1155203 | 1155203 | 2021-03-25 | Lee | Kentucky | 21129 | 1220 | 22 |
1155593 | 1155593 | 2021-03-25 | Lee | Mississippi | 28081 | 9795 | 168 |
1156094 | 1156094 | 2021-03-25 | Lee | North Carolina | 37105 | 5621 | 73 |
1156583 | 1156583 | 2021-03-25 | Lee | South Carolina | 45061 | 1824 | 59 |
1156904 | 1156904 | 2021-03-25 | Lee | Texas | 48287 | 2097 | 37 |
1157131 | 1157131 | 2021-03-25 | Lee | Virginia | 51105 | 2354 | 44 |
1150931 | 1150931 | 2021-03-24 | Lee | Alabama | 1081 | 15333 | 166 |
1151039 | 1151039 | 2021-03-24 | Lee | Arkansas | 5077 | 1654 | 34 |
1151247 | 1151247 | 2021-03-24 | Lee | Florida | 12071 | 61387 | 909 |
1151368 | 1151368 | 2021-03-24 | Lee | Georgia | 13177 | 2672 | 55 |
1151542 | 1151542 | 2021-03-24 | Lee | Illinois | 17103 | 3606 | 84 |
1151741 | 1151741 | 2021-03-24 | Lee | Iowa | 19111 | 3556 | 55 |
1151956 | 1151956 | 2021-03-24 | Lee | Kentucky | 21129 | 1219 | 22 |
1152346 | 1152346 | 2021-03-24 | Lee | Mississippi | 28081 | 9793 | 167 |
1152847 | 1152847 | 2021-03-24 | Lee | North Carolina | 37105 | 5611 | 73 |
1153336 | 1153336 | 2021-03-24 | Lee | South Carolina | 45061 | 1823 | 58 |
1153657 | 1153657 | 2021-03-24 | Lee | Texas | 48287 | 2095 | 37 |
1153884 | 1153884 | 2021-03-24 | Lee | Virginia | 51105 | 2353 | 44 |
1147684 | 1147684 | 2021-03-23 | Lee | Alabama | 1081 | 15292 | 166 |
1147792 | 1147792 | 2021-03-23 | Lee | Arkansas | 5077 | 1654 | 34 |
1148000 | 1148000 | 2021-03-23 | Lee | Florida | 12071 | 61201 | 907 |
1148121 | 1148121 | 2021-03-23 | Lee | Georgia | 13177 | 2670 | 54 |
1148295 | 1148295 | 2021-03-23 | Lee | Illinois | 17103 | 3578 | 84 |
1148494 | 1148494 | 2021-03-23 | Lee | Iowa | 19111 | 3555 | 54 |
1148709 | 1148709 | 2021-03-23 | Lee | Kentucky | 21129 | 1216 | 22 |
1149099 | 1149099 | 2021-03-23 | Lee | Mississippi | 28081 | 9789 | 167 |
1149600 | 1149600 | 2021-03-23 | Lee | North Carolina | 37105 | 5602 | 73 |
1150089 | 1150089 | 2021-03-23 | Lee | South Carolina | 45061 | 1822 | 58 |
1150410 | 1150410 | 2021-03-23 | Lee | Texas | 48287 | 2090 | 37 |
1150637 | 1150637 | 2021-03-23 | Lee | Virginia | 51105 | 2352 | 44 |
1144437 | 1144437 | 2021-03-22 | Lee | Alabama | 1081 | 15290 | 166 |
1144545 | 1144545 | 2021-03-22 | Lee | Arkansas | 5077 | 1652 | 34 |
1144753 | 1144753 | 2021-03-22 | Lee | Florida | 12071 | 61014 | 907 |
1144874 | 1144874 | 2021-03-22 | Lee | Georgia | 13177 | 2668 | 54 |
1145048 | 1145048 | 2021-03-22 | Lee | Illinois | 17103 | 3569 | 84 |
1145247 | 1145247 | 2021-03-22 | Lee | Iowa | 19111 | 3553 | 54 |
1145462 | 1145462 | 2021-03-22 | Lee | Kentucky | 21129 | 1214 | 22 |
1145852 | 1145852 | 2021-03-22 | Lee | Mississippi | 28081 | 9787 | 167 |
1146353 | 1146353 | 2021-03-22 | Lee | North Carolina | 37105 | 5597 | 73 |
1146842 | 1146842 | 2021-03-22 | Lee | South Carolina | 45061 | 1821 | 58 |
1147163 | 1147163 | 2021-03-22 | Lee | Texas | 48287 | 2090 | 37 |
1147390 | 1147390 | 2021-03-22 | Lee | Virginia | 51105 | 2346 | 44 |
1141190 | 1141190 | 2021-03-21 | Lee | Alabama | 1081 | 15282 | 166 |
1141298 | 1141298 | 2021-03-21 | Lee | Arkansas | 5077 | 1651 | 34 |
1141506 | 1141506 | 2021-03-21 | Lee | Florida | 12071 | 60913 | 906 |
1141627 | 1141627 | 2021-03-21 | Lee | Georgia | 13177 | 2667 | 54 |
1141801 | 1141801 | 2021-03-21 | Lee | Illinois | 17103 | 3562 | 84 |
1142000 | 1142000 | 2021-03-21 | Lee | Iowa | 19111 | 3552 | 54 |
1142215 | 1142215 | 2021-03-21 | Lee | Kentucky | 21129 | 1214 | 22 |
1142605 | 1142605 | 2021-03-21 | Lee | Mississippi | 28081 | 9787 | 167 |
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);