ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Lawrence", deaths = 103 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1510118 | 1510118 | 2021-07-12 | Lawrence | Ohio | 39087 | 5814 | 103 |
1506871 | 1506871 | 2021-07-11 | Lawrence | Ohio | 39087 | 5804 | 103 |
1503625 | 1503625 | 2021-07-10 | Lawrence | Ohio | 39087 | 5801 | 103 |
1500379 | 1500379 | 2021-07-09 | Lawrence | Ohio | 39087 | 5785 | 103 |
1497133 | 1497133 | 2021-07-08 | Lawrence | Ohio | 39087 | 5776 | 103 |
1493886 | 1493886 | 2021-07-07 | Lawrence | Ohio | 39087 | 5768 | 103 |
1490639 | 1490639 | 2021-07-06 | Lawrence | Ohio | 39087 | 5764 | 103 |
1487392 | 1487392 | 2021-07-05 | Lawrence | Ohio | 39087 | 5757 | 103 |
1484145 | 1484145 | 2021-07-04 | Lawrence | Ohio | 39087 | 5757 | 103 |
1480899 | 1480899 | 2021-07-03 | Lawrence | Ohio | 39087 | 5757 | 103 |
1477652 | 1477652 | 2021-07-02 | Lawrence | Ohio | 39087 | 5756 | 103 |
1474406 | 1474406 | 2021-07-01 | Lawrence | Ohio | 39087 | 5756 | 103 |
1471160 | 1471160 | 2021-06-30 | Lawrence | Ohio | 39087 | 5754 | 103 |
1467915 | 1467915 | 2021-06-29 | Lawrence | Ohio | 39087 | 5753 | 103 |
1464670 | 1464670 | 2021-06-28 | Lawrence | Ohio | 39087 | 5749 | 103 |
1461425 | 1461425 | 2021-06-27 | Lawrence | Ohio | 39087 | 5747 | 103 |
1458180 | 1458180 | 2021-06-26 | Lawrence | Ohio | 39087 | 5747 | 103 |
1454935 | 1454935 | 2021-06-25 | Lawrence | Ohio | 39087 | 5744 | 103 |
1354320 | 1354320 | 2021-05-25 | Lawrence | Ohio | 39087 | 5642 | 103 |
1351074 | 1351074 | 2021-05-24 | Lawrence | Ohio | 39087 | 5631 | 103 |
1347828 | 1347828 | 2021-05-23 | Lawrence | Ohio | 39087 | 5623 | 103 |
1344580 | 1344580 | 2021-05-22 | Lawrence | Ohio | 39087 | 5623 | 103 |
1341332 | 1341332 | 2021-05-21 | Lawrence | Ohio | 39087 | 5614 | 103 |
1338084 | 1338084 | 2021-05-20 | Lawrence | Ohio | 39087 | 5609 | 103 |
1334837 | 1334837 | 2021-05-19 | Lawrence | Ohio | 39087 | 5603 | 103 |
1331590 | 1331590 | 2021-05-18 | Lawrence | Ohio | 39087 | 5594 | 103 |
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);