ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where county = "Bullock", deaths = 42 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1748390 | 1748390 | 2021-09-24 | Bullock | Alabama | 1011 | 1488 | 42 |
1745140 | 1745140 | 2021-09-23 | Bullock | Alabama | 1011 | 1486 | 42 |
1741891 | 1741891 | 2021-09-22 | Bullock | Alabama | 1011 | 1477 | 42 |
1738642 | 1738642 | 2021-09-21 | Bullock | Alabama | 1011 | 1475 | 42 |
1735393 | 1735393 | 2021-09-20 | Bullock | Alabama | 1011 | 1473 | 42 |
1732143 | 1732143 | 2021-09-19 | Bullock | Alabama | 1011 | 1472 | 42 |
1728893 | 1728893 | 2021-09-18 | Bullock | Alabama | 1011 | 1471 | 42 |
1725643 | 1725643 | 2021-09-17 | Bullock | Alabama | 1011 | 1468 | 42 |
1722394 | 1722394 | 2021-09-16 | Bullock | Alabama | 1011 | 1462 | 42 |
1719146 | 1719146 | 2021-09-15 | Bullock | Alabama | 1011 | 1456 | 42 |
1715898 | 1715898 | 2021-09-14 | Bullock | Alabama | 1011 | 1451 | 42 |
1712652 | 1712652 | 2021-09-13 | Bullock | Alabama | 1011 | 1442 | 42 |
1709405 | 1709405 | 2021-09-12 | Bullock | Alabama | 1011 | 1441 | 42 |
1706158 | 1706158 | 2021-09-11 | Bullock | Alabama | 1011 | 1440 | 42 |
1702910 | 1702910 | 2021-09-10 | Bullock | Alabama | 1011 | 1435 | 42 |
1699660 | 1699660 | 2021-09-09 | Bullock | Alabama | 1011 | 1434 | 42 |
1696411 | 1696411 | 2021-09-08 | Bullock | Alabama | 1011 | 1430 | 42 |
1693163 | 1693163 | 2021-09-07 | Bullock | Alabama | 1011 | 1422 | 42 |
1689914 | 1689914 | 2021-09-06 | Bullock | Alabama | 1011 | 1412 | 42 |
1686664 | 1686664 | 2021-09-05 | Bullock | Alabama | 1011 | 1409 | 42 |
1683414 | 1683414 | 2021-09-04 | Bullock | Alabama | 1011 | 1404 | 42 |
1680163 | 1680163 | 2021-09-03 | Bullock | Alabama | 1011 | 1399 | 42 |
1589212 | 1589212 | 2021-08-06 | Bullock | Alabama | 1011 | 1267 | 42 |
1585963 | 1585963 | 2021-08-05 | Bullock | Alabama | 1011 | 1267 | 42 |
1582713 | 1582713 | 2021-08-04 | Bullock | Alabama | 1011 | 1265 | 42 |
1579463 | 1579463 | 2021-08-03 | Bullock | Alabama | 1011 | 1265 | 42 |
1576215 | 1576215 | 2021-08-02 | Bullock | Alabama | 1011 | 1265 | 42 |
1572967 | 1572967 | 2021-08-01 | Bullock | Alabama | 1011 | 1265 | 42 |
1569719 | 1569719 | 2021-07-31 | Bullock | Alabama | 1011 | 1265 | 42 |
1566471 | 1566471 | 2021-07-30 | Bullock | Alabama | 1011 | 1261 | 42 |
1563223 | 1563223 | 2021-07-29 | Bullock | Alabama | 1011 | 1261 | 42 |
1559975 | 1559975 | 2021-07-28 | Bullock | Alabama | 1011 | 1261 | 42 |
1556728 | 1556728 | 2021-07-27 | Bullock | Alabama | 1011 | 1260 | 42 |
1553481 | 1553481 | 2021-07-26 | Bullock | Alabama | 1011 | 1256 | 42 |
1550234 | 1550234 | 2021-07-25 | Bullock | Alabama | 1011 | 1256 | 42 |
1546987 | 1546987 | 2021-07-24 | Bullock | Alabama | 1011 | 1256 | 42 |
1543740 | 1543740 | 2021-07-23 | Bullock | Alabama | 1011 | 1255 | 42 |
1540492 | 1540492 | 2021-07-22 | Bullock | Alabama | 1011 | 1253 | 42 |
1537245 | 1537245 | 2021-07-21 | Bullock | Alabama | 1011 | 1253 | 42 |
1533997 | 1533997 | 2021-07-20 | Bullock | Alabama | 1011 | 1252 | 42 |
1530750 | 1530750 | 2021-07-19 | Bullock | Alabama | 1011 | 1252 | 42 |
1527503 | 1527503 | 2021-07-18 | Bullock | Alabama | 1011 | 1252 | 42 |
1524256 | 1524256 | 2021-07-17 | Bullock | Alabama | 1011 | 1252 | 42 |
1521008 | 1521008 | 2021-07-16 | Bullock | Alabama | 1011 | 1251 | 42 |
1517760 | 1517760 | 2021-07-15 | Bullock | Alabama | 1011 | 1251 | 42 |
1514513 | 1514513 | 2021-07-14 | Bullock | Alabama | 1011 | 1250 | 42 |
1511267 | 1511267 | 2021-07-13 | Bullock | Alabama | 1011 | 1250 | 42 |
1508020 | 1508020 | 2021-07-12 | Bullock | Alabama | 1011 | 1250 | 42 |
1504774 | 1504774 | 2021-07-11 | Bullock | Alabama | 1011 | 1250 | 42 |
1501528 | 1501528 | 2021-07-10 | Bullock | Alabama | 1011 | 1250 | 42 |
1498282 | 1498282 | 2021-07-09 | Bullock | Alabama | 1011 | 1250 | 42 |
1495035 | 1495035 | 2021-07-08 | Bullock | Alabama | 1011 | 1250 | 42 |
1491788 | 1491788 | 2021-07-07 | Bullock | Alabama | 1011 | 1250 | 42 |
1488541 | 1488541 | 2021-07-06 | Bullock | Alabama | 1011 | 1250 | 42 |
1485294 | 1485294 | 2021-07-05 | Bullock | Alabama | 1011 | 1250 | 42 |
1482048 | 1482048 | 2021-07-04 | Bullock | Alabama | 1011 | 1250 | 42 |
1478801 | 1478801 | 2021-07-03 | Bullock | Alabama | 1011 | 1250 | 42 |
1475555 | 1475555 | 2021-07-02 | Bullock | Alabama | 1011 | 1250 | 42 |
1472309 | 1472309 | 2021-07-01 | Bullock | Alabama | 1011 | 1249 | 42 |
1469064 | 1469064 | 2021-06-30 | Bullock | Alabama | 1011 | 1249 | 42 |
1465819 | 1465819 | 2021-06-29 | Bullock | Alabama | 1011 | 1249 | 42 |
1462574 | 1462574 | 2021-06-28 | Bullock | Alabama | 1011 | 1249 | 42 |
1459329 | 1459329 | 2021-06-27 | Bullock | Alabama | 1011 | 1247 | 42 |
1456084 | 1456084 | 2021-06-26 | Bullock | Alabama | 1011 | 1247 | 42 |
1452839 | 1452839 | 2021-06-25 | Bullock | Alabama | 1011 | 1247 | 42 |
1449593 | 1449593 | 2021-06-24 | Bullock | Alabama | 1011 | 1246 | 42 |
1446348 | 1446348 | 2021-06-23 | Bullock | Alabama | 1011 | 1246 | 42 |
1443103 | 1443103 | 2021-06-22 | Bullock | Alabama | 1011 | 1245 | 42 |
1439858 | 1439858 | 2021-06-21 | Bullock | Alabama | 1011 | 1245 | 42 |
1436611 | 1436611 | 2021-06-20 | Bullock | Alabama | 1011 | 1243 | 42 |
1433364 | 1433364 | 2021-06-19 | Bullock | Alabama | 1011 | 1243 | 42 |
1430118 | 1430118 | 2021-06-18 | Bullock | Alabama | 1011 | 1243 | 42 |
1426873 | 1426873 | 2021-06-17 | Bullock | Alabama | 1011 | 1242 | 42 |
1423627 | 1423627 | 2021-06-16 | Bullock | Alabama | 1011 | 1242 | 42 |
1420380 | 1420380 | 2021-06-15 | Bullock | Alabama | 1011 | 1242 | 42 |
1417135 | 1417135 | 2021-06-14 | Bullock | Alabama | 1011 | 1242 | 42 |
1413889 | 1413889 | 2021-06-13 | Bullock | Alabama | 1011 | 1242 | 42 |
1410644 | 1410644 | 2021-06-12 | Bullock | Alabama | 1011 | 1242 | 42 |
1407399 | 1407399 | 2021-06-11 | Bullock | Alabama | 1011 | 1242 | 42 |
1404153 | 1404153 | 2021-06-10 | Bullock | Alabama | 1011 | 1243 | 42 |
1400908 | 1400908 | 2021-06-09 | Bullock | Alabama | 1011 | 1240 | 42 |
1397663 | 1397663 | 2021-06-08 | Bullock | Alabama | 1011 | 1240 | 42 |
1394416 | 1394416 | 2021-06-07 | Bullock | Alabama | 1011 | 1240 | 42 |
1391171 | 1391171 | 2021-06-06 | Bullock | Alabama | 1011 | 1237 | 42 |
1387926 | 1387926 | 2021-06-05 | Bullock | Alabama | 1011 | 1237 | 42 |
1384681 | 1384681 | 2021-06-04 | Bullock | Alabama | 1011 | 1237 | 42 |
1381435 | 1381435 | 2021-06-03 | Bullock | Alabama | 1011 | 1236 | 42 |
1378190 | 1378190 | 2021-06-02 | Bullock | Alabama | 1011 | 1236 | 42 |
1374944 | 1374944 | 2021-06-01 | Bullock | Alabama | 1011 | 1233 | 42 |
1371699 | 1371699 | 2021-05-31 | Bullock | Alabama | 1011 | 1233 | 42 |
1368453 | 1368453 | 2021-05-30 | Bullock | Alabama | 1011 | 1233 | 42 |
1365207 | 1365207 | 2021-05-29 | Bullock | Alabama | 1011 | 1233 | 42 |
1361961 | 1361961 | 2021-05-28 | Bullock | Alabama | 1011 | 1233 | 42 |
1358715 | 1358715 | 2021-05-27 | Bullock | Alabama | 1011 | 1233 | 42 |
1355469 | 1355469 | 2021-05-26 | Bullock | Alabama | 1011 | 1233 | 42 |
1352223 | 1352223 | 2021-05-25 | Bullock | Alabama | 1011 | 1233 | 42 |
1348977 | 1348977 | 2021-05-24 | Bullock | Alabama | 1011 | 1233 | 42 |
1345729 | 1345729 | 2021-05-23 | Bullock | Alabama | 1011 | 1233 | 42 |
1342481 | 1342481 | 2021-05-22 | Bullock | Alabama | 1011 | 1233 | 42 |
1339233 | 1339233 | 2021-05-21 | Bullock | Alabama | 1011 | 1233 | 42 |
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);