ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where county = "Marshall", deaths = 9 and fips = 1095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
287127 | 287127 | 2020-06-30 | Marshall | Alabama | 1095 | 1505 | 9 |
283981 | 283981 | 2020-06-29 | Marshall | Alabama | 1095 | 1463 | 9 |
280835 | 280835 | 2020-06-28 | Marshall | Alabama | 1095 | 1418 | 9 |
277687 | 277687 | 2020-06-27 | Marshall | Alabama | 1095 | 1399 | 9 |
274539 | 274539 | 2020-06-26 | Marshall | Alabama | 1095 | 1336 | 9 |
271399 | 271399 | 2020-06-25 | Marshall | Alabama | 1095 | 1275 | 9 |
268265 | 268265 | 2020-06-24 | Marshall | Alabama | 1095 | 1192 | 9 |
265136 | 265136 | 2020-06-23 | Marshall | Alabama | 1095 | 1148 | 9 |
262007 | 262007 | 2020-06-22 | Marshall | Alabama | 1095 | 1104 | 9 |
258880 | 258880 | 2020-06-21 | Marshall | Alabama | 1095 | 1082 | 9 |
255753 | 255753 | 2020-06-20 | Marshall | Alabama | 1095 | 1061 | 9 |
252634 | 252634 | 2020-06-19 | Marshall | Alabama | 1095 | 1038 | 9 |
249519 | 249519 | 2020-06-18 | Marshall | Alabama | 1095 | 1001 | 9 |
246407 | 246407 | 2020-06-17 | Marshall | Alabama | 1095 | 962 | 9 |
243294 | 243294 | 2020-06-16 | Marshall | Alabama | 1095 | 931 | 9 |
240183 | 240183 | 2020-06-15 | Marshall | Alabama | 1095 | 901 | 9 |
237075 | 237075 | 2020-06-14 | Marshall | Alabama | 1095 | 887 | 9 |
233968 | 233968 | 2020-06-13 | Marshall | Alabama | 1095 | 854 | 9 |
230863 | 230863 | 2020-06-12 | Marshall | Alabama | 1095 | 816 | 9 |
227759 | 227759 | 2020-06-11 | Marshall | Alabama | 1095 | 791 | 9 |
224658 | 224658 | 2020-06-10 | Marshall | Alabama | 1095 | 768 | 9 |
221562 | 221562 | 2020-06-09 | Marshall | Alabama | 1095 | 756 | 9 |
218470 | 218470 | 2020-06-08 | Marshall | Alabama | 1095 | 748 | 9 |
215380 | 215380 | 2020-06-07 | Marshall | Alabama | 1095 | 743 | 9 |
212293 | 212293 | 2020-06-06 | Marshall | Alabama | 1095 | 734 | 9 |
209208 | 209208 | 2020-06-05 | Marshall | Alabama | 1095 | 718 | 9 |
206126 | 206126 | 2020-06-04 | Marshall | Alabama | 1095 | 712 | 9 |
203047 | 203047 | 2020-06-03 | Marshall | Alabama | 1095 | 709 | 9 |
199971 | 199971 | 2020-06-02 | Marshall | Alabama | 1095 | 709 | 9 |
196898 | 196898 | 2020-06-01 | Marshall | Alabama | 1095 | 704 | 9 |
193828 | 193828 | 2020-05-31 | Marshall | Alabama | 1095 | 693 | 9 |
190762 | 190762 | 2020-05-30 | Marshall | Alabama | 1095 | 687 | 9 |
187698 | 187698 | 2020-05-29 | Marshall | Alabama | 1095 | 681 | 9 |
184641 | 184641 | 2020-05-28 | Marshall | Alabama | 1095 | 668 | 9 |
181589 | 181589 | 2020-05-27 | Marshall | Alabama | 1095 | 660 | 9 |
178545 | 178545 | 2020-05-26 | Marshall | Alabama | 1095 | 660 | 9 |
175500 | 175500 | 2020-05-25 | Marshall | Alabama | 1095 | 650 | 9 |
172457 | 172457 | 2020-05-24 | Marshall | Alabama | 1095 | 649 | 9 |
169416 | 169416 | 2020-05-23 | Marshall | Alabama | 1095 | 645 | 9 |
166380 | 166380 | 2020-05-22 | Marshall | Alabama | 1095 | 642 | 9 |
163348 | 163348 | 2020-05-21 | Marshall | Alabama | 1095 | 643 | 9 |
160320 | 160320 | 2020-05-20 | Marshall | Alabama | 1095 | 641 | 9 |
157296 | 157296 | 2020-05-19 | Marshall | Alabama | 1095 | 638 | 9 |
154280 | 154280 | 2020-05-18 | Marshall | Alabama | 1095 | 632 | 9 |
151268 | 151268 | 2020-05-17 | Marshall | Alabama | 1095 | 624 | 9 |
148259 | 148259 | 2020-05-16 | Marshall | Alabama | 1095 | 624 | 9 |
145256 | 145256 | 2020-05-15 | Marshall | Alabama | 1095 | 612 | 9 |
142257 | 142257 | 2020-05-14 | Marshall | Alabama | 1095 | 599 | 9 |
139261 | 139261 | 2020-05-13 | Marshall | Alabama | 1095 | 586 | 9 |
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);