ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where county = "Lawrence" and deaths = 137 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2032667 | 2032667 | 2021-12-20 | Lawrence | Missouri | 29109 | 5658 | 137 |
2029416 | 2029416 | 2021-12-19 | Lawrence | Missouri | 29109 | 5651 | 137 |
2026165 | 2026165 | 2021-12-18 | Lawrence | Missouri | 29109 | 5643 | 137 |
2022914 | 2022914 | 2021-12-17 | Lawrence | Missouri | 29109 | 5629 | 137 |
2019663 | 2019663 | 2021-12-16 | Lawrence | Missouri | 29109 | 5607 | 137 |
2016413 | 2016413 | 2021-12-15 | Lawrence | Missouri | 29109 | 5592 | 137 |
2013162 | 2013162 | 2021-12-14 | Lawrence | Missouri | 29109 | 5580 | 137 |
2009911 | 2009911 | 2021-12-13 | Lawrence | Missouri | 29109 | 5570 | 137 |
2006660 | 2006660 | 2021-12-12 | Lawrence | Missouri | 29109 | 5563 | 137 |
2003409 | 2003409 | 2021-12-11 | Lawrence | Missouri | 29109 | 5547 | 137 |
2000159 | 2000159 | 2021-12-10 | Lawrence | Missouri | 29109 | 5537 | 137 |
1996908 | 1996908 | 2021-12-09 | Lawrence | Missouri | 29109 | 5509 | 137 |
1993657 | 1993657 | 2021-12-08 | Lawrence | Missouri | 29109 | 5499 | 137 |
1938398 | 1938398 | 2021-11-21 | Lawrence | Missouri | 29109 | 5335 | 137 |
1935148 | 1935148 | 2021-11-20 | Lawrence | Missouri | 29109 | 5335 | 137 |
1931898 | 1931898 | 2021-11-19 | Lawrence | Missouri | 29109 | 5326 | 137 |
1828466 | 1828466 | 2021-10-18 | Lawrence | Ohio | 39087 | 9663 | 137 |
1825217 | 1825217 | 2021-10-17 | Lawrence | Ohio | 39087 | 9647 | 137 |
1821968 | 1821968 | 2021-10-16 | Lawrence | Ohio | 39087 | 9638 | 137 |
1818719 | 1818719 | 2021-10-15 | Lawrence | Ohio | 39087 | 9630 | 137 |
1815470 | 1815470 | 2021-10-14 | Lawrence | Ohio | 39087 | 9595 | 137 |
1812222 | 1812222 | 2021-10-13 | Lawrence | Ohio | 39087 | 9556 | 137 |
1808973 | 1808973 | 2021-10-12 | Lawrence | Ohio | 39087 | 9534 | 137 |
1805723 | 1805723 | 2021-10-11 | Lawrence | Ohio | 39087 | 9490 | 137 |
1802473 | 1802473 | 2021-10-10 | Lawrence | Ohio | 39087 | 9481 | 137 |
1799224 | 1799224 | 2021-10-09 | Lawrence | Ohio | 39087 | 9462 | 137 |
1795975 | 1795975 | 2021-10-08 | Lawrence | Ohio | 39087 | 9442 | 137 |
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);