ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Davidson" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419060 | 1419060 | 2021-06-14 | Davidson | North Carolina | 37057 | 16967 | 196 |
1415815 | 1415815 | 2021-06-13 | Davidson | North Carolina | 37057 | 16951 | 196 |
1412569 | 1412569 | 2021-06-12 | Davidson | North Carolina | 37057 | 16951 | 196 |
1409324 | 1409324 | 2021-06-11 | Davidson | North Carolina | 37057 | 16951 | 196 |
1406079 | 1406079 | 2021-06-10 | Davidson | North Carolina | 37057 | 16943 | 195 |
1402833 | 1402833 | 2021-06-09 | Davidson | North Carolina | 37057 | 16939 | 194 |
1399588 | 1399588 | 2021-06-08 | Davidson | North Carolina | 37057 | 16951 | 193 |
1396343 | 1396343 | 2021-06-07 | Davidson | North Carolina | 37057 | 16940 | 193 |
1393096 | 1393096 | 2021-06-06 | Davidson | North Carolina | 37057 | 16914 | 193 |
1389851 | 1389851 | 2021-06-05 | Davidson | North Carolina | 37057 | 16914 | 193 |
1386606 | 1386606 | 2021-06-04 | Davidson | North Carolina | 37057 | 16914 | 193 |
1383361 | 1383361 | 2021-06-03 | Davidson | North Carolina | 37057 | 16903 | 193 |
1380115 | 1380115 | 2021-06-02 | Davidson | North Carolina | 37057 | 16894 | 193 |
1376870 | 1376870 | 2021-06-01 | Davidson | North Carolina | 37057 | 16890 | 193 |
1373624 | 1373624 | 2021-05-31 | Davidson | North Carolina | 37057 | 16849 | 193 |
1370379 | 1370379 | 2021-05-30 | Davidson | North Carolina | 37057 | 16849 | 193 |
1367133 | 1367133 | 2021-05-29 | Davidson | North Carolina | 37057 | 16849 | 193 |
1363887 | 1363887 | 2021-05-28 | Davidson | North Carolina | 37057 | 16849 | 193 |
1360641 | 1360641 | 2021-05-27 | Davidson | North Carolina | 37057 | 16840 | 193 |
1357395 | 1357395 | 2021-05-26 | Davidson | North Carolina | 37057 | 16808 | 192 |
1354149 | 1354149 | 2021-05-25 | Davidson | North Carolina | 37057 | 16789 | 189 |
1350903 | 1350903 | 2021-05-24 | Davidson | North Carolina | 37057 | 16774 | 187 |
1347657 | 1347657 | 2021-05-23 | Davidson | North Carolina | 37057 | 16744 | 188 |
1344409 | 1344409 | 2021-05-22 | Davidson | North Carolina | 37057 | 16744 | 188 |
1341161 | 1341161 | 2021-05-21 | Davidson | North Carolina | 37057 | 16744 | 188 |
1337913 | 1337913 | 2021-05-20 | Davidson | North Carolina | 37057 | 16735 | 188 |
1334666 | 1334666 | 2021-05-19 | Davidson | North Carolina | 37057 | 16699 | 187 |
1331419 | 1331419 | 2021-05-18 | Davidson | North Carolina | 37057 | 16693 | 187 |
1328172 | 1328172 | 2021-05-17 | Davidson | North Carolina | 37057 | 16670 | 187 |
1324926 | 1324926 | 2021-05-16 | Davidson | North Carolina | 37057 | 16605 | 187 |
1321680 | 1321680 | 2021-05-15 | Davidson | North Carolina | 37057 | 16605 | 187 |
1318434 | 1318434 | 2021-05-14 | Davidson | North Carolina | 37057 | 16605 | 187 |
1315186 | 1315186 | 2021-05-13 | Davidson | North Carolina | 37057 | 16571 | 187 |
1311940 | 1311940 | 2021-05-12 | Davidson | North Carolina | 37057 | 16545 | 187 |
1308693 | 1308693 | 2021-05-11 | Davidson | North Carolina | 37057 | 16519 | 185 |
1305447 | 1305447 | 2021-05-10 | Davidson | North Carolina | 37057 | 16494 | 184 |
1302201 | 1302201 | 2021-05-09 | Davidson | North Carolina | 37057 | 16407 | 185 |
1298953 | 1298953 | 2021-05-08 | Davidson | North Carolina | 37057 | 16407 | 185 |
1295707 | 1295707 | 2021-05-07 | Davidson | North Carolina | 37057 | 16407 | 185 |
1292461 | 1292461 | 2021-05-06 | Davidson | North Carolina | 37057 | 16375 | 185 |
1289215 | 1289215 | 2021-05-05 | Davidson | North Carolina | 37057 | 16345 | 186 |
1285969 | 1285969 | 2021-05-04 | Davidson | North Carolina | 37057 | 16317 | 185 |
1282723 | 1282723 | 2021-05-03 | Davidson | North Carolina | 37057 | 16289 | 185 |
1279476 | 1279476 | 2021-05-02 | Davidson | North Carolina | 37057 | 16195 | 185 |
1276229 | 1276229 | 2021-05-01 | Davidson | North Carolina | 37057 | 16195 | 185 |
1272982 | 1272982 | 2021-04-30 | Davidson | North Carolina | 37057 | 16195 | 185 |
1269735 | 1269735 | 2021-04-29 | Davidson | North Carolina | 37057 | 16170 | 185 |
1266488 | 1266488 | 2021-04-28 | Davidson | North Carolina | 37057 | 16128 | 185 |
1263241 | 1263241 | 2021-04-27 | Davidson | North Carolina | 37057 | 16095 | 185 |
1259994 | 1259994 | 2021-04-26 | Davidson | North Carolina | 37057 | 16075 | 185 |
1256747 | 1256747 | 2021-04-25 | Davidson | North Carolina | 37057 | 15985 | 185 |
1253500 | 1253500 | 2021-04-24 | Davidson | North Carolina | 37057 | 15985 | 185 |
1250253 | 1250253 | 2021-04-23 | Davidson | North Carolina | 37057 | 15985 | 185 |
1247006 | 1247006 | 2021-04-22 | Davidson | North Carolina | 37057 | 15945 | 185 |
1243759 | 1243759 | 2021-04-21 | Davidson | North Carolina | 37057 | 15933 | 185 |
1240512 | 1240512 | 2021-04-20 | Davidson | North Carolina | 37057 | 15912 | 185 |
1237265 | 1237265 | 2021-04-19 | Davidson | North Carolina | 37057 | 15899 | 185 |
1234018 | 1234018 | 2021-04-18 | Davidson | North Carolina | 37057 | 15825 | 183 |
1230770 | 1230770 | 2021-04-17 | Davidson | North Carolina | 37057 | 15825 | 183 |
1227522 | 1227522 | 2021-04-16 | Davidson | North Carolina | 37057 | 15825 | 183 |
1224274 | 1224274 | 2021-04-15 | Davidson | North Carolina | 37057 | 15780 | 183 |
1221027 | 1221027 | 2021-04-14 | Davidson | North Carolina | 37057 | 15739 | 182 |
1217779 | 1217779 | 2021-04-13 | Davidson | North Carolina | 37057 | 15692 | 182 |
1214531 | 1214531 | 2021-04-12 | Davidson | North Carolina | 37057 | 15675 | 182 |
1211284 | 1211284 | 2021-04-11 | Davidson | North Carolina | 37057 | 15599 | 182 |
1208035 | 1208035 | 2021-04-10 | Davidson | North Carolina | 37057 | 15599 | 182 |
1204787 | 1204787 | 2021-04-09 | Davidson | North Carolina | 37057 | 15599 | 182 |
1201539 | 1201539 | 2021-04-08 | Davidson | North Carolina | 37057 | 15561 | 180 |
1198290 | 1198290 | 2021-04-07 | Davidson | North Carolina | 37057 | 15528 | 180 |
1195041 | 1195041 | 2021-04-06 | Davidson | North Carolina | 37057 | 15505 | 178 |
1191793 | 1191793 | 2021-04-05 | Davidson | North Carolina | 37057 | 15492 | 178 |
1188544 | 1188544 | 2021-04-04 | Davidson | North Carolina | 37057 | 15384 | 178 |
1185297 | 1185297 | 2021-04-03 | Davidson | North Carolina | 37057 | 15384 | 178 |
1182050 | 1182050 | 2021-04-02 | Davidson | North Carolina | 37057 | 15384 | 178 |
1178803 | 1178803 | 2021-04-01 | Davidson | North Carolina | 37057 | 15384 | 178 |
1175556 | 1175556 | 2021-03-31 | Davidson | North Carolina | 37057 | 15345 | 178 |
1172309 | 1172309 | 2021-03-30 | Davidson | North Carolina | 37057 | 15306 | 178 |
1169062 | 1169062 | 2021-03-29 | Davidson | North Carolina | 37057 | 15282 | 178 |
1165814 | 1165814 | 2021-03-28 | Davidson | North Carolina | 37057 | 15191 | 178 |
1162566 | 1162566 | 2021-03-27 | Davidson | North Carolina | 37057 | 15191 | 178 |
1159317 | 1159317 | 2021-03-26 | Davidson | North Carolina | 37057 | 15191 | 178 |
1156070 | 1156070 | 2021-03-25 | Davidson | North Carolina | 37057 | 15154 | 178 |
1152823 | 1152823 | 2021-03-24 | Davidson | North Carolina | 37057 | 15126 | 178 |
1149576 | 1149576 | 2021-03-23 | Davidson | North Carolina | 37057 | 15105 | 177 |
1146329 | 1146329 | 2021-03-22 | Davidson | North Carolina | 37057 | 15080 | 177 |
1143082 | 1143082 | 2021-03-21 | Davidson | North Carolina | 37057 | 15037 | 177 |
1139835 | 1139835 | 2021-03-20 | Davidson | North Carolina | 37057 | 15037 | 177 |
1136589 | 1136589 | 2021-03-19 | Davidson | North Carolina | 37057 | 15013 | 177 |
1133343 | 1133343 | 2021-03-18 | Davidson | North Carolina | 37057 | 14992 | 177 |
1130095 | 1130095 | 2021-03-17 | Davidson | North Carolina | 37057 | 14970 | 177 |
1126848 | 1126848 | 2021-03-16 | Davidson | North Carolina | 37057 | 14947 | 177 |
1123602 | 1123602 | 2021-03-15 | Davidson | North Carolina | 37057 | 14931 | 177 |
1120356 | 1120356 | 2021-03-14 | Davidson | North Carolina | 37057 | 14875 | 177 |
1117109 | 1117109 | 2021-03-13 | Davidson | North Carolina | 37057 | 14875 | 177 |
1113862 | 1113862 | 2021-03-12 | Davidson | North Carolina | 37057 | 14869 | 172 |
1110616 | 1110616 | 2021-03-11 | Davidson | North Carolina | 37057 | 14846 | 172 |
1107370 | 1107370 | 2021-03-10 | Davidson | North Carolina | 37057 | 14829 | 172 |
1104124 | 1104124 | 2021-03-09 | Davidson | North Carolina | 37057 | 14795 | 168 |
1100878 | 1100878 | 2021-03-08 | Davidson | North Carolina | 37057 | 14783 | 168 |
1097632 | 1097632 | 2021-03-07 | Davidson | North Carolina | 37057 | 14746 | 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);