ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lee" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280310 | 1280310 | 2021-05-02 | Lee | Texas | 48287 | 2177 | 39 |
1277063 | 1277063 | 2021-05-01 | Lee | Texas | 48287 | 2177 | 39 |
1273816 | 1273816 | 2021-04-30 | Lee | Texas | 48287 | 2175 | 39 |
1270569 | 1270569 | 2021-04-29 | Lee | Texas | 48287 | 2172 | 39 |
1267322 | 1267322 | 2021-04-28 | Lee | Texas | 48287 | 2170 | 39 |
1264075 | 1264075 | 2021-04-27 | Lee | Texas | 48287 | 2168 | 39 |
1260828 | 1260828 | 2021-04-26 | Lee | Texas | 48287 | 2167 | 39 |
1257581 | 1257581 | 2021-04-25 | Lee | Texas | 48287 | 2165 | 39 |
1254334 | 1254334 | 2021-04-24 | Lee | Texas | 48287 | 2165 | 39 |
1251087 | 1251087 | 2021-04-23 | Lee | Texas | 48287 | 2162 | 39 |
1247840 | 1247840 | 2021-04-22 | Lee | Texas | 48287 | 2157 | 39 |
1244593 | 1244593 | 2021-04-21 | Lee | Texas | 48287 | 2156 | 39 |
1241346 | 1241346 | 2021-04-20 | Lee | Texas | 48287 | 2147 | 39 |
1238099 | 1238099 | 2021-04-19 | Lee | Texas | 48287 | 2143 | 39 |
1234852 | 1234852 | 2021-04-18 | Lee | Texas | 48287 | 2141 | 39 |
1231604 | 1231604 | 2021-04-17 | Lee | Texas | 48287 | 2141 | 39 |
1228356 | 1228356 | 2021-04-16 | Lee | Texas | 48287 | 2138 | 39 |
1225108 | 1225108 | 2021-04-15 | Lee | Texas | 48287 | 2134 | 39 |
1221861 | 1221861 | 2021-04-14 | Lee | Texas | 48287 | 2132 | 39 |
1218613 | 1218613 | 2021-04-13 | Lee | Texas | 48287 | 2129 | 39 |
1215365 | 1215365 | 2021-04-12 | Lee | Texas | 48287 | 2128 | 39 |
1212118 | 1212118 | 2021-04-11 | Lee | Texas | 48287 | 2126 | 39 |
1208869 | 1208869 | 2021-04-10 | Lee | Texas | 48287 | 2126 | 39 |
1205621 | 1205621 | 2021-04-09 | Lee | Texas | 48287 | 2125 | 38 |
1202373 | 1202373 | 2021-04-08 | Lee | Texas | 48287 | 2123 | 38 |
1199124 | 1199124 | 2021-04-07 | Lee | Texas | 48287 | 2120 | 38 |
1195875 | 1195875 | 2021-04-06 | Lee | Texas | 48287 | 2119 | 38 |
1192627 | 1192627 | 2021-04-05 | Lee | Texas | 48287 | 2119 | 38 |
1189378 | 1189378 | 2021-04-04 | Lee | Texas | 48287 | 2119 | 38 |
1186131 | 1186131 | 2021-04-03 | Lee | Texas | 48287 | 2119 | 38 |
1182884 | 1182884 | 2021-04-02 | Lee | Texas | 48287 | 2121 | 38 |
1179637 | 1179637 | 2021-04-01 | Lee | Texas | 48287 | 2119 | 38 |
1176390 | 1176390 | 2021-03-31 | Lee | Texas | 48287 | 2115 | 38 |
1173143 | 1173143 | 2021-03-30 | Lee | Texas | 48287 | 2113 | 37 |
1169896 | 1169896 | 2021-03-29 | Lee | Texas | 48287 | 2110 | 37 |
1166648 | 1166648 | 2021-03-28 | Lee | Texas | 48287 | 2104 | 37 |
1163400 | 1163400 | 2021-03-27 | Lee | Texas | 48287 | 2104 | 37 |
1160151 | 1160151 | 2021-03-26 | Lee | Texas | 48287 | 2099 | 37 |
1156904 | 1156904 | 2021-03-25 | Lee | Texas | 48287 | 2097 | 37 |
1153657 | 1153657 | 2021-03-24 | Lee | Texas | 48287 | 2095 | 37 |
1150410 | 1150410 | 2021-03-23 | Lee | Texas | 48287 | 2090 | 37 |
1147163 | 1147163 | 2021-03-22 | Lee | Texas | 48287 | 2090 | 37 |
1143916 | 1143916 | 2021-03-21 | Lee | Texas | 48287 | 2090 | 37 |
1140669 | 1140669 | 2021-03-20 | Lee | Texas | 48287 | 2090 | 37 |
1137423 | 1137423 | 2021-03-19 | Lee | Texas | 48287 | 2083 | 37 |
1134177 | 1134177 | 2021-03-18 | Lee | Texas | 48287 | 2086 | 36 |
1130929 | 1130929 | 2021-03-17 | Lee | Texas | 48287 | 2083 | 36 |
1127682 | 1127682 | 2021-03-16 | Lee | Texas | 48287 | 2077 | 36 |
1124436 | 1124436 | 2021-03-15 | Lee | Texas | 48287 | 2077 | 36 |
1121190 | 1121190 | 2021-03-14 | Lee | Texas | 48287 | 2074 | 36 |
1117943 | 1117943 | 2021-03-13 | Lee | Texas | 48287 | 2074 | 36 |
1114696 | 1114696 | 2021-03-12 | Lee | Texas | 48287 | 2071 | 36 |
1111450 | 1111450 | 2021-03-11 | Lee | Texas | 48287 | 2070 | 36 |
1108204 | 1108204 | 2021-03-10 | Lee | Texas | 48287 | 2067 | 36 |
1104958 | 1104958 | 2021-03-09 | Lee | Texas | 48287 | 2059 | 36 |
1101712 | 1101712 | 2021-03-08 | Lee | Texas | 48287 | 2051 | 36 |
1098466 | 1098466 | 2021-03-07 | Lee | Texas | 48287 | 2049 | 36 |
1095218 | 1095218 | 2021-03-06 | Lee | Texas | 48287 | 2049 | 36 |
1091972 | 1091972 | 2021-03-05 | Lee | Texas | 48287 | 2044 | 36 |
1088726 | 1088726 | 2021-03-04 | Lee | Texas | 48287 | 2028 | 36 |
1085481 | 1085481 | 2021-03-03 | Lee | Texas | 48287 | 2022 | 36 |
1082235 | 1082235 | 2021-03-02 | Lee | Texas | 48287 | 2015 | 36 |
1078989 | 1078989 | 2021-03-01 | Lee | Texas | 48287 | 2011 | 36 |
1075744 | 1075744 | 2021-02-28 | Lee | Texas | 48287 | 2001 | 36 |
1072498 | 1072498 | 2021-02-27 | Lee | Texas | 48287 | 2001 | 36 |
1069252 | 1069252 | 2021-02-26 | Lee | Texas | 48287 | 1997 | 36 |
1066007 | 1066007 | 2021-02-25 | Lee | Texas | 48287 | 1991 | 36 |
1062762 | 1062762 | 2021-02-24 | Lee | Texas | 48287 | 1983 | 36 |
1059517 | 1059517 | 2021-02-23 | Lee | Texas | 48287 | 1959 | 36 |
1056271 | 1056271 | 2021-02-22 | Lee | Texas | 48287 | 1952 | 36 |
1053025 | 1053025 | 2021-02-21 | Lee | Texas | 48287 | 1949 | 36 |
1049778 | 1049778 | 2021-02-20 | Lee | Texas | 48287 | 1949 | 36 |
1046531 | 1046531 | 2021-02-19 | Lee | Texas | 48287 | 1943 | 36 |
1043286 | 1043286 | 2021-02-18 | Lee | Texas | 48287 | 1937 | 36 |
1040041 | 1040041 | 2021-02-17 | Lee | Texas | 48287 | 1930 | 36 |
1036796 | 1036796 | 2021-02-16 | Lee | Texas | 48287 | 1926 | 36 |
1033551 | 1033551 | 2021-02-15 | Lee | Texas | 48287 | 1912 | 36 |
1030305 | 1030305 | 2021-02-14 | Lee | Texas | 48287 | 1912 | 36 |
1027058 | 1027058 | 2021-02-13 | Lee | Texas | 48287 | 1912 | 36 |
1023813 | 1023813 | 2021-02-12 | Lee | Texas | 48287 | 1902 | 36 |
1020568 | 1020568 | 2021-02-11 | Lee | Texas | 48287 | 1868 | 36 |
1017323 | 1017323 | 2021-02-10 | Lee | Texas | 48287 | 1836 | 36 |
1014078 | 1014078 | 2021-02-09 | Lee | Texas | 48287 | 1812 | 36 |
1010833 | 1010833 | 2021-02-08 | Lee | Texas | 48287 | 1806 | 36 |
1007587 | 1007587 | 2021-02-07 | Lee | Texas | 48287 | 1802 | 36 |
1004341 | 1004341 | 2021-02-06 | Lee | Texas | 48287 | 1802 | 36 |
1001095 | 1001095 | 2021-02-05 | Lee | Texas | 48287 | 1780 | 36 |
997849 | 997849 | 2021-02-04 | Lee | Texas | 48287 | 1749 | 36 |
994603 | 994603 | 2021-02-03 | Lee | Texas | 48287 | 1708 | 36 |
991357 | 991357 | 2021-02-02 | Lee | Texas | 48287 | 1699 | 36 |
988111 | 988111 | 2021-02-01 | Lee | Texas | 48287 | 1674 | 36 |
984864 | 984864 | 2021-01-31 | Lee | Texas | 48287 | 1307 | 36 |
981617 | 981617 | 2021-01-30 | Lee | Texas | 48287 | 1300 | 36 |
978371 | 978371 | 2021-01-29 | Lee | Texas | 48287 | 1291 | 36 |
975126 | 975126 | 2021-01-28 | Lee | Texas | 48287 | 1270 | 36 |
971881 | 971881 | 2021-01-27 | Lee | Texas | 48287 | 1252 | 36 |
968636 | 968636 | 2021-01-26 | Lee | Texas | 48287 | 1247 | 36 |
965392 | 965392 | 2021-01-25 | Lee | Texas | 48287 | 1245 | 36 |
962147 | 962147 | 2021-01-24 | Lee | Texas | 48287 | 1245 | 36 |
958902 | 958902 | 2021-01-23 | Lee | Texas | 48287 | 1244 | 36 |
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);