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 397
- Georgia 392
- Alabama 388
- South Carolina 385
- Mississippi 383
- North Carolina 381
- Virginia 381
- Arkansas 371
- Texas 370
- Illinois 368
- Iowa 368
- Kentucky 314
fips 12
county 1
- Lee · 4,498 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193149 | 1193149 | 2021-04-06 | Lee | Alabama | 1081 | 15468 | 165 |
1193257 | 1193257 | 2021-04-06 | Lee | Arkansas | 5077 | 1659 | 34 |
1193465 | 1193465 | 2021-04-06 | Lee | Florida | 12071 | 63773 | 930 |
1193586 | 1193586 | 2021-04-06 | Lee | Georgia | 13177 | 2683 | 56 |
1193760 | 1193760 | 2021-04-06 | Lee | Illinois | 17103 | 3777 | 87 |
1193959 | 1193959 | 2021-04-06 | Lee | Iowa | 19111 | 3655 | 55 |
1194174 | 1194174 | 2021-04-06 | Lee | Kentucky | 21129 | 1254 | 22 |
1194563 | 1194563 | 2021-04-06 | Lee | Mississippi | 28081 | 9831 | 169 |
1195065 | 1195065 | 2021-04-06 | Lee | North Carolina | 37105 | 5726 | 75 |
1195554 | 1195554 | 2021-04-06 | Lee | South Carolina | 45061 | 1839 | 59 |
1195875 | 1195875 | 2021-04-06 | Lee | Texas | 48287 | 2119 | 38 |
1196103 | 1196103 | 2021-04-06 | Lee | Virginia | 51105 | 2372 | 45 |
1189899 | 1189899 | 2021-04-05 | Lee | Alabama | 1081 | 15459 | 166 |
1190007 | 1190007 | 2021-04-05 | Lee | Arkansas | 5077 | 1659 | 34 |
1190215 | 1190215 | 2021-04-05 | Lee | Florida | 12071 | 63571 | 923 |
1190336 | 1190336 | 2021-04-05 | Lee | Georgia | 13177 | 2679 | 56 |
1190510 | 1190510 | 2021-04-05 | Lee | Illinois | 17103 | 3761 | 87 |
1190709 | 1190709 | 2021-04-05 | Lee | Iowa | 19111 | 3652 | 55 |
1190924 | 1190924 | 2021-04-05 | Lee | Kentucky | 21129 | 1254 | 22 |
1191314 | 1191314 | 2021-04-05 | Lee | Mississippi | 28081 | 9829 | 169 |
1191817 | 1191817 | 2021-04-05 | Lee | North Carolina | 37105 | 5726 | 75 |
1192306 | 1192306 | 2021-04-05 | Lee | South Carolina | 45061 | 1837 | 59 |
1192627 | 1192627 | 2021-04-05 | Lee | Texas | 48287 | 2119 | 38 |
1192855 | 1192855 | 2021-04-05 | Lee | Virginia | 51105 | 2373 | 45 |
1186652 | 1186652 | 2021-04-04 | Lee | Alabama | 1081 | 15457 | 166 |
1186760 | 1186760 | 2021-04-04 | Lee | Arkansas | 5077 | 1659 | 34 |
1186968 | 1186968 | 2021-04-04 | Lee | Florida | 12071 | 63511 | 923 |
1187089 | 1187089 | 2021-04-04 | Lee | Georgia | 13177 | 2678 | 56 |
1187263 | 1187263 | 2021-04-04 | Lee | Illinois | 17103 | 3753 | 87 |
1187462 | 1187462 | 2021-04-04 | Lee | Iowa | 19111 | 3652 | 55 |
1187677 | 1187677 | 2021-04-04 | Lee | Kentucky | 21129 | 1252 | 22 |
1188066 | 1188066 | 2021-04-04 | Lee | Mississippi | 28081 | 9827 | 169 |
1188568 | 1188568 | 2021-04-04 | Lee | North Carolina | 37105 | 5693 | 74 |
1189057 | 1189057 | 2021-04-04 | Lee | South Carolina | 45061 | 1835 | 59 |
1189378 | 1189378 | 2021-04-04 | Lee | Texas | 48287 | 2119 | 38 |
1189605 | 1189605 | 2021-04-04 | Lee | Virginia | 51105 | 2369 | 45 |
1183405 | 1183405 | 2021-04-03 | Lee | Alabama | 1081 | 15452 | 166 |
1183513 | 1183513 | 2021-04-03 | Lee | Arkansas | 5077 | 1658 | 34 |
1183721 | 1183721 | 2021-04-03 | Lee | Florida | 12071 | 63333 | 923 |
1183842 | 1183842 | 2021-04-03 | Lee | Georgia | 13177 | 2678 | 56 |
1184016 | 1184016 | 2021-04-03 | Lee | Illinois | 17103 | 3748 | 87 |
1184215 | 1184215 | 2021-04-03 | Lee | Iowa | 19111 | 3651 | 55 |
1184430 | 1184430 | 2021-04-03 | Lee | Kentucky | 21129 | 1252 | 22 |
1184819 | 1184819 | 2021-04-03 | Lee | Mississippi | 28081 | 9823 | 169 |
1185321 | 1185321 | 2021-04-03 | Lee | North Carolina | 37105 | 5693 | 74 |
1185810 | 1185810 | 2021-04-03 | Lee | South Carolina | 45061 | 1835 | 59 |
1186131 | 1186131 | 2021-04-03 | Lee | Texas | 48287 | 2119 | 38 |
1186358 | 1186358 | 2021-04-03 | Lee | Virginia | 51105 | 2369 | 45 |
1180158 | 1180158 | 2021-04-02 | Lee | Alabama | 1081 | 15444 | 166 |
1180266 | 1180266 | 2021-04-02 | Lee | Arkansas | 5077 | 1658 | 34 |
1180474 | 1180474 | 2021-04-02 | Lee | Florida | 12071 | 63129 | 921 |
1180595 | 1180595 | 2021-04-02 | Lee | Georgia | 13177 | 2673 | 56 |
1180769 | 1180769 | 2021-04-02 | Lee | Illinois | 17103 | 3743 | 87 |
1180968 | 1180968 | 2021-04-02 | Lee | Iowa | 19111 | 3644 | 55 |
1181183 | 1181183 | 2021-04-02 | Lee | Kentucky | 21129 | 1250 | 22 |
1181573 | 1181573 | 2021-04-02 | Lee | Mississippi | 28081 | 9818 | 169 |
1182074 | 1182074 | 2021-04-02 | Lee | North Carolina | 37105 | 5693 | 74 |
1182563 | 1182563 | 2021-04-02 | Lee | South Carolina | 45061 | 1835 | 59 |
1182884 | 1182884 | 2021-04-02 | Lee | Texas | 48287 | 2121 | 38 |
1183111 | 1183111 | 2021-04-02 | Lee | Virginia | 51105 | 2367 | 45 |
1176911 | 1176911 | 2021-04-01 | Lee | Alabama | 1081 | 15433 | 166 |
1177019 | 1177019 | 2021-04-01 | Lee | Arkansas | 5077 | 1658 | 34 |
1177227 | 1177227 | 2021-04-01 | Lee | Florida | 12071 | 62901 | 921 |
1177348 | 1177348 | 2021-04-01 | Lee | Georgia | 13177 | 2673 | 56 |
1177522 | 1177522 | 2021-04-01 | Lee | Illinois | 17103 | 3725 | 87 |
1177721 | 1177721 | 2021-04-01 | Lee | Iowa | 19111 | 3642 | 55 |
1177936 | 1177936 | 2021-04-01 | Lee | Kentucky | 21129 | 1248 | 22 |
1178326 | 1178326 | 2021-04-01 | Lee | Mississippi | 28081 | 9813 | 169 |
1178827 | 1178827 | 2021-04-01 | Lee | North Carolina | 37105 | 5693 | 74 |
1179316 | 1179316 | 2021-04-01 | Lee | South Carolina | 45061 | 1830 | 59 |
1179637 | 1179637 | 2021-04-01 | Lee | Texas | 48287 | 2119 | 38 |
1179864 | 1179864 | 2021-04-01 | Lee | Virginia | 51105 | 2365 | 45 |
1173664 | 1173664 | 2021-03-31 | Lee | Alabama | 1081 | 15417 | 166 |
1173772 | 1173772 | 2021-03-31 | Lee | Arkansas | 5077 | 1656 | 34 |
1173980 | 1173980 | 2021-03-31 | Lee | Florida | 12071 | 62712 | 915 |
1174101 | 1174101 | 2021-03-31 | Lee | Georgia | 13177 | 2672 | 56 |
1174275 | 1174275 | 2021-03-31 | Lee | Illinois | 17103 | 3714 | 86 |
1174474 | 1174474 | 2021-03-31 | Lee | Iowa | 19111 | 3637 | 55 |
1174689 | 1174689 | 2021-03-31 | Lee | Kentucky | 21129 | 1248 | 22 |
1175079 | 1175079 | 2021-03-31 | Lee | Mississippi | 28081 | 9808 | 169 |
1175580 | 1175580 | 2021-03-31 | Lee | North Carolina | 37105 | 5687 | 74 |
1176069 | 1176069 | 2021-03-31 | Lee | South Carolina | 45061 | 1828 | 59 |
1176390 | 1176390 | 2021-03-31 | Lee | Texas | 48287 | 2115 | 38 |
1176617 | 1176617 | 2021-03-31 | Lee | Virginia | 51105 | 2363 | 45 |
1170417 | 1170417 | 2021-03-30 | Lee | Alabama | 1081 | 15397 | 166 |
1170525 | 1170525 | 2021-03-30 | Lee | Arkansas | 5077 | 1656 | 34 |
1170733 | 1170733 | 2021-03-30 | Lee | Florida | 12071 | 62482 | 913 |
1170854 | 1170854 | 2021-03-30 | Lee | Georgia | 13177 | 2672 | 55 |
1171028 | 1171028 | 2021-03-30 | Lee | Illinois | 17103 | 3693 | 86 |
1171227 | 1171227 | 2021-03-30 | Lee | Iowa | 19111 | 3634 | 55 |
1171442 | 1171442 | 2021-03-30 | Lee | Kentucky | 21129 | 1244 | 22 |
1171832 | 1171832 | 2021-03-30 | Lee | Mississippi | 28081 | 9805 | 168 |
1172333 | 1172333 | 2021-03-30 | Lee | North Carolina | 37105 | 5673 | 73 |
1172822 | 1172822 | 2021-03-30 | Lee | South Carolina | 45061 | 1827 | 59 |
1173143 | 1173143 | 2021-03-30 | Lee | Texas | 48287 | 2113 | 37 |
1173370 | 1173370 | 2021-03-30 | Lee | Virginia | 51105 | 2360 | 45 |
1167169 | 1167169 | 2021-03-29 | Lee | Alabama | 1081 | 15394 | 166 |
1167277 | 1167277 | 2021-03-29 | Lee | Arkansas | 5077 | 1655 | 34 |
1167485 | 1167485 | 2021-03-29 | Lee | Florida | 12071 | 62299 | 910 |
1167606 | 1167606 | 2021-03-29 | Lee | Georgia | 13177 | 2688 | 55 |
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);