ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 1, fips = 28005 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 |
---|---|---|---|---|---|---|---|
216701 | 216701 | 2020-06-07 | Amite | Mississippi | 28005 | 65 | 1 |
213613 | 213613 | 2020-06-06 | Amite | Mississippi | 28005 | 65 | 1 |
210529 | 210529 | 2020-06-05 | Amite | Mississippi | 28005 | 65 | 1 |
207448 | 207448 | 2020-06-04 | Amite | Mississippi | 28005 | 66 | 1 |
204367 | 204367 | 2020-06-03 | Amite | Mississippi | 28005 | 65 | 1 |
201290 | 201290 | 2020-06-02 | Amite | Mississippi | 28005 | 64 | 1 |
198217 | 198217 | 2020-06-01 | Amite | Mississippi | 28005 | 64 | 1 |
195146 | 195146 | 2020-05-31 | Amite | Mississippi | 28005 | 64 | 1 |
192078 | 192078 | 2020-05-30 | Amite | Mississippi | 28005 | 60 | 1 |
189014 | 189014 | 2020-05-29 | Amite | Mississippi | 28005 | 59 | 1 |
185956 | 185956 | 2020-05-28 | Amite | Mississippi | 28005 | 56 | 1 |
182900 | 182900 | 2020-05-27 | Amite | Mississippi | 28005 | 56 | 1 |
179854 | 179854 | 2020-05-26 | Amite | Mississippi | 28005 | 53 | 1 |
176810 | 176810 | 2020-05-25 | Amite | Mississippi | 28005 | 52 | 1 |
173767 | 173767 | 2020-05-24 | Amite | Mississippi | 28005 | 52 | 1 |
170725 | 170725 | 2020-05-23 | Amite | Mississippi | 28005 | 50 | 1 |
167687 | 167687 | 2020-05-22 | Amite | Mississippi | 28005 | 49 | 1 |
164651 | 164651 | 2020-05-21 | Amite | Mississippi | 28005 | 49 | 1 |
161622 | 161622 | 2020-05-20 | Amite | Mississippi | 28005 | 48 | 1 |
158596 | 158596 | 2020-05-19 | Amite | Mississippi | 28005 | 45 | 1 |
82542 | 82542 | 2020-04-23 | Amite | Mississippi | 28005 | 24 | 1 |
79746 | 79746 | 2020-04-22 | Amite | Mississippi | 28005 | 20 | 1 |
68641 | 68641 | 2020-04-18 | Amite | Mississippi | 28005 | 16 | 1 |
65889 | 65889 | 2020-04-17 | Amite | Mississippi | 28005 | 17 | 1 |
63149 | 63149 | 2020-04-16 | Amite | Mississippi | 28005 | 16 | 1 |
60427 | 60427 | 2020-04-15 | Amite | Mississippi | 28005 | 15 | 1 |
57716 | 57716 | 2020-04-14 | Amite | Mississippi | 28005 | 14 | 1 |
55018 | 55018 | 2020-04-13 | Amite | Mississippi | 28005 | 14 | 1 |
52336 | 52336 | 2020-04-12 | Amite | Mississippi | 28005 | 12 | 1 |
49663 | 49663 | 2020-04-11 | Amite | Mississippi | 28005 | 11 | 1 |
47017 | 47017 | 2020-04-10 | Amite | Mississippi | 28005 | 10 | 1 |
44408 | 44408 | 2020-04-09 | Amite | Mississippi | 28005 | 10 | 1 |
41832 | 41832 | 2020-04-08 | Amite | Mississippi | 28005 | 7 | 1 |
39278 | 39278 | 2020-04-07 | Amite | Mississippi | 28005 | 7 | 1 |
36767 | 36767 | 2020-04-06 | Amite | Mississippi | 28005 | 6 | 1 |
34305 | 34305 | 2020-04-05 | Amite | Mississippi | 28005 | 6 | 1 |
31878 | 31878 | 2020-04-04 | Amite | Mississippi | 28005 | 6 | 1 |
29498 | 29498 | 2020-04-03 | Amite | Mississippi | 28005 | 5 | 1 |
27179 | 27179 | 2020-04-02 | Amite | Mississippi | 28005 | 4 | 1 |
24925 | 24925 | 2020-04-01 | Amite | Mississippi | 28005 | 4 | 1 |
22742 | 22742 | 2020-03-31 | Amite | Mississippi | 28005 | 4 | 1 |
20625 | 20625 | 2020-03-30 | Amite | Mississippi | 28005 | 4 | 1 |
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);