ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where county = "Lawrence" and deaths = 102 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1759683 | 1759683 | 2021-09-27 | Lawrence | Missouri | 29109 | 5011 | 102 |
1756435 | 1756435 | 2021-09-26 | Lawrence | Missouri | 29109 | 5002 | 102 |
1753187 | 1753187 | 2021-09-25 | Lawrence | Missouri | 29109 | 4999 | 102 |
1749939 | 1749939 | 2021-09-24 | Lawrence | Missouri | 29109 | 4993 | 102 |
1746689 | 1746689 | 2021-09-23 | Lawrence | Missouri | 29109 | 4983 | 102 |
1743440 | 1743440 | 2021-09-22 | Lawrence | Missouri | 29109 | 4966 | 102 |
1740191 | 1740191 | 2021-09-21 | Lawrence | Missouri | 29109 | 4949 | 102 |
1735427 | 1735427 | 2021-09-20 | Lawrence | Alabama | 1079 | 4069 | 102 |
1732177 | 1732177 | 2021-09-19 | Lawrence | Alabama | 1079 | 4059 | 102 |
1728927 | 1728927 | 2021-09-18 | Lawrence | Alabama | 1079 | 4046 | 102 |
1643760 | 1643760 | 2021-08-22 | Lawrence | Tennessee | 47099 | 6842 | 102 |
1640510 | 1640510 | 2021-08-21 | Lawrence | Tennessee | 47099 | 6842 | 102 |
1637260 | 1637260 | 2021-08-20 | Lawrence | Tennessee | 47099 | 6842 | 102 |
1634010 | 1634010 | 2021-08-19 | Lawrence | Tennessee | 47099 | 6758 | 102 |
1630763 | 1630763 | 2021-08-18 | Lawrence | Tennessee | 47099 | 6723 | 102 |
1451690 | 1451690 | 2021-06-24 | Lawrence | Ohio | 39087 | 5743 | 102 |
1448444 | 1448444 | 2021-06-23 | Lawrence | Ohio | 39087 | 5741 | 102 |
1445199 | 1445199 | 2021-06-22 | Lawrence | Ohio | 39087 | 5739 | 102 |
1441954 | 1441954 | 2021-06-21 | Lawrence | Ohio | 39087 | 5734 | 102 |
1438709 | 1438709 | 2021-06-20 | Lawrence | Ohio | 39087 | 5732 | 102 |
1435462 | 1435462 | 2021-06-19 | Lawrence | Ohio | 39087 | 5731 | 102 |
1432215 | 1432215 | 2021-06-18 | Lawrence | Ohio | 39087 | 5730 | 102 |
1428969 | 1428969 | 2021-06-17 | Lawrence | Ohio | 39087 | 5726 | 102 |
1425724 | 1425724 | 2021-06-16 | Lawrence | Ohio | 39087 | 5724 | 102 |
1422477 | 1422477 | 2021-06-15 | Lawrence | Ohio | 39087 | 5723 | 102 |
1419231 | 1419231 | 2021-06-14 | Lawrence | Ohio | 39087 | 5723 | 102 |
1415986 | 1415986 | 2021-06-13 | Lawrence | Ohio | 39087 | 5722 | 102 |
1412740 | 1412740 | 2021-06-12 | Lawrence | Ohio | 39087 | 5722 | 102 |
1409495 | 1409495 | 2021-06-11 | Lawrence | Ohio | 39087 | 5722 | 102 |
1406250 | 1406250 | 2021-06-10 | Lawrence | Ohio | 39087 | 5720 | 102 |
1403004 | 1403004 | 2021-06-09 | Lawrence | Ohio | 39087 | 5712 | 102 |
1399759 | 1399759 | 2021-06-08 | Lawrence | Ohio | 39087 | 5704 | 102 |
1396514 | 1396514 | 2021-06-07 | Lawrence | Ohio | 39087 | 5696 | 102 |
1393267 | 1393267 | 2021-06-06 | Lawrence | Ohio | 39087 | 5691 | 102 |
1390022 | 1390022 | 2021-06-05 | Lawrence | Ohio | 39087 | 5691 | 102 |
1386777 | 1386777 | 2021-06-04 | Lawrence | Ohio | 39087 | 5690 | 102 |
1383532 | 1383532 | 2021-06-03 | Lawrence | Ohio | 39087 | 5680 | 102 |
1380286 | 1380286 | 2021-06-02 | Lawrence | Ohio | 39087 | 5675 | 102 |
1377041 | 1377041 | 2021-06-01 | Lawrence | Ohio | 39087 | 5674 | 102 |
1373795 | 1373795 | 2021-05-31 | Lawrence | Ohio | 39087 | 5667 | 102 |
1370550 | 1370550 | 2021-05-30 | Lawrence | Ohio | 39087 | 5667 | 102 |
1367304 | 1367304 | 2021-05-29 | Lawrence | Ohio | 39087 | 5667 | 102 |
1364058 | 1364058 | 2021-05-28 | Lawrence | Ohio | 39087 | 5668 | 102 |
1360812 | 1360812 | 2021-05-27 | Lawrence | Ohio | 39087 | 5660 | 102 |
1357566 | 1357566 | 2021-05-26 | Lawrence | Ohio | 39087 | 5648 | 102 |
1328343 | 1328343 | 2021-05-17 | Lawrence | Ohio | 39087 | 5590 | 102 |
1325097 | 1325097 | 2021-05-16 | Lawrence | Ohio | 39087 | 5588 | 102 |
1321851 | 1321851 | 2021-05-15 | Lawrence | Ohio | 39087 | 5587 | 102 |
1318605 | 1318605 | 2021-05-14 | Lawrence | Ohio | 39087 | 5583 | 102 |
1315357 | 1315357 | 2021-05-13 | Lawrence | Ohio | 39087 | 5578 | 102 |
1312111 | 1312111 | 2021-05-12 | Lawrence | Ohio | 39087 | 5570 | 102 |
1308864 | 1308864 | 2021-05-11 | Lawrence | Ohio | 39087 | 5560 | 102 |
1305618 | 1305618 | 2021-05-10 | Lawrence | Ohio | 39087 | 5559 | 102 |
1302372 | 1302372 | 2021-05-09 | Lawrence | Ohio | 39087 | 5551 | 102 |
1299124 | 1299124 | 2021-05-08 | Lawrence | Ohio | 39087 | 5549 | 102 |
1295878 | 1295878 | 2021-05-07 | Lawrence | Ohio | 39087 | 5546 | 102 |
1292632 | 1292632 | 2021-05-06 | Lawrence | Ohio | 39087 | 5542 | 102 |
1289386 | 1289386 | 2021-05-05 | Lawrence | Ohio | 39087 | 5542 | 102 |
1286140 | 1286140 | 2021-05-04 | Lawrence | Ohio | 39087 | 5536 | 102 |
1282894 | 1282894 | 2021-05-03 | Lawrence | Ohio | 39087 | 5535 | 102 |
1279647 | 1279647 | 2021-05-02 | Lawrence | Ohio | 39087 | 5532 | 102 |
1276400 | 1276400 | 2021-05-01 | Lawrence | Ohio | 39087 | 5530 | 102 |
1273153 | 1273153 | 2021-04-30 | Lawrence | Ohio | 39087 | 5528 | 102 |
1269906 | 1269906 | 2021-04-29 | Lawrence | Ohio | 39087 | 5520 | 102 |
1266659 | 1266659 | 2021-04-28 | Lawrence | Ohio | 39087 | 5516 | 102 |
1263412 | 1263412 | 2021-04-27 | Lawrence | Ohio | 39087 | 5511 | 102 |
1260165 | 1260165 | 2021-04-26 | Lawrence | Ohio | 39087 | 5500 | 102 |
1256918 | 1256918 | 2021-04-25 | Lawrence | Ohio | 39087 | 5488 | 102 |
1253671 | 1253671 | 2021-04-24 | Lawrence | Ohio | 39087 | 5488 | 102 |
1250424 | 1250424 | 2021-04-23 | Lawrence | Ohio | 39087 | 5484 | 102 |
1247177 | 1247177 | 2021-04-22 | Lawrence | Ohio | 39087 | 5483 | 102 |
1243930 | 1243930 | 2021-04-21 | Lawrence | Ohio | 39087 | 5483 | 102 |
1240683 | 1240683 | 2021-04-20 | Lawrence | Ohio | 39087 | 5478 | 102 |
1237436 | 1237436 | 2021-04-19 | Lawrence | Ohio | 39087 | 5470 | 102 |
1234189 | 1234189 | 2021-04-18 | Lawrence | Ohio | 39087 | 5467 | 102 |
1230941 | 1230941 | 2021-04-17 | Lawrence | Ohio | 39087 | 5467 | 102 |
1227693 | 1227693 | 2021-04-16 | Lawrence | Ohio | 39087 | 5465 | 102 |
1224445 | 1224445 | 2021-04-15 | Lawrence | Ohio | 39087 | 5458 | 102 |
1221198 | 1221198 | 2021-04-14 | Lawrence | Ohio | 39087 | 5454 | 102 |
1217950 | 1217950 | 2021-04-13 | Lawrence | Ohio | 39087 | 5445 | 102 |
1214702 | 1214702 | 2021-04-12 | Lawrence | Ohio | 39087 | 5445 | 102 |
1211455 | 1211455 | 2021-04-11 | Lawrence | Ohio | 39087 | 5439 | 102 |
1208206 | 1208206 | 2021-04-10 | Lawrence | Ohio | 39087 | 5435 | 102 |
1204958 | 1204958 | 2021-04-09 | Lawrence | Ohio | 39087 | 5433 | 102 |
841604 | 841604 | 2020-12-18 | Lawrence | Pennsylvania | 42073 | 3536 | 102 |
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);