ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where deaths = 0 and fips = 28089 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 |
---|---|---|---|---|---|---|---|
34344 | 34344 | 2020-04-05 | Madison | Mississippi | 28089 | 72 | 0 |
31917 | 31917 | 2020-04-04 | Madison | Mississippi | 28089 | 67 | 0 |
29537 | 29537 | 2020-04-03 | Madison | Mississippi | 28089 | 65 | 0 |
27218 | 27218 | 2020-04-02 | Madison | Mississippi | 28089 | 55 | 0 |
24964 | 24964 | 2020-04-01 | Madison | Mississippi | 28089 | 53 | 0 |
22780 | 22780 | 2020-03-31 | Madison | Mississippi | 28089 | 42 | 0 |
20663 | 20663 | 2020-03-30 | Madison | Mississippi | 28089 | 38 | 0 |
18639 | 18639 | 2020-03-29 | Madison | Mississippi | 28089 | 37 | 0 |
16717 | 16717 | 2020-03-28 | Madison | Mississippi | 28089 | 29 | 0 |
14893 | 14893 | 2020-03-27 | Madison | Mississippi | 28089 | 25 | 0 |
13175 | 13175 | 2020-03-26 | Madison | Mississippi | 28089 | 21 | 0 |
11582 | 11582 | 2020-03-25 | Madison | Mississippi | 28089 | 17 | 0 |
10162 | 10162 | 2020-03-24 | Madison | Mississippi | 28089 | 14 | 0 |
8866 | 8866 | 2020-03-23 | Madison | Mississippi | 28089 | 11 | 0 |
7685 | 7685 | 2020-03-22 | Madison | Mississippi | 28089 | 9 | 0 |
6602 | 6602 | 2020-03-21 | Madison | Mississippi | 28089 | 7 | 0 |
5620 | 5620 | 2020-03-20 | Madison | Mississippi | 28089 | 3 | 0 |
4792 | 4792 | 2020-03-19 | Madison | Mississippi | 28089 | 1 | 0 |
4078 | 4078 | 2020-03-18 | Madison | Mississippi | 28089 | 1 | 0 |
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);