ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where county = "Warren", deaths = 117 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1181607 | 1181607 | 2021-04-02 | Warren | Mississippi | 28149 | 4256 | 117 |
1178360 | 1178360 | 2021-04-01 | Warren | Mississippi | 28149 | 4252 | 117 |
1175113 | 1175113 | 2021-03-31 | Warren | Mississippi | 28149 | 4248 | 117 |
1171866 | 1171866 | 2021-03-30 | Warren | Mississippi | 28149 | 4247 | 117 |
1168618 | 1168618 | 2021-03-29 | Warren | Mississippi | 28149 | 4243 | 117 |
1165370 | 1165370 | 2021-03-28 | Warren | Mississippi | 28149 | 4242 | 117 |
1162122 | 1162122 | 2021-03-27 | Warren | Mississippi | 28149 | 4238 | 117 |
1158874 | 1158874 | 2021-03-26 | Warren | Mississippi | 28149 | 4232 | 117 |
1155627 | 1155627 | 2021-03-25 | Warren | Mississippi | 28149 | 4229 | 117 |
1152380 | 1152380 | 2021-03-24 | Warren | Mississippi | 28149 | 4222 | 117 |
1149133 | 1149133 | 2021-03-23 | Warren | Mississippi | 28149 | 4214 | 117 |
1145886 | 1145886 | 2021-03-22 | Warren | Mississippi | 28149 | 4212 | 117 |
1142639 | 1142639 | 2021-03-21 | Warren | Mississippi | 28149 | 4208 | 117 |
1139392 | 1139392 | 2021-03-20 | Warren | Mississippi | 28149 | 4206 | 117 |
1136146 | 1136146 | 2021-03-19 | Warren | Mississippi | 28149 | 4203 | 117 |
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);