ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Richmond city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1488319 | 1488319 | 2021-07-05 | Richmond city | Virginia | 51760 | 17054 | 271 |
1485072 | 1485072 | 2021-07-04 | Richmond city | Virginia | 51760 | 17051 | 271 |
1481826 | 1481826 | 2021-07-03 | Richmond city | Virginia | 51760 | 17048 | 271 |
1478579 | 1478579 | 2021-07-02 | Richmond city | Virginia | 51760 | 17083 | 272 |
1475333 | 1475333 | 2021-07-01 | Richmond city | Virginia | 51760 | 17120 | 272 |
1472087 | 1472087 | 2021-06-30 | Richmond city | Virginia | 51760 | 17139 | 272 |
1468842 | 1468842 | 2021-06-29 | Richmond city | Virginia | 51760 | 17150 | 272 |
1465597 | 1465597 | 2021-06-28 | Richmond city | Virginia | 51760 | 17160 | 271 |
1462352 | 1462352 | 2021-06-27 | Richmond city | Virginia | 51760 | 17154 | 271 |
1459107 | 1459107 | 2021-06-26 | Richmond city | Virginia | 51760 | 17154 | 271 |
1455862 | 1455862 | 2021-06-25 | Richmond city | Virginia | 51760 | 17150 | 270 |
1452617 | 1452617 | 2021-06-24 | Richmond city | Virginia | 51760 | 17161 | 270 |
1449371 | 1449371 | 2021-06-23 | Richmond city | Virginia | 51760 | 17153 | 270 |
1446126 | 1446126 | 2021-06-22 | Richmond city | Virginia | 51760 | 17150 | 271 |
1442881 | 1442881 | 2021-06-21 | Richmond city | Virginia | 51760 | 17145 | 272 |
1439636 | 1439636 | 2021-06-20 | Richmond city | Virginia | 51760 | 17142 | 272 |
1436389 | 1436389 | 2021-06-19 | Richmond city | Virginia | 51760 | 17136 | 271 |
1433142 | 1433142 | 2021-06-18 | Richmond city | Virginia | 51760 | 17140 | 271 |
1429896 | 1429896 | 2021-06-17 | Richmond city | Virginia | 51760 | 17139 | 271 |
1426651 | 1426651 | 2021-06-16 | Richmond city | Virginia | 51760 | 17141 | 271 |
1423405 | 1423405 | 2021-06-15 | Richmond city | Virginia | 51760 | 17131 | 271 |
1420158 | 1420158 | 2021-06-14 | Richmond city | Virginia | 51760 | 17139 | 271 |
1416913 | 1416913 | 2021-06-13 | Richmond city | Virginia | 51760 | 17136 | 271 |
1413667 | 1413667 | 2021-06-12 | Richmond city | Virginia | 51760 | 17137 | 270 |
1410422 | 1410422 | 2021-06-11 | Richmond city | Virginia | 51760 | 17140 | 270 |
1407177 | 1407177 | 2021-06-10 | Richmond city | Virginia | 51760 | 17139 | 270 |
1403931 | 1403931 | 2021-06-09 | Richmond city | Virginia | 51760 | 17143 | 270 |
1400686 | 1400686 | 2021-06-08 | Richmond city | Virginia | 51760 | 17142 | 269 |
1397441 | 1397441 | 2021-06-07 | Richmond city | Virginia | 51760 | 17134 | 269 |
1394194 | 1394194 | 2021-06-06 | Richmond city | Virginia | 51760 | 17137 | 268 |
1390949 | 1390949 | 2021-06-05 | Richmond city | Virginia | 51760 | 17134 | 268 |
1387704 | 1387704 | 2021-06-04 | Richmond city | Virginia | 51760 | 17120 | 268 |
1384459 | 1384459 | 2021-06-03 | Richmond city | Virginia | 51760 | 17112 | 268 |
1381213 | 1381213 | 2021-06-02 | Richmond city | Virginia | 51760 | 17099 | 268 |
1377968 | 1377968 | 2021-06-01 | Richmond city | Virginia | 51760 | 17088 | 267 |
1374722 | 1374722 | 2021-05-31 | Richmond city | Virginia | 51760 | 17086 | 267 |
1371477 | 1371477 | 2021-05-30 | Richmond city | Virginia | 51760 | 17084 | 267 |
1368231 | 1368231 | 2021-05-29 | Richmond city | Virginia | 51760 | 17074 | 267 |
1364985 | 1364985 | 2021-05-28 | Richmond city | Virginia | 51760 | 17067 | 267 |
1361739 | 1361739 | 2021-05-27 | Richmond city | Virginia | 51760 | 17061 | 266 |
1358493 | 1358493 | 2021-05-26 | Richmond city | Virginia | 51760 | 17054 | 266 |
1355247 | 1355247 | 2021-05-25 | Richmond city | Virginia | 51760 | 17057 | 266 |
1352001 | 1352001 | 2021-05-24 | Richmond city | Virginia | 51760 | 17049 | 265 |
1348755 | 1348755 | 2021-05-23 | Richmond city | Virginia | 51760 | 17048 | 265 |
1345507 | 1345507 | 2021-05-22 | Richmond city | Virginia | 51760 | 17042 | 265 |
1342259 | 1342259 | 2021-05-21 | Richmond city | Virginia | 51760 | 17033 | 265 |
1339011 | 1339011 | 2021-05-20 | Richmond city | Virginia | 51760 | 17027 | 265 |
1335764 | 1335764 | 2021-05-19 | Richmond city | Virginia | 51760 | 17016 | 265 |
1332517 | 1332517 | 2021-05-18 | Richmond city | Virginia | 51760 | 17011 | 266 |
1329270 | 1329270 | 2021-05-17 | Richmond city | Virginia | 51760 | 17008 | 266 |
1326024 | 1326024 | 2021-05-16 | Richmond city | Virginia | 51760 | 17001 | 265 |
1322778 | 1322778 | 2021-05-15 | Richmond city | Virginia | 51760 | 16989 | 263 |
1319532 | 1319532 | 2021-05-14 | Richmond city | Virginia | 51760 | 16980 | 263 |
1316284 | 1316284 | 2021-05-13 | Richmond city | Virginia | 51760 | 16963 | 261 |
1313038 | 1313038 | 2021-05-12 | Richmond city | Virginia | 51760 | 16948 | 259 |
1309791 | 1309791 | 2021-05-11 | Richmond city | Virginia | 51760 | 16940 | 259 |
1306545 | 1306545 | 2021-05-10 | Richmond city | Virginia | 51760 | 16932 | 259 |
1303299 | 1303299 | 2021-05-09 | Richmond city | Virginia | 51760 | 16927 | 259 |
1300052 | 1300052 | 2021-05-08 | Richmond city | Virginia | 51760 | 16911 | 259 |
1296805 | 1296805 | 2021-05-07 | Richmond city | Virginia | 51760 | 16897 | 258 |
1293559 | 1293559 | 2021-05-06 | Richmond city | Virginia | 51760 | 16889 | 258 |
1290313 | 1290313 | 2021-05-05 | Richmond city | Virginia | 51760 | 16868 | 258 |
1287067 | 1287067 | 2021-05-04 | Richmond city | Virginia | 51760 | 16862 | 258 |
1283821 | 1283821 | 2021-05-03 | Richmond city | Virginia | 51760 | 16849 | 257 |
1280574 | 1280574 | 2021-05-02 | Richmond city | Virginia | 51760 | 16823 | 257 |
1277327 | 1277327 | 2021-05-01 | Richmond city | Virginia | 51760 | 16804 | 257 |
1274080 | 1274080 | 2021-04-30 | Richmond city | Virginia | 51760 | 16777 | 257 |
1270833 | 1270833 | 2021-04-29 | Richmond city | Virginia | 51760 | 16746 | 257 |
1267586 | 1267586 | 2021-04-28 | Richmond city | Virginia | 51760 | 16717 | 257 |
1264339 | 1264339 | 2021-04-27 | Richmond city | Virginia | 51760 | 16692 | 257 |
1261092 | 1261092 | 2021-04-26 | Richmond city | Virginia | 51760 | 16665 | 257 |
1257845 | 1257845 | 2021-04-25 | Richmond city | Virginia | 51760 | 16649 | 257 |
1254598 | 1254598 | 2021-04-24 | Richmond city | Virginia | 51760 | 16638 | 256 |
1251351 | 1251351 | 2021-04-23 | Richmond city | Virginia | 51760 | 16626 | 256 |
1248104 | 1248104 | 2021-04-22 | Richmond city | Virginia | 51760 | 16592 | 256 |
1244857 | 1244857 | 2021-04-21 | Richmond city | Virginia | 51760 | 16549 | 256 |
1241610 | 1241610 | 2021-04-20 | Richmond city | Virginia | 51760 | 16526 | 258 |
1238363 | 1238363 | 2021-04-19 | Richmond city | Virginia | 51760 | 16504 | 256 |
1235116 | 1235116 | 2021-04-18 | Richmond city | Virginia | 51760 | 16466 | 256 |
1231868 | 1231868 | 2021-04-17 | Richmond city | Virginia | 51760 | 16437 | 255 |
1228620 | 1228620 | 2021-04-16 | Richmond city | Virginia | 51760 | 16394 | 255 |
1225372 | 1225372 | 2021-04-15 | Richmond city | Virginia | 51760 | 16354 | 254 |
1222125 | 1222125 | 2021-04-14 | Richmond city | Virginia | 51760 | 16313 | 255 |
1218877 | 1218877 | 2021-04-13 | Richmond city | Virginia | 51760 | 16271 | 255 |
1215629 | 1215629 | 2021-04-12 | Richmond city | Virginia | 51760 | 16232 | 255 |
1212382 | 1212382 | 2021-04-11 | Richmond city | Virginia | 51760 | 16202 | 255 |
1209133 | 1209133 | 2021-04-10 | Richmond city | Virginia | 51760 | 16159 | 255 |
1205885 | 1205885 | 2021-04-09 | Richmond city | Virginia | 51760 | 16123 | 254 |
1202637 | 1202637 | 2021-04-08 | Richmond city | Virginia | 51760 | 16096 | 255 |
1199389 | 1199389 | 2021-04-07 | Richmond city | Virginia | 51760 | 16026 | 253 |
1196140 | 1196140 | 2021-04-06 | Richmond city | Virginia | 51760 | 15991 | 253 |
1192892 | 1192892 | 2021-04-05 | Richmond city | Virginia | 51760 | 15960 | 251 |
1189642 | 1189642 | 2021-04-04 | Richmond city | Virginia | 51760 | 15918 | 248 |
1186395 | 1186395 | 2021-04-03 | Richmond city | Virginia | 51760 | 15897 | 244 |
1183148 | 1183148 | 2021-04-02 | Richmond city | Virginia | 51760 | 15848 | 244 |
1179901 | 1179901 | 2021-04-01 | Richmond city | Virginia | 51760 | 15812 | 243 |
1176654 | 1176654 | 2021-03-31 | Richmond city | Virginia | 51760 | 15773 | 243 |
1173407 | 1173407 | 2021-03-30 | Richmond city | Virginia | 51760 | 15696 | 242 |
1170160 | 1170160 | 2021-03-29 | Richmond city | Virginia | 51760 | 15655 | 243 |
1166912 | 1166912 | 2021-03-28 | Richmond city | Virginia | 51760 | 15623 | 242 |
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);