ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where county = "Lawrence" and deaths = 63 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Lawrence · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324856 | 2324856 | 2022-03-20 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2321602 | 2321602 | 2022-03-19 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2318348 | 2318348 | 2022-03-18 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2315095 | 2315095 | 2022-03-17 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2311842 | 2311842 | 2022-03-16 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2308589 | 2308589 | 2022-03-15 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2305338 | 2305338 | 2022-03-14 | Lawrence | Kentucky | 21127 | 4520 | 63 |
2083266 | 2083266 | 2022-01-05 | Lawrence | Arkansas | 5075 | 3809 | 63 |
2080014 | 2080014 | 2022-01-04 | Lawrence | Arkansas | 5075 | 3775 | 63 |
2076762 | 2076762 | 2022-01-03 | Lawrence | Arkansas | 5075 | 3743 | 63 |
2073511 | 2073511 | 2022-01-02 | Lawrence | Arkansas | 5075 | 3732 | 63 |
2070260 | 2070260 | 2022-01-01 | Lawrence | Arkansas | 5075 | 3725 | 63 |
2067009 | 2067009 | 2021-12-31 | Lawrence | Arkansas | 5075 | 3706 | 63 |
2063758 | 2063758 | 2021-12-30 | Lawrence | Arkansas | 5075 | 3687 | 63 |
2060508 | 2060508 | 2021-12-29 | Lawrence | Arkansas | 5075 | 3672 | 63 |
2057259 | 2057259 | 2021-12-28 | Lawrence | Arkansas | 5075 | 3656 | 63 |
1000433 | 1000433 | 2021-02-05 | Lawrence | Ohio | 39087 | 4939 | 63 |
997187 | 997187 | 2021-02-04 | Lawrence | Ohio | 39087 | 4902 | 63 |
993941 | 993941 | 2021-02-03 | Lawrence | Ohio | 39087 | 4883 | 63 |
990145 | 990145 | 2021-02-02 | Lawrence | Missouri | 29109 | 2653 | 63 |
900296 | 900296 | 2021-01-05 | Lawrence | Tennessee | 47099 | 4630 | 63 |
866016 | 866016 | 2020-12-26 | Lawrence | Indiana | 18093 | 3117 | 63 |
862771 | 862771 | 2020-12-25 | Lawrence | Indiana | 18093 | 3074 | 63 |
859526 | 859526 | 2020-12-24 | Lawrence | Indiana | 18093 | 3031 | 63 |
856281 | 856281 | 2020-12-23 | Lawrence | Indiana | 18093 | 2985 | 63 |
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);