ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 2, fips = 28131 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
374545 | 374545 | 2020-07-27 | Stone | Mississippi | 28131 | 129 | 2 |
371333 | 371333 | 2020-07-26 | Stone | Mississippi | 28131 | 128 | 2 |
368123 | 368123 | 2020-07-25 | Stone | Mississippi | 28131 | 121 | 2 |
364915 | 364915 | 2020-07-24 | Stone | Mississippi | 28131 | 118 | 2 |
361708 | 361708 | 2020-07-23 | Stone | Mississippi | 28131 | 113 | 2 |
358503 | 358503 | 2020-07-22 | Stone | Mississippi | 28131 | 111 | 2 |
355300 | 355300 | 2020-07-21 | Stone | Mississippi | 28131 | 109 | 2 |
352098 | 352098 | 2020-07-20 | Stone | Mississippi | 28131 | 104 | 2 |
348898 | 348898 | 2020-07-19 | Stone | Mississippi | 28131 | 100 | 2 |
345697 | 345697 | 2020-07-18 | Stone | Mississippi | 28131 | 98 | 2 |
342497 | 342497 | 2020-07-17 | Stone | Mississippi | 28131 | 94 | 2 |
339301 | 339301 | 2020-07-16 | Stone | Mississippi | 28131 | 88 | 2 |
336105 | 336105 | 2020-07-15 | Stone | Mississippi | 28131 | 85 | 2 |
332912 | 332912 | 2020-07-14 | Stone | Mississippi | 28131 | 80 | 2 |
329725 | 329725 | 2020-07-13 | Stone | Mississippi | 28131 | 77 | 2 |
326539 | 326539 | 2020-07-12 | Stone | Mississippi | 28131 | 77 | 2 |
323356 | 323356 | 2020-07-11 | Stone | Mississippi | 28131 | 74 | 2 |
320177 | 320177 | 2020-07-10 | Stone | Mississippi | 28131 | 73 | 2 |
317002 | 317002 | 2020-07-09 | Stone | Mississippi | 28131 | 73 | 2 |
313828 | 313828 | 2020-07-08 | Stone | Mississippi | 28131 | 72 | 2 |
310658 | 310658 | 2020-07-07 | Stone | Mississippi | 28131 | 69 | 2 |
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);