ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where county = "Greene", deaths = 18 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1494760 | 1494760 | 2021-07-07 | Greene | Virginia | 51079 | 1305 | 18 |
1491513 | 1491513 | 2021-07-06 | Greene | Virginia | 51079 | 1302 | 18 |
1488266 | 1488266 | 2021-07-05 | Greene | Virginia | 51079 | 1300 | 18 |
1485019 | 1485019 | 2021-07-04 | Greene | Virginia | 51079 | 1300 | 18 |
1481773 | 1481773 | 2021-07-03 | Greene | Virginia | 51079 | 1300 | 18 |
1478526 | 1478526 | 2021-07-02 | Greene | Virginia | 51079 | 1300 | 18 |
1475280 | 1475280 | 2021-07-01 | Greene | Virginia | 51079 | 1299 | 18 |
1472034 | 1472034 | 2021-06-30 | Greene | Virginia | 51079 | 1298 | 18 |
1468789 | 1468789 | 2021-06-29 | Greene | Virginia | 51079 | 1298 | 18 |
1465544 | 1465544 | 2021-06-28 | Greene | Virginia | 51079 | 1297 | 18 |
1462299 | 1462299 | 2021-06-27 | Greene | Virginia | 51079 | 1297 | 18 |
1459054 | 1459054 | 2021-06-26 | Greene | Virginia | 51079 | 1297 | 18 |
1455809 | 1455809 | 2021-06-25 | Greene | Virginia | 51079 | 1297 | 18 |
1452564 | 1452564 | 2021-06-24 | Greene | Virginia | 51079 | 1297 | 18 |
1449318 | 1449318 | 2021-06-23 | Greene | Virginia | 51079 | 1298 | 18 |
1446073 | 1446073 | 2021-06-22 | Greene | Virginia | 51079 | 1299 | 18 |
1442828 | 1442828 | 2021-06-21 | Greene | Virginia | 51079 | 1298 | 18 |
1439583 | 1439583 | 2021-06-20 | Greene | Virginia | 51079 | 1298 | 18 |
1436336 | 1436336 | 2021-06-19 | Greene | Virginia | 51079 | 1299 | 18 |
1433089 | 1433089 | 2021-06-18 | Greene | Virginia | 51079 | 1299 | 18 |
1429843 | 1429843 | 2021-06-17 | Greene | Virginia | 51079 | 1299 | 18 |
1426598 | 1426598 | 2021-06-16 | Greene | Virginia | 51079 | 1298 | 18 |
1423352 | 1423352 | 2021-06-15 | Greene | Virginia | 51079 | 1298 | 18 |
1420105 | 1420105 | 2021-06-14 | Greene | Virginia | 51079 | 1297 | 18 |
1416860 | 1416860 | 2021-06-13 | Greene | Virginia | 51079 | 1297 | 18 |
1413614 | 1413614 | 2021-06-12 | Greene | Virginia | 51079 | 1297 | 18 |
1410369 | 1410369 | 2021-06-11 | Greene | Virginia | 51079 | 1297 | 18 |
1407124 | 1407124 | 2021-06-10 | Greene | Virginia | 51079 | 1297 | 18 |
1403878 | 1403878 | 2021-06-09 | Greene | Virginia | 51079 | 1297 | 18 |
1400633 | 1400633 | 2021-06-08 | Greene | Virginia | 51079 | 1295 | 18 |
1397388 | 1397388 | 2021-06-07 | Greene | Virginia | 51079 | 1293 | 18 |
1394141 | 1394141 | 2021-06-06 | Greene | Virginia | 51079 | 1292 | 18 |
1390896 | 1390896 | 2021-06-05 | Greene | Virginia | 51079 | 1291 | 18 |
1387651 | 1387651 | 2021-06-04 | Greene | Virginia | 51079 | 1289 | 18 |
1384406 | 1384406 | 2021-06-03 | Greene | Virginia | 51079 | 1288 | 18 |
1381160 | 1381160 | 2021-06-02 | Greene | Virginia | 51079 | 1288 | 18 |
1377915 | 1377915 | 2021-06-01 | Greene | Virginia | 51079 | 1288 | 18 |
1374669 | 1374669 | 2021-05-31 | Greene | Virginia | 51079 | 1289 | 18 |
1371424 | 1371424 | 2021-05-30 | Greene | Virginia | 51079 | 1288 | 18 |
1368178 | 1368178 | 2021-05-29 | Greene | Virginia | 51079 | 1288 | 18 |
1364932 | 1364932 | 2021-05-28 | Greene | Virginia | 51079 | 1284 | 18 |
1361686 | 1361686 | 2021-05-27 | Greene | Virginia | 51079 | 1281 | 18 |
1358440 | 1358440 | 2021-05-26 | Greene | Virginia | 51079 | 1281 | 18 |
1355194 | 1355194 | 2021-05-25 | Greene | Virginia | 51079 | 1281 | 18 |
1351948 | 1351948 | 2021-05-24 | Greene | Virginia | 51079 | 1281 | 18 |
1348702 | 1348702 | 2021-05-23 | Greene | Virginia | 51079 | 1281 | 18 |
1345454 | 1345454 | 2021-05-22 | Greene | Virginia | 51079 | 1281 | 18 |
1342206 | 1342206 | 2021-05-21 | Greene | Virginia | 51079 | 1280 | 18 |
1338958 | 1338958 | 2021-05-20 | Greene | Virginia | 51079 | 1280 | 18 |
1335711 | 1335711 | 2021-05-19 | Greene | Virginia | 51079 | 1277 | 18 |
1332464 | 1332464 | 2021-05-18 | Greene | Virginia | 51079 | 1275 | 18 |
1329217 | 1329217 | 2021-05-17 | Greene | Virginia | 51079 | 1274 | 18 |
1325971 | 1325971 | 2021-05-16 | Greene | Virginia | 51079 | 1274 | 18 |
1322725 | 1322725 | 2021-05-15 | Greene | Virginia | 51079 | 1273 | 18 |
1319479 | 1319479 | 2021-05-14 | Greene | Virginia | 51079 | 1264 | 18 |
1316231 | 1316231 | 2021-05-13 | Greene | Virginia | 51079 | 1262 | 18 |
1312985 | 1312985 | 2021-05-12 | Greene | Virginia | 51079 | 1259 | 18 |
1309738 | 1309738 | 2021-05-11 | Greene | Virginia | 51079 | 1258 | 18 |
1306492 | 1306492 | 2021-05-10 | Greene | Virginia | 51079 | 1257 | 18 |
1303246 | 1303246 | 2021-05-09 | Greene | Virginia | 51079 | 1255 | 18 |
1299999 | 1299999 | 2021-05-08 | Greene | Virginia | 51079 | 1255 | 18 |
1296752 | 1296752 | 2021-05-07 | Greene | Virginia | 51079 | 1253 | 18 |
1293506 | 1293506 | 2021-05-06 | Greene | Virginia | 51079 | 1252 | 18 |
1290260 | 1290260 | 2021-05-05 | Greene | Virginia | 51079 | 1250 | 18 |
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);