ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
165 rows where county = "Bond", deaths = 30 and state = "Illinois" 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 |
---|---|---|---|---|---|---|---|
1823716 | 1823716 | 2021-10-17 | Bond | Illinois | 17005 | 2550 | 30 |
1820467 | 1820467 | 2021-10-16 | Bond | Illinois | 17005 | 2550 | 30 |
1817218 | 1817218 | 2021-10-15 | Bond | Illinois | 17005 | 2550 | 30 |
1813970 | 1813970 | 2021-10-14 | Bond | Illinois | 17005 | 2545 | 30 |
1810721 | 1810721 | 2021-10-13 | Bond | Illinois | 17005 | 2538 | 30 |
1807472 | 1807472 | 2021-10-12 | Bond | Illinois | 17005 | 2527 | 30 |
1804221 | 1804221 | 2021-10-11 | Bond | Illinois | 17005 | 2513 | 30 |
1800972 | 1800972 | 2021-10-10 | Bond | Illinois | 17005 | 2513 | 30 |
1797723 | 1797723 | 2021-10-09 | Bond | Illinois | 17005 | 2513 | 30 |
1794474 | 1794474 | 2021-10-08 | Bond | Illinois | 17005 | 2513 | 30 |
1791226 | 1791226 | 2021-10-07 | Bond | Illinois | 17005 | 2506 | 30 |
1787977 | 1787977 | 2021-10-06 | Bond | Illinois | 17005 | 2497 | 30 |
1541089 | 1541089 | 2021-07-22 | Bond | Illinois | 17005 | 2112 | 30 |
1537842 | 1537842 | 2021-07-21 | Bond | Illinois | 17005 | 2108 | 30 |
1534594 | 1534594 | 2021-07-20 | Bond | Illinois | 17005 | 2108 | 30 |
1531347 | 1531347 | 2021-07-19 | Bond | Illinois | 17005 | 2107 | 30 |
1528100 | 1528100 | 2021-07-18 | Bond | Illinois | 17005 | 2105 | 30 |
1524853 | 1524853 | 2021-07-17 | Bond | Illinois | 17005 | 2105 | 30 |
1521605 | 1521605 | 2021-07-16 | Bond | Illinois | 17005 | 2105 | 30 |
1518357 | 1518357 | 2021-07-15 | Bond | Illinois | 17005 | 2104 | 30 |
1515110 | 1515110 | 2021-07-14 | Bond | Illinois | 17005 | 2103 | 30 |
1511864 | 1511864 | 2021-07-13 | Bond | Illinois | 17005 | 2100 | 30 |
1508617 | 1508617 | 2021-07-12 | Bond | Illinois | 17005 | 2100 | 30 |
1505371 | 1505371 | 2021-07-11 | Bond | Illinois | 17005 | 2094 | 30 |
1502125 | 1502125 | 2021-07-10 | Bond | Illinois | 17005 | 2094 | 30 |
1498879 | 1498879 | 2021-07-09 | Bond | Illinois | 17005 | 2094 | 30 |
1495632 | 1495632 | 2021-07-08 | Bond | Illinois | 17005 | 2092 | 30 |
1492386 | 1492386 | 2021-07-07 | Bond | Illinois | 17005 | 2091 | 30 |
1489139 | 1489139 | 2021-07-06 | Bond | Illinois | 17005 | 2091 | 30 |
1485892 | 1485892 | 2021-07-05 | Bond | Illinois | 17005 | 2091 | 30 |
1482646 | 1482646 | 2021-07-04 | Bond | Illinois | 17005 | 2091 | 30 |
1479399 | 1479399 | 2021-07-03 | Bond | Illinois | 17005 | 2091 | 30 |
1476153 | 1476153 | 2021-07-02 | Bond | Illinois | 17005 | 2091 | 30 |
1472907 | 1472907 | 2021-07-01 | Bond | Illinois | 17005 | 2091 | 30 |
1469661 | 1469661 | 2021-06-30 | Bond | Illinois | 17005 | 2087 | 30 |
1466416 | 1466416 | 2021-06-29 | Bond | Illinois | 17005 | 2086 | 30 |
1463171 | 1463171 | 2021-06-28 | Bond | Illinois | 17005 | 2087 | 30 |
1459926 | 1459926 | 2021-06-27 | Bond | Illinois | 17005 | 2087 | 30 |
1456681 | 1456681 | 2021-06-26 | Bond | Illinois | 17005 | 2087 | 30 |
1453436 | 1453436 | 2021-06-25 | Bond | Illinois | 17005 | 2087 | 30 |
1450190 | 1450190 | 2021-06-24 | Bond | Illinois | 17005 | 2087 | 30 |
1446945 | 1446945 | 2021-06-23 | Bond | Illinois | 17005 | 2087 | 30 |
1443700 | 1443700 | 2021-06-22 | Bond | Illinois | 17005 | 2087 | 30 |
1440455 | 1440455 | 2021-06-21 | Bond | Illinois | 17005 | 2087 | 30 |
1437208 | 1437208 | 2021-06-20 | Bond | Illinois | 17005 | 2087 | 30 |
1433961 | 1433961 | 2021-06-19 | Bond | Illinois | 17005 | 2087 | 30 |
1430715 | 1430715 | 2021-06-18 | Bond | Illinois | 17005 | 2087 | 30 |
1427470 | 1427470 | 2021-06-17 | Bond | Illinois | 17005 | 2087 | 30 |
1424225 | 1424225 | 2021-06-16 | Bond | Illinois | 17005 | 2087 | 30 |
1420977 | 1420977 | 2021-06-15 | Bond | Illinois | 17005 | 2087 | 30 |
1417732 | 1417732 | 2021-06-14 | Bond | Illinois | 17005 | 2088 | 30 |
1414486 | 1414486 | 2021-06-13 | Bond | Illinois | 17005 | 2088 | 30 |
1411241 | 1411241 | 2021-06-12 | Bond | Illinois | 17005 | 2088 | 30 |
1407996 | 1407996 | 2021-06-11 | Bond | Illinois | 17005 | 2087 | 30 |
1404750 | 1404750 | 2021-06-10 | Bond | Illinois | 17005 | 2086 | 30 |
1401505 | 1401505 | 2021-06-09 | Bond | Illinois | 17005 | 2085 | 30 |
1398260 | 1398260 | 2021-06-08 | Bond | Illinois | 17005 | 2085 | 30 |
1395013 | 1395013 | 2021-06-07 | Bond | Illinois | 17005 | 2085 | 30 |
1391768 | 1391768 | 2021-06-06 | Bond | Illinois | 17005 | 2085 | 30 |
1388523 | 1388523 | 2021-06-05 | Bond | Illinois | 17005 | 2085 | 30 |
1385278 | 1385278 | 2021-06-04 | Bond | Illinois | 17005 | 2083 | 30 |
1382032 | 1382032 | 2021-06-03 | Bond | Illinois | 17005 | 2083 | 30 |
1378787 | 1378787 | 2021-06-02 | Bond | Illinois | 17005 | 2083 | 30 |
1375541 | 1375541 | 2021-06-01 | Bond | Illinois | 17005 | 2082 | 30 |
1372296 | 1372296 | 2021-05-31 | Bond | Illinois | 17005 | 2082 | 30 |
1369051 | 1369051 | 2021-05-30 | Bond | Illinois | 17005 | 2082 | 30 |
1365805 | 1365805 | 2021-05-29 | Bond | Illinois | 17005 | 2081 | 30 |
1362559 | 1362559 | 2021-05-28 | Bond | Illinois | 17005 | 2081 | 30 |
1359312 | 1359312 | 2021-05-27 | Bond | Illinois | 17005 | 2080 | 30 |
1356066 | 1356066 | 2021-05-26 | Bond | Illinois | 17005 | 2077 | 30 |
1352820 | 1352820 | 2021-05-25 | Bond | Illinois | 17005 | 2077 | 30 |
1349574 | 1349574 | 2021-05-24 | Bond | Illinois | 17005 | 2072 | 30 |
1346327 | 1346327 | 2021-05-23 | Bond | Illinois | 17005 | 2073 | 30 |
1343079 | 1343079 | 2021-05-22 | Bond | Illinois | 17005 | 2071 | 30 |
1339831 | 1339831 | 2021-05-21 | Bond | Illinois | 17005 | 2070 | 30 |
1336584 | 1336584 | 2021-05-20 | Bond | Illinois | 17005 | 2069 | 30 |
1333337 | 1333337 | 2021-05-19 | Bond | Illinois | 17005 | 2061 | 30 |
1330090 | 1330090 | 2021-05-18 | Bond | Illinois | 17005 | 2058 | 30 |
1326843 | 1326843 | 2021-05-17 | Bond | Illinois | 17005 | 2055 | 30 |
1323597 | 1323597 | 2021-05-16 | Bond | Illinois | 17005 | 2055 | 30 |
1320351 | 1320351 | 2021-05-15 | Bond | Illinois | 17005 | 2054 | 30 |
1317104 | 1317104 | 2021-05-14 | Bond | Illinois | 17005 | 2050 | 30 |
1313857 | 1313857 | 2021-05-13 | Bond | Illinois | 17005 | 2048 | 30 |
1310610 | 1310610 | 2021-05-12 | Bond | Illinois | 17005 | 2046 | 30 |
1307364 | 1307364 | 2021-05-11 | Bond | Illinois | 17005 | 2042 | 30 |
1304118 | 1304118 | 2021-05-10 | Bond | Illinois | 17005 | 2039 | 30 |
1300871 | 1300871 | 2021-05-09 | Bond | Illinois | 17005 | 2037 | 30 |
1297624 | 1297624 | 2021-05-08 | Bond | Illinois | 17005 | 2035 | 30 |
1294378 | 1294378 | 2021-05-07 | Bond | Illinois | 17005 | 2029 | 30 |
1291132 | 1291132 | 2021-05-06 | Bond | Illinois | 17005 | 2022 | 30 |
1287886 | 1287886 | 2021-05-05 | Bond | Illinois | 17005 | 2022 | 30 |
1284640 | 1284640 | 2021-05-04 | Bond | Illinois | 17005 | 2019 | 30 |
1281393 | 1281393 | 2021-05-03 | Bond | Illinois | 17005 | 2019 | 30 |
1278146 | 1278146 | 2021-05-02 | Bond | Illinois | 17005 | 2019 | 30 |
1274899 | 1274899 | 2021-05-01 | Bond | Illinois | 17005 | 2018 | 30 |
1271652 | 1271652 | 2021-04-30 | Bond | Illinois | 17005 | 2016 | 30 |
1268405 | 1268405 | 2021-04-29 | Bond | Illinois | 17005 | 2012 | 30 |
1265158 | 1265158 | 2021-04-28 | Bond | Illinois | 17005 | 2009 | 30 |
1261911 | 1261911 | 2021-04-27 | Bond | Illinois | 17005 | 2007 | 30 |
1258664 | 1258664 | 2021-04-26 | Bond | Illinois | 17005 | 2002 | 30 |
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);