ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Gage" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1275999 | 1275999 | 2021-05-01 | Gage | Nebraska | 31067 | 2183 | 19 |
1272752 | 1272752 | 2021-04-30 | Gage | Nebraska | 31067 | 2182 | 19 |
1269505 | 1269505 | 2021-04-29 | Gage | Nebraska | 31067 | 2178 | 19 |
1266258 | 1266258 | 2021-04-28 | Gage | Nebraska | 31067 | 2179 | 19 |
1263011 | 1263011 | 2021-04-27 | Gage | Nebraska | 31067 | 2179 | 19 |
1259764 | 1259764 | 2021-04-26 | Gage | Nebraska | 31067 | 2175 | 19 |
1256517 | 1256517 | 2021-04-25 | Gage | Nebraska | 31067 | 2174 | 19 |
1253270 | 1253270 | 2021-04-24 | Gage | Nebraska | 31067 | 2174 | 19 |
1250023 | 1250023 | 2021-04-23 | Gage | Nebraska | 31067 | 2175 | 19 |
1246776 | 1246776 | 2021-04-22 | Gage | Nebraska | 31067 | 2173 | 19 |
1243529 | 1243529 | 2021-04-21 | Gage | Nebraska | 31067 | 2172 | 19 |
1240282 | 1240282 | 2021-04-20 | Gage | Nebraska | 31067 | 2172 | 19 |
1237035 | 1237035 | 2021-04-19 | Gage | Nebraska | 31067 | 2170 | 19 |
1233788 | 1233788 | 2021-04-18 | Gage | Nebraska | 31067 | 2170 | 19 |
1230540 | 1230540 | 2021-04-17 | Gage | Nebraska | 31067 | 2170 | 19 |
1227292 | 1227292 | 2021-04-16 | Gage | Nebraska | 31067 | 2167 | 19 |
1224044 | 1224044 | 2021-04-15 | Gage | Nebraska | 31067 | 2165 | 19 |
1220797 | 1220797 | 2021-04-14 | Gage | Nebraska | 31067 | 2164 | 19 |
1217549 | 1217549 | 2021-04-13 | Gage | Nebraska | 31067 | 2165 | 19 |
1214302 | 1214302 | 2021-04-12 | Gage | Nebraska | 31067 | 2165 | 19 |
1211054 | 1211054 | 2021-04-11 | Gage | Nebraska | 31067 | 2165 | 19 |
1207805 | 1207805 | 2021-04-10 | Gage | Nebraska | 31067 | 2164 | 19 |
1204557 | 1204557 | 2021-04-09 | Gage | Nebraska | 31067 | 2161 | 19 |
1201309 | 1201309 | 2021-04-08 | Gage | Nebraska | 31067 | 2155 | 19 |
1198060 | 1198060 | 2021-04-07 | Gage | Nebraska | 31067 | 2156 | 19 |
1194811 | 1194811 | 2021-04-06 | Gage | Nebraska | 31067 | 2151 | 19 |
1191562 | 1191562 | 2021-04-05 | Gage | Nebraska | 31067 | 2151 | 19 |
1188314 | 1188314 | 2021-04-04 | Gage | Nebraska | 31067 | 2151 | 19 |
1185067 | 1185067 | 2021-04-03 | Gage | Nebraska | 31067 | 2151 | 19 |
1181821 | 1181821 | 2021-04-02 | Gage | Nebraska | 31067 | 2150 | 19 |
1178574 | 1178574 | 2021-04-01 | Gage | Nebraska | 31067 | 2145 | 19 |
1175327 | 1175327 | 2021-03-31 | Gage | Nebraska | 31067 | 2140 | 19 |
1172080 | 1172080 | 2021-03-30 | Gage | Nebraska | 31067 | 2139 | 19 |
1168832 | 1168832 | 2021-03-29 | Gage | Nebraska | 31067 | 2136 | 19 |
1165584 | 1165584 | 2021-03-28 | Gage | Nebraska | 31067 | 2135 | 19 |
1162336 | 1162336 | 2021-03-27 | Gage | Nebraska | 31067 | 2132 | 19 |
1159088 | 1159088 | 2021-03-26 | Gage | Nebraska | 31067 | 2132 | 19 |
1155841 | 1155841 | 2021-03-25 | Gage | Nebraska | 31067 | 2130 | 19 |
1152594 | 1152594 | 2021-03-24 | Gage | Nebraska | 31067 | 2128 | 19 |
1149347 | 1149347 | 2021-03-23 | Gage | Nebraska | 31067 | 2126 | 19 |
1146100 | 1146100 | 2021-03-22 | Gage | Nebraska | 31067 | 2126 | 19 |
1142853 | 1142853 | 2021-03-21 | Gage | Nebraska | 31067 | 2126 | 19 |
1139606 | 1139606 | 2021-03-20 | Gage | Nebraska | 31067 | 2123 | 19 |
1136360 | 1136360 | 2021-03-19 | Gage | Nebraska | 31067 | 2119 | 19 |
1133114 | 1133114 | 2021-03-18 | Gage | Nebraska | 31067 | 2117 | 19 |
1129866 | 1129866 | 2021-03-17 | Gage | Nebraska | 31067 | 2117 | 19 |
1126619 | 1126619 | 2021-03-16 | Gage | Nebraska | 31067 | 2115 | 19 |
1123373 | 1123373 | 2021-03-15 | Gage | Nebraska | 31067 | 2113 | 19 |
1120126 | 1120126 | 2021-03-14 | Gage | Nebraska | 31067 | 2115 | 19 |
1116879 | 1116879 | 2021-03-13 | Gage | Nebraska | 31067 | 2112 | 19 |
1113633 | 1113633 | 2021-03-12 | Gage | Nebraska | 31067 | 2111 | 19 |
1110387 | 1110387 | 2021-03-11 | Gage | Nebraska | 31067 | 2109 | 19 |
1107141 | 1107141 | 2021-03-10 | Gage | Nebraska | 31067 | 2107 | 19 |
1103895 | 1103895 | 2021-03-09 | Gage | Nebraska | 31067 | 2103 | 19 |
1100649 | 1100649 | 2021-03-08 | Gage | Nebraska | 31067 | 2095 | 19 |
1097402 | 1097402 | 2021-03-07 | Gage | Nebraska | 31067 | 2091 | 19 |
1094155 | 1094155 | 2021-03-06 | Gage | Nebraska | 31067 | 2089 | 19 |
1090909 | 1090909 | 2021-03-05 | Gage | Nebraska | 31067 | 2087 | 19 |
1087664 | 1087664 | 2021-03-04 | Gage | Nebraska | 31067 | 2086 | 19 |
1084419 | 1084419 | 2021-03-03 | Gage | Nebraska | 31067 | 2083 | 19 |
1081173 | 1081173 | 2021-03-02 | Gage | Nebraska | 31067 | 2083 | 19 |
1077927 | 1077927 | 2021-03-01 | Gage | Nebraska | 31067 | 2082 | 19 |
1074681 | 1074681 | 2021-02-28 | Gage | Nebraska | 31067 | 2082 | 19 |
1071435 | 1071435 | 2021-02-27 | Gage | Nebraska | 31067 | 2081 | 19 |
1068190 | 1068190 | 2021-02-26 | Gage | Nebraska | 31067 | 2077 | 19 |
1064945 | 1064945 | 2021-02-25 | Gage | Nebraska | 31067 | 2075 | 16 |
1061701 | 1061701 | 2021-02-24 | Gage | Nebraska | 31067 | 2073 | 16 |
1058455 | 1058455 | 2021-02-23 | Gage | Nebraska | 31067 | 2071 | 16 |
1055209 | 1055209 | 2021-02-22 | Gage | Nebraska | 31067 | 2072 | 16 |
1051962 | 1051962 | 2021-02-21 | Gage | Nebraska | 31067 | 2072 | 16 |
1048715 | 1048715 | 2021-02-20 | Gage | Nebraska | 31067 | 2072 | 16 |
1045469 | 1045469 | 2021-02-19 | Gage | Nebraska | 31067 | 2065 | 16 |
1042224 | 1042224 | 2021-02-18 | Gage | Nebraska | 31067 | 2059 | 16 |
1038979 | 1038979 | 2021-02-17 | Gage | Nebraska | 31067 | 2052 | 16 |
1035734 | 1035734 | 2021-02-16 | Gage | Nebraska | 31067 | 2052 | 16 |
1032489 | 1032489 | 2021-02-15 | Gage | Nebraska | 31067 | 2050 | 16 |
1029242 | 1029242 | 2021-02-14 | Gage | Nebraska | 31067 | 2048 | 16 |
1025996 | 1025996 | 2021-02-13 | Gage | Nebraska | 31067 | 2048 | 16 |
1022751 | 1022751 | 2021-02-12 | Gage | Nebraska | 31067 | 2045 | 16 |
1019506 | 1019506 | 2021-02-11 | Gage | Nebraska | 31067 | 2040 | 16 |
1016261 | 1016261 | 2021-02-10 | Gage | Nebraska | 31067 | 2032 | 16 |
1013016 | 1013016 | 2021-02-09 | Gage | Nebraska | 31067 | 2026 | 16 |
1009771 | 1009771 | 2021-02-08 | Gage | Nebraska | 31067 | 2025 | 16 |
1006524 | 1006524 | 2021-02-07 | Gage | Nebraska | 31067 | 2025 | 16 |
1003278 | 1003278 | 2021-02-06 | Gage | Nebraska | 31067 | 2022 | 16 |
1000033 | 1000033 | 2021-02-05 | Gage | Nebraska | 31067 | 2012 | 16 |
996787 | 996787 | 2021-02-04 | Gage | Nebraska | 31067 | 2006 | 16 |
993541 | 993541 | 2021-02-03 | Gage | Nebraska | 31067 | 2003 | 16 |
990295 | 990295 | 2021-02-02 | Gage | Nebraska | 31067 | 2002 | 16 |
987048 | 987048 | 2021-02-01 | Gage | Nebraska | 31067 | 2001 | 16 |
983801 | 983801 | 2021-01-31 | Gage | Nebraska | 31067 | 2001 | 16 |
980555 | 980555 | 2021-01-30 | Gage | Nebraska | 31067 | 1999 | 16 |
977309 | 977309 | 2021-01-29 | Gage | Nebraska | 31067 | 1998 | 16 |
974064 | 974064 | 2021-01-28 | Gage | Nebraska | 31067 | 1998 | 16 |
970819 | 970819 | 2021-01-27 | Gage | Nebraska | 31067 | 1993 | 16 |
967574 | 967574 | 2021-01-26 | Gage | Nebraska | 31067 | 1992 | 16 |
964330 | 964330 | 2021-01-25 | Gage | Nebraska | 31067 | 1992 | 16 |
961085 | 961085 | 2021-01-24 | Gage | Nebraska | 31067 | 1992 | 16 |
957839 | 957839 | 2021-01-23 | Gage | Nebraska | 31067 | 1991 | 16 |
954594 | 954594 | 2021-01-22 | Gage | Nebraska | 31067 | 1983 | 16 |
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);