ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where county = "Lawrence" and deaths = 23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
- Mississippi 40
- Pennsylvania 18
- South Dakota 5
- Alabama 4
- Indiana 4
- Ohio 2
- Arkansas 1
- Illinois 1
- Kentucky 1
county 1
- Lawrence · 76 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1301721 | 1301721 | 2021-05-09 | Lawrence | Mississippi | 28077 | 1283 | 23 |
1298473 | 1298473 | 2021-05-08 | Lawrence | Mississippi | 28077 | 1283 | 23 |
1295227 | 1295227 | 2021-05-07 | Lawrence | Mississippi | 28077 | 1283 | 23 |
1291981 | 1291981 | 2021-05-06 | Lawrence | Mississippi | 28077 | 1283 | 23 |
1288347 | 1288347 | 2021-05-05 | Lawrence | Kentucky | 21127 | 1438 | 23 |
1288735 | 1288735 | 2021-05-05 | Lawrence | Mississippi | 28077 | 1283 | 23 |
1285489 | 1285489 | 2021-05-04 | Lawrence | Mississippi | 28077 | 1282 | 23 |
1282243 | 1282243 | 2021-05-03 | Lawrence | Mississippi | 28077 | 1282 | 23 |
1278996 | 1278996 | 2021-05-02 | Lawrence | Mississippi | 28077 | 1281 | 23 |
1275749 | 1275749 | 2021-05-01 | Lawrence | Mississippi | 28077 | 1281 | 23 |
1272502 | 1272502 | 2021-04-30 | Lawrence | Mississippi | 28077 | 1281 | 23 |
1269255 | 1269255 | 2021-04-29 | Lawrence | Mississippi | 28077 | 1281 | 23 |
1266008 | 1266008 | 2021-04-28 | Lawrence | Mississippi | 28077 | 1279 | 23 |
1262761 | 1262761 | 2021-04-27 | Lawrence | Mississippi | 28077 | 1279 | 23 |
1259514 | 1259514 | 2021-04-26 | Lawrence | Mississippi | 28077 | 1278 | 23 |
1256267 | 1256267 | 2021-04-25 | Lawrence | Mississippi | 28077 | 1274 | 23 |
1253020 | 1253020 | 2021-04-24 | Lawrence | Mississippi | 28077 | 1274 | 23 |
1249773 | 1249773 | 2021-04-23 | Lawrence | Mississippi | 28077 | 1274 | 23 |
1246526 | 1246526 | 2021-04-22 | Lawrence | Mississippi | 28077 | 1272 | 23 |
1243279 | 1243279 | 2021-04-21 | Lawrence | Mississippi | 28077 | 1269 | 23 |
1240032 | 1240032 | 2021-04-20 | Lawrence | Mississippi | 28077 | 1268 | 23 |
1236785 | 1236785 | 2021-04-19 | Lawrence | Mississippi | 28077 | 1268 | 23 |
1233538 | 1233538 | 2021-04-18 | Lawrence | Mississippi | 28077 | 1268 | 23 |
1230290 | 1230290 | 2021-04-17 | Lawrence | Mississippi | 28077 | 1267 | 23 |
1227042 | 1227042 | 2021-04-16 | Lawrence | Mississippi | 28077 | 1266 | 23 |
1223794 | 1223794 | 2021-04-15 | Lawrence | Mississippi | 28077 | 1266 | 23 |
1220547 | 1220547 | 2021-04-14 | Lawrence | Mississippi | 28077 | 1264 | 23 |
1217299 | 1217299 | 2021-04-13 | Lawrence | Mississippi | 28077 | 1264 | 23 |
1214052 | 1214052 | 2021-04-12 | Lawrence | Mississippi | 28077 | 1263 | 23 |
1210804 | 1210804 | 2021-04-11 | Lawrence | Mississippi | 28077 | 1262 | 23 |
1207555 | 1207555 | 2021-04-10 | Lawrence | Mississippi | 28077 | 1262 | 23 |
1204307 | 1204307 | 2021-04-09 | Lawrence | Mississippi | 28077 | 1261 | 23 |
1201059 | 1201059 | 2021-04-08 | Lawrence | Mississippi | 28077 | 1260 | 23 |
1197810 | 1197810 | 2021-04-07 | Lawrence | Mississippi | 28077 | 1260 | 23 |
1194561 | 1194561 | 2021-04-06 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1191312 | 1191312 | 2021-04-05 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1188064 | 1188064 | 2021-04-04 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1184817 | 1184817 | 2021-04-03 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1181571 | 1181571 | 2021-04-02 | Lawrence | Mississippi | 28077 | 1256 | 23 |
1178324 | 1178324 | 2021-04-01 | Lawrence | Mississippi | 28077 | 1255 | 23 |
1175077 | 1175077 | 2021-03-31 | Lawrence | Mississippi | 28077 | 1251 | 23 |
839957 | 839957 | 2020-12-18 | Lawrence | Illinois | 17101 | 1558 | 23 |
809346 | 809346 | 2020-12-08 | Lawrence | South Dakota | 46081 | 2230 | 23 |
806101 | 806101 | 2020-12-07 | Lawrence | South Dakota | 46081 | 2219 | 23 |
802856 | 802856 | 2020-12-06 | Lawrence | South Dakota | 46081 | 2202 | 23 |
799611 | 799611 | 2020-12-05 | Lawrence | South Dakota | 46081 | 2186 | 23 |
796366 | 796366 | 2020-12-04 | Lawrence | South Dakota | 46081 | 2152 | 23 |
709646 | 709646 | 2020-11-08 | Lawrence | Arkansas | 5075 | 955 | 23 |
627447 | 627447 | 2020-10-13 | Lawrence | Pennsylvania | 42073 | 643 | 23 |
624205 | 624205 | 2020-10-12 | Lawrence | Pennsylvania | 42073 | 628 | 23 |
620962 | 620962 | 2020-10-11 | Lawrence | Pennsylvania | 42073 | 622 | 23 |
617719 | 617719 | 2020-10-10 | Lawrence | Pennsylvania | 42073 | 608 | 23 |
614283 | 614283 | 2020-10-09 | Lawrence | Ohio | 39087 | 778 | 23 |
614477 | 614477 | 2020-10-09 | Lawrence | Pennsylvania | 42073 | 602 | 23 |
611042 | 611042 | 2020-10-08 | Lawrence | Ohio | 39087 | 766 | 23 |
611236 | 611236 | 2020-10-08 | Lawrence | Pennsylvania | 42073 | 593 | 23 |
607994 | 607994 | 2020-10-07 | Lawrence | Pennsylvania | 42073 | 568 | 23 |
591782 | 591782 | 2020-10-02 | Lawrence | Pennsylvania | 42073 | 548 | 23 |
588541 | 588541 | 2020-10-01 | Lawrence | Pennsylvania | 42073 | 540 | 23 |
585301 | 585301 | 2020-09-30 | Lawrence | Pennsylvania | 42073 | 531 | 23 |
582061 | 582061 | 2020-09-29 | Lawrence | Pennsylvania | 42073 | 531 | 23 |
576567 | 576567 | 2020-09-28 | Lawrence | Alabama | 1079 | 628 | 23 |
578821 | 578821 | 2020-09-28 | Lawrence | Pennsylvania | 42073 | 531 | 23 |
573323 | 573323 | 2020-09-27 | Lawrence | Alabama | 1079 | 621 | 23 |
575580 | 575580 | 2020-09-27 | Lawrence | Pennsylvania | 42073 | 519 | 23 |
570081 | 570081 | 2020-09-26 | Lawrence | Alabama | 1079 | 620 | 23 |
572336 | 572336 | 2020-09-26 | Lawrence | Pennsylvania | 42073 | 517 | 23 |
566840 | 566840 | 2020-09-25 | Lawrence | Alabama | 1079 | 616 | 23 |
569094 | 569094 | 2020-09-25 | Lawrence | Pennsylvania | 42073 | 510 | 23 |
565853 | 565853 | 2020-09-24 | Lawrence | Pennsylvania | 42073 | 509 | 23 |
562612 | 562612 | 2020-09-23 | Lawrence | Pennsylvania | 42073 | 505 | 23 |
559375 | 559375 | 2020-09-22 | Lawrence | Pennsylvania | 42073 | 501 | 23 |
176172 | 176172 | 2020-05-25 | Lawrence | Indiana | 18093 | 144 | 23 |
173128 | 173128 | 2020-05-24 | Lawrence | Indiana | 18093 | 143 | 23 |
170087 | 170087 | 2020-05-23 | Lawrence | Indiana | 18093 | 143 | 23 |
157963 | 157963 | 2020-05-19 | Lawrence | Indiana | 18093 | 142 | 23 |
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);